DBA Data[Home] [Help]

APPS.OE_DEFAULT_PVT dependencies on OE_AK_LINE_PAYMENTS_V

Line 100: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

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
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);

Line 280: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

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;
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;

Line 353: ELSIF p_database_object_name = 'OE_AK_LINE_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
357: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code;

Line 423: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'

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
427: THEN

Line 436: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

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:
440: IF l_credit_card_number IS NOT NULL AND

Line 472: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

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
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;

Line 552: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'

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
556: THEN

Line 571: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

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:
575: IF l_credit_card_number IS NOT NULL AND

Line 1637: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN

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;
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