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 PA_R_PROJECT_RESOURCES_IND_V

Line 166: FROM pa_r_project_resources_ind_v

162: org_name,
163: resource_type,
164: job_id,
165: job_group_id
166: FROM pa_r_project_resources_ind_v
167: WHERE person_id = l_per_id
168: /* Start of Changes for Bug 6056112 */
169: UNION
170: SELECT person_id,

Line 419: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,

415: P_CALENDAR_ID IN NUMBER,
416: P_COUNT IN NUMBER,
417: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
418: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
419: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,

416: P_COUNT IN NUMBER,
417: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
418: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
419: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 421: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,

417: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
418: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
419: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 422: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,

418: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
419: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 423: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,

419: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 424: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,

420: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 431: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%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,
435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,

Line 433: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%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,
435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
436: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
437: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)

Line 434: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%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,
435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
436: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
437: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
438: IS

Line 435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%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,
435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
436: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
437: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
438: IS
439: l_insert VARCHAR2(1) := 'N';

Line 436: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%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,
435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
436: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
437: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
438: IS
439: l_insert VARCHAR2(1) := 'N';
440: l_end_date_insert VARCHAR2(1) := 'N'; -- Bug 4668272

Line 437: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_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,
435: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
436: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
437: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
438: IS
439: l_insert VARCHAR2(1) := 'N';
440: l_end_date_insert VARCHAR2(1) := 'N'; -- Bug 4668272
441:

Line 1422: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,

1418: P_COUNT IN NUMBER,
1419: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1420: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1421: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1422: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,

1419: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1420: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1421: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1422: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 1424: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,

1420: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1421: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1422: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 1425: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,

1421: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1422: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 1426: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,

1422: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 1427: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,

1423: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%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,

Line 1434: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%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,
1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,

Line 1436: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%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,
1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)

Line 1437: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%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,
1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
1441: IS

Line 1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%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,
1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
1441: IS
1442: l_resource_type_code PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE := 'EMPLOYEE';

Line 1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%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,
1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
1441: IS
1442: l_resource_type_code PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE := 'EMPLOYEE';
1443: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;

Line 1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_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,
1438: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
1439: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
1440: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE)
1441: IS
1442: l_resource_type_code PA_RESOURCE_TYPES.RESOURCE_TYPE_CODE%TYPE := 'EMPLOYEE';
1443: l_resource_type_id PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE;
1444:

Line 2102: from pa_r_project_resources_ind_v res

2098:
2099: --MOAC Changes bug 4363092 - removed nvl used with org_id
2100: CURSOR get_max_asgmt_end_date IS
2101: select max(assignment_end_date)
2102: from pa_r_project_resources_ind_v res
2103: , hr_organization_information org_info
2104: , pa_all_organizations org
2105: where res.person_id = l_person_id
2106: and res.organization_id = org_info.organization_id

Line 2196: -- It goes through a loop using pa_r_project_resources_ind_v

2192: log_message('For Internal Resources');
2193:
2194: ------------------------------------------------------------
2195: -- This is the individual case condition
2196: -- It goes through a loop using pa_r_project_resources_ind_v
2197: ------------------------------------------------------------
2198: IF (l_individual = 'Y') THEN
2199: pa_debug.g_err_stage := 'Log: For a single Resource';
2200: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */