APPS.OKL_BOOK_CONTROLLER_PVT dependencies on OKL_STREAM_INTERFACES

Line 2003: FROM okl_stream_interfaces

1999:
2000: --cursor to fetch the ESG transaction status
2001: CURSOR extr_strm_gen_status(p_trx_num NUMBER) IS
2002: SELECT sis_code
2003: FROM okl_stream_interfaces
2004: WHERE transaction_number = p_trx_num;
2005:
2006: --cursor to fetch the current contract status
2007: CURSOR get_contract_status(p_khr_id okc_k_headers_b.id%TYPE) IS

Line 2015: FROM okl_stream_interfaces

2011:
2012: --cursor the fetch the ESG trx number and status for the contract
2013: CURSOR get_trx_number(p_khr_id okc_k_headers_b.id%TYPE) IS
2014: SELECT transaction_number, sis_code
2015: FROM okl_stream_interfaces
2016: WHERE khr_id = p_khr_id
2017: AND date_processed =
2018: (SELECT MAX(date_processed)
2019: FROM okl_stream_interfaces

Line 2019: FROM okl_stream_interfaces

2015: FROM okl_stream_interfaces
2016: WHERE khr_id = p_khr_id
2017: AND date_processed =
2018: (SELECT MAX(date_processed)
2019: FROM okl_stream_interfaces
2020: WHERE khr_id = p_khr_id
2021: AND sis_code NOT IN ('PROCESS_COMPLETE','PROCESS_COMPLETE_ERRORS',
2022: 'PROCESSING_FAILED','TIME_OUT','PROCESS_ABORTED', 'SERVER_NA')
2023: );

Line 2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No record found in okl_stream_interfaces for trx_number'||l_trx_number);

2107: OPEN extr_strm_gen_status(l_trx_number);
2108: FETCH extr_strm_gen_status INTO l_sis_code;
2109: IF extr_strm_gen_status%NOTFOUND THEN
2110: p_retcode := 2;
2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No record found in okl_stream_interfaces for trx_number'||l_trx_number);
2112: EXIT;
2113: END IF;
2114: CLOSE extr_strm_gen_status;
2115: