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_INSURANCE_POLICIES_PVT dependencies on OKL_K_HEADERS

Line 47: FROM OKL_K_HEADERS_FULL_V

43:
44: -- cursor to get scs_code
45: CURSOR scs_code_csr IS
46: SELECT scs_code
47: FROM OKL_K_HEADERS_FULL_V
48: WHERE id = p_khr_id;
49:
50: BEGIN
51: -- get scs_code

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

1647: and IPYB.territory_code = inr.ic_id
1648: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
1649:
1650:
1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

1649:
1650:
1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;

Line 1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1650:
1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;
1658: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1651: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;
1658: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
1659:

Line 1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1652:
1653: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1654: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1655: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1656: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1657: x_functional_covered_amt NUMBER ;
1658: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
1659:
1660:

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

2956: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)
2957: and IPYB.territory_code = inr.ic_id
2958: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

2957: and IPYB.territory_code = inr.ic_id
2958: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;

Line 2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

2958: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;
2966: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

2959:
2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;
2966: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
2967:

Line 2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

2960: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2961: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2962: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2963: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2964: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2965: x_functional_covered_amt NUMBER ;
2966: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
2967:
2968: BEGIN

Line 3324: FROM OKL_K_HEADERS A,

3320:
3321: l_inc_sty_id_rep NUMBER ; -- MGAAP 7263041
3322: CURSOR check_csr(p_khr_id NUMBER) IS
3323: SELECT A.MULTI_GAAP_YN, B.REPORTING_PDT_ID
3324: FROM OKL_K_HEADERS A,
3325: OKL_PRODUCTS B
3326: WHERE A.ID = p_khr_id
3327: AND A.PDT_ID = B.ID;
3328:

Line 3329: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

3325: OKL_PRODUCTS B
3326: WHERE A.ID = p_khr_id
3327: AND A.PDT_ID = B.ID;
3328:
3329: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
3330: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
3331:
3332: l_total_bill_accrued_rep NUMBER;
3333: l_adjustment_amount_rep NUMBER;

Line 3343: FROM okl_k_headers_full_v

3339: SELECT currency_code
3340: ,currency_conversion_type
3341: -- ,currency_conversion_rate
3342: ,currency_conversion_date
3343: FROM okl_k_headers_full_v
3344: WHERE id = p_ipyv_rec.khr_id ;
3345:
3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

3342: ,currency_conversion_date
3343: FROM okl_k_headers_full_v
3344: WHERE id = p_ipyv_rec.khr_id ;
3345:
3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3348:
3349: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3350: SELECT khr.pdt_id pdt_id

Line 3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

3343: FROM okl_k_headers_full_v
3344: WHERE id = p_ipyv_rec.khr_id ;
3345:
3346: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3348:
3349: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3350: SELECT khr.pdt_id pdt_id
3351: FROM okl_k_headers_v khr

Line 3351: FROM okl_k_headers_v khr

3347: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3348:
3349: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3350: SELECT khr.pdt_id pdt_id
3351: FROM okl_k_headers_v khr
3352: WHERE khr.ID = p_khr_id;
3353:
3354: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
3355: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;

Line 3961: FROM okl_k_headers_full_v

3957: SELECT currency_code
3958: ,currency_conversion_type
3959: -- ,currency_conversion_rate
3960: ,currency_conversion_date
3961: FROM okl_k_headers_full_v
3962: WHERE id = p_ipyv_rec.khr_id ;
3963:
3964: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3965: SELECT khr.pdt_id pdt_id,

Line 3968: FROM okl_k_headers_v khr,

3964: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3965: SELECT khr.pdt_id pdt_id,
3966: khr.multi_gaap_yn mylti_gaap_yn, -- MGAAP
3967: pdt.reporting_pdt_id reporting_pdt_id
3968: FROM okl_k_headers_v khr,
3969: okl_products pdt
3970: WHERE khr.ID = p_khr_id
3971: AND khr.PDT_ID = pdt.ID;
3972:

Line 4004: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

4000: --smoduga..Bug 4493213 fix..08-aug-2005..end
4001:
4002:
4003: l_ptid NUMBER;
4004: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4005: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4006: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
4007:
4008: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

Line 4005: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

4001:
4002:
4003: l_ptid NUMBER;
4004: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4005: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4006: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
4007:
4008: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
4009: --l_acct_call_rec l_acc_dtls_csr%ROWTYPE;

Line 4020: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

4016: -- MGAAP start 7263041
4017:
4018: l_strm_type_id_rep NUMBER;
4019: l_adjustment_amount_rep NUMBER;
4020: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
4021: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
4022: l_sob_id NUMBER;
4023: l_total_pay_accrued_rep NUMBER;
4024: l_inc_sty_id_rep NUMBER ;

Line 5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

5885: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5892: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5893:

Line 5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5892: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5893:
5894: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start

Line 5989: FROM okl_k_headers_full_v

5985: CURSOR l_contract_currency_csr IS
5986: SELECT currency_code
5987: ,currency_conversion_type
5988: ,currency_conversion_date
5989: FROM okl_k_headers_full_v
5990: WHERE id = p_ipyv_rec.khr_id ;
5991:
5992:
5993:

Line 5996: FROM okl_k_headers_v khr

5992:
5993:
5994: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
5995: SELECT khr.pdt_id pdt_id
5996: FROM okl_k_headers_v khr
5997: WHERE khr.ID = p_khr_id;
5998:
5999: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
6000: