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