APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TXD_ASSETS_B

Line 488: -- source table : okl_txd_assets_b

484: WHERE tas.id = txl.tas_id and
485: txl.id = p_source_id;
486:
487: -- Cursor to fetch the transaction number
488: -- source table : okl_txd_assets_b
489: CURSOR c_txd_trans_number_csr (p_source_id NUMBER)
490: IS
491: SELECT tas.trans_number trans_number
492: ,txl.id txl_id

Line 496: ,okl_txd_assets_b txd

492: ,txl.id txl_id
493: ,tas.id tas_id
494: FROM okl_trx_assets tas
495: ,okl_txl_assets_b txl
496: ,okl_txd_assets_b txd
497: WHERE tas.id = txl.tas_id and
498: txl.id = txd.tal_id and
499: txd.id = p_source_id;
500:

Line 4252: -- Validation 2: Source Table should be OKL_TXL_ASSETS_B/OKL_TXD_ASSETS_B only

4248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4249: END IF;
4250: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4251: 'Validation 1 Successfull !');
4252: -- Validation 2: Source Table should be OKL_TXL_ASSETS_B/OKL_TXD_ASSETS_B only
4253: IF p_fxhv_rec.source_table <> G_TRX_ASSETS
4254: THEN
4255: -- Raise an Exception
4256: OKL_API.set_message(

Line 4266: -- Validation 3: Source Table should be OKL_TXL_ASSETS_B/OKL_TXD_ASSETS_B only

4262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4263: END IF;
4264: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4265: 'Validation 2 Successfull !');
4266: -- Validation 3: Source Table should be OKL_TXL_ASSETS_B/OKL_TXD_ASSETS_B only
4267: IF p_fxlv_rec.source_table NOT IN ( G_TXL_ASSETS, G_TXD_ASSETS )
4268: THEN
4269: -- Raise an Exception
4270: OKL_API.set_message(

Line 4455: ELSIF p_fxlv_rec.source_table = 'OKL_TXD_ASSETS_B'

4451: l_fxh_rec.trans_number := t_rec.trans_number;
4452: l_txl_id := t_rec.txl_id;
4453: l_fxh_rec.source_id := t_rec.tas_id;
4454: END LOOP; -- End for c_txl_trans_number_csr
4455: ELSIF p_fxlv_rec.source_table = 'OKL_TXD_ASSETS_B'
4456: THEN
4457: --if source table is OKL_TXD_ASSETS_B
4458: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4459: 'Executing the Cursor c_txd_trans_number_csr. p_source_id=' || p_fxlv_rec.source_id);

Line 4457: --if source table is OKL_TXD_ASSETS_B

4453: l_fxh_rec.source_id := t_rec.tas_id;
4454: END LOOP; -- End for c_txl_trans_number_csr
4455: ELSIF p_fxlv_rec.source_table = 'OKL_TXD_ASSETS_B'
4456: THEN
4457: --if source table is OKL_TXD_ASSETS_B
4458: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4459: 'Executing the Cursor c_txd_trans_number_csr. p_source_id=' || p_fxlv_rec.source_id);
4460: FOR t_rec IN c_txd_trans_number_csr(
4461: p_source_id => p_fxlv_rec.source_id )