APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 194: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;

190:
191: l_today date:=sysdate;
192: l_session_var ghr_history_api.g_session_var_type;
193: l_result varchar2(30);
194: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
195: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
196: l_sf52_shadow ghr_pa_requests%rowtype;
197: l_shadow_data ghr_pa_request_shadow%rowtype;
198: l_sf52_data ghr_pa_requests%rowtype;

Line 195: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

191: l_today date:=sysdate;
192: l_session_var ghr_history_api.g_session_var_type;
193: l_result varchar2(30);
194: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
195: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
196: l_sf52_shadow ghr_pa_requests%rowtype;
197: l_shadow_data ghr_pa_request_shadow%rowtype;
198: l_sf52_data ghr_pa_requests%rowtype;
199: l_proc varchar2(30):='single_action_sf52';

Line 343: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;

339:
340: l_today date:=sysdate;
341: l_sf52_data ghr_pa_requests%rowtype;
342: l_sf52_data_save ghr_pa_requests%rowtype;
343: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
344: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
345: l_shadow_data ghr_pa_request_shadow%rowtype;
346: l_session_var ghr_history_api.g_session_var_type;
347: l_result varchar2(30);

Line 344: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

340: l_today date:=sysdate;
341: l_sf52_data ghr_pa_requests%rowtype;
342: l_sf52_data_save ghr_pa_requests%rowtype;
343: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
344: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
345: l_shadow_data ghr_pa_request_shadow%rowtype;
346: l_session_var ghr_history_api.g_session_var_type;
347: l_result varchar2(30);
348: l_proc varchar2(30):='dual_action_sf52';

Line 581: p_sf52_ei_data out nocopy ghr_pa_request_extra_info%rowtype,

577: -- ---------------------------------------------------------------------------
578: Procedure Fetch_Extra_Info( p_pa_request_id in number,
579: p_noa_id in number,
580: p_agency_ei in boolean default False,
581: p_sf52_ei_data out nocopy ghr_pa_request_extra_info%rowtype,
582: p_result out nocopy varchar2) is
583: l_info_type ghr_pa_request_info_types.information_type%type;
584: -- this cursor fetches the extra info data given the information_type and pa_request_id
585: cursor c_req_ei ( cp_pa_request_id number,

Line 588: from ghr_pa_request_extra_info

584: -- this cursor fetches the extra info data given the information_type and pa_request_id
585: cursor c_req_ei ( cp_pa_request_id number,
586: cp_info_type ghr_pa_request_info_types.information_type%type) is
587: select *
588: from ghr_pa_request_extra_info
589: where pa_request_id = cp_pa_request_id and
590: information_type = cp_info_type;
591:
592: l_proc varchar2(30):='fetch_Extra_info';