[Home] [Help]
PACKAGE BODY: APPS.OE_BULK_LINE_UTIL
Source
1 PACKAGE BODY OE_BULK_LINE_UTIL AS
2 /* $Header: OEBULINB.pls 120.5.12010000.5 2008/11/30 21:44:21 smusanna ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_LINE_UTIL';
5
6
7 TYPE Kit_Item_Rec_Type IS RECORD
8 ( ii_count NUMBER
9 , ii_start_index NUMBER
10 );
11
12 TYPE Kit_Item_Tbl_Type IS TABLE OF Kit_Item_Rec_Type
13 INDEX BY BINARY_INTEGER;
14
15 TYPE Inc_Item_Rec_Type IS RECORD
16 ( component_code VARCHAR2(30)
17 , component_sequence_id NUMBER
18 , component_item_id NUMBER
19 , extended_quantity NUMBER
20 , primary_uom_code VARCHAR2(3)
21 , ordered_item VARCHAR2(30)
22 , sort_order VARCHAR2(2000) -- 4336446
23 , shippable_flag VARCHAR2(1)
24 );
25 TYPE Inc_Item_Tbl_Type IS TABLE OF Inc_Item_Rec_Type
26 INDEX BY BINARY_INTEGER;
27
28 G_KIT_ITEM_TBL Kit_Item_Tbl_Type;
29 G_INC_ITEM_TBL Inc_Item_Tbl_Type;
30
31 ---------------------------------------------------------------------
32 -- PROCEDURE Load_Lines
33 --
34 -- Loads order lines in the batch from interface tables to
35 -- the record - p_line_rec
36 ---------------------------------------------------------------------
37
38 PROCEDURE Load_Lines
39 ( p_batch_id IN NUMBER
40 ,p_process_configurations IN VARCHAR2
41 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
42 )
43 IS
44
45 CURSOR c_lines IS
46 SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
47 L.ACCOUNTING_RULE_ID
48 , L.ACCOUNTING_RULE_DURATION
49 , L.ACTUAL_ARRIVAL_DATE
50 -- , L.ACTUAL_SHIPMENT_DATE
51 , L.AGREEMENT_ID
52 , L.ARRIVAL_SET_ID
53 , L.ATO_LINE_ID
54 , L.ATTRIBUTE1
55 , L.ATTRIBUTE10
56 , L.ATTRIBUTE11
57 , L.ATTRIBUTE12
58 , L.ATTRIBUTE13
59 , L.ATTRIBUTE14
60 , L.ATTRIBUTE15
61 , L.ATTRIBUTE16 --For bug 2184255
62 , L.ATTRIBUTE17
63 , L.ATTRIBUTE18
64 , L.ATTRIBUTE19
65 , L.ATTRIBUTE2
66 , L.ATTRIBUTE20
67 , L.ATTRIBUTE3
68 , L.ATTRIBUTE4
69 , L.ATTRIBUTE5
70 , L.ATTRIBUTE6
71 , L.ATTRIBUTE7
72 , L.ATTRIBUTE8
73 , L.ATTRIBUTE9
74 -- , L.AUTO_SELECTED_QUANTITY
75 , L.AUTHORIZED_TO_SHIP_FLAG
76 , NULL -- L.BOOKED_FLAG
77 , 'N' -- L.CANCELLED_FLAG
78 , L.CANCELLED_QUANTITY
79 , L.COMPONENT_CODE
80 , NULL -- L.COMPONENT_NUMBER
81 , L.COMPONENT_SEQUENCE_ID
82 , L.CONFIG_HEADER_ID
83 , L.CONFIG_REV_NBR
84 ,null -- , L.CONFIG_DISPLAY_SEQUENCE
85 , L.CONFIGURATION_ID
86 , L.CONTEXT
87 -- , L.CREATED_BY
88 -- , L.CREATION_DATE
89 , L.CREDIT_INVOICE_LINE_ID
90 , L.CUSTOMER_DOCK_CODE
91 , L.CUSTOMER_JOB
92 , L.CUSTOMER_PRODUCTION_LINE
93 , L.CUST_PRODUCTION_SEQ_NUM
94 -- , L.CUSTOMER_TRX_LINE_ID
95 , L.CUST_MODEL_SERIAL_NUMBER
96 , L.CUSTOMER_PO_NUMBER
97 , L.CUSTOMER_LINE_NUMBER
98 , L.DELIVERY_LEAD_TIME
99 , L.DELIVER_TO_CONTACT_ID
100 , L.DELIVER_TO_ORG_ID
101 , L.DEMAND_BUCKET_TYPE_CODE
102 , L.DEMAND_CLASS_CODE
103 -- , L.DEP_PLAN_REQUIRED_FLAG
104 , L.EARLIEST_ACCEPTABLE_DATE
105 , L.END_ITEM_UNIT_NUMBER
106 , L.EXPLOSION_DATE
107 -- , L.FIRST_ACK_CODE
108 -- , L.FIRST_ACK_DATE
109 , L.FOB_POINT_CODE
110 , NULL --L.FREIGHT_CARRIER_CODE for bug 3610475
111 , L.FREIGHT_TERMS_CODE
112 -- , L.FULFILLED_QUANTITY
113 -- , L.FULFILLED_FLAG
114 -- , L.FULFILLMENT_METHOD_CODE
115 -- , L.FULFILLMENT_DATE
116 , L.GLOBAL_ATTRIBUTE1
117 , L.GLOBAL_ATTRIBUTE10
118 , L.GLOBAL_ATTRIBUTE11
119 , L.GLOBAL_ATTRIBUTE12
120 , L.GLOBAL_ATTRIBUTE13
121 , L.GLOBAL_ATTRIBUTE14
122 , L.GLOBAL_ATTRIBUTE15
123 , L.GLOBAL_ATTRIBUTE16
124 , L.GLOBAL_ATTRIBUTE17
125 , L.GLOBAL_ATTRIBUTE18
126 , L.GLOBAL_ATTRIBUTE19
127 , L.GLOBAL_ATTRIBUTE2
128 , L.GLOBAL_ATTRIBUTE20
129 , L.GLOBAL_ATTRIBUTE3
130 , L.GLOBAL_ATTRIBUTE4
131 , L.GLOBAL_ATTRIBUTE5
132 , L.GLOBAL_ATTRIBUTE6
133 , L.GLOBAL_ATTRIBUTE7
134 , L.GLOBAL_ATTRIBUTE8
135 , L.GLOBAL_ATTRIBUTE9
136 , L.GLOBAL_ATTRIBUTE_CATEGORY
137 , NULL -- L.HEADER_ID
138 , L.INDUSTRY_ATTRIBUTE1
139 , L.INDUSTRY_ATTRIBUTE10
140 , L.INDUSTRY_ATTRIBUTE11
141 , L.INDUSTRY_ATTRIBUTE12
142 , L.INDUSTRY_ATTRIBUTE13
143 , L.INDUSTRY_ATTRIBUTE14
144 , L.INDUSTRY_ATTRIBUTE15
145 , L.INDUSTRY_ATTRIBUTE16
146 , L.INDUSTRY_ATTRIBUTE17
147 , L.INDUSTRY_ATTRIBUTE18
148 , L.INDUSTRY_ATTRIBUTE19
149 , L.INDUSTRY_ATTRIBUTE20
150 , L.INDUSTRY_ATTRIBUTE21
151 , L.INDUSTRY_ATTRIBUTE22
152 , L.INDUSTRY_ATTRIBUTE23
153 , L.INDUSTRY_ATTRIBUTE24
154 , L.INDUSTRY_ATTRIBUTE25
155 , L.INDUSTRY_ATTRIBUTE26
156 , L.INDUSTRY_ATTRIBUTE27
157 , L.INDUSTRY_ATTRIBUTE28
158 , L.INDUSTRY_ATTRIBUTE29
159 , L.INDUSTRY_ATTRIBUTE30
160 , L.INDUSTRY_ATTRIBUTE2
161 , L.INDUSTRY_ATTRIBUTE3
162 , L.INDUSTRY_ATTRIBUTE4
163 , L.INDUSTRY_ATTRIBUTE5
164 , L.INDUSTRY_ATTRIBUTE6
165 , L.INDUSTRY_ATTRIBUTE7
166 , L.INDUSTRY_ATTRIBUTE8
167 , L.INDUSTRY_ATTRIBUTE9
168 , L.INDUSTRY_CONTEXT
169 -- , L.INTERMED_SHIP_TO_CONTACT_ID
170 -- , L.INTERMED_SHIP_TO_ORG_ID
171 , L.INVENTORY_ITEM_ID
172 -- , L.INVOICE_INTERFACE_STATUS_CODE
173 , L.INVOICE_TO_CONTACT_ID
174 , L.INVOICE_TO_ORG_ID
175 -- , L.INVOICED_QUANTITY
176 , L.INVOICING_RULE_ID
177 , L.CUSTOMER_ITEM_ID -- L.ORDERED_ITEM_ID
178 , L.CUSTOMER_ITEM_ID_TYPE -- L.ITEM_IDENTIFIER_TYPE
179 , L.CUSTOMER_ITEM_NAME -- L.ORDERED_ITEM
180 , L.CUSTOMER_ITEM_NET_PRICE
181 , L.CUSTOMER_PAYMENT_TERM_ID
182 , L.ITEM_REVISION
183 , L.ITEM_TYPE_CODE
184 -- , L.LAST_ACK_CODE
185 -- , L.LAST_ACK_DATE
186 -- , L.LAST_UPDATED_BY
187 -- , L.LAST_UPDATE_DATE
188 -- , L.LAST_UPDATE_LOGIN
189 , L.LATEST_ACCEPTABLE_DATE
190 , NULL -- L.LINE_CATEGORY_CODE
191 -- Use pre-generated line_id value from interface tables
192 , L.LINE_ID
193 , L.LINE_NUMBER
194 , L.LINE_TYPE_ID
195 , NULL -- L.LINK_TO_LINE_ID
196 , L.MODEL_GROUP_NUMBER
197 , NULL -- L.MFG_LEAD_TIME
198 -- , L.OPEN_FLAG
199 , L.OPTION_FLAG
200 , L.OPTION_NUMBER
201 , L.ORDERED_QUANTITY
202 , L.ORDERED_QUANTITY2 --OPM 02/JUN/00
203 , L.ORDER_QUANTITY_UOM
204 , L.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
205 , L.ORG_ID
206 , L.ORIG_SYS_DOCUMENT_REF
207 , L.ORIG_SYS_LINE_REF
208 , L.ORIG_SYS_SHIPMENT_REF
209 , L.CHANGE_SEQUENCE
210 , L.OVER_SHIP_REASON_CODE
211 , L.OVER_SHIP_RESOLVED_FLAG
212 , L.PAYMENT_TERM_ID
213 -- , L.PLANNING_PRIORITY
214 , L.PREFERRED_GRADE --OPM HVOP
215 , L.PRICE_LIST_ID
216 -- , L.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
217 , L.PRICING_ATTRIBUTE1
218 , L.PRICING_ATTRIBUTE10
219 , L.PRICING_ATTRIBUTE2
220 , L.PRICING_ATTRIBUTE3
221 , L.PRICING_ATTRIBUTE4
222 , L.PRICING_ATTRIBUTE5
223 , L.PRICING_ATTRIBUTE6
224 , L.PRICING_ATTRIBUTE7
225 , L.PRICING_ATTRIBUTE8
226 , L.PRICING_ATTRIBUTE9
227 , L.PRICING_CONTEXT
228 , L.PRICING_DATE
229 , L.PRICING_QUANTITY
230 , L.PRICING_QUANTITY_UOM
231 -- , L.PROGRAM_APPLICATION_ID
232 -- , L.PROGRAM_ID
233 -- , L.PROGRAM_UPDATE_DATE
234 , L.PROJECT_ID
235 , L.PROMISE_DATE
236 , NULL -- L.RE_SOURCE_FLAG
237 -- , L.REFERENCE_CUSTOMER_TRX_LINE_ID
238 , L.REFERENCE_HEADER_ID
239 , L.REFERENCE_LINE_ID
240 , L.REFERENCE_TYPE
241 , L.REQUEST_DATE
242 , L.REQUEST_ID
243 , L.RETURN_ATTRIBUTE1
244 , L.RETURN_ATTRIBUTE10
245 , L.RETURN_ATTRIBUTE11
246 , L.RETURN_ATTRIBUTE12
247 , L.RETURN_ATTRIBUTE13
248 , L.RETURN_ATTRIBUTE14
249 , L.RETURN_ATTRIBUTE15
250 , L.RETURN_ATTRIBUTE2
251 , L.RETURN_ATTRIBUTE3
252 , L.RETURN_ATTRIBUTE4
253 , L.RETURN_ATTRIBUTE5
254 , L.RETURN_ATTRIBUTE6
255 , L.RETURN_ATTRIBUTE7
256 , L.RETURN_ATTRIBUTE8
257 , L.RETURN_ATTRIBUTE9
258 , L.RETURN_CONTEXT
259 , L.RETURN_REASON_CODE
260 -- , L.RLA_SCHEDULE_TYPE_CODE
261 , L.SALESREP_ID
262 , L.SCHEDULE_ARRIVAL_DATE
263 , L.SCHEDULE_SHIP_DATE
264 , L.SCHEDULE_STATUS_CODE
265 , L.SHIPMENT_NUMBER
266 , L.SHIPMENT_PRIORITY_CODE
267 , L.SHIPPED_QUANTITY
268 , L.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
269 , L.SHIPPING_METHOD_CODE
270 , L.SHIPPING_QUANTITY
271 , L.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
272 , L.SHIPPING_QUANTITY_UOM
273 , L.SHIP_FROM_ORG_ID
274 , L.SUBINVENTORY
275 , L.SHIP_SET_ID
276 , L.SHIP_TOLERANCE_ABOVE
277 , L.SHIP_TOLERANCE_BELOW
278 , NULL -- L.SHIPPABLE_FLAG
279 -- , L.SHIPPING_INTERFACED_FLAG
280 , L.SHIP_TO_CONTACT_ID
281 , L.SHIP_TO_ORG_ID
282 , L.SHIP_MODEL_COMPLETE_FLAG
283 , L.SOLD_TO_ORG_ID
284 , L.SOLD_FROM_ORG_ID
285 , L.SORT_ORDER
286 , NULL -- L.SOURCE_DOCUMENT_ID
287 -- , L.SOURCE_DOCUMENT_LINE_ID
288 -- , L.SOURCE_DOCUMENT_TYPE_ID
289 , L.SOURCE_TYPE_CODE
290 , L.SPLIT_FROM_LINE_ID
291 -- , L.LINE_SET_ID
292 -- , L.SPLIT_BY
293 ,'N' -- L.MODEL_REMNANT_FLAG
294 , L.TASK_ID
295 , L.TAX_CODE
296 , L.TAX_DATE
297 , L.TAX_EXEMPT_FLAG
298 , L.TAX_EXEMPT_NUMBER
299 , L.TAX_EXEMPT_REASON_CODE
300 , L.TAX_POINT_CODE
301 -- , L.TAX_RATE
302 , L.TAX_VALUE
303 , NULL -- L.TOP_MODEL_LINE_ID
304 , L.UNIT_LIST_PRICE
305 , L.UNIT_LIST_PRICE_PER_PQTY
306 , L.UNIT_SELLING_PRICE
307 , L.UNIT_SELLING_PRICE_PER_PQTY
308 , NULL -- L.VISIBLE_DEMAND_FLAG
309 , L.VEH_CUS_ITEM_CUM_KEY_ID
310 , L.SHIPPING_INSTRUCTIONS
311 , L.PACKING_INSTRUCTIONS
312 , L.SERVICE_TXN_REASON_CODE
313 , L.SERVICE_TXN_COMMENTS
314 , L.SERVICE_DURATION
315 , L.SERVICE_PERIOD
316 , L.SERVICE_START_DATE
317 , L.SERVICE_END_DATE
318 , L.SERVICE_COTERMINATE_FLAG
319 , L.UNIT_LIST_PERCENT
320 , L.UNIT_SELLING_PERCENT
321 , L.UNIT_PERCENT_BASE_PRICE
322 , L.SERVICE_NUMBER
323 , L.SERVICE_REFERENCE_TYPE_CODE
324 -- , L.SERVICE_REFERENCE_LINE_ID
325 -- , L.SERVICE_REFERENCE_SYSTEM_ID
326 , L.TP_CONTEXT
327 , L.TP_ATTRIBUTE1
328 , L.TP_ATTRIBUTE2
329 , L.TP_ATTRIBUTE3
330 , L.TP_ATTRIBUTE4
331 , L.TP_ATTRIBUTE5
332 , L.TP_ATTRIBUTE6
333 , L.TP_ATTRIBUTE7
334 , L.TP_ATTRIBUTE8
335 , L.TP_ATTRIBUTE9
336 , L.TP_ATTRIBUTE10
337 , L.TP_ATTRIBUTE11
338 , L.TP_ATTRIBUTE12
339 , L.TP_ATTRIBUTE13
340 , L.TP_ATTRIBUTE14
341 , L.TP_ATTRIBUTE15
342 -- , L.FLOW_STATUS_CODE
343 -- , L.MARKETING_SOURCE_CODE_ID
344 , L.CALCULATE_PRICE_FLAG
345 , L.COMMITMENT_ID
346 , L.ORDER_SOURCE_ID -- aksingh
347 -- , L.upgraded_flag
348 , 1 -- L.LOCK_CONTROL
349 , NULL -- wf_process_name
350 , NULL --- ii_start_index
351 , NULL -- ii_count
352 , L.user_item_description
353 , NULL -- parent_line_index
354 , NULL -- Firm Demand flag
355 -- end customer (Bug 5054618)
356 ,L.End_customer_contact_id
357 ,L.End_customer_id
358 ,L.End_customer_site_use_id
359 ,L.IB_owner_code
360 ,L.IB_current_location_code
361 ,L.IB_Installed_at_Location_code
362 , NULL -- cust_trx_type_id
363 , NULL -- tax_calculation_flag
364 , NULL -- ato_line_index
365 , NULL -- top_model_line_index
366 FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
367 WHERE h.batch_id = p_batch_id
368 AND h.order_source_id = l.order_source_id
369 AND h.orig_sys_document_ref = l.orig_sys_document_ref
370 AND nvl(h.error_flag,'N') = 'N'
371 AND nvl(l.error_flag,'N') = 'N'
372 AND nvl(l.rejected_flag,'N') = 'N'
373 AND NVL(h.Ineligible_for_hvop,'N')<>'Y'
374 ORDER BY l.order_source_id
375 ,l.orig_sys_document_ref
376 , l.orig_sys_line_ref
377 ,l.orig_sys_shipment_ref;
378
379 CURSOR c_lines_rtrim IS
380 SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
381 L.ACCOUNTING_RULE_ID
382 , L.ACCOUNTING_RULE_DURATION
383 , L.ACTUAL_ARRIVAL_DATE
384 -- , L.ACTUAL_SHIPMENT_DATE
385 , L.AGREEMENT_ID
386 , L.ARRIVAL_SET_ID
387 , L.ATO_LINE_ID
388 , L.ATTRIBUTE1
389 , L.ATTRIBUTE10
390 , L.ATTRIBUTE11
391 , L.ATTRIBUTE12
392 , L.ATTRIBUTE13
393 , L.ATTRIBUTE14
394 , L.ATTRIBUTE15
395 , L.ATTRIBUTE16 --For bug 2184255
396 , L.ATTRIBUTE17
397 , L.ATTRIBUTE18
398 , L.ATTRIBUTE19
399 , L.ATTRIBUTE2
400 , L.ATTRIBUTE20
401 , L.ATTRIBUTE3
402 , L.ATTRIBUTE4
403 , L.ATTRIBUTE5
404 , L.ATTRIBUTE6
405 , L.ATTRIBUTE7
406 , L.ATTRIBUTE8
407 , L.ATTRIBUTE9
408 -- , L.AUTO_SELECTED_QUANTITY
409 , L.AUTHORIZED_TO_SHIP_FLAG
410 , NULL -- L.BOOKED_FLAG
411 , 'N' -- L.CANCELLED_FLAG
412 , L.CANCELLED_QUANTITY
413 , L.COMPONENT_CODE
414 , NULL -- L.COMPONENT_NUMBER
415 , L.COMPONENT_SEQUENCE_ID
416 -- , L.CONFIG_HEADER_ID
417 -- , L.CONFIG_REV_NBR
418 -- , L.CONFIG_DISPLAY_SEQUENCE
419 -- , L.CONFIGURATION_ID
420 , L.CONTEXT
421 -- , L.CREATED_BY
422 -- , L.CREATION_DATE
423 , L.CREDIT_INVOICE_LINE_ID
424 , RTRIM(L.CUSTOMER_DOCK_CODE,' ') -- 3390458
425 , RTRIM(L.CUSTOMER_JOB, ' ') -- 3390458
426 , RTRIM(L.CUSTOMER_PRODUCTION_LINE, ' ') -- 3390458
427 , RTRIM(L.CUST_PRODUCTION_SEQ_NUM, ' ') -- 3390458
428 -- , L.CUSTOMER_TRX_LINE_ID
429 , RTRIM(L.CUST_MODEL_SERIAL_NUMBER,' ') -- 3390458
430 , RTRIM(L.CUSTOMER_PO_NUMBER,' ') -- 3390458
431 , L.CUSTOMER_LINE_NUMBER
432 , L.DELIVERY_LEAD_TIME
433 , L.DELIVER_TO_CONTACT_ID
434 , L.DELIVER_TO_ORG_ID
435 , L.DEMAND_BUCKET_TYPE_CODE
436 , L.DEMAND_CLASS_CODE
437 -- , L.DEP_PLAN_REQUIRED_FLAG
438 , L.EARLIEST_ACCEPTABLE_DATE
439 , RTRIM(L.END_ITEM_UNIT_NUMBER,' ') -- 3390458
440 , L.EXPLOSION_DATE
441 -- , L.FIRST_ACK_CODE
442 -- , L.FIRST_ACK_DATE
443 , L.FOB_POINT_CODE
444 , NULL --L.FREIGHT_CARRIER_CODE for bug 3610475
445 , L.FREIGHT_TERMS_CODE
446 -- , L.FULFILLED_QUANTITY
447 -- , L.FULFILLED_FLAG
448 -- , L.FULFILLMENT_METHOD_CODE
449 -- , L.FULFILLMENT_DATE
450 , L.GLOBAL_ATTRIBUTE1
451 , L.GLOBAL_ATTRIBUTE10
452 , L.GLOBAL_ATTRIBUTE11
453 , L.GLOBAL_ATTRIBUTE12
454 , L.GLOBAL_ATTRIBUTE13
455 , L.GLOBAL_ATTRIBUTE14
456 , L.GLOBAL_ATTRIBUTE15
457 , L.GLOBAL_ATTRIBUTE16
458 , L.GLOBAL_ATTRIBUTE17
459 , L.GLOBAL_ATTRIBUTE18
460 , L.GLOBAL_ATTRIBUTE19
461 , L.GLOBAL_ATTRIBUTE2
462 , L.GLOBAL_ATTRIBUTE20
463 , L.GLOBAL_ATTRIBUTE3
464 , L.GLOBAL_ATTRIBUTE4
465 , L.GLOBAL_ATTRIBUTE5
466 , L.GLOBAL_ATTRIBUTE6
467 , L.GLOBAL_ATTRIBUTE7
468 , L.GLOBAL_ATTRIBUTE8
469 , L.GLOBAL_ATTRIBUTE9
470 , L.GLOBAL_ATTRIBUTE_CATEGORY
471 , NULL -- L.HEADER_ID
472 , L.INDUSTRY_ATTRIBUTE1
473 , L.INDUSTRY_ATTRIBUTE10
474 , L.INDUSTRY_ATTRIBUTE11
475 , L.INDUSTRY_ATTRIBUTE12
476 , L.INDUSTRY_ATTRIBUTE13
477 , L.INDUSTRY_ATTRIBUTE14
478 , L.INDUSTRY_ATTRIBUTE15
479 , L.INDUSTRY_ATTRIBUTE16
480 , L.INDUSTRY_ATTRIBUTE17
481 , L.INDUSTRY_ATTRIBUTE18
482 , L.INDUSTRY_ATTRIBUTE19
483 , L.INDUSTRY_ATTRIBUTE20
484 , L.INDUSTRY_ATTRIBUTE21
485 , L.INDUSTRY_ATTRIBUTE22
486 , L.INDUSTRY_ATTRIBUTE23
487 , L.INDUSTRY_ATTRIBUTE24
488 , L.INDUSTRY_ATTRIBUTE25
489 , L.INDUSTRY_ATTRIBUTE26
490 , L.INDUSTRY_ATTRIBUTE27
491 , L.INDUSTRY_ATTRIBUTE28
492 , L.INDUSTRY_ATTRIBUTE29
493 , L.INDUSTRY_ATTRIBUTE30
494 , L.INDUSTRY_ATTRIBUTE2
495 , L.INDUSTRY_ATTRIBUTE3
496 , L.INDUSTRY_ATTRIBUTE4
497 , L.INDUSTRY_ATTRIBUTE5
498 , L.INDUSTRY_ATTRIBUTE6
499 , L.INDUSTRY_ATTRIBUTE7
500 , L.INDUSTRY_ATTRIBUTE8
501 , L.INDUSTRY_ATTRIBUTE9
502 , L.INDUSTRY_CONTEXT
503 -- , L.INTERMED_SHIP_TO_CONTACT_ID
504 -- , L.INTERMED_SHIP_TO_ORG_ID
505 , L.INVENTORY_ITEM_ID
506 -- , L.INVOICE_INTERFACE_STATUS_CODE
507 , L.INVOICE_TO_CONTACT_ID
508 , L.INVOICE_TO_ORG_ID
509 -- , L.INVOICED_QUANTITY
510 , L.INVOICING_RULE_ID
511 , L.CUSTOMER_ITEM_ID -- L.ORDERED_ITEM_ID
512 , L.CUSTOMER_ITEM_ID_TYPE -- L.ITEM_IDENTIFIER_TYPE
513 , L.CUSTOMER_ITEM_NAME -- L.ORDERED_ITEM
514 , L.CUSTOMER_ITEM_NET_PRICE
515 , L.CUSTOMER_PAYMENT_TERM_ID
516 , L.ITEM_REVISION
517 , L.ITEM_TYPE_CODE
518 -- , L.LAST_ACK_CODE
519 -- , L.LAST_ACK_DATE
520 -- , L.LAST_UPDATED_BY
521 -- , L.LAST_UPDATE_DATE
522 -- , L.LAST_UPDATE_LOGIN
523 , L.LATEST_ACCEPTABLE_DATE
524 , NULL -- L.LINE_CATEGORY_CODE
525 -- Use pre-generated line_id value from interface tables
526 , L.LINE_ID
527 , L.LINE_NUMBER
528 , L.LINE_TYPE_ID
529 , NULL -- L.LINK_TO_LINE_ID
530 , L.MODEL_GROUP_NUMBER
531 , NULL -- L.MFG_LEAD_TIME
532 -- , L.OPEN_FLAG
533 , L.OPTION_FLAG
534 , L.OPTION_NUMBER
535 , L.ORDERED_QUANTITY
536 , L.ORDERED_QUANTITY2 --OPM 02/JUN/00
537 , L.ORDER_QUANTITY_UOM
538 , L.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
539 , L.ORG_ID
540 , L.ORIG_SYS_DOCUMENT_REF
541 , L.ORIG_SYS_LINE_REF
542 , L.ORIG_SYS_SHIPMENT_REF
543 , L.CHANGE_SEQUENCE
544 , L.OVER_SHIP_REASON_CODE
545 , L.OVER_SHIP_RESOLVED_FLAG
546 , L.PAYMENT_TERM_ID
547 -- , L.PLANNING_PRIORITY
548 , L.PREFERRED_GRADE --OPM HVOP
549 , L.PRICE_LIST_ID
550 -- , L.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
551 , L.PRICING_ATTRIBUTE1
552 , L.PRICING_ATTRIBUTE10
553 , L.PRICING_ATTRIBUTE2
554 , L.PRICING_ATTRIBUTE3
555 , L.PRICING_ATTRIBUTE4
556 , L.PRICING_ATTRIBUTE5
557 , L.PRICING_ATTRIBUTE6
558 , L.PRICING_ATTRIBUTE7
559 , L.PRICING_ATTRIBUTE8
560 , L.PRICING_ATTRIBUTE9
561 , L.PRICING_CONTEXT
562 , L.PRICING_DATE
563 , L.PRICING_QUANTITY
564 , L.PRICING_QUANTITY_UOM
565 -- , L.PROGRAM_APPLICATION_ID
566 -- , L.PROGRAM_ID
567 -- , L.PROGRAM_UPDATE_DATE
568 , L.PROJECT_ID
569 , L.PROMISE_DATE
570 , NULL -- L.RE_SOURCE_FLAG
571 -- , L.REFERENCE_CUSTOMER_TRX_LINE_ID
572 , L.REFERENCE_HEADER_ID
573 , L.REFERENCE_LINE_ID
574 , L.REFERENCE_TYPE
575 , L.REQUEST_DATE
576 , L.REQUEST_ID
577 , L.RETURN_ATTRIBUTE1
578 , L.RETURN_ATTRIBUTE10
579 , L.RETURN_ATTRIBUTE11
580 , L.RETURN_ATTRIBUTE12
581 , L.RETURN_ATTRIBUTE13
582 , L.RETURN_ATTRIBUTE14
583 , L.RETURN_ATTRIBUTE15
584 , L.RETURN_ATTRIBUTE2
585 , L.RETURN_ATTRIBUTE3
586 , L.RETURN_ATTRIBUTE4
587 , L.RETURN_ATTRIBUTE5
588 , L.RETURN_ATTRIBUTE6
589 , L.RETURN_ATTRIBUTE7
590 , L.RETURN_ATTRIBUTE8
591 , L.RETURN_ATTRIBUTE9
592 , L.RETURN_CONTEXT
593 , L.RETURN_REASON_CODE
594 -- , L.RLA_SCHEDULE_TYPE_CODE
595 , L.SALESREP_ID
596 , L.SCHEDULE_ARRIVAL_DATE
597 , L.SCHEDULE_SHIP_DATE
598 , L.SCHEDULE_STATUS_CODE
599 , L.SHIPMENT_NUMBER
600 , L.SHIPMENT_PRIORITY_CODE
601 , L.SHIPPED_QUANTITY
602 , L.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
603 , L.SHIPPING_METHOD_CODE
604 , L.SHIPPING_QUANTITY
605 , L.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
606 , L.SHIPPING_QUANTITY_UOM
607 , L.SHIP_FROM_ORG_ID
608 , L.SUBINVENTORY
609 , L.SHIP_SET_ID
610 , L.SHIP_TOLERANCE_ABOVE
611 , L.SHIP_TOLERANCE_BELOW
612 , NULL -- L.SHIPPABLE_FLAG
613 -- , L.SHIPPING_INTERFACED_FLAG
614 , L.SHIP_TO_CONTACT_ID
615 , L.SHIP_TO_ORG_ID
616 , L.SHIP_MODEL_COMPLETE_FLAG
617 , L.SOLD_TO_ORG_ID
618 , L.SOLD_FROM_ORG_ID
619 , L.SORT_ORDER
620 , NULL -- L.SOURCE_DOCUMENT_ID
621 -- , L.SOURCE_DOCUMENT_LINE_ID
622 -- , L.SOURCE_DOCUMENT_TYPE_ID
623 , L.SOURCE_TYPE_CODE
624 , L.SPLIT_FROM_LINE_ID
625 -- , L.LINE_SET_ID
626 -- , L.SPLIT_BY
627 , 'N' -- L.MODEL_REMNANT_FLAG
628 , L.TASK_ID
629 , L.TAX_CODE
630 , L.TAX_DATE
631 , L.TAX_EXEMPT_FLAG
632 , L.TAX_EXEMPT_NUMBER
633 , L.TAX_EXEMPT_REASON_CODE
634 , L.TAX_POINT_CODE
635 -- , L.TAX_RATE
636 , L.TAX_VALUE
637 , NULL -- L.TOP_MODEL_LINE_ID
638 , L.UNIT_LIST_PRICE
639 , L.UNIT_LIST_PRICE_PER_PQTY
640 , L.UNIT_SELLING_PRICE
641 , L.UNIT_SELLING_PRICE_PER_PQTY
642 , NULL -- L.VISIBLE_DEMAND_FLAG
643 , L.VEH_CUS_ITEM_CUM_KEY_ID
644 , RTRIM(L.SHIPPING_INSTRUCTIONS,' ') -- 33090458
645 , RTRIM(L.PACKING_INSTRUCTIONS,' ') -- 33090458
646 , L.SERVICE_TXN_REASON_CODE
647 , L.SERVICE_TXN_COMMENTS
648 , L.SERVICE_DURATION
649 , L.SERVICE_PERIOD
650 , L.SERVICE_START_DATE
651 , L.SERVICE_END_DATE
652 , L.SERVICE_COTERMINATE_FLAG
653 , L.UNIT_LIST_PERCENT
654 , L.UNIT_SELLING_PERCENT
655 , L.UNIT_PERCENT_BASE_PRICE
656 , L.SERVICE_NUMBER
657 , L.SERVICE_REFERENCE_TYPE_CODE
658 -- , L.SERVICE_REFERENCE_LINE_ID
659 -- , L.SERVICE_REFERENCE_SYSTEM_ID
660 , RTRIM(L.TP_CONTEXT,' ') -- 3390458
661 , RTRIM(L.TP_ATTRIBUTE1,' ') -- 3390458
662 , RTRIM(L.TP_ATTRIBUTE2,' ') -- 3390458
663 , RTRIM(L.TP_ATTRIBUTE3,' ') -- 3390458
664 , RTRIM(L.TP_ATTRIBUTE4,' ') -- 3390458
665 , RTRIM(L.TP_ATTRIBUTE5,' ') -- 3390458
666 , RTRIM(L.TP_ATTRIBUTE6,' ') -- 3390458
667 , RTRIM(L.TP_ATTRIBUTE7,' ') -- 3390458
668 , RTRIM(L.TP_ATTRIBUTE8,' ') -- 3390458
669 , RTRIM(L.TP_ATTRIBUTE9,' ') -- 3390458
670 , RTRIM(L.TP_ATTRIBUTE10,' ') -- 3390458
671 , RTRIM(L.TP_ATTRIBUTE11,' ') -- 3390458
672 , RTRIM(L.TP_ATTRIBUTE12,' ') -- 3390458
673 , RTRIM(L.TP_ATTRIBUTE13,' ') -- 3390458
674 , RTRIM(L.TP_ATTRIBUTE14,' ') -- 3390458
675 , RTRIM(L.TP_ATTRIBUTE15,' ') -- 3390458
676 -- , L.FLOW_STATUS_CODE
677 -- , L.MARKETING_SOURCE_CODE_ID
678 , L.CALCULATE_PRICE_FLAG
679 , L.COMMITMENT_ID
680 , L.ORDER_SOURCE_ID -- aksingh
681 -- , L.upgraded_flag
682 , 1 -- L.LOCK_CONTROL
683 , NULL -- wf_process_name
684 , NULL -- ii_start_index
685 , NULL -- ii_count
686 , RTRIM(L.user_item_description,' ') -- 3390458
687 , NULL -- parent_line_index
688 , NULL -- Firm Demand flag
689 -- end customer (Bug 5054618)
690 ,L.End_customer_contact_id
691 ,L.End_customer_id
692 ,L.End_customer_site_use_id
693 ,L.IB_owner_code
694 ,L.IB_current_location_code
695 ,L.IB_Installed_at_Location_code
696 FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
697 WHERE h.batch_id = p_batch_id
698 AND h.order_source_id = l.order_source_id
699 AND h.orig_sys_document_ref = l.orig_sys_document_ref
700 AND nvl(h.error_flag,'N') = 'N'
701 AND nvl(h.ineligible_for_hvop, 'N') <> 'Y'
702 AND nvl(l.error_flag,'N') = 'N'
703 AND nvl(l.rejected_flag,'N') = 'N'
704 ORDER BY l.order_source_id, l.orig_sys_document_ref
705 , l.orig_sys_line_ref,
706 l.orig_sys_shipment_ref;
707
708
709 ----------------
710 --- Addind a new cursor c_lines1. this will be loaded if p_process_configurator=y and OE_BULK_ORDER_IMPORT_PVT.G_RTRIM_IFACE_DATA = 'N'
711 ----------------
712 CURSOR c_lines1 IS
713 SELECT * FROM (
714 -- records from the line interface tables ( include standard items and config items)
715 SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
716 L.ACCOUNTING_RULE_ID
717 , L.ACCOUNTING_RULE_DURATION
718 , L.ACTUAL_ARRIVAL_DATE
719 -- , L.ACTUAL_SHIPMENT_DATE
720 , L.AGREEMENT_ID
721 , L.ARRIVAL_SET_ID
722 , nvl(T.ATO_LINE_ID, L.ATO_LINE_ID) ATO_LINE_ID
723 , L.ATTRIBUTE1
724 , L.ATTRIBUTE10
725 , L.ATTRIBUTE11
726 , L.ATTRIBUTE12
727 , L.ATTRIBUTE13
728 , L.ATTRIBUTE14
729 , L.ATTRIBUTE15
730 , L.ATTRIBUTE16 --For bug 2184255
731 , L.ATTRIBUTE17
732 , L.ATTRIBUTE18
733 , L.ATTRIBUTE19
734 , L.ATTRIBUTE2
735 , L.ATTRIBUTE20
736 , L.ATTRIBUTE3
737 , L.ATTRIBUTE4
738 , L.ATTRIBUTE5
739 , L.ATTRIBUTE6
740 , L.ATTRIBUTE7
741 , L.ATTRIBUTE8
742 , L.ATTRIBUTE9
743 -- , L.AUTO_SELECTED_QUANTITY
744 , L.AUTHORIZED_TO_SHIP_FLAG
745 , NULL BOOKED_FLAG
746 , 'N' CANCELLED_FLAG
747 , L.CANCELLED_QUANTITY
748 , nvl(T.COMPONENT_CODE, L.COMPONENT_CODE) COMPONENT_CODE
749 , NULL COMPONENT_NUMBER
750 , nvl(T.COMPONENT_SEQUENCE_ID, L.COMPONENT_SEQUENCE_ID) COMPONENT_SEQUENCE_ID
751 , nvl(T.CONFIG_HEADER_ID, L.CONFIG_HEADER_ID) CONFIG_HEADER_ID
752 , nvl(T.CONFIG_REV_NBR, L.CONFIG_REV_NBR) CONFIG_REV_NBR
753 , null CONFIG_DISPLAY_SEQUENCE
754 , nvl(T.CONFIGURATION_ID, L.CONFIGURATION_ID) CONFIGURATION_ID
755 , L.CONTEXT
756 -- , L.CREATED_BY
757 -- , L.CREATION_DATE
758 , L.CREDIT_INVOICE_LINE_ID
759 , L.CUSTOMER_DOCK_CODE
760 , L.CUSTOMER_JOB
761 , L.CUSTOMER_PRODUCTION_LINE
762 , L.CUST_PRODUCTION_SEQ_NUM
763 -- , L.CUSTOMER_TRX_LINE_ID
764 , L.CUST_MODEL_SERIAL_NUMBER
765 , L.CUSTOMER_PO_NUMBER
766 , L.CUSTOMER_LINE_NUMBER
767 , L.DELIVERY_LEAD_TIME
768 , L.DELIVER_TO_CONTACT_ID
769 , L.DELIVER_TO_ORG_ID
770 , L.DEMAND_BUCKET_TYPE_CODE
771 , L.DEMAND_CLASS_CODE
772 -- , L.DEP_PLAN_REQUIRED_FLAG
773 , L.EARLIEST_ACCEPTABLE_DATE
774 , L.END_ITEM_UNIT_NUMBER
775 , L.EXPLOSION_DATE
776 -- , L.FIRST_ACK_CODE
777 -- , L.FIRST_ACK_DATE
778 , L.FOB_POINT_CODE
779 , NULL FREIGHT_CARRIER_CODE
780 , L.FREIGHT_TERMS_CODE
781 -- , L.FULFILLED_QUANTITY
782 -- , L.FULFILLED_FLAG
783 -- , L.FULFILLMENT_METHOD_CODE
784 -- , L.FULFILLMENT_DATE
785 , L.GLOBAL_ATTRIBUTE1
786 , L.GLOBAL_ATTRIBUTE10
787 , L.GLOBAL_ATTRIBUTE11
788 , L.GLOBAL_ATTRIBUTE12
789 , L.GLOBAL_ATTRIBUTE13
790 , L.GLOBAL_ATTRIBUTE14
791 , L.GLOBAL_ATTRIBUTE15
792 , L.GLOBAL_ATTRIBUTE16
793 , L.GLOBAL_ATTRIBUTE17
794 , L.GLOBAL_ATTRIBUTE18
795 , L.GLOBAL_ATTRIBUTE19
796 , L.GLOBAL_ATTRIBUTE2
797 , L.GLOBAL_ATTRIBUTE20
798 , L.GLOBAL_ATTRIBUTE3
799 , L.GLOBAL_ATTRIBUTE4
800 , L.GLOBAL_ATTRIBUTE5
801 , L.GLOBAL_ATTRIBUTE6
802 , L.GLOBAL_ATTRIBUTE7
803 , L.GLOBAL_ATTRIBUTE8
804 , L.GLOBAL_ATTRIBUTE9
805 , L.GLOBAL_ATTRIBUTE_CATEGORY
806 , NULL HEADER_ID
807 , L.INDUSTRY_ATTRIBUTE1
808 , L.INDUSTRY_ATTRIBUTE10
809 , L.INDUSTRY_ATTRIBUTE11
810 , L.INDUSTRY_ATTRIBUTE12
811 , L.INDUSTRY_ATTRIBUTE13
812 , L.INDUSTRY_ATTRIBUTE14
813 , L.INDUSTRY_ATTRIBUTE15
814 , L.INDUSTRY_ATTRIBUTE16
815 , L.INDUSTRY_ATTRIBUTE17
816 , L.INDUSTRY_ATTRIBUTE18
817 , L.INDUSTRY_ATTRIBUTE19
818 , L.INDUSTRY_ATTRIBUTE20
819 , L.INDUSTRY_ATTRIBUTE21
820 , L.INDUSTRY_ATTRIBUTE22
821 , L.INDUSTRY_ATTRIBUTE23
822 , L.INDUSTRY_ATTRIBUTE24
823 , L.INDUSTRY_ATTRIBUTE25
824 , L.INDUSTRY_ATTRIBUTE26
825 , L.INDUSTRY_ATTRIBUTE27
826 , L.INDUSTRY_ATTRIBUTE28
827 , L.INDUSTRY_ATTRIBUTE29
828 , L.INDUSTRY_ATTRIBUTE30
829 , L.INDUSTRY_ATTRIBUTE2
830 , L.INDUSTRY_ATTRIBUTE3
831 , L.INDUSTRY_ATTRIBUTE4
832 , L.INDUSTRY_ATTRIBUTE5
833 , L.INDUSTRY_ATTRIBUTE6
834 , L.INDUSTRY_ATTRIBUTE7
835 , L.INDUSTRY_ATTRIBUTE8
836 , L.INDUSTRY_ATTRIBUTE9
837 , L.INDUSTRY_CONTEXT
838 -- , L.INTERMED_SHIP_TO_CONTACT_ID
839 -- , L.INTERMED_SHIP_TO_ORG_ID
840 , nvl(T.INVENTORY_ITEM_ID, L.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
841 -- , L.INVOICE_INTERFACE_STATUS_CODE
842 , L.INVOICE_TO_CONTACT_ID
843 , L.INVOICE_TO_ORG_ID
844 -- , L.INVOICED_QUANTITY
845 , L.INVOICING_RULE_ID
846 , L.CUSTOMER_ITEM_ID -- L.ORDERED_ITEM_ID
847 , L.CUSTOMER_ITEM_ID_TYPE -- L.ITEM_IDENTIFIER_TYPE
848 , L.CUSTOMER_ITEM_NAME -- L.ORDERED_ITEM
849 , L.CUSTOMER_ITEM_NET_PRICE
850 , L.CUSTOMER_PAYMENT_TERM_ID
851 , L.ITEM_REVISION
852 , nvl(T.ITEM_TYPE_CODE, L.ITEM_TYPE_CODE) ITEM_TYPE_CODE
853 -- , L.LAST_ACK_CODE
854 -- , L.LAST_ACK_DATE
855 -- , L.LAST_UPDATED_BY
856 -- , L.LAST_UPDATE_DATE
857 -- , L.LAST_UPDATE_LOGIN
858 , L.LATEST_ACCEPTABLE_DATE
859 , NULL LINE_CATEGORY_CODE
860 -- Use pre-generated line_id value from interface tables
861 , L.LINE_ID
862 , L.LINE_NUMBER
863 , nvl(T.LINE_TYPE, L.LINE_TYPE_ID) LINE_TYPE
864 , T.LINK_TO_LINE_ID
865 , L.MODEL_GROUP_NUMBER
866 , NULL MFG_LEAD_TIME
867 -- , L.OPEN_FLAG
868 , L.OPTION_FLAG
869 , L.OPTION_NUMBER
870 , nvl(T.ORDERED_QUANTITY, L.ORDERED_QUANTITY) ORDERED_QUANTITY
871 , L.ORDERED_QUANTITY2 --OPM 02/JUN/00
872 , nvl(T.UOM_CODE, L.ORDER_QUANTITY_UOM) UOM_CODE
873 , L.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
874 , L.ORG_ID
875 , L.ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
876 , L.ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
877 , L.ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
878 , L.CHANGE_SEQUENCE
879 , L.OVER_SHIP_REASON_CODE
880 , L.OVER_SHIP_RESOLVED_FLAG
881 , L.PAYMENT_TERM_ID
882 -- , L.PLANNING_PRIORITY
883 , L.PREFERRED_GRADE --OPM HVOP
884 , L.PRICE_LIST_ID
885 -- , L.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
886 , L.PRICING_ATTRIBUTE1
887 , L.PRICING_ATTRIBUTE10
888 , L.PRICING_ATTRIBUTE2
889 , L.PRICING_ATTRIBUTE3
890 , L.PRICING_ATTRIBUTE4
891 , L.PRICING_ATTRIBUTE5
892 , L.PRICING_ATTRIBUTE6
893 , L.PRICING_ATTRIBUTE7
894 , L.PRICING_ATTRIBUTE8
895 , L.PRICING_ATTRIBUTE9
896 , L.PRICING_CONTEXT
897 , L.PRICING_DATE
898 , L.PRICING_QUANTITY
899 , L.PRICING_QUANTITY_UOM
900 -- , L.PROGRAM_APPLICATION_ID
901 -- , L.PROGRAM_ID
902 -- , L.PROGRAM_UPDATE_DATE
903 , L.PROJECT_ID
904 , L.PROMISE_DATE
905 , NULL RE_SOURCE_FLAG
906 -- , L.REFERENCE_CUSTOMER_TRX_LINE_ID
907 , L.REFERENCE_HEADER_ID
908 , L.REFERENCE_LINE_ID
909 , L.REFERENCE_TYPE
910 , L.REQUEST_DATE
911 , L.REQUEST_ID
912 , L.RETURN_ATTRIBUTE1
913 , L.RETURN_ATTRIBUTE10
914 , L.RETURN_ATTRIBUTE11
915 , L.RETURN_ATTRIBUTE12
916 , L.RETURN_ATTRIBUTE13
917 , L.RETURN_ATTRIBUTE14
918 , L.RETURN_ATTRIBUTE15
919 , L.RETURN_ATTRIBUTE2
920 , L.RETURN_ATTRIBUTE3
921 , L.RETURN_ATTRIBUTE4
922 , L.RETURN_ATTRIBUTE5
923 , L.RETURN_ATTRIBUTE6
924 , L.RETURN_ATTRIBUTE7
925 , L.RETURN_ATTRIBUTE8
926 , L.RETURN_ATTRIBUTE9
927 , L.RETURN_CONTEXT
928 , L.RETURN_REASON_CODE
929 -- , L.RLA_SCHEDULE_TYPE_CODE
930 , L.SALESREP_ID
931 , L.SCHEDULE_ARRIVAL_DATE
932 , L.SCHEDULE_SHIP_DATE
933 , L.SCHEDULE_STATUS_CODE
934 , L.SHIPMENT_NUMBER
935 , L.SHIPMENT_PRIORITY_CODE
936 , L.SHIPPED_QUANTITY
937 , L.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
938 , L.SHIPPING_METHOD_CODE
939 , L.SHIPPING_QUANTITY
940 , L.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
941 , L.SHIPPING_QUANTITY_UOM
942 , L.SHIP_FROM_ORG_ID
943 , L.SUBINVENTORY
944 , L.SHIP_SET_ID
945 , L.SHIP_TOLERANCE_ABOVE
946 , L.SHIP_TOLERANCE_BELOW
947 , NULL SHIPPABLE_FLAG
948 -- , L.SHIPPING_INTERFACED_FLAG
949 , L.SHIP_TO_CONTACT_ID
950 , L.SHIP_TO_ORG_ID
951 , L.SHIP_MODEL_COMPLETE_FLAG
952 , L.SOLD_TO_ORG_ID
953 , L.SOLD_FROM_ORG_ID
954 , nvl(T.SORT_ORDER, L.SORT_ORDER) SORT_ORDER
955 , NULL SOURCE_DOCUMENT_ID
956 -- , L.SOURCE_DOCUMENT_LINE_ID
957 -- , L.SOURCE_DOCUMENT_TYPE_ID
958 , L.SOURCE_TYPE_CODE
959 , L.SPLIT_FROM_LINE_ID
960 -- , L.LINE_SET_ID
961 -- , L.SPLIT_BY
962 , 'N' MODEL_REMNANT_FLAG
963 , L.TASK_ID
964 , L.TAX_CODE
965 , L.TAX_DATE
966 , L.TAX_EXEMPT_FLAG
967 , L.TAX_EXEMPT_NUMBER
968 , L.TAX_EXEMPT_REASON_CODE
969 , L.TAX_POINT_CODE
970 -- , L.TAX_RATE
971 , L.TAX_VALUE
972 , T.TOP_MODEL_LINE_ID
973 , T.TOP_MODEL_LINE_REF TOP_MODEL_LINE_REF
974 , L.UNIT_LIST_PRICE
975 , L.UNIT_LIST_PRICE_PER_PQTY
976 , L.UNIT_SELLING_PRICE
977 , L.UNIT_SELLING_PRICE_PER_PQTY
978 , NULL VISIBLE_DEMAND_FLAG
979 , L.VEH_CUS_ITEM_CUM_KEY_ID
980 , L.SHIPPING_INSTRUCTIONS
981 , L.PACKING_INSTRUCTIONS
982 , L.SERVICE_TXN_REASON_CODE
983 , L.SERVICE_TXN_COMMENTS
984 , L.SERVICE_DURATION
985 , L.SERVICE_PERIOD
986 , L.SERVICE_START_DATE
987 , L.SERVICE_END_DATE
988 , L.SERVICE_COTERMINATE_FLAG
989 , L.UNIT_LIST_PERCENT
990 , L.UNIT_SELLING_PERCENT
991 , L.UNIT_PERCENT_BASE_PRICE
992 , L.SERVICE_NUMBER
993 , L.SERVICE_REFERENCE_TYPE_CODE
994 -- , L.SERVICE_REFERENCE_LINE_ID
995 -- , L.SERVICE_REFERENCE_SYSTEM_ID
996 , L.TP_CONTEXT
997 , L.TP_ATTRIBUTE1
998 , L.TP_ATTRIBUTE2
999 , L.TP_ATTRIBUTE3
1000 , L.TP_ATTRIBUTE4
1001 , L.TP_ATTRIBUTE5
1002 , L.TP_ATTRIBUTE6
1003 , L.TP_ATTRIBUTE7
1004 , L.TP_ATTRIBUTE8
1005 , L.TP_ATTRIBUTE9
1006 , L.TP_ATTRIBUTE10
1007 , L.TP_ATTRIBUTE11
1008 , L.TP_ATTRIBUTE12
1009 , L.TP_ATTRIBUTE13
1010 , L.TP_ATTRIBUTE14
1011 , L.TP_ATTRIBUTE15
1012 -- , L.FLOW_STATUS_CODE
1013 -- , L.MARKETING_SOURCE_CODE_ID
1014 , L.CALCULATE_PRICE_FLAG
1015 , L.COMMITMENT_ID
1016 , L.ORDER_SOURCE_ID ORDER_SOURCE_ID
1017 -- , L.upgraded_flag
1018 , 1 LOCK_CONTROL
1019 , NULL wf_process_name
1020 , NULL ii_start_index
1021 , NULL ii_count
1022 , L.user_item_description
1023 , NULL parent_line_index
1024 , NULL Firm_Demand_flag
1025 -- end customer
1026 ,L.End_customer_contact_id
1027 ,L.End_customer_id
1028 ,L.End_customer_site_use_id
1029 ,L.IB_owner_code
1030 ,L.IB_current_location_code
1031 ,L.IB_Installed_at_Location_code
1032 , NULL cust_trx_type_id
1033 , NULL tax_calculation_flag
1034 , NULL ato_line_index
1035 , NULL top_model_line_index
1036 FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1037 , OE_CONFIG_DETAILS_TMP T
1038 WHERE h.batch_id = p_batch_id
1039 AND h.order_source_id = l.order_source_id
1040 AND h.orig_sys_document_ref = l.orig_sys_document_ref
1041 AND nvl(h.error_flag,'N') = 'N'
1042 AND nvl(h.ineligible_for_hvop, 'N') <> 'Y'
1043 AND nvl(l.error_flag,'N') = 'N'
1044 AND nvl(l.rejected_flag,'N') = 'N'
1045 AND l.line_id = t.line_id(+)
1046 UNION ALL
1047 -- records from oe_config_details_tmp and not in line interface table
1048 SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1049 NULL ACCOUNTING_RULE_ID
1050 , NULL ACCOUNTING_RULE_DURATION
1051 , NULL ACTUAL_ARRIVAL_DATE
1052 -- , L.ACTUAL_SHIPMENT_DATE
1053 , NULL AGREEMENT_ID
1054 , NULL ARRIVAL_SET_ID
1055 , T.ATO_LINE_ID ATO_LINE_ID
1056 , NULL ATTRIBUTE1
1057 , NULL ATTRIBUTE10
1058 , NULL ATTRIBUTE11
1059 , NULL ATTRIBUTE12
1060 , NULL ATTRIBUTE13
1061 , NULL ATTRIBUTE14
1062 , NULL ATTRIBUTE15
1063 , NULL ATTRIBUTE16 --For bug 2184255
1064 , NULL ATTRIBUTE17
1065 , NULL ATTRIBUTE18
1066 , NULL ATTRIBUTE19
1067 , NULL ATTRIBUTE2
1068 , NULL ATTRIBUTE20
1069 , NULL ATTRIBUTE3
1070 , NULL ATTRIBUTE4
1071 , NULL ATTRIBUTE5
1072 , NULL ATTRIBUTE6
1073 , NULL ATTRIBUTE7
1074 , NULL ATTRIBUTE8
1075 , NULL ATTRIBUTE9
1076 -- , L.AUTO_SELECTED_QUANTITY
1077 , NULL AUTHORIZED_TO_SHIP_FLAG
1078 , NULL BOOKED_FLAG
1079 , 'N' CANCELLED_FLAG
1080 , NULL CANCELLED_QUANTITY
1081 , T.COMPONENT_CODE COMPONENT_CODE
1082 , NULL COMPONENT_NUMBER
1083 , T.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
1084 , T.CONFIG_HEADER_ID CONFIG_HEADER_ID
1085 , T.CONFIG_REV_NBR CONFIG_REV_NBR
1086 , null CONFIG_DISPLAY_SEQUENCE
1087 , T.CONFIGURATION_ID CONFIGURATION_ID
1088 , NULL CONTEXT
1089 -- , L.CREATED_BY
1090 -- , L.CREATION_DATE
1091 , NULL CREDIT_INVOICE_LINE_ID
1092 , NULL CUSTOMER_DOCK_CODE
1093 , NULL CUSTOMER_JOB
1094 , NULL CUSTOMER_PRODUCTION_LINE
1095 , NULL CUST_PRODUCTION_SEQ_NUM
1096 -- , L.CUSTOMER_TRX_LINE_ID
1097 , NULL CUST_MODEL_SERIAL_NUMBER
1098 , NULL CUSTOMER_PO_NUMBER
1099 , NULL CUSTOMER_LINE_NUMBER
1100 , NULL DELIVERY_LEAD_TIME
1101 , NULL DELIVER_TO_CONTACT_ID
1102 , NULL DELIVER_TO_ORG_ID
1103 , NULL DEMAND_BUCKET_TYPE_CODE
1104 , NULL DEMAND_CLASS_CODE
1105 -- , L.DEP_PLAN_REQUIRED_FLAG
1106 , NULL EARLIEST_ACCEPTABLE_DATE
1107 , NULL END_ITEM_UNIT_NUMBER
1108 , NULL EXPLOSION_DATE
1109 -- , L.FIRST_ACK_CODE
1110 -- , L.FIRST_ACK_DATE
1111 , NULL FOB_POINT_CODE
1112 , NULL FREIGHT_CARRIER_CODE
1113 , NULL FREIGHT_TERMS_CODE
1114 -- , L.FULFILLED_QUANTITY
1115 -- , L.FULFILLED_FLAG
1116 -- , L.FULFILLMENT_METHOD_CODE
1117 -- , L.FULFILLMENT_DATE
1118 , NULL GLOBAL_ATTRIBUTE1
1119 , NULL GLOBAL_ATTRIBUTE10
1120 , NULL GLOBAL_ATTRIBUTE11
1121 , NULL GLOBAL_ATTRIBUTE12
1122 , NULL GLOBAL_ATTRIBUTE13
1123 , NULL GLOBAL_ATTRIBUTE14
1124 , NULL GLOBAL_ATTRIBUTE15
1125 , NULL GLOBAL_ATTRIBUTE16
1126 , NULL GLOBAL_ATTRIBUTE17
1127 , NULL GLOBAL_ATTRIBUTE18
1128 , NULL GLOBAL_ATTRIBUTE19
1129 , NULL GLOBAL_ATTRIBUTE2
1130 , NULL GLOBAL_ATTRIBUTE20
1131 , NULL GLOBAL_ATTRIBUTE3
1132 , NULL GLOBAL_ATTRIBUTE4
1133 , NULL GLOBAL_ATTRIBUTE5
1134 , NULL GLOBAL_ATTRIBUTE6
1135 , NULL GLOBAL_ATTRIBUTE7
1136 , NULL GLOBAL_ATTRIBUTE8
1137 , NULL GLOBAL_ATTRIBUTE9
1138 , NULL GLOBAL_ATTRIBUTE_CATEGORY
1139 , NULL HEADER_ID
1140 , NULL INDUSTRY_ATTRIBUTE1
1141 , NULL INDUSTRY_ATTRIBUTE10
1142 , NULL INDUSTRY_ATTRIBUTE11
1143 , NULL INDUSTRY_ATTRIBUTE12
1144 , NULL INDUSTRY_ATTRIBUTE13
1145 , NULL INDUSTRY_ATTRIBUTE14
1146 , NULL INDUSTRY_ATTRIBUTE15
1147 , NULL INDUSTRY_ATTRIBUTE16
1148 , NULL INDUSTRY_ATTRIBUTE17
1149 , NULL INDUSTRY_ATTRIBUTE18
1150 , NULL INDUSTRY_ATTRIBUTE19
1151 , NULL INDUSTRY_ATTRIBUTE20
1152 , NULL INDUSTRY_ATTRIBUTE21
1153 , NULL INDUSTRY_ATTRIBUTE22
1154 , NULL INDUSTRY_ATTRIBUTE23
1155 , NULL INDUSTRY_ATTRIBUTE24
1156 , NULL INDUSTRY_ATTRIBUTE25
1157 , NULL INDUSTRY_ATTRIBUTE26
1158 , NULL INDUSTRY_ATTRIBUTE27
1159 , NULL INDUSTRY_ATTRIBUTE28
1160 , NULL INDUSTRY_ATTRIBUTE29
1161 , NULL INDUSTRY_ATTRIBUTE30
1162 , NULL INDUSTRY_ATTRIBUTE2
1163 , NULL INDUSTRY_ATTRIBUTE3
1164 , NULL INDUSTRY_ATTRIBUTE4
1165 , NULL INDUSTRY_ATTRIBUTE5
1166 , NULL INDUSTRY_ATTRIBUTE6
1167 , NULL INDUSTRY_ATTRIBUTE7
1168 , NULL INDUSTRY_ATTRIBUTE8
1169 , NULL INDUSTRY_ATTRIBUTE9
1170 , NULL INDUSTRY_CONTEXT
1171 -- , L.INTERMED_SHIP_TO_CONTACT_ID
1172 -- , L.INTERMED_SHIP_TO_ORG_ID
1173 , T.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
1174 -- , L.INVOICE_INTERFACE_STATUS_CODE
1175 , NULL INVOICE_TO_CONTACT_ID
1176 , NULL INVOICE_TO_ORG_ID
1177 -- , L.INVOICED_QUANTITY
1178 , NULL INVOICING_RULE_ID
1179 , NULL CUSTOMER_ITEM_ID -- L.ORDERED_ITEM_ID
1180 , NULL CUSTOMER_ITEM_ID_TYPE -- L.ITEM_IDENTIFIER_TYPE
1181 , NULL CUSTOMER_ITEM_NAME -- NULL ORDERED_ITEM
1182 , NULL CUSTOMER_ITEM_NET_PRICE
1183 , NULL CUSTOMER_PAYMENT_TERM_ID
1184 , NULL ITEM_REVISION
1185 , T.ITEM_TYPE_CODE ITEM_TYPE_CODE
1186 -- , L.LAST_ACK_CODE
1187 -- , L.LAST_ACK_DATE
1188 -- , L.LAST_UPDATED_BY
1189 -- , L.LAST_UPDATE_DATE
1190 -- , L.LAST_UPDATE_LOGIN
1191 , NULL LATEST_ACCEPTABLE_DATE
1192 , NULL LINE_CATEGORY_CODE
1193 -- Use pre-generated line_id value from interface tables
1194 , T.LINE_ID LINE_ID
1195 , NULL LINE_NUMBER
1196 , T.LINE_TYPE LINE_TYPE
1197 , T.LINK_TO_LINE_ID LINK_TO_LINE_ID
1198 , NULL MODEL_GROUP_NUMBER
1199 , NULL MFG_LEAD_TIME
1200 -- , L.OPEN_FLAG
1201 , NULL OPTION_FLAG
1202 , NULL OPTION_NUMBER
1203 , T.ORDERED_QUANTITY ORDERED_QUANTITY
1204 , NULL ORDERED_QUANTITY2 --OPM 02/JUN/00
1205 , T.UOM_CODE UOM_CODE
1206 , NULL ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
1207 , L.ORG_ID
1208 , T.ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
1209 , T.ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
1210 , T.ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
1211 , NULL CHANGE_SEQUENCE
1212 , NULL OVER_SHIP_REASON_CODE
1213 , NULL OVER_SHIP_RESOLVED_FLAG
1214 , NULL PAYMENT_TERM_ID
1215 -- , L.PLANNING_PRIORITY
1216 , NULL PREFERRED_GRADE --OPM HVOP
1217 , NULL PRICE_LIST_ID
1218 -- , L.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
1219 , NULL PRICING_ATTRIBUTE1
1220 , NULL PRICING_ATTRIBUTE10
1221 , NULL PRICING_ATTRIBUTE2
1222 , NULL PRICING_ATTRIBUTE3
1223 , NULL PRICING_ATTRIBUTE4
1224 , NULL PRICING_ATTRIBUTE5
1225 , NULL PRICING_ATTRIBUTE6
1226 , NULL PRICING_ATTRIBUTE7
1227 , NULL PRICING_ATTRIBUTE8
1228 , NULL PRICING_ATTRIBUTE9
1229 , NULL PRICING_CONTEXT
1230 , NULL PRICING_DATE
1231 , NULL PRICING_QUANTITY
1232 , NULL PRICING_QUANTITY_UOM
1233 -- , L.PROGRAM_APPLICATION_ID
1234 -- , L.PROGRAM_ID
1235 -- , L.PROGRAM_UPDATE_DATE
1236 , NULL PROJECT_ID
1237 , NULL PROMISE_DATE
1238 , NULL RE_SOURCE_FLAG
1239 -- , L.REFERENCE_CUSTOMER_TRX_LINE_ID
1240 , NULL REFERENCE_HEADER_ID
1241 , NULL REFERENCE_LINE_ID
1242 , NULL REFERENCE_TYPE
1243 , NULL REQUEST_DATE
1244 , NULL REQUEST_ID
1245 , NULL RETURN_ATTRIBUTE1
1246 , NULL RETURN_ATTRIBUTE10
1247 , NULL RETURN_ATTRIBUTE11
1248 , NULL RETURN_ATTRIBUTE12
1249 , NULL RETURN_ATTRIBUTE13
1250 , NULL RETURN_ATTRIBUTE14
1251 , NULL RETURN_ATTRIBUTE15
1252 , NULL RETURN_ATTRIBUTE2
1253 , NULL RETURN_ATTRIBUTE3
1254 , NULL RETURN_ATTRIBUTE4
1255 , NULL RETURN_ATTRIBUTE5
1256 , NULL RETURN_ATTRIBUTE6
1257 , NULL RETURN_ATTRIBUTE7
1258 , NULL RETURN_ATTRIBUTE8
1259 , NULL RETURN_ATTRIBUTE9
1260 , NULL RETURN_CONTEXT
1261 , NULL RETURN_REASON_CODE
1262 -- , L.RLA_SCHEDULE_TYPE_CODE
1263 , NULL SALESREP_ID
1264 , NULL SCHEDULE_ARRIVAL_DATE
1265 , NULL SCHEDULE_SHIP_DATE
1266 , NULL SCHEDULE_STATUS_CODE
1267 , NULL SHIPMENT_NUMBER
1268 , NULL SHIPMENT_PRIORITY_CODE
1269 , NULL SHIPPED_QUANTITY
1270 , NULL SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
1271 , NULL SHIPPING_METHOD_CODE
1272 , NULL SHIPPING_QUANTITY
1273 , NULL SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
1274 , NULL SHIPPING_QUANTITY_UOM
1275 , NULL SHIP_FROM_ORG_ID
1276 , NULL SUBINVENTORY
1277 , NULL SHIP_SET_ID
1278 , NULL SHIP_TOLERANCE_ABOVE
1279 , NULL SHIP_TOLERANCE_BELOW
1280 , NULL SHIPPABLE_FLAG
1281 -- , L.SHIPPING_INTERFACED_FLAG
1282 , NULL SHIP_TO_CONTACT_ID
1283 , NULL SHIP_TO_ORG_ID
1284 , NULL SHIP_MODEL_COMPLETE_FLAG
1285 , NULL SOLD_TO_ORG_ID
1286 , NULL SOLD_FROM_ORG_ID
1287 , T.SORT_ORDER SORT_ORDER
1288 , NULL SOURCE_DOCUMENT_ID
1289 -- , L.SOURCE_DOCUMENT_LINE_ID
1290 -- , L.SOURCE_DOCUMENT_TYPE_ID
1291 , NULL SOURCE_TYPE_CODE
1292 , NULL SPLIT_FROM_LINE_ID
1293 -- , L.LINE_SET_ID
1294 -- , L.SPLIT_BY
1295 , 'N' MODEL_REMNANT_FLAG
1296 , NULL TASK_ID
1297 , NULL TAX_CODE
1298 , NULL TAX_DATE
1299 , NULL TAX_EXEMPT_FLAG
1300 , NULL TAX_EXEMPT_NUMBER
1301 , NULL TAX_EXEMPT_REASON_CODE
1302 , NULL TAX_POINT_CODE
1303 -- , L.TAX_RATE
1304 , NULL TAX_VALUE
1305 , T.TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
1306 , T.TOP_MODEL_LINE_REF TOP_MODEL_LINE_REF
1307 , NULL UNIT_LIST_PRICE
1308 , NULL UNIT_LIST_PRICE_PER_PQTY
1309 , NULL UNIT_SELLING_PRICE
1310 , NULL UNIT_SELLING_PRICE_PER_PQTY
1311 , NULL VISIBLE_DEMAND_FLAG
1312 , NULL VEH_CUS_ITEM_CUM_KEY_ID
1313 , NULL SHIPPING_INSTRUCTIONS
1314 , NULL PACKING_INSTRUCTIONS
1315 , NULL SERVICE_TXN_REASON_CODE
1316 , NULL SERVICE_TXN_COMMENTS
1317 , NULL SERVICE_DURATION
1318 , NULL SERVICE_PERIOD
1319 , NULL SERVICE_START_DATE
1320 , NULL SERVICE_END_DATE
1321 , NULL SERVICE_COTERMINATE_FLAG
1322 , NULL UNIT_LIST_PERCENT
1323 , NULL UNIT_SELLING_PERCENT
1324 , NULL UNIT_PERCENT_BASE_PRICE
1325 , NULL SERVICE_NUMBER
1326 , NULL SERVICE_REFERENCE_TYPE_CODE
1327 -- , L.SERVICE_REFERENCE_LINE_ID
1328 -- , L.SERVICE_REFERENCE_SYSTEM_ID
1329 , NULL TP_CONTEXT
1330 , NULL TP_ATTRIBUTE1
1331 , NULL TP_ATTRIBUTE2
1332 , NULL TP_ATTRIBUTE3
1333 , NULL TP_ATTRIBUTE4
1334 , NULL TP_ATTRIBUTE5
1335 , NULL TP_ATTRIBUTE6
1336 , NULL TP_ATTRIBUTE7
1337 , NULL TP_ATTRIBUTE8
1338 , NULL TP_ATTRIBUTE9
1339 , NULL TP_ATTRIBUTE10
1340 , NULL TP_ATTRIBUTE11
1341 , NULL TP_ATTRIBUTE12
1342 , NULL TP_ATTRIBUTE13
1343 , NULL TP_ATTRIBUTE14
1344 , NULL TP_ATTRIBUTE15
1345 -- , L.FLOW_STATUS_CODE
1346 -- , L.MARKETING_SOURCE_CODE_ID
1347 , NULL CALCULATE_PRICE_FLAG
1348 , NULL COMMITMENT_ID
1349 , T.ORDER_SOURCE_ID ORDER_SOURCE_ID
1350 -- , L.upgraded_flag
1351 , 1 LOCK_CONTROL
1352 , NULL wf_process_name
1353 , NULL ii_start_index
1354 , NULL ii_count
1355 , NULL user_item_description
1356 , NULL parent_line_index
1357 , NULL Firm_Demand_flag
1358 -- end customer
1359 ,NULL End_customer_contact_id
1360 ,NULL End_customer_id
1361 ,NULL End_customer_site_use_id
1362 ,NULL IB_owner_code
1363 ,NULL IB_current_location_code
1364 ,NULL IB_Installed_at_Location_code
1365 , NULL cust_trx_type_id
1366 , NULL tax_calculation_flag
1367 , NULL ato_line_index
1368 , NULL top_model_line_index
1369 FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1370 , OE_CONFIG_DETAILS_TMP T
1371 WHERE h.batch_id = p_batch_id
1372 AND h.order_source_id = l.order_source_id
1373 AND h.orig_sys_document_ref = l.orig_sys_document_ref
1374 AND nvl(h.error_flag,'N') = 'N'
1375 AND nvl(h.ineligible_for_hvop, 'N') <> 'Y'
1376 AND nvl(l.error_flag,'N') = 'N'
1377 AND nvl(l.rejected_flag,'N') = 'N'
1378 AND l.order_source_id = t.order_source_id
1379 AND l.orig_sys_document_ref = t.orig_sys_document_ref
1380 AND l.top_model_line_ref = t.top_model_line_ref
1381 AND l.item_type_code = 'MODEL'
1382 AND NOT EXISTS ( select 1
1383 from OE_LINES_IFACE_ALL L1
1384 where l1.line_id = t.line_id) ) LINES
1385 ORDER BY order_source_id,
1386 orig_sys_document_ref,
1387 decode(top_model_line_ref, null, orig_sys_line_ref, top_model_line_ref),
1388 orig_sys_shipment_ref,
1389 sort_order;
1390
1391
1392 ----------------
1393 --- Addind a new cursor c_lines1_rtrim. this will be loaded if p_process_configurator=y and OE_BULK_ORDER_IMPORT_PVT.G_RTRIM_IFACE_DATA = 'N'
1394 ----------------
1395
1396 CURSOR c_lines1_rtrim IS
1397 SELECT * FROM (
1398 SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1399 L.ACCOUNTING_RULE_ID
1400 , L.ACCOUNTING_RULE_DURATION
1401 , L.ACTUAL_ARRIVAL_DATE
1402 , L.AGREEMENT_ID
1403 , L.ARRIVAL_SET_ID
1404 , nvl(T.ATO_LINE_ID, L.ATO_LINE_ID) ATO_LINE_ID
1405 , L.ATTRIBUTE1
1406 , L.ATTRIBUTE10
1407 , L.ATTRIBUTE11
1408 , L.ATTRIBUTE12
1409 , L.ATTRIBUTE13
1410 , L.ATTRIBUTE14
1411 , L.ATTRIBUTE15
1412 , L.ATTRIBUTE16 --For bug 2184255
1413 , L.ATTRIBUTE17
1414 , L.ATTRIBUTE18
1415 , L.ATTRIBUTE19
1416 , L.ATTRIBUTE2
1417 , L.ATTRIBUTE20
1418 , L.ATTRIBUTE3
1419 , L.ATTRIBUTE4
1420 , L.ATTRIBUTE5
1421 , L.ATTRIBUTE6
1422 , L.ATTRIBUTE7
1423 , L.ATTRIBUTE8
1424 , L.ATTRIBUTE9
1425 , L.AUTHORIZED_TO_SHIP_FLAG
1426 , NULL BOOKED_FLAG
1427 , 'N' CANCELLED_FLAG
1428 , L.CANCELLED_QUANTITY
1429 , nvl(T.COMPONENT_CODE, L.COMPONENT_CODE) COMPONENT_CODE
1430 , NULL COMPONENT_NUMBER
1431 , nvl(T.COMPONENT_SEQUENCE_ID, L.COMPONENT_SEQUENCE_ID) COMPONENT_SEQUENCE_ID
1432 , nvl(T.CONFIG_HEADER_ID, L.CONFIG_HEADER_ID) CONFIG_HEADER_ID
1433 , nvl(T.CONFIG_REV_NBR, L.CONFIG_REV_NBR) CONFIG_REV_NBR
1434 , null CONFIG_DISPLAY_SEQUENCE
1435 , nvl(T.CONFIGURATION_ID, L.CONFIGURATION_ID) CONFIGURATION_ID
1436 , L.CONTEXT
1437 -- , L.CREATED_BY
1438 -- , L.CREATION_DATE
1439 , L.CREDIT_INVOICE_LINE_ID
1440 , RTRIM(L.CUSTOMER_DOCK_CODE,' ') -- 3390458
1441 , RTRIM(L.CUSTOMER_JOB, ' ') -- 3390458
1442 , RTRIM(L.CUSTOMER_PRODUCTION_LINE, ' ') -- 3390458
1443 , RTRIM(L.CUST_PRODUCTION_SEQ_NUM, ' ') -- 3390458
1444 -- , L.CUSTOMER_TRX_LINE_ID
1445 , RTRIM(L.CUST_MODEL_SERIAL_NUMBER,' ') -- 3390458
1446 , RTRIM(L.CUSTOMER_PO_NUMBER,' ') -- 3390458
1447 , L.CUSTOMER_LINE_NUMBER
1448 , L.DELIVERY_LEAD_TIME
1449 , L.DELIVER_TO_CONTACT_ID
1450 , L.DELIVER_TO_ORG_ID
1451 , L.DEMAND_BUCKET_TYPE_CODE
1452 , L.DEMAND_CLASS_CODE
1453 -- , L.DEP_PLAN_REQUIRED_FLAG
1454 , L.EARLIEST_ACCEPTABLE_DATE
1455 , RTRIM(L.END_ITEM_UNIT_NUMBER,' ') -- 3390458
1456 , L.EXPLOSION_DATE
1457 -- , L.FIRST_ACK_CODE
1458 -- , L.FIRST_ACK_DATE
1459 , L.FOB_POINT_CODE
1460 , NULL FREIGHT_CARRIER_CODE
1461 , L.FREIGHT_TERMS_CODE
1462 -- , L.FULFILLED_QUANTITY
1463 -- , L.FULFILLED_FLAG
1464 -- , L.FULFILLMENT_METHOD_CODE
1465 -- , L.FULFILLMENT_DATE
1466 , L.GLOBAL_ATTRIBUTE1
1467 , L.GLOBAL_ATTRIBUTE10
1468 , L.GLOBAL_ATTRIBUTE11
1469 , L.GLOBAL_ATTRIBUTE12
1470 , L.GLOBAL_ATTRIBUTE13
1471 , L.GLOBAL_ATTRIBUTE14
1472 , L.GLOBAL_ATTRIBUTE15
1473 , L.GLOBAL_ATTRIBUTE16
1474 , L.GLOBAL_ATTRIBUTE17
1475 , L.GLOBAL_ATTRIBUTE18
1476 , L.GLOBAL_ATTRIBUTE19
1477 , L.GLOBAL_ATTRIBUTE2
1478 , L.GLOBAL_ATTRIBUTE20
1479 , L.GLOBAL_ATTRIBUTE3
1480 , L.GLOBAL_ATTRIBUTE4
1481 , L.GLOBAL_ATTRIBUTE5
1482 , L.GLOBAL_ATTRIBUTE6
1483 , L.GLOBAL_ATTRIBUTE7
1484 , L.GLOBAL_ATTRIBUTE8
1485 , L.GLOBAL_ATTRIBUTE9
1486 , L.GLOBAL_ATTRIBUTE_CATEGORY
1487 , NULL HEADER_ID
1488 , L.INDUSTRY_ATTRIBUTE1
1489 , L.INDUSTRY_ATTRIBUTE10
1490 , L.INDUSTRY_ATTRIBUTE11
1491 , L.INDUSTRY_ATTRIBUTE12
1492 , L.INDUSTRY_ATTRIBUTE13
1493 , L.INDUSTRY_ATTRIBUTE14
1494 , L.INDUSTRY_ATTRIBUTE15
1495 , L.INDUSTRY_ATTRIBUTE16
1496 , L.INDUSTRY_ATTRIBUTE17
1497 , L.INDUSTRY_ATTRIBUTE18
1498 , L.INDUSTRY_ATTRIBUTE19
1499 , L.INDUSTRY_ATTRIBUTE20
1500 , L.INDUSTRY_ATTRIBUTE21
1501 , L.INDUSTRY_ATTRIBUTE22
1502 , L.INDUSTRY_ATTRIBUTE23
1503 , L.INDUSTRY_ATTRIBUTE24
1504 , L.INDUSTRY_ATTRIBUTE25
1505 , L.INDUSTRY_ATTRIBUTE26
1506 , L.INDUSTRY_ATTRIBUTE27
1507 , L.INDUSTRY_ATTRIBUTE28
1508 , L.INDUSTRY_ATTRIBUTE29
1509 , L.INDUSTRY_ATTRIBUTE30
1510 , L.INDUSTRY_ATTRIBUTE2
1511 , L.INDUSTRY_ATTRIBUTE3
1512 , L.INDUSTRY_ATTRIBUTE4
1513 , L.INDUSTRY_ATTRIBUTE5
1514 , L.INDUSTRY_ATTRIBUTE6
1515 , L.INDUSTRY_ATTRIBUTE7
1516 , L.INDUSTRY_ATTRIBUTE8
1517 , L.INDUSTRY_ATTRIBUTE9
1518 , L.INDUSTRY_CONTEXT
1519 -- , L.INTERMED_SHIP_TO_CONTACT_ID
1520 -- , L.INTERMED_SHIP_TO_ORG_ID
1521 , nvl(T.INVENTORY_ITEM_ID, L.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
1522 -- , L.INVOICE_INTERFACE_STATUS_CODE
1523 , L.INVOICE_TO_CONTACT_ID
1524 , L.INVOICE_TO_ORG_ID
1525 -- , L.INVOICED_QUANTITY
1526 , L.INVOICING_RULE_ID
1527 , L.CUSTOMER_ITEM_ID -- L.ORDERED_ITEM_ID
1528 , L.CUSTOMER_ITEM_ID_TYPE -- L.ITEM_IDENTIFIER_TYPE
1529 , L.CUSTOMER_ITEM_NAME -- L.ORDERED_ITEM
1530 , L.CUSTOMER_ITEM_NET_PRICE
1531 , L.CUSTOMER_PAYMENT_TERM_ID
1532 , L.ITEM_REVISION
1533 , nvl(T.ITEM_TYPE_CODE, L.ITEM_TYPE_CODE) ITEM_TYPE_CODE
1534 -- , L.LAST_ACK_CODE
1535 -- , L.LAST_ACK_DATE
1536 -- , L.LAST_UPDATED_BY
1537 -- , L.LAST_UPDATE_DATE
1538 -- , L.LAST_UPDATE_LOGIN
1539 , L.LATEST_ACCEPTABLE_DATE
1540 , NULL LINE_CATEGORY_CODE
1541 -- Use pre-generated line_id value from interface tables
1542 , L.LINE_ID
1543 , L.LINE_NUMBER
1544 , nvl(T.LINE_TYPE, L.LINE_TYPE_ID) LINE_TYPE
1545 , T.LINK_TO_LINE_ID
1546 , L.MODEL_GROUP_NUMBER
1547 , NULL MFG_LEAD_TIME
1548 -- , L.OPEN_FLAG
1549 , L.OPTION_FLAG
1550 , L.OPTION_NUMBER
1551 , nvl(T.ORDERED_QUANTITY, L.ORDERED_QUANTITY) ORDERED_QUANTITY
1552 , L.ORDERED_QUANTITY2 --OPM 02/JUN/00
1553 , nvl(T.UOM_CODE, L.ORDER_QUANTITY_UOM) UOM_CODE
1554 , L.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
1555 , L.ORG_ID
1556 , L.ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
1557 , L.ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
1558 , L.ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
1559 , L.CHANGE_SEQUENCE
1560 , L.OVER_SHIP_REASON_CODE
1561 , L.OVER_SHIP_RESOLVED_FLAG
1562 , L.PAYMENT_TERM_ID
1563 -- , L.PLANNING_PRIORITY
1564 , L.PREFERRED_GRADE --OPM HVOP
1565 , L.PRICE_LIST_ID
1566 -- , L.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
1567 , L.PRICING_ATTRIBUTE1
1568 , L.PRICING_ATTRIBUTE10
1569 , L.PRICING_ATTRIBUTE2
1570 , L.PRICING_ATTRIBUTE3
1571 , L.PRICING_ATTRIBUTE4
1572 , L.PRICING_ATTRIBUTE5
1573 , L.PRICING_ATTRIBUTE6
1574 , L.PRICING_ATTRIBUTE7
1575 , L.PRICING_ATTRIBUTE8
1576 , L.PRICING_ATTRIBUTE9
1577 , L.PRICING_CONTEXT
1578 , L.PRICING_DATE
1579 , L.PRICING_QUANTITY
1580 , L.PRICING_QUANTITY_UOM
1581 -- , L.PROGRAM_APPLICATION_ID
1582 -- , L.PROGRAM_ID
1583 -- , L.PROGRAM_UPDATE_DATE
1584 , L.PROJECT_ID
1585 , L.PROMISE_DATE
1586 , NULL RE_SOURCE_FLAG
1587 -- , L.REFERENCE_CUSTOMER_TRX_LINE_ID
1588 , L.REFERENCE_HEADER_ID
1589 , L.REFERENCE_LINE_ID
1590 , L.REFERENCE_TYPE
1591 , L.REQUEST_DATE
1592 , L.REQUEST_ID
1593 , L.RETURN_ATTRIBUTE1
1594 , L.RETURN_ATTRIBUTE10
1595 , L.RETURN_ATTRIBUTE11
1596 , L.RETURN_ATTRIBUTE12
1597 , L.RETURN_ATTRIBUTE13
1598 , L.RETURN_ATTRIBUTE14
1599 , L.RETURN_ATTRIBUTE15
1600 , L.RETURN_ATTRIBUTE2
1601 , L.RETURN_ATTRIBUTE3
1602 , L.RETURN_ATTRIBUTE4
1603 , L.RETURN_ATTRIBUTE5
1604 , L.RETURN_ATTRIBUTE6
1605 , L.RETURN_ATTRIBUTE7
1606 , L.RETURN_ATTRIBUTE8
1607 , L.RETURN_ATTRIBUTE9
1608 , L.RETURN_CONTEXT
1609 , L.RETURN_REASON_CODE
1610 -- , L.RLA_SCHEDULE_TYPE_CODE
1611 , L.SALESREP_ID
1612 , L.SCHEDULE_ARRIVAL_DATE
1613 , L.SCHEDULE_SHIP_DATE
1614 , L.SCHEDULE_STATUS_CODE
1615 , L.SHIPMENT_NUMBER
1616 , L.SHIPMENT_PRIORITY_CODE
1617 , L.SHIPPED_QUANTITY
1618 , L.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
1619 , L.SHIPPING_METHOD_CODE
1620 , L.SHIPPING_QUANTITY
1621 , L.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
1622 , L.SHIPPING_QUANTITY_UOM
1623 , L.SHIP_FROM_ORG_ID
1624 , L.SUBINVENTORY
1625 , L.SHIP_SET_ID
1626 , L.SHIP_TOLERANCE_ABOVE
1627 , L.SHIP_TOLERANCE_BELOW
1628 , NULL SHIPPABLE_FLAG
1629 -- , L.SHIPPING_INTERFACED_FLAG
1630 , L.SHIP_TO_CONTACT_ID
1631 , L.SHIP_TO_ORG_ID
1632 , L.SHIP_MODEL_COMPLETE_FLAG
1633 , L.SOLD_TO_ORG_ID
1634 , L.SOLD_FROM_ORG_ID
1635 , T.SORT_ORDER SORT_ORDER
1636 , NULL SOURCE_DOCUMENT_ID
1637 -- , L.SOURCE_DOCUMENT_LINE_ID
1638 -- , L.SOURCE_DOCUMENT_TYPE_ID
1639 , L.SOURCE_TYPE_CODE
1640 , L.SPLIT_FROM_LINE_ID
1641 -- , L.LINE_SET_ID
1642 -- , L.SPLIT_BY
1643 , 'N' MODEL_REMNANT_FLAG
1644 , L.TASK_ID
1645 , L.TAX_CODE
1646 , L.TAX_DATE
1647 , L.TAX_EXEMPT_FLAG
1648 , L.TAX_EXEMPT_NUMBER
1649 , L.TAX_EXEMPT_REASON_CODE
1650 , L.TAX_POINT_CODE
1651 -- , L.TAX_RATE
1652 , L.TAX_VALUE
1653 , T.TOP_MODEL_LINE_ID
1654 , T.TOP_MODEL_LINE_REF TOP_MODEL_LINE_REF
1655 , L.UNIT_LIST_PRICE
1656 , L.UNIT_LIST_PRICE_PER_PQTY
1657 , L.UNIT_SELLING_PRICE
1658 , L.UNIT_SELLING_PRICE_PER_PQTY
1659 , NULL VISIBLE_DEMAND_FLAG
1660 , L.VEH_CUS_ITEM_CUM_KEY_ID
1661 , RTRIM(L.SHIPPING_INSTRUCTIONS,' ') -- 33090458
1662 , RTRIM(L.PACKING_INSTRUCTIONS,' ') -- 33090458
1663 , L.SERVICE_TXN_REASON_CODE
1664 , L.SERVICE_TXN_COMMENTS
1665 , L.SERVICE_DURATION
1666 , L.SERVICE_PERIOD
1667 , L.SERVICE_START_DATE
1668 , L.SERVICE_END_DATE
1669 , L.SERVICE_COTERMINATE_FLAG
1670 , L.UNIT_LIST_PERCENT
1671 , L.UNIT_SELLING_PERCENT
1672 , L.UNIT_PERCENT_BASE_PRICE
1673 , L.SERVICE_NUMBER
1674 , L.SERVICE_REFERENCE_TYPE_CODE
1675 -- , L.SERVICE_REFERENCE_LINE_ID
1676 -- , L.SERVICE_REFERENCE_SYSTEM_ID
1677 , RTRIM(L.TP_CONTEXT,' ') -- 3390458
1678 , RTRIM(L.TP_ATTRIBUTE1,' ') -- 3390458
1679 , RTRIM(L.TP_ATTRIBUTE2,' ') -- 3390458
1680 , RTRIM(L.TP_ATTRIBUTE3,' ') -- 3390458
1681 , RTRIM(L.TP_ATTRIBUTE4,' ') -- 3390458
1682 , RTRIM(L.TP_ATTRIBUTE5,' ') -- 3390458
1683 , RTRIM(L.TP_ATTRIBUTE6,' ') -- 3390458
1684 , RTRIM(L.TP_ATTRIBUTE7,' ') -- 3390458
1685 , RTRIM(L.TP_ATTRIBUTE8,' ') -- 3390458
1686 , RTRIM(L.TP_ATTRIBUTE9,' ') -- 3390458
1687 , RTRIM(L.TP_ATTRIBUTE10,' ') -- 3390458
1688 , RTRIM(L.TP_ATTRIBUTE11,' ') -- 3390458
1689 , RTRIM(L.TP_ATTRIBUTE12,' ') -- 3390458
1690 , RTRIM(L.TP_ATTRIBUTE13,' ') -- 3390458
1691 , RTRIM(L.TP_ATTRIBUTE14,' ') -- 3390458
1692 , RTRIM(L.TP_ATTRIBUTE15,' ') -- 3390458
1693 -- , L.FLOW_STATUS_CODE
1694 -- , L.MARKETING_SOURCE_CODE_ID
1695 , L.CALCULATE_PRICE_FLAG
1696 , L.COMMITMENT_ID
1697 , L.ORDER_SOURCE_ID ORDER_SOURCE_ID
1698 -- , L.upgraded_flag
1699 , 1 LOCK_CONTROL
1700 , NULL wf_process_name
1701 , NULL ii_start_index
1702 , NULL ii_count
1703 , RTRIM(L.user_item_description,' ') user_item_description
1704 , NULL parent_line_index
1705 , NULL Firm_Demand_flag
1706 -- end customer
1707 ,L.End_customer_contact_id
1708 ,L.End_customer_id
1709 ,L.End_customer_site_use_id
1710 ,L.IB_owner_code
1711 ,L.IB_current_location_code
1712 ,L.IB_Installed_at_Location_code
1713 , NULL cust_trx_type_id
1714 , NULL tax_calculation_flag
1715 , NULL ato_line_index
1716 , NULL top_model_line_index
1717 FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
1718 , OE_CONFIG_DETAILS_TMP T
1719 WHERE h.batch_id = p_batch_id
1720 AND h.order_source_id = l.order_source_id
1721 AND h.orig_sys_document_ref = l.orig_sys_document_ref
1722 AND nvl(h.error_flag,'N') = 'N'
1723 AND nvl(h.ineligible_for_hvop, 'N') <> 'Y'
1724 AND nvl(l.error_flag,'N') = 'N'
1725 AND nvl(l.rejected_flag,'N') = 'N'
1726 AND l.line_id = t.line_id(+)
1727 UNION ALL
1728 SELECT /*+ ORDERED USE_NL(H L) USE_INDEX(H OE_HEADERS_IFACE_ALL_N2) */
1729 NULL ACCOUNTING_RULE_ID
1730 , NULL ACCOUNTING_RULE_DURATION
1731 , NULL ACTUAL_ARRIVAL_DATE
1732 -- , NULL ACTUAL_SHIPMENT_DATE
1733 , NULL AGREEMENT_ID
1734 , NULL ARRIVAL_SET_ID
1735 , T.ATO_LINE_ID ATO_LINE_ID
1736 , NULL ATTRIBUTE1
1737 , NULL ATTRIBUTE10
1738 , NULL ATTRIBUTE11
1739 , NULL ATTRIBUTE12
1740 , NULL ATTRIBUTE13
1741 , NULL ATTRIBUTE14
1742 , NULL ATTRIBUTE15
1743 , NULL ATTRIBUTE16 --For bug 2184255
1744 , NULL ATTRIBUTE17
1745 , NULL ATTRIBUTE18
1746 , NULL ATTRIBUTE19
1747 , NULL ATTRIBUTE2
1748 , NULL ATTRIBUTE20
1749 , NULL ATTRIBUTE3
1750 , NULL ATTRIBUTE4
1751 , NULL ATTRIBUTE5
1752 , NULL ATTRIBUTE6
1753 , NULL ATTRIBUTE7
1754 , NULL ATTRIBUTE8
1755 , NULL ATTRIBUTE9
1756 -- , L.AUTO_SELECTED_QUANTITY
1757 , NULL AUTHORIZED_TO_SHIP_FLAG
1758 , NULL BOOKED_FLAG
1759 , 'N' CANCELLED_FLAG
1760 , NULL CANCELLED_QUANTITY
1761 , T.COMPONENT_CODE COMPONENT_CODE
1762 , NULL COMPONENT_NUMBER
1763 , T.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
1764 , T.CONFIG_HEADER_ID CONFIG_HEADER_ID
1765 , T.CONFIG_REV_NBR CONFIG_REV_NBR
1766 , null CONFIG_DISPLAY_SEQUENCE
1767 , T.CONFIGURATION_ID CONFIGURATION_ID
1768 , NULL CONTEXT
1769 -- , L.CREATED_BY
1770 -- , L.CREATION_DATE
1771 , NULL CREDIT_INVOICE_LINE_ID
1772 , NULL CUSTOMER_DOCK_CODE
1773 , NULL CUSTOMER_JOB
1774 , NULL CUSTOMER_PRODUCTION_LINE
1775 , NULL CUST_PRODUCTION_SEQ_NUM
1776 -- , L.CUSTOMER_TRX_LINE_ID
1777 , NULL CUST_MODEL_SERIAL_NUMBER
1778 , NULL CUSTOMER_PO_NUMBER
1779 , NULL CUSTOMER_LINE_NUMBER
1780 , NULL DELIVERY_LEAD_TIME
1781 , NULL DELIVER_TO_CONTACT_ID
1782 , NULL DELIVER_TO_ORG_ID
1783 , NULL DEMAND_BUCKET_TYPE_CODE
1784 , NULL DEMAND_CLASS_CODE
1785 -- , L.DEP_PLAN_REQUIRED_FLAG
1786 , NULL EARLIEST_ACCEPTABLE_DATE
1787 , NULL END_ITEM_UNIT_NUMBER
1788 , NULL EXPLOSION_DATE
1789 -- , L.FIRST_ACK_CODE
1790 -- , L.FIRST_ACK_DATE
1791 , NULL FOB_POINT_CODE
1792 , NULL FREIGHT_CARRIER_CODE
1793 , NULL FREIGHT_TERMS_CODE
1794 -- , L.FULFILLED_QUANTITY
1795 -- , L.FULFILLED_FLAG
1796 -- , L.FULFILLMENT_METHOD_CODE
1797 -- , L.FULFILLMENT_DATE
1798 , NULL GLOBAL_ATTRIBUTE1
1799 , NULL GLOBAL_ATTRIBUTE10
1800 , NULL GLOBAL_ATTRIBUTE11
1801 , NULL GLOBAL_ATTRIBUTE12
1802 , NULL GLOBAL_ATTRIBUTE13
1803 , NULL GLOBAL_ATTRIBUTE14
1804 , NULL GLOBAL_ATTRIBUTE15
1805 , NULL GLOBAL_ATTRIBUTE16
1806 , NULL GLOBAL_ATTRIBUTE17
1807 , NULL GLOBAL_ATTRIBUTE18
1808 , NULL GLOBAL_ATTRIBUTE19
1809 , NULL GLOBAL_ATTRIBUTE2
1810 , NULL GLOBAL_ATTRIBUTE20
1811 , NULL GLOBAL_ATTRIBUTE3
1812 , NULL GLOBAL_ATTRIBUTE4
1813 , NULL GLOBAL_ATTRIBUTE5
1814 , NULL GLOBAL_ATTRIBUTE6
1815 , NULL GLOBAL_ATTRIBUTE7
1816 , NULL GLOBAL_ATTRIBUTE8
1817 , NULL GLOBAL_ATTRIBUTE9
1818 , NULL GLOBAL_ATTRIBUTE_CATEGORY
1819 , NULL HEADER_ID
1820 , NULL INDUSTRY_ATTRIBUTE1
1821 , NULL INDUSTRY_ATTRIBUTE10
1822 , NULL INDUSTRY_ATTRIBUTE11
1823 , NULL INDUSTRY_ATTRIBUTE12
1824 , NULL INDUSTRY_ATTRIBUTE13
1825 , NULL INDUSTRY_ATTRIBUTE14
1826 , NULL INDUSTRY_ATTRIBUTE15
1827 , NULL INDUSTRY_ATTRIBUTE16
1828 , NULL INDUSTRY_ATTRIBUTE17
1829 , NULL INDUSTRY_ATTRIBUTE18
1830 , NULL INDUSTRY_ATTRIBUTE19
1831 , NULL INDUSTRY_ATTRIBUTE20
1832 , NULL INDUSTRY_ATTRIBUTE21
1833 , NULL INDUSTRY_ATTRIBUTE22
1834 , NULL INDUSTRY_ATTRIBUTE23
1835 , NULL INDUSTRY_ATTRIBUTE24
1836 , NULL INDUSTRY_ATTRIBUTE25
1837 , NULL INDUSTRY_ATTRIBUTE26
1838 , NULL INDUSTRY_ATTRIBUTE27
1839 , NULL INDUSTRY_ATTRIBUTE28
1840 , NULL INDUSTRY_ATTRIBUTE29
1841 , NULL INDUSTRY_ATTRIBUTE30
1842 , NULL INDUSTRY_ATTRIBUTE2
1843 , NULL INDUSTRY_ATTRIBUTE3
1844 , NULL INDUSTRY_ATTRIBUTE4
1845 , NULL INDUSTRY_ATTRIBUTE5
1846 , NULL INDUSTRY_ATTRIBUTE6
1847 , NULL INDUSTRY_ATTRIBUTE7
1848 , NULL INDUSTRY_ATTRIBUTE8
1849 , NULL INDUSTRY_ATTRIBUTE9
1850 , NULL INDUSTRY_CONTEXT
1851 -- , L.INTERMED_SHIP_TO_CONTACT_ID
1852 -- , L.INTERMED_SHIP_TO_ORG_ID
1853 , T.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
1854 -- , NULL INVOICE_INTERFACE_STATUS_CODE
1855 , NULL INVOICE_TO_CONTACT_ID
1856 , NULL INVOICE_TO_ORG_ID
1857 -- , NULL INVOICED_QUANTITY
1858 , NULL INVOICING_RULE_ID
1859 , NULL CUSTOMER_ITEM_ID -- L.ORDERED_ITEM_ID
1860 , NULL CUSTOMER_ITEM_ID_TYPE -- L.ITEM_IDENTIFIER_TYPE
1861 , NULL CUSTOMER_ITEM_NAME -- L.ORDERED_ITEM
1862 , NULL CUSTOMER_ITEM_NET_PRICE
1863 , NULL CUSTOMER_PAYMENT_TERM_ID
1864 , NULL ITEM_REVISION
1865 , T.ITEM_TYPE_CODE ITEM_TYPE_CODE
1866 -- , L.LAST_ACK_CODE
1867 -- , L.LAST_ACK_DATE
1868 -- , L.LAST_UPDATED_BY
1869 -- , L.LAST_UPDATE_DATE
1870 -- , L.LAST_UPDATE_LOGIN
1871 , NULL LATEST_ACCEPTABLE_DATE
1872 , NULL LINE_CATEGORY_CODE
1873 -- Use pre-generated line_id value from interface tables
1874 , T.LINE_ID LINE_ID
1875 , NULL LINE_NUMBER
1876 , T.LINE_TYPE LINE_TYPE
1877 , T.LINK_TO_LINE_ID LINK_TO_LINE_ID
1878 , NULL MODEL_GROUP_NUMBER
1879 , NULL MFG_LEAD_TIME
1880 -- , L.OPEN_FLAG
1881 , NULL OPTION_FLAG
1882 , NULL OPTION_NUMBER
1883 , T.ORDERED_QUANTITY ORDERED_QUANTITY
1884 , NULL ORDERED_QUANTITY2 --OPM 02/JUN/00
1885 , T.UOM_CODE UOM_CODE
1886 , NULL ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
1887 , L.ORG_ID
1888 , T.ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
1889 , T.ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
1890 , T.ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
1891 , NULL CHANGE_SEQUENCE
1892 , NULL OVER_SHIP_REASON_CODE
1893 , NULL OVER_SHIP_RESOLVED_FLAG
1894 , NULL PAYMENT_TERM_ID
1895 -- , NULL PLANNING_PRIORITY
1896 , NULL PREFERRED_GRADE --OPM HVOP
1897 , NULL PRICE_LIST_ID
1898 -- , NULL PRICE_REQUEST_CODE --PROMOTIONS MAY/01
1899 , NULL PRICING_ATTRIBUTE1
1900 , NULL PRICING_ATTRIBUTE10
1901 , NULL PRICING_ATTRIBUTE2
1902 , NULL PRICING_ATTRIBUTE3
1903 , NULL PRICING_ATTRIBUTE4
1904 , NULL PRICING_ATTRIBUTE5
1905 , NULL PRICING_ATTRIBUTE6
1906 , NULL PRICING_ATTRIBUTE7
1907 , NULL PRICING_ATTRIBUTE8
1908 , NULL PRICING_ATTRIBUTE9
1909 , NULL PRICING_CONTEXT
1910 , NULL PRICING_DATE
1911 , NULL PRICING_QUANTITY
1912 , NULL PRICING_QUANTITY_UOM
1913 -- , L.PROGRAM_APPLICATION_ID
1914 -- , L.PROGRAM_ID
1915 -- , L.PROGRAM_UPDATE_DATE
1916 , NULL PROJECT_ID
1917 , NULL PROMISE_DATE
1918 , NULL RE_SOURCE_FLAG
1919 -- , L.REFERENCE_CUSTOMER_TRX_LINE_ID
1920 , L.REFERENCE_HEADER_ID
1921 , NULL REFERENCE_LINE_ID
1922 , NULL REFERENCE_TYPE
1923 , NULL REQUEST_DATE
1924 , NULL REQUEST_ID
1925 , NULL RETURN_ATTRIBUTE1
1926 , NULL RETURN_ATTRIBUTE10
1927 , NULL RETURN_ATTRIBUTE11
1928 , NULL RETURN_ATTRIBUTE12
1929 , NULL RETURN_ATTRIBUTE13
1930 , NULL RETURN_ATTRIBUTE14
1931 , NULL RETURN_ATTRIBUTE15
1932 , NULL RETURN_ATTRIBUTE2
1933 , NULL RETURN_ATTRIBUTE3
1934 , NULL RETURN_ATTRIBUTE4
1935 , NULL RETURN_ATTRIBUTE5
1936 , NULL RETURN_ATTRIBUTE6
1937 , NULL RETURN_ATTRIBUTE7
1938 , NULL RETURN_ATTRIBUTE8
1939 , NULL RETURN_ATTRIBUTE9
1940 , NULL RETURN_CONTEXT
1941 , NULL RETURN_REASON_CODE
1942 -- , L.RLA_SCHEDULE_TYPE_CODE
1943 , NULL SALESREP_ID
1944 , NULL SCHEDULE_ARRIVAL_DATE
1945 , NULL SCHEDULE_SHIP_DATE
1946 , NULL SCHEDULE_STATUS_CODE
1947 , NULL SHIPMENT_NUMBER
1948 , NULL SHIPMENT_PRIORITY_CODE
1949 , NULL SHIPPED_QUANTITY
1950 , NULL SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
1951 , NULL SHIPPING_METHOD_CODE
1952 , NULL SHIPPING_QUANTITY
1953 , NULL SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
1954 , NULL SHIPPING_QUANTITY_UOM
1955 , NULL SHIP_FROM_ORG_ID
1956 , NULL SUBINVENTORY
1957 , NULL SHIP_SET_ID
1958 , NULL SHIP_TOLERANCE_ABOVE
1959 , NULL SHIP_TOLERANCE_BELOW
1960 , NULL SHIPPABLE_FLAG
1961 -- , L.SHIPPING_INTERFACED_FLAG
1962 , NULL SHIP_TO_CONTACT_ID
1963 , NULL SHIP_TO_ORG_ID
1964 , NULL SHIP_MODEL_COMPLETE_FLAG
1965 , NULL SOLD_TO_ORG_ID
1966 , NULL SOLD_FROM_ORG_ID
1967 , T.SORT_ORDER SORT_ORDER
1968 , NULL SOURCE_DOCUMENT_ID
1969 -- , L.SOURCE_DOCUMENT_LINE_ID
1970 -- , L.SOURCE_DOCUMENT_TYPE_ID
1971 , NULL SOURCE_TYPE_CODE
1972 , NULL SPLIT_FROM_LINE_ID
1973 -- , NULL LINE_SET_ID
1974 -- , NULL SPLIT_BY
1975 , 'N' MODEL_REMNANT_FLAG
1976 , NULL TASK_ID
1977 , NULL TAX_CODE
1978 , NULL TAX_DATE
1979 , NULL TAX_EXEMPT_FLAG
1980 , NULL TAX_EXEMPT_NUMBER
1981 , NULL TAX_EXEMPT_REASON_CODE
1982 , NULL TAX_POINT_CODE
1983 -- , NULL TAX_RATE
1984 , NULL TAX_VALUE
1985 , T.TOP_MODEL_LINE_ID
1986 , T.TOP_MODEL_LINE_REF TOP_MODEL_LINE_REF
1987 , NULL UNIT_LIST_PRICE
1988 , NULL UNIT_LIST_PRICE_PER_PQTY
1989 , NULL UNIT_SELLING_PRICE
1990 , NULL UNIT_SELLING_PRICE_PER_PQTY
1991 , NULL VISIBLE_DEMAND_FLAG
1992 , NULL VEH_CUS_ITEM_CUM_KEY_ID
1993 , NULL SHIPPING_INSTRUCTIONS
1994 , NULL PACKING_INSTRUCTIONS
1995 , NULL SERVICE_TXN_REASON_CODE
1996 , NULL SERVICE_TXN_COMMENTS
1997 , NULL SERVICE_DURATION
1998 , NULL SERVICE_PERIOD
1999 , NULL SERVICE_START_DATE
2000 , NULL SERVICE_END_DATE
2001 , NULL SERVICE_COTERMINATE_FLAG
2002 , NULL UNIT_LIST_PERCENT
2003 , NULL UNIT_SELLING_PERCENT
2004 , NULL UNIT_PERCENT_BASE_PRICE
2005 , NULL SERVICE_NUMBER
2006 , NULL SERVICE_REFERENCE_TYPE_CODE
2007 -- , NULL SERVICE_REFERENCE_LINE_ID
2008 -- , NULL SERVICE_REFERENCE_SYSTEM_ID
2009 , NULL TP_CONTEXT
2010 , NULL TP_ATTRIBUTE1
2011 , NULL TP_ATTRIBUTE2
2012 , NULL TP_ATTRIBUTE3
2013 , NULL TP_ATTRIBUTE4
2014 , NULL TP_ATTRIBUTE5
2015 , NULL TP_ATTRIBUTE6
2016 , NULL TP_ATTRIBUTE7
2017 , NULL TP_ATTRIBUTE8
2018 , NULL TP_ATTRIBUTE9
2019 , NULL TP_ATTRIBUTE10
2020 , NULL TP_ATTRIBUTE11
2021 , NULL TP_ATTRIBUTE12
2022 , NULL TP_ATTRIBUTE13
2023 , NULL TP_ATTRIBUTE14
2024 , NULL TP_ATTRIBUTE15
2025 -- , NULL FLOW_STATUS_CODE
2026 -- , NULL MARKETING_SOURCE_CODE_ID
2027 , NULL CALCULATE_PRICE_FLAG
2028 , NULL COMMITMENT_ID
2029 , T.ORDER_SOURCE_ID ORDER_SOURCE_ID
2030 -- , NULL upgraded_flag
2031 , 1 LOCK_CONTROL
2032 , NULL wf_process_name
2033 , NULL ii_start_index
2034 , NULL ii_count
2035 , NULL user_item_description
2036 , NULL parent_line_index
2037 , NULL Firm_Demand_flag
2038 -- end customer
2039 ,NULL End_customer_contact_id
2040 ,NULL End_customer_id
2041 ,NULL End_customer_site_use_id
2042 ,NULL IB_owner_code
2043 ,NULL IB_current_location_code
2044 ,NULL IB_Installed_at_Location_code
2045 , NULL cust_trx_type_id
2046 , NULL tax_calculation_flag
2047 , NULL ato_line_index
2048 , NULL top_model_line_index
2049 FROM OE_HEADERS_IFACE_ALL H, OE_LINES_IFACE_ALL L
2050 , OE_CONFIG_DETAILS_TMP T
2051 WHERE h.batch_id = p_batch_id
2052 AND h.order_source_id = l.order_source_id
2053 AND h.orig_sys_document_ref = l.orig_sys_document_ref
2054 AND nvl(h.error_flag,'N') = 'N'
2055 AND nvl(h.ineligible_for_hvop, 'N') <> 'Y'
2056 AND nvl(l.error_flag,'N') = 'N'
2057 AND nvl(l.rejected_flag,'N') = 'N'
2058 AND l.order_source_id = t.order_source_id
2059 AND l.orig_sys_document_ref = t.orig_sys_document_ref
2060 AND l.top_model_line_ref = t.top_model_line_ref
2061 AND l.item_type_code = 'MODEL'
2062 AND NOT EXISTS ( select 1
2063 from OE_LINES_IFACE_ALL L1
2064 where l1.line_id = t.line_id)) LINES
2065 ORDER BY order_source_id,
2066 orig_sys_document_ref,
2067 decode(top_model_line_ref, NULL, orig_sys_line_ref, top_model_line_ref),
2068 orig_sys_shipment_ref,
2069 sort_order;
2070
2071
2072 --
2073 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2074 --
2075 BEGIN
2076
2077 IF OE_BULK_ORDER_IMPORT_PVT.G_RTRIM_IFACE_DATA = 'N' THEN
2078 IF p_process_configurations = 'N'
2079 THEN
2080 oe_debug_pub.add('before OPEN c_lines');
2081
2082 OPEN c_lines;
2083 oe_debug_pub.add('after OPEN c_lines');
2084 FETCH c_lines BULK COLLECT INTO
2085 p_line_rec.ACCOUNTING_RULE_ID
2086 ,p_line_rec.ACCOUNTING_RULE_DURATION
2087 ,p_line_rec.ACTUAL_ARRIVAL_DATE
2088 --,p_line_rec.ACTUAL_SHIPMENT_DATE
2089 ,p_line_rec.AGREEMENT_ID
2090 ,p_line_rec.ARRIVAL_SET_ID
2091 ,p_line_rec.ATO_LINE_ID
2092 ,p_line_rec.ATTRIBUTE1
2093 ,p_line_rec.ATTRIBUTE10
2094 ,p_line_rec.ATTRIBUTE11
2095 ,p_line_rec.ATTRIBUTE12
2096 ,p_line_rec.ATTRIBUTE13
2097 ,p_line_rec.ATTRIBUTE14
2098 ,p_line_rec.ATTRIBUTE15
2099 ,p_line_rec.ATTRIBUTE16 --For bug 2184255
2100 ,p_line_rec.ATTRIBUTE17
2101 ,p_line_rec.ATTRIBUTE18
2102 ,p_line_rec.ATTRIBUTE19
2103 ,p_line_rec.ATTRIBUTE2
2104 ,p_line_rec.ATTRIBUTE20
2105 ,p_line_rec.ATTRIBUTE3
2106 ,p_line_rec.ATTRIBUTE4
2107 ,p_line_rec.ATTRIBUTE5
2108 ,p_line_rec.ATTRIBUTE6
2109 ,p_line_rec.ATTRIBUTE7
2110 ,p_line_rec.ATTRIBUTE8
2111 ,p_line_rec.ATTRIBUTE9
2112 --,p_line_rec.AUTO_SELECTED_QUANTITY
2113 ,p_line_rec.AUTHORIZED_TO_SHIP_FLAG
2114 ,p_line_rec.BOOKED_FLAG
2115 ,p_line_rec.CANCELLED_FLAG
2116 ,p_line_rec.CANCELLED_QUANTITY
2117 ,p_line_rec.COMPONENT_CODE
2118 ,p_line_rec.COMPONENT_NUMBER
2119 ,p_line_rec.COMPONENT_SEQUENCE_ID
2120 ,p_line_rec.CONFIG_HEADER_ID
2121 ,p_line_rec.CONFIG_REV_NBR
2122 ,p_line_rec.CONFIG_DISPLAY_SEQUENCE
2123 ,p_line_rec.CONFIGURATION_ID
2124 ,p_line_rec.CONTEXT
2125 --,p_line_rec.CREATED_BY
2126 --,p_line_rec.CREATION_DATE
2127 ,p_line_rec.CREDIT_INVOICE_LINE_ID
2128 ,p_line_rec.CUSTOMER_DOCK_CODE
2129 ,p_line_rec.CUSTOMER_JOB
2130 ,p_line_rec.CUSTOMER_PRODUCTION_LINE
2131 ,p_line_rec.CUST_PRODUCTION_SEQ_NUM
2132 --,p_line_rec.CUSTOMER_TRX_LINE_ID
2133 ,p_line_rec.CUST_MODEL_SERIAL_NUMBER
2134 ,p_line_rec.CUST_PO_NUMBER
2135 ,p_line_rec.CUSTOMER_LINE_NUMBER
2136 ,p_line_rec.DELIVERY_LEAD_TIME
2137 ,p_line_rec.DELIVER_TO_CONTACT_ID
2138 ,p_line_rec.DELIVER_TO_ORG_ID
2139 ,p_line_rec.DEMAND_BUCKET_TYPE_CODE
2140 ,p_line_rec.DEMAND_CLASS_CODE
2141 --,p_line_rec.DEP_PLAN_REQUIRED_FLAG
2142 ,p_line_rec.EARLIEST_ACCEPTABLE_DATE
2143 ,p_line_rec.END_ITEM_UNIT_NUMBER
2144 ,p_line_rec.EXPLOSION_DATE
2145 --,p_line_rec.FIRST_ACK_CODE
2146 --,p_line_rec.FIRST_ACK_DATE
2147 ,p_line_rec.FOB_POINT_CODE
2148 ,p_line_rec.FREIGHT_CARRIER_CODE
2149 ,p_line_rec.FREIGHT_TERMS_CODE
2150 --,p_line_rec.FULFILLED_QUANTITY
2151 --,p_line_rec.FULFILLED_FLAG
2152 --,p_line_rec.FULFILLMENT_METHOD_CODE
2153 --,p_line_rec.FULFILLMENT_DATE
2154 ,p_line_rec.GLOBAL_ATTRIBUTE1
2155 ,p_line_rec.GLOBAL_ATTRIBUTE10
2156 ,p_line_rec.GLOBAL_ATTRIBUTE11
2157 ,p_line_rec.GLOBAL_ATTRIBUTE12
2158 ,p_line_rec.GLOBAL_ATTRIBUTE13
2159 ,p_line_rec.GLOBAL_ATTRIBUTE14
2160 ,p_line_rec.GLOBAL_ATTRIBUTE15
2161 ,p_line_rec.GLOBAL_ATTRIBUTE16
2162 ,p_line_rec.GLOBAL_ATTRIBUTE17
2163 ,p_line_rec.GLOBAL_ATTRIBUTE18
2164 ,p_line_rec.GLOBAL_ATTRIBUTE19
2165 ,p_line_rec.GLOBAL_ATTRIBUTE2
2166 ,p_line_rec.GLOBAL_ATTRIBUTE20
2167 ,p_line_rec.GLOBAL_ATTRIBUTE3
2168 ,p_line_rec.GLOBAL_ATTRIBUTE4
2169 ,p_line_rec.GLOBAL_ATTRIBUTE5
2170 ,p_line_rec.GLOBAL_ATTRIBUTE6
2171 ,p_line_rec.GLOBAL_ATTRIBUTE7
2172 ,p_line_rec.GLOBAL_ATTRIBUTE8
2173 ,p_line_rec.GLOBAL_ATTRIBUTE9
2174 ,p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
2175 ,p_line_rec.HEADER_ID
2176 ,p_line_rec.INDUSTRY_ATTRIBUTE1
2177 ,p_line_rec.INDUSTRY_ATTRIBUTE10
2178 ,p_line_rec.INDUSTRY_ATTRIBUTE11
2179 ,p_line_rec.INDUSTRY_ATTRIBUTE12
2180 ,p_line_rec.INDUSTRY_ATTRIBUTE13
2181 ,p_line_rec.INDUSTRY_ATTRIBUTE14
2182 ,p_line_rec.INDUSTRY_ATTRIBUTE15
2183 ,p_line_rec.INDUSTRY_ATTRIBUTE16
2184 ,p_line_rec.INDUSTRY_ATTRIBUTE17
2185 ,p_line_rec.INDUSTRY_ATTRIBUTE18
2186 ,p_line_rec.INDUSTRY_ATTRIBUTE19
2187 ,p_line_rec.INDUSTRY_ATTRIBUTE20
2188 ,p_line_rec.INDUSTRY_ATTRIBUTE21
2189 ,p_line_rec.INDUSTRY_ATTRIBUTE22
2190 ,p_line_rec.INDUSTRY_ATTRIBUTE23
2191 ,p_line_rec.INDUSTRY_ATTRIBUTE24
2192 ,p_line_rec.INDUSTRY_ATTRIBUTE25
2193 ,p_line_rec.INDUSTRY_ATTRIBUTE26
2194 ,p_line_rec.INDUSTRY_ATTRIBUTE27
2195 ,p_line_rec.INDUSTRY_ATTRIBUTE28
2196 ,p_line_rec.INDUSTRY_ATTRIBUTE29
2197 ,p_line_rec.INDUSTRY_ATTRIBUTE30
2198 ,p_line_rec.INDUSTRY_ATTRIBUTE2
2199 ,p_line_rec.INDUSTRY_ATTRIBUTE3
2200 ,p_line_rec.INDUSTRY_ATTRIBUTE4
2201 ,p_line_rec.INDUSTRY_ATTRIBUTE5
2202 ,p_line_rec.INDUSTRY_ATTRIBUTE6
2203 ,p_line_rec.INDUSTRY_ATTRIBUTE7
2204 ,p_line_rec.INDUSTRY_ATTRIBUTE8
2205 ,p_line_rec.INDUSTRY_ATTRIBUTE9
2206 ,p_line_rec.INDUSTRY_CONTEXT
2207 --,p_line_rec.INTERMED_SHIP_TO_CONTACT_ID
2208 --,p_line_rec.INTERMED_SHIP_TO_ORG_ID
2209 ,p_line_rec.INVENTORY_ITEM_ID
2210 --,p_line_rec.INVOICE_INTERFACE_STATUS_CODE
2211 ,p_line_rec.INVOICE_TO_CONTACT_ID
2212 ,p_line_rec.INVOICE_TO_ORG_ID
2213 --,p_line_rec.INVOICED_QUANTITY
2214 ,p_line_rec.INVOICING_RULE_ID
2215 ,p_line_rec.ORDERED_ITEM_ID
2216 ,p_line_rec.ITEM_IDENTIFIER_TYPE
2217 ,p_line_rec.ORDERED_ITEM
2218 ,p_line_rec.CUSTOMER_ITEM_NET_PRICE
2219 ,p_line_rec.CUSTOMER_PAYMENT_TERM_ID
2220 ,p_line_rec.ITEM_REVISION
2221 ,p_line_rec.ITEM_TYPE_CODE
2222 --,p_line_rec.LAST_ACK_CODE
2223 --,p_line_rec.LAST_ACK_DATE
2224 --,p_line_rec.LAST_UPDATED_BY
2225 --,p_line_rec.LAST_UPDATE_DATE
2226 --,p_line_rec.LAST_UPDATE_LOGIN
2227 ,p_line_rec.LATEST_ACCEPTABLE_DATE
2228 ,p_line_rec.LINE_CATEGORY_CODE
2229 ,p_line_rec.LINE_ID
2230 ,p_line_rec.LINE_NUMBER
2231 ,p_line_rec.LINE_TYPE_ID
2232 ,p_line_rec.LINK_TO_LINE_ID
2233 ,p_line_rec.MODEL_GROUP_NUMBER
2234 ,p_line_rec.MFG_LEAD_TIME
2235 --,p_line_rec.OPEN_FLAG
2236 ,p_line_rec.OPTION_FLAG
2237 ,p_line_rec.OPTION_NUMBER
2238 ,p_line_rec.ORDERED_QUANTITY
2239 ,p_line_rec.ORDERED_QUANTITY2 --OPM 02/JUN/00
2240 ,p_line_rec.ORDER_QUANTITY_UOM
2241 ,p_line_rec.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
2242 ,p_line_rec.ORG_ID
2243 ,p_line_rec.ORIG_SYS_DOCUMENT_REF
2244 ,p_line_rec.ORIG_SYS_LINE_REF
2245 ,p_line_rec.ORIG_SYS_SHIPMENT_REF
2246 ,p_line_rec.CHANGE_SEQUENCE
2247 ,p_line_rec.OVER_SHIP_REASON_CODE
2248 ,p_line_rec.OVER_SHIP_RESOLVED_FLAG
2249 ,p_line_rec.PAYMENT_TERM_ID
2250 --,p_line_rec.PLANNING_PRIORITY
2251 ,p_line_rec.PREFERRED_GRADE --OPM HVOP
2252 ,p_line_rec.PRICE_LIST_ID
2253 --,p_line_rec.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
2254 ,p_line_rec.PRICING_ATTRIBUTE1
2255 ,p_line_rec.PRICING_ATTRIBUTE10
2256 ,p_line_rec.PRICING_ATTRIBUTE2
2257 ,p_line_rec.PRICING_ATTRIBUTE3
2258 ,p_line_rec.PRICING_ATTRIBUTE4
2259 ,p_line_rec.PRICING_ATTRIBUTE5
2260 ,p_line_rec.PRICING_ATTRIBUTE6
2261 ,p_line_rec.PRICING_ATTRIBUTE7
2262 ,p_line_rec.PRICING_ATTRIBUTE8
2263 ,p_line_rec.PRICING_ATTRIBUTE9
2264 ,p_line_rec.PRICING_CONTEXT
2265 ,p_line_rec.PRICING_DATE
2266 ,p_line_rec.PRICING_QUANTITY
2267 ,p_line_rec.PRICING_QUANTITY_UOM
2268 --,p_line_rec.PROGRAM_APPLICATION_ID
2269 --,p_line_rec.PROGRAM_ID
2270 --,p_line_rec.PROGRAM_UPDATE_DATE
2271 ,p_line_rec.PROJECT_ID
2272 ,p_line_rec.PROMISE_DATE
2273 ,p_line_rec.RE_SOURCE_FLAG
2274 --,p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
2275 ,p_line_rec.REFERENCE_HEADER_ID
2276 ,p_line_rec.REFERENCE_LINE_ID
2277 ,p_line_rec.REFERENCE_TYPE
2278 ,p_line_rec.REQUEST_DATE
2279 ,p_line_rec.REQUEST_ID
2280 ,p_line_rec.RETURN_ATTRIBUTE1
2281 ,p_line_rec.RETURN_ATTRIBUTE10
2282 ,p_line_rec.RETURN_ATTRIBUTE11
2283 ,p_line_rec.RETURN_ATTRIBUTE12
2284 ,p_line_rec.RETURN_ATTRIBUTE13
2285 ,p_line_rec.RETURN_ATTRIBUTE14
2286 ,p_line_rec.RETURN_ATTRIBUTE15
2287 ,p_line_rec.RETURN_ATTRIBUTE2
2288 ,p_line_rec.RETURN_ATTRIBUTE3
2289 ,p_line_rec.RETURN_ATTRIBUTE4
2290 ,p_line_rec.RETURN_ATTRIBUTE5
2291 ,p_line_rec.RETURN_ATTRIBUTE6
2292 ,p_line_rec.RETURN_ATTRIBUTE7
2293 ,p_line_rec.RETURN_ATTRIBUTE8
2294 ,p_line_rec.RETURN_ATTRIBUTE9
2295 ,p_line_rec.RETURN_CONTEXT
2296 ,p_line_rec.RETURN_REASON_CODE
2297 --,p_line_rec.RLA_SCHEDULE_TYPE_CODE
2298 ,p_line_rec.SALESREP_ID
2299 ,p_line_rec.SCHEDULE_ARRIVAL_DATE
2300 ,p_line_rec.SCHEDULE_SHIP_DATE
2301 ,p_line_rec.SCHEDULE_STATUS_CODE
2302 ,p_line_rec.SHIPMENT_NUMBER
2303 ,p_line_rec.SHIPMENT_PRIORITY_CODE
2304 ,p_line_rec.SHIPPED_QUANTITY
2305 ,p_line_rec.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
2306 ,p_line_rec.SHIPPING_METHOD_CODE
2307 ,p_line_rec.SHIPPING_QUANTITY
2308 ,p_line_rec.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
2309 ,p_line_rec.SHIPPING_QUANTITY_UOM
2310 ,p_line_rec.SHIP_FROM_ORG_ID
2311 ,p_line_rec.SUBINVENTORY
2312 ,p_line_rec.SHIP_SET_ID
2313 ,p_line_rec.SHIP_TOLERANCE_ABOVE
2314 ,p_line_rec.SHIP_TOLERANCE_BELOW
2315 ,p_line_rec.SHIPPABLE_FLAG
2316 --,p_line_rec.SHIPPING_INTERFACED_FLAG
2317 ,p_line_rec.SHIP_TO_CONTACT_ID
2318 ,p_line_rec.SHIP_TO_ORG_ID
2319 ,p_line_rec.SHIP_MODEL_COMPLETE_FLAG
2320 ,p_line_rec.SOLD_TO_ORG_ID
2321 ,p_line_rec.SOLD_FROM_ORG_ID
2322 ,p_line_rec.SORT_ORDER
2323 ,p_line_rec.SOURCE_DOCUMENT_ID
2324 --,p_line_rec.SOURCE_DOCUMENT_LINE_ID
2325 --,p_line_rec.SOURCE_DOCUMENT_TYPE_ID
2326 ,p_line_rec.SOURCE_TYPE_CODE
2327 ,p_line_rec.SPLIT_FROM_LINE_ID
2328 --,p_line_rec.LINE_SET_ID
2329 --,p_line_rec.SPLIT_BY
2330 ,p_line_rec.MODEL_REMNANT_FLAG
2331 ,p_line_rec.TASK_ID
2332 ,p_line_rec.TAX_CODE
2333 ,p_line_rec.TAX_DATE
2334 ,p_line_rec.TAX_EXEMPT_FLAG
2335 ,p_line_rec.TAX_EXEMPT_NUMBER
2336 ,p_line_rec.TAX_EXEMPT_REASON_CODE
2337 ,p_line_rec.TAX_POINT_CODE
2338 --,p_line_rec.TAX_RATE
2339 ,p_line_rec.TAX_VALUE
2340 ,p_line_rec.TOP_MODEL_LINE_ID
2341 ,p_line_rec.UNIT_LIST_PRICE
2342 ,p_line_rec.UNIT_LIST_PRICE_PER_PQTY
2343 ,p_line_rec.UNIT_SELLING_PRICE
2344 ,p_line_rec.UNIT_SELLING_PRICE_PER_PQTY
2345 ,p_line_rec.VISIBLE_DEMAND_FLAG
2346 ,p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
2347 ,p_line_rec.SHIPPING_INSTRUCTIONS
2348 ,p_line_rec.PACKING_INSTRUCTIONS
2349 ,p_line_rec.SERVICE_TXN_REASON_CODE
2350 ,p_line_rec.SERVICE_TXN_COMMENTS
2351 ,p_line_rec.SERVICE_DURATION
2352 ,p_line_rec.SERVICE_PERIOD
2353 ,p_line_rec.SERVICE_START_DATE
2354 ,p_line_rec.SERVICE_END_DATE
2355 ,p_line_rec.SERVICE_COTERMINATE_FLAG
2356 ,p_line_rec.UNIT_LIST_PERCENT
2357 ,p_line_rec.UNIT_SELLING_PERCENT
2358 ,p_line_rec.UNIT_PERCENT_BASE_PRICE
2359 ,p_line_rec.SERVICE_NUMBER
2360 ,p_line_rec.SERVICE_REFERENCE_TYPE_CODE
2361 --,p_line_rec.SERVICE_REFERENCE_LINE_ID
2362 --,p_line_rec.SERVICE_REFERENCE_SYSTEM_ID
2363 ,p_line_rec.TP_CONTEXT
2364 ,p_line_rec.TP_ATTRIBUTE1
2365 ,p_line_rec.TP_ATTRIBUTE2
2366 ,p_line_rec.TP_ATTRIBUTE3
2367 ,p_line_rec.TP_ATTRIBUTE4
2368 ,p_line_rec.TP_ATTRIBUTE5
2369 ,p_line_rec.TP_ATTRIBUTE6
2370 ,p_line_rec.TP_ATTRIBUTE7
2371 ,p_line_rec.TP_ATTRIBUTE8
2372 ,p_line_rec.TP_ATTRIBUTE9
2373 ,p_line_rec.TP_ATTRIBUTE10
2374 ,p_line_rec.TP_ATTRIBUTE11
2375 ,p_line_rec.TP_ATTRIBUTE12
2376 ,p_line_rec.TP_ATTRIBUTE13
2377 ,p_line_rec.TP_ATTRIBUTE14
2378 ,p_line_rec.TP_ATTRIBUTE15
2379 --,p_line_rec.FLOW_STATUS_CODE
2380 --,p_line_rec.MARKETING_SOURCE_CODE_ID
2381 ,p_line_rec.CALCULATE_PRICE_FLAG
2382 ,p_line_rec.COMMITMENT_ID
2383 ,p_line_rec.ORDER_SOURCE_ID
2384 --,p_line_rec.upgraded_flag
2385 ,p_line_rec.LOCK_CONTROL
2386 ,p_line_rec.WF_PROCESS_NAME
2387 ,p_line_rec.II_START_INDEX
2388 ,p_line_rec.II_COUNT
2389 ,p_line_rec.user_item_description
2390 ,p_line_rec.parent_line_index
2391 ,p_line_rec.firm_demand_flag
2392 -- end customer(Bug 5054618)
2393 ,p_line_rec.End_customer_contact_id
2394 ,p_line_rec.End_customer_id
2395 ,p_line_rec.End_customer_site_use_id
2396 ,p_line_rec.IB_owner
2397 ,p_line_rec.IB_current_location
2398 ,p_line_rec.IB_Installed_at_Location
2399 ,p_line_rec.cust_trx_type_id
2400 ,p_line_rec.tax_calculation_flag
2401 ,p_line_rec.ato_line_index
2402 ,p_line_rec.top_model_line_index ;
2403
2404 else -- when p_process_configurations in Y
2405
2406 IF l_debug_level > 0 THEN
2407 oe_debug_pub.add('before OPEN c_lines1');
2408 END IF;
2409
2410 OPEN c_lines1;
2411
2412 IF l_debug_level > 0 THEN
2413 oe_debug_pub.add('after OPEN c_lines1');
2414 END IF;
2415
2416 FETCH c_lines1 BULK COLLECT INTO
2417 p_line_rec.ACCOUNTING_RULE_ID
2418 ,p_line_rec.ACCOUNTING_RULE_DURATION
2419 ,p_line_rec.ACTUAL_ARRIVAL_DATE
2420 --,p_line_rec.ACTUAL_SHIPMENT_DATE
2421 ,p_line_rec.AGREEMENT_ID
2422 ,p_line_rec.ARRIVAL_SET_ID
2423 ,p_line_rec.ATO_LINE_ID
2424 ,p_line_rec.ATTRIBUTE1
2425 ,p_line_rec.ATTRIBUTE10
2426 ,p_line_rec.ATTRIBUTE11
2427 ,p_line_rec.ATTRIBUTE12
2428 ,p_line_rec.ATTRIBUTE13
2429 ,p_line_rec.ATTRIBUTE14
2430 ,p_line_rec.ATTRIBUTE15
2431 ,p_line_rec.ATTRIBUTE16 --For bug 2184255
2432 ,p_line_rec.ATTRIBUTE17
2433 ,p_line_rec.ATTRIBUTE18
2434 ,p_line_rec.ATTRIBUTE19
2435 ,p_line_rec.ATTRIBUTE2
2436 ,p_line_rec.ATTRIBUTE20
2437 ,p_line_rec.ATTRIBUTE3
2438 ,p_line_rec.ATTRIBUTE4
2439 ,p_line_rec.ATTRIBUTE5
2440 ,p_line_rec.ATTRIBUTE6
2441 ,p_line_rec.ATTRIBUTE7
2442 ,p_line_rec.ATTRIBUTE8
2443 ,p_line_rec.ATTRIBUTE9
2444 --,p_line_rec.AUTO_SELECTED_QUANTITY
2445 ,p_line_rec.AUTHORIZED_TO_SHIP_FLAG
2446 ,p_line_rec.BOOKED_FLAG
2447 ,p_line_rec.CANCELLED_FLAG
2448 ,p_line_rec.CANCELLED_QUANTITY
2449 ,p_line_rec.COMPONENT_CODE
2450 ,p_line_rec.COMPONENT_NUMBER
2451 ,p_line_rec.COMPONENT_SEQUENCE_ID
2452 ,p_line_rec.CONFIG_HEADER_ID
2453 ,p_line_rec.CONFIG_REV_NBR
2454 ,p_line_rec.CONFIG_DISPLAY_SEQUENCE
2455 ,p_line_rec.CONFIGURATION_ID
2456 ,p_line_rec.CONTEXT
2457 --,p_line_rec.CREATED_BY
2458 --,p_line_rec.CREATION_DATE
2459 ,p_line_rec.CREDIT_INVOICE_LINE_ID
2460 ,p_line_rec.CUSTOMER_DOCK_CODE
2461 ,p_line_rec.CUSTOMER_JOB
2462 ,p_line_rec.CUSTOMER_PRODUCTION_LINE
2463 ,p_line_rec.CUST_PRODUCTION_SEQ_NUM
2464 --,p_line_rec.CUSTOMER_TRX_LINE_ID
2465 ,p_line_rec.CUST_MODEL_SERIAL_NUMBER
2466 ,p_line_rec.CUST_PO_NUMBER
2467 ,p_line_rec.CUSTOMER_LINE_NUMBER
2468 ,p_line_rec.DELIVERY_LEAD_TIME
2469 ,p_line_rec.DELIVER_TO_CONTACT_ID
2470 ,p_line_rec.DELIVER_TO_ORG_ID
2471 ,p_line_rec.DEMAND_BUCKET_TYPE_CODE
2472 ,p_line_rec.DEMAND_CLASS_CODE
2473 --,p_line_rec.DEP_PLAN_REQUIRED_FLAG
2474 ,p_line_rec.EARLIEST_ACCEPTABLE_DATE
2475 ,p_line_rec.END_ITEM_UNIT_NUMBER
2476 ,p_line_rec.EXPLOSION_DATE
2477 -- ,p_line_rec.FIRST_ACK_CODE
2478 -- ,p_line_rec.FIRST_ACK_DATE
2479 ,p_line_rec.FOB_POINT_CODE
2480 ,p_line_rec.FREIGHT_CARRIER_CODE
2481 ,p_line_rec.FREIGHT_TERMS_CODE
2482 --,p_line_rec.FULFILLED_QUANTITY
2483 --,p_line_rec.FULFILLED_FLAG
2484 --,p_line_rec.FULFILLMENT_METHOD_CODE
2485 --,p_line_rec.FULFILLMENT_DATE
2486 ,p_line_rec.GLOBAL_ATTRIBUTE1
2487 ,p_line_rec.GLOBAL_ATTRIBUTE10
2488 ,p_line_rec.GLOBAL_ATTRIBUTE11
2489 ,p_line_rec.GLOBAL_ATTRIBUTE12
2490 ,p_line_rec.GLOBAL_ATTRIBUTE13
2491 ,p_line_rec.GLOBAL_ATTRIBUTE14
2492 ,p_line_rec.GLOBAL_ATTRIBUTE15
2493 ,p_line_rec.GLOBAL_ATTRIBUTE16
2494 ,p_line_rec.GLOBAL_ATTRIBUTE17
2495 ,p_line_rec.GLOBAL_ATTRIBUTE18
2496 ,p_line_rec.GLOBAL_ATTRIBUTE19
2497 ,p_line_rec.GLOBAL_ATTRIBUTE2
2498 ,p_line_rec.GLOBAL_ATTRIBUTE20
2499 ,p_line_rec.GLOBAL_ATTRIBUTE3
2500 ,p_line_rec.GLOBAL_ATTRIBUTE4
2501 ,p_line_rec.GLOBAL_ATTRIBUTE5
2502 ,p_line_rec.GLOBAL_ATTRIBUTE6
2503 ,p_line_rec.GLOBAL_ATTRIBUTE7
2504 ,p_line_rec.GLOBAL_ATTRIBUTE8
2505 ,p_line_rec.GLOBAL_ATTRIBUTE9
2506 ,p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
2507 ,p_line_rec.HEADER_ID
2508 ,p_line_rec.INDUSTRY_ATTRIBUTE1
2509 ,p_line_rec.INDUSTRY_ATTRIBUTE10
2510 ,p_line_rec.INDUSTRY_ATTRIBUTE11
2511 ,p_line_rec.INDUSTRY_ATTRIBUTE12
2512 ,p_line_rec.INDUSTRY_ATTRIBUTE13
2513 ,p_line_rec.INDUSTRY_ATTRIBUTE14
2514 ,p_line_rec.INDUSTRY_ATTRIBUTE15
2515 ,p_line_rec.INDUSTRY_ATTRIBUTE16
2516 ,p_line_rec.INDUSTRY_ATTRIBUTE17
2517 ,p_line_rec.INDUSTRY_ATTRIBUTE18
2518 ,p_line_rec.INDUSTRY_ATTRIBUTE19
2519 ,p_line_rec.INDUSTRY_ATTRIBUTE20
2520 ,p_line_rec.INDUSTRY_ATTRIBUTE21
2521 ,p_line_rec.INDUSTRY_ATTRIBUTE22
2522 ,p_line_rec.INDUSTRY_ATTRIBUTE23
2523 ,p_line_rec.INDUSTRY_ATTRIBUTE24
2524 ,p_line_rec.INDUSTRY_ATTRIBUTE25
2525 ,p_line_rec.INDUSTRY_ATTRIBUTE26
2526 ,p_line_rec.INDUSTRY_ATTRIBUTE27
2527 ,p_line_rec.INDUSTRY_ATTRIBUTE28
2528 ,p_line_rec.INDUSTRY_ATTRIBUTE29
2529 ,p_line_rec.INDUSTRY_ATTRIBUTE30
2530 ,p_line_rec.INDUSTRY_ATTRIBUTE2
2531 ,p_line_rec.INDUSTRY_ATTRIBUTE3
2532 ,p_line_rec.INDUSTRY_ATTRIBUTE4
2533 ,p_line_rec.INDUSTRY_ATTRIBUTE5
2534 ,p_line_rec.INDUSTRY_ATTRIBUTE6
2535 ,p_line_rec.INDUSTRY_ATTRIBUTE7
2536 ,p_line_rec.INDUSTRY_ATTRIBUTE8
2537 ,p_line_rec.INDUSTRY_ATTRIBUTE9
2538 ,p_line_rec.INDUSTRY_CONTEXT
2539 --,p_line_rec.INTERMED_SHIP_TO_CONTACT_ID
2540 --,p_line_rec.INTERMED_SHIP_TO_ORG_ID
2541 ,p_line_rec.INVENTORY_ITEM_ID
2542 --,p_line_rec.INVOICE_INTERFACE_STATUS_CODE
2543 ,p_line_rec.INVOICE_TO_CONTACT_ID
2544 ,p_line_rec.INVOICE_TO_ORG_ID
2545 --,p_line_rec.INVOICED_QUANTITY
2546 ,p_line_rec.INVOICING_RULE_ID
2547 ,p_line_rec.ORDERED_ITEM_ID
2548 ,p_line_rec.ITEM_IDENTIFIER_TYPE
2549 ,p_line_rec.ORDERED_ITEM
2550 ,p_line_rec.CUSTOMER_ITEM_NET_PRICE
2551 ,p_line_rec.CUSTOMER_PAYMENT_TERM_ID
2552 ,p_line_rec.ITEM_REVISION
2553 ,p_line_rec.ITEM_TYPE_CODE
2554 -- ,p_line_rec.LAST_ACK_CODE
2555 -- ,p_line_rec.LAST_ACK_DATE
2556 --,p_line_rec.LAST_UPDATED_BY
2557 --,p_line_rec.LAST_UPDATE_DATE
2558 --,p_line_rec.LAST_UPDATE_LOGIN
2559 ,p_line_rec.LATEST_ACCEPTABLE_DATE
2560 ,p_line_rec.LINE_CATEGORY_CODE
2561 ,p_line_rec.LINE_ID
2562 ,p_line_rec.LINE_NUMBER
2563 ,p_line_rec.LINE_TYPE_ID
2564 ,p_line_rec.LINK_TO_LINE_ID
2565 ,p_line_rec.MODEL_GROUP_NUMBER
2566 ,p_line_rec.MFG_LEAD_TIME
2567 --,p_line_rec.OPEN_FLAG
2568 ,p_line_rec.OPTION_FLAG
2569 ,p_line_rec.OPTION_NUMBER
2570 ,p_line_rec.ORDERED_QUANTITY
2571 ,p_line_rec.ORDERED_QUANTITY2 --OPM 02/JUN/00
2572 ,p_line_rec.ORDER_QUANTITY_UOM
2573 ,p_line_rec.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
2574 ,p_line_rec.ORG_ID
2575 ,p_line_rec.ORIG_SYS_DOCUMENT_REF
2576 ,p_line_rec.ORIG_SYS_LINE_REF
2577 ,p_line_rec.ORIG_SYS_SHIPMENT_REF
2578 ,p_line_rec.CHANGE_SEQUENCE
2579 ,p_line_rec.OVER_SHIP_REASON_CODE
2580 ,p_line_rec.OVER_SHIP_RESOLVED_FLAG
2581 ,p_line_rec.PAYMENT_TERM_ID
2582 --,p_line_rec.PLANNING_PRIORITY
2583 ,p_line_rec.PREFERRED_GRADE --OPM HVOP
2584 ,p_line_rec.PRICE_LIST_ID
2585 --,p_line_rec.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
2586 ,p_line_rec.PRICING_ATTRIBUTE1
2587 ,p_line_rec.PRICING_ATTRIBUTE10
2588 ,p_line_rec.PRICING_ATTRIBUTE2
2589 ,p_line_rec.PRICING_ATTRIBUTE3
2590 ,p_line_rec.PRICING_ATTRIBUTE4
2591 ,p_line_rec.PRICING_ATTRIBUTE5
2592 ,p_line_rec.PRICING_ATTRIBUTE6
2593 ,p_line_rec.PRICING_ATTRIBUTE7
2594 ,p_line_rec.PRICING_ATTRIBUTE8
2595 ,p_line_rec.PRICING_ATTRIBUTE9
2596 ,p_line_rec.PRICING_CONTEXT
2597 ,p_line_rec.PRICING_DATE
2598 ,p_line_rec.PRICING_QUANTITY
2599 ,p_line_rec.PRICING_QUANTITY_UOM
2600 --,p_line_rec.PROGRAM_APPLICATION_ID
2601 --,p_line_rec.PROGRAM_ID
2602 --,p_line_rec.PROGRAM_UPDATE_DATE
2603 ,p_line_rec.PROJECT_ID
2604 ,p_line_rec.PROMISE_DATE
2605 ,p_line_rec.RE_SOURCE_FLAG
2606 --,p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
2607 ,p_line_rec.REFERENCE_HEADER_ID
2608 ,p_line_rec.REFERENCE_LINE_ID
2609 ,p_line_rec.REFERENCE_TYPE
2610 ,p_line_rec.REQUEST_DATE
2611 ,p_line_rec.REQUEST_ID
2612 ,p_line_rec.RETURN_ATTRIBUTE1
2613 ,p_line_rec.RETURN_ATTRIBUTE10
2614 ,p_line_rec.RETURN_ATTRIBUTE11
2615 ,p_line_rec.RETURN_ATTRIBUTE12
2616 ,p_line_rec.RETURN_ATTRIBUTE13
2617 ,p_line_rec.RETURN_ATTRIBUTE14
2618 ,p_line_rec.RETURN_ATTRIBUTE15
2619 ,p_line_rec.RETURN_ATTRIBUTE2
2620 ,p_line_rec.RETURN_ATTRIBUTE3
2621 ,p_line_rec.RETURN_ATTRIBUTE4
2622 ,p_line_rec.RETURN_ATTRIBUTE5
2623 ,p_line_rec.RETURN_ATTRIBUTE6
2624 ,p_line_rec.RETURN_ATTRIBUTE7
2625 ,p_line_rec.RETURN_ATTRIBUTE8
2626 ,p_line_rec.RETURN_ATTRIBUTE9
2627 ,p_line_rec.RETURN_CONTEXT
2628 ,p_line_rec.RETURN_REASON_CODE
2629 --,p_line_rec.RLA_SCHEDULE_TYPE_CODE
2630 ,p_line_rec.SALESREP_ID
2631 ,p_line_rec.SCHEDULE_ARRIVAL_DATE
2632 ,p_line_rec.SCHEDULE_SHIP_DATE
2633 ,p_line_rec.SCHEDULE_STATUS_CODE
2634 ,p_line_rec.SHIPMENT_NUMBER
2635 ,p_line_rec.SHIPMENT_PRIORITY_CODE
2636 ,p_line_rec.SHIPPED_QUANTITY
2637 ,p_line_rec.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
2638 ,p_line_rec.SHIPPING_METHOD_CODE
2639 ,p_line_rec.SHIPPING_QUANTITY
2640 ,p_line_rec.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
2641 ,p_line_rec.SHIPPING_QUANTITY_UOM
2642 ,p_line_rec.SHIP_FROM_ORG_ID
2643 ,p_line_rec.SUBINVENTORY
2644 ,p_line_rec.SHIP_SET_ID
2645 ,p_line_rec.SHIP_TOLERANCE_ABOVE
2646 ,p_line_rec.SHIP_TOLERANCE_BELOW
2647 ,p_line_rec.SHIPPABLE_FLAG
2648 --,p_line_rec.SHIPPING_INTERFACED_FLAG
2649 ,p_line_rec.SHIP_TO_CONTACT_ID
2650 ,p_line_rec.SHIP_TO_ORG_ID
2651 ,p_line_rec.SHIP_MODEL_COMPLETE_FLAG
2652 ,p_line_rec.SOLD_TO_ORG_ID
2653 ,p_line_rec.SOLD_FROM_ORG_ID
2654 ,p_line_rec.SORT_ORDER
2655 ,p_line_rec.SOURCE_DOCUMENT_ID
2656 --,p_line_rec.SOURCE_DOCUMENT_LINE_ID
2657 --,p_line_rec.SOURCE_DOCUMENT_TYPE_ID
2658 ,p_line_rec.SOURCE_TYPE_CODE
2659 ,p_line_rec.SPLIT_FROM_LINE_ID
2660 --,p_line_rec.LINE_SET_ID
2661 --,p_line_rec.SPLIT_BY
2662 ,p_line_rec.MODEL_REMNANT_FLAG
2663 ,p_line_rec.TASK_ID
2664 ,p_line_rec.TAX_CODE
2665 ,p_line_rec.TAX_DATE
2666 ,p_line_rec.TAX_EXEMPT_FLAG
2667 ,p_line_rec.TAX_EXEMPT_NUMBER
2668 ,p_line_rec.TAX_EXEMPT_REASON_CODE
2669 ,p_line_rec.TAX_POINT_CODE
2670 --,p_line_rec.TAX_RATE
2671 ,p_line_rec.TAX_VALUE
2672 ,p_line_rec.TOP_MODEL_LINE_ID
2673 ,p_line_rec.TOP_MODEL_LINE_REF
2674 ,p_line_rec.UNIT_LIST_PRICE
2675 ,p_line_rec.UNIT_LIST_PRICE_PER_PQTY
2676 ,p_line_rec.UNIT_SELLING_PRICE
2677 ,p_line_rec.UNIT_SELLING_PRICE_PER_PQTY
2678 ,p_line_rec.VISIBLE_DEMAND_FLAG
2679 ,p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
2680 ,p_line_rec.SHIPPING_INSTRUCTIONS
2681 ,p_line_rec.PACKING_INSTRUCTIONS
2682 ,p_line_rec.SERVICE_TXN_REASON_CODE
2683 ,p_line_rec.SERVICE_TXN_COMMENTS
2684 ,p_line_rec.SERVICE_DURATION
2685 ,p_line_rec.SERVICE_PERIOD
2686 ,p_line_rec.SERVICE_START_DATE
2687 ,p_line_rec.SERVICE_END_DATE
2688 ,p_line_rec.SERVICE_COTERMINATE_FLAG
2689 ,p_line_rec.UNIT_LIST_PERCENT
2690 ,p_line_rec.UNIT_SELLING_PERCENT
2691 ,p_line_rec.UNIT_PERCENT_BASE_PRICE
2692 ,p_line_rec.SERVICE_NUMBER
2693 ,p_line_rec.SERVICE_REFERENCE_TYPE_CODE
2694 --,p_line_rec.SERVICE_REFERENCE_LINE_ID
2695 --,p_line_rec.SERVICE_REFERENCE_SYSTEM_ID
2696 ,p_line_rec.TP_CONTEXT
2697 ,p_line_rec.TP_ATTRIBUTE1
2698 ,p_line_rec.TP_ATTRIBUTE2
2699 ,p_line_rec.TP_ATTRIBUTE3
2700 ,p_line_rec.TP_ATTRIBUTE4
2701 ,p_line_rec.TP_ATTRIBUTE5
2702 ,p_line_rec.TP_ATTRIBUTE6
2703 ,p_line_rec.TP_ATTRIBUTE7
2704 ,p_line_rec.TP_ATTRIBUTE8
2705 ,p_line_rec.TP_ATTRIBUTE9
2706 ,p_line_rec.TP_ATTRIBUTE10
2707 ,p_line_rec.TP_ATTRIBUTE11
2708 ,p_line_rec.TP_ATTRIBUTE12
2709 ,p_line_rec.TP_ATTRIBUTE13
2710 ,p_line_rec.TP_ATTRIBUTE14
2711 ,p_line_rec.TP_ATTRIBUTE15
2712 --,p_line_rec.FLOW_STATUS_CODE
2713 --,p_line_rec.MARKETING_SOURCE_CODE_ID
2714 ,p_line_rec.CALCULATE_PRICE_FLAG
2715 ,p_line_rec.COMMITMENT_ID
2716 ,p_line_rec.ORDER_SOURCE_ID
2717 --,p_line_rec.upgraded_flag
2718 ,p_line_rec.LOCK_CONTROL
2719 ,p_line_rec.WF_PROCESS_NAME
2720 ,p_line_rec.II_START_INDEX
2721 ,p_line_rec.II_COUNT
2722 ,p_line_rec.user_item_description
2723 ,p_line_rec.parent_line_index
2724 ,p_line_rec.firm_demand_flag
2725 -- end customer
2726 ,p_line_rec.End_customer_contact_id
2727 ,p_line_rec.End_customer_id
2728 ,p_line_rec.End_customer_site_use_id
2729 ,p_line_rec.IB_owner
2730 ,p_line_rec.IB_current_location
2731 ,p_line_rec.IB_Installed_at_Location
2732 ,p_line_rec.cust_trx_type_id
2733 ,p_line_rec.tax_calculation_flag
2734 ,p_line_rec.ato_line_index
2735 ,p_line_rec.top_model_line_index
2736 ;
2737 END IF; -- p_process_configuration
2738 ELSE -- added for bug 3390458
2739
2740 -- This code is added to rtrim text columns. It is controlled by the
2741 -- input parameter to HVOP order import program.
2742 IF p_process_configurations = 'N'
2743 THEN
2744 oe_debug_pub.add('before OPEN c_lines_rtrim');
2745 OPEN c_lines_rtrim;
2746 oe_debug_pub.add('after OPEN c_lines_rtrim');
2747 ------------------------------------------------------------------------------
2748
2749 FETCH c_lines_rtrim BULK COLLECT INTO
2750 p_line_rec.ACCOUNTING_RULE_ID
2751 ,p_line_rec.ACCOUNTING_RULE_DURATION
2752 ,p_line_rec.ACTUAL_ARRIVAL_DATE
2753 --,p_line_rec.ACTUAL_SHIPMENT_DATE
2754 ,p_line_rec.AGREEMENT_ID
2755 ,p_line_rec.ARRIVAL_SET_ID
2756 ,p_line_rec.ATO_LINE_ID
2757 ,p_line_rec.ATTRIBUTE1
2758 ,p_line_rec.ATTRIBUTE10
2759 ,p_line_rec.ATTRIBUTE11
2760 ,p_line_rec.ATTRIBUTE12
2761 ,p_line_rec.ATTRIBUTE13
2762 ,p_line_rec.ATTRIBUTE14
2763 ,p_line_rec.ATTRIBUTE15
2764 ,p_line_rec.ATTRIBUTE16 --For bug 2184255
2765 ,p_line_rec.ATTRIBUTE17
2766 ,p_line_rec.ATTRIBUTE18
2767 ,p_line_rec.ATTRIBUTE19
2768 ,p_line_rec.ATTRIBUTE2
2769 ,p_line_rec.ATTRIBUTE20
2770 ,p_line_rec.ATTRIBUTE3
2771 ,p_line_rec.ATTRIBUTE4
2772 ,p_line_rec.ATTRIBUTE5
2773 ,p_line_rec.ATTRIBUTE6
2774 ,p_line_rec.ATTRIBUTE7
2775 ,p_line_rec.ATTRIBUTE8
2776 ,p_line_rec.ATTRIBUTE9
2777 --,p_line_rec.AUTO_SELECTED_QUANTITY
2778 ,p_line_rec.AUTHORIZED_TO_SHIP_FLAG
2779 ,p_line_rec.BOOKED_FLAG
2780 ,p_line_rec.CANCELLED_FLAG
2781 ,p_line_rec.CANCELLED_QUANTITY
2782 ,p_line_rec.COMPONENT_CODE
2783 ,p_line_rec.COMPONENT_NUMBER
2784 ,p_line_rec.COMPONENT_SEQUENCE_ID
2785 --,p_line_rec.CONFIG_HEADER_ID
2786 --,p_line_rec.CONFIG_REV_NBR
2787 --,p_line_rec.CONFIG_DISPLAY_SEQUENCE
2788 --,p_line_rec.CONFIGURATION_ID
2789 ,p_line_rec.CONTEXT
2790 --,p_line_rec.CREATED_BY
2791 --,p_line_rec.CREATION_DATE
2792 ,p_line_rec.CREDIT_INVOICE_LINE_ID
2793 ,p_line_rec.CUSTOMER_DOCK_CODE
2794 ,p_line_rec.CUSTOMER_JOB
2795 ,p_line_rec.CUSTOMER_PRODUCTION_LINE
2796 ,p_line_rec.CUST_PRODUCTION_SEQ_NUM
2797 --,p_line_rec.CUSTOMER_TRX_LINE_ID
2798 ,p_line_rec.CUST_MODEL_SERIAL_NUMBER
2799 ,p_line_rec.CUST_PO_NUMBER
2800 ,p_line_rec.CUSTOMER_LINE_NUMBER
2801 ,p_line_rec.DELIVERY_LEAD_TIME
2802 ,p_line_rec.DELIVER_TO_CONTACT_ID
2803 ,p_line_rec.DELIVER_TO_ORG_ID
2804 ,p_line_rec.DEMAND_BUCKET_TYPE_CODE
2805 ,p_line_rec.DEMAND_CLASS_CODE
2806 --,p_line_rec.DEP_PLAN_REQUIRED_FLAG
2807 ,p_line_rec.EARLIEST_ACCEPTABLE_DATE
2808 ,p_line_rec.END_ITEM_UNIT_NUMBER
2809 ,p_line_rec.EXPLOSION_DATE
2810 --,p_line_rec.FIRST_ACK_CODE
2811 --,p_line_rec.FIRST_ACK_DATE
2812 ,p_line_rec.FOB_POINT_CODE
2813 ,p_line_rec.FREIGHT_CARRIER_CODE
2814 ,p_line_rec.FREIGHT_TERMS_CODE
2815 --,p_line_rec.FULFILLED_QUANTITY
2816 --,p_line_rec.FULFILLED_FLAG
2817 --,p_line_rec.FULFILLMENT_METHOD_CODE
2818 --,p_line_rec.FULFILLMENT_DATE
2819 ,p_line_rec.GLOBAL_ATTRIBUTE1
2820 ,p_line_rec.GLOBAL_ATTRIBUTE10
2821 ,p_line_rec.GLOBAL_ATTRIBUTE11
2822 ,p_line_rec.GLOBAL_ATTRIBUTE12
2823 ,p_line_rec.GLOBAL_ATTRIBUTE13
2824 ,p_line_rec.GLOBAL_ATTRIBUTE14
2825 ,p_line_rec.GLOBAL_ATTRIBUTE15
2826 ,p_line_rec.GLOBAL_ATTRIBUTE16
2827 ,p_line_rec.GLOBAL_ATTRIBUTE17
2828 ,p_line_rec.GLOBAL_ATTRIBUTE18
2829 ,p_line_rec.GLOBAL_ATTRIBUTE19
2830 ,p_line_rec.GLOBAL_ATTRIBUTE2
2831 ,p_line_rec.GLOBAL_ATTRIBUTE20
2832 ,p_line_rec.GLOBAL_ATTRIBUTE3
2833 ,p_line_rec.GLOBAL_ATTRIBUTE4
2834 ,p_line_rec.GLOBAL_ATTRIBUTE5
2835 ,p_line_rec.GLOBAL_ATTRIBUTE6
2836 ,p_line_rec.GLOBAL_ATTRIBUTE7
2837 ,p_line_rec.GLOBAL_ATTRIBUTE8
2838 ,p_line_rec.GLOBAL_ATTRIBUTE9
2839 ,p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
2840 ,p_line_rec.HEADER_ID
2841 ,p_line_rec.INDUSTRY_ATTRIBUTE1
2842 ,p_line_rec.INDUSTRY_ATTRIBUTE10
2843 ,p_line_rec.INDUSTRY_ATTRIBUTE11
2844 ,p_line_rec.INDUSTRY_ATTRIBUTE12
2845 ,p_line_rec.INDUSTRY_ATTRIBUTE13
2846 ,p_line_rec.INDUSTRY_ATTRIBUTE14
2847 ,p_line_rec.INDUSTRY_ATTRIBUTE15
2848 ,p_line_rec.INDUSTRY_ATTRIBUTE16
2849 ,p_line_rec.INDUSTRY_ATTRIBUTE17
2850 ,p_line_rec.INDUSTRY_ATTRIBUTE18
2851 ,p_line_rec.INDUSTRY_ATTRIBUTE19
2852 ,p_line_rec.INDUSTRY_ATTRIBUTE20
2853 ,p_line_rec.INDUSTRY_ATTRIBUTE21
2854 ,p_line_rec.INDUSTRY_ATTRIBUTE22
2855 ,p_line_rec.INDUSTRY_ATTRIBUTE23
2856 ,p_line_rec.INDUSTRY_ATTRIBUTE24
2857 ,p_line_rec.INDUSTRY_ATTRIBUTE25
2858 ,p_line_rec.INDUSTRY_ATTRIBUTE26
2859 ,p_line_rec.INDUSTRY_ATTRIBUTE27
2860 ,p_line_rec.INDUSTRY_ATTRIBUTE28
2861 ,p_line_rec.INDUSTRY_ATTRIBUTE29
2862 ,p_line_rec.INDUSTRY_ATTRIBUTE30
2863 ,p_line_rec.INDUSTRY_ATTRIBUTE2
2864 ,p_line_rec.INDUSTRY_ATTRIBUTE3
2865 ,p_line_rec.INDUSTRY_ATTRIBUTE4
2866 ,p_line_rec.INDUSTRY_ATTRIBUTE5
2867 ,p_line_rec.INDUSTRY_ATTRIBUTE6
2868 ,p_line_rec.INDUSTRY_ATTRIBUTE7
2869 ,p_line_rec.INDUSTRY_ATTRIBUTE8
2870 ,p_line_rec.INDUSTRY_ATTRIBUTE9
2871 ,p_line_rec.INDUSTRY_CONTEXT
2872 --,p_line_rec.INTERMED_SHIP_TO_CONTACT_ID
2873 --,p_line_rec.INTERMED_SHIP_TO_ORG_ID
2874 ,p_line_rec.INVENTORY_ITEM_ID
2875 --,p_line_rec.INVOICE_INTERFACE_STATUS_CODE
2876 ,p_line_rec.INVOICE_TO_CONTACT_ID
2877 ,p_line_rec.INVOICE_TO_ORG_ID
2878 --,p_line_rec.INVOICED_QUANTITY
2879 ,p_line_rec.INVOICING_RULE_ID
2880 ,p_line_rec.ORDERED_ITEM_ID
2881 ,p_line_rec.ITEM_IDENTIFIER_TYPE
2882 ,p_line_rec.ORDERED_ITEM
2883 ,p_line_rec.CUSTOMER_ITEM_NET_PRICE
2884 ,p_line_rec.CUSTOMER_PAYMENT_TERM_ID
2885 ,p_line_rec.ITEM_REVISION
2886 ,p_line_rec.ITEM_TYPE_CODE
2887 --,p_line_rec.LAST_ACK_CODE
2888 --,p_line_rec.LAST_ACK_DATE
2889 --,p_line_rec.LAST_UPDATED_BY
2890 --,p_line_rec.LAST_UPDATE_DATE
2891 --,p_line_rec.LAST_UPDATE_LOGIN
2892 ,p_line_rec.LATEST_ACCEPTABLE_DATE
2893 ,p_line_rec.LINE_CATEGORY_CODE
2894 ,p_line_rec.LINE_ID
2895 ,p_line_rec.LINE_NUMBER
2896 ,p_line_rec.LINE_TYPE_ID
2897 ,p_line_rec.LINK_TO_LINE_ID
2898 ,p_line_rec.MODEL_GROUP_NUMBER
2899 ,p_line_rec.MFG_LEAD_TIME
2900 --,p_line_rec.OPEN_FLAG
2901 ,p_line_rec.OPTION_FLAG
2902 ,p_line_rec.OPTION_NUMBER
2903 ,p_line_rec.ORDERED_QUANTITY
2904 ,p_line_rec.ORDERED_QUANTITY2 --OPM 02/JUN/00
2905 ,p_line_rec.ORDER_QUANTITY_UOM
2906 ,p_line_rec.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
2907 ,p_line_rec.ORG_ID
2908 ,p_line_rec.ORIG_SYS_DOCUMENT_REF
2909 ,p_line_rec.ORIG_SYS_LINE_REF
2910 ,p_line_rec.ORIG_SYS_SHIPMENT_REF
2911 ,p_line_rec.CHANGE_SEQUENCE
2912 ,p_line_rec.OVER_SHIP_REASON_CODE
2913 ,p_line_rec.OVER_SHIP_RESOLVED_FLAG
2914 ,p_line_rec.PAYMENT_TERM_ID
2915 --,p_line_rec.PLANNING_PRIORITY
2916 ,p_line_rec.PREFERRED_GRADE --OPM HVOP
2917 ,p_line_rec.PRICE_LIST_ID
2918 --,p_line_rec.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
2919 ,p_line_rec.PRICING_ATTRIBUTE1
2920 ,p_line_rec.PRICING_ATTRIBUTE10
2921 ,p_line_rec.PRICING_ATTRIBUTE2
2922 ,p_line_rec.PRICING_ATTRIBUTE3
2923 ,p_line_rec.PRICING_ATTRIBUTE4
2924 ,p_line_rec.PRICING_ATTRIBUTE5
2925 ,p_line_rec.PRICING_ATTRIBUTE6
2926 ,p_line_rec.PRICING_ATTRIBUTE7
2927 ,p_line_rec.PRICING_ATTRIBUTE8
2928 ,p_line_rec.PRICING_ATTRIBUTE9
2929 ,p_line_rec.PRICING_CONTEXT
2930 ,p_line_rec.PRICING_DATE
2931 ,p_line_rec.PRICING_QUANTITY
2932 ,p_line_rec.PRICING_QUANTITY_UOM
2933 --,p_line_rec.PROGRAM_APPLICATION_ID
2934 --,p_line_rec.PROGRAM_ID
2935 --,p_line_rec.PROGRAM_UPDATE_DATE
2936 ,p_line_rec.PROJECT_ID
2937 ,p_line_rec.PROMISE_DATE
2938 ,p_line_rec.RE_SOURCE_FLAG
2939 --,p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
2940 ,p_line_rec.REFERENCE_HEADER_ID
2941 ,p_line_rec.REFERENCE_LINE_ID
2942 ,p_line_rec.REFERENCE_TYPE
2943 ,p_line_rec.REQUEST_DATE
2944 ,p_line_rec.REQUEST_ID
2945 ,p_line_rec.RETURN_ATTRIBUTE1
2946 ,p_line_rec.RETURN_ATTRIBUTE10
2947 ,p_line_rec.RETURN_ATTRIBUTE11
2948 ,p_line_rec.RETURN_ATTRIBUTE12
2949 ,p_line_rec.RETURN_ATTRIBUTE13
2950 ,p_line_rec.RETURN_ATTRIBUTE14
2951 ,p_line_rec.RETURN_ATTRIBUTE15
2952 ,p_line_rec.RETURN_ATTRIBUTE2
2953 ,p_line_rec.RETURN_ATTRIBUTE3
2954 ,p_line_rec.RETURN_ATTRIBUTE4
2955 ,p_line_rec.RETURN_ATTRIBUTE5
2956 ,p_line_rec.RETURN_ATTRIBUTE6
2957 ,p_line_rec.RETURN_ATTRIBUTE7
2958 ,p_line_rec.RETURN_ATTRIBUTE8
2959 ,p_line_rec.RETURN_ATTRIBUTE9
2960 ,p_line_rec.RETURN_CONTEXT
2961 ,p_line_rec.RETURN_REASON_CODE
2962 --,p_line_rec.RLA_SCHEDULE_TYPE_CODE
2963 ,p_line_rec.SALESREP_ID
2964 ,p_line_rec.SCHEDULE_ARRIVAL_DATE
2965 ,p_line_rec.SCHEDULE_SHIP_DATE
2966 ,p_line_rec.SCHEDULE_STATUS_CODE
2967 ,p_line_rec.SHIPMENT_NUMBER
2968 ,p_line_rec.SHIPMENT_PRIORITY_CODE
2969 ,p_line_rec.SHIPPED_QUANTITY
2970 ,p_line_rec.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
2971 ,p_line_rec.SHIPPING_METHOD_CODE
2972 ,p_line_rec.SHIPPING_QUANTITY
2973 ,p_line_rec.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
2974 ,p_line_rec.SHIPPING_QUANTITY_UOM
2975 ,p_line_rec.SHIP_FROM_ORG_ID
2976 ,p_line_rec.SUBINVENTORY
2977 ,p_line_rec.SHIP_SET_ID
2978 ,p_line_rec.SHIP_TOLERANCE_ABOVE
2979 ,p_line_rec.SHIP_TOLERANCE_BELOW
2980 ,p_line_rec.SHIPPABLE_FLAG
2981 --,p_line_rec.SHIPPING_INTERFACED_FLAG
2982 ,p_line_rec.SHIP_TO_CONTACT_ID
2983 ,p_line_rec.SHIP_TO_ORG_ID
2984 ,p_line_rec.SHIP_MODEL_COMPLETE_FLAG
2985 ,p_line_rec.SOLD_TO_ORG_ID
2986 ,p_line_rec.SOLD_FROM_ORG_ID
2987 ,p_line_rec.SORT_ORDER
2988 ,p_line_rec.SOURCE_DOCUMENT_ID
2989 --,p_line_rec.SOURCE_DOCUMENT_LINE_ID
2990 --,p_line_rec.SOURCE_DOCUMENT_TYPE_ID
2991 ,p_line_rec.SOURCE_TYPE_CODE
2992 ,p_line_rec.SPLIT_FROM_LINE_ID
2993 --,p_line_rec.LINE_SET_ID
2994 --,p_line_rec.SPLIT_BY
2995 ,p_line_rec.MODEL_REMNANT_FLAG
2996 ,p_line_rec.TASK_ID
2997 ,p_line_rec.TAX_CODE
2998 ,p_line_rec.TAX_DATE
2999 ,p_line_rec.TAX_EXEMPT_FLAG
3000 ,p_line_rec.TAX_EXEMPT_NUMBER
3001 ,p_line_rec.TAX_EXEMPT_REASON_CODE
3002 ,p_line_rec.TAX_POINT_CODE
3003 --,p_line_rec.TAX_RATE
3004 ,p_line_rec.TAX_VALUE
3005 ,p_line_rec.TOP_MODEL_LINE_ID
3006 ,p_line_rec.UNIT_LIST_PRICE
3007 ,p_line_rec.UNIT_LIST_PRICE_PER_PQTY
3008 ,p_line_rec.UNIT_SELLING_PRICE
3009 ,p_line_rec.UNIT_SELLING_PRICE_PER_PQTY
3010 ,p_line_rec.VISIBLE_DEMAND_FLAG
3011 ,p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
3012 ,p_line_rec.SHIPPING_INSTRUCTIONS
3013 ,p_line_rec.PACKING_INSTRUCTIONS
3014 ,p_line_rec.SERVICE_TXN_REASON_CODE
3015 ,p_line_rec.SERVICE_TXN_COMMENTS
3016 ,p_line_rec.SERVICE_DURATION
3017 ,p_line_rec.SERVICE_PERIOD
3018 ,p_line_rec.SERVICE_START_DATE
3019 ,p_line_rec.SERVICE_END_DATE
3020 ,p_line_rec.SERVICE_COTERMINATE_FLAG
3021 ,p_line_rec.UNIT_LIST_PERCENT
3022 ,p_line_rec.UNIT_SELLING_PERCENT
3023 ,p_line_rec.UNIT_PERCENT_BASE_PRICE
3024 ,p_line_rec.SERVICE_NUMBER
3025 ,p_line_rec.SERVICE_REFERENCE_TYPE_CODE
3026 --,p_line_rec.SERVICE_REFERENCE_LINE_ID
3027 --,p_line_rec.SERVICE_REFERENCE_SYSTEM_ID
3028 ,p_line_rec.TP_CONTEXT
3029 ,p_line_rec.TP_ATTRIBUTE1
3030 ,p_line_rec.TP_ATTRIBUTE2
3031 ,p_line_rec.TP_ATTRIBUTE3
3032 ,p_line_rec.TP_ATTRIBUTE4
3033 ,p_line_rec.TP_ATTRIBUTE5
3034 ,p_line_rec.TP_ATTRIBUTE6
3035 ,p_line_rec.TP_ATTRIBUTE7
3036 ,p_line_rec.TP_ATTRIBUTE8
3037 ,p_line_rec.TP_ATTRIBUTE9
3038 ,p_line_rec.TP_ATTRIBUTE10
3039 ,p_line_rec.TP_ATTRIBUTE11
3040 ,p_line_rec.TP_ATTRIBUTE12
3041 ,p_line_rec.TP_ATTRIBUTE13
3042 ,p_line_rec.TP_ATTRIBUTE14
3043 ,p_line_rec.TP_ATTRIBUTE15
3044 --,p_line_rec.FLOW_STATUS_CODE
3045 --,p_line_rec.MARKETING_SOURCE_CODE_ID
3046 ,p_line_rec.CALCULATE_PRICE_FLAG
3047 ,p_line_rec.COMMITMENT_ID
3048 ,p_line_rec.ORDER_SOURCE_ID
3049 --,p_line_rec.upgraded_flag
3050 ,p_line_rec.LOCK_CONTROL
3051 ,p_line_rec.WF_PROCESS_NAME
3052 ,p_line_rec.II_START_INDEX
3053 ,p_line_rec.II_COUNT
3054 ,p_line_rec.user_item_description
3055 ,p_line_rec.parent_line_index
3056 ,p_line_rec.firm_demand_flag
3057 -- end customer (Bug 5054618)
3058 ,p_line_rec.End_customer_contact_id
3059 ,p_line_rec.End_customer_id
3060 ,p_line_rec.End_customer_site_use_id
3061 ,p_line_rec.IB_owner
3062 ,p_line_rec.IB_current_location
3063 ,p_line_rec.IB_Installed_at_Location
3064 ;
3065 else -- p_process_configuration=y
3066 IF l_debug_level > 0 THEN
3067 oe_debug_pub.add('before OPEN c_lines1_rtrim');
3068 END IF;
3069
3070 OPEN c_lines1_rtrim;
3071
3072 IF l_debug_level > 0 THEN
3073 oe_debug_pub.add('after OPEN c_lines1_rtrim');
3074 END IF;
3075
3076 FETCH c_lines1_rtrim BULK COLLECT INTO
3077 p_line_rec.ACCOUNTING_RULE_ID
3078 ,p_line_rec.ACCOUNTING_RULE_DURATION
3079 ,p_line_rec.ACTUAL_ARRIVAL_DATE
3080 --,p_line_rec.ACTUAL_SHIPMENT_DATE
3081 ,p_line_rec.AGREEMENT_ID
3082 ,p_line_rec.ARRIVAL_SET_ID
3083 ,p_line_rec.ATO_LINE_ID
3084 ,p_line_rec.ATTRIBUTE1
3085 ,p_line_rec.ATTRIBUTE10
3086 ,p_line_rec.ATTRIBUTE11
3087 ,p_line_rec.ATTRIBUTE12
3088 ,p_line_rec.ATTRIBUTE13
3089 ,p_line_rec.ATTRIBUTE14
3090 ,p_line_rec.ATTRIBUTE15
3091 ,p_line_rec.ATTRIBUTE16 --For bug 2184255
3092 ,p_line_rec.ATTRIBUTE17
3093 ,p_line_rec.ATTRIBUTE18
3094 ,p_line_rec.ATTRIBUTE19
3095 ,p_line_rec.ATTRIBUTE2
3096 ,p_line_rec.ATTRIBUTE20
3097 ,p_line_rec.ATTRIBUTE3
3098 ,p_line_rec.ATTRIBUTE4
3099 ,p_line_rec.ATTRIBUTE5
3100 ,p_line_rec.ATTRIBUTE6
3101 ,p_line_rec.ATTRIBUTE7
3102 ,p_line_rec.ATTRIBUTE8
3103 ,p_line_rec.ATTRIBUTE9
3104 --,p_line_rec.AUTO_SELECTED_QUANTITY
3105 ,p_line_rec.AUTHORIZED_TO_SHIP_FLAG
3106 ,p_line_rec.BOOKED_FLAG
3107 ,p_line_rec.CANCELLED_FLAG
3108 ,p_line_rec.CANCELLED_QUANTITY
3109 ,p_line_rec.COMPONENT_CODE
3110 ,p_line_rec.COMPONENT_NUMBER
3111 ,p_line_rec.COMPONENT_SEQUENCE_ID
3112 ,p_line_rec.CONFIG_HEADER_ID
3113 ,p_line_rec.CONFIG_REV_NBR
3114 ,p_line_rec.CONFIG_DISPLAY_SEQUENCE
3115 ,p_line_rec.CONFIGURATION_ID
3116 ,p_line_rec.CONTEXT
3117 --,p_line_rec.CREATED_BY
3118 --,p_line_rec.CREATION_DATE
3119 ,p_line_rec.CREDIT_INVOICE_LINE_ID
3120 ,p_line_rec.CUSTOMER_DOCK_CODE
3121 ,p_line_rec.CUSTOMER_JOB
3122 ,p_line_rec.CUSTOMER_PRODUCTION_LINE
3123 ,p_line_rec.CUST_PRODUCTION_SEQ_NUM
3124 --,p_line_rec.CUSTOMER_TRX_LINE_ID
3125 ,p_line_rec.CUST_MODEL_SERIAL_NUMBER
3126 ,p_line_rec.CUST_PO_NUMBER
3127 ,p_line_rec.CUSTOMER_LINE_NUMBER
3128 ,p_line_rec.DELIVERY_LEAD_TIME
3129 ,p_line_rec.DELIVER_TO_CONTACT_ID
3130 ,p_line_rec.DELIVER_TO_ORG_ID
3131 ,p_line_rec.DEMAND_BUCKET_TYPE_CODE
3132 ,p_line_rec.DEMAND_CLASS_CODE
3133 --,p_line_rec.DEP_PLAN_REQUIRED_FLAG
3134 ,p_line_rec.EARLIEST_ACCEPTABLE_DATE
3135 ,p_line_rec.END_ITEM_UNIT_NUMBER
3136 ,p_line_rec.EXPLOSION_DATE
3137 -- ,p_line_rec.FIRST_ACK_CODE
3138 -- ,p_line_rec.FIRST_ACK_DATE
3139 ,p_line_rec.FOB_POINT_CODE
3140 ,p_line_rec.FREIGHT_CARRIER_CODE
3141 ,p_line_rec.FREIGHT_TERMS_CODE
3142 --,p_line_rec.FULFILLED_QUANTITY
3143 --,p_line_rec.FULFILLED_FLAG
3144 --,p_line_rec.FULFILLMENT_METHOD_CODE
3145 --,p_line_rec.FULFILLMENT_DATE
3146 ,p_line_rec.GLOBAL_ATTRIBUTE1
3147 ,p_line_rec.GLOBAL_ATTRIBUTE10
3148 ,p_line_rec.GLOBAL_ATTRIBUTE11
3149 ,p_line_rec.GLOBAL_ATTRIBUTE12
3150 ,p_line_rec.GLOBAL_ATTRIBUTE13
3151 ,p_line_rec.GLOBAL_ATTRIBUTE14
3152 ,p_line_rec.GLOBAL_ATTRIBUTE15
3153 ,p_line_rec.GLOBAL_ATTRIBUTE16
3154 ,p_line_rec.GLOBAL_ATTRIBUTE17
3155 ,p_line_rec.GLOBAL_ATTRIBUTE18
3156 ,p_line_rec.GLOBAL_ATTRIBUTE19
3157 ,p_line_rec.GLOBAL_ATTRIBUTE2
3158 ,p_line_rec.GLOBAL_ATTRIBUTE20
3159 ,p_line_rec.GLOBAL_ATTRIBUTE3
3160 ,p_line_rec.GLOBAL_ATTRIBUTE4
3161 ,p_line_rec.GLOBAL_ATTRIBUTE5
3162 ,p_line_rec.GLOBAL_ATTRIBUTE6
3163 ,p_line_rec.GLOBAL_ATTRIBUTE7
3164 ,p_line_rec.GLOBAL_ATTRIBUTE8
3165 ,p_line_rec.GLOBAL_ATTRIBUTE9
3166 ,p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
3167 ,p_line_rec.HEADER_ID
3168 ,p_line_rec.INDUSTRY_ATTRIBUTE1
3169 ,p_line_rec.INDUSTRY_ATTRIBUTE10
3170 ,p_line_rec.INDUSTRY_ATTRIBUTE11
3171 ,p_line_rec.INDUSTRY_ATTRIBUTE12
3172 ,p_line_rec.INDUSTRY_ATTRIBUTE13
3173 ,p_line_rec.INDUSTRY_ATTRIBUTE14
3174 ,p_line_rec.INDUSTRY_ATTRIBUTE15
3175 ,p_line_rec.INDUSTRY_ATTRIBUTE16
3176 ,p_line_rec.INDUSTRY_ATTRIBUTE17
3177 ,p_line_rec.INDUSTRY_ATTRIBUTE18
3178 ,p_line_rec.INDUSTRY_ATTRIBUTE19
3179 ,p_line_rec.INDUSTRY_ATTRIBUTE20
3180 ,p_line_rec.INDUSTRY_ATTRIBUTE21
3181 ,p_line_rec.INDUSTRY_ATTRIBUTE22
3182 ,p_line_rec.INDUSTRY_ATTRIBUTE23
3183 ,p_line_rec.INDUSTRY_ATTRIBUTE24
3184 ,p_line_rec.INDUSTRY_ATTRIBUTE25
3185 ,p_line_rec.INDUSTRY_ATTRIBUTE26
3186 ,p_line_rec.INDUSTRY_ATTRIBUTE27
3187 ,p_line_rec.INDUSTRY_ATTRIBUTE28
3188 ,p_line_rec.INDUSTRY_ATTRIBUTE29
3189 ,p_line_rec.INDUSTRY_ATTRIBUTE30
3190 ,p_line_rec.INDUSTRY_ATTRIBUTE2
3191 ,p_line_rec.INDUSTRY_ATTRIBUTE3
3192 ,p_line_rec.INDUSTRY_ATTRIBUTE4
3193 ,p_line_rec.INDUSTRY_ATTRIBUTE5
3194 ,p_line_rec.INDUSTRY_ATTRIBUTE6
3195 ,p_line_rec.INDUSTRY_ATTRIBUTE7
3196 ,p_line_rec.INDUSTRY_ATTRIBUTE8
3197 ,p_line_rec.INDUSTRY_ATTRIBUTE9
3198 ,p_line_rec.INDUSTRY_CONTEXT
3199 --,p_line_rec.INTERMED_SHIP_TO_CONTACT_ID
3200 --,p_line_rec.INTERMED_SHIP_TO_ORG_ID
3201 ,p_line_rec.INVENTORY_ITEM_ID
3202 --,p_line_rec.INVOICE_INTERFACE_STATUS_CODE
3203 ,p_line_rec.INVOICE_TO_CONTACT_ID
3204 ,p_line_rec.INVOICE_TO_ORG_ID
3205 --,p_line_rec.INVOICED_QUANTITY
3206 ,p_line_rec.INVOICING_RULE_ID
3207 ,p_line_rec.ORDERED_ITEM_ID
3208 ,p_line_rec.ITEM_IDENTIFIER_TYPE
3209 ,p_line_rec.ORDERED_ITEM
3210 ,p_line_rec.CUSTOMER_ITEM_NET_PRICE
3211 ,p_line_rec.CUSTOMER_PAYMENT_TERM_ID
3212 ,p_line_rec.ITEM_REVISION
3213 ,p_line_rec.ITEM_TYPE_CODE
3214 -- ,p_line_rec.LAST_ACK_CODE
3215 -- ,p_line_rec.LAST_ACK_DATE
3216 --,p_line_rec.LAST_UPDATED_BY
3217 --,p_line_rec.LAST_UPDATE_DATE
3218 --,p_line_rec.LAST_UPDATE_LOGIN
3219 ,p_line_rec.LATEST_ACCEPTABLE_DATE
3220 ,p_line_rec.LINE_CATEGORY_CODE
3221 ,p_line_rec.LINE_ID
3222 ,p_line_rec.LINE_NUMBER
3223 ,p_line_rec.LINE_TYPE_ID
3224 ,p_line_rec.LINK_TO_LINE_ID
3225 ,p_line_rec.MODEL_GROUP_NUMBER
3226 ,p_line_rec.MFG_LEAD_TIME
3227 --,p_line_rec.OPEN_FLAG
3228 ,p_line_rec.OPTION_FLAG
3229 ,p_line_rec.OPTION_NUMBER
3230 ,p_line_rec.ORDERED_QUANTITY
3231 ,p_line_rec.ORDERED_QUANTITY2 --OPM 02/JUN/00
3232 ,p_line_rec.ORDER_QUANTITY_UOM
3233 ,p_line_rec.ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
3234 ,p_line_rec.ORG_ID
3235 ,p_line_rec.ORIG_SYS_DOCUMENT_REF
3236 ,p_line_rec.ORIG_SYS_LINE_REF
3237 ,p_line_rec.ORIG_SYS_SHIPMENT_REF
3238 ,p_line_rec.CHANGE_SEQUENCE
3239 ,p_line_rec.OVER_SHIP_REASON_CODE
3240 ,p_line_rec.OVER_SHIP_RESOLVED_FLAG
3241 ,p_line_rec.PAYMENT_TERM_ID
3242 --,p_line_rec.PLANNING_PRIORITY
3243 ,p_line_rec.PREFERRED_GRADE --OPM HVOP
3244 ,p_line_rec.PRICE_LIST_ID
3245 --,p_line_rec.PRICE_REQUEST_CODE --PROMOTIONS MAY/01
3246 ,p_line_rec.PRICING_ATTRIBUTE1
3247 ,p_line_rec.PRICING_ATTRIBUTE10
3248 ,p_line_rec.PRICING_ATTRIBUTE2
3249 ,p_line_rec.PRICING_ATTRIBUTE3
3250 ,p_line_rec.PRICING_ATTRIBUTE4
3251 ,p_line_rec.PRICING_ATTRIBUTE5
3252 ,p_line_rec.PRICING_ATTRIBUTE6
3253 ,p_line_rec.PRICING_ATTRIBUTE7
3254 ,p_line_rec.PRICING_ATTRIBUTE8
3255 ,p_line_rec.PRICING_ATTRIBUTE9
3256 ,p_line_rec.PRICING_CONTEXT
3257 ,p_line_rec.PRICING_DATE
3258 ,p_line_rec.PRICING_QUANTITY
3259 ,p_line_rec.PRICING_QUANTITY_UOM
3260 --,p_line_rec.PROGRAM_APPLICATION_ID
3261 --,p_line_rec.PROGRAM_ID
3262 --,p_line_rec.PROGRAM_UPDATE_DATE
3263 ,p_line_rec.PROJECT_ID
3264 ,p_line_rec.PROMISE_DATE
3265 ,p_line_rec.RE_SOURCE_FLAG
3266 --,p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID
3267 ,p_line_rec.REFERENCE_HEADER_ID
3268 ,p_line_rec.REFERENCE_LINE_ID
3269 ,p_line_rec.REFERENCE_TYPE
3270 ,p_line_rec.REQUEST_DATE
3271 ,p_line_rec.REQUEST_ID
3272 ,p_line_rec.RETURN_ATTRIBUTE1
3273 ,p_line_rec.RETURN_ATTRIBUTE10
3274 ,p_line_rec.RETURN_ATTRIBUTE11
3275 ,p_line_rec.RETURN_ATTRIBUTE12
3276 ,p_line_rec.RETURN_ATTRIBUTE13
3277 ,p_line_rec.RETURN_ATTRIBUTE14
3278 ,p_line_rec.RETURN_ATTRIBUTE15
3279 ,p_line_rec.RETURN_ATTRIBUTE2
3280 ,p_line_rec.RETURN_ATTRIBUTE3
3281 ,p_line_rec.RETURN_ATTRIBUTE4
3282 ,p_line_rec.RETURN_ATTRIBUTE5
3283 ,p_line_rec.RETURN_ATTRIBUTE6
3284 ,p_line_rec.RETURN_ATTRIBUTE7
3285 ,p_line_rec.RETURN_ATTRIBUTE8
3286 ,p_line_rec.RETURN_ATTRIBUTE9
3287 ,p_line_rec.RETURN_CONTEXT
3288 ,p_line_rec.RETURN_REASON_CODE
3289 --,p_line_rec.RLA_SCHEDULE_TYPE_CODE
3290 ,p_line_rec.SALESREP_ID
3291 ,p_line_rec.SCHEDULE_ARRIVAL_DATE
3292 ,p_line_rec.SCHEDULE_SHIP_DATE
3293 ,p_line_rec.SCHEDULE_STATUS_CODE
3294 ,p_line_rec.SHIPMENT_NUMBER
3295 ,p_line_rec.SHIPMENT_PRIORITY_CODE
3296 ,p_line_rec.SHIPPED_QUANTITY
3297 ,p_line_rec.SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
3298 ,p_line_rec.SHIPPING_METHOD_CODE
3299 ,p_line_rec.SHIPPING_QUANTITY
3300 ,p_line_rec.SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
3301 ,p_line_rec.SHIPPING_QUANTITY_UOM
3302 ,p_line_rec.SHIP_FROM_ORG_ID
3303 ,p_line_rec.SUBINVENTORY
3304 ,p_line_rec.SHIP_SET_ID
3305 ,p_line_rec.SHIP_TOLERANCE_ABOVE
3306 ,p_line_rec.SHIP_TOLERANCE_BELOW
3307 ,p_line_rec.SHIPPABLE_FLAG
3308 --,p_line_rec.SHIPPING_INTERFACED_FLAG
3309 ,p_line_rec.SHIP_TO_CONTACT_ID
3310 ,p_line_rec.SHIP_TO_ORG_ID
3311 ,p_line_rec.SHIP_MODEL_COMPLETE_FLAG
3312 ,p_line_rec.SOLD_TO_ORG_ID
3313 ,p_line_rec.SOLD_FROM_ORG_ID
3314 ,p_line_rec.SORT_ORDER
3315 ,p_line_rec.SOURCE_DOCUMENT_ID
3316 --,p_line_rec.SOURCE_DOCUMENT_LINE_ID
3317 --,p_line_rec.SOURCE_DOCUMENT_TYPE_ID
3318 ,p_line_rec.SOURCE_TYPE_CODE
3319 ,p_line_rec.SPLIT_FROM_LINE_ID
3320 --,p_line_rec.LINE_SET_ID
3321 --,p_line_rec.SPLIT_BY
3322 ,p_line_rec.MODEL_REMNANT_FLAG
3323 ,p_line_rec.TASK_ID
3324 ,p_line_rec.TAX_CODE
3325 ,p_line_rec.TAX_DATE
3326 ,p_line_rec.TAX_EXEMPT_FLAG
3327 ,p_line_rec.TAX_EXEMPT_NUMBER
3328 ,p_line_rec.TAX_EXEMPT_REASON_CODE
3329 ,p_line_rec.TAX_POINT_CODE
3330 --,p_line_rec.TAX_RATE
3331 ,p_line_rec.TAX_VALUE
3332 ,p_line_rec.TOP_MODEL_LINE_ID
3333 ,p_line_rec.TOP_MODEL_LINE_REF
3334 ,p_line_rec.UNIT_LIST_PRICE
3335 ,p_line_rec.UNIT_LIST_PRICE_PER_PQTY
3336 ,p_line_rec.UNIT_SELLING_PRICE
3337 ,p_line_rec.UNIT_SELLING_PRICE_PER_PQTY
3338 ,p_line_rec.VISIBLE_DEMAND_FLAG
3339 ,p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
3340 ,p_line_rec.SHIPPING_INSTRUCTIONS
3341 ,p_line_rec.PACKING_INSTRUCTIONS
3342 ,p_line_rec.SERVICE_TXN_REASON_CODE
3343 ,p_line_rec.SERVICE_TXN_COMMENTS
3344 ,p_line_rec.SERVICE_DURATION
3345 ,p_line_rec.SERVICE_PERIOD
3346 ,p_line_rec.SERVICE_START_DATE
3347 ,p_line_rec.SERVICE_END_DATE
3348 ,p_line_rec.SERVICE_COTERMINATE_FLAG
3349 ,p_line_rec.UNIT_LIST_PERCENT
3350 ,p_line_rec.UNIT_SELLING_PERCENT
3351 ,p_line_rec.UNIT_PERCENT_BASE_PRICE
3352 ,p_line_rec.SERVICE_NUMBER
3353 ,p_line_rec.SERVICE_REFERENCE_TYPE_CODE
3354 --,p_line_rec.SERVICE_REFERENCE_LINE_ID
3355 --,p_line_rec.SERVICE_REFERENCE_SYSTEM_ID
3356 ,p_line_rec.TP_CONTEXT
3357 ,p_line_rec.TP_ATTRIBUTE1
3358 ,p_line_rec.TP_ATTRIBUTE2
3359 ,p_line_rec.TP_ATTRIBUTE3
3360 ,p_line_rec.TP_ATTRIBUTE4
3361 ,p_line_rec.TP_ATTRIBUTE5
3362 ,p_line_rec.TP_ATTRIBUTE6
3363 ,p_line_rec.TP_ATTRIBUTE7
3364 ,p_line_rec.TP_ATTRIBUTE8
3365 ,p_line_rec.TP_ATTRIBUTE9
3366 ,p_line_rec.TP_ATTRIBUTE10
3367 ,p_line_rec.TP_ATTRIBUTE11
3368 ,p_line_rec.TP_ATTRIBUTE12
3369 ,p_line_rec.TP_ATTRIBUTE13
3370 ,p_line_rec.TP_ATTRIBUTE14
3371 ,p_line_rec.TP_ATTRIBUTE15
3372 --,p_line_rec.FLOW_STATUS_CODE
3373 --,p_line_rec.MARKETING_SOURCE_CODE_ID
3374 ,p_line_rec.CALCULATE_PRICE_FLAG
3375 ,p_line_rec.COMMITMENT_ID
3376 ,p_line_rec.ORDER_SOURCE_ID
3377 --,p_line_rec.upgraded_flag
3378 ,p_line_rec.LOCK_CONTROL
3379 ,p_line_rec.WF_PROCESS_NAME
3380 ,p_line_rec.II_START_INDEX
3381 ,p_line_rec.II_COUNT
3382 ,p_line_rec.user_item_description
3383 ,p_line_rec.parent_line_index
3384 ,p_line_rec.firm_demand_flag
3385 -- end customer
3386 ,p_line_rec.End_customer_contact_id
3387 ,p_line_rec.End_customer_id
3388 ,p_line_rec.End_customer_site_use_id
3389 ,p_line_rec.IB_owner
3390 ,p_line_rec.IB_current_location
3391 ,p_line_rec.IB_Installed_at_Location
3392 ,p_line_rec.cust_trx_type_id
3393 ,p_line_rec.tax_calculation_flag
3394 ,p_line_rec.ato_line_index
3395 ,p_line_rec.top_model_line_index
3396 ;
3397 END IF; -- p_process_configuration
3398 END IF;
3399
3400 if (p_line_rec.line_index.count < p_line_rec.line_id.count)
3401 then
3402 p_line_rec.line_index.extend(p_line_rec.line_id.count - p_line_rec.line_index.count);
3403 end if;
3404
3405 if (p_line_rec.header_index.count < p_line_rec.line_id.count)
3406 then
3407 p_line_rec.header_index.extend(p_line_rec.line_id.count - p_line_rec.header_index.count);
3408 end if;
3409 oe_debug_pub.add('after bulk collect');
3410 EXCEPTION
3411 WHEN OTHERS THEN
3412 IF l_debug_level > 0 THEN
3413 oe_debug_pub.add( 'OTHERS ERROR , LOAD_LINES' ) ;
3414 oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
3415 END IF;
3416 OE_BULK_MSG_PUB.Add_Exc_Msg
3417 ( G_PKG_NAME
3418 , 'Load_Lines'
3419 );
3420 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3421 END Load_Lines;
3422
3423
3424 ---------------------------------------------------------------------
3425 -- PROCEDURE Insert_Lines
3426 --
3427 -- BULK Inserts order lines into the OM tables from p_line_rec
3428 ---------------------------------------------------------------------
3429
3430 PROCEDURE Insert_Lines
3431 (p_line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE)
3432 IS
3433 ctr NUMBER;
3434 --
3435 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3436 --
3437 BEGIN
3438
3439 ctr := p_line_rec.line_id.count;
3440
3441 FORALL i IN 1..ctr
3442 INSERT INTO OE_ORDER_LINES
3443 (ACCOUNTING_RULE_ID
3444 ,ACCOUNTING_RULE_DURATION
3445 ,ACTUAL_ARRIVAL_DATE
3446 -- ,ACTUAL_SHIPMENT_DATE
3447 ,AGREEMENT_ID
3448 ,ARRIVAL_SET_ID
3449 ,ATO_LINE_ID
3450 ,ATTRIBUTE1
3451 ,ATTRIBUTE10
3452 ,ATTRIBUTE11
3453 ,ATTRIBUTE12
3454 ,ATTRIBUTE13
3455 ,ATTRIBUTE14
3456 ,ATTRIBUTE15
3457 ,ATTRIBUTE16 --For bug 2184255
3458 ,ATTRIBUTE17
3459 ,ATTRIBUTE18
3460 ,ATTRIBUTE19
3461 ,ATTRIBUTE2
3462 ,ATTRIBUTE20
3463 ,ATTRIBUTE3
3464 ,ATTRIBUTE4
3465 ,ATTRIBUTE5
3466 ,ATTRIBUTE6
3467 ,ATTRIBUTE7
3468 ,ATTRIBUTE8
3469 ,ATTRIBUTE9
3470 -- ,AUTO_SELECTED_QUANTITY
3471 ,AUTHORIZED_TO_SHIP_FLAG
3472 ,BOOKED_FLAG
3473 ,CANCELLED_FLAG
3474 ,CANCELLED_QUANTITY
3475 ,COMPONENT_CODE
3476 ,COMPONENT_NUMBER
3477 ,COMPONENT_SEQUENCE_ID
3478 ,CONFIG_HEADER_ID
3479 ,CONFIG_REV_NBR
3480 ,CONFIG_DISPLAY_SEQUENCE
3481 ,CONFIGURATION_ID
3482 ,CONTEXT
3483 ,CREATED_BY
3484 ,CREATION_DATE
3485 ,CREDIT_INVOICE_LINE_ID
3486 ,CUSTOMER_DOCK_CODE
3487 ,CUSTOMER_JOB
3488 ,CUSTOMER_PRODUCTION_LINE
3489 ,CUST_PRODUCTION_SEQ_NUM
3490 -- ,CUSTOMER_TRX_LINE_ID
3491 ,CUST_MODEL_SERIAL_NUMBER
3492 ,CUST_PO_NUMBER
3493 ,CUSTOMER_LINE_NUMBER
3494 ,DELIVERY_LEAD_TIME
3495 ,DELIVER_TO_CONTACT_ID
3496 ,DELIVER_TO_ORG_ID
3497 ,DEMAND_BUCKET_TYPE_CODE
3498 ,DEMAND_CLASS_CODE
3499 -- ,DEP_PLAN_REQUIRED_FLAG
3500 ,EARLIEST_ACCEPTABLE_DATE
3501 ,END_ITEM_UNIT_NUMBER
3502 ,EXPLOSION_DATE
3503 -- ,FIRST_ACK_CODE
3504 -- ,FIRST_ACK_DATE
3505 ,FOB_POINT_CODE
3506 ,FREIGHT_CARRIER_CODE
3507 ,FREIGHT_TERMS_CODE
3508 -- ,FULFILLED_QUANTITY
3509 -- ,FULFILLED_FLAG
3510 -- ,FULFILLMENT_METHOD_CODE
3511 -- ,FULFILLMENT_DATE
3512 ,GLOBAL_ATTRIBUTE1
3513 ,GLOBAL_ATTRIBUTE10
3514 ,GLOBAL_ATTRIBUTE11
3515 ,GLOBAL_ATTRIBUTE12
3516 ,GLOBAL_ATTRIBUTE13
3517 ,GLOBAL_ATTRIBUTE14
3518 ,GLOBAL_ATTRIBUTE15
3519 ,GLOBAL_ATTRIBUTE16
3520 ,GLOBAL_ATTRIBUTE17
3521 ,GLOBAL_ATTRIBUTE18
3522 ,GLOBAL_ATTRIBUTE19
3523 ,GLOBAL_ATTRIBUTE2
3524 ,GLOBAL_ATTRIBUTE20
3525 ,GLOBAL_ATTRIBUTE3
3526 ,GLOBAL_ATTRIBUTE4
3527 ,GLOBAL_ATTRIBUTE5
3528 ,GLOBAL_ATTRIBUTE6
3529 ,GLOBAL_ATTRIBUTE7
3530 ,GLOBAL_ATTRIBUTE8
3531 ,GLOBAL_ATTRIBUTE9
3532 ,GLOBAL_ATTRIBUTE_CATEGORY
3533 ,HEADER_ID
3534 ,INDUSTRY_ATTRIBUTE1
3535 ,INDUSTRY_ATTRIBUTE10
3536 ,INDUSTRY_ATTRIBUTE11
3537 ,INDUSTRY_ATTRIBUTE12
3538 ,INDUSTRY_ATTRIBUTE13
3539 ,INDUSTRY_ATTRIBUTE14
3540 ,INDUSTRY_ATTRIBUTE15
3541 ,INDUSTRY_ATTRIBUTE16
3542 ,INDUSTRY_ATTRIBUTE17
3543 ,INDUSTRY_ATTRIBUTE18
3544 ,INDUSTRY_ATTRIBUTE19
3545 ,INDUSTRY_ATTRIBUTE20
3546 ,INDUSTRY_ATTRIBUTE21
3547 ,INDUSTRY_ATTRIBUTE22
3548 ,INDUSTRY_ATTRIBUTE23
3549 ,INDUSTRY_ATTRIBUTE24
3550 ,INDUSTRY_ATTRIBUTE25
3551 ,INDUSTRY_ATTRIBUTE26
3552 ,INDUSTRY_ATTRIBUTE27
3553 ,INDUSTRY_ATTRIBUTE28
3554 ,INDUSTRY_ATTRIBUTE29
3555 ,INDUSTRY_ATTRIBUTE30
3556 ,INDUSTRY_ATTRIBUTE2
3557 ,INDUSTRY_ATTRIBUTE3
3558 ,INDUSTRY_ATTRIBUTE4
3559 ,INDUSTRY_ATTRIBUTE5
3560 ,INDUSTRY_ATTRIBUTE6
3561 ,INDUSTRY_ATTRIBUTE7
3562 ,INDUSTRY_ATTRIBUTE8
3563 ,INDUSTRY_ATTRIBUTE9
3564 ,INDUSTRY_CONTEXT
3565 -- ,INTERMED_SHIP_TO_CONTACT_ID
3566 -- ,INTERMED_SHIP_TO_ORG_ID
3567 ,INVENTORY_ITEM_ID
3568 -- ,INVOICE_INTERFACE_STATUS_CODE
3569 ,INVOICE_TO_CONTACT_ID
3570 ,INVOICE_TO_ORG_ID
3571 -- ,INVOICED_QUANTITY
3572 ,INVOICING_RULE_ID
3573 ,ORDERED_ITEM_ID
3574 ,ITEM_IDENTIFIER_TYPE
3575 ,ORDERED_ITEM
3576 ,CUSTOMER_ITEM_NET_PRICE
3577 ,ITEM_REVISION
3578 ,ITEM_TYPE_CODE
3579 -- ,LAST_ACK_CODE
3580 -- ,LAST_ACK_DATE
3581 ,LAST_UPDATED_BY
3582 ,LAST_UPDATE_DATE
3583 -- ,LAST_UPDATE_LOGIN
3584 ,LATEST_ACCEPTABLE_DATE
3585 ,LINE_CATEGORY_CODE
3586 ,LINE_ID
3587 ,LINE_NUMBER
3588 ,LINE_TYPE_ID
3589 ,LINK_TO_LINE_ID
3590 ,MODEL_GROUP_NUMBER
3591 ,MFG_LEAD_TIME
3592 ,OPEN_FLAG
3593 ,OPTION_FLAG
3594 ,OPTION_NUMBER
3595 ,ORDERED_QUANTITY
3596 ,ORDERED_QUANTITY2 --OPM 02/JUN/00
3597 ,ORDER_QUANTITY_UOM
3598 ,ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
3599 ,ORG_ID --moac
3600 ,ORIG_SYS_DOCUMENT_REF
3601 ,ORIG_SYS_LINE_REF
3602 ,ORIG_SYS_SHIPMENT_REF
3603 ,CHANGE_SEQUENCE
3604 ,OVER_SHIP_REASON_CODE
3605 ,OVER_SHIP_RESOLVED_FLAG
3606 ,PAYMENT_TERM_ID
3607 -- ,PLANNING_PRIORITY
3608 ,PREFERRED_GRADE --OPM HVOP
3609 ,PRICE_LIST_ID
3610 -- ,PRICE_REQUEST_CODE --PROMOTIONS MAY/01
3611 ,PRICING_ATTRIBUTE1
3612 ,PRICING_ATTRIBUTE10
3613 ,PRICING_ATTRIBUTE2
3614 ,PRICING_ATTRIBUTE3
3615 ,PRICING_ATTRIBUTE4
3616 ,PRICING_ATTRIBUTE5
3617 ,PRICING_ATTRIBUTE6
3618 ,PRICING_ATTRIBUTE7
3619 ,PRICING_ATTRIBUTE8
3620 ,PRICING_ATTRIBUTE9
3621 ,PRICING_CONTEXT
3622 ,PRICING_DATE
3623 ,PRICING_QUANTITY
3624 ,PRICING_QUANTITY_UOM
3625 -- ,PROGRAM_APPLICATION_ID
3626 -- ,PROGRAM_ID
3627 -- ,PROGRAM_UPDATE_DATE
3628 ,PROJECT_ID
3629 ,PROMISE_DATE
3630 ,RE_SOURCE_FLAG
3631 -- ,REFERENCE_CUSTOMER_TRX_LINE_ID
3632 ,REFERENCE_HEADER_ID
3633 ,REFERENCE_LINE_ID
3634 ,REFERENCE_TYPE
3635 ,REQUEST_DATE
3636 ,REQUEST_ID
3637 ,RETURN_ATTRIBUTE1
3638 ,RETURN_ATTRIBUTE10
3639 ,RETURN_ATTRIBUTE11
3640 ,RETURN_ATTRIBUTE12
3641 ,RETURN_ATTRIBUTE13
3642 ,RETURN_ATTRIBUTE14
3643 ,RETURN_ATTRIBUTE15
3644 ,RETURN_ATTRIBUTE2
3645 ,RETURN_ATTRIBUTE3
3646 ,RETURN_ATTRIBUTE4
3647 ,RETURN_ATTRIBUTE5
3648 ,RETURN_ATTRIBUTE6
3649 ,RETURN_ATTRIBUTE7
3650 ,RETURN_ATTRIBUTE8
3651 ,RETURN_ATTRIBUTE9
3652 ,RETURN_CONTEXT
3653 ,RETURN_REASON_CODE
3654 -- ,RLA_SCHEDULE_TYPE_CODE
3655 ,SALESREP_ID
3656 ,SCHEDULE_ARRIVAL_DATE
3657 ,SCHEDULE_SHIP_DATE
3658 ,SCHEDULE_STATUS_CODE
3659 ,SHIPMENT_NUMBER
3660 ,SHIPMENT_PRIORITY_CODE
3661 ,SHIPPED_QUANTITY
3662 ,SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
3663 ,SHIPPING_METHOD_CODE
3664 ,SHIPPING_QUANTITY
3665 ,SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
3666 ,SHIPPING_QUANTITY_UOM
3667 ,SHIP_FROM_ORG_ID
3668 ,SUBINVENTORY
3669 ,SHIP_SET_ID
3670 ,SHIP_TOLERANCE_ABOVE
3671 ,SHIP_TOLERANCE_BELOW
3672 ,SHIPPABLE_FLAG
3673 ,SHIPPING_INTERFACED_FLAG
3674 ,SHIP_TO_CONTACT_ID
3675 ,SHIP_TO_ORG_ID
3676 ,SHIP_MODEL_COMPLETE_FLAG
3677 ,SOLD_TO_ORG_ID
3678 ,SOLD_FROM_ORG_ID
3679 ,SORT_ORDER
3680 ,SOURCE_DOCUMENT_ID
3681 -- ,SOURCE_DOCUMENT_LINE_ID
3682 -- ,SOURCE_DOCUMENT_TYPE_ID
3683 ,SOURCE_TYPE_CODE
3684 ,SPLIT_FROM_LINE_ID
3685 -- ,LINE_SET_ID
3686 -- ,SPLIT_BY
3687 ,MODEL_REMNANT_FLAG
3688 ,TASK_ID
3689 ,TAX_CODE
3690 ,TAX_DATE
3691 ,TAX_EXEMPT_FLAG
3692 ,TAX_EXEMPT_NUMBER
3693 ,TAX_EXEMPT_REASON_CODE
3694 ,TAX_POINT_CODE
3695 -- ,TAX_RATE
3696 ,TAX_VALUE
3697 ,TOP_MODEL_LINE_ID
3698 ,UNIT_LIST_PRICE
3699 ,UNIT_LIST_PRICE_PER_PQTY
3700 ,UNIT_SELLING_PRICE
3701 ,UNIT_SELLING_PRICE_PER_PQTY
3702 ,VISIBLE_DEMAND_FLAG
3703 ,VEH_CUS_ITEM_CUM_KEY_ID
3704 ,SHIPPING_INSTRUCTIONS
3705 ,PACKING_INSTRUCTIONS
3706 ,SERVICE_TXN_REASON_CODE
3707 ,SERVICE_TXN_COMMENTS
3708 ,SERVICE_DURATION
3709 ,SERVICE_PERIOD
3710 ,SERVICE_START_DATE
3711 ,SERVICE_END_DATE
3712 ,SERVICE_COTERMINATE_FLAG
3713 ,UNIT_LIST_PERCENT
3714 ,UNIT_SELLING_PERCENT
3715 ,UNIT_PERCENT_BASE_PRICE
3716 ,SERVICE_NUMBER
3717 ,SERVICE_REFERENCE_TYPE_CODE
3718 -- ,SERVICE_REFERENCE_LINE_ID
3719 -- ,SERVICE_REFERENCE_SYSTEM_ID
3720 ,TP_CONTEXT
3721 ,TP_ATTRIBUTE1
3722 ,TP_ATTRIBUTE2
3723 ,TP_ATTRIBUTE3
3724 ,TP_ATTRIBUTE4
3725 ,TP_ATTRIBUTE5
3726 ,TP_ATTRIBUTE6
3727 ,TP_ATTRIBUTE7
3728 ,TP_ATTRIBUTE8
3729 ,TP_ATTRIBUTE9
3730 ,TP_ATTRIBUTE10
3731 ,TP_ATTRIBUTE11
3732 ,TP_ATTRIBUTE12
3733 ,TP_ATTRIBUTE13
3734 ,TP_ATTRIBUTE14
3735 ,TP_ATTRIBUTE15
3736 ,FLOW_STATUS_CODE
3737 -- ,MARKETING_SOURCE_CODE_ID
3738 ,CALCULATE_PRICE_FLAG
3739 ,COMMITMENT_ID
3740 ,ORDER_SOURCE_ID
3741 -- ,upgraded_flag
3742 ,user_item_description
3743 ,LOCK_CONTROL
3744 ,FIRM_DEMAND_FLAG
3745 -- QUOTING change
3746 ,transaction_phase_code
3747 -- end customer (Bug 5054618)
3748 ,End_customer_contact_id
3749 ,End_customer_id
3750 ,End_customer_site_use_id
3751 ,IB_owner
3752 ,IB_current_location
3753 ,IB_Installed_at_Location
3754 )
3755 VALUES
3756 (p_line_rec.ACCOUNTING_RULE_ID(i)
3757 ,p_line_rec.ACCOUNTING_RULE_DURATION(i)
3758 ,p_line_rec.ACTUAL_ARRIVAL_DATE(i)
3759 --,p_line_rec.ACTUAL_SHIPMENT_DATE(i)
3760 ,p_line_rec.AGREEMENT_ID(i)
3761 ,p_line_rec.ARRIVAL_SET_ID(i)
3762 ,p_line_rec.ATO_LINE_ID(i)
3763 ,p_line_rec.ATTRIBUTE1(i)
3764 ,p_line_rec.ATTRIBUTE10(i)
3765 ,p_line_rec.ATTRIBUTE11(i)
3766 ,p_line_rec.ATTRIBUTE12(i)
3767 ,p_line_rec.ATTRIBUTE13(i)
3768 ,p_line_rec.ATTRIBUTE14(i)
3769 ,p_line_rec.ATTRIBUTE15(i)
3770 ,p_line_rec.ATTRIBUTE16(i) --For bug 2184255
3771 ,p_line_rec.ATTRIBUTE17(i)
3772 ,p_line_rec.ATTRIBUTE18(i)
3773 ,p_line_rec.ATTRIBUTE19(i)
3774 ,p_line_rec.ATTRIBUTE2(i)
3775 ,p_line_rec.ATTRIBUTE20(i)
3776 ,p_line_rec.ATTRIBUTE3(i)
3777 ,p_line_rec.ATTRIBUTE4(i)
3778 ,p_line_rec.ATTRIBUTE5(i)
3779 ,p_line_rec.ATTRIBUTE6(i)
3780 ,p_line_rec.ATTRIBUTE7(i)
3781 ,p_line_rec.ATTRIBUTE8(i)
3782 ,p_line_rec.ATTRIBUTE9(i)
3783 --,p_line_rec.AUTO_SELECTED_QUANTITY(i)
3784 ,p_line_rec.AUTHORIZED_TO_SHIP_FLAG(i)
3785 ,p_line_rec.BOOKED_FLAG (i)
3786 ,p_line_rec.CANCELLED_FLAG(i)
3787 ,p_line_rec.CANCELLED_QUANTITY(i)
3788 ,p_line_rec.COMPONENT_CODE(i)
3789 ,p_line_rec.COMPONENT_NUMBER(i)
3790 ,p_line_rec.COMPONENT_SEQUENCE_ID(i)
3791 ,p_line_rec.CONFIG_HEADER_ID(i)
3792 ,p_line_rec.CONFIG_REV_NBR(i)
3793 ,p_line_rec.CONFIG_DISPLAY_SEQUENCE(i)
3794 ,p_line_rec.CONFIGURATION_ID(i)
3795 ,p_line_rec.CONTEXT(i)
3796 ,FND_GLOBAL.USER_ID -- p_line_rec.CREATED_BY(i)
3797 ,sysdate -- p_line_rec.CREATION_DATE(i)
3798 ,p_line_rec.CREDIT_INVOICE_LINE_ID(i)
3799 ,p_line_rec.CUSTOMER_DOCK_CODE(i)
3800 ,p_line_rec.CUSTOMER_JOB(i)
3801 ,p_line_rec.CUSTOMER_PRODUCTION_LINE(i)
3802 ,p_line_rec.CUST_PRODUCTION_SEQ_NUM(i)
3803 --,p_line_rec.CUSTOMER_TRX_LINE_ID(i)
3804 ,p_line_rec.CUST_MODEL_SERIAL_NUMBER(i)
3805 ,p_line_rec.CUST_PO_NUMBER(i)
3806 ,p_line_rec.CUSTOMER_LINE_NUMBER(i)
3807 ,p_line_rec.DELIVERY_LEAD_TIME(i)
3808 ,p_line_rec.DELIVER_TO_CONTACT_ID(i)
3809 ,p_line_rec.DELIVER_TO_ORG_ID(i)
3810 ,p_line_rec.DEMAND_BUCKET_TYPE_CODE(i)
3811 ,p_line_rec.DEMAND_CLASS_CODE(i)
3812 --,p_line_rec.DEP_PLAN_REQUIRED_FLAG(i)
3813 ,p_line_rec.EARLIEST_ACCEPTABLE_DATE(i)
3814 ,p_line_rec.END_ITEM_UNIT_NUMBER(i)
3815 ,p_line_rec.EXPLOSION_DATE(i)
3816 --,p_line_rec.FIRST_ACK_CODE(i)
3817 --,p_line_rec.FIRST_ACK_DATE(i)
3818 ,p_line_rec.FOB_POINT_CODE(i)
3819 ,p_line_rec.FREIGHT_CARRIER_CODE(i)
3820 ,p_line_rec.FREIGHT_TERMS_CODE(i)
3821 --,p_line_rec.FULFILLED_QUANTITY(i)
3822 --,p_line_rec.FULFILLED_FLAG(i)
3823 --,p_line_rec.FULFILLMENT_METHOD_CODE(i)
3824 --,p_line_rec.FULFILLMENT_DATE(i)
3825 ,p_line_rec.GLOBAL_ATTRIBUTE1(i)
3826 ,p_line_rec.GLOBAL_ATTRIBUTE10(i)
3827 ,p_line_rec.GLOBAL_ATTRIBUTE11(i)
3828 ,p_line_rec.GLOBAL_ATTRIBUTE12(i)
3829 ,p_line_rec.GLOBAL_ATTRIBUTE13(i)
3830 ,p_line_rec.GLOBAL_ATTRIBUTE14(i)
3831 ,p_line_rec.GLOBAL_ATTRIBUTE15(i)
3832 ,p_line_rec.GLOBAL_ATTRIBUTE16(i)
3833 ,p_line_rec.GLOBAL_ATTRIBUTE17(i)
3834 ,p_line_rec.GLOBAL_ATTRIBUTE18(i)
3835 ,p_line_rec.GLOBAL_ATTRIBUTE19(i)
3836 ,p_line_rec.GLOBAL_ATTRIBUTE2(i)
3837 ,p_line_rec.GLOBAL_ATTRIBUTE20(i)
3838 ,p_line_rec.GLOBAL_ATTRIBUTE3(i)
3839 ,p_line_rec.GLOBAL_ATTRIBUTE4(i)
3840 ,p_line_rec.GLOBAL_ATTRIBUTE5(i)
3841 ,p_line_rec.GLOBAL_ATTRIBUTE6(i)
3842 ,p_line_rec.GLOBAL_ATTRIBUTE7(i)
3843 ,p_line_rec.GLOBAL_ATTRIBUTE8(i)
3844 ,p_line_rec.GLOBAL_ATTRIBUTE9(i)
3845 ,p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY(i)
3846 ,p_line_rec.HEADER_ID(i)
3847 ,p_line_rec.INDUSTRY_ATTRIBUTE1(i)
3848 ,p_line_rec.INDUSTRY_ATTRIBUTE10(i)
3849 ,p_line_rec.INDUSTRY_ATTRIBUTE11(i)
3850 ,p_line_rec.INDUSTRY_ATTRIBUTE12(i)
3851 ,p_line_rec.INDUSTRY_ATTRIBUTE13(i)
3852 ,p_line_rec.INDUSTRY_ATTRIBUTE14(i)
3853 ,p_line_rec.INDUSTRY_ATTRIBUTE15(i)
3854 ,p_line_rec.INDUSTRY_ATTRIBUTE16(i)
3855 ,p_line_rec.INDUSTRY_ATTRIBUTE17(i)
3856 ,p_line_rec.INDUSTRY_ATTRIBUTE18(i)
3857 ,p_line_rec.INDUSTRY_ATTRIBUTE19(i)
3858 ,p_line_rec.INDUSTRY_ATTRIBUTE20(i)
3859 ,p_line_rec.INDUSTRY_ATTRIBUTE21(i)
3860 ,p_line_rec.INDUSTRY_ATTRIBUTE22(i)
3861 ,p_line_rec.INDUSTRY_ATTRIBUTE23(i)
3862 ,p_line_rec.INDUSTRY_ATTRIBUTE24(i)
3863 ,p_line_rec.INDUSTRY_ATTRIBUTE25(i)
3864 ,p_line_rec.INDUSTRY_ATTRIBUTE26(i)
3865 ,p_line_rec.INDUSTRY_ATTRIBUTE27(i)
3866 ,p_line_rec.INDUSTRY_ATTRIBUTE28(i)
3867 ,p_line_rec.INDUSTRY_ATTRIBUTE29(i)
3868 ,p_line_rec.INDUSTRY_ATTRIBUTE30(i)
3869 ,p_line_rec.INDUSTRY_ATTRIBUTE2(i)
3870 ,p_line_rec.INDUSTRY_ATTRIBUTE3(i)
3871 ,p_line_rec.INDUSTRY_ATTRIBUTE4(i)
3872 ,p_line_rec.INDUSTRY_ATTRIBUTE5(i)
3873 ,p_line_rec.INDUSTRY_ATTRIBUTE6(i)
3874 ,p_line_rec.INDUSTRY_ATTRIBUTE7(i)
3875 ,p_line_rec.INDUSTRY_ATTRIBUTE8(i)
3876 ,p_line_rec.INDUSTRY_ATTRIBUTE9(i)
3877 ,p_line_rec.INDUSTRY_CONTEXT(i)
3878 --,p_line_rec.INTERMED_SHIP_TO_CONTACT_ID(i)
3879 --,p_line_rec.INTERMED_SHIP_TO_ORG_ID(i)
3880 ,p_line_rec.INVENTORY_ITEM_ID(i)
3881 --,p_line_rec.INVOICE_INTERFACE_STATUS_CODE(i)
3882 ,p_line_rec.INVOICE_TO_CONTACT_ID(i)
3883 ,p_line_rec.INVOICE_TO_ORG_ID(i)
3884 --,p_line_rec.INVOICED_QUANTITY(i)
3885 ,p_line_rec.INVOICING_RULE_ID(i)
3886 ,p_line_rec.ORDERED_ITEM_ID(i)
3887 ,p_line_rec.ITEM_IDENTIFIER_TYPE(i)
3888 ,p_line_rec.ORDERED_ITEM(i)
3889 ,p_line_rec.CUSTOMER_ITEM_NET_PRICE(i)
3890 ,p_line_rec.ITEM_REVISION(i)
3891 ,p_line_rec.ITEM_TYPE_CODE(i)
3892 --,p_line_rec.LAST_ACK_CODE(i)
3893 --,p_line_rec.LAST_ACK_DATE(i)
3894 ,FND_GLOBAL.USER_ID -- p_line_rec.LAST_UPDATED_BY(i)
3895 ,sysdate -- p_line_rec.LAST_UPDATE_DATE(i)
3896 --,p_line_rec.LAST_UPDATE_LOGIN(i)
3897 ,p_line_rec.LATEST_ACCEPTABLE_DATE(i)
3898 ,p_line_rec.LINE_CATEGORY_CODE(i)
3899 ,p_line_rec.LINE_ID(i)
3900 ,p_line_rec.LINE_NUMBER(i)
3901 ,p_line_rec.LINE_TYPE_ID(i)
3902 ,p_line_rec.LINK_TO_LINE_ID(i)
3903 ,p_line_rec.MODEL_GROUP_NUMBER(i)
3904 ,p_line_rec.MFG_LEAD_TIME(i)
3905 ,'Y' -- p_line_rec.OPEN_FLAG(i)
3906 ,p_line_rec.OPTION_FLAG(i)
3907 ,p_line_rec.OPTION_NUMBER(i)
3908 ,p_line_rec.ORDERED_QUANTITY(i)
3909 ,p_line_rec.ORDERED_QUANTITY2(i) --OPM 02/JUN/00
3910 ,p_line_rec.ORDER_QUANTITY_UOM(i)
3911 ,p_line_rec.ORDERED_QUANTITY_UOM2(i) --OPM 02/JUN/00
3912 ,p_line_rec.ORG_ID(i) --moac
3913 ,p_line_rec.ORIG_SYS_DOCUMENT_REF(i)
3914 ,p_line_rec.ORIG_SYS_LINE_REF(i)
3915 ,p_line_rec.ORIG_SYS_SHIPMENT_REF(i)
3916 ,p_line_rec.CHANGE_SEQUENCE(i)
3917 ,p_line_rec.OVER_SHIP_REASON_CODE(i)
3918 ,p_line_rec.OVER_SHIP_RESOLVED_FLAG(i)
3919 ,p_line_rec.PAYMENT_TERM_ID(i)
3920 --,p_line_rec.PLANNING_PRIORITY(i)
3921 ,p_line_rec.PREFERRED_GRADE(i) --OPM HVOP
3922 ,p_line_rec.PRICE_LIST_ID(i)
3923 --,p_line_rec.PRICE_REQUEST_CODE(i) --PROMOTIONS MAY/01
3924 ,p_line_rec.PRICING_ATTRIBUTE1(i)
3925 ,p_line_rec.PRICING_ATTRIBUTE10(i)
3926 ,p_line_rec.PRICING_ATTRIBUTE2(i)
3927 ,p_line_rec.PRICING_ATTRIBUTE3(i)
3928 ,p_line_rec.PRICING_ATTRIBUTE4(i)
3929 ,p_line_rec.PRICING_ATTRIBUTE5(i)
3930 ,p_line_rec.PRICING_ATTRIBUTE6(i)
3931 ,p_line_rec.PRICING_ATTRIBUTE7(i)
3932 ,p_line_rec.PRICING_ATTRIBUTE8(i)
3933 ,p_line_rec.PRICING_ATTRIBUTE9(i)
3934 ,p_line_rec.PRICING_CONTEXT(i)
3935 ,p_line_rec.PRICING_DATE(i)
3936 ,p_line_rec.PRICING_QUANTITY(i)
3937 ,p_line_rec.PRICING_QUANTITY_UOM(i)
3938 --,p_line_rec.PROGRAM_APPLICATION_ID(i)
3939 --,p_line_rec.PROGRAM_ID(i)
3940 --,p_line_rec.PROGRAM_UPDATE_DATE(i)
3941 ,p_line_rec.PROJECT_ID(i)
3942 ,p_line_rec.PROMISE_DATE(i)
3943 ,p_line_rec.RE_SOURCE_FLAG(i)
3944 --,p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID(i)
3945 ,p_line_rec.REFERENCE_HEADER_ID(i)
3946 ,p_line_rec.REFERENCE_LINE_ID(i)
3947 ,p_line_rec.REFERENCE_TYPE(i)
3948 ,p_line_rec.REQUEST_DATE(i)
3949 ,OE_BULK_ORDER_PVT.G_REQUEST_ID
3950 ,p_line_rec.RETURN_ATTRIBUTE1(i)
3951 ,p_line_rec.RETURN_ATTRIBUTE10(i)
3952 ,p_line_rec.RETURN_ATTRIBUTE11(i)
3953 ,p_line_rec.RETURN_ATTRIBUTE12(i)
3954 ,p_line_rec.RETURN_ATTRIBUTE13(i)
3955 ,p_line_rec.RETURN_ATTRIBUTE14(i)
3956 ,p_line_rec.RETURN_ATTRIBUTE15(i)
3957 ,p_line_rec.RETURN_ATTRIBUTE2(i)
3958 ,p_line_rec.RETURN_ATTRIBUTE3(i)
3959 ,p_line_rec.RETURN_ATTRIBUTE4(i)
3960 ,p_line_rec.RETURN_ATTRIBUTE5(i)
3961 ,p_line_rec.RETURN_ATTRIBUTE6(i)
3962 ,p_line_rec.RETURN_ATTRIBUTE7(i)
3963 ,p_line_rec.RETURN_ATTRIBUTE8(i)
3964 ,p_line_rec.RETURN_ATTRIBUTE9(i)
3965 ,p_line_rec.RETURN_CONTEXT(i)
3966 ,p_line_rec.RETURN_REASON_CODE(i)
3967 --,p_line_rec.RLA_SCHEDULE_TYPE_CODE(i)
3968 ,p_line_rec.SALESREP_ID(i)
3969 ,p_line_rec.SCHEDULE_ARRIVAL_DATE(i)
3970 ,p_line_rec.SCHEDULE_SHIP_DATE(i)
3971 ,p_line_rec.SCHEDULE_STATUS_CODE(i)
3972 ,1 -- p_line_rec.SHIPMENT_NUMBER(i)
3973 ,p_line_rec.SHIPMENT_PRIORITY_CODE(i)
3974 ,p_line_rec.SHIPPED_QUANTITY(i)
3975 ,p_line_rec.SHIPPED_QUANTITY2(i) -- OPM B1661023 04/02/01
3976 ,p_line_rec.SHIPPING_METHOD_CODE(i)
3977 ,p_line_rec.SHIPPING_QUANTITY(i)
3978 ,p_line_rec.SHIPPING_QUANTITY2(i) -- OPM B1661023 04/02/01
3979 ,p_line_rec.SHIPPING_QUANTITY_UOM(i)
3980 ,p_line_rec.SHIP_FROM_ORG_ID(i)
3981 ,p_line_rec.SUBINVENTORY(i)
3982 ,p_line_rec.SHIP_SET_ID(i)
3983 ,p_line_rec.SHIP_TOLERANCE_ABOVE(i)
3984 ,p_line_rec.SHIP_TOLERANCE_BELOW(i)
3985 ,p_line_rec.SHIPPABLE_FLAG(i)
3986 ,'N' -- p_line_rec.SHIPPING_INTERFACED_FLAG(i)
3987 ,p_line_rec.SHIP_TO_CONTACT_ID(i)
3988 ,p_line_rec.SHIP_TO_ORG_ID(i)
3989 ,p_line_rec.SHIP_MODEL_COMPLETE_FLAG(i)
3990 ,p_line_rec.SOLD_TO_ORG_ID(i)
3991 ,OE_GLOBALS.G_ORG_ID
3992 ,p_line_rec.SORT_ORDER(i)
3993 ,p_line_rec.SOURCE_DOCUMENT_ID(i)
3994 --,p_line_rec.SOURCE_DOCUMENT_LINE_ID (i)
3995 --,p_line_rec.SOURCE_DOCUMENT_TYPE_ID(i)
3996 ,p_line_rec.SOURCE_TYPE_CODE(i)
3997 ,p_line_rec.SPLIT_FROM_LINE_ID(i)
3998 --,p_line_rec.LINE_SET_ID(i)
3999 --,p_line_rec.SPLIT_BY(i)
4000 ,p_line_rec.MODEL_REMNANT_FLAG(i)
4001 ,p_line_rec.TASK_ID(i)
4002 ,p_line_rec.TAX_CODE(i)
4003 ,p_line_rec.TAX_DATE(i)
4004 ,p_line_rec.TAX_EXEMPT_FLAG(i)
4005 ,p_line_rec.TAX_EXEMPT_NUMBER(i)
4006 ,p_line_rec.TAX_EXEMPT_REASON_CODE(i)
4007 ,p_line_rec.TAX_POINT_CODE(i)
4008 --,p_line_rec.TAX_RATE(i)
4009 ,p_line_rec.TAX_VALUE(i)
4010 ,p_line_rec.TOP_MODEL_LINE_ID(i)
4011 ,p_line_rec.UNIT_LIST_PRICE(i)
4012 ,p_line_rec.UNIT_LIST_PRICE_PER_PQTY(i)
4013 ,p_line_rec.UNIT_SELLING_PRICE(i)
4014 ,p_line_rec.UNIT_SELLING_PRICE_PER_PQTY(i)
4015 ,p_line_rec.VISIBLE_DEMAND_FLAG(i)
4016 ,p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID(i)
4017 ,p_line_rec.SHIPPING_INSTRUCTIONS(i)
4018 ,p_line_rec.PACKING_INSTRUCTIONS(i)
4019 ,p_line_rec.SERVICE_TXN_REASON_CODE(i)
4020 ,p_line_rec.SERVICE_TXN_COMMENTS(i)
4021 ,p_line_rec.SERVICE_DURATION(i)
4022 ,p_line_rec.SERVICE_PERIOD(i)
4023 ,p_line_rec.SERVICE_START_DATE(i)
4024 ,p_line_rec.SERVICE_END_DATE(i)
4025 ,p_line_rec.SERVICE_COTERMINATE_FLAG(i)
4026 ,p_line_rec.UNIT_LIST_PERCENT(i)
4027 ,p_line_rec.UNIT_SELLING_PERCENT(i)
4028 ,p_line_rec.UNIT_PERCENT_BASE_PRICE(i)
4029 ,p_line_rec.SERVICE_NUMBER(i)
4030 ,p_line_rec.SERVICE_REFERENCE_TYPE_CODE(i)
4031 --,p_line_rec.SERVICE_REFERENCE_LINE_ID(i)
4032 --,p_line_rec.SERVICE_REFERENCE_SYSTEM_ID(i)
4033 ,p_line_rec.TP_CONTEXT(i)
4034 ,p_line_rec.TP_ATTRIBUTE1(i)
4035 ,p_line_rec.TP_ATTRIBUTE2(i)
4036 ,p_line_rec.TP_ATTRIBUTE3(i)
4037 ,p_line_rec.TP_ATTRIBUTE4(i)
4038 ,p_line_rec.TP_ATTRIBUTE5(i)
4039 ,p_line_rec.TP_ATTRIBUTE6(i)
4040 ,p_line_rec.TP_ATTRIBUTE7(i)
4041 ,p_line_rec.TP_ATTRIBUTE8(i)
4042 ,p_line_rec.TP_ATTRIBUTE9(i)
4043 ,p_line_rec.TP_ATTRIBUTE10(i)
4044 ,p_line_rec.TP_ATTRIBUTE11(i)
4045 ,p_line_rec.TP_ATTRIBUTE12(i)
4046 ,p_line_rec.TP_ATTRIBUTE13(i)
4047 ,p_line_rec.TP_ATTRIBUTE14(i)
4048 ,p_line_rec.TP_ATTRIBUTE15(i)
4049 ,decode(p_line_rec.booked_flag(i)
4050 ,'Y','BOOKED','ENTERED') --,p_line_rec.FLOW_STATUS_CODE(i)
4051 --,p_line_rec.MARKETING_SOURCE_CODE_ID(i)
4052 ,p_line_rec.CALCULATE_PRICE_FLAG(i)
4053 ,p_line_rec.COMMITMENT_ID(i)
4054 ,p_line_rec.ORDER_SOURCE_ID(i)
4055 --,p_line_rec.upgraded_flag(i)
4056 ,p_line_rec.user_item_description(i)
4057 ,p_line_rec.LOCK_CONTROL(i)
4058 ,p_line_rec.FIRM_DEMAND_FLAG(i)
4059 -- QUOTING change
4060 -- Negotiation orders not supported with HVOP
4061 -- insert fulfillment (F) for transaction phase
4062 ,'F'
4063 -- end customer (Bug 5054618)
4064 ,p_line_rec.End_customer_contact_id(i)
4065 ,p_line_rec.End_customer_id(i)
4066 ,p_line_rec.End_customer_site_use_id(i)
4067 ,p_line_rec.IB_owner(i)
4068 ,p_line_rec.IB_current_location(i)
4069 ,p_line_rec.IB_Installed_at_Location(i)
4070 );
4071
4072 EXCEPTION
4073 WHEN OTHERS THEN
4074 IF l_debug_level > 0 THEN
4075 oe_debug_pub.add( 'OTHERS ERROR , INSERT_LINES' ) ;
4076 oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4077 END IF;
4078 OE_BULK_MSG_PUB.Add_Exc_Msg
4079 ( G_PKG_NAME
4080 , 'Insert_Lines'
4081 );
4082 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4083 END Insert_Lines;
4084
4085
4086 PROCEDURE Extend_Line_Rec
4087 (p_count IN NUMBER
4088 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4089 )
4090 IS
4091 --
4092 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4093 --
4094 BEGIN
4095
4096 p_line_rec.ACCOUNTING_RULE_ID.extend(p_count);
4097 p_line_rec.ACCOUNTING_RULE_DURATION.extend(p_count);
4098 p_line_rec.ACTUAL_ARRIVAL_DATE.extend(p_count);
4099 --p_line_rec.ACTUAL_SHIPMENT_DATE.extend(p_count);
4100 p_line_rec.AGREEMENT_ID.extend(p_count);
4101 p_line_rec.ARRIVAL_SET_ID.extend(p_count);
4102 p_line_rec.ATO_LINE_ID.extend(p_count);
4103 p_line_rec.ATTRIBUTE1.extend(p_count);
4104 p_line_rec.ATTRIBUTE10.extend(p_count);
4105 p_line_rec.ATTRIBUTE11.extend(p_count);
4106 p_line_rec.ATTRIBUTE12.extend(p_count);
4107 p_line_rec.ATTRIBUTE13.extend(p_count);
4108 p_line_rec.ATTRIBUTE14.extend(p_count);
4109 p_line_rec.ATTRIBUTE15.extend(p_count);
4110 p_line_rec.ATTRIBUTE16.extend(p_count); --For bug 2184255
4111 p_line_rec.ATTRIBUTE17.extend(p_count);
4112 p_line_rec.ATTRIBUTE18.extend(p_count);
4113 p_line_rec.ATTRIBUTE19.extend(p_count);
4114 p_line_rec.ATTRIBUTE2.extend(p_count);
4115 p_line_rec.ATTRIBUTE20.extend(p_count);
4116 p_line_rec.ATTRIBUTE3.extend(p_count);
4117 p_line_rec.ATTRIBUTE4.extend(p_count);
4118 p_line_rec.ATTRIBUTE5.extend(p_count);
4119 p_line_rec.ATTRIBUTE6.extend(p_count);
4120 p_line_rec.ATTRIBUTE7.extend(p_count);
4121 p_line_rec.ATTRIBUTE8.extend(p_count);
4122 p_line_rec.ATTRIBUTE9.extend(p_count);
4123 --p_line_rec.AUTO_SELECTED_QUANTITY.extend(p_count);
4124 p_line_rec.AUTHORIZED_TO_SHIP_FLAG.extend(p_count);
4125 p_line_rec.BOOKED_FLAG .extend(p_count);
4126 p_line_rec.CANCELLED_FLAG.extend(p_count);
4127 p_line_rec.CANCELLED_QUANTITY.extend(p_count);
4128 p_line_rec.COMPONENT_CODE.extend(p_count);
4129 p_line_rec.COMPONENT_NUMBER.extend(p_count);
4130 p_line_rec.COMPONENT_SEQUENCE_ID.extend(p_count);
4131 p_line_rec.CONFIG_HEADER_ID.extend(p_count);
4132 p_line_rec.CONFIG_REV_NBR.extend(p_count);
4133 p_line_rec.CONFIG_DISPLAY_SEQUENCE.extend(p_count);
4134 p_line_rec.CONFIGURATION_ID.extend(p_count);
4135 p_line_rec.CONTEXT.extend(p_count);
4136 --p_line_rec.CREATED_BY.extend(p_count);
4137 --p_line_rec.CREATION_DATE.extend(p_count);
4138 p_line_rec.CREDIT_INVOICE_LINE_ID.extend(p_count);
4139 p_line_rec.CUSTOMER_DOCK_CODE.extend(p_count);
4140 p_line_rec.CUSTOMER_JOB.extend(p_count);
4141 p_line_rec.CUSTOMER_PRODUCTION_LINE.extend(p_count);
4142 p_line_rec.CUST_PRODUCTION_SEQ_NUM.extend(p_count);
4143 --p_line_rec.CUSTOMER_TRX_LINE_ID.extend(p_count);
4144 p_line_rec.CUST_MODEL_SERIAL_NUMBER.extend(p_count);
4145 p_line_rec.CUST_PO_NUMBER.extend(p_count);
4146 p_line_rec.CUSTOMER_LINE_NUMBER.extend(p_count);
4147 p_line_rec.DELIVERY_LEAD_TIME.extend(p_count);
4148 p_line_rec.DELIVER_TO_CONTACT_ID.extend(p_count);
4149 p_line_rec.DELIVER_TO_ORG_ID.extend(p_count);
4150 p_line_rec.DEMAND_BUCKET_TYPE_CODE.extend(p_count);
4151 p_line_rec.DEMAND_CLASS_CODE.extend(p_count);
4152 --p_line_rec.DEP_PLAN_REQUIRED_FLAG.extend(p_count);
4153 p_line_rec.EARLIEST_ACCEPTABLE_DATE.extend(p_count);
4154 p_line_rec.END_ITEM_UNIT_NUMBER.extend(p_count);
4155 p_line_rec.EXPLOSION_DATE.extend(p_count);
4156 --p_line_rec.FIRST_ACK_CODE.extend(p_count);
4157 --p_line_rec.FIRST_ACK_DATE.extend(p_count);
4158 p_line_rec.FOB_POINT_CODE.extend(p_count);
4159 p_line_rec.FREIGHT_CARRIER_CODE.extend(p_count);
4160 p_line_rec.FREIGHT_TERMS_CODE.extend(p_count);
4161 --p_line_rec.FULFILLED_QUANTITY.extend(p_count);
4162 --p_line_rec.FULFILLED_FLAG.extend(p_count);
4163 --p_line_rec.FULFILLMENT_METHOD_CODE.extend(p_count);
4164 --p_line_rec.FULFILLMENT_DATE.extend(p_count);
4165 p_line_rec.GLOBAL_ATTRIBUTE1.extend(p_count);
4166 p_line_rec.GLOBAL_ATTRIBUTE10.extend(p_count);
4167 p_line_rec.GLOBAL_ATTRIBUTE11.extend(p_count);
4168 p_line_rec.GLOBAL_ATTRIBUTE12.extend(p_count);
4169 p_line_rec.GLOBAL_ATTRIBUTE13.extend(p_count);
4170 p_line_rec.GLOBAL_ATTRIBUTE14.extend(p_count);
4171 p_line_rec.GLOBAL_ATTRIBUTE15.extend(p_count);
4172 p_line_rec.GLOBAL_ATTRIBUTE16.extend(p_count);
4173 p_line_rec.GLOBAL_ATTRIBUTE17.extend(p_count);
4174 p_line_rec.GLOBAL_ATTRIBUTE18.extend(p_count);
4175 p_line_rec.GLOBAL_ATTRIBUTE19.extend(p_count);
4176 p_line_rec.GLOBAL_ATTRIBUTE2.extend(p_count);
4177 p_line_rec.GLOBAL_ATTRIBUTE20.extend(p_count);
4178 p_line_rec.GLOBAL_ATTRIBUTE3.extend(p_count);
4179 p_line_rec.GLOBAL_ATTRIBUTE4.extend(p_count);
4180 p_line_rec.GLOBAL_ATTRIBUTE5.extend(p_count);
4181 p_line_rec.GLOBAL_ATTRIBUTE6.extend(p_count);
4182 p_line_rec.GLOBAL_ATTRIBUTE7.extend(p_count);
4183 p_line_rec.GLOBAL_ATTRIBUTE8.extend(p_count);
4184 p_line_rec.GLOBAL_ATTRIBUTE9.extend(p_count);
4185 p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY.extend(p_count);
4186 p_line_rec.HEADER_ID.extend(p_count);
4187 p_line_rec.INDUSTRY_ATTRIBUTE1.extend(p_count);
4188 p_line_rec.INDUSTRY_ATTRIBUTE10.extend(p_count);
4189 p_line_rec.INDUSTRY_ATTRIBUTE11.extend(p_count);
4190 p_line_rec.INDUSTRY_ATTRIBUTE12.extend(p_count);
4191 p_line_rec.INDUSTRY_ATTRIBUTE13.extend(p_count);
4192 p_line_rec.INDUSTRY_ATTRIBUTE14.extend(p_count);
4193 p_line_rec.INDUSTRY_ATTRIBUTE15.extend(p_count);
4194 p_line_rec.INDUSTRY_ATTRIBUTE16.extend(p_count);
4195 p_line_rec.INDUSTRY_ATTRIBUTE17.extend(p_count);
4196 p_line_rec.INDUSTRY_ATTRIBUTE18.extend(p_count);
4197 p_line_rec.INDUSTRY_ATTRIBUTE19.extend(p_count);
4198 p_line_rec.INDUSTRY_ATTRIBUTE20.extend(p_count);
4199 p_line_rec.INDUSTRY_ATTRIBUTE21.extend(p_count);
4200 p_line_rec.INDUSTRY_ATTRIBUTE22.extend(p_count);
4201 p_line_rec.INDUSTRY_ATTRIBUTE23.extend(p_count);
4202 p_line_rec.INDUSTRY_ATTRIBUTE24.extend(p_count);
4203 p_line_rec.INDUSTRY_ATTRIBUTE25.extend(p_count);
4204 p_line_rec.INDUSTRY_ATTRIBUTE26.extend(p_count);
4205 p_line_rec.INDUSTRY_ATTRIBUTE27.extend(p_count);
4206 p_line_rec.INDUSTRY_ATTRIBUTE28.extend(p_count);
4207 p_line_rec.INDUSTRY_ATTRIBUTE29.extend(p_count);
4208 p_line_rec.INDUSTRY_ATTRIBUTE30.extend(p_count);
4209 p_line_rec.INDUSTRY_ATTRIBUTE2.extend(p_count);
4210 p_line_rec.INDUSTRY_ATTRIBUTE3.extend(p_count);
4211 p_line_rec.INDUSTRY_ATTRIBUTE4.extend(p_count);
4212 p_line_rec.INDUSTRY_ATTRIBUTE5.extend(p_count);
4213 p_line_rec.INDUSTRY_ATTRIBUTE6.extend(p_count);
4214 p_line_rec.INDUSTRY_ATTRIBUTE7.extend(p_count);
4215 p_line_rec.INDUSTRY_ATTRIBUTE8.extend(p_count);
4216 p_line_rec.INDUSTRY_ATTRIBUTE9.extend(p_count);
4217 p_line_rec.INDUSTRY_CONTEXT.extend(p_count);
4218 --p_line_rec.INTERMED_SHIP_TO_CONTACT_ID.extend(p_count);
4219 --p_line_rec.INTERMED_SHIP_TO_ORG_ID.extend(p_count);
4220 p_line_rec.INVENTORY_ITEM_ID.extend(p_count);
4221 --p_line_rec.INVOICE_INTERFACE_STATUS_CODE.extend(p_count);
4222 p_line_rec.INVOICE_TO_CONTACT_ID.extend(p_count);
4223 p_line_rec.INVOICE_TO_ORG_ID.extend(p_count);
4224 --p_line_rec.INVOICED_QUANTITY.extend(p_count);
4225 p_line_rec.INVOICING_RULE_ID.extend(p_count);
4226 p_line_rec.ORDERED_ITEM_ID.extend(p_count);
4227 p_line_rec.ITEM_IDENTIFIER_TYPE.extend(p_count);
4228 p_line_rec.ORDERED_ITEM.extend(p_count);
4229 p_line_rec.CUSTOMER_ITEM_NET_PRICE.extend(p_count);
4230 p_line_rec.ITEM_REVISION.extend(p_count);
4231 p_line_rec.ITEM_TYPE_CODE.extend(p_count);
4232 --p_line_rec.LAST_ACK_CODE.extend(p_count);
4233 --p_line_rec.LAST_ACK_DATE.extend(p_count);
4234 --p_line_rec.LAST_UPDATED_BY.extend(p_count);
4235 --p_line_rec.LAST_UPDATE_DATE.extend(p_count);
4236 --p_line_rec.LAST_UPDATE_LOGIN.extend(p_count);
4237 p_line_rec.LATEST_ACCEPTABLE_DATE.extend(p_count);
4238 p_line_rec.LINE_CATEGORY_CODE.extend(p_count);
4239 p_line_rec.LINE_ID.extend(p_count);
4240 p_line_rec.LINE_NUMBER.extend(p_count);
4241 p_line_rec.LINE_TYPE_ID.extend(p_count);
4242 p_line_rec.LINK_TO_LINE_ID.extend(p_count);
4243 p_line_rec.MODEL_GROUP_NUMBER.extend(p_count);
4244 p_line_rec.MFG_LEAD_TIME.extend(p_count);
4245 --p_line_rec.OPEN_FLAG.extend(p_count);
4246 p_line_rec.OPTION_FLAG.extend(p_count);
4247 p_line_rec.OPTION_NUMBER.extend(p_count);
4248 p_line_rec.ORDERED_QUANTITY.extend(p_count);
4249 p_line_rec.ORDERED_QUANTITY2.extend(p_count);
4250 p_line_rec.ORDER_QUANTITY_UOM.extend(p_count);
4251 p_line_rec.ORDERED_QUANTITY_UOM2.extend(p_count);
4252 p_line_rec.ORG_ID.extend(p_count);
4253 p_line_rec.ORIG_SYS_DOCUMENT_REF.extend(p_count);
4254 p_line_rec.ORIG_SYS_LINE_REF.extend(p_count);
4255 p_line_rec.ORIG_SYS_SHIPMENT_REF.extend(p_count);
4256 p_line_rec.CHANGE_SEQUENCE.extend(p_count);
4257 p_line_rec.OVER_SHIP_REASON_CODE.extend(p_count);
4258 p_line_rec.OVER_SHIP_RESOLVED_FLAG.extend(p_count);
4259 p_line_rec.PAYMENT_TERM_ID.extend(p_count);
4260 --p_line_rec.PLANNING_PRIORITY.extend(p_count);
4261 p_line_rec.PREFERRED_GRADE.extend(p_count); -- OPM HVOP
4262 p_line_rec.PRICE_LIST_ID.extend(p_count);
4263 --p_line_rec.PRICE_REQUEST_CODE --PROMOTIONS MAY/01.extend(p_count);
4264 p_line_rec.PRICING_ATTRIBUTE1.extend(p_count);
4265 p_line_rec.PRICING_ATTRIBUTE10.extend(p_count);
4266 p_line_rec.PRICING_ATTRIBUTE2.extend(p_count);
4267 p_line_rec.PRICING_ATTRIBUTE3.extend(p_count);
4268 p_line_rec.PRICING_ATTRIBUTE4.extend(p_count);
4269 p_line_rec.PRICING_ATTRIBUTE5.extend(p_count);
4270 p_line_rec.PRICING_ATTRIBUTE6.extend(p_count);
4271 p_line_rec.PRICING_ATTRIBUTE7.extend(p_count);
4272 p_line_rec.PRICING_ATTRIBUTE8.extend(p_count);
4273 p_line_rec.PRICING_ATTRIBUTE9.extend(p_count);
4274 p_line_rec.PRICING_CONTEXT.extend(p_count);
4275 p_line_rec.PRICING_DATE.extend(p_count);
4276 p_line_rec.PRICING_QUANTITY.extend(p_count);
4277 p_line_rec.PRICING_QUANTITY_UOM.extend(p_count);
4278 --p_line_rec.PROGRAM_APPLICATION_ID.extend(p_count);
4279 --p_line_rec.PROGRAM_ID.extend(p_count);
4280 --p_line_rec.PROGRAM_UPDATE_DATE.extend(p_count);
4281 p_line_rec.PROJECT_ID.extend(p_count);
4282 p_line_rec.PROMISE_DATE.extend(p_count);
4283 p_line_rec.RE_SOURCE_FLAG.extend(p_count);
4284 --p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID.extend(p_count);
4285 p_line_rec.REFERENCE_HEADER_ID.extend(p_count);
4286 p_line_rec.REFERENCE_LINE_ID.extend(p_count);
4287 p_line_rec.REFERENCE_TYPE.extend(p_count);
4288 p_line_rec.REQUEST_DATE.extend(p_count);
4289 p_line_rec.REQUEST_ID.extend(p_count);
4290 p_line_rec.RETURN_ATTRIBUTE1.extend(p_count);
4291 p_line_rec.RETURN_ATTRIBUTE10.extend(p_count);
4292 p_line_rec.RETURN_ATTRIBUTE11.extend(p_count);
4293 p_line_rec.RETURN_ATTRIBUTE12.extend(p_count);
4294 p_line_rec.RETURN_ATTRIBUTE13.extend(p_count);
4295 p_line_rec.RETURN_ATTRIBUTE14.extend(p_count);
4296 p_line_rec.RETURN_ATTRIBUTE15.extend(p_count);
4297 p_line_rec.RETURN_ATTRIBUTE2.extend(p_count);
4298 p_line_rec.RETURN_ATTRIBUTE3.extend(p_count);
4299 p_line_rec.RETURN_ATTRIBUTE4.extend(p_count);
4300 p_line_rec.RETURN_ATTRIBUTE5.extend(p_count);
4301 p_line_rec.RETURN_ATTRIBUTE6.extend(p_count);
4302 p_line_rec.RETURN_ATTRIBUTE7.extend(p_count);
4303 p_line_rec.RETURN_ATTRIBUTE8.extend(p_count);
4304 p_line_rec.RETURN_ATTRIBUTE9.extend(p_count);
4305 p_line_rec.RETURN_CONTEXT.extend(p_count);
4306 p_line_rec.RETURN_REASON_CODE.extend(p_count);
4307 --p_line_rec.RLA_SCHEDULE_TYPE_CODE.extend(p_count);
4308 p_line_rec.SALESREP_ID.extend(p_count);
4309 p_line_rec.SCHEDULE_ARRIVAL_DATE.extend(p_count);
4310 p_line_rec.SCHEDULE_SHIP_DATE.extend(p_count);
4311 p_line_rec.SCHEDULE_STATUS_CODE.extend(p_count);
4312 p_line_rec.SHIPMENT_NUMBER.extend(p_count);
4313 p_line_rec.SHIPMENT_PRIORITY_CODE.extend(p_count);
4314 p_line_rec.SHIPPED_QUANTITY.extend(p_count);
4315 p_line_rec.SHIPPED_QUANTITY2.extend(p_count);
4316 p_line_rec.SHIPPING_METHOD_CODE.extend(p_count);
4317 p_line_rec.SHIPPING_QUANTITY.extend(p_count);
4318 p_line_rec.SHIPPING_QUANTITY2.extend(p_count);
4319 p_line_rec.SHIPPING_QUANTITY_UOM.extend(p_count);
4320 p_line_rec.SHIP_FROM_ORG_ID.extend(p_count);
4321 p_line_rec.SUBINVENTORY.extend(p_count);
4322 p_line_rec.SHIP_SET_ID.extend(p_count);
4323 p_line_rec.SHIP_TOLERANCE_ABOVE.extend(p_count);
4324 p_line_rec.SHIP_TOLERANCE_BELOW.extend(p_count);
4325 p_line_rec.SHIPPABLE_FLAG.extend(p_count);
4326 --p_line_rec.SHIPPING_INTERFACED_FLAG.extend(p_count);
4327 p_line_rec.SHIP_TO_CONTACT_ID.extend(p_count);
4328 p_line_rec.SHIP_TO_ORG_ID.extend(p_count);
4329 p_line_rec.SHIP_MODEL_COMPLETE_FLAG.extend(p_count);
4330 p_line_rec.SOLD_TO_ORG_ID.extend(p_count);
4331 p_line_rec.SOLD_FROM_ORG_ID.extend(p_count);
4332 p_line_rec.SORT_ORDER.extend(p_count);
4333 p_line_rec.SOURCE_DOCUMENT_ID.extend(p_count);
4334 --p_line_rec.SOURCE_DOCUMENT_LINE_ID .extend(p_count);
4335 --p_line_rec.SOURCE_DOCUMENT_TYPE_ID.extend(p_count);
4336 p_line_rec.SOURCE_TYPE_CODE.extend(p_count);
4337 p_line_rec.SPLIT_FROM_LINE_ID.extend(p_count);
4338 --p_line_rec.LINE_SET_ID.extend(p_count);
4339 --p_line_rec.SPLIT_BY.extend(p_count);
4340 p_line_rec.MODEL_REMNANT_FLAG.extend(p_count);
4341 p_line_rec.TASK_ID.extend(p_count);
4342 p_line_rec.TAX_CODE.extend(p_count);
4343 p_line_rec.TAX_DATE.extend(p_count);
4344 p_line_rec.TAX_EXEMPT_FLAG.extend(p_count);
4345 p_line_rec.TAX_EXEMPT_NUMBER.extend(p_count);
4346 p_line_rec.TAX_EXEMPT_REASON_CODE.extend(p_count);
4347 p_line_rec.TAX_POINT_CODE.extend(p_count);
4348 --p_line_rec.TAX_RATE.extend(p_count);
4349 p_line_rec.TAX_VALUE.extend(p_count);
4350 p_line_rec.TOP_MODEL_LINE_ID.extend(p_count);
4351 p_line_rec.UNIT_LIST_PRICE.extend(p_count);
4352 p_line_rec.UNIT_LIST_PRICE_PER_PQTY.extend(p_count);
4353 p_line_rec.UNIT_SELLING_PRICE.extend(p_count);
4354 p_line_rec.UNIT_SELLING_PRICE_PER_PQTY.extend(p_count);
4355 p_line_rec.VISIBLE_DEMAND_FLAG.extend(p_count);
4356 p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID.extend(p_count);
4357 p_line_rec.SHIPPING_INSTRUCTIONS.extend(p_count);
4358 p_line_rec.PACKING_INSTRUCTIONS.extend(p_count);
4359 p_line_rec.SERVICE_TXN_REASON_CODE.extend(p_count);
4360 p_line_rec.SERVICE_TXN_COMMENTS.extend(p_count);
4361 p_line_rec.SERVICE_DURATION.extend(p_count);
4362 p_line_rec.SERVICE_PERIOD.extend(p_count);
4363 p_line_rec.SERVICE_START_DATE.extend(p_count);
4364 p_line_rec.SERVICE_END_DATE.extend(p_count);
4365 p_line_rec.SERVICE_COTERMINATE_FLAG.extend(p_count);
4366 p_line_rec.UNIT_LIST_PERCENT.extend(p_count);
4367 p_line_rec.UNIT_SELLING_PERCENT.extend(p_count);
4368 p_line_rec.UNIT_PERCENT_BASE_PRICE.extend(p_count);
4369 p_line_rec.SERVICE_NUMBER.extend(p_count);
4370 p_line_rec.SERVICE_REFERENCE_TYPE_CODE.extend(p_count);
4371 --p_line_rec.SERVICE_REFERENCE_LINE_ID.extend(p_count);
4372 --p_line_rec.SERVICE_REFERENCE_SYSTEM_ID.extend(p_count);
4373 p_line_rec.TP_CONTEXT.extend(p_count);
4374 p_line_rec.TP_ATTRIBUTE1.extend(p_count);
4375 p_line_rec.TP_ATTRIBUTE2.extend(p_count);
4376 p_line_rec.TP_ATTRIBUTE3.extend(p_count);
4377 p_line_rec.TP_ATTRIBUTE4.extend(p_count);
4378 p_line_rec.TP_ATTRIBUTE5.extend(p_count);
4379 p_line_rec.TP_ATTRIBUTE6.extend(p_count);
4380 p_line_rec.TP_ATTRIBUTE7.extend(p_count);
4381 p_line_rec.TP_ATTRIBUTE8.extend(p_count);
4382 p_line_rec.TP_ATTRIBUTE9.extend(p_count);
4383 p_line_rec.TP_ATTRIBUTE10.extend(p_count);
4384 p_line_rec.TP_ATTRIBUTE11.extend(p_count);
4385 p_line_rec.TP_ATTRIBUTE12.extend(p_count);
4386 p_line_rec.TP_ATTRIBUTE13.extend(p_count);
4387 p_line_rec.TP_ATTRIBUTE14.extend(p_count);
4388 p_line_rec.TP_ATTRIBUTE15.extend(p_count);
4389 --p_line_rec.FLOW_STATUS_CODE.extend(p_count);
4390 --p_line_rec.MARKETING_SOURCE_CODE_ID.extend(p_count);
4391 p_line_rec.CALCULATE_PRICE_FLAG.extend(p_count);
4392 p_line_rec.COMMITMENT_ID.extend(p_count);
4393 p_line_rec.ORDER_SOURCE_ID.extend(p_count);
4394 --p_line_rec.upgraded_flag.extend(p_count);
4395 p_line_rec.LOCK_CONTROL.extend(p_count);
4396 p_line_rec.WF_PROCESS_NAME.extend(p_count);
4397 p_line_rec.user_item_description.extend(p_count);
4398 p_line_rec.parent_line_index.extend(p_count);
4399 p_line_rec.firm_demand_flag.extend(p_count);
4400 p_line_rec.line_index.extend(p_count);
4401 p_line_rec.header_index.extend(p_count);
4402
4403 EXCEPTION
4404 WHEN OTHERS THEN
4405 IF l_debug_level > 0 THEN
4406 oe_debug_pub.add( 'OTHERS ERROR , EXTEND_LINE_REC' ) ;
4407 oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4408 END IF;
4409 OE_BULK_MSG_PUB.Add_Exc_Msg
4410 ( G_PKG_NAME
4411 , 'Extend_Line_Rec'
4412 );
4413 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4414 END Extend_Line_Rec;
4415
4416 PROCEDURE Extend_Inc_Item_Rec
4417 (p_count IN NUMBER
4418 ,p_parent_index IN NUMBER
4419 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4420 )
4421 IS
4422 --
4423 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4424 --
4425 BEGIN
4426
4427 p_line_rec.ACCOUNTING_RULE_ID.extend(p_count,p_parent_index);
4428 p_line_rec.ACCOUNTING_RULE_DURATION.extend(p_count,p_parent_index);
4429 p_line_rec.ACTUAL_ARRIVAL_DATE.extend(p_count,p_parent_index);
4430 --p_line_rec.ACTUAL_SHIPMENT_DATE.extend(p_count,p_parent_index);
4431 p_line_rec.AGREEMENT_ID.extend(p_count,p_parent_index);
4432 p_line_rec.ARRIVAL_SET_ID.extend(p_count,p_parent_index);
4433 p_line_rec.ATO_LINE_ID.extend(p_count,p_parent_index);
4434 p_line_rec.ATTRIBUTE1.extend(p_count,p_parent_index);
4435 p_line_rec.ATTRIBUTE10.extend(p_count,p_parent_index);
4436 p_line_rec.ATTRIBUTE11.extend(p_count,p_parent_index);
4437 p_line_rec.ATTRIBUTE12.extend(p_count,p_parent_index);
4438 p_line_rec.ATTRIBUTE13.extend(p_count,p_parent_index);
4439 p_line_rec.ATTRIBUTE14.extend(p_count,p_parent_index);
4440 p_line_rec.ATTRIBUTE15.extend(p_count,p_parent_index);
4441 p_line_rec.ATTRIBUTE16.extend(p_count,p_parent_index); --For bug 2184255
4442 p_line_rec.ATTRIBUTE17.extend(p_count,p_parent_index);
4443 p_line_rec.ATTRIBUTE18.extend(p_count,p_parent_index);
4444 p_line_rec.ATTRIBUTE19.extend(p_count,p_parent_index);
4445 p_line_rec.ATTRIBUTE2.extend(p_count,p_parent_index);
4446 p_line_rec.ATTRIBUTE20.extend(p_count,p_parent_index);
4447 p_line_rec.ATTRIBUTE3.extend(p_count,p_parent_index);
4448 p_line_rec.ATTRIBUTE4.extend(p_count,p_parent_index);
4449 p_line_rec.ATTRIBUTE5.extend(p_count,p_parent_index);
4450 p_line_rec.ATTRIBUTE6.extend(p_count,p_parent_index);
4451 p_line_rec.ATTRIBUTE7.extend(p_count,p_parent_index);
4452 p_line_rec.ATTRIBUTE8.extend(p_count,p_parent_index);
4453 p_line_rec.ATTRIBUTE9.extend(p_count,p_parent_index);
4454 --p_line_rec.AUTO_SELECTED_QUANTITY.extend(p_count,p_parent_index);
4455 p_line_rec.AUTHORIZED_TO_SHIP_FLAG.extend(p_count,p_parent_index);
4456 p_line_rec.BOOKED_FLAG .extend(p_count,p_parent_index);
4457 p_line_rec.CANCELLED_FLAG.extend(p_count,p_parent_index);
4458 p_line_rec.CANCELLED_QUANTITY.extend(p_count,p_parent_index);
4459 p_line_rec.COMPONENT_CODE.extend(p_count,p_parent_index);
4460 p_line_rec.COMPONENT_NUMBER.extend(p_count,p_parent_index);
4461 p_line_rec.COMPONENT_SEQUENCE_ID.extend(p_count,p_parent_index);
4462 p_line_rec.CONFIG_HEADER_ID.extend(p_count,p_parent_index);
4463 p_line_rec.CONFIG_REV_NBR.extend(p_count,p_parent_index);
4464 p_line_rec.CONFIG_DISPLAY_SEQUENCE.extend(p_count,p_parent_index);
4465 p_line_rec.CONFIGURATION_ID.extend(p_count,p_parent_index);
4466 p_line_rec.CONTEXT.extend(p_count,p_parent_index);
4467 --p_line_rec.CREATED_BY.extend(p_count,p_parent_index);
4468 --p_line_rec.CREATION_DATE.extend(p_count,p_parent_index);
4469 p_line_rec.CREDIT_INVOICE_LINE_ID.extend(p_count,p_parent_index);
4470 p_line_rec.CUSTOMER_DOCK_CODE.extend(p_count,p_parent_index);
4471 p_line_rec.CUSTOMER_JOB.extend(p_count,p_parent_index);
4472 p_line_rec.CUSTOMER_PRODUCTION_LINE.extend(p_count,p_parent_index);
4473 p_line_rec.CUST_PRODUCTION_SEQ_NUM.extend(p_count,p_parent_index);
4474 --p_line_rec.CUSTOMER_TRX_LINE_ID.extend(p_count,p_parent_index);
4475 p_line_rec.CUST_MODEL_SERIAL_NUMBER.extend(p_count,p_parent_index);
4476 p_line_rec.CUST_PO_NUMBER.extend(p_count,p_parent_index);
4477 p_line_rec.CUSTOMER_LINE_NUMBER.extend(p_count,p_parent_index);
4478 p_line_rec.DELIVERY_LEAD_TIME.extend(p_count,p_parent_index);
4479 p_line_rec.DELIVER_TO_CONTACT_ID.extend(p_count,p_parent_index);
4480 p_line_rec.DELIVER_TO_ORG_ID.extend(p_count,p_parent_index);
4481 p_line_rec.DEMAND_BUCKET_TYPE_CODE.extend(p_count,p_parent_index);
4482 p_line_rec.DEMAND_CLASS_CODE.extend(p_count,p_parent_index);
4483 --p_line_rec.DEP_PLAN_REQUIRED_FLAG.extend(p_count,p_parent_index);
4484 p_line_rec.EARLIEST_ACCEPTABLE_DATE.extend(p_count,p_parent_index);
4485 p_line_rec.END_ITEM_UNIT_NUMBER.extend(p_count,p_parent_index);
4486 p_line_rec.EXPLOSION_DATE.extend(p_count,p_parent_index);
4487 --p_line_rec.FIRST_ACK_CODE.extend(p_count,p_parent_index);
4488 --p_line_rec.FIRST_ACK_DATE.extend(p_count,p_parent_index);
4489 p_line_rec.FOB_POINT_CODE.extend(p_count,p_parent_index);
4490 p_line_rec.FREIGHT_CARRIER_CODE.extend(p_count,p_parent_index);
4491 p_line_rec.FREIGHT_TERMS_CODE.extend(p_count,p_parent_index);
4492 --p_line_rec.FULFILLED_QUANTITY.extend(p_count,p_parent_index);
4493 --p_line_rec.FULFILLED_FLAG.extend(p_count,p_parent_index);
4494 --p_line_rec.FULFILLMENT_METHOD_CODE.extend(p_count,p_parent_index);
4495 --p_line_rec.FULFILLMENT_DATE.extend(p_count,p_parent_index);
4496 p_line_rec.GLOBAL_ATTRIBUTE1.extend(p_count,p_parent_index);
4497 p_line_rec.GLOBAL_ATTRIBUTE10.extend(p_count,p_parent_index);
4498 p_line_rec.GLOBAL_ATTRIBUTE11.extend(p_count,p_parent_index);
4499 p_line_rec.GLOBAL_ATTRIBUTE12.extend(p_count,p_parent_index);
4500 p_line_rec.GLOBAL_ATTRIBUTE13.extend(p_count,p_parent_index);
4501 p_line_rec.GLOBAL_ATTRIBUTE14.extend(p_count,p_parent_index);
4502 p_line_rec.GLOBAL_ATTRIBUTE15.extend(p_count,p_parent_index);
4503 p_line_rec.GLOBAL_ATTRIBUTE16.extend(p_count,p_parent_index);
4504 p_line_rec.GLOBAL_ATTRIBUTE17.extend(p_count,p_parent_index);
4505 p_line_rec.GLOBAL_ATTRIBUTE18.extend(p_count,p_parent_index);
4506 p_line_rec.GLOBAL_ATTRIBUTE19.extend(p_count,p_parent_index);
4507 p_line_rec.GLOBAL_ATTRIBUTE2.extend(p_count,p_parent_index);
4508 p_line_rec.GLOBAL_ATTRIBUTE20.extend(p_count,p_parent_index);
4509 p_line_rec.GLOBAL_ATTRIBUTE3.extend(p_count,p_parent_index);
4510 p_line_rec.GLOBAL_ATTRIBUTE4.extend(p_count,p_parent_index);
4511 p_line_rec.GLOBAL_ATTRIBUTE5.extend(p_count,p_parent_index);
4512 p_line_rec.GLOBAL_ATTRIBUTE6.extend(p_count,p_parent_index);
4513 p_line_rec.GLOBAL_ATTRIBUTE7.extend(p_count,p_parent_index);
4514 p_line_rec.GLOBAL_ATTRIBUTE8.extend(p_count,p_parent_index);
4515 p_line_rec.GLOBAL_ATTRIBUTE9.extend(p_count,p_parent_index);
4516 p_line_rec.GLOBAL_ATTRIBUTE_CATEGORY.extend(p_count,p_parent_index);
4517 p_line_rec.HEADER_ID.extend(p_count,p_parent_index);
4518 p_line_rec.INDUSTRY_ATTRIBUTE1.extend(p_count,p_parent_index);
4519 p_line_rec.INDUSTRY_ATTRIBUTE10.extend(p_count,p_parent_index);
4520 p_line_rec.INDUSTRY_ATTRIBUTE11.extend(p_count,p_parent_index);
4521 p_line_rec.INDUSTRY_ATTRIBUTE12.extend(p_count,p_parent_index);
4522 p_line_rec.INDUSTRY_ATTRIBUTE13.extend(p_count,p_parent_index);
4523 p_line_rec.INDUSTRY_ATTRIBUTE14.extend(p_count,p_parent_index);
4524 p_line_rec.INDUSTRY_ATTRIBUTE15.extend(p_count,p_parent_index);
4525 p_line_rec.INDUSTRY_ATTRIBUTE16.extend(p_count,p_parent_index);
4526 p_line_rec.INDUSTRY_ATTRIBUTE17.extend(p_count,p_parent_index);
4527 p_line_rec.INDUSTRY_ATTRIBUTE18.extend(p_count,p_parent_index);
4528 p_line_rec.INDUSTRY_ATTRIBUTE19.extend(p_count,p_parent_index);
4529 p_line_rec.INDUSTRY_ATTRIBUTE20.extend(p_count,p_parent_index);
4530 p_line_rec.INDUSTRY_ATTRIBUTE21.extend(p_count,p_parent_index);
4531 p_line_rec.INDUSTRY_ATTRIBUTE22.extend(p_count,p_parent_index);
4532 p_line_rec.INDUSTRY_ATTRIBUTE23.extend(p_count,p_parent_index);
4533 p_line_rec.INDUSTRY_ATTRIBUTE24.extend(p_count,p_parent_index);
4534 p_line_rec.INDUSTRY_ATTRIBUTE25.extend(p_count,p_parent_index);
4535 p_line_rec.INDUSTRY_ATTRIBUTE26.extend(p_count,p_parent_index);
4536 p_line_rec.INDUSTRY_ATTRIBUTE27.extend(p_count,p_parent_index);
4537 p_line_rec.INDUSTRY_ATTRIBUTE28.extend(p_count,p_parent_index);
4538 p_line_rec.INDUSTRY_ATTRIBUTE29.extend(p_count,p_parent_index);
4539 p_line_rec.INDUSTRY_ATTRIBUTE30.extend(p_count,p_parent_index);
4540 p_line_rec.INDUSTRY_ATTRIBUTE2.extend(p_count,p_parent_index);
4541 p_line_rec.INDUSTRY_ATTRIBUTE3.extend(p_count,p_parent_index);
4542 p_line_rec.INDUSTRY_ATTRIBUTE4.extend(p_count,p_parent_index);
4543 p_line_rec.INDUSTRY_ATTRIBUTE5.extend(p_count,p_parent_index);
4544 p_line_rec.INDUSTRY_ATTRIBUTE6.extend(p_count,p_parent_index);
4545 p_line_rec.INDUSTRY_ATTRIBUTE7.extend(p_count,p_parent_index);
4546 p_line_rec.INDUSTRY_ATTRIBUTE8.extend(p_count,p_parent_index);
4547 p_line_rec.INDUSTRY_ATTRIBUTE9.extend(p_count,p_parent_index);
4548 p_line_rec.INDUSTRY_CONTEXT.extend(p_count,p_parent_index);
4549 --p_line_rec.INTERMED_SHIP_TO_CONTACT_ID.extend(p_count,p_parent_index);
4550 --p_line_rec.INTERMED_SHIP_TO_ORG_ID.extend(p_count,p_parent_index);
4551 p_line_rec.INVENTORY_ITEM_ID.extend(p_count,p_parent_index);
4552 --p_line_rec.INVOICE_INTERFACE_STATUS_CODE.extend(p_count,p_parent_index);
4553 p_line_rec.INVOICE_TO_CONTACT_ID.extend(p_count,p_parent_index);
4554 p_line_rec.INVOICE_TO_ORG_ID.extend(p_count,p_parent_index);
4555 --p_line_rec.INVOICED_QUANTITY.extend(p_count,p_parent_index);
4556 p_line_rec.INVOICING_RULE_ID.extend(p_count,p_parent_index);
4557 p_line_rec.ORDERED_ITEM_ID.extend(p_count,p_parent_index);
4558 p_line_rec.ITEM_IDENTIFIER_TYPE.extend(p_count,p_parent_index);
4559 p_line_rec.ORDERED_ITEM.extend(p_count,p_parent_index);
4560 p_line_rec.CUSTOMER_ITEM_NET_PRICE.extend(p_count,p_parent_index);
4561 p_line_rec.ITEM_REVISION.extend(p_count,p_parent_index);
4562 p_line_rec.ITEM_TYPE_CODE.extend(p_count,p_parent_index);
4563 --p_line_rec.LAST_ACK_CODE.extend(p_count,p_parent_index);
4564 --p_line_rec.LAST_ACK_DATE.extend(p_count,p_parent_index);
4565 --p_line_rec.LAST_UPDATED_BY.extend(p_count,p_parent_index);
4566 --p_line_rec.LAST_UPDATE_DATE.extend(p_count,p_parent_index);
4567 --p_line_rec.LAST_UPDATE_LOGIN.extend(p_count,p_parent_index);
4568 p_line_rec.LATEST_ACCEPTABLE_DATE.extend(p_count,p_parent_index);
4569 p_line_rec.LINE_CATEGORY_CODE.extend(p_count,p_parent_index);
4570 p_line_rec.LINE_ID.extend(p_count,p_parent_index);
4571 p_line_rec.LINE_NUMBER.extend(p_count,p_parent_index);
4572 p_line_rec.LINE_TYPE_ID.extend(p_count,p_parent_index);
4573 p_line_rec.LINK_TO_LINE_ID.extend(p_count,p_parent_index);
4574 p_line_rec.MODEL_GROUP_NUMBER.extend(p_count,p_parent_index);
4575 p_line_rec.MFG_LEAD_TIME.extend(p_count,p_parent_index);
4576 --p_line_rec.OPEN_FLAG.extend(p_count,p_parent_index);
4577 p_line_rec.OPTION_FLAG.extend(p_count,p_parent_index);
4578 p_line_rec.OPTION_NUMBER.extend(p_count,p_parent_index);
4579 p_line_rec.ORDERED_QUANTITY.extend(p_count,p_parent_index);
4580 p_line_rec.ORDERED_QUANTITY2.extend(p_count,p_parent_index);
4581 p_line_rec.ORDER_QUANTITY_UOM.extend(p_count,p_parent_index);
4582 p_line_rec.ORDERED_QUANTITY_UOM2.extend(p_count,p_parent_index);
4583 p_line_rec.ORG_ID.extend(p_count,p_parent_index);
4584 p_line_rec.ORIG_SYS_DOCUMENT_REF.extend(p_count,p_parent_index);
4585 p_line_rec.ORIG_SYS_LINE_REF.extend(p_count,p_parent_index);
4586 p_line_rec.ORIG_SYS_SHIPMENT_REF.extend(p_count,p_parent_index);
4587 p_line_rec.CHANGE_SEQUENCE.extend(p_count,p_parent_index);
4588 p_line_rec.OVER_SHIP_REASON_CODE.extend(p_count,p_parent_index);
4589 p_line_rec.OVER_SHIP_RESOLVED_FLAG.extend(p_count,p_parent_index);
4590 p_line_rec.PAYMENT_TERM_ID.extend(p_count,p_parent_index);
4591 --p_line_rec.PLANNING_PRIORITY.extend(p_count,p_parent_index);
4592 p_line_rec.PREFERRED_GRADE.extend(p_count,p_parent_index); -- OPM HVOP
4593 p_line_rec.PRICE_LIST_ID.extend(p_count,p_parent_index);
4594 --p_line_rec.PRICE_REQUEST_CODE --PROMOTIONS MAY/01.extend(p_count,p_parent_index);
4595 p_line_rec.PRICING_ATTRIBUTE1.extend(p_count,p_parent_index);
4596 p_line_rec.PRICING_ATTRIBUTE10.extend(p_count,p_parent_index);
4597 p_line_rec.PRICING_ATTRIBUTE2.extend(p_count,p_parent_index);
4598 p_line_rec.PRICING_ATTRIBUTE3.extend(p_count,p_parent_index);
4599 p_line_rec.PRICING_ATTRIBUTE4.extend(p_count,p_parent_index);
4600 p_line_rec.PRICING_ATTRIBUTE5.extend(p_count,p_parent_index);
4601 p_line_rec.PRICING_ATTRIBUTE6.extend(p_count,p_parent_index);
4602 p_line_rec.PRICING_ATTRIBUTE7.extend(p_count,p_parent_index);
4603 p_line_rec.PRICING_ATTRIBUTE8.extend(p_count,p_parent_index);
4604 p_line_rec.PRICING_ATTRIBUTE9.extend(p_count,p_parent_index);
4605 p_line_rec.PRICING_CONTEXT.extend(p_count,p_parent_index);
4606 p_line_rec.PRICING_DATE.extend(p_count,p_parent_index);
4607 p_line_rec.PRICING_QUANTITY.extend(p_count,p_parent_index);
4608 p_line_rec.PRICING_QUANTITY_UOM.extend(p_count,p_parent_index);
4609 --p_line_rec.PROGRAM_APPLICATION_ID.extend(p_count,p_parent_index);
4610 --p_line_rec.PROGRAM_ID.extend(p_count,p_parent_index);
4611 --p_line_rec.PROGRAM_UPDATE_DATE.extend(p_count,p_parent_index);
4612 p_line_rec.PROJECT_ID.extend(p_count,p_parent_index);
4613 p_line_rec.PROMISE_DATE.extend(p_count,p_parent_index);
4614 p_line_rec.RE_SOURCE_FLAG.extend(p_count,p_parent_index);
4615 --p_line_rec.REFERENCE_CUSTOMER_TRX_LINE_ID.extend(p_count,p_parent_index);
4616 p_line_rec.REFERENCE_HEADER_ID.extend(p_count,p_parent_index);
4617 p_line_rec.REFERENCE_LINE_ID.extend(p_count,p_parent_index);
4618 p_line_rec.REFERENCE_TYPE.extend(p_count,p_parent_index);
4619 p_line_rec.REQUEST_DATE.extend(p_count,p_parent_index);
4620 p_line_rec.REQUEST_ID.extend(p_count,p_parent_index);
4621 p_line_rec.RETURN_ATTRIBUTE1.extend(p_count,p_parent_index);
4622 p_line_rec.RETURN_ATTRIBUTE10.extend(p_count,p_parent_index);
4623 p_line_rec.RETURN_ATTRIBUTE11.extend(p_count,p_parent_index);
4624 p_line_rec.RETURN_ATTRIBUTE12.extend(p_count,p_parent_index);
4625 p_line_rec.RETURN_ATTRIBUTE13.extend(p_count,p_parent_index);
4626 p_line_rec.RETURN_ATTRIBUTE14.extend(p_count,p_parent_index);
4627 p_line_rec.RETURN_ATTRIBUTE15.extend(p_count,p_parent_index);
4628 p_line_rec.RETURN_ATTRIBUTE2.extend(p_count,p_parent_index);
4629 p_line_rec.RETURN_ATTRIBUTE3.extend(p_count,p_parent_index);
4630 p_line_rec.RETURN_ATTRIBUTE4.extend(p_count,p_parent_index);
4631 p_line_rec.RETURN_ATTRIBUTE5.extend(p_count,p_parent_index);
4632 p_line_rec.RETURN_ATTRIBUTE6.extend(p_count,p_parent_index);
4633 p_line_rec.RETURN_ATTRIBUTE7.extend(p_count,p_parent_index);
4634 p_line_rec.RETURN_ATTRIBUTE8.extend(p_count,p_parent_index);
4635 p_line_rec.RETURN_ATTRIBUTE9.extend(p_count,p_parent_index);
4636 p_line_rec.RETURN_CONTEXT.extend(p_count,p_parent_index);
4637 p_line_rec.RETURN_REASON_CODE.extend(p_count,p_parent_index);
4638 --p_line_rec.RLA_SCHEDULE_TYPE_CODE.extend(p_count,p_parent_index);
4639 p_line_rec.SALESREP_ID.extend(p_count,p_parent_index);
4640 p_line_rec.SCHEDULE_ARRIVAL_DATE.extend(p_count,p_parent_index);
4641 p_line_rec.SCHEDULE_SHIP_DATE.extend(p_count,p_parent_index);
4642 p_line_rec.SCHEDULE_STATUS_CODE.extend(p_count,p_parent_index);
4643 p_line_rec.SHIPMENT_NUMBER.extend(p_count,p_parent_index);
4644 p_line_rec.SHIPMENT_PRIORITY_CODE.extend(p_count,p_parent_index);
4645 p_line_rec.SHIPPED_QUANTITY.extend(p_count,p_parent_index);
4646 p_line_rec.SHIPPED_QUANTITY2.extend(p_count,p_parent_index);
4647 p_line_rec.SHIPPING_METHOD_CODE.extend(p_count,p_parent_index);
4648 p_line_rec.SHIPPING_QUANTITY.extend(p_count,p_parent_index);
4649 p_line_rec.SHIPPING_QUANTITY2.extend(p_count,p_parent_index);
4650 p_line_rec.SHIPPING_QUANTITY_UOM.extend(p_count,p_parent_index);
4651 p_line_rec.SHIP_FROM_ORG_ID.extend(p_count,p_parent_index);
4652 p_line_rec.SUBINVENTORY.extend(p_count,p_parent_index);
4653 p_line_rec.SHIP_SET_ID.extend(p_count,p_parent_index);
4654 p_line_rec.SHIP_TOLERANCE_ABOVE.extend(p_count,p_parent_index);
4655 p_line_rec.SHIP_TOLERANCE_BELOW.extend(p_count,p_parent_index);
4656 p_line_rec.SHIPPABLE_FLAG.extend(p_count,p_parent_index);
4657 --p_line_rec.SHIPPING_INTERFACED_FLAG.extend(p_count,p_parent_index);
4658 p_line_rec.SHIP_TO_CONTACT_ID.extend(p_count,p_parent_index);
4659 p_line_rec.SHIP_TO_ORG_ID.extend(p_count,p_parent_index);
4660 p_line_rec.SHIP_MODEL_COMPLETE_FLAG.extend(p_count,p_parent_index);
4661 p_line_rec.SOLD_TO_ORG_ID.extend(p_count,p_parent_index);
4662 p_line_rec.SOLD_FROM_ORG_ID.extend(p_count,p_parent_index);
4663 p_line_rec.SORT_ORDER.extend(p_count,p_parent_index);
4664 p_line_rec.SOURCE_DOCUMENT_ID.extend(p_count,p_parent_index);
4665 --p_line_rec.SOURCE_DOCUMENT_LINE_ID .extend(p_count,p_parent_index);
4666 --p_line_rec.SOURCE_DOCUMENT_TYPE_ID.extend(p_count,p_parent_index);
4667 p_line_rec.SOURCE_TYPE_CODE.extend(p_count,p_parent_index);
4668 p_line_rec.SPLIT_FROM_LINE_ID.extend(p_count,p_parent_index);
4669 --p_line_rec.LINE_SET_ID.extend(p_count,p_parent_index);
4670 --p_line_rec.SPLIT_BY.extend(p_count,p_parent_index);
4671 p_line_rec.MODEL_REMNANT_FLAG.extend(p_count,p_parent_index);
4672 p_line_rec.TASK_ID.extend(p_count,p_parent_index);
4673 p_line_rec.TAX_CODE.extend(p_count,p_parent_index);
4674 p_line_rec.TAX_DATE.extend(p_count,p_parent_index);
4675 p_line_rec.TAX_EXEMPT_FLAG.extend(p_count,p_parent_index);
4676 p_line_rec.TAX_EXEMPT_NUMBER.extend(p_count,p_parent_index);
4677 p_line_rec.TAX_EXEMPT_REASON_CODE.extend(p_count,p_parent_index);
4678 p_line_rec.TAX_POINT_CODE.extend(p_count,p_parent_index);
4679 --p_line_rec.TAX_RATE.extend(p_count,p_parent_index);
4680 p_line_rec.TAX_VALUE.extend(p_count,p_parent_index);
4681 p_line_rec.TOP_MODEL_LINE_ID.extend(p_count,p_parent_index);
4682 p_line_rec.UNIT_LIST_PRICE.extend(p_count,p_parent_index);
4683 p_line_rec.UNIT_LIST_PRICE_PER_PQTY.extend(p_count,p_parent_index);
4684 p_line_rec.UNIT_SELLING_PRICE.extend(p_count,p_parent_index);
4685 p_line_rec.UNIT_SELLING_PRICE_PER_PQTY.extend(p_count,p_parent_index);
4686 p_line_rec.VISIBLE_DEMAND_FLAG.extend(p_count,p_parent_index);
4687 p_line_rec.VEH_CUS_ITEM_CUM_KEY_ID.extend(p_count,p_parent_index);
4688 p_line_rec.SHIPPING_INSTRUCTIONS.extend(p_count,p_parent_index);
4689 p_line_rec.PACKING_INSTRUCTIONS.extend(p_count,p_parent_index);
4690 p_line_rec.SERVICE_TXN_REASON_CODE.extend(p_count,p_parent_index);
4691 p_line_rec.SERVICE_TXN_COMMENTS.extend(p_count,p_parent_index);
4692 p_line_rec.SERVICE_DURATION.extend(p_count,p_parent_index);
4693 p_line_rec.SERVICE_PERIOD.extend(p_count,p_parent_index);
4694 p_line_rec.SERVICE_START_DATE.extend(p_count,p_parent_index);
4695 p_line_rec.SERVICE_END_DATE.extend(p_count,p_parent_index);
4696 p_line_rec.SERVICE_COTERMINATE_FLAG.extend(p_count,p_parent_index);
4697 p_line_rec.UNIT_LIST_PERCENT.extend(p_count,p_parent_index);
4698 p_line_rec.UNIT_SELLING_PERCENT.extend(p_count,p_parent_index);
4699 p_line_rec.UNIT_PERCENT_BASE_PRICE.extend(p_count,p_parent_index);
4700 p_line_rec.SERVICE_NUMBER.extend(p_count,p_parent_index);
4701 p_line_rec.SERVICE_REFERENCE_TYPE_CODE.extend(p_count,p_parent_index);
4702 --p_line_rec.SERVICE_REFERENCE_LINE_ID.extend(p_count,p_parent_index);
4703 --p_line_rec.SERVICE_REFERENCE_SYSTEM_ID.extend(p_count,p_parent_index);
4704 p_line_rec.TP_CONTEXT.extend(p_count,p_parent_index);
4705 p_line_rec.TP_ATTRIBUTE1.extend(p_count,p_parent_index);
4706 p_line_rec.TP_ATTRIBUTE2.extend(p_count,p_parent_index);
4707 p_line_rec.TP_ATTRIBUTE3.extend(p_count,p_parent_index);
4708 p_line_rec.TP_ATTRIBUTE4.extend(p_count,p_parent_index);
4709 p_line_rec.TP_ATTRIBUTE5.extend(p_count,p_parent_index);
4710 p_line_rec.TP_ATTRIBUTE6.extend(p_count,p_parent_index);
4711 p_line_rec.TP_ATTRIBUTE7.extend(p_count,p_parent_index);
4712 p_line_rec.TP_ATTRIBUTE8.extend(p_count,p_parent_index);
4713 p_line_rec.TP_ATTRIBUTE9.extend(p_count,p_parent_index);
4714 p_line_rec.TP_ATTRIBUTE10.extend(p_count,p_parent_index);
4715 p_line_rec.TP_ATTRIBUTE11.extend(p_count,p_parent_index);
4716 p_line_rec.TP_ATTRIBUTE12.extend(p_count,p_parent_index);
4717 p_line_rec.TP_ATTRIBUTE13.extend(p_count,p_parent_index);
4718 p_line_rec.TP_ATTRIBUTE14.extend(p_count,p_parent_index);
4719 p_line_rec.TP_ATTRIBUTE15.extend(p_count,p_parent_index);
4720 --p_line_rec.FLOW_STATUS_CODE.extend(p_count,p_parent_index);
4721 --p_line_rec.MARKETING_SOURCE_CODE_ID.extend(p_count,p_parent_index);
4722 p_line_rec.CALCULATE_PRICE_FLAG.extend(p_count,p_parent_index);
4723 p_line_rec.COMMITMENT_ID.extend(p_count,p_parent_index);
4724 p_line_rec.ORDER_SOURCE_ID.extend(p_count,p_parent_index);
4725 --p_line_rec.upgraded_flag.extend(p_count,p_parent_index);
4726 p_line_rec.LOCK_CONTROL.extend(p_count,p_parent_index);
4727 p_line_rec.WF_PROCESS_NAME.extend(p_count,p_parent_index);
4728 p_line_rec.user_item_description.extend(p_count,p_parent_index);
4729 p_line_rec.parent_line_index.extend(p_count,p_parent_index);
4730 p_line_rec.firm_demand_flag.extend(p_count,p_parent_index);
4731 -- p_line_rec.line_index.extend(p_count, p_parent_index);
4732 -- p_line_rec.header_index.extend(p_count, p_parent_index);
4733 -- end customer (Bug 5054618)
4734 p_line_rec.End_customer_contact_id.extend(p_count,p_parent_index);
4735 p_line_rec.End_customer_id.extend(p_count,p_parent_index);
4736 p_line_rec.End_customer_site_use_id.extend(p_count,p_parent_index);
4737 p_line_rec.IB_owner.extend(p_count,p_parent_index);
4738 p_line_rec.IB_current_location.extend(p_count,p_parent_index);
4739 p_line_rec.IB_Installed_at_Location.extend(p_count,p_parent_index);
4740 EXCEPTION
4741 WHEN OTHERS THEN
4742 IF l_debug_level > 0 THEN
4743 oe_debug_pub.add( 'OTHERS ERROR , EXTEND_INC_ITEM_REC' ) ;
4744 oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4745 END IF;
4746 OE_BULK_MSG_PUB.Add_Exc_Msg
4747 ( G_PKG_NAME
4748 , 'Extend_Inc_Item_Rec'
4749 );
4750 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4751 END Extend_Inc_Item_Rec;
4752
4753 PROCEDURE Assign_Included_Items
4754 (p_ii_count IN NUMBER
4755 ,p_ii_start_index IN NUMBER
4756 ,p_parent_index IN NUMBER
4757 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
4758 ,p_header_index IN NUMBER
4759 ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
4760 ,x_ii_on_generic_hold OUT NOCOPY BOOLEAN
4761 )
4762 IS
4763 l_process_name VARCHAR2(30);
4764 l_index NUMBER;
4765 l_component_number NUMBER := 1;
4766 l_ii_index NUMBER := p_ii_start_index;
4767 l_on_generic_hold BOOLEAN := FALSE;
4768 l_on_booking_hold BOOLEAN := FALSE;
4769 l_on_scheduling_hold BOOLEAN := FALSE;
4770 l_ii_on_hold_count NUMBER := 0;
4771 --
4772 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4773 --
4774 l_line_rec_for_hold OE_Order_PUB.Line_Rec_Type; --ER#7479609
4775 l_header_rec_for_hold OE_Order_PUB.Header_Rec_Type; --ER#7479609
4776 BEGIN
4777
4778 x_ii_on_generic_hold := FALSE;
4779 l_index := (p_line_rec.line_id.COUNT - p_ii_count) + 1;
4780
4781 FOR I IN 1..p_ii_count LOOP
4782
4783 IF l_debug_level > 0 THEN
4784 oe_debug_pub.add( 'INDEX :'||L_INDEX ) ;
4785 END IF;
4786
4787 p_line_rec.COMPONENT_CODE(l_index) := G_INC_ITEM_TBL(l_ii_index).COMPONENT_CODE;
4788 p_line_rec.COMPONENT_NUMBER(l_index) := l_component_number;
4789 p_line_rec.COMPONENT_SEQUENCE_ID(l_index) := G_INC_ITEM_TBL(l_ii_index).COMPONENT_SEQUENCE_ID;
4790 p_line_rec.INVENTORY_ITEM_ID(l_index) := G_INC_ITEM_TBL(l_ii_index).COMPONENT_ITEM_ID;
4791 p_line_rec.ORDERED_ITEM_ID(l_index) := G_INC_ITEM_TBL(l_ii_index).COMPONENT_ITEM_ID;
4792 p_line_rec.ORDERED_ITEM(l_index) := G_INC_ITEM_TBL(l_ii_index).ORDERED_ITEM;
4793 p_line_rec.ITEM_TYPE_CODE(l_index) := 'INCLUDED';
4794 p_line_rec.ORDERED_QUANTITY(l_index) := G_INC_ITEM_TBL(l_ii_index).extended_quantity
4795 * p_line_rec.ORDERED_QUANTITY(p_parent_index);
4796 p_line_rec.ORDERED_QUANTITY2(l_index) := p_line_rec.ORDERED_QUANTITY2(p_parent_index);
4797 p_line_rec.ORDER_QUANTITY_UOM(l_index) := G_INC_ITEM_TBL(l_ii_index).primary_uom_code;
4798 p_line_rec.ORDERED_QUANTITY_UOM2(l_index) := p_line_rec.ORDERED_QUANTITY_UOM2(p_parent_index);
4799 p_line_rec.PRICING_QUANTITY(l_index) := G_INC_ITEM_TBL(l_ii_index).extended_quantity
4800 * p_line_rec.ORDERED_QUANTITY(p_parent_index);
4801 p_line_rec.PRICING_QUANTITY_UOM(l_index) := G_INC_ITEM_TBL(l_ii_index).PRIMARY_UOM_CODE;
4802 p_line_rec.SHIPPABLE_FLAG(l_index) := G_INC_ITEM_TBL(l_ii_index).SHIPPABLE_FLAG;
4803 p_line_rec.SORT_ORDER(l_index) := G_INC_ITEM_TBL(l_ii_index).SORT_ORDER;
4804 p_line_rec.unit_list_price(l_index) := 0;
4805 p_line_rec.unit_list_price_per_pqty(l_index) := 0;
4806 p_line_rec.unit_selling_price(l_index) := 0;
4807 p_line_rec.unit_selling_price_per_pqty(l_index) := 0;
4808 -- Bug 2670420: query_included_items did not retrieve any items as
4809 -- link_to_line_id was not being populated earlier
4810 -- Set link_to_line_id to be same as top_model_line_id
4811 p_line_rec.link_to_line_id(l_index) := p_line_rec.line_id(p_parent_index);
4812 p_line_rec.parent_line_index(l_index) := p_parent_index;
4813 if (NOT p_line_rec.line_index.exists(l_index))
4814 THEN
4815 p_line_rec.line_index.extend(l_index - p_line_rec.line_index.count);
4816 end if;
4817 p_line_rec.line_index(l_index) := l_index;
4818 if (NOT p_line_rec.header_index.exists(l_index))
4819 THEN
4820 p_line_rec.header_index.extend(l_index - p_line_rec.header_index.count);
4821 end if;
4822 p_line_rec.header_index(l_index) := p_header_index;
4823
4824 SELECT OE_ORDER_LINES_S.NEXTVAL
4825 INTO p_line_rec.line_id(l_index)
4826 FROM DUAL;
4827
4828 -- Assign Workflow Process for Included Item Type
4829 IF NOT OE_BULK_WF_UTIL.Validate_LT_WF_Assignment(
4830 p_header_rec.order_type_id(p_header_index)
4831 ,l_index
4832 ,p_line_rec
4833 ,l_process_name)
4834 THEN
4835 p_line_rec.lock_control(l_index) := -99 ;
4836 fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
4837 FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
4838 OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
4839 OE_BULK_MSG_PUB.Add('Y','ERROR');
4840 RAISE FND_API.G_EXC_ERROR;
4841 ELSE
4842 IF l_debug_level > 0 THEN
4843 oe_debug_pub.add('Worflow Process for ii :'||l_process_name);
4844 END IF;
4845
4846 p_line_rec.wf_process_name(l_index) := l_process_name;
4847 END IF;
4848 --PIB
4849 IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4850 OE_BULK_PRICEORDER_PVT.set_calc_flag_incl_item(p_line_rec,l_index);
4851 END IF;
4852 --PIB
4853
4854 -- Evaluate Holds for inc item
4855 /*ER#7479609 start
4856 OE_Bulk_Holds_PVT.Evaluate_Holds(
4857 p_header_id => p_line_rec.header_id(l_index),
4858 p_line_id => p_line_rec.line_id(l_index),
4859 p_line_number => p_line_rec.line_number(l_index),
4860 p_sold_to_org_id => p_line_rec.sold_to_org_id(l_index),
4861 p_inventory_item_id => p_line_rec.inventory_item_id(l_index),
4862 p_ship_from_org_id => p_line_rec.ship_from_org_id(l_index),
4863 p_invoice_to_org_id => p_line_rec.invoice_to_org_id(l_index),
4864 p_ship_to_org_id => p_line_rec.ship_to_org_id(l_index),
4865 p_top_model_line_id => p_line_rec.top_model_line_id(l_index),
4866 p_ship_set_name => NULL,
4867 p_arrival_set_name => NULL,
4868 p_on_generic_hold => l_on_generic_hold,
4869 p_on_booking_hold => l_on_booking_hold,
4870 p_on_scheduling_hold => l_on_scheduling_hold
4871 );
4872 ER#7479609 end*/
4873
4874 --ER#7479609 start
4875 BEGIN
4876 SELECT order_type_id
4877 INTO l_header_rec_for_hold.order_type_id
4878 FROM OE_ORDER_HEADERS_ALL
4879 WHERE header_id=p_line_rec.header_id(l_index);
4880 EXCEPTION
4881 WHEN OTHERS THEN
4882 l_header_rec_for_hold.order_type_id := NULL;
4883 END;
4884
4885
4886 l_line_rec_for_hold.header_id := p_line_rec.header_id(l_index);
4887 l_line_rec_for_hold.line_id := p_line_rec.line_id(l_index);
4888 l_line_rec_for_hold.line_number := p_line_rec.line_number(l_index);
4889 l_line_rec_for_hold.sold_to_org_id := p_line_rec.sold_to_org_id(l_index);
4890 l_line_rec_for_hold.inventory_item_id := p_line_rec.inventory_item_id(l_index);
4891 l_line_rec_for_hold.ship_from_org_id := p_line_rec.ship_from_org_id(l_index);
4892 l_line_rec_for_hold.invoice_to_org_id := p_line_rec.invoice_to_org_id(l_index);
4893 l_line_rec_for_hold.ship_to_org_id := p_line_rec.ship_to_org_id(l_index);
4894 l_line_rec_for_hold.top_model_line_id := p_line_rec.top_model_line_id(l_index);
4895 l_line_rec_for_hold.price_list_id := p_line_rec.price_list_id(l_index);
4896 l_line_rec_for_hold.creation_date := to_char(sysdate,'DD-MON-RRRR');
4897 l_line_rec_for_hold.shipping_method_code := p_line_rec.shipping_method_code(l_index);
4898 l_line_rec_for_hold.deliver_to_org_id := p_line_rec.deliver_to_org_id(l_index);
4899 l_line_rec_for_hold.source_type_code := p_line_rec.source_type_code(l_index);
4900 l_line_rec_for_hold.line_type_id := p_line_rec.line_type_id(l_index);
4901 l_line_rec_for_hold.payment_term_id := p_line_rec.payment_term_id(l_index);
4902 l_line_rec_for_hold.created_by := NVL(FND_GLOBAL.USER_ID, -1);
4903
4904
4905 OE_Bulk_Holds_PVT.Evaluate_Holds(
4906 p_header_rec => l_header_rec_for_hold,
4907 p_line_rec => l_line_rec_for_hold,
4908 p_on_generic_hold => l_on_generic_hold,
4909 p_on_booking_hold => l_on_booking_hold,
4910 p_on_scheduling_hold => l_on_scheduling_hold
4911 );
4912 --ER#7479609 end
4913
4914 IF l_on_generic_hold THEN
4915 x_ii_on_generic_hold := TRUE;
4916 l_ii_on_hold_count := l_ii_on_hold_count + 1;
4917 -- If line is to be scheduled AND lines on hold should NOT be
4918 -- scheduled, populate error message and clear scheduling
4919 -- fields on this included item.
4920 IF p_line_rec.schedule_status_code(l_index) IS NOT NULL
4921 AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4922 THEN
4923 -- Add scheduling on hold message
4924 FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4925 OE_BULK_MSG_PUB.Add;
4926 p_line_rec.schedule_status_code(l_index) := NULL;
4927 p_line_rec.schedule_ship_date(l_index) := NULL;
4928 p_line_rec.schedule_arrival_date(l_index) := NULL;
4929 END IF;
4930 END IF;
4931
4932 l_index := l_index + 1;
4933 l_ii_index := l_ii_index + 1;
4934 l_component_number := l_component_number + 1;
4935
4936 END LOOP;
4937
4938 IF p_line_rec.schedule_status_code(p_parent_index) IS NOT NULL THEN
4939
4940 IF x_ii_on_generic_hold
4941 AND OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4942 THEN
4943
4944 -- Decrement the kit item from scheduling count
4945 -- For SMC and non-SMC, kit should not be scheduled if
4946 -- any included item is on generic hold
4947 OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4948 OE_BULK_ORDER_PVT.G_SCH_COUNT - 1;
4949
4950 -- If Non-SMC, increment the scheduling count by lines
4951 -- that need to be scheduled.
4952 IF p_line_rec.ship_model_complete_flag(p_parent_index) = 'N' THEN
4953
4954 OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4955 OE_BULK_ORDER_PVT.G_SCH_COUNT + (p_ii_count - l_ii_on_hold_count);
4956 -- Mark parent line status as ON HOLD so that scheduling ignores
4957 -- the parent line BUT still schedules the included items that
4958 -- are not on hold. If the status is nulled out, none of the
4959 -- included items will be scheduled !
4960 p_line_rec.schedule_status_code(p_parent_index) := 'II_ON_HOLD';
4961 p_line_rec.schedule_ship_date(p_parent_index) := NULL;
4962 p_line_rec.schedule_arrival_date(p_parent_index) := NULL;
4963
4964 ELSIF p_line_rec.ship_model_complete_flag(p_parent_index) = 'Y' THEN
4965
4966 -- For SMCs, all included items should not be scheduled if one is on hold
4967 FOR l_index IN (p_line_rec.line_id.COUNT - p_ii_count) + 1..p_line_rec.line_id.COUNT LOOP
4968 p_line_rec.schedule_status_code(l_index) := NULL;
4969 p_line_rec.schedule_ship_date(l_index) := NULL;
4970 p_line_rec.schedule_arrival_date(l_index) := NULL;
4971 END LOOP;
4972 -- Kit line should not be scheduled either for SMCs
4973 p_line_rec.schedule_status_code(p_parent_index) := NULL;
4974 p_line_rec.schedule_ship_date(p_parent_index) := NULL;
4975 p_line_rec.schedule_arrival_date(p_parent_index) := NULL;
4976
4977 END IF;
4978
4979 -- NO Holds, increment the scheduling count by number of
4980 -- included items
4981 ELSE
4982 OE_BULK_ORDER_PVT.G_SCH_COUNT :=
4983 OE_BULK_ORDER_PVT.G_SCH_COUNT + p_ii_count;
4984 END IF;
4985
4986 END IF;
4987
4988 EXCEPTION
4989 WHEN OTHERS THEN
4990 IF l_debug_level > 0 THEN
4991 oe_debug_pub.add( 'OTHERS ERROR , ASSIGN_INCLUDED_ITEMS' ) ;
4992 oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4993 END IF;
4994 OE_BULK_MSG_PUB.Add_Exc_Msg
4995 ( G_PKG_NAME
4996 , 'Assign_Included_Items'
4997 );
4998 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4999 END Assign_Included_Items;
5000
5001 ---------------------------------------------------------------------
5002 -- PROCEDURE Create_Line_Scredits
5003 --
5004 -- BULK Inserts line sales credits into the OM tables from
5005 -- p_line_scredit_rec
5006 ---------------------------------------------------------------------
5007
5008 PROCEDURE Create_Line_Scredits
5009 (p_line_scredit_rec IN OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
5010 )
5011 IS
5012 --
5013 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5014 --
5015 BEGIN
5016
5017 IF p_line_scredit_rec.header_id.COUNT = 0 THEN
5018 RETURN;
5019 END IF;
5020
5021 FORALL I IN p_line_scredit_rec.header_id.FIRST..p_line_scredit_rec.header_id.LAST
5022 INSERT INTO OE_SALES_CREDITS
5023 (
5024 CREATED_BY
5025 , CREATION_DATE
5026 , DW_UPDATE_ADVICE_FLAG
5027 , HEADER_ID
5028 , LAST_UPDATED_BY
5029 , LAST_UPDATE_DATE
5030 , LAST_UPDATE_LOGIN
5031 , LINE_ID
5032 , PERCENT
5033 , SALESREP_ID
5034 , sales_credit_type_id
5035 , SALES_CREDIT_ID
5036 , WH_UPDATE_DATE
5037 , ORIG_SYS_CREDIT_REF
5038 , LOCK_CONTROL
5039 )
5040 VALUES
5041 (
5042 FND_GLOBAL.USER_ID
5043 , sysdate
5044 , NULL
5045 , p_line_scredit_rec.header_id(i)
5046 , FND_GLOBAL.USER_ID
5047 , sysdate
5048 , FND_GLOBAL.USER_ID
5049 , p_line_scredit_rec.line_id(i)
5050 , 100
5051 , p_line_scredit_rec.salesrep_id(i)
5052 , nvl(p_line_scredit_rec.Sales_Credit_Type_id(i),1)
5053 , OE_SALES_CREDITS_S.nextval
5054 , NULL
5055 , NULL
5056 , 1
5057 );
5058
5059 EXCEPTION
5060 WHEN OTHERS THEN
5061 OE_BULK_MSG_PUB.Add_Exc_Msg
5062 ( G_PKG_NAME
5063 , 'Create_Line_Scredits'
5064 );
5065 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5066 END Create_Line_Scredits;
5067
5068 ---------------------------------------------------------------------
5069 -- PROCEDURE Append_Included_Items
5070 --
5071 -- This procedure is called for each KIT line being processed.
5072 -- It appends the exploded included item order lines for this kit
5073 -- to the end of p_line_rec.
5074 -- IN/IN OUT Parameters -
5075 -- p_parent_index : index of the KIT line in p_line_rec
5076 -- p_line_rec: order lines in this batch
5077 -- p_header_index : index of the order header for the kit line in
5078 -- p_header_rec
5079 -- p_header_rec: order headers in this batch
5080 -- OUT Parameters -
5081 -- x_ii_count : number of included item lines for this KIT line
5082 -- x_ii_start_index : starting index from where the included items
5083 -- for this KIT line are appended in p_line_rec
5084 -- x_ii_on_generic_hold : TRUE if any one included item for this
5085 -- KIT is applicable for a generic hold
5086 ---------------------------------------------------------------------
5087
5088 PROCEDURE Append_Included_Items
5089 (p_parent_index IN NUMBER
5090 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
5091 ,p_header_index IN NUMBER
5092 ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
5093 ,x_ii_count OUT NOCOPY NUMBER
5094 ,x_ii_start_index OUT NOCOPY NUMBER
5095 ,x_ii_on_generic_hold OUT NOCOPY BOOLEAN
5096 )
5097 IS
5098 l_kit_item_id NUMBER;
5099 l_ship_from_org_id NUMBER;
5100 l_index NUMBER;
5101 l_msg_data VARCHAR2(2000);
5102 l_error_code VARCHAR2(2000);
5103 l_return_status VARCHAR2(30);
5104 l_freeze BOOLEAN := FALSE;
5105 CURSOR c_inc_items IS
5106 SELECT be.component_code
5107 ,be.component_sequence_id
5108 ,be.component_item_id
5109 ,be.extended_quantity
5110 ,be.primary_uom_code
5111 ,be.sort_order
5112 ,i.concatenated_segments ordered_item
5113 ,wi.shippable_item_flag
5114 FROM BOM_BILL_OF_MATERIALS bom
5115 , BOM_EXPLOSIONS be
5116 , MTL_SYSTEM_ITEMS_KFV i -- item in item validation org
5117 , MTL_SYSTEM_ITEMS wi -- item in ship from org
5118 WHERE bom.assembly_item_id = l_kit_item_id
5119 AND bom.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5120 AND be.top_bill_sequence_id = bom.bill_sequence_id
5121 AND be.explosion_type = 'INCLUDED'
5122 AND be.plan_level >= 0
5123 AND be.effectivity_date <= sysdate
5124 AND be.disable_date > sysdate
5125 AND be.component_item_id <> be.top_item_id
5126 AND i.inventory_item_id = be.component_item_id
5127 AND i.organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
5128 AND wi.inventory_item_id = be.component_item_id
5129 AND wi.organization_id = nvl(l_ship_from_org_id,OE_BULK_ORDER_PVT.G_ITEM_ORG)
5130 ORDER BY be.sort_order;
5131 --
5132 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5133 --
5134 BEGIN
5135
5136 ------------------------------------------------------------------
5137 -- Check if this kit line should be exploded/frozen
5138 ------------------------------------------------------------------
5139
5140 -- 1. If freeze method is 'Entry', explode and freeze included items
5141 IF OE_BULK_ORDER_PVT.G_IIFM = 'ENTRY' THEN
5142 l_freeze := TRUE;
5143
5144 -- 2. If freeze method is 'Booked', freeze if parent line is booked.
5145 -- If not booked, explode if parent line is to be scheduled
5146 -- but do not freeze.
5147 ELSIF OE_BULK_ORDER_PVT.G_IIFM = 'BOOKING' THEN
5148 IF p_line_rec.booked_flag(p_parent_index) = 'Y' THEN
5149 l_freeze := TRUE;
5150 ELSIF p_line_rec.schedule_status_code(p_parent_index) IS NULL THEN
5151 RETURN;
5152 END IF;
5153
5154 -- 3. For other freeze methods (e.g. Pick Release), explode if
5155 -- parent line is to be scheduled but do not freeze.
5156 ELSIF p_line_rec.schedule_status_code(p_parent_index) IS NULL THEN
5157 RETURN;
5158 END IF;
5159
5160 ------------------------------------------------------------------
5161 -- Cache included item info in globals - G_KIT_ITEM_TBL and
5162 -- G_INC_ITEM_TBL - for this kit item
5163 ------------------------------------------------------------------
5164
5165 l_kit_item_id := p_line_rec.inventory_item_id(p_parent_index);
5166
5167 IF NOT G_KIT_ITEM_TBL.EXISTS(l_kit_item_id) THEN
5168
5169 OE_Config_UTIL.Explode
5170 (p_validation_org => OE_BULK_ORDER_PVT.G_ITEM_ORG,
5171 p_levels => 6, --??
5172 p_stdcompflag => 'INCLUDED',
5173 p_top_item_id => l_kit_item_id,
5174 p_revdate => sysdate,
5175 x_msg_data => l_msg_data,
5176 x_error_code => l_error_code,
5177 x_return_status => l_return_status
5178 );
5179
5180 -- When does BOM return expected error during Explode?
5181 IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5182 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183 ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5184 RAISE FND_API.G_EXC_ERROR;
5185 END IF;
5186
5187 l_index := G_INC_ITEM_TBL.COUNT + 1;
5188
5189 IF l_debug_level > 0 THEN
5190 oe_debug_pub.add( 'START INDEX :'||L_INDEX ) ;
5191 END IF;
5192 G_KIT_ITEM_TBL(l_kit_item_id).ii_start_index := l_index;
5193
5194 l_ship_from_org_id := p_line_rec.ship_from_org_id(p_parent_index);
5195
5196 OPEN c_inc_items;
5197
5198 LOOP
5199 FETCH c_inc_items INTO
5200 G_INC_ITEM_TBL(l_index).component_code
5201 ,G_INC_ITEM_TBL(l_index).component_sequence_id
5202 ,G_INC_ITEM_TBL(l_index).component_item_id
5203 ,G_INC_ITEM_TBL(l_index).extended_quantity
5204 ,G_INC_ITEM_TBL(l_index).primary_uom_code
5205 ,G_INC_ITEM_TBL(l_index).sort_order
5206 ,G_INC_ITEM_TBL(l_index).ordered_item
5207 ,G_INC_ITEM_TBL(l_index).shippable_flag
5208 ;
5209
5210 IF c_inc_items%NOTFOUND THEN
5211 EXIT;
5212 END IF;
5213
5214 l_index := l_index + 1;
5215
5216 END LOOP;
5217
5218 CLOSE c_inc_items;
5219
5220 IF l_debug_level > 0 THEN
5221 oe_debug_pub.add( 'END INDEX :'||L_INDEX ) ;
5222 END IF;
5223 G_KIT_ITEM_TBL(l_kit_item_id).ii_count :=
5224 l_index - G_KIT_ITEM_TBL(l_kit_item_id).ii_start_index;
5225
5226 END IF; -- End caching included item info
5227
5228 ------------------------------------------------------------------
5229 -- Use the cached records to append included item order lines
5230 -- to lines global: p_line_rec
5231 ------------------------------------------------------------------
5232
5233 x_ii_count := G_KIT_ITEM_TBL(l_kit_item_id).ii_count;
5234 x_ii_start_index := p_line_rec.line_id.count + 1;
5235
5236 Extend_Inc_Item_Rec
5237 (p_count => G_KIT_ITEM_TBL(l_kit_item_id).ii_count
5238 ,p_parent_index => p_parent_index
5239 ,p_line_rec => p_line_rec
5240 );
5241
5242 Assign_Included_Items
5243 (p_ii_count => G_KIT_ITEM_TBL(l_kit_item_id).ii_count
5244 ,p_ii_start_index => G_KIT_ITEM_TBL(l_kit_item_id).ii_start_index
5245 ,p_parent_index => p_parent_index
5246 ,p_line_rec => p_line_rec
5247 ,p_header_index => p_header_index
5248 ,p_header_rec => p_header_rec
5249 ,x_ii_on_generic_hold => x_ii_on_generic_hold
5250 );
5251
5252 IF (l_freeze) THEN
5253 p_line_rec.explosion_date(p_parent_index) := sysdate;
5254 END IF;
5255
5256 EXCEPTION
5257 WHEN FND_API.G_EXC_ERROR THEN
5258 RAISE FND_API.G_EXC_ERROR;
5259 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5261 WHEN OTHERS THEN
5262 IF l_debug_level > 0 THEN
5263 oe_debug_pub.add( 'OTHERS ERROR , APPEND_INCLUDED_ITEMS' ) ;
5264 oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5265 END IF;
5266 OE_BULK_MSG_PUB.Add_Exc_Msg
5267 ( G_PKG_NAME
5268 , 'Append_Included_Items'
5269 );
5270 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271 END Append_Included_Items;
5272 END OE_BULK_LINE_UTIL;