48: p_err_num OUT NOCOPY NUMBER ,
49: p_err_msg OUT NOCOPY VARCHAR2
50: ) ;
51:
52: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
53: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
54: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
55: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
56: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
49: p_err_msg OUT NOCOPY VARCHAR2
50: ) ;
51:
52: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
53: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
54: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
55: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
56: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
57: p_copy_text IN VARCHAR2 ,
50: ) ;
51:
52: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
53: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
54: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
55: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
56: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
57: p_copy_text IN VARCHAR2 ,
58: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
51:
52: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
53: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
54: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
55: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
56: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
57: p_copy_text IN VARCHAR2 ,
58: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
59: p_err_num OUT NOCOPY NUMBER ,
52: PROCEDURE copy_effectivity( p_old_priceff_id IN OP_PRCE_EFF.PRICEFF_ID%TYPE ,
53: p_list_id IN OP_PRCE_EFF.PRICELIST_ID%TYPE ,
54: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
55: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
56: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
57: p_copy_text IN VARCHAR2 ,
58: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
59: p_err_num OUT NOCOPY NUMBER ,
60: p_err_msg OUT NOCOPY VARCHAR2
54: p_new_start_date IN OP_PRCE_EFF.START_DATE%TYPE ,
55: p_new_end_date IN OP_PRCE_EFF.END_DATE%TYPE ,
56: p_new_preference IN OP_PRCE_EFF.PREFERENCE%TYPE ,
57: p_copy_text IN VARCHAR2 ,
58: p_user_id IN OP_PRCE_EFF.CREATED_BY%TYPE ,
59: p_err_num OUT NOCOPY NUMBER ,
60: p_err_msg OUT NOCOPY VARCHAR2
61: );
62: