APPS.GHR_WF_WGI_PKG dependencies on GHR_POIS

Line 83: l_gbx_user_id ghr_pois.person_id%TYPE;

79: l_line6 varchar2(500);
80: l_line7 varchar2(500);
81: l_wgi_error_note varchar2(500);
82: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
83: l_gbx_user_id ghr_pois.person_id%TYPE;
84: l_routing_group varchar2(500);
85: -- NOCOPY Changes
86: l_result varchar2(250);
87: --

Line 484: p_gbx_user_id out nocopy ghr_pois.person_id%TYPE

480: p_position_id IN number,
481: p_effective_date IN date,
482: p_groupbox_name out nocopy varchar2,
483: p_personnel_office_id out nocopy ghr_pa_requests.personnel_office_id%TYPE,
484: p_gbx_user_id out nocopy ghr_pois.person_id%TYPE
485: ) IS
486: --
487: -- Local variables
488: --

Line 502: l_gbx_user_id ghr_pois.person_id%TYPE;

498: l_appropriation_code2 ghr_pa_requests.appropriation_code2%TYPE;
499: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
500: l_from_office_symbol ghr_pa_requests.from_office_symbol%TYPE;
501: l_part_time_hours ghr_pa_requests.part_time_hours%TYPE;
502: l_gbx_user_id ghr_pois.person_id%TYPE;
503: --
504: --
505: cursor csr_poi_code is
506: SELECT gbx.name ,poi.person_id

Line 507: from ghr_groupboxes gbx, ghr_pois poi

503: --
504: --
505: cursor csr_poi_code is
506: SELECT gbx.name ,poi.person_id
507: from ghr_groupboxes gbx, ghr_pois poi
508: WHERE gbx.groupbox_id (+) = nvl(poi.groupbox_id,-9999999)
509: AND poi.personnel_office_id = nvl(l_personnel_office_id,-99999999);
510: --
511: begin

Line 1048: ,p_gbx_user_id in ghr_pois.person_id%TYPE)

1044: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1045: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type
1046: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type
1047: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
1048: ,p_gbx_user_id in ghr_pois.person_id%TYPE)
1049: is
1050: --
1051: Cursor c_fnd_sessions is
1052: Select 1

Line 2019: l_gbx_user_id ghr_pois.person_id%TYPE;

2015: l_line5 varchar2(500);
2016: l_line6 varchar2(500);
2017: l_line7 varchar2(500);
2018: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
2019: l_gbx_user_id ghr_pois.person_id%TYPE;
2020: l_routing_group varchar2(500);
2021: l_wgi_error_note varchar2(500);
2022: -- NOCOPY Changes
2023: l_result varchar2(250);