APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_REP_MANAGERS

Line 1738: delete jtf_rs_rep_managers

1734: FOR k IN 1 .. l_child_rol_rel_tab.COUNT
1735: LOOP
1736: --delete rep mgr
1737: begin
1738: delete jtf_rs_rep_managers
1739: where par_role_relate_id = l_par_rol_rel_tab(l).role_relate_id
1740: and child_role_relate_id = l_child_rol_rel_tab(k).role_relate_id;
1741:
1742: exception

Line 2398: --call to DELETt records in jtf_rs_rep_managers

2394: --delete the previous hierarchy for the group
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,

Line 2426: --call to DELETE records in jtf_rs_rep_managers

2422: for r_child_denorm IN c_child_denorm(l_child_tab(i).p_group_id,
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,

Line 3726: delete jtf_rs_rep_managers

3722: FOR k IN 1 .. l_child_rol_rel_tab.COUNT
3723: LOOP
3724: --delete rep mgr
3725: begin
3726: delete jtf_rs_rep_managers
3727: where par_role_relate_id = l_par_rol_rel_tab(l).role_relate_id
3728: and child_role_relate_id = l_child_rol_rel_tab(k).role_relate_id;
3729:
3730: exception