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.IBU_DYN_USER_GROUPS_PKG dependencies on JTF_RS_ROLE_RELATIONS

Line 341: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;

337: l_group_desc jtf_rs_groups_vl.group_desc%TYPE;
338: l_obj_grp_version_num jtf_rs_groups_vl.object_version_number%TYPE;
339: l_sql_text jtf_rs_dynamic_groups_vl.sql_text%TYPE;
340: l_category varchar2(50);
341: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
342: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
343: l_user_id fnd_user.user_id%TYPE;
344:
345: Cursor l_del_mem_csr(p_group_id jtf_rs_groups_vl.group_id%TYPE)

Line 342: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;

338: l_obj_grp_version_num jtf_rs_groups_vl.object_version_number%TYPE;
339: l_sql_text jtf_rs_dynamic_groups_vl.sql_text%TYPE;
340: l_category varchar2(50);
341: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
342: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
343: l_user_id fnd_user.user_id%TYPE;
344:
345: Cursor l_del_mem_csr(p_group_id jtf_rs_groups_vl.group_id%TYPE)
346: IS

Line 438: from jtf_rs_role_relations

434:
435: /* call update role_relations */
436: select role_relate_id, object_version_number
437: into l_role_relate_id, l_object_version_number
438: from jtf_rs_role_relations
439: where role_resource_type = 'RS_GROUP'
440: and role_resource_id = l_group_id;
441: jtf_rs_role_relate_pub.UPDATE_RESOURCE_ROLE_RELATE (
442: P_API_VERSION => 1.0,

Line 703: l_role_code jtf_rs_role_relations_vl.ROLE_TYPE_CODE%TYPE := 'IBUUG';

699: l_channel_rec AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE;
700:
701: -- constants in this program
702: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE DEFAULT 'N';
703: l_role_code jtf_rs_role_relations_vl.ROLE_TYPE_CODE%TYPE := 'IBUUG';
704: l_usage JTF_RS_GROUP_USAGES.USAGE%TYPE := 'ISUPPORT';
705:
706: -- Temporary variables
707: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;

Line 717: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;

713: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;
714: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;
715: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
716: l_channel_id NUMBER;
717: l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE;
718: l_group_usage_id JTF_RS_GROUP_USAGES.GROUP_USAGE_ID%TYPE;
719: l_category varchar2(50);
720: l_res_cnt NUMBER;
721: l_group_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE;

Line 1109: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;

1105: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1106: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1107: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1108: l_category varchar2(50);
1109: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1110: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
1111:
1112: -- constant
1113: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

Line 1110: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;

1106: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1107: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1108: l_category varchar2(50);
1109: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1110: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
1111:
1112: -- constant
1113: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
1114:

Line 1147: from jtf_rs_role_relations

1143: /* call update role_relations */
1144: Begin
1145: select role_relate_id, object_version_number
1146: into l_role_relate_id, l_object_version_number
1147: from jtf_rs_role_relations
1148: where role_resource_type = 'RS_GROUP'
1149: and role_resource_id = l_del_rec.static_group_id;
1150: Exception
1151: When no_data_found then

Line 1247: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;

1243: l_creby_resource_id jtf_rs_resource_extns.resource_id%TYPE;
1244: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1245: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1246: l_category varchar2(50);
1247: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1248: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
1249:
1250: l_return_status varchar2(1);
1251: l_msg_count number;

Line 1248: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;

1244: l_creby_resource_number jtf_rs_resource_extns.resource_number%TYPE;
1245: l_creby_obj_ver_num jtf_rs_resource_extns.object_version_number%TYPE;
1246: l_category varchar2(50);
1247: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1248: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
1249:
1250: l_return_status varchar2(1);
1251: l_msg_count number;
1252: l_msg_data varchar2(2000);