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

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

27:
28: TYPE WorkerList is table of NUMBER index by binary_integer;
29: g_worker WorkerList;
30:
31: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
32: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
33: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
34: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
35: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;

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

29: g_worker WorkerList;
30:
31: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
32: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
33: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
34: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
35: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
36: TYPE g_last_collect_date_tab IS TABLE OF bix_sessions.last_collect_date%TYPE;
37: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;

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

30:
31: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
32: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
33: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
34: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
35: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
36: TYPE g_last_collect_date_tab IS TABLE OF bix_sessions.last_collect_date%TYPE;
37: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
38: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;

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

31: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
32: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
33: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
34: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
35: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
36: TYPE g_last_collect_date_tab IS TABLE OF bix_sessions.last_collect_date%TYPE;
37: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
38: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;
39: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_id%TYPE;

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

34: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
35: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
36: TYPE g_last_collect_date_tab IS TABLE OF bix_sessions.last_collect_date%TYPE;
37: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
38: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;
39: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_id%TYPE;
40: TYPE g_campaign_id_tab IS TABLE OF ams_campaign_schedules_b.campaign_id%TYPE;
41:
42: PROCEDURE Write_Log (p_msg IN VARCHAR2) IS

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

290: p_server_group_id in g_server_group_id_tab,
291: p_application_id in g_application_id_tab)
292: IS
293: TYPE login_time_tab is TABLE OF bix_agent_session_f.login_time%TYPE;
294: TYPE session_id_tab is TABLE OF ieu_sh_sessions.session_id%TYPE;
295: TYPE collect_date_tab is TABLE OF ieu_sh_sessions.end_date_time%TYPE;
296:
297: l_agent_id g_resource_id_tab;
298: l_period_start_date g_begin_date_time_tab;

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

291: p_application_id in g_application_id_tab)
292: IS
293: TYPE login_time_tab is TABLE OF bix_agent_session_f.login_time%TYPE;
294: TYPE session_id_tab is TABLE OF ieu_sh_sessions.session_id%TYPE;
295: TYPE collect_date_tab is TABLE OF ieu_sh_sessions.end_date_time%TYPE;
296:
297: l_agent_id g_resource_id_tab;
298: l_period_start_date g_begin_date_time_tab;
299: l_login_time login_time_tab;

Line 493: ieu_sh_sessions iss

489: ,bis1.last_collect_date last_collect_date
490: ,nvl(res.server_group_id,-1) server_group_id
491: ,decode(iss.application_id, 696, 696, 680, 680, 0) application_id
492: FROM
493: ieu_sh_sessions iss
494: ,bix_sessions bis1
495: ,jtf_rs_resource_extns res
496: WHERE iss.last_update_date > g_collect_start_date
497: AND iss.last_update_date <= g_collect_end_date

Line 543: ieu_sh_sessions iss1

539: , iss1.begin_date_time begin_date_time
540: , iss1.end_date_time end_date_time
541: , min(iss2.begin_date_time) next_sess_begin_date_time
542: FROM
543: ieu_sh_sessions iss1
544: ,ieu_sh_sessions iss2
545: WHERE iss1.active_flag = 'T'
546: AND iss1.resource_id = iss2.resource_id(+)
547: AND iss2.begin_date_time(+) > iss1.begin_date_time

Line 544: ,ieu_sh_sessions iss2

540: , iss1.end_date_time end_date_time
541: , min(iss2.begin_date_time) next_sess_begin_date_time
542: FROM
543: ieu_sh_sessions iss1
544: ,ieu_sh_sessions iss2
545: WHERE iss1.active_flag = 'T'
546: AND iss1.resource_id = iss2.resource_id(+)
547: AND iss2.begin_date_time(+) > iss1.begin_date_time
548: GROUP BY iss1.session_id, iss1.resource_id, iss1.application_id, iss1.begin_date_time, iss1.end_date_time

Line 794: ieu_sh_sessions iss

790: schedule_id
791: ,decode(isa.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
792: campaign_id
793: FROM
794: ieu_sh_sessions iss
795: ,ieu_sh_activities isa
796: ,bix_sessions bis1
797: ,jtf_rs_resource_extns res
798: ,ams_campaign_schedules_b csh

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

795: ,ieu_sh_activities isa
796: ,bix_sessions bis1
797: ,jtf_rs_resource_extns res
798: ,ams_campaign_schedules_b csh
799: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess
800: where activity_type_code='MEDIA'
801: and isamedsess.last_update_date > g_collect_start_date-2 --dummy filter to force index scan
802: and isamed.last_update_date > g_collect_start_date
803: AND isamed.last_update_date <= g_collect_end_date

Line 1068: ieu_sh_sessions iss

1064: schedule_id
1065: ,decode(isa2.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
1066: campaign_id
1067: FROM
1068: ieu_sh_sessions iss
1069: ,ieu_sh_activities isa1
1070: ,ieu_sh_activities isa2
1071: ,bix_sessions bis1
1072: ,jtf_rs_resource_extns res