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_Assignment_rec.Assignment_Id,p_old_Assignment_rec.Assignment_Id)
30: THEN
31: NULL;
32: END IF;
33:
30: THEN
31: NULL;
32: END IF;
33:
34: IF NOT MRP_Globals.Equal(p_Assignment_rec.Assignment_Set_Id,p_old_Assignment_rec.Assignment_Set_Id)
35: THEN
36: NULL;
37: END IF;
38:
35: THEN
36: NULL;
37: END IF;
38:
39: IF NOT MRP_Globals.Equal(p_Assignment_rec.Assignment_Type,p_old_Assignment_rec.Assignment_Type)
40: THEN
41: NULL;
42: END IF;
43:
40: THEN
41: NULL;
42: END IF;
43:
44: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute1,p_old_Assignment_rec.Attribute1)
45: THEN
46: NULL;
47: END IF;
48:
45: THEN
46: NULL;
47: END IF;
48:
49: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute10,p_old_Assignment_rec.Attribute10)
50: THEN
51: NULL;
52: END IF;
53:
50: THEN
51: NULL;
52: END IF;
53:
54: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute11,p_old_Assignment_rec.Attribute11)
55: THEN
56: NULL;
57: END IF;
58:
55: THEN
56: NULL;
57: END IF;
58:
59: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute12,p_old_Assignment_rec.Attribute12)
60: THEN
61: NULL;
62: END IF;
63:
60: THEN
61: NULL;
62: END IF;
63:
64: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute13,p_old_Assignment_rec.Attribute13)
65: THEN
66: NULL;
67: END IF;
68:
65: THEN
66: NULL;
67: END IF;
68:
69: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute14,p_old_Assignment_rec.Attribute14)
70: THEN
71: NULL;
72: END IF;
73:
70: THEN
71: NULL;
72: END IF;
73:
74: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute15,p_old_Assignment_rec.Attribute15)
75: THEN
76: NULL;
77: END IF;
78:
75: THEN
76: NULL;
77: END IF;
78:
79: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute2,p_old_Assignment_rec.Attribute2)
80: THEN
81: NULL;
82: END IF;
83:
80: THEN
81: NULL;
82: END IF;
83:
84: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute3,p_old_Assignment_rec.Attribute3)
85: THEN
86: NULL;
87: END IF;
88:
85: THEN
86: NULL;
87: END IF;
88:
89: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute4,p_old_Assignment_rec.Attribute4)
90: THEN
91: NULL;
92: END IF;
93:
90: THEN
91: NULL;
92: END IF;
93:
94: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute5,p_old_Assignment_rec.Attribute5)
95: THEN
96: NULL;
97: END IF;
98:
95: THEN
96: NULL;
97: END IF;
98:
99: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute6,p_old_Assignment_rec.Attribute6)
100: THEN
101: NULL;
102: END IF;
103:
100: THEN
101: NULL;
102: END IF;
103:
104: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute7,p_old_Assignment_rec.Attribute7)
105: THEN
106: NULL;
107: END IF;
108:
105: THEN
106: NULL;
107: END IF;
108:
109: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute8,p_old_Assignment_rec.Attribute8)
110: THEN
111: NULL;
112: END IF;
113:
110: THEN
111: NULL;
112: END IF;
113:
114: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute9,p_old_Assignment_rec.Attribute9)
115: THEN
116: NULL;
117: END IF;
118:
115: THEN
116: NULL;
117: END IF;
118:
119: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute_Category,p_old_Assignment_rec.Attribute_Category)
120: THEN
121: NULL;
122: END IF;
123:
120: THEN
121: NULL;
122: END IF;
123:
124: IF NOT MRP_Globals.Equal(p_Assignment_rec.Category_Id,p_old_Assignment_rec.Category_Id)
125: THEN
126: NULL;
127: END IF;
128:
125: THEN
126: NULL;
127: END IF;
128:
129: IF NOT MRP_Globals.Equal(p_Assignment_rec.Category_Set_Id,p_old_Assignment_rec.Category_Set_Id)
130: THEN
131: NULL;
132: END IF;
133:
130: THEN
131: NULL;
132: END IF;
133:
134: IF NOT MRP_Globals.Equal(p_Assignment_rec.Created_By,p_old_Assignment_rec.Created_By)
135: THEN
136: NULL;
137: END IF;
138:
135: THEN
136: NULL;
137: END IF;
138:
139: IF NOT MRP_Globals.Equal(p_Assignment_rec.Creation_Date,p_old_Assignment_rec.Creation_Date)
140: THEN
141: NULL;
142: END IF;
143:
140: THEN
141: NULL;
142: END IF;
143:
144: IF NOT MRP_Globals.Equal(p_Assignment_rec.Customer_Id,p_old_Assignment_rec.Customer_Id)
145: THEN
146: NULL;
147: END IF;
148:
145: THEN
146: NULL;
147: END IF;
148:
149: IF NOT MRP_Globals.Equal(p_Assignment_rec.Inventory_Item_Id,p_old_Assignment_rec.Inventory_Item_Id)
150: THEN
151: NULL;
152: END IF;
153:
150: THEN
151: NULL;
152: END IF;
153:
154: IF NOT MRP_Globals.Equal(p_Assignment_rec.Last_Updated_By,p_old_Assignment_rec.Last_Updated_By)
155: THEN
156: NULL;
157: END IF;
158:
155: THEN
156: NULL;
157: END IF;
158:
159: IF NOT MRP_Globals.Equal(p_Assignment_rec.Last_Update_Date,p_old_Assignment_rec.Last_Update_Date)
160: THEN
161: NULL;
162: END IF;
163:
160: THEN
161: NULL;
162: END IF;
163:
164: IF NOT MRP_Globals.Equal(p_Assignment_rec.Last_Update_Login,p_old_Assignment_rec.Last_Update_Login)
165: THEN
166: NULL;
167: END IF;
168:
165: THEN
166: NULL;
167: END IF;
168:
169: IF NOT MRP_Globals.Equal(p_Assignment_rec.Organization_Id,p_old_Assignment_rec.Organization_Id)
170: THEN
171: NULL;
172: END IF;
173:
170: THEN
171: NULL;
172: END IF;
173:
174: IF NOT MRP_Globals.Equal(p_Assignment_rec.Program_Application_Id,p_old_Assignment_rec.Program_Application_Id)
175: THEN
176: NULL;
177: END IF;
178:
175: THEN
176: NULL;
177: END IF;
178:
179: IF NOT MRP_Globals.Equal(p_Assignment_rec.Program_Id,p_old_Assignment_rec.Program_Id)
180: THEN
181: NULL;
182: END IF;
183:
180: THEN
181: NULL;
182: END IF;
183:
184: IF NOT MRP_Globals.Equal(p_Assignment_rec.Program_Update_Date,p_old_Assignment_rec.Program_Update_Date)
185: THEN
186: NULL;
187: END IF;
188:
185: THEN
186: NULL;
187: END IF;
188:
189: IF NOT MRP_Globals.Equal(p_Assignment_rec.Request_Id,p_old_Assignment_rec.Request_Id)
190: THEN
191: NULL;
192: END IF;
193:
190: THEN
191: NULL;
192: END IF;
193:
194: IF NOT MRP_Globals.Equal(p_Assignment_rec.Secondary_Inventory,p_old_Assignment_rec.Secondary_Inventory)
195: THEN
196: NULL;
197: END IF;
198:
195: THEN
196: NULL;
197: END IF;
198:
199: IF NOT MRP_Globals.Equal(p_Assignment_rec.Ship_To_Site_Id,p_old_Assignment_rec.Ship_To_Site_Id)
200: THEN
201: NULL;
202: END IF;
203:
200: THEN
201: NULL;
202: END IF;
203:
204: IF NOT MRP_Globals.Equal(p_Assignment_rec.Sourcing_Rule_Id,p_old_Assignment_rec.Sourcing_Rule_Id)
205: THEN
206: NULL;
207: END IF;
208:
205: THEN
206: NULL;
207: END IF;
208:
209: IF NOT MRP_Globals.Equal(p_Assignment_rec.Sourcing_Rule_Type,p_old_Assignment_rec.Sourcing_Rule_Type)
210: THEN
211: NULL;
212: END IF;
213:
356: -- Load out record
357:
358: x_Assignment_rec := p_Assignment_rec;
359:
360: IF NOT MRP_Globals.Equal(p_Assignment_rec.Assignment_Id,p_old_Assignment_rec.Assignment_Id)
361: THEN
362: NULL;
363: END IF;
364:
361: THEN
362: NULL;
363: END IF;
364:
365: IF NOT MRP_Globals.Equal(p_Assignment_rec.Assignment_Set_Id,p_old_Assignment_rec.Assignment_Set_Id)
366: THEN
367: NULL;
368: END IF;
369:
366: THEN
367: NULL;
368: END IF;
369:
370: IF NOT MRP_Globals.Equal(p_Assignment_rec.Assignment_Type,p_old_Assignment_rec.Assignment_Type)
371: THEN
372: NULL;
373: END IF;
374:
371: THEN
372: NULL;
373: END IF;
374:
375: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute1,p_old_Assignment_rec.Attribute1)
376: THEN
377: NULL;
378: END IF;
379:
376: THEN
377: NULL;
378: END IF;
379:
380: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute10,p_old_Assignment_rec.Attribute10)
381: THEN
382: NULL;
383: END IF;
384:
381: THEN
382: NULL;
383: END IF;
384:
385: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute11,p_old_Assignment_rec.Attribute11)
386: THEN
387: NULL;
388: END IF;
389:
386: THEN
387: NULL;
388: END IF;
389:
390: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute12,p_old_Assignment_rec.Attribute12)
391: THEN
392: NULL;
393: END IF;
394:
391: THEN
392: NULL;
393: END IF;
394:
395: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute13,p_old_Assignment_rec.Attribute13)
396: THEN
397: NULL;
398: END IF;
399:
396: THEN
397: NULL;
398: END IF;
399:
400: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute14,p_old_Assignment_rec.Attribute14)
401: THEN
402: NULL;
403: END IF;
404:
401: THEN
402: NULL;
403: END IF;
404:
405: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute15,p_old_Assignment_rec.Attribute15)
406: THEN
407: NULL;
408: END IF;
409:
406: THEN
407: NULL;
408: END IF;
409:
410: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute2,p_old_Assignment_rec.Attribute2)
411: THEN
412: NULL;
413: END IF;
414:
411: THEN
412: NULL;
413: END IF;
414:
415: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute3,p_old_Assignment_rec.Attribute3)
416: THEN
417: NULL;
418: END IF;
419:
416: THEN
417: NULL;
418: END IF;
419:
420: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute4,p_old_Assignment_rec.Attribute4)
421: THEN
422: NULL;
423: END IF;
424:
421: THEN
422: NULL;
423: END IF;
424:
425: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute5,p_old_Assignment_rec.Attribute5)
426: THEN
427: NULL;
428: END IF;
429:
426: THEN
427: NULL;
428: END IF;
429:
430: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute6,p_old_Assignment_rec.Attribute6)
431: THEN
432: NULL;
433: END IF;
434:
431: THEN
432: NULL;
433: END IF;
434:
435: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute7,p_old_Assignment_rec.Attribute7)
436: THEN
437: NULL;
438: END IF;
439:
436: THEN
437: NULL;
438: END IF;
439:
440: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute8,p_old_Assignment_rec.Attribute8)
441: THEN
442: NULL;
443: END IF;
444:
441: THEN
442: NULL;
443: END IF;
444:
445: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute9,p_old_Assignment_rec.Attribute9)
446: THEN
447: NULL;
448: END IF;
449:
446: THEN
447: NULL;
448: END IF;
449:
450: IF NOT MRP_Globals.Equal(p_Assignment_rec.Attribute_Category,p_old_Assignment_rec.Attribute_Category)
451: THEN
452: NULL;
453: END IF;
454:
451: THEN
452: NULL;
453: END IF;
454:
455: IF NOT MRP_Globals.Equal(p_Assignment_rec.Category_Id,p_old_Assignment_rec.Category_Id)
456: THEN
457: NULL;
458: END IF;
459:
456: THEN
457: NULL;
458: END IF;
459:
460: IF NOT MRP_Globals.Equal(p_Assignment_rec.Category_Set_Id,p_old_Assignment_rec.Category_Set_Id)
461: THEN
462: NULL;
463: END IF;
464:
461: THEN
462: NULL;
463: END IF;
464:
465: IF NOT MRP_Globals.Equal(p_Assignment_rec.Created_By,p_old_Assignment_rec.Created_By)
466: THEN
467: NULL;
468: END IF;
469:
466: THEN
467: NULL;
468: END IF;
469:
470: IF NOT MRP_Globals.Equal(p_Assignment_rec.Creation_Date,p_old_Assignment_rec.Creation_Date)
471: THEN
472: NULL;
473: END IF;
474:
471: THEN
472: NULL;
473: END IF;
474:
475: IF NOT MRP_Globals.Equal(p_Assignment_rec.Customer_Id,p_old_Assignment_rec.Customer_Id)
476: THEN
477: NULL;
478: END IF;
479:
476: THEN
477: NULL;
478: END IF;
479:
480: IF NOT MRP_Globals.Equal(p_Assignment_rec.Inventory_Item_Id,p_old_Assignment_rec.Inventory_Item_Id)
481: THEN
482: NULL;
483: END IF;
484:
481: THEN
482: NULL;
483: END IF;
484:
485: IF NOT MRP_Globals.Equal(p_Assignment_rec.Last_Updated_By,p_old_Assignment_rec.Last_Updated_By)
486: THEN
487: NULL;
488: END IF;
489:
486: THEN
487: NULL;
488: END IF;
489:
490: IF NOT MRP_Globals.Equal(p_Assignment_rec.Last_Update_Date,p_old_Assignment_rec.Last_Update_Date)
491: THEN
492: NULL;
493: END IF;
494:
491: THEN
492: NULL;
493: END IF;
494:
495: IF NOT MRP_Globals.Equal(p_Assignment_rec.Last_Update_Login,p_old_Assignment_rec.Last_Update_Login)
496: THEN
497: NULL;
498: END IF;
499:
496: THEN
497: NULL;
498: END IF;
499:
500: IF NOT MRP_Globals.Equal(p_Assignment_rec.Organization_Id,p_old_Assignment_rec.Organization_Id)
501: THEN
502: NULL;
503: END IF;
504:
501: THEN
502: NULL;
503: END IF;
504:
505: IF NOT MRP_Globals.Equal(p_Assignment_rec.Program_Application_Id,p_old_Assignment_rec.Program_Application_Id)
506: THEN
507: NULL;
508: END IF;
509:
506: THEN
507: NULL;
508: END IF;
509:
510: IF NOT MRP_Globals.Equal(p_Assignment_rec.Program_Id,p_old_Assignment_rec.Program_Id)
511: THEN
512: NULL;
513: END IF;
514:
511: THEN
512: NULL;
513: END IF;
514:
515: IF NOT MRP_Globals.Equal(p_Assignment_rec.Program_Update_Date,p_old_Assignment_rec.Program_Update_Date)
516: THEN
517: NULL;
518: END IF;
519:
516: THEN
517: NULL;
518: END IF;
519:
520: IF NOT MRP_Globals.Equal(p_Assignment_rec.Request_Id,p_old_Assignment_rec.Request_Id)
521: THEN
522: NULL;
523: END IF;
524:
521: THEN
522: NULL;
523: END IF;
524:
525: IF NOT MRP_Globals.Equal(p_Assignment_rec.Secondary_Inventory,p_old_Assignment_rec.Secondary_Inventory)
526: THEN
527: NULL;
528: END IF;
529:
526: THEN
527: NULL;
528: END IF;
529:
530: IF NOT MRP_Globals.Equal(p_Assignment_rec.Ship_To_Site_Id,p_old_Assignment_rec.Ship_To_Site_Id)
531: THEN
532: NULL;
533: END IF;
534:
531: THEN
532: NULL;
533: END IF;
534:
535: IF NOT MRP_Globals.Equal(p_Assignment_rec.Sourcing_Rule_Id,p_old_Assignment_rec.Sourcing_Rule_Id)
536: THEN
537: NULL;
538: END IF;
539:
536: THEN
537: NULL;
538: END IF;
539:
540: IF NOT MRP_Globals.Equal(p_Assignment_rec.Sourcing_Rule_Type,p_old_Assignment_rec.Sourcing_Rule_Type)
541: THEN
542: NULL;
543: END IF;
544: