1 PACKAGE ASO_QUOTE_CUHK AUTHID CURRENT_USER as
2 /* $Header: asocqtes.pls 120.5 2011/12/26 13:03:53 rassharm ship $ */
3 -- Start of Comments
4 -- Start of Comments
5 -- Package name : ASO_QUOTE_CUHK
6 -- Purpose :
7 -- This package is the spec required for customer user hooks needed to
8 -- simplify the customization process. It consists of both the pre and
9 -- post processing APIs.
10
11
12
13
14
15 -- *******************************************************
16 -- Start of Comments
17 -- *******************************************************
18 -- API Name: Create_quote
19 -- Type : Public
20 -- Pre-Req :
21 -- Parameters:
22 -- IN
23 -- p_api_version_number IN NUMBER Required
24 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
25 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
26 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
27 --
28 -- OUT:
29 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
31 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 -- Version : Current version 2.0
33 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
34 -- and basic operation, developer must manually add parameters and business logic as necessary.
35 --
36 -- End of Comments
37 --
38
39
40 PROCEDURE Create_quote_PRE(
41 P_Validation_Level IN OUT NOCOPY NUMBER ,
42 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
43 P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
44 P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
45 P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
46 P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
47 P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
48 P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
49 P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
50 P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
51 P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
52 P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
53 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
54 P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
55 P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
56 P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
57 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
58 P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
59 P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
60 P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
61 P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
62 P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
63 P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
64 P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
65 P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
66 P_Related_Obj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type,
67 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
69 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 );
71
72
73
74 PROCEDURE Create_quote_POST(
75 P_Validation_Level IN NUMBER ,
76 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
77 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
78 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
79 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
80 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
81 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
82 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
83 P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
84 P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
85 P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
86 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
87 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
88 P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
89 P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
90 P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
91 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
92 P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
93 P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
94 P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
95 P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
96 P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
97 P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
98 P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
99 P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
100 P_Related_Obj_Tbl IN ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type, -- bug 13533957
101 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
103 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 );
105
106
107
108
109 -- *******************************************************
110 -- Start of Comments
111 -- *******************************************************
112 -- API Name: Update_quote
113 -- Type : Public
114 -- Pre-Req :
115 -- Parameters:
116 -- IN
117 -- p_api_version_number IN NUMBER Required
118 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
121 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
122 --
123 -- OUT:
124 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
126 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 -- Version : Current version 2.0
128 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
129 -- and basic operation, developer must manually add parameters and business logic as necessary.
130 --
131 -- End of Comments
132 --
133 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
134 PROCEDURE Update_quote_PRE(
135 P_Validation_Level IN OUT NOCOPY /* file.sql.39 change */ NUMBER ,
136 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
137 P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
138 P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
139 P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
140 P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
141 P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
142 P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
143 P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
144 P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
145 P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
146 P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
147 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
148 P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
149 P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
150 P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
151 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
152 P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
153 P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
154 P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
155 P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
156 P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
157 P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
158 P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
159 P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
160 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
161 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
162 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
163 );
164
165
166
167 PROCEDURE UPdate_quote_POST(
168 P_Validation_Level IN NUMBER ,
169 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
170 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
171 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
172 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
173 P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
174 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
175 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
176 P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
177 P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
178 P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
179 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
180 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
181 P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
182 P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
183 P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
184 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
185 P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
186 P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
187 P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
188 P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
189 P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
190 P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
191 P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
192 P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
193 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
194 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
195 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
196 );
197
198
199
200
201
202 -- *******************************************************
203 -- Start of Comments
204 -- *******************************************************
205 -- API Name: Delete_quote
206 -- Type : Public
207 -- Pre-Req :
208 -- Parameters:
209 -- IN
210 -- p_api_version_number IN NUMBER Required
211 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
212 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
213 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
214 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
215 --
216 -- OUT:
217 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
218 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
219 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
220 -- Version : Current version 2.0
221 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
222 -- and basic operation, developer must manually add parameters and business logic as necessary.
223 --
224 -- End of Comments
225 --
226 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
227 -- The Master delete procedure may not be needed depends on different business requirements.
228 PROCEDURE Delete_quote_PRE(
229 P_Qte_Header_Id IN OUT NOCOPY NUMBER,
230 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
231 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
232 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
233 );
234
235
236 PROCEDURE Delete_quote_POST(
237 P_Qte_Header_Id IN NUMBER,
238 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
239 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
240 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
241 );
242
243 -- *******************************************************
244 -- Start of Comments
245 -- *******************************************************
246 -- API Name: Copy_quote
247 -- Type : Public
248 -- Pre-Req :
249 -- Parameters:
250 -- IN
251 -- p_api_version_number IN NUMBER Required
252 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
253 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
254 --
255 -- OUT:
256 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
257 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
258 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
259 -- Version : Current version 2.0
260 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
264 --
261 -- and basic operation, developer must manually add parameters and business logic as necessary.
262 --
263 -- End of Comments
265 PROCEDURE Copy_quote_PRE(
266 P_Qte_Header_Id IN OUT NOCOPY NUMBER,
267 P_Last_Update_Date IN OUT NOCOPY DATE,
268 P_Copy_Only_Header IN OUT NOCOPY VARCHAR2,
269 P_New_Version IN OUT NOCOPY VARCHAR2,
270 P_Qte_Status_Id IN OUT NOCOPY NUMBER ,
271 P_Qte_Number IN OUT NOCOPY NUMBER ,
272 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
273 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
274 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
275 );
276
277
278 PROCEDURE Copy_quote_POST(
279 P_Qte_Header_Id IN NUMBER,
280 P_Last_Update_Date IN DATE,
281 P_Copy_Only_Header IN VARCHAR2 ,
282 P_New_Version IN VARCHAR2 ,
283 P_Qte_Status_Id IN NUMBER ,
284 P_Qte_Number IN NUMBER ,
285 P_NEW_Qte_Header_Id IN NUMBER,
286 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
287 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
288 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
289 );
290
291
292
293
294
295
296 -- *******************************************************
297 -- Start of Comments
298 -- *******************************************************
299 -- API Name: Submit_Quote
300 -- Type : Public
301 -- Pre-Req :
302 -- Parameters:
303 -- IN
304 -- p_api_version_number IN NUMBER Required
305 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
306 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
307 -- OUT:
308 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
309 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
310 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
311 -- Version : Current version 2.0
312 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
313 -- and basic operation, developer must manually add parameters and business logic as necessary.
314 --
315 -- End of Comments
316 --
317 PROCEDURE Submit_quote_PRE(
318 p_control_rec IN OUT NOCOPY ASO_QUOTE_PUB.Submit_Control_Rec_Type,
319 P_Qte_Header_Id IN OUT NOCOPY NUMBER,
320 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
321 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
322 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
323 );
324
325
326 PROCEDURE Submit_quote_POST(
327 p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,
328 P_Qte_Header_Id IN NUMBER,
329 p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,
330 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
331 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
332 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
333 );
334
335
336
337
338
339 -- *******************************************************
340 -- Start of Comments
341 -- *******************************************************
342 -- API Name: Create_Quote_Line
343 -- Type : Public
344 -- Pre-Req :
345 -- Parameters:
346 -- IN
347 -- p_api_version_number IN NUMBER Required
348 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
349 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
350 -- P_qte_lines_Rec IN qte_line_Rec_Type Required
351 -- P_quote_header_id IN NUMBER Required
352 -- P_header_last_update_date IN DATE Required
353 -- P_Payment_Tbl IN Payment_Tbl_Type
354 -- P_Price_Adj_Tbl IN Price_Adj_Tbl_Type
355 -- P_Qte_Line_Dtl_Rec IN Qte_Line_Dtl_Rec_Type
356 -- P_Shipment_Tbl IN Shipment_Tbl_Type
357 -- P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
358 -- P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
359 -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
360 -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
361 -- P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
362 -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
363
364 -- OUT:
365 -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
366 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
367 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
368 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
369 -- Version : Current version 2.0
370 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
371 -- and basic operation, developer must manually add parameters and business logic as necessary.
372 --
373
374
375 -- do not need defaults because they are already defaulted in the call to
376 -- the public api
377 -- End of Comments
378 --
379 PROCEDURE Create_Quote_Line_PRE(
380 P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
381 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
382 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
383 P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
387 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
384 P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
385 P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
386 P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
388 P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
389 P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
390 P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
391 P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
392 P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
393 P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
394 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
395 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
396 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
397 );
398
399
400
401 PROCEDURE Create_Quote_Line_POST(
402 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
403 P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
404 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
405 P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
406 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
407 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
408 P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
409 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
410 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
411 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
412 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
413 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
414 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
415 P_Update_Header_Flag IN VARCHAR2 ,
416 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
417 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
418 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
419 );
420
421
422 -- *******************************************************
423 -- Start of Comments
424 -- *******************************************************
425 -- API Name: Update_Quote_Line
426 -- Type : Public
427 -- Pre-Req :
428 -- Parameters:
429 -- IN
430
431
432 PROCEDURE Update_Quote_Line_PRE(
433 P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
434 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
435 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
436 P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
437 P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
438 P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
439 P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
440 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
441 P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
442 P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
443 P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
444 P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
445 P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
446 P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
447 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
448 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
449 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
450 );
451
452
453
454 PROCEDURE Update_Quote_Line_POST(
455 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
456 P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
457 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
458 P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
459 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
460 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
461 P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
462 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
463 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
464 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
465 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
466 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
467 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
468 P_Update_Header_Flag IN VARCHAR2 ,
469 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
470 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
471 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472 );
473
474
475
476 -- *******************************************************
477 -- Start of Comments
478 -- *******************************************************
479 -- API Name: Delete_Quote_Line
480 -- Type : Public
481 -- Pre-Req :
482 -- Parameters:
483 -- IN
484 -- p_api_version_number IN NUMBER Required
485 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
486 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
487 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
488 -- P_qte_line_Rec IN qte_line_Rec_Type Required
489 -- P_quote_header_id IN NUMBER Required
490 -- P_header_last_update_date IN DATE Required
491 --
492 -- OUT:
493 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
494 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
495 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
496 -- Version : Current version 2.0
497 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
498 -- and basic operation, developer must manually add parameters and business logic as necessary.
499 --
500 -- End of Comments
501 --
502 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
503 -- The Master delete procedure may not be needed depends on different business requirements.
504
505 PROCEDURE Delete_Quote_Line_PRE(
506 P_qte_line_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_Rec_Type,
507 P_Control_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Control_rec_Type,
508 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
509 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
510 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
511 );
512
513 PROCEDURE Delete_Quote_Line_POST(
514 P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
515 P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
516 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
517 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
518 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
519 );
520
521 PROCEDURE Allocate_Sales_Credits_PRE(
522 p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
523 P_Qte_Header_Id IN NUMBER,
524 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
525 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
526 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
527
528 PROCEDURE Allocate_Sales_Credits_POST(
529 p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
530 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
531 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
532 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
533 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
534
535 End ASO_QUOTE_CUHK;