1: PACKAGE BODY OE_Header_Payment_Util AS
2: /* $Header: OEXUHPMB.pls 120.22.12020000.5 2013/03/13 08:40:44 kadiraju ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXUHPMB.pls 120.22.12020000.5 2013/03/13 08:40:44 kadiraju ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Header_Payment_Util';
7:
8: --3382262
9: Procedure Delete_Payment_at_header(p_header_id in number,
10: p_line_id in number := null,
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;
233:
234: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute2,p_old_Header_Payment_rec.attribute2)
235: THEN
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;
239:
240: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute3,p_old_Header_Payment_rec.attribute3)
241: THEN
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;
245:
246: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute4,p_old_Header_Payment_rec.attribute4)
247: THEN
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;
251:
252: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute5,p_old_Header_Payment_rec.attribute5)
253: THEN
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;
257:
258: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute6,p_old_Header_Payment_rec.attribute6)
259: THEN
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;
263:
264: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute7,p_old_Header_Payment_rec.attribute7)
265: THEN
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;
269:
270: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute8,p_old_Header_Payment_rec.attribute8)
271: THEN
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;
275:
276: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute9,p_old_Header_Payment_rec.attribute9)
277: THEN
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;
281:
282: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute10,p_old_Header_Payment_rec.attribute10)
283: THEN
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;
287:
288: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute11,p_old_Header_Payment_rec.attribute11)
289: THEN
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;
293:
294: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute12,p_old_Header_Payment_rec.attribute12)
295: THEN
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;
299:
300: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute13,p_old_Header_Payment_rec.attribute13)
301: THEN
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;
305:
306: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute14,p_old_Header_Payment_rec.attribute14)
307: THEN
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;
311:
312: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute15,p_old_Header_Payment_rec.attribute15)
313: THEN
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;
317:
318: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.context,p_old_Header_Payment_rec.context)
319: THEN
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;
323:
324: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.created_by,p_old_Header_Payment_rec.created_by)
325: THEN
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;
329:
330: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.creation_date,p_old_Header_Payment_rec.creation_date)
331: THEN
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;
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
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;
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
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;
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
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;
353:
354: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.check_number,p_old_Header_Payment_rec.check_number)
355: THEN
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;
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
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;
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
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;
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
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;
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
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;
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
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;
389: --R12 CC Encryption
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
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;
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
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;
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
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;
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
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;
419:
420: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_number,p_old_Header_Payment_rec.payment_number)
421: THEN
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;
425:
426: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.header_id,p_old_Header_Payment_rec.header_id)
427: THEN
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;
431:
432: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.line_id,p_old_Header_Payment_rec.line_id)
433: THEN
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;
437:
438: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_amount,p_old_Header_Payment_rec.payment_amount)
439: THEN
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;
443:
444:
445: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.payment_collection_event,p_old_Header_Payment_rec.payment_collection_event)
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;
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
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;
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
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;
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
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;
468:
469: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.prepaid_amount,p_old_Header_Payment_rec.prepaid_amount)
470: THEN
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;
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
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;
480:
481: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.program_id,p_old_Header_Payment_rec.program_id)
482: THEN
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;
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
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;
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
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;
498:
499: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.request_id,p_old_Header_Payment_rec.request_id)
500: THEN
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;
504:
505: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.tangible_id,p_old_Header_Payment_rec.tangible_id)
506: THEN
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;
510:
511: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
512: l_index := l_index + 1;
509: END IF;
510:
511: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1;
514: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
515: l_index := l_index + 1;
516: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2;
517: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
512: l_index := l_index + 1;
513: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1;
514: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
515: l_index := l_index + 1;
516: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2;
517: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3;
520: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
515: l_index := l_index + 1;
516: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2;
517: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3;
520: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
521: l_index := l_index + 1;
522: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4;
523: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
518: l_index := l_index + 1;
519: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3;
520: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
521: l_index := l_index + 1;
522: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4;
523: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5;
526: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
521: l_index := l_index + 1;
522: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4;
523: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5;
526: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
527: l_index := l_index + 1;
528: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6;
529: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
524: l_index := l_index + 1;
525: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5;
526: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
527: l_index := l_index + 1;
528: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6;
529: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7;
532: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
527: l_index := l_index + 1;
528: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6;
529: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7;
532: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
533: l_index := l_index + 1;
534: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8;
535: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
530: l_index := l_index + 1;
531: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7;
532: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
533: l_index := l_index + 1;
534: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8;
535: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9;
538: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
533: l_index := l_index + 1;
534: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8;
535: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9;
538: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
539: l_index := l_index + 1;
540: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10;
541: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
536: l_index := l_index + 1;
537: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9;
538: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
539: l_index := l_index + 1;
540: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10;
541: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11;
544: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
539: l_index := l_index + 1;
540: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10;
541: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11;
544: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
545: l_index := l_index + 1;
546: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12;
547: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
542: l_index := l_index + 1;
543: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11;
544: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
545: l_index := l_index + 1;
546: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12;
547: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13;
550: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
545: l_index := l_index + 1;
546: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12;
547: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13;
550: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14;
553: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
548: l_index := l_index + 1;
549: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13;
550: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14;
553: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15;
556: ELSIF p_attr_id = G_CREATED_BY THEN
551: l_index := l_index + 1;
552: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14;
553: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15;
556: ELSIF p_attr_id = G_CREATED_BY THEN
557: l_index := l_index + 1;
558: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATED_BY;
559: ELSIF p_attr_id = G_CREATION_DATE THEN
554: l_index := l_index + 1;
555: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15;
556: ELSIF p_attr_id = G_CREATED_BY THEN
557: l_index := l_index + 1;
558: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATED_BY;
559: ELSIF p_attr_id = G_CREATION_DATE THEN
560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE;
562: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
557: l_index := l_index + 1;
558: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATED_BY;
559: ELSIF p_attr_id = G_CREATION_DATE THEN
560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE;
562: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY;
565: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
560: l_index := l_index + 1;
561: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE;
562: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY;
565: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
566: l_index := l_index + 1;
567: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE;
568: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY;
565: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
566: l_index := l_index + 1;
567: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE;
568: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
569: l_index := l_index + 1;
570: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN;
571: ELSIF p_attr_id = G_CHECK_NUMBER THEN
566: l_index := l_index + 1;
567: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE;
568: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
569: l_index := l_index + 1;
570: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN;
571: ELSIF p_attr_id = G_CHECK_NUMBER THEN
572: l_index := l_index + 1;
573: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER;
574: ELSIF p_attr_id = G_CREDIT_CARD_APPROVAL_CODE THEN
569: l_index := l_index + 1;
570: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN;
571: ELSIF p_attr_id = G_CHECK_NUMBER THEN
572: l_index := l_index + 1;
573: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER;
574: ELSIF p_attr_id = G_CREDIT_CARD_APPROVAL_CODE THEN
575: l_index := l_index + 1;
576: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE;
577: ELSIF p_attr_id = G_CREDIT_CARD_APPROVAL_DATE THEN
572: l_index := l_index + 1;
573: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER;
574: ELSIF p_attr_id = G_CREDIT_CARD_APPROVAL_CODE THEN
575: l_index := l_index + 1;
576: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE;
577: ELSIF p_attr_id = G_CREDIT_CARD_APPROVAL_DATE THEN
578: l_index := l_index + 1;
579: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
580: ELSIF p_attr_id = G_CREDIT_CARD_CODE THEN
575: l_index := l_index + 1;
576: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE;
577: ELSIF p_attr_id = G_CREDIT_CARD_APPROVAL_DATE THEN
578: l_index := l_index + 1;
579: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
580: ELSIF p_attr_id = G_CREDIT_CARD_CODE THEN
581: l_index := l_index + 1;
582: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_CODE;
583: ELSIF p_attr_id = G_CREDIT_CARD_EXPIRATION_DATE THEN
578: l_index := l_index + 1;
579: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
580: ELSIF p_attr_id = G_CREDIT_CARD_CODE THEN
581: l_index := l_index + 1;
582: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_CODE;
583: ELSIF p_attr_id = G_CREDIT_CARD_EXPIRATION_DATE THEN
584: l_index := l_index + 1;
585: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
586: ELSIF p_attr_id = G_CREDIT_CARD_HOLDER_NAME THEN
581: l_index := l_index + 1;
582: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_CODE;
583: ELSIF p_attr_id = G_CREDIT_CARD_EXPIRATION_DATE THEN
584: l_index := l_index + 1;
585: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
586: ELSIF p_attr_id = G_CREDIT_CARD_HOLDER_NAME THEN
587: l_index := l_index + 1;
588: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME;
589: ELSIF p_attr_id = G_CREDIT_CARD_NUMBER THEN
584: l_index := l_index + 1;
585: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
586: ELSIF p_attr_id = G_CREDIT_CARD_HOLDER_NAME THEN
587: l_index := l_index + 1;
588: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME;
589: ELSIF p_attr_id = G_CREDIT_CARD_NUMBER THEN
590: l_index := l_index + 1;
591: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER;
592: ELSIF p_attr_id = G_PAYMENT_LEVEL_CODE THEN
587: l_index := l_index + 1;
588: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME;
589: ELSIF p_attr_id = G_CREDIT_CARD_NUMBER THEN
590: l_index := l_index + 1;
591: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER;
592: ELSIF p_attr_id = G_PAYMENT_LEVEL_CODE THEN
593: l_index := l_index + 1;
594: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE;
595: ELSIF p_attr_id = G_COMMITMENT_APPLIED_AMOUNT THEN
590: l_index := l_index + 1;
591: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER;
592: ELSIF p_attr_id = G_PAYMENT_LEVEL_CODE THEN
593: l_index := l_index + 1;
594: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE;
595: ELSIF p_attr_id = G_COMMITMENT_APPLIED_AMOUNT THEN
596: l_index := l_index + 1;
597: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT;
598: ELSIF p_attr_id = G_COMMITMENT_INTERFACED_AMOUNT THEN
593: l_index := l_index + 1;
594: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE;
595: ELSIF p_attr_id = G_COMMITMENT_APPLIED_AMOUNT THEN
596: l_index := l_index + 1;
597: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT;
598: ELSIF p_attr_id = G_COMMITMENT_INTERFACED_AMOUNT THEN
599: l_index := l_index + 1;
600: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT;
601: ELSIF p_attr_id = G_CONTEXT THEN
596: l_index := l_index + 1;
597: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT;
598: ELSIF p_attr_id = G_COMMITMENT_INTERFACED_AMOUNT THEN
599: l_index := l_index + 1;
600: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT;
601: ELSIF p_attr_id = G_CONTEXT THEN
602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CONTEXT;
604: ELSIF p_attr_id = G_PAYMENT_NUMBER THEN
599: l_index := l_index + 1;
600: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT;
601: ELSIF p_attr_id = G_CONTEXT THEN
602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CONTEXT;
604: ELSIF p_attr_id = G_PAYMENT_NUMBER THEN
605: l_index := l_index + 1;
606: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER;
607: ELSIF p_attr_id = G_HEADER THEN
602: l_index := l_index + 1;
603: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_CONTEXT;
604: ELSIF p_attr_id = G_PAYMENT_NUMBER THEN
605: l_index := l_index + 1;
606: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER;
607: ELSIF p_attr_id = G_HEADER THEN
608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_HEADER;
610: ELSIF p_attr_id = G_LINE THEN
605: l_index := l_index + 1;
606: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER;
607: ELSIF p_attr_id = G_HEADER THEN
608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_HEADER;
610: ELSIF p_attr_id = G_LINE THEN
611: l_index := l_index + 1;
612: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LINE;
613: ELSIF p_attr_id = G_PAYMENT_AMOUNT THEN
608: l_index := l_index + 1;
609: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_HEADER;
610: ELSIF p_attr_id = G_LINE THEN
611: l_index := l_index + 1;
612: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LINE;
613: ELSIF p_attr_id = G_PAYMENT_AMOUNT THEN
614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT;
616: ELSIF p_attr_id = G_PAYMENT_COLLECTION_EVENT THEN
611: l_index := l_index + 1;
612: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_LINE;
613: ELSIF p_attr_id = G_PAYMENT_AMOUNT THEN
614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT;
616: ELSIF p_attr_id = G_PAYMENT_COLLECTION_EVENT THEN
617: l_index := l_index + 1;
618: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT;
619: ELSIF p_attr_id = G_PAYMENT_TRX_ID THEN
614: l_index := l_index + 1;
615: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT;
616: ELSIF p_attr_id = G_PAYMENT_COLLECTION_EVENT THEN
617: l_index := l_index + 1;
618: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT;
619: ELSIF p_attr_id = G_PAYMENT_TRX_ID THEN
620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
622: ELSIF p_attr_id = G_PAYMENT_TYPE_CODE THEN
617: l_index := l_index + 1;
618: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT;
619: ELSIF p_attr_id = G_PAYMENT_TRX_ID THEN
620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
622: ELSIF p_attr_id = G_PAYMENT_TYPE_CODE THEN
623: l_index := l_index + 1;
624: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE;
625: ELSIF p_attr_id = G_PAYMENT_SET_ID THEN
620: l_index := l_index + 1;
621: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID;
622: ELSIF p_attr_id = G_PAYMENT_TYPE_CODE THEN
623: l_index := l_index + 1;
624: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE;
625: ELSIF p_attr_id = G_PAYMENT_SET_ID THEN
626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID;
628: ELSIF p_attr_id = G_PREPAID_AMOUNT THEN
623: l_index := l_index + 1;
624: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE;
625: ELSIF p_attr_id = G_PAYMENT_SET_ID THEN
626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID;
628: ELSIF p_attr_id = G_PREPAID_AMOUNT THEN
629: l_index := l_index + 1;
630: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT;
631: ELSIF p_attr_id = G_PROGRAM_APPLICATION_ID THEN
626: l_index := l_index + 1;
627: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID;
628: ELSIF p_attr_id = G_PREPAID_AMOUNT THEN
629: l_index := l_index + 1;
630: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT;
631: ELSIF p_attr_id = G_PROGRAM_APPLICATION_ID THEN
632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID;
634: ELSIF p_attr_id = G_PROGRAM_ID THEN
629: l_index := l_index + 1;
630: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT;
631: ELSIF p_attr_id = G_PROGRAM_APPLICATION_ID THEN
632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID;
634: ELSIF p_attr_id = G_PROGRAM_ID THEN
635: l_index := l_index + 1;
636: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID;
637: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
632: l_index := l_index + 1;
633: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID;
634: ELSIF p_attr_id = G_PROGRAM_ID THEN
635: l_index := l_index + 1;
636: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID;
637: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE;
640: ELSIF p_attr_id = G_RECEIPT_METHOD_ID THEN
635: l_index := l_index + 1;
636: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID;
637: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE;
640: ELSIF p_attr_id = G_RECEIPT_METHOD_ID THEN
641: l_index := l_index + 1;
642: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
643: ELSIF p_attr_id = G_REQUEST_ID THEN
638: l_index := l_index + 1;
639: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE;
640: ELSIF p_attr_id = G_RECEIPT_METHOD_ID THEN
641: l_index := l_index + 1;
642: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
643: ELSIF p_attr_id = G_REQUEST_ID THEN
644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID;
646: ELSIF p_attr_id = G_TANGIBLE_ID THEN
641: l_index := l_index + 1;
642: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID;
643: ELSIF p_attr_id = G_REQUEST_ID THEN
644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID;
646: ELSIF p_attr_id = G_TANGIBLE_ID THEN
647: l_index := l_index + 1;
648: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID;
649: END IF;
644: l_index := l_index + 1;
645: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID;
646: ELSIF p_attr_id = G_TANGIBLE_ID THEN
647: l_index := l_index + 1;
648: l_src_attr_tbl(l_index) := OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID;
649: END IF;
650:
651: If l_src_attr_tbl.COUNT <> 0 THEN
652:
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
659: IF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
660: p_x_Header_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
661: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
657:
658: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
659: IF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
660: p_x_Header_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
661: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
659: IF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
660: p_x_Header_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
661: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
661: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER THEN
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER THEN
702: p_x_Header_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
703: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER THEN
702: p_x_Header_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
703: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
704: --R12 CC Encryption
705: --Added the additional conditional before clearing credit
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER THEN
702: p_x_Header_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
703: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
704: --R12 CC Encryption
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
712: ) -- AND condition added to fix 3098878
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
720: ) -- AND condition added to fix 3098878
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
728: ) -- AND condition added to fix 3098878
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
736: ) -- AND condition added to fix 3098878
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
744: ) -- AND condition added to fix 3098878
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)
754: THEN
755: p_x_Header_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
756: END IF;
757: --R12 CC Encryption
758: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
759: p_x_Header_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
760: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
756: END IF;
757: --R12 CC Encryption
758: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
759: p_x_Header_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
760: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
758: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
759: p_x_Header_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
760: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
760: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
791: p_x_Header_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
792: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID THEN
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
791: p_x_Header_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
792: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID THEN
793: p_x_Header_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
794: END IF;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
791: p_x_Header_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
792: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID THEN
793: p_x_Header_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
794: END IF;
795: END LOOP;
796: END IF;
2021: p_hdr_pmt_id => p_header_Payment_rec.payment_number,
2022: x_index => l_index,
2023: x_return_status => l_return_status);*/
2024: IF l_debug_level > 0 THEN
2025: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
2026: END IF;
2027: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: IF l_debug_level > 0 THEN
2029: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2028: IF l_debug_level > 0 THEN
2029: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2030: END IF;
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2033: END IF;
2034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2035: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2036: IF l_debug_level > 0 THEN
2033: END IF;
2034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2035: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2036: IF l_debug_level > 0 THEN
2037: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
2038: END IF;
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2041: END IF;
2036: IF l_debug_level > 0 THEN
2037: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
2038: END IF;
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2041: END IF;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: END IF; /*code_release_level*/
2135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2136: --
2137: BEGIN
2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2140: END IF;
2141:
2142: INSERT INTO OE_PAYMENTS
2143: ( ATTRIBUTE1
2258: p_hdr_pmt_id => p_header_Payment_rec.payment_number,
2259: x_index => l_index,
2260: x_return_status => l_return_status); */
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2263: END IF;
2264: IF l_debug_level > 0 THEN
2265: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2266: END IF;
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2271: END IF;
2272: IF l_debug_level > 0 THEN
2273: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2274: END IF;
2275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2277: IF l_debug_level > 0 THEN
2274: END IF;
2275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2277: IF l_debug_level > 0 THEN
2278: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2279: END IF;
2280: IF l_debug_level > 0 THEN
2281: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2282: END IF;
2277: IF l_debug_level > 0 THEN
2278: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2279: END IF;
2280: IF l_debug_level > 0 THEN
2281: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2282: END IF;
2283: RAISE FND_API.G_EXC_ERROR;
2284: END IF;
2285: END IF; /*code_release_level*/
2285: END IF; /*code_release_level*/
2286: -- notification framework end
2287:
2288: IF l_debug_level > 0 THEN
2289: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2290: END IF;
2291:
2292: EXCEPTION
2293:
2337: l_payment_type_code VARCHAR2(80);
2338: --R12 CC Encryption
2339: BEGIN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2342: END IF;
2343:
2344: IF p_header_id <> FND_API.G_MISS_NUM AND
2345: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2364: x_index => l_index,
2365: x_return_status => l_return_status); */
2366:
2367: IF l_debug_level > 0 THEN
2368: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2369: END IF;
2370: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2371: IF l_debug_level > 0 THEN
2372: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2371: IF l_debug_level > 0 THEN
2372: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2373: END IF;
2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2376: END IF;
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: IF l_debug_level > 0 THEN
2376: END IF;
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2381: END IF;
2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2384: END IF;
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2381: END IF;
2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2384: END IF;
2385: RAISE FND_API.G_EXC_ERROR;
2386: END IF;
2387: END IF; /*code_release_level*/
2418: oe_debug_pub.add('Error message'||sqlerrm);
2419: oe_debug_pub.add('Msg data'||l_msg_data);
2420: END IF;
2421: IF l_debug_level > 0 THEN
2422: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2428: oe_debug_pub.add('Error message'||sqlerrm);
2429: oe_debug_pub.add('Msg data'||l_msg_data);
2430: END IF;
2431: IF l_debug_level > 0 THEN
2428: oe_debug_pub.add('Error message'||sqlerrm);
2429: oe_debug_pub.add('Msg data'||l_msg_data);
2430: END IF;
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2433: END IF;
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;
2436: END IF;
2521: --ER#7479609 end
2522:
2523:
2524: IF l_debug_level > 0 THEN
2525: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2526: END IF;
2527:
2528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: IF l_debug_level > 0 THEN
2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2531: END IF;
2532: IF l_debug_level > 0 THEN
2533: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2534: END IF;
2535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2536: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2537: IF l_debug_level > 0 THEN
2534: END IF;
2535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2536: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2539: END IF;
2540: IF l_debug_level > 0 THEN
2541: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2542: END IF;
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2539: END IF;
2540: IF l_debug_level > 0 THEN
2541: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2542: END IF;
2543: RAISE FND_API.G_EXC_ERROR;
2544: END IF;
2545: END IF; /*code_release_level*/
2591: IF l_debug_level > 0 THEN
2592: oe_debug_pub.add( '2:Delete Payment at Header - UNEXPECTED ERROR' ) ;
2593: END IF;
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2599: IF l_debug_level > 0 THEN
2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2599: IF l_debug_level > 0 THEN
2600: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2601: END IF;
2602: IF l_debug_level > 0 THEN
2603: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2604: END IF;
2599: IF l_debug_level > 0 THEN
2600: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2601: END IF;
2602: IF l_debug_level > 0 THEN
2603: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2604: END IF;
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607: END IF;
2675: END IF;
2676:
2677: END IF;
2678:
2679: oe_debug_pub.add('exiting oe_header_Payment_util.delete_row ',1);
2680:
2681: END IF;
2682:
2683: EXCEPTION
3104: --
3105: BEGIN
3106:
3107: IF l_debug_level > 0 THEN
3108: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.LOCK_ROW' , 1 ) ;
3109: END IF;
3110:
3111: SAVEPOINT Lock_Row;
3112:
3134: IF l_debug_level > 0 THEN
3135: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
3136: END IF;
3137:
3138: OE_Header_Payment_Util.Query_Row
3139: (p_payment_number => l_payment_number
3140: ,p_header_id => l_header_id
3141: ,x_header_Payment_rec => p_x_header_Payment_rec );
3142:
3318: END IF;
3319:
3320: -- locked all
3321:
3322: OE_Header_Payment_Util.Query_Rows
3323: (p_payment_number => p_payment_number
3324: ,p_header_id => p_header_id
3325: ,x_header_Payment_tbl => x_header_Payment_tbl
3326: );
3582:
3583: BEGIN
3584:
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( 'entering oe_header_payment_util.Pre_Write_Process. payment_type_code'||p_x_header_Payment_rec.payment_type_code);
3587: END IF;
3588: --R12 CC Encryption
3589: --Querying the invoice to org id before checking the payment type
3590: --as it is needed for both credit card and check payments.
4138: := ROUND(p_x_header_payment_rec.payment_amount, OE_ORDER_UTIL.G_Precision);
4139: END IF;
4140:
4141: IF l_debug_level > 0 THEN
4142: oe_debug_pub.add('EXITING OE_HEADER_PAYMENT_UTIL.PRE_WRITE_PROCESS');
4143: END IF;
4144:
4145: EXCEPTION
4146: WHEN FND_API.G_EXC_ERROR THEN
4252:
4253: END Delete_Payment_at_header;
4254: --3382262
4255:
4256: END OE_Header_Payment_Util;