APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TTY_GEO_WEBADI_INTERFACE

Line 281: delete from JTF_TTY_GEO_WEBADI_INTERFACE

277:
278: BEGIN
279:
280: -- remove existing old data for this userid
281: delete from JTF_TTY_GEO_WEBADI_INTERFACE
282: where user_id = p_userid
283: and sysdate - creation_date >2;
284:
285: select jtf_tty_geo_int_s.nextval into SEQ from dual;

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

283: and sysdate - creation_date >2;
284:
285: select jtf_tty_geo_int_s.nextval into SEQ from dual;
286:
287: select count(*) into id from JTF_TTY_GEO_WEBADI_INTERFACE;
288: if id=0 then id:=1;
289: else select max(id)+1 into id from JTF_TTY_GEO_WEBADI_INTERFACE;
290: end if;
291:

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

285: select jtf_tty_geo_int_s.nextval into SEQ from dual;
286:
287: select count(*) into id from JTF_TTY_GEO_WEBADI_INTERFACE;
288: if id=0 then id:=1;
289: else select max(id)+1 into id from JTF_TTY_GEO_WEBADI_INTERFACE;
290: end if;
291:
292: user_id := to_number(p_userid);
293:

Line 329: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,

325: the pc from all terr the user owners */
326:
327: FOR pc IN unsigned_terr_pc(l_rsc_id)
328: LOOP
329: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,
330: user_id, user_sequence, territory_group,
331: manager_terr_name, country, state_province,
332: city, postal_code, geo_terr_name,geo_terr_value_id,
333: created_by,creation_date, last_updated_by,

Line 350: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,

346: else
347: FOR pc IN signed_nd_terr_pc(to_number(GEO_TERR_LIST(i)))
348: LOOP
349: --insert into tmp values(GEO_TERR_LIST(i)||'value', pc.postal_code); commit;
350: INSERT INTO JTF_TTY_GEO_WEBADI_INTERFACE(jtf_tty_webadi_int_id, object_version_number,
351: user_id, user_sequence, territory_group,
352: manager_terr_name, country, state_province,
353: city, postal_code, geo_terr_name, geo_terr_value_id,
354: created_by, creation_date, last_updated_by,