eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 4745: FROM okl_invoice_formats_v

4741: CURSOR inv_format_csr(p_invoice_format_code VARCHAR2,
4742: p_invoice_format_id NUMBER) IS
4743: SELECT id,
4744: name
4745: FROM okl_invoice_formats_v
4746: WHERE ((name = p_invoice_format_code
4747: AND
4748: p_invoice_format_code IS NOT NULL)
4749: OR

Line 4757: l_id OKL_INVOICE_FORMATS_V.ID%TYPE;

4753: )
4754: )
4755: AND TRUNC(SYSDATE) between NVL(START_DATE, TRUNC(SYSDATE)) AND NVL(END_DATE,TRUNC(SYSDATE));
4756:
4757: l_id OKL_INVOICE_FORMATS_V.ID%TYPE;
4758: l_name OKL_INVOICE_FORMATS_V.NAME%TYPE;
4759: inv_format_failed EXCEPTION;
4760: l_proc_name VARCHAR2(35) := 'GET_INVOICE_FORMAT_ID';
4761:

Line 4758: l_name OKL_INVOICE_FORMATS_V.NAME%TYPE;

4754: )
4755: AND TRUNC(SYSDATE) between NVL(START_DATE, TRUNC(SYSDATE)) AND NVL(END_DATE,TRUNC(SYSDATE));
4756:
4757: l_id OKL_INVOICE_FORMATS_V.ID%TYPE;
4758: l_name OKL_INVOICE_FORMATS_V.NAME%TYPE;
4759: inv_format_failed EXCEPTION;
4760: l_proc_name VARCHAR2(35) := 'GET_INVOICE_FORMAT_ID';
4761:
4762: BEGIN

Line 7749: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;

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;
7751: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7752: x_index_id okl_indices.id%TYPE;
7753:

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

Line 21702: x_invoice_format_name okl_invoice_formats_v.name%TYPE;

21698: x_bank_account_id NUMBER := NULL;
21699: x_bill_to_address_id NUMBER := NULL;
21700: x_invoice_format_id NUMBER := NULL;
21701: x_payment_method_id NUMBER := NULL;
21702: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
21703: l_rgp_id NUMBER;
21704:
21705: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;
21706: BEGIN