[Home] [Help]
12: -- Introduced new OUT parameter x_dep_attr_exists. This parameter
13: -- is set to 'Y' if at least one dependent attribute is set to missing
14: -- in this procedure.
15: PROCEDURE Clear_Dependents
16: (p_src_attr_tbl IN OE_GLOBALS.NUMBER_Tbl_Type
17: ,p_initial_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
18: ,p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
19: ,p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
20: ,x_dep_attr_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
18: ,p_old_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
19: ,p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
20: ,x_dep_attr_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21: IS
22: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
23:
24: PROCEDURE ACCOUNTING_RULE IS
25: BEGIN
26: IF (p_initial_line_rec.ACCOUNTING_RULE_ID = FND_API.G_MISS_NUM OR
23:
24: PROCEDURE ACCOUNTING_RULE IS
25: BEGIN
26: IF (p_initial_line_rec.ACCOUNTING_RULE_ID = FND_API.G_MISS_NUM OR
27: (OE_GLOBAlS.Equal(p_initial_line_rec.ACCOUNTING_RULE_ID, p_old_line_rec.ACCOUNTING_RULE_ID)
28: AND
29: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ACCOUNTING_RULE_ID IS NOT NULL))
30: ) -- the AND condition above added to fix 3098878
31: THEN
36:
37: PROCEDURE ACCOUNTING_RULE_DURATION IS
38: BEGIN
39: IF (p_initial_line_rec.ACCOUNTING_RULE_DURATION = FND_API.G_MISS_NUM OR
40: (OE_GLOBAlS.Equal(p_initial_line_rec.ACCOUNTING_RULE_DURATION, p_old_line_rec.ACCOUNTING_RULE_DURATION)
41: AND
42: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ACCOUNTING_RULE_DURATION IS NOT NULL))
43: ) -- the AND condition above added to fix 3098878
44: THEN
49:
50: PROCEDURE AGREEMENT IS
51: BEGIN
52: IF (p_initial_line_rec.AGREEMENT_ID = FND_API.G_MISS_NUM OR
53: (OE_GLOBAlS.Equal(p_initial_line_rec.AGREEMENT_ID, p_old_line_rec.AGREEMENT_ID)
54: AND
55: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.AGREEMENT_ID IS NOT NULL))
56: ) -- the AND condition above added to fix 3098878
57: THEN
62:
63: PROCEDURE ATO_LINE IS
64: BEGIN
65: IF (p_initial_line_rec.ATO_LINE_ID = FND_API.G_MISS_NUM OR
66: (OE_GLOBAlS.Equal(p_initial_line_rec.ATO_LINE_ID, p_old_line_rec.ATO_LINE_ID)
67: AND
68: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ATO_LINE_ID IS NOT NULL))
69: ) -- the AND condition above added to fix 3098878
70: THEN
76: -- For bug 3571400
77: PROCEDURE BLANKET_NUMBER IS
78: BEGIN
79: IF (p_initial_line_rec.blanket_number = FND_API.G_MISS_NUM OR
80: (OE_GLOBAlS.Equal(p_initial_line_rec.blanket_number, p_old_line_rec.blanket_number)
81: AND
82: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.blanket_number IS NOT NULL))
83: )
84: THEN
89:
90: PROCEDURE BLANKET_LINE_NUMBER IS
91: BEGIN
92: IF (p_initial_line_rec.blanket_line_number = FND_API.G_MISS_NUM OR
93: (OE_GLOBAlS.Equal(p_initial_line_rec.blanket_line_number, p_old_line_rec.blanket_line_number)
94: AND
95: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.blanket_line_number IS NOT NULL))
96: ) -- the AND condition above added to fix 3098878
97: THEN
102:
103: PROCEDURE BLANKET_VERSION_NUMBER IS
104: BEGIN
105: IF (p_initial_line_rec.blanket_version_number = FND_API.G_MISS_NUM OR
106: (OE_GLOBAlS.Equal(p_initial_line_rec.blanket_version_number, p_old_line_rec.blanket_version_number)
107: AND
108: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.blanket_version_number IS NOT NULL))
109: ) -- the AND condition above added to fix 3098878
110: THEN
116:
117: PROCEDURE COMMITMENT IS
118: BEGIN
119: IF (p_initial_line_rec.COMMITMENT_ID = FND_API.G_MISS_NUM OR
120: (OE_GLOBAlS.Equal(p_initial_line_rec.COMMITMENT_ID, p_old_line_rec.COMMITMENT_ID)
121: AND
122: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.COMMITMENT_ID IS NOT NULL))
123: ) -- the AND condition above added to fix 3098878
124: THEN
130:
131: PROCEDURE COMPONENT IS
132: BEGIN
133: IF (p_initial_line_rec.COMPONENT_CODE = FND_API.G_MISS_CHAR OR
134: (OE_GLOBAlS.Equal(p_initial_line_rec.COMPONENT_CODE, p_old_line_rec.COMPONENT_CODE)
135: AND
136: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.COMPONENT_CODE IS NOT NULL))
137: ) -- the AND condition above added to fix 3098878
138: THEN
144:
145: PROCEDURE COMPONENT_SEQUENCE IS
146: BEGIN
147: IF (p_initial_line_rec.COMPONENT_SEQUENCE_ID = FND_API.G_MISS_NUM OR
148: (OE_GLOBALS.Equal(p_initial_line_rec.COMPONENT_SEQUENCE_ID, p_old_line_rec.COMPONENT_SEQUENCE_ID)
149: AND
150: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.COMPONENT_SEQUENCE_ID IS NOT NULL))
151: ) -- the AND condition above added to fix 3098878
152: THEN
158:
159: PROCEDURE SORT_ORDER IS
160: BEGIN
161: IF (p_initial_line_rec.SORT_ORDER = FND_API.G_MISS_CHAR OR
162: (OE_GLOBAlS.Equal(p_initial_line_rec.SORT_ORDER, p_old_line_rec.SORT_ORDER)
163: AND
164: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SORT_ORDER IS NOT NULL))
165: ) -- the AND condition above added to fix 3098878
166: THEN
172:
173: PROCEDURE SOURCE_TYPE IS
174: BEGIN
175: IF (p_initial_line_rec.SOURCE_TYPE_CODE = FND_API.G_MISS_CHAR OR
176: (OE_GLOBALS.Equal(p_initial_line_rec.SOURCE_TYPE_CODE, p_old_line_rec.SOURCE_TYPE_CODE)
177: AND
178: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SOURCE_TYPE_CODE IS NOT NULL))
179: ) -- the AND condition above added to fix 3098878
180: THEN
196:
197: PROCEDURE CUST_PO_NUMBER IS
198: BEGIN
199: IF (p_initial_line_rec.CUST_PO_NUMBER = FND_API.G_MISS_CHAR OR
200: (OE_GLOBALS.Equal(p_initial_line_rec.CUST_PO_NUMBER, p_old_line_rec.CUST_PO_NUMBER)
201: AND
202: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.CUST_PO_NUMBER IS NOT NULL))
203: ) -- the AND condition above added to fix 3098878
204: THEN
209:
210: PROCEDURE CUSTOMER_LINE_NUMBER IS --For bug 2844285
211: BEGIN
212: IF (p_initial_line_rec.CUSTOMER_LINE_NUMBER = FND_API.G_MISS_CHAR OR
213: (OE_GLOBALS.Equal(p_initial_line_rec.CUSTOMER_LINE_NUMBER, p_old_line_rec.CUSTOMER_LINE_NUMBER)
214: AND
215: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.CUSTOMER_LINE_NUMBER IS NOT NULL))
216: ) -- the AND condition above added to fix 3098878
217: THEN
222:
223: PROCEDURE DELIVER_TO_CONTACT IS
224: BEGIN
225: IF (p_initial_line_rec.DELIVER_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
226: (OE_GLOBALS.Equal(p_initial_line_rec.DELIVER_TO_CONTACT_ID, p_old_line_rec.DELIVER_TO_CONTACT_ID)
227: AND
228: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DELIVER_TO_CONTACT_ID IS NOT NULL))
229: ) -- the AND condition above added to fix 3098878
230: THEN
242:
243: PROCEDURE DELIVER_TO_ORG IS
244: BEGIN
245: IF (p_initial_line_rec.DELIVER_TO_ORG_ID = FND_API.G_MISS_NUM OR
246: (OE_GLOBALS.Equal(p_initial_line_rec.DELIVER_TO_ORG_ID, p_old_line_rec.DELIVER_TO_ORG_ID)
247: AND
248: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DELIVER_TO_ORG_ID IS NOT NULL))
249: ) -- the AND condition above added to fix 3098878
250: THEN
262:
263: PROCEDURE DEMAND_CLASS IS
264: BEGIN
265: IF (p_initial_line_rec.DEMAND_CLASS_CODE = FND_API.G_MISS_CHAR OR
266: (OE_GLOBALS.Equal(p_initial_line_rec.DEMAND_CLASS_CODE, p_old_line_rec.DEMAND_CLASS_CODE)
267: AND
268: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DEMAND_CLASS_CODE IS NOT NULL))
269: ) -- the AND condition above added to fix 3098878
270: THEN
275:
276: PROCEDURE DEP_PLAN_REQUIRED IS
277: BEGIN
278: IF (p_initial_line_rec.DEP_PLAN_REQUIRED_FLAG = FND_API.G_MISS_CHAR OR
279: (OE_GLOBALS.Equal(p_initial_line_rec.DEP_PLAN_REQUIRED_FLAG, p_old_line_rec.DEP_PLAN_REQUIRED_FLAG)
280: AND
281: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.DEP_PLAN_REQUIRED_FLAG IS NOT NULL))
282: ) -- the AND condition above added to fix 3098878
283: THEN
288:
289: PROCEDURE END_ITEM_UNIT_NUMBER IS
290: BEGIN
291: IF (p_initial_line_rec.END_ITEM_UNIT_NUMBER = FND_API.G_MISS_CHAR OR
292: (OE_GLOBALS.Equal(p_initial_line_rec.END_ITEM_UNIT_NUMBER, p_old_line_rec.END_ITEM_UNIT_NUMBER)
293: AND
294: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.END_ITEM_UNIT_NUMBER IS NOT NULL))
295: ) -- the AND condition above added to fix 3098878
296: THEN
301:
302: PROCEDURE FOB_POINT IS
303: BEGIN
304: IF (p_initial_line_rec.FOB_POINT_CODE = FND_API.G_MISS_CHAR OR
305: (OE_GLOBALS.Equal(p_initial_line_rec.FOB_POINT_CODE, p_old_line_rec.FOB_POINT_CODE)
306: AND
307: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.FOB_POINT_CODE IS NOT NULL))
308: ) -- the AND condition above added to fix 3098878
309: THEN
314:
315: PROCEDURE FREIGHT_TERMS IS
316: BEGIN
317: IF (p_initial_line_rec.FREIGHT_TERMS_CODE = FND_API.G_MISS_CHAR OR
318: (OE_GLOBALS.Equal(p_initial_line_rec.FREIGHT_TERMS_CODE, p_old_line_rec.FREIGHT_TERMS_CODE)
319: AND
320: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.FREIGHT_TERMS_CODE IS NOT NULL))
321: ) -- the AND condition above added to fix 3098878
322: THEN
327:
328: PROCEDURE INTERMED_SHIP_TO_CONTACT IS
329: BEGIN
330: IF (p_initial_line_rec.INTERMED_SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
331: (OE_GLOBALS.Equal(p_initial_line_rec.INTERMED_SHIP_TO_CONTACT_ID, p_old_line_rec.INTERMED_SHIP_TO_CONTACT_ID)
332: AND
333: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INTERMED_SHIP_TO_CONTACT_ID IS NOT NULL))
334: ) -- the AND condition above added to fix 3098878
335: THEN
340:
341: PROCEDURE INTERMED_SHIP_TO_ORG IS
342: BEGIN
343: IF (p_initial_line_rec.INTERMED_SHIP_TO_ORG_ID = FND_API.G_MISS_NUM OR
344: (OE_GLOBALS.Equal(p_initial_line_rec.INTERMED_SHIP_TO_ORG_ID, p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
345: AND
346: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INTERMED_SHIP_TO_ORG_ID IS NOT NULL))
347: ) -- the AND condition above added to fix 3098878
348: THEN
353:
354: PROCEDURE INVOICE_TO_CONTACT IS
355: BEGIN
356: IF (p_initial_line_rec.INVOICE_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
357: (OE_GLOBALS.Equal(p_initial_line_rec.INVOICE_TO_CONTACT_ID, p_old_line_rec.INVOICE_TO_CONTACT_ID)
358: AND
359: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INVOICE_TO_CONTACT_ID IS NOT NULL))
360: ) -- the AND condition above added to fix 3098878
361: THEN
373:
374: PROCEDURE INVOICE_TO_ORG IS
375: BEGIN
376: IF (p_initial_line_rec.INVOICE_TO_ORG_ID = FND_API.G_MISS_NUM OR
377: (OE_GLOBALS.Equal(p_initial_line_rec.INVOICE_TO_ORG_ID, p_old_line_rec.INVOICE_TO_ORG_ID)
378: AND
379: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INVOICE_TO_ORG_ID IS NOT NULL))
380: ) -- the AND condition above added to fix 3098878
381: THEN
393:
394: PROCEDURE INVOICING_RULE IS
395: BEGIN
396: IF (p_initial_line_rec.INVOICING_RULE_ID = FND_API.G_MISS_NUM OR
397: (OE_GLOBALS.Equal(p_initial_line_rec.INVOICING_RULE_ID, p_old_line_rec.INVOICING_RULE_ID)
398: AND
399: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.INVOICING_RULE_ID IS NOT NULL))
400: ) -- the AND condition above added to fix 3098878
401: THEN
406:
407: PROCEDURE ITEM_IDENTIFIER_TYPE IS
408: BEGIN
409: IF (p_initial_line_rec.ITEM_IDENTIFIER_TYPE = FND_API.G_MISS_CHAR OR
410: (OE_GLOBAlS.Equal(p_initial_line_rec.ITEM_IDENTIFIER_TYPE, p_old_line_rec.ITEM_IDENTIFIER_TYPE)
411: AND
412: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ITEM_IDENTIFIER_TYPE IS NOT NULL))
413: ) -- the AND condition above added to fix 3098878
414: THEN
426:
427: PROCEDURE ITEM_REVISION IS -- For bug 2951575
428: BEGIN
429: IF (p_initial_line_rec.ITEM_REVISION = FND_API.G_MISS_CHAR OR
430: (OE_GLOBAlS.Equal(p_initial_line_rec.ITEM_REVISION, p_old_line_rec.ITEM_REVISION)
431: AND
432: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ITEM_REVISION IS NOT NULL))
433: ) -- the AND condition above added to fix 3098878
434: THEN
439:
440: PROCEDURE ITEM_TYPE IS
441: BEGIN
442: IF (p_initial_line_rec.ITEM_TYPE_CODE = FND_API.G_MISS_CHAR OR
443: (OE_GLOBAlS.Equal(p_initial_line_rec.ITEM_TYPE_CODE, p_old_line_rec.ITEM_TYPE_CODE)
444: AND
445: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ITEM_TYPE_CODE IS NOT NULL))
446: ) -- the AND condition above added to fix 3098878
447: THEN
459:
460: PROCEDURE LINE_TYPE IS
461: BEGIN
462: IF (p_initial_line_rec.LINE_TYPE_ID = FND_API.G_MISS_NUM OR
463: (OE_GLOBALS.Equal(p_initial_line_rec.LINE_TYPE_ID, p_old_line_rec.LINE_TYPE_ID)
464: AND
465: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.LINE_TYPE_ID IS NOT NULL))
466: ) -- the AND condition above added to fix 3098878
467: THEN
472:
473: PROCEDURE LINE_CATEGORY IS
474: BEGIN
475: IF (p_initial_line_rec.LINE_CATEGORY_CODE = FND_API.G_MISS_CHAR OR
476: (OE_GLOBAlS.Equal(p_initial_line_rec.LINE_CATEGORY_CODE, p_old_line_rec.LINE_CATEGORY_CODE)
477: AND
478: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.LINE_CATEGORY_CODE IS NOT NULL))
479: ) -- the AND condition above added to fix 3098878
480: THEN
486:
487: PROCEDURE OPTION_NUMBER IS
488: BEGIN
489: IF (p_initial_line_rec.OPTION_NUMBER = FND_API.G_MISS_NUM OR
490: (OE_GLOBALS.Equal(p_initial_line_rec.OPTION_NUMBER, p_old_line_rec.OPTION_NUMBER)
491: AND
492: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.OPTION_NUMBER IS NOT NULL))
493: ) -- the AND condition above added to fix 3098878
494: THEN
499:
500: PROCEDURE ORDERED_ITEM IS
501: BEGIN
502: IF (p_initial_line_rec.ORDERED_ITEM_ID = FND_API.G_MISS_NUM OR
503: (OE_GLOBALS.Equal(p_initial_line_rec.ORDERED_ITEM_ID, p_old_line_rec.ORDERED_ITEM_ID)
504: AND
505: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDERED_ITEM_ID IS NOT NULL))
506: ) -- the AND condition above added to fix 3098878
507: THEN
519:
520: PROCEDURE ORDER_QUANTITY_UOM IS
521: BEGIN
522: IF (p_initial_line_rec.ORDER_QUANTITY_UOM = FND_API.G_MISS_CHAR OR
523: (OE_GLOBAlS.Equal(p_initial_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
524: AND
525: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDER_QUANTITY_UOM IS NOT NULL))
526: ) -- the AND condition above added to fix 3098878
527: THEN
542: RETURN;
543: END IF;
544:
545: -- bug 2454963, do not clear for pricing call
546: IF (nvl(OE_GLOBALS.G_PRICING_RECURSION,'N') <> 'Y') THEN
547: p_x_line_rec.ORDER_QUANTITY_UOM := FND_API.G_MISS_CHAR;
548: END IF;
549: x_dep_attr_exists := 'Y';
550: END IF;
555: =====================*/
556: PROCEDURE ORDERED_QUANTITY_UOM2 IS
557: BEGIN
558: IF (p_initial_line_rec.ORDERED_QUANTITY_UOM2 = FND_API.G_MISS_CHAR OR
559: (OE_GLOBAlS.Equal(p_initial_line_rec.ORDERED_QUANTITY_UOM2, p_old_line_rec.ORDERED_QUANTITY_UOM2)
560: AND
561: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDERED_QUANTITY_UOM2 IS NOT NULL))
562: ) -- the AND condition above added to fix 3098878
563: THEN
579: PROCEDURE ORDERED_QUANTITY2 IS
580: BEGIN
581: OE_DEBUG_PUB.add('OPM Procedure ordered_quantity2',1);
582: IF (p_initial_line_rec.ORDERED_QUANTITY2 = FND_API.G_MISS_NUM OR
583: (OE_GLOBALS.Equal(p_initial_line_rec.ORDERED_QUANTITY2, p_old_line_rec.ORDERED_QUANTITY2)
584: AND
585: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDERED_QUANTITY2 IS NOT NULL))
586: ) -- the AND condition above added to fix 3098878
587: THEN
601:
602: PROCEDURE PAYMENT_TERM IS
603: BEGIN
604: IF (p_initial_line_rec.PAYMENT_TERM_ID = FND_API.G_MISS_NUM OR
605: (OE_GLOBALS.Equal(p_initial_line_rec.PAYMENT_TERM_ID, p_old_line_rec.PAYMENT_TERM_ID)
606: AND
607: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PAYMENT_TERM_ID IS NOT NULL))
608: ) -- the AND condition above added to fix 3098878
609: THEN
616: =====================*/
617: PROCEDURE PREFERRED_GRADE IS
618: BEGIN
619: IF (p_initial_line_rec.PREFERRED_GRADE = FND_API.G_MISS_CHAR OR
620: (OE_GLOBAlS.Equal(p_initial_line_rec.PREFERRED_GRADE, p_old_line_rec.PREFERRED_GRADE)
621: AND
622: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PREFERRED_GRADE IS NOT NULL))
623: ) -- the AND condition above added to fix 3098878
624: THEN
631:
632: PROCEDURE PRICE_LIST IS
633: BEGIN
634: IF (p_initial_line_rec.PRICE_LIST_ID = FND_API.G_MISS_NUM OR
635: (OE_GLOBALS.Equal(p_initial_line_rec.PRICE_LIST_ID, p_old_line_rec.PRICE_LIST_ID)
636: AND
637: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PRICE_LIST_ID IS NOT NULL))
638: ) -- the AND condition above added to fix 3098878
639: THEN
660:
661: PROCEDURE PRICE_REQUEST_CODE IS -- PROMOTIONS SEP/01
662: BEGIN
663: IF (p_initial_line_rec.PRICE_REQUEST_CODE = FND_API.G_MISS_CHAR OR
664: (OE_GLOBAlS.Equal(p_initial_line_rec.PRICE_REQUEST_CODE, p_old_line_rec.PRICE_REQUEST_CODE)
665: AND
666: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PRICE_REQUEST_CODE IS NOT NULL))
667: ) -- the AND condition above added to fix 3098878
668: THEN
673:
674: PROCEDURE PRICING_QUANTITY_UOM IS
675: BEGIN
676: IF (p_initial_line_rec.PRICING_QUANTITY_UOM = FND_API.G_MISS_CHAR OR
677: (OE_GLOBAlS.Equal(p_initial_line_rec.PRICING_QUANTITY_UOM, p_old_line_rec.PRICING_QUANTITY_UOM)
678: AND
679: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PRICING_QUANTITY_UOM IS NOT NULL))
680: ) -- the AND condition above added to fix 3098878
681: THEN
680: ) -- the AND condition above added to fix 3098878
681: THEN
682:
683: -- bug 2454963, do not clear for pricing call
684: IF (nvl(OE_GLOBALS.G_PRICING_RECURSION,'N') <> 'Y') THEN
685: p_x_line_rec.PRICING_QUANTITY_UOM := FND_API.G_MISS_CHAR;
686: END IF;
687: x_dep_attr_exists := 'Y';
688: END IF;
690:
691: PROCEDURE PROMISE_DATE IS
692: BEGIN
693: IF (p_initial_line_rec.PROMISE_DATE = FND_API.G_MISS_DATE OR
694: (OE_GLOBALS.Equal(p_initial_line_rec.PROMISE_DATE, p_old_line_rec.PROMISE_DATE)
695: AND
696: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PROMISE_DATE IS NOT NULL))
697: ) -- the AND condition above added to fix 3098878
698: THEN
703:
704: PROCEDURE REQUEST_DATE IS
705: BEGIN
706: IF (p_initial_line_rec.REQUEST_DATE = FND_API.G_MISS_DATE OR
707: (OE_GLOBALS.Equal(p_initial_line_rec.REQUEST_DATE, p_old_line_rec.REQUEST_DATE)
708: AND
709: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.REQUEST_DATE IS NOT NULL))
710: ) -- the AND condition above added to fix 3098878
711: THEN
730:
731: PROCEDURE SALESREP IS
732: BEGIN
733: IF (p_initial_line_rec.SALESREP_ID = FND_API.G_MISS_NUM OR
734: (OE_GLOBALS.Equal(p_initial_line_rec.SALESREP_ID, p_old_line_rec.SALESREP_ID)
735: AND
736: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SALESREP_ID IS NOT NULL))
737: ) -- the AND condition above added to fix 3098878
738: THEN
743:
744: PROCEDURE SCHEDULE_SHIP_DATE IS
745: BEGIN
746: IF (p_initial_line_rec.SCHEDULE_SHIP_DATE = FND_API.G_MISS_DATE OR
747: (OE_GLOBALS.Equal(p_initial_line_rec.SCHEDULE_SHIP_DATE, p_old_line_rec.SCHEDULE_SHIP_DATE)
748: AND
749: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SCHEDULE_SHIP_DATE IS NOT NULL))
750: ) -- the AND condition above added to fix 3098878
751: THEN
756:
757: PROCEDURE SHIPMENT_NUMBER IS
758: BEGIN
759: IF ((p_initial_line_rec.SHIPMENT_NUMBER = FND_API.G_MISS_NUM OR
760: (OE_GLOBALS.Equal(p_initial_line_rec.SHIPMENT_NUMBER, p_old_line_rec.SHIPMENT_NUMBER)
761: AND
762: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPMENT_NUMBER IS NOT NULL)))
763: AND
764: (p_initial_line_rec.SPLIT_FROM_LINE_ID is null OR p_initial_line_rec.SPLIT_FROM_LINE_ID= FND_API.G_MISS_NUM)
772:
773: PROCEDURE SHIPMENT_PRIORITY IS
774: BEGIN
775: IF (p_initial_line_rec.SHIPMENT_PRIORITY_CODE = FND_API.G_MISS_CHAR OR
776: (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPMENT_PRIORITY_CODE, p_old_line_rec.SHIPMENT_PRIORITY_CODE)
777: AND
778: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPMENT_PRIORITY_CODE IS NOT NULL))
779: ) -- the AND condition above added to fix 3098878
780: THEN
785:
786: PROCEDURE SHIPPABLE IS
787: BEGIN
788: IF (p_initial_line_rec.SHIPPABLE_FLAG = FND_API.G_MISS_CHAR OR
789: (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPABLE_FLAG, p_old_line_rec.SHIPPABLE_FLAG)
790: AND
791: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPABLE_FLAG IS NOT NULL))
792: ) -- the AND condition above added to fix 3098878
793: THEN
810:
811: PROCEDURE SHIPPING_METHOD IS
812: BEGIN
813: IF (p_initial_line_rec.SHIPPING_METHOD_CODE = FND_API.G_MISS_CHAR OR
814: (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPING_METHOD_CODE, p_old_line_rec.SHIPPING_METHOD_CODE)
815: AND
816: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPING_METHOD_CODE IS NOT NULL))
817: ) -- the AND condition above added to fix 3098878
818: THEN
823:
824: PROCEDURE SHIP_FROM_ORG IS
825: BEGIN
826: IF (p_initial_line_rec.SHIP_FROM_ORG_ID = FND_API.G_MISS_NUM OR
827: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_FROM_ORG_ID, p_old_line_rec.SHIP_FROM_ORG_ID)
828: AND
829: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_FROM_ORG_ID IS NOT NULL))
830: ) -- the AND condition above added to fix 3098878
831: THEN
865:
866: PROCEDURE SUBINVENTORY IS
867: BEGIN
868: IF (p_initial_line_rec.SUBINVENTORY = FND_API.G_MISS_CHAR OR
869: (OE_GLOBAlS.Equal(p_initial_line_rec.SUBINVENTORY, p_old_line_rec.SUBINVENTORY)
870: AND
871: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SUBINVENTORY IS NOT NULL))
872: ) -- the AND condition above added to fix 3098878
873: THEN
880:
881: PROCEDURE SHIP_TOLERANCE_ABOVE IS
882: BEGIN
883: IF (p_initial_line_rec.SHIP_TOLERANCE_ABOVE = FND_API.G_MISS_NUM OR
884: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_ABOVE, p_old_line_rec.SHIP_TOLERANCE_ABOVE)
885: AND
886: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_ABOVE IS NOT NULL))
887: ) -- the AND condition above added to fix 3098878
888: THEN
893:
894: PROCEDURE SHIP_TOLERANCE_BELOW IS
895: BEGIN
896: IF (p_initial_line_rec.SHIP_TOLERANCE_BELOW = FND_API.G_MISS_NUM OR
897: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_BELOW, p_old_line_rec.SHIP_TOLERANCE_BELOW)
898: AND
899: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_BELOW IS NOT NULL))
900: ) -- the AND condition above added to fix 3098878
901: THEN
906:
907: PROCEDURE SHIP_TO_CONTACT IS
908: BEGIN
909: IF (p_initial_line_rec.SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
910: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_CONTACT_ID, p_old_line_rec.SHIP_TO_CONTACT_ID)
911: AND
912: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_CONTACT_ID IS NOT NULL))
913: ) -- the AND condition above added to fix 3098878
914: THEN
919:
920: PROCEDURE SHIP_TO_ORG IS
921: BEGIN
922: IF (p_initial_line_rec.SHIP_TO_ORG_ID = FND_API.G_MISS_NUM OR
923: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_ORG_ID, p_old_line_rec.SHIP_TO_ORG_ID)
924: AND
925: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_ORG_ID IS NOT NULL))
926: ) -- the AND condition above added to fix 3098878
927: THEN
947:
948: PROCEDURE SOLD_TO_ORG IS
949: BEGIN
950: IF (p_initial_line_rec.SOLD_TO_ORG_ID = FND_API.G_MISS_NUM OR
951: (OE_GLOBALS.Equal(p_initial_line_rec.SOLD_TO_ORG_ID, p_old_line_rec.SOLD_TO_ORG_ID)
952: AND
953: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SOLD_TO_ORG_ID IS NOT NULL))
954: ) -- the AND condition above added to fix 3098878
955: THEN
967:
968: PROCEDURE TAX IS
969: BEGIN
970: IF (p_initial_line_rec.TAX_CODE = FND_API.G_MISS_CHAR OR
971: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_CODE, p_old_line_rec.TAX_CODE)
972: AND
973: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_CODE IS NOT NULL))
974: ) -- the AND condition above added to fix 3098878
975: THEN
990:
991: PROCEDURE TAX_DATE IS
992: BEGIN
993: IF (p_initial_line_rec.TAX_DATE = FND_API.G_MISS_DATE OR
994: (OE_GLOBALS.Equal(p_initial_line_rec.TAX_DATE, p_old_line_rec.TAX_DATE)
995: AND
996: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_DATE IS NOT NULL))
997: ) -- the AND condition above added to fix 3098878
998: THEN
1009:
1010: PROCEDURE TAX_EXEMPT IS
1011: BEGIN
1012: IF (p_initial_line_rec.TAX_EXEMPT_FLAG = FND_API.G_MISS_CHAR OR
1013: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_FLAG, p_old_line_rec.TAX_EXEMPT_FLAG)
1014: AND
1015: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_FLAG IS NOT NULL))
1016: ) -- the AND condition above added to fix 3098878
1017: THEN
1029:
1030: PROCEDURE TAX_EXEMPT_NUMBER IS
1031: BEGIN
1032: IF (p_initial_line_rec.TAX_EXEMPT_NUMBER = FND_API.G_MISS_CHAR OR
1033: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_NUMBER, p_old_line_rec.TAX_EXEMPT_NUMBER)
1034: AND
1035: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_NUMBER IS NOT NULL))
1036: ) -- the AND condition above added to fix 3098878
1037: THEN
1042: NULL;
1043: ELSE
1044: -- Clear it only if the tax_exempt_flag = 'S' or
1045: -- the tax_exempt_flag has changed.
1046: IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1047: , p_old_line_rec.TAX_EXEMPT_FLAG)
1048: OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1049: p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1050:
1058:
1059: PROCEDURE TAX_EXEMPT_REASON IS
1060: BEGIN
1061: IF (p_initial_line_rec.TAX_EXEMPT_REASON_CODE = FND_API.G_MISS_CHAR OR
1062: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_REASON_CODE, p_old_line_rec.TAX_EXEMPT_REASON_CODE)
1063: AND
1064: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_REASON_CODE IS NOT NULL))
1065: ) -- the AND condition above added to fix 3098878
1066: THEN
1072: ELSE
1073: -- Clear it only if the tax_exempt_flag = 'S' or
1074: -- the tax_exempt_flag has changed.
1075:
1076: IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1077: , p_old_line_rec.TAX_EXEMPT_FLAG)
1078: OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1079: p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1080:
1089:
1090: PROCEDURE TOP_MODEL_LINE IS
1091: BEGIN
1092: IF (p_initial_line_rec.TOP_MODEL_LINE_ID = FND_API.G_MISS_NUM OR
1093: (OE_GLOBALS.Equal(p_initial_line_rec.TOP_MODEL_LINE_ID, p_old_line_rec.TOP_MODEL_LINE_ID)
1094: AND
1095: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TOP_MODEL_LINE_ID IS NOT NULL))
1096: ) -- the AND condition above added to fix 3098878
1097: THEN
1102:
1103: PROCEDURE SERVICE_START_DATE IS
1104: BEGIN
1105: IF (p_initial_line_rec.SERVICE_START_DATE = FND_API.G_MISS_DATE OR
1106: (OE_GLOBALS.Equal(p_initial_line_rec.SERVICE_START_DATE, p_old_line_rec.SERVICE_START_DATE)
1107: AND
1108: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_START_DATE IS NOT NULL))
1109: ) -- the AND condition above added to fix 3098878
1110: THEN
1115:
1116: PROCEDURE SERVICE_PERIOD IS
1117: BEGIN
1118: IF (p_initial_line_rec.SERVICE_PERIOD = FND_API.G_MISS_CHAR OR
1119: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_PERIOD, p_old_line_rec.SERVICE_PERIOD)
1120: AND
1121: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_PERIOD IS NOT NULL))
1122: ) -- the AND condition above added to fix 3098878
1123: THEN
1129: -- bug4283037
1130: PROCEDURE SERVICE_DURATION IS
1131: BEGIN
1132: IF (p_initial_line_rec.SERVICE_DURATION = FND_API.G_MISS_NUM OR
1133: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_DURATION, p_old_line_rec.SERVICE_DURATION)
1134: AND
1135: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_DURATION IS NOT NULL))
1136: ) -- the AND condition above added to fix 3098878
1137: THEN
1142:
1143: PROCEDURE SERVICE_REFERENCE_TYPE_CODE IS
1144: BEGIN
1145: IF (p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE = FND_API.G_MISS_CHAR OR
1146: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE, p_old_line_rec.SERVICE_REFERENCE_TYPE_CODE)
1147: AND
1148: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL))
1149: ) -- the AND condition above added to fix 3098878
1150: THEN
1155:
1156: PROCEDURE RETURN_CONTEXT IS
1157: BEGIN
1158: IF (p_initial_line_rec.RETURN_CONTEXT = FND_API.G_MISS_CHAR OR
1159: (OE_GLOBAlS.Equal(p_initial_line_rec.RETURN_CONTEXT, p_old_line_rec.RETURN_CONTEXT)
1160: AND
1161: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.RETURN_CONTEXT IS NOT NULL))
1162: ) -- the AND condition above added to fix 3098878
1163: THEN
1176: -- Add for Bug 2766005
1177: PROCEDURE PACKING_INSTRUCTIONS IS
1178: BEGIN
1179: IF (p_initial_line_rec.PACKING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1180: (OE_GLOBAlS.Equal(p_initial_line_rec.PACKING_INSTRUCTIONS, p_old_line_rec.PACKING_INSTRUCTIONS)
1181: AND
1182: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PACKING_INSTRUCTIONS IS NOT NULL))
1183: ) -- the AND condition above added to fix 3098878
1184: THEN
1189:
1190: PROCEDURE SHIPPING_INSTRUCTIONS IS
1191: BEGIN
1192: IF (p_initial_line_rec.SHIPPING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1193: (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPING_INSTRUCTIONS, p_old_line_rec.SHIPPING_INSTRUCTIONS)
1194: AND
1195: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPING_INSTRUCTIONS IS NOT NULL))
1196: ) -- the AND condition above added to fix 3098878
1197: THEN
1205: --distributed orders
1206: PROCEDURE end_customer IS
1207: BEGIN
1208: IF (p_initial_line_rec.end_customer_id = FND_API.G_MISS_NUM
1209: OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_id
1210: , p_old_line_rec.end_customer_id ))
1211: THEN
1212: p_x_line_rec.end_customer_id := FND_API.G_MISS_NUM;
1213: x_dep_attr_exists := 'Y';
1216:
1217: PROCEDURE end_customer_contact IS
1218: BEGIN
1219: IF (p_initial_line_rec.end_customer_contact_id = FND_API.G_MISS_NUM
1220: OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_contact_id
1221: , p_old_line_rec.end_customer_contact_id ))
1222: THEN
1223: p_x_line_rec.end_customer_contact_id := FND_API.G_MISS_NUM;
1224: x_dep_attr_exists := 'Y';
1227:
1228: PROCEDURE end_customer_site_use IS
1229: BEGIN
1230: IF (p_initial_line_rec.end_customer_site_use_id = FND_API.G_MISS_NUM
1231: OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_site_use_id ,
1232: p_old_line_rec.end_customer_site_use_id ))
1233: THEN
1234: p_x_line_rec.end_customer_site_use_id := FND_API.G_MISS_NUM;
1235: x_dep_attr_exists := 'Y';
1239: --key Transaction Dates Project
1240: PROCEDURE order_firmed_date IS
1241: BEGIN
1242: IF(p_initial_line_rec.order_firmed_date = FND_API.G_MISS_DATE
1243: OR OE_GLOBALS.Equal(p_initial_line_rec.order_firmed_date ,
1244: p_old_line_rec.order_firmed_date ))
1245: THEN
1246: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE ;
1247: x_dep_attr_exists := 'Y' ;
1251: --Rakesh
1252: PROCEDURE CHARGE_PERIODICITY IS
1253: BEGIN
1254: IF (p_initial_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR OR
1255: OE_GLOBAlS.Equal(p_initial_line_rec.charge_periodicity_code, p_old_line_rec.charge_periodicity_code))
1256: THEN
1257: p_x_line_rec.charge_periodicity_code := FND_API.G_MISS_CHAR;
1258: x_dep_attr_exists := 'Y';
1259: END IF;
1270:
1271: IF p_src_attr_tbl.COUNT > 0 THEN
1272:
1273: OE_Dependencies.Mark_Dependent
1274: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1275: p_source_attr_tbl => p_src_attr_tbl,
1276: p_dep_attr_tbl => l_dep_attr_tbl);
1277:
1278: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
2535: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2536: )
2537: IS
2538: l_index NUMBER :=0;
2539: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2540: l_dep_attr_exists VARCHAR2(1);
2541: BEGIN
2542:
2543: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2553: -- every changed attribute clear its dependent fields.
2554:
2555: ELSE
2556:
2557: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ACCOUNTING_RULE_ID,p_old_line_rec.ACCOUNTING_RULE_ID)
2558: THEN
2559: l_index := l_index + 1.0;
2560: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2561: END IF;
2559: l_index := l_index + 1.0;
2560: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2561: END IF;
2562:
2563: IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2564: THEN
2565: l_index := l_index + 1.0;
2566: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2567: END IF;
2565: l_index := l_index + 1.0;
2566: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2567: END IF;
2568:
2569: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2570: THEN
2571: l_index := l_index + 1.0;
2572: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2573: END IF;
2571: l_index := l_index + 1.0;
2572: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2573: END IF;
2574:
2575: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2576: THEN
2577: l_index := l_index + 1.0;
2578: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2579: END IF;
2578: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2579: END IF;
2580:
2581: --bug5160469
2582: IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)
2583: THEN
2584: l_index := l_index + 1.0;
2585: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2586: END IF;
2584: l_index := l_index + 1.0;
2585: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2586: END IF;
2587:
2588: IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2589: THEN
2590: l_index := l_index + 1.0;
2591: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2592: END IF;
2590: l_index := l_index + 1.0;
2591: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2592: END IF;
2593:
2594: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2595: THEN
2596: l_index := l_index + 1.0;
2597: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG;
2598: END IF;
2598: END IF;
2599:
2600:
2601:
2602: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVENTORY_ITEM_ID,p_old_line_rec.INVENTORY_ITEM_ID)
2603: THEN
2604: l_index := l_index + 1.0;
2605: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2606: END IF;
2604: l_index := l_index + 1.0;
2605: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2606: END IF;
2607:
2608: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)
2609: THEN
2610: l_index := l_index + 1.0;
2611: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2612: END IF;
2610: l_index := l_index + 1.0;
2611: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2612: END IF;
2613:
2614: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2615: THEN
2616: l_index := l_index + 1.0;
2617: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2618: END IF;
2616: l_index := l_index + 1.0;
2617: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2618: END IF;
2619:
2620: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2621: THEN
2622: l_index := l_index + 1.0;
2623: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2624: END IF;
2622: l_index := l_index + 1.0;
2623: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2624: END IF;
2625:
2626: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2627: THEN
2628: l_index := l_index + 1.0;
2629: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2630: END IF;
2628: l_index := l_index + 1.0;
2629: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2630: END IF;
2631:
2632: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2633: THEN
2634: l_index := l_index + 1.0;
2635: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2636: END IF;
2634: l_index := l_index + 1.0;
2635: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2636: END IF;
2637:
2638: IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2639: THEN
2640: l_index := l_index + 1.0;
2641: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2642: END IF;
2640: l_index := l_index + 1.0;
2641: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2642: END IF;
2643:
2644: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2645: THEN
2646: l_index := l_index + 1.0;
2647: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2648: END IF;
2646: l_index := l_index + 1.0;
2647: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2648: END IF;
2649:
2650: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2651: THEN
2652: l_index := l_index + 1.0;
2653: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2654: END IF;
2652: l_index := l_index + 1.0;
2653: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2654: END IF;
2655:
2656: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2657: THEN
2658: l_index := l_index + 1.0;
2659: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2660: END IF;
2658: l_index := l_index + 1.0;
2659: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2660: END IF;
2661:
2662: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2663: THEN
2664: l_index := l_index + 1.0;
2665: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2666: END IF;
2664: l_index := l_index + 1.0;
2665: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2666: END IF;
2667:
2668: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2669: THEN
2670: l_index := l_index + 1.0;
2671: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2672: END IF;
2670: l_index := l_index + 1.0;
2671: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2672: END IF;
2673:
2674: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2675: THEN
2676: l_index := l_index + 1.0;
2677: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2678: END IF;
2676: l_index := l_index + 1.0;
2677: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2678: END IF;
2679:
2680: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2681: THEN
2682: l_index := l_index + 1.0;
2683: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2684: END IF;
2682: l_index := l_index + 1.0;
2683: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2684: END IF;
2685:
2686: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2687: THEN
2688: l_index := l_index + 1.0;
2689: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2690: END IF;
2688: l_index := l_index + 1.0;
2689: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2690: END IF;
2691: --Added following condition for Bug 2245073
2692: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2693: ) Then
2694: l_index := l_index + 1.0;
2695: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2696: End If;
2695: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2696: End If;
2697:
2698: -- The next two IF statements added for bug 5076119
2699: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)
2700: THEN
2701: l_index := l_index + 1.0;
2702: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2703: END IF;
2701: l_index := l_index + 1.0;
2702: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2703: END IF;
2704:
2705: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2706: THEN
2707: l_index := l_index + 1.0;
2708: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;
2709: END IF;
2781: -- 13-DEC-01 Introduced new procedure - clear_dep_and_default.
2782: -- This procedure will be used to detect if there was a dependent
2783: -- attribute that is changed and re-defaulted in the call or not.
2784: PROCEDURE Clear_Dep_And_Default
2785: ( p_src_attr_tbl IN OE_GLOBALS.Number_Tbl_Type
2786: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2787: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2788: )IS
2789: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2800: -- that passed to process order with the user-specified changes only
2801: l_initial_line_rec := l_line_rec;
2802:
2803: -- Initialize the global to 'N'
2804: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
2805:
2806: Clear_Dependents
2807: ( p_src_attr_tbl => p_src_attr_tbl
2808: , p_initial_line_rec => l_initial_line_rec