APPS.JTF_TTY_POP_TERR_ADMIN_BIN_PVT dependencies on JTF_TTY_ADMIN_BIN_SUMM

Line 48: Update jtf_tty_admin_bin_summ jtabs

44: BEGIN
45: L_SYSDATE := SYSDATE;
46: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('In populate_catch_all_bin_info Procedure ');
47:
48: Update jtf_tty_admin_bin_summ jtabs
49: set LEADS = 0
50: , OPPORTUNITIES = 0
51: , ACCOUNTS = 0
52: , CATCH_ALL_UPDATE_DATE = L_SYSDATE

Line 97: Update jtf_tty_admin_bin_summ jtabs

93: AND LEAD_ID IS NOT NULL
94: AND SALES_LEAD_ID IS NULL;
95:
96:
97: Update jtf_tty_admin_bin_summ jtabs
98: set LEADS = L_LEADS
99: , OPPORTUNITIES = L_OPPORTUNITIES
100: , ACCOUNTS = L_ACCOUNTS
101: where terr_group_id = l_list.terr_group_id;

Line 135: Update jtf_tty_admin_bin_summ jtabs

131: L_SYSDATE := SYSDATE;
132:
133: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('In populate_kpi_bin_info Procedure ');
134:
135: Update jtf_tty_admin_bin_summ jtabs
136: set TOTAL_NAMED_ACCOUNT = '0.0%'
137: , MAPPED_NAMED_ACC_PER = '0.0%'
138: , ASSIGNED_NAMED_ACC_PER = '0.0%'
139: , KPI_UPDATE_DATE = L_SYSDATE

Line 144: Update jtf_tty_admin_bin_summ jtabs

140: , LAST_UPDATED_BY = L_USER_ID
141: , LAST_UPDATE_DATE = L_SYSDATE
142: ;
143:
144: Update jtf_tty_admin_bin_summ jtabs
145: set (TOTAL_NAMED_ACCOUNT
146: , MAPPED_NAMED_ACC_PER
147: , ASSIGNED_NAMED_ACC_PER
148: )

Line 219: delete from jtf_tty_admin_bin_summ

215: from jtf_tty_named_acct_rsc narsc
216: where assigned_flag = 'Y');
217:
218:
219: delete from jtf_tty_admin_bin_summ
220: where TERR_GROUP_ID not in (
221: select TERR_GROUP_ID from jtf_tty_terr_groups
222: Where TRUNC(active_from_date) <= TRUNC(SYSDATE)
223: AND TRUNC(NVL(active_to_date, SYSDATE)) >= TRUNC(SYSDATE)

Line 226: update jtf_tty_admin_bin_summ jtabs

222: Where TRUNC(active_from_date) <= TRUNC(SYSDATE)
223: AND TRUNC(NVL(active_to_date, SYSDATE)) >= TRUNC(SYSDATE)
224: );
225:
226: update jtf_tty_admin_bin_summ jtabs
227: set jtabs.TERR_GROUP_NAME = (select jtg.TERR_GROUP_NAME
228: from jtf_tty_terr_groups jtg
229: where jtg.TERR_GROUP_ID = jtabs.TERR_GROUP_ID);
230:

Line 232: insert into jtf_tty_admin_bin_summ jtabs

228: from jtf_tty_terr_groups jtg
229: where jtg.TERR_GROUP_ID = jtabs.TERR_GROUP_ID);
230:
231:
232: insert into jtf_tty_admin_bin_summ jtabs
233: ( ADMIN_BIN_TERR_GRP_ID
234: , OBJECT_VERSION_NUMBER
235: , TERR_GROUP_ID
236: , TERR_GROUP_NAME

Line 252: from jtf_tty_admin_bin_summ)

248: , L_SYSDATE
249: from jtf_tty_terr_groups
250: where TERR_GROUP_ID not in
251: (select TERR_GROUP_ID
252: from jtf_tty_admin_bin_summ)
253: AND self_service_type = 'NAMED_ACCOUNT'
254: AND TRUNC(active_from_date) <= TRUNC(SYSDATE)
255: AND TRUNC(NVL(active_to_date, SYSDATE)) >= TRUNC(SYSDATE) ;
256: