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.OE_LINE_PAYMENT_UTIL dependencies on OE_GLOBALS

Line 216: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

212: , p_old_instrument_id IN NUMBER DEFAULT NULL
213: )
214: IS
215: l_index NUMBER :=0;
216: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
217: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
218: --
219: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
220: --

Line 217: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

213: )
214: IS
215: l_index NUMBER :=0;
216: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
217: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
218: --
219: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
220: --
221: BEGIN

Line 232: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute1,p_old_Line_Payment_rec.attribute1)

228: -- every changed attribute clear its dependent fields.
229:
230: IF p_attr_id = FND_API.G_MISS_NUM THEN
231:
232: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute1,p_old_Line_Payment_rec.attribute1)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE1;
236: END IF;

Line 238: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute2,p_old_Line_Payment_rec.attribute2)

234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE1;
236: END IF;
237:
238: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute2,p_old_Line_Payment_rec.attribute2)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2;
242: END IF;

Line 244: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute3,p_old_Line_Payment_rec.attribute3)

240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2;
242: END IF;
243:
244: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute3,p_old_Line_Payment_rec.attribute3)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3;
248: END IF;

Line 250: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute4,p_old_Line_Payment_rec.attribute4)

246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3;
248: END IF;
249:
250: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute4,p_old_Line_Payment_rec.attribute4)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4;
254: END IF;

Line 256: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute5,p_old_Line_Payment_rec.attribute5)

252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4;
254: END IF;
255:
256: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute5,p_old_Line_Payment_rec.attribute5)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5;
260: END IF;

Line 262: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute6,p_old_Line_Payment_rec.attribute6)

258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5;
260: END IF;
261:
262: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute6,p_old_Line_Payment_rec.attribute6)
263: THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6;
266: END IF;

Line 268: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute7,p_old_Line_Payment_rec.attribute7)

264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6;
266: END IF;
267:
268: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute7,p_old_Line_Payment_rec.attribute7)
269: THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7;
272: END IF;

Line 274: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute8,p_old_Line_Payment_rec.attribute8)

270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7;
272: END IF;
273:
274: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute8,p_old_Line_Payment_rec.attribute8)
275: THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8;
278: END IF;

Line 280: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute9,p_old_Line_Payment_rec.attribute9)

276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8;
278: END IF;
279:
280: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute9,p_old_Line_Payment_rec.attribute9)
281: THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9;
284: END IF;

Line 286: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute10,p_old_Line_Payment_rec.attribute10)

282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9;
284: END IF;
285:
286: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute10,p_old_Line_Payment_rec.attribute10)
287: THEN
288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10;
290: END IF;

Line 292: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute11,p_old_Line_Payment_rec.attribute11)

288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10;
290: END IF;
291:
292: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute11,p_old_Line_Payment_rec.attribute11)
293: THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11;
296: END IF;

Line 298: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute12,p_old_Line_Payment_rec.attribute12)

294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11;
296: END IF;
297:
298: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute12,p_old_Line_Payment_rec.attribute12)
299: THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12;
302: END IF;

Line 304: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute13,p_old_Line_Payment_rec.attribute13)

300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12;
302: END IF;
303:
304: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute13,p_old_Line_Payment_rec.attribute13)
305: THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13;
308: END IF;

Line 310: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute14,p_old_Line_Payment_rec.attribute14)

306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13;
308: END IF;
309:
310: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute14,p_old_Line_Payment_rec.attribute14)
311: THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14;
314: END IF;

Line 316: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute15,p_old_Line_Payment_rec.attribute15)

312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14;
314: END IF;
315:
316: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute15,p_old_Line_Payment_rec.attribute15)
317: THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15;
320: END IF;

Line 322: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.context,p_old_Line_Payment_rec.context)

318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15;
320: END IF;
321:
322: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.context,p_old_Line_Payment_rec.context)
323: THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CONTEXT;
326: END IF;

Line 328: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.created_by,p_old_Line_Payment_rec.created_by)

324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CONTEXT;
326: END IF;
327:
328: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.created_by,p_old_Line_Payment_rec.created_by)
329: THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREATED_BY;
332: END IF;

Line 334: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.creation_date,p_old_Line_Payment_rec.creation_date)

330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREATED_BY;
332: END IF;
333:
334: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.creation_date,p_old_Line_Payment_rec.creation_date)
335: THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREATION_DATE;
338: END IF;

Line 340: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_updated_by,p_old_Line_Payment_rec.last_updated_by)

336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREATION_DATE;
338: END IF;
339:
340: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_updated_by,p_old_Line_Payment_rec.last_updated_by)
341: THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY;
344: END IF;

Line 346: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_date,p_old_Line_Payment_rec.last_update_date)

342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY;
344: END IF;
345:
346: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_date,p_old_Line_Payment_rec.last_update_date)
347: THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE;
350: END IF;

Line 352: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_login,p_old_Line_Payment_rec.last_update_login)

348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE;
350: END IF;
351:
352: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_login,p_old_Line_Payment_rec.last_update_login)
353: THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN;
356: END IF;

Line 358: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.check_number,p_old_Line_Payment_rec.check_number)

354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN;
356: END IF;
357:
358: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.check_number,p_old_Line_Payment_rec.check_number)
359: THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER;
362: END IF;

Line 364: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_code,p_old_Line_Payment_rec.credit_card_approval_code)

360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER;
362: END IF;
363:
364: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_code,p_old_Line_Payment_rec.credit_card_approval_code)
365: THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE;
368: END IF;

Line 370: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_date,p_old_Line_Payment_rec.credit_card_approval_date)

366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE;
368: END IF;
369:
370: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_date,p_old_Line_Payment_rec.credit_card_approval_date)
371: THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
374: END IF;

Line 376: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_code,p_old_Line_Payment_rec.credit_card_code)

372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
374: END IF;
375:
376: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_code,p_old_Line_Payment_rec.credit_card_code)
377: THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_CODE;
380: END IF;

Line 382: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_expiration_date,p_old_Line_Payment_rec.credit_card_expiration_date)

378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_CODE;
380: END IF;
381:
382: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_expiration_date,p_old_Line_Payment_rec.credit_card_expiration_date)
383: THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
386: END IF;

Line 388: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_holder_name,p_old_Line_Payment_rec.credit_card_holder_name)

384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
386: END IF;
387:
388: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_holder_name,p_old_Line_Payment_rec.credit_card_holder_name)
389: THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME;
392: END IF;

Line 399: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.credit_card_number,

395: --Since the credit card numbers are encrypted, passing both the credit card
396: --numbers as well as instrument ids to determine if both the old and new
397: --values point to the same credit card number.
398:
399: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.credit_card_number,
400: p_x_Line_Payment_rec.credit_card_number,p_old_instrument_id,
401: p_x_instrument_id)
402: THEN
403: l_index := l_index + 1;

Line 407: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_level_code,p_old_Line_Payment_rec.payment_level_code)

403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER;
405: END IF;
406:
407: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_level_code,p_old_Line_Payment_rec.payment_level_code)
408: THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE;
411: END IF;

Line 413: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_applied_amount,p_old_Line_Payment_rec.commitment_applied_amount)

409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE;
411: END IF;
412:
413: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_applied_amount,p_old_Line_Payment_rec.commitment_applied_amount)
414: THEN
415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT;
417: END IF;

Line 419: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_interfaced_amount,p_old_Line_Payment_rec.commitment_interfaced_amount)

415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT;
417: END IF;
418:
419: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_interfaced_amount,p_old_Line_Payment_rec.commitment_interfaced_amount)
420: THEN
421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT;
423: END IF;

Line 425: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_number,p_old_Line_Payment_rec.payment_number)

421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT;
423: END IF;
424:
425: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_number,p_old_Line_Payment_rec.payment_number)
426: THEN
427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER;
429: END IF;

Line 431: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.header_id,p_old_Line_Payment_rec.header_id)

427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER;
429: END IF;
430:
431: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.header_id,p_old_Line_Payment_rec.header_id)
432: THEN
433: l_index := l_index + 1;
434: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_HEADER;
435: END IF;

Line 437: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.line_id,p_old_Line_Payment_rec.line_id)

433: l_index := l_index + 1;
434: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_HEADER;
435: END IF;
436:
437: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.line_id,p_old_Line_Payment_rec.line_id)
438: THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LINE;
441: END IF;

Line 443: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_amount,p_old_Line_Payment_rec.payment_amount)

439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_LINE;
441: END IF;
442:
443: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_amount,p_old_Line_Payment_rec.payment_amount)
444: THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT;
447: END IF;

Line 450: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_collection_event,p_old_Line_Payment_rec.payment_collection_event)

446: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT;
447: END IF;
448:
449:
450: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_collection_event,p_old_Line_Payment_rec.payment_collection_event)
451: THEN
452: l_index := l_index + 1;
453: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT;
454: END IF;

Line 455: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_trx_id,p_old_Line_Payment_rec.payment_trx_id)

451: THEN
452: l_index := l_index + 1;
453: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT;
454: END IF;
455: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_trx_id,p_old_Line_Payment_rec.payment_trx_id)
456: THEN
457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
459: END IF;

Line 461: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)

457: l_index := l_index + 1;
458: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
459: END IF;
460:
461: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
462: THEN
463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE;
465: END IF;

Line 467: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_set_id,p_old_Line_Payment_rec.payment_set_id)

463: l_index := l_index + 1;
464: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE;
465: END IF;
466:
467: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_set_id,p_old_Line_Payment_rec.payment_set_id)
468: THEN
469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID;
471: END IF;

Line 473: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.prepaid_amount,p_old_Line_Payment_rec.prepaid_amount)

469: l_index := l_index + 1;
470: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID;
471: END IF;
472:
473: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.prepaid_amount,p_old_Line_Payment_rec.prepaid_amount)
474: THEN
475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT;
477: END IF;

Line 479: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_application_id,p_old_Line_Payment_rec.program_application_id)

475: l_index := l_index + 1;
476: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT;
477: END IF;
478:
479: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_application_id,p_old_Line_Payment_rec.program_application_id)
480: THEN
481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID;
483: END IF;

Line 485: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_id,p_old_Line_Payment_rec.program_id)

481: l_index := l_index + 1;
482: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID;
483: END IF;
484:
485: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_id,p_old_Line_Payment_rec.program_id)
486: THEN
487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID;
489: END IF;

Line 491: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_update_date,p_old_Line_Payment_rec.program_update_date)

487: l_index := l_index + 1;
488: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID;
489: END IF;
490:
491: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_update_date,p_old_Line_Payment_rec.program_update_date)
492: THEN
493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE;
495: END IF;

Line 497: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.receipt_method_id,p_old_Line_Payment_rec.receipt_method_id)

493: l_index := l_index + 1;
494: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE;
495: END IF;
496:
497: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.receipt_method_id,p_old_Line_Payment_rec.receipt_method_id)
498: THEN
499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
501: END IF;

Line 503: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.request_id,p_old_Line_Payment_rec.request_id)

499: l_index := l_index + 1;
500: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
501: END IF;
502:
503: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.request_id,p_old_Line_Payment_rec.request_id)
504: THEN
505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_REQUEST_ID;
507: END IF;

Line 509: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.tangible_id,p_old_Line_Payment_rec.tangible_id)

505: l_index := l_index + 1;
506: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_REQUEST_ID;
507: END IF;
508:
509: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.tangible_id,p_old_Line_Payment_rec.tangible_id)
510: THEN
511: l_index := l_index + 1;
512: l_src_attr_tbl(l_index) := OE_LINE_PAYMENT_UTIL.G_TANGIBLE_ID;
513: END IF;

Line 658: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

654:
655: If l_src_attr_tbl.COUNT <> 0 THEN
656:
657: OE_Dependencies.Mark_Dependent
658: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
659: p_source_attr_tbl => l_src_attr_tbl,
660: p_dep_attr_tbl => l_dep_attr_tbl);
661:
662: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP

Line 713: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE, p_old_Line_Payment_rec.CREDIT_CARD_APPROVAL_CODE)

709: --Added the additional conditional before clearing credit
710: --card attributes as the dependent attributes were cleared out
711: --when the change attributes was called for multiple attributes
712: --in a single call
713: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE, p_old_Line_Payment_rec.CREDIT_CARD_APPROVAL_CODE)
714: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
715: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE IS NOT NULL)
716: ) -- AND condition added to fix 3098878
717: THEN

Line 721: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE, p_old_Line_Payment_rec.CREDIT_CARD_APPROVAL_DATE)

717: THEN
718: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
719: END IF;
720: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE THEN
721: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE, p_old_Line_Payment_rec.CREDIT_CARD_APPROVAL_DATE)
722: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
723: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE IS NOT NULL)
724: ) -- AND condition added to fix 3098878
725: THEN

Line 729: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE, p_old_Line_Payment_rec.CREDIT_CARD_CODE)

725: THEN
726: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
727: END IF;
728: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_CODE THEN
729: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE, p_old_Line_Payment_rec.CREDIT_CARD_CODE)
730: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
731: p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE IS NOT NULL)
732: ) -- AND condition added to fix 3098878
733: THEN

Line 741: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE, p_old_Line_Payment_rec.CREDIT_CARD_EXPIRATION_DATE)

737: IF l_debug_level > 0 THEN
738: oe_debug_pub.add('Old exp date'||p_old_Line_Payment_rec.credit_card_expiration_date);
739: oe_debug_pub.add('New exp date'||p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE);
740: END IF;
741: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE, p_old_Line_Payment_rec.CREDIT_CARD_EXPIRATION_DATE)
742: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
743: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE IS NOT NULL)
744: ) -- AND condition added to fix 3098878
745: THEN

Line 753: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME, p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME)

749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add('Old holder name'||p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME);
751: oe_debug_pub.add('New holder name'||p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME);
752: END IF;
753: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME, p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME)
754: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
755: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME IS NOT NULL)
756: ) -- AND condition added to fix 3098878
757: THEN

Line 761: IF (OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.CREDIT_CARD_NUMBER,

757: THEN
758: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
759: END IF;
760: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER THEN
761: IF (OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.CREDIT_CARD_NUMBER,
762: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER,p_old_instrument_id,
763: p_x_instrument_id)
764: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
765: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER IS NOT NULL)

Line 958: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute1,p_old_Line_Payment_rec.attribute1)

954:
955: -- Load out record
956:
957:
958: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute1,p_old_Line_Payment_rec.attribute1)
959: THEN
960: NULL;
961: END IF;
962:

Line 963: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute2,p_old_Line_Payment_rec.attribute2)

959: THEN
960: NULL;
961: END IF;
962:
963: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute2,p_old_Line_Payment_rec.attribute2)
964: THEN
965: NULL;
966: END IF;
967:

Line 968: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute3,p_old_Line_Payment_rec.attribute3)

964: THEN
965: NULL;
966: END IF;
967:
968: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute3,p_old_Line_Payment_rec.attribute3)
969: THEN
970: NULL;
971: END IF;
972:

Line 973: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute4,p_old_Line_Payment_rec.attribute4)

969: THEN
970: NULL;
971: END IF;
972:
973: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute4,p_old_Line_Payment_rec.attribute4)
974: THEN
975: NULL;
976: END IF;
977:

Line 978: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute5,p_old_Line_Payment_rec.attribute5)

974: THEN
975: NULL;
976: END IF;
977:
978: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute5,p_old_Line_Payment_rec.attribute5)
979: THEN
980: NULL;
981: END IF;
982:

Line 983: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute6,p_old_Line_Payment_rec.attribute6)

979: THEN
980: NULL;
981: END IF;
982:
983: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute6,p_old_Line_Payment_rec.attribute6)
984: THEN
985: NULL;
986: END IF;
987:

Line 988: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute7,p_old_Line_Payment_rec.attribute7)

984: THEN
985: NULL;
986: END IF;
987:
988: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute7,p_old_Line_Payment_rec.attribute7)
989: THEN
990: NULL;
991: END IF;
992:

Line 993: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute8,p_old_Line_Payment_rec.attribute8)

989: THEN
990: NULL;
991: END IF;
992:
993: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute8,p_old_Line_Payment_rec.attribute8)
994: THEN
995: NULL;
996: END IF;
997:

Line 998: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute9,p_old_Line_Payment_rec.attribute9)

994: THEN
995: NULL;
996: END IF;
997:
998: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute9,p_old_Line_Payment_rec.attribute9)
999: THEN
1000: NULL;
1001: END IF;
1002:

Line 1003: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute10,p_old_Line_Payment_rec.attribute10)

999: THEN
1000: NULL;
1001: END IF;
1002:
1003: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute10,p_old_Line_Payment_rec.attribute10)
1004: THEN
1005: NULL;
1006: END IF;
1007:

Line 1008: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute11,p_old_Line_Payment_rec.attribute11)

1004: THEN
1005: NULL;
1006: END IF;
1007:
1008: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute11,p_old_Line_Payment_rec.attribute11)
1009: THEN
1010: NULL;
1011: END IF;
1012:

Line 1013: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute12,p_old_Line_Payment_rec.attribute12)

1009: THEN
1010: NULL;
1011: END IF;
1012:
1013: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute12,p_old_Line_Payment_rec.attribute12)
1014: THEN
1015: NULL;
1016: END IF;
1017:

Line 1018: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute13,p_old_Line_Payment_rec.attribute13)

1014: THEN
1015: NULL;
1016: END IF;
1017:
1018: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute13,p_old_Line_Payment_rec.attribute13)
1019: THEN
1020: NULL;
1021: END IF;
1022:

Line 1023: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute14,p_old_Line_Payment_rec.attribute14)

1019: THEN
1020: NULL;
1021: END IF;
1022:
1023: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute14,p_old_Line_Payment_rec.attribute14)
1024: THEN
1025: NULL;
1026: END IF;
1027:

Line 1028: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute15,p_old_Line_Payment_rec.attribute15)

1024: THEN
1025: NULL;
1026: END IF;
1027:
1028: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute15,p_old_Line_Payment_rec.attribute15)
1029: THEN
1030: NULL;
1031: END IF;
1032:

Line 1033: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.context,p_old_Line_Payment_rec.context)

1029: THEN
1030: NULL;
1031: END IF;
1032:
1033: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.context,p_old_Line_Payment_rec.context)
1034: THEN
1035: NULL;
1036: END IF;
1037:

Line 1038: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.created_by,p_old_Line_Payment_rec.created_by)

1034: THEN
1035: NULL;
1036: END IF;
1037:
1038: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.created_by,p_old_Line_Payment_rec.created_by)
1039: THEN
1040: NULL;
1041: END IF;
1042:

Line 1043: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.creation_date,p_old_Line_Payment_rec.creation_date)

1039: THEN
1040: NULL;
1041: END IF;
1042:
1043: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.creation_date,p_old_Line_Payment_rec.creation_date)
1044: THEN
1045: NULL;
1046: END IF;
1047:

Line 1048: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_updated_by,p_old_Line_Payment_rec.last_updated_by)

1044: THEN
1045: NULL;
1046: END IF;
1047:
1048: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_updated_by,p_old_Line_Payment_rec.last_updated_by)
1049: THEN
1050: NULL;
1051: END IF;
1052:

Line 1053: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_date,p_old_Line_Payment_rec.last_update_date)

1049: THEN
1050: NULL;
1051: END IF;
1052:
1053: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_date,p_old_Line_Payment_rec.last_update_date)
1054: THEN
1055: NULL;
1056: END IF;
1057:

Line 1058: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_login,p_old_Line_Payment_rec.last_update_login)

1054: THEN
1055: NULL;
1056: END IF;
1057:
1058: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.last_update_login,p_old_Line_Payment_rec.last_update_login)
1059: THEN
1060: NULL;
1061: END IF;
1062:

Line 1063: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.check_number,p_old_Line_Payment_rec.check_number)

1059: THEN
1060: NULL;
1061: END IF;
1062:
1063: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.check_number,p_old_Line_Payment_rec.check_number)
1064: THEN
1065: NULL;
1066: END IF;
1067:

Line 1068: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_code,p_old_Line_Payment_rec.credit_card_approval_code)

1064: THEN
1065: NULL;
1066: END IF;
1067:
1068: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_code,p_old_Line_Payment_rec.credit_card_approval_code)
1069: THEN
1070: NULL;
1071: END IF;
1072:

Line 1073: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_date,p_old_Line_Payment_rec.credit_card_approval_date)

1069: THEN
1070: NULL;
1071: END IF;
1072:
1073: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_approval_date,p_old_Line_Payment_rec.credit_card_approval_date)
1074: THEN
1075: NULL;
1076: END IF;
1077:

Line 1078: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_code,p_old_Line_Payment_rec.credit_card_code)

1074: THEN
1075: NULL;
1076: END IF;
1077:
1078: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_code,p_old_Line_Payment_rec.credit_card_code)
1079: THEN
1080: NULL;
1081: END IF;
1082:

Line 1083: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_expiration_date,p_old_Line_Payment_rec.credit_card_expiration_date)

1079: THEN
1080: NULL;
1081: END IF;
1082:
1083: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_expiration_date,p_old_Line_Payment_rec.credit_card_expiration_date)
1084: THEN
1085: NULL;
1086: END IF;
1087:

Line 1088: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_holder_name,p_old_Line_Payment_rec.credit_card_holder_name)

1084: THEN
1085: NULL;
1086: END IF;
1087:
1088: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.credit_card_holder_name,p_old_Line_Payment_rec.credit_card_holder_name)
1089: THEN
1090: NULL;
1091: END IF;
1092:

Line 1104: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.credit_card_number,

1100: oe_debug_pub.add('Old instr id'||p_old_Line_Payment_rec.cc_instrument_id);
1101: oe_debug_pub.add('New instr id'||p_x_Line_Payment_rec.cc_instrument_id);
1102: END IF;
1103:
1104: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.credit_card_number,
1105: p_x_Line_Payment_rec.credit_card_number,
1106: p_old_Line_Payment_rec.cc_instrument_id,
1107: p_x_Line_Payment_rec.cc_instrument_id)
1108: THEN

Line 1112: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_level_code,p_old_Line_Payment_rec.payment_level_code)

1108: THEN
1109: NULL;
1110: END IF;
1111:
1112: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_level_code,p_old_Line_Payment_rec.payment_level_code)
1113: THEN
1114: NULL;
1115: END IF;
1116:

Line 1117: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_applied_amount,p_old_Line_Payment_rec.commitment_applied_amount)

1113: THEN
1114: NULL;
1115: END IF;
1116:
1117: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_applied_amount,p_old_Line_Payment_rec.commitment_applied_amount)
1118: THEN
1119: NULL;
1120: END IF;
1121:

Line 1122: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_interfaced_amount,p_old_Line_Payment_rec.commitment_interfaced_amount)

1118: THEN
1119: NULL;
1120: END IF;
1121:
1122: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_interfaced_amount,p_old_Line_Payment_rec.commitment_interfaced_amount)
1123: THEN
1124: NULL;
1125: END IF;
1126:

Line 1127: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_number,p_old_Line_Payment_rec.payment_number)

1123: THEN
1124: NULL;
1125: END IF;
1126:
1127: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_number,p_old_Line_Payment_rec.payment_number)
1128: THEN
1129: NULL;
1130: END IF;
1131:

Line 1132: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.header_id,p_old_Line_Payment_rec.header_id)

1128: THEN
1129: NULL;
1130: END IF;
1131:
1132: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.header_id,p_old_Line_Payment_rec.header_id)
1133: THEN
1134: NULL;
1135: END IF;
1136:

Line 1137: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.line_id,p_old_Line_Payment_rec.line_id)

1133: THEN
1134: NULL;
1135: END IF;
1136:
1137: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.line_id,p_old_Line_Payment_rec.line_id)
1138: THEN
1139: NULL;
1140: END IF;
1141:

Line 1142: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_amount,p_old_Line_Payment_rec.payment_amount)

1138: THEN
1139: NULL;
1140: END IF;
1141:
1142: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_amount,p_old_Line_Payment_rec.payment_amount)
1143: THEN
1144: NULL;
1145: END IF;
1146:

Line 1147: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_collection_event,p_old_Line_Payment_rec.payment_collection_event)

1143: THEN
1144: NULL;
1145: END IF;
1146:
1147: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_collection_event,p_old_Line_Payment_rec.payment_collection_event)
1148: THEN
1149: NULL;
1150: END IF;
1151:

Line 1152: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.defer_payment_processing_flag,p_old_Line_Payment_rec.defer_payment_processing_flag)

1148: THEN
1149: NULL;
1150: END IF;
1151:
1152: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.defer_payment_processing_flag,p_old_Line_Payment_rec.defer_payment_processing_flag)
1153: THEN
1154: NULL;
1155: END IF;
1156:

Line 1158: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.trxn_extension_id,p_old_Line_Payment_rec.trxn_extension_id)

1154: NULL;
1155: END IF;
1156:
1157: -- R12 CC Encryption
1158: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.trxn_extension_id,p_old_Line_Payment_rec.trxn_extension_id)
1159: THEN
1160: NULL;
1161: END IF;
1162:

Line 1163: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.instrument_security_code,p_old_Line_Payment_rec.instrument_security_code)

1159: THEN
1160: NULL;
1161: END IF;
1162:
1163: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.instrument_security_code,p_old_Line_Payment_rec.instrument_security_code)
1164: THEN
1165: NULL;
1166: END IF;
1167:

Line 1171: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_trx_id,p_old_Line_Payment_rec.payment_trx_id)

1167:
1168: -- R12 CC Encryption
1169:
1170:
1171: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_trx_id,p_old_Line_Payment_rec.payment_trx_id)
1172: THEN
1173: IF p_x_Line_Payment_rec.payment_type_code = 'COMMITMENT'
1174: AND OE_Commitment_Pvt.Do_Commitment_Sequencing
1175: AND NOT OE_GLOBALS.G_UI_FLAG THEN

Line 1175: AND NOT OE_GLOBALS.G_UI_FLAG THEN

1171: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_trx_id,p_old_Line_Payment_rec.payment_trx_id)
1172: THEN
1173: IF p_x_Line_Payment_rec.payment_type_code = 'COMMITMENT'
1174: AND OE_Commitment_Pvt.Do_Commitment_Sequencing
1175: AND NOT OE_GLOBALS.G_UI_FLAG THEN
1176: -- only need to log delayed request when this is not from UI.
1177: l_calculate_commitment_flag := 'Y';
1178: END IF;
1179: END IF;

Line 1181: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)

1177: l_calculate_commitment_flag := 'Y';
1178: END IF;
1179: END IF;
1180:
1181: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1182: THEN
1183: l_payments_update_flag := 'Y';
1184:
1185: IF p_old_Line_Payment_rec.payment_type_code = 'CREDIT_CARD'

Line 1217: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new) THEN

1213: FROM oe_payment_types_vl
1214: WHERE payment_type_code=p_x_Line_Payment_rec.payment_type_code;
1215:
1216: IF l_booked_flag = 'Y' AND
1217: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new) THEN
1218:
1219: IF( l_debug_level > 0) THEN
1220: oe_debug_pub.add('l_invoke_credit_checking is: '||l_invoke_credit_checking, 3);
1221: END IF;

Line 1248: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_set_id,p_old_Line_Payment_rec.payment_set_id)

1244:
1245: END IF;
1246: END IF;
1247:
1248: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_set_id,p_old_Line_Payment_rec.payment_set_id)
1249: THEN
1250: NULL;
1251: END IF;
1252:

Line 1253: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.prepaid_amount,p_old_Line_Payment_rec.prepaid_amount)

1249: THEN
1250: NULL;
1251: END IF;
1252:
1253: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.prepaid_amount,p_old_Line_Payment_rec.prepaid_amount)
1254: THEN
1255: NULL;
1256: END IF;
1257:

Line 1258: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_application_id,p_old_Line_Payment_rec.program_application_id)

1254: THEN
1255: NULL;
1256: END IF;
1257:
1258: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_application_id,p_old_Line_Payment_rec.program_application_id)
1259: THEN
1260: NULL;
1261: END IF;
1262:

Line 1263: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_id,p_old_Line_Payment_rec.program_id)

1259: THEN
1260: NULL;
1261: END IF;
1262:
1263: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_id,p_old_Line_Payment_rec.program_id)
1264: THEN
1265: NULL;
1266: END IF;
1267:

Line 1268: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_update_date,p_old_Line_Payment_rec.program_update_date)

1264: THEN
1265: NULL;
1266: END IF;
1267:
1268: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_update_date,p_old_Line_Payment_rec.program_update_date)
1269: THEN
1270: NULL;
1271: END IF;
1272:

Line 1273: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.receipt_method_id,p_old_Line_Payment_rec.receipt_method_id)

1269: THEN
1270: NULL;
1271: END IF;
1272:
1273: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.receipt_method_id,p_old_Line_Payment_rec.receipt_method_id)
1274: THEN
1275: NULL;
1276: END IF;
1277:

Line 1278: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.request_id,p_old_Line_Payment_rec.request_id)

1274: THEN
1275: NULL;
1276: END IF;
1277:
1278: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.request_id,p_old_Line_Payment_rec.request_id)
1279: THEN
1280: NULL;
1281: END IF;
1282:

Line 1283: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.tangible_id,p_old_Line_Payment_rec.tangible_id)

1279: THEN
1280: NULL;
1281: END IF;
1282:
1283: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.tangible_id,p_old_Line_Payment_rec.tangible_id)
1284: THEN
1285: NULL;
1286: END IF;
1287:

Line 1296: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1292:
1293: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1294:
1295: OE_delayed_requests_Pvt.log_request
1296: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1297: p_entity_id => p_x_Line_Payment_rec.line_id,
1298: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1299: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1300: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,

Line 1298: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1294:
1295: OE_delayed_requests_Pvt.log_request
1296: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1297: p_entity_id => p_x_Line_Payment_rec.line_id,
1298: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1299: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1300: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
1301: p_param1 => 'UPDATE_LINE',
1302: p_param2 => p_x_Line_Payment_rec.header_id,

Line 1300: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,

1296: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1297: p_entity_id => p_x_Line_Payment_rec.line_id,
1298: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1299: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1300: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
1301: p_param1 => 'UPDATE_LINE',
1302: p_param2 => p_x_Line_Payment_rec.header_id,
1303: x_return_status => l_return_status);
1304:

Line 1313: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1309: oe_debug_pub.add('OEXULPMB: Logging delayed request for Commitment.', 1);
1310: END IF;
1311:
1312: OE_Delayed_Requests_Pvt.Log_Request(
1313: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1314: p_entity_id => p_x_Line_Payment_rec.line_id,
1315: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1316: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1317: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

Line 1315: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1311:
1312: OE_Delayed_Requests_Pvt.Log_Request(
1313: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1314: p_entity_id => p_x_Line_Payment_rec.line_id,
1315: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1316: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1317: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1318: x_return_status => l_return_status);
1319: END IF;

Line 1317: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

1313: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1314: p_entity_id => p_x_Line_Payment_rec.line_id,
1315: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1316: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1317: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1318: x_return_status => l_return_status);
1319: END IF;
1320:
1321: --bug3625027 start

Line 1329: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1325: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1326: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1327: END IF;
1328: OE_delayed_requests_Pvt.log_request
1329: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1330: p_entity_id => p_x_Line_Payment_rec.header_id,
1331: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1332: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1333: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,

Line 1331: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1327: END IF;
1328: OE_delayed_requests_Pvt.log_request
1329: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1330: p_entity_id => p_x_Line_Payment_rec.header_id,
1331: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1332: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1333: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,
1334: p_param1 => p_x_Line_Payment_rec.line_id,
1335: x_return_status => l_return_status);

Line 1333: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,

1329: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1330: p_entity_id => p_x_Line_Payment_rec.header_id,
1331: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1332: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1333: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,
1334: p_param1 => p_x_Line_Payment_rec.line_id,
1335: x_return_status => l_return_status);
1336: END IF;
1337: --bug3625027 end

Line 1345: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1341: oe_debug_pub.add('OEXULPMB: Logging delayed request for Delete_Payment_Hold.', 3);
1342: END IF;
1343:
1344: OE_delayed_requests_Pvt.log_request
1345: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1346: p_entity_id => p_x_Line_Payment_rec.line_id,
1347: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1348: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1349: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,

Line 1347: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1343:
1344: OE_delayed_requests_Pvt.log_request
1345: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1346: p_entity_id => p_x_Line_Payment_rec.line_id,
1347: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1348: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1349: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,
1350: p_param1 => 'VERIFY_PAYMENT',
1351: p_param2 => p_x_Line_Payment_rec.header_id,

Line 1349: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,

1345: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1346: p_entity_id => p_x_Line_Payment_rec.line_id,
1347: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1348: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1349: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,
1350: p_param1 => 'VERIFY_PAYMENT',
1351: p_param2 => p_x_Line_Payment_rec.header_id,
1352: x_return_status => l_return_status);
1353: END IF;

Line 1359: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)

1355:
1356: oe_debug_pub.add('OEXULPMB.pls : exiting apply attribute changes');
1357:
1358: --ER#7479609 start
1359: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1360: THEN
1361: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1362:
1363: OE_delayed_requests_Pvt.log_request

Line 1364: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1360: THEN
1361: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1362:
1363: OE_delayed_requests_Pvt.log_request
1364: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1365: p_entity_id => p_x_Line_Payment_rec.line_id,
1366: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1367: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1368: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,

Line 1366: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1362:
1363: OE_delayed_requests_Pvt.log_request
1364: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1365: p_entity_id => p_x_Line_Payment_rec.line_id,
1366: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1367: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1368: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
1369: p_request_unique_key1 => 'PAYMENT_TYPE',
1370: p_param1 => 'P',

Line 1368: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,

1364: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1365: p_entity_id => p_x_Line_Payment_rec.line_id,
1366: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1367: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1368: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
1369: p_request_unique_key1 => 'PAYMENT_TYPE',
1370: p_param1 => 'P',
1371: p_param2 => p_x_Line_Payment_rec.payment_type_code,
1372: x_return_status => l_return_status);

Line 2191: l_new_line_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;

2187: --added notification framework
2188: --check code release level first. Notification framework is at Pack H level
2189: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2190: /* Set the operation on the record so that globals are updated as well */
2191: l_new_line_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2192: l_new_line_Payment_rec.payment_number := l_pmt.payment_number;
2193: --R12 CC Encryption
2194: l_payment_type_code := l_pmt.payment_type_code;
2195: l_trxn_extension_id := l_pmt.trxn_extension_id;

Line 2281: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

2277: END LOOP;
2278:
2279:
2280: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
2281: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
2282: p_entity_id => p_line_id,
2283: x_return_status => l_return_status
2284: );
2285: DELETE FROM OE_PAYMENTS

Line 2344: l_new_line_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;

2340: --added notification framework
2341: --check code release level first. Notification framework is at Pack H level
2342: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2343: /* Set the operation on the record so that globals are updated as well */
2344: l_new_line_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2345: l_new_line_Payment_rec.payment_number := p_payment_number;
2346: l_new_line_Payment_rec.line_id := p_line_id;
2347: /* OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2348: p_Lin_pmt_rec =>l_new_line_Payment_rec,

Line 2394: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_Payment,

2390: END IF; /*code_release_level*/
2391: -- notification framework end
2392:
2393: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
2394: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_Payment,
2395: p_entity_id => p_line_id,
2396: x_return_status => l_return_status
2397: );
2398:

Line 3019: IF OE_GLOBALS.Equal(p_x_Line_Payment_rec.lock_control,

3015:
3016: -- Row locked. If the whole record is passed, then
3017: -- Compare IN attributes to DB attributes.
3018:
3019: IF OE_GLOBALS.Equal(p_x_Line_Payment_rec.lock_control,
3020: l_lock_control)
3021: THEN
3022:
3023: -- Row has not changed. Set out parameter.

Line 3246: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_collection_event,

3242: BEGIN
3243:
3244: IF (p_Line_Payment_rec.payment_collection_event IS NULL OR
3245: p_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND
3246: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_collection_event,
3247: p_old_Line_Payment_rec.payment_collection_event)
3248: THEN
3249: l_Line_Payment_val_rec.payment_collection_event_name := OE_Id_To_Value.payment_collection_event_name
3250: ( p_payment_collection_event => p_Line_Payment_rec.payment_collection_event

Line 3256: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.receipt_method_id,

3252: END IF;
3253:
3254: IF (p_Line_Payment_rec.receipt_method_id IS NULL OR
3255: p_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND
3256: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.receipt_method_id,
3257: p_old_Line_Payment_rec.receipt_method_id)
3258: THEN
3259: l_Line_Payment_val_rec.receipt_method := OE_Id_To_Value.Receipt_Method
3260: ( p_receipt_method => p_Line_Payment_rec.receipt_method_id

Line 3266: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_type_code,

3262: END IF;
3263:
3264: IF (p_Line_Payment_rec.payment_type_code IS NULL OR
3265: p_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
3266: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_type_code,
3267: p_old_Line_Payment_rec.payment_type_code)
3268: THEN
3269: l_Line_Payment_val_rec.payment_type := OE_Id_To_Value.payment_type
3270: ( p_payment_type_code => p_Line_Payment_rec.payment_type_code

Line 3499: IF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

3495: END IF;
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
3498: END IF;
3499: IF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3500: l_new_commitment_bal := l_commitment_bal - p_x_line_Payment_rec.commitment_applied_amount;
3501: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3502: l_new_commitment_bal := l_commitment_bal + p_old_line_Payment_rec.commitment_applied_amount - p_x_line_Payment_rec.commitment_applied_amount;
3503: END IF;

Line 3501: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

3497: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
3498: END IF;
3499: IF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3500: l_new_commitment_bal := l_commitment_bal - p_x_line_Payment_rec.commitment_applied_amount;
3501: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3502: l_new_commitment_bal := l_commitment_bal + p_old_line_Payment_rec.commitment_applied_amount - p_x_line_Payment_rec.commitment_applied_amount;
3503: END IF;
3504: IF l_debug_level > 0 THEN
3505: oe_debug_pub.add('l_new_commitment_bal : '||l_new_commitment_bal);

Line 3593: AND (p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE)

3589: -- To make sure this is coming from external caller,
3590: -- not from a copied order, need to check for source
3591: -- document type id, which is 2 for a copy order.
3592: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3593: AND (p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE)
3594: AND nvl(l_order_source_doc_id, -99) <> 2 THEN
3595:
3596: IF l_debug_level > 0 THEN
3597: oe_debug_pub.add('Before calling copy payment trxn...');

Line 3627: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

3623: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);
3624: END IF;
3625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3626: END;
3627: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3628: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3629: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3630: AND ((p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD'
3631: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

Line 3631: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

3627: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3628: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3629: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3630: AND ((p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD'
3631: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3632: p_x_line_Payment_rec.credit_card_number,
3633: p_old_line_Payment_rec.cc_instrument_id,
3634: p_x_line_Payment_rec.cc_instrument_id)
3635: AND p_x_line_Payment_rec.credit_card_holder_name = p_old_line_Payment_rec.credit_card_holder_name

Line 3679: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: END IF;
3678:
3679: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3680: p_x_line_Payment_rec.credit_card_number,
3681: p_old_line_Payment_rec.cc_instrument_id,
3682: p_x_line_Payment_rec.cc_instrument_id)
3683: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

Line 3683: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

3679: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3680: p_x_line_Payment_rec.credit_card_number,
3681: p_old_line_Payment_rec.cc_instrument_id,
3682: p_x_line_Payment_rec.cc_instrument_id)
3683: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3684: p_old_line_Payment_rec.credit_card_code) THEN
3685: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3686: p_old_line_Payment_rec.credit_card_holder_name)
3687: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

Line 3685: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,

3681: p_old_line_Payment_rec.cc_instrument_id,
3682: p_x_line_Payment_rec.cc_instrument_id)
3683: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3684: p_old_line_Payment_rec.credit_card_code) THEN
3685: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3686: p_old_line_Payment_rec.credit_card_holder_name)
3687: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3688: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3689: l_update_card_flag := 'Y';

Line 3687: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

3683: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3684: p_old_line_Payment_rec.credit_card_code) THEN
3685: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3686: p_old_line_Payment_rec.credit_card_holder_name)
3687: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3688: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3689: l_update_card_flag := 'Y';
3690: ELSE
3691: l_update_card_flag := 'N';

Line 3693: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,

3689: l_update_card_flag := 'Y';
3690: ELSE
3691: l_update_card_flag := 'N';
3692: END IF;
3693: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3694: p_old_line_Payment_rec.credit_card_holder_name)
3695: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3696: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3697: l_update_card_flag := 'Y';

Line 3695: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

3691: l_update_card_flag := 'N';
3692: END IF;
3693: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3694: p_old_line_Payment_rec.credit_card_holder_name)
3695: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3696: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3697: l_update_card_flag := 'Y';
3698: END IF;
3699:

Line 3780: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

3776: --R12 CC Encryption
3777: --Since the credit card numbers are encrypted, passing both the credit card
3778: --numbers as well as instrument ids to determine if both the old and new
3779: --values point to the same credit card number.
3780: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3781: p_x_line_Payment_rec.credit_card_number,
3782: p_old_line_Payment_rec.cc_instrument_id,
3783: p_x_line_Payment_rec.cc_instrument_id)
3784: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

Line 3784: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

3780: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3781: p_x_line_Payment_rec.credit_card_number,
3782: p_old_line_Payment_rec.cc_instrument_id,
3783: p_x_line_Payment_rec.cc_instrument_id)
3784: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3785: p_old_line_Payment_rec.credit_card_code) THEN
3786: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3787: p_old_line_Payment_rec.credit_card_holder_name)
3788: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

Line 3786: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,

3782: p_old_line_Payment_rec.cc_instrument_id,
3783: p_x_line_Payment_rec.cc_instrument_id)
3784: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3785: p_old_line_Payment_rec.credit_card_code) THEN
3786: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3787: p_old_line_Payment_rec.credit_card_holder_name)
3788: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3789: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3790: l_update_card_flag := 'Y';

Line 3788: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

3784: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3785: p_old_line_Payment_rec.credit_card_code) THEN
3786: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3787: p_old_line_Payment_rec.credit_card_holder_name)
3788: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3789: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3790: l_update_card_flag := 'Y';
3791: ELSE
3792: l_update_card_flag := 'N';

Line 3794: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,

3790: l_update_card_flag := 'Y';
3791: ELSE
3792: l_update_card_flag := 'N';
3793: END IF;
3794: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3795: p_old_line_Payment_rec.credit_card_holder_name)
3796: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3797: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3798: l_update_card_flag := 'Y';

Line 3796: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

3792: l_update_card_flag := 'N';
3793: END IF;
3794: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3795: p_old_line_Payment_rec.credit_card_holder_name)
3796: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3797: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3798: l_update_card_flag := 'Y';
3799: END IF;
3800: IF l_debug_level > 0 THEN

Line 3858: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify

3854: END;
3855: END IF;
3856: --Operation is Create. Hence need to create a new Trxn extension id
3857: --by calling the Create_trxn_extension API.
3858: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify
3859:
3860: IF l_debug_level > 0 THEN
3861: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3862: END IF;

Line 3880: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

3876: RAISE FND_API.G_EXC_ERROR;
3877: END IF;
3878: END IF;
3879:
3880: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3881: p_x_line_Payment_rec.credit_card_number,
3882: p_old_line_Payment_rec.cc_instrument_id,
3883: p_x_line_Payment_rec.cc_instrument_id)
3884: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

Line 3884: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

3880: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3881: p_x_line_Payment_rec.credit_card_number,
3882: p_old_line_Payment_rec.cc_instrument_id,
3883: p_x_line_Payment_rec.cc_instrument_id)
3884: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3885: p_old_line_Payment_rec.credit_card_code) THEN
3886: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3887: p_old_line_Payment_rec.credit_card_holder_name)
3888: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

Line 3886: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,

3882: p_old_line_Payment_rec.cc_instrument_id,
3883: p_x_line_Payment_rec.cc_instrument_id)
3884: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3885: p_old_line_Payment_rec.credit_card_code) THEN
3886: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3887: p_old_line_Payment_rec.credit_card_holder_name)
3888: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3889: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3890: l_update_card_flag := 'Y';

Line 3888: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

3884: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3885: p_old_line_Payment_rec.credit_card_code) THEN
3886: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3887: p_old_line_Payment_rec.credit_card_holder_name)
3888: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3889: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3890: l_update_card_flag := 'Y';
3891: ELSE
3892: l_update_card_flag := 'N';

Line 3894: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,

3890: l_update_card_flag := 'Y';
3891: ELSE
3892: l_update_card_flag := 'N';
3893: END IF;
3894: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3895: p_old_line_Payment_rec.credit_card_holder_name)
3896: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3897: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3898: l_update_card_flag := 'Y';

Line 3896: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

3892: l_update_card_flag := 'N';
3893: END IF;
3894: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3895: p_old_line_Payment_rec.credit_card_holder_name)
3896: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3897: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3898: l_update_card_flag := 'Y';
3899: END IF;
3900:

Line 3960: p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE

3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3957: end;
3958: END IF; --Operation
3959: ELSIF p_x_line_payment_rec.payment_type_code IN ('CHECK','CASH') AND
3960: p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE
3961: AND p_old_line_Payment_rec.trxn_extension_id IS NOT NULL THEN
3962:
3963: --For update operation, the trxn extension id of the original
3964: --transaction needs to be deleted if it already exists as