eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DEFAULT_PVT dependencies on ONT_HEADER_PAYMENT_DEF_HDLR

Line 94: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;

90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
91:
92: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
93:
94: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;
95:
96: OPEN get_hdr_sold_inv(ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id);
97: FETCH get_hdr_sold_inv into l_cust_org_id, l_invoice_to_org_id;
98: CLOSE get_hdr_sold_inv;

Line 96: OPEN get_hdr_sold_inv(ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id);

92: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
93:
94: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;
95:
96: OPEN get_hdr_sold_inv(ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id);
97: FETCH get_hdr_sold_inv into l_cust_org_id, l_invoice_to_org_id;
98: CLOSE get_hdr_sold_inv;
99:
100: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

Line 274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;

270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
277: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
278: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;

Line 275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;

271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
277: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
278: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
279: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;

Line 276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;

272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
277: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
278: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
279: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
280: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

Line 277: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;

273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
277: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
278: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
279: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
280: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
281: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;

Line 349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL

345: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code IS NOT NULL
346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN
347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;
348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR
351: THEN
352: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code;
353: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'

Line 350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR

346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN
347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;
348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR
351: THEN
352: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code;
353: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
354: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL

Line 352: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code;

348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR
351: THEN
352: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code;
353: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
354: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
355: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR
356: THEN

Line 418: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL

414: THEN
415:
416: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name;
417: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
418: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
419: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name
420: <> FND_API.G_MISS_CHAR
421: THEN
422: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;

Line 419: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name

415:
416: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name;
417: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
418: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
419: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name
420: <> FND_API.G_MISS_CHAR
421: THEN
422: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;
423: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'

Line 422: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;

418: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
419: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name
420: <> FND_API.G_MISS_CHAR
421: THEN
422: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;
423: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
424: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
425: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name
426: <> FND_API.G_MISS_CHAR

Line 435: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;

431:
432: /*IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
433: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;
434: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
435: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;
436: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
437: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;
438: END IF;
439:

Line 468: OPEN get_hdr_sold_inv(ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id);

464: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
465:
466: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
467:
468: OPEN get_hdr_sold_inv(ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id);
469: FETCH get_hdr_sold_inv into l_cust_org_id, l_invoice_to_org_id;
470: CLOSE get_hdr_sold_inv;
471:
472: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

Line 547: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL

543: <> FND_API.G_MISS_DATE
544: THEN
545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;
546: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
547: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
548: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
549: <> FND_API.G_MISS_DATE
550: THEN
551: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;

Line 548: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date

544: THEN
545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;
546: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
547: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
548: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
549: <> FND_API.G_MISS_DATE
550: THEN
551: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;
552: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'

Line 551: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;

547: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
548: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
549: <> FND_API.G_MISS_DATE
550: THEN
551: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;
552: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
553: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
554: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
555: <> FND_API.G_MISS_DATE

Line 570: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;

566:
567: /*IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
568: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;
569: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
570: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;
571: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
572: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;
573: END IF;
574:

Line 1631: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;

1627: oe_debug_pub.add('Entering Get_Receipt_Method');
1628: END IF;
1629:
1630: IF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
1631: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;
1632: l_header_id := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id;
1633:
1634: IF l_debug_level > 0 THEN
1635: oe_debug_pub.add('payment_type_code from header payments'||l_payment_type_code);

Line 1632: l_header_id := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id;

1628: END IF;
1629:
1630: IF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
1631: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;
1632: l_header_id := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id;
1633:
1634: IF l_debug_level > 0 THEN
1635: oe_debug_pub.add('payment_type_code from header payments'||l_payment_type_code);
1636: END IF;