1: PACKAGE GMLCOPPR AUTHID CURRENT_USER AS
2: /* $Header: GMLCPPRS.pls 115.1 2002/12/04 19:00:48 gmangari ship $ */
3: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
4: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
5: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
6: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
7: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
1: PACKAGE GMLCOPPR AUTHID CURRENT_USER AS
2: /* $Header: GMLCPPRS.pls 115.1 2002/12/04 19:00:48 gmangari ship $ */
3: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
4: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
5: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
6: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
7: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
8: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
1: PACKAGE GMLCOPPR AUTHID CURRENT_USER AS
2: /* $Header: GMLCPPRS.pls 115.1 2002/12/04 19:00:48 gmangari ship $ */
3: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
4: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
5: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
6: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
7: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
8: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
9: p_price_change_type IN NUMBER ,
2: /* $Header: GMLCPPRS.pls 115.1 2002/12/04 19:00:48 gmangari ship $ */
3: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
4: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
5: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
6: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
7: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
8: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
9: p_price_change_type IN NUMBER ,
10: p_price_change IN NUMBER ,
3: PROCEDURE copy_list ( p_old_pricelist_id IN OP_PRCE_MST.PRICELIST_ID%TYPE ,
4: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
5: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
6: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
7: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
8: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
9: p_price_change_type IN NUMBER ,
10: p_price_change IN NUMBER ,
11: p_decimal IN NUMBER ,
4: p_pricelist_code IN OP_PRCE_MST.PRICELIST_CODE%TYPE,
5: p_pricelist_desc1 IN OP_PRCE_MST.PRICELIST_DESC1%TYPE,
6: p_pricesort_name IN OP_PRCE_MST.PRICESORT_NAME%TYPE,
7: p_currency_code IN OP_PRCE_MST.CURRENCY_CODE%TYPE ,
8: p_comments IN OP_PRCE_MST.COMMENTS%TYPE ,
9: p_price_change_type IN NUMBER ,
10: p_price_change IN NUMBER ,
11: p_decimal IN NUMBER ,
12: p_copy_text IN VARCHAR2 ,
9: p_price_change_type IN NUMBER ,
10: p_price_change IN NUMBER ,
11: p_decimal IN NUMBER ,
12: p_copy_text IN VARCHAR2 ,
13: p_user_id IN OP_PRCE_MST.CREATED_BY%TYPE ,
14: p_err_num OUT NOCOPY NUMBER ,
15: p_err_msg OUT NOCOPY VARCHAR2
16: ) ;
17: