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 1632: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;

1628: and IPYB.territory_code = inr.ic_id
1629: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
1630:
1631:
1632: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1633:
1634: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1635: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1636: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

Line 1634: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

1630:
1631:
1632: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1633:
1634: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1635: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1636: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1637: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1638: x_functional_covered_amt NUMBER ;

Line 1635: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1631:
1632: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1633:
1634: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1635: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1636: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1637: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1638: x_functional_covered_amt NUMBER ;
1639: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 1636: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1632: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
1633:
1634: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1635: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1636: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1637: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1638: x_functional_covered_amt NUMBER ;
1639: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
1640:

Line 1637: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1633:
1634: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
1635: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1636: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1637: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1638: x_functional_covered_amt NUMBER ;
1639: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
1640:
1641:

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

2937: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)
2938: and IPYB.territory_code = inr.ic_id
2939: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2940:
2941: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2942: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2943: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2944: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2945: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 2942: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;

2938: and IPYB.territory_code = inr.ic_id
2939: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2940:
2941: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2942: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2943: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2944: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2945: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2946: x_functional_covered_amt NUMBER ;

Line 2943: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

2939: AND IPYB.FACTOR_VALUE BETWEEN inr.FACTOR_RANGE_START AND inr.FACTOR_RANGE_END ;
2940:
2941: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2942: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2943: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2944: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2945: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2946: x_functional_covered_amt NUMBER ;
2947: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;

Line 2944: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

2940:
2941: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2942: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2943: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2944: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2945: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2946: x_functional_covered_amt NUMBER ;
2947: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
2948:

Line 2945: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

2941: l_functional_currency okl_k_headers_full_v.currency_code%TYPE := okl_accounting_util.get_func_curr_code;
2942: x_contract_currency okl_k_headers_full_v.currency_code%TYPE;
2943: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
2944: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
2945: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
2946: x_functional_covered_amt NUMBER ;
2947: p_contract_currency fnd_currencies_vl.currency_code%TYPE ;
2948:
2949: BEGIN

Line 3305: FROM OKL_K_HEADERS A,

3301:
3302: l_inc_sty_id_rep NUMBER ; -- MGAAP 7263041
3303: CURSOR check_csr(p_khr_id NUMBER) IS
3304: SELECT A.MULTI_GAAP_YN, B.REPORTING_PDT_ID
3305: FROM OKL_K_HEADERS A,
3306: OKL_PRODUCTS B
3307: WHERE A.ID = p_khr_id
3308: AND A.PDT_ID = B.ID;
3309:

Line 3310: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

3306: OKL_PRODUCTS B
3307: WHERE A.ID = p_khr_id
3308: AND A.PDT_ID = B.ID;
3309:
3310: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
3311: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
3312:
3313: l_total_bill_accrued_rep NUMBER;
3314: l_adjustment_amount_rep NUMBER;

Line 3324: FROM okl_k_headers_full_v

3320: SELECT currency_code
3321: ,currency_conversion_type
3322: -- ,currency_conversion_rate
3323: ,currency_conversion_date
3324: FROM okl_k_headers_full_v
3325: WHERE id = p_ipyv_rec.khr_id ;
3326:
3327: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3328: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 3327: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

3323: ,currency_conversion_date
3324: FROM okl_k_headers_full_v
3325: WHERE id = p_ipyv_rec.khr_id ;
3326:
3327: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3328: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3329:
3330: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3331: SELECT khr.pdt_id pdt_id

Line 3328: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

3324: FROM okl_k_headers_full_v
3325: WHERE id = p_ipyv_rec.khr_id ;
3326:
3327: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3328: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3329:
3330: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3331: SELECT khr.pdt_id pdt_id
3332: FROM okl_k_headers_v khr

Line 3332: FROM okl_k_headers_v khr

3328: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3329:
3330: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3331: SELECT khr.pdt_id pdt_id
3332: FROM okl_k_headers_v khr
3333: WHERE khr.ID = p_khr_id;
3334:
3335: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
3336: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;

Line 3936: FROM okl_k_headers_full_v

3932: SELECT currency_code
3933: ,currency_conversion_type
3934: -- ,currency_conversion_rate
3935: ,currency_conversion_date
3936: FROM okl_k_headers_full_v
3937: WHERE id = p_ipyv_rec.khr_id ;
3938:
3939: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3940: SELECT khr.pdt_id pdt_id,

Line 3943: FROM okl_k_headers_v khr,

3939: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
3940: SELECT khr.pdt_id pdt_id,
3941: khr.multi_gaap_yn mylti_gaap_yn, -- MGAAP
3942: pdt.reporting_pdt_id reporting_pdt_id
3943: FROM okl_k_headers_v khr,
3944: okl_products pdt
3945: WHERE khr.ID = p_khr_id
3946: AND khr.PDT_ID = pdt.ID;
3947:

Line 3979: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

3975: --smoduga..Bug 4493213 fix..08-aug-2005..end
3976:
3977:
3978: l_ptid NUMBER;
3979: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3980: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3981: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
3982:
3983: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

Line 3980: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

3976:
3977:
3978: l_ptid NUMBER;
3979: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
3980: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
3981: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
3982:
3983: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
3984: --l_acct_call_rec l_acc_dtls_csr%ROWTYPE;

Line 3995: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;

3991: -- MGAAP start 7263041
3992:
3993: l_strm_type_id_rep NUMBER;
3994: l_adjustment_amount_rep NUMBER;
3995: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
3996: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
3997: l_sob_id NUMBER;
3998: l_total_pay_accrued_rep NUMBER;
3999: l_inc_sty_id_rep NUMBER ;

Line 5896: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

5892: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5893: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5894: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5895: */
5896: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5897: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5898: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5899: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5900:

Line 5897: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

5893: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5894: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5895: */
5896: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5897: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5898: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5899: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5900:
5901: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start

Line 5996: FROM okl_k_headers_full_v

5992: CURSOR l_contract_currency_csr IS
5993: SELECT currency_code
5994: ,currency_conversion_type
5995: ,currency_conversion_date
5996: FROM okl_k_headers_full_v
5997: WHERE id = p_ipyv_rec.khr_id ;
5998:
5999:
6000:

Line 6003: FROM okl_k_headers_v khr

5999:
6000:
6001: CURSOR l_acc_dtls_csr(p_khr_id IN NUMBER) IS
6002: SELECT khr.pdt_id pdt_id
6003: FROM okl_k_headers_v khr
6004: WHERE khr.ID = p_khr_id;
6005:
6006: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
6007: