APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TTY_GEO_TERR_VALUES

Line 89: jtf_tty_geo_terr_values terrv,

85: terrv.geo_terr_value_id tv_id
86: from jtf_tty_geographies g,
87: jtf_tty_geo_terr terr,
88: jtf_tty_geo_terr pterr,
89: jtf_tty_geo_terr_values terrv,
90: jtf_tty_terr_groups tg
91: where terrv.geo_territory_id = terr_id
92: and terrv.geo_territory_id = terr.geo_territory_id
93: and terr.parent_geo_terr_id = pterr.geo_territory_id(+)

Line 248: jtf_tty_geo_terr_values tv

244: from jtf_tty_terr_groups tg,
245: jtf_tty_geo_terr terr,
246: jtf_tty_geo_terr_rsc rsc,
247: jtf_tty_geographies g,
248: jtf_tty_geo_terr_values tv
249: where
250: rsc.resource_id = l_rsc_id
251: and rsc.geo_territory_id = terr.geo_territory_id
252: and terr.terr_group_id = tg.terr_group_id

Line 263: jtf_tty_geo_terr_values tv

259: where geo_id not in -- the terr the user owners
260: (
261: select tv.geo_id geo_id
262: from jtf_tty_geo_terr terr,
263: jtf_tty_geo_terr_values tv
264: where
265: terr.owner_resource_id = l_rsc_id
266: and tv.geo_territory_id = terr.geo_territory_id
267: );

Line 551: jtf_tty_geo_terr_values terrv,

547: --insert into tmp values(l_user_id,p_terrgroup); commit;
548: -- check if a regular terr the user working on has the postal code.
549: select terr.geo_territory_id into terr_id
550: from jtf_tty_geo_terr terr,
551: jtf_tty_geo_terr_values terrv,
552: jtf_tty_geo_terr_rsc rsc,
553: jtf_tty_geographies geog
554: where terr.geo_territory_id = terrv.geo_territory_id
555: and terrv.geo_id = geog.geo_id

Line 628: jtf_tty_geo_terr_values terrv,

624: -- no need check for unsigned because it wont exist?
625:
626: select count(geog.postal_code) into found --geog.postal_code, terr.geo_terr_name
627: from jtf_tty_geo_terr terr,
628: jtf_tty_geo_terr_values terrv,
629: jtf_tty_geographies geog
630: where terr.owner_resource_id = rsc_id
631: and terr.geo_territory_id = terrv.geo_territory_id
632: and terrv.geo_id = geog.geo_id

Line 640: /* delete from jtf_tty_geo_terr_values

636: if found=0 then
637: -- the p_geo_terr_value_id is from the old assignment but pc/terr_name is new
638: -- remove the old assignment, only happens in no-default terr
639: -- p_geo_terr_value_id can be null
640: /* delete from jtf_tty_geo_terr_values
641: where geo_terr_value_id = p_geo_terr_value_id;
642: */
643: BEGIN
644: /*remove recursively*/

Line 649: from jtf_tty_geo_terr_values

645: l_geo_id :=0;
646: l_terr_id :=0;
647: select geo_id,geo_territory_id
648: into l_geo_id,l_terr_id
649: from jtf_tty_geo_terr_values
650: where geo_terr_value_id = p_geo_terr_value_id;
651: exception
652: when no_data_found then
653: null;

Line 658: delete from jtf_tty_geo_terr_values gtv

654: when others then
655: null;
656: END;
657:
658: delete from jtf_tty_geo_terr_values gtv
659: where geo_id = l_geo_id
660: and geo_territory_id in (
661: select geo_territory_id
662: from jtf_tty_geo_terr

Line 672: select jtf_tty_geo_terr_values_s.nextval into n from dual;

668: --insert into tmp values('enter',p_geo_terr_name); commit;
669: -- n: geo_terr_value_id
670: if trim(p_geo_terr_value_id) is null then
671: -- new geo_terr_value_id
672: select jtf_tty_geo_terr_values_s.nextval into n from dual;
673: else n:=trim(p_geo_terr_value_id);
674: end if;
675:
676:

Line 711: insert into jtf_tty_geo_terr_values (geo_terr_value_id,object_version_number,

707: return;
708: end;
709:
710:
711: insert into jtf_tty_geo_terr_values (geo_terr_value_id,object_version_number,
712: geo_territory_id,geo_id, created_by,
713: creation_date,last_updated_by,
714: last_update_date,last_update_login)
715: values(n,1,terr_id, m, rsc_id, sysdate, rsc_id, sysdate, rsc_id);