Skip to content

Instantly share code, notes, and snippets.

View padwasabimasala's full-sized avatar
😃

Matthew Thorley padwasabimasala

😃
View GitHub Profile
@padwasabimasala
padwasabimasala / gist:2956238
Created June 19, 2012 20:05
CREATE RPL PL/SQL STORED PROCEDURE
CREATE OR REPLACE
PROCEDURE CREATE_RPL2(
p_order_item_id IN ORDER_ITEM_PRICES.ORDER_ITEM_PRICE_ID%TYPE,
p_rpl IN ORDER_ITEM_PRICES.PRICE%TYPE,
p_start_day IN NUMBER,
p_created_by IN ORDER_ITEM_PRICES.CREATED_BY%TYPE)
IS
V_ORDER_MONTH NUMBER;
V_ORDER_YEAR NUMBER;
V_MONTH_END NUMBER;