DBA Data[Home] [Help]

APPS.CSF_RES_GROUP_ROLE_PVT dependencies on FND_API

Line 16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

12: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
13: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
14:
15: PROCEDURE INSERT_GROUP_ROLES(P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
19: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
20: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

Line 17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

13: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
14:
15: PROCEDURE INSERT_GROUP_ROLES(P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,
19: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
20: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
21: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

Line 77: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN

73: X_MSG_COUNT => X_MSG_COUNT,
74: X_MSG_DATA => X_MSG_DATA,
75: X_GROUP_MEMBER_ID => X_GROUP_MEMBER_ID
76: );
77: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
78: Debug_Message('jtf_rs_group_members_pub.create_resource_group_members Successful,X_GROUP_MEMBER_ID'||X_GROUP_MEMBER_ID, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
79: l_role_resource_id := X_GROUP_MEMBER_ID;
80: END IF;
81: ELSE

Line 105: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN

101: X_MSG_COUNT => X_MSG_COUNT,
102: X_MSG_DATA => X_MSG_DATA,
103: X_ROLE_RELATE_ID => X_ROLE_RELATE_ID
104: );
105: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
106: Debug_Message('jtf_rs_role_relate_pub.create_resource_role_relate Successful,X_ROLE_RELATE_ID='||X_ROLE_RELATE_ID, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
107: END IF;
108: END IF;
109:

Line 124: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

120: Debug_Message('In Exception Block of INSERT_GROUP_ROLES'||l_msg_data, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
121: END INSERT_GROUP_ROLES;
122:
123: PROCEDURE DELETE_GROUP_ROLES(P_API_VERSION IN NUMBER,
124: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
125: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
127: P_OBJECT_VERSION_NUM1 IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
128: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

Line 125: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

121: END INSERT_GROUP_ROLES;
122:
123: PROCEDURE DELETE_GROUP_ROLES(P_API_VERSION IN NUMBER,
124: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
125: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
127: P_OBJECT_VERSION_NUM1 IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
128: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
129: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

Line 171: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN

167: X_RETURN_STATUS => X_RETURN_STATUS,
168: X_MSG_COUNT => X_MSG_COUNT,
169: X_MSG_DATA => X_MSG_DATA
170: );
171: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
172: Debug_Message('Call to jtf_rs_role_relate_pub.delete_resource_role_relate Successful', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
173: l_role_deleted := TRUE;
174: END IF;
175: ELSE

Line 200: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN

196: X_RETURN_STATUS => X_RETURN_STATUS,
197: X_MSG_COUNT => X_MSG_COUNT,
198: X_MSG_DATA => X_MSG_DATA
199: );
200: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
201: Debug_Message('Call to jtf_rs_group_members_pub.delete_resource_group_members Successful', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
202: END IF;
203: END IF;
204: END IF;