DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on FND_CONCURRENT_REQUESTS

Line 2017: from fnd_concurrent_requests fnd

2013: l_error_cd hr_lookups.lookup_code%TYPE; -- UTF8 varchar2(80);
2014: --
2015: cursor c_threads(p_request_id number) is
2016: select null
2017: from fnd_concurrent_requests fnd
2018: where fnd.phase_code <> 'C'
2019: and fnd.request_id = p_request_id;
2020: --
2021: cursor get_hdr_cnt is

Line 2104: -- To prevent over polling of fnd_concurrent_requests

2100: close c_threads;
2101: --
2102: end loop;
2103: --
2104: -- To prevent over polling of fnd_concurrent_requests
2105: -- like all ben batch processes sleep for a while.
2106: --
2107: If (l_no_threads) then
2108: dbms_lock.sleep(5);

Line 6833: FROM fnd_concurrent_requests

6829:
6830: -- Cursor to get the extract parameters of the last req.
6831: CURSOR csr_req_params ( c_req_id IN NUMBER) IS
6832: SELECT *
6833: FROM fnd_concurrent_requests
6834: WHERE request_id = c_req_id;
6835:
6836: l_conc_params csr_req_params%ROWTYPE;
6837: l_pqp_extract BOOLEAN;

Line 7136: from fnd_concurrent_requests fnd

7132:
7133: --
7134: cursor c_threads(p_request_id number) is
7135: select null
7136: from fnd_concurrent_requests fnd
7137: where /*fnd.phase_code <> 'C' and */
7138: fnd.request_id = p_request_id;
7139: --
7140: cursor c_bg_name is