DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER dependencies on OE_ORDER_HEADERS_ALL

Line 2610: --oe order headers all before calling card details

2606:
2607: IF p_header_rec_type.payment_type_code IN ('CREDIT_CARD') THEN
2608:
2609: --Query to verify payment details are existing in
2610: --oe order headers all before calling card details
2611: --Only if credit card number is null then call card details...!
2612: BEGIN
2613: SELECT
2614: CREDIT_CARD_CODE

Line 2627: FROM OE_ORDER_HEADERS_ALL

2623: l_credit_card_number,
2624: l_credit_card_expiration_date,
2625: l_credit_card_approval_code ,
2626: l_credit_card_approval_date
2627: FROM OE_ORDER_HEADERS_ALL
2628: WHERE HEADER_ID = p_header_rec_type.header_id;
2629: EXCEPTION
2630: WHEN NO_DATA_FOUND THEN
2631: l_credit_card_code := null;