APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_RECEIPT_METHODS_V

Line 5009: FROM okx_receipt_methods_v

5005: p_payment_method_id NUMBER,
5006: p_customer_acc_id NUMBER,
5007: p_bill_to_address_id NUMBER) IS
5008: SELECT id1
5009: FROM okx_receipt_methods_v
5010: WHERE ((name = p_payment_method
5011: AND
5012: p_payment_method IS NOT NULL)
5013: OR

Line 5023: l_id OKX_RECEIPT_METHODS_V.ID1%TYPE;

5019: OR
5020: site_use_id IS NULL)
5021: AND TRUNC(SYSDATE) between NVL(START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE));
5022:
5023: l_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
5024: payment_failed EXCEPTION;
5025: l_proc_name VARCHAR2(35) := 'GET_PAYMENT_METHOD_ID';
5026:
5027: BEGIN

Line 7918: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;

7914: x_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
7915: x_bill_to_address_id OKX_CUST_SITE_USES_V.ID1%TYPE;
7916: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
7917: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;
7918: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7919: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7920: x_index_id okl_indices.id%TYPE;
7921:
7922: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;