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