DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER dependencies on OE_ORDER_HEADERS_ALL

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

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

Line 2626: FROM OE_ORDER_HEADERS_ALL

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