[Home] [Help]
1: PACKAGE BODY OE_Header_Payment_Util AS
2: /* $Header: OEXUHPMB.pls 120.15.12010000.4 2008/11/25 14:23:54 sgoli ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXUHPMB.pls 120.15.12010000.4 2008/11/25 14:23:54 sgoli 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;
1944: p_hdr_pmt_id => p_header_Payment_rec.payment_number,
1945: x_index => l_index,
1946: x_return_status => l_return_status);*/
1947: IF l_debug_level > 0 THEN
1948: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1949: END IF;
1950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1951: IF l_debug_level > 0 THEN
1952: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1951: IF l_debug_level > 0 THEN
1952: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1953: END IF;
1954: IF l_debug_level > 0 THEN
1955: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
1956: END IF;
1957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1959: IF l_debug_level > 0 THEN
1956: END IF;
1957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1959: IF l_debug_level > 0 THEN
1960: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
1961: END IF;
1962: IF l_debug_level > 0 THEN
1963: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
1964: END IF;
1959: IF l_debug_level > 0 THEN
1960: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
1961: END IF;
1962: IF l_debug_level > 0 THEN
1963: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
1964: END IF;
1965: RAISE FND_API.G_EXC_ERROR;
1966: END IF;
1967: END IF; /*code_release_level*/
2053: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2054: --
2055: BEGIN
2056: IF l_debug_level > 0 THEN
2057: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2058: END IF;
2059:
2060: INSERT INTO OE_PAYMENTS
2061: ( ATTRIBUTE1
2172: p_hdr_pmt_id => p_header_Payment_rec.payment_number,
2173: x_index => l_index,
2174: x_return_status => l_return_status); */
2175: IF l_debug_level > 0 THEN
2176: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
2177: END IF;
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2180: END IF;
2183: IF l_debug_level > 0 THEN
2184: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2185: END IF;
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN
2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2193: END IF;
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2196: END IF;
2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2193: END IF;
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199: END IF; /*code_release_level*/
2199: END IF; /*code_release_level*/
2200: -- notification framework end
2201:
2202: IF l_debug_level > 0 THEN
2203: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2204: END IF;
2205:
2206: EXCEPTION
2207:
2251: l_payment_type_code VARCHAR2(80);
2252: --R12 CC Encryption
2253: BEGIN
2254: IF l_debug_level > 0 THEN
2255: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2256: END IF;
2257:
2258: IF p_header_id <> FND_API.G_MISS_NUM AND
2259: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2278: x_index => l_index,
2279: x_return_status => l_return_status); */
2280:
2281: IF l_debug_level > 0 THEN
2282: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2283: END IF;
2284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2285: IF l_debug_level > 0 THEN
2286: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2285: IF l_debug_level > 0 THEN
2286: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2287: END IF;
2288: IF l_debug_level > 0 THEN
2289: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2290: END IF;
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2293: IF l_debug_level > 0 THEN
2290: END IF;
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2295: END IF;
2296: IF l_debug_level > 0 THEN
2297: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2298: END IF;
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2295: END IF;
2296: IF l_debug_level > 0 THEN
2297: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2298: END IF;
2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;
2301: END IF; /*code_release_level*/
2332: oe_debug_pub.add('Error message'||sqlerrm);
2333: oe_debug_pub.add('Msg data'||l_msg_data);
2334: END IF;
2335: IF l_debug_level > 0 THEN
2336: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2337: END IF;
2338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2339: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2340: IF l_debug_level > 0 THEN
2337: END IF;
2338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2339: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2342: oe_debug_pub.add('Error message'||sqlerrm);
2343: oe_debug_pub.add('Msg data'||l_msg_data);
2344: END IF;
2345: IF l_debug_level > 0 THEN
2342: oe_debug_pub.add('Error message'||sqlerrm);
2343: oe_debug_pub.add('Msg data'||l_msg_data);
2344: END IF;
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2347: END IF;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: END IF;
2435: --ER#7479609 end
2436:
2437:
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2440: END IF;
2441:
2442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: IF l_debug_level > 0 THEN
2443: IF l_debug_level > 0 THEN
2444: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2445: END IF;
2446: IF l_debug_level > 0 THEN
2447: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2448: END IF;
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: IF l_debug_level > 0 THEN
2448: END IF;
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2453: END IF;
2454: IF l_debug_level > 0 THEN
2455: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2456: END IF;
2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2453: END IF;
2454: IF l_debug_level > 0 THEN
2455: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2456: END IF;
2457: RAISE FND_API.G_EXC_ERROR;
2458: END IF;
2459: END IF; /*code_release_level*/
2505: IF l_debug_level > 0 THEN
2506: oe_debug_pub.add( '2:Delete Payment at Header - UNEXPECTED ERROR' ) ;
2507: END IF;
2508: IF l_debug_level > 0 THEN
2509: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2510: END IF;
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2513: IF l_debug_level > 0 THEN
2510: END IF;
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2513: IF l_debug_level > 0 THEN
2514: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2515: END IF;
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2518: END IF;
2513: IF l_debug_level > 0 THEN
2514: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2515: END IF;
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2518: END IF;
2519: RAISE FND_API.G_EXC_ERROR;
2520: END IF;
2521: END IF;
2589: END IF;
2590:
2591: END IF;
2592:
2593: oe_debug_pub.add('exiting oe_header_Payment_util.delete_row ',1);
2594:
2595: END IF;
2596:
2597: EXCEPTION
3014: --
3015: BEGIN
3016:
3017: IF l_debug_level > 0 THEN
3018: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.LOCK_ROW' , 1 ) ;
3019: END IF;
3020:
3021: SAVEPOINT Lock_Row;
3022:
3044: IF l_debug_level > 0 THEN
3045: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
3046: END IF;
3047:
3048: OE_Header_Payment_Util.Query_Row
3049: (p_payment_number => l_payment_number
3050: ,p_header_id => l_header_id
3051: ,x_header_Payment_rec => p_x_header_Payment_rec );
3052:
3228: END IF;
3229:
3230: -- locked all
3231:
3232: OE_Header_Payment_Util.Query_Rows
3233: (p_payment_number => p_payment_number
3234: ,p_header_id => p_header_id
3235: ,x_header_Payment_tbl => x_header_Payment_tbl
3236: );
3463:
3464: BEGIN
3465:
3466: IF l_debug_level > 0 THEN
3467: oe_debug_pub.add( 'entering oe_header_payment_util.Pre_Write_Process. payment_type_code'||p_x_header_Payment_rec.payment_type_code);
3468: END IF;
3469: --R12 CC Encryption
3470: --Querying the invoice to org id before checking the payment type
3471: --as it is needed for both credit card and check payments.
4017: := ROUND(p_x_header_payment_rec.payment_amount, OE_ORDER_UTIL.G_Precision);
4018: END IF;
4019:
4020: IF l_debug_level > 0 THEN
4021: oe_debug_pub.add('EXITING OE_HEADER_PAYMENT_UTIL.PRE_WRITE_PROCESS');
4022: END IF;
4023:
4024: EXCEPTION
4025: WHEN FND_API.G_EXC_ERROR THEN
4131:
4132: END Delete_Payment_at_header;
4133: --3382262
4134:
4135: END OE_Header_Payment_Util;