APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_WEBADI_INTERFACE

Line 94: from jtf_tty_webadi_interface

90: FROM
91: jtf_tty_my_directs_gt mydir,
92: (
93: select terr_grp_acct_id
94: from jtf_tty_webadi_interface
95: where user_id = userid
96: ) tgaid_list
97: WHERE
98: mydir.current_user_id = userid

Line 127: from jtf_tty_webadi_interface tmp,

123: tmp.terr_grp_acct_id,
124: repmgr.parent_resource_id resource_id,
125: grpmem.group_id group_id,
126: rol.role_code role_code
127: from jtf_tty_webadi_interface tmp,
128: jtf_tty_named_acct_rsc narsc,
129: jtf_rs_rep_managers repmgr,
130: jtf_rs_role_relations rlt,
131: jtf_rs_roles_b rol,

Line 158: from jtf_tty_webadi_interface tmp,

154: tmp.terr_grp_acct_id,
155: narsc.resource_id resource_id,
156: narsc.rsc_group_id group_id,
157: narsc.rsc_role_code role_code
158: from jtf_tty_webadi_interface tmp,
159: jtf_tty_named_acct_rsc narsc,
160: jtf_tty_my_directs_gt dir
161: where narsc.terr_group_account_id = tmp.terr_grp_acct_id
162: AND dir.current_user_id = userid

Line 198: FROM jtf_tty_webadi_interface

194:
195:
196: cursor getNAFromInterface IS
197: SELECT jtf_tty_webadi_int_id, terr_grp_acct_id
198: FROM jtf_tty_webadi_interface
199: where user_id=p_userid;
200:
201:
202: cursor na_sales(userid in number, tgaid in number) IS

Line 296: delete from JTF_TTY_WEBADI_INTERFACE

292: BEGIN
293: --delete from tmp;
294: --insert into tmp values('1 start user_id=' || p_userid, to_char(sysdate,'HH:MI:SS'));commit;
295: -- remove existing old data for this userid
296: delete from JTF_TTY_WEBADI_INTERFACE
297: where user_id = to_number(p_userid);
298: -- and sysdate - creation_date >2;
299:
300: select jtf_tty_interface_s.nextval into SEQ from dual;

Line 349: ' INSERT into JTF_TTY_WEBADI_INTERFACE ' ||

345:
346: -- insert into tmp values('1.5 '||l_var1, l_var2); commit;
347:
348: l_getAlignNamedAccount :=
349: ' INSERT into JTF_TTY_WEBADI_INTERFACE ' ||
350: ' ( USER_SEQUENCE,USER_ID,TERR_GRP_ACCT_ID,JTF_TTY_WEBADI_INT_ID,NAMED_ACCOUNT,SITE_TYPE,TRADE_NAME,DUNS, '||
351: ' GU_DUNS,GU_NAME,CITY,STATE,POSTAL_CODE,TERRITORY_GROUP, ALIGNMENT_ID, ' ||
352: ' CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE ' ||
353: ' ) ' ||

Line 645: update JTF_TTY_WEBADI_INTERFACE -- /*+ INDEX(JTF_TTY_WEBADI_INTF_N2) */

641: end if; -- of p_init_flag='Y' or l_align_id is null
642:
643: --insert into tmp values('4.5 done with one salesrep', to_char(sysdate,'HH:MI:SS'));commit;
644:
645: update JTF_TTY_WEBADI_INTERFACE -- /*+ INDEX(JTF_TTY_WEBADI_INTF_N2) */
646: set RESOURCE1_NAME=RESOURCE_NAME(1),GROUP1_NAME=GROUP_NAME(1),ROLE1_NAME=ROLE_NAME(1),
647: RESOURCE2_NAME=RESOURCE_NAME(2),GROUP2_NAME=GROUP_NAME(2),ROLE2_NAME=ROLE_NAME(2),
648: RESOURCE3_NAME=RESOURCE_NAME(3),GROUP3_NAME=GROUP_NAME(3),ROLE3_NAME=ROLE_NAME(3),
649: RESOURCE4_NAME=RESOURCE_NAME(4),GROUP4_NAME=GROUP_NAME(4),ROLE4_NAME=ROLE_NAME(4),