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_SSC_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_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_SSC_rec.application_short_name,p_old_SSC_rec.application_short_name)

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_SSC_rec.application_short_name,p_old_SSC_rec.application_short_name)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_APPLICATION_SHORT_NAME;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute1,p_old_SSC_rec.attribute1)

34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_APPLICATION_SHORT_NAME;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute1,p_old_SSC_rec.attribute1)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;
42: END IF;

Line 44: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute10,p_old_SSC_rec.attribute10)

40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE1;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute10,p_old_SSC_rec.attribute10)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;
48: END IF;

Line 50: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute11,p_old_SSC_rec.attribute11)

46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE10;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute11,p_old_SSC_rec.attribute11)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;
54: END IF;

Line 56: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute12,p_old_SSC_rec.attribute12)

52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE11;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute12,p_old_SSC_rec.attribute12)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;
60: END IF;

Line 62: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute13,p_old_SSC_rec.attribute13)

58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE12;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute13,p_old_SSC_rec.attribute13)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;
66: END IF;

Line 68: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute14,p_old_SSC_rec.attribute14)

64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE13;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute14,p_old_SSC_rec.attribute14)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;
72: END IF;

Line 74: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute15,p_old_SSC_rec.attribute15)

70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE14;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute15,p_old_SSC_rec.attribute15)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;
78: END IF;

Line 80: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute2,p_old_SSC_rec.attribute2)

76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE15;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute2,p_old_SSC_rec.attribute2)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;
84: END IF;

Line 86: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute3,p_old_SSC_rec.attribute3)

82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE2;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute3,p_old_SSC_rec.attribute3)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;
90: END IF;

Line 92: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute4,p_old_SSC_rec.attribute4)

88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE3;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute4,p_old_SSC_rec.attribute4)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;
96: END IF;

Line 98: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute5,p_old_SSC_rec.attribute5)

94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE4;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute5,p_old_SSC_rec.attribute5)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;
102: END IF;

Line 104: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute6,p_old_SSC_rec.attribute6)

100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE5;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute6,p_old_SSC_rec.attribute6)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;
108: END IF;

Line 110: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute7,p_old_SSC_rec.attribute7)

106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE6;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute7,p_old_SSC_rec.attribute7)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;
114: END IF;

Line 116: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute8,p_old_SSC_rec.attribute8)

112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE7;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute8,p_old_SSC_rec.attribute8)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;
120: END IF;

Line 122: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute9,p_old_SSC_rec.attribute9)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE8;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute9,p_old_SSC_rec.attribute9)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_SSC_rec.context,p_old_SSC_rec.context)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ATTRIBUTE9;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_SSC_rec.context,p_old_SSC_rec.context)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_SSC_rec.created_by,p_old_SSC_rec.created_by)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CONTEXT;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_SSC_rec.created_by,p_old_SSC_rec.created_by)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_SSC_rec.creation_date,p_old_SSC_rec.creation_date)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATED_BY;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_SSC_rec.creation_date,p_old_SSC_rec.creation_date)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,p_old_SSC_rec.enabled_flag)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_CREATION_DATE;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,p_old_SSC_rec.enabled_flag)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,p_old_SSC_rec.last_updated_by)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_ENABLED;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,p_old_SSC_rec.last_updated_by)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_LAST_UPDATED_BY;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_date,p_old_SSC_rec.last_update_date)

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

Line 164: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_login,p_old_SSC_rec.last_update_login)

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

Line 170: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_application_id,p_old_SSC_rec.program_application_id)

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

Line 176: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_id,p_old_SSC_rec.program_id)

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

Line 182: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_update_date,p_old_SSC_rec.program_update_date)

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

Line 188: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,p_old_SSC_rec.pte_code)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,p_old_SSC_rec.pte_code)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,p_old_SSC_rec.pte_source_system_id)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,p_old_SSC_rec.pte_source_system_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_SSC_UTIL.G_PTE_SOURCE_SYSTEM;
198: END IF;

Line 303: IF NOT QP_GLOBALS.Equal(p_SSC_rec.application_short_name,p_old_SSC_rec.application_short_name)

299: -- Load out record
300:
301: x_SSC_rec := p_SSC_rec;
302:
303: IF NOT QP_GLOBALS.Equal(p_SSC_rec.application_short_name,p_old_SSC_rec.application_short_name)
304: THEN
305: NULL;
306: END IF;
307:

Line 308: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute1,p_old_SSC_rec.attribute1)

304: THEN
305: NULL;
306: END IF;
307:
308: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute1,p_old_SSC_rec.attribute1)
309: THEN
310: NULL;
311: END IF;
312:

Line 313: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute10,p_old_SSC_rec.attribute10)

309: THEN
310: NULL;
311: END IF;
312:
313: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute10,p_old_SSC_rec.attribute10)
314: THEN
315: NULL;
316: END IF;
317:

Line 318: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute11,p_old_SSC_rec.attribute11)

314: THEN
315: NULL;
316: END IF;
317:
318: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute11,p_old_SSC_rec.attribute11)
319: THEN
320: NULL;
321: END IF;
322:

Line 323: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute12,p_old_SSC_rec.attribute12)

319: THEN
320: NULL;
321: END IF;
322:
323: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute12,p_old_SSC_rec.attribute12)
324: THEN
325: NULL;
326: END IF;
327:

Line 328: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute13,p_old_SSC_rec.attribute13)

324: THEN
325: NULL;
326: END IF;
327:
328: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute13,p_old_SSC_rec.attribute13)
329: THEN
330: NULL;
331: END IF;
332:

Line 333: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute14,p_old_SSC_rec.attribute14)

329: THEN
330: NULL;
331: END IF;
332:
333: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute14,p_old_SSC_rec.attribute14)
334: THEN
335: NULL;
336: END IF;
337:

Line 338: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute15,p_old_SSC_rec.attribute15)

334: THEN
335: NULL;
336: END IF;
337:
338: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute15,p_old_SSC_rec.attribute15)
339: THEN
340: NULL;
341: END IF;
342:

Line 343: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute2,p_old_SSC_rec.attribute2)

339: THEN
340: NULL;
341: END IF;
342:
343: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute2,p_old_SSC_rec.attribute2)
344: THEN
345: NULL;
346: END IF;
347:

Line 348: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute3,p_old_SSC_rec.attribute3)

344: THEN
345: NULL;
346: END IF;
347:
348: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute3,p_old_SSC_rec.attribute3)
349: THEN
350: NULL;
351: END IF;
352:

Line 353: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute4,p_old_SSC_rec.attribute4)

349: THEN
350: NULL;
351: END IF;
352:
353: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute4,p_old_SSC_rec.attribute4)
354: THEN
355: NULL;
356: END IF;
357:

Line 358: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute5,p_old_SSC_rec.attribute5)

354: THEN
355: NULL;
356: END IF;
357:
358: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute5,p_old_SSC_rec.attribute5)
359: THEN
360: NULL;
361: END IF;
362:

Line 363: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute6,p_old_SSC_rec.attribute6)

359: THEN
360: NULL;
361: END IF;
362:
363: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute6,p_old_SSC_rec.attribute6)
364: THEN
365: NULL;
366: END IF;
367:

Line 368: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute7,p_old_SSC_rec.attribute7)

364: THEN
365: NULL;
366: END IF;
367:
368: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute7,p_old_SSC_rec.attribute7)
369: THEN
370: NULL;
371: END IF;
372:

Line 373: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute8,p_old_SSC_rec.attribute8)

369: THEN
370: NULL;
371: END IF;
372:
373: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute8,p_old_SSC_rec.attribute8)
374: THEN
375: NULL;
376: END IF;
377:

Line 378: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute9,p_old_SSC_rec.attribute9)

374: THEN
375: NULL;
376: END IF;
377:
378: IF NOT QP_GLOBALS.Equal(p_SSC_rec.attribute9,p_old_SSC_rec.attribute9)
379: THEN
380: NULL;
381: END IF;
382:

Line 383: IF NOT QP_GLOBALS.Equal(p_SSC_rec.context,p_old_SSC_rec.context)

379: THEN
380: NULL;
381: END IF;
382:
383: IF NOT QP_GLOBALS.Equal(p_SSC_rec.context,p_old_SSC_rec.context)
384: THEN
385: NULL;
386: END IF;
387:

Line 388: IF NOT QP_GLOBALS.Equal(p_SSC_rec.created_by,p_old_SSC_rec.created_by)

384: THEN
385: NULL;
386: END IF;
387:
388: IF NOT QP_GLOBALS.Equal(p_SSC_rec.created_by,p_old_SSC_rec.created_by)
389: THEN
390: NULL;
391: END IF;
392:

Line 393: IF NOT QP_GLOBALS.Equal(p_SSC_rec.creation_date,p_old_SSC_rec.creation_date)

389: THEN
390: NULL;
391: END IF;
392:
393: IF NOT QP_GLOBALS.Equal(p_SSC_rec.creation_date,p_old_SSC_rec.creation_date)
394: THEN
395: NULL;
396: END IF;
397:

Line 398: IF NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,p_old_SSC_rec.enabled_flag)

394: THEN
395: NULL;
396: END IF;
397:
398: IF NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,p_old_SSC_rec.enabled_flag)
399: THEN
400: NULL;
401: END IF;
402:

Line 403: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,p_old_SSC_rec.last_updated_by)

399: THEN
400: NULL;
401: END IF;
402:
403: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,p_old_SSC_rec.last_updated_by)
404: THEN
405: NULL;
406: END IF;
407:

Line 408: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_date,p_old_SSC_rec.last_update_date)

404: THEN
405: NULL;
406: END IF;
407:
408: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_date,p_old_SSC_rec.last_update_date)
409: THEN
410: NULL;
411: END IF;
412:

Line 413: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_login,p_old_SSC_rec.last_update_login)

409: THEN
410: NULL;
411: END IF;
412:
413: IF NOT QP_GLOBALS.Equal(p_SSC_rec.last_update_login,p_old_SSC_rec.last_update_login)
414: THEN
415: NULL;
416: END IF;
417:

Line 418: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_application_id,p_old_SSC_rec.program_application_id)

414: THEN
415: NULL;
416: END IF;
417:
418: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_application_id,p_old_SSC_rec.program_application_id)
419: THEN
420: NULL;
421: END IF;
422:

Line 423: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_id,p_old_SSC_rec.program_id)

419: THEN
420: NULL;
421: END IF;
422:
423: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_id,p_old_SSC_rec.program_id)
424: THEN
425: NULL;
426: END IF;
427:

Line 428: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_update_date,p_old_SSC_rec.program_update_date)

424: THEN
425: NULL;
426: END IF;
427:
428: IF NOT QP_GLOBALS.Equal(p_SSC_rec.program_update_date,p_old_SSC_rec.program_update_date)
429: THEN
430: NULL;
431: END IF;
432:

Line 433: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,p_old_SSC_rec.pte_code)

429: THEN
430: NULL;
431: END IF;
432:
433: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,p_old_SSC_rec.pte_code)
434: THEN
435: NULL;
436: END IF;
437:

Line 438: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,p_old_SSC_rec.pte_source_system_id)

434: THEN
435: NULL;
436: END IF;
437:
438: IF NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,p_old_SSC_rec.pte_source_system_id)
439: THEN
440: NULL;
441: END IF;
442:

Line 1103: IF QP_GLOBALS.Equal(p_SSC_rec.application_short_name,

1099: FOR UPDATE NOWAIT;
1100:
1101: -- Row locked. Compare IN attributes to DB attributes.
1102:
1103: IF QP_GLOBALS.Equal(p_SSC_rec.application_short_name,
1104: l_SSC_rec.application_short_name)
1105: AND QP_GLOBALS.Equal(p_SSC_rec.attribute1,
1106: l_SSC_rec.attribute1)
1107: AND QP_GLOBALS.Equal(p_SSC_rec.attribute10,

Line 1105: AND QP_GLOBALS.Equal(p_SSC_rec.attribute1,

1101: -- Row locked. Compare IN attributes to DB attributes.
1102:
1103: IF QP_GLOBALS.Equal(p_SSC_rec.application_short_name,
1104: l_SSC_rec.application_short_name)
1105: AND QP_GLOBALS.Equal(p_SSC_rec.attribute1,
1106: l_SSC_rec.attribute1)
1107: AND QP_GLOBALS.Equal(p_SSC_rec.attribute10,
1108: l_SSC_rec.attribute10)
1109: AND QP_GLOBALS.Equal(p_SSC_rec.attribute11,

Line 1107: AND QP_GLOBALS.Equal(p_SSC_rec.attribute10,

1103: IF QP_GLOBALS.Equal(p_SSC_rec.application_short_name,
1104: l_SSC_rec.application_short_name)
1105: AND QP_GLOBALS.Equal(p_SSC_rec.attribute1,
1106: l_SSC_rec.attribute1)
1107: AND QP_GLOBALS.Equal(p_SSC_rec.attribute10,
1108: l_SSC_rec.attribute10)
1109: AND QP_GLOBALS.Equal(p_SSC_rec.attribute11,
1110: l_SSC_rec.attribute11)
1111: AND QP_GLOBALS.Equal(p_SSC_rec.attribute12,

Line 1109: AND QP_GLOBALS.Equal(p_SSC_rec.attribute11,

1105: AND QP_GLOBALS.Equal(p_SSC_rec.attribute1,
1106: l_SSC_rec.attribute1)
1107: AND QP_GLOBALS.Equal(p_SSC_rec.attribute10,
1108: l_SSC_rec.attribute10)
1109: AND QP_GLOBALS.Equal(p_SSC_rec.attribute11,
1110: l_SSC_rec.attribute11)
1111: AND QP_GLOBALS.Equal(p_SSC_rec.attribute12,
1112: l_SSC_rec.attribute12)
1113: AND QP_GLOBALS.Equal(p_SSC_rec.attribute13,

Line 1111: AND QP_GLOBALS.Equal(p_SSC_rec.attribute12,

1107: AND QP_GLOBALS.Equal(p_SSC_rec.attribute10,
1108: l_SSC_rec.attribute10)
1109: AND QP_GLOBALS.Equal(p_SSC_rec.attribute11,
1110: l_SSC_rec.attribute11)
1111: AND QP_GLOBALS.Equal(p_SSC_rec.attribute12,
1112: l_SSC_rec.attribute12)
1113: AND QP_GLOBALS.Equal(p_SSC_rec.attribute13,
1114: l_SSC_rec.attribute13)
1115: AND QP_GLOBALS.Equal(p_SSC_rec.attribute14,

Line 1113: AND QP_GLOBALS.Equal(p_SSC_rec.attribute13,

1109: AND QP_GLOBALS.Equal(p_SSC_rec.attribute11,
1110: l_SSC_rec.attribute11)
1111: AND QP_GLOBALS.Equal(p_SSC_rec.attribute12,
1112: l_SSC_rec.attribute12)
1113: AND QP_GLOBALS.Equal(p_SSC_rec.attribute13,
1114: l_SSC_rec.attribute13)
1115: AND QP_GLOBALS.Equal(p_SSC_rec.attribute14,
1116: l_SSC_rec.attribute14)
1117: AND QP_GLOBALS.Equal(p_SSC_rec.attribute15,

Line 1115: AND QP_GLOBALS.Equal(p_SSC_rec.attribute14,

1111: AND QP_GLOBALS.Equal(p_SSC_rec.attribute12,
1112: l_SSC_rec.attribute12)
1113: AND QP_GLOBALS.Equal(p_SSC_rec.attribute13,
1114: l_SSC_rec.attribute13)
1115: AND QP_GLOBALS.Equal(p_SSC_rec.attribute14,
1116: l_SSC_rec.attribute14)
1117: AND QP_GLOBALS.Equal(p_SSC_rec.attribute15,
1118: l_SSC_rec.attribute15)
1119: AND QP_GLOBALS.Equal(p_SSC_rec.attribute2,

Line 1117: AND QP_GLOBALS.Equal(p_SSC_rec.attribute15,

1113: AND QP_GLOBALS.Equal(p_SSC_rec.attribute13,
1114: l_SSC_rec.attribute13)
1115: AND QP_GLOBALS.Equal(p_SSC_rec.attribute14,
1116: l_SSC_rec.attribute14)
1117: AND QP_GLOBALS.Equal(p_SSC_rec.attribute15,
1118: l_SSC_rec.attribute15)
1119: AND QP_GLOBALS.Equal(p_SSC_rec.attribute2,
1120: l_SSC_rec.attribute2)
1121: AND QP_GLOBALS.Equal(p_SSC_rec.attribute3,

Line 1119: AND QP_GLOBALS.Equal(p_SSC_rec.attribute2,

1115: AND QP_GLOBALS.Equal(p_SSC_rec.attribute14,
1116: l_SSC_rec.attribute14)
1117: AND QP_GLOBALS.Equal(p_SSC_rec.attribute15,
1118: l_SSC_rec.attribute15)
1119: AND QP_GLOBALS.Equal(p_SSC_rec.attribute2,
1120: l_SSC_rec.attribute2)
1121: AND QP_GLOBALS.Equal(p_SSC_rec.attribute3,
1122: l_SSC_rec.attribute3)
1123: AND QP_GLOBALS.Equal(p_SSC_rec.attribute4,

Line 1121: AND QP_GLOBALS.Equal(p_SSC_rec.attribute3,

1117: AND QP_GLOBALS.Equal(p_SSC_rec.attribute15,
1118: l_SSC_rec.attribute15)
1119: AND QP_GLOBALS.Equal(p_SSC_rec.attribute2,
1120: l_SSC_rec.attribute2)
1121: AND QP_GLOBALS.Equal(p_SSC_rec.attribute3,
1122: l_SSC_rec.attribute3)
1123: AND QP_GLOBALS.Equal(p_SSC_rec.attribute4,
1124: l_SSC_rec.attribute4)
1125: AND QP_GLOBALS.Equal(p_SSC_rec.attribute5,

Line 1123: AND QP_GLOBALS.Equal(p_SSC_rec.attribute4,

1119: AND QP_GLOBALS.Equal(p_SSC_rec.attribute2,
1120: l_SSC_rec.attribute2)
1121: AND QP_GLOBALS.Equal(p_SSC_rec.attribute3,
1122: l_SSC_rec.attribute3)
1123: AND QP_GLOBALS.Equal(p_SSC_rec.attribute4,
1124: l_SSC_rec.attribute4)
1125: AND QP_GLOBALS.Equal(p_SSC_rec.attribute5,
1126: l_SSC_rec.attribute5)
1127: AND QP_GLOBALS.Equal(p_SSC_rec.attribute6,

Line 1125: AND QP_GLOBALS.Equal(p_SSC_rec.attribute5,

1121: AND QP_GLOBALS.Equal(p_SSC_rec.attribute3,
1122: l_SSC_rec.attribute3)
1123: AND QP_GLOBALS.Equal(p_SSC_rec.attribute4,
1124: l_SSC_rec.attribute4)
1125: AND QP_GLOBALS.Equal(p_SSC_rec.attribute5,
1126: l_SSC_rec.attribute5)
1127: AND QP_GLOBALS.Equal(p_SSC_rec.attribute6,
1128: l_SSC_rec.attribute6)
1129: AND QP_GLOBALS.Equal(p_SSC_rec.attribute7,

Line 1127: AND QP_GLOBALS.Equal(p_SSC_rec.attribute6,

1123: AND QP_GLOBALS.Equal(p_SSC_rec.attribute4,
1124: l_SSC_rec.attribute4)
1125: AND QP_GLOBALS.Equal(p_SSC_rec.attribute5,
1126: l_SSC_rec.attribute5)
1127: AND QP_GLOBALS.Equal(p_SSC_rec.attribute6,
1128: l_SSC_rec.attribute6)
1129: AND QP_GLOBALS.Equal(p_SSC_rec.attribute7,
1130: l_SSC_rec.attribute7)
1131: AND QP_GLOBALS.Equal(p_SSC_rec.attribute8,

Line 1129: AND QP_GLOBALS.Equal(p_SSC_rec.attribute7,

1125: AND QP_GLOBALS.Equal(p_SSC_rec.attribute5,
1126: l_SSC_rec.attribute5)
1127: AND QP_GLOBALS.Equal(p_SSC_rec.attribute6,
1128: l_SSC_rec.attribute6)
1129: AND QP_GLOBALS.Equal(p_SSC_rec.attribute7,
1130: l_SSC_rec.attribute7)
1131: AND QP_GLOBALS.Equal(p_SSC_rec.attribute8,
1132: l_SSC_rec.attribute8)
1133: AND QP_GLOBALS.Equal(p_SSC_rec.attribute9,

Line 1131: AND QP_GLOBALS.Equal(p_SSC_rec.attribute8,

1127: AND QP_GLOBALS.Equal(p_SSC_rec.attribute6,
1128: l_SSC_rec.attribute6)
1129: AND QP_GLOBALS.Equal(p_SSC_rec.attribute7,
1130: l_SSC_rec.attribute7)
1131: AND QP_GLOBALS.Equal(p_SSC_rec.attribute8,
1132: l_SSC_rec.attribute8)
1133: AND QP_GLOBALS.Equal(p_SSC_rec.attribute9,
1134: l_SSC_rec.attribute9)
1135: AND QP_GLOBALS.Equal(p_SSC_rec.context,

Line 1133: AND QP_GLOBALS.Equal(p_SSC_rec.attribute9,

1129: AND QP_GLOBALS.Equal(p_SSC_rec.attribute7,
1130: l_SSC_rec.attribute7)
1131: AND QP_GLOBALS.Equal(p_SSC_rec.attribute8,
1132: l_SSC_rec.attribute8)
1133: AND QP_GLOBALS.Equal(p_SSC_rec.attribute9,
1134: l_SSC_rec.attribute9)
1135: AND QP_GLOBALS.Equal(p_SSC_rec.context,
1136: l_SSC_rec.context)
1137: AND QP_GLOBALS.Equal(p_SSC_rec.created_by,

Line 1135: AND QP_GLOBALS.Equal(p_SSC_rec.context,

1131: AND QP_GLOBALS.Equal(p_SSC_rec.attribute8,
1132: l_SSC_rec.attribute8)
1133: AND QP_GLOBALS.Equal(p_SSC_rec.attribute9,
1134: l_SSC_rec.attribute9)
1135: AND QP_GLOBALS.Equal(p_SSC_rec.context,
1136: l_SSC_rec.context)
1137: AND QP_GLOBALS.Equal(p_SSC_rec.created_by,
1138: l_SSC_rec.created_by)
1139: AND QP_GLOBALS.Equal(p_SSC_rec.creation_date,

Line 1137: AND QP_GLOBALS.Equal(p_SSC_rec.created_by,

1133: AND QP_GLOBALS.Equal(p_SSC_rec.attribute9,
1134: l_SSC_rec.attribute9)
1135: AND QP_GLOBALS.Equal(p_SSC_rec.context,
1136: l_SSC_rec.context)
1137: AND QP_GLOBALS.Equal(p_SSC_rec.created_by,
1138: l_SSC_rec.created_by)
1139: AND QP_GLOBALS.Equal(p_SSC_rec.creation_date,
1140: l_SSC_rec.creation_date)
1141: AND QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,

Line 1139: AND QP_GLOBALS.Equal(p_SSC_rec.creation_date,

1135: AND QP_GLOBALS.Equal(p_SSC_rec.context,
1136: l_SSC_rec.context)
1137: AND QP_GLOBALS.Equal(p_SSC_rec.created_by,
1138: l_SSC_rec.created_by)
1139: AND QP_GLOBALS.Equal(p_SSC_rec.creation_date,
1140: l_SSC_rec.creation_date)
1141: AND QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,
1142: l_SSC_rec.enabled_flag)
1143: AND QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,

Line 1141: AND QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,

1137: AND QP_GLOBALS.Equal(p_SSC_rec.created_by,
1138: l_SSC_rec.created_by)
1139: AND QP_GLOBALS.Equal(p_SSC_rec.creation_date,
1140: l_SSC_rec.creation_date)
1141: AND QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,
1142: l_SSC_rec.enabled_flag)
1143: AND QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,
1144: l_SSC_rec.last_updated_by)
1145: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_date,

Line 1143: AND QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,

1139: AND QP_GLOBALS.Equal(p_SSC_rec.creation_date,
1140: l_SSC_rec.creation_date)
1141: AND QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,
1142: l_SSC_rec.enabled_flag)
1143: AND QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,
1144: l_SSC_rec.last_updated_by)
1145: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_date,
1146: l_SSC_rec.last_update_date)
1147: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_login,

Line 1145: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_date,

1141: AND QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,
1142: l_SSC_rec.enabled_flag)
1143: AND QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,
1144: l_SSC_rec.last_updated_by)
1145: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_date,
1146: l_SSC_rec.last_update_date)
1147: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_login,
1148: l_SSC_rec.last_update_login)
1149: AND QP_GLOBALS.Equal(p_SSC_rec.program_application_id,

Line 1147: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_login,

1143: AND QP_GLOBALS.Equal(p_SSC_rec.last_updated_by,
1144: l_SSC_rec.last_updated_by)
1145: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_date,
1146: l_SSC_rec.last_update_date)
1147: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_login,
1148: l_SSC_rec.last_update_login)
1149: AND QP_GLOBALS.Equal(p_SSC_rec.program_application_id,
1150: l_SSC_rec.program_application_id)
1151: AND QP_GLOBALS.Equal(p_SSC_rec.program_id,

Line 1149: AND QP_GLOBALS.Equal(p_SSC_rec.program_application_id,

1145: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_date,
1146: l_SSC_rec.last_update_date)
1147: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_login,
1148: l_SSC_rec.last_update_login)
1149: AND QP_GLOBALS.Equal(p_SSC_rec.program_application_id,
1150: l_SSC_rec.program_application_id)
1151: AND QP_GLOBALS.Equal(p_SSC_rec.program_id,
1152: l_SSC_rec.program_id)
1153: AND QP_GLOBALS.Equal(p_SSC_rec.program_update_date,

Line 1151: AND QP_GLOBALS.Equal(p_SSC_rec.program_id,

1147: AND QP_GLOBALS.Equal(p_SSC_rec.last_update_login,
1148: l_SSC_rec.last_update_login)
1149: AND QP_GLOBALS.Equal(p_SSC_rec.program_application_id,
1150: l_SSC_rec.program_application_id)
1151: AND QP_GLOBALS.Equal(p_SSC_rec.program_id,
1152: l_SSC_rec.program_id)
1153: AND QP_GLOBALS.Equal(p_SSC_rec.program_update_date,
1154: l_SSC_rec.program_update_date)
1155: AND QP_GLOBALS.Equal(p_SSC_rec.pte_code,

Line 1153: AND QP_GLOBALS.Equal(p_SSC_rec.program_update_date,

1149: AND QP_GLOBALS.Equal(p_SSC_rec.program_application_id,
1150: l_SSC_rec.program_application_id)
1151: AND QP_GLOBALS.Equal(p_SSC_rec.program_id,
1152: l_SSC_rec.program_id)
1153: AND QP_GLOBALS.Equal(p_SSC_rec.program_update_date,
1154: l_SSC_rec.program_update_date)
1155: AND QP_GLOBALS.Equal(p_SSC_rec.pte_code,
1156: l_SSC_rec.pte_code)
1157: AND QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,

Line 1155: AND QP_GLOBALS.Equal(p_SSC_rec.pte_code,

1151: AND QP_GLOBALS.Equal(p_SSC_rec.program_id,
1152: l_SSC_rec.program_id)
1153: AND QP_GLOBALS.Equal(p_SSC_rec.program_update_date,
1154: l_SSC_rec.program_update_date)
1155: AND QP_GLOBALS.Equal(p_SSC_rec.pte_code,
1156: l_SSC_rec.pte_code)
1157: AND QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,
1158: l_SSC_rec.pte_source_system_id)
1159: THEN

Line 1157: AND QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,

1153: AND QP_GLOBALS.Equal(p_SSC_rec.program_update_date,
1154: l_SSC_rec.program_update_date)
1155: AND QP_GLOBALS.Equal(p_SSC_rec.pte_code,
1156: l_SSC_rec.pte_code)
1157: AND QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,
1158: l_SSC_rec.pte_source_system_id)
1159: THEN
1160:
1161: -- Row has not changed. Set out parameter.

Line 1241: NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,

1237: BEGIN
1238:
1239: IF p_SSC_rec.enabled_flag IS NOT NULL AND
1240: p_SSC_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1241: NOT QP_GLOBALS.Equal(p_SSC_rec.enabled_flag,
1242: p_old_SSC_rec.enabled_flag)
1243: THEN
1244: l_SSC_val_rec.enabled := QP_Id_To_Value.Enabled
1245: ( p_enabled_flag => p_SSC_rec.enabled_flag

Line 1251: NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,

1247: END IF;
1248:
1249: IF p_SSC_rec.pte_code IS NOT NULL AND
1250: p_SSC_rec.pte_code <> FND_API.G_MISS_CHAR AND
1251: NOT QP_GLOBALS.Equal(p_SSC_rec.pte_code,
1252: p_old_SSC_rec.pte_code)
1253: THEN
1254: l_SSC_val_rec.pte := QP_Id_To_Value.Pte
1255: ( p_pte_code => p_SSC_rec.pte_code

Line 1261: NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,

1257: END IF;
1258:
1259: IF p_SSC_rec.pte_source_system_id IS NOT NULL AND
1260: p_SSC_rec.pte_source_system_id <> FND_API.G_MISS_NUM AND
1261: NOT QP_GLOBALS.Equal(p_SSC_rec.pte_source_system_id,
1262: p_old_SSC_rec.pte_source_system_id)
1263: THEN
1264: l_SSC_val_rec.pte_source_system := QP_Id_To_Value.Pte_Source_System
1265: ( p_pte_source_system_id => p_SSC_rec.pte_source_system_id