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 AMS_CAMPAIGN_SCHEDULES_B

Line 39: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_id%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
43: BEGIN

Line 40: TYPE g_campaign_id_tab IS TABLE OF ams_campaign_schedules_b.campaign_id%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
43: BEGIN
44: IF (g_debug_flag = 'Y') THEN

Line 798: ,ams_campaign_schedules_b csh

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

Line 1073: ,ams_campaign_schedules_b csh

1069: ,ieu_sh_activities isa1
1070: ,ieu_sh_activities isa2
1071: ,bix_sessions bis1
1072: ,jtf_rs_resource_extns res
1073: ,ams_campaign_schedules_b csh
1074: WHERE isa1.last_update_date > g_collect_start_date
1075: AND isa1.last_update_date <= g_collect_end_date
1076: AND iss.application_id = 696
1077: AND iss.session_id = isa1.session_id