APPS.JTF_TTY_WEBADI_NADOC_PKG dependencies on JTF_TTY_WEBADI_INTERFACE

Line 178: FROM jtf_tty_webadi_interface--JTF_TTY_WEBADI_INT_GT --

174:
175:
176: CURSOR getNAFromInterface IS
177: SELECT jtf_tty_webadi_int_id, terr_grp_acct_id
178: FROM jtf_tty_webadi_interface--JTF_TTY_WEBADI_INT_GT --
179: WHERE user_id=p_userid;
180:
181:
182: BEGIN

Line 205: FROM JTF_TTY_WEBADI_INTERFACE tty

201:
202: --delete from JTF_TTY_WEBADI_INT_GT ;
203: -- remove existing old data for this userid
204: DELETE /*+ INDEX(jtf_tty_webadi_intf_n1) */
205: FROM JTF_TTY_WEBADI_INTERFACE tty
206: WHERE tty.user_id = TO_NUMBER(p_userid);
207: -- AND tty.user_sequence <> seq;
208:
209: --dbms_output.put_line('CLEANUP ROW COUNT = '|| TO_CHAR(SQL%ROWCOUNT) );

Line 213: -- prevent locking of JTF_TTY_WEBADI_INTERFACE

209: --dbms_output.put_line('CLEANUP ROW COUNT = '|| TO_CHAR(SQL%ROWCOUNT) );
210:
211: -- JDOCHERT: 11/01/03
212: -- Very important commit as it will
213: -- prevent locking of JTF_TTY_WEBADI_INTERFACE
214: -- table should the download fail
215: --
216: COMMIT;
217:

Line 225: --select count(*) into id from JTF_TTY_WEBADI_INTERFACE;

221:
222: END;
223:
224: -- and sysdate - creation_date >2;
225: --select count(*) into id from JTF_TTY_WEBADI_INTERFACE;
226: --if id=0 then id:=1;
227: --else select max(id)+1 into id from JTF_TTY_WEBADI_INTERFACE;
228: --end if;
229:

Line 227: --else select max(id)+1 into id from JTF_TTY_WEBADI_INTERFACE;

223:
224: -- and sysdate - creation_date >2;
225: --select count(*) into id from JTF_TTY_WEBADI_INTERFACE;
226: --if id=0 then id:=1;
227: --else select max(id)+1 into id from JTF_TTY_WEBADI_INTERFACE;
228: --end if;
229:
230: BEGIN
231:

Line 261: 'INSERT into JTF_TTY_WEBADI_INTERFACE ' || --JTF_TTY_WEBADI_INT_GT

257: IF p_callfrom = 'S' /* simple search */ THEN
258:
259: --DBMS_OUTPUT.PUT_LINE ('p_userid: '||P_USERID ||', SEQ: ' ||SEQ||', CURR_DATE: '||CURR_DATE);
260: l_na_query :=
261: 'INSERT into JTF_TTY_WEBADI_INTERFACE ' || --JTF_TTY_WEBADI_INT_GT
262: ' ( USER_SEQUENCE,USER_ID,TERR_GRP_ACCT_ID,JTF_TTY_WEBADI_INT_ID,NAMED_ACCOUNT,SITE_TYPE,TRADE_NAME,DUNS, '||
263: ' GU_DUNS,GU_NAME,CITY,STATE,POSTAL_CODE,TERRITORY_GROUP, ' ||
264: ' CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE ' ||
265: ' ) ' ||

Line 475: ' INSERT into JTF_TTY_WEBADI_INTERFACE ' || --JTF_TTY_WEBADI_INTERFACE '||

471: ' L_CURR_DATE DATE := :CURR_DATE; '||
472:
473: ' BEGIN '||
474:
475: ' INSERT into JTF_TTY_WEBADI_INTERFACE ' || --JTF_TTY_WEBADI_INTERFACE '||
476: ' ( USER_SEQUENCE,USER_ID,TERR_GRP_ACCT_ID,JTF_TTY_WEBADI_INT_ID,NAMED_ACCOUNT,SITE_TYPE,TRADE_NAME,DUNS, '||
477: ' GU_DUNS,GU_NAME,CITY,STATE,POSTAL_CODE,TERRITORY_GROUP, ' ||
478: ' CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE ' ||
479: ' ) ' ||

Line 984: || ' FROM jtf_tty_webadi_interface jtw ' --JTF_TTY_WEBADI_INT_GT

980: || 'SELECT rol.role_code role_code, COUNT(rol.role_code) num '
981: || 'FROM '
982: || ' ( SELECT /*+ DYNAMIC_SAMPLING(jtw,5) */ '
983: || ' jtw.jtf_tty_webadi_int_id '
984: || ' FROM jtf_tty_webadi_interface jtw ' --JTF_TTY_WEBADI_INT_GT
985: || ' WHERE jtw.user_id = ' ||p_userid
986: || ' ) sub, '
987: || ' jtf_rs_roles_vl rol, '
988: || ' jtf_tty_named_acct_rsc narsc, '

Line 1062: UPDATE JTF_TTY_WEBADI_INTERFACE -- /*+ INDEX JTF_TTY_WEBADI_INTF_N2 */

1058: END LOOP; -- of slotting
1059: END LOOP; -- of SALES
1060:
1061:
1062: UPDATE JTF_TTY_WEBADI_INTERFACE -- /*+ INDEX JTF_TTY_WEBADI_INTF_N2 */
1063: SET RESOURCE1_NAME=RESOURCE_NAME(1),GROUP1_NAME=GROUP_NAME(1),ROLE1_NAME=ROLE_NAME(1),
1064: RESOURCE2_NAME=RESOURCE_NAME(2),GROUP2_NAME=GROUP_NAME(2),ROLE2_NAME=ROLE_NAME(2),
1065: RESOURCE3_NAME=RESOURCE_NAME(3),GROUP3_NAME=GROUP_NAME(3),ROLE3_NAME=ROLE_NAME(3),
1066: RESOURCE4_NAME=RESOURCE_NAME(4),GROUP4_NAME=GROUP_NAME(4),ROLE4_NAME=ROLE_NAME(4),