APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_ROLE_ACCESS

Line 109: delete from jtf_tty_role_access

105:
106: /* following code deletes the data first in case of an update and
107: coninue with the create statements */
108:
109: delete from jtf_tty_role_access
110: where TERR_GROUP_ROLE_ID in (select TERR_GROUP_ROLE_ID
111: from jtf_tty_terr_grp_roles
112: where terr_group_id = l_terr_grp_id);
113:

Line 461: insert into jtf_tty_role_access (

457: END;
458: --
459: BEGIN
460: --
461: insert into jtf_tty_role_access (
462: TERR_GROUP_ROLE_ACCESS_ID
463: ,TERR_GROUP_ROLE_ID
464: ,ACCESS_TYPE
465: ,OBJECT_VERSION_NUMBER

Line 471: jtf_tty_role_access_s.nextval

467: ,CREATION_DATE
468: ,LAST_UPDATED_BY
469: ,LAST_UPDATE_DATE)
470: select
471: jtf_tty_role_access_s.nextval
472: ,lp_terr_grp_role_id
473: ,ACCESS_TYPE
474: , 1
475: ,CREATED_BY

Line 607: delete from jtf_tty_role_access

603: (select terr_group_role_id from jtf_tty_terr_grp_roles
604: where terr_group_id = p_terr_gp_id);
605:
606:
607: delete from jtf_tty_role_access
608: where terr_group_role_id in
609: (select terr_group_role_id from jtf_tty_terr_grp_roles
610: where terr_group_id = p_terr_gp_id);
611: