399:
400: --Start code added by pgomes on 11/22/2002
401: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
402: l_khr_id khr_id_type;
403: l_currency_code okl_ext_sell_invs_b.currency_code%type;
404: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
405: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
406: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
407:
400: --Start code added by pgomes on 11/22/2002
401: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
402: l_khr_id khr_id_type;
403: l_currency_code okl_ext_sell_invs_b.currency_code%type;
404: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
405: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
406: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
407:
408: --Get currency conversion attributes for a contract
401: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
402: l_khr_id khr_id_type;
403: l_currency_code okl_ext_sell_invs_b.currency_code%type;
404: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
405: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
406: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
407:
408: --Get currency conversion attributes for a contract
409: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
402: l_khr_id khr_id_type;
403: l_currency_code okl_ext_sell_invs_b.currency_code%type;
404: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
405: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
406: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
407:
408: --Get currency conversion attributes for a contract
409: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
410: SELECT currency_code
1820:
1821: --Start code added by pgomes on 11/22/2002
1822: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
1823: l_khr_id khr_id_type;
1824: l_currency_code okl_ext_sell_invs_b.currency_code%type;
1825: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
1826: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
1827: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
1828:
1821: --Start code added by pgomes on 11/22/2002
1822: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
1823: l_khr_id khr_id_type;
1824: l_currency_code okl_ext_sell_invs_b.currency_code%type;
1825: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
1826: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
1827: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
1828:
1829: --Get currency conversion attributes for a contract
1822: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
1823: l_khr_id khr_id_type;
1824: l_currency_code okl_ext_sell_invs_b.currency_code%type;
1825: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
1826: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
1827: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
1828:
1829: --Get currency conversion attributes for a contract
1830: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
1823: l_khr_id khr_id_type;
1824: l_currency_code okl_ext_sell_invs_b.currency_code%type;
1825: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
1826: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
1827: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
1828:
1829: --Get currency conversion attributes for a contract
1830: CURSOR l_curr_conv_csr(cp_khr_id IN khr_id_type) IS
1831: SELECT currency_code