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

Line 19: IF (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_create) THEN

15: l_return_status varchar2(30);
16:
17: BEGIN
18:
19: IF (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_create) THEN
20:
21: IF p_LIMITS_rec.list_header_id IS NOT NULL THEN
22: UPDATE QP_LIST_HEADERS_B
23: SET LIMIT_EXISTS_FLAG = 'Y'

Line 37: ELSIF (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_delete) OR (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_update) THEN

33: and nvl(LIMIT_EXISTS_FLAG,'N') <> 'Y' ; --Bug no 6193752
34: l_updated := 2; --pattern
35: END IF;
36:
37: ELSIF (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_delete) OR (p_LIMITS_rec.operation = QP_GLOBALS.g_opr_update) THEN
38:
39: IF p_LIMITS_rec.list_header_id IS NOT NULL THEN
40:
41: l_dummy := 0;

Line 101: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

97: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
98: IF (p_LIMITS_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
99: IF l_updated = 1 then
100: qp_delayed_requests_pvt.log_request(
101: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
102: p_entity_id => p_LIMITS_rec.list_header_id,
103: p_request_unique_key1 => NULL,
104: p_request_unique_key2 => 'UD',
105: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 105: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

101: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
102: p_entity_id => p_LIMITS_rec.list_header_id,
103: p_request_unique_key1 => NULL,
104: p_request_unique_key2 => 'UD',
105: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
106: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
107: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
108: x_return_status => l_return_status);
109: END IF;

Line 107: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

103: p_request_unique_key1 => NULL,
104: p_request_unique_key2 => 'UD',
105: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
106: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
107: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
108: x_return_status => l_return_status);
109: END IF;
110: IF l_updated = 2 then
111: qp_delayed_requests_pvt.log_request(

Line 112: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

108: x_return_status => l_return_status);
109: END IF;
110: IF l_updated = 2 then
111: qp_delayed_requests_pvt.log_request(
112: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
113: p_entity_id => p_LIMITS_rec.list_header_id,
114: p_request_unique_key1 => p_LIMITS_rec.list_line_id,
115: p_request_unique_key2 => NULL,
116: p_request_unique_key3 => 'UD',

Line 117: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

113: p_entity_id => p_LIMITS_rec.list_header_id,
114: p_request_unique_key1 => p_LIMITS_rec.list_line_id,
115: p_request_unique_key2 => NULL,
116: p_request_unique_key3 => 'UD',
117: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
118: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
119: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
120: x_return_status => l_return_status);
121: END IF;

Line 119: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,

115: p_request_unique_key2 => NULL,
116: p_request_unique_key3 => 'UD',
117: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
118: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
119: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
120: x_return_status => l_return_status);
121: END IF;
122: END IF;
123: END IF;

Line 130: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

126: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
127: IF (p_LIMITS_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
128: IF l_updated = 1 then
129: qp_delayed_requests_pvt.log_request(
130: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
131: p_entity_id => p_LIMITS_rec.list_header_id,
132: p_request_unique_key1 => NULL,
133: p_request_unique_key2 => 'UD',
134: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

Line 134: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

130: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
131: p_entity_id => p_LIMITS_rec.list_header_id,
132: p_request_unique_key1 => NULL,
133: p_request_unique_key2 => 'UD',
134: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
135: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
136: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
137: x_return_status => l_return_status);
138: END IF;

Line 136: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,

132: p_request_unique_key1 => NULL,
133: p_request_unique_key2 => 'UD',
134: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
135: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
136: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
137: x_return_status => l_return_status);
138: END IF;
139: IF l_updated = 2 then
140: qp_delayed_requests_pvt.log_request(

Line 141: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

137: x_return_status => l_return_status);
138: END IF;
139: IF l_updated = 2 then
140: qp_delayed_requests_pvt.log_request(
141: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
142: p_entity_id => p_LIMITS_rec.list_header_id,
143: p_request_unique_key1 => p_LIMITS_rec.list_line_id,
144: p_request_unique_key2 => NULL,
145: p_request_unique_key3 => 'UD',

Line 146: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,

142: p_entity_id => p_LIMITS_rec.list_header_id,
143: p_request_unique_key1 => p_LIMITS_rec.list_line_id,
144: p_request_unique_key2 => NULL,
145: p_request_unique_key3 => 'UD',
146: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
147: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
148: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
149: x_return_status => l_return_status);
150: END IF;

Line 148: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,

144: p_request_unique_key2 => NULL,
145: p_request_unique_key3 => 'UD',
146: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
147: p_requesting_entity_id => p_LIMITS_rec.list_header_id,
148: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
149: x_return_status => l_return_status);
150: END IF;
151: END IF;
152: END IF;

Line 167: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

163: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
164: )
165: IS
166: l_index NUMBER := 0;
167: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
168: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
169: BEGIN
170:
171: -- Load out record

Line 168: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

164: )
165: IS
166: l_index NUMBER := 0;
167: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
168: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
169: BEGIN
170:
171: -- Load out record
172:

Line 180: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)

176: -- every changed attribute clear its dependent fields.
177:
178: IF p_attr_id = FND_API.G_MISS_NUM THEN
179:
180: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)
181: THEN
182: l_index := l_index + 1;
183: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;
184: END IF;

Line 186: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)

182: l_index := l_index + 1;
183: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;
184: END IF;
185:
186: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)
187: THEN
188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
190: END IF;

Line 192: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)

188: l_index := l_index + 1;
189: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
190: END IF;
191:
192: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)
193: THEN
194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
196: END IF;

Line 198: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)

194: l_index := l_index + 1;
195: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
196: END IF;
197:
198: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)
199: THEN
200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
202: END IF;

Line 204: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)

200: l_index := l_index + 1;
201: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
202: END IF;
203:
204: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)
205: THEN
206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
208: END IF;

Line 210: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)

206: l_index := l_index + 1;
207: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
208: END IF;
209:
210: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)
211: THEN
212: l_index := l_index + 1;
213: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
214: END IF;

Line 216: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)

212: l_index := l_index + 1;
213: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
214: END IF;
215:
216: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)
217: THEN
218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
220: END IF;

Line 222: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute15, p_old_LIMITS_rec.attribute15)

218: l_index := l_index + 1;
219: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
220: END IF;
221:
222: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute15, p_old_LIMITS_rec.attribute15)
223: THEN
224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
226: END IF;

Line 228: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute2, p_old_LIMITS_rec.attribute2)

224: l_index := l_index + 1;
225: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
226: END IF;
227:
228: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute2, p_old_LIMITS_rec.attribute2)
229: THEN
230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
232: END IF;

Line 234: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute3, p_old_LIMITS_rec.attribute3)

230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
232: END IF;
233:
234: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute3, p_old_LIMITS_rec.attribute3)
235: THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
238: END IF;

Line 240: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute4, p_old_LIMITS_rec.attribute4)

236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
238: END IF;
239:
240: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute4, p_old_LIMITS_rec.attribute4)
241: THEN
242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
244: END IF;

Line 246: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute5, p_old_LIMITS_rec.attribute5)

242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
244: END IF;
245:
246: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute5, p_old_LIMITS_rec.attribute5)
247: THEN
248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
250: END IF;

Line 252: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute6, p_old_LIMITS_rec.attribute6)

248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
250: END IF;
251:
252: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute6, p_old_LIMITS_rec.attribute6)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
256: END IF;

Line 258: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute7, p_old_LIMITS_rec.attribute7)

254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
256: END IF;
257:
258: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute7, p_old_LIMITS_rec.attribute7)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
262: END IF;

Line 264: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute8, p_old_LIMITS_rec.attribute8)

260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
262: END IF;
263:
264: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute8, p_old_LIMITS_rec.attribute8)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
268: END IF;

Line 270: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute9, p_old_LIMITS_rec.attribute9)

266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
268: END IF;
269:
270: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute9, p_old_LIMITS_rec.attribute9)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
274: END IF;

Line 276: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.basis, p_old_LIMITS_rec.basis)

272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
274: END IF;
275:
276: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.basis, p_old_LIMITS_rec.basis)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
280: END IF;

Line 282: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.context, p_old_LIMITS_rec.context)

278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
280: END IF;
281:
282: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.context, p_old_LIMITS_rec.context)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
286: END IF;

Line 288: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.created_by, p_old_LIMITS_rec.created_by)

284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
286: END IF;
287:
288: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.created_by, p_old_LIMITS_rec.created_by)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
292: END IF;

Line 294: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.creation_date, p_old_LIMITS_rec.creation_date)

290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
292: END IF;
293:
294: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.creation_date, p_old_LIMITS_rec.creation_date)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
298: END IF;

Line 300: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)

296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
298: END IF;
299:
300: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
304: END IF;

Line 306: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)

302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
304: END IF;
305:
306: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
310: END IF;

Line 312: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)

308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
310: END IF;
311:
312: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
316: END IF;

Line 318: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code, p_old_LIMITS_rec.limit_exceed_action_code)

314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
316: END IF;
317:
318: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code, p_old_LIMITS_rec.limit_exceed_action_code)
319: THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;
322: END IF;

Line 325: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id, p_old_LIMITS_rec.limit_id)

321: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;
322: END IF;
323:
324:
325: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id, p_old_LIMITS_rec.limit_id)
326: THEN
327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;
329: END IF;

Line 331: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code, p_old_LIMITS_rec.limit_level_code)

327: l_index := l_index + 1;
328: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT;
329: END IF;
330:
331: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code, p_old_LIMITS_rec.limit_level_code)
332: THEN
333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;
335: END IF;

Line 337: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_number, p_old_LIMITS_rec.limit_number)

333: l_index := l_index + 1;
334: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_LEVEL;
335: END IF;
336:
337: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_number, p_old_LIMITS_rec.limit_number)
338: THEN
339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;
341: END IF;

Line 343: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id, p_old_LIMITS_rec.list_header_id)

339: l_index := l_index + 1;
340: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_NUMBER;
341: END IF;
342:
343: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id, p_old_LIMITS_rec.list_header_id)
344: THEN
345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;
347: END IF;

Line 349: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id, p_old_LIMITS_rec.list_line_id)

345: l_index := l_index + 1;
346: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_HEADER;
347: END IF;
348:
349: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id, p_old_LIMITS_rec.list_line_id)
350: THEN
351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;
353: END IF;

Line 355: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag, p_old_LIMITS_rec.organization_flag)

351: l_index := l_index + 1;
352: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;
353: END IF;
354:
355: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag, p_old_LIMITS_rec.organization_flag)
356: THEN
357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
359: END IF;

Line 361: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id, p_old_LIMITS_rec.program_application_id)

357: l_index := l_index + 1;
358: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
359: END IF;
360:
361: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id, p_old_LIMITS_rec.program_application_id)
362: THEN
363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
365: END IF;

Line 367: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_id, p_old_LIMITS_rec.program_id)

363: l_index := l_index + 1;
364: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
365: END IF;
366:
367: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_id, p_old_LIMITS_rec.program_id)
368: THEN
369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
371: END IF;

Line 373: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)

369: l_index := l_index + 1;
370: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
371: END IF;
372:
373: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)
374: THEN
375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
377: END IF;

Line 379: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.request_id, p_old_LIMITS_rec.request_id)

375: l_index := l_index + 1;
376: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
377: END IF;
378:
379: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.request_id, p_old_LIMITS_rec.request_id)
380: THEN
381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
383: END IF;

Line 385: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag, p_old_LIMITS_rec.limit_hold_flag)

381: l_index := l_index + 1;
382: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
383: END IF;
384:
385: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag, p_old_LIMITS_rec.limit_hold_flag)
386: THEN
387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
389: END IF;

Line 391: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type, p_old_LIMITS_rec.multival_attr1_type)

387: l_index := l_index + 1;
388: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
389: END IF;
390:
391: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type, p_old_LIMITS_rec.multival_attr1_type)
392: THEN
393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
395: END IF;

Line 397: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context, p_old_LIMITS_rec.multival_attr1_context)

393: l_index := l_index + 1;
394: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
395: END IF;
396:
397: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context, p_old_LIMITS_rec.multival_attr1_context)
398: THEN
399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
401: END IF;

Line 403: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1, p_old_LIMITS_rec.multival_attribute1)

399: l_index := l_index + 1;
400: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
401: END IF;
402:
403: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1, p_old_LIMITS_rec.multival_attribute1)
404: THEN
405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
407: END IF;

Line 409: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype, p_old_LIMITS_rec.multival_attr1_datatype)

405: l_index := l_index + 1;
406: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
407: END IF;
408:
409: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype, p_old_LIMITS_rec.multival_attr1_datatype)
410: THEN
411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
413: END IF;

Line 415: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type, p_old_LIMITS_rec.multival_attr2_type)

411: l_index := l_index + 1;
412: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
413: END IF;
414:
415: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type, p_old_LIMITS_rec.multival_attr2_type)
416: THEN
417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
419: END IF;

Line 421: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context, p_old_LIMITS_rec.multival_attr2_context)

417: l_index := l_index + 1;
418: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
419: END IF;
420:
421: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context, p_old_LIMITS_rec.multival_attr2_context)
422: THEN
423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
425: END IF;

Line 427: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2, p_old_LIMITS_rec.multival_attribute2)

423: l_index := l_index + 1;
424: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
425: END IF;
426:
427: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2, p_old_LIMITS_rec.multival_attribute2)
428: THEN
429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
431: END IF;

Line 433: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype, p_old_LIMITS_rec.multival_attr2_datatype)

429: l_index := l_index + 1;
430: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
431: END IF;
432:
433: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype, p_old_LIMITS_rec.multival_attr2_datatype)
434: THEN
435: l_index := l_index + 1;
436: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
437: END IF;

Line 587: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)

583: -- Load out record
584:
585: x_LIMITS_rec := p_LIMITS_rec;
586:
587: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)
588: THEN
589: NULL;
590: END IF;
591:

Line 592: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)

588: THEN
589: NULL;
590: END IF;
591:
592: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)
593: THEN
594: NULL;
595: END IF;
596:

Line 597: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)

593: THEN
594: NULL;
595: END IF;
596:
597: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)
598: THEN
599: NULL;
600: END IF;
601:

Line 602: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)

598: THEN
599: NULL;
600: END IF;
601:
602: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)
603: THEN
604: NULL;
605: END IF;
606:

Line 607: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)

603: THEN
604: NULL;
605: END IF;
606:
607: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)
608: THEN
609: NULL;
610: END IF;
611:

Line 612: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)

608: THEN
609: NULL;
610: END IF;
611:
612: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)
613: THEN
614: NULL;
615: END IF;
616:

Line 617: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)

613: THEN
614: NULL;
615: END IF;
616:
617: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)
618: THEN
619: NULL;
620: END IF;
621:

Line 622: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute15, p_old_LIMITS_rec.attribute15)

618: THEN
619: NULL;
620: END IF;
621:
622: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute15, p_old_LIMITS_rec.attribute15)
623: THEN
624: NULL;
625: END IF;
626:

Line 627: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute2, p_old_LIMITS_rec.attribute2)

623: THEN
624: NULL;
625: END IF;
626:
627: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute2, p_old_LIMITS_rec.attribute2)
628: THEN
629: NULL;
630: END IF;
631:

Line 632: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute3, p_old_LIMITS_rec.attribute3)

628: THEN
629: NULL;
630: END IF;
631:
632: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute3, p_old_LIMITS_rec.attribute3)
633: THEN
634: NULL;
635: END IF;
636:

Line 637: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute4, p_old_LIMITS_rec.attribute4)

633: THEN
634: NULL;
635: END IF;
636:
637: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute4, p_old_LIMITS_rec.attribute4)
638: THEN
639: NULL;
640: END IF;
641:

Line 642: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute5, p_old_LIMITS_rec.attribute5)

638: THEN
639: NULL;
640: END IF;
641:
642: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute5, p_old_LIMITS_rec.attribute5)
643: THEN
644: NULL;
645: END IF;
646:

Line 647: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute6, p_old_LIMITS_rec.attribute6)

643: THEN
644: NULL;
645: END IF;
646:
647: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute6, p_old_LIMITS_rec.attribute6)
648: THEN
649: NULL;
650: END IF;
651:

Line 652: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute7, p_old_LIMITS_rec.attribute7)

648: THEN
649: NULL;
650: END IF;
651:
652: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute7, p_old_LIMITS_rec.attribute7)
653: THEN
654: NULL;
655: END IF;
656:

Line 657: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute8, p_old_LIMITS_rec.attribute8)

653: THEN
654: NULL;
655: END IF;
656:
657: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute8, p_old_LIMITS_rec.attribute8)
658: THEN
659: NULL;
660: END IF;
661:

Line 662: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute9, p_old_LIMITS_rec.attribute9)

658: THEN
659: NULL;
660: END IF;
661:
662: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute9, p_old_LIMITS_rec.attribute9)
663: THEN
664: NULL;
665: END IF;
666:

Line 667: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.basis, p_old_LIMITS_rec.basis)

663: THEN
664: NULL;
665: END IF;
666:
667: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.basis, p_old_LIMITS_rec.basis)
668: THEN
669: NULL;
670: END IF;
671:

Line 672: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.context, p_old_LIMITS_rec.context)

668: THEN
669: NULL;
670: END IF;
671:
672: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.context, p_old_LIMITS_rec.context)
673: THEN
674: NULL;
675: END IF;
676:

Line 677: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.created_by, p_old_LIMITS_rec.created_by)

673: THEN
674: NULL;
675: END IF;
676:
677: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.created_by, p_old_LIMITS_rec.created_by)
678: THEN
679: NULL;
680: END IF;
681:

Line 682: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.creation_date, p_old_LIMITS_rec.creation_date)

678: THEN
679: NULL;
680: END IF;
681:
682: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.creation_date, p_old_LIMITS_rec.creation_date)
683: THEN
684: NULL;
685: END IF;
686:

Line 687: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)

683: THEN
684: NULL;
685: END IF;
686:
687: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)
688: THEN
689: NULL;
690: END IF;
691:

Line 692: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)

688: THEN
689: NULL;
690: END IF;
691:
692: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)
693: THEN
694: NULL;
695: END IF;
696:

Line 697: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)

693: THEN
694: NULL;
695: END IF;
696:
697: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)
698: THEN
699: NULL;
700: END IF;
701:

Line 702: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code, p_old_LIMITS_rec.limit_exceed_action_code)

698: THEN
699: NULL;
700: END IF;
701:
702: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code, p_old_LIMITS_rec.limit_exceed_action_code)
703: THEN
704: NULL;
705: END IF;
706:

Line 707: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id, p_old_LIMITS_rec.limit_id)

703: THEN
704: NULL;
705: END IF;
706:
707: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id, p_old_LIMITS_rec.limit_id)
708: THEN
709: NULL;
710: END IF;
711:

Line 712: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code, p_old_LIMITS_rec.limit_level_code)

708: THEN
709: NULL;
710: END IF;
711:
712: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code, p_old_LIMITS_rec.limit_level_code)
713: THEN
714: NULL;
715: END IF;
716:

Line 717: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_number, p_old_LIMITS_rec.limit_number)

713: THEN
714: NULL;
715: END IF;
716:
717: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_number, p_old_LIMITS_rec.limit_number)
718: THEN
719: NULL;
720: END IF;
721:

Line 722: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id, p_old_LIMITS_rec.list_header_id)

718: THEN
719: NULL;
720: END IF;
721:
722: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id, p_old_LIMITS_rec.list_header_id)
723: THEN
724: NULL;
725: END IF;
726:

Line 727: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id, p_old_LIMITS_rec.list_line_id)

723: THEN
724: NULL;
725: END IF;
726:
727: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id, p_old_LIMITS_rec.list_line_id)
728: THEN
729: NULL;
730: END IF;
731:

Line 732: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag, p_old_LIMITS_rec.organization_flag)

728: THEN
729: NULL;
730: END IF;
731:
732: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag, p_old_LIMITS_rec.organization_flag)
733: THEN
734: NULL;
735: END IF;
736:

Line 737: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id, p_old_LIMITS_rec.program_application_id)

733: THEN
734: NULL;
735: END IF;
736:
737: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id, p_old_LIMITS_rec.program_application_id)
738: THEN
739: NULL;
740: END IF;
741:

Line 742: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_id, p_old_LIMITS_rec.program_id)

738: THEN
739: NULL;
740: END IF;
741:
742: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_id, p_old_LIMITS_rec.program_id)
743: THEN
744: NULL;
745: END IF;
746:

Line 747: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)

743: THEN
744: NULL;
745: END IF;
746:
747: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)
748: THEN
749: NULL;
750: END IF;
751:

Line 752: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.request_id, p_old_LIMITS_rec.request_id)

748: THEN
749: NULL;
750: END IF;
751:
752: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.request_id, p_old_LIMITS_rec.request_id)
753: THEN
754: NULL;
755: END IF;
756:

Line 757: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag, p_old_LIMITS_rec.limit_hold_flag)

753: THEN
754: NULL;
755: END IF;
756:
757: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag, p_old_LIMITS_rec.limit_hold_flag)
758: THEN
759: NULL;
760: END IF;
761:

Line 762: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type, p_old_LIMITS_rec.multival_attr1_type)

758: THEN
759: NULL;
760: END IF;
761:
762: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type, p_old_LIMITS_rec.multival_attr1_type)
763: THEN
764: NULL;
765: END IF;
766:

Line 767: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context, p_old_LIMITS_rec.multival_attr1_context)

763: THEN
764: NULL;
765: END IF;
766:
767: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context, p_old_LIMITS_rec.multival_attr1_context)
768: THEN
769: NULL;
770: END IF;
771:

Line 772: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1, p_old_LIMITS_rec.multival_attribute1)

768: THEN
769: NULL;
770: END IF;
771:
772: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1, p_old_LIMITS_rec.multival_attribute1)
773: THEN
774: NULL;
775: END IF;
776:

Line 777: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype, p_old_LIMITS_rec.multival_attr1_datatype)

773: THEN
774: NULL;
775: END IF;
776:
777: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype, p_old_LIMITS_rec.multival_attr1_datatype)
778: THEN
779: NULL;
780: END IF;
781:

Line 782: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type, p_old_LIMITS_rec.multival_attr2_type)

778: THEN
779: NULL;
780: END IF;
781:
782: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type, p_old_LIMITS_rec.multival_attr2_type)
783: THEN
784: NULL;
785: END IF;
786:

Line 787: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context, p_old_LIMITS_rec.multival_attr2_context)

783: THEN
784: NULL;
785: END IF;
786:
787: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context, p_old_LIMITS_rec.multival_attr2_context)
788: THEN
789: NULL;
790: END IF;
791:

Line 792: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2, p_old_LIMITS_rec.multival_attribute2)

788: THEN
789: NULL;
790: END IF;
791:
792: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2, p_old_LIMITS_rec.multival_attribute2)
793: THEN
794: NULL;
795: END IF;
796:

Line 797: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype, p_old_LIMITS_rec.multival_attr2_datatype)

793: THEN
794: NULL;
795: END IF;
796:
797: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype, p_old_LIMITS_rec.multival_attr2_datatype)
798: THEN
799: NULL;
800: END IF;
801:

Line 1244: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_update;

1240: , PROGRAM_UPDATE_DATE = p_LIMITS_rec.program_update_date
1241: , REQUEST_ID = p_LIMITS_rec.request_id
1242: WHERE LIMIT_ID = p_LIMITS_rec.limit_id
1243: ;
1244: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_update;
1245:
1246: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1247: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1248:

Line 1279: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount

1275:
1276: Update_List_Header_And_Line(l_LIMITS_rec);
1277:
1278:
1279: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount
1280: ,l_limits_rec1.amount)
1281: THEN
1282: QP_LIMIT_CONC_REQ.UPDATE_BALANCES(x_retcode
1283: ,x_errbuf

Line 1425: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_create;

1421: , p_LIMITS_rec.program_id
1422: , p_LIMITS_rec.program_update_date
1423: , p_LIMITS_rec.request_id
1424: );
1425: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_create;
1426: Update_List_Header_And_Line(l_LIMITS_rec);
1427: --dbms_output.put_line('End Insert Row');
1428: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1429: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN

Line 1485: l_limits_rec.operation := QP_GLOBALS.g_opr_delete;

1481: BEGIN
1482:
1483: l_limits_rec := Query_Row(p_limit_id);
1484:
1485: l_limits_rec.operation := QP_GLOBALS.g_opr_delete;
1486: --dbms_output.put_line('In Delete_Row ..' || 'Header ' || l_limits_rec.list_header_id || ' line ' || l_limits_rec.list_line_id);
1487:
1488: DELETE FROM QP_LIMITS
1489: WHERE LIMIT_ID = p_limit_id;

Line 1735: IF QP_GLOBALS.Equal(p_LIMITS_rec.amount,

1731: FOR UPDATE NOWAIT;
1732:
1733: -- Row locked. Compare IN attributes to DB attributes.
1734:
1735: IF QP_GLOBALS.Equal(p_LIMITS_rec.amount,
1736: l_LIMITS_rec.amount)
1737: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1738: l_LIMITS_rec.attribute1)
1739: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,

Line 1737: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,

1733: -- Row locked. Compare IN attributes to DB attributes.
1734:
1735: IF QP_GLOBALS.Equal(p_LIMITS_rec.amount,
1736: l_LIMITS_rec.amount)
1737: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1738: l_LIMITS_rec.attribute1)
1739: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1740: l_LIMITS_rec.attribute10)
1741: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,

Line 1739: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,

1735: IF QP_GLOBALS.Equal(p_LIMITS_rec.amount,
1736: l_LIMITS_rec.amount)
1737: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1738: l_LIMITS_rec.attribute1)
1739: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1740: l_LIMITS_rec.attribute10)
1741: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1742: l_LIMITS_rec.attribute11)
1743: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,

Line 1741: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,

1737: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1738: l_LIMITS_rec.attribute1)
1739: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1740: l_LIMITS_rec.attribute10)
1741: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1742: l_LIMITS_rec.attribute11)
1743: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1744: l_LIMITS_rec.attribute12)
1745: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,

Line 1743: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,

1739: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1740: l_LIMITS_rec.attribute10)
1741: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1742: l_LIMITS_rec.attribute11)
1743: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1744: l_LIMITS_rec.attribute12)
1745: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1746: l_LIMITS_rec.attribute13)
1747: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,

Line 1745: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,

1741: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1742: l_LIMITS_rec.attribute11)
1743: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1744: l_LIMITS_rec.attribute12)
1745: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1746: l_LIMITS_rec.attribute13)
1747: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1748: l_LIMITS_rec.attribute14)
1749: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,

Line 1747: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,

1743: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1744: l_LIMITS_rec.attribute12)
1745: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1746: l_LIMITS_rec.attribute13)
1747: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1748: l_LIMITS_rec.attribute14)
1749: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1750: l_LIMITS_rec.attribute15)
1751: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,

Line 1749: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,

1745: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1746: l_LIMITS_rec.attribute13)
1747: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1748: l_LIMITS_rec.attribute14)
1749: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1750: l_LIMITS_rec.attribute15)
1751: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1752: l_LIMITS_rec.attribute2)
1753: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,

Line 1751: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,

1747: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1748: l_LIMITS_rec.attribute14)
1749: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1750: l_LIMITS_rec.attribute15)
1751: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1752: l_LIMITS_rec.attribute2)
1753: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1754: l_LIMITS_rec.attribute3)
1755: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,

Line 1753: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,

1749: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1750: l_LIMITS_rec.attribute15)
1751: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1752: l_LIMITS_rec.attribute2)
1753: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1754: l_LIMITS_rec.attribute3)
1755: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1756: l_LIMITS_rec.attribute4)
1757: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,

Line 1755: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,

1751: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1752: l_LIMITS_rec.attribute2)
1753: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1754: l_LIMITS_rec.attribute3)
1755: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1756: l_LIMITS_rec.attribute4)
1757: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1758: l_LIMITS_rec.attribute5)
1759: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,

Line 1757: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,

1753: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1754: l_LIMITS_rec.attribute3)
1755: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1756: l_LIMITS_rec.attribute4)
1757: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1758: l_LIMITS_rec.attribute5)
1759: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1760: l_LIMITS_rec.attribute6)
1761: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,

Line 1759: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,

1755: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1756: l_LIMITS_rec.attribute4)
1757: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1758: l_LIMITS_rec.attribute5)
1759: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1760: l_LIMITS_rec.attribute6)
1761: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1762: l_LIMITS_rec.attribute7)
1763: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,

Line 1761: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,

1757: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1758: l_LIMITS_rec.attribute5)
1759: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1760: l_LIMITS_rec.attribute6)
1761: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1762: l_LIMITS_rec.attribute7)
1763: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1764: l_LIMITS_rec.attribute8)
1765: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,

Line 1763: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,

1759: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1760: l_LIMITS_rec.attribute6)
1761: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1762: l_LIMITS_rec.attribute7)
1763: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1764: l_LIMITS_rec.attribute8)
1765: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1766: l_LIMITS_rec.attribute9)
1767: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,

Line 1765: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,

1761: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1762: l_LIMITS_rec.attribute7)
1763: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1764: l_LIMITS_rec.attribute8)
1765: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1766: l_LIMITS_rec.attribute9)
1767: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1768: l_LIMITS_rec.basis)
1769: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,

Line 1767: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,

1763: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1764: l_LIMITS_rec.attribute8)
1765: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1766: l_LIMITS_rec.attribute9)
1767: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1768: l_LIMITS_rec.basis)
1769: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1770: l_LIMITS_rec.context)
1771: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,

Line 1769: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,

1765: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1766: l_LIMITS_rec.attribute9)
1767: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1768: l_LIMITS_rec.basis)
1769: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1770: l_LIMITS_rec.context)
1771: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1772: l_LIMITS_rec.created_by)
1773: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,

Line 1771: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,

1767: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1768: l_LIMITS_rec.basis)
1769: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1770: l_LIMITS_rec.context)
1771: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1772: l_LIMITS_rec.created_by)
1773: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1774: l_LIMITS_rec.creation_date)
1775: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,

Line 1773: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,

1769: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1770: l_LIMITS_rec.context)
1771: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1772: l_LIMITS_rec.created_by)
1773: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1774: l_LIMITS_rec.creation_date)
1775: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1776: l_LIMITS_rec.last_updated_by)
1777: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,

Line 1775: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,

1771: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1772: l_LIMITS_rec.created_by)
1773: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1774: l_LIMITS_rec.creation_date)
1775: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1776: l_LIMITS_rec.last_updated_by)
1777: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1778: l_LIMITS_rec.last_update_date)
1779: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,

Line 1777: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,

1773: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1774: l_LIMITS_rec.creation_date)
1775: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1776: l_LIMITS_rec.last_updated_by)
1777: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1778: l_LIMITS_rec.last_update_date)
1779: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1780: l_LIMITS_rec.last_update_login)
1781: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,

Line 1779: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,

1775: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1776: l_LIMITS_rec.last_updated_by)
1777: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1778: l_LIMITS_rec.last_update_date)
1779: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1780: l_LIMITS_rec.last_update_login)
1781: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1782: l_LIMITS_rec.limit_exceed_action_code)
1783: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,

Line 1781: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,

1777: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1778: l_LIMITS_rec.last_update_date)
1779: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1780: l_LIMITS_rec.last_update_login)
1781: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1782: l_LIMITS_rec.limit_exceed_action_code)
1783: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1784: l_LIMITS_rec.limit_hold_flag)
1785: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,

Line 1783: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,

1779: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1780: l_LIMITS_rec.last_update_login)
1781: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1782: l_LIMITS_rec.limit_exceed_action_code)
1783: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1784: l_LIMITS_rec.limit_hold_flag)
1785: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1786: l_LIMITS_rec.limit_id)
1787: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,

Line 1785: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,

1781: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1782: l_LIMITS_rec.limit_exceed_action_code)
1783: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1784: l_LIMITS_rec.limit_hold_flag)
1785: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1786: l_LIMITS_rec.limit_id)
1787: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1788: l_LIMITS_rec.limit_level_code)
1789: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,

Line 1787: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,

1783: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1784: l_LIMITS_rec.limit_hold_flag)
1785: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1786: l_LIMITS_rec.limit_id)
1787: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1788: l_LIMITS_rec.limit_level_code)
1789: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1790: l_LIMITS_rec.limit_number)
1791: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,

Line 1789: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,

1785: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1786: l_LIMITS_rec.limit_id)
1787: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1788: l_LIMITS_rec.limit_level_code)
1789: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1790: l_LIMITS_rec.limit_number)
1791: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1792: l_LIMITS_rec.list_header_id)
1793: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,

Line 1791: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,

1787: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1788: l_LIMITS_rec.limit_level_code)
1789: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1790: l_LIMITS_rec.limit_number)
1791: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1792: l_LIMITS_rec.list_header_id)
1793: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1794: l_LIMITS_rec.list_line_id)
1795: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,

Line 1793: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,

1789: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1790: l_LIMITS_rec.limit_number)
1791: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1792: l_LIMITS_rec.list_header_id)
1793: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1794: l_LIMITS_rec.list_line_id)
1795: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1796: l_LIMITS_rec.multival_attr1_type)
1797: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,

Line 1795: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,

1791: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1792: l_LIMITS_rec.list_header_id)
1793: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1794: l_LIMITS_rec.list_line_id)
1795: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1796: l_LIMITS_rec.multival_attr1_type)
1797: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1798: l_LIMITS_rec.multival_attr1_context)
1799: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,

Line 1797: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,

1793: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1794: l_LIMITS_rec.list_line_id)
1795: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1796: l_LIMITS_rec.multival_attr1_type)
1797: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1798: l_LIMITS_rec.multival_attr1_context)
1799: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1800: l_LIMITS_rec.multival_attribute1)
1801: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,

Line 1799: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,

1795: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1796: l_LIMITS_rec.multival_attr1_type)
1797: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1798: l_LIMITS_rec.multival_attr1_context)
1799: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1800: l_LIMITS_rec.multival_attribute1)
1801: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1802: l_LIMITS_rec.multival_attr1_datatype)
1803: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,

Line 1801: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,

1797: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1798: l_LIMITS_rec.multival_attr1_context)
1799: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1800: l_LIMITS_rec.multival_attribute1)
1801: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1802: l_LIMITS_rec.multival_attr1_datatype)
1803: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1804: l_LIMITS_rec.multival_attr2_type)
1805: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,

Line 1803: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,

1799: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1800: l_LIMITS_rec.multival_attribute1)
1801: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1802: l_LIMITS_rec.multival_attr1_datatype)
1803: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1804: l_LIMITS_rec.multival_attr2_type)
1805: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1806: l_LIMITS_rec.multival_attr2_context)
1807: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,

Line 1805: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,

1801: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1802: l_LIMITS_rec.multival_attr1_datatype)
1803: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1804: l_LIMITS_rec.multival_attr2_type)
1805: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1806: l_LIMITS_rec.multival_attr2_context)
1807: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1808: l_LIMITS_rec.multival_attribute2)
1809: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,

Line 1807: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,

1803: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1804: l_LIMITS_rec.multival_attr2_type)
1805: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1806: l_LIMITS_rec.multival_attr2_context)
1807: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1808: l_LIMITS_rec.multival_attribute2)
1809: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1810: l_LIMITS_rec.multival_attr2_datatype)
1811: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,

Line 1809: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,

1805: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1806: l_LIMITS_rec.multival_attr2_context)
1807: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1808: l_LIMITS_rec.multival_attribute2)
1809: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1810: l_LIMITS_rec.multival_attr2_datatype)
1811: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1812: l_LIMITS_rec.organization_flag)
1813: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,

Line 1811: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,

1807: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1808: l_LIMITS_rec.multival_attribute2)
1809: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1810: l_LIMITS_rec.multival_attr2_datatype)
1811: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1812: l_LIMITS_rec.organization_flag)
1813: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1814: l_LIMITS_rec.program_application_id)
1815: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,

Line 1813: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,

1809: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1810: l_LIMITS_rec.multival_attr2_datatype)
1811: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1812: l_LIMITS_rec.organization_flag)
1813: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1814: l_LIMITS_rec.program_application_id)
1815: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1816: l_LIMITS_rec.program_id)
1817: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,

Line 1815: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,

1811: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1812: l_LIMITS_rec.organization_flag)
1813: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1814: l_LIMITS_rec.program_application_id)
1815: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1816: l_LIMITS_rec.program_id)
1817: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,
1818: l_LIMITS_rec.program_update_date)
1819: AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,

Line 1817: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,

1813: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1814: l_LIMITS_rec.program_application_id)
1815: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1816: l_LIMITS_rec.program_id)
1817: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,
1818: l_LIMITS_rec.program_update_date)
1819: AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,
1820: l_LIMITS_rec.request_id)
1821: THEN

Line 1819: AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,

1815: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1816: l_LIMITS_rec.program_id)
1817: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,
1818: l_LIMITS_rec.program_update_date)
1819: AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,
1820: l_LIMITS_rec.request_id)
1821: THEN
1822:
1823: -- Row has not changed. Set out parameter.

Line 1903: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,

1899: BEGIN
1900:
1901: IF p_LIMITS_rec.limit_exceed_action_code IS NOT NULL AND
1902: p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR AND
1903: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1904: p_old_LIMITS_rec.limit_exceed_action_code)
1905: THEN
1906: l_LIMITS_val_rec.limit_exceed_action := QP_Id_To_Value.Limit_Exceed_Action
1907: ( p_limit_exceed_action_code => p_LIMITS_rec.limit_exceed_action_code

Line 1913: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,

1909: END IF;
1910:
1911: IF p_LIMITS_rec.limit_id IS NOT NULL AND
1912: p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM AND
1913: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1914: p_old_LIMITS_rec.limit_id)
1915: THEN
1916: l_LIMITS_val_rec.limit := QP_Id_To_Value.Limit
1917: ( p_limit_id => p_LIMITS_rec.limit_id

Line 1923: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,

1919: END IF;
1920:
1921: IF p_LIMITS_rec.limit_level_code IS NOT NULL AND
1922: p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR AND
1923: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1924: p_old_LIMITS_rec.limit_level_code)
1925: THEN
1926: l_LIMITS_val_rec.limit_level := QP_Id_To_Value.Limit_Level
1927: ( p_limit_level_code => p_LIMITS_rec.limit_level_code

Line 1933: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,

1929: END IF;
1930:
1931: IF p_LIMITS_rec.list_header_id IS NOT NULL AND
1932: p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM AND
1933: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1934: p_old_LIMITS_rec.list_header_id)
1935: THEN
1936: l_LIMITS_val_rec.list_header := QP_Id_To_Value.List_Header
1937: ( p_list_header_id => p_LIMITS_rec.list_header_id

Line 1943: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,

1939: END IF;
1940:
1941: IF p_LIMITS_rec.list_line_id IS NOT NULL AND
1942: p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM AND
1943: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1944: p_old_LIMITS_rec.list_line_id)
1945: THEN
1946: l_LIMITS_val_rec.list_line := QP_Id_To_Value.List_Line
1947: ( p_list_line_id => p_LIMITS_rec.list_line_id

Line 1953: NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,

1949: END IF;
1950:
1951: IF p_LIMITS_rec.organization_flag IS NOT NULL AND
1952: p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR AND
1953: NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1954: p_old_LIMITS_rec.organization_flag)
1955: THEN
1956: l_LIMITS_val_rec.organization := QP_Id_To_Value.Organization
1957: ( p_organization_flag => p_LIMITS_rec.organization_flag

Line 2185: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2181:
2182:
2183: qp_delayed_requests_PVT.log_request
2184: (
2185: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2186: p_entity_id => p_LIMITS_rec.limit_id,
2187: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2188: p_requesting_entity_id => p_LIMITS_rec.limit_id,
2189: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,

Line 2187: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

2183: qp_delayed_requests_PVT.log_request
2184: (
2185: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2186: p_entity_id => p_LIMITS_rec.limit_id,
2187: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2188: p_requesting_entity_id => p_LIMITS_rec.limit_id,
2189: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,
2190: x_return_status => l_return_status
2191: );

Line 2189: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,

2185: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2186: p_entity_id => p_LIMITS_rec.limit_id,
2187: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2188: p_requesting_entity_id => p_LIMITS_rec.limit_id,
2189: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,
2190: x_return_status => l_return_status
2191: );
2192:
2193: null;