APPS.OKL_ACCOUNT_DIST_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 2505: FROM OKL_TXL_CNTRCT_LNS_ALL tcl

2501:
2502: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)
2503: IS
2504: SELECT tcl.tcn_id
2505: FROM OKL_TXL_CNTRCT_LNS_ALL tcl
2506: WHERE tcl.id = p_source_id;
2507:
2508:
2509: CURSOR get_tai_id_csr(p_source_id IN NUMBER)

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 2642: IF NVL(p_dist_info_rec.source_table, 'OKL_TXL_CNTRCT_LNS') = 'OKL_TXL_CNTRCT_LNS' THEN

2638: get_rep_attributes;
2639:
2640: l_ledger_id := NULL;
2641:
2642: IF NVL(p_dist_info_rec.source_table, 'OKL_TXL_CNTRCT_LNS') = 'OKL_TXL_CNTRCT_LNS' THEN
2643: OPEN get_ledger_id_csr(p_dist_info_rec.source_id);
2644: FETCH get_ledger_id_csr INTO l_ledger_id;
2645: CLOSE get_ledger_id_csr;
2646: END IF;

Line 3475: l_tclv_rec.source_table := 'OKL_TXL_CNTRCT_LNS';

3471: CLOSE get_ext_hdr_csr;
3472:
3473: --Make the call to Capture line sources
3474: l_tclv_rec.source_id := p_dist_info_rec.source_id;
3475: l_tclv_rec.source_table := 'OKL_TXL_CNTRCT_LNS';
3476: l_tclv_rec.teh_id := l_tehv_id;
3477:
3478: --Make the call to capture account header source
3479: OKL_SLA_ACC_SOURCES_PVT.populate_tcl_sources(p_api_version => l_api_version

Line 3985: FROM OKL_TXL_CNTRCT_LNS tcl

3981:
3982: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)
3983: IS
3984: SELECT tcl.tcn_id
3985: FROM OKL_TXL_CNTRCT_LNS tcl
3986: WHERE tcl.id = p_source_id;
3987:
3988: -- cursor to get the ledger details for a trx header. MG Uptake
3989: CURSOR get_ledger_id_csr(p_tcl_id IN NUMBER)

Line 3992: FROM okl_trx_contracts hdr, okl_txl_cntrct_lns lns

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

Line 4028: IF l_dist_info_tbl(l_dist_info_tbl.first).source_table = 'OKL_TXL_CNTRCT_LNS' THEN

4024:
4025: -- get the ledger attributes .. racheruv
4026: get_rep_attributes;
4027:
4028: IF l_dist_info_tbl(l_dist_info_tbl.first).source_table = 'OKL_TXL_CNTRCT_LNS' THEN
4029: OPEN get_ledger_id_csr(l_dist_info_tbl(l_dist_info_tbl.first).source_id);
4030: FETCH get_ledger_id_csr INTO l_ledger_id;
4031: CLOSE get_ledger_id_csr;
4032: END IF;

Line 5132: FROM OKL_TXL_CNTRCT_LNS_ALL tcl

5128:
5129: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)
5130: IS
5131: SELECT tcl.tcn_id
5132: FROM OKL_TXL_CNTRCT_LNS_ALL tcl
5133: WHERE tcl.id = p_source_id;
5134:
5135: -- get the ledger based on the p_trx_header_id parameter
5136: CURSOR get_ledger_id_csr

Line 5161: okl_txl_cntrct_lns_all txl,

5157: CURSOR get_acc_event_id(p_tcn_id IN NUMBER)
5158: IS
5159: SELECT distinct dist.accounting_event_id
5160: FROM okl_trns_acc_dstrs_all dist,
5161: okl_txl_cntrct_lns_all txl,
5162: okl_trx_contracts_all trx
5163: WHERE dist.source_id = txl.id
5164: AND txl.tcn_id = trx.id
5165: and trx.id = p_tcn_id;

Line 5212: IF NVL(p_trx_header_table, 'OKL_TXL_CNTRCT_LNS') = 'OKL_TXL_CNTRCT_LNS' then

5208:
5209: -- get the representation attributes.. MG uptake
5210: get_rep_attributes;
5211:
5212: IF NVL(p_trx_header_table, 'OKL_TXL_CNTRCT_LNS') = 'OKL_TXL_CNTRCT_LNS' then
5213: OPEN get_ledger_id_csr;
5214: FETCH get_ledger_id_csr INTO l_ledger_id;
5215: CLOSE get_ledger_id_csr;
5216: END IF;