APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TTY_GEO_WEBADI_INTERFACE

Line 273: delete from JTF_TTY_GEO_WEBADI_INTERFACE

269:
270: BEGIN
271:
272: -- remove existing old data for this userid
273: delete from JTF_TTY_GEO_WEBADI_INTERFACE
274: where user_id = p_userid
275: and sysdate - creation_date >2;
276:
277: select jtf_tty_geo_int_s.nextval into SEQ from dual;

Line 279: select count(*) into id from JTF_TTY_GEO_WEBADI_INTERFACE;

275: and sysdate - creation_date >2;
276:
277: select jtf_tty_geo_int_s.nextval into SEQ from dual;
278:
279: select count(*) into id from JTF_TTY_GEO_WEBADI_INTERFACE;
280: if id=0 then id:=1;
281: else select max(id)+1 into id from JTF_TTY_GEO_WEBADI_INTERFACE;
282: end if;
283:

Line 281: else select max(id)+1 into id from JTF_TTY_GEO_WEBADI_INTERFACE;

277: select jtf_tty_geo_int_s.nextval into SEQ from dual;
278:
279: select count(*) into id from JTF_TTY_GEO_WEBADI_INTERFACE;
280: if id=0 then id:=1;
281: else select max(id)+1 into id from JTF_TTY_GEO_WEBADI_INTERFACE;
282: end if;
283:
284: user_id := to_number(p_userid);
285:

Line 321: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,

317: the pc from all terr the user owners */
318:
319: FOR pc IN unsigned_terr_pc(l_rsc_id)
320: LOOP
321: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,
322: user_id, user_sequence, territory_group,
323: manager_terr_name, country, state_province,
324: city, postal_code, geo_terr_name,geo_terr_value_id,
325: created_by,creation_date, last_updated_by,

Line 342: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,

338: else
339: FOR pc IN signed_nd_terr_pc(to_number(GEO_TERR_LIST(i)))
340: LOOP
341: --insert into tmp values(GEO_TERR_LIST(i)||'value', pc.postal_code); commit;
342: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,
343: user_id, user_sequence, territory_group,
344: manager_terr_name, country, state_province,
345: city, postal_code, geo_terr_name, geo_terr_value_id,
346: created_by, creation_date, last_updated_by,