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_EMAILS_LOAD_PKG dependencies on FII_TIME_DAY

Line 289: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;

285: TYPE two_done_rsln_tab IS TABLE OF bix_email_details_f.two_rsln_in_period%TYPE;
286: TYPE three_done_rsln_tab IS TABLE OF bix_email_details_f.three_rsln_in_period%TYPE;
287: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;
288: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
289: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
290: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
291: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
292: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
293: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;

Line 290: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;

286: TYPE three_done_rsln_tab IS TABLE OF bix_email_details_f.three_rsln_in_period%TYPE;
287: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;
288: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
289: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
290: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
291: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
292: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
293: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
294:

Line 291: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;

287: TYPE four_done_rsln_tab IS TABLE OF bix_email_details_f.four_rsln_in_period%TYPE;
288: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
289: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
290: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
291: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
292: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
293: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
294:
295: l_root_interaction_id root_interaction_id_tab;

Line 292: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;

288: TYPE intr_thread_tab IS TABLE OF bix_email_details_f.interaction_threads_in_period%TYPE;
289: TYPE week_id_tab IS TABLE OF fii_time_day.week_id%TYPE;
290: TYPE ent_period_id_tab IS TABLE OF fii_time_day.ent_period_id%TYPE;
291: TYPE ent_qtr_id_tab IS TABLE OF fii_time_day.ent_qtr_id%TYPE;
292: TYPE ent_year_id_tab IS TABLE OF fii_time_day.ent_year_id%TYPE;
293: TYPE curr_depth_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
294:
295: l_root_interaction_id root_interaction_id_tab;
296: l_agent_id agent_id_tab;

Line 2909: fii_time_day ftd

2905: ftd.ent_year_id
2906: order by to_date(to_char(bed.period_start_date, 'dd/mm/yyyy ') ||
2907: lpad(bed.period_start_time, 5, '0'), 'dd/mm/yyyy hh24:mi') desc) year_acc_emails_week_plus
2908: FROM bix_email_details_f bed,
2909: fii_time_day ftd
2910: WHERE bed.time_id = ftd.report_date_julian
2911: --1/2hr changed period_Type_id to 1 from -1
2912: --AND bed.period_type_id = -1) inv2
2913: AND bed.period_type_id = 1) inv2

Line 2967: FROM fii_time_day

2963: p_has_missing_date := FALSE;
2964:
2965: SELECT count(*)
2966: INTO l_count1
2967: FROM fii_time_day
2968: WHERE report_date between trunc(p_start_date) and trunc(p_end_date);
2969:
2970: SELECT (trunc(p_end_date) - trunc(p_start_date)) + 1
2971: INTO l_count2