APPS.JTF_TTY_OVERLAP_WEBADI_PKG dependencies on JTF_TTY_WEBADI_INTERFACES

Line 107: delete from JTF_TTY_WEBADI_INTERFACES

103: J NUMBER;
104: BEGIN
105:
106: -- remove existing old data for this userid
107: delete from JTF_TTY_WEBADI_INTERFACES
108: where user_id = to_number(p_userid)
109: and sysdate - creation_date >2;
110:
111: select jtf_tty_interface_s.nextval into l_seq from dual;

Line 235: insert into JTF_TTY_WEBADI_INTERFACES

231:
232: --insert record into table, if there the named accountbelongs to more than one territory group
233: if J>1 then
234:
235: insert into JTF_TTY_WEBADI_INTERFACES
236: ( user_sequence
237: ,user_id
238: ,attribute1
239: ,attribute2

Line 527: insert into JTF_TTY_WEBADI_INTERFACES

523:
524: --insert record into table, if there the named accountbelongs to more than one territory group
525: if J>1 then
526:
527: insert into JTF_TTY_WEBADI_INTERFACES
528: ( user_sequence
529: ,user_id
530: ,attribute1
531: ,attribute2

Line 780: insert into JTF_TTY_WEBADI_INTERFACES

776:
777: --insert record into table, if there the named accountbelongs to more than one territory group
778: if J>1 then
779:
780: insert into JTF_TTY_WEBADI_INTERFACES
781: ( user_sequence
782: ,user_id
783: ,attribute1
784: ,attribute2