APPS.PQP_GB_PSI_FUNCTIONS dependencies on FND_CONCURRENT

Line 44: l_debug_enable_mode fnd_concurrent_requests.argument3%type;

40: g_proc_name||'check_debug';
41:
42: l_config_value pqp_utilities.t_config_values;
43: l_return VARCHAR2(20);
44: l_debug_enable_mode fnd_concurrent_requests.argument3%type;
45: l_process_parameters csr_debug_enable_mode%rowtype;
46: l_parent_process_parameters csr_debug_enable_mode%rowtype;
47:
48: --

Line 939: l_request_id fnd_concurrent_requests.request_id%TYPE;

935: l_extract_name ben_ext_dfn.name%TYPE;
936: l_extract_shortname VARCHAR2(80);
937: l_extract_count NUMBER;
938:
939: l_request_id fnd_concurrent_requests.request_id%TYPE;
940: l_index fnd_concurrent_requests.request_id%TYPE;
941:
942: l_wait_success BOOLEAN := FALSE;
943: l_effective_date DATE;

Line 940: l_index fnd_concurrent_requests.request_id%TYPE;

936: l_extract_shortname VARCHAR2(80);
937: l_extract_count NUMBER;
938:
939: l_request_id fnd_concurrent_requests.request_id%TYPE;
940: l_index fnd_concurrent_requests.request_id%TYPE;
941:
942: l_wait_success BOOLEAN := FALSE;
943: l_effective_date DATE;
944: l_cutover_date DATE;

Line 1224: l_wait_success := fnd_concurrent.wait_for_request

1220:
1221:
1222:
1223: IF l_threads <> 1 THEN
1224: l_wait_success := fnd_concurrent.wait_for_request
1225: (request_id => l_request_id
1226: ,interval => (g_wait_interval - 30)
1227: ,max_wait => g_max_wait
1228: ,phase => l_phase -- OUT

Line 1289: l_wait_success := fnd_concurrent.wait_for_request

1285: LOOP
1286: IF g_ext_dtls(l_index).extract_name IS NOT NULL
1287: THEN
1288:
1289: l_wait_success := fnd_concurrent.wait_for_request
1290: (request_id => g_ext_dtls(l_index).request_id
1291: ,interval => (g_wait_interval - 30)
1292: ,max_wait => g_max_wait
1293: ,phase => l_phase -- OUT

Line 1424: l_wait_success := fnd_concurrent.wait_for_request

1420:
1421: COMMIT;
1422:
1423: -- now wait for control totals to finish
1424: l_wait_success := fnd_concurrent.wait_for_request
1425: (request_id => l_request_id
1426: ,interval => (g_wait_interval - 30)
1427: ,max_wait => g_max_wait
1428: ,phase => l_phase -- OUT

Line 1773: FROM fnd_concurrent_requests req, ben_benefit_actions bba

1769: ,argument5 Extract_Type
1770: ,argument6 Interface_File
1771: ,argument8 Extract_eff_date --- For Nuvos
1772: ,request_date req_date
1773: FROM fnd_concurrent_requests req, ben_benefit_actions bba
1774: WHERE parent_request_id = c_get_rsltid
1775: AND bba.request_id = req.request_id
1776: AND bba.business_group_id = p_business_group_id;
1777:

Line 1783: FROM fnd_concurrent_requests req ,ben_ext_rslt ben

1779: -- For Nuvos
1780:
1781: CURSOR csr_get_eff_date (c_ext_rslt_id IN number) IS
1782: SELECT argument8 Extract_eff_date --- For Nuvos
1783: FROM fnd_concurrent_requests req ,ben_ext_rslt ben
1784: where req.request_id = ben.request_id
1785: and ben.ext_rslt_id = c_ext_rslt_id
1786: and ben.business_group_id = p_business_group_id;
1787: