APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 5106: FROM okx_customer_accounts_v

5102: CURSOR cust_acct_csr(p_cust_id NUMBER,
5103: p_cust_acc_number VARCHAR2,
5104: p_customer_account_id NUMBER) IS
5105: SELECT id1
5106: FROM okx_customer_accounts_v
5107: WHERE ((description = p_cust_acc_number
5108: AND
5109: p_cust_acc_number IS NOT NULL)
5110: OR

Line 5119: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

5115: )
5116: AND party_id = p_cust_id
5117: AND status = 'A';
5118:
5119: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
5120: cust_acct_failed EXCEPTION;
5121: l_proc_name VARCHAR2(35) := 'GET_CUSTOMER_ACCOUNT_ID';
5122:
5123: BEGIN

Line 5199: FROM okx_customer_accounts_v

5195:
5196: CURSOR cust_acct_csr(p_cust_acc_number VARCHAR2,
5197: p_customer_account_id NUMBER) IS
5198: SELECT id1
5199: FROM okx_customer_accounts_v
5200: WHERE ((description = p_cust_acc_number
5201: AND
5202: p_cust_acc_number IS NOT NULL)
5203: OR

Line 5211: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

5207: )
5208: )
5209: AND status = 'A';
5210:
5211: l_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
5212: cust_acct_failed EXCEPTION;
5213: l_proc_name VARCHAR2(35) := 'GET_CUSTOMER_ACCOUNT_ID';
5214:
5215: BEGIN

Line 7914: x_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

7910:
7911: header_rule_failed EXCEPTION;
7912: l_proc_name VARCHAR2(35) := 'CREATE_HEADER_RULES';
7913:
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;

Line 24988: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

24984: WHERE id = p_chr_id
24985: AND end_date >= p_main_start_date;
24986:
24987: l_customer_id OKX_PARTIES_V.ID1%TYPE;
24988: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24989: l_credit_customer_id OKX_PARTIES_V.ID1%TYPE;
24990: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24991: l_rule_count NUMBER;
24992: l_rulv_tbl rulv_tbl_type;

Line 24990: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;

24986:
24987: l_customer_id OKX_PARTIES_V.ID1%TYPE;
24988: l_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24989: l_credit_customer_id OKX_PARTIES_V.ID1%TYPE;
24990: l_credit_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
24991: l_rule_count NUMBER;
24992: l_rulv_tbl rulv_tbl_type;
24993: l_ok VARCHAR2(1) := '?';
24994: