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.JTF_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_GROUPS_DENORM

Line 201: FROM jtf_rs_groups_denorm

197: immediate_parent_flag,
198: start_date_active,
199: end_date_active,
200: denorm_level
201: FROM jtf_rs_groups_denorm
202: WHERE group_id = l_group_id
203: AND parent_group_id <> l_group_id
204: /* AND ((l_start_date_active between start_date_active
205: and nvl(end_date_active , l_start_date_active +1))

Line 286: FROM jtf_rs_groups_denorm

282: immediate_parent_flag,
283: start_date_active,
284: end_date_active,
285: denorm_level
286: FROM jtf_rs_groups_denorm
287: WHERE parent_group_id = l_group_id
288: AND group_id <> l_group_id;
289: /* AND ((l_start_date_active between start_date_active
290: and nvl(end_date_active , l_start_date_active +1))

Line 1313: FROM jtf_rs_groups_denorm

1309: l_end_date_active DATE)
1310: IS
1311: SELECT parent_group_id,
1312: immediate_parent_flag
1313: FROM jtf_rs_groups_denorm
1314: WHERE group_id = l_group_id
1315: AND parent_group_id <> l_group_id
1316: AND ((l_start_date_active between start_date_active
1317: and nvl(end_date_active , l_start_date_active +1))

Line 1394: FROM jtf_rs_groups_denorm

1390: l_end_date_active DATE)
1391: IS
1392: SELECT group_id,
1393: immediate_parent_flag
1394: FROM jtf_rs_groups_denorm
1395: WHERE parent_group_id = l_group_id
1396: AND group_id <> l_group_id
1397: AND ((l_start_date_active between start_date_active
1398: and nvl(end_date_active , l_start_date_active +1))

Line 2819: -- FOR DELETE ON JTF_RS_GROUPS_DENORM

2815:
2816: END DELETE_MEMBERS;
2817:
2818:
2819: -- FOR DELETE ON JTF_RS_GROUPS_DENORM
2820: PROCEDURE DELETE_GROUP_DENORM(
2821: P_API_VERSION IN NUMBER,
2822: P_INIT_MSG_LIST IN VARCHAR2,
2823: P_COMMIT IN VARCHAR2,

Line 2824: P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,

2820: PROCEDURE DELETE_GROUP_DENORM(
2821: P_API_VERSION IN NUMBER,
2822: P_INIT_MSG_LIST IN VARCHAR2,
2823: P_COMMIT IN VARCHAR2,
2824: P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,
2825: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2826: X_MSG_COUNT OUT NOCOPY NUMBER,
2827: X_MSG_DATA OUT NOCOPY VARCHAR2 )
2828: IS

Line 2830: l_denorm_grp_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE := p_denorm_grp_id;

2826: X_MSG_COUNT OUT NOCOPY NUMBER,
2827: X_MSG_DATA OUT NOCOPY VARCHAR2 )
2828: IS
2829:
2830: l_denorm_grp_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE := p_denorm_grp_id;
2831:
2832: CURSOR denorm_cur(l_denorm_group_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE)
2833: IS
2834: SELECT parent_group_id ,

Line 2832: CURSOR denorm_cur(l_denorm_group_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE)

2828: IS
2829:
2830: l_denorm_grp_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE := p_denorm_grp_id;
2831:
2832: CURSOR denorm_cur(l_denorm_group_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE)
2833: IS
2834: SELECT parent_group_id ,
2835: group_id
2836: FROM jtf_rs_groups_denorm

Line 2836: FROM jtf_rs_groups_denorm

2832: CURSOR denorm_cur(l_denorm_group_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE)
2833: IS
2834: SELECT parent_group_id ,
2835: group_id
2836: FROM jtf_rs_groups_denorm
2837: WHERE denorm_grp_id = l_denorm_group_id;
2838:
2839: denorm_rec denorm_cur%rowtype;
2840:

Line 2925: jtf_rs_groups_denorm_pkg.delete_row(l_denorm_grp_id);

2921: FETCH denorm_cur INTO denorm_rec;
2922: IF (denorm_cur%FOUND)
2923: THEN
2924: --added this to delete the denorm record before recreating it again
2925: jtf_rs_groups_denorm_pkg.delete_row(l_denorm_grp_id);
2926: --get all the role relate ids for the parent group
2927: OPEN par_role_relate_cur(denorm_rec.parent_group_id);
2928: FETCH par_role_relate_cur INTO par_role_relate_rec;
2929: WHILE(par_role_relate_cur%FOUND)

Line 3103: FROM jtf_rs_groups_denorm

3099: l_end_date_active DATE)
3100: IS
3101: SELECT parent_group_id,
3102: immediate_parent_flag
3103: FROM jtf_rs_groups_denorm
3104: WHERE group_id = l_group_id
3105: AND parent_group_id <> l_group_id
3106: AND ((l_start_date_active between start_date_active
3107: and nvl(end_date_active , l_start_date_active +1))

Line 3875: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,

3871: PROCEDURE DELETE_REP_MGR (
3872: P_API_VERSION IN NUMBER,
3873: P_INIT_MSG_LIST IN VARCHAR2,
3874: P_COMMIT IN VARCHAR2,
3875: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
3876: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
3877: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3878: X_MSG_COUNT OUT NOCOPY NUMBER,
3879: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3876: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,

3872: P_API_VERSION IN NUMBER,
3873: P_INIT_MSG_LIST IN VARCHAR2,
3874: P_COMMIT IN VARCHAR2,
3875: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
3876: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
3877: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3878: X_MSG_COUNT OUT NOCOPY NUMBER,
3879: X_MSG_DATA OUT NOCOPY VARCHAR2)
3880: IS

Line 4042: from jtf_rs_groups_denorm

4038: FROM jtf_rs_group_members mem,
4039: jtf_rs_role_relations rlt,
4040: jtf_rs_roles_B rol
4041: WHERE mem.group_id IN ( select distinct(parent_group_id)
4042: from jtf_rs_groups_denorm
4043: where group_id = l_group_id)
4044: /* this has been added to include all parents in the hierarchy */
4045: AND mem.group_member_id = rlt.role_resource_id
4046: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 4085: FROM jtf_rs_groups_denorm

4081: SELECT group_id,
4082: start_date_active,
4083: end_date_active,
4084: immediate_parent_flag
4085: FROM jtf_rs_groups_denorm
4086: WHERE parent_group_id = l_group_id
4087: AND group_id NOT IN (l_group_id);
4088:
4089: child_grp_rec child_grp_cur%ROWTYPE;