APPS.BIX_SESSION_LOAD_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 28: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_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;
32:

Line 388: ,jtf_rs_resource_extns res

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

Line 642: ,jtf_rs_resource_extns res

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

Line 919: from jtf_rs_resource_extns res,

915: nvl (inv.end_date_time, lead (inv.prevsd, 1, inv.maxval) over
916: (partition by inv.resource_id order by begin_date_time)) end_date_time,
917: nvl (res.server_group_id, -1) server_group_id,
918: decode (inv.application_id, 696, 696, 680, 680, 0) application_id
919: from jtf_rs_resource_extns res,
920: (select /*+ parallel(x) */ type, resource_id, begin_date_time,
921: end_date_time, session_id, application_id, lag (begin_date_time)
922: over (partition by resource_id order by begin_date_time) prevsd,
923: max (begin_date_time)

Line 975: ,jtf_rs_resource_extns res

971: ,'WITH_AGENT'
972: ,'EMAIL_ESCALATED'
973: )
974: ) mseg
975: ,jtf_rs_resource_extns res
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