APPS.QP_SOU_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record

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

Line 38: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute10,p_old_SOU_rec.attribute10)

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

Line 44: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute11,p_old_SOU_rec.attribute11)

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

Line 50: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute12,p_old_SOU_rec.attribute12)

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

Line 56: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute13,p_old_SOU_rec.attribute13)

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

Line 62: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute14,p_old_SOU_rec.attribute14)

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

Line 68: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute15,p_old_SOU_rec.attribute15)

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

Line 74: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute2,p_old_SOU_rec.attribute2)

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

Line 80: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute3,p_old_SOU_rec.attribute3)

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

Line 86: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute4,p_old_SOU_rec.attribute4)

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

Line 92: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute5,p_old_SOU_rec.attribute5)

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

Line 98: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute6,p_old_SOU_rec.attribute6)

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

Line 104: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute7,p_old_SOU_rec.attribute7)

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

Line 110: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute8,p_old_SOU_rec.attribute8)

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

Line 116: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute9,p_old_SOU_rec.attribute9)

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

Line 122: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,p_old_SOU_rec.attribute_sourcing_id)

118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,p_old_SOU_rec.attribute_sourcing_id)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING;
126: END IF;

Line 128: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,p_old_SOU_rec.attribute_sourcing_level)

124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,p_old_SOU_rec.attribute_sourcing_level)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING_LEVEL;
132: END IF;

Line 134: IF NOT QP_GLOBALS.Equal(p_SOU_rec.application_id,p_old_SOU_rec.application_id)

130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ATTRIBUTE_SOURCING_LEVEL;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_SOU_rec.application_id,p_old_SOU_rec.application_id)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_APPLICATION_ID;
138: END IF;

Line 140: IF NOT QP_GLOBALS.Equal(p_SOU_rec.context,p_old_SOU_rec.context)

136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_APPLICATION_ID;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_SOU_rec.context,p_old_SOU_rec.context)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CONTEXT;
144: END IF;

Line 146: IF NOT QP_GLOBALS.Equal(p_SOU_rec.created_by,p_old_SOU_rec.created_by)

142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CONTEXT;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_SOU_rec.created_by,p_old_SOU_rec.created_by)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATED_BY;
150: END IF;

Line 152: IF NOT QP_GLOBALS.Equal(p_SOU_rec.creation_date,p_old_SOU_rec.creation_date)

148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATED_BY;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_SOU_rec.creation_date,p_old_SOU_rec.creation_date)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATION_DATE;
156: END IF;

Line 158: IF NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,p_old_SOU_rec.enabled_flag)

154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_CREATION_DATE;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,p_old_SOU_rec.enabled_flag)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ENABLED;
162: END IF;

Line 164: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,p_old_SOU_rec.last_updated_by)

160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_ENABLED;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,p_old_SOU_rec.last_updated_by)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATED_BY;
168: END IF;

Line 170: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_date,p_old_SOU_rec.last_update_date)

166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATED_BY;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_date,p_old_SOU_rec.last_update_date)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_DATE;
174: END IF;

Line 176: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_login,p_old_SOU_rec.last_update_login)

172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_DATE;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_login,p_old_SOU_rec.last_update_login)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_LOGIN;
180: END IF;

Line 182: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_application_id,p_old_SOU_rec.program_application_id)

178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_LAST_UPDATE_LOGIN;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_application_id,p_old_SOU_rec.program_application_id)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_APPLICATION;
186: END IF;

Line 188: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_id,p_old_SOU_rec.program_id)

184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_APPLICATION;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_id,p_old_SOU_rec.program_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM;
192: END IF;

Line 194: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_update_date,p_old_SOU_rec.program_update_date)

190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_update_date,p_old_SOU_rec.program_update_date)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;

Line 200: IF NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,p_old_SOU_rec.request_type_code)

196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_PROGRAM_UPDATE_DATE;
198: END IF;
199:
200: IF NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,p_old_SOU_rec.request_type_code)
201: THEN
202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_REQUEST_TYPE;
204: END IF;

Line 206: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,p_old_SOU_rec.seeded_flag)

202: l_index := l_index + 1;
203: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_REQUEST_TYPE;
204: END IF;
205:
206: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,p_old_SOU_rec.seeded_flag)
207: THEN
208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED;
210: END IF;

Line 212: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,p_old_SOU_rec.seeded_sourcing_type)

208: l_index := l_index + 1;
209: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED;
210: END IF;
211:
212: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,p_old_SOU_rec.seeded_sourcing_type)
213: THEN
214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_SOURCING_TYPE;
216: END IF;

Line 218: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,p_old_SOU_rec.seeded_value_string)

214: l_index := l_index + 1;
215: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_SOURCING_TYPE;
216: END IF;
217:
218: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,p_old_SOU_rec.seeded_value_string)
219: THEN
220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_VALUE_STRING;
222: END IF;

Line 224: IF NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,p_old_SOU_rec.segment_id)

220: l_index := l_index + 1;
221: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEEDED_VALUE_STRING;
222: END IF;
223:
224: IF NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,p_old_SOU_rec.segment_id)
225: THEN
226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEGMENT;
228: END IF;

Line 230: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,p_old_SOU_rec.user_sourcing_type)

226: l_index := l_index + 1;
227: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_SEGMENT;
228: END IF;
229:
230: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,p_old_SOU_rec.user_sourcing_type)
231: THEN
232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_USER_SOURCING_TYPE;
234: END IF;

Line 236: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_value_string,p_old_SOU_rec.user_value_string)

232: l_index := l_index + 1;
233: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_USER_SOURCING_TYPE;
234: END IF;
235:
236: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_value_string,p_old_SOU_rec.user_value_string)
237: THEN
238: l_index := l_index + 1;
239: l_src_attr_tbl(l_index) := QP_SOU_UTIL.G_USER_VALUE_STRING;
240: END IF;

Line 366: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute1,p_old_SOU_rec.attribute1)

362: -- Load out record
363:
364: x_SOU_rec := p_SOU_rec;
365:
366: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute1,p_old_SOU_rec.attribute1)
367: THEN
368: NULL;
369: END IF;
370:

Line 371: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute10,p_old_SOU_rec.attribute10)

367: THEN
368: NULL;
369: END IF;
370:
371: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute10,p_old_SOU_rec.attribute10)
372: THEN
373: NULL;
374: END IF;
375:

Line 376: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute11,p_old_SOU_rec.attribute11)

372: THEN
373: NULL;
374: END IF;
375:
376: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute11,p_old_SOU_rec.attribute11)
377: THEN
378: NULL;
379: END IF;
380:

Line 381: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute12,p_old_SOU_rec.attribute12)

377: THEN
378: NULL;
379: END IF;
380:
381: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute12,p_old_SOU_rec.attribute12)
382: THEN
383: NULL;
384: END IF;
385:

Line 386: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute13,p_old_SOU_rec.attribute13)

382: THEN
383: NULL;
384: END IF;
385:
386: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute13,p_old_SOU_rec.attribute13)
387: THEN
388: NULL;
389: END IF;
390:

Line 391: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute14,p_old_SOU_rec.attribute14)

387: THEN
388: NULL;
389: END IF;
390:
391: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute14,p_old_SOU_rec.attribute14)
392: THEN
393: NULL;
394: END IF;
395:

Line 396: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute15,p_old_SOU_rec.attribute15)

392: THEN
393: NULL;
394: END IF;
395:
396: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute15,p_old_SOU_rec.attribute15)
397: THEN
398: NULL;
399: END IF;
400:

Line 401: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute2,p_old_SOU_rec.attribute2)

397: THEN
398: NULL;
399: END IF;
400:
401: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute2,p_old_SOU_rec.attribute2)
402: THEN
403: NULL;
404: END IF;
405:

Line 406: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute3,p_old_SOU_rec.attribute3)

402: THEN
403: NULL;
404: END IF;
405:
406: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute3,p_old_SOU_rec.attribute3)
407: THEN
408: NULL;
409: END IF;
410:

Line 411: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute4,p_old_SOU_rec.attribute4)

407: THEN
408: NULL;
409: END IF;
410:
411: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute4,p_old_SOU_rec.attribute4)
412: THEN
413: NULL;
414: END IF;
415:

Line 416: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute5,p_old_SOU_rec.attribute5)

412: THEN
413: NULL;
414: END IF;
415:
416: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute5,p_old_SOU_rec.attribute5)
417: THEN
418: NULL;
419: END IF;
420:

Line 421: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute6,p_old_SOU_rec.attribute6)

417: THEN
418: NULL;
419: END IF;
420:
421: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute6,p_old_SOU_rec.attribute6)
422: THEN
423: NULL;
424: END IF;
425:

Line 426: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute7,p_old_SOU_rec.attribute7)

422: THEN
423: NULL;
424: END IF;
425:
426: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute7,p_old_SOU_rec.attribute7)
427: THEN
428: NULL;
429: END IF;
430:

Line 431: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute8,p_old_SOU_rec.attribute8)

427: THEN
428: NULL;
429: END IF;
430:
431: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute8,p_old_SOU_rec.attribute8)
432: THEN
433: NULL;
434: END IF;
435:

Line 436: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute9,p_old_SOU_rec.attribute9)

432: THEN
433: NULL;
434: END IF;
435:
436: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute9,p_old_SOU_rec.attribute9)
437: THEN
438: NULL;
439: END IF;
440:

Line 441: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,p_old_SOU_rec.attribute_sourcing_id)

437: THEN
438: NULL;
439: END IF;
440:
441: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,p_old_SOU_rec.attribute_sourcing_id)
442: THEN
443: NULL;
444: END IF;
445:

Line 446: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,p_old_SOU_rec.attribute_sourcing_level)

442: THEN
443: NULL;
444: END IF;
445:
446: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,p_old_SOU_rec.attribute_sourcing_level)
447: THEN
448: NULL;
449: END IF;
450:

Line 451: IF NOT QP_GLOBALS.Equal(p_SOU_rec.application_id,p_old_SOU_rec.application_id)

447: THEN
448: NULL;
449: END IF;
450:
451: IF NOT QP_GLOBALS.Equal(p_SOU_rec.application_id,p_old_SOU_rec.application_id)
452: THEN
453: NULL;
454: END IF;
455:

Line 457: IF NOT QP_GLOBALS.Equal(p_SOU_rec.context,p_old_SOU_rec.context)

453: NULL;
454: END IF;
455:
456:
457: IF NOT QP_GLOBALS.Equal(p_SOU_rec.context,p_old_SOU_rec.context)
458: THEN
459: NULL;
460: END IF;
461:

Line 462: IF NOT QP_GLOBALS.Equal(p_SOU_rec.created_by,p_old_SOU_rec.created_by)

458: THEN
459: NULL;
460: END IF;
461:
462: IF NOT QP_GLOBALS.Equal(p_SOU_rec.created_by,p_old_SOU_rec.created_by)
463: THEN
464: NULL;
465: END IF;
466:

Line 467: IF NOT QP_GLOBALS.Equal(p_SOU_rec.creation_date,p_old_SOU_rec.creation_date)

463: THEN
464: NULL;
465: END IF;
466:
467: IF NOT QP_GLOBALS.Equal(p_SOU_rec.creation_date,p_old_SOU_rec.creation_date)
468: THEN
469: NULL;
470: END IF;
471:

Line 472: IF NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,p_old_SOU_rec.enabled_flag)

468: THEN
469: NULL;
470: END IF;
471:
472: IF NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,p_old_SOU_rec.enabled_flag)
473: THEN
474: NULL;
475: END IF;
476:

Line 477: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,p_old_SOU_rec.last_updated_by)

473: THEN
474: NULL;
475: END IF;
476:
477: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,p_old_SOU_rec.last_updated_by)
478: THEN
479: NULL;
480: END IF;
481:

Line 482: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_date,p_old_SOU_rec.last_update_date)

478: THEN
479: NULL;
480: END IF;
481:
482: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_date,p_old_SOU_rec.last_update_date)
483: THEN
484: NULL;
485: END IF;
486:

Line 487: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_login,p_old_SOU_rec.last_update_login)

483: THEN
484: NULL;
485: END IF;
486:
487: IF NOT QP_GLOBALS.Equal(p_SOU_rec.last_update_login,p_old_SOU_rec.last_update_login)
488: THEN
489: NULL;
490: END IF;
491:

Line 492: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_application_id,p_old_SOU_rec.program_application_id)

488: THEN
489: NULL;
490: END IF;
491:
492: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_application_id,p_old_SOU_rec.program_application_id)
493: THEN
494: NULL;
495: END IF;
496:

Line 497: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_id,p_old_SOU_rec.program_id)

493: THEN
494: NULL;
495: END IF;
496:
497: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_id,p_old_SOU_rec.program_id)
498: THEN
499: NULL;
500: END IF;
501:

Line 502: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_update_date,p_old_SOU_rec.program_update_date)

498: THEN
499: NULL;
500: END IF;
501:
502: IF NOT QP_GLOBALS.Equal(p_SOU_rec.program_update_date,p_old_SOU_rec.program_update_date)
503: THEN
504: NULL;
505: END IF;
506:

Line 507: IF NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,p_old_SOU_rec.request_type_code)

503: THEN
504: NULL;
505: END IF;
506:
507: IF NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,p_old_SOU_rec.request_type_code)
508: THEN
509: NULL;
510: END IF;
511:

Line 512: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,p_old_SOU_rec.seeded_flag)

508: THEN
509: NULL;
510: END IF;
511:
512: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,p_old_SOU_rec.seeded_flag)
513: THEN
514: NULL;
515: END IF;
516:

Line 517: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,p_old_SOU_rec.seeded_sourcing_type)

513: THEN
514: NULL;
515: END IF;
516:
517: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,p_old_SOU_rec.seeded_sourcing_type)
518: THEN
519: NULL;
520: END IF;
521:

Line 522: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,p_old_SOU_rec.seeded_value_string)

518: THEN
519: NULL;
520: END IF;
521:
522: IF NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,p_old_SOU_rec.seeded_value_string)
523: THEN
524: NULL;
525: END IF;
526:

Line 527: IF NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,p_old_SOU_rec.segment_id)

523: THEN
524: NULL;
525: END IF;
526:
527: IF NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,p_old_SOU_rec.segment_id)
528: THEN
529: NULL;
530: END IF;
531:

Line 532: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,p_old_SOU_rec.user_sourcing_type)

528: THEN
529: NULL;
530: END IF;
531:
532: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,p_old_SOU_rec.user_sourcing_type)
533: THEN
534: NULL;
535: END IF;
536:

Line 537: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_value_string,p_old_SOU_rec.user_value_string)

533: THEN
534: NULL;
535: END IF;
536:
537: IF NOT QP_GLOBALS.Equal(p_SOU_rec.user_value_string,p_old_SOU_rec.user_value_string)
538: THEN
539: NULL;
540: END IF;
541:

Line 1306: IF QP_GLOBALS.Equal(p_SOU_rec.attribute1,

1302: FOR UPDATE NOWAIT;
1303:
1304: -- Row locked. Compare IN attributes to DB attributes.
1305:
1306: IF QP_GLOBALS.Equal(p_SOU_rec.attribute1,
1307: l_SOU_rec.attribute1)
1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,

Line 1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,

1304: -- Row locked. Compare IN attributes to DB attributes.
1305:
1306: IF QP_GLOBALS.Equal(p_SOU_rec.attribute1,
1307: l_SOU_rec.attribute1)
1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,

Line 1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,

1306: IF QP_GLOBALS.Equal(p_SOU_rec.attribute1,
1307: l_SOU_rec.attribute1)
1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,

Line 1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,

1308: AND QP_GLOBALS.Equal(p_SOU_rec.attribute10,
1309: l_SOU_rec.attribute10)
1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,

Line 1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,

1310: AND QP_GLOBALS.Equal(p_SOU_rec.attribute11,
1311: l_SOU_rec.attribute11)
1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,

Line 1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,

1312: AND QP_GLOBALS.Equal(p_SOU_rec.attribute12,
1313: l_SOU_rec.attribute12)
1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,

Line 1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,

1314: AND QP_GLOBALS.Equal(p_SOU_rec.attribute13,
1315: l_SOU_rec.attribute13)
1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,

Line 1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,

1316: AND QP_GLOBALS.Equal(p_SOU_rec.attribute14,
1317: l_SOU_rec.attribute14)
1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,

Line 1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,

1318: AND QP_GLOBALS.Equal(p_SOU_rec.attribute15,
1319: l_SOU_rec.attribute15)
1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,

Line 1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,

1320: AND QP_GLOBALS.Equal(p_SOU_rec.attribute2,
1321: l_SOU_rec.attribute2)
1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,

Line 1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,

1322: AND QP_GLOBALS.Equal(p_SOU_rec.attribute3,
1323: l_SOU_rec.attribute3)
1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,

Line 1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,

1324: AND QP_GLOBALS.Equal(p_SOU_rec.attribute4,
1325: l_SOU_rec.attribute4)
1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,

Line 1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,

1326: AND QP_GLOBALS.Equal(p_SOU_rec.attribute5,
1327: l_SOU_rec.attribute5)
1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,

Line 1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,

1328: AND QP_GLOBALS.Equal(p_SOU_rec.attribute6,
1329: l_SOU_rec.attribute6)
1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,

Line 1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,

1330: AND QP_GLOBALS.Equal(p_SOU_rec.attribute7,
1331: l_SOU_rec.attribute7)
1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,

Line 1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,

1332: AND QP_GLOBALS.Equal(p_SOU_rec.attribute8,
1333: l_SOU_rec.attribute8)
1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,

Line 1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,

1334: AND QP_GLOBALS.Equal(p_SOU_rec.attribute9,
1335: l_SOU_rec.attribute9)
1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,

Line 1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,

1336: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1337: l_SOU_rec.attribute_sourcing_id)
1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,

Line 1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,

1338: AND QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_level,
1339: l_SOU_rec.attribute_sourcing_level)
1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,

Line 1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,

1340: AND QP_GLOBALS.Equal(p_SOU_rec.application_id,
1341: l_SOU_rec.application_id)
1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,

Line 1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,

1342: AND QP_GLOBALS.Equal(p_SOU_rec.context,
1343: l_SOU_rec.context)
1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,

Line 1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,

1344: AND QP_GLOBALS.Equal(p_SOU_rec.created_by,
1345: l_SOU_rec.created_by)
1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,

Line 1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,

1346: AND QP_GLOBALS.Equal(p_SOU_rec.creation_date,
1347: l_SOU_rec.creation_date)
1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,

Line 1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,

1348: AND QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1349: l_SOU_rec.enabled_flag)
1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,

Line 1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,

1350: AND QP_GLOBALS.Equal(p_SOU_rec.last_updated_by,
1351: l_SOU_rec.last_updated_by)
1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,

Line 1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,

1352: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_date,
1353: l_SOU_rec.last_update_date)
1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,

Line 1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,

1354: AND QP_GLOBALS.Equal(p_SOU_rec.last_update_login,
1355: l_SOU_rec.last_update_login)
1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,

Line 1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,

1356: AND QP_GLOBALS.Equal(p_SOU_rec.program_application_id,
1357: l_SOU_rec.program_application_id)
1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,

Line 1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,

1358: AND QP_GLOBALS.Equal(p_SOU_rec.program_id,
1359: l_SOU_rec.program_id)
1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,

Line 1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,

1360: AND QP_GLOBALS.Equal(p_SOU_rec.program_update_date,
1361: l_SOU_rec.program_update_date)
1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,

Line 1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,

1362: AND QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1363: l_SOU_rec.request_type_code)
1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,

Line 1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,

1364: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1365: l_SOU_rec.seeded_flag)
1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,

Line 1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,

1366: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_sourcing_type,
1367: l_SOU_rec.seeded_sourcing_type)
1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
1373: l_SOU_rec.user_sourcing_type)
1374: AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,

Line 1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,

1368: AND QP_GLOBALS.Equal(p_SOU_rec.seeded_value_string,
1369: l_SOU_rec.seeded_value_string)
1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
1373: l_SOU_rec.user_sourcing_type)
1374: AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,
1375: l_SOU_rec.user_value_string)
1376: THEN

Line 1374: AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,

1370: AND QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1371: l_SOU_rec.segment_id)
1372: AND QP_GLOBALS.Equal(p_SOU_rec.user_sourcing_type,
1373: l_SOU_rec.user_sourcing_type)
1374: AND QP_GLOBALS.Equal(p_SOU_rec.user_value_string,
1375: l_SOU_rec.user_value_string)
1376: THEN
1377:
1378: -- Row has not changed. Set out parameter.

Line 1458: NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,

1454: BEGIN
1455:
1456: IF p_SOU_rec.attribute_sourcing_id IS NOT NULL AND
1457: p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM AND
1458: NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1459: p_old_SOU_rec.attribute_sourcing_id)
1460: THEN
1461: l_SOU_val_rec.attribute_sourcing := QP_Id_To_Value.Attribute_Sourcing
1462: ( p_attribute_sourcing_id => p_SOU_rec.attribute_sourcing_id

Line 1468: NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,

1464: END IF;
1465:
1466: IF p_SOU_rec.enabled_flag IS NOT NULL AND
1467: p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1468: NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1469: p_old_SOU_rec.enabled_flag)
1470: THEN
1471: l_SOU_val_rec.enabled := QP_Id_To_Value.Enabled
1472: ( p_enabled_flag => p_SOU_rec.enabled_flag

Line 1478: NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,

1474: END IF;
1475:
1476: IF p_SOU_rec.request_type_code IS NOT NULL AND
1477: p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR AND
1478: NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1479: p_old_SOU_rec.request_type_code)
1480: THEN
1481: l_SOU_val_rec.request_type := QP_Id_To_Value.Request_Type
1482: ( p_request_type_code => p_SOU_rec.request_type_code

Line 1488: NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,

1484: END IF;
1485:
1486: IF p_SOU_rec.seeded_flag IS NOT NULL AND
1487: p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1488: NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1489: p_old_SOU_rec.seeded_flag)
1490: THEN
1491: l_SOU_val_rec.seeded := QP_Id_To_Value.Seeded
1492: ( p_seeded_flag => p_SOU_rec.seeded_flag

Line 1498: NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,

1494: END IF;
1495:
1496: IF p_SOU_rec.segment_id IS NOT NULL AND
1497: p_SOU_rec.segment_id <> FND_API.G_MISS_NUM AND
1498: NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1499: p_old_SOU_rec.segment_id)
1500: THEN
1501: l_SOU_val_rec.segment := QP_Id_To_Value.Segment
1502: ( p_segment_id => p_SOU_rec.segment_id