[Home] [Help]
PACKAGE: APPS.PA_R_PROJECT_RESOURCES_PUB
Source
1 PACKAGE PA_R_PROJECT_RESOURCES_PUB
2 /* $Header: PARCPRPS.pls 120.3 2006/11/09 09:01:07 msachan noship $ */
3 AS
4
5 PROCEDURE CREATE_RESOURCE(
6 P_API_VERSION IN NUMBER,
7 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT NULL,
8 P_COMMIT IN VARCHAR2 DEFAULT NULL,
9 P_VALIDATE_ONLY IN VARCHAR2 DEFAULT NULL,
10 P_MAX_MSG_COUNT IN NUMBER DEFAULT NULL,
11 P_INTERNAL IN VARCHAR2 DEFAULT 'Y',
12 P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE
13 DEFAULT NULL,
14 P_INDIVIDUAL IN VARCHAR2 DEFAULT 'N',
15 P_CHECK_RESOURCE IN VARCHAR2 DEFAULT 'N',
16 P_SCHEDULED_MEMBER_FLAG IN VARCHAR2 DEFAULT 'Y',
17 P_RESOURCE_TYPE IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE DEFAULT NULL,
18 P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PARTY_ID%TYPE DEFAULT NULL,
19 P_FROM_EMP_NUM IN VARCHAR2 DEFAULT NULL,
20 P_TO_EMP_NUM IN VARCHAR2 DEFAULT NULL,
21 P_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
22 P_REFRESH IN VARCHAR2 DEFAULT 'Y',
23 P_PULL_TERM_RES IN VARCHAR2 DEFAULT 'N',
24 P_TERM_RANGE_DATE IN DATE DEFAULT NULL,
25 P_PERSON_TYPE IN VARCHAR2 DEFAULT 'ALL',
26 P_START_DATE IN DATE DEFAULT NULL, -- Bug 5337454
27 -- Added parameters for PJR Resource Pull Enhancements - Bug 5130414
28 P_SELECTION_OPTION IN VARCHAR2 DEFAULT NULL,
29 P_ORG_STR_VERSION_ID IN NUMBER DEFAULT NULL,
30 P_START_ORGANIZATION_ID IN NUMBER DEFAULT NULL,
31 -- End of parameters added for PJR Resource Pull Enhancements - Bug 5130414
32 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
34 X_MSG_DATA OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE ); --File.Sql.39 bug 4440895
36
37
38 END PA_R_PROJECT_RESOURCES_PUB;