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_Receiving_Org_rec.Sr_Receipt_Id,p_old_Receiving_Org_rec.Sr_Receipt_Id)
30: THEN
31: NULL;
32: END IF;
33:
30: THEN
31: NULL;
32: END IF;
33:
34: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute1,p_old_Receiving_Org_rec.Attribute1)
35: THEN
36: NULL;
37: END IF;
38:
35: THEN
36: NULL;
37: END IF;
38:
39: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute10,p_old_Receiving_Org_rec.Attribute10)
40: THEN
41: NULL;
42: END IF;
43:
40: THEN
41: NULL;
42: END IF;
43:
44: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute11,p_old_Receiving_Org_rec.Attribute11)
45: THEN
46: NULL;
47: END IF;
48:
45: THEN
46: NULL;
47: END IF;
48:
49: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute12,p_old_Receiving_Org_rec.Attribute12)
50: THEN
51: NULL;
52: END IF;
53:
50: THEN
51: NULL;
52: END IF;
53:
54: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute13,p_old_Receiving_Org_rec.Attribute13)
55: THEN
56: NULL;
57: END IF;
58:
55: THEN
56: NULL;
57: END IF;
58:
59: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute14,p_old_Receiving_Org_rec.Attribute14)
60: THEN
61: NULL;
62: END IF;
63:
60: THEN
61: NULL;
62: END IF;
63:
64: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute15,p_old_Receiving_Org_rec.Attribute15)
65: THEN
66: NULL;
67: END IF;
68:
65: THEN
66: NULL;
67: END IF;
68:
69: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute2,p_old_Receiving_Org_rec.Attribute2)
70: THEN
71: NULL;
72: END IF;
73:
70: THEN
71: NULL;
72: END IF;
73:
74: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute3,p_old_Receiving_Org_rec.Attribute3)
75: THEN
76: NULL;
77: END IF;
78:
75: THEN
76: NULL;
77: END IF;
78:
79: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute4,p_old_Receiving_Org_rec.Attribute4)
80: THEN
81: NULL;
82: END IF;
83:
80: THEN
81: NULL;
82: END IF;
83:
84: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute5,p_old_Receiving_Org_rec.Attribute5)
85: THEN
86: NULL;
87: END IF;
88:
85: THEN
86: NULL;
87: END IF;
88:
89: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute6,p_old_Receiving_Org_rec.Attribute6)
90: THEN
91: NULL;
92: END IF;
93:
90: THEN
91: NULL;
92: END IF;
93:
94: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute7,p_old_Receiving_Org_rec.Attribute7)
95: THEN
96: NULL;
97: END IF;
98:
95: THEN
96: NULL;
97: END IF;
98:
99: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute8,p_old_Receiving_Org_rec.Attribute8)
100: THEN
101: NULL;
102: END IF;
103:
100: THEN
101: NULL;
102: END IF;
103:
104: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute9,p_old_Receiving_Org_rec.Attribute9)
105: THEN
106: NULL;
107: END IF;
108:
105: THEN
106: NULL;
107: END IF;
108:
109: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute_Category,p_old_Receiving_Org_rec.Attribute_Category)
110: THEN
111: NULL;
112: END IF;
113:
110: THEN
111: NULL;
112: END IF;
113:
114: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Created_By,p_old_Receiving_Org_rec.Created_By)
115: THEN
116: NULL;
117: END IF;
118:
115: THEN
116: NULL;
117: END IF;
118:
119: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Creation_Date,p_old_Receiving_Org_rec.Creation_Date)
120: THEN
121: NULL;
122: END IF;
123:
120: THEN
121: NULL;
122: END IF;
123:
124: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Disable_Date,p_old_Receiving_Org_rec.Disable_Date)
125: THEN
126: NULL;
127: END IF;
128:
125: THEN
126: NULL;
127: END IF;
128:
129: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Effective_Date,p_old_Receiving_Org_rec.Effective_Date)
130: THEN
131: NULL;
132: END IF;
133:
130: THEN
131: NULL;
132: END IF;
133:
134: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Last_Updated_By,p_old_Receiving_Org_rec.Last_Updated_By)
135: THEN
136: NULL;
137: END IF;
138:
135: THEN
136: NULL;
137: END IF;
138:
139: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Last_Update_Date,p_old_Receiving_Org_rec.Last_Update_Date)
140: THEN
141: NULL;
142: END IF;
143:
140: THEN
141: NULL;
142: END IF;
143:
144: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Last_Update_Login,p_old_Receiving_Org_rec.Last_Update_Login)
145: THEN
146: NULL;
147: END IF;
148:
145: THEN
146: NULL;
147: END IF;
148:
149: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Program_Application_Id,p_old_Receiving_Org_rec.Program_Application_Id)
150: THEN
151: NULL;
152: END IF;
153:
150: THEN
151: NULL;
152: END IF;
153:
154: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Program_Id,p_old_Receiving_Org_rec.Program_Id)
155: THEN
156: NULL;
157: END IF;
158:
155: THEN
156: NULL;
157: END IF;
158:
159: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Program_Update_Date,p_old_Receiving_Org_rec.Program_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_Receiving_Org_rec.Receipt_Organization_Id,p_old_Receiving_Org_rec.Receipt_Organization_Id)
165: THEN
166: NULL;
167: END IF;
168:
165: THEN
166: NULL;
167: END IF;
168:
169: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Request_Id,p_old_Receiving_Org_rec.Request_Id)
170: THEN
171: NULL;
172: END IF;
173:
170: THEN
171: NULL;
172: END IF;
173:
174: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Sourcing_Rule_Id,p_old_Receiving_Org_rec.Sourcing_Rule_Id)
175: THEN
176: NULL;
177: END IF;
178:
254: -- Load out record
255:
256: x_Receiving_Org_rec := p_Receiving_Org_rec;
257:
258: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Sr_Receipt_Id,p_old_Receiving_Org_rec.Sr_Receipt_Id)
259: THEN
260: NULL;
261: END IF;
262:
259: THEN
260: NULL;
261: END IF;
262:
263: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute1,p_old_Receiving_Org_rec.Attribute1)
264: THEN
265: NULL;
266: END IF;
267:
264: THEN
265: NULL;
266: END IF;
267:
268: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute10,p_old_Receiving_Org_rec.Attribute10)
269: THEN
270: NULL;
271: END IF;
272:
269: THEN
270: NULL;
271: END IF;
272:
273: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute11,p_old_Receiving_Org_rec.Attribute11)
274: THEN
275: NULL;
276: END IF;
277:
274: THEN
275: NULL;
276: END IF;
277:
278: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute12,p_old_Receiving_Org_rec.Attribute12)
279: THEN
280: NULL;
281: END IF;
282:
279: THEN
280: NULL;
281: END IF;
282:
283: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute13,p_old_Receiving_Org_rec.Attribute13)
284: THEN
285: NULL;
286: END IF;
287:
284: THEN
285: NULL;
286: END IF;
287:
288: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute14,p_old_Receiving_Org_rec.Attribute14)
289: THEN
290: NULL;
291: END IF;
292:
289: THEN
290: NULL;
291: END IF;
292:
293: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute15,p_old_Receiving_Org_rec.Attribute15)
294: THEN
295: NULL;
296: END IF;
297:
294: THEN
295: NULL;
296: END IF;
297:
298: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute2,p_old_Receiving_Org_rec.Attribute2)
299: THEN
300: NULL;
301: END IF;
302:
299: THEN
300: NULL;
301: END IF;
302:
303: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute3,p_old_Receiving_Org_rec.Attribute3)
304: THEN
305: NULL;
306: END IF;
307:
304: THEN
305: NULL;
306: END IF;
307:
308: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute4,p_old_Receiving_Org_rec.Attribute4)
309: THEN
310: NULL;
311: END IF;
312:
309: THEN
310: NULL;
311: END IF;
312:
313: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute5,p_old_Receiving_Org_rec.Attribute5)
314: THEN
315: NULL;
316: END IF;
317:
314: THEN
315: NULL;
316: END IF;
317:
318: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute6,p_old_Receiving_Org_rec.Attribute6)
319: THEN
320: NULL;
321: END IF;
322:
319: THEN
320: NULL;
321: END IF;
322:
323: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute7,p_old_Receiving_Org_rec.Attribute7)
324: THEN
325: NULL;
326: END IF;
327:
324: THEN
325: NULL;
326: END IF;
327:
328: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute8,p_old_Receiving_Org_rec.Attribute8)
329: THEN
330: NULL;
331: END IF;
332:
329: THEN
330: NULL;
331: END IF;
332:
333: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute9,p_old_Receiving_Org_rec.Attribute9)
334: THEN
335: NULL;
336: END IF;
337:
334: THEN
335: NULL;
336: END IF;
337:
338: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Attribute_Category,p_old_Receiving_Org_rec.Attribute_Category)
339: THEN
340: NULL;
341: END IF;
342:
339: THEN
340: NULL;
341: END IF;
342:
343: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Created_By,p_old_Receiving_Org_rec.Created_By)
344: THEN
345: NULL;
346: END IF;
347:
344: THEN
345: NULL;
346: END IF;
347:
348: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Creation_Date,p_old_Receiving_Org_rec.Creation_Date)
349: THEN
350: NULL;
351: END IF;
352:
349: THEN
350: NULL;
351: END IF;
352:
353: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Disable_Date,p_old_Receiving_Org_rec.Disable_Date)
354: THEN
355: NULL;
356: END IF;
357:
354: THEN
355: NULL;
356: END IF;
357:
358: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Effective_Date,p_old_Receiving_Org_rec.Effective_Date)
359: THEN
360: NULL;
361: END IF;
362:
359: THEN
360: NULL;
361: END IF;
362:
363: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Last_Updated_By,p_old_Receiving_Org_rec.Last_Updated_By)
364: THEN
365: NULL;
366: END IF;
367:
364: THEN
365: NULL;
366: END IF;
367:
368: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Last_Update_Date,p_old_Receiving_Org_rec.Last_Update_Date)
369: THEN
370: NULL;
371: END IF;
372:
369: THEN
370: NULL;
371: END IF;
372:
373: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Last_Update_Login,p_old_Receiving_Org_rec.Last_Update_Login)
374: THEN
375: NULL;
376: END IF;
377:
374: THEN
375: NULL;
376: END IF;
377:
378: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Program_Application_Id,p_old_Receiving_Org_rec.Program_Application_Id)
379: THEN
380: NULL;
381: END IF;
382:
379: THEN
380: NULL;
381: END IF;
382:
383: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Program_Id,p_old_Receiving_Org_rec.Program_Id)
384: THEN
385: NULL;
386: END IF;
387:
384: THEN
385: NULL;
386: END IF;
387:
388: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Program_Update_Date,p_old_Receiving_Org_rec.Program_Update_Date)
389: THEN
390: NULL;
391: END IF;
392:
389: THEN
390: NULL;
391: END IF;
392:
393: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Receipt_Organization_Id,p_old_Receiving_Org_rec.Receipt_Organization_Id)
394: THEN
395: NULL;
396: END IF;
397:
394: THEN
395: NULL;
396: END IF;
397:
398: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Request_Id,p_old_Receiving_Org_rec.Request_Id)
399: THEN
400: NULL;
401: END IF;
402:
399: THEN
400: NULL;
401: END IF;
402:
403: IF NOT MRP_Globals.Equal(p_Receiving_Org_rec.Sourcing_Rule_Id,p_old_Receiving_Org_rec.Sourcing_Rule_Id)
404: THEN
405: NULL;
406: END IF;
407: