APPS.GMLCOPPR dependencies on OP_PRCE_ITM

Line 73: FROM op_prce_itm

69: WHERE pricelist_id = p_old_pricelist_id;
70:
71: CURSOR Cur_prce_itm IS
72: SELECT *
73: FROM op_prce_itm
74: WHERE pricelist_id = p_old_pricelist_id;
75:
76: CURSOR Cur_prce_brk ( V_old_price_id GML.OP_PRCE_BRK.PRICE_ID%TYPE) IS
77: SELECT *

Line 86: X_price_id OP_PRCE_ITM.PRICE_ID%TYPE ;

82: V_prce_mst Cur_prce_mst%ROWTYPE ;
83:
84: /* Scalars */
85: X_pricelist_id OP_PRCE_MST.PRICELIST_ID%TYPE;
86: X_price_id OP_PRCE_ITM.PRICE_ID%TYPE ;
87: X_breaktype_id OP_PRCE_BRK.BREAKTYPE_ID%TYPE;
88: X_prce_mst_text_code OP_PRCE_MST.TEXT_CODE%TYPE ;
89: X_prce_itm_text_code OP_PRCE_ITM.TEXT_CODE%TYPE ;
90: X_breakpoint_price OP_PRCE_BRK.BREAKPOINT_PRICE%TYPE;

Line 89: X_prce_itm_text_code OP_PRCE_ITM.TEXT_CODE%TYPE ;

85: X_pricelist_id OP_PRCE_MST.PRICELIST_ID%TYPE;
86: X_price_id OP_PRCE_ITM.PRICE_ID%TYPE ;
87: X_breaktype_id OP_PRCE_BRK.BREAKTYPE_ID%TYPE;
88: X_prce_mst_text_code OP_PRCE_MST.TEXT_CODE%TYPE ;
89: X_prce_itm_text_code OP_PRCE_ITM.TEXT_CODE%TYPE ;
90: X_breakpoint_price OP_PRCE_BRK.BREAKPOINT_PRICE%TYPE;
91: X_base_price OP_PRCE_ITM.BASE_PRICE%TYPE;
92: BEGIN
93:

Line 91: X_base_price OP_PRCE_ITM.BASE_PRICE%TYPE;

87: X_breaktype_id OP_PRCE_BRK.BREAKTYPE_ID%TYPE;
88: X_prce_mst_text_code OP_PRCE_MST.TEXT_CODE%TYPE ;
89: X_prce_itm_text_code OP_PRCE_ITM.TEXT_CODE%TYPE ;
90: X_breakpoint_price OP_PRCE_BRK.BREAKPOINT_PRICE%TYPE;
91: X_base_price OP_PRCE_ITM.BASE_PRICE%TYPE;
92: BEGIN
93:
94: /* Initialize error number to zero */
95: p_err_num := 0;

Line 196: /* Retrieve and Copy rows from op_prce_itm */

192: v_prce_mst.attribute29 , v_prce_mst.attribute30,
193: v_prce_mst.attribute_category
194: FROM DUAL;
195:
196: /* Retrieve and Copy rows from op_prce_itm */
197: FOR v_prce_itm IN cur_prce_itm LOOP
198:
199: /*Get a new surrogate id */
200: X_price_id := create_price_id;

Line 227: /* Now insert a new row in OP_PRCE_ITM */

223: IF X_base_price < 0 THEN
224: X_base_price := 0;
225: END IF;
226:
227: /* Now insert a new row in OP_PRCE_ITM */
228: INSERT INTO OP_PRCE_ITM
229: ( base_price , pricelist_id ,
230: price_id , price_type ,
231: break_type , creation_date ,

Line 228: INSERT INTO OP_PRCE_ITM

224: X_base_price := 0;
225: END IF;
226:
227: /* Now insert a new row in OP_PRCE_ITM */
228: INSERT INTO OP_PRCE_ITM
229: ( base_price , pricelist_id ,
230: price_id , price_type ,
231: break_type , creation_date ,
232: last_update_date , last_updated_by ,