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_DM_SESSIONINFO_SUMMARY_PKG dependencies on BIX_DM_AGENT_SESSION_SUM

Line 119: IF(p_type = 1 AND p_table_name = 'BIX_DM_AGENT_SESSION_SUM') THEN

115: l_rows_deleted := 0;
116:
117: LOOP
118:
119: IF(p_type = 1 AND p_table_name = 'BIX_DM_AGENT_SESSION_SUM') THEN
120: DELETE FROM BIX_DM_AGENT_SESSION_SUM
121: WHERE period_start_date_time between g_rounded_collect_start_date AND g_rounded_collect_end_date
122: AND rownum <= g_commit_chunk_size;
123: ELSIF(p_type = 1 AND p_table_name = 'BIX_DM_GROUP_SESSION_SUM') THEN

Line 120: DELETE FROM BIX_DM_AGENT_SESSION_SUM

116:
117: LOOP
118:
119: IF(p_type = 1 AND p_table_name = 'BIX_DM_AGENT_SESSION_SUM') THEN
120: DELETE FROM BIX_DM_AGENT_SESSION_SUM
121: WHERE period_start_date_time between g_rounded_collect_start_date AND g_rounded_collect_end_date
122: AND rownum <= g_commit_chunk_size;
123: ELSIF(p_type = 1 AND p_table_name = 'BIX_DM_GROUP_SESSION_SUM') THEN
124: DELETE FROM BIX_DM_GROUP_SESSION_SUM

Line 127: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_AGENT_SESSION_SUM') THEN

123: ELSIF(p_type = 1 AND p_table_name = 'BIX_DM_GROUP_SESSION_SUM') THEN
124: DELETE FROM BIX_DM_GROUP_SESSION_SUM
125: WHERE period_start_date_time between g_rounded_collect_start_date AND g_rounded_collect_end_date
126: AND rownum <= g_commit_chunk_size;
127: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_AGENT_SESSION_SUM') THEN
128: DELETE FROM BIX_DM_AGENT_SESSION_SUM
129: WHERE request_id = g_request_id
130: AND rownum <= g_commit_chunk_size;
131: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_GROUP_SESSION_SUM') THEN

Line 128: DELETE FROM BIX_DM_AGENT_SESSION_SUM

124: DELETE FROM BIX_DM_GROUP_SESSION_SUM
125: WHERE period_start_date_time between g_rounded_collect_start_date AND g_rounded_collect_end_date
126: AND rownum <= g_commit_chunk_size;
127: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_AGENT_SESSION_SUM') THEN
128: DELETE FROM BIX_DM_AGENT_SESSION_SUM
129: WHERE request_id = g_request_id
130: AND rownum <= g_commit_chunk_size;
131: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_GROUP_SESSION_SUM') THEN
132: DELETE FROM BIX_DM_GROUP_SESSION_SUM

Line 172: FROM BIX_DM_AGENT_SESSION_SUM

168:
169: BEGIN
170: SELECT 'Y'
171: INTO l_exists
172: FROM BIX_DM_AGENT_SESSION_SUM
173: WHERE resource_id = p_resource_id
174: AND period_start_date_time = p_start_date;
175: EXCEPTION
176: WHEN NO_DATA_FOUND THEN

Line 184: INSERT INTO BIX_DM_AGENT_SESSION_SUM

180: END;
181:
182: IF l_exists = 'N'
183: THEN
184: INSERT INTO BIX_DM_AGENT_SESSION_SUM
185: ( agent_session_summary_id
186: ,resource_id
187: ,period_start_date
188: ,period_start_time

Line 204: ( BIX_DM_AGENT_SESSION_SUM_S.NEXTVAL

200: ,program_application_id
201: ,program_id
202: ,program_update_date
203: ) VALUES
204: ( BIX_DM_AGENT_SESSION_SUM_S.NEXTVAL
205: ,p_resource_id
206: ,TRUNC(p_start_date)
207: ,TO_CHAR(p_start_date,'HH24:MI')
208: ,p_start_date

Line 224: UPDATE BIX_DM_AGENT_SESSION_SUM

220: ,g_program_id
221: ,SYSDATE );
222: p_ddl_type := 'I' ;
223: ELSE
224: UPDATE BIX_DM_AGENT_SESSION_SUM
225: SET login_time = login_time + p_secs,
226: agent_cost = agent_cost + ((p_secs/3600) * p_agent_cost ),
227: last_update_date = SYSDATE,
228: last_updated_by = g_user_id,

Line 327: UPDATE BIX_DM_AGENT_SESSION_SUM

323: END IF;
324: l_secs := round((l_idle_end - l_idle_start) * 24 * 3600);
325: IF (l_secs > 0 )
326: THEN
327: UPDATE BIX_DM_AGENT_SESSION_SUM
328: SET idle_time = nvl(idle_time,0)+l_secs,
329: last_update_date = SYSDATE,
330: last_updated_by = g_user_id,
331: program_update_date = SYSDATE

Line 394: UPDATE BIX_DM_AGENT_SESSION_SUM

390: END IF;
391: l_secs := round((l_idle_end - l_idle_start) * 24 * 3600);
392: IF (l_secs > 0 )
393: THEN
394: UPDATE BIX_DM_AGENT_SESSION_SUM
395: SET idle_time = nvl(idle_time,0)+l_secs,
396: last_update_date = SYSDATE,
397: last_updated_by = g_user_id,
398: program_update_date = SYSDATE

Line 468: g_message := 'Start collecting agent login time into BIX_DM_AGENT_SESSION_SUM';

464: g_message := 'Failed to get the Agent cost.';
465: write_log( g_pkg_name, l_proc_name, g_message );
466: END;
467:
468: g_message := 'Start collecting agent login time into BIX_DM_AGENT_SESSION_SUM';
469: write_log( g_pkg_name, l_proc_name, g_message );
470:
471: FOR login_time IN get_login_time
472: LOOP

Line 643: UPDATE BIX_DM_AGENT_SESSION_SUM

639: END IF;
640: l_secs := round((l_login_end - l_login_start) * 24 * 3600);
641: IF (l_secs > 0 )
642: THEN
643: UPDATE BIX_DM_AGENT_SESSION_SUM
644: SET available_time = nvl(available_time,0)+l_secs,
645: last_update_date = SYSDATE,
646: last_updated_by = g_user_id,
647: program_update_date = SYSDATE

Line 690: FROM bix_dm_agent_session_sum agt_sum,

686: SUM(agt_sum.available_time) available_time,
687: SUM(agt_sum.login_time) login_time,
688: SUM(agt_sum.idle_time) idle_time,
689: SUM(agt_sum.agent_cost) group_cost
690: FROM bix_dm_agent_session_sum agt_sum,
691: jtf_rs_group_members groups,
692: jtf_rs_groups_denorm group_denorm
693: WHERE agt_sum.period_start_date_time BETWEEN g_rounded_collect_start_date
694: AND g_rounded_collect_end_date

Line 812: g_message := 'Start rolling back data in BIX_DM_AGENT_SESSION_SUM table';

808: g_message := 'Failed to roll back data in BIX_DM_GROUP_SESSION_SUM table ';
809: write_log(g_pkg_name, l_proc_name, g_message );
810: END;
811:
812: g_message := 'Start rolling back data in BIX_DM_AGENT_SESSION_SUM table';
813: write_log(g_pkg_name, l_proc_name, g_message );
814:
815: BEGIN
816: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_row_count);

Line 816: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_row_count);

812: g_message := 'Start rolling back data in BIX_DM_AGENT_SESSION_SUM table';
813: write_log(g_pkg_name, l_proc_name, g_message );
814:
815: BEGIN
816: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_row_count);
817: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSION_SUM table ' ;
818: write_log(g_pkg_name, l_proc_name, g_message );
819: EXCEPTION
820: WHEN OTHERS THEN

Line 817: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSION_SUM table ' ;

813: write_log(g_pkg_name, l_proc_name, g_message );
814:
815: BEGIN
816: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_row_count);
817: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSION_SUM table ' ;
818: write_log(g_pkg_name, l_proc_name, g_message );
819: EXCEPTION
820: WHEN OTHERS THEN
821: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSION_SUM table ';

Line 821: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSION_SUM table ';

817: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSION_SUM table ' ;
818: write_log(g_pkg_name, l_proc_name, g_message );
819: EXCEPTION
820: WHEN OTHERS THEN
821: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSION_SUM table ';
822: write_log(g_pkg_name, l_proc_name, g_message );
823: END;
824:
825: UPDATE BIX_DM_COLLECT_LOG

Line 831: AND object_name = 'BIX_DM_AGENT_SESSION_SUM';

827: rows_inserted = 0,
828: rows_updated = 0,
829: collect_excep_mesg = g_error_msg
830: WHERE request_id = g_request_id
831: AND object_name = 'BIX_DM_AGENT_SESSION_SUM';
832:
833: g_run_end_date := sysdate;
834: g_status := 'FAILURE';
835: insert_log_table;

Line 850: g_table_name := 'BIX_DM_AGENT_SESSION_SUM';

846: g_insert_count := 0;
847: g_delete_count := 0;
848: g_update_count := 0;
849: g_proc_name := l_proc_name;
850: g_table_name := 'BIX_DM_AGENT_SESSION_SUM';
851:
852: /* Delete data between these dates and re-compute */
853: delete_in_chunks( 'BIX_DM_AGENT_SESSION_SUM', 1, g_delete_count);
854:

Line 853: delete_in_chunks( 'BIX_DM_AGENT_SESSION_SUM', 1, g_delete_count);

849: g_proc_name := l_proc_name;
850: g_table_name := 'BIX_DM_AGENT_SESSION_SUM';
851:
852: /* Delete data between these dates and re-compute */
853: delete_in_chunks( 'BIX_DM_AGENT_SESSION_SUM', 1, g_delete_count);
854:
855: /* Procedure collects Agent login time from IEU_SH_SESSIONS table */
856: collect_agent_login_time;
857:

Line 867: COMMIT; --commit after all rows are inserted in bix_dm_agent_session_sum

863: g_run_end_date := sysdate;
864: g_status := 'SUCCESS';
865: insert_log_table;
866:
867: COMMIT; --commit after all rows are inserted in bix_dm_agent_session_sum
868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: g_message := 'Failed while populating bix_dm_agent_session_sum : '||

Line 871: g_message := 'Failed while populating bix_dm_agent_session_sum : '||

867: COMMIT; --commit after all rows are inserted in bix_dm_agent_session_sum
868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: g_message := 'Failed while populating bix_dm_agent_session_sum : '||
872: sqlerrm;
873: write_log(g_pkg_name, l_proc_name, g_message);
874:
875: g_message :='Start rolling back data in BIX_DM_AGENT_SESSION_SUM table';

Line 875: g_message :='Start rolling back data in BIX_DM_AGENT_SESSION_SUM table';

871: g_message := 'Failed while populating bix_dm_agent_session_sum : '||
872: sqlerrm;
873: write_log(g_pkg_name, l_proc_name, g_message);
874:
875: g_message :='Start rolling back data in BIX_DM_AGENT_SESSION_SUM table';
876: write_log(g_pkg_name, l_proc_name, g_message );
877:
878: BEGIN
879: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_delete_count);

Line 879: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_delete_count);

875: g_message :='Start rolling back data in BIX_DM_AGENT_SESSION_SUM table';
876: write_log(g_pkg_name, l_proc_name, g_message );
877:
878: BEGIN
879: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_delete_count);
880: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSION_SUM table' ;
881: write_log(g_pkg_name, l_proc_name, g_message );
882: EXCEPTION
883: WHEN OTHERS THEN

Line 880: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSION_SUM table' ;

876: write_log(g_pkg_name, l_proc_name, g_message );
877:
878: BEGIN
879: delete_in_chunks('BIX_DM_AGENT_SESSION_SUM', 2, l_delete_count);
880: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSION_SUM table' ;
881: write_log(g_pkg_name, l_proc_name, g_message );
882: EXCEPTION
883: WHEN OTHERS THEN
884: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSION_SUM table ';

Line 884: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSION_SUM table ';

880: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSION_SUM table' ;
881: write_log(g_pkg_name, l_proc_name, g_message );
882: EXCEPTION
883: WHEN OTHERS THEN
884: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSION_SUM table ';
885: write_log(g_pkg_name, l_proc_name, g_message );
886: END;
887:
888: g_run_end_date := sysdate;