3222: -- Nulling record
3223: l_init_tilv_rec okl_til_pvt.tilv_rec_type;
3224:
3225: -- Multi Currency Compliance
3226: l_currency_code okl_ext_sell_invs_b.currency_code%type;
3227: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
3228: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
3229: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
3230:
3223: l_init_tilv_rec okl_til_pvt.tilv_rec_type;
3224:
3225: -- Multi Currency Compliance
3226: l_currency_code okl_ext_sell_invs_b.currency_code%type;
3227: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
3228: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
3229: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
3230:
3231: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
3224:
3225: -- Multi Currency Compliance
3226: l_currency_code okl_ext_sell_invs_b.currency_code%type;
3227: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
3228: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
3229: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
3230:
3231: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
3232: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
3225: -- Multi Currency Compliance
3226: l_currency_code okl_ext_sell_invs_b.currency_code%type;
3227: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
3228: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
3229: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
3230:
3231: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
3232: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
3233:
3228: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
3229: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
3230:
3231: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
3232: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
3233:
3234: CURSOR l_curr_conv_csr( cp_khr_id NUMBER ) IS
3235: SELECT currency_code
3236: ,currency_conversion_type
4254: -- Nulling record
4255: l_init_tilv_rec okl_til_pvt.tilv_rec_type;
4256:
4257: -- Multi Currency Compliance
4258: l_currency_code okl_ext_sell_invs_b.currency_code%type;
4259: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
4260: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
4261: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
4262:
4255: l_init_tilv_rec okl_til_pvt.tilv_rec_type;
4256:
4257: -- Multi Currency Compliance
4258: l_currency_code okl_ext_sell_invs_b.currency_code%type;
4259: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
4260: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
4261: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
4262:
4263: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
4256:
4257: -- Multi Currency Compliance
4258: l_currency_code okl_ext_sell_invs_b.currency_code%type;
4259: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
4260: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
4261: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
4262:
4263: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
4264: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
4257: -- Multi Currency Compliance
4258: l_currency_code okl_ext_sell_invs_b.currency_code%type;
4259: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
4260: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
4261: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
4262:
4263: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
4264: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
4265:
4260: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;
4261: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;
4262:
4263: l_previous_tap_id okl_trx_ap_invoices_b.id%TYPE := NULL;
4264: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;
4265:
4266: CURSOR l_curr_conv_csr( cp_khr_id NUMBER ) IS
4267: SELECT currency_code
4268: ,currency_conversion_type