APPS.GMLCOPPR dependencies on OP_CNTR_DTL

Line 414: FROM op_cntr_dtl

410: WHERE contract_id = p_old_contract_id;
411:
412: CURSOR Cur_cntr_dtl IS
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 *

Line 427: X_price_id OP_CNTR_DTL.PRICE_ID%TYPE ;

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 ;

Line 430: X_cntr_dtl_text_code OP_CNTR_DTL.TEXT_CODE%TYPE ;

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 ;
433:
434: BEGIN

Line 431: X_base_price OP_CNTR_DTL.BASE_PRICE%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 ;
433:
434: BEGIN
435:

Line 541: /* Retrieve and Copy rows from op_cntr_dtl */

537: v_cntr_hdr.attribute29 , v_cntr_hdr.attribute30 ,
538: v_cntr_hdr.attribute_category
539: FROM DUAL ;
540:
541: /* Retrieve and Copy rows from op_cntr_dtl */
542: FOR v_cntr_dtl IN cur_cntr_dtl LOOP
543:
544: /* Get a new surrogate id */
545: X_price_id := create_price_id;

Line 572: /* Now insert a new row in OP_CNTR_DTL */

568: IF X_base_price < 0 THEN
569: X_base_price := 0;
570: END IF;
571:
572: /* Now insert a new row in OP_CNTR_DTL */
573: INSERT INTO OP_CNTR_DTL
574: ( price_id , contract_id ,
575: base_price , price_type ,
576: break_type , creation_date ,

Line 573: INSERT INTO OP_CNTR_DTL

569: X_base_price := 0;
570: END IF;
571:
572: /* Now insert a new row in OP_CNTR_DTL */
573: INSERT INTO OP_CNTR_DTL
574: ( price_id , contract_id ,
575: base_price , price_type ,
576: break_type , creation_date ,
577: last_update_date , last_updated_by ,