DBA Data[Home] [Help]

APPS.CSF_RES_GROUP_ROLE_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 7: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

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,

Line 10: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

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,

Line 11: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

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,

Line 12: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

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,

Line 23: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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,

Line 24: P_OBJECT_VERSION_NUM1 IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

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,