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_GROUP_DENORM_PVT dependencies on JTF_RS_REP_MGR_DENORM_PVT

Line 866: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

862: X_LAST_UPDATED_BY => l_user_id,
863: X_LAST_UPDATE_LOGIN => l_login_id,
864: X_DENORM_LEVEL => l_child_tab(i).level);
865:
866: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
867: P_API_VERSION => 1.0,
868: P_GROUP_DENORM_ID => l_denorm_grp_id,
869: P_GROUP_ID => l_child_tab(i).p_group_id ,
870: P_PARENT_GROUP_ID => p_group_id ,

Line 995: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

991: X_DENORM_LEVEL => r_parents.level);
992:
993:
994:
995: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
996: P_API_VERSION => 1.0,
997: P_GROUP_DENORM_ID => l_denorm_grp_id,
998: P_GROUP_ID => p_group_id ,
999: P_PARENT_GROUP_ID => r_parents.related_group_id ,

Line 1108: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

1104: X_LAST_UPDATED_BY => l_user_id,
1105: X_LAST_UPDATE_LOGIN => l_login_id,
1106: X_DENORM_LEVEL => l_child_tab(i).level + r_parents.level);
1107:
1108: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
1109: P_API_VERSION => 1.0,
1110: P_GROUP_DENORM_ID => l_denorm_grp_id,
1111: P_GROUP_ID => l_child_tab(i).p_group_id ,
1112: P_PARENT_GROUP_ID => r_parents.related_group_id ,

Line 1310: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (

1306: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1307: --delete the previous hierarchy for the group
1308: for r_group_denorm IN c_group_denorm(p_group_id)
1309: loop
1310: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (
1311: P_API_VERSION => 1.0,
1312: P_GROUP_ID => r_group_denorm.group_id,
1313: P_PARENT_GROUP_ID => r_group_denorm.parent_group_id,
1314: X_RETURN_STATUS => l_return_status,

Line 1336: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (

1332: LOOP
1333:
1334: for r_group_denorm IN c_group_denorm(r_child.group_id)
1335: loop
1336: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (
1337: P_API_VERSION => 1.0,
1338: P_GROUP_ID => r_group_denorm.group_id,
1339: P_PARENT_GROUP_ID => r_group_denorm.parent_group_id,
1340: X_RETURN_STATUS => l_return_status,

Line 1809: jtf_rs_rep_mgr_denorm_pvt.insert_rep_mgr_parent(

1805: FOR k IN 1 .. l_child_rol_rel_tab.COUNT
1806: LOOP
1807: if(l_child_rol_rel_tab(k).group_id = l_child_tab(i).p_group_id)
1808: then
1809: jtf_rs_rep_mgr_denorm_pvt.insert_rep_mgr_parent(
1810: p_api_version => 1.0,
1811: p_commit => 'T',
1812: p_role_relate_id => l_child_rol_rel_tab(k).role_relate_id,
1813: x_return_status => x_return_status,

Line 2181: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

2177: X_DENORM_LEVEL => r_parents.level );
2178:
2179:
2180: --call rep manager insert
2181: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
2182: P_API_VERSION => 1.0,
2183: P_GROUP_DENORM_ID => l_denorm_grp_id,
2184: P_GROUP_ID => p_group_id ,
2185: P_PARENT_GROUP_ID => r_parents.related_group_id ,

Line 2399: JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM

2395: for r_group_denorm IN c_group_denorm(p_group_id)
2396: loop
2397:
2398: --call to DELETt records in jtf_rs_rep_managers
2399: JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM
2400: ( P_API_VERSION => 1.0,
2401: P_INIT_MSG_LIST => p_init_msg_list,
2402: P_COMMIT => null,
2403: P_DENORM_GRP_ID => r_group_denorm.denorm_grp_id,

Line 2427: JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM

2423: r_group_denorm.parent_group_id)
2424: loop
2425:
2426: --call to DELETE records in jtf_rs_rep_managers
2427: JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM
2428: ( P_API_VERSION => 1.0,
2429: P_INIT_MSG_LIST => p_init_msg_list,
2430: P_COMMIT => null,
2431: P_DENORM_GRP_ID => r_child_denorm.denorm_grp_id,

Line 2443: --removing this and calling this in JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM

2439: END IF;
2440:
2441:
2442:
2443: --removing this and calling this in JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM
2444: --jtf_rs_groups_denorm_pkg.delete_row(r_child_denorm.denorm_grp_id);
2445: end loop;
2446: end if;
2447: END LOOP;

Line 2449: --removing this and calling this in JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM

2445: end loop;
2446: end if;
2447: END LOOP;
2448: END IF;
2449: --removing this and calling this in JTF_RS_REP_MGR_DENORM_PVT.DELETE_GROUP_DENORM
2450: --jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.denorm_grp_id);
2451:
2452:
2453: end loop;

Line 2986: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

2982: X_LAST_UPDATED_BY => l_user_id,
2983: X_LAST_UPDATE_LOGIN => l_login_id,
2984: X_DENORM_LEVEL => l_child_tab(i).level);
2985:
2986: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
2987: P_API_VERSION => 1.0,
2988: P_GROUP_DENORM_ID => l_denorm_grp_id,
2989: P_GROUP_ID => l_child_tab(i).p_group_id ,
2990: P_PARENT_GROUP_ID => p_group_id ,

Line 3113: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

3109: X_DENORM_LEVEL => l_parent_tab(j).level);
3110:
3111:
3112:
3113: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
3114: P_API_VERSION => 1.0,
3115: P_GROUP_DENORM_ID => l_denorm_grp_id,
3116: P_GROUP_ID => p_group_id ,
3117: P_PARENT_GROUP_ID => l_parent_tab(j).p_related_group_id ,

Line 3226: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

3222: X_LAST_UPDATED_BY => l_user_id,
3223: X_LAST_UPDATE_LOGIN => l_login_id,
3224: X_DENORM_LEVEL => l_child_tab(i).level + l_parent_tab(j).level);
3225:
3226: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
3227: P_API_VERSION => 1.0,
3228: P_GROUP_DENORM_ID => l_denorm_grp_id,
3229: P_GROUP_ID => l_child_tab(i).p_group_id ,
3230: P_PARENT_GROUP_ID => l_parent_tab(j).p_related_group_id ,

Line 3381: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (

3377: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
3378: --delete the previous hierarchy for the group
3379: for r_group_denorm IN c_group_denorm(p_group_id)
3380: loop
3381: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (
3382: P_API_VERSION => 1.0,
3383: P_GROUP_ID => r_group_denorm.group_id,
3384: P_PARENT_GROUP_ID => r_group_denorm.parent_group_id,
3385: X_RETURN_STATUS => l_return_status,

Line 3409: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (

3405: FOR I IN 1 .. l_child_tab.COUNT
3406: LOOP
3407: for r_group_denorm IN c_group_denorm(l_child_tab(i).p_group_id)
3408: loop
3409: JTF_RS_REP_MGR_DENORM_PVT.DELETE_REP_MGR (
3410: P_API_VERSION => 1.0,
3411: P_GROUP_ID => r_group_denorm.group_id,
3412: P_PARENT_GROUP_ID => r_group_denorm.parent_group_id,
3413: X_RETURN_STATUS => l_return_status,

Line 4111: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(

4107: X_DENORM_LEVEL => l_parent_tab(i).level );
4108:
4109:
4110: --call rep manager insert
4111: JTF_RS_REP_MGR_DENORM_PVT.INSERT_GRP_DENORM(
4112: P_API_VERSION => 1.0,
4113: P_GROUP_DENORM_ID => l_denorm_grp_id,
4114: P_GROUP_ID => p_group_id ,
4115: P_PARENT_GROUP_ID => l_parent_tab(i).p_related_group_id ,