eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_FNA_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_FNA_rec OUT NOCOPY QP_Attr_Map_PUB.Fna_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

Line 20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_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
24:

Line 32: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute1,p_old_FNA_rec.attribute1)

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_FNA_rec.attribute1,p_old_FNA_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute10,p_old_FNA_rec.attribute10)

34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute10,p_old_FNA_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE10;
42: END IF;

Line 44: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute11,p_old_FNA_rec.attribute11)

40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute11,p_old_FNA_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE11;
48: END IF;

Line 50: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute12,p_old_FNA_rec.attribute12)

46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute12,p_old_FNA_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE12;
54: END IF;

Line 56: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute13,p_old_FNA_rec.attribute13)

52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute13,p_old_FNA_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE13;
60: END IF;

Line 62: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute14,p_old_FNA_rec.attribute14)

58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute14,p_old_FNA_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE14;
66: END IF;

Line 68: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute15,p_old_FNA_rec.attribute15)

64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute15,p_old_FNA_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE15;
72: END IF;

Line 74: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute2,p_old_FNA_rec.attribute2)

70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute2,p_old_FNA_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE2;
78: END IF;

Line 80: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute3,p_old_FNA_rec.attribute3)

76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute3,p_old_FNA_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE3;
84: END IF;

Line 86: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute4,p_old_FNA_rec.attribute4)

82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute4,p_old_FNA_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE4;
90: END IF;

Line 92: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute5,p_old_FNA_rec.attribute5)

88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute5,p_old_FNA_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE5;
96: END IF;

Line 98: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute6,p_old_FNA_rec.attribute6)

94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute6,p_old_FNA_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE6;
102: END IF;

Line 104: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute7,p_old_FNA_rec.attribute7)

100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute7,p_old_FNA_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE7;
108: END IF;

Line 110: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute8,p_old_FNA_rec.attribute8)

106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute8,p_old_FNA_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE8;
114: END IF;

Line 116: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute9,p_old_FNA_rec.attribute9)

112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute9,p_old_FNA_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE9;
120: END IF;

Line 122: IF NOT QP_GLOBALS.Equal(p_FNA_rec.context,p_old_FNA_rec.context)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_FNA_rec.context,p_old_FNA_rec.context)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_CONTEXT;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_FNA_rec.created_by,p_old_FNA_rec.created_by)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_CONTEXT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_FNA_rec.created_by,p_old_FNA_rec.created_by)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_CREATED_BY;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_FNA_rec.creation_date,p_old_FNA_rec.creation_date)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_CREATED_BY;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_FNA_rec.creation_date,p_old_FNA_rec.creation_date)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_CREATION_DATE;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,p_old_FNA_rec.enabled_flag)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_CREATION_DATE;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,p_old_FNA_rec.enabled_flag)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ENABLED;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,p_old_FNA_rec.functional_area_id)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_ENABLED;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,p_old_FNA_rec.functional_area_id)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_FUNCTIONAL_AREA;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,p_old_FNA_rec.last_updated_by)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_FUNCTIONAL_AREA;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,p_old_FNA_rec.last_updated_by)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_LAST_UPDATED_BY;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_date,p_old_FNA_rec.last_update_date)

154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_LAST_UPDATED_BY;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_date,p_old_FNA_rec.last_update_date)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_LAST_UPDATE_DATE;
162: END IF;

Line 164: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_login,p_old_FNA_rec.last_update_login)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_LAST_UPDATE_DATE;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_login,p_old_FNA_rec.last_update_login)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_LAST_UPDATE_LOGIN;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_application_id,p_old_FNA_rec.program_application_id)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_LAST_UPDATE_LOGIN;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_application_id,p_old_FNA_rec.program_application_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PROGRAM_APPLICATION;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_id,p_old_FNA_rec.program_id)

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PROGRAM_APPLICATION;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_id,p_old_FNA_rec.program_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PROGRAM;
180: END IF;

Line 182: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_update_date,p_old_FNA_rec.program_update_date)

178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PROGRAM;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_update_date,p_old_FNA_rec.program_update_date)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;

Line 188: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,p_old_FNA_rec.pte_sourcesystem_fnarea_id)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,p_old_FNA_rec.pte_sourcesystem_fnarea_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PTE_SOURCESYSTEM_FNAREA;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,p_old_FNA_rec.pte_source_system_id)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PTE_SOURCESYSTEM_FNAREA;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,p_old_FNA_rec.pte_source_system_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PTE_SOURCE_SYSTEM;
198: END IF;

Line 200: IF NOT QP_GLOBALS.Equal(p_FNA_rec.request_id,p_old_FNA_rec.request_id)

196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_PTE_SOURCE_SYSTEM;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_FNA_rec.request_id,p_old_FNA_rec.request_id)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_REQUEST;
204: END IF;

Line 206: IF NOT QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,p_old_FNA_rec.seeded_flag)

202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_REQUEST;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,p_old_FNA_rec.seeded_flag)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_FNA_UTIL.G_SEEDED;
210: END IF;

Line 323: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute1,p_old_FNA_rec.attribute1)

319: -- Load out record
320:
321: x_FNA_rec := p_FNA_rec;
322:
323: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute1,p_old_FNA_rec.attribute1)
324: THEN
325: NULL;
326: END IF;
327:

Line 328: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute10,p_old_FNA_rec.attribute10)

324: THEN
325: NULL;
326: END IF;
327:
328: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute10,p_old_FNA_rec.attribute10)
329: THEN
330: NULL;
331: END IF;
332:

Line 333: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute11,p_old_FNA_rec.attribute11)

329: THEN
330: NULL;
331: END IF;
332:
333: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute11,p_old_FNA_rec.attribute11)
334: THEN
335: NULL;
336: END IF;
337:

Line 338: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute12,p_old_FNA_rec.attribute12)

334: THEN
335: NULL;
336: END IF;
337:
338: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute12,p_old_FNA_rec.attribute12)
339: THEN
340: NULL;
341: END IF;
342:

Line 343: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute13,p_old_FNA_rec.attribute13)

339: THEN
340: NULL;
341: END IF;
342:
343: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute13,p_old_FNA_rec.attribute13)
344: THEN
345: NULL;
346: END IF;
347:

Line 348: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute14,p_old_FNA_rec.attribute14)

344: THEN
345: NULL;
346: END IF;
347:
348: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute14,p_old_FNA_rec.attribute14)
349: THEN
350: NULL;
351: END IF;
352:

Line 353: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute15,p_old_FNA_rec.attribute15)

349: THEN
350: NULL;
351: END IF;
352:
353: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute15,p_old_FNA_rec.attribute15)
354: THEN
355: NULL;
356: END IF;
357:

Line 358: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute2,p_old_FNA_rec.attribute2)

354: THEN
355: NULL;
356: END IF;
357:
358: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute2,p_old_FNA_rec.attribute2)
359: THEN
360: NULL;
361: END IF;
362:

Line 363: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute3,p_old_FNA_rec.attribute3)

359: THEN
360: NULL;
361: END IF;
362:
363: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute3,p_old_FNA_rec.attribute3)
364: THEN
365: NULL;
366: END IF;
367:

Line 368: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute4,p_old_FNA_rec.attribute4)

364: THEN
365: NULL;
366: END IF;
367:
368: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute4,p_old_FNA_rec.attribute4)
369: THEN
370: NULL;
371: END IF;
372:

Line 373: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute5,p_old_FNA_rec.attribute5)

369: THEN
370: NULL;
371: END IF;
372:
373: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute5,p_old_FNA_rec.attribute5)
374: THEN
375: NULL;
376: END IF;
377:

Line 378: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute6,p_old_FNA_rec.attribute6)

374: THEN
375: NULL;
376: END IF;
377:
378: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute6,p_old_FNA_rec.attribute6)
379: THEN
380: NULL;
381: END IF;
382:

Line 383: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute7,p_old_FNA_rec.attribute7)

379: THEN
380: NULL;
381: END IF;
382:
383: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute7,p_old_FNA_rec.attribute7)
384: THEN
385: NULL;
386: END IF;
387:

Line 388: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute8,p_old_FNA_rec.attribute8)

384: THEN
385: NULL;
386: END IF;
387:
388: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute8,p_old_FNA_rec.attribute8)
389: THEN
390: NULL;
391: END IF;
392:

Line 393: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute9,p_old_FNA_rec.attribute9)

389: THEN
390: NULL;
391: END IF;
392:
393: IF NOT QP_GLOBALS.Equal(p_FNA_rec.attribute9,p_old_FNA_rec.attribute9)
394: THEN
395: NULL;
396: END IF;
397:

Line 398: IF NOT QP_GLOBALS.Equal(p_FNA_rec.context,p_old_FNA_rec.context)

394: THEN
395: NULL;
396: END IF;
397:
398: IF NOT QP_GLOBALS.Equal(p_FNA_rec.context,p_old_FNA_rec.context)
399: THEN
400: NULL;
401: END IF;
402:

Line 403: IF NOT QP_GLOBALS.Equal(p_FNA_rec.created_by,p_old_FNA_rec.created_by)

399: THEN
400: NULL;
401: END IF;
402:
403: IF NOT QP_GLOBALS.Equal(p_FNA_rec.created_by,p_old_FNA_rec.created_by)
404: THEN
405: NULL;
406: END IF;
407:

Line 408: IF NOT QP_GLOBALS.Equal(p_FNA_rec.creation_date,p_old_FNA_rec.creation_date)

404: THEN
405: NULL;
406: END IF;
407:
408: IF NOT QP_GLOBALS.Equal(p_FNA_rec.creation_date,p_old_FNA_rec.creation_date)
409: THEN
410: NULL;
411: END IF;
412:

Line 413: IF NOT QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,p_old_FNA_rec.enabled_flag)

409: THEN
410: NULL;
411: END IF;
412:
413: IF NOT QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,p_old_FNA_rec.enabled_flag)
414: THEN
415: -- If enabled flag has been changed from 'Y', log DR to check for enabled
416: -- functional area mappings
417:

Line 420: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,

416: -- functional area mappings
417:
418: IF p_old_FNA_rec.enabled_flag = 'Y' THEN
419: qp_delayed_requests_PVT.log_request(
420: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
421: p_entity_id => p_FNA_rec.pte_source_system_id,
422: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,
423: p_requesting_entity_id => p_FNA_rec.pte_source_system_id,
424: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,

Line 422: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,

418: IF p_old_FNA_rec.enabled_flag = 'Y' THEN
419: qp_delayed_requests_PVT.log_request(
420: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
421: p_entity_id => p_FNA_rec.pte_source_system_id,
422: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,
423: p_requesting_entity_id => p_FNA_rec.pte_source_system_id,
424: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,
425: x_return_status => l_dummy_ret_status);
426:

Line 424: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,

420: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
421: p_entity_id => p_FNA_rec.pte_source_system_id,
422: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,
423: p_requesting_entity_id => p_FNA_rec.pte_source_system_id,
424: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,
425: x_return_status => l_dummy_ret_status);
426:
427: IF p_called_from_ui = 'N' THEN
428: Warn_Disable_Delete_Fna

Line 439: IF NOT QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,p_old_FNA_rec.functional_area_id)

435:
436: END IF;
437: END IF;
438:
439: IF NOT QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,p_old_FNA_rec.functional_area_id)
440: THEN
441: NULL;
442: END IF;
443:

Line 444: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,p_old_FNA_rec.last_updated_by)

440: THEN
441: NULL;
442: END IF;
443:
444: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,p_old_FNA_rec.last_updated_by)
445: THEN
446: NULL;
447: END IF;
448:

Line 449: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_date,p_old_FNA_rec.last_update_date)

445: THEN
446: NULL;
447: END IF;
448:
449: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_date,p_old_FNA_rec.last_update_date)
450: THEN
451: NULL;
452: END IF;
453:

Line 454: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_login,p_old_FNA_rec.last_update_login)

450: THEN
451: NULL;
452: END IF;
453:
454: IF NOT QP_GLOBALS.Equal(p_FNA_rec.last_update_login,p_old_FNA_rec.last_update_login)
455: THEN
456: NULL;
457: END IF;
458:

Line 459: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_application_id,p_old_FNA_rec.program_application_id)

455: THEN
456: NULL;
457: END IF;
458:
459: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_application_id,p_old_FNA_rec.program_application_id)
460: THEN
461: NULL;
462: END IF;
463:

Line 464: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_id,p_old_FNA_rec.program_id)

460: THEN
461: NULL;
462: END IF;
463:
464: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_id,p_old_FNA_rec.program_id)
465: THEN
466: NULL;
467: END IF;
468:

Line 469: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_update_date,p_old_FNA_rec.program_update_date)

465: THEN
466: NULL;
467: END IF;
468:
469: IF NOT QP_GLOBALS.Equal(p_FNA_rec.program_update_date,p_old_FNA_rec.program_update_date)
470: THEN
471: NULL;
472: END IF;
473:

Line 474: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,p_old_FNA_rec.pte_sourcesystem_fnarea_id)

470: THEN
471: NULL;
472: END IF;
473:
474: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,p_old_FNA_rec.pte_sourcesystem_fnarea_id)
475: THEN
476: NULL;
477: END IF;
478:

Line 479: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,p_old_FNA_rec.pte_source_system_id)

475: THEN
476: NULL;
477: END IF;
478:
479: IF NOT QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,p_old_FNA_rec.pte_source_system_id)
480: THEN
481: NULL;
482: END IF;
483:

Line 484: IF NOT QP_GLOBALS.Equal(p_FNA_rec.request_id,p_old_FNA_rec.request_id)

480: THEN
481: NULL;
482: END IF;
483:
484: IF NOT QP_GLOBALS.Equal(p_FNA_rec.request_id,p_old_FNA_rec.request_id)
485: THEN
486: NULL;
487: END IF;
488:

Line 489: IF NOT QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,p_old_FNA_rec.seeded_flag)

485: THEN
486: NULL;
487: END IF;
488:
489: IF NOT QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,p_old_FNA_rec.seeded_flag)
490: THEN
491: NULL;
492: END IF;
493:

Line 1181: IF QP_GLOBALS.Equal(p_FNA_rec.attribute1,

1177: FOR UPDATE NOWAIT;
1178:
1179: -- Row locked. Compare IN attributes to DB attributes.
1180:
1181: IF QP_GLOBALS.Equal(p_FNA_rec.attribute1,
1182: l_FNA_rec.attribute1)
1183: AND QP_GLOBALS.Equal(p_FNA_rec.attribute10,
1184: l_FNA_rec.attribute10)
1185: AND QP_GLOBALS.Equal(p_FNA_rec.attribute11,

Line 1183: AND QP_GLOBALS.Equal(p_FNA_rec.attribute10,

1179: -- Row locked. Compare IN attributes to DB attributes.
1180:
1181: IF QP_GLOBALS.Equal(p_FNA_rec.attribute1,
1182: l_FNA_rec.attribute1)
1183: AND QP_GLOBALS.Equal(p_FNA_rec.attribute10,
1184: l_FNA_rec.attribute10)
1185: AND QP_GLOBALS.Equal(p_FNA_rec.attribute11,
1186: l_FNA_rec.attribute11)
1187: AND QP_GLOBALS.Equal(p_FNA_rec.attribute12,

Line 1185: AND QP_GLOBALS.Equal(p_FNA_rec.attribute11,

1181: IF QP_GLOBALS.Equal(p_FNA_rec.attribute1,
1182: l_FNA_rec.attribute1)
1183: AND QP_GLOBALS.Equal(p_FNA_rec.attribute10,
1184: l_FNA_rec.attribute10)
1185: AND QP_GLOBALS.Equal(p_FNA_rec.attribute11,
1186: l_FNA_rec.attribute11)
1187: AND QP_GLOBALS.Equal(p_FNA_rec.attribute12,
1188: l_FNA_rec.attribute12)
1189: AND QP_GLOBALS.Equal(p_FNA_rec.attribute13,

Line 1187: AND QP_GLOBALS.Equal(p_FNA_rec.attribute12,

1183: AND QP_GLOBALS.Equal(p_FNA_rec.attribute10,
1184: l_FNA_rec.attribute10)
1185: AND QP_GLOBALS.Equal(p_FNA_rec.attribute11,
1186: l_FNA_rec.attribute11)
1187: AND QP_GLOBALS.Equal(p_FNA_rec.attribute12,
1188: l_FNA_rec.attribute12)
1189: AND QP_GLOBALS.Equal(p_FNA_rec.attribute13,
1190: l_FNA_rec.attribute13)
1191: AND QP_GLOBALS.Equal(p_FNA_rec.attribute14,

Line 1189: AND QP_GLOBALS.Equal(p_FNA_rec.attribute13,

1185: AND QP_GLOBALS.Equal(p_FNA_rec.attribute11,
1186: l_FNA_rec.attribute11)
1187: AND QP_GLOBALS.Equal(p_FNA_rec.attribute12,
1188: l_FNA_rec.attribute12)
1189: AND QP_GLOBALS.Equal(p_FNA_rec.attribute13,
1190: l_FNA_rec.attribute13)
1191: AND QP_GLOBALS.Equal(p_FNA_rec.attribute14,
1192: l_FNA_rec.attribute14)
1193: AND QP_GLOBALS.Equal(p_FNA_rec.attribute15,

Line 1191: AND QP_GLOBALS.Equal(p_FNA_rec.attribute14,

1187: AND QP_GLOBALS.Equal(p_FNA_rec.attribute12,
1188: l_FNA_rec.attribute12)
1189: AND QP_GLOBALS.Equal(p_FNA_rec.attribute13,
1190: l_FNA_rec.attribute13)
1191: AND QP_GLOBALS.Equal(p_FNA_rec.attribute14,
1192: l_FNA_rec.attribute14)
1193: AND QP_GLOBALS.Equal(p_FNA_rec.attribute15,
1194: l_FNA_rec.attribute15)
1195: AND QP_GLOBALS.Equal(p_FNA_rec.attribute2,

Line 1193: AND QP_GLOBALS.Equal(p_FNA_rec.attribute15,

1189: AND QP_GLOBALS.Equal(p_FNA_rec.attribute13,
1190: l_FNA_rec.attribute13)
1191: AND QP_GLOBALS.Equal(p_FNA_rec.attribute14,
1192: l_FNA_rec.attribute14)
1193: AND QP_GLOBALS.Equal(p_FNA_rec.attribute15,
1194: l_FNA_rec.attribute15)
1195: AND QP_GLOBALS.Equal(p_FNA_rec.attribute2,
1196: l_FNA_rec.attribute2)
1197: AND QP_GLOBALS.Equal(p_FNA_rec.attribute3,

Line 1195: AND QP_GLOBALS.Equal(p_FNA_rec.attribute2,

1191: AND QP_GLOBALS.Equal(p_FNA_rec.attribute14,
1192: l_FNA_rec.attribute14)
1193: AND QP_GLOBALS.Equal(p_FNA_rec.attribute15,
1194: l_FNA_rec.attribute15)
1195: AND QP_GLOBALS.Equal(p_FNA_rec.attribute2,
1196: l_FNA_rec.attribute2)
1197: AND QP_GLOBALS.Equal(p_FNA_rec.attribute3,
1198: l_FNA_rec.attribute3)
1199: AND QP_GLOBALS.Equal(p_FNA_rec.attribute4,

Line 1197: AND QP_GLOBALS.Equal(p_FNA_rec.attribute3,

1193: AND QP_GLOBALS.Equal(p_FNA_rec.attribute15,
1194: l_FNA_rec.attribute15)
1195: AND QP_GLOBALS.Equal(p_FNA_rec.attribute2,
1196: l_FNA_rec.attribute2)
1197: AND QP_GLOBALS.Equal(p_FNA_rec.attribute3,
1198: l_FNA_rec.attribute3)
1199: AND QP_GLOBALS.Equal(p_FNA_rec.attribute4,
1200: l_FNA_rec.attribute4)
1201: AND QP_GLOBALS.Equal(p_FNA_rec.attribute5,

Line 1199: AND QP_GLOBALS.Equal(p_FNA_rec.attribute4,

1195: AND QP_GLOBALS.Equal(p_FNA_rec.attribute2,
1196: l_FNA_rec.attribute2)
1197: AND QP_GLOBALS.Equal(p_FNA_rec.attribute3,
1198: l_FNA_rec.attribute3)
1199: AND QP_GLOBALS.Equal(p_FNA_rec.attribute4,
1200: l_FNA_rec.attribute4)
1201: AND QP_GLOBALS.Equal(p_FNA_rec.attribute5,
1202: l_FNA_rec.attribute5)
1203: AND QP_GLOBALS.Equal(p_FNA_rec.attribute6,

Line 1201: AND QP_GLOBALS.Equal(p_FNA_rec.attribute5,

1197: AND QP_GLOBALS.Equal(p_FNA_rec.attribute3,
1198: l_FNA_rec.attribute3)
1199: AND QP_GLOBALS.Equal(p_FNA_rec.attribute4,
1200: l_FNA_rec.attribute4)
1201: AND QP_GLOBALS.Equal(p_FNA_rec.attribute5,
1202: l_FNA_rec.attribute5)
1203: AND QP_GLOBALS.Equal(p_FNA_rec.attribute6,
1204: l_FNA_rec.attribute6)
1205: AND QP_GLOBALS.Equal(p_FNA_rec.attribute7,

Line 1203: AND QP_GLOBALS.Equal(p_FNA_rec.attribute6,

1199: AND QP_GLOBALS.Equal(p_FNA_rec.attribute4,
1200: l_FNA_rec.attribute4)
1201: AND QP_GLOBALS.Equal(p_FNA_rec.attribute5,
1202: l_FNA_rec.attribute5)
1203: AND QP_GLOBALS.Equal(p_FNA_rec.attribute6,
1204: l_FNA_rec.attribute6)
1205: AND QP_GLOBALS.Equal(p_FNA_rec.attribute7,
1206: l_FNA_rec.attribute7)
1207: AND QP_GLOBALS.Equal(p_FNA_rec.attribute8,

Line 1205: AND QP_GLOBALS.Equal(p_FNA_rec.attribute7,

1201: AND QP_GLOBALS.Equal(p_FNA_rec.attribute5,
1202: l_FNA_rec.attribute5)
1203: AND QP_GLOBALS.Equal(p_FNA_rec.attribute6,
1204: l_FNA_rec.attribute6)
1205: AND QP_GLOBALS.Equal(p_FNA_rec.attribute7,
1206: l_FNA_rec.attribute7)
1207: AND QP_GLOBALS.Equal(p_FNA_rec.attribute8,
1208: l_FNA_rec.attribute8)
1209: AND QP_GLOBALS.Equal(p_FNA_rec.attribute9,

Line 1207: AND QP_GLOBALS.Equal(p_FNA_rec.attribute8,

1203: AND QP_GLOBALS.Equal(p_FNA_rec.attribute6,
1204: l_FNA_rec.attribute6)
1205: AND QP_GLOBALS.Equal(p_FNA_rec.attribute7,
1206: l_FNA_rec.attribute7)
1207: AND QP_GLOBALS.Equal(p_FNA_rec.attribute8,
1208: l_FNA_rec.attribute8)
1209: AND QP_GLOBALS.Equal(p_FNA_rec.attribute9,
1210: l_FNA_rec.attribute9)
1211: AND QP_GLOBALS.Equal(p_FNA_rec.context,

Line 1209: AND QP_GLOBALS.Equal(p_FNA_rec.attribute9,

1205: AND QP_GLOBALS.Equal(p_FNA_rec.attribute7,
1206: l_FNA_rec.attribute7)
1207: AND QP_GLOBALS.Equal(p_FNA_rec.attribute8,
1208: l_FNA_rec.attribute8)
1209: AND QP_GLOBALS.Equal(p_FNA_rec.attribute9,
1210: l_FNA_rec.attribute9)
1211: AND QP_GLOBALS.Equal(p_FNA_rec.context,
1212: l_FNA_rec.context)
1213: AND QP_GLOBALS.Equal(p_FNA_rec.created_by,

Line 1211: AND QP_GLOBALS.Equal(p_FNA_rec.context,

1207: AND QP_GLOBALS.Equal(p_FNA_rec.attribute8,
1208: l_FNA_rec.attribute8)
1209: AND QP_GLOBALS.Equal(p_FNA_rec.attribute9,
1210: l_FNA_rec.attribute9)
1211: AND QP_GLOBALS.Equal(p_FNA_rec.context,
1212: l_FNA_rec.context)
1213: AND QP_GLOBALS.Equal(p_FNA_rec.created_by,
1214: l_FNA_rec.created_by)
1215: AND QP_GLOBALS.Equal(p_FNA_rec.creation_date,

Line 1213: AND QP_GLOBALS.Equal(p_FNA_rec.created_by,

1209: AND QP_GLOBALS.Equal(p_FNA_rec.attribute9,
1210: l_FNA_rec.attribute9)
1211: AND QP_GLOBALS.Equal(p_FNA_rec.context,
1212: l_FNA_rec.context)
1213: AND QP_GLOBALS.Equal(p_FNA_rec.created_by,
1214: l_FNA_rec.created_by)
1215: AND QP_GLOBALS.Equal(p_FNA_rec.creation_date,
1216: l_FNA_rec.creation_date)
1217: AND QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,

Line 1215: AND QP_GLOBALS.Equal(p_FNA_rec.creation_date,

1211: AND QP_GLOBALS.Equal(p_FNA_rec.context,
1212: l_FNA_rec.context)
1213: AND QP_GLOBALS.Equal(p_FNA_rec.created_by,
1214: l_FNA_rec.created_by)
1215: AND QP_GLOBALS.Equal(p_FNA_rec.creation_date,
1216: l_FNA_rec.creation_date)
1217: AND QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,
1218: l_FNA_rec.enabled_flag)
1219: AND QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,

Line 1217: AND QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,

1213: AND QP_GLOBALS.Equal(p_FNA_rec.created_by,
1214: l_FNA_rec.created_by)
1215: AND QP_GLOBALS.Equal(p_FNA_rec.creation_date,
1216: l_FNA_rec.creation_date)
1217: AND QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,
1218: l_FNA_rec.enabled_flag)
1219: AND QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,
1220: l_FNA_rec.functional_area_id)
1221: AND QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,

Line 1219: AND QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,

1215: AND QP_GLOBALS.Equal(p_FNA_rec.creation_date,
1216: l_FNA_rec.creation_date)
1217: AND QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,
1218: l_FNA_rec.enabled_flag)
1219: AND QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,
1220: l_FNA_rec.functional_area_id)
1221: AND QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,
1222: l_FNA_rec.last_updated_by)
1223: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_date,

Line 1221: AND QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,

1217: AND QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,
1218: l_FNA_rec.enabled_flag)
1219: AND QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,
1220: l_FNA_rec.functional_area_id)
1221: AND QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,
1222: l_FNA_rec.last_updated_by)
1223: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_date,
1224: l_FNA_rec.last_update_date)
1225: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_login,

Line 1223: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_date,

1219: AND QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,
1220: l_FNA_rec.functional_area_id)
1221: AND QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,
1222: l_FNA_rec.last_updated_by)
1223: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_date,
1224: l_FNA_rec.last_update_date)
1225: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_login,
1226: l_FNA_rec.last_update_login)
1227: AND QP_GLOBALS.Equal(p_FNA_rec.program_application_id,

Line 1225: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_login,

1221: AND QP_GLOBALS.Equal(p_FNA_rec.last_updated_by,
1222: l_FNA_rec.last_updated_by)
1223: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_date,
1224: l_FNA_rec.last_update_date)
1225: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_login,
1226: l_FNA_rec.last_update_login)
1227: AND QP_GLOBALS.Equal(p_FNA_rec.program_application_id,
1228: l_FNA_rec.program_application_id)
1229: AND QP_GLOBALS.Equal(p_FNA_rec.program_id,

Line 1227: AND QP_GLOBALS.Equal(p_FNA_rec.program_application_id,

1223: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_date,
1224: l_FNA_rec.last_update_date)
1225: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_login,
1226: l_FNA_rec.last_update_login)
1227: AND QP_GLOBALS.Equal(p_FNA_rec.program_application_id,
1228: l_FNA_rec.program_application_id)
1229: AND QP_GLOBALS.Equal(p_FNA_rec.program_id,
1230: l_FNA_rec.program_id)
1231: AND QP_GLOBALS.Equal(p_FNA_rec.program_update_date,

Line 1229: AND QP_GLOBALS.Equal(p_FNA_rec.program_id,

1225: AND QP_GLOBALS.Equal(p_FNA_rec.last_update_login,
1226: l_FNA_rec.last_update_login)
1227: AND QP_GLOBALS.Equal(p_FNA_rec.program_application_id,
1228: l_FNA_rec.program_application_id)
1229: AND QP_GLOBALS.Equal(p_FNA_rec.program_id,
1230: l_FNA_rec.program_id)
1231: AND QP_GLOBALS.Equal(p_FNA_rec.program_update_date,
1232: l_FNA_rec.program_update_date)
1233: AND QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,

Line 1231: AND QP_GLOBALS.Equal(p_FNA_rec.program_update_date,

1227: AND QP_GLOBALS.Equal(p_FNA_rec.program_application_id,
1228: l_FNA_rec.program_application_id)
1229: AND QP_GLOBALS.Equal(p_FNA_rec.program_id,
1230: l_FNA_rec.program_id)
1231: AND QP_GLOBALS.Equal(p_FNA_rec.program_update_date,
1232: l_FNA_rec.program_update_date)
1233: AND QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,
1234: l_FNA_rec.pte_sourcesystem_fnarea_id)
1235: AND QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,

Line 1233: AND QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,

1229: AND QP_GLOBALS.Equal(p_FNA_rec.program_id,
1230: l_FNA_rec.program_id)
1231: AND QP_GLOBALS.Equal(p_FNA_rec.program_update_date,
1232: l_FNA_rec.program_update_date)
1233: AND QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,
1234: l_FNA_rec.pte_sourcesystem_fnarea_id)
1235: AND QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,
1236: l_FNA_rec.pte_source_system_id)
1237: AND QP_GLOBALS.Equal(p_FNA_rec.request_id,

Line 1235: AND QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,

1231: AND QP_GLOBALS.Equal(p_FNA_rec.program_update_date,
1232: l_FNA_rec.program_update_date)
1233: AND QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,
1234: l_FNA_rec.pte_sourcesystem_fnarea_id)
1235: AND QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,
1236: l_FNA_rec.pte_source_system_id)
1237: AND QP_GLOBALS.Equal(p_FNA_rec.request_id,
1238: l_FNA_rec.request_id)
1239: AND QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,

Line 1237: AND QP_GLOBALS.Equal(p_FNA_rec.request_id,

1233: AND QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,
1234: l_FNA_rec.pte_sourcesystem_fnarea_id)
1235: AND QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,
1236: l_FNA_rec.pte_source_system_id)
1237: AND QP_GLOBALS.Equal(p_FNA_rec.request_id,
1238: l_FNA_rec.request_id)
1239: AND QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,
1240: l_FNA_rec.seeded_flag)
1241: THEN

Line 1239: AND QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,

1235: AND QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,
1236: l_FNA_rec.pte_source_system_id)
1237: AND QP_GLOBALS.Equal(p_FNA_rec.request_id,
1238: l_FNA_rec.request_id)
1239: AND QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,
1240: l_FNA_rec.seeded_flag)
1241: THEN
1242:
1243: -- Row has not changed. Set out parameter.

Line 1323: NOT QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,

1319: BEGIN
1320:
1321: IF p_FNA_rec.enabled_flag IS NOT NULL AND
1322: p_FNA_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1323: NOT QP_GLOBALS.Equal(p_FNA_rec.enabled_flag,
1324: p_old_FNA_rec.enabled_flag)
1325: THEN
1326: l_FNA_val_rec.enabled := QP_Id_To_Value.Enabled
1327: ( p_enabled_flag => p_FNA_rec.enabled_flag

Line 1333: NOT QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,

1329: END IF;
1330:
1331: IF p_FNA_rec.functional_area_id IS NOT NULL AND
1332: p_FNA_rec.functional_area_id <> FND_API.G_MISS_NUM AND
1333: NOT QP_GLOBALS.Equal(p_FNA_rec.functional_area_id,
1334: p_old_FNA_rec.functional_area_id)
1335: THEN
1336: l_FNA_val_rec.functional_area := QP_Id_To_Value.Functional_Area
1337: ( p_functional_area_id => p_FNA_rec.functional_area_id

Line 1343: NOT QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,

1339: END IF;
1340:
1341: IF p_FNA_rec.pte_sourcesystem_fnarea_id IS NOT NULL AND
1342: p_FNA_rec.pte_sourcesystem_fnarea_id <> FND_API.G_MISS_NUM AND
1343: NOT QP_GLOBALS.Equal(p_FNA_rec.pte_sourcesystem_fnarea_id,
1344: p_old_FNA_rec.pte_sourcesystem_fnarea_id)
1345: THEN
1346: -- We comment this code out because we have a pte_sourcesystem_fnarea_id,
1347: -- but there is no corresponding value. The code changes the value from

Line 1360: NOT QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,

1356:
1357:
1358: IF p_FNA_rec.pte_source_system_id IS NOT NULL AND
1359: p_FNA_rec.pte_source_system_id <> FND_API.G_MISS_NUM AND
1360: NOT QP_GLOBALS.Equal(p_FNA_rec.pte_source_system_id,
1361: p_old_FNA_rec.pte_source_system_id)
1362: THEN
1363: l_FNA_val_rec.pte_source_system := QP_Id_To_Value.Pte_Source_System
1364: ( p_pte_source_system_id => p_FNA_rec.pte_source_system_id

Line 1371: NOT QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,

1367:
1368:
1369: IF p_FNA_rec.seeded_flag IS NOT NULL AND
1370: p_FNA_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1371: NOT QP_GLOBALS.Equal(p_FNA_rec.seeded_flag,
1372: p_old_FNA_rec.seeded_flag)
1373: THEN
1374: l_FNA_val_rec.seeded := QP_Id_To_Value.Seeded
1375: ( p_seeded_flag => p_FNA_rec.seeded_flag