1 PACKAGE OE_MASS_CHANGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVMSCS.pls 120.6.12020000.2 2013/01/07 13:26:25 sujithku ship $ */
3 -- Start of Comments
4 -- API name Process_Order
5 -- Type Private
6 -- Function
7 --
8 -- Pre-reqs
9 --
10 -- Parameters
11 --
12 -- Version Current version = 1.0
13 -- Initial version = 1.0
14 --
15 -- Notes
16 --
17 -- End of Comments
18
19 G_PKG_NAME VARCHAR2(30) := 'OE_MASS_CHANGE_PVT';
20 COMMIT_EXIT_ON_ERROR NUMBER := 1;
21 ROLLBACK_EXIT_ON_ERROR NUMBER := 2;
22 COMMIT_SHOW_ERROR NUMBER := 3;
23 ASK_COMMIT NUMBER := 4;
24 IS_MASS_CHANGE VARCHAR2(1) := 'F';
25
26 EXIT_FIRST_ERROR CONSTANT NUMBER := 5;
27 SKIP_ALL CONSTANT NUMBER := 7;
28 SKIP_CONTINUE CONSTANT NUMBER := 8;
29
30 G_COUNTER Integer := 0; /* Number of records Processed */
31
32 G_ERROR_COUNT Integer := 0; /* Number of records with Errors */
33
34 --Bug 7566697
35 --This flag will be used for Mass Change.
36 --If in a pricing call, error occuress, then whole order would be rolled back using this flag
37 G_PRICING_ERROR VARCHAR2(1) := 'N';
38
39 -- 4020312
40 TYPE Sel_Rec_Tbl IS TABLE OF OE_GLOBALS.Selected_Record_Type;
41
42 Procedure Process_Order_Scalar(
43 p_num_of_records IN NUMBER
44 , p_sel_rec_tbl IN Oe_Globals.Selected_Record_Tbl
45 , p_multi_OU IN Boolean
46 --, p_record_ids IN VARCHAR2
47 , p_change_reason IN VARCHAR2
48 , p_change_comments IN VARCHAR2
49 , p_msg_count OUT NOCOPY NUMBER
50 , p_msg_data OUT NOCOPY VARCHAR2
51 , p_return_status OUT NOCOPY VARCHAR2
52 , p_mc_err_handling_flag IN NUMBER DEFAULT FND_API.G_MISS_NUM
53 , p_error_count OUT NOCOPY NUMBER
54 , p_accounting_rule_id IN NUMBER
55 , p_accounting_rule_duration IN NUMBER
56 , p_agreement_id IN NUMBER
57 , p_attribute1 IN VARCHAR2
58 , p_attribute10 IN VARCHAR2
59 , p_attribute11 IN VARCHAR2
60 , p_attribute12 IN VARCHAR2
61 , p_attribute13 IN VARCHAR2
62 , p_attribute14 IN VARCHAR2
63 , p_attribute15 IN VARCHAR2
64 , p_attribute16 IN VARCHAR2 --For bug 2184255
65 , p_attribute17 IN VARCHAR2
66 , p_attribute18 IN VARCHAR2
67 , p_attribute19 IN VARCHAR2
68 , p_attribute2 IN VARCHAR2
69 , p_attribute20 IN VARCHAR2
70 , p_attribute3 IN VARCHAR2
71 , p_attribute4 IN VARCHAR2
72 , p_attribute5 IN VARCHAR2
73 , p_attribute6 IN VARCHAR2
74 , p_attribute7 IN VARCHAR2
75 , p_attribute8 IN VARCHAR2
76 , p_attribute9 IN VARCHAR2
77 , p_blanket_number IN NUMBER
78 , p_context IN VARCHAR2
79 , p_conversion_rate IN NUMBER
80 , p_conversion_rate_date IN DATE
81 , p_conversion_type_code IN VARCHAR2
82 , p_cust_po_number IN VARCHAR2
83 , p_deliver_to_contact_id IN NUMBER
84 , p_deliver_to_org_id IN NUMBER
85 , p_demand_class_code IN VARCHAR2
86 , p_expiration_date IN DATE
87 , p_earliest_schedule_limit IN NUMBER
88 , p_fob_point_code IN VARCHAR2
89 , p_freight_carrier_code IN VARCHAR2
90 , p_freight_terms_code IN VARCHAR2
91 , p_global_attribute1 IN VARCHAR2
92 , p_global_attribute10 IN VARCHAR2
93 , p_global_attribute11 IN VARCHAR2
94 , p_global_attribute12 IN VARCHAR2
95 , p_global_attribute13 IN VARCHAR2
96 , p_global_attribute14 IN VARCHAR2
97 , p_global_attribute15 IN VARCHAR2
98 , p_global_attribute16 IN VARCHAR2
99 , p_global_attribute17 IN VARCHAR2
100 , p_global_attribute18 IN VARCHAR2
101 , p_global_attribute19 IN VARCHAR2
102 , p_global_attribute2 IN VARCHAR2
103 , p_global_attribute20 IN VARCHAR2
104 , p_global_attribute3 IN VARCHAR2
105 , p_global_attribute4 IN VARCHAR2
106 , p_global_attribute5 IN VARCHAR2
107 , p_global_attribute6 IN VARCHAR2
108 , p_global_attribute7 IN VARCHAR2
109 , p_global_attribute8 IN VARCHAR2
110 , p_global_attribute9 IN VARCHAR2
111 , p_global_attribute_category IN VARCHAR2
112 , p_header_id IN NUMBER
113 , p_invoice_to_contact_id IN NUMBER
114 , p_invoice_to_org_id IN NUMBER
115 , p_invoicing_rule_id IN NUMBER
116 , p_latest_schedule_limit IN NUMBER
117 , p_ordered_date IN DATE
118 , p_order_date_type_code IN VARCHAR2
119 , p_order_number IN NUMBER
120 , p_order_source_id IN NUMBER
121 , p_order_type_id IN NUMBER
122 , p_org_id IN NUMBER
123 , p_orig_sys_document_ref IN VARCHAR2
124 , p_partial_shipments_allowed IN VARCHAR2
125 , p_payment_term_id IN NUMBER
126 , p_price_list_id IN NUMBER
127 , p_pricing_date IN DATE
128 , p_request_date IN DATE
129 , p_shipment_priority_code IN VARCHAR2
130 , p_shipping_method_code IN VARCHAR2
131 , p_ship_from_org_id IN NUMBER
132 , p_ship_tolerance_above IN NUMBER
133 , p_ship_tolerance_below IN NUMBER
134 , p_ship_to_contact_id IN NUMBER
135 , p_ship_to_org_id IN NUMBER
136 , p_sold_to_contact_id IN NUMBER
137 , p_sold_to_org_id IN NUMBER
138 , p_source_document_id IN NUMBER
139 , p_source_document_type_id IN NUMBER
140 , p_tax_exempt_flag IN VARCHAR2
141 , p_tax_exempt_number IN VARCHAR2
142 , p_tax_exempt_reason_code IN VARCHAR2
143 , p_tax_point_code IN VARCHAR2
144 , p_transactional_curr_code IN VARCHAR2
145 , p_version_number IN NUMBER
146 , p_accounting_rule IN VARCHAR2
147 , p_agreement IN VARCHAR2
148 , p_conversion_type IN VARCHAR2
149 , p_deliver_to_address1 IN VARCHAR2
150 , p_deliver_to_address2 IN VARCHAR2
151 , p_deliver_to_address3 IN VARCHAR2
152 , p_deliver_to_address4 IN VARCHAR2
153 , p_deliver_to_contact IN VARCHAR2
154 , p_deliver_to_location IN VARCHAR2
155 , p_deliver_to_org IN VARCHAR2
156 , p_fob_point IN VARCHAR2
157 , p_freight_terms IN VARCHAR2
158 , p_invoice_to_address1 IN VARCHAR2
159 , p_invoice_to_address2 IN VARCHAR2
160 , p_invoice_to_address3 IN VARCHAR2
161 , p_invoice_to_address4 IN VARCHAR2
162 , p_invoice_to_contact IN VARCHAR2
163 , p_invoice_to_location IN VARCHAR2
164 , p_invoice_to_org IN VARCHAR2
165 , p_invoicing_rule IN VARCHAR2
166 , p_order_source IN VARCHAR2
167 , p_order_type IN VARCHAR2
168 , p_payment_term IN VARCHAR2
169 , p_price_list IN VARCHAR2
170 , p_shipment_priority IN VARCHAR2
171 , p_ship_from_address1 IN VARCHAR2
172 , p_ship_from_address2 IN VARCHAR2
173 , p_ship_from_address3 IN VARCHAR2
174 , p_ship_from_address4 IN VARCHAR2
175 , p_ship_from_location IN VARCHAR2
176 , p_ship_from_org IN VARCHAR2
177 , p_ship_to_address1 IN VARCHAR2
178 , p_ship_to_address2 IN VARCHAR2
179 , p_ship_to_address3 IN VARCHAR2
180 , p_ship_to_address4 IN VARCHAR2
181 , p_ship_to_contact IN VARCHAR2
182 , p_ship_to_location IN VARCHAR2
183 , p_ship_to_org IN VARCHAR2
184 , p_sold_to_contact IN VARCHAR2
185 , p_sold_to_org IN VARCHAR2
186 , p_tax_exempt IN VARCHAR2
187 , p_tax_exempt_reason IN VARCHAR2
188 , p_tax_point IN VARCHAR2
189 , p_salesrep_id IN NUMBER
190 , p_return_reason_code IN VARCHAR2
191 , p_salesrep IN VARCHAR2
192 , p_return_reason IN VARCHAR2
193 , p_payment_type_code IN VARCHAR2
194 , p_payment_amount IN NUMBER
195 , p_check_number IN VARCHAR2
196 , p_credit_card_code IN VARCHAR2
197 , p_credit_card_holder_name IN VARCHAR2
198 , p_credit_card_number IN VARCHAR2
199 , p_instrument_Security_code IN VARCHAR2 --bug 5191301
200 , p_credit_card_expiration_date IN DATE
201 , p_credit_card_approval_date IN DATE
202 , p_credit_card_approval_code IN VARCHAR2
203 , p_payment_type IN VARCHAR2
204 , p_credit_card IN VARCHAR2
205 , p_first_ack_code IN VARCHAR2
206 , p_first_ack_date IN DATE
207 , p_last_ack_code IN VARCHAR2
208 , p_last_ack_date IN DATE
209 , p_tp_attribute1 IN VARCHAR2
210 , p_tp_attribute10 IN VARCHAR2
211 , p_tp_attribute11 IN VARCHAR2
212 , p_tp_attribute12 IN VARCHAR2
213 , p_tp_attribute13 IN VARCHAR2
214 , p_tp_attribute14 IN VARCHAR2
215 , p_tp_attribute15 IN VARCHAR2
216 , p_tp_attribute2 IN VARCHAR2
217 , p_tp_attribute3 IN VARCHAR2
218 , p_tp_attribute4 IN VARCHAR2
219 , p_tp_attribute5 IN VARCHAR2
220 , p_tp_attribute6 IN VARCHAR2
221 , p_tp_attribute7 IN VARCHAR2
222 , p_tp_attribute8 IN VARCHAR2
223 , p_tp_attribute9 IN VARCHAR2
224 , p_tp_context IN VARCHAR2
225 , p_shipping_instructions IN VARCHAR2
226 , p_packing_instructions IN VARCHAR2
227 , p_sales_channel_code IN VARCHAR2
228 --My Addition
229 , p_sold_to_address1 IN VARCHAR2
230 , p_sold_to_address2 IN VARCHAR2
231 , p_sold_to_address3 IN VARCHAR2
232 , p_sold_to_address4 IN VARCHAR2
233 , p_sold_to_location IN VARCHAR2
234 , p_sold_to_site_use_id IN NUMBER
235 -- end customer changes
236 , p_end_customer_contact_id IN NUMBER
237 , p_end_customer_id IN NUMBER
238 , p_end_customer_site_use_id IN NUMBER
239 , p_end_customer_address1 IN VARCHAR2
240 , p_end_customer_address2 IN VARCHAR2
241 , p_end_customer_address3 IN VARCHAR2
242 , p_end_customer_address4 IN VARCHAR2
243 , p_end_customer_contact IN VARCHAR2
244 , p_end_customer_location IN VARCHAR2
245 , p_ib_owner IN VARCHAR2
246 , p_ib_installed_at_location IN VARCHAR2
247 , p_ib_current_location IN VARCHAR2
248 , p_cascade_header_changes IN VARCHAR2 DEFAULT 'N'
249 );
250 -- bug4529937
251 Function Lines_Remaining return Varchar2;
252
253 Procedure Process_Line_Scalar(
254 p_num_of_records IN NUMBER
255 , p_sel_rec_tbl IN Oe_Globals.Selected_Record_Tbl --MOAC PI
256 , p_multi_OU IN Boolean --MOAC PI
257 --, p_record_ids IN VARCHAR2 --MOAC PI
258 , p_change_reason IN VARCHAR2
259 , p_change_comments IN VARCHAR2
260 , p_msg_count OUT NOCOPY NUMBER
261 , p_msg_data OUT NOCOPY VARCHAR2
262 , p_return_status OUT NOCOPY VARCHAR2
263 , p_mc_err_handling_flag IN NUMBER DEFAULT FND_API.G_MISS_NUM
264 , p_error_count OUT NOCOPY NUMBER
265 , p_header_id IN NUMBER
266 , p_accounting_rule_id IN NUMBER
267 , p_accounting_rule_duration IN NUMBER
268 , p_actual_arrival_date IN DATE
269 , p_actual_shipment_date IN DATE
270 , p_agreement_id IN NUMBER
271 , p_ato_line_id IN NUMBER
272 , p_attribute1 IN VARCHAR2
273 , p_attribute10 IN VARCHAR2
274 , p_attribute11 IN VARCHAR2
275 , p_attribute12 IN VARCHAR2
276 , p_attribute13 IN VARCHAR2
277 , p_attribute14 IN VARCHAR2
278 , p_attribute15 IN VARCHAR2
279 , p_attribute16 IN VARCHAR2 --For bug 2184255
280 , p_attribute17 IN VARCHAR2
281 , p_attribute18 IN VARCHAR2
282 , p_attribute19 IN VARCHAR2
283 , p_attribute2 IN VARCHAR2
284 , p_attribute20 IN VARCHAR2
285 , p_attribute3 IN VARCHAR2
286 , p_attribute4 IN VARCHAR2
287 , p_attribute5 IN VARCHAR2
288 , p_attribute6 IN VARCHAR2
289 , p_attribute7 IN VARCHAR2
290 , p_attribute8 IN VARCHAR2
291 , p_attribute9 IN VARCHAR2
292 , p_blanket_number IN NUMBER
293 , p_blanket_line_number IN NUMBER
294 , p_blanket_version_number IN NUMBER
295 , p_context IN VARCHAR2
296 , p_auto_selected_quantity IN NUMBER
297 , p_cancelled_quantity In NUMBER
298 , p_component_code IN VARCHAR2
299 , p_component_number IN NUMBER
300 , p_component_sequence_id IN NUMBER
301 , p_config_display_sequence IN NUMBER
302 , p_configuration_id IN NUMBER
303 , p_config_header_id IN NUMBER
304 , p_config_rev_nbr IN NUMBER
305 , p_credit_invoice_line_id IN NUMBER
306 , p_customer_dock_code IN VARCHAR2
307 , p_customer_job IN VARCHAR2
308 , p_customer_production_line IN VARCHAR2
309 , p_customer_trx_line_id IN NUMBER
310 , p_cust_model_serial_number IN VARCHAR2
311 , p_cust_po_number IN VARCHAR2
312 , p_delivery_lead_time IN NUMBER
313 , p_deliver_to_contact_id IN NUMBER
314 , p_deliver_to_org_id IN NUMBER
315 , p_demand_bucket_type_code IN VARCHAR2
316 , p_demand_class_code IN VARCHAR2
317 , p_dep_plan_required_flag IN VARCHAR2
318 , p_earliest_acceptable_date IN DATE
319 , p_explosion_date IN DATE
320 , p_fob_point_code IN VARCHAR2
321 , p_freight_carrier_code IN VARCHAR2
322 , p_freight_terms_code IN VARCHAR2
323 , p_fulfilled_quantity IN NUMBER
324 , p_global_attribute1 IN VARCHAR2
325 , p_global_attribute10 IN VARCHAR2
326 , p_global_attribute11 IN VARCHAR2
327 , p_global_attribute12 IN VARCHAR2
328 , p_global_attribute13 IN VARCHAR2
329 , p_global_attribute14 IN VARCHAR2
330 , p_global_attribute15 IN VARCHAR2
331 , p_global_attribute16 IN VARCHAR2
332 , p_global_attribute17 IN VARCHAR2
333 , p_global_attribute18 IN VARCHAR2
334 , p_global_attribute19 IN VARCHAR2
335 , p_global_attribute2 IN VARCHAR2
336 , p_global_attribute20 IN VARCHAR2
337 , p_global_attribute3 IN VARCHAR2
338 , p_global_attribute4 IN VARCHAR2
339 , p_global_attribute5 IN VARCHAR2
340 , p_global_attribute6 IN VARCHAR2
341 , p_global_attribute7 IN VARCHAR2
342 , p_global_attribute8 IN VARCHAR2
343 , p_global_attribute9 IN VARCHAR2
344 , p_global_attribute_category IN VARCHAR2
345 , p_industry_attribute1 IN VARCHAR2
346 , p_industry_attribute10 IN VARCHAR2
347 , p_industry_attribute11 IN VARCHAR2
348 , p_industry_attribute12 IN VARCHAR2
349 , p_industry_attribute13 IN VARCHAR2
350 , p_industry_attribute14 IN VARCHAR2
351 , p_industry_attribute15 IN VARCHAR2
352 , p_industry_attribute2 IN VARCHAR2
353 , p_industry_attribute3 IN VARCHAR2
354 , p_industry_attribute4 IN VARCHAR2
355 , p_industry_attribute5 IN VARCHAR2
356 , p_industry_attribute6 IN VARCHAR2
357 , p_industry_attribute7 IN VARCHAR2
358 , p_industry_attribute8 IN VARCHAR2
359 , p_industry_attribute9 IN VARCHAR2
360 , p_industry_context IN VARCHAR2
361 , p_intermed_ship_to_contact_id IN NUMBER
362 , p_intermed_ship_to_org_id IN NUMBER
363 , p_inventory_item_id IN NUMBER
364 , p_invoice_interface_status IN VARCHAR2
365 , p_invoice_to_contact_id IN NUMBER
366 , p_invoice_to_org_id IN NUMBER
367 , p_invoicing_rule_id IN NUMBER
368 , p_ordered_item_id IN NUMBER
369 , p_item_identifier_type IN VARCHAR2
370 , p_ordered_item IN VARCHAR2
371 , p_item_revision IN VARCHAR2
372 , p_item_type_code IN VARCHAR2
373 , p_latest_acceptable_date IN DATE
374 , p_line_category_code IN VARCHAR2
375 , p_line_id IN NUMBER
376 , p_line_number IN NUMBER
377 , p_line_type_id IN NUMBER
378 , p_link_to_line_id IN NUMBER
379 , p_model_group_number IN NUMBER
380 , p_option_flag IN VARCHAR2
381 , p_option_number IN NUMBER
382 , p_ordered_quantity IN NUMBER
383 , p_order_quantity_uom IN VARCHAR2
384 , p_org_id IN NUMBER
385 , p_orig_sys_document_ref IN VARCHAR2
386 , p_orig_sys_line_ref IN VARCHAR2
387 , p_payment_term_id IN NUMBER
388 , p_price_list_id IN NUMBER
389 , p_pricing_attribute1 IN VARCHAR2
390 , p_pricing_attribute10 IN VARCHAR2
391 , p_pricing_attribute2 IN VARCHAR2
392 , p_pricing_attribute3 IN VARCHAR2
393 , p_pricing_attribute4 IN VARCHAR2
394 , p_pricing_attribute5 IN VARCHAR2
395 , p_pricing_attribute6 IN VARCHAR2
396 , p_pricing_attribute7 IN VARCHAR2
397 , p_pricing_attribute8 IN VARCHAR2
398 , p_pricing_attribute9 IN VARCHAR2
399 , p_pricing_context IN VARCHAR2
400 , p_pricing_date IN DATE
401 , p_pricing_quantity IN NUMBER
402 , p_pricing_quantity_uom IN VARCHAR2
403 , p_project_id IN NUMBER
404 , p_promise_date IN DATE
405 , p_reference_header_id IN NUMBER
406 , p_reference_line_id IN NUMBER
407 , p_reference_type IN VARCHAR2
408 , p_request_date IN DATE
409 , p_reserved_quantity IN NUMBER
410 , p_return_attribute1 IN VARCHAR2
411 , p_return_attribute10 IN VARCHAR2
412 , p_return_attribute11 IN VARCHAR2
413 , p_return_attribute12 IN VARCHAR2
414 , p_return_attribute13 IN VARCHAR2
415 , p_return_attribute14 IN VARCHAR2
416 , p_return_attribute15 IN VARCHAR2
417 , p_return_attribute2 IN VARCHAR2
418 , p_return_attribute3 IN VARCHAR2
419 , p_return_attribute4 IN VARCHAR2
420 , p_return_attribute5 IN VARCHAR2
421 , p_return_attribute6 IN VARCHAR2
422 , p_return_attribute7 IN VARCHAR2
423 , p_return_attribute8 IN VARCHAR2
424 , p_return_attribute9 IN VARCHAR2
425 , p_return_context IN VARCHAR2
426 , p_rla_schedule_type_code IN VARCHAR2
427 , p_schedule_arrival_date IN DATE
428 , p_schedule_ship_date IN DATE
429 , p_schedule_action_code IN VARCHAR2
430 , p_schedule_status_code IN VARCHAR2
431 , p_shipment_number IN NUMBER
432 , p_shipment_priority_code IN VARCHAR2
433 , p_shipped_quantity IN NUMBER
434 , p_shipping_method_code IN VARCHAR2
435 , p_shipping_quantity IN NUMBER
436 , p_shipping_quantity_uom IN VARCHAR2
437 , p_ship_from_org_id IN NUMBER
438 , p_ship_tolerance_above IN NUMBER
439 , p_ship_tolerance_below IN NUMBER
440 , p_shipping_interfaced_flag IN VARCHAR2
441 , p_ship_to_contact_id IN NUMBER
442 , p_ship_to_org_id IN NUMBER
443 , p_ship_model_complete_flag IN VARCHAR2
444 , p_sold_to_org_id IN NUMBER
445 , p_sort_order IN VARCHAR2
446 , p_source_document_id IN NUMBER
447 , p_source_document_line_id IN NUMBER
448 , p_source_document_type_id IN NUMBER
449 , p_source_type_code IN VARCHAR2
450 , p_task_id IN NUMBER
451 , p_tax_code IN VARCHAR2
452 , p_tax_date IN DATE
453 , p_tax_exempt_flag IN VARCHAR2
454 , p_tax_exempt_number IN VARCHAR2
455 , p_tax_exempt_reason_code IN VARCHAR2
456 , p_tax_point_code IN VARCHAR2
457 , p_tax_rate IN NUMBER
458 , p_tax_value IN NUMBER
459 , p_top_model_line_id IN NUMBER
460 , p_unit_list_price IN NUMBER
461 , p_unit_selling_price IN NUMBER
462 , p_visible_demand_flag IN VARCHAR2
463 , p_accounting_rule IN VARCHAR2
464 , p_agreement IN VARCHAR2
465 , p_customer_item IN VARCHAR2
466 , p_deliver_to_address1 IN VARCHAR2
467 , p_deliver_to_address2 IN VARCHAR2
468 , p_deliver_to_address3 IN VARCHAR2
469 , p_deliver_to_address4 IN VARCHAR2
470 , p_deliver_to_contact IN VARCHAR2
471 , p_deliver_to_location IN VARCHAR2
472 , p_deliver_to_org IN VARCHAR2
473 , p_demand_bucket_type IN VARCHAR2
474 , p_fob_point IN VARCHAR2
475 , p_freight_terms IN VARCHAR2
476 , p_inventory_item IN VARCHAR2
477 , p_invoice_to_address1 IN VARCHAR2
478 , p_invoice_to_address2 IN VARCHAR2
479 , p_invoice_to_address3 IN VARCHAR2
480 , p_invoice_to_address4 IN VARCHAR2
481 , p_invoice_to_contact IN VARCHAR2
482 , p_invoice_to_location IN VARCHAR2
483 , p_invoice_to_org IN VARCHAR2
484 , p_invoicing_rule IN VARCHAR2
485 , p_intermed_ship_to_address1 IN VARCHAR2
486 , p_intermed_ship_to_address2 IN VARCHAR2
487 , p_intermed_ship_to_address3 IN VARCHAR2
488 , p_intermed_ship_to_address4 IN VARCHAR2
489 , p_intermed_ship_to_contact IN VARCHAR2
490 , p_intermed_ship_to_location IN VARCHAR2
491 , p_intermed_ship_to_org IN VARCHAR2
492 , p_item IN VARCHAR2
493 , p_item_type IN VARCHAR2
494 , p_line_type IN VARCHAR2
495 , p_payment_term IN VARCHAR2
496 , p_price_list IN VARCHAR2
497 , p_project IN VARCHAR2
498 , p_rla_schedule_type IN VARCHAR2
499 , p_shipment_priority IN VARCHAR2
500 , p_ship_from_address1 IN VARCHAR2
501 , p_ship_from_address2 IN VARCHAR2
502 , p_ship_from_address3 IN VARCHAR2
503 , p_ship_from_address4 IN VARCHAR2
504 , p_ship_from_location IN VARCHAR2
505 , p_ship_from_org IN VARCHAR2
506 , p_ship_to_address1 IN VARCHAR2
507 , p_ship_to_address2 IN VARCHAR2
508 , p_ship_to_address3 IN VARCHAR2
509 , p_ship_to_address4 IN VARCHAR2
510 , p_ship_to_contact IN VARCHAR2
511 , p_ship_to_location IN VARCHAR2
512 , p_ship_to_org IN VARCHAR2
513 , p_sold_to_org IN VARCHAR2
514 , p_task IN VARCHAR2
515 , p_tax_exempt IN VARCHAR2
516 , p_tax_exempt_reason IN VARCHAR2
517 , p_tax_point IN VARCHAR2
518 , p_split_from_line_id IN NUMBER
519 , p_cust_production_seq_num IN VARCHAR2
520 , p_authorized_to_ship_flag IN VARCHAR2
521 , p_veh_cus_item_cum_key_id IN NUMBER
522 , p_salesrep_id IN NUMBER
523 , p_return_reason_code IN VARCHAR2
524 , p_arrival_set_id IN NUMBER
525 , p_ship_set_id IN NUMBER
526 , p_over_ship_reason_code IN VARCHAR2
527 , p_over_ship_resolved_flag IN VARCHAR2
528 , p_industry_attribute16 IN VARCHAR2
529 , p_industry_attribute17 IN VARCHAR2
530 , p_industry_attribute18 IN VARCHAR2
531 , p_industry_attribute19 IN VARCHAR2
532 , p_industry_attribute20 IN VARCHAR2
533 , p_industry_attribute21 IN VARCHAR2
534 , p_industry_attribute22 IN VARCHAR2
535 , p_industry_attribute23 IN VARCHAR2
536 , p_industry_attribute24 IN VARCHAR2
537 , p_industry_attribute25 IN VARCHAR2
538 , p_industry_attribute26 IN VARCHAR2
539 , p_industry_attribute27 IN VARCHAR2
540 , p_industry_attribute28 IN VARCHAR2
541 , p_industry_attribute29 IN VARCHAR2
542 , p_industry_attribute30 IN VARCHAR2
543 , p_veh_cus_item_cum_key IN VARCHAR2
544 , p_salesrep IN VARCHAR2
545 , p_return_reason IN VARCHAR2
546 , p_delivery IN VARCHAR2
547 , p_arrival_set IN VARCHAR2
548 , p_ship_set IN VARCHAR2
549 , p_over_ship_reason IN VARCHAR2
550 , p_first_ack_code IN VARCHAR2
551 , p_first_ack_date IN DATE
552 , p_last_ack_code IN VARCHAR2
553 , p_last_ack_date IN DATE
554 , p_service_txn_reason_code IN VARCHAR2
555 , p_service_txn_comments IN VARCHAR2
556 , p_unit_selling_percent IN NUMBER
557 , p_unit_list_percent IN NUMBER
558 , p_unit_percent_base_price IN NUMBER
559 , p_service_duration IN NUMBER
560 , p_service_period IN VARCHAR2
561 , p_service_start_date IN DATE
562 , p_service_end_date IN DATE
563 , p_service_coterminate_flag IN VARCHAR2
564 , p_service_number IN NUMBER
565 , p_service_reference_type_code IN VARCHAR2
566 , p_service_reference_line_id IN NUMBER
567 , p_service_reference_system_id IN NUMBER
568 , p_tp_attribute1 IN VARCHAR2
569 , p_tp_attribute10 IN VARCHAR2
570 , p_tp_attribute11 IN VARCHAR2
571 , p_tp_attribute12 IN VARCHAR2
572 , p_tp_attribute13 IN VARCHAR2
573 , p_tp_attribute14 IN VARCHAR2
574 , p_tp_attribute15 IN VARCHAR2
575 , p_tp_attribute2 IN VARCHAR2
576 , p_tp_attribute3 IN VARCHAR2
577 , p_tp_attribute4 IN VARCHAR2
578 , p_tp_attribute5 IN VARCHAR2
579 , p_tp_attribute6 IN VARCHAR2
580 , p_tp_attribute7 IN VARCHAR2
581 , p_tp_attribute8 IN VARCHAR2
582 , p_tp_attribute9 IN VARCHAR2
583 , p_tp_context IN VARCHAR2
584 , p_shipping_instructions IN VARCHAR2
585 , p_packing_instructions IN VARCHAR2
586 , p_planning_priority IN VARCHAR2
587 , p_calculate_price_flag IN VARCHAR2
588 --end custoemr chagnes
589 , p_end_customer_contact_id IN NUMBER
590 , p_end_customer_id IN NUMBER
591 , p_end_customer_site_use_id IN NUMBER
592 , p_end_customer_address1 IN VARCHAR2
593 , p_end_customer_address2 IN VARCHAR2
594 , p_end_customer_address3 IN VARCHAR2
595 , p_end_customer_address4 IN VARCHAR2
596 , p_end_customer_contact IN VARCHAR2
597 , p_end_customer_location IN VARCHAR2
598 , p_ib_owner IN VARCHAR2
599 , p_ib_installed_at_location IN VARCHAR2
600 , p_ib_current_location IN VARCHAR2
601 , p_block_name IN VARCHAR2 DEFAULT NULL -- bug4529937
602 --sol_ord_er #16014165 Start
603 , p_service_bill_profile_id IN NUMBER DEFAULT NULL
604 , p_service_bill_option_code IN varchar2 DEFAULT NULL
605 , p_service_cov_template_id IN NUMBER DEFAULT NULL
606 , p_service_subs_template_id IN NUMBER DEFAULT NULL
607 --sol_ord_er #16014165 end
608 );
609
610 Procedure save_messages;
611
612 Procedure insert_message (
613 p_msg_index IN NUMBER );
614
615
616 Procedure MC_Rollback;
617
618 Procedure Set_Counter;
619
620 Function Get_Counter return NUMBER;
621
622 Procedure Set_Error_Count;
623
624 Function Get_Error_Count return NUMBER;
625
626 -- 4020312
627 FUNCTION get_sel_rec_tbl RETURN Sel_Rec_Tbl PIPELINED;
628
629 END OE_MASS_CHANGE_PVT;
[Home] [Help]