15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
24:
28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute1,p_old_PSG_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE1;
36: END IF;
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute10,p_old_PSG_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE10;
42: END IF;
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute11,p_old_PSG_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE11;
48: END IF;
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute12,p_old_PSG_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE12;
54: END IF;
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute13,p_old_PSG_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE13;
60: END IF;
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute14,p_old_PSG_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE14;
66: END IF;
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute15,p_old_PSG_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE15;
72: END IF;
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute2,p_old_PSG_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE2;
78: END IF;
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute3,p_old_PSG_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE3;
84: END IF;
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute4,p_old_PSG_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE4;
90: END IF;
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute5,p_old_PSG_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE5;
96: END IF;
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute6,p_old_PSG_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE6;
102: END IF;
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute7,p_old_PSG_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE7;
108: END IF;
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute8,p_old_PSG_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE8;
114: END IF;
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute9,p_old_PSG_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE9;
120: END IF;
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_PSG_rec.context,p_old_PSG_rec.context)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CONTEXT;
126: END IF;
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CONTEXT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_PSG_rec.created_by,p_old_PSG_rec.created_by)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATED_BY;
132: END IF;
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATED_BY;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_PSG_rec.creation_date,p_old_PSG_rec.creation_date)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATION_DATE;
138: END IF;
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_CREATION_DATE;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATED_BY;
144: END IF;
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATED_BY;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_DATE;
150: END IF;
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_DATE;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_LOGIN;
156: END IF;
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LAST_UPDATE_LOGIN;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,p_old_PSG_rec.limits_enabled)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LIMITS_ENABLED;
162: END IF;
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LIMITS_ENABLED;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,p_old_PSG_rec.lov_enabled)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LOV_ENABLED;
168: END IF;
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_LOV_ENABLED;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_application_id,p_old_PSG_rec.program_application_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_APPLICATION;
174: END IF;
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_APPLICATION;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_id,p_old_PSG_rec.program_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM;
180: END IF;
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,p_old_PSG_rec.pte_code)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PTE;
192: END IF;
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_PTE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,p_old_PSG_rec.seeded_sourcing_method)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEEDED_SOURCING_METHOD;
198: END IF;
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEEDED_SOURCING_METHOD;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,p_old_PSG_rec.segment_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT;
204: END IF;
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_level,p_old_PSG_rec.segment_level)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_LEVEL;
210: END IF;
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_LEVEL;
210: END IF;
211:
212: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,p_old_PSG_rec.segment_pte_id)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_PTE;
216: END IF;
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SEGMENT_PTE;
216: END IF;
217:
218: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,p_old_PSG_rec.sourcing_enabled)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_ENABLED;
222: END IF;
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_ENABLED;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,p_old_PSG_rec.sourcing_status)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_STATUS;
228: END IF;
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_SOURCING_STATUS;
228: END IF;
229:
230: IF NOT QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,p_old_PSG_rec.user_sourcing_method)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_PSG_UTIL.G_USER_SOURCING_METHOD;
234: END IF;
353: -- Load out record
354:
355: x_PSG_rec := p_PSG_rec;
356:
357: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute1,p_old_PSG_rec.attribute1)
358: THEN
359: NULL;
360: END IF;
361:
358: THEN
359: NULL;
360: END IF;
361:
362: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute10,p_old_PSG_rec.attribute10)
363: THEN
364: NULL;
365: END IF;
366:
363: THEN
364: NULL;
365: END IF;
366:
367: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute11,p_old_PSG_rec.attribute11)
368: THEN
369: NULL;
370: END IF;
371:
368: THEN
369: NULL;
370: END IF;
371:
372: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute12,p_old_PSG_rec.attribute12)
373: THEN
374: NULL;
375: END IF;
376:
373: THEN
374: NULL;
375: END IF;
376:
377: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute13,p_old_PSG_rec.attribute13)
378: THEN
379: NULL;
380: END IF;
381:
378: THEN
379: NULL;
380: END IF;
381:
382: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute14,p_old_PSG_rec.attribute14)
383: THEN
384: NULL;
385: END IF;
386:
383: THEN
384: NULL;
385: END IF;
386:
387: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute15,p_old_PSG_rec.attribute15)
388: THEN
389: NULL;
390: END IF;
391:
388: THEN
389: NULL;
390: END IF;
391:
392: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute2,p_old_PSG_rec.attribute2)
393: THEN
394: NULL;
395: END IF;
396:
393: THEN
394: NULL;
395: END IF;
396:
397: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute3,p_old_PSG_rec.attribute3)
398: THEN
399: NULL;
400: END IF;
401:
398: THEN
399: NULL;
400: END IF;
401:
402: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute4,p_old_PSG_rec.attribute4)
403: THEN
404: NULL;
405: END IF;
406:
403: THEN
404: NULL;
405: END IF;
406:
407: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute5,p_old_PSG_rec.attribute5)
408: THEN
409: NULL;
410: END IF;
411:
408: THEN
409: NULL;
410: END IF;
411:
412: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute6,p_old_PSG_rec.attribute6)
413: THEN
414: NULL;
415: END IF;
416:
413: THEN
414: NULL;
415: END IF;
416:
417: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute7,p_old_PSG_rec.attribute7)
418: THEN
419: NULL;
420: END IF;
421:
418: THEN
419: NULL;
420: END IF;
421:
422: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute8,p_old_PSG_rec.attribute8)
423: THEN
424: NULL;
425: END IF;
426:
423: THEN
424: NULL;
425: END IF;
426:
427: IF NOT QP_GLOBALS.Equal(p_PSG_rec.attribute9,p_old_PSG_rec.attribute9)
428: THEN
429: NULL;
430: END IF;
431:
428: THEN
429: NULL;
430: END IF;
431:
432: IF NOT QP_GLOBALS.Equal(p_PSG_rec.context,p_old_PSG_rec.context)
433: THEN
434: NULL;
435: END IF;
436:
433: THEN
434: NULL;
435: END IF;
436:
437: IF NOT QP_GLOBALS.Equal(p_PSG_rec.created_by,p_old_PSG_rec.created_by)
438: THEN
439: NULL;
440: END IF;
441:
438: THEN
439: NULL;
440: END IF;
441:
442: IF NOT QP_GLOBALS.Equal(p_PSG_rec.creation_date,p_old_PSG_rec.creation_date)
443: THEN
444: NULL;
445: END IF;
446:
443: THEN
444: NULL;
445: END IF;
446:
447: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,p_old_PSG_rec.last_updated_by)
448: THEN
449: NULL;
450: END IF;
451:
448: THEN
449: NULL;
450: END IF;
451:
452: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_date,p_old_PSG_rec.last_update_date)
453: THEN
454: NULL;
455: END IF;
456:
453: THEN
454: NULL;
455: END IF;
456:
457: IF NOT QP_GLOBALS.Equal(p_PSG_rec.last_update_login,p_old_PSG_rec.last_update_login)
458: THEN
459: NULL;
460: END IF;
461:
458: THEN
459: NULL;
460: END IF;
461:
462: IF NOT QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,p_old_PSG_rec.limits_enabled)
463: THEN
464: NULL;
465: END IF;
466:
463: THEN
464: NULL;
465: END IF;
466:
467: IF NOT QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,p_old_PSG_rec.lov_enabled)
468: THEN
469: NULL;
470: END IF;
471:
468: THEN
469: NULL;
470: END IF;
471:
472: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_application_id,p_old_PSG_rec.program_application_id)
473: THEN
474: NULL;
475: END IF;
476:
473: THEN
474: NULL;
475: END IF;
476:
477: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_id,p_old_PSG_rec.program_id)
478: THEN
479: NULL;
480: END IF;
481:
478: THEN
479: NULL;
480: END IF;
481:
482: IF NOT QP_GLOBALS.Equal(p_PSG_rec.program_update_date,p_old_PSG_rec.program_update_date)
483: THEN
484: NULL;
485: END IF;
486:
483: THEN
484: NULL;
485: END IF;
486:
487: IF NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,p_old_PSG_rec.pte_code)
488: THEN
489: NULL;
490: END IF;
491:
488: THEN
489: NULL;
490: END IF;
491:
492: IF NOT QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,p_old_PSG_rec.seeded_sourcing_method)
493: THEN
494: NULL;
495: END IF;
496:
493: THEN
494: NULL;
495: END IF;
496:
497: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,p_old_PSG_rec.segment_id)
498: THEN
499: NULL;
500: END IF;
501:
498: THEN
499: NULL;
500: END IF;
501:
502: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_level,p_old_PSG_rec.segment_level)
503: THEN
504: NULL;
505: END IF;
506:
503: THEN
504: NULL;
505: END IF;
506:
507: IF NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,p_old_PSG_rec.segment_pte_id)
508: THEN
509: NULL;
510: END IF;
511:
508: THEN
509: NULL;
510: END IF;
511:
512: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,p_old_PSG_rec.sourcing_enabled)
513: THEN
514: NULL;
515: END IF;
516:
513: THEN
514: NULL;
515: END IF;
516:
517: IF NOT QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,p_old_PSG_rec.sourcing_status)
518: THEN
519: NULL;
520: END IF;
521:
518: THEN
519: NULL;
520: END IF;
521:
522: IF NOT QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,p_old_PSG_rec.user_sourcing_method)
523: THEN
524: NULL;
525: END IF;
526:
1274: FOR UPDATE NOWAIT;
1275:
1276: -- Row locked. Compare IN attributes to DB attributes.
1277:
1278: IF QP_GLOBALS.Equal(p_PSG_rec.attribute1,
1279: l_PSG_rec.attribute1)
1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1276: -- Row locked. Compare IN attributes to DB attributes.
1277:
1278: IF QP_GLOBALS.Equal(p_PSG_rec.attribute1,
1279: l_PSG_rec.attribute1)
1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1278: IF QP_GLOBALS.Equal(p_PSG_rec.attribute1,
1279: l_PSG_rec.attribute1)
1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1280: AND QP_GLOBALS.Equal(p_PSG_rec.attribute10,
1281: l_PSG_rec.attribute10)
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1282: AND QP_GLOBALS.Equal(p_PSG_rec.attribute11,
1283: l_PSG_rec.attribute11)
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1284: AND QP_GLOBALS.Equal(p_PSG_rec.attribute12,
1285: l_PSG_rec.attribute12)
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1286: AND QP_GLOBALS.Equal(p_PSG_rec.attribute13,
1287: l_PSG_rec.attribute13)
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1288: AND QP_GLOBALS.Equal(p_PSG_rec.attribute14,
1289: l_PSG_rec.attribute14)
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1290: AND QP_GLOBALS.Equal(p_PSG_rec.attribute15,
1291: l_PSG_rec.attribute15)
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1292: AND QP_GLOBALS.Equal(p_PSG_rec.attribute2,
1293: l_PSG_rec.attribute2)
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1294: AND QP_GLOBALS.Equal(p_PSG_rec.attribute3,
1295: l_PSG_rec.attribute3)
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1296: AND QP_GLOBALS.Equal(p_PSG_rec.attribute4,
1297: l_PSG_rec.attribute4)
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1298: AND QP_GLOBALS.Equal(p_PSG_rec.attribute5,
1299: l_PSG_rec.attribute5)
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1300: AND QP_GLOBALS.Equal(p_PSG_rec.attribute6,
1301: l_PSG_rec.attribute6)
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1302: AND QP_GLOBALS.Equal(p_PSG_rec.attribute7,
1303: l_PSG_rec.attribute7)
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1304: AND QP_GLOBALS.Equal(p_PSG_rec.attribute8,
1305: l_PSG_rec.attribute8)
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1306: AND QP_GLOBALS.Equal(p_PSG_rec.attribute9,
1307: l_PSG_rec.attribute9)
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1308: AND QP_GLOBALS.Equal(p_PSG_rec.context,
1309: l_PSG_rec.context)
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1310: AND QP_GLOBALS.Equal(p_PSG_rec.created_by,
1311: l_PSG_rec.created_by)
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1312: AND QP_GLOBALS.Equal(p_PSG_rec.creation_date,
1313: l_PSG_rec.creation_date)
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1314: AND QP_GLOBALS.Equal(p_PSG_rec.last_updated_by,
1315: l_PSG_rec.last_updated_by)
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1316: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_date,
1317: l_PSG_rec.last_update_date)
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1318: AND QP_GLOBALS.Equal(p_PSG_rec.last_update_login,
1319: l_PSG_rec.last_update_login)
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1320: AND QP_GLOBALS.Equal(p_PSG_rec.limits_enabled,
1321: l_PSG_rec.limits_enabled)
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1322: AND QP_GLOBALS.Equal(p_PSG_rec.lov_enabled,
1323: l_PSG_rec.lov_enabled)
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1324: AND QP_GLOBALS.Equal(p_PSG_rec.program_application_id,
1325: l_PSG_rec.program_application_id)
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1326: AND QP_GLOBALS.Equal(p_PSG_rec.program_id,
1327: l_PSG_rec.program_id)
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1328: AND QP_GLOBALS.Equal(p_PSG_rec.program_update_date,
1329: l_PSG_rec.program_update_date)
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1330: AND QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1331: l_PSG_rec.pte_code)
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1332: AND QP_GLOBALS.Equal(p_PSG_rec.seeded_sourcing_method,
1333: l_PSG_rec.seeded_sourcing_method)
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1334: AND QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1335: l_PSG_rec.segment_id)
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
1336: AND QP_GLOBALS.Equal(p_PSG_rec.segment_level,
1337: l_PSG_rec.segment_level)
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
1343: l_PSG_rec.sourcing_status)
1344: AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,
1338: AND QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1339: l_PSG_rec.segment_pte_id)
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
1343: l_PSG_rec.sourcing_status)
1344: AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,
1345: l_PSG_rec.user_sourcing_method)
1346: THEN
1340: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_enabled,
1341: l_PSG_rec.sourcing_enabled)
1342: AND QP_GLOBALS.Equal(p_PSG_rec.sourcing_status,
1343: l_PSG_rec.sourcing_status)
1344: AND QP_GLOBALS.Equal(p_PSG_rec.user_sourcing_method,
1345: l_PSG_rec.user_sourcing_method)
1346: THEN
1347:
1348: -- Row has not changed. Set out parameter.
1424: BEGIN
1425:
1426: IF p_PSG_rec.pte_code IS NOT NULL AND
1427: p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR AND
1428: NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1429: p_old_PSG_rec.pte_code)
1430: THEN
1431: l_PSG_val_rec.pte := QP_Id_To_Value.Pte
1432: ( p_pte_code => p_PSG_rec.pte_code
1434: END IF;
1435:
1436: IF p_PSG_rec.segment_id IS NOT NULL AND
1437: p_PSG_rec.segment_id <> FND_API.G_MISS_NUM AND
1438: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1439: p_old_PSG_rec.segment_id)
1440: THEN
1441: l_PSG_val_rec.segment := QP_Id_To_Value.Segment
1442: ( p_segment_id => p_PSG_rec.segment_id
1444: END IF;
1445:
1446: IF p_PSG_rec.segment_pte_id IS NOT NULL AND
1447: p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM AND
1448: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1449: p_old_PSG_rec.segment_pte_id)
1450: THEN
1451: l_PSG_val_rec.segment_pte := QP_Id_To_Value.Segment_Pte
1452: ( p_segment_pte_id => p_PSG_rec.segment_pte_id