DBA Data[Home] [Help]

APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_TRANSACTION_TYPES_ALL

Line 9021: OE_TRANSACTION_TYPES_ALL ordr_type

9017: BEGIN
9018: SELECT NVL(ordr_type.CREDIT_CARD_REV_REAUTH_CODE,oe_sys_parameters.value('OE_CC_REVERSAL_REAUTHORIZATION'))
9019: INTO l_cc_rev_reauth_code
9020: FROM OE_ORDER_HEADERS_ALL ordr ,
9021: OE_TRANSACTION_TYPES_ALL ordr_type
9022: WHERE ordr.ORDER_TYPE_ID = ordr_type.TRANSACTION_TYPE_ID
9023: AND ordr.header_id = p_header_id;
9024: EXCEPTION
9025: WHEN OTHERS THEN