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_LINE_PAYMENT_DEF_HDLR

Line 102: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;

98: CLOSE get_hdr_sold_inv;
99:
100: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
101:
102: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;
103:
104: OPEN get_line_sold_inv(ONT_LINE_PAYMENT_DEF_HDLR.g_record.line_id);
105: FETCH get_line_sold_inv into l_cust_org_id, l_invoice_to_org_id;
106: CLOSE get_line_sold_inv;

Line 104: OPEN get_line_sold_inv(ONT_LINE_PAYMENT_DEF_HDLR.g_record.line_id);

100: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
101:
102: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;
103:
104: OPEN get_line_sold_inv(ONT_LINE_PAYMENT_DEF_HDLR.g_record.line_id);
105: FETCH get_line_sold_inv into l_cust_org_id, l_invoice_to_org_id;
106: CLOSE get_line_sold_inv;
107:
108: END IF;

Line 281: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;

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;
282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
284: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
285: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;

Line 282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;

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;
282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
284: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
285: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
286: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;

Line 283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;

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;
282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
284: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
285: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
286: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
287: END IF;

Line 284: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;

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;
282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
284: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
285: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
286: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
287: END IF;
288:

Line 354: AND ONT_LINE_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
357: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code;
358: END IF;

Line 355: AND ONT_LINE_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
357: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code;
358: END IF;
359: RETURN NULL;

Line 357: RETURN ONT_LINE_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
357: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code;
358: END IF;
359: RETURN NULL;
360:
361: END Get_Credit_Card_Code;

Line 424: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL

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
427: THEN
428: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;

Line 425: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name

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
427: THEN
428: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;
429: END IF;

Line 428: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;

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
427: THEN
428: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;
429: END IF;
430: RETURN NULL;
431:
432: /*IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN

Line 437: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;

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:
440: IF l_credit_card_number IS NOT NULL AND
441: l_credit_card_number <> FND_API.G_MISS_CHAR THEN

Line 474: OPEN get_line_sold_inv(ONT_LINE_PAYMENT_DEF_HDLR.g_record.line_id);

470: CLOSE get_hdr_sold_inv;
471:
472: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
473:
474: OPEN get_line_sold_inv(ONT_LINE_PAYMENT_DEF_HDLR.g_record.line_id);
475: FETCH get_line_sold_inv into l_cust_org_id, l_invoice_to_org_id;
476: CLOSE get_line_sold_inv;
477:
478: END IF;

Line 553: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL

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
556: THEN
557: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;

Line 554: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_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
556: THEN
557: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;
558: END IF;

Line 557: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;

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
556: THEN
557: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;
558: END IF;
559:
560: RETURN NULL;
561:

Line 572: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;

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:
575: IF l_credit_card_number IS NOT NULL AND
576: l_credit_card_number <> FND_API.G_MISS_CHAR THEN

Line 1638: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;

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;
1637: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
1638: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;
1639: l_header_id := ONT_LINE_PAYMENT_DEF_HDLR.g_record.header_id;
1640:
1641: IF l_debug_level > 0 THEN
1642: oe_debug_pub.add('payment_type_code from line payments'||l_payment_type_code ||':org_id:'||l_org_id);

Line 1639: l_header_id := ONT_LINE_PAYMENT_DEF_HDLR.g_record.header_id;

1635: oe_debug_pub.add('payment_type_code from header payments'||l_payment_type_code);
1636: END IF;
1637: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
1638: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;
1639: l_header_id := ONT_LINE_PAYMENT_DEF_HDLR.g_record.header_id;
1640:
1641: IF l_debug_level > 0 THEN
1642: oe_debug_pub.add('payment_type_code from line payments'||l_payment_type_code ||':org_id:'||l_org_id);
1643: END IF;