APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 4938: FROM okx_customer_accounts_v

4934: CURSOR cust_acct_csr(p_cust_id NUMBER,
4935: p_cust_acc_number VARCHAR2,
4936: p_customer_account_id NUMBER) IS
4937: SELECT id1
4938: FROM okx_customer_accounts_v
4939: WHERE ((description = p_cust_acc_number
4940: AND
4941: p_cust_acc_number IS NOT NULL)
4942: OR

Line 4951: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

4947: )
4948: AND party_id = p_cust_id
4949: AND status = 'A';
4950:
4951: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
4952: cust_acct_failed EXCEPTION;
4953: l_proc_name VARCHAR2(35) := 'GET_CUSTOMER_ACCOUNT_ID';
4954:
4955: BEGIN

Line 5031: FROM okx_customer_accounts_v

5027:
5028: CURSOR cust_acct_csr(p_cust_acc_number VARCHAR2,
5029: p_customer_account_id NUMBER) IS
5030: SELECT id1
5031: FROM okx_customer_accounts_v
5032: WHERE ((description = p_cust_acc_number
5033: AND
5034: p_cust_acc_number IS NOT NULL)
5035: OR

Line 5043: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

5039: )
5040: )
5041: AND status = 'A';
5042:
5043: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
5044: cust_acct_failed EXCEPTION;
5045: l_proc_name VARCHAR2(35) := 'GET_CUSTOMER_ACCOUNT_ID';
5046:
5047: BEGIN

Line 7746: x_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

7742:
7743: header_rule_failed EXCEPTION;
7744: l_proc_name VARCHAR2(35) := 'CREATE_HEADER_RULES';
7745:
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;

Line 24746: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

24742: WHERE id = p_chr_id
24743: AND end_date >= p_main_start_date;
24744:
24745: l_customer_id OKX_PARTIES_V.ID1%TYPE;
24746: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24747: l_credit_customer_id OKX_PARTIES_V.ID1%TYPE;
24748: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24749: l_rule_count NUMBER;
24750: l_rulv_tbl rulv_tbl_type;

Line 24748: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

24744:
24745: l_customer_id OKX_PARTIES_V.ID1%TYPE;
24746: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24747: l_credit_customer_id OKX_PARTIES_V.ID1%TYPE;
24748: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24749: l_rule_count NUMBER;
24750: l_rulv_tbl rulv_tbl_type;
24751: l_ok VARCHAR2(1) := '?';
24752: