236: | user defined: Procedure specific : -30040 to -30049 |
237: | |
238: +========================================================================*/
239:
240: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
241: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
242: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
243: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
244: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
237: | |
238: +========================================================================*/
239:
240: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
241: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
242: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
243: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
244: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
245: p_copy_text IN VARCHAR2 ,
238: +========================================================================*/
239:
240: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
241: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
242: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
243: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
244: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
245: p_copy_text IN VARCHAR2 ,
246: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
239:
240: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
241: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
242: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
243: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
244: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
245: p_copy_text IN VARCHAR2 ,
246: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
247: p_err_num OUT NOCOPY NUMBER ,
240: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
241: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
242: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
243: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
244: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
245: p_copy_text IN VARCHAR2 ,
246: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
247: p_err_num OUT NOCOPY NUMBER ,
248: p_err_msg OUT NOCOPY VARCHAR2
242: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
243: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
244: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
245: p_copy_text IN VARCHAR2 ,
246: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
247: p_err_num OUT NOCOPY NUMBER ,
248: p_err_msg OUT NOCOPY VARCHAR2
249: ) IS
250: BEGIN