APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_RECEIPT_METHODS_V

Line 4841: FROM okx_receipt_methods_v

4837: p_payment_method_id NUMBER,
4838: p_customer_acc_id NUMBER,
4839: p_bill_to_address_id NUMBER) IS
4840: SELECT id1
4841: FROM okx_receipt_methods_v
4842: WHERE ((name = p_payment_method
4843: AND
4844: p_payment_method IS NOT NULL)
4845: OR

Line 4855: l_id OKX_RECEIPT_METHODS_V.ID1%TYPE;

4851: OR
4852: site_use_id IS NULL)
4853: AND TRUNC(SYSDATE) between NVL(START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE));
4854:
4855: l_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
4856: payment_failed EXCEPTION;
4857: l_proc_name VARCHAR2(35) := 'GET_PAYMENT_METHOD_ID';
4858:
4859: BEGIN

Line 7750: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;

7746: x_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
7747: x_bill_to_address_id OKX_CUST_SITE_USES_V.ID1%TYPE;
7748: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
7749: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;
7750: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7751: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7752: x_index_id okl_indices.id%TYPE;
7753:
7754: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;