APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 4913: FROM okl_invoice_formats_v

4909: CURSOR inv_format_csr(p_invoice_format_code VARCHAR2,
4910: p_invoice_format_id NUMBER) IS
4911: SELECT id,
4912: name
4913: FROM okl_invoice_formats_v
4914: WHERE ((name = p_invoice_format_code
4915: AND
4916: p_invoice_format_code IS NOT NULL)
4917: OR

Line 4925: l_id OKL_INVOICE_FORMATS_V.ID%TYPE;

4921: )
4922: )
4923: AND TRUNC(SYSDATE) between NVL(START_DATE, TRUNC(SYSDATE)) AND NVL(END_DATE,TRUNC(SYSDATE));
4924:
4925: l_id OKL_INVOICE_FORMATS_V.ID%TYPE;
4926: l_name OKL_INVOICE_FORMATS_V.NAME%TYPE;
4927: inv_format_failed EXCEPTION;
4928: l_proc_name VARCHAR2(35) := 'GET_INVOICE_FORMAT_ID';
4929:

Line 4926: l_name OKL_INVOICE_FORMATS_V.NAME%TYPE;

4922: )
4923: AND TRUNC(SYSDATE) between NVL(START_DATE, TRUNC(SYSDATE)) AND NVL(END_DATE,TRUNC(SYSDATE));
4924:
4925: l_id OKL_INVOICE_FORMATS_V.ID%TYPE;
4926: l_name OKL_INVOICE_FORMATS_V.NAME%TYPE;
4927: inv_format_failed EXCEPTION;
4928: l_proc_name VARCHAR2(35) := 'GET_INVOICE_FORMAT_ID';
4929:
4930: BEGIN

Line 7917: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;

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;
7919: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7920: x_index_id okl_indices.id%TYPE;
7921:

Line 7919: x_invoice_format_name okl_invoice_formats_v.name%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;
7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;

Line 21888: x_invoice_format_name okl_invoice_formats_v.name%TYPE;

21884: x_bank_account_id NUMBER := NULL;
21885: x_bill_to_address_id NUMBER := NULL;
21886: x_invoice_format_id NUMBER := NULL;
21887: x_payment_method_id NUMBER := NULL;
21888: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
21889: l_rgp_id NUMBER;
21890:
21891: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;
21892: BEGIN