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 200: FROM jtf_rs_groups_denorm

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

Line 285: FROM jtf_rs_groups_denorm

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

Line 1312: FROM jtf_rs_groups_denorm

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

Line 1393: FROM jtf_rs_groups_denorm

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

Line 2806: -- FOR DELETE ON JTF_RS_GROUPS_DENORM

2802:
2803: END DELETE_MEMBERS;
2804:
2805:
2806: -- FOR DELETE ON JTF_RS_GROUPS_DENORM
2807: PROCEDURE DELETE_GROUP_DENORM(
2808: P_API_VERSION IN NUMBER,
2809: P_INIT_MSG_LIST IN VARCHAR2,
2810: P_COMMIT IN VARCHAR2,

Line 2811: P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,

2807: PROCEDURE DELETE_GROUP_DENORM(
2808: P_API_VERSION IN NUMBER,
2809: P_INIT_MSG_LIST IN VARCHAR2,
2810: P_COMMIT IN VARCHAR2,
2811: P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,
2812: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2813: X_MSG_COUNT OUT NOCOPY NUMBER,
2814: X_MSG_DATA OUT NOCOPY VARCHAR2 )
2815: IS

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

2813: X_MSG_COUNT OUT NOCOPY NUMBER,
2814: X_MSG_DATA OUT NOCOPY VARCHAR2 )
2815: IS
2816:
2817: l_denorm_grp_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE := p_denorm_grp_id;
2818:
2819: CURSOR denorm_cur(l_denorm_group_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE)
2820: IS
2821: SELECT parent_group_id ,

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

2815: IS
2816:
2817: l_denorm_grp_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE := p_denorm_grp_id;
2818:
2819: CURSOR denorm_cur(l_denorm_group_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE)
2820: IS
2821: SELECT parent_group_id ,
2822: group_id
2823: FROM jtf_rs_groups_denorm

Line 2823: FROM jtf_rs_groups_denorm

2819: CURSOR denorm_cur(l_denorm_group_id JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE)
2820: IS
2821: SELECT parent_group_id ,
2822: group_id
2823: FROM jtf_rs_groups_denorm
2824: WHERE denorm_grp_id = l_denorm_group_id;
2825:
2826: denorm_rec denorm_cur%rowtype;
2827:

Line 2912: jtf_rs_groups_denorm_pkg.delete_row(l_denorm_grp_id);

2908: FETCH denorm_cur INTO denorm_rec;
2909: IF (denorm_cur%FOUND)
2910: THEN
2911: --added this to delete the denorm record before recreating it again
2912: jtf_rs_groups_denorm_pkg.delete_row(l_denorm_grp_id);
2913: --get all the role relate ids for the parent group
2914: OPEN par_role_relate_cur(denorm_rec.parent_group_id);
2915: FETCH par_role_relate_cur INTO par_role_relate_rec;
2916: WHILE(par_role_relate_cur%FOUND)

Line 3090: FROM jtf_rs_groups_denorm

3086: l_end_date_active DATE)
3087: IS
3088: SELECT parent_group_id,
3089: immediate_parent_flag
3090: FROM jtf_rs_groups_denorm
3091: WHERE group_id = l_group_id
3092: AND parent_group_id <> l_group_id
3093: AND ((l_start_date_active between start_date_active
3094: and nvl(end_date_active , l_start_date_active +1))

Line 3862: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,

3858: PROCEDURE DELETE_REP_MGR (
3859: P_API_VERSION IN NUMBER,
3860: P_INIT_MSG_LIST IN VARCHAR2,
3861: P_COMMIT IN VARCHAR2,
3862: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
3863: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
3864: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3865: X_MSG_COUNT OUT NOCOPY NUMBER,
3866: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3863: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,

3859: P_API_VERSION IN NUMBER,
3860: P_INIT_MSG_LIST IN VARCHAR2,
3861: P_COMMIT IN VARCHAR2,
3862: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
3863: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
3864: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3865: X_MSG_COUNT OUT NOCOPY NUMBER,
3866: X_MSG_DATA OUT NOCOPY VARCHAR2)
3867: IS

Line 4029: from jtf_rs_groups_denorm

4025: FROM jtf_rs_group_members mem,
4026: jtf_rs_role_relations rlt,
4027: jtf_rs_roles_B rol
4028: WHERE mem.group_id IN ( select distinct(parent_group_id)
4029: from jtf_rs_groups_denorm
4030: where group_id = l_group_id)
4031: /* this has been added to include all parents in the hierarchy */
4032: AND mem.group_member_id = rlt.role_resource_id
4033: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 4072: FROM jtf_rs_groups_denorm

4068: SELECT group_id,
4069: start_date_active,
4070: end_date_active,
4071: immediate_parent_flag
4072: FROM jtf_rs_groups_denorm
4073: WHERE parent_group_id = l_group_id
4074: AND group_id NOT IN (l_group_id);
4075:
4076: child_grp_rec child_grp_cur%ROWTYPE;