APPS.OKL_ACCOUNT_DIST_PVT dependencies on OKL_TRX_CONTRACTS

Line 2615: FROM okl_trx_contracts hdr, okl_txl_cntrct_lns lns

2611: -- get the set of books from the trx header .. MG uptake
2612: CURSOR get_ledger_id_csr(p_tcl_id IN NUMBER)
2613: IS
2614: SELECT set_of_books_id
2615: FROM okl_trx_contracts hdr, okl_txl_cntrct_lns lns
2616: WHERE hdr.id = lns.tcn_id
2617: AND lns.id = p_tcl_id;
2618:
2619: l_ledger_id NUMBER;

Line 2789: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';

2785: FETCH get_tcn_id_csr INTO l_tcn_id;
2786: CLOSE get_tcn_id_csr;
2787:
2788: l_tcnv_rec.source_id := l_tcn_id;
2789: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
2790:
2791: --Existing sources are being deleted.
2792: okl_sla_acc_sources_pvt.delete_trx_extension(
2793: p_api_version => l_api_version

Line 3095: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';

3091: FETCH get_tcn_id_csr INTO l_tcn_id;
3092: CLOSE get_tcn_id_csr;
3093:
3094: l_tcnv_rec.source_id := l_tcn_id;
3095: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
3096:
3097: --Existing sources are being deleted.
3098: okl_sla_acc_sources_pvt.delete_trx_extension(
3099: p_api_version => l_api_version

Line 3354: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';

3350: RAISE OKL_API.G_EXCEPTION_ERROR;
3351: END IF;
3352:
3353: l_tcnv_rec.source_id := l_tcn_id;
3354: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
3355:
3356: --Make the call to capture account header source
3357: OKL_SLA_ACC_SOURCES_PVT.populate_tcn_sources(p_api_version => l_api_version
3358: ,p_init_msg_list => l_init_msg_list

Line 3414: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';

3410: IF (l_check_status = 1)
3411: THEN
3412: --Populate header sources
3413: l_tcnv_rec.source_id := l_tcn_id;
3414: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
3415:
3416: --Make the call to capture account header source
3417: OKL_SLA_ACC_SOURCES_PVT.populate_tcn_sources(p_api_version => l_api_version
3418: ,p_init_msg_list => l_init_msg_list

Line 3990: FROM okl_trx_contracts hdr, okl_txl_cntrct_lns lns

3986: -- cursor to get the ledger details for a trx header. MG Uptake
3987: CURSOR get_ledger_id_csr(p_tcl_id IN NUMBER)
3988: IS
3989: SELECT set_of_books_id
3990: FROM okl_trx_contracts hdr, okl_txl_cntrct_lns lns
3991: WHERE hdr.id = lns.tcn_id
3992: AND lns.id = p_tcl_id;
3993:
3994: l_ledger_id NUMBER;

Line 5135: FROM okl_trx_contracts

5131: -- get the ledger based on the p_trx_header_id parameter
5132: CURSOR get_ledger_id_csr
5133: IS
5134: SELECT set_of_books_id
5135: FROM okl_trx_contracts
5136: WHERE id = p_trx_header_id;
5137:
5138: l_ledger_id NUMBER;
5139:

Line 5158: okl_trx_contracts_all trx

5154: IS
5155: SELECT distinct dist.accounting_event_id
5156: FROM okl_trns_acc_dstrs_all dist,
5157: okl_txl_cntrct_lns_all txl,
5158: okl_trx_contracts_all trx
5159: WHERE dist.source_id = txl.id
5160: AND txl.tcn_id = trx.id
5161: and trx.id = p_tcn_id;
5162:

Line 5339: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';

5335: 'RELEASE','INVESTOR','SPLIT_ASSET') AND (l_line_tbl.count > 0)
5336: THEN
5337: --Populated for the calls to delete/create Account Sources
5338: l_tcnv_rec.source_id := p_trx_header_id;
5339: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
5340:
5341: OPEN get_acc_event_id(p_trx_header_id);
5342: FETCH get_acc_event_id INTO l_event_id;
5343: CLOSE get_acc_event_id;