DBA Data[Home] [Help]

APPS.PA_RESOURCE_PKG dependencies on PA_RESOURCES

Line 7: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,

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,

Line 8: X_NAME IN PA_RESOURCES.NAME%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,

Line 9: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%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,

Line 10: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,

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,

Line 11: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,

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,

Line 12: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%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,
16: X_PROGRAM_APPLICATION_ID IN NUMBER,

Line 17: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, -- default 'HOURS', --added for bug 2599790

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,

Line 18: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534

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,

Line 19: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534

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,