[Home] [Help]
PACKAGE BODY: APPS.IBE_SHOP_LIST_WRAPPER_PVT
Source
1 PACKAGE BODY IBE_Shop_List_Wrapper_PVT AS
2 /* $Header: IBEVQLWB.pls 120.2 2010/11/30 10:06:08 scnagara ship $ */
3
4 ROSETTA_G_MISTAKE_DATE DATE := TO_DATE('01/01/+4713', 'MM/DD/SYYYY');
5 ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724;
6
7
8 FUNCTION Construct_Control_Rec(
9 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
10 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
11 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
12 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
13 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
14 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
15 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
16 p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' -- change line logic pricing
17 ) RETURN ASO_QUOTE_PUB.Control_Rec_Type
18 IS
19 control_rec ASO_QUOTE_PUB.Control_Rec_Type;
20 BEGIN
21 IF p_c_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
22 control_rec.last_update_date := FND_API.G_MISS_DATE;
23 ELSE
24 control_rec.last_update_date := p_c_last_update_date;
25 END IF;
26 control_rec.auto_version_flag := p_c_auto_version_flag;
27 control_rec.pricing_request_type := p_c_pricing_request_type;
28 control_rec.header_pricing_event := p_c_header_pricing_event;
29 control_rec.line_pricing_event := p_c_line_pricing_event;
30 control_rec.calculate_tax_flag := p_c_cal_tax_flag;
31 control_rec.calculate_freight_charge_flag := p_c_cal_freight_charge_flag;
32 control_rec.price_mode := p_c_price_mode; -- change line logic pricing
33 RETURN control_rec;
34 END Construct_Control_Rec;
35
36
37 FUNCTION Construct_Quote_Header_Rec(
38 p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
39 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
40 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
41 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
42 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
43 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
44 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
45 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
46 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
47 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
48 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
49 p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
51 p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
52 p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
53 p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
55 p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
56 p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
59 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
60 p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
61 p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
66 p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
67 p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
68 p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
69 p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
71 p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
73 p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
74 p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
75 p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
76 p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
77 p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
78 p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
79 p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
80 p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
81 p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
82 p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
83 p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
84 p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
88 p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
107 p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
108 p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
109 p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
121 p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
123 p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
127 p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
128 p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
131 p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
132 p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
133 p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
134 p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
136 p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM
137 ) RETURN ASO_QUOTE_PUB.Qte_Header_Rec_Type
138 IS
139 q_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
140 BEGIN
141 IF p_h_quote_header_id = ROSETTA_G_MISS_NUM THEN
142 q_header_rec.quote_header_id := FND_API.G_MISS_NUM;
143 ELSE
144 q_header_rec.quote_header_id := p_h_quote_header_id;
145 END IF;
146 IF p_h_creation_date = ROSETTA_G_MISTAKE_DATE THEN
147 q_header_rec.creation_date := FND_API.G_MISS_DATE;
148 ELSE
149 q_header_rec.creation_date := p_h_creation_date;
150 END IF;
151 IF p_h_created_by = ROSETTA_G_MISS_NUM THEN
152 q_header_rec.created_by := FND_API.G_MISS_NUM;
153 ELSE
154 q_header_rec.created_by := p_h_created_by;
155 END IF;
156 IF p_h_last_updated_by = ROSETTA_G_MISS_NUM THEN
157 q_header_rec.last_updated_by := FND_API.G_MISS_NUM;
158 ELSE
159 q_header_rec.last_updated_by := p_h_last_updated_by;
160 END IF;
161 IF p_h_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
162 q_header_rec.last_update_date := FND_API.G_MISS_DATE;
163 ELSE
164 q_header_rec.last_update_date := p_h_last_update_date;
165 END IF;
166 IF p_h_last_update_login = ROSETTA_G_MISS_NUM THEN
167 q_header_rec.last_update_login := FND_API.G_MISS_NUM;
168 ELSE
169 q_header_rec.last_update_login := p_h_last_update_login;
170 END IF;
171 IF p_h_request_id = ROSETTA_G_MISS_NUM THEN
172 q_header_rec.request_id := FND_API.G_MISS_NUM;
173 ELSE
174 q_header_rec.request_id := p_h_request_id;
175 END IF;
176 IF p_h_program_application_id = ROSETTA_G_MISS_NUM THEN
177 q_header_rec.program_application_id := FND_API.G_MISS_NUM;
178 ELSE
179 q_header_rec.program_application_id := p_h_program_application_id;
180 END IF;
181 IF p_h_program_id = ROSETTA_G_MISS_NUM THEN
182 q_header_rec.program_id := FND_API.G_MISS_NUM;
183 ELSE
184 q_header_rec.program_id := p_h_program_id;
185 END IF;
186 IF p_h_program_update_date = ROSETTA_G_MISTAKE_DATE THEN
187 q_header_rec.program_update_date := FND_API.G_MISS_DATE;
188 ELSE
189 q_header_rec.program_update_date := p_h_program_update_date;
190 END IF;
191 IF p_h_org_id = ROSETTA_G_MISS_NUM THEN
192 q_header_rec.org_id := FND_API.G_MISS_NUM;
193 ELSE
194 q_header_rec.org_id := p_h_org_id;
195 END IF;
196 q_header_rec.quote_name := p_h_quote_name;
197 IF p_h_quote_number = ROSETTA_G_MISS_NUM THEN
198 q_header_rec.quote_number := FND_API.G_MISS_NUM;
199 ELSE
200 q_header_rec.quote_number := p_h_quote_number;
201 END IF;
202 IF p_h_quote_version = ROSETTA_G_MISS_NUM THEN
203 q_header_rec.quote_version := FND_API.G_MISS_NUM;
204 ELSE
205 q_header_rec.quote_version := p_h_quote_version;
206 END IF;
207 IF p_h_quote_status_id = ROSETTA_G_MISS_NUM THEN
208 q_header_rec.quote_status_id := FND_API.G_MISS_NUM;
209 ELSE
210 q_header_rec.quote_status_id := p_h_quote_status_id;
211 END IF;
212 q_header_rec.quote_source_code := p_h_quote_source_code;
213 IF p_h_quote_expiration_date = ROSETTA_G_MISTAKE_DATE THEN
214 q_header_rec.quote_expiration_date := FND_API.G_MISS_DATE;
215 ELSE
216 q_header_rec.quote_expiration_date := p_h_quote_expiration_date;
217 END IF;
221 q_header_rec.price_frozen_date := p_h_price_frozen_date;
218 IF p_h_price_frozen_date = ROSETTA_G_MISTAKE_DATE THEN
219 q_header_rec.price_frozen_date := FND_API.G_MISS_DATE;
220 ELSE
222 END IF;
223 q_header_rec.quote_password := p_h_quote_password;
224 q_header_rec.original_system_reference := p_h_original_system_reference;
225 IF p_h_party_id = ROSETTA_G_MISS_NUM THEN
226 q_header_rec.party_id := FND_API.G_MISS_NUM;
227 ELSE
228 q_header_rec.party_id := p_h_party_id;
229 END IF;
230 IF p_h_cust_account_id = ROSETTA_G_MISS_NUM THEN
231 q_header_rec.cust_account_id := FND_API.G_MISS_NUM;
232 ELSE
233 q_header_rec.cust_account_id := p_h_cust_account_id;
234 END IF;
235 IF p_h_org_contact_id = ROSETTA_G_MISS_NUM THEN
236 q_header_rec.org_contact_id := FND_API.G_MISS_NUM;
237 ELSE
238 q_header_rec.org_contact_id := p_h_org_contact_id;
239 END IF;
240 q_header_rec.party_name := p_h_party_name;
241 q_header_rec.party_type := p_h_party_type;
242 q_header_rec.person_first_name := p_h_person_first_name;
243 q_header_rec.person_last_name := p_h_person_last_name;
244 q_header_rec.person_middle_name := p_h_person_middle_name;
245 IF p_h_phone_id = ROSETTA_G_MISS_NUM THEN
246 q_header_rec.phone_id := FND_API.G_MISS_NUM;
247 ELSE
248 q_header_rec.phone_id := p_h_phone_id;
249 END IF;
250 IF p_h_price_list_id = ROSETTA_G_MISS_NUM THEN
251 q_header_rec.price_list_id := FND_API.G_MISS_NUM;
252 ELSE
253 q_header_rec.price_list_id := p_h_price_list_id;
257 q_header_rec.tax_status_indicator := p_h_tax_status_indicator;
254 END IF;
255
256 q_header_rec.pricing_status_indicator := p_h_pricing_status_indicator; -- change line logic pricing
258
259 q_header_rec.price_list_name := p_h_price_list_name;
260 q_header_rec.currency_code := p_h_currency_code;
261 IF p_h_total_list_price = ROSETTA_G_MISS_NUM THEN
262 q_header_rec.total_list_price := FND_API.G_MISS_NUM;
263 ELSE
264 q_header_rec.total_list_price := p_h_total_list_price;
265 END IF;
266 IF p_h_total_adjusted_amount = ROSETTA_G_MISS_NUM THEN
267 q_header_rec.total_adjusted_amount := FND_API.G_MISS_NUM;
268 ELSE
269 q_header_rec.total_adjusted_amount := p_h_total_adjusted_amount;
270 END IF;
271 IF p_h_total_adjusted_percent = ROSETTA_G_MISS_NUM THEN
272 q_header_rec.total_adjusted_percent := FND_API.G_MISS_NUM;
273 ELSE
274 q_header_rec.total_adjusted_percent := p_h_total_adjusted_percent;
275 END IF;
276 IF p_h_total_tax = ROSETTA_G_MISS_NUM THEN
277 q_header_rec.total_tax := FND_API.G_MISS_NUM;
278 ELSE
279 q_header_rec.total_tax := p_h_total_tax;
280 END IF;
281 IF p_h_total_shipping_charge = ROSETTA_G_MISS_NUM THEN
282 q_header_rec.total_shipping_charge := FND_API.G_MISS_NUM;
283 ELSE
284 q_header_rec.total_shipping_charge := p_h_total_shipping_charge;
285 END IF;
286 IF p_h_surcharge = ROSETTA_G_MISS_NUM THEN
287 q_header_rec.surcharge := FND_API.G_MISS_NUM;
288 ELSE
289 q_header_rec.surcharge := p_h_surcharge;
290 END IF;
291 IF p_h_total_quote_price = ROSETTA_G_MISS_NUM THEN
292 q_header_rec.total_quote_price := FND_API.G_MISS_NUM;
293 ELSE
294 q_header_rec.total_quote_price := p_h_total_quote_price;
295 END IF;
296 IF p_h_payment_amount = ROSETTA_G_MISS_NUM THEN
297 q_header_rec.payment_amount := FND_API.G_MISS_NUM;
298 ELSE
299 q_header_rec.payment_amount := p_h_payment_amount;
300 END IF;
301 IF p_h_accounting_rule_id = ROSETTA_G_MISS_NUM THEN
302 q_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
303 ELSE
304 q_header_rec.accounting_rule_id := p_h_accounting_rule_id;
305 END IF;
306 IF p_h_exchange_rate = ROSETTA_G_MISS_NUM THEN
307 q_header_rec.exchange_rate := FND_API.G_MISS_NUM;
308 ELSE
309 q_header_rec.exchange_rate := p_h_exchange_rate;
310 END IF;
314 ELSE
311 q_header_rec.exchange_type_code := p_h_exchange_type_code;
312 IF p_h_exchange_rate_date = ROSETTA_G_MISTAKE_DATE THEN
313 q_header_rec.exchange_rate_date := FND_API.G_MISS_DATE;
315 q_header_rec.exchange_rate_date := p_h_exchange_rate_date;
316 END IF;
317 q_header_rec.quote_category_code := p_h_quote_category_code;
318 q_header_rec.quote_status_code := p_h_quote_status_code;
319 q_header_rec.quote_status := p_h_quote_status;
320 IF p_h_employee_person_id = ROSETTA_G_MISS_NUM THEN
321 q_header_rec.employee_person_id := FND_API.G_MISS_NUM;
322 ELSE
323 q_header_rec.employee_person_id := p_h_employee_person_id;
324 END IF;
325 q_header_rec.sales_channel_code := p_h_sales_channel_code;
326 -- q_header_rec.salesrep_full_name := p_h_salesrep_full_name;
327 q_header_rec.attribute_category := p_h_attribute_category;
328 q_header_rec.attribute1 := p_h_attribute1;
329 q_header_rec.attribute10 := p_h_attribute10;
330 q_header_rec.attribute11 := p_h_attribute11;
331 q_header_rec.attribute12 := p_h_attribute12;
332 q_header_rec.attribute13 := p_h_attribute13;
333 q_header_rec.attribute14 := p_h_attribute14;
334 q_header_rec.attribute15 := p_h_attribute15;
335 q_header_rec.attribute2 := p_h_attribute2;
336 q_header_rec.attribute3 := p_h_attribute3;
337 q_header_rec.attribute4 := p_h_attribute4;
338 q_header_rec.attribute5 := p_h_attribute5;
339 q_header_rec.attribute6 := p_h_attribute6;
340 q_header_rec.attribute7 := p_h_attribute7;
341 q_header_rec.attribute8 := p_h_attribute8;
342 q_header_rec.attribute9 := p_h_attribute9;
343 IF p_h_contract_id = ROSETTA_G_MISS_NUM THEN
344 q_header_rec.contract_id := FND_API.G_MISS_NUM;
345 ELSE
346 q_header_rec.contract_id := p_h_contract_id;
347 END IF;
348 IF p_h_qte_contract_id = ROSETTA_G_MISS_NUM THEN
349 q_header_rec.qte_contract_id := FND_API.G_MISS_NUM;
350 ELSE
351 q_header_rec.qte_contract_id := p_h_qte_contract_id;
352 END IF;
353 IF p_h_ffm_request_id = ROSETTA_G_MISS_NUM THEN
354 q_header_rec.ffm_request_id := FND_API.G_MISS_NUM;
355 ELSE
356 q_header_rec.ffm_request_id := p_h_ffm_request_id;
357 END IF;
358 q_header_rec.invoice_to_address1 := p_h_invoice_to_address1;
359 q_header_rec.invoice_to_address2 := p_h_invoice_to_address2;
360 q_header_rec.invoice_to_address3 := p_h_invoice_to_address3;
361 q_header_rec.invoice_to_address4 := p_h_invoice_to_address4;
362 q_header_rec.invoice_to_city := p_h_invoice_to_city;
363 q_header_rec.invoice_to_contact_first_name := p_h_invoice_to_cont_first_name;
364 q_header_rec.invoice_to_contact_last_name := p_h_invoice_to_cont_last_name;
365 q_header_rec.invoice_to_contact_middle_name := p_h_invoice_to_cont_mid_name;
366 q_header_rec.invoice_to_country_code := p_h_invoice_to_country_code;
367 q_header_rec.invoice_to_country := p_h_invoice_to_country;
368 q_header_rec.invoice_to_county := p_h_invoice_to_county;
369 IF p_h_invoice_to_party_id = ROSETTA_G_MISS_NUM THEN
370 q_header_rec.invoice_to_party_id := FND_API.G_MISS_NUM;
371 ELSE
372 q_header_rec.invoice_to_party_id := p_h_invoice_to_party_id;
373 END IF;
374 q_header_rec.invoice_to_party_name := p_h_invoice_to_party_name;
375 IF p_h_invoice_to_party_site_id = ROSETTA_G_MISS_NUM THEN
376 q_header_rec.invoice_to_party_site_id := FND_API.G_MISS_NUM;
377 ELSE
378 q_header_rec.invoice_to_party_site_id := p_h_invoice_to_party_site_id;
379 END IF;
380 q_header_rec.invoice_to_postal_code := p_h_invoice_to_postal_code;
381 q_header_rec.invoice_to_province := p_h_invoice_to_province;
382 q_header_rec.invoice_to_state := p_h_invoice_to_state;
383 IF p_h_invoicing_rule_id = ROSETTA_G_MISS_NUM THEN
384 q_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
385 ELSE
386 q_header_rec.invoicing_rule_id := p_h_invoicing_rule_id;
387 END IF;
388 IF p_h_marketing_source_code_id = ROSETTA_G_MISS_NUM THEN
389 q_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
390 ELSE
391 q_header_rec.marketing_source_code_id := p_h_marketing_source_code_id;
392 END IF;
393 q_header_rec.marketing_source_code := p_h_marketing_source_code;
394 q_header_rec.marketing_source_name := p_h_marketing_source_name;
395 IF p_h_orig_mktg_source_code_id = ROSETTA_G_MISS_NUM THEN
396 q_header_rec.orig_mktg_source_code_id := FND_API.G_MISS_NUM;
397 ELSE
398 q_header_rec.orig_mktg_source_code_id := p_h_orig_mktg_source_code_id;
399 END IF;
400 IF p_h_order_type_id = ROSETTA_G_MISS_NUM THEN
401 q_header_rec.order_type_id := FND_API.G_MISS_NUM;
402 ELSE
403 q_header_rec.order_type_id := p_h_order_type_id;
404 END IF;
405 IF p_h_order_id = ROSETTA_G_MISS_NUM THEN
406 q_header_rec.order_id := FND_API.G_MISS_NUM;
407 ELSE
408 q_header_rec.order_id := p_h_order_id;
409 END IF;
410 IF p_h_order_number = ROSETTA_G_MISS_NUM THEN
411 q_header_rec.order_number := FND_API.G_MISS_NUM;
412 ELSE
413 q_header_rec.order_number := p_h_order_number;
414 END IF;
415 q_header_rec.order_type_name := p_h_order_type_name;
416 IF p_h_ordered_date = ROSETTA_G_MISTAKE_DATE THEN
417 q_header_rec.ordered_date := FND_API.G_MISS_DATE;
418 ELSE
419 q_header_rec.ordered_date := p_h_ordered_date;
420 END IF;
421 IF p_h_resource_id = ROSETTA_G_MISS_NUM THEN
422 q_header_rec.resource_id := FND_API.G_MISS_NUM;
423 ELSE
424 q_header_rec.resource_id := p_h_resource_id;
425 END IF;
426
427 RETURN q_header_rec;
428 END Construct_Quote_Header_Rec;
429
430 FUNCTION Construct_SL_Header_Rec(
431 p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
432 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
436 p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
433 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
434 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
435 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
437 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
438 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
439 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
440 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
441 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
442 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
443 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
444 p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
445 p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
446 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
447 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
448 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
449 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
450 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
451 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
452 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
453 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
454 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
455 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
456 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
457 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
458 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
459 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
460 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
461 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
462 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM
463 ) RETURN IBE_Shop_List_PVT.SL_Header_Rec_Type
464 IS
465 sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
466 BEGIN
467 IF p_h_shp_list_id = ROSETTA_G_MISS_NUM THEN
468 sl_header_rec.shp_list_id := FND_API.G_MISS_NUM;
469 ELSE
470 sl_header_rec.shp_list_id := p_h_shp_list_id;
471 END IF;
472 IF p_h_request_id = ROSETTA_G_MISS_NUM THEN
473 sl_header_rec.request_id := FND_API.G_MISS_NUM;
474 ELSE
475 sl_header_rec.request_id := p_h_request_id;
476 END IF;
477 IF p_h_program_application_id = ROSETTA_G_MISS_NUM THEN
478 sl_header_rec.program_application_id := FND_API.G_MISS_NUM;
479 ELSE
480 sl_header_rec.program_application_id := p_h_program_application_id;
481 END IF;
482 IF p_h_program_id = ROSETTA_G_MISS_NUM THEN
483 sl_header_rec.program_id := FND_API.G_MISS_NUM;
484 ELSE
485 sl_header_rec.program_id := p_h_program_id;
486 END IF;
487 IF p_h_program_update_date = ROSETTA_G_MISTAKE_DATE THEN
488 sl_header_rec.program_update_date := FND_API.G_MISS_DATE;
489 ELSE
490 sl_header_rec.program_update_date := p_h_program_update_date;
491 END IF;
492 IF p_h_object_version_number = ROSETTA_G_MISS_NUM THEN
493 sl_header_rec.object_version_number := FND_API.G_MISS_NUM;
494 ELSE
495 sl_header_rec.object_version_number := p_h_object_version_number;
496 END IF;
497 IF p_h_created_by = ROSETTA_G_MISS_NUM THEN
498 sl_header_rec.created_by := FND_API.G_MISS_NUM;
499 ELSE
500 sl_header_rec.created_by := p_h_created_by;
501 END IF;
502 IF p_h_creation_date = ROSETTA_G_MISTAKE_DATE THEN
503 sl_header_rec.creation_date := FND_API.G_MISS_DATE;
504 ELSE
505 sl_header_rec.creation_date := p_h_creation_date;
506 END IF;
507 IF p_h_last_updated_by = ROSETTA_G_MISS_NUM THEN
508 sl_header_rec.last_updated_by := FND_API.G_MISS_NUM;
509 ELSE
510 sl_header_rec.last_updated_by := p_h_last_updated_by;
511 END IF;
512 IF p_h_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
513 sl_header_rec.last_update_date := FND_API.G_MISS_DATE;
514 ELSE
515 sl_header_rec.last_update_date := p_h_last_update_date;
516 END IF;
517 IF p_h_last_update_login = ROSETTA_G_MISS_NUM THEN
518 sl_header_rec.last_update_login := FND_API.G_MISS_NUM;
519 ELSE
520 sl_header_rec.last_update_login := p_h_last_update_login;
521 END IF;
522 IF p_h_party_id = ROSETTA_G_MISS_NUM THEN
523 sl_header_rec.party_id := FND_API.G_MISS_NUM;
524 ELSE
525 sl_header_rec.party_id := p_h_party_id;
526 END IF;
527 IF p_h_cust_account_id = ROSETTA_G_MISS_NUM THEN
528 sl_header_rec.cust_account_id := FND_API.G_MISS_NUM;
529 ELSE
530 sl_header_rec.cust_account_id := p_h_cust_account_id;
531 END IF;
532 sl_header_rec.shopping_list_name := p_h_shopping_list_name;
533 sl_header_rec.description := p_h_description;
534 sl_header_rec.attribute_category := p_h_attribute_category;
538 sl_header_rec.attribute4 := p_h_attribute4;
535 sl_header_rec.attribute1 := p_h_attribute1;
536 sl_header_rec.attribute2 := p_h_attribute2;
537 sl_header_rec.attribute3 := p_h_attribute3;
539 sl_header_rec.attribute5 := p_h_attribute5;
540 sl_header_rec.attribute6 := p_h_attribute6;
541 sl_header_rec.attribute7 := p_h_attribute7;
542 sl_header_rec.attribute8 := p_h_attribute8;
543 sl_header_rec.attribute9 := p_h_attribute9;
544 sl_header_rec.attribute10 := p_h_attribute10;
545 sl_header_rec.attribute11 := p_h_attribute11;
546 sl_header_rec.attribute12 := p_h_attribute12;
547 sl_header_rec.attribute13 := p_h_attribute13;
548 sl_header_rec.attribute14 := p_h_attribute14;
549 sl_header_rec.attribute15 := p_h_attribute15;
550 IF p_h_org_id = ROSETTA_G_MISS_NUM THEN
551 sl_header_rec.org_id := FND_API.G_MISS_NUM;
552 ELSE
553 sl_header_rec.org_id := p_h_org_id;
554 END IF;
555
556 RETURN sl_header_rec;
557 END Construct_SL_Header_Rec;
558
559
560 FUNCTION Construct_SL_Line_Tbl(
561 p_l_shp_list_item_id IN jtf_number_table := NULL,
562 p_l_object_version_number IN jtf_number_table := NULL,
563 p_l_creation_date IN jtf_date_table := NULL,
564 p_l_created_by IN jtf_number_table := NULL,
565 p_l_last_updated_by IN jtf_number_table := NULL,
566 p_l_last_update_date IN jtf_date_table := NULL,
567 p_l_last_update_login IN jtf_number_table := NULL,
568 p_l_request_id IN jtf_number_table := NULL,
569 p_l_program_id IN jtf_number_table := NULL,
570 p_l_program_application_id IN jtf_number_table := NULL,
571 p_l_program_update_date IN jtf_date_table := NULL,
572 p_l_shp_list_id IN jtf_number_table := NULL,
573 p_l_inventory_item_id IN jtf_number_table := NULL,
574 p_l_organization_id IN jtf_number_table := NULL,
575 p_l_uom_code IN jtf_varchar2_table_100 := NULL,
576 p_l_quantity IN jtf_number_table := NULL,
577 p_l_config_header_id IN jtf_number_table := NULL,
578 p_l_config_revision_num IN jtf_number_table := NULL,
579 p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
580 p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
581 p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
582 p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
583 p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
584 p_l_attribute2 IN jtf_varchar2_table_200 := NULL,
585 p_l_attribute3 IN jtf_varchar2_table_200 := NULL,
586 p_l_attribute4 IN jtf_varchar2_table_200 := NULL,
587 p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588 p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589 p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590 p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591 p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592 p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593 p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594 p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595 p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
596 p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
597 p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
598 p_l_org_id IN jtf_number_table := NULL
599 ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
600 IS
601 sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
602 := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
603 l_table_size PLS_INTEGER;
604 i PLS_INTEGER;
605 BEGIN
606 IF p_l_shp_list_item_id IS NOT NULL AND p_l_shp_list_item_id.COUNT > 0 THEN
607 l_table_size := p_l_shp_list_item_id.COUNT;
608
609 FOR i IN 1..l_table_size LOOP
610 IF p_l_shp_list_item_id(i) = ROSETTA_G_MISS_NUM THEN
611 sl_line_tbl(i).shp_list_item_id := FND_API.G_MISS_NUM;
612 ELSE
613 sl_line_tbl(i).shp_list_item_id := p_l_shp_list_item_id(i);
614 END IF;
615 END LOOP;
616 FOR i IN 1..l_table_size LOOP
617 IF p_l_object_version_number(i) = ROSETTA_G_MISS_NUM THEN
618 sl_line_tbl(i).object_version_number := FND_API.G_MISS_NUM;
619 ELSE
620 sl_line_tbl(i).object_version_number := p_l_object_version_number(i);
621 END IF;
622 END LOOP;
623 FOR i IN 1..l_table_size LOOP
624 IF p_l_creation_date(i) = ROSETTA_G_MISTAKE_DATE THEN
625 sl_line_tbl(i).creation_date := FND_API.G_MISS_DATE;
626 ELSE
627 sl_line_tbl(i).creation_date := p_l_creation_date(i);
628 END IF;
629 END LOOP;
630 FOR i IN 1..l_table_size LOOP
631 IF p_l_created_by(i) = ROSETTA_G_MISS_NUM THEN
632 sl_line_tbl(i).created_by := FND_API.G_MISS_NUM;
633 ELSE
634 sl_line_tbl(i).created_by := p_l_created_by(i);
635 END IF;
636 END LOOP;
637 FOR i IN 1..l_table_size LOOP
638 IF p_l_last_updated_by(i) = ROSETTA_G_MISS_NUM THEN
639 sl_line_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
640 ELSE
641 sl_line_tbl(i).last_updated_by := p_l_last_updated_by(i);
642 END IF;
643 END LOOP;
644 FOR i IN 1..l_table_size LOOP
648 sl_line_tbl(i).last_update_date := p_l_last_update_date(i);
645 IF p_l_last_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
646 sl_line_tbl(i).last_update_date := FND_API.G_MISS_DATE;
647 ELSE
649 END IF;
650 END LOOP;
651 FOR i IN 1..l_table_size LOOP
652 IF p_l_last_update_login(i) = ROSETTA_G_MISS_NUM THEN
653 sl_line_tbl(i).last_update_login := FND_API.G_MISS_NUM;
654 ELSE
655 sl_line_tbl(i).last_update_login := p_l_last_update_login(i);
656 END IF;
657 END LOOP;
658 FOR i IN 1..l_table_size LOOP
659 IF p_l_request_id(i) = ROSETTA_G_MISS_NUM THEN
660 sl_line_tbl(i).request_id := FND_API.G_MISS_NUM;
661 ELSE
662 sl_line_tbl(i).request_id := p_l_request_id(i);
663 END IF;
664 END LOOP;
665 FOR i IN 1..l_table_size LOOP
666 IF p_l_program_id(i) = ROSETTA_G_MISS_NUM THEN
667 sl_line_tbl(i).program_id := FND_API.G_MISS_NUM;
668 ELSE
669 sl_line_tbl(i).program_id := p_l_program_id(i);
673 IF p_l_program_application_id(i) = ROSETTA_G_MISS_NUM THEN
670 END IF;
671 END LOOP;
672 FOR i IN 1..l_table_size LOOP
674 sl_line_tbl(i).program_application_id := FND_API.G_MISS_NUM;
675 ELSE
676 sl_line_tbl(i).program_application_id := p_l_program_application_id(i);
677 END IF;
678 END LOOP;
679 FOR i IN 1..l_table_size LOOP
680 IF p_l_program_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
681 sl_line_tbl(i).program_update_date := FND_API.G_MISS_DATE;
682 ELSE
683 sl_line_tbl(i).program_update_date := p_l_program_update_date(i);
684 END IF;
685 END LOOP;
686 FOR i IN 1..l_table_size LOOP
687 IF p_l_shp_list_id(i) = ROSETTA_G_MISS_NUM THEN
688 sl_line_tbl(i).shp_list_id := FND_API.G_MISS_NUM;
689 ELSE
690 sl_line_tbl(i).shp_list_id := p_l_shp_list_id(i);
691 END IF;
692 END LOOP;
693 FOR i IN 1..l_table_size LOOP
694 IF p_l_inventory_item_id(i) = ROSETTA_G_MISS_NUM THEN
695 sl_line_tbl(i).inventory_item_id := FND_API.G_MISS_NUM;
696 ELSE
697 sl_line_tbl(i).inventory_item_id := p_l_inventory_item_id(i);
698 END IF;
699 END LOOP;
700 FOR i IN 1..l_table_size LOOP
701 IF p_l_organization_id(i) = ROSETTA_G_MISS_NUM THEN
702 sl_line_tbl(i).organization_id := FND_API.G_MISS_NUM;
703 ELSE
704 sl_line_tbl(i).organization_id := p_l_organization_id(i);
705 END IF;
706 END LOOP;
707 FOR i IN 1..l_table_size LOOP
708 sl_line_tbl(i).uom_code := p_l_uom_code(i);
709 END LOOP;
710 FOR i IN 1..l_table_size LOOP
711 IF p_l_quantity(i) = ROSETTA_G_MISS_NUM THEN
712 sl_line_tbl(i).quantity := FND_API.G_MISS_NUM;
713 ELSE
714 sl_line_tbl(i).quantity := p_l_quantity(i);
715 END IF;
716 END LOOP;
717 FOR i IN 1..l_table_size LOOP
718 IF p_l_config_header_id(i) = ROSETTA_G_MISS_NUM THEN
719 sl_line_tbl(i).config_header_id := FND_API.G_MISS_NUM;
720 ELSE
721 sl_line_tbl(i).config_header_id := p_l_config_header_id(i);
722 END IF;
723 END LOOP;
724 FOR i IN 1..l_table_size LOOP
725 IF p_l_config_revision_num(i) = ROSETTA_G_MISS_NUM THEN
726 sl_line_tbl(i).config_revision_num := FND_API.G_MISS_NUM;
727 ELSE
728 sl_line_tbl(i).config_revision_num := p_l_config_revision_num(i);
729 END IF;
730 END LOOP;
731 FOR i IN 1..l_table_size LOOP
732 sl_line_tbl(i).complete_configuration_flag := p_l_complete_config_flag(i);
733 END LOOP;
734 FOR i IN 1..l_table_size LOOP
738 sl_line_tbl(i).item_type_code := p_l_item_type_code(i);
735 sl_line_tbl(i).valid_configuration_flag := p_l_valid_configuration_flag(i);
736 END LOOP;
737 FOR i IN 1..l_table_size LOOP
739 END LOOP;
740 FOR i IN 1..l_table_size LOOP
741 sl_line_tbl(i).attribute_category := p_l_attribute_category(i);
742 END LOOP;
743 FOR i IN 1..l_table_size LOOP
744 sl_line_tbl(i).attribute1 := p_l_attribute1(i);
745 END LOOP;
746 FOR i IN 1..l_table_size LOOP
747 sl_line_tbl(i).attribute2 := p_l_attribute2(i);
748 END LOOP;
749 FOR i IN 1..l_table_size LOOP
750 sl_line_tbl(i).attribute3 := p_l_attribute3(i);
751 END LOOP;
752 FOR i IN 1..l_table_size LOOP
753 sl_line_tbl(i).attribute4 := p_l_attribute4(i);
754 END LOOP;
755 FOR i IN 1..l_table_size LOOP
756 sl_line_tbl(i).attribute5 := p_l_attribute5(i);
757 END LOOP;
758 FOR i IN 1..l_table_size LOOP
759 sl_line_tbl(i).attribute6 := p_l_attribute6(i);
760 END LOOP;
761 FOR i IN 1..l_table_size LOOP
762 sl_line_tbl(i).attribute7 := p_l_attribute7(i);
763 END LOOP;
764 FOR i IN 1..l_table_size LOOP
765 sl_line_tbl(i).attribute8 := p_l_attribute8(i);
766 END LOOP;
767 FOR i IN 1..l_table_size LOOP
768 sl_line_tbl(i).attribute9 := p_l_attribute9(i);
769 END LOOP;
770 FOR i IN 1..l_table_size LOOP
771 sl_line_tbl(i).attribute10 := p_l_attribute10(i);
772 END LOOP;
773 FOR i IN 1..l_table_size LOOP
774 sl_line_tbl(i).attribute11 := p_l_attribute11(i);
775 END LOOP;
776 FOR i IN 1..l_table_size LOOP
777 sl_line_tbl(i).attribute12 := p_l_attribute12(i);
778 END LOOP;
779 FOR i IN 1..l_table_size LOOP
780 sl_line_tbl(i).attribute13 := p_l_attribute13(i);
781 END LOOP;
782 FOR i IN 1..l_table_size LOOP
783 sl_line_tbl(i).attribute14 := p_l_attribute14(i);
784 END LOOP;
785 FOR i IN 1..l_table_size LOOP
786 sl_line_tbl(i).attribute15 := p_l_attribute15(i);
787 END LOOP;
788 FOR i IN 1..l_table_size LOOP
789 IF p_l_org_id(i) = ROSETTA_G_MISS_NUM THEN
790 sl_line_tbl(i).org_id := FND_API.G_MISS_NUM;
791 ELSE
792 sl_line_tbl(i).org_id := p_l_org_id(i);
793 END IF;
794 END LOOP;
795 END IF;
796
797 RETURN sl_line_tbl;
798 END Construct_SL_Line_Tbl;
799
800
801 FUNCTION Construct_SL_Line_Rel_Tbl(
802 p_lr_shlitem_rel_id IN jtf_number_table := NULL,
803 p_lr_request_id IN jtf_number_table := NULL,
804 p_lr_program_application_id IN jtf_number_table := NULL,
805 p_lr_program_id IN jtf_number_table := NULL,
806 p_lr_program_update_date IN jtf_date_table := NULL,
807 p_lr_object_version_number IN jtf_number_table := NULL,
808 p_lr_created_by IN jtf_number_table := NULL,
809 p_lr_creation_date IN jtf_date_table := NULL,
810 p_lr_last_updated_by IN jtf_number_table := NULL,
811 p_lr_last_update_date IN jtf_date_table := NULL,
812 p_lr_last_update_login IN jtf_number_table := NULL,
813 p_lr_shp_list_item_id IN jtf_number_table := NULL,
814 p_lr_line_index IN jtf_number_table := NULL,
815 p_lr_related_shp_list_item_id IN jtf_number_table := NULL,
816 p_lr_related_line_index IN jtf_number_table := NULL,
817 p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL
818 ) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
819 IS
820 sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
824 BEGIN
821 := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
822 l_table_size PLS_INTEGER;
823 i PLS_INTEGER;
825 IF p_lr_shlitem_rel_id IS NOT NULL AND p_lr_shlitem_rel_id.COUNT > 0 THEN
826 l_table_size := p_lr_shlitem_rel_id.COUNT;
827
831 ELSE
828 FOR i IN 1..l_table_size LOOP
829 IF p_lr_shlitem_rel_id(i) = ROSETTA_G_MISS_NUM THEN
830 sl_line_rel_tbl(i).shlitem_rel_id := FND_API.G_MISS_NUM;
832 sl_line_rel_tbl(i).shlitem_rel_id := p_lr_shlitem_rel_id(i);
833 END IF;
834 END LOOP;
835 FOR i IN 1..l_table_size LOOP
836 IF p_lr_request_id(i) = ROSETTA_G_MISS_NUM THEN
837 sl_line_rel_tbl(i).request_id := FND_API.G_MISS_NUM;
838 ELSE
839 sl_line_rel_tbl(i).request_id := p_lr_request_id(i);
840 END IF;
841 END LOOP;
842 FOR i IN 1..l_table_size LOOP
843 IF p_lr_program_application_id(i) = ROSETTA_G_MISS_NUM THEN
844 sl_line_rel_tbl(i).program_application_id := FND_API.G_MISS_NUM;
845 ELSE
846 sl_line_rel_tbl(i).program_application_id := p_lr_program_application_id(i);
847 END IF;
848 END LOOP;
849 FOR i IN 1..l_table_size LOOP
850 IF p_lr_program_id(i) = ROSETTA_G_MISS_NUM THEN
851 sl_line_rel_tbl(i).program_id := FND_API.G_MISS_NUM;
852 ELSE
853 sl_line_rel_tbl(i).program_id := p_lr_program_id(i);
854 END IF;
855 END LOOP;
856 FOR i IN 1..l_table_size LOOP
857 IF p_lr_program_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
858 sl_line_rel_tbl(i).program_update_date := FND_API.G_MISS_DATE;
859 ELSE
860 sl_line_rel_tbl(i).program_update_date := p_lr_program_update_date(i);
861 END IF;
862 END LOOP;
863 FOR i IN 1..l_table_size LOOP
864 IF p_lr_object_version_number(i) = ROSETTA_G_MISS_NUM THEN
865 sl_line_rel_tbl(i).object_version_number := FND_API.G_MISS_NUM;
866 ELSE
867 sl_line_rel_tbl(i).object_version_number := p_lr_object_version_number(i);
868 END IF;
869 END LOOP;
870 FOR i IN 1..l_table_size LOOP
871 IF p_lr_created_by(i) = ROSETTA_G_MISS_NUM THEN
872 sl_line_rel_tbl(i).created_by := FND_API.G_MISS_NUM;
873 ELSE
874 sl_line_rel_tbl(i).created_by := p_lr_created_by(i);
875 END IF;
876 END LOOP;
877 FOR i IN 1..l_table_size LOOP
878 IF p_lr_creation_date(i) = ROSETTA_G_MISTAKE_DATE THEN
879 sl_line_rel_tbl(i).creation_date := FND_API.G_MISS_DATE;
880 ELSE
881 sl_line_rel_tbl(i).creation_date := p_lr_creation_date(i);
882 END IF;
883 END LOOP;
884 FOR i IN 1..l_table_size LOOP
885 IF p_lr_last_updated_by(i) = ROSETTA_G_MISS_NUM THEN
886 sl_line_rel_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
887 ELSE
888 sl_line_rel_tbl(i).last_updated_by := p_lr_last_updated_by(i);
889 END IF;
890 END LOOP;
891 FOR i IN 1..l_table_size LOOP
892 IF p_lr_last_update_date(i) = ROSETTA_G_MISTAKE_DATE THEN
893 sl_line_rel_tbl(i).last_update_date := FND_API.G_MISS_DATE;
894 ELSE
895 sl_line_rel_tbl(i).last_update_date := p_lr_last_update_date(i);
896 END IF;
897 END LOOP;
898 FOR i IN 1..l_table_size LOOP
899 IF p_lr_last_update_login(i) = ROSETTA_G_MISS_NUM THEN
900 sl_line_rel_tbl(i).last_update_login := FND_API.G_MISS_NUM;
901 ELSE
902 sl_line_rel_tbl(i).last_update_login := p_lr_last_update_login(i);
903 END IF;
904 END LOOP;
905 FOR i IN 1..l_table_size LOOP
906 IF p_lr_shp_list_item_id(i) = ROSETTA_G_MISS_NUM THEN
907 sl_line_rel_tbl(i).shp_list_item_id := FND_API.G_MISS_NUM;
908 ELSE
909 sl_line_rel_tbl(i).shp_list_item_id := p_lr_shp_list_item_id(i);
910 END IF;
911 END LOOP;
912 FOR i IN 1..l_table_size LOOP
913 IF p_lr_line_index(i) = ROSETTA_G_MISS_NUM THEN
914 sl_line_rel_tbl(i).line_index := FND_API.G_MISS_NUM;
915 ELSE
916 sl_line_rel_tbl(i).line_index := p_lr_line_index(i);
917 END IF;
918 END LOOP;
919 FOR i IN 1..l_table_size LOOP
920 IF p_lr_related_shp_list_item_id(i) = ROSETTA_G_MISS_NUM THEN
921 sl_line_rel_tbl(i).related_shp_list_item_id := FND_API.G_MISS_NUM;
922 ELSE
923 sl_line_rel_tbl(i).related_shp_list_item_id := p_lr_related_shp_list_item_id(i);
924 END IF;
925 END LOOP;
926 FOR i IN 1..l_table_size LOOP
927 IF p_lr_related_line_index(i) = ROSETTA_G_MISS_NUM THEN
928 sl_line_rel_tbl(i).related_line_index := FND_API.G_MISS_NUM;
929 ELSE
930 sl_line_rel_tbl(i).related_line_index := p_lr_related_line_index(i);
931 END IF;
932 END LOOP;
933 FOR i IN 1..l_table_size LOOP
934 sl_line_rel_tbl(i).relationship_type_code := p_lr_relationship_type_code(i);
935 END LOOP;
936 END IF;
937
938 RETURN sl_line_rel_tbl;
939 END Construct_SL_Line_Rel_Tbl;
940
941
942 PROCEDURE Save(
943 p_api_version IN NUMBER := 1 ,
944 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
945 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
946 x_return_status OUT NOCOPY VARCHAR2 ,
947 x_msg_count OUT NOCOPY NUMBER ,
948 x_msg_data OUT NOCOPY VARCHAR2 ,
949 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
950 p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
951 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
952 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
956 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
953 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
954 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
955 p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
957 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
958 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
959 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
960 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
961 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
962 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
963 p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
964 p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
965 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
966 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
971 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
972 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
973 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
978 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
982 p_l_shp_list_item_id IN jtf_number_table := NULL ,
983 p_l_object_version_number IN jtf_number_table := NULL ,
984 p_l_creation_date IN jtf_date_table := NULL ,
985 p_l_created_by IN jtf_number_table := NULL ,
986 p_l_last_updated_by IN jtf_number_table := NULL ,
987 p_l_last_update_date IN jtf_date_table := NULL ,
988 p_l_last_update_login IN jtf_number_table := NULL ,
989 p_l_request_id IN jtf_number_table := NULL ,
990 p_l_program_id IN jtf_number_table := NULL ,
991 p_l_program_application_id IN jtf_number_table := NULL ,
992 p_l_program_update_date IN jtf_date_table := NULL ,
993 p_l_shp_list_id IN jtf_number_table := NULL ,
994 p_l_inventory_item_id IN jtf_number_table := NULL ,
995 p_l_organization_id IN jtf_number_table := NULL ,
996 p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
997 p_l_quantity IN jtf_number_table := NULL ,
998 p_l_config_header_id IN jtf_number_table := NULL ,
999 p_l_config_revision_num IN jtf_number_table := NULL ,
1000 p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
1001 p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
1002 p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
1003 p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
1004 p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
1005 p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,
1006 p_l_attribute3 IN jtf_varchar2_table_200 := NULL ,
1007 p_l_attribute4 IN jtf_varchar2_table_200 := NULL ,
1008 p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009 p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010 p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011 p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012 p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013 p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014 p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015 p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016 p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1017 p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1018 p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1019 p_l_org_id IN jtf_number_table := NULL ,
1020 p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1021 p_lr_request_id IN jtf_number_table := NULL ,
1022 p_lr_program_application_id IN jtf_number_table := NULL ,
1023 p_lr_program_id IN jtf_number_table := NULL ,
1024 p_lr_program_update_date IN jtf_date_table := NULL ,
1025 p_lr_object_version_number IN jtf_number_table := NULL ,
1026 p_lr_created_by IN jtf_number_table := NULL ,
1027 p_lr_creation_date IN jtf_date_table := NULL ,
1028 p_lr_last_updated_by IN jtf_number_table := NULL ,
1029 p_lr_last_update_date IN jtf_date_table := NULL ,
1030 p_lr_last_update_login IN jtf_number_table := NULL ,
1031 p_lr_shp_list_item_id IN jtf_number_table := NULL ,
1032 p_lr_line_index IN jtf_number_table := NULL ,
1033 p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
1034 p_lr_related_line_index IN jtf_number_table := NULL ,
1035 p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
1036 x_sl_header_id OUT NOCOPY NUMBER
1037 )
1038 IS
1039 l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1043
1040 l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type;
1041 l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;
1042 BEGIN
1044 l_sl_header_rec := Construct_SL_Header_Rec(
1045 p_h_shp_list_id => p_h_shp_list_id,
1046 p_h_request_id => p_h_request_id,
1047 p_h_program_application_id => p_h_program_application_id,
1048 p_h_program_id => p_h_program_id,
1049 p_h_program_update_date => p_h_program_update_date,
1050 p_h_object_version_number => p_h_object_version_number,
1051 p_h_created_by => p_h_created_by,
1052 p_h_creation_date => p_h_creation_date,
1053 p_h_last_updated_by => p_h_last_updated_by,
1054 p_h_last_update_date => p_h_last_update_date,
1055 p_h_last_update_login => p_h_last_update_login,
1056 p_h_party_id => p_h_party_id,
1057 p_h_cust_account_id => p_h_cust_account_id,
1058 p_h_shopping_list_name => p_h_shopping_list_name,
1059 p_h_description => p_h_description,
1060 p_h_attribute_category => p_h_attribute_category,
1061 p_h_attribute1 => p_h_attribute1,
1062 p_h_attribute2 => p_h_attribute2,
1063 p_h_attribute3 => p_h_attribute3,
1064 p_h_attribute4 => p_h_attribute4,
1065 p_h_attribute5 => p_h_attribute5,
1066 p_h_attribute6 => p_h_attribute6,
1067 p_h_attribute7 => p_h_attribute7,
1068 p_h_attribute8 => p_h_attribute8,
1069 p_h_attribute9 => p_h_attribute9,
1073 p_h_attribute13 => p_h_attribute13,
1070 p_h_attribute10 => p_h_attribute10,
1071 p_h_attribute11 => p_h_attribute11,
1072 p_h_attribute12 => p_h_attribute11,
1074 p_h_attribute14 => p_h_attribute14,
1075 p_h_attribute15 => p_h_attribute15,
1076 p_h_org_id => p_h_org_id);
1077
1078 l_sl_line_tbl := Construct_SL_Line_Tbl(
1079 p_l_shp_list_item_id => p_l_shp_list_item_id ,
1080 p_l_object_version_number => p_l_object_version_number ,
1081 p_l_creation_date => p_l_creation_date ,
1082 p_l_created_by => p_l_created_by ,
1083 p_l_last_updated_by => p_l_last_updated_by ,
1084 p_l_last_update_date => p_l_last_update_date ,
1085 p_l_last_update_login => p_l_last_update_login ,
1086 p_l_request_id => p_l_request_id ,
1087 p_l_program_id => p_l_program_id ,
1088 p_l_program_application_id => p_l_program_application_id ,
1089 p_l_program_update_date => p_l_program_update_date ,
1090 p_l_shp_list_id => p_l_shp_list_id ,
1091 p_l_inventory_item_id => p_l_inventory_item_id ,
1092 p_l_organization_id => p_l_organization_id ,
1093 p_l_uom_code => p_l_uom_code ,
1094 p_l_quantity => p_l_quantity ,
1095 p_l_config_header_id => p_l_config_header_id ,
1096 p_l_config_revision_num => p_l_config_revision_num ,
1097 p_l_complete_config_flag => p_l_complete_config_flag ,
1098 p_l_valid_configuration_flag => p_l_valid_configuration_flag,
1099 p_l_item_type_code => p_l_item_type_code ,
1100 p_l_attribute_category => p_l_attribute_category ,
1101 p_l_attribute1 => p_l_attribute1 ,
1102 p_l_attribute2 => p_l_attribute2 ,
1103 p_l_attribute3 => p_l_attribute3 ,
1104 p_l_attribute4 => p_l_attribute4 ,
1105 p_l_attribute5 => p_l_attribute5 ,
1106 p_l_attribute6 => p_l_attribute6 ,
1107 p_l_attribute7 => p_l_attribute7 ,
1108 p_l_attribute8 => p_l_attribute8 ,
1109 p_l_attribute9 => p_l_attribute9 ,
1110 p_l_attribute10 => p_l_attribute10 ,
1111 p_l_attribute11 => p_l_attribute11 ,
1112 p_l_attribute12 => p_l_attribute12 ,
1113 p_l_attribute13 => p_l_attribute13 ,
1114 p_l_attribute14 => p_l_attribute14 ,
1115 p_l_attribute15 => p_l_attribute15 ,
1116 p_l_org_id => p_l_org_id);
1117
1118 l_sl_line_rel_tbl := Construct_SL_Line_Rel_Tbl(
1119 p_lr_shlitem_rel_id => p_lr_shlitem_rel_id ,
1120 p_lr_request_id => p_lr_request_id ,
1121 p_lr_program_application_id => p_lr_program_application_id ,
1122 p_lr_program_id => p_lr_program_id ,
1126 p_lr_creation_date => p_lr_creation_date ,
1123 p_lr_program_update_date => p_lr_program_update_date ,
1124 p_lr_object_version_number => p_lr_object_version_number ,
1125 p_lr_created_by => p_lr_created_by ,
1127 p_lr_last_updated_by => p_lr_last_updated_by ,
1128 p_lr_last_update_date => p_lr_last_update_date ,
1129 p_lr_last_update_login => p_lr_last_update_login ,
1130 p_lr_shp_list_item_id => p_lr_shp_list_item_id ,
1131 p_lr_line_index => p_lr_line_index ,
1132 p_lr_related_shp_list_item_id => p_lr_related_shp_list_item_id,
1133 p_lr_related_line_index => p_lr_related_line_index ,
1134 p_lr_relationship_type_code => p_lr_relationship_type_code);
1135
1136 IBE_Shop_List_PVT.Save(
1137 p_api_version => p_api_version ,
1138 p_init_msg_list => p_init_msg_list ,
1139 p_commit => p_commit ,
1140 x_return_status => x_return_status ,
1141 x_msg_count => x_msg_count ,
1142 x_msg_data => x_msg_data ,
1143 p_combine_same_item => p_combine_same_item,
1144 p_sl_header_rec => l_sl_header_rec ,
1145 p_sl_line_tbl => l_sl_line_tbl ,
1146 p_sl_line_rel_tbl => l_sl_line_rel_tbl ,
1147 x_sl_header_id => x_sl_header_id);
1148 END Save;
1149
1150
1151 PROCEDURE Save_List_From_Items(
1152 p_api_version IN NUMBER := 1 ,
1153 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1154 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1155 x_return_status OUT NOCOPY VARCHAR2 ,
1156 x_msg_count OUT NOCOPY NUMBER ,
1157 x_msg_data OUT NOCOPY VARCHAR2 ,
1158 p_sl_line_ids IN jtf_number_table ,
1159 p_sl_line_ovns IN jtf_number_table := NULL ,
1160 p_mode IN VARCHAR2 := 'MERGE' ,
1161 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1162 p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1163 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
1164 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
1165 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
1166 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
1167 p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
1168 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
1169 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
1170 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
1171 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
1172 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
1173 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1174 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1175 p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1176 p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1177 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1178 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1179 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1183 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1180 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1181 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1182 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1184 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1185 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1186 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1187 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1188 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1189 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1190 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1191 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1192 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1193 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
1194 x_sl_header_id OUT NOCOPY NUMBER
1195 )
1196 IS
1197 l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1198 BEGIN
1199 l_sl_header_rec := Construct_SL_Header_Rec(
1200 p_h_shp_list_id => p_h_shp_list_id,
1201 p_h_request_id => p_h_request_id,
1202 p_h_program_application_id => p_h_program_application_id,
1203 p_h_program_id => p_h_program_id,
1204 p_h_program_update_date => p_h_program_update_date,
1205 p_h_object_version_number => p_h_object_version_number,
1206 p_h_created_by => p_h_created_by,
1210 p_h_last_update_login => p_h_last_update_login,
1207 p_h_creation_date => p_h_creation_date,
1208 p_h_last_updated_by => p_h_last_updated_by,
1209 p_h_last_update_date => p_h_last_update_date,
1211 p_h_party_id => p_h_party_id,
1212 p_h_cust_account_id => p_h_cust_account_id,
1213 p_h_shopping_list_name => p_h_shopping_list_name,
1214 p_h_description => p_h_description,
1215 p_h_attribute_category => p_h_attribute_category,
1216 p_h_attribute1 => p_h_attribute1,
1217 p_h_attribute2 => p_h_attribute2,
1218 p_h_attribute3 => p_h_attribute3,
1219 p_h_attribute4 => p_h_attribute4,
1220 p_h_attribute5 => p_h_attribute5,
1221 p_h_attribute6 => p_h_attribute6,
1222 p_h_attribute7 => p_h_attribute7,
1223 p_h_attribute8 => p_h_attribute8,
1224 p_h_attribute9 => p_h_attribute9,
1225 p_h_attribute10 => p_h_attribute10,
1226 p_h_attribute11 => p_h_attribute11,
1227 p_h_attribute12 => p_h_attribute11,
1228 p_h_attribute13 => p_h_attribute13,
1229 p_h_attribute14 => p_h_attribute14,
1230 p_h_attribute15 => p_h_attribute15,
1231 p_h_org_id => p_h_org_id);
1232
1233 IBE_Shop_List_PVT.Save_List_From_Items(
1234 p_api_version => p_api_version ,
1235 p_init_msg_list => p_init_msg_list ,
1236 p_commit => p_commit ,
1237 x_return_status => x_return_status ,
1238 x_msg_count => x_msg_count ,
1239 x_msg_data => x_msg_data ,
1240 p_sl_line_ids => p_sl_line_ids ,
1241 p_sl_line_ovns => p_sl_line_ovns ,
1242 p_mode => p_mode ,
1243 p_combine_same_item => p_combine_same_item,
1244 p_sl_header_rec => l_sl_header_rec ,
1245 x_sl_header_id => x_sl_header_id);
1246 END Save_List_From_Items;
1247
1248
1249 PROCEDURE Save_List_From_Quote(
1250 p_api_version IN NUMBER := 1 ,
1251 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1252 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1253 x_return_status OUT NOCOPY VARCHAR2 ,
1254 x_msg_count OUT NOCOPY NUMBER ,
1255 x_msg_data OUT NOCOPY VARCHAR2 ,
1256 p_quote_header_id IN NUMBER ,
1257 p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1258 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
1259 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1260 p_mode IN VARCHAR2 := 'MERGE' ,
1261 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1262 p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1263 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
1264 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
1265 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
1266 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
1267 p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
1268 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
1269 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
1270 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
1271 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
1272 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
1273 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1274 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1275 p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1276 p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1277 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1278 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1279 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1280 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1281 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1282 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1283 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1284 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1285 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1286 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1287 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1288 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1289 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1290 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1291 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1292 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1293 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
1294 x_sl_header_id OUT NOCOPY NUMBER
1295 )
1296 IS
1297 l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;
1301 p_h_request_id => p_h_request_id,
1298 BEGIN
1299 l_sl_header_rec := Construct_SL_Header_Rec(
1300 p_h_shp_list_id => p_h_shp_list_id,
1302 p_h_program_application_id => p_h_program_application_id,
1303 p_h_program_id => p_h_program_id,
1304 p_h_program_update_date => p_h_program_update_date,
1305 p_h_object_version_number => p_h_object_version_number,
1306 p_h_created_by => p_h_created_by,
1307 p_h_creation_date => p_h_creation_date,
1308 p_h_last_updated_by => p_h_last_updated_by,
1309 p_h_last_update_date => p_h_last_update_date,
1310 p_h_last_update_login => p_h_last_update_login,
1311 p_h_party_id => p_h_party_id,
1312 p_h_cust_account_id => p_h_cust_account_id,
1313 p_h_shopping_list_name => p_h_shopping_list_name,
1314 p_h_description => p_h_description,
1315 p_h_attribute_category => p_h_attribute_category,
1316 p_h_attribute1 => p_h_attribute1,
1317 p_h_attribute2 => p_h_attribute2,
1318 p_h_attribute3 => p_h_attribute3,
1319 p_h_attribute4 => p_h_attribute4,
1320 p_h_attribute5 => p_h_attribute5,
1321 p_h_attribute6 => p_h_attribute6,
1322 p_h_attribute7 => p_h_attribute7,
1323 p_h_attribute8 => p_h_attribute8,
1324 p_h_attribute9 => p_h_attribute9,
1325 p_h_attribute10 => p_h_attribute10,
1326 p_h_attribute11 => p_h_attribute11,
1327 p_h_attribute12 => p_h_attribute11,
1328 p_h_attribute13 => p_h_attribute13,
1329 p_h_attribute14 => p_h_attribute14,
1330 p_h_attribute15 => p_h_attribute15,
1331 p_h_org_id => p_h_org_id);
1332
1333 IBE_Shop_List_PVT.Save_List_From_Quote(
1334 p_api_version => p_api_version ,
1335 p_init_msg_list => p_init_msg_list ,
1336 p_commit => p_commit ,
1337 x_return_status => x_return_status ,
1338 x_msg_count => x_msg_count ,
1339 x_msg_data => x_msg_data ,
1340 p_quote_header_id => p_quote_header_id ,
1341 p_quote_retrieval_number => p_quote_retrieval_number,
1342 p_minisite_id => p_minisite_id ,
1343 p_last_update_date => p_last_update_date ,
1344 p_mode => p_mode ,
1345 p_sl_header_rec => l_sl_header_rec ,
1346 p_combine_same_item => p_combine_same_item ,
1347 x_sl_header_id => x_sl_header_id);
1348 END Save_List_From_Quote;
1349
1350
1351 PROCEDURE Save_Quote_From_List_Items(
1352 p_api_version IN NUMBER := 1 ,
1353 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1354 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1355 x_return_status OUT NOCOPY VARCHAR2 ,
1356 x_msg_count OUT NOCOPY NUMBER ,
1357 x_msg_data OUT NOCOPY VARCHAR2 ,
1358 p_sl_line_ids IN jtf_number_table ,
1359 p_sl_line_ovns IN jtf_number_table := NULL ,
1360 p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1361 p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1362 p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1363 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
1364 p_mode IN VARCHAR2 := 'MERGE' ,
1365 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1366 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
1367 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1368 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1369 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
1370 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
1371 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373 p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
1374 p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
1375 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
1376 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
1377 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
1378 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
1379 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
1380 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
1381 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
1382 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
1383 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
1384 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
1385 p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1386 p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
1387 p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
1388 p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
1389 p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390 p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
1394 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1391 p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
1392 p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
1393 p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
1395 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1396 p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
1397 p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1398 p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
1399 p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1400 p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1401 p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1402 p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
1403 p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1404 p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
1405 p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1406 p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1410 p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
1407 p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1408 p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
1409 p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
1411 p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
1412 p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
1413 p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
1414 p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
1415 p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
1416 p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
1417 p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
1418 p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1419 p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
1420 p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1421 p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1422 p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
1423 p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
1424 p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1425 -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1426 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1427 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1428 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1429 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1430 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1431 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1432 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1433 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1434 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1435 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1436 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1437 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1438 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1439 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1440 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1441 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1442 p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
1443 p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
1444 p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
1445 p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1446 p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1447 p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1451 p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1448 p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1449 p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
1450 p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1452 p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1453 p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1454 p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
1455 p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
1456 p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1457 p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1458 p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
1459 p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1460 p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
1461 p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
1462 p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
1463 p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
1464 p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1465 p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1466 p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
1467 p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
1468 p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
1469 p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
1470 p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1471 p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
1472 p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
1473 p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
1474 p_email_address IN jtf_varchar2_table_2000 := NULL,
1475 p_privilege_type IN jtf_varchar2_table_100 := NULL,
1476 p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
1477 p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
1478 p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR, --added for R12
1479 x_q_header_id OUT NOCOPY NUMBER
1480 )
1481 IS
1482 l_control_rec ASO_QUOTE_PUB.Control_Rec_Type
1483 := ASO_QUOTE_PUB.G_MISS_CONTROL_REC;
1484 l_q_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type
1485 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC;
1486 BEGIN
1487 l_control_rec := Construct_Control_Rec(
1488 p_c_last_update_date => p_c_last_update_date ,
1489 p_c_auto_version_flag => p_c_auto_version_flag ,
1490 p_c_pricing_request_type => p_c_pricing_request_type,
1491 p_c_header_pricing_event => p_c_header_pricing_event,
1492 p_c_line_pricing_event => p_c_line_pricing_event ,
1493 p_c_cal_tax_flag => p_c_cal_tax_flag ,
1494 p_c_cal_freight_charge_flag => p_c_cal_freight_charge_flag,
1495 p_c_price_mode => p_c_price_mode);
1496
1497 l_q_header_rec := Construct_Quote_Header_Rec(
1498 p_h_quote_header_id => p_h_quote_header_id ,
1499 p_h_creation_date => p_h_creation_date ,
1500 p_h_created_by => p_h_created_by ,
1501 p_h_last_updated_by => p_h_last_updated_by ,
1502 p_h_last_update_date => p_h_last_update_date ,
1503 p_h_last_update_login => p_h_last_update_login ,
1504 p_h_request_id => p_h_request_id ,
1505 p_h_program_application_id => p_h_program_application_id ,
1506 p_h_program_id => p_h_program_id ,
1507 p_h_program_update_date => p_h_program_update_date ,
1508 p_h_org_id => p_h_org_id ,
1509 p_h_quote_name => p_h_quote_name ,
1510 p_h_quote_number => p_h_quote_number ,
1511 p_h_quote_version => p_h_quote_version ,
1512 p_h_quote_status_id => p_h_quote_status_id ,
1513 p_h_quote_source_code => p_h_quote_source_code ,
1514 p_h_quote_expiration_date => p_h_quote_expiration_date ,
1515 p_h_price_frozen_date => p_h_price_frozen_date ,
1516 p_h_quote_password => p_h_quote_password ,
1517 p_h_original_system_reference => p_h_original_system_reference ,
1518 p_h_party_id => p_h_party_id ,
1519 p_h_cust_account_id => p_h_cust_account_id ,
1520 p_h_org_contact_id => p_h_org_contact_id ,
1521 p_h_party_name => p_h_party_name ,
1522 p_h_party_type => p_h_party_type ,
1523 p_h_person_first_name => p_h_person_first_name ,
1524 p_h_person_last_name => p_h_person_last_name ,
1525 p_h_person_middle_name => p_h_person_middle_name ,
1526 p_h_phone_id => p_h_phone_id ,
1527 p_h_price_list_id => p_h_price_list_id ,
1528 p_h_pricing_status_indicator => p_h_pricing_status_indicator , -- change line logic pricing
1529 p_h_tax_status_indicator => p_h_tax_status_indicator ,
1530 p_h_price_list_name => p_h_price_list_name ,
1531 p_h_currency_code => p_h_currency_code ,
1532 p_h_total_list_price => p_h_total_list_price ,
1533 p_h_total_adjusted_amount => p_h_total_adjusted_amount ,
1534 p_h_total_adjusted_percent => p_h_total_adjusted_percent ,
1535 p_h_total_tax => p_h_total_tax ,
1536 p_h_total_shipping_charge => p_h_total_shipping_charge ,
1540 p_h_accounting_rule_id => p_h_accounting_rule_id ,
1537 p_h_surcharge => p_h_surcharge ,
1538 p_h_total_quote_price => p_h_total_quote_price ,
1539 p_h_payment_amount => p_h_payment_amount ,
1541 p_h_exchange_rate => p_h_exchange_rate ,
1542 p_h_exchange_type_code => p_h_exchange_type_code ,
1543 p_h_exchange_rate_date => p_h_exchange_rate_date ,
1544 p_h_quote_category_code => p_h_quote_category_code ,
1545 p_h_quote_status_code => p_h_quote_status_code ,
1546 p_h_quote_status => p_h_quote_status ,
1547 p_h_employee_person_id => p_h_employee_person_id ,
1548 p_h_sales_channel_code => p_h_sales_channel_code ,
1549 -- p_h_salesrep_full_name => p_h_salesrep_full_name ,
1550 p_h_attribute_category => p_h_attribute_category ,
1551 p_h_attribute1 => p_h_attribute1 ,
1552 p_h_attribute10 => p_h_attribute10 ,
1553 p_h_attribute11 => p_h_attribute11 ,
1554 p_h_attribute12 => p_h_attribute12 ,
1555 p_h_attribute13 => p_h_attribute13 ,
1556 p_h_attribute14 => p_h_attribute14 ,
1557 p_h_attribute15 => p_h_attribute15 ,
1558 p_h_attribute2 => p_h_attribute2 ,
1559 p_h_attribute3 => p_h_attribute3 ,
1560 p_h_attribute4 => p_h_attribute4 ,
1561 p_h_attribute5 => p_h_attribute5 ,
1562 p_h_attribute6 => p_h_attribute6 ,
1563 p_h_attribute7 => p_h_attribute7 ,
1564 p_h_attribute8 => p_h_attribute8 ,
1565 p_h_attribute9 => p_h_attribute9 ,
1566 p_h_contract_id => p_h_contract_id ,
1567 p_h_qte_contract_id => p_h_qte_contract_id ,
1568 p_h_ffm_request_id => p_h_ffm_request_id ,
1569 p_h_invoice_to_address1 => p_h_invoice_to_address1 ,
1570 p_h_invoice_to_address2 => p_h_invoice_to_address2 ,
1571 p_h_invoice_to_address3 => p_h_invoice_to_address3 ,
1572 p_h_invoice_to_address4 => p_h_invoice_to_address4 ,
1573 p_h_invoice_to_city => p_h_invoice_to_city ,
1574 p_h_invoice_to_cont_first_name => p_h_invoice_to_cont_first_name,
1575 p_h_invoice_to_cont_last_name => p_h_invoice_to_cont_last_name ,
1576 p_h_invoice_to_cont_mid_name => p_h_invoice_to_cont_mid_name ,
1577 p_h_invoice_to_country_code => p_h_invoice_to_country_code ,
1578 p_h_invoice_to_country => p_h_invoice_to_country ,
1579 p_h_invoice_to_county => p_h_invoice_to_county ,
1580 p_h_invoice_to_party_id => p_h_invoice_to_party_id ,
1581 p_h_invoice_to_party_name => p_h_invoice_to_party_name ,
1582 p_h_invoice_to_party_site_id => p_h_invoice_to_party_site_id ,
1583 p_h_invoice_to_postal_code => p_h_invoice_to_postal_code ,
1584 p_h_invoice_to_province => p_h_invoice_to_province ,
1585 p_h_invoice_to_state => p_h_invoice_to_state ,
1586 p_h_invoicing_rule_id => p_h_invoicing_rule_id ,
1587 p_h_marketing_source_code_id => p_h_marketing_source_code_id ,
1588 p_h_marketing_source_code => p_h_marketing_source_code ,
1589 p_h_marketing_source_name => p_h_marketing_source_name ,
1590 p_h_orig_mktg_source_code_id => p_h_orig_mktg_source_code_id ,
1591 p_h_order_type_id => p_h_order_type_id ,
1592 p_h_order_id => p_h_order_id ,
1593 p_h_order_number => p_h_order_number ,
1594 p_h_order_type_name => p_h_order_type_name ,
1595 p_h_ordered_date => p_h_ordered_date ,
1596 p_h_resource_id => p_h_resource_id);
1597
1598 IBE_Shop_List_PVT.Save_Quote_From_List_Items(
1599 p_api_version => p_api_version ,
1600 p_init_msg_list => p_init_msg_list ,
1601 p_commit => p_commit ,
1602 x_return_status => x_return_status ,
1603 x_msg_count => x_msg_count ,
1604 x_msg_data => x_msg_data ,
1605 p_sl_line_ids => p_sl_line_ids ,
1609 p_recipient_cust_account_id => p_recipient_cust_account_id,
1606 p_sl_line_ovns => p_sl_line_ovns ,
1607 p_quote_retrieval_number => p_quote_retrieval_number,
1608 p_recipient_party_id => p_recipient_party_id ,
1613 p_control_rec => l_control_rec ,
1610 p_minisite_id => p_minisite_id ,
1611 p_mode => p_mode ,
1612 p_combine_same_item => p_combine_same_item ,
1614 p_q_header_rec => l_q_header_rec ,
1615 p_password => p_password ,
1616 p_email_address => p_email_address ,
1617 p_privilege_type => p_privilege_type ,
1618 p_url => p_url ,
1619 p_comments => p_comments ,
1620 p_promocode => p_promocode ,
1621 x_q_header_id => x_q_header_id);
1622 END Save_Quote_From_List_Items;
1623
1624 END IBE_Shop_List_Wrapper_PVT;
1625