DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on FND_GLOBAL

Line 476: g_conc_request_id := Fnd_Global.conc_request_id;

472:
473: BEGIN
474:
475: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
476: g_conc_request_id := Fnd_Global.conc_request_id;
477: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
478: DELETE FROM pay_us_rpt_totals
479: WHERE organization_name = 'US Pension Extracts'
480: AND attribute30 = 'EXTRACT_COMPLETED'

Line 5408: ,p_request_id => Fnd_Global.conc_request_id

5404: (p_err_num => p_error_NUMBER
5405: ,p_err_name => l_error_text
5406: ,p_typ_cd => 'W'
5407: ,p_person_id => l_person_id
5408: ,p_request_id => Fnd_Global.conc_request_id
5409: ,p_business_group_id => Fnd_Global.per_business_group_id
5410: ,p_ext_rslt_id => get_current_extract_result
5411: );
5412: l_return_value:= 0;

Line 5409: ,p_business_group_id => Fnd_Global.per_business_group_id

5405: ,p_err_name => l_error_text
5406: ,p_typ_cd => 'W'
5407: ,p_person_id => l_person_id
5408: ,p_request_id => Fnd_Global.conc_request_id
5409: ,p_business_group_id => Fnd_Global.per_business_group_id
5410: ,p_ext_rslt_id => get_current_extract_result
5411: );
5412: l_return_value:= 0;
5413: ELSE