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_Sourcing_Rule_rec.Sourcing_Rule_Id,p_old_Sourcing_Rule_rec.Sourcing_Rule_Id)
30: THEN
31: NULL;
32: END IF;
33:
30: THEN
31: NULL;
32: END IF;
33:
34: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute1,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute10,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute11,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute12,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute13,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute14,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute15,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute2,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute3,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute4,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute5,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute6,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute7,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute8,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute9,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Attribute_Category,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Created_By,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Creation_Date,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Description,p_old_Sourcing_Rule_rec.Description)
125: THEN
126: NULL;
127: END IF;
128:
125: THEN
126: NULL;
127: END IF;
128:
129: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Updated_By,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Last_Update_Date,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Last_Update_Login,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Organization_Id,p_old_Sourcing_Rule_rec.Organization_Id)
145: THEN
146: NULL;
147: END IF;
148:
145: THEN
146: NULL;
147: END IF;
148:
149: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Planning_Active,p_old_Sourcing_Rule_rec.Planning_Active)
150: THEN
151: NULL;
152: END IF;
153:
150: THEN
151: NULL;
152: END IF;
153:
154: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Application_Id,p_old_Sourcing_Rule_rec.Program_Application_Id)
155: THEN
156: NULL;
157: END IF;
158:
155: THEN
156: NULL;
157: END IF;
158:
159: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Id,p_old_Sourcing_Rule_rec.Program_Id)
160: THEN
161: NULL;
162: END IF;
163:
160: THEN
161: NULL;
162: END IF;
163:
164: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Update_Date,p_old_Sourcing_Rule_rec.Program_Update_Date)
165: THEN
166: NULL;
167: END IF;
168:
165: THEN
166: NULL;
167: END IF;
168:
169: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Request_Id,p_old_Sourcing_Rule_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_Sourcing_Rule_rec.Sourcing_Rule_Name,p_old_Sourcing_Rule_rec.Sourcing_Rule_Name)
175: THEN
176: NULL;
177: END IF;
178:
175: THEN
176: NULL;
177: END IF;
178:
179: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Sourcing_Rule_Type,p_old_Sourcing_Rule_rec.Sourcing_Rule_Type)
180: THEN
181: NULL;
182: END IF;
183:
180: THEN
181: NULL;
182: END IF;
183:
184: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Status,p_old_Sourcing_Rule_rec.Status)
185: THEN
186: NULL;
187: END IF;
188:
268: -- Load out record
269:
270: x_Sourcing_Rule_rec := p_Sourcing_Rule_rec;
271:
272: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Sourcing_Rule_Id,p_old_Sourcing_Rule_rec.Sourcing_Rule_Id)
273: THEN
274: NULL;
275: END IF;
276:
273: THEN
274: NULL;
275: END IF;
276:
277: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute1,p_old_Sourcing_Rule_rec.Attribute1)
278: THEN
279: NULL;
280: END IF;
281:
278: THEN
279: NULL;
280: END IF;
281:
282: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute10,p_old_Sourcing_Rule_rec.Attribute10)
283: THEN
284: NULL;
285: END IF;
286:
283: THEN
284: NULL;
285: END IF;
286:
287: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute11,p_old_Sourcing_Rule_rec.Attribute11)
288: THEN
289: NULL;
290: END IF;
291:
288: THEN
289: NULL;
290: END IF;
291:
292: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute12,p_old_Sourcing_Rule_rec.Attribute12)
293: THEN
294: NULL;
295: END IF;
296:
293: THEN
294: NULL;
295: END IF;
296:
297: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute13,p_old_Sourcing_Rule_rec.Attribute13)
298: THEN
299: NULL;
300: END IF;
301:
298: THEN
299: NULL;
300: END IF;
301:
302: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute14,p_old_Sourcing_Rule_rec.Attribute14)
303: THEN
304: NULL;
305: END IF;
306:
303: THEN
304: NULL;
305: END IF;
306:
307: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute15,p_old_Sourcing_Rule_rec.Attribute15)
308: THEN
309: NULL;
310: END IF;
311:
308: THEN
309: NULL;
310: END IF;
311:
312: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute2,p_old_Sourcing_Rule_rec.Attribute2)
313: THEN
314: NULL;
315: END IF;
316:
313: THEN
314: NULL;
315: END IF;
316:
317: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute3,p_old_Sourcing_Rule_rec.Attribute3)
318: THEN
319: NULL;
320: END IF;
321:
318: THEN
319: NULL;
320: END IF;
321:
322: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute4,p_old_Sourcing_Rule_rec.Attribute4)
323: THEN
324: NULL;
325: END IF;
326:
323: THEN
324: NULL;
325: END IF;
326:
327: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute5,p_old_Sourcing_Rule_rec.Attribute5)
328: THEN
329: NULL;
330: END IF;
331:
328: THEN
329: NULL;
330: END IF;
331:
332: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute6,p_old_Sourcing_Rule_rec.Attribute6)
333: THEN
334: NULL;
335: END IF;
336:
333: THEN
334: NULL;
335: END IF;
336:
337: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute7,p_old_Sourcing_Rule_rec.Attribute7)
338: THEN
339: NULL;
340: END IF;
341:
338: THEN
339: NULL;
340: END IF;
341:
342: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute8,p_old_Sourcing_Rule_rec.Attribute8)
343: THEN
344: NULL;
345: END IF;
346:
343: THEN
344: NULL;
345: END IF;
346:
347: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute9,p_old_Sourcing_Rule_rec.Attribute9)
348: THEN
349: NULL;
350: END IF;
351:
348: THEN
349: NULL;
350: END IF;
351:
352: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Attribute_Category,p_old_Sourcing_Rule_rec.Attribute_Category)
353: THEN
354: NULL;
355: END IF;
356:
353: THEN
354: NULL;
355: END IF;
356:
357: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Created_By,p_old_Sourcing_Rule_rec.Created_By)
358: THEN
359: NULL;
360: END IF;
361:
358: THEN
359: NULL;
360: END IF;
361:
362: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Creation_Date,p_old_Sourcing_Rule_rec.Creation_Date)
363: THEN
364: NULL;
365: END IF;
366:
363: THEN
364: NULL;
365: END IF;
366:
367: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Description,p_old_Sourcing_Rule_rec.Description)
368: THEN
369: NULL;
370: END IF;
371:
368: THEN
369: NULL;
370: END IF;
371:
372: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Updated_By,p_old_Sourcing_Rule_rec.Last_Updated_By)
373: THEN
374: NULL;
375: END IF;
376:
373: THEN
374: NULL;
375: END IF;
376:
377: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Update_Date,p_old_Sourcing_Rule_rec.Last_Update_Date)
378: THEN
379: NULL;
380: END IF;
381:
378: THEN
379: NULL;
380: END IF;
381:
382: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Last_Update_Login,p_old_Sourcing_Rule_rec.Last_Update_Login)
383: THEN
384: NULL;
385: END IF;
386:
383: THEN
384: NULL;
385: END IF;
386:
387: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Organization_Id,p_old_Sourcing_Rule_rec.Organization_Id)
388: THEN
389: NULL;
390: END IF;
391:
388: THEN
389: NULL;
390: END IF;
391:
392: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Planning_Active,p_old_Sourcing_Rule_rec.Planning_Active)
393: THEN
394: NULL;
395: END IF;
396:
393: THEN
394: NULL;
395: END IF;
396:
397: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Application_Id,p_old_Sourcing_Rule_rec.Program_Application_Id)
398: THEN
399: NULL;
400: END IF;
401:
398: THEN
399: NULL;
400: END IF;
401:
402: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Id,p_old_Sourcing_Rule_rec.Program_Id)
403: THEN
404: NULL;
405: END IF;
406:
403: THEN
404: NULL;
405: END IF;
406:
407: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Program_Update_Date,p_old_Sourcing_Rule_rec.Program_Update_Date)
408: THEN
409: NULL;
410: END IF;
411:
408: THEN
409: NULL;
410: END IF;
411:
412: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Request_Id,p_old_Sourcing_Rule_rec.Request_Id)
413: THEN
414: NULL;
415: END IF;
416:
413: THEN
414: NULL;
415: END IF;
416:
417: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Sourcing_Rule_Name,p_old_Sourcing_Rule_rec.Sourcing_Rule_Name)
418: THEN
419: NULL;
420: END IF;
421:
418: THEN
419: NULL;
420: END IF;
421:
422: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Sourcing_Rule_Type,p_old_Sourcing_Rule_rec.Sourcing_Rule_Type)
423: THEN
424: NULL;
425: END IF;
426:
423: THEN
424: NULL;
425: END IF;
426:
427: IF NOT MRP_Globals.Equal(p_Sourcing_Rule_rec.Status,p_old_Sourcing_Rule_rec.Status)
428: THEN
429: NULL;
430: END IF;
431: