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 959: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute1,p_old_Line_Payment_rec.attribute1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1112: IF p_x_Line_Payment_rec.operation ='UPDATE' AND OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code) THEN

1108: p_x_Line_Payment_rec.cc_instrument_id)
1109: THEN
1110: NULL;
1111: --CC Reversal ER#16014135 start
1112: IF p_x_Line_Payment_rec.operation ='UPDATE' AND OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code) THEN
1113: l_verify_payment_flag:='Y';
1114: IF l_debug_level > 0 THEN
1115: oe_debug_pub.add('in Is_Same_Credit_Card' );
1116: END IF;

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

1117: END IF;
1118: --CC Reversal ER#16014135 end
1119: END IF;
1120:
1121: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_level_code,p_old_Line_Payment_rec.payment_level_code)
1122: THEN
1123: NULL;
1124: END IF;
1125:

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

1122: THEN
1123: NULL;
1124: END IF;
1125:
1126: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_applied_amount,p_old_Line_Payment_rec.commitment_applied_amount)
1127: THEN
1128: NULL;
1129: --CC Reversal ER#16014135 start
1130: l_verify_payment_flag:='Y';

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

1133: END IF;
1134: --CC Reversal ER#16014135 end
1135: END IF;
1136:
1137: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.commitment_interfaced_amount,p_old_Line_Payment_rec.commitment_interfaced_amount)
1138: THEN
1139: NULL;
1140: --CC Reversal ER#16014135 start
1141: l_verify_payment_flag:='Y';

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

1144: END IF;
1145: --CC Reversal ER#16014135 end
1146: END IF;
1147:
1148: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_number,p_old_Line_Payment_rec.payment_number)
1149: THEN
1150: NULL;
1151: END IF;
1152:

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

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

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

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

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

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

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

1164: THEN
1165: NULL;
1166: END IF;
1167:
1168: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_collection_event,p_old_Line_Payment_rec.payment_collection_event)
1169: THEN
1170: NULL;
1171: END IF;
1172:

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

1169: THEN
1170: NULL;
1171: END IF;
1172:
1173: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.defer_payment_processing_flag,p_old_Line_Payment_rec.defer_payment_processing_flag)
1174: THEN
1175: NULL;
1176: END IF;
1177:

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

1175: NULL;
1176: END IF;
1177:
1178: -- R12 CC Encryption
1179: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.trxn_extension_id,p_old_Line_Payment_rec.trxn_extension_id)
1180: THEN
1181: NULL;
1182: --CC Reversal ER#16014135 start
1183: l_verify_payment_flag:='Y';

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

1187: END IF;
1188: --CC Reversal ER#16014135 end
1189: END IF;
1190:
1191: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.instrument_security_code,p_old_Line_Payment_rec.instrument_security_code)
1192: THEN
1193: NULL;
1194: END IF;
1195:

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

1195:
1196: -- R12 CC Encryption
1197:
1198:
1199: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_trx_id,p_old_Line_Payment_rec.payment_trx_id)
1200: THEN
1201: IF p_x_Line_Payment_rec.payment_type_code = 'COMMITMENT'
1202: AND OE_Commitment_Pvt.Do_Commitment_Sequencing
1203: AND NOT OE_GLOBALS.G_UI_FLAG THEN

Line 1203: AND NOT OE_GLOBALS.G_UI_FLAG THEN

1199: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_trx_id,p_old_Line_Payment_rec.payment_trx_id)
1200: THEN
1201: IF p_x_Line_Payment_rec.payment_type_code = 'COMMITMENT'
1202: AND OE_Commitment_Pvt.Do_Commitment_Sequencing
1203: AND NOT OE_GLOBALS.G_UI_FLAG THEN
1204: -- only need to log delayed request when this is not from UI.
1205: l_calculate_commitment_flag := 'Y';
1206: END IF;
1207: END IF;

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

1205: l_calculate_commitment_flag := 'Y';
1206: END IF;
1207: END IF;
1208:
1209: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1210: THEN
1211: l_payments_update_flag := 'Y';
1212: --CC Reversal ER#16014135 start
1213: IF (p_x_Line_Payment_rec.operation ='UPDATE'AND p_x_Line_Payment_rec.payment_type_code<>'CREDIT_CARD')

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

1275: FROM oe_payment_types_vl
1276: WHERE payment_type_code=p_x_Line_Payment_rec.payment_type_code;
1277:
1278: IF l_booked_flag = 'Y' AND
1279: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new) THEN
1280:
1281: IF( l_debug_level > 0) THEN
1282: oe_debug_pub.add('l_invoke_credit_checking is: '||l_invoke_credit_checking, 3);
1283: END IF;

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

1306:
1307: END IF;
1308: END IF;
1309:
1310: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_set_id,p_old_Line_Payment_rec.payment_set_id)
1311: THEN
1312: NULL;
1313: END IF;
1314:

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

1311: THEN
1312: NULL;
1313: END IF;
1314:
1315: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.prepaid_amount,p_old_Line_Payment_rec.prepaid_amount)
1316: THEN
1317: NULL;
1318: END IF;
1319:

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

1316: THEN
1317: NULL;
1318: END IF;
1319:
1320: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_application_id,p_old_Line_Payment_rec.program_application_id)
1321: THEN
1322: NULL;
1323: END IF;
1324:

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

1321: THEN
1322: NULL;
1323: END IF;
1324:
1325: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_id,p_old_Line_Payment_rec.program_id)
1326: THEN
1327: NULL;
1328: END IF;
1329:

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

1326: THEN
1327: NULL;
1328: END IF;
1329:
1330: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.program_update_date,p_old_Line_Payment_rec.program_update_date)
1331: THEN
1332: NULL;
1333: END IF;
1334:

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

1331: THEN
1332: NULL;
1333: END IF;
1334:
1335: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.receipt_method_id,p_old_Line_Payment_rec.receipt_method_id)
1336: THEN
1337: NULL;
1338: END IF;
1339:

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

1336: THEN
1337: NULL;
1338: END IF;
1339:
1340: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.request_id,p_old_Line_Payment_rec.request_id)
1341: THEN
1342: NULL;
1343: END IF;
1344:

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

1341: THEN
1342: NULL;
1343: END IF;
1344:
1345: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.tangible_id,p_old_Line_Payment_rec.tangible_id)
1346: THEN
1347: NULL;
1348: END IF;
1349:

Line 1358: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1354:
1355: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1356:
1357: OE_delayed_requests_Pvt.log_request
1358: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1359: p_entity_id => p_x_Line_Payment_rec.line_id,
1360: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1361: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1362: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,

Line 1360: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1356:
1357: OE_delayed_requests_Pvt.log_request
1358: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1359: p_entity_id => p_x_Line_Payment_rec.line_id,
1360: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1361: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1362: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
1363: p_param1 => 'UPDATE_LINE',
1364: p_param2 => p_x_Line_Payment_rec.header_id,

Line 1362: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,

1358: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1359: p_entity_id => p_x_Line_Payment_rec.line_id,
1360: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1361: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1362: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
1363: p_param1 => 'UPDATE_LINE',
1364: p_param2 => p_x_Line_Payment_rec.header_id,
1365: x_return_status => l_return_status);
1366:

Line 1375: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1371: oe_debug_pub.add('OEXULPMB: Logging delayed request for Commitment.', 1);
1372: END IF;
1373:
1374: OE_Delayed_Requests_Pvt.Log_Request(
1375: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1376: p_entity_id => p_x_Line_Payment_rec.line_id,
1377: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1378: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1379: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

Line 1377: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1373:
1374: OE_Delayed_Requests_Pvt.Log_Request(
1375: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1376: p_entity_id => p_x_Line_Payment_rec.line_id,
1377: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1378: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1379: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1380: x_return_status => l_return_status);
1381: END IF;

Line 1379: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,

1375: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1376: p_entity_id => p_x_Line_Payment_rec.line_id,
1377: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1378: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1379: p_request_type => OE_GLOBALS.G_CALCULATE_COMMITMENT,
1380: x_return_status => l_return_status);
1381: END IF;
1382:
1383: --bug3625027 start

Line 1391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1387: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1388: oe_debug_pub.add('line_id is: ' || p_x_Line_Payment_rec.line_id);
1389: END IF;
1390: OE_delayed_requests_Pvt.log_request
1391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1392: p_entity_id => p_x_Line_Payment_rec.header_id,
1393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1394: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1395: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,

Line 1393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1389: END IF;
1390: OE_delayed_requests_Pvt.log_request
1391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1392: p_entity_id => p_x_Line_Payment_rec.header_id,
1393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1394: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1395: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,
1396: p_param1 => p_x_Line_Payment_rec.line_id,
1397: x_return_status => l_return_status);

Line 1395: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,

1391: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1392: p_entity_id => p_x_Line_Payment_rec.header_id,
1393: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1394: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1395: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,
1396: p_param1 => p_x_Line_Payment_rec.line_id,
1397: x_return_status => l_return_status);
1398: END IF;
1399: --bug3625027 end

Line 1407: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1403: oe_debug_pub.add('OEXULPMB: Logging delayed request for Delete_Payment_Hold.', 3);
1404: END IF;
1405:
1406: OE_delayed_requests_Pvt.log_request
1407: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1408: p_entity_id => p_x_Line_Payment_rec.line_id,
1409: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1410: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1411: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,

Line 1409: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1405:
1406: OE_delayed_requests_Pvt.log_request
1407: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1408: p_entity_id => p_x_Line_Payment_rec.line_id,
1409: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1410: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1411: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,
1412: p_param1 => 'VERIFY_PAYMENT',
1413: p_param2 => p_x_Line_Payment_rec.header_id,

Line 1411: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,

1407: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1408: p_entity_id => p_x_Line_Payment_rec.line_id,
1409: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1410: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1411: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,
1412: p_param1 => 'VERIFY_PAYMENT',
1413: p_param2 => p_x_Line_Payment_rec.header_id,
1414: x_return_status => l_return_status);
1415: END IF;

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

1417:
1418: oe_debug_pub.add('OEXULPMB.pls : exiting apply attribute changes');
1419:
1420: --ER#7479609 start
1421: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.payment_type_code,p_old_Line_Payment_rec.payment_type_code)
1422: THEN
1423: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1424:
1425: OE_delayed_requests_Pvt.log_request

Line 1426: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

1422: THEN
1423: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1424:
1425: OE_delayed_requests_Pvt.log_request
1426: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1427: p_entity_id => p_x_Line_Payment_rec.line_id,
1428: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1429: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1430: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,

Line 1428: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

1424:
1425: OE_delayed_requests_Pvt.log_request
1426: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1427: p_entity_id => p_x_Line_Payment_rec.line_id,
1428: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1429: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1430: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
1431: p_request_unique_key1 => 'PAYMENT_TYPE',
1432: p_param1 => 'P',

Line 1430: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,

1426: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
1427: p_entity_id => p_x_Line_Payment_rec.line_id,
1428: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
1429: p_requesting_entity_id => p_x_Line_Payment_rec.line_id,
1430: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
1431: p_request_unique_key1 => 'PAYMENT_TYPE',
1432: p_param1 => 'P',
1433: p_param2 => p_x_Line_Payment_rec.payment_type_code,
1434: x_return_status => l_return_status);

Line 1445: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1441: oe_debug_pub.ADD('OEXULPMB: Logging delayed request for Verify Payment CC Reversal',5);
1442: END IF;
1443: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1444: OE_delayed_requests_Pvt.log_request
1445: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1446: p_entity_id => p_x_Line_Payment_rec.header_id,
1447: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1448: p_requesting_entity_id => p_x_Line_Payment_rec.header_id,
1449: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 1447: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

1443: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1444: OE_delayed_requests_Pvt.log_request
1445: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1446: p_entity_id => p_x_Line_Payment_rec.header_id,
1447: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1448: p_requesting_entity_id => p_x_Line_Payment_rec.header_id,
1449: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1450: x_return_status => l_return_status);
1451: END IF;

Line 1449: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

1445: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1446: p_entity_id => p_x_Line_Payment_rec.header_id,
1447: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1448: p_requesting_entity_id => p_x_Line_Payment_rec.header_id,
1449: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1450: x_return_status => l_return_status);
1451: END IF;
1452: --CC Reversal ER#16014135 End
1453: END Apply_Attribute_Changes;

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

2265: --added notification framework
2266: --check code release level first. Notification framework is at Pack H level
2267: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2268: /* Set the operation on the record so that globals are updated as well */
2269: l_new_line_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2270: l_new_line_Payment_rec.payment_number := l_pmt.payment_number;
2271: --R12 CC Encryption
2272: l_payment_type_code := l_pmt.payment_type_code;
2273: l_trxn_extension_id := l_pmt.trxn_extension_id;

Line 2359: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,

2355: END LOOP;
2356:
2357:
2358: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
2359: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_PAYMENT,
2360: p_entity_id => p_line_id,
2361: x_return_status => l_return_status
2362: );
2363: DELETE FROM OE_PAYMENTS

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

2418: --added notification framework
2419: --check code release level first. Notification framework is at Pack H level
2420: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2421: /* Set the operation on the record so that globals are updated as well */
2422: l_new_line_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2423: l_new_line_Payment_rec.payment_number := p_payment_number;
2424: l_new_line_Payment_rec.line_id := p_line_id;
2425: /* OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2426: p_Lin_pmt_rec =>l_new_line_Payment_rec,

Line 2472: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_Payment,

2468: END IF; /*code_release_level*/
2469: -- notification framework end
2470:
2471: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
2472: p_entity_code => OE_GLOBALS.G_ENTITY_LINE_Payment,
2473: p_entity_id => p_line_id,
2474: x_return_status => l_return_status
2475: );
2476:

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

3093:
3094: -- Row locked. If the whole record is passed, then
3095: -- Compare IN attributes to DB attributes.
3096:
3097: IF OE_GLOBALS.Equal(p_x_Line_Payment_rec.lock_control,
3098: l_lock_control)
3099: THEN
3100:
3101: -- Row has not changed. Set out parameter.

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

3320: BEGIN
3321:
3322: IF (p_Line_Payment_rec.payment_collection_event IS NULL OR
3323: p_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND
3324: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_collection_event,
3325: p_old_Line_Payment_rec.payment_collection_event)
3326: THEN
3327: l_Line_Payment_val_rec.payment_collection_event_name := OE_Id_To_Value.payment_collection_event_name
3328: ( p_payment_collection_event => p_Line_Payment_rec.payment_collection_event

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

3330: END IF;
3331:
3332: IF (p_Line_Payment_rec.receipt_method_id IS NULL OR
3333: p_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND
3334: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.receipt_method_id,
3335: p_old_Line_Payment_rec.receipt_method_id)
3336: THEN
3337: l_Line_Payment_val_rec.receipt_method := OE_Id_To_Value.Receipt_Method
3338: ( p_receipt_method => p_Line_Payment_rec.receipt_method_id

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

3340: END IF;
3341:
3342: IF (p_Line_Payment_rec.payment_type_code IS NULL OR
3343: p_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
3344: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_type_code,
3345: p_old_Line_Payment_rec.payment_type_code)
3346: THEN
3347: l_Line_Payment_val_rec.payment_type := OE_Id_To_Value.payment_type
3348: ( p_payment_type_code => p_Line_Payment_rec.payment_type_code

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

3573: END IF;
3574: IF l_debug_level > 0 THEN
3575: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
3576: END IF;
3577: IF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3578: l_new_commitment_bal := l_commitment_bal - p_x_line_Payment_rec.commitment_applied_amount;
3579: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3580: l_new_commitment_bal := l_commitment_bal + p_old_line_Payment_rec.commitment_applied_amount - p_x_line_Payment_rec.commitment_applied_amount;
3581: END IF;

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

3575: oe_debug_pub.add( 'COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
3576: END IF;
3577: IF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3578: l_new_commitment_bal := l_commitment_bal - p_x_line_Payment_rec.commitment_applied_amount;
3579: ELSIF p_x_line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3580: l_new_commitment_bal := l_commitment_bal + p_old_line_Payment_rec.commitment_applied_amount - p_x_line_Payment_rec.commitment_applied_amount;
3581: END IF;
3582: IF l_debug_level > 0 THEN
3583: oe_debug_pub.add('l_new_commitment_bal : '||l_new_commitment_bal);

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

3667: -- To make sure this is coming from external caller,
3668: -- not from a copied order, need to check for source
3669: -- document type id, which is 2 for a copy order.
3670: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3671: AND (p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE)
3672: AND nvl(l_order_source_doc_id, -99) <> 2 THEN
3673:
3674: IF l_debug_level > 0 THEN
3675: oe_debug_pub.add('Before calling copy payment trxn...');

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

3701: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);
3702: END IF;
3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3704: END;
3705: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3706: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3707: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3708: AND ((p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD'
3709: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

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

3705: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3706: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3707: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3708: AND ((p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD'
3709: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3710: p_x_line_Payment_rec.credit_card_number,
3711: p_old_line_Payment_rec.cc_instrument_id,
3712: p_x_line_Payment_rec.cc_instrument_id)
3713: AND p_x_line_Payment_rec.credit_card_holder_name = p_old_line_Payment_rec.credit_card_holder_name

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

3753: RAISE FND_API.G_EXC_ERROR;
3754: END IF;
3755: END IF;
3756:
3757: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3758: p_x_line_Payment_rec.credit_card_number,
3759: p_old_line_Payment_rec.cc_instrument_id,
3760: p_x_line_Payment_rec.cc_instrument_id)
3761: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

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

3757: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3758: p_x_line_Payment_rec.credit_card_number,
3759: p_old_line_Payment_rec.cc_instrument_id,
3760: p_x_line_Payment_rec.cc_instrument_id)
3761: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3762: p_old_line_Payment_rec.credit_card_code) THEN
3763: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3764: p_old_line_Payment_rec.credit_card_holder_name)
3765: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

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

3759: p_old_line_Payment_rec.cc_instrument_id,
3760: p_x_line_Payment_rec.cc_instrument_id)
3761: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3762: p_old_line_Payment_rec.credit_card_code) THEN
3763: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3764: p_old_line_Payment_rec.credit_card_holder_name)
3765: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3766: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3767: l_update_card_flag := 'Y';

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

3761: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3762: p_old_line_Payment_rec.credit_card_code) THEN
3763: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3764: p_old_line_Payment_rec.credit_card_holder_name)
3765: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3766: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3767: l_update_card_flag := 'Y';
3768: ELSE
3769: l_update_card_flag := 'N';

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

3767: l_update_card_flag := 'Y';
3768: ELSE
3769: l_update_card_flag := 'N';
3770: END IF;
3771: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3772: p_old_line_Payment_rec.credit_card_holder_name)
3773: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3774: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3775: l_update_card_flag := 'Y';

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

3769: l_update_card_flag := 'N';
3770: END IF;
3771: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3772: p_old_line_Payment_rec.credit_card_holder_name)
3773: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3774: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3775: l_update_card_flag := 'Y';
3776: END IF;
3777:

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

3854: --R12 CC Encryption
3855: --Since the credit card numbers are encrypted, passing both the credit card
3856: --numbers as well as instrument ids to determine if both the old and new
3857: --values point to the same credit card number.
3858: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3859: p_x_line_Payment_rec.credit_card_number,
3860: p_old_line_Payment_rec.cc_instrument_id,
3861: p_x_line_Payment_rec.cc_instrument_id)
3862: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

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

3858: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3859: p_x_line_Payment_rec.credit_card_number,
3860: p_old_line_Payment_rec.cc_instrument_id,
3861: p_x_line_Payment_rec.cc_instrument_id)
3862: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3863: p_old_line_Payment_rec.credit_card_code) THEN
3864: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3865: p_old_line_Payment_rec.credit_card_holder_name)
3866: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

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

3860: p_old_line_Payment_rec.cc_instrument_id,
3861: p_x_line_Payment_rec.cc_instrument_id)
3862: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3863: p_old_line_Payment_rec.credit_card_code) THEN
3864: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3865: p_old_line_Payment_rec.credit_card_holder_name)
3866: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3867: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3868: l_update_card_flag := 'Y';

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

3862: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3863: p_old_line_Payment_rec.credit_card_code) THEN
3864: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3865: p_old_line_Payment_rec.credit_card_holder_name)
3866: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3867: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3868: l_update_card_flag := 'Y';
3869: ELSE
3870: l_update_card_flag := 'N';

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

3868: l_update_card_flag := 'Y';
3869: ELSE
3870: l_update_card_flag := 'N';
3871: END IF;
3872: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3873: p_old_line_Payment_rec.credit_card_holder_name)
3874: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3875: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3876: l_update_card_flag := 'Y';

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

3870: l_update_card_flag := 'N';
3871: END IF;
3872: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3873: p_old_line_Payment_rec.credit_card_holder_name)
3874: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3875: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3876: l_update_card_flag := 'Y';
3877: END IF;
3878: IF l_debug_level > 0 THEN

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

3932: END;
3933: END IF;
3934: --Operation is Create. Hence need to create a new Trxn extension id
3935: --by calling the Create_trxn_extension API.
3936: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify
3937:
3938: IF l_debug_level > 0 THEN
3939: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3940: END IF;

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

3954: RAISE FND_API.G_EXC_ERROR;
3955: END IF;
3956: END IF;
3957:
3958: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3959: p_x_line_Payment_rec.credit_card_number,
3960: p_old_line_Payment_rec.cc_instrument_id,
3961: p_x_line_Payment_rec.cc_instrument_id)
3962: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,

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

3958: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3959: p_x_line_Payment_rec.credit_card_number,
3960: p_old_line_Payment_rec.cc_instrument_id,
3961: p_x_line_Payment_rec.cc_instrument_id)
3962: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3963: p_old_line_Payment_rec.credit_card_code) THEN
3964: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3965: p_old_line_Payment_rec.credit_card_holder_name)
3966: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,

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

3960: p_old_line_Payment_rec.cc_instrument_id,
3961: p_x_line_Payment_rec.cc_instrument_id)
3962: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3963: p_old_line_Payment_rec.credit_card_code) THEN
3964: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3965: p_old_line_Payment_rec.credit_card_holder_name)
3966: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3967: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3968: l_update_card_flag := 'Y';

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

3962: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_code,
3963: p_old_line_Payment_rec.credit_card_code) THEN
3964: IF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3965: p_old_line_Payment_rec.credit_card_holder_name)
3966: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3967: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3968: l_update_card_flag := 'Y';
3969: ELSE
3970: l_update_card_flag := 'N';

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

3968: l_update_card_flag := 'Y';
3969: ELSE
3970: l_update_card_flag := 'N';
3971: END IF;
3972: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3973: p_old_line_Payment_rec.credit_card_holder_name)
3974: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3975: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3976: l_update_card_flag := 'Y';

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

3970: l_update_card_flag := 'N';
3971: END IF;
3972: ELSIF NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_holder_name,
3973: p_old_line_Payment_rec.credit_card_holder_name)
3974: OR NOT OE_GLOBALS.Equal(p_x_line_Payment_rec.credit_card_expiration_date,
3975: p_old_line_Payment_rec.credit_card_expiration_date) THEN
3976: l_update_card_flag := 'Y';
3977: END IF;
3978:

Line 4038: p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE

4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: end;
4036: END IF; --Operation
4037: ELSIF p_x_line_payment_rec.payment_type_code IN ('CHECK','CASH') AND
4038: p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE
4039: AND p_old_line_Payment_rec.trxn_extension_id IS NOT NULL THEN
4040:
4041: --For update operation, the trxn extension id of the original
4042: --transaction needs to be deleted if it already exists as