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
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:
4307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4308: END IF;
4309: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4310: 'Validation 1 Successfull !');
4311: -- Validation 2: Source Table should be OKL_TXL_ASSETS_B/OKL_TXD_ASSETS_B only
4312: IF p_fxhv_rec.source_table <> G_TRX_ASSETS
4313: THEN
4314: -- Raise an Exception
4315: OKL_API.set_message(
4321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4322: END IF;
4323: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4324: 'Validation 2 Successfull !');
4325: -- Validation 3: Source Table should be OKL_TXL_ASSETS_B/OKL_TXD_ASSETS_B only
4326: IF p_fxlv_rec.source_table NOT IN ( G_TXL_ASSETS, G_TXD_ASSETS )
4327: THEN
4328: -- Raise an Exception
4329: OKL_API.set_message(
4560: l_fxh_rec.trans_number := t_rec.trans_number;
4561: l_txl_id := t_rec.txl_id;
4562: l_fxh_rec.source_id := t_rec.tas_id;
4563: END LOOP; -- End for c_txl_trans_number_csr
4564: ELSIF p_fxlv_rec.source_table = 'OKL_TXD_ASSETS_B'
4565: THEN
4566: --if source table is OKL_TXD_ASSETS_B
4567: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4568: 'Executing the Cursor c_txd_trans_number_csr. p_source_id=' || p_fxlv_rec.source_id);
4562: l_fxh_rec.source_id := t_rec.tas_id;
4563: END LOOP; -- End for c_txl_trans_number_csr
4564: ELSIF p_fxlv_rec.source_table = 'OKL_TXD_ASSETS_B'
4565: THEN
4566: --if source table is OKL_TXD_ASSETS_B
4567: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
4568: 'Executing the Cursor c_txd_trans_number_csr. p_source_id=' || p_fxlv_rec.source_id);
4569: FOR t_rec IN c_txd_trans_number_csr(
4570: p_source_id => p_fxlv_rec.source_id )