1 PACKAGE IBE_Quote_Save_pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVQCUS.pls 120.7.12000000.1 2007/01/17 10:53:39 appldev ship $ */
3 -- Start of Comments
4 -- Package name : IBE_Quote_Save_pvt
5 -- Purpose :
6 -- NOTE :
7
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH CONSTANT NUMBER := 30;
12
13 -- line codes to distinguish line level operations
14 STANDARD_LINE_CODE CONSTANT NUMBER := 0;
15 SERVICEABLE_LINE_CODE CONSTANT NUMBER := 1;
16 SERVICE_LINE_CODE CONSTANT NUMBER := 2;
17 MODEL_UI_LINE_CODE CONSTANT NUMBER := 3;
18 MODEL_BUNDLE_LINE_CODE CONSTANT NUMBER := 4;
19
20
21 -- save types to give context to the overall operation
22 -- used for api routing and validations
23 SAVE_NORMAL CONSTANT NUMBER := 0;
24 SAVE_ADDTOCART CONSTANT NUMBER := 1;
25 SAVE_EXPRESSORDER CONSTANT NUMBER := 2;
26 SALES_ASSISTANCE CONSTANT NUMBER := 5;
27 UPDATE_EXPRESSORDER CONSTANT NUMBER := 7;
28 OP_DELETE_CART CONSTANT NUMBER := 8;
29 OP_DUPLICATE_CART CONSTANT NUMBER := 9;
30
31
32 PROCEDURE Delete(
33 p_api_version_number IN NUMBER := 1 ,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
36 x_return_status OUT NOCOPY VARCHAR2 ,
37 x_msg_count OUT NOCOPY NUMBER ,
38 x_msg_data OUT NOCOPY VARCHAR2 ,
39 p_quote_header_id IN NUMBER ,
40 p_expunge_flag IN VARCHAR2 :=FND_API.G_TRUE ,
41 p_minisite_id IN NUMBER :=FND_API.G_MISS_NUM ,
42 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
43 p_Quote_access_tbl IN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE
44 := IBE_QUOTE_SAVESHARE_pvt.G_miss_quote_access_Tbl ,
45 p_notes IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 -- in even that we are deleting a shared cart
47 -- could be owner or admin recipient
48 p_initiator_party_id IN NUMBER :=FND_API.G_MISS_NUM ,
49 p_initiator_account_id IN NUMBER :=FND_API.G_MISS_NUM
50 );
51
52
53 PROCEDURE DeleteAllLines(
54 p_api_version_number IN NUMBER := 1 ,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
57 x_return_status OUT NOCOPY VARCHAR2 ,
58 x_msg_count OUT NOCOPY NUMBER ,
59 x_msg_data OUT NOCOPY VARCHAR2 ,
60 p_quote_header_id IN NUMBER ,
61 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
62 p_sharee_number IN NUMBER := FND_API.G_MISS_NUM ,
63 x_quote_header_id OUT NOCOPY NUMBER ,
64 x_last_update_date OUT NOCOPY DATE
65 );
66
67
68 procedure Get_quote_expiration_date(
69 p_api_version IN NUMBER := 1.0 ,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
72 x_return_status OUT NOCOPY VARCHAR2 ,
73 x_msg_count OUT NOCOPY NUMBER ,
74 x_msg_data OUT NOCOPY VARCHAR2 ,
75 p_quote_header_rec IN aso_quote_pub.qte_header_rec_type ,
76 X_expiration_date OUT NOCOPY DATE);
77
78 PROCEDURE request_for_sales_assistance (
79 P_Api_Version IN NUMBER ,
80 p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,
81 p_Commit IN VARCHAR2:= FND_API.G_FALSE ,
82 x_return_status OUT NOCOPY VARCHAR2 ,
83 x_msg_count OUT NOCOPY NUMBER ,
84 x_msg_data OUT NOCOPY VARCHAR2 ,
85 x_last_update_date OUT NOCOPY Date ,
86 p_minisite_id IN NUMBER ,
87 p_last_update_date IN Date ,
88 p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
89 p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
90 p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
91 p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
92 P_quote_name IN varchar2 ,
93 P_Reason_code IN varchar2 ,
94 p_url IN varchar2 := FND_API.G_MISS_CHAR,
95 P_COMMENTS IN varchar2,
96 p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
97 p_contract_context IN VARCHAR2 :='N',
98 p_notes IN VARCHAR2 := NULL) ;
99
100
101 -- API NAME: SAVE
102 -- IN PARAMETERS (non-standard)
103 -- OUT PARAMETERS (non-standard)
104 -- x_new_quote_Header_id
105 PROCEDURE SAVE(
106 P_Api_Version_Number IN NUMBER
107 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
108 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
109 ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
110 ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
111
112 ,p_sharee_Number in Number := FND_API.G_MISS_NUM
113 ,p_sharee_party_id in Number := FND_API.G_MISS_NUM
114 ,p_sharee_cust_account_id in Number := FND_API.G_MISS_NUM
115 ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
116 ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
117
118
119 ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
120 := ASO_QUOTE_PUB.G_Miss_Control_Rec
121 ,p_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
122 := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec
123 ,p_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
124 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl
125 ,p_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
126 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
127 ,p_hd_Shipment_TBL IN ASO_QUOTE_PUB.Shipment_tbl_Type
128 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL
129 ,p_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
130 := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl
131 ,p_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
132 := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
133 ,p_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
134 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL
135 ,p_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
136 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL
137 ,p_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
138 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL
139 ,p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
140 := ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl
141 ,p_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
142 := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl
143 ,p_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
144 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl
145 ,p_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
146 := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl
147 ,p_Ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
148 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl
149 ,p_Ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
150 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
151 ,p_Ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
152 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL
153 ,p_Ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
154 := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl
155 ,p_Ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
156 := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
157 ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
158 ,x_quote_header_id OUT NOCOPY varchar2
159 ,x_last_update_date OUT NOCOPY DATE
160 ,X_Return_Status OUT NOCOPY VARCHAR2
161 ,X_Msg_Count OUT NOCOPY NUMBER
162 ,X_Msg_Data OUT NOCOPY VARCHAR2
163 );
164
165 PROCEDURE Save(
166 P_Api_Version_Number IN NUMBER
167 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
168 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
169 ,p_auto_update_active_quote IN VARCHAR2 := FND_API.G_TRUE
170 ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
171
172 ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
173 ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
174 ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
175 ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
176 ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
177
178 ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
179 := ASO_Quote_Pub.G_Miss_Control_Rec
180 ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
181 := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
182 ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
183 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl
184 ,p_hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type
185 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL
186 ,p_hd_Shipment_TBL IN ASO_Quote_Pub.Shipment_tbl_Type
187 := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL
188 ,p_hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
189 := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
190 ,p_hd_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
191 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
192 ,p_Qte_Line_Tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type
193 := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL
194 ,p_Qte_Line_Dtl_Tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
195 := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL
196 ,p_Line_Attr_Ext_Tbl IN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
197 := ASO_Quote_Pub.G_MISS_Line_Attribs_Ext_TBL
198 ,p_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type
199 := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl
200 ,p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type
201 := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl
202 ,p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
203 := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl
204 ,p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
205 := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl
206 ,p_Ln_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
207 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl
208 ,p_Ln_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type
209 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL
210 ,p_Ln_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type
211 := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL
212 ,p_Ln_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
213 := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
214 ,p_Ln_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
215 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
216 ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
217 ,x_quote_header_id OUT NOCOPY varchar2
218 ,x_last_update_date OUT NOCOPY DATE
219
220 ,x_Qte_Header_Rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
221 ,x_Hd_Price_Attributes_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
222 ,x_Hd_Payment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Payment_Tbl_Type
223 ,x_Hd_Shipment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
224 ,x_Hd_Shipment_Rec IN OUT NOCOPY ASO_Quote_Pub.Shipment_Rec_Type
225 ,x_Hd_Freight_Charge_Tbl IN OUT NOCOPY ASO_Quote_Pub.Freight_Charge_Tbl_Type
226 ,x_Hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE
227 ,x_Qte_Line_Tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type
228 ,x_Qte_Line_Dtl_Tbl IN OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
229 ,x_Line_Attr_Ext_Tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
230 ,x_Line_rltship_tbl IN OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type
231 ,x_Ln_Price_Attributes_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
232 ,x_Ln_Payment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Payment_Tbl_Type
233 ,x_Ln_Shipment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Shipment_Tbl_Type
234 ,x_Ln_Freight_Charge_Tbl IN OUT NOCOPY ASO_Quote_Pub.Freight_Charge_Tbl_Type
235 ,x_Ln_Tax_Detail_Tbl IN OUT NOCOPY ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE
236 ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
237 ,x_Price_Adj_Attr_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
238 ,x_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
239
240 ,X_Return_Status OUT NOCOPY VARCHAR2
241 ,X_Msg_Count OUT NOCOPY NUMBER
242 ,X_Msg_Data OUT NOCOPY VARCHAR2
243 );
244
245 PROCEDURE UpdateQuoteForSharee(
246 p_api_version_number IN NUMBER
247 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
248 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
249
250 ,p_sharee_Party_Id IN NUMBER
251 ,p_sharee_Cust_account_Id IN NUMBER
252 ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
253
254 ,P_Control_Rec in ASO_QUOTE_PUB.Control_Rec_Type
255
256 ,P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
257 := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec
258 ,p_Hd_Price_Attributes_Tbl in ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
259 := ASO_QUOTE_PUB.G_MISS_Price_Attributes_Tbl
260 ,p_Hd_Payment_Tbl in ASO_QUOTE_PUB.Payment_Tbl_Type
261 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
262 ,p_Hd_Shipment_Tbl in ASO_QUOTE_PUB.Shipment_Tbl_Type
263 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_Tbl
264 ,p_Hd_Tax_Detail_Tbl in ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE
265 := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl
266 ,p_Hd_Freight_Charge_Tbl in ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
267 := ASO_QUOTE_PUB.G_MISS_Freight_Charge_Tbl
268
269 ,p_qte_line_tbl in ASO_QUOTE_PUB.Qte_Line_Tbl_Type
270 := aso_quote_pub.G_MISS_QTE_LINE_TBL
271 ,p_Qte_Line_Dtl_Tbl in ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
272 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL
273 ,p_Line_rltship_tbl in ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
274 := ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl
275 ,p_Line_Attr_Ext_Tbl in ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
276 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_Tbl
277 ,p_Ln_Price_Attributes_Tbl in ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
278 := ASO_QUOTE_PUB.G_MISS_Price_Attributes_Tbl
279 ,p_Ln_Payment_Tbl in ASO_QUOTE_PUB.Payment_Tbl_Type
280 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
281 ,p_Ln_Shipment_Tbl in ASO_QUOTE_PUB.Shipment_Tbl_Type
282 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL
283 ,p_Ln_Tax_Detail_Tbl in ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE
284 := ASO_QUOTE_PUB.G_MISS_Tax_Detail_Tbl
285 ,p_Ln_Freight_Charge_Tbl in ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
286 := ASO_QUOTE_PUB.G_MISS_Freight_Charge_Tbl
287 ,p_Price_Adj_Attr_Tbl in ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
288 := ASO_QUOTE_PUB.G_MISS_PRICE_ADJ_ATTR_Tbl
289 ,p_Price_Adjustment_Tbl in ASO_QUOTE_PUB.Price_Adj_Tbl_Type
290 := ASO_QUOTE_PUB.G_MISS_Price_Adj_Tbl
291 ,p_Price_Adj_Rltship_Tbl in ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
292 := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_Tbl
293
294 ,x_qte_header_rec OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type
295 ,x_qte_line_tbl OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Tbl_Type
296 ,X_Return_Status OUT NOCOPY VARCHAR2
297 ,X_Msg_Count OUT NOCOPY NUMBER
298 ,X_Msg_Data OUT NOCOPY VARCHAR2
299 );
300 -- formerly AddItemsToCart; the original addItemsToCart
301 -- this is the one that handles adding of std, services, cartlevel services
302 PROCEDURE AddItemsToCart_orig(
303 P_Api_Version_Number IN NUMBER
304 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
305 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
306 ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
307 ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
308 ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
309 ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
310 ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
311 ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
312 ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
313 := ASO_Quote_Pub.G_Miss_Control_Rec
314 ,p_ql_line_codes IN jtf_number_table := NULL
315 ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
316 := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
317
318 ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
319 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl
320 ,p_hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type
321 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL
322 ,p_hd_Shipment_TBL IN ASO_Quote_Pub.Shipment_tbl_Type
323 := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL
324 ,p_hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
325 := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
326 ,p_hd_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
327 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
328 ,p_Qte_Line_Tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type
329 := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL
330 ,p_Qte_Line_Dtl_Tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
331 := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL
332 ,p_Line_Attr_Ext_Tbl IN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
333 := ASO_Quote_Pub.G_MISS_Line_Attribs_Ext_TBL
334 ,p_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type
335 := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl
336 ,p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type
337 := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl
338 ,p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
339 := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl
340 ,p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
341 := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl
342 ,p_Ln_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
343 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl
344 ,p_Ln_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type
345 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL
346 ,p_Ln_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type
347 := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL
348 ,p_Ln_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
349 := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
350 ,p_Ln_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
351 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
352 ,P_save_flag IN NUMBER := SAVE_ADDTOCART
353 ,x_quote_header_id OUT NOCOPY varchar2
354 ,x_Qte_Line_Tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type
355 ,x_last_update_date OUT NOCOPY DATE
356 ,X_Return_Status OUT NOCOPY VARCHAR2
357 ,X_Msg_Count OUT NOCOPY NUMBER
358 ,X_Msg_Data OUT NOCOPY VARCHAR2
359 );
360 -- formerly AddModelsToCart
361 -- same signature, but expanded to match the original addItemsToCart
362 -- this should be the main entry point for all item types as it internally calls addItemsToCart_orig
363 PROCEDURE AddItemsToCart(
364 P_Api_Version_Number IN NUMBER
365 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
366 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
367 ,p_Bundle_Flag IN VARCHAR2 := FND_API.G_FALSE
368 ,p_combineSameItem IN VARCHAR2 := FND_API.G_MISS_CHAR
369 ,p_sharee_Number IN Number := FND_API.G_MISS_NUM
370 ,p_sharee_party_id IN Number := FND_API.G_MISS_NUM
371 ,p_sharee_cust_account_id IN Number := FND_API.G_MISS_NUM
372 ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
373 ,p_changeowner IN VARCHAR2 := FND_API.G_FALSE
374 ,p_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
375 := ASO_Quote_Pub.G_Miss_Control_Rec
376 ,p_ql_line_codes IN jtf_number_table := NULL
377 ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
378 := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
379 ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
380 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl
381 ,p_hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type
382 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL
383 ,p_hd_Shipment_TBL IN ASO_Quote_Pub.Shipment_tbl_Type
384 := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL
385 ,p_hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
386 := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
387 ,p_hd_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
388 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
389 ,p_Qte_Line_Tbl IN ASO_Quote_Pub.Qte_Line_Tbl_Type
390 := ASO_Quote_Pub.G_MISS_QTE_LINE_TBL
391 ,p_Qte_Line_Dtl_Tbl IN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
392 := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL
393 ,p_Line_Attr_Ext_Tbl IN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
394 := ASO_Quote_Pub.G_MISS_Line_Attribs_Ext_TBL
395 ,p_line_rltship_tbl IN ASO_Quote_Pub.Line_Rltship_Tbl_Type
396 := ASO_Quote_Pub.G_MISS_Line_Rltship_Tbl
397 ,p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type
398 := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl
399 ,p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
400 := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl
401 ,p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
402 := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl
403 ,p_Ln_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
404 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl
405 ,p_Ln_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type
406 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL
407 ,p_Ln_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type
408 := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL
409 ,p_Ln_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
410 := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
411 ,p_Ln_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
412 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
413 ,P_save_flag IN NUMBER := SAVE_ADDTOCART
414 ,x_quote_header_id OUT NOCOPY varchar2
415 ,x_Qte_Line_Tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type
416 ,x_last_update_date OUT NOCOPY DATE
417 ,X_Return_Status OUT NOCOPY VARCHAR2
418 ,X_Msg_Count OUT NOCOPY NUMBER
419 ,X_Msg_Data OUT NOCOPY VARCHAR2
420 );
421
422 PROCEDURE getHdrDefaultValues(
423 P_Api_Version_Number IN NUMBER
424 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
425 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
426
427 ,p_minisite_id IN NUMBER
428
429 ,p_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
430 := ASO_Quote_Pub.G_MISS_Qte_Header_Rec
431 ,p_hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type
432 := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl
433 ,p_hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type
434 := ASO_Quote_Pub.G_MISS_PAYMENT_TBL
435 ,p_hd_Shipment_TBL IN ASO_Quote_Pub.Shipment_tbl_Type
436 := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL
437 ,p_hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type
438 := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl
439 ,p_hd_Tax_Detail_Tbl IN ASO_Quote_Pub.Tax_Detail_Tbl_Type
440 := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl
441 ,p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type
442 := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl
443 ,p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
444 := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl
445 ,p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
446 := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl
447
448 ,x_Qte_Header_Rec OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
449 ,x_hd_Price_Attributes_Tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
450 ,x_hd_Payment_Tbl OUT NOCOPY ASO_Quote_Pub.Payment_Tbl_Type
451 ,x_hd_Shipment_TBL OUT NOCOPY ASO_Quote_Pub.Shipment_tbl_Type
452 ,x_hd_Freight_Charge_Tbl OUT NOCOPY ASO_Quote_Pub.Freight_Charge_Tbl_Type
453 ,x_hd_Tax_Detail_Tbl OUT NOCOPY ASO_Quote_Pub.Tax_Detail_Tbl_Type
454 ,x_Price_Adjustment_Tbl OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
455 ,x_Price_Adj_Attr_Tbl OUT NOCOPY ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
456 ,x_Price_Adj_Rltship_Tbl OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
457
458 ,x_last_update_date OUT NOCOPY DATE
459 ,X_Return_Status OUT NOCOPY VARCHAR2
460 ,X_Msg_Count OUT NOCOPY NUMBER
461 ,X_Msg_Data OUT NOCOPY VARCHAR2
462 );
463
464 PROCEDURE getHdrDefaultAddress(
465 P_Api_Version_Number IN NUMBER
466 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
467 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
468 ,px_hd_Shipment_TBL IN OUT NOCOPY ASO_Quote_Pub.Shipment_tbl_Type
469 ,px_qte_header_rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
470 ,p_party_site_use IN varchar2
471 ,X_Return_Status OUT NOCOPY VARCHAR2
472 ,X_Msg_Count OUT NOCOPY NUMBER
473 ,X_Msg_Data OUT NOCOPY VARCHAR2
474 );
475
476 PROCEDURE getHdrDefaultShipMethod(
477 P_Api_Version_Number IN NUMBER
478 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
479 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
480 ,px_hd_Shipment_TBL IN OUT NOCOPY ASO_Quote_Pub.Shipment_tbl_Type
481 ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
482 ,p_minisite_id IN Number
483 ,X_Return_Status OUT NOCOPY VARCHAR2
484 ,X_Msg_Count OUT NOCOPY NUMBER
485 ,X_Msg_Data OUT NOCOPY VARCHAR2
486 );
487
488 PROCEDURE getHdrDefaultPaymentMethod(
489 P_Api_Version_Number IN NUMBER
490 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
491 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
492 ,px_hd_Payment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Payment_Tbl_Type
493 ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
494 ,p_minisite_id IN Number
495 ,X_Return_Status OUT NOCOPY VARCHAR2
496 ,X_Msg_Count OUT NOCOPY NUMBER
497 ,X_Msg_Data OUT NOCOPY VARCHAR2
498 );
499
500 PROCEDURE getHdrDefaultTaxExemption(
501 P_Api_Version_Number IN NUMBER
502 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
503 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
504 ,px_hd_Tax_Detail_Tbl IN OUT NOCOPY ASO_Quote_Pub.Tax_Detail_Tbl_Type
505 ,p_qte_header_rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
506 ,X_Return_Status OUT NOCOPY VARCHAR2
507 ,X_Msg_Count OUT NOCOPY NUMBER
508 ,X_Msg_Data OUT NOCOPY VARCHAR2
509 );
510
511 PROCEDURE getHdrDefaultEndCustomer(
512 P_Api_Version_Number IN NUMBER
513 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
514 ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
515 ,p_hd_Shipment_TBL IN ASO_Quote_Pub.Shipment_tbl_Type
516 ,px_qte_header_rec IN OUT NOCOPY ASO_Quote_Pub.Qte_Header_Rec_Type
517 ,X_Return_Status OUT NOCOPY VARCHAR2
518 ,X_Msg_Count OUT NOCOPY NUMBER
519 ,X_Msg_Data OUT NOCOPY VARCHAR2
520 );
521
522 PROCEDURE Create_Contract_For_Quote(
523 P_Api_Version_Number IN NUMBER := OKC_API.G_MISS_NUM
524 ,p_Init_Msg_List IN VARCHAR2 := OKC_API.G_FALSE
525 ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
526 ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR
527 ,p_terms_agreed_flag IN VARCHAR2 := OKC_API.G_FALSE
528 ,p_trace_mode IN VARCHAR2 := OKC_API.G_FALSE
529 ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
530 ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
531 ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
532 ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
533 ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
534 ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
535 ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
536 ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
537 ,x_return_status OUT NOCOPY VARCHAR2
538 ,x_msg_count OUT NOCOPY NUMBER
539 ,x_msg_data OUT NOCOPY VARCHAR2
540 );
541
542 --Added for 11.5.11, Duplicate Cart feature - MaithiliK
543 PROCEDURE DUPLICATE_CART (
544 P_Api_Version IN NUMBER ,
545 p_Init_Msg_List IN VARCHAR2:= FND_API.G_FALSE ,
546 p_Commit IN VARCHAR2:= FND_API.G_FALSE ,
547 x_return_status OUT NOCOPY VARCHAR2 ,
548 x_msg_count OUT NOCOPY NUMBER ,
549 x_msg_data OUT NOCOPY VARCHAR2 ,
550 x_last_update_date OUT NOCOPY Date ,
551 x_quote_header_id OUT NOCOPY NUMBER ,
552 p_last_update_date IN Date ,
553 p_quote_header_id IN NUMBER:= FND_API.G_MISS_NUM,
554 p_party_id IN NUMBER:= FND_API.G_MISS_NUM,
555 p_cust_account_id IN NUMBER:= FND_API.G_MISS_NUM,
556 p_validate_user IN VARCHAR2:= FND_API.G_FALSE ,
557 P_new_quote_name IN VARCHAR2 ,
558 p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
559 p_minisite_id IN NUMBER);
560
561 TYPE ConfigCurTyp IS REF CURSOR;
562 -- API NAME: RECONFIGURE_FROM_IB
563 PROCEDURE RECONFIGURE_FROM_IB(
564 p_api_version_number IN NUMBER := 1
565 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
566 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
567 ,p_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
568 := ASO_QUOTE_PUB.G_Miss_Control_Rec
569 ,p_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
570 := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec
571 ,p_instance_ids IN jtf_number_table := NULL
572 ,x_config_line OUT NOCOPY ConfigCurTyp
573 ,x_last_update_date OUT NOCOPY DATE
574 ,x_return_status OUT NOCOPY VARCHAR2
575 ,x_msg_count OUT NOCOPY NUMBER
576 ,x_msg_data OUT NOCOPY VARCHAR2
577 );
578
579 PROCEDURE UPDATE_SUPPORT_AND_QUANTITY(
580 p_api_version IN NUMBER,
581 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
582 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583 x_return_status OUT NOCOPY VARCHAR2,
584 x_msg_count OUT NOCOPY NUMBER,
585 x_msg_data OUT NOCOPY VARCHAR2,
586
587 p_quote_header_id IN NUMBER,
588 p_quote_line_id_tbl IN JTF_NUMBER_TABLE := NULL,
589 p_line_quantity_tbl IN JTF_NUMBER_TABLE := NULL,
590 p_new_service_id_tbl IN JTF_NUMBER_TABLE := NULL,
591 p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
592
593 p_party_id IN NUMBER := FND_API.G_MISS_NUM,
594 p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
595 p_sharee_number IN NUMBER := FND_API.G_MISS_NUM,
596
597 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
598 p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
599 p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
600 p_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
601 p_save_type IN NUMBER := FND_API.G_MISS_NUM,
602 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
603 x_last_update_date IN OUT NOCOPY DATE
604 );
605
606
607 END IBE_Quote_Save_pvt;