DBA Data[Home] [Help]

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 875: l_request_id fnd_concurrent_requests.request_id%TYPE;

871: l_extract_name ben_ext_dfn.name%TYPE;
872: l_extract_shortname VARCHAR2(80);
873: l_extract_count NUMBER;
874:
875: l_request_id fnd_concurrent_requests.request_id%TYPE;
876: l_index fnd_concurrent_requests.request_id%TYPE;
877:
878: l_wait_success BOOLEAN := FALSE;
879: l_effective_date DATE;

Line 876: l_index fnd_concurrent_requests.request_id%TYPE;

872: l_extract_shortname VARCHAR2(80);
873: l_extract_count NUMBER;
874:
875: l_request_id fnd_concurrent_requests.request_id%TYPE;
876: l_index fnd_concurrent_requests.request_id%TYPE;
877:
878: l_wait_success BOOLEAN := FALSE;
879: l_effective_date DATE;
880: l_cutover_date DATE;

Line 1160: l_wait_success := fnd_concurrent.wait_for_request

1156:
1157:
1158:
1159: IF l_threads <> 1 THEN
1160: l_wait_success := fnd_concurrent.wait_for_request
1161: (request_id => l_request_id
1162: ,interval => (g_wait_interval - 30)
1163: ,max_wait => g_max_wait
1164: ,phase => l_phase -- OUT

Line 1225: l_wait_success := fnd_concurrent.wait_for_request

1221: LOOP
1222: IF g_ext_dtls(l_index).extract_name IS NOT NULL
1223: THEN
1224:
1225: l_wait_success := fnd_concurrent.wait_for_request
1226: (request_id => g_ext_dtls(l_index).request_id
1227: ,interval => (g_wait_interval - 30)
1228: ,max_wait => g_max_wait
1229: ,phase => l_phase -- OUT

Line 1360: l_wait_success := fnd_concurrent.wait_for_request

1356:
1357: COMMIT;
1358:
1359: -- now wait for control totals to finish
1360: l_wait_success := fnd_concurrent.wait_for_request
1361: (request_id => l_request_id
1362: ,interval => (g_wait_interval - 30)
1363: ,max_wait => g_max_wait
1364: ,phase => l_phase -- OUT

Line 1709: FROM fnd_concurrent_requests req, ben_benefit_actions bba

1705: ,argument5 Extract_Type
1706: ,argument6 Interface_File
1707: ,argument8 Extract_eff_date --- For Nuvos
1708: ,request_date req_date
1709: FROM fnd_concurrent_requests req, ben_benefit_actions bba
1710: WHERE parent_request_id = c_get_rsltid
1711: AND bba.request_id = req.request_id
1712: AND bba.business_group_id = p_business_group_id;
1713:

Line 1719: FROM fnd_concurrent_requests req ,ben_ext_rslt ben

1715: -- For Nuvos
1716:
1717: CURSOR csr_get_eff_date (c_ext_rslt_id IN number) IS
1718: SELECT argument8 Extract_eff_date --- For Nuvos
1719: FROM fnd_concurrent_requests req ,ben_ext_rslt ben
1720: where req.request_id = ben.request_id
1721: and ben.ext_rslt_id = c_ext_rslt_id
1722: and ben.business_group_id = p_business_group_id;
1723: