3: AUTHID CURRENT_USER AS
4:
5: PROCEDURE INSERT_ROW1(
6: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
8: X_NAME IN PA_RESOURCES.NAME%TYPE,
9: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
10: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
11: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
4:
5: PROCEDURE INSERT_ROW1(
6: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
8: X_NAME IN PA_RESOURCES.NAME%TYPE,
9: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
10: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
11: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
12: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
5: PROCEDURE INSERT_ROW1(
6: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
8: X_NAME IN PA_RESOURCES.NAME%TYPE,
9: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
10: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
11: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
12: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
13: X_REQUEST_ID IN NUMBER,
6: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
7: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
8: X_NAME IN PA_RESOURCES.NAME%TYPE,
9: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
10: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
11: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
12: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
13: X_REQUEST_ID IN NUMBER,
14: X_PROGRAM_ID IN NUMBER,
7: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
8: X_NAME IN PA_RESOURCES.NAME%TYPE,
9: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
10: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
11: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
12: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
13: X_REQUEST_ID IN NUMBER,
14: X_PROGRAM_ID IN NUMBER,
15: X_PROGRAM_UPDATE_DATE IN DATE,
8: X_NAME IN PA_RESOURCES.NAME%TYPE,
9: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
10: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
11: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
12: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
13: X_REQUEST_ID IN NUMBER,
14: X_PROGRAM_ID IN NUMBER,
15: X_PROGRAM_UPDATE_DATE IN DATE,
16: X_PROGRAM_APPLICATION_ID IN NUMBER,
13: X_REQUEST_ID IN NUMBER,
14: X_PROGRAM_ID IN NUMBER,
15: X_PROGRAM_UPDATE_DATE IN DATE,
16: X_PROGRAM_APPLICATION_ID IN NUMBER,
17: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, -- default 'HOURS', --added for bug 2599790
18: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534
19: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534
20: X_LAST_UPDATE_BY IN NUMBER,
21: X_LAST_UPDATE_DATE IN DATE,
14: X_PROGRAM_ID IN NUMBER,
15: X_PROGRAM_UPDATE_DATE IN DATE,
16: X_PROGRAM_APPLICATION_ID IN NUMBER,
17: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, -- default 'HOURS', --added for bug 2599790
18: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534
19: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534
20: X_LAST_UPDATE_BY IN NUMBER,
21: X_LAST_UPDATE_DATE IN DATE,
22: X_CREATION_DATE IN DATE,
15: X_PROGRAM_UPDATE_DATE IN DATE,
16: X_PROGRAM_APPLICATION_ID IN NUMBER,
17: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, -- default 'HOURS', --added for bug 2599790
18: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534
19: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534
20: X_LAST_UPDATE_BY IN NUMBER,
21: X_LAST_UPDATE_DATE IN DATE,
22: X_CREATION_DATE IN DATE,
23: X_CREATED_BY IN NUMBER,