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