1 PACKAGE IBE_Shop_List_Wrapper_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVQLWS.pls 120.2 2010/11/30 10:17:46 scnagara ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Shop_List_Wrapper_PVT';
5
6 PROCEDURE Save(
7 p_api_version IN NUMBER := 1 ,
8 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10 x_return_status OUT NOCOPY VARCHAR2 ,
11 x_msg_count OUT NOCOPY NUMBER ,
12 x_msg_data OUT NOCOPY VARCHAR2 ,
13 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
14 p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
15 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19 p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27 p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28 p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46 p_l_shp_list_item_id IN jtf_number_table := NULL ,
47 p_l_object_version_number IN jtf_number_table := NULL ,
48 p_l_creation_date IN jtf_date_table := NULL ,
49 p_l_created_by IN jtf_number_table := NULL ,
50 p_l_last_updated_by IN jtf_number_table := NULL ,
51 p_l_last_update_date IN jtf_date_table := NULL ,
52 p_l_last_update_login IN jtf_number_table := NULL ,
53 p_l_request_id IN jtf_number_table := NULL ,
54 p_l_program_id IN jtf_number_table := NULL ,
55 p_l_program_application_id IN jtf_number_table := NULL ,
56 p_l_program_update_date IN jtf_date_table := NULL ,
57 p_l_shp_list_id IN jtf_number_table := NULL ,
58 p_l_inventory_item_id IN jtf_number_table := NULL ,
59 p_l_organization_id IN jtf_number_table := NULL ,
60 p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
61 p_l_quantity IN jtf_number_table := NULL ,
62 p_l_config_header_id IN jtf_number_table := NULL ,
63 p_l_config_revision_num IN jtf_number_table := NULL ,
64 p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
65 p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
66 p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
67 p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
68 p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
69 p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,
70 p_l_attribute3 IN jtf_varchar2_table_200 := NULL ,
71 p_l_attribute4 IN jtf_varchar2_table_200 := NULL ,
72 p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
73 p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
74 p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
75 p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
76 p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
77 p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
78 p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
79 p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
80 p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
81 p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
82 p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
83 p_l_org_id IN jtf_number_table := NULL ,
84 p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
85 p_lr_request_id IN jtf_number_table := NULL ,
86 p_lr_program_application_id IN jtf_number_table := NULL ,
87 p_lr_program_id IN jtf_number_table := NULL ,
88 p_lr_program_update_date IN jtf_date_table := NULL ,
89 p_lr_object_version_number IN jtf_number_table := NULL ,
90 p_lr_created_by IN jtf_number_table := NULL ,
91 p_lr_creation_date IN jtf_date_table := NULL ,
92 p_lr_last_updated_by IN jtf_number_table := NULL ,
93 p_lr_last_update_date IN jtf_date_table := NULL ,
94 p_lr_last_update_login IN jtf_number_table := NULL ,
95 p_lr_shp_list_item_id IN jtf_number_table := NULL ,
96 p_lr_line_index IN jtf_number_table := NULL ,
97 p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
98 p_lr_related_line_index IN jtf_number_table := NULL ,
99 p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
100 x_sl_header_id OUT NOCOPY NUMBER
101 );
102
103
104 PROCEDURE Save_List_From_Items(
105 p_api_version IN NUMBER := 1 ,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108 x_return_status OUT NOCOPY VARCHAR2 ,
109 x_msg_count OUT NOCOPY NUMBER ,
110 x_msg_data OUT NOCOPY VARCHAR2 ,
111 p_sl_line_ids IN jtf_number_table ,
112 p_sl_line_ovns IN jtf_number_table := NULL ,
113 p_mode IN VARCHAR2 := 'MERGE' ,
114 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120 p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128 p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
147 x_sl_header_id OUT NOCOPY NUMBER
148 );
149
150
151 PROCEDURE Save_List_From_Quote(
152 p_api_version IN NUMBER := 1 ,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
155 x_return_status OUT NOCOPY VARCHAR2 ,
156 x_msg_count OUT NOCOPY NUMBER ,
157 x_msg_data OUT NOCOPY VARCHAR2 ,
158 p_quote_header_id IN NUMBER ,
159 p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
160 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
161 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
162 p_mode IN VARCHAR2 := 'MERGE' ,
163 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164 p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169 p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177 p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178 p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
195 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
196 x_sl_header_id OUT NOCOPY NUMBER
197 );
198
199
200 PROCEDURE Save_Quote_From_List_Items(
201 p_api_version IN NUMBER := 1 ,
202 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
203 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
204 x_return_status OUT NOCOPY VARCHAR2 ,
205 x_msg_count OUT NOCOPY NUMBER ,
206 x_msg_data OUT NOCOPY VARCHAR2 ,
207 p_sl_line_ids IN jtf_number_table ,
208 p_sl_line_ovns IN jtf_number_table := NULL ,
209 p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210 p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211 p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212 p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213 p_mode IN VARCHAR2 := 'MERGE' ,
214 p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222 p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223 p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224 p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225 p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226 p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227 p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228 p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229 p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230 p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231 p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232 p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233 p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234 p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235 p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236 p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237 p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238 p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239 p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240 p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241 p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242 p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243 p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244 p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245 p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246 p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247 p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248 p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
252 p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
249 p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250 p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251 p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
253 p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254 p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255 p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256 p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257 p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258 p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259 p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260 p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261 p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262 p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263 p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264 p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265 p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266 p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267 p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268 p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269 p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270 p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271 p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272 p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273 p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274 -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275 p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276 p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277 p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278 p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279 p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280 p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281 p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282 p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283 p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284 p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285 p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286 p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287 p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288 p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289 p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292 p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293 p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294 p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295 p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296 p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297 p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298 p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299 p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300 p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301 p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302 p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303 p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304 p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305 p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306 p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307 p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308 p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309 p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310 p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311 p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312 p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313 p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314 p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315 p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316 p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317 p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318 p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319 p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320 p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
321 p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
322 p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
323 p_email_address IN jtf_varchar2_table_2000 := NULL,
324 p_privilege_type IN jtf_varchar2_table_100 := NULL,
325 p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
326 p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
327 p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR,
328 x_q_header_id OUT NOCOPY NUMBER
329 );
330
331 END IBE_Shop_List_Wrapper_PVT;
332