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_WF_WGI_PKG dependencies on GHR_GROUPBOXES

Line 65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;

61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
66: l_groupbox_name ghr_groupboxes.name%TYPE;
67: l_groupbox_desc ghr_groupboxes.description%TYPE;
68: l_office_symbol_name hr_lookups.meaning%TYPE;
69: l_wgi_due_date date;

Line 66: l_groupbox_name ghr_groupboxes.name%TYPE;

62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
66: l_groupbox_name ghr_groupboxes.name%TYPE;
67: l_groupbox_desc ghr_groupboxes.description%TYPE;
68: l_office_symbol_name hr_lookups.meaning%TYPE;
69: l_wgi_due_date date;
70: l_rating varchar2(30);

Line 67: l_groupbox_desc ghr_groupboxes.description%TYPE;

63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
66: l_groupbox_name ghr_groupboxes.name%TYPE;
67: l_groupbox_desc ghr_groupboxes.description%TYPE;
68: l_office_symbol_name hr_lookups.meaning%TYPE;
69: l_wgi_due_date date;
70: l_rating varchar2(30);
71: l_multi_error_flag boolean;

Line 378: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;

374: p_routing_group_name out nocopy varchar2,
375: p_routing_group_desc out nocopy varchar2
376: ) IS
377: -- Local variables
378: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
379: l_groupbox_name ghr_groupboxes.name%TYPE;
380: l_groupbox_desc ghr_groupboxes.name%TYPE;
381: l_routing_group_id ghr_groupboxes.routing_group_id%TYPE;
382: l_routing_group_name ghr_routing_groups.name%TYPE;

Line 379: l_groupbox_name ghr_groupboxes.name%TYPE;

375: p_routing_group_desc out nocopy varchar2
376: ) IS
377: -- Local variables
378: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
379: l_groupbox_name ghr_groupboxes.name%TYPE;
380: l_groupbox_desc ghr_groupboxes.name%TYPE;
381: l_routing_group_id ghr_groupboxes.routing_group_id%TYPE;
382: l_routing_group_name ghr_routing_groups.name%TYPE;
383: l_routing_group_desc ghr_routing_groups.description%TYPE;

Line 380: l_groupbox_desc ghr_groupboxes.name%TYPE;

376: ) IS
377: -- Local variables
378: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
379: l_groupbox_name ghr_groupboxes.name%TYPE;
380: l_groupbox_desc ghr_groupboxes.name%TYPE;
381: l_routing_group_id ghr_groupboxes.routing_group_id%TYPE;
382: l_routing_group_name ghr_routing_groups.name%TYPE;
383: l_routing_group_desc ghr_routing_groups.description%TYPE;
384: --

Line 381: l_routing_group_id ghr_groupboxes.routing_group_id%TYPE;

377: -- Local variables
378: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
379: l_groupbox_name ghr_groupboxes.name%TYPE;
380: l_groupbox_desc ghr_groupboxes.name%TYPE;
381: l_routing_group_id ghr_groupboxes.routing_group_id%TYPE;
382: l_routing_group_name ghr_routing_groups.name%TYPE;
383: l_routing_group_desc ghr_routing_groups.description%TYPE;
384: --
385: --

Line 388: from ghr_groupboxes gbx, ghr_routing_groups rgp

384: --
385: --
386: cursor csr_gbx is
387: select gbx.groupbox_id, gbx.routing_group_id, gbx.name, rgp.name , rgp.description
388: from ghr_groupboxes gbx, ghr_routing_groups rgp
389: where gbx.name = l_groupbox_name
390: and gbx.routing_group_id = rgp.routing_group_id;
391: --
392: begin

Line 489: l_groupbox_name ghr_groupboxes.name%TYPE;

485: ) IS
486: --
487: -- Local variables
488: --
489: l_groupbox_name ghr_groupboxes.name%TYPE;
490: --
491: l_flsa_category ghr_pa_requests.flsa_category%TYPE;
492: l_bargaining_unit_status ghr_pa_requests.bargaining_unit_status%TYPE;
493: l_work_schedule ghr_pa_requests.work_schedule%TYPE;

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 2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;

1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
2003: l_groupbox_name ghr_groupboxes.name%TYPE;
2004: l_groupbox_desc ghr_groupboxes.description%TYPE;
2005: l_office_symbol_name hr_lookups.meaning%TYPE;
2006: l_wgi_due_date date;

Line 2003: l_groupbox_name ghr_groupboxes.name%TYPE;

1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
2003: l_groupbox_name ghr_groupboxes.name%TYPE;
2004: l_groupbox_desc ghr_groupboxes.description%TYPE;
2005: l_office_symbol_name hr_lookups.meaning%TYPE;
2006: l_wgi_due_date date;
2007: l_rating varchar2(30);

Line 2004: l_groupbox_desc ghr_groupboxes.description%TYPE;

2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
2003: l_groupbox_name ghr_groupboxes.name%TYPE;
2004: l_groupbox_desc ghr_groupboxes.description%TYPE;
2005: l_office_symbol_name hr_lookups.meaning%TYPE;
2006: l_wgi_due_date date;
2007: l_rating varchar2(30);
2008: l_multi_error_flag boolean;