APPS.OKL_SUBSIDY_POOL_TRX_PVT dependencies on OKL_TRX_SUBSIDY_POOLS

Line 22: -- this procedure inserts records into the OKL_TRX_SUBSIDY_POOLS table

18: -- if the subsidy is not attached with a pool
19: --
20: -- Business Rules : this procedure is used to add to pool balance or reduce from pool
21: -- balance. the trx_type_code determines this action.
22: -- this procedure inserts records into the OKL_TRX_SUBSIDY_POOLS table
23: -- irrespective of trx_type_code. records can never be updated or
24: -- deleted from this table.
25: --
26: -- Parameters : required parameters are source_type_code, source_object_id,

Line 63: lv_subsidy_pool_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;

59: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CREATE_POOL_TRANSACTION';
60: l_return_status VARCHAR2(1);
61: lv_pool_expired VARCHAR2(1);
62: lv_conv_rate NUMBER;
63: lv_subsidy_pool_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
64: lv_subsidy_pool_round_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
65: lv_total_subsidy_amt okl_subsidy_pools_b.total_subsidy_amount%TYPE;
66:
67: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_TRX_PVT.CREATE_POOL_TRANSACTION';

Line 64: lv_subsidy_pool_round_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;

60: l_return_status VARCHAR2(1);
61: lv_pool_expired VARCHAR2(1);
62: lv_conv_rate NUMBER;
63: lv_subsidy_pool_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
64: lv_subsidy_pool_round_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
65: lv_total_subsidy_amt okl_subsidy_pools_b.total_subsidy_amount%TYPE;
66:
67: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_TRX_PVT.CREATE_POOL_TRANSACTION';
68: l_debug_enabled VARCHAR2(10);