eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PROCESS_SF52 dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 268: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;

264:
265: l_today date:=sysdate;
266: l_session_var ghr_history_api.g_session_var_type;
267: l_result varchar2(30);
268: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
269: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
270: l_sf52_shadow ghr_pa_requests%rowtype;
271: l_shadow_data ghr_pa_request_shadow%rowtype;
272: l_sf52_data ghr_pa_requests%rowtype;

Line 269: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

265: l_today date:=sysdate;
266: l_session_var ghr_history_api.g_session_var_type;
267: l_result varchar2(30);
268: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
269: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
270: l_sf52_shadow ghr_pa_requests%rowtype;
271: l_shadow_data ghr_pa_request_shadow%rowtype;
272: l_sf52_data ghr_pa_requests%rowtype;
273: l_proc varchar2(30):='single_action_sf52';

Line 417: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;

413:
414: l_today date:=sysdate;
415: l_sf52_data ghr_pa_requests%rowtype;
416: l_sf52_data_save ghr_pa_requests%rowtype;
417: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
418: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
419: l_shadow_data ghr_pa_request_shadow%rowtype;
420: l_session_var ghr_history_api.g_session_var_type;
421: l_result varchar2(30);

Line 418: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

414: l_today date:=sysdate;
415: l_sf52_data ghr_pa_requests%rowtype;
416: l_sf52_data_save ghr_pa_requests%rowtype;
417: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
418: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
419: l_shadow_data ghr_pa_request_shadow%rowtype;
420: l_session_var ghr_history_api.g_session_var_type;
421: l_result varchar2(30);
422: l_proc varchar2(30):='dual_action_sf52';

Line 673: p_sf52_ei_data out nocopy ghr_pa_request_extra_info%rowtype,

669: -- ---------------------------------------------------------------------------
670: Procedure Fetch_Extra_Info( p_pa_request_id in number,
671: p_noa_id in number,
672: p_agency_ei in boolean default False,
673: p_sf52_ei_data out nocopy ghr_pa_request_extra_info%rowtype,
674: p_result out nocopy varchar2) is
675: l_info_type ghr_pa_request_info_types.information_type%type;
676: -- this cursor fetches the extra info data given the information_type and pa_request_id
677: cursor c_req_ei ( cp_pa_request_id number,

Line 680: from ghr_pa_request_extra_info

676: -- this cursor fetches the extra info data given the information_type and pa_request_id
677: cursor c_req_ei ( cp_pa_request_id number,
678: cp_info_type ghr_pa_request_info_types.information_type%type) is
679: select *
680: from ghr_pa_request_extra_info
681: where pa_request_id = cp_pa_request_id and
682: information_type = cp_info_type;
683:
684: l_proc varchar2(30):='fetch_Extra_info';