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_GROUPS_VL

Line 275: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B

271: -- select B.group_id, B.group_name, B.group_number,
272: -- A.start_date_active, A.end_date_active,
273: -- B.exclusive_flag, B.group_desc, B.object_version_number,
274: -- A.sql_text
275: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B
276: -- Where A.group_name || '(' || A.group_number || ')' = B.GROUP_NAME
277: -- and ( ( A.end_date_active is null ) or ( A.end_date_active > sysdate ) )
278: -- and A.Usage = 'ISUPPORT';
279:

Line 290: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B

286: -- select B.group_id, A.group_name || '(' || A.group_number || ')' group_name, B.group_number,
287: -- A.start_date_active, A.end_date_active,
288: -- B.exclusive_flag, B.group_desc, B.object_version_number,
289: -- A.sql_text
290: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B
291: -- Where B.GROUP_NAME like '%(' || A.group_number || ')'
292: -- and ( ( A.end_date_active is null ) or ( A.end_date_active > sysdate ) )
293: -- and A.Usage = 'ISUPPORT';
294: --and A.last_update_date > Sysdate - 1;

Line 331: l_group_id jtf_rs_groups_vl.group_id%TYPE;

327: and
328: A.Usage = 'ISUPPORT' ;
329:
330:
331: l_group_id jtf_rs_groups_vl.group_id%TYPE;
332: l_group_name jtf_rs_groups_vl.group_name%TYPE;
333: l_group_number jtf_rs_groups_vl.group_number%TYPE;
334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;

Line 332: l_group_name jtf_rs_groups_vl.group_name%TYPE;

328: A.Usage = 'ISUPPORT' ;
329:
330:
331: l_group_id jtf_rs_groups_vl.group_id%TYPE;
332: l_group_name jtf_rs_groups_vl.group_name%TYPE;
333: l_group_number jtf_rs_groups_vl.group_number%TYPE;
334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE;

Line 333: l_group_number jtf_rs_groups_vl.group_number%TYPE;

329:
330:
331: l_group_id jtf_rs_groups_vl.group_id%TYPE;
332: l_group_name jtf_rs_groups_vl.group_name%TYPE;
333: l_group_number jtf_rs_groups_vl.group_number%TYPE;
334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE;
337: l_group_desc jtf_rs_groups_vl.group_desc%TYPE;

Line 336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE;

332: l_group_name jtf_rs_groups_vl.group_name%TYPE;
333: l_group_number jtf_rs_groups_vl.group_number%TYPE;
334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%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);

Line 337: l_group_desc jtf_rs_groups_vl.group_desc%TYPE;

333: l_group_number jtf_rs_groups_vl.group_number%TYPE;
334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%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;

Line 338: l_obj_grp_version_num jtf_rs_groups_vl.object_version_number%TYPE;

334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%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;

Line 345: Cursor l_del_mem_csr(p_group_id jtf_rs_groups_vl.group_id%TYPE)

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
347: select A.group_member_id,
348: B.resource_id,
349: B.resource_number ,

Line 373: Cursor l_cre_csr (p_group_id jtf_rs_groups_vl.group_id%TYPE)

369: and ( (end_date_active is null ) OR (end_date_active > sysdate) )
370: );
371:
372: -- Do not create members whose resource records are end dated
373: Cursor l_cre_csr (p_group_id jtf_rs_groups_vl.group_id%TYPE)
374: IS
375: select B.resource_id, B.resource_number
376: from ibu_usergroups_temp A, jtf_rs_resource_extns B
377: where A.source_id = B.source_id

Line 667: from jtf_rs_groups_vl B

663: A.sql_text,
664: A.created_by
665: from jtf_rs_dynamic_groups_vl A
666: Where not exists ( Select B.group_name
667: from jtf_rs_groups_vl B
668: Where B.group_name = A.group_name || '(' || A.group_number || ')' )
669: and ( ( A.end_date_active is null ) or ( A.end_date_active > sysdate ) )
670: and A.Usage = 'ISUPPORT';
671:

Line 695: l_group_id jtf_rs_groups_vl.group_id%type;

691: createResGrpExp Exception;
692: creByFndUserExp Exception;
693:
694: -- IN/OUT variables for APIs
695: l_group_id jtf_rs_groups_vl.group_id%type;
696: l_group_number jtf_rs_groups_vl.group_number%type;
697: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
698: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
699: l_channel_rec AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE;

Line 696: l_group_number jtf_rs_groups_vl.group_number%type;

692: creByFndUserExp Exception;
693:
694: -- IN/OUT variables for APIs
695: l_group_id jtf_rs_groups_vl.group_id%type;
696: l_group_number jtf_rs_groups_vl.group_number%type;
697: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
698: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
699: l_channel_rec AMV_CHANNEL_PVT.AMV_CHANNEL_OBJ_TYPE;
700:

Line 702: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE DEFAULT 'N';

698: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
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

Line 1073: from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B

1069: B.group_name static_group_name,
1070: B.group_number static_group_number,
1071: A.start_date_active, A.end_date_active, A.sql_text,
1072: B.exclusive_flag, B.group_desc, B.object_version_number
1073: from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B
1074: Where A.group_name || '(' || A.group_number || ')' = B.GROUP_NAME
1075: and ( ( B.end_date_active is null ) OR ( B.end_date_active > sysdate ) )
1076: and ( ( A.end_date_active is not null ) AND ( A.end_date_active <= sysdate ) )
1077: and A.usage = 'ISUPPORT';

Line 1092: from jtf_rs_groups_vl A, jtf_rs_group_members B, jtf_rs_resource_extns C

1088: A.group_number,
1089: B.object_version_number,
1090: B.resource_id,
1091: C.resource_number
1092: from jtf_rs_groups_vl A, jtf_rs_group_members B, jtf_rs_resource_extns C
1093: Where A.group_id = p_group_id
1094: and A.group_id = B.group_id
1095: and B.resource_id = C.resource_id
1096: and B.delete_flag = 'N' ;