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 136: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

132: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
133: )
134: IS
135: l_index NUMBER := 0;
136: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
137: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
138: BEGIN
139:
140: -- Load out record

Line 137: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

133: )
134: IS
135: l_index NUMBER := 0;
136: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
137: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
138: BEGIN
139:
140: -- Load out record
141:

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

145: -- every changed attribute clear its dependent fields.
146:
147: IF p_attr_id = FND_API.G_MISS_NUM THEN
148:
149: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)
150: THEN
151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;
153: END IF;

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

151: l_index := l_index + 1;
152: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_AMOUNT;
153: END IF;
154:
155: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)
156: THEN
157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
159: END IF;

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

157: l_index := l_index + 1;
158: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE1;
159: END IF;
160:
161: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)
162: THEN
163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
165: END IF;

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

163: l_index := l_index + 1;
164: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE10;
165: END IF;
166:
167: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)
168: THEN
169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
171: END IF;

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

169: l_index := l_index + 1;
170: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE11;
171: END IF;
172:
173: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)
174: THEN
175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
177: END IF;

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

175: l_index := l_index + 1;
176: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE12;
177: END IF;
178:
179: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)
180: THEN
181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
183: END IF;

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

181: l_index := l_index + 1;
182: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE13;
183: END IF;
184:
185: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)
186: THEN
187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
189: END IF;

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

187: l_index := l_index + 1;
188: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE14;
189: END IF;
190:
191: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute15, p_old_LIMITS_rec.attribute15)
192: THEN
193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
195: END IF;

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

193: l_index := l_index + 1;
194: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE15;
195: END IF;
196:
197: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute2, p_old_LIMITS_rec.attribute2)
198: THEN
199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
201: END IF;

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

199: l_index := l_index + 1;
200: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE2;
201: END IF;
202:
203: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute3, p_old_LIMITS_rec.attribute3)
204: THEN
205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
207: END IF;

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

205: l_index := l_index + 1;
206: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE3;
207: END IF;
208:
209: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute4, p_old_LIMITS_rec.attribute4)
210: THEN
211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
213: END IF;

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

211: l_index := l_index + 1;
212: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE4;
213: END IF;
214:
215: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute5, p_old_LIMITS_rec.attribute5)
216: THEN
217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
219: END IF;

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

217: l_index := l_index + 1;
218: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE5;
219: END IF;
220:
221: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute6, p_old_LIMITS_rec.attribute6)
222: THEN
223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
225: END IF;

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

223: l_index := l_index + 1;
224: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE6;
225: END IF;
226:
227: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute7, p_old_LIMITS_rec.attribute7)
228: THEN
229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
231: END IF;

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

229: l_index := l_index + 1;
230: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE7;
231: END IF;
232:
233: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute8, p_old_LIMITS_rec.attribute8)
234: THEN
235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
237: END IF;

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

235: l_index := l_index + 1;
236: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE8;
237: END IF;
238:
239: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute9, p_old_LIMITS_rec.attribute9)
240: THEN
241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
243: END IF;

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

241: l_index := l_index + 1;
242: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ATTRIBUTE9;
243: END IF;
244:
245: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.basis, p_old_LIMITS_rec.basis)
246: THEN
247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
249: END IF;

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

247: l_index := l_index + 1;
248: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_BASIS;
249: END IF;
250:
251: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.context, p_old_LIMITS_rec.context)
252: THEN
253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
255: END IF;

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

253: l_index := l_index + 1;
254: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CONTEXT;
255: END IF;
256:
257: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.created_by, p_old_LIMITS_rec.created_by)
258: THEN
259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
261: END IF;

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

259: l_index := l_index + 1;
260: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATED_BY;
261: END IF;
262:
263: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.creation_date, p_old_LIMITS_rec.creation_date)
264: THEN
265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
267: END IF;

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

265: l_index := l_index + 1;
266: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_CREATION_DATE;
267: END IF;
268:
269: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by, p_old_LIMITS_rec.last_updated_by)
270: THEN
271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
273: END IF;

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

271: l_index := l_index + 1;
272: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATED_BY;
273: END IF;
274:
275: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date, p_old_LIMITS_rec.last_update_date)
276: THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
279: END IF;

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

277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_DATE;
279: END IF;
280:
281: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login, p_old_LIMITS_rec.last_update_login)
282: THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
285: END IF;

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

283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LAST_UPDATE_LOGIN;
285: END IF;
286:
287: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code, p_old_LIMITS_rec.limit_exceed_action_code)
288: THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_EXCEED_ACTION;
291: END IF;

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

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

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

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

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

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

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

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

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

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

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

320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIST_LINE;
322: END IF;
323:
324: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag, p_old_LIMITS_rec.organization_flag)
325: THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
328: END IF;

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

326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_ORGANIZATION;
328: END IF;
329:
330: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id, p_old_LIMITS_rec.program_application_id)
331: THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
334: END IF;

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

332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_APPLICATION;
334: END IF;
335:
336: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_id, p_old_LIMITS_rec.program_id)
337: THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
340: END IF;

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

338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM;
340: END IF;
341:
342: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date, p_old_LIMITS_rec.program_update_date)
343: THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
346: END IF;

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

344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_PROGRAM_UPDATE_DATE;
346: END IF;
347:
348: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.request_id, p_old_LIMITS_rec.request_id)
349: THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
352: END IF;

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

350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_REQUEST;
352: END IF;
353:
354: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag, p_old_LIMITS_rec.limit_hold_flag)
355: THEN
356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
358: END IF;

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

356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_LIMIT_HOLD;
358: END IF;
359:
360: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type, p_old_LIMITS_rec.multival_attr1_type)
361: THEN
362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
364: END IF;

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

362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_TYPE;
364: END IF;
365:
366: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context, p_old_LIMITS_rec.multival_attr1_context)
367: THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
370: END IF;

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

368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_CONTEXT;
370: END IF;
371:
372: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1, p_old_LIMITS_rec.multival_attribute1)
373: THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
376: END IF;

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

374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE1;
376: END IF;
377:
378: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype, p_old_LIMITS_rec.multival_attr1_datatype)
379: THEN
380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
382: END IF;

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

380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR1_DATATYPE;
382: END IF;
383:
384: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type, p_old_LIMITS_rec.multival_attr2_type)
385: THEN
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
388: END IF;

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

386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_TYPE;
388: END IF;
389:
390: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context, p_old_LIMITS_rec.multival_attr2_context)
391: THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
394: END IF;

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

392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_CONTEXT;
394: END IF;
395:
396: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2, p_old_LIMITS_rec.multival_attribute2)
397: THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
400: END IF;

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

398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTRIBUTE2;
400: END IF;
401:
402: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype, p_old_LIMITS_rec.multival_attr2_datatype)
403: THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := QP_LIMITS_UTIL.G_MULTIVAL_ATTR2_DATATYPE;
406: END IF;

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

552: -- Load out record
553:
554: x_LIMITS_rec := p_LIMITS_rec;
555:
556: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount, p_old_LIMITS_rec.amount)
557: THEN
558: NULL;
559: END IF;
560:

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

557: THEN
558: NULL;
559: END IF;
560:
561: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute1, p_old_LIMITS_rec.attribute1)
562: THEN
563: NULL;
564: END IF;
565:

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

562: THEN
563: NULL;
564: END IF;
565:
566: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute10, p_old_LIMITS_rec.attribute10)
567: THEN
568: NULL;
569: END IF;
570:

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

567: THEN
568: NULL;
569: END IF;
570:
571: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute11, p_old_LIMITS_rec.attribute11)
572: THEN
573: NULL;
574: END IF;
575:

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

572: THEN
573: NULL;
574: END IF;
575:
576: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute12, p_old_LIMITS_rec.attribute12)
577: THEN
578: NULL;
579: END IF;
580:

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

577: THEN
578: NULL;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute13, p_old_LIMITS_rec.attribute13)
582: THEN
583: NULL;
584: END IF;
585:

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

582: THEN
583: NULL;
584: END IF;
585:
586: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.attribute14, p_old_LIMITS_rec.attribute14)
587: THEN
588: NULL;
589: END IF;
590:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1209: , PROGRAM_UPDATE_DATE = p_LIMITS_rec.program_update_date
1210: , REQUEST_ID = p_LIMITS_rec.request_id
1211: WHERE LIMIT_ID = p_LIMITS_rec.limit_id
1212: ;
1213: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_update;
1214:
1215: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1216: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1217:

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

1244:
1245: Update_List_Header_And_Line(l_LIMITS_rec);
1246:
1247:
1248: IF NOT QP_GLOBALS.Equal(p_LIMITS_rec.amount
1249: ,l_limits_rec1.amount)
1250: THEN
1251: QP_LIMIT_CONC_REQ.UPDATE_BALANCES(x_retcode
1252: ,x_errbuf

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

1390: , p_LIMITS_rec.program_id
1391: , p_LIMITS_rec.program_update_date
1392: , p_LIMITS_rec.request_id
1393: );
1394: l_LIMITS_rec.operation := QP_GLOBALS.g_opr_create;
1395: Update_List_Header_And_Line(l_LIMITS_rec);
1396: --dbms_output.put_line('End Insert Row');
1397: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
1398: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN

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

1450: BEGIN
1451:
1452: l_limits_rec := Query_Row(p_limit_id);
1453:
1454: l_limits_rec.operation := QP_GLOBALS.g_opr_delete;
1455: --dbms_output.put_line('In Delete_Row ..' || 'Header ' || l_limits_rec.list_header_id || ' line ' || l_limits_rec.list_line_id);
1456:
1457: DELETE FROM QP_LIMITS
1458: WHERE LIMIT_ID = p_limit_id;

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

1700: FOR UPDATE NOWAIT;
1701:
1702: -- Row locked. Compare IN attributes to DB attributes.
1703:
1704: IF QP_GLOBALS.Equal(p_LIMITS_rec.amount,
1705: l_LIMITS_rec.amount)
1706: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1707: l_LIMITS_rec.attribute1)
1708: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,

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

1702: -- Row locked. Compare IN attributes to DB attributes.
1703:
1704: IF QP_GLOBALS.Equal(p_LIMITS_rec.amount,
1705: l_LIMITS_rec.amount)
1706: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1707: l_LIMITS_rec.attribute1)
1708: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1709: l_LIMITS_rec.attribute10)
1710: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,

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

1704: IF QP_GLOBALS.Equal(p_LIMITS_rec.amount,
1705: l_LIMITS_rec.amount)
1706: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1707: l_LIMITS_rec.attribute1)
1708: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1709: l_LIMITS_rec.attribute10)
1710: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1711: l_LIMITS_rec.attribute11)
1712: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,

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

1706: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute1,
1707: l_LIMITS_rec.attribute1)
1708: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1709: l_LIMITS_rec.attribute10)
1710: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1711: l_LIMITS_rec.attribute11)
1712: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1713: l_LIMITS_rec.attribute12)
1714: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,

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

1708: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute10,
1709: l_LIMITS_rec.attribute10)
1710: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1711: l_LIMITS_rec.attribute11)
1712: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1713: l_LIMITS_rec.attribute12)
1714: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1715: l_LIMITS_rec.attribute13)
1716: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,

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

1710: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute11,
1711: l_LIMITS_rec.attribute11)
1712: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1713: l_LIMITS_rec.attribute12)
1714: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1715: l_LIMITS_rec.attribute13)
1716: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1717: l_LIMITS_rec.attribute14)
1718: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,

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

1712: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute12,
1713: l_LIMITS_rec.attribute12)
1714: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1715: l_LIMITS_rec.attribute13)
1716: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1717: l_LIMITS_rec.attribute14)
1718: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1719: l_LIMITS_rec.attribute15)
1720: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,

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

1714: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute13,
1715: l_LIMITS_rec.attribute13)
1716: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1717: l_LIMITS_rec.attribute14)
1718: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1719: l_LIMITS_rec.attribute15)
1720: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1721: l_LIMITS_rec.attribute2)
1722: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,

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

1716: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute14,
1717: l_LIMITS_rec.attribute14)
1718: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1719: l_LIMITS_rec.attribute15)
1720: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1721: l_LIMITS_rec.attribute2)
1722: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1723: l_LIMITS_rec.attribute3)
1724: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,

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

1718: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute15,
1719: l_LIMITS_rec.attribute15)
1720: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1721: l_LIMITS_rec.attribute2)
1722: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1723: l_LIMITS_rec.attribute3)
1724: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1725: l_LIMITS_rec.attribute4)
1726: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,

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

1720: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute2,
1721: l_LIMITS_rec.attribute2)
1722: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1723: l_LIMITS_rec.attribute3)
1724: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1725: l_LIMITS_rec.attribute4)
1726: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1727: l_LIMITS_rec.attribute5)
1728: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,

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

1722: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute3,
1723: l_LIMITS_rec.attribute3)
1724: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1725: l_LIMITS_rec.attribute4)
1726: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1727: l_LIMITS_rec.attribute5)
1728: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1729: l_LIMITS_rec.attribute6)
1730: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,

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

1724: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute4,
1725: l_LIMITS_rec.attribute4)
1726: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1727: l_LIMITS_rec.attribute5)
1728: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1729: l_LIMITS_rec.attribute6)
1730: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1731: l_LIMITS_rec.attribute7)
1732: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,

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

1726: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute5,
1727: l_LIMITS_rec.attribute5)
1728: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1729: l_LIMITS_rec.attribute6)
1730: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1731: l_LIMITS_rec.attribute7)
1732: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1733: l_LIMITS_rec.attribute8)
1734: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,

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

1728: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute6,
1729: l_LIMITS_rec.attribute6)
1730: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1731: l_LIMITS_rec.attribute7)
1732: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1733: l_LIMITS_rec.attribute8)
1734: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1735: l_LIMITS_rec.attribute9)
1736: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,

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

1730: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute7,
1731: l_LIMITS_rec.attribute7)
1732: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1733: l_LIMITS_rec.attribute8)
1734: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1735: l_LIMITS_rec.attribute9)
1736: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1737: l_LIMITS_rec.basis)
1738: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,

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

1732: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute8,
1733: l_LIMITS_rec.attribute8)
1734: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1735: l_LIMITS_rec.attribute9)
1736: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1737: l_LIMITS_rec.basis)
1738: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1739: l_LIMITS_rec.context)
1740: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,

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

1734: AND QP_GLOBALS.Equal(p_LIMITS_rec.attribute9,
1735: l_LIMITS_rec.attribute9)
1736: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1737: l_LIMITS_rec.basis)
1738: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1739: l_LIMITS_rec.context)
1740: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1741: l_LIMITS_rec.created_by)
1742: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,

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

1736: AND QP_GLOBALS.Equal(p_LIMITS_rec.basis,
1737: l_LIMITS_rec.basis)
1738: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1739: l_LIMITS_rec.context)
1740: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1741: l_LIMITS_rec.created_by)
1742: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1743: l_LIMITS_rec.creation_date)
1744: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,

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

1738: AND QP_GLOBALS.Equal(p_LIMITS_rec.context,
1739: l_LIMITS_rec.context)
1740: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1741: l_LIMITS_rec.created_by)
1742: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1743: l_LIMITS_rec.creation_date)
1744: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1745: l_LIMITS_rec.last_updated_by)
1746: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,

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

1740: AND QP_GLOBALS.Equal(p_LIMITS_rec.created_by,
1741: l_LIMITS_rec.created_by)
1742: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1743: l_LIMITS_rec.creation_date)
1744: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1745: l_LIMITS_rec.last_updated_by)
1746: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1747: l_LIMITS_rec.last_update_date)
1748: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,

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

1742: AND QP_GLOBALS.Equal(p_LIMITS_rec.creation_date,
1743: l_LIMITS_rec.creation_date)
1744: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1745: l_LIMITS_rec.last_updated_by)
1746: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1747: l_LIMITS_rec.last_update_date)
1748: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1749: l_LIMITS_rec.last_update_login)
1750: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,

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

1744: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_updated_by,
1745: l_LIMITS_rec.last_updated_by)
1746: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1747: l_LIMITS_rec.last_update_date)
1748: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1749: l_LIMITS_rec.last_update_login)
1750: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1751: l_LIMITS_rec.limit_exceed_action_code)
1752: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,

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

1746: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_date,
1747: l_LIMITS_rec.last_update_date)
1748: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1749: l_LIMITS_rec.last_update_login)
1750: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1751: l_LIMITS_rec.limit_exceed_action_code)
1752: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1753: l_LIMITS_rec.limit_hold_flag)
1754: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,

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

1748: AND QP_GLOBALS.Equal(p_LIMITS_rec.last_update_login,
1749: l_LIMITS_rec.last_update_login)
1750: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1751: l_LIMITS_rec.limit_exceed_action_code)
1752: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1753: l_LIMITS_rec.limit_hold_flag)
1754: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1755: l_LIMITS_rec.limit_id)
1756: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,

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

1750: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1751: l_LIMITS_rec.limit_exceed_action_code)
1752: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1753: l_LIMITS_rec.limit_hold_flag)
1754: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1755: l_LIMITS_rec.limit_id)
1756: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1757: l_LIMITS_rec.limit_level_code)
1758: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,

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

1752: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_hold_flag,
1753: l_LIMITS_rec.limit_hold_flag)
1754: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1755: l_LIMITS_rec.limit_id)
1756: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1757: l_LIMITS_rec.limit_level_code)
1758: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1759: l_LIMITS_rec.limit_number)
1760: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,

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

1754: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1755: l_LIMITS_rec.limit_id)
1756: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1757: l_LIMITS_rec.limit_level_code)
1758: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1759: l_LIMITS_rec.limit_number)
1760: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1761: l_LIMITS_rec.list_header_id)
1762: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,

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

1756: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1757: l_LIMITS_rec.limit_level_code)
1758: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1759: l_LIMITS_rec.limit_number)
1760: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1761: l_LIMITS_rec.list_header_id)
1762: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1763: l_LIMITS_rec.list_line_id)
1764: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,

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

1758: AND QP_GLOBALS.Equal(p_LIMITS_rec.limit_number,
1759: l_LIMITS_rec.limit_number)
1760: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1761: l_LIMITS_rec.list_header_id)
1762: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1763: l_LIMITS_rec.list_line_id)
1764: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1765: l_LIMITS_rec.multival_attr1_type)
1766: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,

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

1760: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1761: l_LIMITS_rec.list_header_id)
1762: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1763: l_LIMITS_rec.list_line_id)
1764: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1765: l_LIMITS_rec.multival_attr1_type)
1766: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1767: l_LIMITS_rec.multival_attr1_context)
1768: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,

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

1762: AND QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1763: l_LIMITS_rec.list_line_id)
1764: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1765: l_LIMITS_rec.multival_attr1_type)
1766: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1767: l_LIMITS_rec.multival_attr1_context)
1768: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1769: l_LIMITS_rec.multival_attribute1)
1770: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,

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

1764: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_type,
1765: l_LIMITS_rec.multival_attr1_type)
1766: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1767: l_LIMITS_rec.multival_attr1_context)
1768: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1769: l_LIMITS_rec.multival_attribute1)
1770: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1771: l_LIMITS_rec.multival_attr1_datatype)
1772: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,

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

1766: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_context,
1767: l_LIMITS_rec.multival_attr1_context)
1768: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1769: l_LIMITS_rec.multival_attribute1)
1770: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1771: l_LIMITS_rec.multival_attr1_datatype)
1772: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1773: l_LIMITS_rec.multival_attr2_type)
1774: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,

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

1768: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute1,
1769: l_LIMITS_rec.multival_attribute1)
1770: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1771: l_LIMITS_rec.multival_attr1_datatype)
1772: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1773: l_LIMITS_rec.multival_attr2_type)
1774: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1775: l_LIMITS_rec.multival_attr2_context)
1776: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,

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

1770: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr1_datatype,
1771: l_LIMITS_rec.multival_attr1_datatype)
1772: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1773: l_LIMITS_rec.multival_attr2_type)
1774: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1775: l_LIMITS_rec.multival_attr2_context)
1776: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1777: l_LIMITS_rec.multival_attribute2)
1778: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,

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

1772: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_type,
1773: l_LIMITS_rec.multival_attr2_type)
1774: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1775: l_LIMITS_rec.multival_attr2_context)
1776: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1777: l_LIMITS_rec.multival_attribute2)
1778: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1779: l_LIMITS_rec.multival_attr2_datatype)
1780: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,

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

1774: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_context,
1775: l_LIMITS_rec.multival_attr2_context)
1776: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1777: l_LIMITS_rec.multival_attribute2)
1778: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1779: l_LIMITS_rec.multival_attr2_datatype)
1780: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1781: l_LIMITS_rec.organization_flag)
1782: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,

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

1776: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attribute2,
1777: l_LIMITS_rec.multival_attribute2)
1778: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1779: l_LIMITS_rec.multival_attr2_datatype)
1780: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1781: l_LIMITS_rec.organization_flag)
1782: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1783: l_LIMITS_rec.program_application_id)
1784: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,

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

1778: AND QP_GLOBALS.Equal(p_LIMITS_rec.multival_attr2_datatype,
1779: l_LIMITS_rec.multival_attr2_datatype)
1780: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1781: l_LIMITS_rec.organization_flag)
1782: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1783: l_LIMITS_rec.program_application_id)
1784: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1785: l_LIMITS_rec.program_id)
1786: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,

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

1780: AND QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1781: l_LIMITS_rec.organization_flag)
1782: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1783: l_LIMITS_rec.program_application_id)
1784: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1785: l_LIMITS_rec.program_id)
1786: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,
1787: l_LIMITS_rec.program_update_date)
1788: AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,

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

1782: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_application_id,
1783: l_LIMITS_rec.program_application_id)
1784: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1785: l_LIMITS_rec.program_id)
1786: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,
1787: l_LIMITS_rec.program_update_date)
1788: AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,
1789: l_LIMITS_rec.request_id)
1790: THEN

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

1784: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_id,
1785: l_LIMITS_rec.program_id)
1786: AND QP_GLOBALS.Equal(p_LIMITS_rec.program_update_date,
1787: l_LIMITS_rec.program_update_date)
1788: AND QP_GLOBALS.Equal(p_LIMITS_rec.request_id,
1789: l_LIMITS_rec.request_id)
1790: THEN
1791:
1792: -- Row has not changed. Set out parameter.

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

1868: BEGIN
1869:
1870: IF p_LIMITS_rec.limit_exceed_action_code IS NOT NULL AND
1871: p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR AND
1872: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_exceed_action_code,
1873: p_old_LIMITS_rec.limit_exceed_action_code)
1874: THEN
1875: l_LIMITS_val_rec.limit_exceed_action := QP_Id_To_Value.Limit_Exceed_Action
1876: ( p_limit_exceed_action_code => p_LIMITS_rec.limit_exceed_action_code

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

1878: END IF;
1879:
1880: IF p_LIMITS_rec.limit_id IS NOT NULL AND
1881: p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM AND
1882: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_id,
1883: p_old_LIMITS_rec.limit_id)
1884: THEN
1885: l_LIMITS_val_rec.limit := QP_Id_To_Value.Limit
1886: ( p_limit_id => p_LIMITS_rec.limit_id

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

1888: END IF;
1889:
1890: IF p_LIMITS_rec.limit_level_code IS NOT NULL AND
1891: p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR AND
1892: NOT QP_GLOBALS.Equal(p_LIMITS_rec.limit_level_code,
1893: p_old_LIMITS_rec.limit_level_code)
1894: THEN
1895: l_LIMITS_val_rec.limit_level := QP_Id_To_Value.Limit_Level
1896: ( p_limit_level_code => p_LIMITS_rec.limit_level_code

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

1898: END IF;
1899:
1900: IF p_LIMITS_rec.list_header_id IS NOT NULL AND
1901: p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM AND
1902: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_header_id,
1903: p_old_LIMITS_rec.list_header_id)
1904: THEN
1905: l_LIMITS_val_rec.list_header := QP_Id_To_Value.List_Header
1906: ( p_list_header_id => p_LIMITS_rec.list_header_id

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

1908: END IF;
1909:
1910: IF p_LIMITS_rec.list_line_id IS NOT NULL AND
1911: p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM AND
1912: NOT QP_GLOBALS.Equal(p_LIMITS_rec.list_line_id,
1913: p_old_LIMITS_rec.list_line_id)
1914: THEN
1915: l_LIMITS_val_rec.list_line := QP_Id_To_Value.List_Line
1916: ( p_list_line_id => p_LIMITS_rec.list_line_id

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

1918: END IF;
1919:
1920: IF p_LIMITS_rec.organization_flag IS NOT NULL AND
1921: p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR AND
1922: NOT QP_GLOBALS.Equal(p_LIMITS_rec.organization_flag,
1923: p_old_LIMITS_rec.organization_flag)
1924: THEN
1925: l_LIMITS_val_rec.organization := QP_Id_To_Value.Organization
1926: ( p_organization_flag => p_LIMITS_rec.organization_flag

Line 2154: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

2150:
2151:
2152: qp_delayed_requests_PVT.log_request
2153: (
2154: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2155: p_entity_id => p_LIMITS_rec.limit_id,
2156: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2157: p_requesting_entity_id => p_LIMITS_rec.limit_id,
2158: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,

Line 2156: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,

2152: qp_delayed_requests_PVT.log_request
2153: (
2154: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2155: p_entity_id => p_LIMITS_rec.limit_id,
2156: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2157: p_requesting_entity_id => p_LIMITS_rec.limit_id,
2158: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,
2159: x_return_status => l_return_status
2160: );

Line 2158: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,

2154: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2155: p_entity_id => p_LIMITS_rec.limit_id,
2156: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2157: p_requesting_entity_id => p_LIMITS_rec.limit_id,
2158: p_request_type => QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS,
2159: x_return_status => l_return_status
2160: );
2161:
2162: null;