DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on FND_CONCURRENT_REQUESTS

Line 2019: from fnd_concurrent_requests fnd

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

Line 2106: -- To prevent over polling of fnd_concurrent_requests

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

Line 6874: FROM fnd_concurrent_requests

6870:
6871: -- Cursor to get the extract parameters of the last req.
6872: CURSOR csr_req_params ( c_req_id IN NUMBER) IS
6873: SELECT *
6874: FROM fnd_concurrent_requests
6875: WHERE request_id = c_req_id;
6876:
6877: l_conc_params csr_req_params%ROWTYPE;
6878: l_pqp_extract BOOLEAN;

Line 7177: from fnd_concurrent_requests fnd

7173:
7174: --
7175: cursor c_threads(p_request_id number) is
7176: select null
7177: from fnd_concurrent_requests fnd
7178: where /*fnd.phase_code <> 'C' and */
7179: fnd.request_id = p_request_id;
7180: --
7181: cursor c_bg_name is