[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
887:
888: PROCEDURE SUBINVENTORY IS
889: BEGIN
890: IF (p_initial_line_rec.SUBINVENTORY = FND_API.G_MISS_CHAR OR
891: (OE_GLOBAlS.Equal(p_initial_line_rec.SUBINVENTORY, p_old_line_rec.SUBINVENTORY)
892: AND
893: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SUBINVENTORY IS NOT NULL))
894: ) -- the AND condition above added to fix 3098878
895: THEN
902:
903: PROCEDURE SHIP_TOLERANCE_ABOVE IS
904: BEGIN
905: IF (p_initial_line_rec.SHIP_TOLERANCE_ABOVE = FND_API.G_MISS_NUM OR
906: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_ABOVE, p_old_line_rec.SHIP_TOLERANCE_ABOVE)
907: AND
908: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_ABOVE IS NOT NULL))
909: ) -- the AND condition above added to fix 3098878
910: THEN
915:
916: PROCEDURE SHIP_TOLERANCE_BELOW IS
917: BEGIN
918: IF (p_initial_line_rec.SHIP_TOLERANCE_BELOW = FND_API.G_MISS_NUM OR
919: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TOLERANCE_BELOW, p_old_line_rec.SHIP_TOLERANCE_BELOW)
920: AND
921: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TOLERANCE_BELOW IS NOT NULL))
922: ) -- the AND condition above added to fix 3098878
923: THEN
928:
929: PROCEDURE SHIP_TO_CONTACT IS
930: BEGIN
931: IF (p_initial_line_rec.SHIP_TO_CONTACT_ID = FND_API.G_MISS_NUM OR
932: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_CONTACT_ID, p_old_line_rec.SHIP_TO_CONTACT_ID)
933: AND
934: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_CONTACT_ID IS NOT NULL))
935: ) -- the AND condition above added to fix 3098878
936: THEN
941:
942: PROCEDURE SHIP_TO_ORG IS
943: BEGIN
944: IF (p_initial_line_rec.SHIP_TO_ORG_ID = FND_API.G_MISS_NUM OR
945: (OE_GLOBALS.Equal(p_initial_line_rec.SHIP_TO_ORG_ID, p_old_line_rec.SHIP_TO_ORG_ID)
946: AND
947: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIP_TO_ORG_ID IS NOT NULL))
948: ) -- the AND condition above added to fix 3098878
949: THEN
969:
970: PROCEDURE SOLD_TO_ORG IS
971: BEGIN
972: IF (p_initial_line_rec.SOLD_TO_ORG_ID = FND_API.G_MISS_NUM OR
973: (OE_GLOBALS.Equal(p_initial_line_rec.SOLD_TO_ORG_ID, p_old_line_rec.SOLD_TO_ORG_ID)
974: AND
975: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SOLD_TO_ORG_ID IS NOT NULL))
976: ) -- the AND condition above added to fix 3098878
977: THEN
989:
990: PROCEDURE TAX IS
991: BEGIN
992: IF (p_initial_line_rec.TAX_CODE = FND_API.G_MISS_CHAR OR
993: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_CODE, p_old_line_rec.TAX_CODE)
994: AND
995: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_CODE IS NOT NULL))
996: ) -- the AND condition above added to fix 3098878
997: THEN
1012:
1013: PROCEDURE TAX_DATE IS
1014: BEGIN
1015: IF (p_initial_line_rec.TAX_DATE = FND_API.G_MISS_DATE OR
1016: (OE_GLOBALS.Equal(p_initial_line_rec.TAX_DATE, p_old_line_rec.TAX_DATE)
1017: AND
1018: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_DATE IS NOT NULL))
1019: ) -- the AND condition above added to fix 3098878
1020: THEN
1031:
1032: PROCEDURE TAX_EXEMPT IS
1033: BEGIN
1034: IF (p_initial_line_rec.TAX_EXEMPT_FLAG = FND_API.G_MISS_CHAR OR
1035: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_FLAG, p_old_line_rec.TAX_EXEMPT_FLAG)
1036: AND
1037: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_FLAG IS NOT NULL))
1038: ) -- the AND condition above added to fix 3098878
1039: THEN
1051:
1052: PROCEDURE TAX_EXEMPT_NUMBER IS
1053: BEGIN
1054: IF (p_initial_line_rec.TAX_EXEMPT_NUMBER = FND_API.G_MISS_CHAR OR
1055: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_NUMBER, p_old_line_rec.TAX_EXEMPT_NUMBER)
1056: AND
1057: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_NUMBER IS NOT NULL))
1058: ) -- the AND condition above added to fix 3098878
1059: THEN
1064: NULL;
1065: ELSE
1066: -- Clear it only if the tax_exempt_flag = 'S' or
1067: -- the tax_exempt_flag has changed.
1068: IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1069: , p_old_line_rec.TAX_EXEMPT_FLAG)
1070: OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1071: p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1072:
1080:
1081: PROCEDURE TAX_EXEMPT_REASON IS
1082: BEGIN
1083: IF (p_initial_line_rec.TAX_EXEMPT_REASON_CODE = FND_API.G_MISS_CHAR OR
1084: (OE_GLOBAlS.Equal(p_initial_line_rec.TAX_EXEMPT_REASON_CODE, p_old_line_rec.TAX_EXEMPT_REASON_CODE)
1085: AND
1086: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TAX_EXEMPT_REASON_CODE IS NOT NULL))
1087: ) -- the AND condition above added to fix 3098878
1088: THEN
1094: ELSE
1095: -- Clear it only if the tax_exempt_flag = 'S' or
1096: -- the tax_exempt_flag has changed.
1097:
1098: IF NOT OE_GLOBAlS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG
1099: , p_old_line_rec.TAX_EXEMPT_FLAG)
1100: OR (p_old_line_rec.TAX_EXEMPT_FLAG = 'S' AND
1101: p_x_line_rec.TAX_EXEMPT_FLAG = 'S' ) THEN
1102:
1111:
1112: PROCEDURE TOP_MODEL_LINE IS
1113: BEGIN
1114: IF (p_initial_line_rec.TOP_MODEL_LINE_ID = FND_API.G_MISS_NUM OR
1115: (OE_GLOBALS.Equal(p_initial_line_rec.TOP_MODEL_LINE_ID, p_old_line_rec.TOP_MODEL_LINE_ID)
1116: AND
1117: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.TOP_MODEL_LINE_ID IS NOT NULL))
1118: ) -- the AND condition above added to fix 3098878
1119: THEN
1124:
1125: PROCEDURE SERVICE_START_DATE IS
1126: BEGIN
1127: IF (p_initial_line_rec.SERVICE_START_DATE = FND_API.G_MISS_DATE OR
1128: (OE_GLOBALS.Equal(p_initial_line_rec.SERVICE_START_DATE, p_old_line_rec.SERVICE_START_DATE)
1129: AND
1130: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_START_DATE IS NOT NULL))
1131: ) -- the AND condition above added to fix 3098878
1132: THEN
1137:
1138: PROCEDURE SERVICE_PERIOD IS
1139: BEGIN
1140: IF (p_initial_line_rec.SERVICE_PERIOD = FND_API.G_MISS_CHAR OR
1141: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_PERIOD, p_old_line_rec.SERVICE_PERIOD)
1142: AND
1143: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_PERIOD IS NOT NULL))
1144: ) -- the AND condition above added to fix 3098878
1145: THEN
1151: -- bug4283037
1152: PROCEDURE SERVICE_DURATION IS
1153: BEGIN
1154: IF (p_initial_line_rec.SERVICE_DURATION = FND_API.G_MISS_NUM OR
1155: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_DURATION, p_old_line_rec.SERVICE_DURATION)
1156: AND
1157: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_DURATION IS NOT NULL))
1158: ) -- the AND condition above added to fix 3098878
1159: THEN
1164:
1165: PROCEDURE SERVICE_REFERENCE_TYPE_CODE IS
1166: BEGIN
1167: IF (p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE = FND_API.G_MISS_CHAR OR
1168: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE, p_old_line_rec.SERVICE_REFERENCE_TYPE_CODE)
1169: AND
1170: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL))
1171: ) -- the AND condition above added to fix 3098878
1172: THEN
1178: --sol_ord_er #16014165
1179: PROCEDURE subscription_enable_flag IS
1180: BEGIN
1181: IF (p_initial_line_rec.subscription_enable_flag = FND_API.G_MISS_CHAR OR
1182: (OE_GLOBAlS.Equal(p_initial_line_rec.subscription_enable_flag, p_old_line_rec.subscription_enable_flag)
1183: AND
1184: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.subscription_enable_flag IS NOT NULL))
1185: )
1186: THEN
1191:
1192: PROCEDURE BILL_PROFILE_ID IS
1193: BEGIN
1194: IF (p_initial_line_rec.SERVICE_BILL_PROFILE_ID = FND_API.G_MISS_NUM OR
1195: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_BILL_PROFILE_ID, p_old_line_rec.SERVICE_BILL_PROFILE_ID)
1196: AND
1197: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_BILL_PROFILE_ID IS NOT NULL))
1198: )
1199: THEN
1204:
1205: PROCEDURE SERVICE_COVERAGE_TEMP IS
1206: BEGIN
1207: IF (p_initial_line_rec.SERVICE_COV_TEMPLATE_ID = FND_API.G_MISS_NUM OR
1208: (OE_GLOBAlS.Equal(p_initial_line_rec.SERVICE_COV_TEMPLATE_ID, p_old_line_rec.SERVICE_COV_TEMPLATE_ID)
1209: AND
1210: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SERVICE_COV_TEMPLATE_ID IS NOT NULL))
1211: )
1212: THEN
1217:
1218: PROCEDURE SUBSCRIPTION_TEMP IS
1219: BEGIN
1220: IF (p_initial_line_rec.service_subs_template_id = FND_API.G_MISS_NUM OR
1221: (OE_GLOBAlS.Equal(p_initial_line_rec.service_subs_template_id, p_old_line_rec.service_subs_template_id)
1222: AND
1223: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.service_subs_template_id IS NOT NULL))
1224: )
1225: THEN
1230:
1231: PROCEDURE SERV_BILL_OPTION IS
1232: BEGIN
1233: IF (p_initial_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR OR
1234: (OE_GLOBAlS.Equal(p_initial_line_rec.service_bill_option_code, p_old_line_rec.service_bill_option_code)
1235: AND
1236: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.service_bill_option_code IS NOT NULL))
1237: )
1238: THEN
1244:
1245: PROCEDURE RETURN_CONTEXT IS
1246: BEGIN
1247: IF (p_initial_line_rec.RETURN_CONTEXT = FND_API.G_MISS_CHAR OR
1248: (OE_GLOBAlS.Equal(p_initial_line_rec.RETURN_CONTEXT, p_old_line_rec.RETURN_CONTEXT)
1249: AND
1250: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.RETURN_CONTEXT IS NOT NULL))
1251: ) -- the AND condition above added to fix 3098878
1252: THEN
1265: -- Add for Bug 2766005
1266: PROCEDURE PACKING_INSTRUCTIONS IS
1267: BEGIN
1268: IF (p_initial_line_rec.PACKING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1269: (OE_GLOBAlS.Equal(p_initial_line_rec.PACKING_INSTRUCTIONS, p_old_line_rec.PACKING_INSTRUCTIONS)
1270: AND
1271: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.PACKING_INSTRUCTIONS IS NOT NULL))
1272: ) -- the AND condition above added to fix 3098878
1273: THEN
1278:
1279: PROCEDURE SHIPPING_INSTRUCTIONS IS
1280: BEGIN
1281: IF (p_initial_line_rec.SHIPPING_INSTRUCTIONS = FND_API.G_MISS_CHAR OR
1282: (OE_GLOBAlS.Equal(p_initial_line_rec.SHIPPING_INSTRUCTIONS, p_old_line_rec.SHIPPING_INSTRUCTIONS)
1283: AND
1284: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.SHIPPING_INSTRUCTIONS IS NOT NULL))
1285: ) -- the AND condition above added to fix 3098878
1286: THEN
1294: --distributed orders
1295: PROCEDURE end_customer IS
1296: BEGIN
1297: IF (p_initial_line_rec.end_customer_id = FND_API.G_MISS_NUM
1298: OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_id
1299: , p_old_line_rec.end_customer_id ))
1300: THEN
1301: p_x_line_rec.end_customer_id := FND_API.G_MISS_NUM;
1302: x_dep_attr_exists := 'Y';
1305:
1306: PROCEDURE end_customer_contact IS
1307: BEGIN
1308: IF (p_initial_line_rec.end_customer_contact_id = FND_API.G_MISS_NUM
1309: OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_contact_id
1310: , p_old_line_rec.end_customer_contact_id ))
1311: THEN
1312: p_x_line_rec.end_customer_contact_id := FND_API.G_MISS_NUM;
1313: x_dep_attr_exists := 'Y';
1316:
1317: PROCEDURE end_customer_site_use IS
1318: BEGIN
1319: IF (p_initial_line_rec.end_customer_site_use_id = FND_API.G_MISS_NUM
1320: OR OE_GLOBALS.Equal(p_initial_line_rec.end_customer_site_use_id ,
1321: p_old_line_rec.end_customer_site_use_id ))
1322: THEN
1323: p_x_line_rec.end_customer_site_use_id := FND_API.G_MISS_NUM;
1324: x_dep_attr_exists := 'Y';
1328: --key Transaction Dates Project
1329: PROCEDURE order_firmed_date IS
1330: BEGIN
1331: IF(p_initial_line_rec.order_firmed_date = FND_API.G_MISS_DATE
1332: OR OE_GLOBALS.Equal(p_initial_line_rec.order_firmed_date ,
1333: p_old_line_rec.order_firmed_date ))
1334: THEN
1335: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE ;
1336: x_dep_attr_exists := 'Y' ;
1340: --Rakesh
1341: PROCEDURE CHARGE_PERIODICITY IS
1342: BEGIN
1343: IF (p_initial_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR OR
1344: OE_GLOBAlS.Equal(p_initial_line_rec.charge_periodicity_code, p_old_line_rec.charge_periodicity_code))
1345: THEN
1346: p_x_line_rec.charge_periodicity_code := FND_API.G_MISS_CHAR;
1347: x_dep_attr_exists := 'Y';
1348: END IF;
1350: --13088960 begins
1351: PROCEDURE latest_acceptable_date IS
1352: BEGIN
1353: IF (p_initial_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE OR
1354: OE_GLOBAlS.Equal(p_initial_line_rec.latest_acceptable_date, p_old_line_rec.latest_acceptable_date))
1355: THEN
1356: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
1357: x_dep_attr_exists := 'Y';
1358: END IF;
1373: EXCEPTION
1374: WHEN Others THEN NULL;
1375: END;
1376: IF (p_initial_line_rec.ship_set = FND_API.G_MISS_CHAR OR
1377: OE_GLOBAlS.Equal(p_initial_line_rec.ship_set, p_old_line_rec.ship_set))
1378: THEN
1379: IF NVL(oe_sys_parameters.Value('ONT_LINE_SET_WH',p_initial_line_rec.org_id),'N') = 'Y'
1380: AND NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' -- 13706641
1381: AND OE_ORDER_CACHE.g_header_rec.customer_preference_set_code = 'SHIP' -- 13706641
1401:
1402: IF p_src_attr_tbl.COUNT > 0 THEN
1403:
1404: OE_Dependencies.Mark_Dependent
1405: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1406: p_source_attr_tbl => p_src_attr_tbl,
1407: p_dep_attr_tbl => l_dep_attr_tbl);
1408:
1409: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
2706: , p_x_line_rec IN OUT NOCOPY OE_AK_ORDER_LINES_V%ROWTYPE
2707: )
2708: IS
2709: l_index NUMBER :=0;
2710: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2711: l_dep_attr_exists VARCHAR2(1);
2712: BEGIN
2713:
2714: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2724: -- every changed attribute clear its dependent fields.
2725:
2726: ELSE
2727:
2728: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ACCOUNTING_RULE_ID,p_old_line_rec.ACCOUNTING_RULE_ID)
2729: THEN
2730: l_index := l_index + 1.0;
2731: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2732: END IF;
2730: l_index := l_index + 1.0;
2731: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ACCOUNTING_RULE;
2732: END IF;
2733:
2734: IF NOT OE_GLOBALS.Equal(p_x_line_rec.AGREEMENT_ID,p_old_line_rec.AGREEMENT_ID)
2735: THEN
2736: l_index := l_index + 1.0;
2737: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2738: END IF;
2736: l_index := l_index + 1.0;
2737: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_AGREEMENT;
2738: END IF;
2739:
2740: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_number,p_old_line_rec.blanket_number)
2741: THEN
2742: l_index := l_index + 1.0;
2743: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2744: END IF;
2742: l_index := l_index + 1.0;
2743: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_NUMBER;
2744: END IF;
2745:
2746: IF NOT OE_GLOBALS.Equal(p_x_line_rec.blanket_line_number,p_old_line_rec.blanket_line_number)
2747: THEN
2748: l_index := l_index + 1.0;
2749: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2750: END IF;
2749: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_BLANKET_LINE_NUMBER;
2750: END IF;
2751:
2752: --bug5160469
2753: IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_id,p_old_line_rec.commitment_id)
2754: THEN
2755: l_index := l_index + 1.0;
2756: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2757: END IF;
2755: l_index := l_index + 1.0;
2756: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_COMMITMENT;
2757: END IF;
2758:
2759: IF NOT OE_GLOBALS.Equal(p_x_line_rec.DELIVER_TO_ORG_ID,p_old_line_rec.DELIVER_TO_ORG_ID)
2760: THEN
2761: l_index := l_index + 1.0;
2762: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2763: END IF;
2761: l_index := l_index + 1.0;
2762: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_DELIVER_TO_ORG;
2763: END IF;
2764:
2765: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INTERMED_SHIP_TO_ORG_ID,p_old_line_rec.INTERMED_SHIP_TO_ORG_ID)
2766: THEN
2767: l_index := l_index + 1.0;
2768: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INTERMED_SHIP_TO_ORG;
2769: END IF;
2769: END IF;
2770:
2771:
2772:
2773: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVENTORY_ITEM_ID,p_old_line_rec.INVENTORY_ITEM_ID)
2774: THEN
2775: l_index := l_index + 1.0;
2776: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2777: END IF;
2775: l_index := l_index + 1.0;
2776: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVENTORY_ITEM;
2777: END IF;
2778: --sol_ord_er #16014165
2779: IF NOT OE_GLOBALS.Equal(p_x_line_rec.subscription_enable_flag,p_old_line_rec.subscription_enable_flag)
2780: THEN
2781: l_index := l_index + 1.0;
2782: l_src_attr_tbl(l_index) := OE_LINE_UTIL.g_subscription_enable_flag;
2783: END IF;
2782: l_src_attr_tbl(l_index) := OE_LINE_UTIL.g_subscription_enable_flag;
2783: END IF;
2784: --sol_ord_er #16014165 end
2785:
2786: IF NOT OE_GLOBALS.Equal(p_x_line_rec.INVOICE_TO_ORG_ID,p_old_line_rec.INVOICE_TO_ORG_ID)
2787: THEN
2788: l_index := l_index + 1.0;
2789: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2790: END IF;
2788: l_index := l_index + 1.0;
2789: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_INVOICE_TO_ORG;
2790: END IF;
2791:
2792: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_NUMBER,p_old_line_rec.LINE_NUMBER)
2793: THEN
2794: l_index := l_index + 1.0;
2795: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2796: END IF;
2794: l_index := l_index + 1.0;
2795: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_NUMBER;
2796: END IF;
2797:
2798: IF NOT OE_GLOBALS.Equal(p_x_line_rec.LINE_TYPE_ID,p_old_line_rec.LINE_TYPE_ID)
2799: THEN
2800: l_index := l_index + 1.0;
2801: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2802: END IF;
2800: l_index := l_index + 1.0;
2801: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_LINE_TYPE;
2802: END IF;
2803:
2804: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICE_LIST_ID,p_old_line_rec.PRICE_LIST_ID)
2805: THEN
2806: l_index := l_index + 1.0;
2807: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2808: END IF;
2806: l_index := l_index + 1.0;
2807: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICE_LIST;
2808: END IF;
2809:
2810: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PROMISE_DATE,p_old_line_rec.PROMISE_DATE)
2811: THEN
2812: l_index := l_index + 1.0;
2813: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2814: END IF;
2812: l_index := l_index + 1.0;
2813: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PROMISE_DATE;
2814: END IF;
2815:
2816: IF NOT OE_GLOBALS.Equal(p_x_line_rec.REQUEST_DATE,p_old_line_rec.REQUEST_DATE)
2817: THEN
2818: l_index := l_index + 1.0;
2819: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2820: END IF;
2818: l_index := l_index + 1.0;
2819: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_REQUEST_DATE;
2820: END IF;
2821:
2822: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SCHEDULE_SHIP_DATE,p_old_line_rec.SCHEDULE_SHIP_DATE)
2823: THEN
2824: l_index := l_index + 1.0;
2825: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2826: END IF;
2824: l_index := l_index + 1.0;
2825: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SCHEDULE_SHIP_DATE;
2826: END IF;
2827:
2828: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_FROM_ORG_ID,p_old_line_rec.SHIP_FROM_ORG_ID)
2829: THEN
2830: l_index := l_index + 1.0;
2831: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2832: END IF;
2830: l_index := l_index + 1.0;
2831: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_FROM_ORG;
2832: END IF;
2833:
2834: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SUBINVENTORY,p_old_line_rec.SUBINVENTORY)
2835: THEN
2836: l_index := l_index + 1.0;
2837: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2838: END IF;
2836: l_index := l_index + 1.0;
2837: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SUBINVENTORY;
2838: END IF;
2839:
2840: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SHIP_TO_ORG_ID,p_old_line_rec.SHIP_TO_ORG_ID)
2841: THEN
2842: l_index := l_index + 1.0;
2843: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2844: END IF;
2842: l_index := l_index + 1.0;
2843: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIP_TO_ORG;
2844: END IF;
2845:
2846: IF NOT OE_GLOBALS.Equal(p_x_line_rec.SOLD_TO_ORG_ID,p_old_line_rec.SOLD_TO_ORG_ID)
2847: THEN
2848: l_index := l_index + 1.0;
2849: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2850: END IF;
2848: l_index := l_index + 1.0;
2849: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SOLD_TO_ORG;
2850: END IF;
2851:
2852: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_CODE,p_old_line_rec.TAX_CODE)
2853: THEN
2854: l_index := l_index + 1.0;
2855: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2856: END IF;
2854: l_index := l_index + 1.0;
2855: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX;
2856: END IF;
2857:
2858: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_DATE,p_old_line_rec.TAX_DATE)
2859: THEN
2860: l_index := l_index + 1.0;
2861: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2862: END IF;
2860: l_index := l_index + 1.0;
2861: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_DATE;
2862: END IF;
2863:
2864: IF NOT OE_GLOBALS.Equal(p_x_line_rec.TAX_EXEMPT_FLAG,p_old_line_rec.TAX_EXEMPT_FLAG)
2865: THEN
2866: l_index := l_index + 1.0;
2867: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2868: END IF;
2866: l_index := l_index + 1.0;
2867: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_TAX_EXEMPT;
2868: END IF;
2869: --Added following condition for Bug 2245073
2870: IF NOT OE_GLOBALS.Equal(p_x_line_rec.PRICING_DATE, p_old_line_rec.PRICING_DATE
2871: ) Then
2872: l_index := l_index + 1.0;
2873: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2874: End If;
2873: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_PRICING_DATE;
2874: End If;
2875:
2876: -- The next two IF statements added for bug 5076119
2877: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDERED_QUANTITY, p_old_line_rec.ORDERED_QUANTITY)
2878: THEN
2879: l_index := l_index + 1.0;
2880: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2881: END IF;
2879: l_index := l_index + 1.0;
2880: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDERED_QUANTITY;
2881: END IF;
2882:
2883: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ORDER_QUANTITY_UOM, p_old_line_rec.ORDER_QUANTITY_UOM)
2884: THEN
2885: l_index := l_index + 1.0;
2886: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;
2887: END IF;
2886: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_ORDER_QUANTITY_UOM;
2887: END IF;
2888:
2889: --bug 13088960
2890: IF NOT OE_GLOBALS.Equal(p_x_line_rec.shipping_method_code, p_old_line_rec.shipping_method_code)
2891: THEN
2892: l_index := l_index + 1.0;
2893: l_src_attr_tbl(l_index) := OE_LINE_UTIL.G_SHIPPING_METHOD ;
2894: END IF;
2966: -- 13-DEC-01 Introduced new procedure - clear_dep_and_default.
2967: -- This procedure will be used to detect if there was a dependent
2968: -- attribute that is changed and re-defaulted in the call or not.
2969: PROCEDURE Clear_Dep_And_Default
2970: ( p_src_attr_tbl IN OE_GLOBALS.Number_Tbl_Type
2971: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2972: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
2973: )IS
2974: l_line_rec OE_AK_ORDER_LINES_V%ROWTYPE;
2985: -- that passed to process order with the user-specified changes only
2986: l_initial_line_rec := l_line_rec;
2987:
2988: -- Initialize the global to 'N'
2989: OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := 'N';
2990:
2991: Clear_Dependents
2992: ( p_src_attr_tbl => p_src_attr_tbl
2993: , p_initial_line_rec => l_initial_line_rec