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
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;
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 ;
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 ;
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:
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:
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;
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 ;
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 ;
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:
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
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;
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
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
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,
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;
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;
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:
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
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: