DBA Data[Home] [Help]

APPS.PQP_GB_PSI_FUNCTIONS dependencies on FND_CONCURRENT_REQUESTS

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 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: