1 PACKAGE PA_RESOURCE_PKG
2 -- $Header: PARCTBHS.pls 120.1 2005/08/19 16:49:51 mwasowic noship $
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,
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,
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,
24 X_LAST_UPDATE_LOGIN IN NUMBER ,
25 X_RETURN_STATUS OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
26
27 PROCEDURE INSERT_ROW2 (
28 X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29 X_RESOURCE_TXN_ATTRIBUTE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
30 RESOURCE_TXN_ATTRIBUTE_ID%TYPE,
31 X_RESOURCE_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
32 RESOURCE_ID%TYPE,
33 X_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
34 PERSON_ID%TYPE,
35 X_RESOURCE_FORMAT_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
36 RESOURCE_FORMAT_ID%TYPE,
37 X_REQUEST_ID IN NUMBER,
38 X_PROGRAM_ID IN NUMBER,
39 X_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.
40 PARTY_ID%TYPE,
41 X_PROGRAM_UPDATE_DATE IN DATE,
42 X_PROGRAM_APPLICATION_ID IN NUMBER,
43 X_LAST_UPDATE_BY IN NUMBER,
44 X_LAST_UPDATE_DATE IN DATE,
45 X_CREATION_DATE IN DATE,
46 X_CREATED_BY IN NUMBER,
47 X_LAST_UPDATE_LOGIN IN NUMBER ,
48 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
49
50 END PA_RESOURCE_PKG;