[Home] [Help]
PACKAGE BODY: APPS.OE_VERSION_HISTORY_UTIL
Source
1 PACKAGE BODY OE_VERSION_HISTORY_UTIL AS
2 /* $Header: OEXHVERB.pls 120.8.12020000.3 2013/01/17 07:19:05 sujithku ship $ */
3
4 -- This API will be used to create history records for entities.
5 -- 1. oe_order_header_history
6 -- 2. oe_order_lines_history
7 -- 3. oe_price_adjs_history
8 -- 4. oe_sales_credit_history
9 -- It will skip the records which already exists for the specified version.
10 --
11 -- If the API is called just for Phase_Change then p_version_number should
12 -- be sent in as NULL and p_phase_change_flag = 'Y'.
13
14 --start bug 9503990
15 FUNCTION get_status (p_line_id IN NUMBER, p_flow_status_code IN VARCHAR2) RETURN VARCHAR2 AS
16 released_count NUMBER;
17 total_count NUMBER;
18 l_flow_status_code VARCHAR2(80);
19 BEGIN
20 --IF l_debug_level > 0 THEN
21 oe_debug_pub.add('Entering get_status');
22 oe_debug_pub.add('Flow Status Code:'||p_flow_status_code);
23 --END IF;
24
25 l_flow_status_code := p_flow_status_code;
26
27 IF p_flow_status_code is null THEN
28 SELECT flow_status_code
29 INTO l_flow_status_code
30 FROM oe_order_lines_all
31 WHERE line_id=p_line_id;
32 END IF;
33
34 IF l_flow_status_code <> 'AWAITING_SHIPPING' AND
35 l_flow_status_code <> 'PRODUCTION_COMPLETE' AND
36 l_flow_status_code <> 'PICKED' AND
37 l_flow_status_code <> 'PICKED_PARTIAL' AND
38 l_flow_status_code <> 'PO_RECEIVED'
39 THEN
40 RETURN l_flow_status_code;
41 ELSE
42 SELECT sum(decode(released_status, 'Y', 1, 'C', 1, 0)), sum(1)
43 INTO released_count, total_count
44 FROM wsh_delivery_details
45 WHERE source_line_id = p_line_id
46 AND source_code = 'OE'
47 AND released_status <> 'D';
48 IF released_count = total_count THEN
49 RETURN 'PICKED';
50 ELSIF released_count < total_count and released_count <> 0 THEN
51 RETURN 'PICKED_PARTIAL';
52 ELSE
53 RETURN l_flow_status_code;
54 END IF;
55
56 END IF;
57
58 END get_status;
59 -- end bug 9503990
60
61 PROCEDURE Create_Version_History
62 (p_header_id IN NUMBER
63 ,p_version_number IN NUMBER
64 ,p_phase_change_flag IN VARCHAR2
65 ,p_changed_attribute IN VARCHAR2 := NULL
66 ,x_return_status IN OUT NOCOPY VARCHAR2)
67 IS
68 l_api_name VARCHAR2(30) := 'Create_Version_History';
69 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
70 l_version_number NUMBER;
71 l_version_flag VARCHAR2(1);
72 l_instrument_id NUMBER;
73 l_credit_card_number VARCHAR2(10);
74 l_credit_card_code VARCHAR2(10);
75 l_credit_card_holder_name VARCHAR2(10);
76 l_credit_card_expiration_date DATE;
77
78 BEGIN
79 -- Initialize API return status to success
80 x_return_status := FND_API.G_RET_STS_SUCCESS;
81
82 -- If the call is made just to create PHASE_CHANGE history then caller will
83 -- send in p_version_number as NULL.
84 IF p_version_number IS NULL and p_phase_change_flag = 'Y' THEN
85
86 SELECT version_number
87 INTO l_version_number
88 FROM oe_order_headers
89 WHERE header_id = p_header_id;
90
91 l_version_flag := 'N';
92 ELSE
93 l_version_number := p_version_number;
94 l_version_flag := 'Y';
95 END IF;
96
97 -- First Create History Records for Headers
98 l_api_name := 'Create_Header_History';
99
100 -- R12 CC encryption
101 -- replaced the following query to join to base table for performance fix
102 /*
103 BEGIN
104 SELECT ite.instrument_id
105 INTO l_instrument_id
106 FROM oe_payments op,
107 iby_trxn_extensions_v ite
108 WHERE op.header_id = p_header_id
109 AND op.trxn_extension_id = ite.trxn_extension_id;
110 EXCEPTION WHEN NO_DATA_FOUND THEN
111 null;
112 END;
113 */
114
115 BEGIN
116 SELECT u.instrument_id
117 INTO l_instrument_id
118 FROM oe_payments op,
119 iby_pmt_instr_uses_all u,
120 iby_fndcpt_tx_extensions x
121 WHERE op.header_id = p_header_id
122 AND op.payment_type_code = 'CREDIT_CARD'
123 AND nvl(op.payment_collection_event, 'PREPAY') = 'INVOICE'
124 AND op.trxn_extension_id = x.trxn_extension_id
125 AND op.line_id is null
126 AND x.instr_assignment_id = u.instrument_payment_use_id;
127 EXCEPTION WHEN NO_DATA_FOUND THEN
128 null;
129 END;
130
131
132 -- for credit card orders, only instrument id is stored for credit card number
133 -- and credit card code, need to set these two values to indicate the column
134 -- instrument_id stores actual instrument_id, otherwise it stores the
135 -- card history change id if other card attributes are being changed.
136 IF l_instrument_id IS NOT NULL THEN
137 IF p_changed_attribute IS NOT NULL THEN
138
139 IF l_debug_level > 0 THEN
140 oe_debug_pub.add( 'p_changed_attr is : ' || p_changed_attribute) ;
141 END IF;
142
143 -- store the instrument_id in column instruemnt_id
144 -- if credit_card_number or credit_card_code is updated.
145 IF instr(p_changed_attribute, 'CREDIT_CARD_NUMBER') > 0 THEN
146 l_credit_card_number := '****';
147 END IF;
148
149 IF instr(p_changed_attribute, 'CREDIT_CARD_CODE') > 0 THEN
150 l_credit_card_code := '****';
151 END IF;
152
153 IF instr(p_changed_attribute, 'CREDIT_CARD_HOLDER_NAME') > 0 THEN
154 l_credit_card_holder_name := '****';
155 END IF;
156
157 IF instr(p_changed_attribute, 'CREDIT_CARD_EXPIRATION_DATE') > 0 THEN
158 l_credit_card_expiration_date := sysdate;
159 END IF;
160
161 -- need to store card_history_change_id in column instrument_id
162 -- if credit_card_expiration_date or credit_card_holder_name is updated
163
164 IF l_credit_card_code IS NULL AND l_credit_card_number IS NULL THEN
165 BEGIN
166 SELECT max(card_history_change_id)
167 INTO l_instrument_id
168 FROM iby_creditcard_h
169 WHERE instrid = l_instrument_id;
170 EXCEPTION WHEN NO_DATA_FOUND THEN
171 NULL;
172 END;
173 END IF;
174
175 /**
176 ELSIF p_changed_attribute IS NULL THEN
177 -- need to store card_history_change_id in column instrument_id
178 -- if credit_card_expiration_date or credit_card_holder_name is updated
179 BEGIN
180 SELECT max(card_history_change_id)
181 INTO l_instrument_id
182 FROM iby_creditcard_h
183 WHERE instrid = l_instrument_id;
184 EXCEPTION WHEN NO_DATA_FOUND THEN
185 NULL;
186 END;
187 **/
188
189 END IF;
190 IF l_debug_level > 0 THEN
191 oe_debug_pub.add( 'RECORDHEADERHIST:l_instrument_id is : ' || l_instrument_id) ;
192 END IF;
193 END IF;
194
195
196 INSERT INTO OE_ORDER_HEADER_HISTORY
197 (
198 HEADER_ID,
199 HIST_CREATION_DATE,
200 ORG_ID,
201 ORDER_TYPE_ID,
202 ORDER_NUMBER,
203 VERSION_NUMBER,
204 EXPIRATION_DATE,
205 ORDER_SOURCE_ID,
206 SOURCE_DOCUMENT_TYPE_ID,
207 ORIG_SYS_DOCUMENT_REF,
208 SOURCE_DOCUMENT_ID,
209 ORDERED_DATE,
210 REQUEST_DATE,
211 PRICING_DATE,
212 SHIPMENT_PRIORITY_CODE,
213 DEMAND_CLASS_CODE,
214 PRICE_LIST_ID,
215 TAX_EXEMPT_FLAG,
216 TAX_EXEMPT_NUMBER,
217 TAX_EXEMPT_REASON_CODE,
218 CONVERSION_RATE,
219 CONVERSION_TYPE_CODE,
220 CONVERSION_RATE_DATE,
221 PARTIAL_SHIPMENTS_ALLOWED,
222 SHIP_TOLERANCE_ABOVE,
223 SHIP_TOLERANCE_BELOW,
224 TRANSACTIONAL_CURR_CODE,
225 AGREEMENT_ID,
226 TAX_POINT_CODE,
227 CUST_PO_NUMBER,
228 INVOICING_RULE_ID,
229 ACCOUNTING_RULE_ID,
230 PAYMENT_TERM_ID,
231 SHIPPING_METHOD_CODE,
232 FREIGHT_CARRIER_CODE,
233 FOB_POINT_CODE,
234 FREIGHT_TERMS_CODE,
235 SOLD_FROM_ORG_ID,
236 SOLD_TO_ORG_ID,
237 SHIP_FROM_ORG_ID,
238 SHIP_TO_ORG_ID,
239 INVOICE_TO_ORG_ID,
240 DELIVER_TO_ORG_ID,
241 SOLD_TO_CONTACT_ID,
242 SHIP_TO_CONTACT_ID,
243 INVOICE_TO_CONTACT_ID,
244 DELIVER_TO_CONTACT_ID,
245 CREATION_DATE,
246 CREATED_BY,
247 LAST_UPDATED_BY,
248 LAST_UPDATE_DATE,
249 LAST_UPDATE_LOGIN,
250 PROGRAM_APPLICATION_ID,
251 PROGRAM_ID,
252 PROGRAM_UPDATE_DATE,
253 REQUEST_ID,
254 CONTEXT,
255 ATTRIBUTE1,
256 ATTRIBUTE2,
257 ATTRIBUTE3,
258 ATTRIBUTE4,
259 ATTRIBUTE5,
260 ATTRIBUTE6,
261 ATTRIBUTE7,
262 ATTRIBUTE8,
263 ATTRIBUTE9,
264 ATTRIBUTE10,
265 ATTRIBUTE11,
266 ATTRIBUTE12,
267 ATTRIBUTE13,
268 ATTRIBUTE14,
269 ATTRIBUTE15,
270 GLOBAL_ATTRIBUTE_CATEGORY,
271 GLOBAL_ATTRIBUTE1,
272 GLOBAL_ATTRIBUTE2,
273 GLOBAL_ATTRIBUTE3,
274 GLOBAL_ATTRIBUTE4,
275 GLOBAL_ATTRIBUTE5,
276 GLOBAL_ATTRIBUTE6,
277 GLOBAL_ATTRIBUTE7,
278 GLOBAL_ATTRIBUTE8,
279 GLOBAL_ATTRIBUTE9,
280 GLOBAL_ATTRIBUTE10,
281 GLOBAL_ATTRIBUTE11,
282 GLOBAL_ATTRIBUTE12,
283 GLOBAL_ATTRIBUTE13,
284 GLOBAL_ATTRIBUTE14,
285 GLOBAL_ATTRIBUTE15,
286 GLOBAL_ATTRIBUTE16,
287 GLOBAL_ATTRIBUTE17,
288 GLOBAL_ATTRIBUTE18,
289 GLOBAL_ATTRIBUTE19,
290 GLOBAL_ATTRIBUTE20,
291 CANCELLED_FLAG,
292 OPEN_FLAG,
293 BOOKED_FLAG,
294 SALESREP_ID,
295 RETURN_REASON_CODE,
296 ORDER_DATE_TYPE_CODE,
297 EARLIEST_SCHEDULE_LIMIT,
298 LATEST_SCHEDULE_LIMIT,
299 PAYMENT_TYPE_CODE,
300 PAYMENT_AMOUNT,
301 CHECK_NUMBER,
302 CREDIT_CARD_NUMBER,
303 CREDIT_CARD_CODE,
304 CREDIT_CARD_HOLDER_NAME,
305 CREDIT_CARD_EXPIRATION_DATE,
306 -- CREDIT_CARD_APPROVAL_CODE,
307 SALES_CHANNEL_CODE,
308 FIRST_ACK_CODE,
309 FIRST_ACK_DATE,
310 LAST_ACK_CODE,
311 LAST_ACK_DATE,
312 ORDER_CATEGORY_CODE,
313 CHANGE_SEQUENCE,
314 SHIPPING_INSTRUCTIONS,
315 PACKING_INSTRUCTIONS,
316 TP_CONTEXT,
317 TP_ATTRIBUTE1,
318 TP_ATTRIBUTE2,
319 TP_ATTRIBUTE3,
320 TP_ATTRIBUTE4,
321 TP_ATTRIBUTE5,
322 TP_ATTRIBUTE6,
323 TP_ATTRIBUTE7,
324 TP_ATTRIBUTE8,
325 TP_ATTRIBUTE9,
326 TP_ATTRIBUTE10,
327 TP_ATTRIBUTE11,
328 TP_ATTRIBUTE12,
329 TP_ATTRIBUTE13,
330 TP_ATTRIBUTE14,
331 TP_ATTRIBUTE15,
332 FLOW_STATUS_CODE,
333 MARKETING_SOURCE_CODE_ID,
334 CREDIT_CARD_APPROVAL_DATE,
335 UPGRADED_FLAG,
336 CUSTOMER_PREFERENCE_SET_CODE,
337 BOOKED_DATE,
338 LOCK_CONTROL,
339 REASON_CODE,
340 HIST_COMMENTS,
341 HIST_TYPE_CODE,
342 HIST_CREATED_BY,
343 RESPONSIBILITY_ID,
344 PRICE_REQUEST_CODE,
345 ACCOUNTING_RULE_DURATION,
346 ATTRIBUTE16,
347 ATTRIBUTE17,
348 ATTRIBUTE18,
349 ATTRIBUTE19,
350 ATTRIBUTE20,
351 ITEM_RELATIONSHIP_TYPE,
352 BLANKET_NUMBER,
353 SALES_DOCUMENT_TYPE_CODE,
354 SOLD_TO_PHONE_ID,
355 QUOTE_NUMBER,
356 SALES_DOCUMENT_NAME,
357 TRANSACTION_PHASE_CODE,
358 USER_STATUS_CODE,
359 DRAFT_SUBMITTED_FLAG,
360 SOURCE_DOCUMENT_VERSION_NUMBER,
361 SOLD_TO_SITE_USE_ID,
362 QUOTE_DATE,
363 SUPPLIER_SIGNATURE,
364 SUPPLIER_SIGNATURE_DATE,
365 CUSTOMER_SIGNATURE,
366 CUSTOMER_SIGNATURE_DATE,
367 AUDIT_FLAG,
368 VERSION_FLAG,
369 PHASE_CHANGE_FLAG,
370 --key Transaction Dates
371 ORDER_FIRMED_DATE,
372 INSTRUMENT_ID
373 )
374 SELECT
375 HEADER_ID,
376 sysdate,
377 ORG_ID,
378 ORDER_TYPE_ID,
379 ORDER_NUMBER,
380 VERSION_NUMBER,
381 EXPIRATION_DATE,
382 ORDER_SOURCE_ID,
383 SOURCE_DOCUMENT_TYPE_ID,
384 ORIG_SYS_DOCUMENT_REF,
385 SOURCE_DOCUMENT_ID,
386 ORDERED_DATE,
387 REQUEST_DATE,
388 PRICING_DATE,
389 SHIPMENT_PRIORITY_CODE,
390 DEMAND_CLASS_CODE,
391 PRICE_LIST_ID,
392 TAX_EXEMPT_FLAG,
393 TAX_EXEMPT_NUMBER,
394 TAX_EXEMPT_REASON_CODE,
395 CONVERSION_RATE,
396 CONVERSION_TYPE_CODE,
397 CONVERSION_RATE_DATE,
398 PARTIAL_SHIPMENTS_ALLOWED,
399 SHIP_TOLERANCE_ABOVE,
400 SHIP_TOLERANCE_BELOW,
401 TRANSACTIONAL_CURR_CODE,
402 AGREEMENT_ID,
403 TAX_POINT_CODE,
404 CUST_PO_NUMBER,
405 INVOICING_RULE_ID,
406 ACCOUNTING_RULE_ID,
407 PAYMENT_TERM_ID,
408 SHIPPING_METHOD_CODE,
409 FREIGHT_CARRIER_CODE,
410 FOB_POINT_CODE,
411 FREIGHT_TERMS_CODE,
412 SOLD_FROM_ORG_ID,
413 SOLD_TO_ORG_ID,
414 SHIP_FROM_ORG_ID,
415 SHIP_TO_ORG_ID,
416 INVOICE_TO_ORG_ID,
417 DELIVER_TO_ORG_ID,
418 SOLD_TO_CONTACT_ID,
419 SHIP_TO_CONTACT_ID,
420 INVOICE_TO_CONTACT_ID,
421 DELIVER_TO_CONTACT_ID,
422 CREATION_DATE,
423 CREATED_BY,
424 LAST_UPDATED_BY,
425 LAST_UPDATE_DATE,
426 LAST_UPDATE_LOGIN,
427 PROGRAM_APPLICATION_ID,
428 PROGRAM_ID,
429 PROGRAM_UPDATE_DATE,
430 REQUEST_ID,
431 CONTEXT,
432 ATTRIBUTE1,
433 ATTRIBUTE2,
434 ATTRIBUTE3,
435 ATTRIBUTE4,
436 ATTRIBUTE5,
437 ATTRIBUTE6,
438 ATTRIBUTE7,
439 ATTRIBUTE8,
440 ATTRIBUTE9,
441 ATTRIBUTE10,
442 ATTRIBUTE11,
443 ATTRIBUTE12,
444 ATTRIBUTE13,
445 ATTRIBUTE14,
446 ATTRIBUTE15,
447 GLOBAL_ATTRIBUTE_CATEGORY,
448 GLOBAL_ATTRIBUTE1,
449 GLOBAL_ATTRIBUTE2,
450 GLOBAL_ATTRIBUTE3,
451 GLOBAL_ATTRIBUTE4,
452 GLOBAL_ATTRIBUTE5,
453 GLOBAL_ATTRIBUTE6,
454 GLOBAL_ATTRIBUTE7,
455 GLOBAL_ATTRIBUTE8,
456 GLOBAL_ATTRIBUTE9,
457 GLOBAL_ATTRIBUTE10,
458 GLOBAL_ATTRIBUTE11,
459 GLOBAL_ATTRIBUTE12,
460 GLOBAL_ATTRIBUTE13,
461 GLOBAL_ATTRIBUTE14,
462 GLOBAL_ATTRIBUTE15,
463 GLOBAL_ATTRIBUTE16,
464 GLOBAL_ATTRIBUTE17,
465 GLOBAL_ATTRIBUTE18,
466 GLOBAL_ATTRIBUTE19,
467 GLOBAL_ATTRIBUTE20,
468 CANCELLED_FLAG,
469 OPEN_FLAG,
470 BOOKED_FLAG,
471 SALESREP_ID,
472 RETURN_REASON_CODE,
473 ORDER_DATE_TYPE_CODE,
474 EARLIEST_SCHEDULE_LIMIT,
475 LATEST_SCHEDULE_LIMIT,
476 PAYMENT_TYPE_CODE,
477 PAYMENT_AMOUNT,
478 CHECK_NUMBER,
479 L_CREDIT_CARD_NUMBER,
480 L_CREDIT_CARD_CODE,
481 L_CREDIT_CARD_HOLDER_NAME,
482 L_CREDIT_CARD_EXPIRATION_DATE,
483 -- CREDIT_CARD_APPROVAL_CODE,
484 SALES_CHANNEL_CODE,
485 FIRST_ACK_CODE,
486 FIRST_ACK_DATE,
487 LAST_ACK_CODE,
488 LAST_ACK_DATE,
489 ORDER_CATEGORY_CODE,
490 CHANGE_SEQUENCE,
491 SHIPPING_INSTRUCTIONS,
492 PACKING_INSTRUCTIONS,
493 TP_CONTEXT,
494 TP_ATTRIBUTE1,
495 TP_ATTRIBUTE2,
496 TP_ATTRIBUTE3,
497 TP_ATTRIBUTE4,
498 TP_ATTRIBUTE5,
499 TP_ATTRIBUTE6,
500 TP_ATTRIBUTE7,
501 TP_ATTRIBUTE8,
502 TP_ATTRIBUTE9,
503 TP_ATTRIBUTE10,
504 TP_ATTRIBUTE11,
505 TP_ATTRIBUTE12,
506 TP_ATTRIBUTE13,
507 TP_ATTRIBUTE14,
508 TP_ATTRIBUTE15,
509 FLOW_STATUS_CODE,
510 MARKETING_SOURCE_CODE_ID,
511 CREDIT_CARD_APPROVAL_DATE,
512 UPGRADED_FLAG,
513 CUSTOMER_PREFERENCE_SET_CODE,
514 BOOKED_DATE,
515 LOCK_CONTROL,
516 NULL, --REASON_CODE,
517 NULL, --HIST_COMMENTS,
518 NULL, --HIST_TYPE_CODE,
519 nvl(FND_GLOBAL.USER_ID, -1), --HIST_CREATED_BY,
520 nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID,
521 PRICE_REQUEST_CODE,
522 ACCOUNTING_RULE_DURATION,
523 ATTRIBUTE16,
524 ATTRIBUTE17,
525 ATTRIBUTE18,
526 ATTRIBUTE19,
527 ATTRIBUTE20,
528 NULL, --ITEM_RELATIONSHIP_TYPE,
529 BLANKET_NUMBER,
530 SALES_DOCUMENT_TYPE_CODE,
531 SOLD_TO_PHONE_ID,
532 QUOTE_NUMBER,
533 SALES_DOCUMENT_NAME,
534 TRANSACTION_PHASE_CODE,
535 USER_STATUS_CODE,
536 DRAFT_SUBMITTED_FLAG,
537 SOURCE_DOCUMENT_VERSION_NUMBER,
538 SOLD_TO_SITE_USE_ID,
539 QUOTE_DATE,
540 SUPPLIER_SIGNATURE,
541 SUPPLIER_SIGNATURE_DATE,
542 CUSTOMER_SIGNATURE,
543 CUSTOMER_SIGNATURE_DATE,
544 'N', -- AUDIT_FLAG,
545 l_version_flag, -- VERSION_FLAG,
546 p_phase_change_flag, --PHASE_CHANGE_FLAG
547 --key Transaction Dates
548 order_firmed_date,
549 l_instrument_id
550 FROM OE_ORDER_HEADERS a
551 WHERE a.header_id = p_header_id
552 AND NOT EXISTS (SELECT b.header_id
553 FROM OE_ORDER_HEADER_HISTORY b
554 WHERE a.header_id = b.header_id
555 AND b.version_number = l_version_number
556 AND b.version_flag = l_version_flag);
557 IF l_debug_level > 0 THEN
558 oe_debug_pub.add(' No. of History Records for Header ' ||SQL%ROWCOUNT);
559 END IF;
560
561 -- Create History Records for Lines
562 l_api_name := 'Create_Line_History';
563
564 INSERT INTO oe_order_lines_history
565 (
566 LINE_ID,
567 ORG_ID,
568 HEADER_ID,
569 LINE_TYPE_ID,
570 LINE_NUMBER,
571 REQUEST_DATE,
572 PROMISE_DATE,
573 SCHEDULE_SHIP_DATE,
574 ORDER_QUANTITY_UOM,
575 PRICING_QUANTITY,
576 PRICING_QUANTITY_UOM,
577 CANCELLED_QUANTITY,
578 SHIPPED_QUANTITY,
579 ORDERED_QUANTITY,
580 FULFILLED_QUANTITY,
581 SHIPPING_QUANTITY,
582 SHIPPING_QUANTITY_UOM,
583 DELIVERY_LEAD_TIME,
584 TAX_EXEMPT_FLAG,
585 TAX_EXEMPT_NUMBER,
586 TAX_EXEMPT_REASON_CODE,
587 SHIP_FROM_ORG_ID,
588 SHIP_TO_ORG_ID,
589 INVOICE_TO_ORG_ID,
590 DELIVER_TO_ORG_ID,
591 SHIP_TO_CONTACT_ID,
592 DELIVER_TO_CONTACT_ID,
593 INVOICE_TO_CONTACT_ID,
594 SOLD_FROM_ORG_ID,
595 SOLD_TO_ORG_ID,
596 CUST_PO_NUMBER,
597 SHIP_TOLERANCE_ABOVE,
598 SHIP_TOLERANCE_BELOW,
599 DEMAND_BUCKET_TYPE_CODE,
600 VEH_CUS_ITEM_CUM_KEY_ID,
601 RLA_SCHEDULE_TYPE_CODE,
602 CUSTOMER_DOCK_CODE,
603 CUSTOMER_JOB,
604 CUSTOMER_PRODUCTION_LINE,
605 CUST_MODEL_SERIAL_NUMBER,
606 PROJECT_ID,
607 TASK_ID,
608 INVENTORY_ITEM_ID,
609 TAX_DATE,
610 TAX_CODE,
611 TAX_RATE,
612 DEMAND_CLASS_CODE,
613 PRICE_LIST_ID,
614 PRICING_DATE,
615 SHIPMENT_NUMBER,
616 AGREEMENT_ID,
617 SHIPMENT_PRIORITY_CODE,
618 SHIPPING_METHOD_CODE,
619 FREIGHT_CARRIER_CODE,
620 FREIGHT_TERMS_CODE,
621 FOB_POINT_CODE,
622 TAX_POINT_CODE,
623 PAYMENT_TERM_ID,
624 INVOICING_RULE_ID,
625 ACCOUNTING_RULE_ID,
626 SOURCE_DOCUMENT_TYPE_ID,
627 ORIG_SYS_DOCUMENT_REF,
628 SOURCE_DOCUMENT_ID,
629 ORIG_SYS_LINE_REF,
630 SOURCE_DOCUMENT_LINE_ID,
631 REFERENCE_LINE_ID,
632 REFERENCE_TYPE,
633 REFERENCE_HEADER_ID,
634 ITEM_REVISION,
635 UNIT_SELLING_PRICE,
636 UNIT_LIST_PRICE,
637 TAX_VALUE,
638 CONTEXT,
639 ATTRIBUTE1,
640 ATTRIBUTE2,
641 ATTRIBUTE3,
642 ATTRIBUTE4,
643 ATTRIBUTE5,
644 ATTRIBUTE6,
645 ATTRIBUTE7,
646 ATTRIBUTE8,
647 ATTRIBUTE9,
648 ATTRIBUTE10,
649 ATTRIBUTE11,
650 ATTRIBUTE12,
651 ATTRIBUTE13,
652 ATTRIBUTE14,
653 ATTRIBUTE15,
654 GLOBAL_ATTRIBUTE_CATEGORY,
655 GLOBAL_ATTRIBUTE1,
656 GLOBAL_ATTRIBUTE2,
657 GLOBAL_ATTRIBUTE3,
658 GLOBAL_ATTRIBUTE4,
659 GLOBAL_ATTRIBUTE5,
660 GLOBAL_ATTRIBUTE6,
661 GLOBAL_ATTRIBUTE7,
662 GLOBAL_ATTRIBUTE8,
663 GLOBAL_ATTRIBUTE9,
664 GLOBAL_ATTRIBUTE10,
665 GLOBAL_ATTRIBUTE11,
666 GLOBAL_ATTRIBUTE12,
667 GLOBAL_ATTRIBUTE13,
668 GLOBAL_ATTRIBUTE14,
669 GLOBAL_ATTRIBUTE15,
670 GLOBAL_ATTRIBUTE16,
671 GLOBAL_ATTRIBUTE17,
672 GLOBAL_ATTRIBUTE18,
673 GLOBAL_ATTRIBUTE19,
674 GLOBAL_ATTRIBUTE20,
675 PRICING_CONTEXT,
676 PRICING_ATTRIBUTE1,
677 PRICING_ATTRIBUTE2,
678 PRICING_ATTRIBUTE3,
679 PRICING_ATTRIBUTE4,
680 PRICING_ATTRIBUTE5,
681 PRICING_ATTRIBUTE6,
682 PRICING_ATTRIBUTE7,
683 PRICING_ATTRIBUTE8,
684 PRICING_ATTRIBUTE9,
685 PRICING_ATTRIBUTE10,
686 INDUSTRY_CONTEXT,
687 INDUSTRY_ATTRIBUTE1,
688 INDUSTRY_ATTRIBUTE2,
689 INDUSTRY_ATTRIBUTE3,
690 INDUSTRY_ATTRIBUTE4,
691 INDUSTRY_ATTRIBUTE5,
692 INDUSTRY_ATTRIBUTE6,
693 INDUSTRY_ATTRIBUTE7,
694 INDUSTRY_ATTRIBUTE8,
695 INDUSTRY_ATTRIBUTE9,
696 INDUSTRY_ATTRIBUTE10,
697 INDUSTRY_ATTRIBUTE11,
698 INDUSTRY_ATTRIBUTE13,
699 INDUSTRY_ATTRIBUTE12,
700 INDUSTRY_ATTRIBUTE14,
701 INDUSTRY_ATTRIBUTE15,
702 INDUSTRY_ATTRIBUTE16,
703 INDUSTRY_ATTRIBUTE17,
704 INDUSTRY_ATTRIBUTE18,
705 INDUSTRY_ATTRIBUTE19,
706 INDUSTRY_ATTRIBUTE20,
707 INDUSTRY_ATTRIBUTE21,
708 INDUSTRY_ATTRIBUTE22,
709 INDUSTRY_ATTRIBUTE23,
710 INDUSTRY_ATTRIBUTE24,
711 INDUSTRY_ATTRIBUTE25,
712 INDUSTRY_ATTRIBUTE26,
713 INDUSTRY_ATTRIBUTE27,
714 INDUSTRY_ATTRIBUTE28,
715 INDUSTRY_ATTRIBUTE29,
716 INDUSTRY_ATTRIBUTE30,
717 CREATION_DATE,
718 CREATED_BY,
719 LAST_UPDATE_DATE,
720 LAST_UPDATED_BY,
721 LAST_UPDATE_LOGIN,
722 PROGRAM_APPLICATION_ID,
723 PROGRAM_ID,
724 PROGRAM_UPDATE_DATE,
725 REQUEST_ID,
726 CONFIGURATION_ID,
727 LINK_TO_LINE_ID,
728 COMPONENT_SEQUENCE_ID,
729 COMPONENT_CODE,
730 CONFIG_DISPLAY_SEQUENCE,
731 SORT_ORDER,
732 ITEM_TYPE_CODE,
733 OPTION_NUMBER,
734 OPTION_FLAG,
735 DEP_PLAN_REQUIRED_FLAG,
736 VISIBLE_DEMAND_FLAG,
737 LINE_CATEGORY_CODE,
738 ACTUAL_SHIPMENT_DATE,
739 CUSTOMER_TRX_LINE_ID,
740 RETURN_CONTEXT,
741 RETURN_ATTRIBUTE1,
742 RETURN_ATTRIBUTE2,
743 RETURN_ATTRIBUTE3,
744 RETURN_ATTRIBUTE4,
745 RETURN_ATTRIBUTE5,
746 RETURN_ATTRIBUTE6,
747 RETURN_ATTRIBUTE7,
748 RETURN_ATTRIBUTE8,
749 RETURN_ATTRIBUTE9,
750 RETURN_ATTRIBUTE10,
751 RETURN_ATTRIBUTE11,
752 RETURN_ATTRIBUTE12,
753 RETURN_ATTRIBUTE13,
754 RETURN_ATTRIBUTE14,
755 RETURN_ATTRIBUTE15,
756 INTMED_SHIP_TO_ORG_ID,
757 INTMED_SHIP_TO_CONTACT_ID,
758 ACTUAL_ARRIVAL_DATE,
759 ATO_LINE_ID,
760 AUTO_SELECTED_QUANTITY,
761 COMPONENT_NUMBER,
762 EARLIEST_ACCEPTABLE_DATE,
763 EXPLOSION_DATE,
764 LATEST_ACCEPTABLE_DATE,
765 MODEL_GROUP_NUMBER,
766 SCHEDULE_ARRIVAL_DATE,
767 SHIP_MODEL_COMPLETE_FLAG,
768 SCHEDULE_STATUS_CODE,
769 SOURCE_TYPE_CODE,
770 TOP_MODEL_LINE_ID,
771 BOOKED_FLAG,
772 CANCELLED_FLAG,
773 OPEN_FLAG,
774 LOAD_SEQ_NUMBER,
775 DELIVERY_ID,
776 SALESREP_ID,
777 RETURN_REASON_CODE,
778 WF_ACTIVITY_CODE,
779 WF_RESULT_CODE,
780 REASON_CODE,
781 HIST_COMMENTS,
782 HIST_TYPE_CODE,
783 HIST_CREATION_DATE,
784 HIST_CREATED_BY,
785 CUST_PRODUCTION_SEQ_NUM,
786 AUTHORIZED_TO_SHIP_FLAG,
787 SPLIT_FROM_LINE_ID,
788 OVER_SHIP_REASON_CODE,
789 OVER_SHIP_RESOLVED_FLAG,
790 ITEM_IDENTIFIER_TYPE,
791 ARRIVAL_SET_ID,
792 SHIP_SET_ID,
793 COMMITMENT_ID,
794 SHIPPING_INTERFACED_FLAG,
795 CREDIT_INVOICE_LINE_ID,
796 MFG_COMPONENT_SEQUENCE_ID,
797 TP_CONTEXT,
798 TP_ATTRIBUTE1,
799 TP_ATTRIBUTE2,
800 TP_ATTRIBUTE3,
801 TP_ATTRIBUTE4,
802 TP_ATTRIBUTE5,
803 TP_ATTRIBUTE6,
804 TP_ATTRIBUTE7,
805 TP_ATTRIBUTE8,
806 TP_ATTRIBUTE9,
807 TP_ATTRIBUTE10,
808 TP_ATTRIBUTE11,
809 TP_ATTRIBUTE12,
810 TP_ATTRIBUTE13,
811 TP_ATTRIBUTE14,
812 TP_ATTRIBUTE15,
813 FULFILLMENT_METHOD_CODE,
814 SERVICE_REFERENCE_TYPE_CODE,
815 SERVICE_REFERENCE_LINE_ID,
816 SERVICE_REFERENCE_SYSTEM_ID,
817 INVOICE_INTERFACE_STATUS_CODE,
818 ORDERED_ITEM,
819 ORDERED_ITEM_ID,
820 SERVICE_NUMBER,
821 SERVICED_LINE_ID,
822 SERVICE_DURATION,
823 SERVICE_START_DATE,
824 RE_SOURCE_FLAG,
825 FLOW_STATUS_CODE,
826 SERVICE_END_DATE,
827 SERVICE_COTERMINATE_FLAG,
828 SHIPPABLE_FLAG,
829 ORDER_SOURCE_ID,
830 ORIG_SYS_SHIPMENT_REF,
831 CHANGE_SEQUENCE,
832 DROP_SHIP_FLAG,
833 CUSTOMER_LINE_NUMBER,
834 CUSTOMER_SHIPMENT_NUMBER,
835 CUSTOMER_ITEM_NET_PRICE,
836 CUSTOMER_PAYMENT_TERM_ID,
837 FIRST_ACK_DATE,
838 FIRST_ACK_CODE,
839 LAST_ACK_CODE,
840 LAST_ACK_DATE,
841 PLANNING_PRIORITY,
842 SERVICE_TXN_COMMENTS,
843 SERVICE_PERIOD,
844 UNIT_SELLING_PERCENT,
845 UNIT_LIST_PERCENT,
846 UNIT_PERCENT_BASE_PRICE,
847 MODEL_REMNANT_FLAG,
848 SERVICE_TXN_REASON_CODE,
849 CALCULATE_PRICE_FLAG,
850 ITEM_INPUT,
851 CUSTOMER_ITEM_ID,
852 CUSTOMER_ITEM_REVISION,
853 ITEM_ID,
854 INVOICE_COMPLETE_FLAG,
855 END_ITEM_UNIT_NUMBER,
856 FULFILLED_FLAG,
857 CONFIG_HEADER_ID,
858 CONFIG_REV_NBR,
859 SHIPPING_INSTRUCTIONS,
860 PACKING_INSTRUCTIONS,
861 INVOICED_QUANTITY,
862 REFERENCE_CUSTOMER_TRX_LINE_ID,
863 SPLIT_BY,
864 LINE_SET_ID,
865 REVENUE_AMOUNT,
866 FULFILLMENT_DATE,
867 PREFERRED_GRADE,
868 ORDERED_QUANTITY2,
869 ORDERED_QUANTITY_UOM2,
870 SHIPPED_QUANTITY2,
871 CANCELLED_QUANTITY2,
872 SHIPPING_QUANTITY2,
873 SHIPPING_QUANTITY_UOM2,
874 FULFILLED_QUANTITY2,
875 SUBINVENTORY,
876 RESPONSIBILITY_ID,
877 UNIT_LIST_PRICE_PER_PQTY,
878 UNIT_SELLING_PRICE_PER_PQTY,
879 LATEST_CANCELLED_QUANTITY,
880 PRICE_REQUEST_CODE,
881 LATE_DEMAND_PENALTY_FACTOR,
882 OVERRIDE_ATP_DATE_CODE,
883 ITEM_SUBSTITUTION_TYPE_CODE,
884 ORIGINAL_ITEM_IDENTIFIER_TYPE,
885 ORIGINAL_ORDERED_ITEM,
886 ORIGINAL_ORDERED_ITEM_ID,
887 ORIGINAL_INVENTORY_ITEM_ID,
888 ACCOUNTING_RULE_DURATION,
889 ATTRIBUTE16,
890 ATTRIBUTE17,
891 ATTRIBUTE18,
892 ATTRIBUTE19,
893 ATTRIBUTE20,
894 USER_ITEM_DESCRIPTION,
895 ITEM_RELATIONSHIP_TYPE,
896 BLANKET_NUMBER,
897 BLANKET_LINE_NUMBER,
898 BLANKET_VERSION_NUMBER,
899 VERSION_NUMBER,
900 SALES_DOCUMENT_TYPE_CODE,
901 AUDIT_FLAG,
902 VERSION_FLAG,
903 PHASE_CHANGE_FLAG,
904 TRANSACTION_PHASE_CODE,
905 SOURCE_DOCUMENT_VERSION_NUMBER,
906 --key Transaction Dates
907 ORDER_FIRMED_DATE,
908 CHARGE_PERIODICITY_CODE,
909 ACTUAL_FULFILLMENT_DATE,
910 -- sol_ord_er #16014165
911 SERVICE_BILL_PROFILE_ID,
912 SERVICE_COV_TEMPLATE_ID,
913 SERVICE_SUBS_TEMPLATE_ID,
914 SERVICE_BILL_OPTION_CODE,
915 SERVICE_FIRST_PERIOD_AMOUNT,
916 SUBSCRIPTION_ENABLE_FLAG,
917 SERVICE_FIRST_PERIOD_ENDDATE
918 )
919 SELECT
920 LINE_ID,
921 ORG_ID,
922 HEADER_ID,
923 LINE_TYPE_ID,
924 LINE_NUMBER,
925 REQUEST_DATE,
926 PROMISE_DATE,
927 SCHEDULE_SHIP_DATE,
928 ORDER_QUANTITY_UOM,
929 PRICING_QUANTITY,
930 PRICING_QUANTITY_UOM,
931 CANCELLED_QUANTITY,
932 SHIPPED_QUANTITY,
933 ORDERED_QUANTITY,
934 FULFILLED_QUANTITY,
935 SHIPPING_QUANTITY,
936 SHIPPING_QUANTITY_UOM,
937 DELIVERY_LEAD_TIME,
938 TAX_EXEMPT_FLAG,
939 TAX_EXEMPT_NUMBER,
940 TAX_EXEMPT_REASON_CODE,
941 SHIP_FROM_ORG_ID,
942 SHIP_TO_ORG_ID,
943 INVOICE_TO_ORG_ID,
944 DELIVER_TO_ORG_ID,
945 SHIP_TO_CONTACT_ID,
946 DELIVER_TO_CONTACT_ID,
947 INVOICE_TO_CONTACT_ID,
948 SOLD_FROM_ORG_ID,
949 SOLD_TO_ORG_ID,
950 CUST_PO_NUMBER,
951 SHIP_TOLERANCE_ABOVE,
952 SHIP_TOLERANCE_BELOW,
953 DEMAND_BUCKET_TYPE_CODE,
954 VEH_CUS_ITEM_CUM_KEY_ID,
955 RLA_SCHEDULE_TYPE_CODE,
956 CUSTOMER_DOCK_CODE,
957 CUSTOMER_JOB,
958 CUSTOMER_PRODUCTION_LINE,
959 CUST_MODEL_SERIAL_NUMBER,
960 PROJECT_ID,
961 TASK_ID,
962 INVENTORY_ITEM_ID,
963 TAX_DATE,
964 TAX_CODE,
965 TAX_RATE,
966 DEMAND_CLASS_CODE,
967 PRICE_LIST_ID,
968 PRICING_DATE,
969 SHIPMENT_NUMBER,
970 AGREEMENT_ID,
971 SHIPMENT_PRIORITY_CODE,
972 SHIPPING_METHOD_CODE,
973 FREIGHT_CARRIER_CODE,
974 FREIGHT_TERMS_CODE,
975 FOB_POINT_CODE,
976 TAX_POINT_CODE,
977 PAYMENT_TERM_ID,
978 INVOICING_RULE_ID,
979 ACCOUNTING_RULE_ID,
980 SOURCE_DOCUMENT_TYPE_ID,
981 ORIG_SYS_DOCUMENT_REF,
982 SOURCE_DOCUMENT_ID,
983 ORIG_SYS_LINE_REF,
984 SOURCE_DOCUMENT_LINE_ID,
985 REFERENCE_LINE_ID,
986 REFERENCE_TYPE,
987 REFERENCE_HEADER_ID,
988 ITEM_REVISION,
989 UNIT_SELLING_PRICE,
990 UNIT_LIST_PRICE,
991 TAX_VALUE,
992 CONTEXT,
993 ATTRIBUTE1,
994 ATTRIBUTE2,
995 ATTRIBUTE3,
996 ATTRIBUTE4,
997 ATTRIBUTE5,
998 ATTRIBUTE6,
999 ATTRIBUTE7,
1000 ATTRIBUTE8,
1001 ATTRIBUTE9,
1002 ATTRIBUTE10,
1003 ATTRIBUTE11,
1004 ATTRIBUTE12,
1005 ATTRIBUTE13,
1006 ATTRIBUTE14,
1007 ATTRIBUTE15,
1008 GLOBAL_ATTRIBUTE_CATEGORY,
1009 GLOBAL_ATTRIBUTE1,
1010 GLOBAL_ATTRIBUTE2,
1011 GLOBAL_ATTRIBUTE3,
1012 GLOBAL_ATTRIBUTE4,
1013 GLOBAL_ATTRIBUTE5,
1014 GLOBAL_ATTRIBUTE6,
1015 GLOBAL_ATTRIBUTE7,
1016 GLOBAL_ATTRIBUTE8,
1017 GLOBAL_ATTRIBUTE9,
1018 GLOBAL_ATTRIBUTE10,
1019 GLOBAL_ATTRIBUTE11,
1020 GLOBAL_ATTRIBUTE12,
1021 GLOBAL_ATTRIBUTE13,
1022 GLOBAL_ATTRIBUTE14,
1023 GLOBAL_ATTRIBUTE15,
1024 GLOBAL_ATTRIBUTE16,
1025 GLOBAL_ATTRIBUTE17,
1026 GLOBAL_ATTRIBUTE18,
1027 GLOBAL_ATTRIBUTE19,
1028 GLOBAL_ATTRIBUTE20,
1029 PRICING_CONTEXT,
1030 PRICING_ATTRIBUTE1,
1031 PRICING_ATTRIBUTE2,
1032 PRICING_ATTRIBUTE3,
1033 PRICING_ATTRIBUTE4,
1034 PRICING_ATTRIBUTE5,
1035 PRICING_ATTRIBUTE6,
1036 PRICING_ATTRIBUTE7,
1037 PRICING_ATTRIBUTE8,
1038 PRICING_ATTRIBUTE9,
1039 PRICING_ATTRIBUTE10,
1040 INDUSTRY_CONTEXT,
1041 INDUSTRY_ATTRIBUTE1,
1042 INDUSTRY_ATTRIBUTE2,
1043 INDUSTRY_ATTRIBUTE3,
1044 INDUSTRY_ATTRIBUTE4,
1045 INDUSTRY_ATTRIBUTE5,
1046 INDUSTRY_ATTRIBUTE6,
1047 INDUSTRY_ATTRIBUTE7,
1048 INDUSTRY_ATTRIBUTE8,
1049 INDUSTRY_ATTRIBUTE9,
1050 INDUSTRY_ATTRIBUTE10,
1051 INDUSTRY_ATTRIBUTE11,
1052 INDUSTRY_ATTRIBUTE13,
1053 INDUSTRY_ATTRIBUTE12,
1054 INDUSTRY_ATTRIBUTE14,
1055 INDUSTRY_ATTRIBUTE15,
1056 INDUSTRY_ATTRIBUTE16,
1057 INDUSTRY_ATTRIBUTE17,
1058 INDUSTRY_ATTRIBUTE18,
1059 INDUSTRY_ATTRIBUTE19,
1060 INDUSTRY_ATTRIBUTE20,
1061 INDUSTRY_ATTRIBUTE21,
1062 INDUSTRY_ATTRIBUTE22,
1063 INDUSTRY_ATTRIBUTE23,
1064 INDUSTRY_ATTRIBUTE24,
1065 INDUSTRY_ATTRIBUTE25,
1066 INDUSTRY_ATTRIBUTE26,
1067 INDUSTRY_ATTRIBUTE27,
1068 INDUSTRY_ATTRIBUTE28,
1069 INDUSTRY_ATTRIBUTE29,
1070 INDUSTRY_ATTRIBUTE30,
1071 CREATION_DATE,
1072 CREATED_BY,
1073 LAST_UPDATE_DATE,
1074 LAST_UPDATED_BY,
1075 LAST_UPDATE_LOGIN,
1076 PROGRAM_APPLICATION_ID,
1077 PROGRAM_ID,
1078 PROGRAM_UPDATE_DATE,
1079 REQUEST_ID,
1080 CONFIGURATION_ID,
1081 LINK_TO_LINE_ID,
1082 COMPONENT_SEQUENCE_ID,
1083 COMPONENT_CODE,
1084 CONFIG_DISPLAY_SEQUENCE,
1085 SORT_ORDER,
1086 ITEM_TYPE_CODE,
1087 OPTION_NUMBER,
1088 OPTION_FLAG,
1089 DEP_PLAN_REQUIRED_FLAG,
1090 VISIBLE_DEMAND_FLAG,
1091 LINE_CATEGORY_CODE,
1092 ACTUAL_SHIPMENT_DATE,
1093 CUSTOMER_TRX_LINE_ID,
1094 RETURN_CONTEXT,
1095 RETURN_ATTRIBUTE1,
1096 RETURN_ATTRIBUTE2,
1097 RETURN_ATTRIBUTE3,
1098 RETURN_ATTRIBUTE4,
1099 RETURN_ATTRIBUTE5,
1100 RETURN_ATTRIBUTE6,
1101 RETURN_ATTRIBUTE7,
1102 RETURN_ATTRIBUTE8,
1103 RETURN_ATTRIBUTE9,
1104 RETURN_ATTRIBUTE10,
1105 RETURN_ATTRIBUTE11,
1106 RETURN_ATTRIBUTE12,
1107 RETURN_ATTRIBUTE13,
1108 RETURN_ATTRIBUTE14,
1109 RETURN_ATTRIBUTE15,
1110 INTMED_SHIP_TO_ORG_ID,
1111 INTMED_SHIP_TO_CONTACT_ID,
1112 ACTUAL_ARRIVAL_DATE,
1113 ATO_LINE_ID,
1114 AUTO_SELECTED_QUANTITY,
1115 COMPONENT_NUMBER,
1116 EARLIEST_ACCEPTABLE_DATE,
1117 EXPLOSION_DATE,
1118 LATEST_ACCEPTABLE_DATE,
1119 MODEL_GROUP_NUMBER,
1120 SCHEDULE_ARRIVAL_DATE,
1121 SHIP_MODEL_COMPLETE_FLAG,
1122 SCHEDULE_STATUS_CODE,
1123 SOURCE_TYPE_CODE,
1124 TOP_MODEL_LINE_ID,
1125 BOOKED_FLAG,
1126 CANCELLED_FLAG,
1127 OPEN_FLAG,
1128 NULL, --LOAD_SEQ_NUMBER,
1129 NULL, --DELIVERY_ID,
1130 SALESREP_ID,
1131 RETURN_REASON_CODE,
1132 NULL, --WF_ACTIVITY_CODE,
1133 NULL, --WF_RESULT_CODE,
1134 NULL, --REASON_CODE,
1135 NULL, --HIST_COMMENTS,
1136 'VERSIONING', --HIST_TYPE_CODE,
1137 sysdate, --HIST_CREATION_DATE,
1138 nvl(FND_GLOBAL.USER_ID, -1), -- HIST_CREATED_BY,
1139 CUST_PRODUCTION_SEQ_NUM,
1140 AUTHORIZED_TO_SHIP_FLAG,
1141 SPLIT_FROM_LINE_ID,
1142 OVER_SHIP_REASON_CODE,
1143 OVER_SHIP_RESOLVED_FLAG,
1144 ITEM_IDENTIFIER_TYPE,
1145 ARRIVAL_SET_ID,
1146 SHIP_SET_ID,
1147 COMMITMENT_ID,
1148 SHIPPING_INTERFACED_FLAG,
1149 CREDIT_INVOICE_LINE_ID,
1150 MFG_COMPONENT_SEQUENCE_ID,
1151 TP_CONTEXT,
1152 TP_ATTRIBUTE1,
1153 TP_ATTRIBUTE2,
1154 TP_ATTRIBUTE3,
1155 TP_ATTRIBUTE4,
1156 TP_ATTRIBUTE5,
1157 TP_ATTRIBUTE6,
1158 TP_ATTRIBUTE7,
1159 TP_ATTRIBUTE8,
1160 TP_ATTRIBUTE9,
1161 TP_ATTRIBUTE10,
1162 TP_ATTRIBUTE11,
1163 TP_ATTRIBUTE12,
1164 TP_ATTRIBUTE13,
1165 TP_ATTRIBUTE14,
1166 TP_ATTRIBUTE15,
1167 FULFILLMENT_METHOD_CODE,
1168 SERVICE_REFERENCE_TYPE_CODE,
1169 SERVICE_REFERENCE_LINE_ID,
1170 SERVICE_REFERENCE_SYSTEM_ID,
1171 INVOICE_INTERFACE_STATUS_CODE,
1172 ORDERED_ITEM,
1173 ORDERED_ITEM_ID,
1174 SERVICE_NUMBER,
1175 NULL, -- SERVICED_LINE_ID,
1176 SERVICE_DURATION,
1177 SERVICE_START_DATE,
1178 RE_SOURCE_FLAG,
1179 OE_VERSION_HISTORY_UTIL.get_status(line_id,flow_status_code),-- bug 9503990 FLOW_STATUS_CODE,
1180 SERVICE_END_DATE,
1181 SERVICE_COTERMINATE_FLAG,
1182 SHIPPABLE_FLAG,
1183 ORDER_SOURCE_ID,
1184 ORIG_SYS_SHIPMENT_REF,
1185 CHANGE_SEQUENCE,
1186 DROP_SHIP_FLAG,
1187 CUSTOMER_LINE_NUMBER,
1188 CUSTOMER_SHIPMENT_NUMBER,
1189 CUSTOMER_ITEM_NET_PRICE,
1190 CUSTOMER_PAYMENT_TERM_ID,
1191 FIRST_ACK_DATE,
1192 FIRST_ACK_CODE,
1193 LAST_ACK_CODE,
1194 LAST_ACK_DATE,
1195 PLANNING_PRIORITY,
1196 SERVICE_TXN_COMMENTS,
1197 SERVICE_PERIOD,
1198 UNIT_SELLING_PERCENT,
1199 UNIT_LIST_PERCENT,
1200 UNIT_PERCENT_BASE_PRICE,
1201 MODEL_REMNANT_FLAG,
1202 SERVICE_TXN_REASON_CODE,
1203 CALCULATE_PRICE_FLAG,
1204 NULL, -- ITEM_INPUT,
1205 NULL, -- CUSTOMER_ITEM_ID,
1206 NULL, -- CUSTOMER_ITEM_REVISION,
1207 NULL, -- ITEM_ID ?? check the source
1208 NULL, -- INVOICE_COMPLETE_FLAG ?? check the source
1209 END_ITEM_UNIT_NUMBER,
1210 FULFILLED_FLAG,
1211 CONFIG_HEADER_ID,
1212 CONFIG_REV_NBR,
1213 SHIPPING_INSTRUCTIONS,
1214 PACKING_INSTRUCTIONS,
1215 INVOICED_QUANTITY,
1216 REFERENCE_CUSTOMER_TRX_LINE_ID,
1217 SPLIT_BY,
1218 LINE_SET_ID,
1219 REVENUE_AMOUNT,
1220 FULFILLMENT_DATE,
1221 PREFERRED_GRADE,
1222 ORDERED_QUANTITY2,
1223 ORDERED_QUANTITY_UOM2,
1224 SHIPPED_QUANTITY2,
1225 CANCELLED_QUANTITY2,
1226 SHIPPING_QUANTITY2,
1227 SHIPPING_QUANTITY_UOM2,
1228 FULFILLED_QUANTITY2,
1229 SUBINVENTORY,
1230 nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID
1231 UNIT_LIST_PRICE_PER_PQTY,
1232 UNIT_SELLING_PRICE_PER_PQTY,
1233 NULL, -- LATEST_CANCELLED_QUANTITY
1234 PRICE_REQUEST_CODE,
1235 LATE_DEMAND_PENALTY_FACTOR,
1236 OVERRIDE_ATP_DATE_CODE,
1237 ITEM_SUBSTITUTION_TYPE_CODE,
1238 ORIGINAL_ITEM_IDENTIFIER_TYPE,
1239 ORIGINAL_ORDERED_ITEM,
1240 ORIGINAL_ORDERED_ITEM_ID,
1241 ORIGINAL_INVENTORY_ITEM_ID,
1242 ACCOUNTING_RULE_DURATION,
1243 ATTRIBUTE16,
1244 ATTRIBUTE17,
1245 ATTRIBUTE18,
1246 ATTRIBUTE19,
1247 ATTRIBUTE20,
1248 USER_ITEM_DESCRIPTION,
1249 ITEM_RELATIONSHIP_TYPE,
1250 BLANKET_NUMBER,
1251 BLANKET_LINE_NUMBER,
1252 BLANKET_VERSION_NUMBER,
1253 l_version_number, -- VERSION_NUMBER,
1254 SALES_DOCUMENT_TYPE_CODE,
1255 'N', -- AUDIT_FLAG
1256 l_version_flag, -- VERSION_FLAG
1257 p_phase_change_flag, --PHASE_CHANGE_FLAG,
1258 TRANSACTION_PHASE_CODE,
1259 SOURCE_DOCUMENT_VERSION_NUMBER,
1260 --key Transaction Dates
1261 order_firmed_date,
1262 CHARGE_PERIODICITY_CODE,
1263 actual_fulfillment_date,
1264 -- sol_ord_er #16014165
1265 SERVICE_BILL_PROFILE_ID,
1266 SERVICE_COV_TEMPLATE_ID,
1267 SERVICE_SUBS_TEMPLATE_ID,
1268 SERVICE_BILL_OPTION_CODE,
1269 SERVICE_FIRST_PERIOD_AMOUNT,
1270 SUBSCRIPTION_ENABLE_FLAG,
1271 SERVICE_FIRST_PERIOD_ENDDATE
1272 FROM OE_ORDER_LINES_ALL a
1273 WHERE header_id = p_header_id
1274 AND NOT EXISTS (select b.line_id
1275 FROM oe_order_lines_history b
1276 WHERE a.line_id = b.line_id
1277 AND a.header_id = b.header_id
1278 AND b.version_number = l_version_number
1279 AND b.version_flag = l_version_flag);
1280 IF l_debug_level > 0 THEN
1281 oe_debug_pub.add(' No. of History Records for Lines ' ||SQL%ROWCOUNT);
1282 END IF;
1283
1284 -- Create History Records for Adjustments
1285 l_api_name := 'Create_Price_Adjs_History';
1286
1287 INSERT INTO OE_PRICE_ADJS_HISTORY(
1288 PRICE_ADJUSTMENT_ID,
1289 HEADER_ID,
1290 HIST_CREATION_DATE,
1291 CREATION_DATE,
1292 CREATED_BY,
1293 LAST_UPDATE_DATE,
1294 LAST_UPDATED_BY,
1295 LAST_UPDATE_LOGIN,
1296 PROGRAM_APPLICATION_ID,
1297 PROGRAM_ID,
1298 PROGRAM_UPDATE_DATE,
1299 REQUEST_ID,
1300 DISCOUNT_ID,
1301 DISCOUNT_LINE_ID,
1302 AUTOMATIC_FLAG,
1303 PERCENT,
1304 LINE_ID,
1305 CONTEXT,
1306 ATTRIBUTE1,
1307 ATTRIBUTE2,
1308 ATTRIBUTE3,
1309 ATTRIBUTE4,
1310 ATTRIBUTE5,
1311 ATTRIBUTE6,
1312 ATTRIBUTE7,
1313 ATTRIBUTE8,
1314 ATTRIBUTE9,
1315 ATTRIBUTE10,
1316 ATTRIBUTE11,
1317 ATTRIBUTE12,
1318 ATTRIBUTE13,
1319 ATTRIBUTE14,
1320 ATTRIBUTE15,
1321 ORIG_SYS_DISCOUNT_REF,
1322 CHANGE_SEQUENCE,
1323 LIST_HEADER_ID,
1324 LIST_LINE_ID,
1325 LIST_LINE_TYPE_CODE,
1326 MODIFIED_FROM,
1327 MODIFIED_TO,
1328 UPDATE_ALLOWED,
1329 CHANGE_REASON_CODE,
1330 CHANGE_REASON_TEXT,
1331 MODIFIER_MECHANISM_TYPE_CODE,
1332 UPDATED_FLAG,
1333 APPLIED_FLAG,
1334 OPERAND,
1335 ARITHMETIC_OPERATOR,
1336 COST_ID,
1337 TAX_CODE,
1338 TAX_EXEMPT_FLAG,
1339 TAX_EXEMPT_NUMBER,
1340 TAX_EXEMPT_REASON_CODE,
1341 PARENT_ADJUSTMENT_ID,
1342 INVOICED_FLAG,
1343 ESTIMATED_FLAG,
1344 INC_IN_SALES_PERFORMANCE,
1345 SPLIT_ACTION_CODE,
1346 ADJUSTED_AMOUNT,
1347 PRICING_PHASE_ID,
1348 CHARGE_TYPE_CODE,
1349 CHARGE_SUBTYPE_CODE,
1350 RANGE_BREAK_QUANTITY,
1351 ACCRUAL_CONVERSION_RATE,
1352 PRICING_GROUP_SEQUENCE,
1353 ACCRUAL_FLAG,
1354 LIST_LINE_NO,
1355 SOURCE_SYSTEM_CODE,
1356 BENEFIT_QTY,
1357 BENEFIT_UOM_CODE,
1358 PRINT_ON_INVOICE_FLAG,
1359 EXPIRATION_DATE,
1360 REBATE_TRANSACTION_TYPE_CODE,
1361 REBATE_TRANSACTION_REFERENCE,
1362 REBATE_PAYMENT_SYSTEM_CODE,
1363 REDEEMED_DATE,
1364 REDEEMED_FLAG,
1365 MODIFIER_LEVEL_CODE,
1366 PRICE_BREAK_TYPE_CODE,
1367 SUBSTITUTION_ATTRIBUTE,
1368 PRORATION_TYPE_CODE,
1369 INCLUDE_ON_RETURNS_FLAG,
1370 CREDIT_OR_CHARGE_FLAG,
1371 AC_CONTEXT,
1372 AC_ATTRIBUTE1,
1373 AC_ATTRIBUTE2,
1374 AC_ATTRIBUTE3,
1375 AC_ATTRIBUTE4,
1376 AC_ATTRIBUTE5,
1377 AC_ATTRIBUTE6,
1378 AC_ATTRIBUTE7,
1379 AC_ATTRIBUTE8,
1380 AC_ATTRIBUTE9,
1381 AC_ATTRIBUTE10,
1382 AC_ATTRIBUTE11,
1383 AC_ATTRIBUTE12,
1384 AC_ATTRIBUTE13,
1385 AC_ATTRIBUTE14,
1386 AC_ATTRIBUTE15,
1387 LOCK_CONTROL,
1388 HIST_TYPE_CODE,
1389 HIST_CREATED_BY,
1390 RESPONSIBILITY_ID,
1391 VERSION_NUMBER,
1392 AUDIT_FLAG,
1393 VERSION_FLAG,
1394 PHASE_CHANGE_FLAG
1395 )
1396 SELECT
1397 PRICE_ADJUSTMENT_ID,
1398 HEADER_ID,
1399 sysdate,
1400 CREATION_DATE,
1401 CREATED_BY,
1402 LAST_UPDATE_DATE,
1403 LAST_UPDATED_BY,
1404 LAST_UPDATE_LOGIN,
1405 PROGRAM_APPLICATION_ID,
1406 PROGRAM_ID,
1407 PROGRAM_UPDATE_DATE,
1408 REQUEST_ID,
1409 DISCOUNT_ID,
1410 DISCOUNT_LINE_ID,
1411 AUTOMATIC_FLAG,
1412 PERCENT,
1413 LINE_ID,
1414 CONTEXT,
1415 ATTRIBUTE1,
1416 ATTRIBUTE2,
1417 ATTRIBUTE3,
1418 ATTRIBUTE4,
1419 ATTRIBUTE5,
1420 ATTRIBUTE6,
1421 ATTRIBUTE7,
1422 ATTRIBUTE8,
1423 ATTRIBUTE9,
1424 ATTRIBUTE10,
1425 ATTRIBUTE11,
1426 ATTRIBUTE12,
1427 ATTRIBUTE13,
1428 ATTRIBUTE14,
1429 ATTRIBUTE15,
1430 ORIG_SYS_DISCOUNT_REF,
1431 CHANGE_SEQUENCE,
1432 LIST_HEADER_ID,
1433 LIST_LINE_ID,
1434 LIST_LINE_TYPE_CODE,
1435 MODIFIED_FROM,
1436 MODIFIED_TO,
1437 UPDATE_ALLOWED,
1438 CHANGE_REASON_CODE,
1439 CHANGE_REASON_TEXT,
1440 MODIFIER_MECHANISM_TYPE_CODE,
1441 UPDATED_FLAG,
1442 APPLIED_FLAG,
1443 OPERAND,
1444 ARITHMETIC_OPERATOR,
1445 COST_ID,
1446 TAX_CODE,
1447 TAX_EXEMPT_FLAG,
1448 TAX_EXEMPT_NUMBER,
1449 TAX_EXEMPT_REASON_CODE,
1450 PARENT_ADJUSTMENT_ID,
1451 INVOICED_FLAG,
1452 ESTIMATED_FLAG,
1453 INC_IN_SALES_PERFORMANCE,
1454 SPLIT_ACTION_CODE,
1455 ADJUSTED_AMOUNT,
1456 PRICING_PHASE_ID,
1457 CHARGE_TYPE_CODE,
1458 CHARGE_SUBTYPE_CODE,
1459 RANGE_BREAK_QUANTITY,
1460 ACCRUAL_CONVERSION_RATE,
1461 PRICING_GROUP_SEQUENCE,
1462 ACCRUAL_FLAG,
1463 LIST_LINE_NO,
1464 SOURCE_SYSTEM_CODE,
1465 BENEFIT_QTY,
1466 BENEFIT_UOM_CODE,
1467 PRINT_ON_INVOICE_FLAG,
1468 EXPIRATION_DATE,
1469 REBATE_TRANSACTION_TYPE_CODE,
1470 REBATE_TRANSACTION_REFERENCE,
1471 REBATE_PAYMENT_SYSTEM_CODE,
1472 REDEEMED_DATE,
1473 REDEEMED_FLAG,
1474 MODIFIER_LEVEL_CODE,
1475 PRICE_BREAK_TYPE_CODE,
1476 SUBSTITUTION_ATTRIBUTE,
1477 PRORATION_TYPE_CODE,
1478 INCLUDE_ON_RETURNS_FLAG,
1479 CREDIT_OR_CHARGE_FLAG,
1480 AC_CONTEXT,
1481 AC_ATTRIBUTE1,
1482 AC_ATTRIBUTE2,
1483 AC_ATTRIBUTE3,
1484 AC_ATTRIBUTE4,
1485 AC_ATTRIBUTE5,
1486 AC_ATTRIBUTE6,
1487 AC_ATTRIBUTE7,
1488 AC_ATTRIBUTE8,
1489 AC_ATTRIBUTE9,
1490 AC_ATTRIBUTE10,
1491 AC_ATTRIBUTE11,
1492 AC_ATTRIBUTE12,
1493 AC_ATTRIBUTE13,
1494 AC_ATTRIBUTE14,
1495 AC_ATTRIBUTE15,
1496 LOCK_CONTROL,
1497 NULL, --HIST_TYPE_CODE,
1498 nvl(FND_GLOBAL.USER_ID, -1), --HIST_CREATED_BY,
1499 nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID,
1500 l_version_number, --VERSION_NUMBER,
1501 'N', --AUDIT_FLAG,
1502 l_version_flag, --VERSION_FLAG,
1503 p_phase_change_flag --PHASE_CHANGE_FLAG
1504 FROM OE_PRICE_ADJUSTMENTS a
1505 WHERE a.header_id = p_header_id
1506 AND NOT EXISTS ( SELECT price_adjustment_id
1507 FROM OE_PRICE_ADJS_HISTORY b
1508 WHERE b.price_adjustment_id = a.price_adjustment_id
1509 AND a.header_id = b.header_id
1510 AND b.version_number = l_version_number
1511 AND b.version_flag = l_version_flag);
1512
1513 IF l_debug_level > 0 THEN
1514 oe_debug_pub.add(' No. of History Records for PrcAdjs ' ||SQL%ROWCOUNT);
1515 END IF;
1516
1517 -- Create History Records for SalesCredits
1518 l_api_name := 'Create_Sales_Credits_History';
1519
1520 INSERT INTO OE_SALES_CREDIT_HISTORY (
1521 SALES_CREDIT_ID,
1522 HEADER_ID,
1523 HIST_CREATION_DATE,
1524 CREATION_DATE,
1525 CREATED_BY,
1526 LAST_UPDATE_DATE,
1527 LAST_UPDATED_BY,
1528 LAST_UPDATE_LOGIN,
1529 SALESREP_ID,
1530 PERCENT,
1531 LINE_ID,
1532 CONTEXT,
1533 ATTRIBUTE1,
1534 ATTRIBUTE2,
1535 ATTRIBUTE3,
1536 ATTRIBUTE4,
1537 ATTRIBUTE5,
1538 ATTRIBUTE6,
1539 ATTRIBUTE7,
1540 ATTRIBUTE8,
1541 ATTRIBUTE9,
1542 ATTRIBUTE10,
1543 ATTRIBUTE11,
1544 ATTRIBUTE12,
1545 ATTRIBUTE13,
1546 ATTRIBUTE14,
1547 ATTRIBUTE15,
1548 DW_UPDATE_ADVICE_FLAG,
1549 WH_UPDATE_DATE,
1550 ORIG_SYS_CREDIT_REF,
1551 SALES_CREDIT_TYPE_ID,
1552 LOCK_CONTROL,
1553 REASON_CODE,
1554 HIST_COMMENTS,
1555 HIST_TYPE_CODE,
1556 HIST_CREATED_BY,
1557 RESPONSIBILITY_ID,
1558 VERSION_NUMBER,
1559 AUDIT_FLAG,
1560 VERSION_FLAG,
1561 PHASE_CHANGE_FLAG
1562 )
1563 SELECT
1564 SALES_CREDIT_ID,
1565 HEADER_ID,
1566 sysdate,
1567 CREATION_DATE,
1568 CREATED_BY,
1569 LAST_UPDATE_DATE,
1570 LAST_UPDATED_BY,
1571 LAST_UPDATE_LOGIN,
1572 SALESREP_ID,
1573 PERCENT,
1574 LINE_ID,
1575 CONTEXT,
1576 ATTRIBUTE1,
1577 ATTRIBUTE2,
1578 ATTRIBUTE3,
1579 ATTRIBUTE4,
1580 ATTRIBUTE5,
1581 ATTRIBUTE6,
1582 ATTRIBUTE7,
1583 ATTRIBUTE8,
1584 ATTRIBUTE9,
1585 ATTRIBUTE10,
1586 ATTRIBUTE11,
1587 ATTRIBUTE12,
1588 ATTRIBUTE13,
1589 ATTRIBUTE14,
1590 ATTRIBUTE15,
1591 DW_UPDATE_ADVICE_FLAG,
1592 WH_UPDATE_DATE,
1593 ORIG_SYS_CREDIT_REF,
1594 SALES_CREDIT_TYPE_ID,
1595 LOCK_CONTROL,
1596 NULL, --REASON_CODE,
1597 NULL, --HIST_COMMENTS,
1598 NULL, --HIST_TYPE_CODE,
1599 nvl(FND_GLOBAL.USER_ID, -1), --HIST_CREATED_BY,
1600 nvl(FND_GLOBAL.RESP_ID, -1), --RESPONSIBILITY_ID,
1601 l_version_number, --VERSION_NUMBER,
1602 'N', --AUDIT_FLAG,
1603 l_version_flag, --VERSION_FLAG,
1604 p_phase_change_flag --PHASE_CHANGE_FLAG,
1605 FROM oe_sales_credits a
1606 WHERE a.header_id = p_header_id
1607 AND NOT EXISTS ( SELECT b.SALES_CREDIT_ID
1608 FROM OE_SALES_CREDIT_HISTORY b
1609 WHERE b.SALES_CREDIT_ID = a.SALES_CREDIT_ID
1610 AND a.header_id = b.header_id
1611 AND b.VERSION_NUMBER = l_version_number
1612 AND b.version_flag = l_version_flag);
1613
1614 IF l_debug_level > 0 THEN
1615 oe_debug_pub.add(' No. of History Records for Sales Credits '||SQL%ROWCOUNT);
1616 END IF;
1617
1618 EXCEPTION
1619 WHEN OTHERS THEN
1620
1621 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1622 THEN
1623 OE_MSG_PUB.Add_Exc_Msg
1624 ( G_PKG_NAME
1625 , l_api_name
1626 );
1627 END IF;
1628 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629
1630 END Create_Version_History;
1631
1632
1633 Function Get_Version_Number
1634 (p_header_id IN NUMBER := NULL,
1635 p_line_id IN NUMBER := NULL,
1636 p_price_adjustment_id IN NUMBER := NULL,
1637 p_sales_credit_id IN NUMBER := NULL) RETURN NUMBER
1638 IS
1639
1640 l_current_version_number NUMBER := NULL;
1641 BEGIN
1642
1643 IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
1644
1645 BEGIN
1646 SELECT h.version_number INTO l_current_version_number
1647 FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJUSTMENTS p
1648 WHERE h.header_id = p.header_id
1649 AND p.price_adjustment_id = p_price_adjustment_id;
1650 EXCEPTION WHEN NO_DATA_FOUND THEN
1651 SELECT h.version_number INTO l_current_version_number
1652 FROM OE_ORDER_HEADERS_ALL h, OE_PRICE_ADJS_HISTORY p
1653 WHERE h.header_id = p.header_id
1654 AND p.price_adjustment_id = p_price_adjustment_id
1655 AND rownum = 1;
1656 END;
1657
1658 ELSIF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1659
1660 BEGIN
1661 SELECT h.version_number INTO l_current_version_number
1662 FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDITS s
1663 WHERE h.header_id = s.header_id
1664 AND s.sales_credit_id = p_sales_credit_id;
1665 EXCEPTION WHEN NO_DATA_FOUND THEN
1666 SELECT h.version_number INTO l_current_version_number
1667 FROM OE_ORDER_HEADERS_ALL h, OE_SALES_CREDIT_HISTORY s
1668 WHERE h.header_id = s.header_id
1669 AND s.sales_credit_id = p_sales_credit_id
1670 AND rownum = 1;
1671 END;
1672 ELSIF p_line_id <> FND_API.G_MISS_NUM THEN
1673
1674 BEGIN
1675 SELECT h.version_number INTO l_current_version_number
1676 FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l
1677 WHERE h.header_id = l.header_id
1678 AND l.line_id = p_line_id;
1679 EXCEPTION WHEN NO_DATA_FOUND THEN
1680 SELECT h.version_number INTO l_current_version_number
1681 FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_HISTORY l
1682 WHERE h.header_id = l.header_id
1683 AND l.line_id = p_line_id
1684 AND rownum = 1;
1685 END;
1686
1687 ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
1688
1689 SELECT version_number INTO l_current_version_number
1690 FROM OE_ORDER_HEADERS_ALL WHERE header_id = p_header_id;
1691
1692 END IF;
1693
1694 RETURN l_current_version_number;
1695
1696 EXCEPTION
1697 WHEN OTHERS THEN
1698 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1699 OE_MSG_PUB.Add_Exc_Msg
1700 ( G_PKG_NAME
1701 , 'Get_Version_Number'
1702 );
1703 END IF;
1704 END Get_Version_Number;
1705
1706 -- Moving Query_Rows from Versioning Util to Version History Util
1707 -- to reduce overall size of Versioning Util
1708
1709 Procedure Get_Transaction_Version(
1710 p_header_id IN NUMBER,
1711 p_version_number IN NUMBER := NULL,
1712 p_phase_change_flag IN VARCHAR2 := NULL,
1713 x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
1714 x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
1715 x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
1716 x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
1717 x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
1718 x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
1719 x_return_status OUT NOCOPY VARCHAR2)
1720 IS
1721 l_version_number NUMBER := p_version_number;
1722 l_current_version_number NUMBER;
1723
1724 BEGIN
1725
1726 IF p_version_number IS NOT NULL THEN
1727 l_current_version_number := Get_Version_Number(p_header_id => p_header_id);
1728
1729 IF l_version_number >= l_current_version_number THEN
1730 l_version_number := NULL;
1731 END IF;
1732 END IF;
1733
1734 G_INTERNAL_QUERY := TRUE;
1735
1736 Query_Row(p_header_id => p_header_id,
1737 p_version_number => l_version_number,
1738 p_phase_change_flag => p_phase_change_flag,
1739 x_header_rec => x_header_rec);
1740
1741 Query_Rows(p_header_id => p_header_id,
1742 p_version_number => l_version_number,
1743 p_phase_change_flag => p_phase_change_flag,
1744 x_header_adj_tbl => x_header_adj_tbl);
1745
1746 Query_Rows(p_header_id => p_header_id,
1747 p_version_number => l_version_number,
1748 p_phase_change_flag => p_phase_change_flag,
1749 x_header_scredit_tbl => x_header_scredit_tbl);
1750
1751 Query_Rows(p_header_id => p_header_id,
1752 p_version_number => l_version_number,
1753 p_phase_change_flag => p_phase_change_flag,
1754 x_line_tbl => x_line_tbl);
1755
1756 Query_Rows(p_header_id => p_header_id,
1757 p_version_number => l_version_number,
1758 p_phase_change_flag => p_phase_change_flag,
1759 x_line_adj_tbl => x_line_adj_tbl);
1760
1761 Query_Rows(p_header_id => p_header_id,
1762 p_version_number => l_version_number,
1763 p_phase_change_flag => p_phase_change_flag,
1764 x_line_scredit_tbl => x_line_scredit_tbl);
1765
1766 G_INTERNAL_QUERY := FALSE;
1767
1768 EXCEPTION
1769 WHEN NO_DATA_FOUND THEN
1770 G_INTERNAL_QUERY := FALSE;
1771 RAISE FND_API.G_EXC_ERROR;
1772
1773 WHEN OTHERS THEN
1774 G_INTERNAL_QUERY := FALSE;
1775
1776 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1777 OE_MSG_PUB.Add_Exc_Msg
1778 ( G_PKG_NAME
1779 , 'Get_Transaction_Version'
1780 );
1781 END IF;
1782 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783 END Get_Transaction_Version;
1784
1785 -- Query_Rows with version_number to query from history tables
1786 -- Header Query_Row
1787 PROCEDURE Query_Row
1788 ( p_header_id IN NUMBER,
1789 p_version_number IN NUMBER := NULL,
1790 p_phase_change_flag IN VARCHAR2 := NULL,
1791 x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
1792 )
1793 IS
1794 l_version_number NUMBER := p_version_number;
1795 l_current_version_number NUMBER;
1796 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1797
1798 BEGIN
1799 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
1800 l_current_version_number := Get_Version_Number(p_header_id => p_header_id);
1801
1802 IF l_version_number >= l_current_version_number THEN
1803 l_version_number := NULL;
1804 END IF;
1805 END IF;
1806
1807 IF l_version_number IS NULL THEN
1808 OE_Header_Util.Query_Row(p_header_id => p_header_id, x_header_rec => x_header_rec);
1809 ELSE
1810
1811 oe_debug_pub.add('Entering OE_VERSIONING_UTIL.QUERY_ROW for header', 1);
1812
1813 SELECT ACCOUNTING_RULE_ID
1814 , ACCOUNTING_RULE_DURATION
1815 , AGREEMENT_ID
1816 , ATTRIBUTE1
1817 , ATTRIBUTE10
1818 , ATTRIBUTE11
1819 , ATTRIBUTE12
1820 , ATTRIBUTE13
1821 , ATTRIBUTE14
1822 , ATTRIBUTE15
1823 , ATTRIBUTE16 --For bug 2184255
1824 , ATTRIBUTE17
1825 , ATTRIBUTE18
1826 , ATTRIBUTE19
1827 , ATTRIBUTE2
1828 , ATTRIBUTE20
1829 , ATTRIBUTE3
1830 , ATTRIBUTE4
1831 , ATTRIBUTE5
1832 , ATTRIBUTE6
1833 , ATTRIBUTE7
1834 , ATTRIBUTE8
1835 , ATTRIBUTE9
1836 , BLANKET_NUMBER
1837 , BOOKED_FLAG
1838 , BOOKED_DATE
1839 , CANCELLED_FLAG
1840 , CONTEXT
1841 , CONVERSION_RATE
1842 , CONVERSION_RATE_DATE
1843 , CONVERSION_TYPE_CODE
1844 , CUSTOMER_PREFERENCE_SET_CODE
1845 , CREATED_BY
1846 , CREATION_DATE
1847 , CUST_PO_NUMBER
1848 , DELIVER_TO_CONTACT_ID
1849 , DELIVER_TO_ORG_ID
1850 , DEMAND_CLASS_CODE
1851 , FIRST_ACK_CODE
1852 , FIRST_ACK_DATE
1853 , EXPIRATION_DATE
1854 , EARLIEST_SCHEDULE_LIMIT
1855 , FOB_POINT_CODE
1856 , FREIGHT_CARRIER_CODE
1857 , FREIGHT_TERMS_CODE
1858 , GLOBAL_ATTRIBUTE1
1859 , GLOBAL_ATTRIBUTE10
1860 , GLOBAL_ATTRIBUTE11
1861 , GLOBAL_ATTRIBUTE12
1862 , GLOBAL_ATTRIBUTE13
1863 , GLOBAL_ATTRIBUTE14
1864 , GLOBAL_ATTRIBUTE15
1865 , GLOBAL_ATTRIBUTE16
1866 , GLOBAL_ATTRIBUTE17
1867 , GLOBAL_ATTRIBUTE18
1868 , GLOBAL_ATTRIBUTE19
1869 , GLOBAL_ATTRIBUTE2
1870 , GLOBAL_ATTRIBUTE20
1871 , GLOBAL_ATTRIBUTE3
1872 , GLOBAL_ATTRIBUTE4
1873 , GLOBAL_ATTRIBUTE5
1874 , GLOBAL_ATTRIBUTE6
1875 , GLOBAL_ATTRIBUTE7
1876 , GLOBAL_ATTRIBUTE8
1877 , GLOBAL_ATTRIBUTE9
1878 , GLOBAL_ATTRIBUTE_CATEGORY
1879 , HEADER_ID
1880 , INVOICE_TO_CONTACT_ID
1881 , INVOICE_TO_ORG_ID
1882 , INVOICING_RULE_ID
1883 , LAST_ACK_CODE
1884 , LAST_ACK_DATE
1885 , LAST_UPDATED_BY
1886 , LAST_UPDATE_DATE
1887 , LAST_UPDATE_LOGIN
1888 , LATEST_SCHEDULE_LIMIT
1889 , OPEN_FLAG
1890 , ORDERED_DATE
1891 , ORDER_DATE_TYPE_CODE
1892 , ORDER_NUMBER
1893 , ORDER_SOURCE_ID
1894 , ORDER_TYPE_ID
1895 , ORDER_CATEGORY_CODE
1896 , ORG_ID
1897 , ORIG_SYS_DOCUMENT_REF
1898 , PARTIAL_SHIPMENTS_ALLOWED
1899 , PAYMENT_TERM_ID
1900 , PRICE_LIST_ID
1901 , PRICE_REQUEST_CODE -- PROMOTIONS SEP/01
1902 , PRICING_DATE
1903 , PROGRAM_APPLICATION_ID
1904 , PROGRAM_ID
1905 , PROGRAM_UPDATE_DATE
1906 , REQUEST_DATE
1907 , REQUEST_ID
1908 , RETURN_REASON_CODE
1909 , SALESREP_ID
1910 , SALES_CHANNEL_CODe
1911 , SHIPMENT_PRIORITY_CODE
1912 , SHIPPING_METHOD_CODE
1913 , SHIP_FROM_ORG_ID
1914 , SHIP_TOLERANCE_ABOVE
1915 , SHIP_TOLERANCE_BELOW
1916 , SHIP_TO_CONTACT_ID
1917 , SHIP_TO_ORG_ID
1918 , SOLD_FROM_ORG_ID
1919 , SOLD_TO_CONTACT_ID
1920 , SOLD_TO_ORG_ID
1921 , SOLD_TO_PHONE_ID
1922 , SOURCE_DOCUMENT_ID
1923 , SOURCE_DOCUMENT_TYPE_ID
1924 , TAX_EXEMPT_FLAG
1925 , TAX_EXEMPT_NUMBER
1926 , TAX_EXEMPT_REASON_CODE
1927 , TAX_POINT_CODE
1928 , TRANSACTIONAL_CURR_CODE
1929 , VERSION_NUMBER
1930 , PAYMENT_TYPE_CODE
1931 , PAYMENT_AMOUNT
1932 , CHECK_NUMBER
1933 , CREDIT_CARD_CODE
1934 , CREDIT_CARD_HOLDER_NAME
1935 , CREDIT_CARD_NUMBER
1936 , CREDIT_CARD_EXPIRATION_DATE
1937 , CREDIT_CARD_APPROVAL_DATE
1938 , CREDIT_CARD_APPROVAL_CODE
1939 , SHIPPING_INSTRUCTIONS
1940 , PACKING_INSTRUCTIONS
1941 , FLOW_STATUS_CODE
1942 , MARKETING_SOURCE_CODE_ID
1943 , NULL --DEFAULT_FULFILLMENT_SET
1944 , NULL --FULFILLMENT_SET_NAME
1945 , NULL --LINE_SET_NAME
1946 , TP_ATTRIBUTE1
1947 , TP_ATTRIBUTE10
1948 , TP_ATTRIBUTE11
1949 , TP_ATTRIBUTE12
1950 , TP_ATTRIBUTE13
1951 , TP_ATTRIBUTE14
1952 , TP_ATTRIBUTE15
1953 , TP_ATTRIBUTE2
1954 , TP_ATTRIBUTE3
1955 , TP_ATTRIBUTE4
1956 , TP_ATTRIBUTE5
1957 , TP_ATTRIBUTE6
1958 , TP_ATTRIBUTE7
1959 , TP_ATTRIBUTE8
1960 , TP_ATTRIBUTE9
1961 , TP_CONTEXT
1962 , NULL --XML_MESSAGE_ID
1963 , upgraded_flag
1964 , LOCK_CONTROL
1965 , quote_date
1966 , quote_number
1967 , sales_document_name
1968 , transaction_phase_code
1969 , user_status_code
1970 , draft_submitted_flag
1971 , source_document_version_number
1972 , sold_to_site_use_id
1973 --key Transaction Dates
1974 , order_firmed_date
1975 INTO x_header_rec.accounting_rule_id
1976 , x_header_rec.accounting_rule_duration
1977 , x_header_rec.agreement_id
1978 , x_header_rec.attribute1
1979 , x_header_rec.attribute10
1980 , x_header_rec.attribute11
1981 , x_header_rec.attribute12
1982 , x_header_rec.attribute13
1983 , x_header_rec.attribute14
1984 , x_header_rec.attribute15
1985 , x_header_rec.attribute16 --For bug 2184255
1986 , x_header_rec.attribute17
1987 , x_header_rec.attribute18
1988 , x_header_rec.attribute19
1989 , x_header_rec.attribute2
1990 , x_header_rec.attribute20
1991 , x_header_rec.attribute3
1992 , x_header_rec.attribute4
1993 , x_header_rec.attribute5
1994 , x_header_rec.attribute6
1995 , x_header_rec.attribute7
1996 , x_header_rec.attribute8
1997 , x_header_rec.attribute9
1998 , x_header_rec.Blanket_Number
1999 , x_header_rec.booked_flag
2000 , x_header_rec.booked_date
2001 , x_header_rec.cancelled_flag
2002 , x_header_rec.context
2003 , x_header_rec.conversion_rate
2004 , x_header_rec.conversion_rate_date
2005 , x_header_rec.conversion_type_code
2006 , x_header_rec.CUSTOMER_PREFERENCE_SET_CODE
2007 , x_header_rec.created_by
2008 , x_header_rec.creation_date
2009 , x_header_rec.cust_po_number
2010 , x_header_rec.deliver_to_contact_id
2011 , x_header_rec.deliver_to_org_id
2012 , x_header_rec.demand_class_code
2013 , x_header_rec.first_ack_code
2014 , x_header_rec.first_ack_date
2015 , x_header_rec.expiration_date
2016 , x_header_rec.earliest_schedule_limit
2017 , x_header_rec.fob_point_code
2018 , x_header_rec.freight_carrier_code
2019 , x_header_rec.freight_terms_code
2020 , x_header_rec.global_attribute1
2021 , x_header_rec.global_attribute10
2022 , x_header_rec.global_attribute11
2023 , x_header_rec.global_attribute12
2024 , x_header_rec.global_attribute13
2025 , x_header_rec.global_attribute14
2026 , x_header_rec.global_attribute15
2027 , x_header_rec.global_attribute16
2028 , x_header_rec.global_attribute17
2029 , x_header_rec.global_attribute18
2030 , x_header_rec.global_attribute19
2031 , x_header_rec.global_attribute2
2032 , x_header_rec.global_attribute20
2033 , x_header_rec.global_attribute3
2034 , x_header_rec.global_attribute4
2035 , x_header_rec.global_attribute5
2036 , x_header_rec.global_attribute6
2037 , x_header_rec.global_attribute7
2038 , x_header_rec.global_attribute8
2039 , x_header_rec.global_attribute9
2040 , x_header_rec.global_attribute_category
2041 , x_header_rec.header_id
2042 , x_header_rec.invoice_to_contact_id
2043 , x_header_rec.invoice_to_org_id
2044 , x_header_rec.invoicing_rule_id
2045 , x_header_rec.last_ack_code
2046 , x_header_rec.last_ack_date
2047 , x_header_rec.last_updated_by
2048 , x_header_rec.last_update_date
2049 , x_header_rec.last_update_login
2050 , x_header_rec.latest_schedule_limit
2051 , x_header_rec.open_flag
2052 , x_header_rec.ordered_date
2053 , x_header_rec.order_date_type_code
2054 , x_header_rec.order_number
2055 , x_header_rec.order_source_id
2056 , x_header_rec.order_type_id
2057 , x_header_rec.order_category_code
2058 , x_header_rec.org_id
2059 , x_header_rec.orig_sys_document_ref
2060 , x_header_rec.partial_shipments_allowed
2061 , x_header_rec.payment_term_id
2062 , x_header_rec.price_list_id
2063 , x_header_rec.price_request_code -- PROMOTIONS SEP/01
2064 , x_header_rec.pricing_date
2065 , x_header_rec.program_application_id
2066 , x_header_rec.program_id
2067 , x_header_rec.program_update_date
2068 , x_header_rec.request_date
2069 , x_header_rec.request_id
2070 , x_header_rec.return_reason_code
2071 , x_header_rec.salesrep_id
2072 , x_header_rec.sales_channel_code
2073 , x_header_rec.shipment_priority_code
2074 , x_header_rec.shipping_method_code
2075 , x_header_rec.ship_from_org_id
2076 , x_header_rec.ship_tolerance_above
2077 , x_header_rec.ship_tolerance_below
2078 , x_header_rec.ship_to_contact_id
2079 , x_header_rec.ship_to_org_id
2080 , x_header_rec.sold_from_org_id
2081 , x_header_rec.sold_to_contact_id
2082 , x_header_rec.sold_to_org_id
2083 , x_header_rec.sold_to_phone_id
2084 , x_header_rec.source_document_id
2085 , x_header_rec.source_document_type_id
2086 , x_header_rec.tax_exempt_flag
2087 , x_header_rec.tax_exempt_number
2088 , x_header_rec.tax_exempt_reason_code
2089 , x_header_rec.tax_point_code
2090 , x_header_rec.transactional_curr_code
2091 , x_header_rec.version_number
2092 , x_header_rec.payment_type_code
2093 , x_header_rec.payment_amount
2094 , x_header_rec.check_number
2095 , x_header_rec.credit_card_code
2096 , x_header_rec.credit_card_holder_name
2097 , x_header_rec.credit_card_number
2098 , x_header_rec.credit_card_expiration_date
2099 , x_header_rec.credit_card_approval_date
2100 , x_header_rec.credit_card_approval_code
2101 , x_header_rec.shipping_instructions
2102 , x_header_rec.packing_instructions
2103 , x_header_rec.flow_status_code
2104 , x_header_rec.marketing_source_code_id
2105 , x_header_rec.default_fulfillment_set
2106 , x_header_rec.fulfillment_set_name
2107 , x_header_rec.line_set_name
2108 , x_header_rec.tp_attribute1
2109 , x_header_rec.tp_attribute10
2110 , x_header_rec.tp_attribute11
2111 , x_header_rec.tp_attribute12
2112 , x_header_rec.tp_attribute13
2113 , x_header_rec.tp_attribute14
2114 , x_header_rec.tp_attribute15
2115 , x_header_rec.tp_attribute2
2116 , x_header_rec.tp_attribute3
2117 , x_header_rec.tp_attribute4
2118 , x_header_rec.tp_attribute5
2119 , x_header_rec.tp_attribute6
2120 , x_header_rec.tp_attribute7
2121 , x_header_rec.tp_attribute8
2122 , x_header_rec.tp_attribute9
2123 , x_header_rec.tp_context
2124 , x_header_rec.xml_message_id
2125 , x_header_rec.upgraded_flag
2126 , x_header_rec.lock_control
2127 , x_header_rec.quote_date
2128 , x_header_rec.quote_number
2129 , x_header_rec.sales_document_name
2130 , x_header_rec.transaction_phase_code
2131 , x_header_rec.user_status_code
2132 , x_header_rec.draft_submitted_flag
2133 , x_header_rec.source_document_version_number
2134 , x_header_rec.sold_to_site_use_id
2135 --key Transaction Dates
2136 , x_header_rec.order_firmed_date
2137 FROM OE_ORDER_HEADER_HISTORY
2138 WHERE HEADER_ID = p_header_id
2139 AND VERSION_NUMBER = l_version_number
2140 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2141 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
2142 AND VERSION_FLAG = 'Y'));
2143 END IF;
2144
2145 --R12 CC Encryption
2146 --Need to call query card details procedure to get the credit card
2147 --details as the OM tables would not have these values in R12
2148 IF x_header_rec.payment_type_code IS NOT NULL AND
2149 x_header_rec.payment_type_code = 'CREDIT_CARD'
2150 AND x_header_rec.credit_card_number is null THEN
2151 if l_debug_level > 0 then
2152 oe_debug_pub.add('Calling query card details...');
2153 end if;
2154 OE_Header_Util.Query_card_details
2155 ( p_header_id => x_header_rec.header_id,
2156 p_credit_card_code => x_header_rec.credit_card_code,
2157 p_credit_card_holder_name => x_header_rec.credit_card_holder_name,
2158 p_credit_card_number => x_header_rec.credit_card_number,
2159 p_credit_Card_expiration_date => x_header_rec.credit_card_expiration_date,
2160 p_credit_card_approval_code => x_header_rec.credit_card_approval_code,
2161 p_credit_card_approval_Date => x_header_rec.credit_card_approval_date,
2162 p_instrument_security_code => x_header_rec.instrument_security_code,
2163 p_instrument_id => x_header_rec.cc_instrument_id,
2164 p_instrument_assignment_id => x_header_rec.cc_instrument_assignment_id
2165 );
2166 END IF;
2167 --R12 CC Encryption
2168
2169 EXCEPTION
2170 WHEN OTHERS THEN
2171 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2172 OE_MSG_PUB.Add_Exc_Msg
2173 ( G_PKG_NAME
2174 , 'Header Query_Row'
2175 );
2176 END IF;
2177 END;
2178
2179 -- Header Adj Query_Row
2180 PROCEDURE Query_Row
2181 ( p_price_adjustment_id IN NUMBER
2182 , p_version_number IN NUMBER := NULL
2183 , p_phase_change_flag IN VARCHAR2 := NULL
2184 , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2185 )
2186 IS
2187 l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2188
2189 l_version_number NUMBER := p_version_number;
2190 l_current_version_number NUMBER;
2191 --
2192 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2193 --
2194 BEGIN
2195 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2196 l_current_version_number := Get_Version_Number(p_price_adjustment_id => p_price_adjustment_id);
2197
2198 IF l_version_number >= l_current_version_number THEN
2199 l_version_number := NULL;
2200 END IF;
2201 END IF;
2202
2203 IF l_version_number IS NULL THEN
2204 OE_Header_Adj_Util.Query_Row(p_price_adjustment_id => p_price_adjustment_id, x_header_adj_rec => x_header_adj_rec);
2205 ELSE
2206 IF l_debug_level > 0 THEN
2207 oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
2208 END IF;
2209
2210 G_INTERNAL_QUERY := TRUE;
2211 Query_Rows
2212 ( p_price_adjustment_id => p_price_adjustment_id
2213 , p_version_number => l_version_number
2214 , x_Header_Adj_Tbl => l_Header_Adj_Tbl
2215 );
2216 x_Header_Adj_Rec := l_Header_Adj_Tbl(1);
2217 G_INTERNAL_QUERY := FALSE;
2218
2219 IF l_debug_level > 0 THEN
2220 oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_UTIL.QUERY_ROW' , 1 ) ;
2221 END IF;
2222
2223 END IF;
2224
2225 EXCEPTION
2226 WHEN OTHERS THEN
2227 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2228 OE_MSG_PUB.Add_Exc_Msg
2229 ( G_PKG_NAME
2230 , 'Header Adj Query_Row'
2231 );
2232 END IF;
2233
2234 END;
2235
2236 -- Header Adj Query_Rows
2237 PROCEDURE Query_Rows
2238 ( p_price_adjustment_id IN NUMBER :=
2239 FND_API.G_MISS_NUM
2240 , p_header_id IN NUMBER :=
2241 FND_API.G_MISS_NUM
2242 , p_version_number IN NUMBER := NULL
2243 , p_phase_change_flag IN VARCHAR2 := NULL
2244 , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
2245 )
2246 IS
2247 l_count NUMBER;
2248 l_version_number NUMBER := p_version_number;
2249 l_current_version_number NUMBER;
2250
2251 CURSOR l_Header_Adj_csr_p IS
2252 SELECT ATTRIBUTE1
2253 , ATTRIBUTE10
2254 , ATTRIBUTE11
2255 , ATTRIBUTE12
2256 , ATTRIBUTE13
2257 , ATTRIBUTE14
2258 , ATTRIBUTE15
2259 , ATTRIBUTE2
2260 , ATTRIBUTE3
2261 , ATTRIBUTE4
2262 , ATTRIBUTE5
2263 , ATTRIBUTE6
2264 , ATTRIBUTE7
2265 , ATTRIBUTE8
2266 , ATTRIBUTE9
2267 , AUTOMATIC_FLAG
2268 , CONTEXT
2269 , CREATED_BY
2270 , CREATION_DATE
2271 , DISCOUNT_ID
2272 , DISCOUNT_LINE_ID
2273 , HEADER_ID
2274 , LAST_UPDATED_BY
2275 , LAST_UPDATE_DATE
2276 , LAST_UPDATE_LOGIN
2277 , LINE_ID
2278 , PERCENT
2279 , PRICE_ADJUSTMENT_ID
2280 , PROGRAM_APPLICATION_ID
2281 , PROGRAM_ID
2282 , PROGRAM_UPDATE_DATE
2283 , REQUEST_ID
2284 , LIST_HEADER_ID
2285 , LIST_LINE_ID
2286 , LIST_LINE_TYPE_CODE
2287 , MODIFIER_MECHANISM_TYPE_CODE
2288 , MODIFIED_FROM
2289 , MODIFIED_TO
2290 , UPDATED_FLAG
2291 , UPDATE_ALLOWED
2292 , APPLIED_FLAG
2293 , CHANGE_REASON_CODE
2294 , CHANGE_REASON_TEXT
2295 , operand
2296 , arithmetic_operator
2297 , COST_ID
2298 , TAX_CODE
2299 , TAX_EXEMPT_FLAG
2300 , TAX_EXEMPT_NUMBER
2301 , TAX_EXEMPT_REASON_CODE
2302 , PARENT_ADJUSTMENT_ID
2303 , INVOICED_FLAG
2304 , ESTIMATED_FLAG
2305 , INC_IN_SALES_PERFORMANCE
2306 , SPLIT_ACTION_CODE
2307 , ADJUSTED_AMOUNT
2308 , PRICING_PHASE_ID
2309 , CHARGE_TYPE_CODE
2310 , CHARGE_SUBTYPE_CODE
2311 , list_line_no
2312 , source_system_code
2313 , benefit_qty
2314 , benefit_uom_code
2315 , print_on_invoice_flag
2316 , expiration_date
2317 , rebate_transaction_type_code
2318 , rebate_transaction_reference
2319 , rebate_payment_system_code
2320 , redeemed_date
2321 , redeemed_flag
2322 , accrual_flag
2323 , range_break_quantity
2324 , accrual_conversion_rate
2325 , pricing_group_sequence
2326 , modifier_level_code
2327 , price_break_type_code
2328 , substitution_attribute
2329 , proration_type_code
2330 , CREDIT_OR_CHARGE_FLAG
2331 , INCLUDE_ON_RETURNS_FLAG
2332 , AC_ATTRIBUTE1
2333 , AC_ATTRIBUTE10
2334 , AC_ATTRIBUTE11
2335 , AC_ATTRIBUTE12
2336 , AC_ATTRIBUTE13
2337 , AC_ATTRIBUTE14
2338 , AC_ATTRIBUTE15
2339 , AC_ATTRIBUTE2
2340 , AC_ATTRIBUTE3
2341 , AC_ATTRIBUTE4
2342 , AC_ATTRIBUTE5
2343 , AC_ATTRIBUTE6
2344 , AC_ATTRIBUTE7
2345 , AC_ATTRIBUTE8
2346 , AC_ATTRIBUTE9
2347 , AC_CONTEXT
2348 --uom begin
2349 -- , OPERAND_PER_PQTY
2350 -- , ADJUSTED_AMOUNT_PER_PQTY
2351 --uom end
2352 , LOCK_CONTROL
2353 FROM OE_PRICE_ADJS_HISTORY
2354 WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
2355 AND VERSION_NUMBER = l_version_number
2356 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2357 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
2358 AND VERSION_FLAG = 'Y'));
2359
2360 CURSOR l_Header_Adj_csr_h IS
2361 SELECT ATTRIBUTE1
2362 , ATTRIBUTE10
2363 , ATTRIBUTE11
2364 , ATTRIBUTE12
2365 , ATTRIBUTE13
2366 , ATTRIBUTE14
2367 , ATTRIBUTE15
2368 , ATTRIBUTE2
2369 , ATTRIBUTE3
2370 , ATTRIBUTE4
2371 , ATTRIBUTE5
2372 , ATTRIBUTE6
2373 , ATTRIBUTE7
2374 , ATTRIBUTE8
2375 , ATTRIBUTE9
2376 , AUTOMATIC_FLAG
2377 , CONTEXT
2378 , CREATED_BY
2379 , CREATION_DATE
2380 , DISCOUNT_ID
2381 , DISCOUNT_LINE_ID
2382 , HEADER_ID
2383 , LAST_UPDATED_BY
2384 , LAST_UPDATE_DATE
2385 , LAST_UPDATE_LOGIN
2386 , LINE_ID
2387 , PERCENT
2388 , PRICE_ADJUSTMENT_ID
2389 , PROGRAM_APPLICATION_ID
2390 , PROGRAM_ID
2391 , PROGRAM_UPDATE_DATE
2392 , REQUEST_ID
2393 , LIST_HEADER_ID
2394 , LIST_LINE_ID
2395 , LIST_LINE_TYPE_CODE
2396 , MODIFIER_MECHANISM_TYPE_CODE
2397 , MODIFIED_FROM
2398 , MODIFIED_TO
2399 , UPDATED_FLAG
2400 , UPDATE_ALLOWED
2401 , APPLIED_FLAG
2402 , CHANGE_REASON_CODE
2403 , CHANGE_REASON_TEXT
2404 , operand
2405 , arithmetic_operator
2406 , COST_ID
2407 , TAX_CODE
2408 , TAX_EXEMPT_FLAG
2409 , TAX_EXEMPT_NUMBER
2410 , TAX_EXEMPT_REASON_CODE
2411 , PARENT_ADJUSTMENT_ID
2412 , INVOICED_FLAG
2413 , ESTIMATED_FLAG
2414 , INC_IN_SALES_PERFORMANCE
2415 , SPLIT_ACTION_CODE
2416 , ADJUSTED_AMOUNT
2417 , PRICING_PHASE_ID
2418 , CHARGE_TYPE_CODE
2419 , CHARGE_SUBTYPE_CODE
2420 , list_line_no
2421 , source_system_code
2422 , benefit_qty
2423 , benefit_uom_code
2424 , print_on_invoice_flag
2425 , expiration_date
2426 , rebate_transaction_type_code
2427 , rebate_transaction_reference
2428 , rebate_payment_system_code
2429 , redeemed_date
2430 , redeemed_flag
2431 , accrual_flag
2432 , range_break_quantity
2433 , accrual_conversion_rate
2434 , pricing_group_sequence
2435 , modifier_level_code
2436 , price_break_type_code
2437 , substitution_attribute
2438 , proration_type_code
2439 , CREDIT_OR_CHARGE_FLAG
2440 , INCLUDE_ON_RETURNS_FLAG
2441 , AC_ATTRIBUTE1
2442 , AC_ATTRIBUTE10
2443 , AC_ATTRIBUTE11
2444 , AC_ATTRIBUTE12
2445 , AC_ATTRIBUTE13
2446 , AC_ATTRIBUTE14
2447 , AC_ATTRIBUTE15
2448 , AC_ATTRIBUTE2
2449 , AC_ATTRIBUTE3
2450 , AC_ATTRIBUTE4
2451 , AC_ATTRIBUTE5
2452 , AC_ATTRIBUTE6
2453 , AC_ATTRIBUTE7
2454 , AC_ATTRIBUTE8
2455 , AC_ATTRIBUTE9
2456 , AC_CONTEXT
2457 --uom begin
2458 -- , OPERAND_PER_PQTY
2459 -- , ADJUSTED_AMOUNT_PER_PQTY
2460 --uom end
2461 , LOCK_CONTROL
2462 FROM OE_PRICE_ADJS_HISTORY
2463 WHERE HEADER_ID = p_header_id AND LINE_ID IS NULL
2464 AND VERSION_NUMBER = l_version_number
2465 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2466 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
2467 AND VERSION_FLAG = 'Y'));
2468
2469 l_rec l_header_adj_csr_p%ROWTYPE;
2470 l_entity NUMBER;
2471
2472 BEGIN
2473 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2474 l_current_version_number := Get_Version_Number(p_header_id => p_header_id, p_price_adjustment_id => p_price_adjustment_id);
2475
2476 IF l_version_number >= l_current_version_number THEN
2477 l_version_number := NULL;
2478 END IF;
2479 END IF;
2480
2481 IF l_version_number IS NULL THEN
2482 OE_Header_Adj_Util.Query_Rows(p_price_adjustment_id => p_price_adjustment_id, p_header_id => p_header_id, x_header_adj_tbl => x_header_adj_tbl);
2483 ELSE
2484
2485 IF
2486 (p_price_adjustment_id IS NOT NULL
2487 AND
2488 p_price_adjustment_id <> FND_API.G_MISS_NUM)
2489 AND
2490 (p_header_id IS NOT NULL
2491 AND
2492 p_header_id <> FND_API.G_MISS_NUM)
2493 THEN
2494
2495 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496
2497 END IF;
2498
2499 IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2500 l_entity := 1;
2501 OPEN l_header_adj_csr_p;
2502 ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2503 l_entity := 2;
2504 OPEN l_header_adj_csr_h;
2505 END IF;
2506
2507 -- Loop over fetched records
2508 l_count := 1;
2509 LOOP
2510 IF l_entity = 1 THEN
2511 FETCH l_header_adj_csr_p INTO l_rec;
2512 EXIT WHEN l_header_adj_csr_p%NOTFOUND;
2513 ELSIF l_entity = 2 THEN
2514 FETCH l_header_adj_csr_h INTO l_rec;
2515 EXIT WHEN l_header_adj_csr_h%NOTFOUND;
2516 ELSE
2517 EXIT;
2518 END IF;
2519
2520 x_Header_Adj_tbl(l_count).attribute1 := l_rec.ATTRIBUTE1;
2521 x_Header_Adj_tbl(l_count).attribute10 := l_rec.ATTRIBUTE10;
2522 x_Header_Adj_tbl(l_count).attribute11 := l_rec.ATTRIBUTE11;
2523 x_Header_Adj_tbl(l_count).attribute12 := l_rec.ATTRIBUTE12;
2524 x_Header_Adj_tbl(l_count).attribute13 := l_rec.ATTRIBUTE13;
2525 x_Header_Adj_tbl(l_count).attribute14 := l_rec.ATTRIBUTE14;
2526 x_Header_Adj_tbl(l_count).attribute15 := l_rec.ATTRIBUTE15;
2527 x_Header_Adj_tbl(l_count).attribute2 := l_rec.ATTRIBUTE2;
2528 x_Header_Adj_tbl(l_count).attribute3 := l_rec.ATTRIBUTE3;
2529 x_Header_Adj_tbl(l_count).attribute4 := l_rec.ATTRIBUTE4;
2530 x_Header_Adj_tbl(l_count).attribute5 := l_rec.ATTRIBUTE5;
2531 x_Header_Adj_tbl(l_count).attribute6 := l_rec.ATTRIBUTE6;
2532 x_Header_Adj_tbl(l_count).attribute7 := l_rec.ATTRIBUTE7;
2533 x_Header_Adj_tbl(l_count).attribute8 := l_rec.ATTRIBUTE8;
2534 x_Header_Adj_tbl(l_count).attribute9 := l_rec.ATTRIBUTE9;
2535 x_Header_Adj_tbl(l_count).automatic_flag := l_rec.AUTOMATIC_FLAG;
2536 x_Header_Adj_tbl(l_count).context := l_rec.CONTEXT;
2537 x_Header_Adj_tbl(l_count).created_by := l_rec.CREATED_BY;
2538 x_Header_Adj_tbl(l_count).creation_date := l_rec.CREATION_DATE;
2539 x_Header_Adj_tbl(l_count).discount_id := l_rec.DISCOUNT_ID;
2540 x_Header_Adj_tbl(l_count).discount_line_id := l_rec.DISCOUNT_LINE_ID;
2541 x_Header_Adj_tbl(l_count).header_id := l_rec.HEADER_ID;
2542 x_Header_Adj_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
2543 x_Header_Adj_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
2544 x_Header_Adj_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
2545 x_Header_Adj_tbl(l_count).line_id := l_rec.LINE_ID;
2546 x_Header_Adj_tbl(l_count).percent := l_rec.PERCENT;
2547 x_Header_Adj_tbl(l_count).price_adjustment_id := l_rec.PRICE_ADJUSTMENT_ID;
2548 x_Header_Adj_tbl(l_count).program_application_id := l_rec.PROGRAM_APPLICATION_ID;
2549 x_Header_Adj_tbl(l_count).program_id := l_rec.PROGRAM_ID;
2550 x_Header_Adj_tbl(l_count).program_update_date := l_rec.PROGRAM_UPDATE_DATE;
2551 x_Header_Adj_tbl(l_count).adjusted_amount := l_rec.adjusted_amount;
2552 x_Header_Adj_tbl(l_count).pricing_phase_id := l_rec.pricing_phase_id;
2553 x_Header_Adj_tbl(l_count).list_header_id := l_rec.list_header_id;
2554 x_Header_Adj_tbl(l_count).list_line_id := l_rec.list_line_id;
2555 x_Header_Adj_tbl(l_count).list_line_type_code := l_rec.list_line_type_code;
2556 x_Header_Adj_tbl(l_count).modifier_mechanism_type_code :=
2557 l_rec.modifier_mechanism_type_code;
2558 x_Header_Adj_tbl(l_count).modified_from := l_rec.modified_from;
2559 x_Header_Adj_tbl(l_count).modified_to := l_rec.modified_to;
2560 x_Header_Adj_tbl(l_count).updated_flag := l_rec.updated_flag;
2561 x_Header_Adj_tbl(l_count).update_allowed := l_rec.update_allowed;
2562 x_Header_Adj_tbl(l_count).applied_flag := l_rec.applied_flag;
2563 x_Header_Adj_tbl(l_count).change_reason_code := l_rec.change_reason_code;
2564 x_Header_Adj_tbl(l_count).change_reason_text := l_rec.change_reason_text;
2565 x_Header_Adj_tbl(l_count).operand := l_rec.operand;
2566 x_Header_Adj_tbl(l_count).arithmetic_operator := l_rec.arithmetic_operator;
2567
2568 x_Header_Adj_tbl(l_count).request_id := l_rec.REQUEST_ID;
2569
2570 x_Header_Adj_tbl(l_count).cost_id := l_rec.cost_id;
2571 x_Header_Adj_tbl(l_count).tax_code := l_rec.tax_code;
2572 x_Header_Adj_tbl(l_count).tax_exempt_flag := l_rec.tax_exempt_flag;
2573 x_Header_Adj_tbl(l_count).tax_exempt_number := l_rec.tax_exempt_number;
2574 x_Header_Adj_tbl(l_count).tax_exempt_reason_code := l_rec.tax_exempt_reason_code;
2575 x_Header_Adj_tbl(l_count).parent_adjustment_id := l_rec.parent_adjustment_id;
2576 x_Header_Adj_tbl(l_count).invoiced_flag := l_rec.invoiced_flag;
2577 x_Header_Adj_tbl(l_count).estimated_flag := l_rec.estimated_flag;
2578 x_Header_Adj_tbl(l_count).inc_in_sales_performance := l_rec.inc_in_sales_performance;
2579 x_Header_Adj_tbl(l_count).split_action_code := l_rec.split_action_code;
2580 x_Header_Adj_tbl(l_count).charge_type_code := l_rec.charge_type_code;
2581 x_Header_Adj_tbl(l_count).charge_subtype_code := l_rec.charge_subtype_code;
2582 x_Header_Adj_tbl(l_count).list_line_no := l_rec.list_line_no;
2583 x_Header_Adj_tbl(l_count).source_system_code := l_rec.source_system_code;
2584 x_Header_Adj_tbl(l_count).benefit_qty := l_rec.benefit_qty;
2585 x_Header_Adj_tbl(l_count).benefit_uom_code := l_rec.benefit_uom_code;
2586 x_Header_Adj_tbl(l_count).print_on_invoice_flag := l_rec.print_on_invoice_flag;
2587 x_Header_Adj_tbl(l_count).expiration_date := l_rec.expiration_date;
2588 x_Header_Adj_tbl(l_count).rebate_transaction_type_code := l_rec.rebate_transaction_type_code;
2589 x_Header_Adj_tbl(l_count).rebate_transaction_reference := l_rec.rebate_transaction_reference;
2590 x_Header_Adj_tbl(l_count).rebate_payment_system_code := l_rec.rebate_payment_system_code;
2591 x_Header_Adj_tbl(l_count).redeemed_date := l_rec.redeemed_date;
2592 x_Header_Adj_tbl(l_count).redeemed_flag := l_rec.redeemed_flag;
2593 x_Header_Adj_tbl(l_count).accrual_flag := l_rec.accrual_flag;
2594 x_Header_Adj_tbl(l_count).range_break_quantity := l_rec.range_break_quantity;
2595 x_Header_Adj_tbl(l_count).accrual_conversion_rate := l_rec.accrual_conversion_rate;
2596 x_Header_Adj_tbl(l_count).pricing_group_sequence := l_rec.pricing_group_sequence;
2597 x_Header_Adj_tbl(l_count).modifier_level_code := l_rec.modifier_level_code;
2598 x_Header_Adj_tbl(l_count).price_break_type_code := l_rec.price_break_type_code;
2599 x_Header_Adj_tbl(l_count).substitution_attribute := l_rec.substitution_attribute;
2600 x_Header_Adj_tbl(l_count).proration_type_code := l_rec.proration_type_code;
2601 x_Header_Adj_tbl(l_count).credit_or_charge_flag := l_rec.credit_or_charge_flag;
2602 x_Header_Adj_tbl(l_count).include_on_returns_flag := l_rec.include_on_returns_flag;
2603 x_Header_Adj_tbl(l_count).ac_attribute1 := l_rec.AC_ATTRIBUTE1;
2604 x_Header_Adj_tbl(l_count).ac_attribute10 := l_rec.AC_ATTRIBUTE10;
2605 x_Header_Adj_tbl(l_count).ac_attribute11 := l_rec.AC_ATTRIBUTE11;
2606 x_Header_Adj_tbl(l_count).ac_attribute12 := l_rec.AC_ATTRIBUTE12;
2607 x_Header_Adj_tbl(l_count).ac_attribute13 := l_rec.AC_ATTRIBUTE13;
2608 x_Header_Adj_tbl(l_count).ac_attribute14 := l_rec.AC_ATTRIBUTE14;
2609 x_Header_Adj_tbl(l_count).ac_attribute15 := l_rec.AC_ATTRIBUTE15;
2610 x_Header_Adj_tbl(l_count).ac_attribute2 := l_rec.AC_ATTRIBUTE2;
2611 x_Header_Adj_tbl(l_count).ac_attribute3 := l_rec.AC_ATTRIBUTE3;
2612 x_Header_Adj_tbl(l_count).ac_attribute4 := l_rec.AC_ATTRIBUTE4;
2613 x_Header_Adj_tbl(l_count).ac_attribute5 := l_rec.AC_ATTRIBUTE5;
2614 x_Header_Adj_tbl(l_count).ac_attribute6 := l_rec.AC_ATTRIBUTE6;
2615 x_Header_Adj_tbl(l_count).ac_attribute7 := l_rec.AC_ATTRIBUTE7;
2616 x_Header_Adj_tbl(l_count).ac_attribute8 := l_rec.AC_ATTRIBUTE8;
2617 x_Header_Adj_tbl(l_count).ac_attribute9 := l_rec.AC_ATTRIBUTE9;
2618 x_Header_Adj_tbl(l_count).ac_context := l_rec.AC_CONTEXT;
2619 --uom begin
2620 -- x_Header_Adj_tbl(l_count).OPERAND_PER_PQTY :=l_rec.operand_per_pqty;
2621 -- x_Header_Adj_tbl(l_count).ADJUSTED_AMOUNT_PER_PQTY :=l_rec.adjusted_amount_per_pqty;
2622 --uom end
2623
2624 x_Header_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
2625
2626 -- set values for non-DB fields
2627 x_Header_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
2628 x_Header_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
2629 x_Header_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
2630
2631 l_count := l_count + 1;
2632 END LOOP;
2633
2634 IF l_entity = 1 THEN
2635 CLOSE l_header_adj_csr_p;
2636 ELSIF l_entity = 2 THEN
2637 CLOSE l_header_adj_csr_h;
2638 END IF;
2639
2640 -- PK sent and no rows found
2641
2642 IF
2643 (p_price_adjustment_id IS NOT NULL
2644 AND
2645 p_price_adjustment_id <> FND_API.G_MISS_NUM)
2646 AND
2647 (x_Header_Adj_tbl.COUNT = 0)
2648 THEN
2649 RAISE NO_DATA_FOUND;
2650 END IF;
2651
2652
2653
2654 END IF;
2655
2656 EXCEPTION
2657
2658 WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2659
2660 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2661
2662 WHEN OTHERS THEN
2663
2664 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2665 OE_MSG_PUB.Add_Exc_Msg
2666 ( G_PKG_NAME
2667 , 'Header Adj Query_Rows'
2668 );
2669 END IF;
2670 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2671
2672 END;
2673
2674
2675 -- Header SCredit Query_Row
2676 PROCEDURE Query_Row
2677 ( p_sales_credit_id IN NUMBER,
2678 p_version_number IN NUMBER := NULL,
2679 p_phase_change_flag IN VARCHAR2 := NULL,
2680 x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
2681 )
2682 IS
2683 l_version_number NUMBER := p_version_number;
2684 l_current_version_number NUMBER;
2685 x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2686 --
2687 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2688 --
2689 BEGIN
2690 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2691 l_current_version_number := Get_Version_Number(p_sales_credit_id => p_sales_credit_id);
2692
2693 IF l_version_number >= l_current_version_number THEN
2694 l_version_number := NULL;
2695 END IF;
2696 END IF;
2697
2698 IF l_version_number IS NULL THEN
2699 OE_Header_Scredit_Util.Query_Row(p_sales_credit_id => p_sales_credit_id, x_header_scredit_rec => x_header_scredit_rec);
2700 ELSE
2701 G_INTERNAL_QUERY := TRUE;
2702 Query_Rows
2703 ( p_sales_credit_id => p_sales_credit_id,
2704 p_version_number => l_version_number,
2705 x_Header_Scredit_tbl => x_Header_Scredit_tbl
2706 );
2707 x_Header_Scredit_rec := x_Header_Scredit_tbl(1);
2708 G_INTERNAL_QUERY := FALSE;
2709 END IF;
2710
2711 EXCEPTION
2712 WHEN OTHERS THEN
2713 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2714 OE_MSG_PUB.Add_Exc_Msg
2715 ( G_PKG_NAME
2716 , 'Header Scredit Query_Row'
2717 );
2718 END IF;
2719 END;
2720
2721
2722 -- Header SCredit Query_Rows
2723 PROCEDURE Query_Rows
2724 ( p_sales_credit_id IN NUMBER :=
2725 FND_API.G_MISS_NUM
2726 , p_header_id IN NUMBER :=
2727 FND_API.G_MISS_NUM
2728 , p_version_number IN NUMBER := NULL
2729 , p_phase_change_flag IN VARCHAR2 := NULL
2730 , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
2731 )
2732 IS
2733 l_version_number NUMBER := p_version_number;
2734 l_current_version_number NUMBER;
2735 l_count NUMBER;
2736
2737 CURSOR l_Header_Scredit_csr_s IS
2738 SELECT ATTRIBUTE1
2739 , ATTRIBUTE10
2740 , ATTRIBUTE11
2741 , ATTRIBUTE12
2742 , ATTRIBUTE13
2743 , ATTRIBUTE14
2744 , ATTRIBUTE15
2745 , ATTRIBUTE2
2746 , ATTRIBUTE3
2747 , ATTRIBUTE4
2748 , ATTRIBUTE5
2749 , ATTRIBUTE6
2750 , ATTRIBUTE7
2751 , ATTRIBUTE8
2752 , ATTRIBUTE9
2753 , CONTEXT
2754 , CREATED_BY
2755 , CREATION_DATE
2756 , DW_UPDATE_ADVICE_FLAG
2757 , HEADER_ID
2758 , LAST_UPDATED_BY
2759 , LAST_UPDATE_DATE
2760 , LAST_UPDATE_LOGIN
2761 , LINE_ID
2762 , PERCENT
2763 , SALESREP_ID
2764 , sales_credit_type_id
2765 , SALES_CREDIT_ID
2766 , WH_UPDATE_DATE
2767 --SG {
2768 -- , SALES_GROUP_ID
2769 -- , SALES_GROUP_UPDATED
2770 --SG }
2771 , LOCK_CONTROL
2772 FROM OE_SALES_CREDIT_HISTORY
2773 WHERE SALES_CREDIT_ID = p_sales_credit_id
2774 AND VERSION_NUMBER = l_version_number
2775 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2776 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
2777 AND VERSION_FLAG = 'Y'));
2778
2779 CURSOR l_Header_Scredit_csr_h IS
2780 SELECT ATTRIBUTE1
2781 , ATTRIBUTE10
2782 , ATTRIBUTE11
2783 , ATTRIBUTE12
2784 , ATTRIBUTE13
2785 , ATTRIBUTE14
2786 , ATTRIBUTE15
2787 , ATTRIBUTE2
2788 , ATTRIBUTE3
2789 , ATTRIBUTE4
2790 , ATTRIBUTE5
2791 , ATTRIBUTE6
2792 , ATTRIBUTE7
2793 , ATTRIBUTE8
2794 , ATTRIBUTE9
2795 , CONTEXT
2796 , CREATED_BY
2797 , CREATION_DATE
2798 , DW_UPDATE_ADVICE_FLAG
2799 , HEADER_ID
2800 , LAST_UPDATED_BY
2801 , LAST_UPDATE_DATE
2802 , LAST_UPDATE_LOGIN
2803 , LINE_ID
2804 , PERCENT
2805 , SALESREP_ID
2806 , sales_credit_type_id
2807 , SALES_CREDIT_ID
2808 , WH_UPDATE_DATE
2809 --SG {
2810 -- , SALES_GROUP_ID
2811 -- , SALES_GROUP_UPDATED
2812 --SG }
2813 , LOCK_CONTROL
2814 FROM OE_SALES_CREDIT_HISTORY
2815 WHERE HEADER_ID = p_header_id
2816 AND LINE_ID IS NULL
2817 AND VERSION_NUMBER = l_version_number
2818 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
2819 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
2820 AND VERSION_FLAG = 'Y'));
2821
2822 l_rec l_header_scredit_csr_s%ROWTYPE;
2823 l_entity NUMBER;
2824
2825 BEGIN
2826 IF p_version_number IS NOT NULL AND G_INTERNAL_QUERY = FALSE THEN
2827 l_current_version_number := Get_Version_Number(p_header_id => p_header_id, p_sales_credit_id => p_sales_credit_id);
2828
2829 IF l_version_number >= l_current_version_number THEN
2830 l_version_number := NULL;
2831 END IF;
2832 END IF;
2833
2834 IF l_version_number IS NULL THEN
2835 OE_Header_Scredit_Util.Query_Rows(p_sales_credit_id => p_sales_credit_id, p_header_id => p_header_id, x_header_scredit_tbl => x_header_scredit_tbl);
2836 ELSE
2837
2838 IF
2839 (p_sales_credit_id IS NOT NULL
2840 AND
2841 p_sales_credit_id <> FND_API.G_MISS_NUM)
2842 AND
2843 (p_header_id IS NOT NULL
2844 AND
2845 p_header_id <> FND_API.G_MISS_NUM)
2846 THEN
2847 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2848
2849 END IF;
2850
2851 IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2852 l_entity := 1;
2853 OPEN l_header_scredit_csr_s;
2854 ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
2855 l_entity := 2;
2856 OPEN l_header_scredit_csr_h;
2857 END IF;
2858
2859 -- Loop over fetched records
2860
2861 l_count := 1;
2862
2863 LOOP
2864 IF l_entity = 1 THEN
2865 FETCH l_header_scredit_csr_s INTO l_rec;
2866 EXIT WHEN l_header_scredit_csr_s%NOTFOUND;
2867 ELSIF l_entity = 2 THEN
2868 FETCH l_header_scredit_csr_h INTO l_rec;
2869 EXIT WHEN l_header_scredit_csr_h%NOTFOUND;
2870 ELSE
2871 EXIT;
2872 END IF;
2873
2874 x_header_scredit_tbl(l_count).attribute1 := l_rec.ATTRIBUTE1;
2875 x_header_scredit_tbl(l_count).attribute10 := l_rec.ATTRIBUTE10;
2876 x_header_scredit_tbl(l_count).attribute11 := l_rec.ATTRIBUTE11;
2877 x_header_scredit_tbl(l_count).attribute12 := l_rec.ATTRIBUTE12;
2878 x_header_scredit_tbl(l_count).attribute13 := l_rec.ATTRIBUTE13;
2879 x_header_scredit_tbl(l_count).attribute14 := l_rec.ATTRIBUTE14;
2880 x_header_scredit_tbl(l_count).attribute15 := l_rec.ATTRIBUTE15;
2881 x_header_scredit_tbl(l_count).attribute2 := l_rec.ATTRIBUTE2;
2882 x_header_scredit_tbl(l_count).attribute3 := l_rec.ATTRIBUTE3;
2883 x_header_scredit_tbl(l_count).attribute4 := l_rec.ATTRIBUTE4;
2884 x_header_scredit_tbl(l_count).attribute5 := l_rec.ATTRIBUTE5;
2885 x_header_scredit_tbl(l_count).attribute6 := l_rec.ATTRIBUTE6;
2886 x_header_scredit_tbl(l_count).attribute7 := l_rec.ATTRIBUTE7;
2887 x_header_scredit_tbl(l_count).attribute8 := l_rec.ATTRIBUTE8;
2888 x_header_scredit_tbl(l_count).attribute9 := l_rec.ATTRIBUTE9;
2889 x_header_scredit_tbl(l_count).context := l_rec.CONTEXT;
2890 x_header_scredit_tbl(l_count).created_by := l_rec.CREATED_BY;
2891 x_header_scredit_tbl(l_count).creation_date := l_rec.CREATION_DATE;
2892 x_header_scredit_tbl(l_count).dw_update_advice_flag := l_rec.DW_UPDATE_ADVICE_FLAG;
2893 x_header_scredit_tbl(l_count).header_id := l_rec.HEADER_ID;
2894 x_header_scredit_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
2895 x_header_scredit_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
2896 x_header_scredit_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
2897 x_header_scredit_tbl(l_count).line_id := l_rec.LINE_ID;
2898 x_header_scredit_tbl(l_count).percent := l_rec.PERCENT;
2899 x_header_scredit_tbl(l_count).salesrep_id := l_rec.SALESREP_ID;
2900 x_header_scredit_tbl(l_count).sales_credit_type_id := l_rec.sales_credit_type_id;
2901 x_header_scredit_tbl(l_count).sales_credit_id := l_rec.SALES_CREDIT_ID;
2902 x_header_scredit_tbl(l_count).wh_update_date := l_rec.WH_UPDATE_DATE;
2903 --SG{
2904 -- x_header_scredit_tbl(l_count).sales_group_id := l_rec.sales_group_id;
2905 -- x_header_scredit_tbl(l_count).sales_group_updated:=l_rec.sales_group_updated;
2906 --SG}
2907 x_header_scredit_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
2908
2909 l_count := l_count + 1;
2910 END LOOP;
2911
2912 IF l_entity = 1 THEN
2913 CLOSE l_header_scredit_csr_s;
2914 ELSIF l_entity = 2 THEN
2915 CLOSE l_header_scredit_csr_h;
2916 END IF;
2917
2918 -- PK sent and no rows found
2919
2920 IF
2921 (p_sales_credit_id IS NOT NULL
2922 AND
2923 p_sales_credit_id <> FND_API.G_MISS_NUM)
2924 AND
2925 (x_Header_Scredit_tbl.COUNT = 0)
2926 THEN
2927 RAISE NO_DATA_FOUND;
2928 END IF;
2929
2930 END IF;
2931
2932 EXCEPTION
2933 WHEN OTHERS THEN
2934 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2935 OE_MSG_PUB.Add_Exc_Msg
2936 ( G_PKG_NAME
2937 , 'Header Scredit Query_Rows'
2938 );
2939 END IF;
2940 END;
2941
2942
2943 -- Line Query_Row
2944 PROCEDURE Query_Row
2945 ( p_line_id IN NUMBER
2946 , p_version_number IN NUMBER := NULL
2947 , p_phase_change_flag IN VARCHAR2 := NULL
2948 , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2949 )
2950 IS
2951 l_version_number NUMBER := p_version_number;
2952 l_current_version_number NUMBER;
2953 l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2954 BEGIN
2955 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
2956 l_current_version_number := Get_Version_Number(p_line_id => p_line_id);
2957 IF l_version_number >= l_current_version_number THEN
2958 l_version_number := NULL;
2959 END IF;
2960 END IF;
2961
2962 IF l_version_number IS NULL THEN
2963 OE_Line_Util.Query_Row(p_line_id => p_line_id, x_line_rec => x_line_rec);
2964 ELSE
2965
2966 G_INTERNAL_QUERY := TRUE;
2967 Query_Rows
2968 ( p_line_id => p_line_id
2969 , p_version_number => l_version_number
2970 , x_line_tbl => l_line_tbl
2971 );
2972
2973 x_line_rec := l_line_tbl(1);
2974 G_INTERNAL_QUERY := FALSE;
2975
2976 END IF;
2977
2978 EXCEPTION
2979 WHEN OTHERS THEN
2980 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2981 OE_MSG_PUB.Add_Exc_Msg
2982 ( G_PKG_NAME
2983 , 'Line Query_Row'
2984 );
2985 END IF;
2986 END;
2987
2988
2989 -- Line Query_Rows
2990 PROCEDURE Query_Rows
2991 ( p_line_id IN NUMBER :=
2992 FND_API.G_MISS_NUM
2993 , p_header_id IN NUMBER :=
2994 FND_API.G_MISS_NUM
2995 , p_line_set_id IN NUMBER :=
2996 FND_API.G_MISS_NUM
2997 , p_version_number IN NUMBER := NULL
2998 , p_phase_change_flag IN VARCHAR2 := NULL
2999 , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3000 )
3001 IS
3002 l_version_number NUMBER := p_version_number;
3003 l_current_version_number NUMBER;
3004
3005 l_org_id NUMBER;
3006 l_count NUMBER;
3007 l_entity NUMBER;
3008
3009 CURSOR l_line_csr_l IS
3010 SELECT ACCOUNTING_RULE_ID
3011 , ACCOUNTING_RULE_DURATION
3012 , ACTUAL_ARRIVAL_DATE
3013 , ACTUAL_SHIPMENT_DATE
3014 , AGREEMENT_ID
3015 , ARRIVAL_SET_ID
3016 , ATO_LINE_ID
3017 , ATTRIBUTE1
3018 , ATTRIBUTE10
3019 , ATTRIBUTE11
3020 , ATTRIBUTE12
3021 , ATTRIBUTE13
3022 , ATTRIBUTE14
3023 , ATTRIBUTE15
3024 , ATTRIBUTE16 --For bug 2184255
3025 , ATTRIBUTE17
3026 , ATTRIBUTE18
3027 , ATTRIBUTE19
3028 , ATTRIBUTE2
3029 , ATTRIBUTE20
3030 , ATTRIBUTE3
3031 , ATTRIBUTE4
3032 , ATTRIBUTE5
3033 , ATTRIBUTE6
3034 , ATTRIBUTE7
3035 , ATTRIBUTE8
3036 , ATTRIBUTE9
3037 , AUTO_SELECTED_QUANTITY
3038 , AUTHORIZED_TO_SHIP_FLAG
3039 , BOOKED_FLAG
3040 , CANCELLED_FLAG
3041 , CANCELLED_QUANTITY
3042 , COMPONENT_CODE
3043 , COMPONENT_NUMBER
3044 , COMPONENT_SEQUENCE_ID
3045 , CONFIG_HEADER_ID
3046 , CONFIG_REV_NBR
3047 , CONFIG_DISPLAY_SEQUENCE
3048 , CONFIGURATION_ID
3049 , CONTEXT
3050
3051 , CREATED_BY
3052 , CREATION_DATE
3053 , CREDIT_INVOICE_LINE_ID
3054 , CUSTOMER_DOCK_CODE
3055 , CUSTOMER_JOB
3056 , CUSTOMER_PRODUCTION_LINE
3057 , CUST_PRODUCTION_SEQ_NUM
3058 , CUSTOMER_TRX_LINE_ID
3059 , CUST_MODEL_SERIAL_NUMBER
3060 , CUST_PO_NUMBER
3061 , CUSTOMER_LINE_NUMBER
3062 , DELIVERY_LEAD_TIME
3063 , DELIVER_TO_CONTACT_ID
3064 , DELIVER_TO_ORG_ID
3065 , DEMAND_BUCKET_TYPE_CODE
3066 , DEMAND_CLASS_CODE
3067 , DEP_PLAN_REQUIRED_FLAG
3068
3069 , EARLIEST_ACCEPTABLE_DATE
3070 , END_ITEM_UNIT_NUMBER
3071 , EXPLOSION_DATE
3072 , FIRST_ACK_CODE
3073 , FIRST_ACK_DATE
3074 , FOB_POINT_CODE
3075 , FREIGHT_CARRIER_CODE
3076 , FREIGHT_TERMS_CODE
3077 , FULFILLED_QUANTITY
3078 , FULFILLED_FLAG
3079 , FULFILLMENT_METHOD_CODE
3080 , FULFILLMENT_DATE
3081 , GLOBAL_ATTRIBUTE1
3082 , GLOBAL_ATTRIBUTE10
3083 , GLOBAL_ATTRIBUTE11
3084 , GLOBAL_ATTRIBUTE12
3085 , GLOBAL_ATTRIBUTE13
3086 , GLOBAL_ATTRIBUTE14
3087 , GLOBAL_ATTRIBUTE15
3088 , GLOBAL_ATTRIBUTE16
3089 , GLOBAL_ATTRIBUTE17
3090 , GLOBAL_ATTRIBUTE18
3091 , GLOBAL_ATTRIBUTE19
3092 , GLOBAL_ATTRIBUTE2
3093 , GLOBAL_ATTRIBUTE20
3094 , GLOBAL_ATTRIBUTE3
3095 , GLOBAL_ATTRIBUTE4
3096 , GLOBAL_ATTRIBUTE5
3097 , GLOBAL_ATTRIBUTE6
3098 , GLOBAL_ATTRIBUTE7
3099 , GLOBAL_ATTRIBUTE8
3100 , GLOBAL_ATTRIBUTE9
3101 , GLOBAL_ATTRIBUTE_CATEGORY
3102 , HEADER_ID
3103 , INDUSTRY_ATTRIBUTE1
3104 , INDUSTRY_ATTRIBUTE10
3105 , INDUSTRY_ATTRIBUTE11
3106 , INDUSTRY_ATTRIBUTE12
3107 , INDUSTRY_ATTRIBUTE13
3108 , INDUSTRY_ATTRIBUTE14
3109 , INDUSTRY_ATTRIBUTE15
3110 , INDUSTRY_ATTRIBUTE16
3111 , INDUSTRY_ATTRIBUTE17
3112 , INDUSTRY_ATTRIBUTE18
3113 , INDUSTRY_ATTRIBUTE19
3114 , INDUSTRY_ATTRIBUTE20
3115 , INDUSTRY_ATTRIBUTE21
3116 , INDUSTRY_ATTRIBUTE22
3117 , INDUSTRY_ATTRIBUTE23
3118 , INDUSTRY_ATTRIBUTE24
3119 , INDUSTRY_ATTRIBUTE25
3120 , INDUSTRY_ATTRIBUTE26
3121 , INDUSTRY_ATTRIBUTE27
3122 , INDUSTRY_ATTRIBUTE28
3123 , INDUSTRY_ATTRIBUTE29
3124 , INDUSTRY_ATTRIBUTE30
3125 , INDUSTRY_ATTRIBUTE2
3126 , INDUSTRY_ATTRIBUTE3
3127 , INDUSTRY_ATTRIBUTE4
3128 , INDUSTRY_ATTRIBUTE5
3129 , INDUSTRY_ATTRIBUTE6
3130 , INDUSTRY_ATTRIBUTE7
3131 , INDUSTRY_ATTRIBUTE8
3132 , INDUSTRY_ATTRIBUTE9
3133 , INDUSTRY_CONTEXT
3134 , INTMED_SHIP_TO_CONTACT_ID
3135 , INTMED_SHIP_TO_ORG_ID
3136 , INVENTORY_ITEM_ID
3137 , INVOICE_INTERFACE_STATUS_CODE
3138
3139
3140
3141 , INVOICE_TO_CONTACT_ID
3142 , INVOICE_TO_ORG_ID
3143 , INVOICED_QUANTITY
3144 , INVOICING_RULE_ID
3145 , ORDERED_ITEM_ID
3146 , ITEM_IDENTIFIER_TYPE
3147 , ORDERED_ITEM
3148 , ITEM_REVISION
3149 , ITEM_TYPE_CODE
3150 , LAST_ACK_CODE
3151 , LAST_ACK_DATE
3152 , LAST_UPDATED_BY
3153 , LAST_UPDATE_DATE
3154 , LAST_UPDATE_LOGIN
3155 , LATEST_ACCEPTABLE_DATE
3156 , LINE_CATEGORY_CODE
3157 , LINE_ID
3158 , LINE_NUMBER
3159 , LINE_TYPE_ID
3160 , LINK_TO_LINE_ID
3161
3162 , MODEL_GROUP_NUMBER
3163 -- , MFG_COMPONENT_SEQUENCE_ID
3164 -- , MFG_LEAD_TIME
3165 , OPEN_FLAG
3166 , OPTION_FLAG
3167 , OPTION_NUMBER
3168 , ORDERED_QUANTITY
3169 , ORDERED_QUANTITY2 --OPM 02/JUN/00
3170 , ORDER_QUANTITY_UOM
3171 , ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
3172 , ORG_ID
3173 , ORIG_SYS_DOCUMENT_REF
3174 , ORIG_SYS_LINE_REF
3175 , ORIG_SYS_SHIPMENT_REF
3176 , OVER_SHIP_REASON_CODE
3177 , OVER_SHIP_RESOLVED_FLAG
3178 , PAYMENT_TERM_ID
3179 , PLANNING_PRIORITY
3180 , PREFERRED_GRADE --OPM 02/JUN/00
3181 , PRICE_LIST_ID
3182 , PRICE_REQUEST_CODE --PROMOTIONS MAY/01
3183 , PRICING_ATTRIBUTE1
3184 , PRICING_ATTRIBUTE10
3185 , PRICING_ATTRIBUTE2
3186 , PRICING_ATTRIBUTE3
3187 , PRICING_ATTRIBUTE4
3188 , PRICING_ATTRIBUTE5
3189 , PRICING_ATTRIBUTE6
3190 , PRICING_ATTRIBUTE7
3191 , PRICING_ATTRIBUTE8
3192 , PRICING_ATTRIBUTE9
3193 , PRICING_CONTEXT
3194 , PRICING_DATE
3195 , PRICING_QUANTITY
3196 , PRICING_QUANTITY_UOM
3197 , PROGRAM_APPLICATION_ID
3198 , PROGRAM_ID
3199 , PROGRAM_UPDATE_DATE
3200 , PROJECT_ID
3201 , PROMISE_DATE
3202 , RE_SOURCE_FLAG
3203 , REFERENCE_CUSTOMER_TRX_LINE_ID
3204 , REFERENCE_HEADER_ID
3205 , REFERENCE_LINE_ID
3206 , REFERENCE_TYPE
3207
3208 , REQUEST_DATE
3209 , REQUEST_ID
3210 , RETURN_ATTRIBUTE1
3211 , RETURN_ATTRIBUTE10
3212 , RETURN_ATTRIBUTE11
3213 , RETURN_ATTRIBUTE12
3214 , RETURN_ATTRIBUTE13
3215 , RETURN_ATTRIBUTE14
3216 , RETURN_ATTRIBUTE15
3217 , RETURN_ATTRIBUTE2
3218 , RETURN_ATTRIBUTE3
3219 , RETURN_ATTRIBUTE4
3220 , RETURN_ATTRIBUTE5
3221 , RETURN_ATTRIBUTE6
3222 , RETURN_ATTRIBUTE7
3223 , RETURN_ATTRIBUTE8
3224 , RETURN_ATTRIBUTE9
3225 , RETURN_CONTEXT
3226 , RETURN_REASON_CODE
3227 , RLA_SCHEDULE_TYPE_CODE
3228 , SALESREP_ID
3229 , SCHEDULE_ARRIVAL_DATE
3230 , SCHEDULE_SHIP_DATE
3231 , SCHEDULE_STATUS_CODE
3232 , SHIPMENT_NUMBER
3233 , SHIPMENT_PRIORITY_CODE
3234 , SHIPPED_QUANTITY
3235 , SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
3236 , SHIPPING_METHOD_CODE
3237 , SHIPPING_QUANTITY
3238 , SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
3239 , SHIPPING_QUANTITY_UOM
3240 , SHIP_FROM_ORG_ID
3241 , SUBINVENTORY
3242 , SHIP_SET_ID
3243 , SHIP_TOLERANCE_ABOVE
3244 , SHIP_TOLERANCE_BELOW
3245 , SHIPPABLE_FLAG
3246 , SHIPPING_INTERFACED_FLAG
3247 , SHIP_TO_CONTACT_ID
3248 , SHIP_TO_ORG_ID
3249 , SHIP_MODEL_COMPLETE_FLAG
3250 , SOLD_TO_ORG_ID
3251 , SOLD_FROM_ORG_ID
3252 , SORT_ORDER
3253 , SOURCE_DOCUMENT_ID
3254 , SOURCE_DOCUMENT_LINE_ID
3255 , SOURCE_DOCUMENT_TYPE_ID
3256 , SOURCE_TYPE_CODE
3257 , SPLIT_FROM_LINE_ID
3258 , LINE_SET_ID
3259 , SPLIT_BY
3260 , MODEL_REMNANT_FLAG
3261 , TASK_ID
3262 , TAX_CODE
3263 , TAX_DATE
3264 , TAX_EXEMPT_FLAG
3265 , TAX_EXEMPT_NUMBER
3266 , TAX_EXEMPT_REASON_CODE
3267 , TAX_POINT_CODE
3268 , TAX_RATE
3269 , TAX_VALUE
3270 , TOP_MODEL_LINE_ID
3271 , UNIT_LIST_PRICE
3272 , UNIT_LIST_PRICE_PER_PQTY
3273 , UNIT_SELLING_PRICE
3274 , UNIT_SELLING_PRICE_PER_PQTY
3275 , VISIBLE_DEMAND_FLAG
3276 , VEH_CUS_ITEM_CUM_KEY_ID
3277 , SHIPPING_INSTRUCTIONS
3278 , PACKING_INSTRUCTIONS
3279 , SERVICE_TXN_REASON_CODE
3280 , SERVICE_TXN_COMMENTS
3281 , SERVICE_DURATION
3282 , SERVICE_PERIOD
3283 , SERVICE_START_DATE
3284 , SERVICE_END_DATE
3285 , SERVICE_COTERMINATE_FLAG
3286 , UNIT_LIST_PERCENT
3287 , UNIT_SELLING_PERCENT
3288 , UNIT_PERCENT_BASE_PRICE
3289 , SERVICE_NUMBER
3290 , SERVICE_REFERENCE_TYPE_CODE
3291 , SERVICE_REFERENCE_LINE_ID
3292 , SERVICE_REFERENCE_SYSTEM_ID
3293 , TP_CONTEXT
3294 , TP_ATTRIBUTE1
3295 , TP_ATTRIBUTE2
3296 , TP_ATTRIBUTE3
3297 , TP_ATTRIBUTE4
3298 , TP_ATTRIBUTE5
3299 , TP_ATTRIBUTE6
3300 , TP_ATTRIBUTE7
3301 , TP_ATTRIBUTE8
3302 , TP_ATTRIBUTE9
3303 , TP_ATTRIBUTE10
3304 , TP_ATTRIBUTE11
3305 , TP_ATTRIBUTE12
3306 , TP_ATTRIBUTE13
3307 , TP_ATTRIBUTE14
3308 , TP_ATTRIBUTE15
3309 , FLOW_STATUS_CODE
3310 -- , MARKETING_SOURCE_CODE_ID
3311 , CALCULATE_PRICE_FLAG
3312 , COMMITMENT_ID
3313 , ORDER_SOURCE_ID -- aksingh
3314 -- , UPGRADED_FLAG
3315 , ORIGINAL_INVENTORY_ITEM_ID
3316 , ORIGINAL_ITEM_IDENTIFIER_TYPE
3317 , ORIGINAL_ORDERED_ITEM_ID
3318 , ORIGINAL_ORDERED_ITEM
3319 , ITEM_RELATIONSHIP_TYPE
3320 , ITEM_SUBSTITUTION_TYPE_CODE
3321 , LATE_DEMAND_PENALTY_FACTOR
3322 , OVERRIDE_ATP_DATE_CODE
3323 -- , FIRM_DEMAND_FLAG
3324 -- , EARLIEST_SHIP_DATE
3325 , USER_ITEM_DESCRIPTION
3326 , BLANKET_NUMBER
3327 , BLANKET_LINE_NUMBER
3328 , BLANKET_VERSION_NUMBER
3329 --MRG B
3330 -- , UNIT_COST
3331 --MRG E
3332 -- , LOCK_CONTROL
3333 , NVL(OPTION_NUMBER, -1) OPN
3334 , NVL(COMPONENT_NUMBER, -1) CPN
3335 , NVL(SERVICE_NUMBER, -1) SVN
3336 , CHANGE_SEQUENCE
3337 --key Transaction Dates
3338 , order_firmed_date
3339 , actual_fulfillment_date
3340 -- sol_ord_er #16014165
3341 ,SERVICE_BILL_PROFILE_ID
3342 ,SERVICE_COV_TEMPLATE_ID
3343 ,SERVICE_SUBS_TEMPLATE_ID
3344 ,SERVICE_BILL_OPTION_CODE
3345 ,SERVICE_FIRST_PERIOD_AMOUNT
3346 ,SUBSCRIPTION_ENABLE_FLAG
3347 ,SERVICE_FIRST_PERIOD_ENDDATE
3348 FROM OE_ORDER_LINES_HISTORY
3349 WHERE LINE_ID = p_line_id
3350 AND VERSION_NUMBER = l_version_number
3351 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
3352 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
3353 AND VERSION_FLAG = 'Y'));
3354
3355 CURSOR l_line_csr_h IS
3356 SELECT ACCOUNTING_RULE_ID
3357 , ACCOUNTING_RULE_DURATION
3358 , ACTUAL_ARRIVAL_DATE
3359 , ACTUAL_SHIPMENT_DATE
3360 , AGREEMENT_ID
3361 , ARRIVAL_SET_ID
3362 , ATO_LINE_ID
3363 , ATTRIBUTE1
3364 , ATTRIBUTE10
3365 , ATTRIBUTE11
3366 , ATTRIBUTE12
3367 , ATTRIBUTE13
3368 , ATTRIBUTE14
3369 , ATTRIBUTE15
3370 , ATTRIBUTE16 --For bug 2184255
3371 , ATTRIBUTE17
3372 , ATTRIBUTE18
3373 , ATTRIBUTE19
3374 , ATTRIBUTE2
3375 , ATTRIBUTE20
3376 , ATTRIBUTE3
3377 , ATTRIBUTE4
3378 , ATTRIBUTE5
3379 , ATTRIBUTE6
3380 , ATTRIBUTE7
3381 , ATTRIBUTE8
3382 , ATTRIBUTE9
3383 , AUTO_SELECTED_QUANTITY
3384 , AUTHORIZED_TO_SHIP_FLAG
3385 , BOOKED_FLAG
3386 , CANCELLED_FLAG
3387 , CANCELLED_QUANTITY
3388 , COMPONENT_CODE
3389 , COMPONENT_NUMBER
3390 , COMPONENT_SEQUENCE_ID
3391 , CONFIG_HEADER_ID
3392 , CONFIG_REV_NBR
3393 , CONFIG_DISPLAY_SEQUENCE
3394 , CONFIGURATION_ID
3395 , CONTEXT
3396
3397 , CREATED_BY
3398 , CREATION_DATE
3399 , CREDIT_INVOICE_LINE_ID
3400 , CUSTOMER_DOCK_CODE
3401 , CUSTOMER_JOB
3402 , CUSTOMER_PRODUCTION_LINE
3403 , CUST_PRODUCTION_SEQ_NUM
3404 , CUSTOMER_TRX_LINE_ID
3405 , CUST_MODEL_SERIAL_NUMBER
3406 , CUST_PO_NUMBER
3407 , CUSTOMER_LINE_NUMBER
3408 , DELIVERY_LEAD_TIME
3409 , DELIVER_TO_CONTACT_ID
3410 , DELIVER_TO_ORG_ID
3411 , DEMAND_BUCKET_TYPE_CODE
3412 , DEMAND_CLASS_CODE
3413 , DEP_PLAN_REQUIRED_FLAG
3414
3415 , EARLIEST_ACCEPTABLE_DATE
3416 , END_ITEM_UNIT_NUMBER
3417 , EXPLOSION_DATE
3418 , FIRST_ACK_CODE
3419 , FIRST_ACK_DATE
3420 , FOB_POINT_CODE
3421 , FREIGHT_CARRIER_CODE
3422 , FREIGHT_TERMS_CODE
3423 , FULFILLED_QUANTITY
3424 , FULFILLED_FLAG
3425 , FULFILLMENT_METHOD_CODE
3426 , FULFILLMENT_DATE
3427 , GLOBAL_ATTRIBUTE1
3428 , GLOBAL_ATTRIBUTE10
3429 , GLOBAL_ATTRIBUTE11
3430 , GLOBAL_ATTRIBUTE12
3431 , GLOBAL_ATTRIBUTE13
3432 , GLOBAL_ATTRIBUTE14
3433 , GLOBAL_ATTRIBUTE15
3434 , GLOBAL_ATTRIBUTE16
3435 , GLOBAL_ATTRIBUTE17
3436 , GLOBAL_ATTRIBUTE18
3437 , GLOBAL_ATTRIBUTE19
3438 , GLOBAL_ATTRIBUTE2
3439 , GLOBAL_ATTRIBUTE20
3440 , GLOBAL_ATTRIBUTE3
3441 , GLOBAL_ATTRIBUTE4
3442 , GLOBAL_ATTRIBUTE5
3443 , GLOBAL_ATTRIBUTE6
3444 , GLOBAL_ATTRIBUTE7
3445 , GLOBAL_ATTRIBUTE8
3446 , GLOBAL_ATTRIBUTE9
3447 , GLOBAL_ATTRIBUTE_CATEGORY
3448 , HEADER_ID
3449 , INDUSTRY_ATTRIBUTE1
3450 , INDUSTRY_ATTRIBUTE10
3451 , INDUSTRY_ATTRIBUTE11
3452 , INDUSTRY_ATTRIBUTE12
3453 , INDUSTRY_ATTRIBUTE13
3454 , INDUSTRY_ATTRIBUTE14
3455 , INDUSTRY_ATTRIBUTE15
3456 , INDUSTRY_ATTRIBUTE16
3457 , INDUSTRY_ATTRIBUTE17
3458 , INDUSTRY_ATTRIBUTE18
3459 , INDUSTRY_ATTRIBUTE19
3460 , INDUSTRY_ATTRIBUTE20
3461 , INDUSTRY_ATTRIBUTE21
3462 , INDUSTRY_ATTRIBUTE22
3463 , INDUSTRY_ATTRIBUTE23
3464 , INDUSTRY_ATTRIBUTE24
3465 , INDUSTRY_ATTRIBUTE25
3466 , INDUSTRY_ATTRIBUTE26
3467 , INDUSTRY_ATTRIBUTE27
3468 , INDUSTRY_ATTRIBUTE28
3469 , INDUSTRY_ATTRIBUTE29
3470 , INDUSTRY_ATTRIBUTE30
3471 , INDUSTRY_ATTRIBUTE2
3472 , INDUSTRY_ATTRIBUTE3
3473 , INDUSTRY_ATTRIBUTE4
3474 , INDUSTRY_ATTRIBUTE5
3475 , INDUSTRY_ATTRIBUTE6
3476 , INDUSTRY_ATTRIBUTE7
3477 , INDUSTRY_ATTRIBUTE8
3478 , INDUSTRY_ATTRIBUTE9
3479 , INDUSTRY_CONTEXT
3480 , INTMED_SHIP_TO_CONTACT_ID
3481 , INTMED_SHIP_TO_ORG_ID
3482 , INVENTORY_ITEM_ID
3483 , INVOICE_INTERFACE_STATUS_CODE
3484
3485
3486
3487 , INVOICE_TO_CONTACT_ID
3488 , INVOICE_TO_ORG_ID
3489 , INVOICED_QUANTITY
3490 , INVOICING_RULE_ID
3491 , ORDERED_ITEM_ID
3492 , ITEM_IDENTIFIER_TYPE
3493 , ORDERED_ITEM
3494 , ITEM_REVISION
3495 , ITEM_TYPE_CODE
3496 , LAST_ACK_CODE
3497 , LAST_ACK_DATE
3498 , LAST_UPDATED_BY
3499 , LAST_UPDATE_DATE
3500 , LAST_UPDATE_LOGIN
3501 , LATEST_ACCEPTABLE_DATE
3502 , LINE_CATEGORY_CODE
3503 , LINE_ID
3504 , LINE_NUMBER
3505 , LINE_TYPE_ID
3506 , LINK_TO_LINE_ID
3507
3508 , MODEL_GROUP_NUMBER
3509 -- , MFG_COMPONENT_SEQUENCE_ID
3510 -- , MFG_LEAD_TIME
3511 , OPEN_FLAG
3512 , OPTION_FLAG
3513 , OPTION_NUMBER
3514 , ORDERED_QUANTITY
3515 , ORDERED_QUANTITY2 --OPM 02/JUN/00
3516 , ORDER_QUANTITY_UOM
3517 , ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
3518 , ORG_ID
3519 , ORIG_SYS_DOCUMENT_REF
3520 , ORIG_SYS_LINE_REF
3521 , ORIG_SYS_SHIPMENT_REF
3522 , OVER_SHIP_REASON_CODE
3523 , OVER_SHIP_RESOLVED_FLAG
3524 , PAYMENT_TERM_ID
3525 , PLANNING_PRIORITY
3526 , PREFERRED_GRADE --OPM 02/JUN/00
3527 , PRICE_LIST_ID
3528 , PRICE_REQUEST_CODE --PROMOTIONS SEP/01
3529 , PRICING_ATTRIBUTE1
3530 , PRICING_ATTRIBUTE10
3531 , PRICING_ATTRIBUTE2
3532 , PRICING_ATTRIBUTE3
3533 , PRICING_ATTRIBUTE4
3534 , PRICING_ATTRIBUTE5
3535 , PRICING_ATTRIBUTE6
3536 , PRICING_ATTRIBUTE7
3537 , PRICING_ATTRIBUTE8
3538 , PRICING_ATTRIBUTE9
3539 , PRICING_CONTEXT
3540 , PRICING_DATE
3541 , PRICING_QUANTITY
3542 , PRICING_QUANTITY_UOM
3543 , PROGRAM_APPLICATION_ID
3544 , PROGRAM_ID
3545 , PROGRAM_UPDATE_DATE
3546 , PROJECT_ID
3547 , PROMISE_DATE
3548 , RE_SOURCE_FLAG
3549 , REFERENCE_CUSTOMER_TRX_LINE_ID
3550 , REFERENCE_HEADER_ID
3551 , REFERENCE_LINE_ID
3552 , REFERENCE_TYPE
3553
3554 , REQUEST_DATE
3555 , REQUEST_ID
3556 , RETURN_ATTRIBUTE1
3557 , RETURN_ATTRIBUTE10
3558 , RETURN_ATTRIBUTE11
3559 , RETURN_ATTRIBUTE12
3560 , RETURN_ATTRIBUTE13
3561 , RETURN_ATTRIBUTE14
3562 , RETURN_ATTRIBUTE15
3563 , RETURN_ATTRIBUTE2
3564 , RETURN_ATTRIBUTE3
3565 , RETURN_ATTRIBUTE4
3566 , RETURN_ATTRIBUTE5
3567 , RETURN_ATTRIBUTE6
3568 , RETURN_ATTRIBUTE7
3569 , RETURN_ATTRIBUTE8
3570 , RETURN_ATTRIBUTE9
3571 , RETURN_CONTEXT
3572 , RETURN_REASON_CODE
3573 , RLA_SCHEDULE_TYPE_CODE
3574 , SALESREP_ID
3575 , SCHEDULE_ARRIVAL_DATE
3576 , SCHEDULE_SHIP_DATE
3577 , SCHEDULE_STATUS_CODE
3578 , SHIPMENT_NUMBER
3579 , SHIPMENT_PRIORITY_CODE
3580 , SHIPPED_QUANTITY
3581 , SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
3582 , SHIPPING_METHOD_CODE
3583 , SHIPPING_QUANTITY
3584 , SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
3585 , SHIPPING_QUANTITY_UOM
3586 , SHIP_FROM_ORG_ID
3587 , SUBINVENTORY
3588 , SHIP_SET_ID
3589 , SHIP_TOLERANCE_ABOVE
3590 , SHIP_TOLERANCE_BELOW
3591 , SHIPPABLE_FLAG
3592 , SHIPPING_INTERFACED_FLAG
3593 , SHIP_TO_CONTACT_ID
3594 , SHIP_TO_ORG_ID
3595 , SHIP_MODEL_COMPLETE_FLAG
3596 , SOLD_TO_ORG_ID
3597 , SOLD_FROM_ORG_ID
3598 , SORT_ORDER
3599 , SOURCE_DOCUMENT_ID
3600 , SOURCE_DOCUMENT_LINE_ID
3601 , SOURCE_DOCUMENT_TYPE_ID
3602 , SOURCE_TYPE_CODE
3603 , SPLIT_FROM_LINE_ID
3604 , LINE_SET_ID
3605 , SPLIT_BY
3606 , MODEL_REMNANT_FLAG
3607 , TASK_ID
3608 , TAX_CODE
3609 , TAX_DATE
3610 , TAX_EXEMPT_FLAG
3611 , TAX_EXEMPT_NUMBER
3612 , TAX_EXEMPT_REASON_CODE
3613 , TAX_POINT_CODE
3614 , TAX_RATE
3615 , TAX_VALUE
3616 , TOP_MODEL_LINE_ID
3617 , UNIT_LIST_PRICE
3618 , UNIT_LIST_PRICE_PER_PQTY
3619 , UNIT_SELLING_PRICE
3620 , UNIT_SELLING_PRICE_PER_PQTY
3621 , VISIBLE_DEMAND_FLAG
3622 , VEH_CUS_ITEM_CUM_KEY_ID
3623 , SHIPPING_INSTRUCTIONS
3624 , PACKING_INSTRUCTIONS
3625 , SERVICE_TXN_REASON_CODE
3626 , SERVICE_TXN_COMMENTS
3627 , SERVICE_DURATION
3628 , SERVICE_PERIOD
3629 , SERVICE_START_DATE
3630 , SERVICE_END_DATE
3631 , SERVICE_COTERMINATE_FLAG
3632 , UNIT_LIST_PERCENT
3633 , UNIT_SELLING_PERCENT
3634 , UNIT_PERCENT_BASE_PRICE
3635 , SERVICE_NUMBER
3636 , SERVICE_REFERENCE_TYPE_CODE
3637 , SERVICE_REFERENCE_LINE_ID
3638 , SERVICE_REFERENCE_SYSTEM_ID
3639 , TP_CONTEXT
3640 , TP_ATTRIBUTE1
3641 , TP_ATTRIBUTE2
3642 , TP_ATTRIBUTE3
3643 , TP_ATTRIBUTE4
3644 , TP_ATTRIBUTE5
3645 , TP_ATTRIBUTE6
3646 , TP_ATTRIBUTE7
3647 , TP_ATTRIBUTE8
3648 , TP_ATTRIBUTE9
3649 , TP_ATTRIBUTE10
3650 , TP_ATTRIBUTE11
3651 , TP_ATTRIBUTE12
3652 , TP_ATTRIBUTE13
3653 , TP_ATTRIBUTE14
3654 , TP_ATTRIBUTE15
3655 , FLOW_STATUS_CODE
3656 -- , MARKETING_SOURCE_CODE_ID
3657 , CALCULATE_PRICE_FLAG
3658 , COMMITMENT_ID
3659 , ORDER_SOURCE_ID -- aksingh
3660 -- , upgraded_flag
3661 , ORIGINAL_INVENTORY_ITEM_ID
3662 , ORIGINAL_ITEM_IDENTIFIER_TYPE
3663 , ORIGINAL_ORDERED_ITEM_ID
3664 , ORIGINAL_ORDERED_ITEM
3665 , ITEM_RELATIONSHIP_TYPE
3666 , ITEM_SUBSTITUTION_TYPE_CODE
3667 , LATE_DEMAND_PENALTY_FACTOR
3668 , OVERRIDE_ATP_DATE_CODE
3669 -- , FIRM_DEMAND_FLAG
3670 -- , EARLIEST_SHIP_DATE
3671 , USER_ITEM_DESCRIPTION
3672 , BLANKET_NUMBER
3673 , BLANKET_LINE_NUMBER
3674 , BLANKET_VERSION_NUMBER
3675 --MRG B
3676 -- , UNIT_COST
3677 --MRG E
3678 -- , LOCK_CONTROL
3679 , NVL(OPTION_NUMBER, -1) OPN
3680 , NVL(COMPONENT_NUMBER, -1) CPN
3681 , NVL(SERVICE_NUMBER, -1) SVN
3682 , CHANGE_SEQUENCE
3683 --key Transaction Dates
3684 , order_firmed_date
3685 , actual_fulfillment_date
3686 -- sol_ord_er #16014165
3687 ,SERVICE_BILL_PROFILE_ID
3688 ,SERVICE_COV_TEMPLATE_ID
3689 ,SERVICE_SUBS_TEMPLATE_ID
3690 ,SERVICE_BILL_OPTION_CODE
3691 ,SERVICE_FIRST_PERIOD_AMOUNT
3692 ,SUBSCRIPTION_ENABLE_FLAG
3693 ,SERVICE_FIRST_PERIOD_ENDDATE
3694 FROM OE_ORDER_LINES_HISTORY
3695 WHERE HEADER_ID = p_header_id
3696 AND VERSION_NUMBER = l_version_number
3697 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
3698 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
3699 AND VERSION_FLAG = 'Y'))
3700 ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
3701
3702
3703 CURSOR l_line_csr_s IS
3704 SELECT ACCOUNTING_RULE_ID
3705 , ACCOUNTING_RULE_DURATION
3706 , ACTUAL_ARRIVAL_DATE
3707 , ACTUAL_SHIPMENT_DATE
3708 , AGREEMENT_ID
3709 , ARRIVAL_SET_ID
3710 , ATO_LINE_ID
3711 , ATTRIBUTE1
3712 , ATTRIBUTE10
3713 , ATTRIBUTE11
3714 , ATTRIBUTE12
3715 , ATTRIBUTE13
3716 , ATTRIBUTE14
3717 , ATTRIBUTE15
3718 , ATTRIBUTE16 --For bug 2184255
3719 , ATTRIBUTE17
3720 , ATTRIBUTE18
3721 , ATTRIBUTE19
3722 , ATTRIBUTE2
3723 , ATTRIBUTE20
3724 , ATTRIBUTE3
3725 , ATTRIBUTE4
3726 , ATTRIBUTE5
3727 , ATTRIBUTE6
3728 , ATTRIBUTE7
3729 , ATTRIBUTE8
3730 , ATTRIBUTE9
3731 , AUTO_SELECTED_QUANTITY
3732 , AUTHORIZED_TO_SHIP_FLAG
3733 , BOOKED_FLAG
3734 , CANCELLED_FLAG
3735 , CANCELLED_QUANTITY
3736 , COMPONENT_CODE
3737 , COMPONENT_NUMBER
3738 , COMPONENT_SEQUENCE_ID
3739 , CONFIG_HEADER_ID
3740 , CONFIG_REV_NBR
3741 , CONFIG_DISPLAY_SEQUENCE
3742 , CONFIGURATION_ID
3743 , CONTEXT
3744
3745 , CREATED_BY
3746 , CREATION_DATE
3747 , CREDIT_INVOICE_LINE_ID
3748 , CUSTOMER_DOCK_CODE
3749 , CUSTOMER_JOB
3750 , CUSTOMER_PRODUCTION_LINE
3751 , CUST_PRODUCTION_SEQ_NUM
3752 , CUSTOMER_TRX_LINE_ID
3753 , CUST_MODEL_SERIAL_NUMBER
3754 , CUST_PO_NUMBER
3755 , CUSTOMER_LINE_NUMBER
3756 , DELIVERY_LEAD_TIME
3757 , DELIVER_TO_CONTACT_ID
3758 , DELIVER_TO_ORG_ID
3759 , DEMAND_BUCKET_TYPE_CODE
3760 , DEMAND_CLASS_CODE
3761 , DEP_PLAN_REQUIRED_FLAG
3762
3763 , EARLIEST_ACCEPTABLE_DATE
3764 , END_ITEM_UNIT_NUMBER
3765 , EXPLOSION_DATE
3766 , FIRST_ACK_CODE
3767 , FIRST_ACK_DATE
3768 , FOB_POINT_CODE
3769 , FREIGHT_CARRIER_CODE
3770 , FREIGHT_TERMS_CODE
3771 , FULFILLED_QUANTITY
3772 , FULFILLED_FLAG
3773 , FULFILLMENT_METHOD_CODE
3774 , FULFILLMENT_DATE
3775 , GLOBAL_ATTRIBUTE1
3776 , GLOBAL_ATTRIBUTE10
3777 , GLOBAL_ATTRIBUTE11
3778 , GLOBAL_ATTRIBUTE12
3779 , GLOBAL_ATTRIBUTE13
3780 , GLOBAL_ATTRIBUTE14
3781 , GLOBAL_ATTRIBUTE15
3782 , GLOBAL_ATTRIBUTE16
3783 , GLOBAL_ATTRIBUTE17
3784 , GLOBAL_ATTRIBUTE18
3785 , GLOBAL_ATTRIBUTE19
3786 , GLOBAL_ATTRIBUTE2
3787 , GLOBAL_ATTRIBUTE20
3788 , GLOBAL_ATTRIBUTE3
3789 , GLOBAL_ATTRIBUTE4
3790 , GLOBAL_ATTRIBUTE5
3791 , GLOBAL_ATTRIBUTE6
3792 , GLOBAL_ATTRIBUTE7
3793 , GLOBAL_ATTRIBUTE8
3794 , GLOBAL_ATTRIBUTE9
3795 , GLOBAL_ATTRIBUTE_CATEGORY
3796 , HEADER_ID
3797 , INDUSTRY_ATTRIBUTE1
3798 , INDUSTRY_ATTRIBUTE10
3799 , INDUSTRY_ATTRIBUTE11
3800 , INDUSTRY_ATTRIBUTE12
3801 , INDUSTRY_ATTRIBUTE13
3802 , INDUSTRY_ATTRIBUTE14
3803 , INDUSTRY_ATTRIBUTE15
3804 , INDUSTRY_ATTRIBUTE16
3805 , INDUSTRY_ATTRIBUTE17
3806 , INDUSTRY_ATTRIBUTE18
3807 , INDUSTRY_ATTRIBUTE19
3808 , INDUSTRY_ATTRIBUTE20
3809 , INDUSTRY_ATTRIBUTE21
3810 , INDUSTRY_ATTRIBUTE22
3811 , INDUSTRY_ATTRIBUTE23
3812 , INDUSTRY_ATTRIBUTE24
3813 , INDUSTRY_ATTRIBUTE25
3814 , INDUSTRY_ATTRIBUTE26
3815 , INDUSTRY_ATTRIBUTE27
3816 , INDUSTRY_ATTRIBUTE28
3817 , INDUSTRY_ATTRIBUTE29
3818 , INDUSTRY_ATTRIBUTE30
3819 , INDUSTRY_ATTRIBUTE2
3820 , INDUSTRY_ATTRIBUTE3
3821 , INDUSTRY_ATTRIBUTE4
3822 , INDUSTRY_ATTRIBUTE5
3823 , INDUSTRY_ATTRIBUTE6
3824 , INDUSTRY_ATTRIBUTE7
3825 , INDUSTRY_ATTRIBUTE8
3826 , INDUSTRY_ATTRIBUTE9
3827 , INDUSTRY_CONTEXT
3828 , INTMED_SHIP_TO_CONTACT_ID
3829 , INTMED_SHIP_TO_ORG_ID
3830 , INVENTORY_ITEM_ID
3831 , INVOICE_INTERFACE_STATUS_CODE
3832
3833
3834
3835 , INVOICE_TO_CONTACT_ID
3836 , INVOICE_TO_ORG_ID
3837 , INVOICED_QUANTITY
3838 , INVOICING_RULE_ID
3839 , ORDERED_ITEM_ID
3840 , ITEM_IDENTIFIER_TYPE
3841 , ORDERED_ITEM
3842 , ITEM_REVISION
3843 , ITEM_TYPE_CODE
3844 , LAST_ACK_CODE
3845 , LAST_ACK_DATE
3846 , LAST_UPDATED_BY
3847 , LAST_UPDATE_DATE
3848 , LAST_UPDATE_LOGIN
3849 , LATEST_ACCEPTABLE_DATE
3850 , LINE_CATEGORY_CODE
3851 , LINE_ID
3852 , LINE_NUMBER
3853 , LINE_TYPE_ID
3854 , LINK_TO_LINE_ID
3855
3856 , MODEL_GROUP_NUMBER
3857 -- , MFG_COMPONENT_SEQUENCE_ID
3858 -- , MFG_LEAD_TIME
3859 , OPEN_FLAG
3860 , OPTION_FLAG
3861 , OPTION_NUMBER
3862 , ORDERED_QUANTITY
3863 , ORDERED_QUANTITY2 --OPM 02/JUN/00
3864 , ORDER_QUANTITY_UOM
3865 , ORDERED_QUANTITY_UOM2 --OPM 02/JUN/00
3866 , ORG_ID
3867 , ORIG_SYS_DOCUMENT_REF
3868 , ORIG_SYS_LINE_REF
3869 , ORIG_SYS_SHIPMENT_REF
3870 , OVER_SHIP_REASON_CODE
3871 , OVER_SHIP_RESOLVED_FLAG
3872 , PAYMENT_TERM_ID
3873 , PLANNING_PRIORITY
3874 , PREFERRED_GRADE --OPM 02/JUN/00
3875 , PRICE_LIST_ID
3876 , PRICE_REQUEST_CODE --PROMOTIONS SEP/01
3877 , PRICING_ATTRIBUTE1
3878 , PRICING_ATTRIBUTE10
3879 , PRICING_ATTRIBUTE2
3880 , PRICING_ATTRIBUTE3
3881 , PRICING_ATTRIBUTE4
3882 , PRICING_ATTRIBUTE5
3883 , PRICING_ATTRIBUTE6
3884 , PRICING_ATTRIBUTE7
3885 , PRICING_ATTRIBUTE8
3886 , PRICING_ATTRIBUTE9
3887 , PRICING_CONTEXT
3888 , PRICING_DATE
3889 , PRICING_QUANTITY
3890 , PRICING_QUANTITY_UOM
3891 , PROGRAM_APPLICATION_ID
3892 , PROGRAM_ID
3893 , PROGRAM_UPDATE_DATE
3894 , PROJECT_ID
3895 , PROMISE_DATE
3896 , RE_SOURCE_FLAG
3897 , REFERENCE_CUSTOMER_TRX_LINE_ID
3898 , REFERENCE_HEADER_ID
3899 , REFERENCE_LINE_ID
3900 , REFERENCE_TYPE
3901
3902 , REQUEST_DATE
3903 , REQUEST_ID
3904 , RETURN_ATTRIBUTE1
3905 , RETURN_ATTRIBUTE10
3906 , RETURN_ATTRIBUTE11
3907 , RETURN_ATTRIBUTE12
3908 , RETURN_ATTRIBUTE13
3909 , RETURN_ATTRIBUTE14
3910 , RETURN_ATTRIBUTE15
3911 , RETURN_ATTRIBUTE2
3912 , RETURN_ATTRIBUTE3
3913 , RETURN_ATTRIBUTE4
3914 , RETURN_ATTRIBUTE5
3915 , RETURN_ATTRIBUTE6
3916 , RETURN_ATTRIBUTE7
3917 , RETURN_ATTRIBUTE8
3918 , RETURN_ATTRIBUTE9
3919 , RETURN_CONTEXT
3920 , RETURN_REASON_CODE
3921 , RLA_SCHEDULE_TYPE_CODE
3922 , SALESREP_ID
3923 , SCHEDULE_ARRIVAL_DATE
3924 , SCHEDULE_SHIP_DATE
3925 , SCHEDULE_STATUS_CODE
3926 , SHIPMENT_NUMBER
3927 , SHIPMENT_PRIORITY_CODE
3928 , SHIPPED_QUANTITY
3929 , SHIPPED_QUANTITY2 -- OPM B1661023 04/02/01
3930 , SHIPPING_METHOD_CODE
3931 , SHIPPING_QUANTITY
3932 , SHIPPING_QUANTITY2 -- OPM B1661023 04/02/01
3933 , SHIPPING_QUANTITY_UOM
3934 , SHIP_FROM_ORG_ID
3935 , SUBINVENTORY
3936 , SHIP_SET_ID
3937 , SHIP_TOLERANCE_ABOVE
3938 , SHIP_TOLERANCE_BELOW
3939 , SHIPPABLE_FLAG
3940 , SHIPPING_INTERFACED_FLAG
3941 , SHIP_TO_CONTACT_ID
3942 , SHIP_TO_ORG_ID
3943 , SHIP_MODEL_COMPLETE_FLAG
3944 , SOLD_TO_ORG_ID
3945 , SOLD_FROM_ORG_ID
3946 , SORT_ORDER
3947 , SOURCE_DOCUMENT_ID
3948 , SOURCE_DOCUMENT_LINE_ID
3949 , SOURCE_DOCUMENT_TYPE_ID
3950 , SOURCE_TYPE_CODE
3951 , SPLIT_FROM_LINE_ID
3952 , LINE_SET_ID
3953 , SPLIT_BY
3954 , MODEL_REMNANT_FLAG
3955 , TASK_ID
3956 , TAX_CODE
3957 , TAX_DATE
3958 , TAX_EXEMPT_FLAG
3959 , TAX_EXEMPT_NUMBER
3960 , TAX_EXEMPT_REASON_CODE
3961 , TAX_POINT_CODE
3962 , TAX_RATE
3963 , TAX_VALUE
3964 , TOP_MODEL_LINE_ID
3965 , UNIT_LIST_PRICE
3966 , UNIT_LIST_PRICE_PER_PQTY
3967 , UNIT_SELLING_PRICE
3968 , UNIT_SELLING_PRICE_PER_PQTY
3969 , VISIBLE_DEMAND_FLAG
3970 , VEH_CUS_ITEM_CUM_KEY_ID
3971 , SHIPPING_INSTRUCTIONS
3972 , PACKING_INSTRUCTIONS
3973 , SERVICE_TXN_REASON_CODE
3974 , SERVICE_TXN_COMMENTS
3975 , SERVICE_DURATION
3976 , SERVICE_PERIOD
3977 , SERVICE_START_DATE
3978 , SERVICE_END_DATE
3979 , SERVICE_COTERMINATE_FLAG
3980 , UNIT_LIST_PERCENT
3981 , UNIT_SELLING_PERCENT
3982 , UNIT_PERCENT_BASE_PRICE
3983 , SERVICE_NUMBER
3984 , SERVICE_REFERENCE_TYPE_CODE
3985 , SERVICE_REFERENCE_LINE_ID
3986 , SERVICE_REFERENCE_SYSTEM_ID
3987 , TP_CONTEXT
3988 , TP_ATTRIBUTE1
3989 , TP_ATTRIBUTE2
3990 , TP_ATTRIBUTE3
3991 , TP_ATTRIBUTE4
3992 , TP_ATTRIBUTE5
3993 , TP_ATTRIBUTE6
3994 , TP_ATTRIBUTE7
3995 , TP_ATTRIBUTE8
3996 , TP_ATTRIBUTE9
3997 , TP_ATTRIBUTE10
3998 , TP_ATTRIBUTE11
3999 , TP_ATTRIBUTE12
4000 , TP_ATTRIBUTE13
4001 , TP_ATTRIBUTE14
4002 , TP_ATTRIBUTE15
4003 , FLOW_STATUS_CODE
4004 -- , MARKETING_SOURCE_CODE_ID
4005 , CALCULATE_PRICE_FLAG
4006 , COMMITMENT_ID
4007 , ORDER_SOURCE_ID -- aksingh
4008 -- , upgraded_flag
4009 , ORIGINAL_INVENTORY_ITEM_ID
4010 , ORIGINAL_ITEM_IDENTIFIER_TYPE
4011 , ORIGINAL_ORDERED_ITEM_ID
4012 , ORIGINAL_ORDERED_ITEM
4013 , ITEM_RELATIONSHIP_TYPE
4014 , ITEM_SUBSTITUTION_TYPE_CODE
4015 , LATE_DEMAND_PENALTY_FACTOR
4016 , OVERRIDE_ATP_DATE_CODE
4017 -- , FIRM_DEMAND_FLAG
4018 -- , EARLIEST_SHIP_DATE
4019 , USER_ITEM_DESCRIPTION
4020 , BLANKET_NUMBER
4021 , BLANKET_LINE_NUMBER
4022 , BLANKET_VERSION_NUMBER
4023 --MRG B
4024 -- , UNIT_COST
4025 --MRG E
4026 -- , LOCK_CONTROL
4027 , NVL(OPTION_NUMBER, -1) OPN
4028 , NVL(COMPONENT_NUMBER, -1) CPN
4029 , NVL(SERVICE_NUMBER, -1) SVN
4030 , CHANGE_SEQUENCE
4031 --key Transaction Dates
4032 , order_firmed_date
4033 , actual_fulfillment_date
4034 -- sol_ord_er #16014165
4035 ,SERVICE_BILL_PROFILE_ID
4036 ,SERVICE_COV_TEMPLATE_ID
4037 ,SERVICE_SUBS_TEMPLATE_ID
4038 ,SERVICE_BILL_OPTION_CODE
4039 ,SERVICE_FIRST_PERIOD_AMOUNT
4040 ,SUBSCRIPTION_ENABLE_FLAG
4041 ,SERVICE_FIRST_PERIOD_ENDDATE
4042 FROM OE_ORDER_LINES_HISTORY
4043 WHERE LINE_SET_ID = p_line_set_id
4044 AND VERSION_NUMBER = l_version_number
4045 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4046 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
4047 AND VERSION_FLAG = 'Y'))
4048 ORDER BY LINE_NUMBER,SHIPMENT_NUMBER,OPN, CPN, SVN;
4049
4050 l_rec l_line_csr_l%ROWTYPE;
4051 BEGIN
4052
4053 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
4054 l_current_version_number := Get_Version_Number(p_header_id => p_header_id, p_line_id => p_line_id);
4055
4056 IF l_version_number >= l_current_version_number THEN
4057 l_version_number := NULL;
4058 END IF;
4059 END IF;
4060
4061 IF l_version_number IS NULL THEN
4062 OE_Line_Util.Query_Rows(p_header_id => p_header_id, p_line_id => p_line_id, x_line_tbl => x_line_tbl);
4063 ELSE
4064
4065 IF
4066 (p_line_id IS NOT NULL
4067 AND
4068 p_line_id <> FND_API.G_MISS_NUM)
4069 AND
4070 (p_header_id IS NOT NULL
4071 AND
4072 p_header_id <> FND_API.G_MISS_NUM)
4073 THEN
4074
4075 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4076
4077 END IF;
4078
4079 -----------------------------------------------------------------
4080 -- Fix bug 1275972: Setup the l_entity variable based on the ID
4081 -- variable that is passed.
4082 -----------------------------------------------------------------
4083
4084 IF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4085 l_entity := 1;
4086 OPEN l_line_csr_l;
4087 ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4088 l_entity := 2;
4089 OPEN l_line_csr_h;
4090 ELSIF nvl(p_line_set_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4091 l_entity := 3;
4092 OPEN l_line_csr_s;
4093 END IF;
4094
4095 l_org_id := OE_GLOBALS.G_ORG_ID;
4096 if l_org_id IS NULL THEN
4097 OE_GLOBALS.Set_Context;
4098 l_org_id := OE_GLOBALS.G_ORG_ID;
4099 end if;
4100
4101 oe_debug_pub.add('Entering '||to_char(l_org_id), 1);
4102
4103
4104 -- Loop over fetched records
4105
4106 l_count := 1;
4107
4108 LOOP
4109
4110 IF l_entity = 1 THEN
4111 FETCH l_line_csr_l INTO l_rec;
4112 EXIT WHEN l_line_csr_l%NOTFOUND;
4113 ELSIF l_entity = 2 THEN
4114 FETCH l_line_csr_h INTO l_rec;
4115 EXIT WHEN l_line_csr_h%NOTFOUND;
4116 ELSIF l_entity = 3 THEN
4117 FETCH l_line_csr_s INTO l_rec;
4118 EXIT WHEN l_line_csr_s%NOTFOUND;
4119 ELSE
4120 EXIT;
4121 END IF;
4122
4123 x_line_tbl(l_count).accounting_rule_id := l_rec.ACCOUNTING_RULE_ID;
4124 x_line_tbl(l_count).accounting_rule_duration := l_rec.ACCOUNTING_RULE_DURATION;
4125 x_line_tbl(l_count).actual_arrival_date := l_rec.ACTUAL_ARRIVAL_DATE;
4126 x_line_tbl(l_count).actual_shipment_date := l_rec.ACTUAL_SHIPMENT_DATE;
4127 x_line_tbl(l_count).agreement_id := l_rec.AGREEMENT_ID;
4128 x_line_tbl(l_count).arrival_Set_id := l_rec.ARRIVAL_SET_ID;
4129 x_line_tbl(l_count).ato_line_id := l_rec.ATO_LINE_ID;
4130 x_line_tbl(l_count).attribute1 := l_rec.ATTRIBUTE1;
4131 x_line_tbl(l_count).attribute10 := l_rec.ATTRIBUTE10;
4132 x_line_tbl(l_count).attribute11 := l_rec.ATTRIBUTE11;
4133 x_line_tbl(l_count).attribute12 := l_rec.ATTRIBUTE12;
4134 x_line_tbl(l_count).attribute13 := l_rec.ATTRIBUTE13;
4135 x_line_tbl(l_count).attribute14 := l_rec.ATTRIBUTE14;
4136 x_line_tbl(l_count).attribute15 := l_rec.ATTRIBUTE15;
4137 x_line_tbl(l_count).attribute16 := l_rec.ATTRIBUTE16; --For bug 2184255
4138 x_line_tbl(l_count).attribute17 := l_rec.ATTRIBUTE17;
4139 x_line_tbl(l_count).attribute18 := l_rec.ATTRIBUTE18;
4140 x_line_tbl(l_count).attribute19 := l_rec.ATTRIBUTE19;
4141 x_line_tbl(l_count).attribute2 := l_rec.ATTRIBUTE2;
4142 x_line_tbl(l_count).attribute20 := l_rec.ATTRIBUTE20;
4143 x_line_tbl(l_count).attribute3 := l_rec.ATTRIBUTE3;
4144 x_line_tbl(l_count).attribute4 := l_rec.ATTRIBUTE4;
4145 x_line_tbl(l_count).attribute5 := l_rec.ATTRIBUTE5;
4146 x_line_tbl(l_count).attribute6 := l_rec.ATTRIBUTE6;
4147 x_line_tbl(l_count).attribute7 := l_rec.ATTRIBUTE7;
4148 x_line_tbl(l_count).attribute8 := l_rec.ATTRIBUTE8;
4149 x_line_tbl(l_count).attribute9 := l_rec.ATTRIBUTE9;
4150 x_line_tbl(l_count).auto_selected_quantity := l_rec.AUTO_SELECTED_QUANTITY;
4151 x_line_tbl(l_count).Authorized_to_ship_flag := l_rec.Authorized_to_ship_flag;
4152 x_line_tbl(l_count).booked_flag := l_rec.booked_flag;
4153 x_line_tbl(l_count).cancelled_flag := l_rec.cancelled_flag;
4154 x_line_tbl(l_count).cancelled_quantity := l_rec.CANCELLED_QUANTITY;
4155 x_line_tbl(l_count).component_code := l_rec.COMPONENT_CODE;
4156 x_line_tbl(l_count).component_number := l_rec.COMPONENT_NUMBER;
4157 x_line_tbl(l_count).component_sequence_id := l_rec.COMPONENT_SEQUENCE_ID;
4158 x_line_tbl(l_count).config_header_id := l_rec.CONFIG_HEADER_ID;
4159 x_line_tbl(l_count).config_rev_nbr := l_rec.CONFIG_REV_NBR;
4160 x_line_tbl(l_count).config_display_sequence := l_rec.CONFIG_DISPLAY_SEQUENCE;
4161 x_line_tbl(l_count).configuration_id := l_rec.CONFIGURATION_ID;
4162 x_line_tbl(l_count).context := l_rec.CONTEXT;
4163
4164 x_line_tbl(l_count).created_by := l_rec.CREATED_BY;
4165 x_line_tbl(l_count).creation_date := l_rec.CREATION_DATE;
4166 x_line_tbl(l_count).credit_invoice_line_id := l_rec.CREDIT_INVOICE_LINE_ID;
4167 x_line_tbl(l_count).customer_dock_code := l_rec.CUSTOMER_DOCK_CODE;
4168 x_line_tbl(l_count).customer_job := l_rec.CUSTOMER_JOB;
4169 x_line_tbl(l_count).customer_production_line := l_rec.CUSTOMER_PRODUCTION_LINE;
4170 x_line_tbl(l_count).cust_production_seq_num := l_rec.CUST_PRODUCTION_SEQ_NUM;
4171 x_line_tbl(l_count).customer_trx_line_id := l_rec.CUSTOMER_TRX_LINE_ID;
4172 x_line_tbl(l_count).cust_model_serial_number := l_rec.CUST_MODEL_SERIAL_NUMBER;
4173 x_line_tbl(l_count).cust_po_number := l_rec.CUST_PO_NUMBER;
4174 x_line_tbl(l_count).customer_line_number := l_rec.CUSTOMER_LINE_NUMBER;
4175 x_line_tbl(l_count).delivery_lead_time := l_rec.DELIVERY_LEAD_TIME;
4176 x_line_tbl(l_count).deliver_to_contact_id := l_rec.DELIVER_TO_CONTACT_ID;
4177 x_line_tbl(l_count).deliver_to_org_id := l_rec.DELIVER_TO_ORG_ID;
4178 x_line_tbl(l_count).demand_bucket_type_code := l_rec.DEMAND_BUCKET_TYPE_CODE;
4179 x_line_tbl(l_count).demand_class_code := l_rec.DEMAND_CLASS_CODE;
4180 x_line_tbl(l_count).dep_plan_required_flag := l_rec.DEP_PLAN_REQUIRED_FLAG;
4181
4182 x_line_tbl(l_count).earliest_acceptable_date := l_rec.EARLIEST_ACCEPTABLE_DATE;
4183 x_line_tbl(l_count).end_item_unit_number := l_rec.END_ITEM_UNIT_NUMBER;
4184 x_line_tbl(l_count).explosion_date := l_rec.EXPLOSION_DATE;
4185 x_line_tbl(l_count).first_ack_code := l_rec.FIRST_ACK_CODE;
4186 x_line_tbl(l_count).first_ack_date := l_rec.FIRST_ACK_DATE;
4187 x_line_tbl(l_count).fob_point_code := l_rec.FOB_POINT_CODE;
4188 x_line_tbl(l_count).freight_carrier_code := l_rec.FREIGHT_CARRIER_CODE;
4189 x_line_tbl(l_count).freight_terms_code := l_rec.FREIGHT_TERMS_CODE;
4190 x_line_tbl(l_count).fulfilled_quantity := l_rec.FULFILLED_QUANTITY;
4191 x_line_tbl(l_count).fulfilled_flag := l_rec.FULFILLED_FLAG;
4192 x_line_tbl(l_count).fulfillment_method_code := l_rec.FULFILLMENT_METHOD_CODE;
4193 x_line_tbl(l_count).fulfillment_date := l_rec.FULFILLMENT_DATE;
4194 x_line_tbl(l_count).global_attribute1 := l_rec.GLOBAL_ATTRIBUTE1;
4195 x_line_tbl(l_count).global_attribute10 := l_rec.GLOBAL_ATTRIBUTE10;
4196 x_line_tbl(l_count).global_attribute11 := l_rec.GLOBAL_ATTRIBUTE11;
4197 x_line_tbl(l_count).global_attribute12 := l_rec.GLOBAL_ATTRIBUTE12;
4198 x_line_tbl(l_count).global_attribute13 := l_rec.GLOBAL_ATTRIBUTE13;
4199 x_line_tbl(l_count).global_attribute14 := l_rec.GLOBAL_ATTRIBUTE14;
4200 x_line_tbl(l_count).global_attribute15 := l_rec.GLOBAL_ATTRIBUTE15;
4201 x_line_tbl(l_count).global_attribute16 := l_rec.GLOBAL_ATTRIBUTE16;
4202 x_line_tbl(l_count).global_attribute17 := l_rec.GLOBAL_ATTRIBUTE17;
4203 x_line_tbl(l_count).global_attribute18 := l_rec.GLOBAL_ATTRIBUTE18;
4204 x_line_tbl(l_count).global_attribute19 := l_rec.GLOBAL_ATTRIBUTE19;
4205 x_line_tbl(l_count).global_attribute2 := l_rec.GLOBAL_ATTRIBUTE2;
4206 x_line_tbl(l_count).global_attribute20 := l_rec.GLOBAL_ATTRIBUTE20;
4207 x_line_tbl(l_count).global_attribute3 := l_rec.GLOBAL_ATTRIBUTE3;
4208 x_line_tbl(l_count).global_attribute4 := l_rec.GLOBAL_ATTRIBUTE4;
4209 x_line_tbl(l_count).global_attribute5 := l_rec.GLOBAL_ATTRIBUTE5;
4210 x_line_tbl(l_count).global_attribute6 := l_rec.GLOBAL_ATTRIBUTE6;
4211 x_line_tbl(l_count).global_attribute7 := l_rec.GLOBAL_ATTRIBUTE7;
4212 x_line_tbl(l_count).global_attribute8 := l_rec.GLOBAL_ATTRIBUTE8;
4213 x_line_tbl(l_count).global_attribute9 := l_rec.GLOBAL_ATTRIBUTE9;
4214 x_line_tbl(l_count).global_attribute_category := l_rec.GLOBAL_ATTRIBUTE_CATEGORY;
4215 x_line_tbl(l_count).header_id := l_rec.HEADER_ID;
4216 x_line_tbl(l_count).industry_attribute1 := l_rec.INDUSTRY_ATTRIBUTE1;
4217 x_line_tbl(l_count).industry_attribute10 := l_rec.INDUSTRY_ATTRIBUTE10;
4218 x_line_tbl(l_count).industry_attribute11 := l_rec.INDUSTRY_ATTRIBUTE11;
4219 x_line_tbl(l_count).industry_attribute12 := l_rec.INDUSTRY_ATTRIBUTE12;
4220 x_line_tbl(l_count).industry_attribute13 := l_rec.INDUSTRY_ATTRIBUTE13;
4221 x_line_tbl(l_count).industry_attribute14 := l_rec.INDUSTRY_ATTRIBUTE14;
4222 x_line_tbl(l_count).industry_attribute15 := l_rec.INDUSTRY_ATTRIBUTE15;
4223 x_line_tbl(l_count).industry_attribute16 := l_rec.INDUSTRY_ATTRIBUTE16;
4224 x_line_tbl(l_count).industry_attribute17 := l_rec.INDUSTRY_ATTRIBUTE17;
4225 x_line_tbl(l_count).industry_attribute18 := l_rec.INDUSTRY_ATTRIBUTE18;
4226 x_line_tbl(l_count).industry_attribute19 := l_rec.INDUSTRY_ATTRIBUTE19;
4227 x_line_tbl(l_count).industry_attribute20 := l_rec.INDUSTRY_ATTRIBUTE20;
4228 x_line_tbl(l_count).industry_attribute21 := l_rec.INDUSTRY_ATTRIBUTE21;
4229 x_line_tbl(l_count).industry_attribute22 := l_rec.INDUSTRY_ATTRIBUTE22;
4230 x_line_tbl(l_count).industry_attribute23:= l_rec.INDUSTRY_ATTRIBUTE23;
4231 x_line_tbl(l_count).industry_attribute24 := l_rec.INDUSTRY_ATTRIBUTE24;
4232 x_line_tbl(l_count).industry_attribute25 := l_rec.INDUSTRY_ATTRIBUTE25;
4233 x_line_tbl(l_count).industry_attribute26 := l_rec.INDUSTRY_ATTRIBUTE26;
4234 x_line_tbl(l_count).industry_attribute27 := l_rec.INDUSTRY_ATTRIBUTE27;
4235 x_line_tbl(l_count).industry_attribute28 := l_rec.INDUSTRY_ATTRIBUTE28;
4236 x_line_tbl(l_count).industry_attribute29 := l_rec.INDUSTRY_ATTRIBUTE29;
4237 x_line_tbl(l_count).industry_attribute30 := l_rec.INDUSTRY_ATTRIBUTE30;
4238 x_line_tbl(l_count).industry_attribute2 := l_rec.INDUSTRY_ATTRIBUTE2;
4239 x_line_tbl(l_count).industry_attribute3 := l_rec.INDUSTRY_ATTRIBUTE3;
4240 x_line_tbl(l_count).industry_attribute4 := l_rec.INDUSTRY_ATTRIBUTE4;
4241 x_line_tbl(l_count).industry_attribute5 := l_rec.INDUSTRY_ATTRIBUTE5;
4242 x_line_tbl(l_count).industry_attribute6 := l_rec.INDUSTRY_ATTRIBUTE6;
4243 x_line_tbl(l_count).industry_attribute7 := l_rec.INDUSTRY_ATTRIBUTE7;
4244 x_line_tbl(l_count).industry_attribute8 := l_rec.INDUSTRY_ATTRIBUTE8;
4245 x_line_tbl(l_count).industry_attribute9 := l_rec.INDUSTRY_ATTRIBUTE9;
4246 x_line_tbl(l_count).industry_context := l_rec.INDUSTRY_CONTEXT;
4247 x_line_tbl(l_count).intermed_ship_to_contact_id := l_rec.INTMED_SHIP_TO_CONTACT_ID;
4248 x_line_tbl(l_count).intermed_ship_to_org_id := l_rec.INTMED_SHIP_TO_ORG_ID;
4249 x_line_tbl(l_count).inventory_item_id := l_rec.INVENTORY_ITEM_ID;
4250 x_line_tbl(l_count).invoice_interface_status_code := l_rec.INVOICE_INTERFACE_STATUS_CODE;
4251
4252 x_line_tbl(l_count).invoice_to_contact_id := l_rec.INVOICE_TO_CONTACT_ID;
4253 x_line_tbl(l_count).invoice_to_org_id := l_rec.INVOICE_TO_ORG_ID;
4254 x_line_tbl(l_count).invoiced_quantity := l_rec.INVOICED_QUANTITY;
4255 x_line_tbl(l_count).invoicing_rule_id := l_rec.INVOICING_RULE_ID;
4256 x_line_tbl(l_count).ordered_item_id := l_rec.ORDERED_ITEM_ID;
4257 x_line_tbl(l_count).item_identifier_type := l_rec.ITEM_IDENTIFIER_TYPE;
4258 x_line_tbl(l_count).ordered_item := l_rec.ORDERED_ITEM;
4259 x_line_tbl(l_count).item_revision := l_rec.ITEM_REVISION;
4260 x_line_tbl(l_count).item_type_code := l_rec.ITEM_TYPE_CODE;
4261 x_line_tbl(l_count).last_ack_code := l_rec.LAST_ACK_CODE;
4262 x_line_tbl(l_count).last_ack_date := l_rec.LAST_ACK_DATE;
4263 x_line_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
4264 x_line_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
4265 x_line_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
4266 x_line_tbl(l_count).latest_acceptable_date := l_rec.LATEST_ACCEPTABLE_DATE;
4267 x_line_tbl(l_count).line_category_code := l_rec.LINE_CATEGORY_CODE;
4268 x_line_tbl(l_count).line_id := l_rec.LINE_ID;
4269 x_line_tbl(l_count).line_number := l_rec.LINE_NUMBER;
4270 x_line_tbl(l_count).line_type_id := l_rec.LINE_TYPE_ID;
4271 x_line_tbl(l_count).link_to_line_id := l_rec.LINK_TO_LINE_ID;
4272
4273 x_line_tbl(l_count).model_group_number := l_rec.MODEL_GROUP_NUMBER;
4274 -- x_line_tbl(l_count).mfg_component_sequence_id := l_rec.MFG_COMPONENT_SEQUENCE_ID;
4275 -- x_line_tbl(l_count).mfg_lead_time := l_rec.MFG_LEAD_TIME;
4276 x_line_tbl(l_count).open_flag := l_rec.open_flag;
4277 x_line_tbl(l_count).option_flag := l_rec.OPTION_FLAG;
4278 x_line_tbl(l_count).option_number := l_rec.OPTION_NUMBER;
4279 x_line_tbl(l_count).ordered_quantity := l_rec.ORDERED_QUANTITY;
4280 x_line_tbl(l_count).ordered_quantity2 := l_rec.ORDERED_QUANTITY2; -- OPM
4281 x_line_tbl(l_count).order_quantity_uom := l_rec.ORDER_QUANTITY_UOM;
4282 x_line_tbl(l_count).ordered_quantity_uom2 := l_rec.ORDERED_QUANTITY_UOM2; -- OPM
4283 x_line_tbl(l_count).org_id := l_rec.ORG_ID;
4284 x_line_tbl(l_count).orig_sys_document_ref := l_rec.ORIG_SYS_DOCUMENT_REF;
4285 x_line_tbl(l_count).orig_sys_line_ref := l_rec.ORIG_SYS_LINE_REF;
4286 x_line_tbl(l_count).orig_sys_shipment_ref := l_rec.ORIG_SYS_SHIPMENT_REF;
4287 x_line_tbl(l_count).over_ship_reason_code := l_rec.OVER_SHIP_REASON_CODE;
4288 x_line_tbl(l_count).over_ship_resolved_flag := l_rec.OVER_SHIP_RESOLVED_FLAG;
4289 x_line_tbl(l_count).source_document_line_id := l_rec.SOURCE_DOCUMENT_LINE_ID;
4290 x_line_tbl(l_count).payment_term_id := l_rec.PAYMENT_TERM_ID;
4291 x_line_tbl(l_count).planning_priority := l_rec.PLANNING_PRIORITY;
4292 x_line_tbl(l_count).preferred_grade := l_rec.PREFERRED_GRADE; -- OPM
4293 x_line_tbl(l_count).price_list_id := l_rec.PRICE_LIST_ID;
4294 x_line_tbl(l_count).price_request_code := l_rec.PRICE_REQUEST_CODE; -- PROMOTIONS SEP/01
4295 x_line_tbl(l_count).pricing_attribute1 := l_rec.PRICING_ATTRIBUTE1;
4296 x_line_tbl(l_count).pricing_attribute10 := l_rec.PRICING_ATTRIBUTE10;
4297 x_line_tbl(l_count).pricing_attribute2 := l_rec.PRICING_ATTRIBUTE2;
4298 x_line_tbl(l_count).pricing_attribute3 := l_rec.PRICING_ATTRIBUTE3;
4299 x_line_tbl(l_count).pricing_attribute4 := l_rec.PRICING_ATTRIBUTE4;
4300 x_line_tbl(l_count).pricing_attribute5 := l_rec.PRICING_ATTRIBUTE5;
4301 x_line_tbl(l_count).pricing_attribute6 := l_rec.PRICING_ATTRIBUTE6;
4302 x_line_tbl(l_count).pricing_attribute7 := l_rec.PRICING_ATTRIBUTE7;
4303 x_line_tbl(l_count).pricing_attribute8 := l_rec.PRICING_ATTRIBUTE8;
4304 x_line_tbl(l_count).pricing_attribute9 := l_rec.PRICING_ATTRIBUTE9;
4305 x_line_tbl(l_count).pricing_context := l_rec.PRICING_CONTEXT;
4306 x_line_tbl(l_count).pricing_date := l_rec.PRICING_DATE;
4307 x_line_tbl(l_count).pricing_quantity := l_rec.PRICING_QUANTITY;
4308 x_line_tbl(l_count).pricing_quantity_uom := l_rec.PRICING_QUANTITY_UOM;
4309 x_line_tbl(l_count).program_application_id := l_rec.PROGRAM_APPLICATION_ID;
4310 x_line_tbl(l_count).program_id := l_rec.PROGRAM_ID;
4311 x_line_tbl(l_count).program_update_date := l_rec.PROGRAM_UPDATE_DATE;
4312 x_line_tbl(l_count).project_id := l_rec.PROJECT_ID;
4313 x_line_tbl(l_count).promise_date := l_rec.PROMISE_DATE;
4314 x_line_tbl(l_count).re_source_flag := l_rec.RE_SOURCE_FLAG;
4315 x_line_tbl(l_count).reference_customer_trx_line_id := l_rec.reference_customer_trx_line_id;
4316 x_line_tbl(l_count).reference_header_id := l_rec.REFERENCE_HEADER_ID;
4317 x_line_tbl(l_count).reference_line_id := l_rec.REFERENCE_LINE_ID;
4318 x_line_tbl(l_count).reference_type := l_rec.REFERENCE_TYPE;
4319
4320 x_line_tbl(l_count).request_date := l_rec.REQUEST_DATE;
4321 x_line_tbl(l_count).request_id := l_rec.REQUEST_ID;
4322 x_line_tbl(l_count).return_attribute1 := l_rec.RETURN_ATTRIBUTE1;
4323 x_line_tbl(l_count).return_attribute10 := l_rec.RETURN_ATTRIBUTE10;
4324 x_line_tbl(l_count).return_attribute11 := l_rec.RETURN_ATTRIBUTE11;
4325 x_line_tbl(l_count).return_attribute12 := l_rec.RETURN_ATTRIBUTE12;
4326 x_line_tbl(l_count).return_attribute13 := l_rec.RETURN_ATTRIBUTE13;
4327 x_line_tbl(l_count).return_attribute14 := l_rec.RETURN_ATTRIBUTE14;
4328 x_line_tbl(l_count).return_attribute15 := l_rec.RETURN_ATTRIBUTE15;
4329 x_line_tbl(l_count).return_attribute2 := l_rec.RETURN_ATTRIBUTE2;
4330 x_line_tbl(l_count).return_attribute3 := l_rec.RETURN_ATTRIBUTE3;
4331 x_line_tbl(l_count).return_attribute4 := l_rec.RETURN_ATTRIBUTE4;
4332 x_line_tbl(l_count).return_attribute5 := l_rec.RETURN_ATTRIBUTE5;
4333 x_line_tbl(l_count).return_attribute6 := l_rec.RETURN_ATTRIBUTE6;
4334 x_line_tbl(l_count).return_attribute7 := l_rec.RETURN_ATTRIBUTE7;
4335 x_line_tbl(l_count).return_attribute8 := l_rec.RETURN_ATTRIBUTE8;
4336 x_line_tbl(l_count).return_attribute9 := l_rec.RETURN_ATTRIBUTE9;
4337 x_line_tbl(l_count).return_context := l_rec.RETURN_CONTEXT;
4338 x_line_tbl(l_count).return_reason_code := l_rec.RETURN_REASON_CODE;
4339 x_line_tbl(l_count).salesrep_id := l_rec.SALESREP_ID;
4340 x_line_tbl(l_count).rla_schedule_type_code := l_rec.RLA_SCHEDULE_TYPE_CODE;
4341 x_line_tbl(l_count).schedule_arrival_date := l_rec.SCHEDULE_ARRIVAL_DATE;
4342 x_line_tbl(l_count).schedule_ship_date := l_rec.SCHEDULE_SHIP_DATE;
4343 x_line_tbl(l_count).schedule_status_code := l_rec.SCHEDULE_STATUS_CODE;
4344 x_line_tbl(l_count).shipment_number := l_rec.SHIPMENT_NUMBER;
4345 x_line_tbl(l_count).shipment_priority_code := l_rec.SHIPMENT_PRIORITY_CODE;
4346 x_line_tbl(l_count).shipped_quantity := l_rec.SHIPPED_QUANTITY;
4347 x_line_tbl(l_count).shipped_quantity2 := l_rec.SHIPPED_QUANTITY2; -- OPM B1661023 04/02/01
4348 x_line_tbl(l_count).shipping_method_code := l_rec.SHIPPING_METHOD_CODE;
4349 x_line_tbl(l_count).shipping_quantity := l_rec.SHIPPING_QUANTITY;
4350 x_line_tbl(l_count).shipping_quantity2 := l_rec.SHIPPING_QUANTITY2; -- OPM B1661023 04/02/01
4351 x_line_tbl(l_count).shipping_quantity_uom := l_rec.SHIPPING_QUANTITY_UOM;
4352 x_line_tbl(l_count).ship_from_org_id := l_rec.SHIP_FROM_ORG_ID;
4353 x_line_tbl(l_count).subinventory := l_rec.SUBINVENTORY;
4354 x_line_tbl(l_count).ship_set_id := l_rec.SHIP_SET_ID;
4355 x_line_tbl(l_count).ship_tolerance_above := l_rec.SHIP_TOLERANCE_ABOVE;
4356 x_line_tbl(l_count).ship_tolerance_below := l_rec.SHIP_TOLERANCE_BELOW;
4357 x_line_tbl(l_count).shippable_flag := l_rec.SHIPPABLE_FLAG;
4358 x_line_tbl(l_count).shipping_interfaced_flag := l_rec.SHIPPING_INTERFACED_FLAG;
4359 x_line_tbl(l_count).ship_to_contact_id := l_rec.SHIP_TO_CONTACT_ID;
4360 x_line_tbl(l_count).ship_to_org_id := l_rec.SHIP_TO_ORG_ID;
4361 x_line_tbl(l_count).ship_model_complete_flag := l_rec.SHIP_MODEL_COMPLETE_FLAG;
4362
4363 x_line_tbl(l_count).sold_to_org_id := l_rec.SOLD_TO_ORG_ID;
4364 x_line_tbl(l_count).sold_from_org_id := l_rec.SOLD_FROM_ORG_ID;
4365 x_line_tbl(l_count).sort_order := l_rec.SORT_ORDER;
4366 x_line_tbl(l_count).source_document_id := l_rec.SOURCE_DOCUMENT_ID;
4367 x_line_tbl(l_count).source_document_line_id := l_rec.SOURCE_DOCUMENT_LINE_ID;
4368 x_line_tbl(l_count).source_document_type_id := l_rec.SOURCE_DOCUMENT_TYPE_ID;
4369 x_line_tbl(l_count).source_type_code := l_rec.SOURCE_TYPE_CODE;
4370 x_line_tbl(l_count).split_from_line_id := l_rec.SPLIT_FROM_LINE_ID;
4371 x_line_tbl(l_count).line_set_id := l_rec.LINE_SET_ID;
4372 x_line_tbl(l_count).split_by := l_rec.SPLIT_BY;
4373 x_line_tbl(l_count).model_remnant_flag := l_rec.MODEL_REMNANT_FLAG;
4374 x_line_tbl(l_count).task_id := l_rec.TASK_ID;
4375 x_line_tbl(l_count).tax_code := l_rec.TAX_CODE;
4376 x_line_tbl(l_count).tax_date := l_rec.TAX_DATE;
4377 x_line_tbl(l_count).tax_exempt_flag := l_rec.TAX_EXEMPT_FLAG;
4378 x_line_tbl(l_count).tax_exempt_number := l_rec.TAX_EXEMPT_NUMBER;
4379 x_line_tbl(l_count).tax_exempt_reason_code := l_rec.TAX_EXEMPT_REASON_CODE;
4380 x_line_tbl(l_count).tax_point_code := l_rec.TAX_POINT_CODE;
4381 x_line_tbl(l_count).tax_rate := l_rec.TAX_RATE;
4382 x_line_tbl(l_count).tax_value := l_rec.TAX_VALUE;
4383 x_line_tbl(l_count).top_model_line_id := l_rec.TOP_MODEL_LINE_ID;
4384 x_line_tbl(l_count).unit_list_price := l_rec.UNIT_LIST_PRICE;
4385 x_line_tbl(l_count).unit_list_price_per_pqty := l_rec.UNIT_LIST_PRICE_PER_PQTY;
4386 x_line_tbl(l_count).unit_selling_price := l_rec.UNIT_SELLING_PRICE;
4387 x_line_tbl(l_count).unit_selling_price_per_pqty := l_rec.UNIT_SELLING_PRICE_PER_PQTY;
4388 x_line_tbl(l_count).visible_demand_flag := l_rec.VISIBLE_DEMAND_FLAG;
4389 x_line_tbl(l_count).veh_cus_item_cum_key_id := l_rec.VEH_CUS_ITEM_CUM_KEY_ID;
4390 x_line_tbl(l_count).shipping_instructions := l_rec.shipping_instructions;
4391 x_line_tbl(l_count).packing_instructions := l_rec.packing_instructions;
4392 x_line_tbl(l_count).service_txn_reason_code := l_rec.service_txn_reason_code;
4393 x_line_tbl(l_count).service_txn_comments := l_rec.service_txn_comments;
4394 x_line_tbl(l_count).service_duration := l_rec.service_duration;
4395 x_line_tbl(l_count).service_period := l_rec.service_period;
4396 x_line_tbl(l_count).service_start_date := l_rec.service_start_date;
4397 x_line_tbl(l_count).service_end_date := l_rec.service_end_date;
4398 x_line_tbl(l_count).service_coterminate_flag := l_rec.service_coterminate_flag;
4399 x_line_tbl(l_count).unit_list_percent := l_rec.unit_list_percent;
4400 x_line_tbl(l_count).unit_selling_percent := l_rec.unit_selling_percent;
4401 x_line_tbl(l_count).unit_percent_base_price := l_rec.unit_percent_base_price;
4402 x_line_tbl(l_count).service_number := l_rec.service_number;
4403 x_line_tbl(l_count).service_reference_type_code := l_rec.service_reference_type_code;
4404 x_line_tbl(l_count).service_reference_line_id:= l_rec.service_reference_line_id;
4405 x_line_tbl(l_count).service_reference_system_id:= l_rec.service_reference_system_id;
4406
4407 x_line_tbl(l_count).tp_context := l_rec.tp_context;
4408 x_line_tbl(l_count).tp_attribute1 := l_rec.tp_attribute1;
4409 x_line_tbl(l_count).tp_attribute2 := l_rec.tp_attribute2;
4410 x_line_tbl(l_count).tp_attribute3 := l_rec.tp_attribute3;
4411 x_line_tbl(l_count).tp_attribute4 := l_rec.tp_attribute4;
4412 x_line_tbl(l_count).tp_attribute5 := l_rec.tp_attribute5;
4413 x_line_tbl(l_count).tp_attribute6 := l_rec.tp_attribute6;
4414 x_line_tbl(l_count).tp_attribute7 := l_rec.tp_attribute7;
4415 x_line_tbl(l_count).tp_attribute8 := l_rec.tp_attribute8;
4416 x_line_tbl(l_count).tp_attribute9 := l_rec.tp_attribute9;
4417 x_line_tbl(l_count).tp_attribute10:= l_rec.tp_attribute10;
4418 x_line_tbl(l_count).tp_attribute11:= l_rec.tp_attribute11;
4419 x_line_tbl(l_count).tp_attribute12:= l_rec.tp_attribute12;
4420 x_line_tbl(l_count).tp_attribute13:= l_rec.tp_attribute13;
4421 x_line_tbl(l_count).tp_attribute14:= l_rec.tp_attribute14;
4422 x_line_tbl(l_count).tp_attribute15:= l_rec.tp_attribute15;
4423 x_line_tbl(l_count).flow_status_code := l_rec.flow_status_code;
4424 -- x_line_tbl(l_count).marketing_source_code_id := l_rec.marketing_source_code_id;
4425 x_line_tbl(l_count).calculate_price_flag := l_rec.calculate_price_flag;
4426 x_line_tbl(l_count).commitment_id := l_rec.commitment_id;
4427 -- oe_debug_pub.add('OEXULINB -aksingh -- assigning order_source_id value ' || l_rec.order_source_id);
4428 x_line_tbl(l_count).order_source_id := l_rec.order_source_id;
4429 -- x_line_tbl(l_count).upgraded_flag := l_rec.upgraded_flag ;
4430 x_line_tbl(l_count).Original_Inventory_Item_Id := l_rec.Original_Inventory_Item_Id ;
4431 x_line_tbl(l_count).Original_item_identifier_Type := l_rec.Original_item_identifier_Type ;
4432 x_line_tbl(l_count).Original_ordered_item_id := l_rec.Original_ordered_item_id ;
4433 x_line_tbl(l_count).Original_ordered_item := l_rec.Original_ordered_item ;
4434 x_line_tbl(l_count).Item_Relationship_Type := l_rec.Item_Relationship_Type ;
4435 x_line_tbl(l_count).Item_substitution_type_code := l_rec.Item_substitution_type_code ;
4436 x_line_tbl(l_count).Late_Demand_Penalty_Factor := l_rec.Late_Demand_Penalty_Factor ;
4437 x_line_tbl(l_count).Override_atp_date_code := l_rec.Override_atp_date_code ;
4438 -- x_line_tbl(l_count).Firm_Demand_Flag := l_rec.Firm_Demand_Flag ;
4439 -- x_line_tbl(l_count).Earliest_ship_Date := l_rec.Earliest_ship_Date ;
4440 x_line_tbl(l_count).user_item_description := l_rec.user_item_description ;
4441
4442 -- Changes for Blanket Orders
4443 x_line_tbl(l_count).Blanket_Number := l_rec.Blanket_Number;
4444 x_line_tbl(l_count).Blanket_Line_Number := l_rec.Blanket_Line_Number;
4445 x_line_tbl(l_count).Blanket_Version_Number := l_rec.Blanket_Version_Number;
4446
4447 -- Adding change sequence
4448
4449 x_line_tbl(l_count).change_sequence := l_rec.change_sequence;
4450 --Key Transaction Dates
4451 x_line_tbl(l_count).order_firmed_date := l_rec.order_firmed_date;
4452 x_line_tbl(l_count).actual_fulfillment_date:= l_rec.actual_fulfillment_date;
4453 --end
4454 -- sol_ord_er #16014165
4455 x_line_tbl(l_count).SERVICE_BILL_PROFILE_ID := l_rec.SERVICE_BILL_PROFILE_ID;
4456 x_line_tbl(l_count).SERVICE_COV_TEMPLATE_ID := l_rec.SERVICE_COV_TEMPLATE_ID;
4457 x_line_tbl(l_count).SERVICE_SUBS_TEMPLATE_ID := l_rec.SERVICE_SUBS_TEMPLATE_ID;
4458 x_line_tbl(l_count).SERVICE_BILL_OPTION_CODE := l_rec.SERVICE_BILL_OPTION_CODE;
4459 x_line_tbl(l_count).SERVICE_FIRST_PERIOD_AMOUNT := l_rec.SERVICE_FIRST_PERIOD_AMOUNT;
4460 x_line_tbl(l_count).SUBSCRIPTION_ENABLE_FLAG := l_rec.SUBSCRIPTION_ENABLE_FLAG;
4461 x_line_tbl(l_count).SERVICE_FIRST_PERIOD_ENDDATE := l_rec.SERVICE_FIRST_PERIOD_ENDDATE;
4462 -- sol_ord_er #16014165 end
4463
4464 -- oe_debug_pub.add('outside margin x_line_tbl',1);
4465 --MRG B
4466 --If OE_FEATURES_PVT.Is_Margin_Avail Then
4467 -- oe_debug_pub.add('inside margin x_line_tbl',1);
4468 --x_line_tbl(l_count).unit_cost:=l_rec.unit_cost;
4469 --End If;
4470 --MRG E
4471 -- x_line_tbl(l_count).lock_control:= l_rec.lock_control;
4472
4473 -- Added for COPY ER 1480867
4474 --l_OPN := l_rec.OPN;
4475 --l_CPN := l_rec.CPN;
4476 --l_SVN := l_rec.SVN;
4477
4478
4479 -- set values for non-DB fields
4480 x_line_tbl(l_count).db_flag := FND_API.G_TRUE;
4481 x_line_tbl(l_count).operation := FND_API.G_MISS_CHAR;
4482 x_line_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
4483
4484 x_line_tbl(l_count).schedule_action_code := FND_API.G_MISS_CHAR;
4485 x_line_tbl(l_count).reserved_quantity := FND_API.G_MISS_NUM;
4486 x_line_tbl(l_count).change_reason := FND_API.G_MISS_CHAR;
4487 x_line_tbl(l_count).change_comments := FND_API.G_MISS_CHAR;
4488 x_line_tbl(l_count).arrival_set := FND_API.G_MISS_CHAR;
4489 x_line_tbl(l_count).ship_set := FND_API.G_MISS_CHAR;
4490 x_line_tbl(l_count).fulfillment_set := FND_API.G_MISS_CHAR;
4491 x_line_tbl(l_count).split_action_code := FND_API.G_MISS_CHAR;
4492 l_count := l_count + 1;
4493
4494 END LOOP;
4495
4496 IF l_entity = 1 THEN
4497 CLOSE l_line_csr_l;
4498 ELSIF l_entity = 2 THEN
4499 CLOSE l_line_csr_h;
4500 ELSIF l_entity = 3 THEN
4501 CLOSE l_line_csr_s;
4502 END IF;
4503
4504 -- PK sent and no rows found
4505
4506 IF
4507 (p_line_id IS NOT NULL
4508 AND
4509 p_line_id <> FND_API.G_MISS_NUM)
4510 AND
4511 (x_line_tbl.COUNT = 0)
4512 THEN
4513 RAISE NO_DATA_FOUND;
4514 END IF;
4515
4516 END IF;
4517
4518 EXCEPTION
4519 WHEN OTHERS THEN
4520 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4521 OE_MSG_PUB.Add_Exc_Msg
4522 ( G_PKG_NAME
4523 , 'Line Query_Rows'
4524 );
4525 END IF;
4526 END;
4527
4528
4529 -- Line Adj Query_Row
4530 PROCEDURE Query_Row
4531 ( p_price_adjustment_id IN NUMBER
4532 , p_version_number IN NUMBER := NULL
4533 , p_phase_change_flag IN VARCHAR2 := NULL
4534 , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4535 )
4536 IS
4537 l_version_number NUMBER := p_version_number;
4538 l_current_version_number NUMBER;
4539 l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4540 BEGIN
4541 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
4542 l_current_version_number := Get_Version_Number(p_price_adjustment_id => p_price_adjustment_id);
4543 IF l_version_number >= l_current_version_number THEN
4544 l_version_number := NULL;
4545 END IF;
4546 END IF;
4547
4548 IF l_version_number IS NULL THEN
4549 OE_Line_Adj_Util.Query_Row(p_price_adjustment_id => p_price_adjustment_id, x_line_adj_rec => x_line_adj_rec);
4550 ELSE
4551 G_INTERNAL_QUERY := TRUE;
4552 Query_Rows
4553 ( p_price_adjustment_id => p_price_adjustment_id
4554 , p_version_number => l_version_number
4555 , x_Line_Adj_Tbl => l_Line_Adj_Tbl
4556 );
4557 x_Line_Adj_Rec := l_Line_Adj_Tbl(1);
4558
4559 G_INTERNAL_QUERY := FALSE;
4560
4561 END IF;
4562
4563 EXCEPTION
4564 WHEN OTHERS THEN
4565 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4566 OE_MSG_PUB.Add_Exc_Msg
4567 ( G_PKG_NAME
4568 , 'Line Adj Query_Row'
4569 );
4570 END IF;
4571 END;
4572
4573
4574 -- Line Adj Query_Rows
4575 PROCEDURE Query_Rows
4576 ( p_price_adjustment_id IN NUMBER :=
4577 FND_API.G_MISS_NUM
4578 , p_line_id IN NUMBER :=
4579 FND_API.G_MISS_NUM
4580 , p_Header_id IN NUMBER :=
4581 FND_API.G_MISS_NUM
4582 , p_version_number IN NUMBER := NULL
4583 , p_phase_change_flag IN VARCHAR2 := NULL
4584 , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
4585 )
4586 IS
4587 l_version_number NUMBER := p_version_number;
4588 l_current_version_number NUMBER;
4589 l_count NUMBER;
4590 l_entity NUMBER;
4591
4592 CURSOR l_Line_Adj_csr_p IS
4593 SELECT ATTRIBUTE1
4594 , ATTRIBUTE10
4595 , ATTRIBUTE11
4596 , ATTRIBUTE12
4597 , ATTRIBUTE13
4598 , ATTRIBUTE14
4599 , ATTRIBUTE15
4600 , ATTRIBUTE2
4601 , ATTRIBUTE3
4602 , ATTRIBUTE4
4603 , ATTRIBUTE5
4604 , ATTRIBUTE6
4605 , ATTRIBUTE7
4606 , ATTRIBUTE8
4607 , ATTRIBUTE9
4608 , AUTOMATIC_FLAG
4609 , CONTEXT
4610 , CREATED_BY
4611 , CREATION_DATE
4612 , DISCOUNT_ID
4613 , DISCOUNT_LINE_ID
4614 , HEADER_ID
4615 , LAST_UPDATED_BY
4616 , LAST_UPDATE_DATE
4617 , LAST_UPDATE_LOGIN
4618 , LINE_ID
4619 , PERCENT
4620 , PRICE_ADJUSTMENT_ID
4621 , PROGRAM_APPLICATION_ID
4622 , PROGRAM_ID
4623 , PROGRAM_UPDATE_DATE
4624 , REQUEST_ID
4625 , LIST_HEADER_ID
4626 , LIST_LINE_ID
4627 , LIST_LINE_TYPE_CODE
4628 , MODIFIER_MECHANISM_TYPE_CODE
4629 , MODIFIED_FROM
4630 , MODIFIED_TO
4631 , UPDATED_FLAG
4632 , UPDATE_ALLOWED
4633 , APPLIED_FLAG
4634 , CHANGE_REASON_CODE
4635 , CHANGE_REASON_TEXT
4636 , operand
4637 , Arithmetic_operator
4638 , COST_ID
4639 , TAX_CODE
4640 , TAX_EXEMPT_FLAG
4641 , TAX_EXEMPT_NUMBER
4642 , TAX_EXEMPT_REASON_CODE
4643 , PARENT_ADJUSTMENT_ID
4644 , INVOICED_FLAG
4645 , ESTIMATED_FLAG
4646 , INC_IN_SALES_PERFORMANCE
4647 , SPLIT_ACTION_CODE
4648 , ADJUSTED_AMOUNT
4649 , PRICING_PHASE_ID
4650 , CHARGE_TYPE_CODE
4651 , CHARGE_SUBTYPE_CODE
4652 , list_line_no
4653 , source_system_code
4654 , benefit_qty
4655 , benefit_uom_code
4656 , print_on_invoice_flag
4657 , expiration_date
4658 , rebate_transaction_type_code
4659 , rebate_transaction_reference
4660 , rebate_payment_system_code
4661 , redeemed_date
4662 , redeemed_flag
4663 , accrual_flag
4664 , range_break_quantity
4665 , accrual_conversion_rate
4666 , pricing_group_sequence
4667 , modifier_level_code
4668 , price_break_type_code
4669 , substitution_attribute
4670 , proration_type_code
4671 , credit_or_charge_flag
4672 , include_on_returns_flag
4673 , AC_ATTRIBUTE1
4674 , AC_ATTRIBUTE10
4675 , AC_ATTRIBUTE11
4676 , AC_ATTRIBUTE12
4677 , AC_ATTRIBUTE13
4678 , AC_ATTRIBUTE14
4679 , AC_ATTRIBUTE15
4680 , AC_ATTRIBUTE2
4681 , AC_ATTRIBUTE3
4682 , AC_ATTRIBUTE4
4683 , AC_ATTRIBUTE5
4684 , AC_ATTRIBUTE6
4685 , AC_ATTRIBUTE7
4686 , AC_ATTRIBUTE8
4687 , AC_ATTRIBUTE9
4688 , AC_CONTEXT
4689 --uom begin
4690 -- , OPERAND_PER_PQTY
4691 -- , ADJUSTED_AMOUNT_PER_PQTY
4692 --uom end
4693 , LOCK_CONTROL
4694 -- eBTax changes
4695 , TAX_RATE_ID
4696 FROM OE_PRICE_ADJS_HISTORY
4697 WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
4698 and version_number = l_version_number
4699 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4700 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
4701 AND VERSION_FLAG = 'Y'));
4702
4703 CURSOR l_Line_Adj_csr_l IS
4704 SELECT ATTRIBUTE1
4705 , ATTRIBUTE10
4706 , ATTRIBUTE11
4707 , ATTRIBUTE12
4708 , ATTRIBUTE13
4709 , ATTRIBUTE14
4710 , ATTRIBUTE15
4711 , ATTRIBUTE2
4712 , ATTRIBUTE3
4713 , ATTRIBUTE4
4714 , ATTRIBUTE5
4715 , ATTRIBUTE6
4716 , ATTRIBUTE7
4717 , ATTRIBUTE8
4718 , ATTRIBUTE9
4719 , AUTOMATIC_FLAG
4720 , CONTEXT
4721 , CREATED_BY
4722 , CREATION_DATE
4723 , DISCOUNT_ID
4724 , DISCOUNT_LINE_ID
4725 , HEADER_ID
4726 , LAST_UPDATED_BY
4727 , LAST_UPDATE_DATE
4728 , LAST_UPDATE_LOGIN
4729 , LINE_ID
4730 , PERCENT
4731 , PRICE_ADJUSTMENT_ID
4732 , PROGRAM_APPLICATION_ID
4733 , PROGRAM_ID
4734 , PROGRAM_UPDATE_DATE
4735 , REQUEST_ID
4736 , LIST_HEADER_ID
4737 , LIST_LINE_ID
4738 , LIST_LINE_TYPE_CODE
4739 , MODIFIER_MECHANISM_TYPE_CODE
4740 , MODIFIED_FROM
4741 , MODIFIED_TO
4742 , UPDATED_FLAG
4743 , UPDATE_ALLOWED
4744 , APPLIED_FLAG
4745 , CHANGE_REASON_CODE
4746 , CHANGE_REASON_TEXT
4747 , operand
4748 , Arithmetic_operator
4749 , COST_ID
4750 , TAX_CODE
4751 , TAX_EXEMPT_FLAG
4752 , TAX_EXEMPT_NUMBER
4753 , TAX_EXEMPT_REASON_CODE
4754 , PARENT_ADJUSTMENT_ID
4755 , INVOICED_FLAG
4756 , ESTIMATED_FLAG
4757 , INC_IN_SALES_PERFORMANCE
4758 , SPLIT_ACTION_CODE
4759 , ADJUSTED_AMOUNT
4760 , PRICING_PHASE_ID
4761 , CHARGE_TYPE_CODE
4762 , CHARGE_SUBTYPE_CODE
4763 , list_line_no
4764 , source_system_code
4765 , benefit_qty
4766 , benefit_uom_code
4767 , print_on_invoice_flag
4768 , expiration_date
4769 , rebate_transaction_type_code
4770 , rebate_transaction_reference
4771 , rebate_payment_system_code
4772 , redeemed_date
4773 , redeemed_flag
4774 , accrual_flag
4775 , range_break_quantity
4776 , accrual_conversion_rate
4777 , pricing_group_sequence
4778 , modifier_level_code
4779 , price_break_type_code
4780 , substitution_attribute
4781 , proration_type_code
4782 , credit_or_charge_flag
4783 , include_on_returns_flag
4784 , AC_ATTRIBUTE1
4785 , AC_ATTRIBUTE10
4786 , AC_ATTRIBUTE11
4787 , AC_ATTRIBUTE12
4788 , AC_ATTRIBUTE13
4789 , AC_ATTRIBUTE14
4790 , AC_ATTRIBUTE15
4791 , AC_ATTRIBUTE2
4792 , AC_ATTRIBUTE3
4793 , AC_ATTRIBUTE4
4794 , AC_ATTRIBUTE5
4795 , AC_ATTRIBUTE6
4796 , AC_ATTRIBUTE7
4797 , AC_ATTRIBUTE8
4798 , AC_ATTRIBUTE9
4799 , AC_CONTEXT
4800 --uom begin
4801 -- , OPERAND_PER_PQTY
4802 -- , ADJUSTED_AMOUNT_PER_PQTY
4803 --uom end
4804 , LOCK_CONTROL
4805 -- eBTax changes
4806 , TAX_RATE_ID
4807
4808 FROM OE_PRICE_ADJS_HISTORY
4809 WHERE line_id = p_line_id
4810 and version_number = l_version_number
4811 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4812 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
4813 AND VERSION_FLAG = 'Y'));
4814
4815 CURSOR l_Line_Adj_csr_h IS
4816 SELECT ATTRIBUTE1
4817 , ATTRIBUTE10
4818 , ATTRIBUTE11
4819 , ATTRIBUTE12
4820 , ATTRIBUTE13
4821 , ATTRIBUTE14
4822 , ATTRIBUTE15
4823 , ATTRIBUTE2
4824 , ATTRIBUTE3
4825 , ATTRIBUTE4
4826 , ATTRIBUTE5
4827 , ATTRIBUTE6
4828 , ATTRIBUTE7
4829 , ATTRIBUTE8
4830 , ATTRIBUTE9
4831 , AUTOMATIC_FLAG
4832 , CONTEXT
4833 , CREATED_BY
4834 , CREATION_DATE
4835 , DISCOUNT_ID
4836 , DISCOUNT_LINE_ID
4837 , HEADER_ID
4838 , LAST_UPDATED_BY
4839 , LAST_UPDATE_DATE
4840 , LAST_UPDATE_LOGIN
4841 , LINE_ID
4842 , PERCENT
4843 , PRICE_ADJUSTMENT_ID
4844 , PROGRAM_APPLICATION_ID
4845 , PROGRAM_ID
4846 , PROGRAM_UPDATE_DATE
4847 , REQUEST_ID
4848 , LIST_HEADER_ID
4849 , LIST_LINE_ID
4850 , LIST_LINE_TYPE_CODE
4851 , MODIFIER_MECHANISM_TYPE_CODE
4852 , MODIFIED_FROM
4853 , MODIFIED_TO
4854 , UPDATED_FLAG
4855 , UPDATE_ALLOWED
4856 , APPLIED_FLAG
4857 , CHANGE_REASON_CODE
4858 , CHANGE_REASON_TEXT
4859 , operand
4860 , Arithmetic_operator
4861 , COST_ID
4862 , TAX_CODE
4863 , TAX_EXEMPT_FLAG
4864 , TAX_EXEMPT_NUMBER
4865 , TAX_EXEMPT_REASON_CODE
4866 , PARENT_ADJUSTMENT_ID
4867 , INVOICED_FLAG
4868 , ESTIMATED_FLAG
4869 , INC_IN_SALES_PERFORMANCE
4870 , SPLIT_ACTION_CODE
4871 , ADJUSTED_AMOUNT
4872 , PRICING_PHASE_ID
4873 , CHARGE_TYPE_CODE
4874 , CHARGE_SUBTYPE_CODE
4875 , list_line_no
4876 , source_system_code
4877 , benefit_qty
4878 , benefit_uom_code
4879 , print_on_invoice_flag
4880 , expiration_date
4881 , rebate_transaction_type_code
4882 , rebate_transaction_reference
4883 , rebate_payment_system_code
4884 , redeemed_date
4885 , redeemed_flag
4886 , accrual_flag
4887 , range_break_quantity
4888 , accrual_conversion_rate
4889 , pricing_group_sequence
4890 , modifier_level_code
4891 , price_break_type_code
4892 , substitution_attribute
4893 , proration_type_code
4894 , credit_or_charge_flag
4895 , include_on_returns_flag
4896 , AC_ATTRIBUTE1
4897 , AC_ATTRIBUTE10
4898 , AC_ATTRIBUTE11
4899 , AC_ATTRIBUTE12
4900 , AC_ATTRIBUTE13
4901 , AC_ATTRIBUTE14
4902 , AC_ATTRIBUTE15
4903 , AC_ATTRIBUTE2
4904 , AC_ATTRIBUTE3
4905 , AC_ATTRIBUTE4
4906 , AC_ATTRIBUTE5
4907 , AC_ATTRIBUTE6
4908 , AC_ATTRIBUTE7
4909 , AC_ATTRIBUTE8
4910 , AC_ATTRIBUTE9
4911 , AC_CONTEXT
4912 --uom begin
4913 -- , OPERAND_PER_PQTY
4914 -- , ADJUSTED_AMOUNT_PER_PQTY
4915 --uom end
4916 , LOCK_CONTROL
4917 -- eBTax changes
4918 , TAX_RATE_ID
4919 FROM OE_PRICE_ADJS_HISTORY
4920 WHERE header_id = p_header_id
4921 and line_id is not null
4922 and version_number = l_version_number
4923 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
4924 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
4925 AND VERSION_FLAG = 'Y'));
4926
4927 l_rec l_line_adj_csr_p%ROWTYPE;
4928
4929 --
4930 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4931 --
4932
4933 BEGIN
4934 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
4935 l_current_version_number := Get_Version_Number(p_header_id => p_header_id, p_line_id => p_line_id, p_price_adjustment_id => p_price_adjustment_id);
4936
4937 IF l_version_number >= l_current_version_number THEN
4938 l_version_number := NULL;
4939 END IF;
4940 END IF;
4941
4942 IF l_version_number IS NULL THEN
4943 --bug3392650 (passing the parameter p_header_id instead of p_line_level_header_id)
4944 OE_Line_Adj_Util.Query_Rows(p_price_adjustment_id => p_price_adjustment_id, p_line_id => p_line_id, p_header_id => p_header_id, x_line_adj_tbl => x_line_adj_tbl);
4945 ELSE
4946
4947 IF nvl(p_price_adjustment_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4948 l_entity := 1;
4949 OPEN l_line_adj_csr_p;
4950 ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4951 l_entity := 2;
4952 OPEN l_line_adj_csr_l;
4953 ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4954 l_entity := 3;
4955 OPEN l_line_adj_csr_h;
4956 END IF;
4957
4958 -- Loop over fetched records
4959
4960 l_count := 1;
4961
4962 LOOP
4963
4964 IF l_entity = 1 THEN
4965 FETCH l_line_adj_csr_p INTO l_rec;
4966 EXIT WHEN l_line_adj_csr_p%NOTFOUND;
4967 ELSIF l_entity = 2 THEN
4968 FETCH l_line_adj_csr_l INTO l_rec;
4969 EXIT WHEN l_line_adj_csr_l%NOTFOUND;
4970 ELSIF l_entity = 3 THEN
4971 FETCH l_line_adj_csr_h INTO l_rec;
4972 EXIT WHEN l_line_adj_csr_h%NOTFOUND;
4973 ELSE
4974 EXIT;
4975 END IF;
4976
4977 x_Line_Adj_tbl(l_count).attribute1 := l_rec.ATTRIBUTE1;
4978 x_Line_Adj_tbl(l_count).attribute10 := l_rec.ATTRIBUTE10;
4979 x_Line_Adj_tbl(l_count).attribute11 := l_rec.ATTRIBUTE11;
4980 x_Line_Adj_tbl(l_count).attribute12 := l_rec.ATTRIBUTE12;
4981 x_Line_Adj_tbl(l_count).attribute13 := l_rec.ATTRIBUTE13;
4982 x_Line_Adj_tbl(l_count).attribute14 := l_rec.ATTRIBUTE14;
4983 x_Line_Adj_tbl(l_count).attribute15 := l_rec.ATTRIBUTE15;
4984 x_Line_Adj_tbl(l_count).attribute2 := l_rec.ATTRIBUTE2;
4985 x_Line_Adj_tbl(l_count).attribute3 := l_rec.ATTRIBUTE3;
4986 x_Line_Adj_tbl(l_count).attribute4 := l_rec.ATTRIBUTE4;
4987 x_Line_Adj_tbl(l_count).attribute5 := l_rec.ATTRIBUTE5;
4988 x_Line_Adj_tbl(l_count).attribute6 := l_rec.ATTRIBUTE6;
4989 x_Line_Adj_tbl(l_count).attribute7 := l_rec.ATTRIBUTE7;
4990 x_Line_Adj_tbl(l_count).attribute8 := l_rec.ATTRIBUTE8;
4991 x_Line_Adj_tbl(l_count).attribute9 := l_rec.ATTRIBUTE9;
4992 x_Line_Adj_tbl(l_count).automatic_flag := l_rec.AUTOMATIC_FLAG;
4993 x_Line_Adj_tbl(l_count).context := l_rec.CONTEXT;
4994 x_Line_Adj_tbl(l_count).created_by := l_rec.CREATED_BY;
4995 x_Line_Adj_tbl(l_count).creation_date := l_rec.CREATION_DATE;
4996 x_Line_Adj_tbl(l_count).discount_id := l_rec.DISCOUNT_ID;
4997 x_Line_Adj_tbl(l_count).discount_line_id := l_rec.DISCOUNT_LINE_ID;
4998 x_Line_Adj_tbl(l_count).header_id := l_rec.HEADER_ID;
4999 x_Line_Adj_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
5000 x_Line_Adj_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
5001 x_Line_Adj_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
5002 x_Line_Adj_tbl(l_count).line_id := l_rec.LINE_ID;
5003 x_Line_Adj_tbl(l_count).percent := l_rec.PERCENT;
5004 x_Line_Adj_tbl(l_count).price_adjustment_id := l_rec.PRICE_ADJUSTMENT_ID;
5005 x_Line_Adj_tbl(l_count).program_application_id := l_rec.PROGRAM_APPLICATION_ID;
5006 x_Line_Adj_tbl(l_count).program_id := l_rec.PROGRAM_ID;
5007 x_Line_Adj_tbl(l_count).program_update_date := l_rec.PROGRAM_UPDATE_DATE;
5008 x_Line_Adj_tbl(l_count).request_id := l_rec.REQUEST_ID;
5009 x_Line_Adj_tbl(l_count).list_header_id := l_rec.list_header_id;
5010 x_Line_Adj_tbl(l_count).list_line_id := l_rec.list_line_id;
5011 x_Line_Adj_tbl(l_count).list_line_type_code := l_rec.list_line_type_code;
5012 x_Line_Adj_tbl(l_count).modifier_mechanism_type_code := l_rec.modifier_mechanism_type_code;
5013 x_Line_Adj_tbl(l_count).modified_from := l_rec.modified_from;
5014 x_Line_Adj_tbl(l_count).modified_to := l_rec.modified_to;
5015 x_Line_Adj_tbl(l_count).updated_flag := l_rec.updated_flag;
5016 x_Line_Adj_tbl(l_count).update_allowed := l_rec.update_allowed;
5017 x_Line_Adj_tbl(l_count).applied_flag := l_rec.applied_flag;
5018 x_Line_Adj_tbl(l_count).change_reason_code := l_rec.change_reason_code;
5019 x_Line_Adj_tbl(l_count).change_reason_text := l_rec.change_reason_text;
5020 x_Line_Adj_tbl(l_count).operand := l_rec.operand;
5021 x_Line_Adj_tbl(l_count).arithmetic_operator := l_rec.arithmetic_operator;
5022 x_Line_Adj_tbl(l_count).adjusted_amount := l_rec.adjusted_amount;
5023 x_Line_Adj_tbl(l_count).pricing_phase_id := l_rec.pricing_phase_id;
5024 x_Line_Adj_tbl(l_count).cost_id := l_rec.cost_id;
5025 x_Line_Adj_tbl(l_count).tax_code := l_rec.tax_code;
5026 x_Line_Adj_tbl(l_count).tax_exempt_flag := l_rec.tax_exempt_flag;
5027 x_Line_Adj_tbl(l_count).tax_exempt_number := l_rec.tax_exempt_number;
5028 x_Line_Adj_tbl(l_count).tax_exempt_reason_code := l_rec.tax_exempt_reason_code;
5029 x_Line_Adj_tbl(l_count).parent_adjustment_id := l_rec.parent_adjustment_id;
5030 x_Line_Adj_tbl(l_count).invoiced_flag := l_rec.invoiced_flag;
5031 x_Line_Adj_tbl(l_count).estimated_flag := l_rec.estimated_flag;
5032 x_Line_Adj_tbl(l_count).inc_in_sales_performance := l_rec.inc_in_sales_performance;
5033 x_Line_Adj_tbl(l_count).split_action_code := l_rec.split_action_code;
5034 x_Line_Adj_tbl(l_count).charge_type_code := l_rec.charge_type_code;
5035 x_Line_Adj_tbl(l_count).charge_subtype_code := l_rec.charge_subtype_code;
5036 x_Line_Adj_tbl(l_count).list_line_no := l_rec.list_line_no;
5037 x_Line_Adj_tbl(l_count).source_system_code := l_rec.source_system_code;
5038 x_Line_Adj_tbl(l_count).benefit_qty := l_rec.benefit_qty;
5039 x_Line_Adj_tbl(l_count).benefit_uom_code := l_rec.benefit_uom_code;
5040 x_Line_Adj_tbl(l_count).print_on_invoice_flag := l_rec.print_on_invoice_flag;
5041 x_Line_Adj_tbl(l_count).expiration_date := l_rec.expiration_date;
5042 x_Line_Adj_tbl(l_count).rebate_transaction_type_code := l_rec.rebate_transaction_type_code;
5043 x_Line_Adj_tbl(l_count).rebate_transaction_reference := l_rec.rebate_transaction_reference;
5044 x_Line_Adj_tbl(l_count).rebate_payment_system_code := l_rec.rebate_payment_system_code;
5045 x_Line_Adj_tbl(l_count).redeemed_date := l_rec.redeemed_date;
5046 x_Line_Adj_tbl(l_count).redeemed_flag := l_rec.redeemed_flag;
5047 x_Line_Adj_tbl(l_count).accrual_flag := l_rec.accrual_flag;
5048 x_Line_Adj_tbl(l_count).range_break_quantity := l_rec.range_break_quantity;
5049 x_Line_Adj_tbl(l_count).accrual_conversion_rate := l_rec.accrual_conversion_rate;
5050 x_Line_Adj_tbl(l_count).pricing_group_sequence := l_rec.pricing_group_sequence;
5051 x_Line_Adj_tbl(l_count).modifier_level_code := l_rec.modifier_level_code;
5052 x_Line_Adj_tbl(l_count).price_break_type_code := l_rec.price_break_type_code;
5053 x_Line_Adj_tbl(l_count).substitution_attribute := l_rec.substitution_attribute;
5054 x_Line_Adj_tbl(l_count).proration_type_code := l_rec.proration_type_code;
5055 x_Line_Adj_tbl(l_count).credit_or_charge_flag := l_rec.credit_or_charge_flag;
5056 x_Line_Adj_tbl(l_count).include_on_returns_flag := l_rec.include_on_returns_flag;
5057 x_Line_Adj_tbl(l_count).ac_attribute1 := l_rec.AC_ATTRIBUTE1;
5058 x_Line_Adj_tbl(l_count).ac_attribute10 := l_rec.AC_ATTRIBUTE10;
5059 x_Line_Adj_tbl(l_count).ac_attribute11 := l_rec.AC_ATTRIBUTE11;
5060 x_Line_Adj_tbl(l_count).ac_attribute12 := l_rec.AC_ATTRIBUTE12;
5061 x_Line_Adj_tbl(l_count).ac_attribute13 := l_rec.AC_ATTRIBUTE13;
5062 x_Line_Adj_tbl(l_count).ac_attribute14 := l_rec.AC_ATTRIBUTE14;
5063 x_Line_Adj_tbl(l_count).ac_attribute15 := l_rec.AC_ATTRIBUTE15;
5064 x_Line_Adj_tbl(l_count).ac_attribute2 := l_rec.AC_ATTRIBUTE2;
5065 x_Line_Adj_tbl(l_count).ac_attribute3 := l_rec.AC_ATTRIBUTE3;
5066 x_Line_Adj_tbl(l_count).ac_attribute4 := l_rec.AC_ATTRIBUTE4;
5067 x_Line_Adj_tbl(l_count).ac_attribute5 := l_rec.AC_ATTRIBUTE5;
5068 x_Line_Adj_tbl(l_count).ac_attribute6 := l_rec.AC_ATTRIBUTE6;
5069 x_Line_Adj_tbl(l_count).ac_attribute7 := l_rec.AC_ATTRIBUTE7;
5070 x_Line_Adj_tbl(l_count).ac_attribute8 := l_rec.AC_ATTRIBUTE8;
5071 x_Line_Adj_tbl(l_count).ac_attribute9 := l_rec.AC_ATTRIBUTE9;
5072 x_Line_Adj_tbl(l_count).ac_context := l_rec.AC_CONTEXT;
5073 --uom begin
5074 -- x_Line_Adj_tbl(l_count).operand_per_pqty := l_rec.operand_per_pqty;
5075 -- x_Line_Adj_tbl(l_count).adjusted_amount_per_pqty := l_rec.adjusted_amount_per_pqty;
5076 --uom end
5077 x_Line_Adj_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
5078
5079 -- set values for non-DB fields
5080 x_Line_Adj_tbl(l_count).db_flag := FND_API.G_TRUE;
5081 x_Line_Adj_tbl(l_count).operation := FND_API.G_MISS_CHAR;
5082 x_Line_Adj_tbl(l_count).return_status := FND_API.G_MISS_CHAR;
5083 -- eBTax changes
5084 x_Line_Adj_tbl(l_count).tax_rate_id := l_rec.tax_rate_id;
5085
5086 l_count := l_count + 1;
5087
5088 END LOOP;
5089
5090 IF l_entity = 1 THEN
5091 CLOSE l_line_adj_csr_p;
5092 ELSIF l_entity = 2 THEN
5093 CLOSE l_line_adj_csr_l;
5094 ELSIF l_entity = 3 THEN
5095 CLOSE l_line_adj_csr_h;
5096 END IF;
5097
5098 -- PK sent and no rows found
5099
5100 IF
5101 (p_price_adjustment_id IS NOT NULL
5102 AND
5103 p_price_adjustment_id <> FND_API.G_MISS_NUM)
5104 AND
5105 (x_Line_Adj_tbl.COUNT = 0)
5106 THEN
5107 RAISE NO_DATA_FOUND;
5108 END IF;
5109
5110 -- Return fetched table
5111
5112 END IF;
5113
5114 EXCEPTION
5115 WHEN OTHERS THEN
5116 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5117 OE_MSG_PUB.Add_Exc_Msg
5118 ( G_PKG_NAME
5119 , 'Line Adj Query_Rows'
5120 );
5121 END IF;
5122 END;
5123
5124
5125 -- Line Scredit Query_Row
5126 PROCEDURE Query_Row
5127 ( p_sales_credit_id IN NUMBER
5128 , p_version_number IN NUMBER := NULL
5129 , p_phase_change_flag IN VARCHAR2 := NULL
5130 , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
5131 )
5132 IS
5133 l_version_number NUMBER := p_version_number;
5134 l_current_version_number NUMBER;
5135
5136 l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5137 --
5138 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5139 --
5140 BEGIN
5141 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
5142 l_current_version_number := Get_Version_Number(p_sales_credit_id => p_sales_credit_id);
5143
5144 IF l_version_number >= l_current_version_number THEN
5145 l_version_number := NULL;
5146 END IF;
5147 END IF;
5148
5149 IF l_version_number IS NULL THEN
5150 OE_Line_Scredit_Util.Query_Row(p_sales_credit_id => p_sales_credit_id, x_line_scredit_rec => x_line_scredit_rec);
5151 ELSE
5152
5153 IF l_debug_level > 0 THEN
5154 oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.QUERY_ROW' , 1 ) ;
5155 END IF;
5156
5157 G_INTERNAL_QUERY := TRUE;
5158 Query_Rows
5159 ( p_sales_credit_id => p_sales_credit_id
5160 ,x_Line_Scredit_tbl => l_Line_Scredit_tbl
5161 );
5162 G_INTERNAL_QUERY := FALSE;
5163 x_Line_Scredit_rec := l_Line_Scredit_tbl(1);
5164
5165 END IF;
5166
5167 EXCEPTION
5168 WHEN OTHERS THEN
5169 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5170 OE_MSG_PUB.Add_Exc_Msg
5171 ( G_PKG_NAME
5172 , 'Line Scredit Query_Row'
5173 );
5174 END IF;
5175 END;
5176
5177
5178 -- Line Scredit Query_Rows
5179 PROCEDURE Query_Rows
5180 ( p_sales_credit_id IN NUMBER :=
5181 FND_API.G_MISS_NUM
5182 , p_line_id IN NUMBER :=
5183 FND_API.G_MISS_NUM
5184 , p_header_id IN NUMBER :=
5185 FND_API.G_MISS_NUM
5186 , p_version_number IN NUMBER := NULL
5187 , p_phase_change_flag IN VARCHAR2 := NULL
5188 , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
5189 )
5190 IS
5191 l_version_number NUMBER := p_version_number;
5192 l_current_version_number NUMBER;
5193
5194 CURSOR l_Line_Scredit_csr_s IS
5195 SELECT ATTRIBUTE1
5196 , ATTRIBUTE10
5197 , ATTRIBUTE11
5198 , ATTRIBUTE12
5199 , ATTRIBUTE13
5200 , ATTRIBUTE14
5201 , ATTRIBUTE15
5202 , ATTRIBUTE2
5203 , ATTRIBUTE3
5204 , ATTRIBUTE4
5205 , ATTRIBUTE5
5206 , ATTRIBUTE6
5207 , ATTRIBUTE7
5208 , ATTRIBUTE8
5209 , ATTRIBUTE9
5210 , CONTEXT
5211 , CREATED_BY
5212 , CREATION_DATE
5213 , DW_UPDATE_ADVICE_FLAG
5214 , HEADER_ID
5215 , LAST_UPDATED_BY
5216 , LAST_UPDATE_DATE
5217 , LAST_UPDATE_LOGIN
5218 , LINE_ID
5219 , PERCENT
5220 , SALESREP_ID
5221 , sales_credit_type_id
5222 , SALES_CREDIT_ID
5223 , WH_UPDATE_DATE
5224 , LOCK_CONTROL
5225 FROM OE_SALES_CREDIT_HISTORY
5226 WHERE SALES_CREDIT_ID = p_sales_credit_id
5227 AND VERSION_NUMBER = l_version_number
5228 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
5229 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
5230 AND VERSION_FLAG = 'Y'));
5231
5232 CURSOR l_Line_Scredit_csr_l IS
5233 SELECT ATTRIBUTE1
5234 , ATTRIBUTE10
5235 , ATTRIBUTE11
5236 , ATTRIBUTE12
5237 , ATTRIBUTE13
5238 , ATTRIBUTE14
5239 , ATTRIBUTE15
5240 , ATTRIBUTE2
5241 , ATTRIBUTE3
5242 , ATTRIBUTE4
5243 , ATTRIBUTE5
5244 , ATTRIBUTE6
5245 , ATTRIBUTE7
5246 , ATTRIBUTE8
5247 , ATTRIBUTE9
5248 , CONTEXT
5249 , CREATED_BY
5250 , CREATION_DATE
5251 , DW_UPDATE_ADVICE_FLAG
5252 , HEADER_ID
5253 , LAST_UPDATED_BY
5254 , LAST_UPDATE_DATE
5255 , LAST_UPDATE_LOGIN
5256 , LINE_ID
5257 , PERCENT
5258 , SALESREP_ID
5259 , sales_credit_type_id
5260 , SALES_CREDIT_ID
5261 , WH_UPDATE_DATE
5262 , LOCK_CONTROL
5263 FROM OE_SALES_CREDIT_HISTORY
5264 WHERE LINE_ID = p_line_id
5265 AND VERSION_NUMBER = l_version_number
5266 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
5267 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
5268 AND VERSION_FLAG = 'Y'));
5269
5270 CURSOR l_Line_Scredit_csr_h IS
5271 SELECT ATTRIBUTE1
5272 , ATTRIBUTE10
5273 , ATTRIBUTE11
5274 , ATTRIBUTE12
5275 , ATTRIBUTE13
5276 , ATTRIBUTE14
5277 , ATTRIBUTE15
5278 , ATTRIBUTE2
5279 , ATTRIBUTE3
5280 , ATTRIBUTE4
5281 , ATTRIBUTE5
5282 , ATTRIBUTE6
5283 , ATTRIBUTE7
5284 , ATTRIBUTE8
5285 , ATTRIBUTE9
5286 , CONTEXT
5287 , CREATED_BY
5288 , CREATION_DATE
5289 , DW_UPDATE_ADVICE_FLAG
5290 , HEADER_ID
5291 , LAST_UPDATED_BY
5292 , LAST_UPDATE_DATE
5293 , LAST_UPDATE_LOGIN
5294 , LINE_ID
5295 , PERCENT
5296 , SALESREP_ID
5297 , sales_credit_type_id
5298 , SALES_CREDIT_ID
5299 , WH_UPDATE_DATE
5300 , LOCK_CONTROL
5301 FROM OE_SALES_CREDIT_HISTORY
5302 WHERE HEADER_ID = p_header_id
5303 AND LINE_ID IS NOT NULL
5304 AND VERSION_NUMBER = l_version_number
5305 AND (PHASE_CHANGE_FLAG = p_phase_change_flag
5306 OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
5307 AND VERSION_FLAG = 'Y'));
5308
5309 l_rec l_line_scredit_csr_s%ROWTYPE;
5310 l_entity NUMBER;
5311 l_count NUMBER;
5312
5313 --
5314 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5315 --
5316 BEGIN
5317 IF p_version_number IS NOT NULL AND NOT G_INTERNAL_QUERY THEN
5318 l_current_version_number := Get_Version_Number(p_header_id => p_header_id, p_line_id => p_line_id, p_sales_credit_id => p_sales_credit_id);
5319
5320 IF l_version_number >= l_current_version_number THEN
5321 l_version_number := NULL;
5322 END IF;
5323 END IF;
5324
5325 IF l_version_number IS NULL THEN
5326 OE_Line_Scredit_Util.Query_Rows(p_sales_credit_id => p_sales_credit_id, p_line_id => p_line_id, p_header_id => p_header_id, x_line_scredit_tbl => x_line_scredit_tbl);
5327 ELSE
5328
5329 IF
5330 (p_sales_credit_id IS NOT NULL
5331 AND
5332 p_sales_credit_id <> FND_API.G_MISS_NUM)
5333 AND
5334 (p_line_id IS NOT NULL
5335 AND
5336 p_line_id <> FND_API.G_MISS_NUM)
5337 THEN
5338
5339 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340
5341 END IF;
5342
5343
5344 IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5345 l_entity := 1;
5346 OPEN l_line_scredit_csr_s;
5347 ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5348 l_entity := 2;
5349 OPEN l_line_scredit_csr_l;
5350 ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5351 l_entity := 3;
5352 OPEN l_line_scredit_csr_h;
5353 END IF;
5354
5355 -- Loop over fetched records
5356 l_count := 1;
5357
5358 LOOP
5359 IF l_entity = 1 THEN
5360 FETCH l_line_scredit_csr_s INTO l_rec;
5361 EXIT WHEN l_line_scredit_csr_s%NOTFOUND;
5362 ELSIF l_entity = 2 THEN
5363 FETCH l_line_scredit_csr_l INTO l_rec;
5364 EXIT WHEN l_line_scredit_csr_l%NOTFOUND;
5365 ELSIF l_entity = 3 THEN
5366 FETCH l_line_scredit_csr_h INTO l_rec;
5367 EXIT WHEN l_line_scredit_csr_h%NOTFOUND;
5368 ELSE
5369 EXIT;
5370 END IF;
5371
5372 x_line_scredit_tbl(l_count).attribute1 := l_rec.ATTRIBUTE1;
5373 x_line_scredit_tbl(l_count).attribute10 := l_rec.ATTRIBUTE10;
5374 x_line_scredit_tbl(l_count).attribute11 := l_rec.ATTRIBUTE11;
5375 x_line_scredit_tbl(l_count).attribute12 := l_rec.ATTRIBUTE12;
5376 x_line_scredit_tbl(l_count).attribute13 := l_rec.ATTRIBUTE13;
5377 x_line_scredit_tbl(l_count).attribute14 := l_rec.ATTRIBUTE14;
5378 x_line_scredit_tbl(l_count).attribute15 := l_rec.ATTRIBUTE15;
5379 x_line_scredit_tbl(l_count).attribute2 := l_rec.ATTRIBUTE2;
5380 x_line_scredit_tbl(l_count).attribute3 := l_rec.ATTRIBUTE3;
5381 x_line_scredit_tbl(l_count).attribute4 := l_rec.ATTRIBUTE4;
5382 x_line_scredit_tbl(l_count).attribute5 := l_rec.ATTRIBUTE5;
5383 x_line_scredit_tbl(l_count).attribute6 := l_rec.ATTRIBUTE6;
5384 x_line_scredit_tbl(l_count).attribute7 := l_rec.ATTRIBUTE7;
5385 x_line_scredit_tbl(l_count).attribute8 := l_rec.ATTRIBUTE8;
5386 x_line_scredit_tbl(l_count).attribute9 := l_rec.ATTRIBUTE9;
5387 x_line_scredit_tbl(l_count).context := l_rec.CONTEXT;
5388 x_line_scredit_tbl(l_count).created_by := l_rec.CREATED_BY;
5389 x_line_scredit_tbl(l_count).creation_date := l_rec.CREATION_DATE;
5390 x_line_scredit_tbl(l_count).dw_update_advice_flag := l_rec.DW_UPDATE_ADVICE_FLAG;
5391 x_line_scredit_tbl(l_count).header_id := l_rec.HEADER_ID;
5392 x_line_scredit_tbl(l_count).last_updated_by := l_rec.LAST_UPDATED_BY;
5393 x_line_scredit_tbl(l_count).last_update_date := l_rec.LAST_UPDATE_DATE;
5394 x_line_scredit_tbl(l_count).last_update_login := l_rec.LAST_UPDATE_LOGIN;
5395 x_line_scredit_tbl(l_count).line_id := l_rec.LINE_ID;
5396 x_line_scredit_tbl(l_count).percent := l_rec.PERCENT;
5397 x_line_scredit_tbl(l_count).salesrep_id := l_rec.SALESREP_ID;
5398 x_line_scredit_tbl(l_count).sales_credit_type_id := l_rec.sales_credit_type_id;
5399 x_line_scredit_tbl(l_count).sales_credit_id := l_rec.SALES_CREDIT_ID;
5400 x_line_scredit_tbl(l_count).wh_update_date := l_rec.WH_UPDATE_DATE;
5401 x_line_scredit_tbl(l_count).lock_control := l_rec.LOCK_CONTROL;
5402
5403 l_count := l_count + 1;
5404
5405 END LOOP;
5406
5407 IF l_entity = 1 THEN
5408 CLOSE l_line_scredit_csr_s;
5409 ELSIF l_entity = 2 THEN
5410 CLOSE l_line_scredit_csr_l;
5411 ELSIF l_entity = 3 THEN
5412 CLOSE l_line_scredit_csr_h;
5413 END IF;
5414
5415 -- PK sent and no rows found
5416
5417 IF
5418 (p_sales_credit_id IS NOT NULL
5419 AND
5420 p_sales_credit_id <> FND_API.G_MISS_NUM)
5421 AND
5422 (x_Line_Scredit_tbl.COUNT = 0)
5423 THEN
5424 RAISE NO_DATA_FOUND;
5425 END IF;
5426
5427
5428 -- Return fetched table
5429
5430 IF l_debug_level > 0 THEN
5431 oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.QUERY_ROWS' , 1 ) ;
5432 END IF;
5433
5434
5435 END IF;
5436
5437 EXCEPTION
5438 WHEN OTHERS THEN
5439 IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5440 OE_MSG_PUB.Add_Exc_Msg
5441 ( G_PKG_NAME
5442 , 'Line Scredit Query_Row'
5443 );
5444 END IF;
5445 END;
5446
5447
5448 END OE_VERSION_HISTORY_UTIL;