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 724: l_request_number ghr_pa_requests.request_number%TYPE;

720: l_line6 varchar2(500);
721: l_line7 varchar2(500);
722: l_line8 varchar2(500);
723: l_line9 varchar2(500);
724: l_request_number ghr_pa_requests.request_number%TYPE;
725: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;

Line 725: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;

721: l_line7 varchar2(500);
722: l_line8 varchar2(500);
723: l_line9 varchar2(500);
724: l_request_number ghr_pa_requests.request_number%TYPE;
725: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

Line 726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;

722: l_line8 varchar2(500);
723: l_line9 varchar2(500);
724: l_request_number ghr_pa_requests.request_number%TYPE;
725: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

Line 727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;

723: l_line9 varchar2(500);
724: l_request_number ghr_pa_requests.request_number%TYPE;
725: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;

Line 728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;

724: l_request_number ghr_pa_requests.request_number%TYPE;
725: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;

Line 729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

725: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;

Line 730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;

726: l_employee_first_name ghr_pa_requests.employee_first_name%TYPE;
727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

Line 731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;

727: l_employee_last_name ghr_pa_requests.employee_last_name%TYPE;
728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;

Line 732: l_effective_date ghr_pa_requests.effective_date%TYPE;

728: l_employee_middle_names ghr_pa_requests.employee_middle_names%TYPE;
729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;

Line 733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;

729: l_first_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
737: l_routing_group_name ghr_routing_groups.name%TYPE;

Line 734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

730: l_second_noa_desc ghr_pa_requests.first_noa_desc%TYPE;
731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
737: l_routing_group_name ghr_routing_groups.name%TYPE;
738: l_description ghr_routing_groups.description%TYPE;

Line 735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;

731: l_proposed_effective_date ghr_pa_requests.proposed_effective_date%TYPE;
732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
737: l_routing_group_name ghr_routing_groups.name%TYPE;
738: l_description ghr_routing_groups.description%TYPE;
739: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;

Line 736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;

732: l_effective_date ghr_pa_requests.effective_date%TYPE;
733: l_requested_by_person_id ghr_pa_requests.requested_by_person_id%TYPE;
734: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
735: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
736: l_second_noa_code ghr_pa_requests.second_noa_code%TYPE;
737: l_routing_group_name ghr_routing_groups.name%TYPE;
738: l_description ghr_routing_groups.description%TYPE;
739: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;
740: l_to_organization_name hr_organization_units.name%TYPE;

Line 739: l_to_organization_id ghr_pa_requests.to_organization_id%TYPE;

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

Line 747: l_from_position_id ghr_pa_requests.from_position_id%TYPE;

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

Line 748: l_to_position_id ghr_pa_requests.to_position_id%TYPE;

744: l_action_taken1 ghr_pa_routing_history.action_taken%TYPE;
745: l_creation_date ghr_pa_routing_history.creation_date%TYPE;
746: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
747: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
748: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
749: --
750: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
751: l_status ghr_pa_requests.status%TYPE;
752: l_pos_ei_data per_position_extra_info%rowtype;

Line 750: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;

746: l_date_notification_sent ghr_pa_routing_history.date_notification_sent%TYPE;
747: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
748: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
749: --
750: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
751: l_status ghr_pa_requests.status%TYPE;
752: l_pos_ei_data per_position_extra_info%rowtype;
753: --
754: cursor csr_par_details is

Line 751: l_status ghr_pa_requests.status%TYPE;

747: l_from_position_id ghr_pa_requests.from_position_id%TYPE;
748: l_to_position_id ghr_pa_requests.to_position_id%TYPE;
749: --
750: l_personnel_office_id ghr_pa_requests.personnel_office_id%TYPE;
751: l_status ghr_pa_requests.status%TYPE;
752: l_pos_ei_data per_position_extra_info%rowtype;
753: --
754: cursor csr_par_details is
755: SELECT noa_family_code, request_number,

Line 761: FROM ghr_pa_requests

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

Line 1338: l_effective_date ghr_pa_requests.effective_date%type;

1334: l_forward_to_name ghr_pa_routing_history.user_name%TYPE;
1335: l_user_name ghr_pa_routing_history.user_name%TYPE;
1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1342: l_gbx_id ghr_groupboxes.groupbox_id%type;

Line 1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;

1335: l_user_name ghr_pa_routing_history.user_name%TYPE;
1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1342: l_gbx_id ghr_groupboxes.groupbox_id%type;
1343: --

Line 1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;

1336: l_prh_rec ghr_pa_routing_history%rowtype := NULL;
1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1342: l_gbx_id ghr_groupboxes.groupbox_id%type;
1343: --
1344: CURSOR chk_groupbox is

Line 1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;

1337: l_routing_group_id ghr_routing_groups.routing_group_id%type;
1338: l_effective_date ghr_pa_requests.effective_date%type;
1339: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1340: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1341: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1342: l_gbx_id ghr_groupboxes.groupbox_id%type;
1343: --
1344: CURSOR chk_groupbox is
1345: select name,groupbox_id,display_name from ghr_groupboxes

Line 1380: GHR_PA_REQUESTS

1376: WHERE use.user_name = p_user_name
1377: AND pei.person_id = use.employee_id
1378: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
1379: AND pei.pei_information3 = ( SELECT routing_group_id from
1380: GHR_PA_REQUESTS
1381: where pa_request_id = itemkey);
1382: --
1383: --
1384: /* Cursor c_user_emp_names(p_user_name in varchar2) is

Line 1421: from ghr_pa_requests

1417: Cursor get_par
1418: is
1419: SELECT routing_group_id,nvl(effective_date,sysdate) effective_date,
1420: first_noa_id,second_noa_id,noa_family_code
1421: from ghr_pa_requests
1422: where pa_request_id = itemkey;
1423:
1424: l_valid_user varchar2(1) := 'N';
1425: l_gbx_user_id ghr_groupbox_users.groupbox_user_id%type;