APPS.JTF_TTY_GEO_TERRGP dependencies on JTF_TTY_TERR_GROUPS

Line 118: delete from jtf_tty_terr_groups where terr_group_id = l_terr_grp_id;

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;
119:
120: delete from jtf_tty_geo_terr_rsc where geo_territory_id = l_geo_terr_id;
121:
122: delete from jtf_tty_geo_terr where geo_territory_id = l_geo_terr_id;

Line 126: select jtf_tty_terr_groups_s.nextval

122: delete from jtf_tty_geo_terr where geo_territory_id = l_geo_terr_id;
123:
124:
125: else
126: select jtf_tty_terr_groups_s.nextval
127: into l_terr_grp_id
128: from dual;
129:
130: select jtf_tty_geo_terr_s.nextval

Line 139: INSERT INTO jtf_tty_terr_groups

135:
136: BEGIN
137:
138:
139: INSERT INTO jtf_tty_terr_groups
140: ( TERR_GROUP_ID
141: , TERR_GROUP_NAME
142: , RANK
143: , ACTIVE_FROM_DATE

Line 617: delete from jtf_tty_terr_groups

613: where terr_group_id = p_terr_gp_id;
614:
615: /* finally delete the terr gp itself */
616:
617: delete from jtf_tty_terr_groups
618: where terr_group_id = p_terr_gp_id;
619:
620: /* ACHANDA : added to log the event of territory group delete for GTP to do incremental process */
621: log_event(p_terr_gp_id, 'DELETE', 'Delete Territory Group', 'TG', fnd_global.user_id);

Line 690: FROM jtf_tty_terr_groups

686: p_territory_label VARCHAR2(80);
687: BEGIN
688: SELECT jtf_tty_geo_terr_s.nextval, terr_group_name
689: INTO p_geo_territory_id, p_geo_territory_name
690: FROM jtf_tty_terr_groups
691: WHERE terr_group_id = p_terr_gp_id;
692: /*
693: fnd_message.set_name('JTF', 'JTF_TTY_TERR_LABEL');
694: p_territory_label := fnd_message.Get();