[Home] [Help]
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 *
78: FROM op_prce_brk
79: WHERE price_id = V_old_price_id;
80:
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 *
78: FROM op_prce_brk
79: WHERE price_id = V_old_price_id;
80:
81: /* Composites */
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;
91: X_base_price OP_PRCE_ITM.BASE_PRICE%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:
94: /* Initialize error number to zero */
283: v_prce_itm.attribute29 , v_prce_itm.attribute30 ,
284: v_prce_itm.attribute_category
285: FROM DUAL ;
286:
287: /* Now insert corresponding break rows into OP_PRCE_BRK */
288: FOR v_prce_brk IN cur_prce_brk(v_prce_itm.price_id) LOOP
289: X_breaktype_id := create_breaktype_id;
290:
291: /* Calculate new break price based on the price change type and change. */
301: IF X_breakpoint_price < 0 THEN
302: X_breakpoint_price := 0;
303: END IF;
304:
305: INSERT INTO OP_PRCE_BRK
306: ( price_id , breakpoint_factor,
307: breakpoint_price , creation_date ,
308: last_update_date , last_updated_by ,
309: created_by , last_update_login,