APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_ROLE_ACCESS

Line 427: DELETE FROM jtf_tty_role_access

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
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:

Line 2221: DELETE FROM jtf_tty_role_access

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 (
2223: SELECT terr_group_role_id
2224: FROM jtf_tty_terr_grp_roles
2225: WHERE terr_group_id = p_terr_gp_id);

Line 2621: INSERT INTO JTF_TTY_ROLE_ACCESS(

2617:
2618: BEGIN
2619:
2620: /* create role accesses for the role */
2621: INSERT INTO JTF_TTY_ROLE_ACCESS(
2622: TERR_GROUP_ROLE_ACCESS_ID,
2623: OBJECT_VERSION_NUMBER,
2624: TERR_GROUP_ROLE_ID ,
2625: ACCESS_TYPE ,

Line 2633: JTF_TTY_ROLE_ACCESS_S.NEXTVAL,

2629: LAST_UPDATED_BY ,
2630: LAST_UPDATE_DATE ,
2631: LAST_UPDATE_LOGIN)
2632: VALUES(
2633: JTF_TTY_ROLE_ACCESS_S.NEXTVAL,
2634: 1,
2635: p_terr_gp_role_id,
2636: p_access_type,
2637: p_access_code,

Line 2741: INSERT INTO JTF_TTY_ROLE_ACCESS(

2737: SYSDATE,
2738: p_user_id);
2739:
2740: /* create role accesses for the role */
2741: INSERT INTO JTF_TTY_ROLE_ACCESS(
2742: TERR_GROUP_ROLE_ACCESS_ID,
2743: OBJECT_VERSION_NUMBER,
2744: TERR_GROUP_ROLE_ID ,
2745: ACCESS_TYPE ,

Line 2752: JTF_TTY_ROLE_ACCESS_S.NEXTVAL,

2748: LAST_UPDATED_BY ,
2749: LAST_UPDATE_DATE ,
2750: LAST_UPDATE_LOGIN)
2751: VALUES(
2752: JTF_TTY_ROLE_ACCESS_S.NEXTVAL,
2753: 1,
2754: p_terr_gp_role_id,
2755: p_access_type,
2756: p_user_id,