eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 494: OKL_TXL_CNTRCT_LNS lns

490:
491: CURSOR get_kle_ids_csr (l_id NUMBER) IS
492: select distinct lns.kle_id
493: from okl_trx_contracts khr,
494: OKL_TXL_CNTRCT_LNS lns
495: where khr.id = l_id
496: and khr.id = lns.tcn_id;
497:
498: l_formula_yn boolean := false;

Line 854: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';

850:
851: FOR i IN x_sec_trx_tclv_tbl.FIRST..x_sec_trx_tclv_tbl.LAST LOOP
852:
853: l_dist_info_tbl(i).SOURCE_ID := x_sec_trx_tclv_tbl(i).ID;
854: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';
855: l_dist_info_tbl(i).GL_REVERSAL_FLAG := 'N';
856: l_dist_info_tbl(i).POST_TO_GL := 'Y';
857: l_dist_info_tbl(i).CONTRACT_ID := l_pri_trx_tcnv_rec.KHR_ID;
858: l_dist_info_tbl(i).CONTRACT_LINE_ID := x_sec_trx_tclv_tbl(i).KLE_ID; -- Bug 7626121

Line 1075: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';

1071: l_tmpl_identify_tbl(i).rev_rec_flag := NULL;
1072: l_tmpl_identify_tbl(i).factoring_synd_flag := NULL;
1073:
1074: l_dist_info_tbl(i).SOURCE_ID := x_sec_trx_tclv_tbl(i).ID;
1075: l_dist_info_tbl(i).SOURCE_TABLE := 'OKL_TXL_CNTRCT_LNS';
1076: l_dist_info_tbl(i).GL_REVERSAL_FLAG := 'N';
1077: l_dist_info_tbl(i).POST_TO_GL := 'Y';
1078: l_dist_info_tbl(i).CONTRACT_ID := l_pri_trx_tcnv_rec.KHR_ID;
1079: l_dist_info_tbl(i).CONTRACT_LINE_ID := x_sec_trx_tclv_tbl(i).KLE_ID; -- Bug 7626121

Line 1198: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

1194:
1195: /* variables */
1196: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_SEC_REP_TRX';
1197: l_api_version CONSTANT NUMBER := 1.0;
1198: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1199: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1200: l_sysdate DATE := SYSDATE;
1201: l_reversal_date DATE;
1202: l_COUNT NUMBER :=0;

Line 1225: FROM OKL_TXL_CNTRCT_LNS txl,

1221:
1222: -- Cursor to select transaction lines for reversal
1223: CURSOR reverse_txl_csr(p_tcn_id NUMBER) IS
1224: SELECT txl.id, txl.amount, txl.currency_code
1225: FROM OKL_TXL_CNTRCT_LNS txl,
1226: OKL_TRX_CONTRACTS trx
1227: WHERE txl.tcn_id = trx.id
1228: AND txl.tcn_id = p_tcn_id
1229: AND trx.tsu_code = 'PROCESSED'