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 AMS_CAMPAIGN_SCHEDULES_B

Line 30: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_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
34: BEGIN

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

Line 389: ,ams_campaign_schedules_b csh

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
390: WHERE isa1.last_update_date > g_collect_start_date
391: AND isa1.last_update_date <= g_collect_end_date
392: AND iss.session_id = isa1.session_id
393: AND iss.application_id = 696

Line 643: ,ams_campaign_schedules_b csh

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
645: where activity_type_code='MEDIA'
646: and isamedsess.session_id=isamed.session_id
647: and isamedsess.application_id=696