DBA Data[Home] [Help]

APPS.BIX_POP_AO_SUM_PKG dependencies on BIX_DM_ADVANCED_OUTBOUND_SUM_S

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 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 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),