😃

Matthew Thorley padwasabimasala

😃

Matthew loves Jesus, his family, all things software, art and making things, the light of the sun, the smell of the woods, and a good book.

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;