25: -- every changed attribute clear its dependent fields.
26:
27: IF p_attr_id = FND_API.G_MISS_NUM THEN
28:
29: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Sr_Source_Id,p_old_Shipping_Org_rec.Sr_Source_Id)
30: THEN
31: NULL;
32: END IF;
33:
30: THEN
31: NULL;
32: END IF;
33:
34: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Allocation_Percent,p_old_Shipping_Org_rec.Allocation_Percent)
35: THEN
36: NULL;
37: END IF;
38:
35: THEN
36: NULL;
37: END IF;
38:
39: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute1,p_old_Shipping_Org_rec.Attribute1)
40: THEN
41: NULL;
42: END IF;
43:
40: THEN
41: NULL;
42: END IF;
43:
44: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute10,p_old_Shipping_Org_rec.Attribute10)
45: THEN
46: NULL;
47: END IF;
48:
45: THEN
46: NULL;
47: END IF;
48:
49: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute11,p_old_Shipping_Org_rec.Attribute11)
50: THEN
51: NULL;
52: END IF;
53:
50: THEN
51: NULL;
52: END IF;
53:
54: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute12,p_old_Shipping_Org_rec.Attribute12)
55: THEN
56: NULL;
57: END IF;
58:
55: THEN
56: NULL;
57: END IF;
58:
59: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute13,p_old_Shipping_Org_rec.Attribute13)
60: THEN
61: NULL;
62: END IF;
63:
60: THEN
61: NULL;
62: END IF;
63:
64: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute14,p_old_Shipping_Org_rec.Attribute14)
65: THEN
66: NULL;
67: END IF;
68:
65: THEN
66: NULL;
67: END IF;
68:
69: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute15,p_old_Shipping_Org_rec.Attribute15)
70: THEN
71: NULL;
72: END IF;
73:
70: THEN
71: NULL;
72: END IF;
73:
74: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute2,p_old_Shipping_Org_rec.Attribute2)
75: THEN
76: NULL;
77: END IF;
78:
75: THEN
76: NULL;
77: END IF;
78:
79: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute3,p_old_Shipping_Org_rec.Attribute3)
80: THEN
81: NULL;
82: END IF;
83:
80: THEN
81: NULL;
82: END IF;
83:
84: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute4,p_old_Shipping_Org_rec.Attribute4)
85: THEN
86: NULL;
87: END IF;
88:
85: THEN
86: NULL;
87: END IF;
88:
89: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute5,p_old_Shipping_Org_rec.Attribute5)
90: THEN
91: NULL;
92: END IF;
93:
90: THEN
91: NULL;
92: END IF;
93:
94: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute6,p_old_Shipping_Org_rec.Attribute6)
95: THEN
96: NULL;
97: END IF;
98:
95: THEN
96: NULL;
97: END IF;
98:
99: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute7,p_old_Shipping_Org_rec.Attribute7)
100: THEN
101: NULL;
102: END IF;
103:
100: THEN
101: NULL;
102: END IF;
103:
104: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute8,p_old_Shipping_Org_rec.Attribute8)
105: THEN
106: NULL;
107: END IF;
108:
105: THEN
106: NULL;
107: END IF;
108:
109: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute9,p_old_Shipping_Org_rec.Attribute9)
110: THEN
111: NULL;
112: END IF;
113:
110: THEN
111: NULL;
112: END IF;
113:
114: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute_Category,p_old_Shipping_Org_rec.Attribute_Category)
115: THEN
116: NULL;
117: END IF;
118:
115: THEN
116: NULL;
117: END IF;
118:
119: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Created_By,p_old_Shipping_Org_rec.Created_By)
120: THEN
121: NULL;
122: END IF;
123:
120: THEN
121: NULL;
122: END IF;
123:
124: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Creation_Date,p_old_Shipping_Org_rec.Creation_Date)
125: THEN
126: NULL;
127: END IF;
128:
125: THEN
126: NULL;
127: END IF;
128:
129: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Updated_By,p_old_Shipping_Org_rec.Last_Updated_By)
130: THEN
131: NULL;
132: END IF;
133:
130: THEN
131: NULL;
132: END IF;
133:
134: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Date,p_old_Shipping_Org_rec.Last_Update_Date)
135: THEN
136: NULL;
137: END IF;
138:
135: THEN
136: NULL;
137: END IF;
138:
139: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Login,p_old_Shipping_Org_rec.Last_Update_Login)
140: THEN
141: NULL;
142: END IF;
143:
140: THEN
141: NULL;
142: END IF;
143:
144: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Application_Id,p_old_Shipping_Org_rec.Program_Application_Id)
145: THEN
146: NULL;
147: END IF;
148:
145: THEN
146: NULL;
147: END IF;
148:
149: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Id,p_old_Shipping_Org_rec.Program_Id)
150: THEN
151: NULL;
152: END IF;
153:
150: THEN
151: NULL;
152: END IF;
153:
154: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Update_Date,p_old_Shipping_Org_rec.Program_Update_Date)
155: THEN
156: NULL;
157: END IF;
158:
155: THEN
156: NULL;
157: END IF;
158:
159: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Rank,p_old_Shipping_Org_rec.Rank)
160: THEN
161: NULL;
162: END IF;
163:
160: THEN
161: NULL;
162: END IF;
163:
164: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Request_Id,p_old_Shipping_Org_rec.Request_Id)
165: THEN
166: NULL;
167: END IF;
168:
165: THEN
166: NULL;
167: END IF;
168:
169: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Secondary_Inventory,p_old_Shipping_Org_rec.Secondary_Inventory)
170: THEN
171: NULL;
172: END IF;
173:
170: THEN
171: NULL;
172: END IF;
173:
174: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Ship_Method,p_old_Shipping_Org_rec.Ship_Method)
175: THEN
176: NULL;
177: END IF;
178:
175: THEN
176: NULL;
177: END IF;
178:
179: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Source_Organization_Id,p_old_Shipping_Org_rec.Source_Organization_Id)
180: THEN
181: NULL;
182: END IF;
183:
180: THEN
181: NULL;
182: END IF;
183:
184: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Source_Type,p_old_Shipping_Org_rec.Source_Type)
185: THEN
186: NULL;
187: END IF;
188:
185: THEN
186: NULL;
187: END IF;
188:
189: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Sr_Receipt_Id,p_old_Shipping_Org_rec.Sr_Receipt_Id)
190: THEN
191: NULL;
192: END IF;
193:
190: THEN
191: NULL;
192: END IF;
193:
194: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Vendor_Id,p_old_Shipping_Org_rec.Vendor_Id)
195: THEN
196: NULL;
197: END IF;
198:
195: THEN
196: NULL;
197: END IF;
198:
199: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Vendor_Site_Id,p_old_Shipping_Org_rec.Vendor_Site_Id)
200: THEN
201: NULL;
202: END IF;
203:
303: -- Load out record
304:
305: x_Shipping_Org_rec := p_Shipping_Org_rec;
306:
307: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Sr_Source_Id,p_old_Shipping_Org_rec.Sr_Source_Id)
308: THEN
309: NULL;
310: END IF;
311:
308: THEN
309: NULL;
310: END IF;
311:
312: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Allocation_Percent,p_old_Shipping_Org_rec.Allocation_Percent)
313: THEN
314: NULL;
315: END IF;
316:
313: THEN
314: NULL;
315: END IF;
316:
317: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute1,p_old_Shipping_Org_rec.Attribute1)
318: THEN
319: NULL;
320: END IF;
321:
318: THEN
319: NULL;
320: END IF;
321:
322: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute10,p_old_Shipping_Org_rec.Attribute10)
323: THEN
324: NULL;
325: END IF;
326:
323: THEN
324: NULL;
325: END IF;
326:
327: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute11,p_old_Shipping_Org_rec.Attribute11)
328: THEN
329: NULL;
330: END IF;
331:
328: THEN
329: NULL;
330: END IF;
331:
332: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute12,p_old_Shipping_Org_rec.Attribute12)
333: THEN
334: NULL;
335: END IF;
336:
333: THEN
334: NULL;
335: END IF;
336:
337: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute13,p_old_Shipping_Org_rec.Attribute13)
338: THEN
339: NULL;
340: END IF;
341:
338: THEN
339: NULL;
340: END IF;
341:
342: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute14,p_old_Shipping_Org_rec.Attribute14)
343: THEN
344: NULL;
345: END IF;
346:
343: THEN
344: NULL;
345: END IF;
346:
347: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute15,p_old_Shipping_Org_rec.Attribute15)
348: THEN
349: NULL;
350: END IF;
351:
348: THEN
349: NULL;
350: END IF;
351:
352: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute2,p_old_Shipping_Org_rec.Attribute2)
353: THEN
354: NULL;
355: END IF;
356:
353: THEN
354: NULL;
355: END IF;
356:
357: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute3,p_old_Shipping_Org_rec.Attribute3)
358: THEN
359: NULL;
360: END IF;
361:
358: THEN
359: NULL;
360: END IF;
361:
362: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute4,p_old_Shipping_Org_rec.Attribute4)
363: THEN
364: NULL;
365: END IF;
366:
363: THEN
364: NULL;
365: END IF;
366:
367: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute5,p_old_Shipping_Org_rec.Attribute5)
368: THEN
369: NULL;
370: END IF;
371:
368: THEN
369: NULL;
370: END IF;
371:
372: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute6,p_old_Shipping_Org_rec.Attribute6)
373: THEN
374: NULL;
375: END IF;
376:
373: THEN
374: NULL;
375: END IF;
376:
377: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute7,p_old_Shipping_Org_rec.Attribute7)
378: THEN
379: NULL;
380: END IF;
381:
378: THEN
379: NULL;
380: END IF;
381:
382: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute8,p_old_Shipping_Org_rec.Attribute8)
383: THEN
384: NULL;
385: END IF;
386:
383: THEN
384: NULL;
385: END IF;
386:
387: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute9,p_old_Shipping_Org_rec.Attribute9)
388: THEN
389: NULL;
390: END IF;
391:
388: THEN
389: NULL;
390: END IF;
391:
392: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Attribute_Category,p_old_Shipping_Org_rec.Attribute_Category)
393: THEN
394: NULL;
395: END IF;
396:
393: THEN
394: NULL;
395: END IF;
396:
397: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Created_By,p_old_Shipping_Org_rec.Created_By)
398: THEN
399: NULL;
400: END IF;
401:
398: THEN
399: NULL;
400: END IF;
401:
402: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Creation_Date,p_old_Shipping_Org_rec.Creation_Date)
403: THEN
404: NULL;
405: END IF;
406:
403: THEN
404: NULL;
405: END IF;
406:
407: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Updated_By,p_old_Shipping_Org_rec.Last_Updated_By)
408: THEN
409: NULL;
410: END IF;
411:
408: THEN
409: NULL;
410: END IF;
411:
412: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Date,p_old_Shipping_Org_rec.Last_Update_Date)
413: THEN
414: NULL;
415: END IF;
416:
413: THEN
414: NULL;
415: END IF;
416:
417: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Last_Update_Login,p_old_Shipping_Org_rec.Last_Update_Login)
418: THEN
419: NULL;
420: END IF;
421:
418: THEN
419: NULL;
420: END IF;
421:
422: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Application_Id,p_old_Shipping_Org_rec.Program_Application_Id)
423: THEN
424: NULL;
425: END IF;
426:
423: THEN
424: NULL;
425: END IF;
426:
427: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Id,p_old_Shipping_Org_rec.Program_Id)
428: THEN
429: NULL;
430: END IF;
431:
428: THEN
429: NULL;
430: END IF;
431:
432: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Program_Update_Date,p_old_Shipping_Org_rec.Program_Update_Date)
433: THEN
434: NULL;
435: END IF;
436:
433: THEN
434: NULL;
435: END IF;
436:
437: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Rank,p_old_Shipping_Org_rec.Rank)
438: THEN
439: NULL;
440: END IF;
441:
438: THEN
439: NULL;
440: END IF;
441:
442: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Request_Id,p_old_Shipping_Org_rec.Request_Id)
443: THEN
444: NULL;
445: END IF;
446:
443: THEN
444: NULL;
445: END IF;
446:
447: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Secondary_Inventory,p_old_Shipping_Org_rec.Secondary_Inventory)
448: THEN
449: NULL;
450: END IF;
451:
448: THEN
449: NULL;
450: END IF;
451:
452: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Ship_Method,p_old_Shipping_Org_rec.Ship_Method)
453: THEN
454: NULL;
455: END IF;
456:
453: THEN
454: NULL;
455: END IF;
456:
457: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Source_Organization_Id,p_old_Shipping_Org_rec.Source_Organization_Id)
458: THEN
459: NULL;
460: END IF;
461:
458: THEN
459: NULL;
460: END IF;
461:
462: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Source_Type,p_old_Shipping_Org_rec.Source_Type)
463: THEN
464: NULL;
465: END IF;
466:
463: THEN
464: NULL;
465: END IF;
466:
467: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Sr_Receipt_Id,p_old_Shipping_Org_rec.Sr_Receipt_Id)
468: THEN
469: NULL;
470: END IF;
471:
468: THEN
469: NULL;
470: END IF;
471:
472: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Vendor_Id,p_old_Shipping_Org_rec.Vendor_Id)
473: THEN
474: NULL;
475: END IF;
476:
473: THEN
474: NULL;
475: END IF;
476:
477: IF NOT MRP_Globals.Equal(p_Shipping_Org_rec.Vendor_Site_Id,p_old_Shipping_Org_rec.Vendor_Site_Id)
478: THEN
479: NULL;
480: END IF;
481: