1 PACKAGE CS_CHARGE_DETAILS_CUHK AUTHID CURRENT_USER AS
2 /* $Header: cschrs.pls 120.4 2011/03/18 16:55:17 vpremach ship $ */
3
4
5 /*======================================================================+
6 ==
7 == Package name : CS_CHARGE_DETAILS_CUHK
8 == Description : This is the Customer User Hook API.
9 == The Customers can add customization procedures here for Pre and Post Processing.
10 ==
11 ==
12 ==
13 == Modification History:
14 ==
15 == Date Name Desc
16 == ---------- --------- ---------------------------------------------
17 == 11/18/2004 mviswana Bug fixed 3868233 .
18 == in Create_Charge_Details_Post, Update_Charge_Details_Pre and Update_Charge_Details_Post.
19 == 11/18/2004 mviswana Bug Fixed 3951392 .
20 == in Create_Charge_Details_Post, Update_Charge_Details_Pre and Update_Charge_Details_Post.
21 == 07/07/2005 mviswana Bug Fixed 3951397
22 == primary key unknown in user hook CS_CHARGE_DETAILS_CUHK
23 ==
24 ========================================================================*/
25 /* Customer Procedure for pre processing in case of create charge details */
26
27 Procedure Create_Charge_Details_Pre(
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_object_version_number OUT NOCOPY NUMBER,
35 x_estimate_detail_id OUT NOCOPY NUMBER,
36 x_line_number OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_resp_appl_id IN NUMBER DEFAULT NULL,
39 p_resp_id IN NUMBER DEFAULT NULL,
40 p_user_id IN NUMBER DEFAULT NULL,
41 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
42 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
43 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
44
45
46 /* Customer Procedure for post processing in case of
47 create charge details */
48
49
50 Procedure Create_Charge_Details_Post(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_object_version_number OUT NOCOPY NUMBER,
58 x_estimate_detail_id IN OUT NOCOPY NUMBER, --3951392
59 x_line_number OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_resp_appl_id IN NUMBER DEFAULT NULL,
62 p_resp_id IN NUMBER DEFAULT NULL,
63 p_user_id IN NUMBER DEFAULT NULL,
64 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
65 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
66 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
67
68
69
70 /* Customer Procedure for pre processing in case of update charge details */
71
72 Procedure Update_Charge_Details_Pre(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_object_version_number OUT NOCOPY NUMBER,
80 x_estimate_detail_id IN OUT NOCOPY NUMBER, --3951392
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_resp_appl_id IN NUMBER DEFAULT NULL,
83 p_resp_id IN NUMBER DEFAULT NULL,
84 p_user_id IN NUMBER DEFAULT NULL,
85 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
86 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
87 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
88
89
90 /* Customer Procedure for post processing in case of
91 update charge details */
92
93
94 Procedure Update_Charge_Details_Post(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_object_version_number OUT NOCOPY NUMBER,
102 x_estimate_detail_id IN OUT NOCOPY NUMBER, --3951392
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_resp_appl_id IN NUMBER DEFAULT NULL,
105 p_resp_id IN NUMBER DEFAULT NULL,
106 p_user_id IN NUMBER DEFAULT NULL,
107 p_login_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
108 p_transaction_control IN VARCHAR2 DEFAULT FND_API.G_TRUE,
109 p_est_detail_rec IN CS_Charge_Details_PUB.Charges_Rec_Type);
110
111
112
113 /* Customer Procedure for pre processing in case of call pricing item */
114 Procedure Call_Pricing_Item_Pre (
115 p_inventory_item_id IN NUMBER,
116 p_price_list_id IN NUMBER,
117 p_uom_code IN VARCHAR2,
118 p_currency_code IN VARCHAR2,
119 p_quantity IN NUMBER,
120 p_org_id IN NUMBER,
121 x_list_price OUT NOCOPY NUMBER,
122 p_in_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2 );
126
127 /* Customer Procedure for pre processing in case of Create Order, Bug 11839090*/
128 Procedure Create_Order(
129 P_Api_Version_Number IN NUMBER,
130 l_header_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
131 l_hd_shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
132 l_line_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
133 l_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
134 l_ln_shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
135 l_hd_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
136 l_ln_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
137 l_line_price_adj_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
138 l_lot_serial_tbl IN OUT NOCOPY ASO_ORDER_INT.Lot_Serial_Tbl_Type,
139 l_Control_Rec IN OUT NOCOPY ASO_ORDER_INT.control_rec_type,
140 X_Return_Status OUT NOCOPY VARCHAR2,
141 X_Msg_Count OUT NOCOPY NUMBER,
142 X_Msg_Data OUT NOCOPY VARCHAR2
143 );
144 /* Customer Procedure for pre processing in case of Update Order, Bug 11839090 */
145 Procedure Update_Order(
146 P_Api_Version_Number IN NUMBER,
147 l_header_rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
148 l_line_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
149 l_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
150 l_ln_shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
151 l_hd_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
152 l_ln_payment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
153 l_line_price_adj_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
154 l_lot_serial_tbl IN OUT NOCOPY ASO_ORDER_INT.Lot_Serial_Tbl_Type,
155 l_control_rec IN OUT NOCOPY ASO_ORDER_INT.control_rec_type,
156 X_Order_Header_Rec OUT NOCOPY ASO_ORDER_INT.Order_Header_rec_type,
157 X_Order_Line_Tbl OUT NOCOPY ASO_ORDER_INT.Order_Line_tbl_type,
158 X_Return_Status OUT NOCOPY VARCHAR2,
159 X_Msg_Count OUT NOCOPY NUMBER,
160 X_Msg_Data OUT NOCOPY VARCHAR2
161 );
162
163 END CS_CHARGE_DETAILS_CUHK ;