112: | Database errors : -1 to -30000 |
113: | User defined :common to the package: -30001 to -30009 |
114: | user defined: Procedure specific : -30020 to -30029 |
115: +========================================================================*/
116: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
117: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
118: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
113: | User defined :common to the package: -30001 to -30009 |
114: | user defined: Procedure specific : -30020 to -30029 |
115: +========================================================================*/
116: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
117: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
118: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
114: | user defined: Procedure specific : -30020 to -30029 |
115: +========================================================================*/
116: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
117: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
118: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
122: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
115: +========================================================================*/
116: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
117: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
118: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
122: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
123: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
116: PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
117: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
118: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
122: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
123: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
124: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
117: p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
118: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
122: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
123: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
124: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
125: p_price_change_type IN NUMBER ,
118: p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
122: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
123: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
124: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
125: p_price_change_type IN NUMBER ,
126: p_price_change IN NUMBER ,
119: p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
122: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
123: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
124: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
125: p_price_change_type IN NUMBER ,
126: p_price_change IN NUMBER ,
127: p_decimal IN NUMBER ,
120: p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
121: p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
122: p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
123: p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
124: p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
125: p_price_change_type IN NUMBER ,
126: p_price_change IN NUMBER ,
127: p_decimal IN NUMBER ,
128: p_copy_text IN VARCHAR2 ,
125: p_price_change_type IN NUMBER ,
126: p_price_change IN NUMBER ,
127: p_decimal IN NUMBER ,
128: p_copy_text IN VARCHAR2 ,
129: p_user_id IN OP_CNTR_HDR.CREATED_BY%TYPE ,
130: p_err_num OUT NOCOPY NUMBER ,
131: p_err_msg OUT NOCOPY VARCHAR2
132: ) IS
133: