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_HEADER_PAYMENT_UTIL dependencies on OE_GLOBALS

Line 212: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

208: , p_old_instrument_id IN NUMBER DEFAULT NULL
209: )
210: IS
211: l_index NUMBER :=0;
212: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
213: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
214: --
215: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
216: --

Line 213: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;

209: )
210: IS
211: l_index NUMBER :=0;
212: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
213: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
214: --
215: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
216: --
217: BEGIN

Line 228: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute1,p_old_Header_Payment_rec.attribute1)

224: -- every changed attribute clear its dependent fields.
225:
226: IF p_attr_id = FND_API.G_MISS_NUM THEN
227:
228: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute1,p_old_Header_Payment_rec.attribute1)
229: THEN
230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1;
232: END IF;

Line 234: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute2,p_old_Header_Payment_rec.attribute2)

230: l_index := l_index + 1;
231: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1;
232: END IF;
233:
234: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute2,p_old_Header_Payment_rec.attribute2)
235: THEN
236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2;
238: END IF;

Line 240: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute3,p_old_Header_Payment_rec.attribute3)

236: l_index := l_index + 1;
237: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2;
238: END IF;
239:
240: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute3,p_old_Header_Payment_rec.attribute3)
241: THEN
242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3;
244: END IF;

Line 246: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute4,p_old_Header_Payment_rec.attribute4)

242: l_index := l_index + 1;
243: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3;
244: END IF;
245:
246: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute4,p_old_Header_Payment_rec.attribute4)
247: THEN
248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4;
250: END IF;

Line 252: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute5,p_old_Header_Payment_rec.attribute5)

248: l_index := l_index + 1;
249: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4;
250: END IF;
251:
252: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute5,p_old_Header_Payment_rec.attribute5)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5;
256: END IF;

Line 258: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute6,p_old_Header_Payment_rec.attribute6)

254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5;
256: END IF;
257:
258: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute6,p_old_Header_Payment_rec.attribute6)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6;
262: END IF;

Line 264: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute7,p_old_Header_Payment_rec.attribute7)

260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6;
262: END IF;
263:
264: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute7,p_old_Header_Payment_rec.attribute7)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7;
268: END IF;

Line 270: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute8,p_old_Header_Payment_rec.attribute8)

266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7;
268: END IF;
269:
270: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute8,p_old_Header_Payment_rec.attribute8)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8;
274: END IF;

Line 276: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute9,p_old_Header_Payment_rec.attribute9)

272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8;
274: END IF;
275:
276: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute9,p_old_Header_Payment_rec.attribute9)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9;
280: END IF;

Line 282: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute10,p_old_Header_Payment_rec.attribute10)

278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9;
280: END IF;
281:
282: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute10,p_old_Header_Payment_rec.attribute10)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10;
286: END IF;

Line 288: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute11,p_old_Header_Payment_rec.attribute11)

284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10;
286: END IF;
287:
288: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute11,p_old_Header_Payment_rec.attribute11)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11;
292: END IF;

Line 294: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute12,p_old_Header_Payment_rec.attribute12)

290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11;
292: END IF;
293:
294: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute12,p_old_Header_Payment_rec.attribute12)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12;
298: END IF;

Line 300: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute13,p_old_Header_Payment_rec.attribute13)

296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12;
298: END IF;
299:
300: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute13,p_old_Header_Payment_rec.attribute13)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13;
304: END IF;

Line 306: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute14,p_old_Header_Payment_rec.attribute14)

302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13;
304: END IF;
305:
306: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute14,p_old_Header_Payment_rec.attribute14)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14;
310: END IF;

Line 312: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute15,p_old_Header_Payment_rec.attribute15)

308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14;
310: END IF;
311:
312: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute15,p_old_Header_Payment_rec.attribute15)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15;
316: END IF;

Line 318: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.context,p_old_Header_Payment_rec.context)

314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15;
316: END IF;
317:
318: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.context,p_old_Header_Payment_rec.context)
319: THEN
320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CONTEXT;
322: END IF;

Line 324: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.created_by,p_old_Header_Payment_rec.created_by)

320: l_index := l_index + 1;
321: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CONTEXT;
322: END IF;
323:
324: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.created_by,p_old_Header_Payment_rec.created_by)
325: THEN
326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATED_BY;
328: END IF;

Line 330: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.creation_date,p_old_Header_Payment_rec.creation_date)

326: l_index := l_index + 1;
327: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATED_BY;
328: END IF;
329:
330: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.creation_date,p_old_Header_Payment_rec.creation_date)
331: THEN
332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE;
334: END IF;

Line 336: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_updated_by,p_old_Header_Payment_rec.last_updated_by)

332: l_index := l_index + 1;
333: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE;
334: END IF;
335:
336: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_updated_by,p_old_Header_Payment_rec.last_updated_by)
337: THEN
338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY;
340: END IF;

Line 342: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_date,p_old_Header_Payment_rec.last_update_date)

338: l_index := l_index + 1;
339: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY;
340: END IF;
341:
342: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_date,p_old_Header_Payment_rec.last_update_date)
343: THEN
344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE;
346: END IF;

Line 348: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_login,p_old_Header_Payment_rec.last_update_login)

344: l_index := l_index + 1;
345: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE;
346: END IF;
347:
348: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_login,p_old_Header_Payment_rec.last_update_login)
349: THEN
350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN;
352: END IF;

Line 354: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.check_number,p_old_Header_Payment_rec.check_number)

350: l_index := l_index + 1;
351: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN;
352: END IF;
353:
354: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.check_number,p_old_Header_Payment_rec.check_number)
355: THEN
356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER;
358: END IF;

Line 360: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_code,p_old_Header_Payment_rec.credit_card_approval_code)

356: l_index := l_index + 1;
357: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER;
358: END IF;
359:
360: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_code,p_old_Header_Payment_rec.credit_card_approval_code)
361: THEN
362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE;
364: END IF;

Line 366: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_date,p_old_Header_Payment_rec.credit_card_approval_date)

362: l_index := l_index + 1;
363: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE;
364: END IF;
365:
366: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_date,p_old_Header_Payment_rec.credit_card_approval_date)
367: THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
370: END IF;

Line 372: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_code,p_old_Header_Payment_rec.credit_card_code)

368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
370: END IF;
371:
372: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_code,p_old_Header_Payment_rec.credit_card_code)
373: THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_CODE;
376: END IF;

Line 378: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_expiration_date,p_old_Header_Payment_rec.credit_card_expiration_date)

374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_CODE;
376: END IF;
377:
378: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_expiration_date,p_old_Header_Payment_rec.credit_card_expiration_date)
379: THEN
380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
382: END IF;

Line 384: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_holder_name,p_old_Header_Payment_rec.credit_card_holder_name)

380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
382: END IF;
383:
384: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_holder_name,p_old_Header_Payment_rec.credit_card_holder_name)
385: THEN
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME;
388: END IF;

Line 394: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

390: --Since the credit card numbers are encrypted, passing both the credit card
391: --numbers as well as instrument ids to determine if both the old and new
392: --values point to the same credit card number.
393:
394: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
395: p_x_Header_Payment_rec.credit_card_number,p_old_instrument_id,
396: p_x_instrument_id)
397: THEN
398: l_index := l_index + 1;

Line 402: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_level_code,p_old_Header_Payment_rec.payment_level_code)

398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER;
400: END IF;
401:
402: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_level_code,p_old_Header_Payment_rec.payment_level_code)
403: THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE;
406: END IF;

Line 408: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_applied_amount,p_old_Header_Payment_rec.commitment_applied_amount)

404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE;
406: END IF;
407:
408: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_applied_amount,p_old_Header_Payment_rec.commitment_applied_amount)
409: THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT;
412: END IF;

Line 414: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_interfaced_amount,p_old_Header_Payment_rec.commitment_interfaced_amount)

410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT;
412: END IF;
413:
414: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_interfaced_amount,p_old_Header_Payment_rec.commitment_interfaced_amount)
415: THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT;
418: END IF;

Line 420: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_number,p_old_Header_Payment_rec.payment_number)

416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT;
418: END IF;
419:
420: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_number,p_old_Header_Payment_rec.payment_number)
421: THEN
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER;
424: END IF;

Line 426: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.header_id,p_old_Header_Payment_rec.header_id)

422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER;
424: END IF;
425:
426: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.header_id,p_old_Header_Payment_rec.header_id)
427: THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_HEADER;
430: END IF;

Line 432: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.line_id,p_old_Header_Payment_rec.line_id)

428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_HEADER;
430: END IF;
431:
432: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.line_id,p_old_Header_Payment_rec.line_id)
433: THEN
434: l_index := l_index + 1;
435: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LINE;
436: END IF;

Line 438: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_amount,p_old_Header_Payment_rec.payment_amount)

434: l_index := l_index + 1;
435: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LINE;
436: END IF;
437:
438: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_amount,p_old_Header_Payment_rec.payment_amount)
439: THEN
440: l_index := l_index + 1;
441: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT;
442: END IF;

Line 445: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_collection_event,p_old_Header_Payment_rec.payment_collection_event)

441: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT;
442: END IF;
443:
444:
445: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_collection_event,p_old_Header_Payment_rec.payment_collection_event)
446: THEN
447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT;
449: END IF;

Line 451: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_trx_id,p_old_Header_Payment_rec.payment_trx_id)

447: l_index := l_index + 1;
448: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT;
449: END IF;
450:
451: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_trx_id,p_old_Header_Payment_rec.payment_trx_id)
452: THEN
453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
455: END IF;

Line 457: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)

453: l_index := l_index + 1;
454: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
455: END IF;
456:
457: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)
458: THEN
459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE;
461: END IF;

Line 463: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_set_id,p_old_Header_Payment_rec.payment_set_id)

459: l_index := l_index + 1;
460: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE;
461: END IF;
462:
463: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_set_id,p_old_Header_Payment_rec.payment_set_id)
464: THEN
465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID;
467: END IF;

Line 469: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.prepaid_amount,p_old_Header_Payment_rec.prepaid_amount)

465: l_index := l_index + 1;
466: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID;
467: END IF;
468:
469: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.prepaid_amount,p_old_Header_Payment_rec.prepaid_amount)
470: THEN
471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT;
473: END IF;

Line 475: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_application_id,p_old_Header_Payment_rec.program_application_id)

471: l_index := l_index + 1;
472: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT;
473: END IF;
474:
475: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_application_id,p_old_Header_Payment_rec.program_application_id)
476: THEN
477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID;
479: END IF;

Line 481: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_id,p_old_Header_Payment_rec.program_id)

477: l_index := l_index + 1;
478: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID;
479: END IF;
480:
481: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_id,p_old_Header_Payment_rec.program_id)
482: THEN
483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID;
485: END IF;

Line 487: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_update_date,p_old_Header_Payment_rec.program_update_date)

483: l_index := l_index + 1;
484: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID;
485: END IF;
486:
487: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_update_date,p_old_Header_Payment_rec.program_update_date)
488: THEN
489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE;
491: END IF;

Line 493: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.receipt_method_id,p_old_Header_Payment_rec.receipt_method_id)

489: l_index := l_index + 1;
490: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE;
491: END IF;
492:
493: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.receipt_method_id,p_old_Header_Payment_rec.receipt_method_id)
494: THEN
495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
497: END IF;

Line 499: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.request_id,p_old_Header_Payment_rec.request_id)

495: l_index := l_index + 1;
496: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
497: END IF;
498:
499: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.request_id,p_old_Header_Payment_rec.request_id)
500: THEN
501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID;
503: END IF;

Line 505: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.tangible_id,p_old_Header_Payment_rec.tangible_id)

501: l_index := l_index + 1;
502: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID;
503: END IF;
504:
505: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.tangible_id,p_old_Header_Payment_rec.tangible_id)
506: THEN
507: l_index := l_index + 1;
508: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID;
509: END IF;

Line 654: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

650:
651: If l_src_attr_tbl.COUNT <> 0 THEN
652:
653: OE_Dependencies.Mark_Dependent
654: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
655: p_source_attr_tbl => l_src_attr_tbl,
656: p_dep_attr_tbl => l_dep_attr_tbl);
657:
658: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP

Line 709: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE, p_old_Header_Payment_rec.CREDIT_CARD_APPROVAL_CODE)

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

Line 717: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE, p_old_Header_Payment_rec.CREDIT_CARD_APPROVAL_DATE)

713: THEN
714: p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
715: END IF;
716: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE THEN
717: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE, p_old_Header_Payment_rec.CREDIT_CARD_APPROVAL_DATE)
718: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
719: p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE IS NOT NULL)
720: ) -- AND condition added to fix 3098878
721: THEN

Line 725: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_CODE, p_old_Header_Payment_rec.CREDIT_CARD_CODE)

721: THEN
722: p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
723: END IF;
724: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_CODE THEN
725: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_CODE, p_old_Header_Payment_rec.CREDIT_CARD_CODE)
726: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
727: p_x_Header_PAYMENT_rec.CREDIT_CARD_CODE IS NOT NULL)
728: ) -- AND condition added to fix 3098878
729: THEN

Line 733: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE, p_old_Header_Payment_rec.CREDIT_CARD_EXPIRATION_DATE)

729: THEN
730: p_x_Header_PAYMENT_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
731: END IF;
732: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
733: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE, p_old_Header_Payment_rec.CREDIT_CARD_EXPIRATION_DATE)
734: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
735: p_x_Header_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE IS NOT NULL)
736: ) -- AND condition added to fix 3098878
737: THEN

Line 741: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.credit_card_holder_name, p_old_Header_Payment_rec.credit_card_holder_name)

737: THEN
738: p_x_Header_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
739: END IF;
740: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
741: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.credit_card_holder_name, p_old_Header_Payment_rec.credit_card_holder_name)
742: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
743: p_x_Header_PAYMENT_rec.credit_card_holder_name IS NOT NULL)
744: ) -- AND condition added to fix 3098878
745: THEN

Line 749: IF (OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.CREDIT_CARD_NUMBER,

745: THEN
746: p_x_Header_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
747: END IF;
748: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER THEN
749: IF (OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.CREDIT_CARD_NUMBER,
750: p_x_Header_PAYMENT_rec.CREDIT_CARD_NUMBER,p_old_instrument_id,p_x_instrument_id)
751: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
752: p_x_Header_PAYMENT_rec.CREDIT_CARD_NUMBER IS NOT NULL)
753: ) -- AND condition added to fix 3098878

Line 991: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute1,p_old_Header_Payment_rec.attribute1)

987:
988: -- Load out record
989:
990: oe_debug_pub.add('Trxn_extension id ksurendr'||p_x_Header_Payment_rec.trxn_extension_id);
991: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute1,p_old_Header_Payment_rec.attribute1)
992: THEN
993: NULL;
994: END IF;
995:

Line 996: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute2,p_old_Header_Payment_rec.attribute2)

992: THEN
993: NULL;
994: END IF;
995:
996: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute2,p_old_Header_Payment_rec.attribute2)
997: THEN
998: NULL;
999: END IF;
1000:

Line 1001: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute3,p_old_Header_Payment_rec.attribute3)

997: THEN
998: NULL;
999: END IF;
1000:
1001: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute3,p_old_Header_Payment_rec.attribute3)
1002: THEN
1003: NULL;
1004: END IF;
1005:

Line 1006: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute4,p_old_Header_Payment_rec.attribute4)

1002: THEN
1003: NULL;
1004: END IF;
1005:
1006: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute4,p_old_Header_Payment_rec.attribute4)
1007: THEN
1008: NULL;
1009: END IF;
1010:

Line 1011: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute5,p_old_Header_Payment_rec.attribute5)

1007: THEN
1008: NULL;
1009: END IF;
1010:
1011: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute5,p_old_Header_Payment_rec.attribute5)
1012: THEN
1013: NULL;
1014: END IF;
1015:

Line 1016: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute6,p_old_Header_Payment_rec.attribute6)

1012: THEN
1013: NULL;
1014: END IF;
1015:
1016: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute6,p_old_Header_Payment_rec.attribute6)
1017: THEN
1018: NULL;
1019: END IF;
1020:

Line 1021: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute7,p_old_Header_Payment_rec.attribute7)

1017: THEN
1018: NULL;
1019: END IF;
1020:
1021: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute7,p_old_Header_Payment_rec.attribute7)
1022: THEN
1023: NULL;
1024: END IF;
1025:

Line 1026: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute8,p_old_Header_Payment_rec.attribute8)

1022: THEN
1023: NULL;
1024: END IF;
1025:
1026: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute8,p_old_Header_Payment_rec.attribute8)
1027: THEN
1028: NULL;
1029: END IF;
1030:

Line 1031: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute9,p_old_Header_Payment_rec.attribute9)

1027: THEN
1028: NULL;
1029: END IF;
1030:
1031: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute9,p_old_Header_Payment_rec.attribute9)
1032: THEN
1033: NULL;
1034: END IF;
1035:

Line 1036: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute10,p_old_Header_Payment_rec.attribute10)

1032: THEN
1033: NULL;
1034: END IF;
1035:
1036: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute10,p_old_Header_Payment_rec.attribute10)
1037: THEN
1038: NULL;
1039: END IF;
1040:

Line 1041: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute11,p_old_Header_Payment_rec.attribute11)

1037: THEN
1038: NULL;
1039: END IF;
1040:
1041: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute11,p_old_Header_Payment_rec.attribute11)
1042: THEN
1043: NULL;
1044: END IF;
1045:

Line 1046: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute12,p_old_Header_Payment_rec.attribute12)

1042: THEN
1043: NULL;
1044: END IF;
1045:
1046: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute12,p_old_Header_Payment_rec.attribute12)
1047: THEN
1048: NULL;
1049: END IF;
1050:

Line 1051: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute13,p_old_Header_Payment_rec.attribute13)

1047: THEN
1048: NULL;
1049: END IF;
1050:
1051: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute13,p_old_Header_Payment_rec.attribute13)
1052: THEN
1053: NULL;
1054: END IF;
1055:

Line 1056: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute14,p_old_Header_Payment_rec.attribute14)

1052: THEN
1053: NULL;
1054: END IF;
1055:
1056: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute14,p_old_Header_Payment_rec.attribute14)
1057: THEN
1058: NULL;
1059: END IF;
1060:

Line 1061: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute15,p_old_Header_Payment_rec.attribute15)

1057: THEN
1058: NULL;
1059: END IF;
1060:
1061: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute15,p_old_Header_Payment_rec.attribute15)
1062: THEN
1063: NULL;
1064: END IF;
1065:

Line 1066: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.context,p_old_Header_Payment_rec.context)

1062: THEN
1063: NULL;
1064: END IF;
1065:
1066: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.context,p_old_Header_Payment_rec.context)
1067: THEN
1068: NULL;
1069: END IF;
1070:

Line 1071: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.created_by,p_old_Header_Payment_rec.created_by)

1067: THEN
1068: NULL;
1069: END IF;
1070:
1071: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.created_by,p_old_Header_Payment_rec.created_by)
1072: THEN
1073: NULL;
1074: END IF;
1075:

Line 1076: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.creation_date,p_old_Header_Payment_rec.creation_date)

1072: THEN
1073: NULL;
1074: END IF;
1075:
1076: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.creation_date,p_old_Header_Payment_rec.creation_date)
1077: THEN
1078: NULL;
1079: END IF;
1080:

Line 1081: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_updated_by,p_old_Header_Payment_rec.last_updated_by)

1077: THEN
1078: NULL;
1079: END IF;
1080:
1081: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_updated_by,p_old_Header_Payment_rec.last_updated_by)
1082: THEN
1083: NULL;
1084: END IF;
1085:

Line 1086: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_date,p_old_Header_Payment_rec.last_update_date)

1082: THEN
1083: NULL;
1084: END IF;
1085:
1086: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_date,p_old_Header_Payment_rec.last_update_date)
1087: THEN
1088: NULL;
1089: END IF;
1090:

Line 1091: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_login,p_old_Header_Payment_rec.last_update_login)

1087: THEN
1088: NULL;
1089: END IF;
1090:
1091: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.last_update_login,p_old_Header_Payment_rec.last_update_login)
1092: THEN
1093: NULL;
1094: END IF;
1095:

Line 1096: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.check_number,p_old_Header_Payment_rec.check_number)

1092: THEN
1093: NULL;
1094: END IF;
1095:
1096: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.check_number,p_old_Header_Payment_rec.check_number)
1097: THEN
1098: l_payments_update_flag := 'Y';
1099: END IF;
1100:

Line 1101: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_code,p_old_Header_Payment_rec.credit_card_approval_code)

1097: THEN
1098: l_payments_update_flag := 'Y';
1099: END IF;
1100:
1101: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_code,p_old_Header_Payment_rec.credit_card_approval_code)
1102: THEN
1103: l_payments_update_flag := 'Y';
1104: END IF;
1105:

Line 1106: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_date,p_old_Header_Payment_rec.credit_card_approval_date)

1102: THEN
1103: l_payments_update_flag := 'Y';
1104: END IF;
1105:
1106: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_approval_date,p_old_Header_Payment_rec.credit_card_approval_date)
1107: THEN
1108: l_payments_update_flag := 'Y';
1109: END IF;
1110:

Line 1111: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_code,p_old_Header_Payment_rec.credit_card_code)

1107: THEN
1108: l_payments_update_flag := 'Y';
1109: END IF;
1110:
1111: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_code,p_old_Header_Payment_rec.credit_card_code)
1112: THEN
1113: l_payments_update_flag := 'Y';
1114: END IF;
1115: --IF l_debug_level > 0 THEN

Line 1120: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_expiration_date,p_old_Header_Payment_rec.credit_card_expiration_date)

1116: --oe_debug_pub.add('Old Expiration date in apply attribute changes '||p_old_Header_Payment_rec.credit_card_expiration_date);
1117: --oe_debug_pub.add('New Expiration date'||p_x_Header_Payment_rec.credit_card_expiration_date);
1118: --END IF;
1119:
1120: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_expiration_date,p_old_Header_Payment_rec.credit_card_expiration_date)
1121: THEN
1122: l_payments_update_flag := 'Y';
1123: END IF;
1124: --IF l_debug_level > 0 THEN

Line 1129: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_holder_name,p_old_Header_Payment_rec.credit_card_holder_name)

1125: --oe_debug_pub.add('Old cc holder name'||p_old_Header_Payment_rec.credit_card_holder_name);
1126: --oe_debug_pub.add('New cc holder name'||p_x_Header_Payment_rec.credit_card_holder_name);
1127: --END IF;
1128:
1129: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.credit_card_holder_name,p_old_Header_Payment_rec.credit_card_holder_name)
1130: THEN
1131: l_payments_update_flag := 'Y';
1132: END IF;
1133: --R12 CC Encryption

Line 1138: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

1134: --Since the credit card numbers are encrypted, passing both the credit card
1135: --numbers as well as instrument ids to determine if both the old and new
1136: --values point to the same credit card number.
1137:
1138: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
1139: p_x_Header_Payment_rec.credit_card_number,
1140: p_old_Header_Payment_rec.cc_instrument_id,
1141: p_x_Header_Payment_rec.cc_instrument_id)
1142: THEN

Line 1149: AND OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)) THEN

1145: END IF;
1146: l_payments_update_flag := 'Y';
1147: --CC Reversal ER#16014135 start
1148: IF (p_x_Header_Payment_rec.operation ='UPDATE'
1149: AND OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)) THEN
1150: l_verify_payment_flag:='Y';
1151: END IF;
1152: --CC Reversal ER#16014135 end
1153:

Line 1157: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_level_code,p_old_Header_Payment_rec.payment_level_code)

1153:
1154:
1155: END IF;
1156:
1157: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_level_code,p_old_Header_Payment_rec.payment_level_code)
1158: THEN
1159: l_payments_update_flag := 'Y';
1160: END IF;
1161:

Line 1162: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_applied_amount,p_old_Header_Payment_rec.commitment_applied_amount)

1158: THEN
1159: l_payments_update_flag := 'Y';
1160: END IF;
1161:
1162: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_applied_amount,p_old_Header_Payment_rec.commitment_applied_amount)
1163: THEN
1164: NULL;
1165: --CC Reversal ER#16014135 start
1166: l_verify_payment_flag:='Y';

Line 1173: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_interfaced_amount,p_old_Header_Payment_rec.commitment_interfaced_amount)

1169: END IF;
1170: --CC Reversal ER#16014135 end
1171: END IF;
1172:
1173: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.commitment_interfaced_amount,p_old_Header_Payment_rec.commitment_interfaced_amount)
1174: THEN
1175: NULL;
1176: --CC Reversal ER#16014135 start
1177: l_verify_payment_flag:='Y';

Line 1184: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_number,p_old_Header_Payment_rec.payment_number)

1180: END IF;
1181: --CC Reversal ER#16014135 end
1182: END IF;
1183:
1184: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_number,p_old_Header_Payment_rec.payment_number)
1185: THEN
1186: NULL;
1187: END IF;
1188:

Line 1189: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.header_id,p_old_Header_Payment_rec.header_id)

1185: THEN
1186: NULL;
1187: END IF;
1188:
1189: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.header_id,p_old_Header_Payment_rec.header_id)
1190: THEN
1191: NULL;
1192: END IF;
1193:

Line 1194: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.line_id,p_old_Header_Payment_rec.line_id)

1190: THEN
1191: NULL;
1192: END IF;
1193:
1194: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.line_id,p_old_Header_Payment_rec.line_id)
1195: THEN
1196: NULL;
1197: END IF;
1198:

Line 1200: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.trxn_extension_id,p_old_Header_Payment_rec.trxn_extension_id)

1196: NULL;
1197: END IF;
1198:
1199: --R12 CC Encryption
1200: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.trxn_extension_id,p_old_Header_Payment_rec.trxn_extension_id)
1201: THEN
1202: NULL;
1203: --CC Reversal ER#16014135 start
1204: l_verify_payment_flag:='Y';

Line 1211: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.instrument_security_code,p_old_Header_Payment_rec.instrument_security_code)

1207: END IF;
1208: --CC Reversal ER#16014135 end
1209: END IF;
1210:
1211: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.instrument_security_code,p_old_Header_Payment_rec.instrument_security_code)
1212: THEN
1213: NULL;
1214: END IF;
1215: --R12 CC Encryption

Line 1218: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_amount,p_old_Header_Payment_rec.payment_amount)

1214: END IF;
1215: --R12 CC Encryption
1216:
1217:
1218: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_amount,p_old_Header_Payment_rec.payment_amount)
1219: THEN
1220: l_payments_update_flag := 'Y';
1221:
1222: --bug3507871 start

Line 1235: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

1231: END IF;
1232:
1233:
1234: OE_delayed_requests_Pvt.log_request
1235: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1236: p_entity_id => p_x_Header_Payment_rec.header_id,
1237: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1238: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1239: p_request_type => OE_GLOBALS.G_APPLY_PPP_HOLD,

Line 1237: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

1233:
1234: OE_delayed_requests_Pvt.log_request
1235: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1236: p_entity_id => p_x_Header_Payment_rec.header_id,
1237: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1238: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1239: p_request_type => OE_GLOBALS.G_APPLY_PPP_HOLD,
1240: x_return_status => l_return_status);
1241: END IF;

Line 1239: p_request_type => OE_GLOBALS.G_APPLY_PPP_HOLD,

1235: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1236: p_entity_id => p_x_Header_Payment_rec.header_id,
1237: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1238: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1239: p_request_type => OE_GLOBALS.G_APPLY_PPP_HOLD,
1240: x_return_status => l_return_status);
1241: END IF;
1242: EXCEPTION
1243: WHEN no_data_found THEN

Line 1253: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_collection_event,p_old_Header_Payment_rec.payment_collection_event)

1249: END IF;
1250: --bug3507871 end
1251: END IF;
1252:
1253: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_collection_event,p_old_Header_Payment_rec.payment_collection_event)
1254: THEN
1255: l_payments_update_flag := 'Y';
1256:
1257: -- if changing from credit card invoice payment to a prepayment

Line 1279: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.defer_payment_processing_flag,p_old_Header_Payment_rec.defer_payment_processing_flag)

1275: -- collection event, and press Process Payment button.
1276: OE_Prepayment_PVT.g_process_pmt_req_logged := 'N';
1277: END IF;
1278:
1279: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.defer_payment_processing_flag,p_old_Header_Payment_rec.defer_payment_processing_flag)
1280: THEN
1281: NULL;
1282: END IF;
1283:

Line 1284: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_trx_id,p_old_Header_Payment_rec.payment_trx_id)

1280: THEN
1281: NULL;
1282: END IF;
1283:
1284: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_trx_id,p_old_Header_Payment_rec.payment_trx_id)
1285: THEN
1286: NULL;
1287: END IF;
1288:

Line 1289: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)

1285: THEN
1286: NULL;
1287: END IF;
1288:
1289: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)
1290: THEN
1291: l_payments_update_flag := 'Y';
1292:
1293: --if changing from credit card invoice payment to any other invoice payment.

Line 1323: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new)

1319: FROM oe_payment_types_vl
1320: WHERE payment_type_code=p_x_Header_Payment_rec.payment_type_code;
1321:
1322: IF l_booked_flag = 'Y' AND
1323: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new)
1324: -- AND nvl(l_cc_flag_new, 'N') = 'Y'
1325: THEN
1326:
1327: IF( l_debug_level > 0) THEN

Line 1333: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

1329: oe_debug_pub.add('pviprana: logging a new payment delayed request for processing the payment', 1);
1330: END IF;
1331:
1332: OE_delayed_requests_Pvt.log_request
1333: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1334: p_entity_id => p_x_Header_Payment_rec.header_id,
1335: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1336: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1337: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,

Line 1335: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

1331:
1332: OE_delayed_requests_Pvt.log_request
1333: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1334: p_entity_id => p_x_Header_Payment_rec.header_id,
1335: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1336: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1337: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,
1338: x_return_status => l_return_status);
1339:

Line 1337: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,

1333: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1334: p_entity_id => p_x_Header_Payment_rec.header_id,
1335: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1336: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1337: p_request_type => OE_GLOBALS.G_PROCESS_PAYMENT,
1338: x_return_status => l_return_status);
1339:
1340: -- set the global value, to be used in process_payment
1341: -- API to not call credit checking redundantly.

Line 1355: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_set_id,p_old_Header_Payment_rec.payment_set_id)

1351: --bug3625027 end
1352:
1353: END IF;
1354:
1355: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_set_id,p_old_Header_Payment_rec.payment_set_id)
1356: THEN
1357: NULL;
1358: END IF;
1359:

Line 1360: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.prepaid_amount,p_old_Header_Payment_rec.prepaid_amount)

1356: THEN
1357: NULL;
1358: END IF;
1359:
1360: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.prepaid_amount,p_old_Header_Payment_rec.prepaid_amount)
1361: THEN
1362: NULL;
1363: END IF;
1364:

Line 1365: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_application_id,p_old_Header_Payment_rec.program_application_id)

1361: THEN
1362: NULL;
1363: END IF;
1364:
1365: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_application_id,p_old_Header_Payment_rec.program_application_id)
1366: THEN
1367: NULL;
1368: END IF;
1369:

Line 1370: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_id,p_old_Header_Payment_rec.program_id)

1366: THEN
1367: NULL;
1368: END IF;
1369:
1370: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_id,p_old_Header_Payment_rec.program_id)
1371: THEN
1372: NULL;
1373: END IF;
1374:

Line 1375: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_update_date,p_old_Header_Payment_rec.program_update_date)

1371: THEN
1372: NULL;
1373: END IF;
1374:
1375: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_update_date,p_old_Header_Payment_rec.program_update_date)
1376: THEN
1377: NULL;
1378: END IF;
1379:

Line 1380: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.receipt_method_id,p_old_Header_Payment_rec.receipt_method_id)

1376: THEN
1377: NULL;
1378: END IF;
1379:
1380: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.receipt_method_id,p_old_Header_Payment_rec.receipt_method_id)
1381: THEN
1382: NULL;
1383: END IF;
1384:

Line 1385: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.request_id,p_old_Header_Payment_rec.request_id)

1381: THEN
1382: NULL;
1383: END IF;
1384:
1385: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.request_id,p_old_Header_Payment_rec.request_id)
1386: THEN
1387: NULL;
1388: END IF;
1389:

Line 1390: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.tangible_id,p_old_Header_Payment_rec.tangible_id)

1386: THEN
1387: NULL;
1388: END IF;
1389:
1390: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.tangible_id,p_old_Header_Payment_rec.tangible_id)
1391: THEN
1392: NULL;
1393: END IF;
1394:

Line 1439: NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

1435: (((nvl(p_payment_type_code, '-1') <> nvl(p_x_header_payment_rec.payment_type_code, '-1') or
1436: -- nvl(p_payment_amount, -1) <> nvl(p_x_header_payment_rec.payment_amount,-1) or
1437: nvl(p_check_number, '-1') <> nvl(p_x_header_payment_rec.check_number, '-1') or nvl(p_credit_card_code, '-1') <> nvl(p_x_header_payment_rec.credit_card_code, '-1') or
1438: nvl(p_credit_card_holder_name, '-1') <> nvl(p_x_header_payment_rec.credit_card_holder_name, '-1') or
1439: NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
1440: p_x_Header_Payment_rec.credit_card_number,
1441: p_old_Header_Payment_rec.cc_instrument_id,
1442: p_x_Header_Payment_rec.cc_instrument_id) or
1443: nvl(p_credit_card_expiration_date,sysdate) <> nvl(p_x_header_payment_rec.credit_card_expiration_date, nvl((p_credit_card_expiration_date - 1),sysdate))) and

Line 1453: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

1449:
1450: oe_debug_pub.add('logging synch from UHPMB.pls payment delayed request', 1);
1451:
1452: OE_delayed_requests_Pvt.log_request
1453: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1454: p_entity_id => p_x_Header_Payment_rec.header_id,
1455: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1456: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1457: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,

Line 1455: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

1451:
1452: OE_delayed_requests_Pvt.log_request
1453: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1454: p_entity_id => p_x_Header_Payment_rec.header_id,
1455: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1456: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1457: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
1458: p_param1 => 'UPDATE_HEADER',
1459: x_return_status => l_return_status);

Line 1457: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,

1453: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1454: p_entity_id => p_x_Header_Payment_rec.header_id,
1455: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1456: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1457: p_request_type => OE_GLOBALS.G_UPDATE_HDR_PAYMENT,
1458: p_param1 => 'UPDATE_HEADER',
1459: x_return_status => l_return_status);
1460:
1461:

Line 1476: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

1472: l_delete_pmt_param1 := 'VERIFY_PAYMENT';
1473: END IF;
1474:
1475: OE_delayed_requests_Pvt.log_request
1476: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1477: p_entity_id => p_x_Header_Payment_rec.header_id,
1478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1479: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1480: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,

Line 1478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

1474:
1475: OE_delayed_requests_Pvt.log_request
1476: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1477: p_entity_id => p_x_Header_Payment_rec.header_id,
1478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1479: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1480: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,
1481: p_param1 => l_delete_pmt_param1,
1482: x_return_status => l_return_status);

Line 1480: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,

1476: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1477: p_entity_id => p_x_Header_Payment_rec.header_id,
1478: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1479: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1480: p_request_type => OE_GLOBALS.G_DELETE_PAYMENT_HOLD,
1481: p_param1 => l_delete_pmt_param1,
1482: x_return_status => l_return_status);
1483: END IF;
1484:

Line 1487: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)

1483: END IF;
1484:
1485: --ER#7479609 start
1486: --ER#7479609 start
1487: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_type_code,p_old_Header_Payment_rec.payment_type_code)
1488: THEN
1489: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1490:
1491: OE_delayed_requests_Pvt.log_request

Line 1492: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

1488: THEN
1489: oe_debug_pub.add('logging Delayed request for evaluation of payments hold', 1);
1490:
1491: OE_delayed_requests_Pvt.log_request
1492: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1493: p_entity_id => p_x_Header_Payment_rec.header_id,
1494: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1495: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1496: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,

Line 1494: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

1490:
1491: OE_delayed_requests_Pvt.log_request
1492: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1493: p_entity_id => p_x_Header_Payment_rec.header_id,
1494: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1495: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1496: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
1497: p_request_unique_key1 => 'PAYMENT_TYPE',
1498: p_param1 => 'P',

Line 1496: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,

1492: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
1493: p_entity_id => p_x_Header_Payment_rec.header_id,
1494: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1495: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1496: p_request_type => OE_GLOBALS.G_EVAL_HOLD_SOURCE,
1497: p_request_unique_key1 => 'PAYMENT_TYPE',
1498: p_param1 => 'P',
1499: p_param2 => p_x_Header_Payment_rec.payment_type_code,
1500: x_return_status => l_return_status);

Line 1511: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1507: oe_debug_pub.ADD('OEXUHPMB: Logging delayed request for Verify Payment CC Reversal',5);
1508: END IF;
1509: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1510: OE_delayed_requests_Pvt.log_request
1511: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1512: p_entity_id => p_x_Header_Payment_rec.header_id,
1513: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1514: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1515: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

Line 1513: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,

1509: oe_verify_payment_pub.G_credit_check_flag := 'N' ;
1510: OE_delayed_requests_Pvt.log_request
1511: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1512: p_entity_id => p_x_Header_Payment_rec.header_id,
1513: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1514: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1515: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1516: x_return_status => l_return_status);
1517: END IF;

Line 1515: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,

1511: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1512: p_entity_id => p_x_Header_Payment_rec.header_id,
1513: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
1514: p_requesting_entity_id => p_x_Header_Payment_rec.header_id,
1515: p_request_type => OE_GLOBALS.G_VERIFY_PAYMENT,
1516: x_return_status => l_return_status);
1517: END IF;
1518: --CC Reversal ER#16014135 end
1519:

Line 2354: l_new_header_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;

2350: --added notification framework
2351: --check code release level first. Notification framework is at Pack H level
2352: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2353: /* Set the operation on the record so that globals are updated as well */
2354: l_new_header_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2355: l_new_header_Payment_rec.header_id := p_header_id;
2356: l_new_header_Payment_rec.payment_number := l_pmt.payment_number;
2357: l_new_header_Payment_rec.payment_collection_event := l_pmt.payment_collection_event;
2358: --l_new_header_Payment_rec.payment_type_code := l_pmt.

Line 2441: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,

2437: --R12 CC Encryption
2438: END LOOP;
2439:
2440: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
2441: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_PAYMENT,
2442: p_entity_id => p_header_id,
2443: x_return_status => l_return_status
2444: );
2445:

Line 2498: l_new_header_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;

2494: --added notification framework
2495: --check code release level first. Notification framework is at Pack H level
2496: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2497: /* Set the operation on the record so that globals are updated as well */
2498: l_new_header_Payment_rec.operation := OE_GLOBALS.G_OPR_DELETE;
2499: l_new_header_Payment_rec.payment_number := p_payment_number;
2500: l_new_header_Payment_rec.header_id := p_header_id;
2501: /* OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
2502: p_Hdr_pmt_rec =>l_new_header_Payment_rec,

Line 2549: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_Payment,

2545: END IF; /*code_release_level*/
2546: -- notification framework end
2547:
2548: OE_Delayed_Requests_Pvt.Delete_Reqs_for_deleted_entity(
2549: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_Payment,
2550: p_entity_id => p_header_id,
2551: x_return_status => l_return_status
2552: );
2553:

Line 3160: IF OE_GLOBALS.Equal(p_x_Header_Payment_rec.lock_control,

3156:
3157: -- Row locked. If the whole record is passed, then
3158: -- Compare IN attributes to DB attributes.
3159:
3160: IF OE_GLOBALS.Equal(p_x_Header_Payment_rec.lock_control,
3161: l_lock_control)
3162: THEN
3163:
3164: -- Row has not changed. Set out parameter.

Line 3385: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_collection_event,

3381: BEGIN
3382:
3383: IF (p_Header_Payment_rec.payment_collection_event IS NULL OR
3384: p_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND
3385: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_collection_event,
3386: p_old_Header_Payment_rec.payment_collection_event)
3387: THEN
3388: l_Header_Payment_val_rec.payment_collection_event_name := OE_Id_To_Value.payment_collection_event_name
3389: ( p_payment_collection_event => p_Header_Payment_rec.payment_collection_event

Line 3395: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.receipt_method_id,

3391: END IF;
3392:
3393: IF (p_Header_Payment_rec.receipt_method_id IS NULL OR
3394: p_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND
3395: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.receipt_method_id,
3396: p_old_Header_Payment_rec.receipt_method_id)
3397: THEN
3398: l_Header_Payment_val_rec.receipt_method := OE_Id_To_Value.Receipt_Method
3399: ( p_receipt_method => p_Header_Payment_rec.receipt_method_id

Line 3405: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_type_code,

3401: END IF;
3402:
3403: IF (p_Header_Payment_rec.payment_type_code IS NULL OR
3404: p_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
3405: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_type_code,
3406: p_old_Header_Payment_rec.payment_type_code)
3407: THEN
3408: l_Header_Payment_val_rec.payment_type := OE_Id_To_Value.payment_type
3409: ( p_payment_type_code => p_Header_Payment_rec.payment_type_code

Line 3640: AND p_x_header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

3636: END IF;
3637:
3638: IF p_x_header_Payment_rec.trxn_extension_id IS NOT NULL AND
3639: p_x_header_Payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3640: AND p_x_header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
3641: nvl(oe_order_cache.g_header_rec.source_document_type_id, -99) <> 2 -- not a copy order Verify
3642: THEN
3643: --R12 CC Encryption
3644: --for orders coming from outside of Order Management, we need to call Oracle

Line 3673: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

3669: END;
3670:
3671: p_x_header_payment_rec.trxn_extension_id := l_trxn_extension_id;
3672:
3673: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3674:
3675: IF l_debug_level > 0 THEN
3676: oe_debug_pub.add('trxn id'||p_x_header_payment_rec.trxn_Extension_id);
3677: oe_debug_pub.add('payemnt type'||p_x_header_payment_rec.payment_type_Code);

Line 3678: IF OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

3674:
3675: IF l_debug_level > 0 THEN
3676: oe_debug_pub.add('trxn id'||p_x_header_payment_rec.trxn_Extension_id);
3677: oe_debug_pub.add('payemnt type'||p_x_header_payment_rec.payment_type_Code);
3678: IF OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3679: p_x_Header_Payment_rec.credit_card_number,
3680: p_old_Header_Payment_rec.cc_instrument_id,
3681: p_x_Header_Payment_rec.cc_instrument_id) THEN
3682: oe_debug_pub.add('same cc true');

Line 3686: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_holder_name,

3682: oe_debug_pub.add('same cc true');
3683: ELSE
3684: oe_debug_pub.add('diff cc');
3685: END IF;
3686: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_holder_name,
3687: p_x_header_Payment_rec.credit_card_holder_name) THEN
3688: oe_debug_pub.add('Same name');
3689: ELSE
3690: oe_debug_pub.add('Diff name');

Line 3692: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_expiration_date,

3688: oe_debug_pub.add('Same name');
3689: ELSE
3690: oe_debug_pub.add('Diff name');
3691: END IF;
3692: if OE_GLOBALS.Equal(p_old_header_Payment_rec.credit_card_expiration_date,
3693: p_x_header_Payment_rec.credit_card_expiration_date) THEN
3694: oe_debug_pub.add('Same date');
3695: ELSE
3696: oe_debug_pub.add('Diff date');

Line 3698: if OE_GLOBALS.Equal(p_old_header_payment_rec.instrument_security_code,

3694: oe_debug_pub.add('Same date');
3695: ELSE
3696: oe_debug_pub.add('Diff date');
3697: END IF;
3698: if OE_GLOBALS.Equal(p_old_header_payment_rec.instrument_security_code,
3699: p_x_header_payment_rec.instrument_security_code) THEN
3700: oe_debug_pub.add('Same cvv2');
3701: ELSE
3702: oe_debug_pub.add('Diff cvv2');

Line 3704: if OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id,

3700: oe_debug_pub.add('Same cvv2');
3701: ELSE
3702: oe_debug_pub.add('Diff cvv2');
3703: END IF;
3704: if OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id,
3705: p_old_header_Payment_rec.payment_trx_id) THEN
3706: oe_debug_pub.add('Same trxid');
3707: ELSE
3708: oe_debug_pub.add('Diff trxid');

Line 3711: IF OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_approval_code,

3707: ELSE
3708: oe_debug_pub.add('Diff trxid');
3709: END IF;
3710: --Bug 7460481
3711: IF OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_approval_code,
3712: p_old_header_Payment_rec.credit_card_approval_code) THEN
3713: oe_debug_pub.add('Same approval code');
3714: ELSE
3715: oe_debug_pub.add('Diff approval code');

Line 3721: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

3717: END IF;
3718: IF p_x_header_payment_rec.trxn_extension_id IS NOT NULL
3719: AND p_x_header_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3720: AND ((p_x_header_Payment_rec.payment_type_code = 'CREDIT_CARD'
3721: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3722: p_x_Header_Payment_rec.credit_card_number,
3723: p_old_Header_Payment_rec.cc_instrument_id,
3724: p_x_Header_Payment_rec.cc_instrument_id)
3725: AND p_x_header_Payment_rec.credit_card_holder_name =

Line 3729: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date ,

3725: AND p_x_header_Payment_rec.credit_card_holder_name =
3726: p_old_header_Payment_rec.credit_card_holder_name
3727: --12661167 AND p_x_header_Payment_rec.credit_card_expiration_date =
3728: --12661167 p_old_header_Payment_rec.credit_card_expiration_date
3729: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date ,
3730: p_old_header_Payment_rec.credit_card_expiration_date) --12661167
3731: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.instrument_security_code, --Using OE_GLOBALS.Equal for cvv2
3732: p_old_header_payment_rec.instrument_security_code) --as cvv2 might be null for certain cards
3733: --Bug 7460481

Line 3731: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.instrument_security_code, --Using OE_GLOBALS.Equal for cvv2

3727: --12661167 AND p_x_header_Payment_rec.credit_card_expiration_date =
3728: --12661167 p_old_header_Payment_rec.credit_card_expiration_date
3729: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date ,
3730: p_old_header_Payment_rec.credit_card_expiration_date) --12661167
3731: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.instrument_security_code, --Using OE_GLOBALS.Equal for cvv2
3732: p_old_header_payment_rec.instrument_security_code) --as cvv2 might be null for certain cards
3733: --Bug 7460481
3734: AND OE_GLOBALS.Equal(p_x_header_payment_rec.credit_card_approval_code,
3735: p_old_header_Payment_rec.credit_card_approval_code))

Line 3734: AND OE_GLOBALS.Equal(p_x_header_payment_rec.credit_card_approval_code,

3730: p_old_header_Payment_rec.credit_card_expiration_date) --12661167
3731: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.instrument_security_code, --Using OE_GLOBALS.Equal for cvv2
3732: p_old_header_payment_rec.instrument_security_code) --as cvv2 might be null for certain cards
3733: --Bug 7460481
3734: AND OE_GLOBALS.Equal(p_x_header_payment_rec.credit_card_approval_code,
3735: p_old_header_Payment_rec.credit_card_approval_code))
3736: OR (p_x_header_Payment_rec.payment_type_code IN ('ACH','DIRECT_DEBIT')
3737: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id, p_old_header_Payment_rec.payment_trx_id))
3738: OR (p_x_header_Payment_rec.payment_type_code IN ('CASH','WIRE_TRANSFER'))) THEN

Line 3737: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id, p_old_header_Payment_rec.payment_trx_id))

3733: --Bug 7460481
3734: AND OE_GLOBALS.Equal(p_x_header_payment_rec.credit_card_approval_code,
3735: p_old_header_Payment_rec.credit_card_approval_code))
3736: OR (p_x_header_Payment_rec.payment_type_code IN ('ACH','DIRECT_DEBIT')
3737: AND OE_GLOBALS.Equal(p_x_header_Payment_rec.payment_trx_id, p_old_header_Payment_rec.payment_trx_id))
3738: OR (p_x_header_Payment_rec.payment_type_code IN ('CASH','WIRE_TRANSFER'))) THEN
3739:
3740: --no operation is needed as payment information did not change
3741: IF l_debug_level > 0 THEN

Line 3775: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

3771: --R12 CC Encryption
3772: --Since the credit card numbers are encrypted, passing both the credit card
3773: --numbers as well as instrument ids to determine if both the old and new
3774: --values point to the same credit card number.
3775: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3776: p_x_Header_Payment_rec.credit_card_number,
3777: p_old_Header_Payment_rec.cc_instrument_id,
3778: p_x_Header_Payment_rec.cc_instrument_id)
3779: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,

Line 3779: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,

3775: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3776: p_x_Header_Payment_rec.credit_card_number,
3777: p_old_Header_Payment_rec.cc_instrument_id,
3778: p_x_Header_Payment_rec.cc_instrument_id)
3779: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3780: p_old_header_Payment_rec.credit_card_code) THEN
3781: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3782: p_old_header_Payment_rec.credit_card_holder_name)
3783: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,

Line 3781: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,

3777: p_old_Header_Payment_rec.cc_instrument_id,
3778: p_x_Header_Payment_rec.cc_instrument_id)
3779: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3780: p_old_header_Payment_rec.credit_card_code) THEN
3781: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3782: p_old_header_Payment_rec.credit_card_holder_name)
3783: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3784: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3785: l_update_card_flag := 'Y';

Line 3783: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,

3779: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3780: p_old_header_Payment_rec.credit_card_code) THEN
3781: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3782: p_old_header_Payment_rec.credit_card_holder_name)
3783: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3784: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3785: l_update_card_flag := 'Y';
3786: ELSE
3787: l_update_card_flag := 'N';

Line 3789: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,

3785: l_update_card_flag := 'Y';
3786: ELSE
3787: l_update_card_flag := 'N';
3788: END IF;
3789: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3790: p_old_header_Payment_rec.credit_card_holder_name)
3791: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3792: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3793: l_update_card_flag := 'Y';

Line 3791: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,

3787: l_update_card_flag := 'N';
3788: END IF;
3789: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3790: p_old_header_Payment_rec.credit_card_holder_name)
3791: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3792: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3793: l_update_card_flag := 'Y';
3794: END IF;
3795: Begin

Line 3872: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

3868: --R12 CC Encryption
3869: --Since the credit card numbers are encrypted, passing both the credit card
3870: --numbers as well as instrument ids to determine if both the old and new
3871: --values point to the same credit card number.
3872: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3873: p_x_Header_Payment_rec.credit_card_number,
3874: p_old_Header_Payment_rec.cc_instrument_id,
3875: p_x_Header_Payment_rec.cc_instrument_id)
3876: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,

Line 3876: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,

3872: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3873: p_x_Header_Payment_rec.credit_card_number,
3874: p_old_Header_Payment_rec.cc_instrument_id,
3875: p_x_Header_Payment_rec.cc_instrument_id)
3876: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3877: p_old_header_Payment_rec.credit_card_code) THEN
3878: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3879: p_old_header_Payment_rec.credit_card_holder_name)
3880: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,

Line 3878: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,

3874: p_old_Header_Payment_rec.cc_instrument_id,
3875: p_x_Header_Payment_rec.cc_instrument_id)
3876: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3877: p_old_header_Payment_rec.credit_card_code) THEN
3878: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3879: p_old_header_Payment_rec.credit_card_holder_name)
3880: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3881: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3882: l_update_card_flag := 'Y';

Line 3880: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,

3876: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3877: p_old_header_Payment_rec.credit_card_code) THEN
3878: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3879: p_old_header_Payment_rec.credit_card_holder_name)
3880: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3881: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3882: l_update_card_flag := 'Y';
3883: ELSE
3884: l_update_card_flag := 'N';

Line 3886: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,

3882: l_update_card_flag := 'Y';
3883: ELSE
3884: l_update_card_flag := 'N';
3885: END IF;
3886: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3887: p_old_header_Payment_rec.credit_card_holder_name)
3888: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3889: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3890: l_update_card_flag := 'Y';

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

3884: l_update_card_flag := 'N';
3885: END IF;
3886: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3887: p_old_header_Payment_rec.credit_card_holder_name)
3888: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3889: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3890: l_update_card_flag := 'Y';
3891: END IF;
3892: oe_debug_pub.add('b4 call to update pay...');

Line 3955: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify

3951: IF l_debug_level > 0 THEN
3952: oe_debug_pub.add( 'id already derived for this credit card');
3953: END IF;
3954:
3955: ELSIF p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN --not a copy order Verify
3956:
3957: IF l_debug_level > 0 THEN
3958: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');
3959: END IF;

Line 3981: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,

3977: --R12 CC Encryption
3978: --Since the credit card numbers are encrypted, passing both the credit card
3979: --numbers as well as instrument ids to determine if both the old and new
3980: --values point to the same credit card number.
3981: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3982: p_x_Header_Payment_rec.credit_card_number,
3983: p_old_Header_Payment_rec.cc_instrument_id,
3984: p_x_Header_Payment_rec.cc_instrument_id)
3985: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,

Line 3985: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,

3981: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3982: p_x_Header_Payment_rec.credit_card_number,
3983: p_old_Header_Payment_rec.cc_instrument_id,
3984: p_x_Header_Payment_rec.cc_instrument_id)
3985: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_code,
3986: p_old_header_Payment_rec.credit_card_code) THEN
3987: IF l_debug_level > 0 THEN
3988: oe_debug_pub.add('credit card details changed!');
3989: END IF;

Line 3991: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,

3987: IF l_debug_level > 0 THEN
3988: oe_debug_pub.add('credit card details changed!');
3989: END IF;
3990:
3991: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3992: p_old_header_Payment_rec.credit_card_holder_name)
3993: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3994: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3995: IF l_debug_level > 0 THEN

Line 3993: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,

3989: END IF;
3990:
3991: IF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
3992: p_old_header_Payment_rec.credit_card_holder_name)
3993: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
3994: p_old_header_Payment_rec.credit_card_expiration_date) THEN
3995: IF l_debug_level > 0 THEN
3996: oe_debug_pub.add('Need to call update_card API');
3997: END IF;

Line 4007: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,

4003: END IF;
4004:
4005: l_update_card_flag := 'N';
4006: END IF;
4007: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
4008: p_old_header_Payment_rec.credit_card_holder_name)
4009: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
4010: p_old_header_Payment_rec.credit_card_expiration_date) THEN
4011: IF l_debug_level > 0 THEN

Line 4009: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,

4005: l_update_card_flag := 'N';
4006: END IF;
4007: ELSIF NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_holder_name,
4008: p_old_header_Payment_rec.credit_card_holder_name)
4009: OR NOT OE_GLOBALS.Equal(p_x_header_Payment_rec.credit_card_expiration_date,
4010: p_old_header_Payment_rec.credit_card_expiration_date) THEN
4011: IF l_debug_level > 0 THEN
4012: oe_debug_pub.add('Need to call update_card API 1');
4013: END IF;

Line 4083: p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE

4079:
4080: p_x_header_payment_rec.payment_trx_id := l_bank_acct_id;
4081: END IF;
4082: ELSIF p_x_header_Payment_rec.payment_type_code IN ('CHECK','CASH') AND
4083: p_x_header_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE
4084: AND p_old_header_Payment_rec.trxn_extension_id IS NOT NULL THEN
4085:
4086: --For update operation, the trxn extension id of the original
4087: --transaction needs to be deleted if it already exists as