eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_POP_AO_SUM_PKG dependencies on BIX_DM_ADVANCED_OUTBOUND_SUM

Line 67: 'BIX_DM_ADVANCED_OUTBOUND_SUM',

63: VALUES
64: (
65: BIX_DM_COLLECT_LOG_S.NEXTVAL,
66: NULL,
67: 'BIX_DM_ADVANCED_OUTBOUND_SUM',
68: 'TABLE',
69: g_program_start_date,
70: SYSDATE,
71: g_collect_start_date,

Line 109: 'Start rolling back from BIX_DM_ADVANCED_OUTBOUND_SUMtable ');

105: PROCEDURE clean_up IS
106: BEGIN
107: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||g_error_mesg);
108: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
109: 'Start rolling back from BIX_DM_ADVANCED_OUTBOUND_SUMtable ');
110:
111: /* Delete from AO summary table */
112:
113: LOOP

Line 114: DELETE bix_dm_advanced_outbound_sum

110:
111: /* Delete from AO summary table */
112:
113: LOOP
114: DELETE bix_dm_advanced_outbound_sum
115: WHERE last_update_date > g_program_start_date
116: AND rownum <= g_commit_chunk_size ;
117:
118: IF(SQL%ROWCOUNT < g_commit_chunk_size) THEN

Line 178: TYPE campaign_schedule_id IS TABLE OF bix_dm_advanced_outbound_sum.campaign_schedule_id%TYPE;

174: period_start_date,
175: period_start_time,
176: period_start_date_time;
177:
178: TYPE campaign_schedule_id IS TABLE OF bix_dm_advanced_outbound_sum.campaign_schedule_id%TYPE;
179: TYPE source_list_id IS TABLE OF bix_dm_advanced_outbound_sum.source_list_id%TYPE;
180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;
181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;

Line 179: TYPE source_list_id IS TABLE OF bix_dm_advanced_outbound_sum.source_list_id%TYPE;

175: period_start_time,
176: period_start_date_time;
177:
178: TYPE campaign_schedule_id IS TABLE OF bix_dm_advanced_outbound_sum.campaign_schedule_id%TYPE;
179: TYPE source_list_id IS TABLE OF bix_dm_advanced_outbound_sum.source_list_id%TYPE;
180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;
181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;

Line 180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;

176: period_start_date_time;
177:
178: TYPE campaign_schedule_id IS TABLE OF bix_dm_advanced_outbound_sum.campaign_schedule_id%TYPE;
179: TYPE source_list_id IS TABLE OF bix_dm_advanced_outbound_sum.source_list_id%TYPE;
180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;
181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;

Line 181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;

177:
178: TYPE campaign_schedule_id IS TABLE OF bix_dm_advanced_outbound_sum.campaign_schedule_id%TYPE;
179: TYPE source_list_id IS TABLE OF bix_dm_advanced_outbound_sum.source_list_id%TYPE;
180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;
181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;

Line 182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;

178: TYPE campaign_schedule_id IS TABLE OF bix_dm_advanced_outbound_sum.campaign_schedule_id%TYPE;
179: TYPE source_list_id IS TABLE OF bix_dm_advanced_outbound_sum.source_list_id%TYPE;
180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;
181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;

Line 183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;

179: TYPE source_list_id IS TABLE OF bix_dm_advanced_outbound_sum.source_list_id%TYPE;
180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;
181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;

Line 184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;

180: TYPE sublist_id IS TABLE OF bix_dm_advanced_outbound_sum.sublist_id%TYPE;
181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;

Line 185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;

181: TYPE period_start_date IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date%TYPE;
182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;

Line 186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;

182: TYPE period_start_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_time%TYPE;
183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;

Line 187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;

183: TYPE period_start_date_time IS TABLE OF bix_dm_advanced_outbound_sum.period_start_date_time%TYPE;
184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;

Line 188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;

184: TYPE agent_work_on IS TABLE OF bix_dm_advanced_outbound_sum.agent_work_on%TYPE;
185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;

Line 189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;

185: TYPE talk_time IS TABLE OF bix_dm_advanced_outbound_sum.talk_time%TYPE;
186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;

Line 190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;

186: TYPE wrap_time IS TABLE OF bix_dm_advanced_outbound_sum.wrap_time%TYPE;
187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;

Line 191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;

187: TYPE leads_created IS TABLE OF bix_dm_advanced_outbound_sum.leads_created%TYPE;
188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;

Line 192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;

188: TYPE leads_amount IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount%TYPE;
189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;

Line 193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;

189: TYPE leads_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.leads_amount_txn%TYPE;
190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;
197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;

Line 194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;

190: TYPE opportunities_won IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won%TYPE;
191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;
197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;
198: TYPE answering_machine IS TABLE OF bix_dm_advanced_outbound_sum.answering_machine_count%TYPE;

Line 195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;

191: TYPE opportunities_won_amount IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount%TYPE;
192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;
197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;
198: TYPE answering_machine IS TABLE OF bix_dm_advanced_outbound_sum.answering_machine_count%TYPE;
199: TYPE sit IS TABLE OF bix_dm_advanced_outbound_sum.sit_count%TYPE;

Line 196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;

192: TYPE opportunities_won_amount_txn IS TABLE OF bix_dm_advanced_outbound_sum.opportunities_won_amount_txn%TYPE;
193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;
197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;
198: TYPE answering_machine IS TABLE OF bix_dm_advanced_outbound_sum.answering_machine_count%TYPE;
199: TYPE sit IS TABLE OF bix_dm_advanced_outbound_sum.sit_count%TYPE;
200:

Line 197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;

193: TYPE dialed IS TABLE OF bix_dm_advanced_outbound_sum.dialed_count%TYPE;
194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;
197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;
198: TYPE answering_machine IS TABLE OF bix_dm_advanced_outbound_sum.answering_machine_count%TYPE;
199: TYPE sit IS TABLE OF bix_dm_advanced_outbound_sum.sit_count%TYPE;
200:
201:

Line 198: TYPE answering_machine IS TABLE OF bix_dm_advanced_outbound_sum.answering_machine_count%TYPE;

194: TYPE connected IS TABLE OF bix_dm_advanced_outbound_sum.connected_count%TYPE;
195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;
197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;
198: TYPE answering_machine IS TABLE OF bix_dm_advanced_outbound_sum.answering_machine_count%TYPE;
199: TYPE sit IS TABLE OF bix_dm_advanced_outbound_sum.sit_count%TYPE;
200:
201:
202: l_campaign_schedule_id campaign_schedule_id;

Line 199: TYPE sit IS TABLE OF bix_dm_advanced_outbound_sum.sit_count%TYPE;

195: TYPE abandoned IS TABLE OF bix_dm_advanced_outbound_sum.abandoned_count%TYPE;
196: TYPE busy IS TABLE OF bix_dm_advanced_outbound_sum.busy_count%TYPE;
197: TYPE ring_no_answer IS TABLE OF bix_dm_advanced_outbound_sum.ring_no_answer_count%TYPE;
198: TYPE answering_machine IS TABLE OF bix_dm_advanced_outbound_sum.answering_machine_count%TYPE;
199: TYPE sit IS TABLE OF bix_dm_advanced_outbound_sum.sit_count%TYPE;
200:
201:
202: l_campaign_schedule_id campaign_schedule_id;
203: l_source_list_id source_list_id;

Line 243: DELETE bix_dm_advanced_outbound_sum

239: ' BIX_POP_AO_SUM_PKG.POPULATE: '||
240: ' Start Deleting rows in BIM_DM_AO_SUM table: ' );
241: LOOP
242: --dbms_output.put_line('Start deleting................');
243: DELETE bix_dm_advanced_outbound_sum
244: WHERE PERIOD_START_DATE_TIME >= p_start_date_time
245: AND PERIOD_START_DATE_TIME <= p_end_date_time
246: AND rownum <= g_commit_chunk_size ;
247:

Line 300: INSERT INTO BIX_DM_ADVANCED_OUTBOUND_SUM

296:
297: IF( l_campaign_schedule_id.COUNT > 0) THEN
298: FORALL i IN l_campaign_schedule_id.FIRST .. l_campaign_schedule_id.LAST
299:
300: INSERT INTO BIX_DM_ADVANCED_OUTBOUND_SUM
301: (
302: ADVANCED_OUTBOUND_ID,
303: CAMPAIGN_SCHEDULE_ID,
304: SOURCE_LIST_ID,

Line 335: bix_dm_advanced_outbound_sum_s.NEXTVAL,

331: PROGRAM_ID,
332: PROGRAM_UPDATE_DATE
333: )
334: VALUES (
335: bix_dm_advanced_outbound_sum_s.NEXTVAL,
336: l_campaign_schedule_id(i),
337: l_source_list_id(i),
338: l_sublist_id(i),
339: l_period_start_date(i),