APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_TERR_GRP_ROLES

Line 423: (SELECT terr_group_role_id FROM jtf_tty_terr_grp_roles

419: WHERE terr_group_id = p_terr_gp_id;
420:
421: DELETE FROM jtf_tty_role_prod_int
422: WHERE terr_group_role_id IN
423: (SELECT terr_group_role_id FROM jtf_tty_terr_grp_roles
424: WHERE terr_group_id = p_terr_gp_id);
425:
426:
427: DELETE FROM jtf_tty_role_access

Line 429: (SELECT terr_group_role_id FROM jtf_tty_terr_grp_roles

425:
426:
427: DELETE FROM jtf_tty_role_access
428: WHERE terr_group_role_id IN
429: (SELECT terr_group_role_id FROM jtf_tty_terr_grp_roles
430: WHERE terr_group_id = p_terr_gp_id);
431:
432: DELETE FROM jtf_tty_terr_grp_roles
433: WHERE terr_group_id = p_terr_gp_id;

Line 432: DELETE FROM jtf_tty_terr_grp_roles

428: WHERE terr_group_role_id IN
429: (SELECT terr_group_role_id FROM jtf_tty_terr_grp_roles
430: WHERE terr_group_id = p_terr_gp_id);
431:
432: DELETE FROM jtf_tty_terr_grp_roles
433: WHERE terr_group_id = p_terr_gp_id;
434:
435: /* finally delete the terr gp itself */
436:

Line 2218: FROM jtf_tty_terr_grp_roles

2214: /* delete all the roles, first the product interests, access and finally the roles */
2215: DELETE FROM jtf_tty_role_prod_int
2216: WHERE terr_group_role_id IN (
2217: SELECT terr_group_role_id
2218: FROM jtf_tty_terr_grp_roles
2219: WHERE terr_group_id = p_terr_gp_id);
2220:
2221: DELETE FROM jtf_tty_role_access
2222: WHERE terr_group_role_id IN (

Line 2224: FROM jtf_tty_terr_grp_roles

2220:
2221: DELETE FROM jtf_tty_role_access
2222: WHERE terr_group_role_id IN (
2223: SELECT terr_group_role_id
2224: FROM jtf_tty_terr_grp_roles
2225: WHERE terr_group_id = p_terr_gp_id);
2226:
2227: DELETE FROM jtf_tty_terr_grp_roles
2228: WHERE terr_group_id = p_terr_gp_id;

Line 2227: DELETE FROM jtf_tty_terr_grp_roles

2223: SELECT terr_group_role_id
2224: FROM jtf_tty_terr_grp_roles
2225: WHERE terr_group_id = p_terr_gp_id);
2226:
2227: DELETE FROM jtf_tty_terr_grp_roles
2228: WHERE terr_group_id = p_terr_gp_id;
2229:
2230: COMMIT;
2231: END delete_terrgp_owners_roles;

Line 2367: INSERT INTO JTF_TTY_TERR_GRP_ROLES(

2363: AS
2364: BEGIN
2365:
2366: /* create a role */
2367: INSERT INTO JTF_TTY_TERR_GRP_ROLES(
2368: TERR_GROUP_ROLE_ID,
2369: OBJECT_VERSION_NUMBER,
2370: TERR_GROUP_ID,
2371: ROLE_CODE,

Line 2719: INSERT INTO JTF_TTY_TERR_GRP_ROLES(

2715: BEGIN
2716: /* create a role, assign accesses to role and assign prod interests to role */
2717:
2718: /* create a role */
2719: INSERT INTO JTF_TTY_TERR_GRP_ROLES(
2720: TERR_GROUP_ROLE_ID,
2721: OBJECT_VERSION_NUMBER,
2722: TERR_GROUP_ID,
2723: ROLE_CODE,