[Home] [Help]
413: SELECT *
414: FROM op_cntr_dtl
415: WHERE contract_id = p_old_contract_id;
416:
417: CURSOR Cur_cntr_brk ( V_old_price_id GML.OP_CNTR_BRK.PRICE_ID%TYPE) IS
418: SELECT *
419: FROM op_cntr_brk
420: WHERE price_id = V_old_price_id;
421:
415: WHERE contract_id = p_old_contract_id;
416:
417: CURSOR Cur_cntr_brk ( V_old_price_id GML.OP_CNTR_BRK.PRICE_ID%TYPE) IS
418: SELECT *
419: FROM op_cntr_brk
420: WHERE price_id = V_old_price_id;
421:
422: /* Composites */
423: V_cntr_hdr Cur_cntr_hdr%ROWTYPE ;
424:
425: /* Scalars */
426: X_contract_id OP_CNTR_HDR.CONTRACT_ID%TYPE;
427: X_price_id OP_CNTR_DTL.PRICE_ID%TYPE ;
428: X_breaktype_id OP_CNTR_BRK.BREAKTYPE_ID%TYPE;
429: X_cntr_hdr_text_code OP_CNTR_HDR.TEXT_CODE%TYPE ;
430: X_cntr_dtl_text_code OP_CNTR_DTL.TEXT_CODE%TYPE ;
431: X_base_price OP_CNTR_DTL.BASE_PRICE%TYPE ;
432: X_breakpoint_price OP_CNTR_BRK.BREAKPOINT_PRICE%TYPE ;
428: X_breaktype_id OP_CNTR_BRK.BREAKTYPE_ID%TYPE;
429: X_cntr_hdr_text_code OP_CNTR_HDR.TEXT_CODE%TYPE ;
430: X_cntr_dtl_text_code OP_CNTR_DTL.TEXT_CODE%TYPE ;
431: X_base_price OP_CNTR_DTL.BASE_PRICE%TYPE ;
432: X_breakpoint_price OP_CNTR_BRK.BREAKPOINT_PRICE%TYPE ;
433:
434: BEGIN
435:
436: IF P_price_change_type IN ( 1, 2) THEN
628: v_cntr_dtl.attribute29 , v_cntr_dtl.attribute30 ,
629: v_cntr_dtl.attribute_category
630: ) ;
631:
632: /* Now insert corresponding break rows into OP_CNTR_BRK */
633: FOR v_cntr_brk IN cur_cntr_brk(v_cntr_dtl.price_id) LOOP
634: X_breaktype_id := create_breaktype_id;
635:
636: /* Calculate new break price based on the price change type and change. */
646: IF X_breakpoint_price < 0 THEN
647: X_breakpoint_price := 0;
648: END IF;
649:
650: INSERT INTO OP_CNTR_BRK
651: ( breakpoint_factor , breakpoint_price ,
652: creation_date , last_updated_by ,
653: last_update_date , created_by ,
654: price_id , last_update_login,