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

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_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 NOCOPY /* file.sql.39 change */ 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 NOCOPY /* file.sql.39 change */ record
24:

Line 32: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,p_old_QUALIFIER_RULES_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_QUALIFIER_RULES_rec.attribute1,p_old_QUALIFIER_RULES_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE1;
36: END IF;

Line 38: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,p_old_QUALIFIER_RULES_rec.attribute10)

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

Line 44: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,p_old_QUALIFIER_RULES_rec.attribute11)

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

Line 50: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,p_old_QUALIFIER_RULES_rec.attribute12)

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

Line 56: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,p_old_QUALIFIER_RULES_rec.attribute13)

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

Line 62: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,p_old_QUALIFIER_RULES_rec.attribute14)

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

Line 68: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,p_old_QUALIFIER_RULES_rec.attribute15)

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

Line 74: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,p_old_QUALIFIER_RULES_rec.attribute2)

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

Line 80: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,p_old_QUALIFIER_RULES_rec.attribute3)

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

Line 86: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,p_old_QUALIFIER_RULES_rec.attribute4)

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

Line 92: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,p_old_QUALIFIER_RULES_rec.attribute5)

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

Line 98: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,p_old_QUALIFIER_RULES_rec.attribute6)

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

Line 104: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,p_old_QUALIFIER_RULES_rec.attribute7)

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

Line 110: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,p_old_QUALIFIER_RULES_rec.attribute8)

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

Line 116: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,p_old_QUALIFIER_RULES_rec.attribute9)

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

Line 122: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,p_old_QUALIFIER_RULES_rec.context)

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

Line 128: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,p_old_QUALIFIER_RULES_rec.created_by)

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

Line 134: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,p_old_QUALIFIER_RULES_rec.creation_date)

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

Line 140: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,p_old_QUALIFIER_RULES_rec.description)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATION_DATE;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,p_old_QUALIFIER_RULES_rec.description)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,p_old_QUALIFIER_RULES_rec.last_updated_by)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,p_old_QUALIFIER_RULES_rec.last_updated_by)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,p_old_QUALIFIER_RULES_rec.last_update_date)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,p_old_QUALIFIER_RULES_rec.last_update_date)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,p_old_QUALIFIER_RULES_rec.last_update_login)

154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,p_old_QUALIFIER_RULES_rec.last_update_login)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;
162: END IF;

Line 164: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,p_old_QUALIFIER_RULES_rec.name)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,p_old_QUALIFIER_RULES_rec.name)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,p_old_QUALIFIER_RULES_rec.program_application_id)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,p_old_QUALIFIER_RULES_rec.program_application_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_APPLICATION;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,p_old_QUALIFIER_RULES_rec.program_id)

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

Line 182: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,p_old_QUALIFIER_RULES_rec.program_update_date)

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

Line 188: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,p_old_QUALIFIER_RULES_rec.qualifier_rule_id)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,p_old_QUALIFIER_RULES_rec.qualifier_rule_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,p_old_QUALIFIER_RULES_rec.request_id)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,p_old_QUALIFIER_RULES_rec.request_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_REQUEST;
198: END IF;

Line 303: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,p_old_QUALIFIER_RULES_rec.attribute1)

299: -- Load out NOCOPY /* file.sql.39 change */ record
300:
301: x_QUALIFIER_RULES_rec := p_QUALIFIER_RULES_rec;
302:
303: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,p_old_QUALIFIER_RULES_rec.attribute1)
304: THEN
305: NULL;
306: END IF;
307:

Line 308: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,p_old_QUALIFIER_RULES_rec.attribute10)

304: THEN
305: NULL;
306: END IF;
307:
308: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,p_old_QUALIFIER_RULES_rec.attribute10)
309: THEN
310: NULL;
311: END IF;
312:

Line 313: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,p_old_QUALIFIER_RULES_rec.attribute11)

309: THEN
310: NULL;
311: END IF;
312:
313: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,p_old_QUALIFIER_RULES_rec.attribute11)
314: THEN
315: NULL;
316: END IF;
317:

Line 318: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,p_old_QUALIFIER_RULES_rec.attribute12)

314: THEN
315: NULL;
316: END IF;
317:
318: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,p_old_QUALIFIER_RULES_rec.attribute12)
319: THEN
320: NULL;
321: END IF;
322:

Line 323: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,p_old_QUALIFIER_RULES_rec.attribute13)

319: THEN
320: NULL;
321: END IF;
322:
323: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,p_old_QUALIFIER_RULES_rec.attribute13)
324: THEN
325: NULL;
326: END IF;
327:

Line 328: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,p_old_QUALIFIER_RULES_rec.attribute14)

324: THEN
325: NULL;
326: END IF;
327:
328: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,p_old_QUALIFIER_RULES_rec.attribute14)
329: THEN
330: NULL;
331: END IF;
332:

Line 333: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,p_old_QUALIFIER_RULES_rec.attribute15)

329: THEN
330: NULL;
331: END IF;
332:
333: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,p_old_QUALIFIER_RULES_rec.attribute15)
334: THEN
335: NULL;
336: END IF;
337:

Line 338: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,p_old_QUALIFIER_RULES_rec.attribute2)

334: THEN
335: NULL;
336: END IF;
337:
338: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,p_old_QUALIFIER_RULES_rec.attribute2)
339: THEN
340: NULL;
341: END IF;
342:

Line 343: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,p_old_QUALIFIER_RULES_rec.attribute3)

339: THEN
340: NULL;
341: END IF;
342:
343: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,p_old_QUALIFIER_RULES_rec.attribute3)
344: THEN
345: NULL;
346: END IF;
347:

Line 348: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,p_old_QUALIFIER_RULES_rec.attribute4)

344: THEN
345: NULL;
346: END IF;
347:
348: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,p_old_QUALIFIER_RULES_rec.attribute4)
349: THEN
350: NULL;
351: END IF;
352:

Line 353: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,p_old_QUALIFIER_RULES_rec.attribute5)

349: THEN
350: NULL;
351: END IF;
352:
353: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,p_old_QUALIFIER_RULES_rec.attribute5)
354: THEN
355: NULL;
356: END IF;
357:

Line 358: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,p_old_QUALIFIER_RULES_rec.attribute6)

354: THEN
355: NULL;
356: END IF;
357:
358: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,p_old_QUALIFIER_RULES_rec.attribute6)
359: THEN
360: NULL;
361: END IF;
362:

Line 363: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,p_old_QUALIFIER_RULES_rec.attribute7)

359: THEN
360: NULL;
361: END IF;
362:
363: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,p_old_QUALIFIER_RULES_rec.attribute7)
364: THEN
365: NULL;
366: END IF;
367:

Line 368: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,p_old_QUALIFIER_RULES_rec.attribute8)

364: THEN
365: NULL;
366: END IF;
367:
368: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,p_old_QUALIFIER_RULES_rec.attribute8)
369: THEN
370: NULL;
371: END IF;
372:

Line 373: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,p_old_QUALIFIER_RULES_rec.attribute9)

369: THEN
370: NULL;
371: END IF;
372:
373: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,p_old_QUALIFIER_RULES_rec.attribute9)
374: THEN
375: NULL;
376: END IF;
377:

Line 378: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,p_old_QUALIFIER_RULES_rec.context)

374: THEN
375: NULL;
376: END IF;
377:
378: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,p_old_QUALIFIER_RULES_rec.context)
379: THEN
380: NULL;
381: END IF;
382:

Line 383: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,p_old_QUALIFIER_RULES_rec.created_by)

379: THEN
380: NULL;
381: END IF;
382:
383: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,p_old_QUALIFIER_RULES_rec.created_by)
384: THEN
385: NULL;
386: END IF;
387:

Line 388: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,p_old_QUALIFIER_RULES_rec.creation_date)

384: THEN
385: NULL;
386: END IF;
387:
388: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,p_old_QUALIFIER_RULES_rec.creation_date)
389: THEN
390: NULL;
391: END IF;
392:

Line 393: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,p_old_QUALIFIER_RULES_rec.description)

389: THEN
390: NULL;
391: END IF;
392:
393: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,p_old_QUALIFIER_RULES_rec.description)
394: THEN
395: NULL;
396: END IF;
397:

Line 398: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,p_old_QUALIFIER_RULES_rec.last_updated_by)

394: THEN
395: NULL;
396: END IF;
397:
398: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,p_old_QUALIFIER_RULES_rec.last_updated_by)
399: THEN
400: NULL;
401: END IF;
402:

Line 403: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,p_old_QUALIFIER_RULES_rec.last_update_date)

399: THEN
400: NULL;
401: END IF;
402:
403: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,p_old_QUALIFIER_RULES_rec.last_update_date)
404: THEN
405: NULL;
406: END IF;
407:

Line 408: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,p_old_QUALIFIER_RULES_rec.last_update_login)

404: THEN
405: NULL;
406: END IF;
407:
408: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,p_old_QUALIFIER_RULES_rec.last_update_login)
409: THEN
410: NULL;
411: END IF;
412:

Line 413: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,p_old_QUALIFIER_RULES_rec.name)

409: THEN
410: NULL;
411: END IF;
412:
413: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,p_old_QUALIFIER_RULES_rec.name)
414: THEN
415: NULL;
416: END IF;
417:

Line 418: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,p_old_QUALIFIER_RULES_rec.program_application_id)

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

Line 423: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,p_old_QUALIFIER_RULES_rec.program_id)

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

Line 428: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,p_old_QUALIFIER_RULES_rec.program_update_date)

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

Line 433: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,p_old_QUALIFIER_RULES_rec.qualifier_rule_id)

429: THEN
430: NULL;
431: END IF;
432:
433: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,p_old_QUALIFIER_RULES_rec.qualifier_rule_id)
434: THEN
435: NULL;
436: END IF;
437:

Line 438: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,p_old_QUALIFIER_RULES_rec.request_id)

434: THEN
435: NULL;
436: END IF;
437:
438: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,p_old_QUALIFIER_RULES_rec.request_id)
439: THEN
440: NULL;
441: END IF;
442:

Line 1040: IF QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,

1036: FOR UPDATE NOWAIT;
1037:
1038: -- Row locked. Compare IN attributes to DB attributes.
1039:
1040: IF QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,
1041: l_QUALIFIER_RULES_rec.attribute1)
1042: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,
1043: l_QUALIFIER_RULES_rec.attribute10)
1044: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,

Line 1042: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,

1038: -- Row locked. Compare IN attributes to DB attributes.
1039:
1040: IF QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,
1041: l_QUALIFIER_RULES_rec.attribute1)
1042: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,
1043: l_QUALIFIER_RULES_rec.attribute10)
1044: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,
1045: l_QUALIFIER_RULES_rec.attribute11)
1046: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,

Line 1044: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,

1040: IF QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,
1041: l_QUALIFIER_RULES_rec.attribute1)
1042: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,
1043: l_QUALIFIER_RULES_rec.attribute10)
1044: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,
1045: l_QUALIFIER_RULES_rec.attribute11)
1046: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,
1047: l_QUALIFIER_RULES_rec.attribute12)
1048: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,

Line 1046: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,

1042: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,
1043: l_QUALIFIER_RULES_rec.attribute10)
1044: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,
1045: l_QUALIFIER_RULES_rec.attribute11)
1046: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,
1047: l_QUALIFIER_RULES_rec.attribute12)
1048: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,
1049: l_QUALIFIER_RULES_rec.attribute13)
1050: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,

Line 1048: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,

1044: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,
1045: l_QUALIFIER_RULES_rec.attribute11)
1046: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,
1047: l_QUALIFIER_RULES_rec.attribute12)
1048: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,
1049: l_QUALIFIER_RULES_rec.attribute13)
1050: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,
1051: l_QUALIFIER_RULES_rec.attribute14)
1052: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,

Line 1050: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,

1046: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,
1047: l_QUALIFIER_RULES_rec.attribute12)
1048: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,
1049: l_QUALIFIER_RULES_rec.attribute13)
1050: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,
1051: l_QUALIFIER_RULES_rec.attribute14)
1052: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,
1053: l_QUALIFIER_RULES_rec.attribute15)
1054: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,

Line 1052: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,

1048: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,
1049: l_QUALIFIER_RULES_rec.attribute13)
1050: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,
1051: l_QUALIFIER_RULES_rec.attribute14)
1052: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,
1053: l_QUALIFIER_RULES_rec.attribute15)
1054: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,
1055: l_QUALIFIER_RULES_rec.attribute2)
1056: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,

Line 1054: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,

1050: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,
1051: l_QUALIFIER_RULES_rec.attribute14)
1052: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,
1053: l_QUALIFIER_RULES_rec.attribute15)
1054: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,
1055: l_QUALIFIER_RULES_rec.attribute2)
1056: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,
1057: l_QUALIFIER_RULES_rec.attribute3)
1058: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,

Line 1056: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,

1052: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,
1053: l_QUALIFIER_RULES_rec.attribute15)
1054: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,
1055: l_QUALIFIER_RULES_rec.attribute2)
1056: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,
1057: l_QUALIFIER_RULES_rec.attribute3)
1058: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,
1059: l_QUALIFIER_RULES_rec.attribute4)
1060: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,

Line 1058: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,

1054: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,
1055: l_QUALIFIER_RULES_rec.attribute2)
1056: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,
1057: l_QUALIFIER_RULES_rec.attribute3)
1058: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,
1059: l_QUALIFIER_RULES_rec.attribute4)
1060: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,
1061: l_QUALIFIER_RULES_rec.attribute5)
1062: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,

Line 1060: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,

1056: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,
1057: l_QUALIFIER_RULES_rec.attribute3)
1058: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,
1059: l_QUALIFIER_RULES_rec.attribute4)
1060: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,
1061: l_QUALIFIER_RULES_rec.attribute5)
1062: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,
1063: l_QUALIFIER_RULES_rec.attribute6)
1064: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,

Line 1062: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,

1058: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,
1059: l_QUALIFIER_RULES_rec.attribute4)
1060: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,
1061: l_QUALIFIER_RULES_rec.attribute5)
1062: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,
1063: l_QUALIFIER_RULES_rec.attribute6)
1064: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,
1065: l_QUALIFIER_RULES_rec.attribute7)
1066: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,

Line 1064: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,

1060: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,
1061: l_QUALIFIER_RULES_rec.attribute5)
1062: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,
1063: l_QUALIFIER_RULES_rec.attribute6)
1064: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,
1065: l_QUALIFIER_RULES_rec.attribute7)
1066: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,
1067: l_QUALIFIER_RULES_rec.attribute8)
1068: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,

Line 1066: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,

1062: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,
1063: l_QUALIFIER_RULES_rec.attribute6)
1064: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,
1065: l_QUALIFIER_RULES_rec.attribute7)
1066: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,
1067: l_QUALIFIER_RULES_rec.attribute8)
1068: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,
1069: l_QUALIFIER_RULES_rec.attribute9)
1070: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,

Line 1068: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,

1064: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,
1065: l_QUALIFIER_RULES_rec.attribute7)
1066: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,
1067: l_QUALIFIER_RULES_rec.attribute8)
1068: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,
1069: l_QUALIFIER_RULES_rec.attribute9)
1070: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,
1071: l_QUALIFIER_RULES_rec.context)
1072: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,

Line 1070: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,

1066: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,
1067: l_QUALIFIER_RULES_rec.attribute8)
1068: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,
1069: l_QUALIFIER_RULES_rec.attribute9)
1070: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,
1071: l_QUALIFIER_RULES_rec.context)
1072: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,
1073: l_QUALIFIER_RULES_rec.created_by)
1074: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,

Line 1072: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,

1068: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,
1069: l_QUALIFIER_RULES_rec.attribute9)
1070: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,
1071: l_QUALIFIER_RULES_rec.context)
1072: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,
1073: l_QUALIFIER_RULES_rec.created_by)
1074: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,
1075: l_QUALIFIER_RULES_rec.creation_date)
1076: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,

Line 1074: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,

1070: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,
1071: l_QUALIFIER_RULES_rec.context)
1072: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,
1073: l_QUALIFIER_RULES_rec.created_by)
1074: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,
1075: l_QUALIFIER_RULES_rec.creation_date)
1076: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,
1077: l_QUALIFIER_RULES_rec.description)
1078: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,

Line 1076: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,

1072: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,
1073: l_QUALIFIER_RULES_rec.created_by)
1074: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,
1075: l_QUALIFIER_RULES_rec.creation_date)
1076: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,
1077: l_QUALIFIER_RULES_rec.description)
1078: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,
1079: l_QUALIFIER_RULES_rec.last_updated_by)
1080: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,

Line 1078: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,

1074: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,
1075: l_QUALIFIER_RULES_rec.creation_date)
1076: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,
1077: l_QUALIFIER_RULES_rec.description)
1078: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,
1079: l_QUALIFIER_RULES_rec.last_updated_by)
1080: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,
1081: l_QUALIFIER_RULES_rec.last_update_date)
1082: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,

Line 1080: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,

1076: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,
1077: l_QUALIFIER_RULES_rec.description)
1078: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,
1079: l_QUALIFIER_RULES_rec.last_updated_by)
1080: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,
1081: l_QUALIFIER_RULES_rec.last_update_date)
1082: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,
1083: l_QUALIFIER_RULES_rec.last_update_login)
1084: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,

Line 1082: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,

1078: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,
1079: l_QUALIFIER_RULES_rec.last_updated_by)
1080: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,
1081: l_QUALIFIER_RULES_rec.last_update_date)
1082: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,
1083: l_QUALIFIER_RULES_rec.last_update_login)
1084: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,
1085: l_QUALIFIER_RULES_rec.name)
1086: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,

Line 1084: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,

1080: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,
1081: l_QUALIFIER_RULES_rec.last_update_date)
1082: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,
1083: l_QUALIFIER_RULES_rec.last_update_login)
1084: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,
1085: l_QUALIFIER_RULES_rec.name)
1086: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,
1087: l_QUALIFIER_RULES_rec.program_application_id)
1088: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,

Line 1086: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,

1082: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,
1083: l_QUALIFIER_RULES_rec.last_update_login)
1084: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,
1085: l_QUALIFIER_RULES_rec.name)
1086: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,
1087: l_QUALIFIER_RULES_rec.program_application_id)
1088: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,
1089: l_QUALIFIER_RULES_rec.program_id)
1090: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,

Line 1088: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,

1084: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,
1085: l_QUALIFIER_RULES_rec.name)
1086: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,
1087: l_QUALIFIER_RULES_rec.program_application_id)
1088: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,
1089: l_QUALIFIER_RULES_rec.program_id)
1090: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,
1091: l_QUALIFIER_RULES_rec.program_update_date)
1092: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,

Line 1090: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,

1086: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,
1087: l_QUALIFIER_RULES_rec.program_application_id)
1088: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,
1089: l_QUALIFIER_RULES_rec.program_id)
1090: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,
1091: l_QUALIFIER_RULES_rec.program_update_date)
1092: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,
1093: l_QUALIFIER_RULES_rec.qualifier_rule_id)
1094: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,

Line 1092: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,

1088: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,
1089: l_QUALIFIER_RULES_rec.program_id)
1090: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,
1091: l_QUALIFIER_RULES_rec.program_update_date)
1092: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,
1093: l_QUALIFIER_RULES_rec.qualifier_rule_id)
1094: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,
1095: l_QUALIFIER_RULES_rec.request_id)
1096: THEN

Line 1094: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,

1090: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,
1091: l_QUALIFIER_RULES_rec.program_update_date)
1092: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,
1093: l_QUALIFIER_RULES_rec.qualifier_rule_id)
1094: AND QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,
1095: l_QUALIFIER_RULES_rec.request_id)
1096: THEN
1097:
1098: -- Row has not changed. Set out NOCOPY /* file.sql.39 change */ parameter.

Line 1182: NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,

1178: BEGIN
1179:
1180: IF p_QUALIFIER_RULES_rec.qualifier_rule_id IS NOT NULL AND
1181: p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND
1182: NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,
1183: p_old_QUALIFIER_RULES_rec.qualifier_rule_id)
1184: THEN
1185: l_QUALIFIER_RULES_val_rec.qualifier_rule := QP_Id_To_Value.Qualifier_Rule
1186: ( p_qualifier_rule_id => p_QUALIFIER_RULES_rec.qualifier_rule_id