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 ,
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
18 PROCEDURE copy_contract( p_old_contract_id IN OP_CNTR_HDR.CONTRACT_ID%TYPE ,
19 p_contract_no IN OP_CNTR_HDR.CONTRACT_NO%TYPE ,
20 p_contract_desc1 IN OP_CNTR_HDR.CONTRACT_DESC1%TYPE,
21 p_contract_desc2 IN OP_CNTR_HDR.CONTRACT_DESC2%TYPE,
22 p_comments IN OP_CNTR_HDR.COMMENTS%TYPE ,
23 p_contract_currency IN OP_CNTR_HDR.CONTRACT_CURRENCY%TYPE ,
24 p_exchange_rate IN OP_CNTR_HDR.EXCHANGE_RATE%TYPE ,
25 p_mul_div_sign IN OP_CNTR_HDR.MUL_DIV_SIGN%TYPE ,
26 p_presales_ord_id IN OP_CNTR_HDR.PRESALES_ORD_ID%TYPE ,
27 p_price_change_type IN NUMBER ,
28 p_price_change IN NUMBER ,
29 p_decimal IN NUMBER ,
30 p_copy_text IN VARCHAR2 ,
31 p_user_id IN OP_CNTR_HDR.CREATED_BY%TYPE ,
32 p_err_num OUT NOCOPY NUMBER ,
33 p_err_msg OUT NOCOPY VARCHAR2
34 );
35
36 PROCEDURE copy_charge( p_old_charge_id IN OP_CHRG_MST.CHARGE_ID%TYPE ,
37 p_charge_code IN OP_CHRG_MST.CHARGE_CODE%TYPE ,
38 p_charge_desc IN OP_CHRG_MST.CHARGE_DESC%TYPE ,
39 p_charge_type IN OP_CHRG_MST.CHARGE_TYPE%TYPE ,
40 p_chgtax_class IN OP_CHRG_MST.CHGTAX_CLASS%TYPE ,
41 p_billable_ind IN OP_CHRG_MST.BILLABLE_IND%TYPE ,
42 p_currency_code IN OP_CHRG_MST.CURRENCY_CODE%TYPE ,
43 p_price_change_type IN NUMBER ,
44 p_price_change IN NUMBER ,
45 p_decimal IN NUMBER ,
46 p_copy_text IN VARCHAR2 ,
47 p_user_id IN OP_CHRG_MST.CREATED_BY%TYPE ,
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 ,
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
63 PROCEDURE copy_charge_asc ( p_old_chargeitem_id IN OP_CHRG_ITM.CHARGEITEM_ID%TYPE ,
64 p_charge_id IN OP_CHRG_ITM.CHARGE_ID%TYPE ,
65 p_copy_text IN VARCHAR2 ,
66 p_user_id IN OP_CHRG_MST.CREATED_BY%TYPE ,
67 p_err_num OUT NOCOPY NUMBER ,
68 p_err_msg OUT NOCOPY VARCHAR2
69 ) ;
70
71 PROCEDURE copy_text_record( p_old_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
72 p_new_text_code IN OP_TEXT_HDR.TEXT_CODE%TYPE ,
73 p_user_id IN OP_TEXT_HDR.CREATED_BY%TYPE
74 );
75
76 FUNCTION create_pricelist_id RETURN NUMBER;
77
78 FUNCTION create_price_id RETURN NUMBER;
79
80 FUNCTION create_breaktype_id RETURN NUMBER;
81
82 FUNCTION create_priceff_id RETURN NUMBER;
83
84 FUNCTION create_contract_id RETURN NUMBER;
85
86 FUNCTION create_charge_id RETURN NUMBER;
87
88 FUNCTION create_chargeitem_id RETURN NUMBER;
89
90 FUNCTION create_chargebreak_id RETURN NUMBER;
91
92 FUNCTION create_text_code RETURN NUMBER;
93
94 END;