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.PA_R_PROJECT_RESOURCES_PVT dependencies on HR_LOCATIONS

Line 425: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,

421: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
422: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
423: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
424: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
425: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
426: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
427: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

Line 426: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,

422: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
423: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
424: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
425: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
426: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
427: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
430: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

Line 427: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,

423: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
424: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
425: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
426: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
427: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
430: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
431: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,

Line 428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,

424: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
425: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
426: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
427: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
430: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
431: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
432: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,

Line 429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

425: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
426: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
427: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
430: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
431: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
432: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
433: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,

Line 430: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

426: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
427: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
428: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
429: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
430: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
431: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
432: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
433: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
434: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,

Line 1428: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,

1424: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
1425: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
1426: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
1427: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
1428: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
1429: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
1430: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

Line 1429: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,

1425: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
1426: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
1427: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
1428: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
1429: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
1430: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
1433: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

Line 1430: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,

1426: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
1427: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
1428: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
1429: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
1430: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
1433: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
1434: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,

Line 1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,

1427: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
1428: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
1429: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
1430: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
1433: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
1434: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
1435: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,

Line 1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,

1428: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
1429: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
1430: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
1433: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
1434: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
1435: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1436: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,

Line 1433: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,

1429: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
1430: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
1431: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
1432: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
1433: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
1434: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
1435: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1436: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
1437: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,

Line 2020: l_address1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;

2016: l_res_found VARCHAR2(1) := 'N';
2017: l_valid VARCHAR2(1) := 'N';
2018: l_return_status VARCHAR2(1000);
2019: l_supervisor_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
2020: l_address1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;
2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;

Line 2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;

2017: l_valid VARCHAR2(1) := 'N';
2018: l_return_status VARCHAR2(1000);
2019: l_supervisor_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
2020: l_address1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;
2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;
2025: l_country HR_LOCATIONS.COUNTRY%TYPE;

Line 2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;

2018: l_return_status VARCHAR2(1000);
2019: l_supervisor_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
2020: l_address1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;
2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;
2025: l_country HR_LOCATIONS.COUNTRY%TYPE;
2026: l_end_date DATE;

Line 2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;

2019: l_supervisor_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
2020: l_address1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;
2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;
2025: l_country HR_LOCATIONS.COUNTRY%TYPE;
2026: l_end_date DATE;
2027: G_person_id NUMBER := 0;

Line 2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;

2020: l_address1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;
2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;
2025: l_country HR_LOCATIONS.COUNTRY%TYPE;
2026: l_end_date DATE;
2027: G_person_id NUMBER := 0;
2028: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;

Line 2025: l_country HR_LOCATIONS.COUNTRY%TYPE;

2021: l_address2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
2022: l_address3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
2023: l_city HR_LOCATIONS.TOWN_OR_CITY%TYPE;
2024: l_postal_code HR_LOCATIONS.POSTAL_CODE%TYPE;
2025: l_country HR_LOCATIONS.COUNTRY%TYPE;
2026: l_end_date DATE;
2027: G_person_id NUMBER := 0;
2028: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;
2029: -- l_org_type VARCHAR2(20); --Bug 4363092