14: p_err_num OUT NOCOPY NUMBER ,
15: p_err_msg OUT NOCOPY VARCHAR2
16: ) ;
17:
18: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
19: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
20: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
15: p_err_msg OUT NOCOPY VARCHAR2
16: ) ;
17:
18: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
19: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
20: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
16: ) ;
17:
18: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
19: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
20: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
17:
18: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
19: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
20: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
25: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
18: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
19: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
20: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
25: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
26: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
19: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
20: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
25: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
26: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
27: p_price_change_type IN NUMBER ,
20: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
25: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
26: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
27: p_price_change_type IN NUMBER ,
28: p_price_change IN NUMBER ,
21: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
25: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
26: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
27: p_price_change_type IN NUMBER ,
28: p_price_change IN NUMBER ,
29: p_decimal IN NUMBER ,
22: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
25: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
26: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
27: p_price_change_type IN NUMBER ,
28: p_price_change IN NUMBER ,
29: p_decimal IN NUMBER ,
30: p_copy_text IN VARCHAR2 ,
27: p_price_change_type IN NUMBER ,
28: p_price_change IN NUMBER ,
29: p_decimal IN NUMBER ,
30: p_copy_text IN VARCHAR2 ,
31: p_user_id IN OP_CNTR_HDR.CREATED_BY%TYPE ,
32: p_err_num OUT NOCOPY NUMBER ,
33: p_err_msg OUT NOCOPY VARCHAR2
34: );
35: