1 PACKAGE ASO_QUOTE_VUHK AUTHID CURRENT_USER as
2 /* $Header: asohqtes.pls 120.1 2005/06/29 12:32:05 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
10
11
12
13
14 -- *******************************************************
15 -- Start of Comments
16 -- *******************************************************
17 -- API Name: Create_quote
18 -- Type : Public
19 -- Pre-Req :
20 -- Parameters:
21 -- IN
22 -- p_api_version_number IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
26 --
27 -- OUT:
28 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
30 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 -- Version : Current version 2.0
32 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
33 -- and basic operation, developer must manually add parameters and business logic as necessary.
34 --
35 -- End of Comments
36 --
37 G_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC;
38 G_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Attributes_TBL;
39 G_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.g_miss_Payment_Tbl;
40 G_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.g_miss_Shipment_Rec;
41 G_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := ASO_QUOTE_PUB.g_miss_Freight_Charge_Tbl;
42 G_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.g_miss_Tax_Detail_Tbl;
43 G_hd_Attribs_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_Tbl;
44 G_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl;
45 G_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl;
46 G_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl ;
47 G_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Tbl ;
48 G_Line_Rltship_Tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl;
49 G_Price_Adj_rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_Tbl;
50 G_ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_Price_Attributes_Tbl;
51 G_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Attr_Tbl;
52 G_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_Tbl;
53 G_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Tbl;
54 G_ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Freight_Charge_Tbl;
55 G_ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl;
56 G_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl;
57 G_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl;
58 G_Line_Attribs_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_Tbl ;
59 G_Qte_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
60 G_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
61 G_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
62 G_Last_Update_Date DATE := FND_API.G_MISS_DATE;
63 G_Copy_Only_Header VARCHAR2(1) := FND_API.G_FALSE;
64 G_New_Version VARCHAR2(1) := FND_API.G_FALSE;
65 G_Qte_Status_Id NUMBER := NULL;
66 G_Qte_Number NUMBER := NULL;
67 G_NEW_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
68 PROCEDURE Create_quote_PRE(
69 P_Validation_Level IN OUT NOCOPY NUMBER ,
70 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
71 P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
72 P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
73 P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
74 P_hd_Shipment_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Rec_Type,
75 P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
76 P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
77 P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
78 P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
79 P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
80 P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
81 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
82 P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
83 P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
84 P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
85 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
86 P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
87 P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
88 P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
89 P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
90 P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
91 P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
92 P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
93 P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
94 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
96 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 );
98
99
100
101 PROCEDURE Create_quote_POST(
102 P_Validation_Level IN NUMBER ,
103 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
104 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
105 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
106 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
107 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
108 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
109 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
110 P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
111 P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
112 P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
113 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
114 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
115 P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
116 P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
117 P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
118 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
119 P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
120 P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
121 P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
122 P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
123 P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
124 P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
125 P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
126 P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
127 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
128 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
129 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 );
131
132
133
134
135 -- *******************************************************
136 -- Start of Comments
137 -- *******************************************************
138 -- API Name: Update_quote
139 -- Type : Public
140 -- Pre-Req :
141 -- Parameters:
142 -- IN
143 -- p_api_version_number IN NUMBER Required
144 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
145 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147 -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
148 --
149 -- OUT:
150 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
152 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 -- Version : Current version 2.0
154 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
155 -- and basic operation, developer must manually add parameters and business logic as necessary.
156 --
157 -- End of Comments
158 --
159 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
160 PROCEDURE Update_quote_PRE(
161 P_Validation_Level IN OUT NOCOPY NUMBER ,
162 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
163 P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
164 P_hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
165 P_hd_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
166 P_hd_Shipment_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_tbl_Type,
167 P_hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
168 P_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
169 P_hd_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
170 P_hd_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
171 P_hd_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
172 P_Qte_Line_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
173 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
174 P_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
175 P_line_rltship_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
176 P_Price_Adjustment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
177 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
178 P_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
179 P_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
180 P_Ln_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type ,
181 P_Ln_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
182 P_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
183 P_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
184 P_ln_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
185 P_ln_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
186 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
187 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
188 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 );
190
191
192
193 PROCEDURE UPdate_quote_POST(
194 P_Validation_Level IN NUMBER ,
195 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type ,
196 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type ,
197 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
198 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
199 P_hd_Shipment_tbl IN ASO_QUOTE_PUB.Shipment_tbl_Type,
200 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
201 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
202 P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
203 P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
204 P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
205 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type ,
206 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
207 P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
208 P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
209 P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
210 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
211 P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
212 P_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
213 P_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type ,
214 P_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
215 P_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
216 P_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
217 P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB. Sales_Credit_Tbl_Type,
218 P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB. Quote_Party_Tbl_Type,
219 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
220 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
221 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
222 );
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
261
262 PROCEDURE Delete_quote_POST(
263 P_Qte_Header_Id IN NUMBER,
264 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
265 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
266 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
267 );
268
269 -- *******************************************************
270 -- Start of Comments
271 -- *******************************************************
272 -- API Name: Copy_quote
273 -- Type : Public
274 -- Pre-Req :
275 -- Parameters:
276 -- IN
277 -- p_api_version_number IN NUMBER Required
278 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
279 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
280 --
281 -- OUT:
282 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
283 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
284 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
285 -- Version : Current version 2.0
286 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
287 -- and basic operation, developer must manually add parameters and business logic as necessary.
288 --
289 -- End of Comments
290 --
291 PROCEDURE Copy_quote_PRE(
292 P_Qte_Header_Id IN OUT NOCOPY NUMBER,
293 P_Last_Update_Date IN OUT NOCOPY DATE,
294 P_Copy_Only_Header IN OUT NOCOPY VARCHAR2,
295 P_New_Version IN OUT NOCOPY VARCHAR2,
296 P_Qte_Status_Id IN OUT NOCOPY NUMBER ,
297 P_Qte_Number IN OUT NOCOPY NUMBER ,
298 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
299 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
300 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
301 );
302
303
304 PROCEDURE Copy_quote_POST(
305 P_Qte_Header_Id IN NUMBER,
306 P_Last_Update_Date IN DATE,
307 P_Copy_Only_Header IN VARCHAR2 ,
308 P_New_Version IN VARCHAR2 ,
309 P_Qte_Status_Id IN NUMBER ,
310 P_Qte_Number IN NUMBER ,
311 P_NEW_Qte_Header_Id IN NUMBER,
312 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
313 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
314 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
315 );
316
317
318
319
320
321
322 -- *******************************************************
323 -- Start of Comments
324 -- *******************************************************
325 -- API Name: Submit_Quote
326 -- Type : Public
327 -- Pre-Req :
328 -- Parameters:
329 -- IN
330 -- p_api_version_number IN NUMBER Required
331 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
332 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
333 -- OUT:
334 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
335 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
336 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337 -- Version : Current version 2.0
338 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
339 -- and basic operation, developer must manually add parameters and business logic as necessary.
340 --
341 -- End of Comments
342 --
343 PROCEDURE Submit_quote_PRE(
344 p_control_rec IN OUT NOCOPY ASO_QUOTE_PUB.Submit_Control_Rec_Type,
345 P_Qte_Header_Id IN OUT NOCOPY NUMBER,
346 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
347 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
348 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
349 );
350
351
352 PROCEDURE Submit_quote_POST(
353 p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type ,
354 P_Qte_Header_Id IN NUMBER,
355 p_order_header_rec IN ASO_QUOTE_PUB.Order_Header_Rec_Type,
356 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
357 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
358 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359 );
360
361
362 -- *******************************************************
363 -- Start of Comments
364 -- *******************************************************
365 -- API Name: Create_Quote_Line
366 -- Type : Public
367 -- Pre-Req :
368 -- Parameters:
369 -- IN
370 -- p_api_version_number IN NUMBER Required
371 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
372 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
373 -- P_qte_lines_Rec IN qte_line_Rec_Type Required
374 -- P_quote_header_id IN NUMBER Required
375 -- P_header_last_update_date IN DATE Required
376 -- P_Payment_Tbl IN Payment_Tbl_Type
377 -- P_Price_Adj_Tbl IN Price_Adj_Tbl_Type
378 -- P_Qte_Line_Dtl_Rec IN Qte_Line_Dtl_Rec_Type
379 -- P_Shipment_Tbl IN Shipment_Tbl_Type
380 -- P_Tax_Detail_Tbl IN Tax_Detail_Tbl_Type
381 -- P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
382 -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
383 -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
384 -- P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
385 -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
386
387 -- OUT:
388 -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
389 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
390 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
391 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
392 -- Version : Current version 2.0
393 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
394 -- and basic operation, developer must manually add parameters and business logic as necessary.
395 --
396
397
398 -- do not need defaults because they are already defaulted in the call to
399 -- the public api
400 -- End of Comments
401 --
402 PROCEDURE Create_Quote_Line_PRE(
403 P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
404 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
405 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
406 P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
407 P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
408 P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
409 P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
410 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
411 P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
412 P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
413 P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
414 P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
415 P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
416 P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
417 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
418 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
419 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
420 );
421
422
423
424 PROCEDURE Create_Quote_Line_POST(
425 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
426 P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
427 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
428 P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
429 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
430 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
431 P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
432 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
433 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
434 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
435 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
436 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
437 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
438 P_Update_Header_Flag IN VARCHAR2 ,
439 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
440 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
441 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442 );
443
444
445 -- *******************************************************
446 -- Start of Comments
447 -- *******************************************************
448 -- API Name: Update_Quote_Line
449 -- Type : Public
450 -- Pre-Req :
451 -- Parameters:
452 -- IN
453
454
455 PROCEDURE Update_Quote_Line_PRE(
456 P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
457 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_rec_Type,
458 P_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
459 P_Line_Attribs_Ext_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
460 P_Payment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Payment_Tbl_Type,
461 P_Price_Adj_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Tbl_Type ,
462 P_Price_Attributes_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
463 P_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
464 P_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
465 P_Tax_Detail_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
466 P_Freight_Charge_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
467 P_Sales_Credit_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
468 P_Quote_Party_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
469 P_Update_Header_Flag IN OUT NOCOPY VARCHAR2,
470 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
471 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
472 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
473 );
474
475
476
477 PROCEDURE Update_Quote_Line_POST(
478 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
479 P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
480 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
481 P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
482 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
483 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
484 P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
485 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
486 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
487 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
488 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
489 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ,
490 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
491 P_Update_Header_Flag IN VARCHAR2 ,
492 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
493 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
494 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
495 );
496
497
498
499 -- *******************************************************
500 -- Start of Comments
501 -- *******************************************************
502 -- API Name: Delete_Quote_Line
503 -- Type : Public
504 -- Pre-Req :
505 -- Parameters:
506 -- IN
507 -- p_api_version_number IN NUMBER Required
508 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
509 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
510 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
511 -- P_qte_line_Rec IN qte_line_Rec_Type Required
512 -- P_quote_header_id IN NUMBER Required
513 -- P_header_last_update_date IN DATE Required
514 --
515 -- OUT:
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 -- Version : Current version 2.0
520 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
521 -- and basic operation, developer must manually add parameters and business logic as necessary.
522 --
523 -- End of Comments
524 --
525 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
526 -- The Master delete procedure may not be needed depends on different business requirements.
527
528 PROCEDURE Delete_Quote_Line_PRE(
529 P_qte_line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.qte_line_Rec_Type,
530 P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_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
536 PROCEDURE Delete_Quote_Line_POST(
537 P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
538 P_Control_Rec IN ASO_QUOTE_PUB.Control_rec_Type,
539 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
540 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
541 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
542 );
543
544 PROCEDURE Allocate_Sales_Credits_PRE(
545 p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
546 P_Qte_Header_Id IN NUMBER,
547 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
548 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
549 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
550
551 PROCEDURE Allocate_Sales_Credits_POST(
552 p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE,
553 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
554 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
555 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
556 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
557
558 End ASO_QUOTE_VUHK;