[Home] [Help]
46: | Database errors : -1 to -30000 |
47: | User defined :common to the package: -30001 to -30009 |
48: | user defined: Procedure specific : -30010 to -30019 |
49: +========================================================================*/
50: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
51: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
52: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
53: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
54: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
47: | User defined :common to the package: -30001 to -30009 |
48: | user defined: Procedure specific : -30010 to -30019 |
49: +========================================================================*/
50: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
51: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
52: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
53: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
54: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
55: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
48: | user defined: Procedure specific : -30010 to -30019 |
49: +========================================================================*/
50: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
51: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
52: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
53: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
54: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
55: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
56: p_price_change_type IN NUMBER ,
49: +========================================================================*/
50: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
51: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
52: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
53: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
54: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
55: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
56: p_price_change_type IN NUMBER ,
57: p_price_change IN NUMBER ,
50: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
51: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
52: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
53: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
54: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
55: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
56: p_price_change_type IN NUMBER ,
57: p_price_change IN NUMBER ,
58: p_decimal IN NUMBER ,
51: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
52: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
53: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
54: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
55: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
56: p_price_change_type IN NUMBER ,
57: p_price_change IN NUMBER ,
58: p_decimal IN NUMBER ,
59: p_copy_text IN VARCHAR2 ,
56: p_price_change_type IN NUMBER ,
57: p_price_change IN NUMBER ,
58: p_decimal IN NUMBER ,
59: p_copy_text IN VARCHAR2 ,
60: p_user_id IN OP_PRCE_MST.CREATED_BY%TYPE ,
61: p_err_num OUT NOCOPY NUMBER ,
62: p_err_msg OUT NOCOPY VARCHAR2
63: ) IS
64: