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_INS_QUOTE_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

4649: l_asset_number VARCHAR2(15);
4650: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE ;
4651:
4652: ----- For Multi Currency
4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

4651:
4652: ----- For Multi Currency
4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;

Line 4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

4652: ----- For Multi Currency
4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;
4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

4653: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;
4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
4661:

Line 4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

4654:
4655: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
4656: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4657: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
4658: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4659: x_functional_covered_amt NUMBER ;
4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
4661:
4662: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS

Line 4664: FROM okl_k_headers_full_v

4660: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
4661:
4662: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS
4663: SELECT currency_code , deal_type, AUTHORING_ORG_ID
4664: FROM okl_k_headers_full_v
4665: WHERE id = p_khr_id;
4666:
4667: l_fun_deal_amount NUMBER;
4668: l_fun_total_oec NUMBER;

Line 4669: l_authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE;

4665: WHERE id = p_khr_id;
4666:
4667: l_fun_deal_amount NUMBER;
4668: l_fun_total_oec NUMBER;
4669: l_authoring_org_id okl_k_headers_full_v.authoring_org_id%TYPE;
4670: --- for Organization
4671: l_inv_org_id NUMBER;
4672:
4673: --- Loan Contract

Line 5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

5369: l_dummy_var VARCHAR(1) := '?' ;
5370: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE ;
5371:
5372:
5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

5371:
5372:
5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;

Line 5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

5372:
5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;
5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

5373: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;
5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
5381:

Line 5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

5374:
5375: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
5376: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5377: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
5378: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5379: x_functional_covered_amt NUMBER ;
5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
5381:
5382: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS

Line 5384: FROM okl_k_headers_full_v

5380: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
5381:
5382: CURSOR l_contract_currency_csr(p_khr_id IN NUMBER) IS
5383: SELECT currency_code, start_date
5384: FROM okl_k_headers_full_v
5385: WHERE id = p_khr_id;
5386: x_func_calculated_premium NUMBER ;
5387: l_con_start_date DATE ;
5388: