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_PKG dependencies on GHR_PA_REQUESTS

Line 720: l_request_number ghr_pa_requests.request_number%TYPE;

716: l_line6 varchar2(500);
717: l_line7 varchar2(500);
718: l_line8 varchar2(500);
719: l_line9 varchar2(500);
720: l_request_number ghr_pa_requests.request_number%TYPE;
721: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;

Line 721: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;

717: l_line7 varchar2(500);
718: l_line8 varchar2(500);
719: l_line9 varchar2(500);
720: l_request_number ghr_pa_requests.request_number%TYPE;
721: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

Line 722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;

718: l_line8 varchar2(500);
719: l_line9 varchar2(500);
720: l_request_number ghr_pa_requests.request_number%TYPE;
721: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

Line 723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;

719: l_line9 varchar2(500);
720: l_request_number ghr_pa_requests.request_number%TYPE;
721: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;

Line 724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;

720: l_request_number ghr_pa_requests.request_number%TYPE;
721: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;

Line 725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

721: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;

Line 726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

722: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

Line 727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;

723: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;

Line 728: l_effective_date ghr_pa_requests.effective_date%TYPE;

724: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;

Line 729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;

725: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
733: l_routing_group_name ghr_routing_groups.name%TYPE;

Line 730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

726: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
733: l_routing_group_name ghr_routing_groups.name%TYPE;
734: l_description ghr_routing_groups.description%TYPE;

Line 731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;

727: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
733: l_routing_group_name ghr_routing_groups.name%TYPE;
734: l_description ghr_routing_groups.description%TYPE;
735: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;

Line 732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;

728: l_effective_date ghr_pa_requests.effective_date%TYPE;
729: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
730: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
733: l_routing_group_name ghr_routing_groups.name%TYPE;
734: l_description ghr_routing_groups.description%TYPE;
735: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
736: l_to_organization_name hr_organization_units.name%TYPE;

Line 735: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;

731: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
732: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
733: l_routing_group_name ghr_routing_groups.name%TYPE;
734: l_description ghr_routing_groups.description%TYPE;
735: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
736: l_to_organization_name hr_organization_units.name%TYPE;
737: l_from_organization_name hr_organization_units.name%TYPE;
738: l_noa_fam_desc ghr_families.name%TYPE;
739: l_error_msg varchar2(1200);

Line 743: l_from_position_id ghr_pa_requests.from_position_id%TYPE;

739: l_error_msg varchar2(1200);
740: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
741: l_creation_date ghr_pa_routing_history.creation_date%TYPE;
742: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
743: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
744: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
745: --
746: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
747: l_status ghr_pa_requests.status%TYPE;

Line 744: l_to_position_id ghr_pa_requests.to_position_id%TYPE;

740: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
741: l_creation_date ghr_pa_routing_history.creation_date%TYPE;
742: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
743: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
744: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
745: --
746: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
747: l_status ghr_pa_requests.status%TYPE;
748: l_pos_ei_data per_position_extra_info%rowtype;

Line 746: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;

742: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
743: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
744: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
745: --
746: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
747: l_status ghr_pa_requests.status%TYPE;
748: l_pos_ei_data per_position_extra_info%rowtype;
749: --
750: cursor csr_par_details is

Line 747: l_status ghr_pa_requests.status%TYPE;

743: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
744: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
745: --
746: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
747: l_status ghr_pa_requests.status%TYPE;
748: l_pos_ei_data per_position_extra_info%rowtype;
749: --
750: cursor csr_par_details is
751: SELECT noa_family_code, request_number,

Line 757: FROM ghr_pa_requests

753: proposed_effective_date, effective_date, requested_by_person_id,
754: routing_group_id, to_organization_id, first_noa_desc, second_noa_desc,
755: first_noa_code, second_noa_code, from_position_id, personnel_office_id,
756: status, to_position_id
757: FROM ghr_pa_requests
758: WHERE pa_request_id = p_pa_request_id;
759: --
760: cursor csr_ghr_families is
761: SELECT name

Line 1316: l_effective_date ghr_pa_requests.effective_date%type;

1312: l_forward_to_name varchar2(30);
1313: l_user_name varchar2(30);
1314: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1315: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1316: l_effective_date ghr_pa_requests.effective_date%type;
1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1320: l_gbx_id ghr_groupboxes.groupbox_id%type;

Line 1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;

1313: l_user_name varchar2(30);
1314: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1315: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1316: l_effective_date ghr_pa_requests.effective_date%type;
1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1320: l_gbx_id ghr_groupboxes.groupbox_id%type;
1321: --

Line 1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;

1314: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1315: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1316: l_effective_date ghr_pa_requests.effective_date%type;
1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1320: l_gbx_id ghr_groupboxes.groupbox_id%type;
1321: --
1322: CURSOR chk_groupbox is

Line 1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;

1315: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1316: l_effective_date ghr_pa_requests.effective_date%type;
1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1320: l_gbx_id ghr_groupboxes.groupbox_id%type;
1321: --
1322: CURSOR chk_groupbox is
1323: select name,groupbox_id,display_name from ghr_groupboxes

Line 1358: GHR_PA_REQUESTS

1354: WHERE use.user_name = p_user_name
1355: AND pei.person_id = use.employee_id
1356: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
1357: AND pei.pei_information3 = ( SELECT routing_group_id from
1358: GHR_PA_REQUESTS
1359: where pa_request_id = itemkey);
1360: --
1361: --
1362: /* Cursor c_user_emp_names(p_user_name in varchar2) is

Line 1399: from ghr_pa_requests

1395: Cursor get_par
1396: is
1397: SELECT routing_group_id,nvl(effective_date,sysdate) effective_date,
1398: first_noa_id,second_noa_id,noa_family_code
1399: from ghr_pa_requests
1400: where pa_request_id = itemkey;
1401:
1402: l_valid_user varchar2(1) := 'N';
1403: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;