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 23: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,

19: P_CALENDAR_ID IN NUMBER,
20: P_COUNT IN NUMBER,
21: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,

Line 24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,

20: P_COUNT IN NUMBER,
21: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,

Line 25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,

21: X_CRM_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE , --File.Sql.39 bug 4440895
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,

Line 26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,

22: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,

Line 27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,

23: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,

Line 28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,

24: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
25: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
26: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
27: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
28: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
29: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
30: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,

Line 35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,

31: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
32: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
39: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,

Line 37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,

33: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
39: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
40: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
41: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;

Line 38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,

34: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
39: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
40: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
41: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;
42:

Line 39: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,

35: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
39: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
40: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
41: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;
42:
43: PROCEDURE INSERT_INTO_PA(

Line 40: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,

36: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
39: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
40: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
41: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;
42:
43: PROCEDURE INSERT_INTO_PA(
44: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,

Line 41: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;

37: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
38: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
39: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
40: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
41: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE) ;
42:
43: PROCEDURE INSERT_INTO_PA(
44: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
45: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,

Line 79: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,

75: P_COUNT IN NUMBER,
76: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
77: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
78: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,

Line 80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,

76: P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
77: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
78: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,

Line 81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,

77: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
78: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,

Line 82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,

78: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,

Line 83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,

79: P_START_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_start_date%TYPE,
80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,

Line 84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,

80: P_END_DATE_ACTIVE IN pa_r_project_resources_ind_v.per_end_date%TYPE,
81: P_SOURCE_NUMBER IN pa_r_project_resources_ind_v.per_emp_number%TYPE,
82: P_SOURCE_JOB_TITLE IN pa_r_project_resources_ind_v.job_name%TYPE,
83: P_SOURCE_EMAIL IN pa_r_project_resources_ind_v.per_email%TYPE,
84: P_SOURCE_PHONE IN pa_r_project_resources_ind_v.per_work_phone%TYPE,
85: P_SOURCE_ADDRESS1 IN HR_LOCATIONS.ADDRESS_LINE_1%TYPE,
86: P_SOURCE_ADDRESS2 IN HR_LOCATIONS.ADDRESS_LINE_2%TYPE,
87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,

Line 91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,

87: P_SOURCE_ADDRESS3 IN HR_LOCATIONS.ADDRESS_LINE_3%TYPE,
88: P_SOURCE_CITY IN HR_LOCATIONS.TOWN_OR_CITY%TYPE,
89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
95: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,

Line 93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,

89: P_SOURCE_POSTAL_CODE IN HR_LOCATIONS.POSTAL_CODE%TYPE,
90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
95: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
96: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
97: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE);

Line 94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,

90: P_SOURCE_COUNTRY IN HR_LOCATIONS.COUNTRY%TYPE,
91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
95: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
96: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
97: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE);
98:

Line 95: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,

91: P_SOURCE_MGR_ID IN pa_r_project_resources_ind_v.supervisor_id%TYPE,
92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
95: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
96: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
97: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE);
98:
99: PROCEDURE CREATE_RESOURCE(

Line 96: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,

92: P_SOURCE_MGR_NAME IN PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
95: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
96: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
97: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE);
98:
99: PROCEDURE CREATE_RESOURCE(
100: P_COMMIT IN VARCHAR2,

Line 97: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE);

93: P_SOURCE_BUSINESS_GRP_ID IN pa_r_project_resources_ind_v.per_business_group_id%TYPE,
94: P_SOURCE_BUSINESS_GRP_NAME IN pa_r_project_resources_ind_v.org_name%TYPE,
95: P_SOURCE_FIRST_NAME IN pa_r_project_resources_ind_v.per_first_name%TYPE,
96: P_SOURCE_LAST_NAME IN pa_r_project_resources_ind_v.per_last_name%TYPE,
97: P_SOURCE_MIDDLE_NAME IN pa_r_project_resources_ind_v.per_middle_name%TYPE);
98:
99: PROCEDURE CREATE_RESOURCE(
100: P_COMMIT IN VARCHAR2,
101: P_VALIDATE_ONLY IN VARCHAR2,