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_SESSION_LOAD_PKG dependencies on IEU_SH_SESSIONS

Line 23: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;

19:
20: G_OLTP_CLEANUP_ISSUE EXCEPTION;
21: G_TIME_DIM_MISSING EXCEPTION;
22:
23: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
24: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
25: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
26: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
27: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;

Line 25: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;

21: G_TIME_DIM_MISSING EXCEPTION;
22:
23: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
24: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
25: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
26: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
27: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
28: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
29: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;

Line 26: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;

22:
23: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
24: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
25: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
26: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
27: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
28: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
29: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;
30: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_id%TYPE;

Line 27: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;

23: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
24: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
25: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
26: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
27: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
28: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
29: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;
30: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_id%TYPE;
31: TYPE g_campaign_id_tab IS TABLE OF ams_campaign_schedules_b.campaign_id%TYPE;

Line 29: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;

25: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
26: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
27: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
28: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
29: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;
30: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_id%TYPE;
31: TYPE g_campaign_id_tab IS TABLE OF ams_campaign_schedules_b.campaign_id%TYPE;
32:
33: PROCEDURE Write_Log (p_msg IN VARCHAR2) IS

Line 385: ieu_sh_sessions iss

381: schedule_id
382: ,decode(isa2.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
383: campaign_id
384: FROM
385: ieu_sh_sessions iss
386: ,ieu_sh_activities isa1
387: ,ieu_sh_activities isa2
388: ,jtf_rs_resource_extns res
389: ,ams_campaign_schedules_b csh

Line 640: ieu_sh_sessions iss

636: schedule_id
637: ,decode(isa.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
638: campaign_id
639: FROM
640: ieu_sh_sessions iss
641: ,ieu_sh_activities isa
642: ,jtf_rs_resource_extns res
643: ,ams_campaign_schedules_b csh
644: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess

Line 644: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess

640: ieu_sh_sessions iss
641: ,ieu_sh_activities isa
642: ,jtf_rs_resource_extns res
643: ,ams_campaign_schedules_b csh
644: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess
645: where activity_type_code='MEDIA'
646: and isamedsess.session_id=isamed.session_id
647: and isamedsess.application_id=696
648: group by parent_cycle_id) isamed

Line 736: TYPE session_id_tab is TABLE OF ieu_sh_sessions.session_id%TYPE;

732: p_server_group_id in g_server_group_id_tab,
733: p_application_id in g_application_id_tab)
734: IS
735: TYPE login_time_tab is TABLE OF bix_agent_session_f.login_time%TYPE;
736: TYPE session_id_tab is TABLE OF ieu_sh_sessions.session_id%TYPE;
737: TYPE collect_date_tab is TABLE OF ieu_sh_sessions.end_date_time%TYPE;
738:
739: l_agent_id g_resource_id_tab;
740: l_period_start_date g_begin_date_time_tab;

Line 737: TYPE collect_date_tab is TABLE OF ieu_sh_sessions.end_date_time%TYPE;

733: p_application_id in g_application_id_tab)
734: IS
735: TYPE login_time_tab is TABLE OF bix_agent_session_f.login_time%TYPE;
736: TYPE session_id_tab is TABLE OF ieu_sh_sessions.session_id%TYPE;
737: TYPE collect_date_tab is TABLE OF ieu_sh_sessions.end_date_time%TYPE;
738:
739: l_agent_id g_resource_id_tab;
740: l_period_start_date g_begin_date_time_tab;
741: l_login_time login_time_tab;

Line 928: from ieu_sh_sessions sess1

924: over (partition by resource_id order by begin_date_time) maxval
925: from (
926: select /*+ parallel(sess1) */ 1 type, resource_id, begin_date_time, end_date_time,
927: session_id, application_id
928: from ieu_sh_sessions sess1
929: WHERE last_update_date > g_collect_start_date
930: AND last_update_date <= g_collect_end_date
931: union all
932: select /*+ parallel(msegs) */ 2 type, resource_id,

Line 980: FROM ieu_sh_sessions sess1

976: ,(
977: SELECT + full(sess1) session_id, resource_id, application_id, begin_date_time, end_date_time,
978: lead(begin_date_time, 1)
979: over (partition by resource_id order by begin_date_time) next_sess_begin_date_time
980: FROM ieu_sh_sessions sess1
981: WHERE last_update_date > g_collect_start_date
982: AND last_update_date <= g_collect_end_date
983: ) inv1
984: WHERE inv1.resource_id = res.resource_id