[Home] [Help]
PACKAGE: APPS.CSF_RES_GROUP_ROLE_PVT
Source
1 PACKAGE CSF_RES_GROUP_ROLE_PVT AUTHID CURRENT_USER AS
2 /* $Header: csfvrsgs.pls 120.2 2010/10/27 10:20:45 dkailash noship $ */
3
4 PROCEDURE INSERT_GROUP_ROLES(P_API_VERSION IN NUMBER,
5 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
6 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7 P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
8 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
9 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
10 P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,
11 P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
12 P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
13 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
14 X_MSG_COUNT OUT NOCOPY NUMBER,
15 X_MSG_DATA OUT NOCOPY VARCHAR2,
16 X_GROUP_MEMBER_ID OUT NOCOPY NUMBER,
17 X_ROLE_RELATE_ID OUT NOCOPY NUMBER
18 );
19
20 PROCEDURE DELETE_GROUP_ROLES(P_API_VERSION IN NUMBER,
21 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
24 P_OBJECT_VERSION_NUM1 IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
25 P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
26 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
27 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
28 P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
29 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
30 X_MSG_COUNT OUT NOCOPY NUMBER,
31 X_MSG_DATA OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE Debug_Message(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER);
35
36 END CSF_RES_GROUP_ROLE_PVT;