eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMLCOPPR dependencies on OP_CNTR_HDR

Line 389: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,

385: | Database errors : -1 to -30000 |
386: | User defined :common to the package: -30001 to -30009 |
387: | user defined: Procedure specific : -30020 to -30029 |
388: +========================================================================*/
389: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
390: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,

Line 390: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,

386: | User defined :common to the package: -30001 to -30009 |
387: | user defined: Procedure specific : -30020 to -30029 |
388: +========================================================================*/
389: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
390: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,

Line 391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,

387: | user defined: Procedure specific : -30020 to -30029 |
388: +========================================================================*/
389: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
390: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,

Line 392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,

388: +========================================================================*/
389: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
390: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
396: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,

Line 393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,

389: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
390: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
396: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
397: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,

Line 394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,

390: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
396: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
397: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
398: p_price_change_type IN NUMBER ,

Line 395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,

391: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
396: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
397: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
398: p_price_change_type IN NUMBER ,
399: p_price_change IN NUMBER ,

Line 396: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,

392: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
396: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
397: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
398: p_price_change_type IN NUMBER ,
399: p_price_change IN NUMBER ,
400: p_decimal IN NUMBER ,

Line 397: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,

393: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
394: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
395: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
396: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
397: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
398: p_price_change_type IN NUMBER ,
399: p_price_change IN NUMBER ,
400: p_decimal IN NUMBER ,
401: p_copy_text IN VARCHAR2 ,

Line 402: p_user_id IN OP_CNTR_HDR.CREATED_BY%TYPE ,

398: p_price_change_type IN NUMBER ,
399: p_price_change IN NUMBER ,
400: p_decimal IN NUMBER ,
401: p_copy_text IN VARCHAR2 ,
402: p_user_id IN OP_CNTR_HDR.CREATED_BY%TYPE ,
403: p_err_num OUT NOCOPY NUMBER ,
404: p_err_msg OUT NOCOPY VARCHAR2
405: ) IS
406: /* Cursors */

Line 409: FROM op_cntr_hdr

405: ) IS
406: /* Cursors */
407: CURSOR Cur_cntr_hdr IS
408: SELECT *
409: FROM op_cntr_hdr
410: WHERE contract_id = p_old_contract_id;
411:
412: CURSOR Cur_cntr_dtl IS
413: SELECT *

Line 426: X_contract_id OP_CNTR_HDR.CONTRACT_ID%TYPE;

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 ;

Line 429: X_cntr_hdr_text_code OP_CNTR_HDR.TEXT_CODE%TYPE ;

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

Line 474: /* Now write the OP_CNTR_HDR record to the table. */

470: X_cntr_hdr_text_code := NULL;
471: END IF;
472:
473:
474: /* Now write the OP_CNTR_HDR record to the table. */
475: /* When creating a new record, if the following parameters are passed in as NULLs, replace them with */
476: /* the corresponding values form the old contract: */
477: /* Contract_desc1, Contract_desc2, contract_currency, Exchange_rate, Mul_div_sign */
478: INSERT INTO OP_CNTR_HDR

Line 478: INSERT INTO OP_CNTR_HDR

474: /* Now write the OP_CNTR_HDR record to the table. */
475: /* When creating a new record, if the following parameters are passed in as NULLs, replace them with */
476: /* the corresponding values form the old contract: */
477: /* Contract_desc1, Contract_desc2, contract_currency, Exchange_rate, Mul_div_sign */
478: INSERT INTO OP_CNTR_HDR
479: ( contract_id , presales_ord_id ,
480: contract_desc1 ,
481: contract_desc2 ,
482: comments ,