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 256: jtf_tty_geo_terr_values tv

252: from jtf_tty_terr_groups tg,
253: jtf_tty_geo_terr terr,
254: jtf_tty_geo_terr_rsc rsc,
255: jtf_tty_geographies g,
256: jtf_tty_geo_terr_values tv
257: where
258: rsc.resource_id = l_rsc_id
259: and rsc.geo_territory_id = terr.geo_territory_id
260: and terr.terr_group_id = tg.terr_group_id

Line 271: jtf_tty_geo_terr_values tv

267: where geo_id not in -- the terr the user owners
268: (
269: select tv.geo_id geo_id
270: from jtf_tty_geo_terr terr,
271: jtf_tty_geo_terr_values tv
272: where
273: terr.owner_resource_id = l_rsc_id
274: and tv.geo_territory_id = terr.geo_territory_id
275: );

Line 571: jtf_tty_geo_terr_values terrv,

567: --insert into tmp values(l_user_id,p_terrgroup); commit;
568: -- check if a regular terr the user working on has the postal code.
569: select terr.geo_territory_id into terr_id
570: from jtf_tty_geo_terr terr,
571: jtf_tty_geo_terr_values terrv,
572: jtf_tty_geo_terr_rsc rsc,
573: jtf_tty_geographies geog
574: where terr.geo_territory_id = terrv.geo_territory_id
575: and terrv.geo_id = geog.geo_id

Line 648: jtf_tty_geo_terr_values terrv,

644: -- no need check for unsigned because it wont exist?
645:
646: select count(geog.postal_code) into found --geog.postal_code, terr.geo_terr_name
647: from jtf_tty_geo_terr terr,
648: jtf_tty_geo_terr_values terrv,
649: jtf_tty_geographies geog
650: where terr.owner_resource_id = rsc_id
651: and terr.geo_territory_id = terrv.geo_territory_id
652: and terrv.geo_id = geog.geo_id

Line 660: /* delete from jtf_tty_geo_terr_values

656: if found=0 then
657: -- the p_geo_terr_value_id is from the old assignment but pc/terr_name is new
658: -- remove the old assignment, only happens in no-default terr
659: -- p_geo_terr_value_id can be null
660: /* delete from jtf_tty_geo_terr_values
661: where geo_terr_value_id = p_geo_terr_value_id;
662: */
663: BEGIN
664: /*remove recursively*/

Line 669: from jtf_tty_geo_terr_values

665: l_geo_id :=0;
666: l_terr_id :=0;
667: select geo_id,geo_territory_id
668: into l_geo_id,l_terr_id
669: from jtf_tty_geo_terr_values
670: where geo_terr_value_id = p_geo_terr_value_id;
671: exception
672: when no_data_found then
673: null;

Line 678: delete from jtf_tty_geo_terr_values gtv

674: when others then
675: null;
676: END;
677:
678: delete from jtf_tty_geo_terr_values gtv
679: where geo_id = l_geo_id
680: and geo_territory_id in (
681: select geo_territory_id
682: from jtf_tty_geo_terr

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

688: --insert into tmp values('enter',p_geo_terr_name); commit;
689: -- n: geo_terr_value_id
690: if trim(p_geo_terr_value_id) is null then
691: -- new geo_terr_value_id
692: select jtf_tty_geo_terr_values_s.nextval into n from dual;
693: else n:=trim(p_geo_terr_value_id);
694: end if;
695:
696:

Line 731: insert into jtf_tty_geo_terr_values (geo_terr_value_id,object_version_number,

727: return;
728: end;
729:
730:
731: insert into jtf_tty_geo_terr_values (geo_terr_value_id,object_version_number,
732: geo_territory_id,geo_id, created_by,
733: creation_date,last_updated_by,
734: last_update_date,last_update_login)
735: values(n,1,terr_id, m, rsc_id, sysdate, rsc_id, sysdate, rsc_id);