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