APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_TERR_GRP_ROLES

Line 111: from jtf_tty_terr_grp_roles

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:
114: delete from jtf_tty_terr_grp_roles where terr_group_id = l_terr_grp_id;
115:

Line 114: delete from jtf_tty_terr_grp_roles where terr_group_id = l_terr_grp_id;

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:
114: delete from jtf_tty_terr_grp_roles where terr_group_id = l_terr_grp_id;
115:
116: delete from jtf_tty_geo_grp_values where terr_group_id = l_terr_grp_id;
117:
118: delete from jtf_tty_terr_groups where terr_group_id = l_terr_grp_id;

Line 424: select jtf_tty_terr_grp_roles_s.nextval

420: for get_terr_grp_roles in csr_get_terr_grp_roles (p_terr_id)
421: --
422: loop
423: --
424: select jtf_tty_terr_grp_roles_s.nextval
425: into lp_terr_grp_role_id
426: from dual;
427: --
428: BEGIN

Line 430: insert into jtf_tty_terr_grp_roles (

426: from dual;
427: --
428: BEGIN
429:
430: insert into jtf_tty_terr_grp_roles (
431: TERR_GROUP_ROLE_ID
432: ,TERR_GROUP_ID
433: ,ROLE_CODE
434: ,OBJECT_VERSION_NUMBER

Line 605: (select terr_group_role_id from jtf_tty_terr_grp_roles

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

Line 611: (select terr_group_role_id from jtf_tty_terr_grp_roles

607:
608:
609: delete from jtf_tty_role_access
610: where terr_group_role_id in
611: (select terr_group_role_id from jtf_tty_terr_grp_roles
612: where terr_group_id = p_terr_gp_id);
613:
614: delete from jtf_tty_terr_grp_roles
615: where terr_group_id = p_terr_gp_id;

Line 614: delete from jtf_tty_terr_grp_roles

610: where terr_group_role_id in
611: (select terr_group_role_id from jtf_tty_terr_grp_roles
612: where terr_group_id = p_terr_gp_id);
613:
614: delete from jtf_tty_terr_grp_roles
615: where terr_group_id = p_terr_gp_id;
616:
617: /* finally delete the terr gp itself */
618: