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_ROLE_RELATIONS

Line 18: P_ROLE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE,

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,
22: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 21: P_ROLE_RESOURCE_TYPE IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE,

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,
25: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 22: P_START_DATE_ACTIVE IN JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,

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,
25: X_MSG_COUNT OUT NOCOPY NUMBER,
26: X_MSG_DATA OUT NOCOPY VARCHAR2,

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

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,
25: X_MSG_COUNT OUT NOCOPY NUMBER,
26: X_MSG_DATA OUT NOCOPY VARCHAR2,
27: X_GROUP_MEMBER_ID OUT NOCOPY NUMBER,

Line 32: l_role_id JTF_RS_ROLE_RELATIONS.ROLE_ID%TYPE := P_ROLE_ID;

28: X_ROLE_RELATE_ID OUT NOCOPY NUMBER
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;

Line 35: l_role_resource_type JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_TYPE%TYPE := P_ROLE_RESOURCE_TYPE;

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;
39: l_role_resource_id NUMBER;

Line 36: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE := P_START_DATE_ACTIVE;

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;
39: l_role_resource_id NUMBER;
40: l_error_code NUMBER;

Line 37: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE := P_END_DATE_ACTIVE;

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;
39: l_role_resource_id NUMBER;
40: l_error_code NUMBER;
41: l_error_msg VARCHAR2(255);

Line 126: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,

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,
130: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

Line 127: P_OBJECT_VERSION_NUM1 IN JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

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,
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,

Line 138: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE := P_ROLE_RELATE_ID;

134: X_MSG_DATA OUT NOCOPY VARCHAR2
135: )
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;

Line 139: l_object_version_number1 JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM1;

135: )
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;

Line 144: l_check_res_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

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);
148: l_role_deleted BOOLEAN := FALSE;

Line 150: CURSOR c_csf_res_role_relation_id( l_resource_role_id IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ) IS

146: l_error_msg VARCHAR2(255);
147: l_msg_data VARCHAR2(255);
148: l_role_deleted BOOLEAN := FALSE;
149:
150: CURSOR c_csf_res_role_relation_id( l_resource_role_id IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ) IS
151: select role_relate_id
152: from jtf_rs_role_relations
153: where role_resource_id = l_resource_role_id
154: and role_resource_type = 'RS_GROUP_MEMBER'

Line 152: from jtf_rs_role_relations

148: l_role_deleted BOOLEAN := FALSE;
149:
150: CURSOR c_csf_res_role_relation_id( l_resource_role_id IN JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE ) IS
151: select role_relate_id
152: from jtf_rs_role_relations
153: where role_resource_id = l_resource_role_id
154: and role_resource_type = 'RS_GROUP_MEMBER'
155: and nvl(delete_flag, 'N') <> 'Y';
156: