eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_RES_GROUP_ROLE_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 19: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 20: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 33: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;

29: )
30: IS
31: l_api_version CONSTANT NUMBER := 1.0;
32: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := P_ROLE_ID;
33: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;
34: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;
35: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := P_ROLE_RESOURCE_TYPE;
36: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := P_START_DATE_ACTIVE;
37: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE := P_END_DATE_ACTIVE;

Line 34: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;

30: IS
31: l_api_version CONSTANT NUMBER := 1.0;
32: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := P_ROLE_ID;
33: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;
34: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;
35: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := P_ROLE_RESOURCE_TYPE;
36: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := P_START_DATE_ACTIVE;
37: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE := P_END_DATE_ACTIVE;
38: l_group_member_id_exists JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE;

Line 38: l_group_member_id_exists JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE;

34: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;
35: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := P_ROLE_RESOURCE_TYPE;
36: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := P_START_DATE_ACTIVE;
37: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE := P_END_DATE_ACTIVE;
38: l_group_member_id_exists JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE;
39: l_role_resource_id NUMBER;
40: l_error_code NUMBER;
41: l_error_msg VARCHAR2(255);
42: l_msg_data VARCHAR2(255);

Line 45: CURSOR c_group_member_id_exists( l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

41: l_error_msg VARCHAR2(255);
42: l_msg_data VARCHAR2(255);
43:
44:
45: CURSOR c_group_member_id_exists( l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
46: l_resource_id IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE )
47: IS
48: select group_member_id
49: from jtf_rs_group_members

Line 46: l_resource_id IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE )

42: l_msg_data VARCHAR2(255);
43:
44:
45: CURSOR c_group_member_id_exists( l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
46: l_resource_id IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE )
47: IS
48: select group_member_id
49: from jtf_rs_group_members
50: where group_id = l_group_id

Line 49: from jtf_rs_group_members

45: CURSOR c_group_member_id_exists( l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
46: l_resource_id IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE )
47: IS
48: select group_member_id
49: from jtf_rs_group_members
50: where group_id = l_group_id
51: and resource_id = l_resource_id
52: and nvl(delete_flag, 'N') <> 'Y';
53:

Line 63: Debug_Message('group member does not exist calling jtf_rs_group_members_pub.create_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

59: OPEN c_group_member_id_exists(l_group_id,l_resource_id);
60: FETCH c_group_member_id_exists INTO l_group_member_id_exists;
61:
62: IF c_group_member_id_exists%NOTFOUND THEN
63: Debug_Message('group member does not exist calling jtf_rs_group_members_pub.create_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
64: jtf_rs_group_members_pub.create_resource_group_members
65: (P_API_VERSION => l_api_version,
66: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
67: P_COMMIT => P_COMMIT,

Line 64: jtf_rs_group_members_pub.create_resource_group_members

60: FETCH c_group_member_id_exists INTO l_group_member_id_exists;
61:
62: IF c_group_member_id_exists%NOTFOUND THEN
63: Debug_Message('group member does not exist calling jtf_rs_group_members_pub.create_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
64: jtf_rs_group_members_pub.create_resource_group_members
65: (P_API_VERSION => l_api_version,
66: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
67: P_COMMIT => P_COMMIT,
68: P_GROUP_ID => l_group_id,

Line 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);

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
82: Debug_Message('Group Member Id Exists,value='||l_group_member_id_exists, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

Line 128: P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

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,
130: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
131: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
132: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 129: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,

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,
130: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
131: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
132: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
133: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 130: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

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,
130: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
131: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
132: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
133: X_MSG_COUNT OUT NOCOPY NUMBER,
134: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 131: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%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,
130: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
131: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,
132: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
133: X_MSG_COUNT OUT NOCOPY NUMBER,
134: X_MSG_DATA OUT NOCOPY VARCHAR2
135: )

Line 140: l_group_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE := P_GROUP_MEMBER_ID;

136: IS
137: l_api_version CONSTANT NUMBER := 1.0;
138: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := P_ROLE_RELATE_ID;
139: l_object_version_number1 JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM1;
140: l_group_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE := P_GROUP_MEMBER_ID;
141: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;
142: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;
143: l_object_version_number JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
144: l_check_res_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

Line 141: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;

137: l_api_version CONSTANT NUMBER := 1.0;
138: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := P_ROLE_RELATE_ID;
139: l_object_version_number1 JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM1;
140: l_group_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE := P_GROUP_MEMBER_ID;
141: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;
142: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;
143: l_object_version_number JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
144: l_check_res_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
145: l_error_code NUMBER;

Line 142: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;

138: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := P_ROLE_RELATE_ID;
139: l_object_version_number1 JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM1;
140: l_group_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE := P_GROUP_MEMBER_ID;
141: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;
142: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;
143: l_object_version_number JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
144: l_check_res_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
145: l_error_code NUMBER;
146: l_error_msg VARCHAR2(255);

Line 143: l_object_version_number JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

139: l_object_version_number1 JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM1;
140: l_group_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE := P_GROUP_MEMBER_ID;
141: l_group_id JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE := P_GROUP_ID;
142: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE := P_RESOURCE_ID;
143: l_object_version_number JTF_RS_GROUP_MEMBERS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
144: l_check_res_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
145: l_error_code NUMBER;
146: l_error_msg VARCHAR2(255);
147: l_msg_data VARCHAR2(255);

Line 186: Debug_Message('No more Roles left in the Group, calling jtf_rs_group_members_pub.delete_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

182: OPEN c_csf_res_role_relation_id(l_group_member_id);
183: FETCH c_csf_res_role_relation_id INTO l_check_res_role_relate_id;
184:
185: IF c_csf_res_role_relation_id%NOTFOUND THEN
186: Debug_Message('No more Roles left in the Group, calling jtf_rs_group_members_pub.delete_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
187: jtf_rs_group_members_pub.delete_resource_group_members
188: (P_API_VERSION => l_api_version,
189: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
190: P_COMMIT => P_COMMIT,

Line 187: jtf_rs_group_members_pub.delete_resource_group_members

183: FETCH c_csf_res_role_relation_id INTO l_check_res_role_relate_id;
184:
185: IF c_csf_res_role_relation_id%NOTFOUND THEN
186: Debug_Message('No more Roles left in the Group, calling jtf_rs_group_members_pub.delete_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
187: jtf_rs_group_members_pub.delete_resource_group_members
188: (P_API_VERSION => l_api_version,
189: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
190: P_COMMIT => P_COMMIT,
191: P_GROUP_ID => l_group_id,

Line 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);

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;
205: