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