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 3473: l_tclv_rec.source_table := 'OKL_TXL_CNTRCT_LNS';

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

Line 3983: FROM OKL_TXL_CNTRCT_LNS tcl

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

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 4026: IF l_dist_info_tbl(l_dist_info_tbl.first).source_table = 'OKL_TXL_CNTRCT_LNS' THEN

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

Line 5128: FROM OKL_TXL_CNTRCT_LNS_ALL tcl

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

Line 5157: okl_txl_cntrct_lns_all txl,

5153: CURSOR get_acc_event_id(p_tcn_id IN NUMBER)
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;

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

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