DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_EXT_SELL_INVS_B

Line 3226: l_currency_code okl_ext_sell_invs_b.currency_code%type;

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:

Line 3227: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;

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;

Line 3228: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%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;
3232: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;

Line 3229: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;

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:

Line 3232: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;

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

Line 4258: l_currency_code okl_ext_sell_invs_b.currency_code%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:

Line 4259: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;

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;

Line 4260: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%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;
4264: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;

Line 4261: l_currency_conversion_date okl_ext_sell_invs_b.currency_conversion_date%type;

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:

Line 4264: l_previous_xpi_id okl_ext_sell_invs_b.id%TYPE := NULL;

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