15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_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_SOU_rec.attribute1,p_old_SOU_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE1;
36: END IF;
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute10,p_old_SOU_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE10;
42: END IF;
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute11,p_old_SOU_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE11;
48: END IF;
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute12,p_old_SOU_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE12;
54: END IF;
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute13,p_old_SOU_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE13;
60: END IF;
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute14,p_old_SOU_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE14;
66: END IF;
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute15,p_old_SOU_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE15;
72: END IF;
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute2,p_old_SOU_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE2;
78: END IF;
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute3,p_old_SOU_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE3;
84: END IF;
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute4,p_old_SOU_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE4;
90: END IF;
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute5,p_old_SOU_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE5;
96: END IF;
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute6,p_old_SOU_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE6;
102: END IF;
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute7,p_old_SOU_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE7;
108: END IF;
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute8,p_old_SOU_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE8;
114: END IF;
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute9,p_old_SOU_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE9;
120: END IF;
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,p_old_SOU_rec.attribute_sourcing_id)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING;
126: END IF;
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,p_old_SOU_rec.attribute_sourcing_level)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING_LEVEL;
132: END IF;
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING_LEVEL;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_SOU_rec.application_id,p_old_SOU_rec.application_id)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_APPLICATION_ID;
138: END IF;
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_APPLICATION_ID;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_SOU_rec.context,p_old_SOU_rec.context)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CONTEXT;
144: END IF;
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CONTEXT;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_SOU_rec.created_by,p_old_SOU_rec.created_by)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATED_BY;
150: END IF;
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATED_BY;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_SOU_rec.creation_date,p_old_SOU_rec.creation_date)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATION_DATE;
156: END IF;
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATION_DATE;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,p_old_SOU_rec.enabled_flag)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ENABLED;
162: END IF;
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ENABLED;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,p_old_SOU_rec.last_updated_by)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATED_BY;
168: END IF;
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATED_BY;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_date,p_old_SOU_rec.last_update_date)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_DATE;
174: END IF;
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_DATE;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_login,p_old_SOU_rec.last_update_login)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_LOGIN;
180: END IF;
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_LOGIN;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_application_id,p_old_SOU_rec.program_application_id)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_APPLICATION;
186: END IF;
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_APPLICATION;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_id,p_old_SOU_rec.program_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM;
192: END IF;
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_update_date,p_old_SOU_rec.program_update_date)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,p_old_SOU_rec.request_type_code)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_REQUEST_TYPE;
204: END IF;
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_REQUEST_TYPE;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,p_old_SOU_rec.seeded_flag)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED;
210: END IF;
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED;
210: END IF;
211:
212: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,p_old_SOU_rec.seeded_sourcing_type)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_SOURCING_TYPE;
216: END IF;
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_SOURCING_TYPE;
216: END IF;
217:
218: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,p_old_SOU_rec.seeded_value_string)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_VALUE_STRING;
222: END IF;
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_VALUE_STRING;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,p_old_SOU_rec.segment_id)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEGMENT;
228: END IF;
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEGMENT;
228: END IF;
229:
230: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,p_old_SOU_rec.user_sourcing_type)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_USER_SOURCING_TYPE;
234: END IF;
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_USER_SOURCING_TYPE;
234: END IF;
235:
236: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_value_string,p_old_SOU_rec.user_value_string)
237: THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_USER_VALUE_STRING;
240: END IF;
362: -- Load out record
363:
364: x_SOU_rec := p_SOU_rec;
365:
366: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute1,p_old_SOU_rec.attribute1)
367: THEN
368: NULL;
369: END IF;
370:
367: THEN
368: NULL;
369: END IF;
370:
371: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute10,p_old_SOU_rec.attribute10)
372: THEN
373: NULL;
374: END IF;
375:
372: THEN
373: NULL;
374: END IF;
375:
376: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute11,p_old_SOU_rec.attribute11)
377: THEN
378: NULL;
379: END IF;
380:
377: THEN
378: NULL;
379: END IF;
380:
381: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute12,p_old_SOU_rec.attribute12)
382: THEN
383: NULL;
384: END IF;
385:
382: THEN
383: NULL;
384: END IF;
385:
386: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute13,p_old_SOU_rec.attribute13)
387: THEN
388: NULL;
389: END IF;
390:
387: THEN
388: NULL;
389: END IF;
390:
391: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute14,p_old_SOU_rec.attribute14)
392: THEN
393: NULL;
394: END IF;
395:
392: THEN
393: NULL;
394: END IF;
395:
396: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute15,p_old_SOU_rec.attribute15)
397: THEN
398: NULL;
399: END IF;
400:
397: THEN
398: NULL;
399: END IF;
400:
401: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute2,p_old_SOU_rec.attribute2)
402: THEN
403: NULL;
404: END IF;
405:
402: THEN
403: NULL;
404: END IF;
405:
406: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute3,p_old_SOU_rec.attribute3)
407: THEN
408: NULL;
409: END IF;
410:
407: THEN
408: NULL;
409: END IF;
410:
411: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute4,p_old_SOU_rec.attribute4)
412: THEN
413: NULL;
414: END IF;
415:
412: THEN
413: NULL;
414: END IF;
415:
416: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute5,p_old_SOU_rec.attribute5)
417: THEN
418: NULL;
419: END IF;
420:
417: THEN
418: NULL;
419: END IF;
420:
421: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute6,p_old_SOU_rec.attribute6)
422: THEN
423: NULL;
424: END IF;
425:
422: THEN
423: NULL;
424: END IF;
425:
426: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute7,p_old_SOU_rec.attribute7)
427: THEN
428: NULL;
429: END IF;
430:
427: THEN
428: NULL;
429: END IF;
430:
431: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute8,p_old_SOU_rec.attribute8)
432: THEN
433: NULL;
434: END IF;
435:
432: THEN
433: NULL;
434: END IF;
435:
436: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute9,p_old_SOU_rec.attribute9)
437: THEN
438: NULL;
439: END IF;
440:
437: THEN
438: NULL;
439: END IF;
440:
441: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,p_old_SOU_rec.attribute_sourcing_id)
442: THEN
443: NULL;
444: END IF;
445:
442: THEN
443: NULL;
444: END IF;
445:
446: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,p_old_SOU_rec.attribute_sourcing_level)
447: THEN
448: NULL;
449: END IF;
450:
447: THEN
448: NULL;
449: END IF;
450:
451: IF NOT QP_GLOBALS.Equal(p_SOU_rec.application_id,p_old_SOU_rec.application_id)
452: THEN
453: NULL;
454: END IF;
455:
453: NULL;
454: END IF;
455:
456:
457: IF NOT QP_GLOBALS.Equal(p_SOU_rec.context,p_old_SOU_rec.context)
458: THEN
459: NULL;
460: END IF;
461:
458: THEN
459: NULL;
460: END IF;
461:
462: IF NOT QP_GLOBALS.Equal(p_SOU_rec.created_by,p_old_SOU_rec.created_by)
463: THEN
464: NULL;
465: END IF;
466:
463: THEN
464: NULL;
465: END IF;
466:
467: IF NOT QP_GLOBALS.Equal(p_SOU_rec.creation_date,p_old_SOU_rec.creation_date)
468: THEN
469: NULL;
470: END IF;
471:
468: THEN
469: NULL;
470: END IF;
471:
472: IF NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,p_old_SOU_rec.enabled_flag)
473: THEN
474: NULL;
475: END IF;
476:
473: THEN
474: NULL;
475: END IF;
476:
477: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,p_old_SOU_rec.last_updated_by)
478: THEN
479: NULL;
480: END IF;
481:
478: THEN
479: NULL;
480: END IF;
481:
482: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_date,p_old_SOU_rec.last_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_SOU_rec.last_update_login,p_old_SOU_rec.last_update_login)
488: THEN
489: NULL;
490: END IF;
491:
488: THEN
489: NULL;
490: END IF;
491:
492: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_application_id,p_old_SOU_rec.program_application_id)
493: THEN
494: NULL;
495: END IF;
496:
493: THEN
494: NULL;
495: END IF;
496:
497: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_id,p_old_SOU_rec.program_id)
498: THEN
499: NULL;
500: END IF;
501:
498: THEN
499: NULL;
500: END IF;
501:
502: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_update_date,p_old_SOU_rec.program_update_date)
503: THEN
504: NULL;
505: END IF;
506:
503: THEN
504: NULL;
505: END IF;
506:
507: IF NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,p_old_SOU_rec.request_type_code)
508: THEN
509: NULL;
510: END IF;
511:
508: THEN
509: NULL;
510: END IF;
511:
512: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,p_old_SOU_rec.seeded_flag)
513: THEN
514: NULL;
515: END IF;
516:
513: THEN
514: NULL;
515: END IF;
516:
517: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,p_old_SOU_rec.seeded_sourcing_type)
518: THEN
519: NULL;
520: END IF;
521:
518: THEN
519: NULL;
520: END IF;
521:
522: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,p_old_SOU_rec.seeded_value_string)
523: THEN
524: NULL;
525: END IF;
526:
523: THEN
524: NULL;
525: END IF;
526:
527: IF NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,p_old_SOU_rec.segment_id)
528: THEN
529: NULL;
530: END IF;
531:
528: THEN
529: NULL;
530: END IF;
531:
532: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,p_old_SOU_rec.user_sourcing_type)
533: THEN
534: NULL;
535: END IF;
536:
533: THEN
534: NULL;
535: END IF;
536:
537: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_value_string,p_old_SOU_rec.user_value_string)
538: THEN
539: NULL;
540: END IF;
541:
1302: FOR UPDATE NOWAIT;
1303:
1304: -- Row locked. Compare IN attributes to DB attributes.
1305:
1306: IF QP_GLOBALS.Equal(p_SOU_rec.attribute1,
1307: l_SOU_rec.attribute1)
1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1304: -- Row locked. Compare IN attributes to DB attributes.
1305:
1306: IF QP_GLOBALS.Equal(p_SOU_rec.attribute1,
1307: l_SOU_rec.attribute1)
1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1306: IF QP_GLOBALS.Equal(p_SOU_rec.attribute1,
1307: l_SOU_rec.attribute1)
1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
1373: l_SOU_rec.user_sourcing_type)
1374: AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
1373: l_SOU_rec.user_sourcing_type)
1374: AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,
1375: l_SOU_rec.user_value_string)
1376: THEN
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
1373: l_SOU_rec.user_sourcing_type)
1374: AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,
1375: l_SOU_rec.user_value_string)
1376: THEN
1377:
1378: -- Row has not changed. Set out parameter.
1454: BEGIN
1455:
1456: IF p_SOU_rec.attribute_sourcing_id IS NOT NULL AND
1457: p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM AND
1458: NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1459: p_old_SOU_rec.attribute_sourcing_id)
1460: THEN
1461: l_SOU_val_rec.attribute_sourcing := QP_Id_To_Value.Attribute_Sourcing
1462: ( p_attribute_sourcing_id => p_SOU_rec.attribute_sourcing_id
1464: END IF;
1465:
1466: IF p_SOU_rec.enabled_flag IS NOT NULL AND
1467: p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1468: NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1469: p_old_SOU_rec.enabled_flag)
1470: THEN
1471: l_SOU_val_rec.enabled := QP_Id_To_Value.Enabled
1472: ( p_enabled_flag => p_SOU_rec.enabled_flag
1474: END IF;
1475:
1476: IF p_SOU_rec.request_type_code IS NOT NULL AND
1477: p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR AND
1478: NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1479: p_old_SOU_rec.request_type_code)
1480: THEN
1481: l_SOU_val_rec.request_type := QP_Id_To_Value.Request_Type
1482: ( p_request_type_code => p_SOU_rec.request_type_code
1484: END IF;
1485:
1486: IF p_SOU_rec.seeded_flag IS NOT NULL AND
1487: p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1488: NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1489: p_old_SOU_rec.seeded_flag)
1490: THEN
1491: l_SOU_val_rec.seeded := QP_Id_To_Value.Seeded
1492: ( p_seeded_flag => p_SOU_rec.seeded_flag
1494: END IF;
1495:
1496: IF p_SOU_rec.segment_id IS NOT NULL AND
1497: p_SOU_rec.segment_id <> FND_API.G_MISS_NUM AND
1498: NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1499: p_old_SOU_rec.segment_id)
1500: THEN
1501: l_SOU_val_rec.segment := QP_Id_To_Value.Segment
1502: ( p_segment_id => p_SOU_rec.segment_id