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_SESSBYCAMP_PKG dependencies on BIX_DM_AGENT_SESSBYCAMP_SUM

Line 139: IF(p_type = 1 AND p_table_name = 'BIX_DM_AGENT_SESSBYCAMP_SUM') THEN

135:
136: LOOP
137: --EXECUTE IMMEDIATE l_delete_statement;
138:
139: IF(p_type = 1 AND p_table_name = 'BIX_DM_AGENT_SESSBYCAMP_SUM') THEN
140: DELETE FROM BIX_DM_AGENT_SESSBYCAMP_SUM
141: WHERE period_start_date_time between g_rounded_collect_start_date
142: AND g_rounded_collect_end_date
143: AND rownum <= g_commit_chunk_size;

Line 140: DELETE FROM BIX_DM_AGENT_SESSBYCAMP_SUM

136: LOOP
137: --EXECUTE IMMEDIATE l_delete_statement;
138:
139: IF(p_type = 1 AND p_table_name = 'BIX_DM_AGENT_SESSBYCAMP_SUM') THEN
140: DELETE FROM BIX_DM_AGENT_SESSBYCAMP_SUM
141: WHERE period_start_date_time between g_rounded_collect_start_date
142: AND g_rounded_collect_end_date
143: AND rownum <= g_commit_chunk_size;
144: ELSIF(p_type = 1 AND p_table_name = 'BIX_DM_GROUP_SESSBYCAMP_SUM') THEN

Line 149: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_AGENT_SESSBYCAMP_SUM') THEN

145: DELETE FROM BIX_DM_GROUP_SESSBYCAMP_SUM
146: WHERE period_start_date_time between g_rounded_collect_start_date
147: AND g_rounded_collect_end_date
148: AND rownum <= g_commit_chunk_size;
149: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_AGENT_SESSBYCAMP_SUM') THEN
150: DELETE FROM BIX_DM_AGENT_SESSBYCAMP_SUM
151: WHERE request_id = g_request_id
152: AND rownum <= g_commit_chunk_size;
153: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_GROUP_SESSBYCAMP_SUM') THEN

Line 150: DELETE FROM BIX_DM_AGENT_SESSBYCAMP_SUM

146: WHERE period_start_date_time between g_rounded_collect_start_date
147: AND g_rounded_collect_end_date
148: AND rownum <= g_commit_chunk_size;
149: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_AGENT_SESSBYCAMP_SUM') THEN
150: DELETE FROM BIX_DM_AGENT_SESSBYCAMP_SUM
151: WHERE request_id = g_request_id
152: AND rownum <= g_commit_chunk_size;
153: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_GROUP_SESSBYCAMP_SUM') THEN
154: DELETE FROM BIX_DM_GROUP_SESSBYCAMP_SUM

Line 202: FROM BIX_DM_AGENT_SESSBYCAMP_SUM

198:
199: BEGIN
200: SELECT 'Y'
201: INTO l_exists
202: FROM BIX_DM_AGENT_SESSBYCAMP_SUM
203: WHERE resource_id = p_resource_id
204: AND period_start_date_time = p_start_date
205: AND server_group_id = p_server_group_id
206: AND campaign_id = p_campaign_id

Line 217: INSERT INTO BIX_DM_AGENT_SESSBYCAMP_SUM

213: END;
214:
215: IF l_exists = 'N'
216: THEN
217: INSERT INTO BIX_DM_AGENT_SESSBYCAMP_SUM
218: ( agent_sessbycamp_sum_id
219: ,resource_id
220: ,server_group_id
221: ,campaign_id

Line 238: ( BIX_DM_AGENT_SESSBYCAMP_SUM_S.NEXTVAL

234: ,program_application_id
235: ,program_id
236: ,program_update_date
237: ) VALUES
238: ( BIX_DM_AGENT_SESSBYCAMP_SUM_S.NEXTVAL
239: ,p_resource_id
240: ,p_server_group_id
241: ,p_campaign_id
242: ,p_campaign_schedule_id

Line 259: UPDATE BIX_DM_AGENT_SESSBYCAMP_SUM

255: ,g_program_id
256: ,SYSDATE );
257: p_ddl_type := 'I' ;
258: ELSE
259: UPDATE BIX_DM_AGENT_SESSBYCAMP_SUM
260: SET work_time = work_time + p_secs,
261: last_update_date = SYSDATE,
262: last_updated_by = g_user_id,
263: program_update_date = SYSDATE

Line 319: g_message := 'Start collecting work time into BIX_DM_AGENT_SESSBYCAMP_SUM';

315: OR sess.end_date_time is NULL ) ;
316: BEGIN
317:
318: g_proc_name := l_proc_name;
319: g_message := 'Start collecting work time into BIX_DM_AGENT_SESSBYCAMP_SUM';
320: write_log( g_pkg_name, l_proc_name, g_message );
321:
322: FOR work_time IN get_work_time
323: LOOP

Line 529: UPDATE BIX_DM_AGENT_SESSBYCAMP_SUM

525: l_secs := round((l_work_end - l_work_start) * 24 * 3600);
526: IF (l_secs > 0 )
527: THEN
528:
529: UPDATE BIX_DM_AGENT_SESSBYCAMP_SUM
530: SET available_time = nvl(available_time,0)+l_secs,
531: last_update_date = SYSDATE,
532: last_updated_by = g_user_id,
533: program_update_date = SYSDATE

Line 581: FROM BIX_DM_AGENT_SESSBYCAMP_sum agt_sum,

577: agt_sum.period_start_time,
578: agt_sum.period_start_date_time,
579: SUM(agt_sum.available_time) available_time,
580: SUM(agt_sum.work_time) work_time
581: FROM BIX_DM_AGENT_SESSBYCAMP_sum agt_sum,
582: jtf_rs_group_members grp_mem,
583: jtf_rs_groups_denorm grp_denorm
584: WHERE agt_sum.period_start_date_time BETWEEN g_rounded_collect_start_date
585: AND g_rounded_collect_end_date

Line 714: g_message := 'Start rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table';

710: g_message := 'Failed to roll back data in BIX_DM_GROUP_SESSBYCAMP_SUM table ';
711: write_log(g_pkg_name, l_proc_name, g_message );
712: END;
713:
714: g_message := 'Start rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table';
715: write_log(g_pkg_name, l_proc_name, g_message );
716:
717: BEGIN
718: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_row_count);

Line 718: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_row_count);

714: g_message := 'Start rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table';
715: write_log(g_pkg_name, l_proc_name, g_message );
716:
717: BEGIN
718: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_row_count);
719: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ' ;
720: write_log(g_pkg_name, l_proc_name, g_message );
721: EXCEPTION
722: WHEN OTHERS THEN

Line 719: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ' ;

715: write_log(g_pkg_name, l_proc_name, g_message );
716:
717: BEGIN
718: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_row_count);
719: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ' ;
720: write_log(g_pkg_name, l_proc_name, g_message );
721: EXCEPTION
722: WHEN OTHERS THEN
723: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ';

Line 723: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ';

719: g_message := 'Finished Rollling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ' ;
720: write_log(g_pkg_name, l_proc_name, g_message );
721: EXCEPTION
722: WHEN OTHERS THEN
723: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ';
724: write_log(g_pkg_name, l_proc_name, g_message );
725: END;
726:
727: UPDATE BIX_DM_COLLECT_LOG

Line 752: g_table_name := 'BIX_DM_AGENT_SESSBYCAMP_SUM';

748: g_insert_count := 0;
749: g_delete_count := 0;
750: g_update_count := 0;
751: g_proc_name := l_proc_name;
752: g_table_name := 'BIX_DM_AGENT_SESSBYCAMP_SUM';
753:
754: /* Delete data between these dates and re-compute */
755: delete_in_chunks( 'BIX_DM_AGENT_SESSBYCAMP_SUM', 1, g_delete_count);
756:

Line 755: delete_in_chunks( 'BIX_DM_AGENT_SESSBYCAMP_SUM', 1, g_delete_count);

751: g_proc_name := l_proc_name;
752: g_table_name := 'BIX_DM_AGENT_SESSBYCAMP_SUM';
753:
754: /* Delete data between these dates and re-compute */
755: delete_in_chunks( 'BIX_DM_AGENT_SESSBYCAMP_SUM', 1, g_delete_count);
756:
757: /* Procedure collects Agent work time from IEU_SH_SESSIONS table */
758: collect_agent_work_time;
759:

Line 769: COMMIT; --commit after all rows are inserted in BIX_DM_AGENT_SESSBYCAMP_sum

765: g_run_end_date := sysdate;
766: g_status := 'SUCCESS';
767: insert_log_table;
768:
769: COMMIT; --commit after all rows are inserted in BIX_DM_AGENT_SESSBYCAMP_sum
770:
771: EXCEPTION
772: WHEN OTHERS THEN
773: g_message := 'Failed while populating BIX_DM_AGENT_SESSBYCAMP_sum : '||

Line 773: g_message := 'Failed while populating BIX_DM_AGENT_SESSBYCAMP_sum : '||

769: COMMIT; --commit after all rows are inserted in BIX_DM_AGENT_SESSBYCAMP_sum
770:
771: EXCEPTION
772: WHEN OTHERS THEN
773: g_message := 'Failed while populating BIX_DM_AGENT_SESSBYCAMP_sum : '||
774: sqlerrm;
775: write_log(g_pkg_name, l_proc_name, g_message);
776:
777: g_message :='Start rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table';

Line 777: g_message :='Start rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table';

773: g_message := 'Failed while populating BIX_DM_AGENT_SESSBYCAMP_sum : '||
774: sqlerrm;
775: write_log(g_pkg_name, l_proc_name, g_message);
776:
777: g_message :='Start rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table';
778: write_log(g_pkg_name, l_proc_name, g_message );
779:
780: BEGIN
781: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_delete_count);

Line 781: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_delete_count);

777: g_message :='Start rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table';
778: write_log(g_pkg_name, l_proc_name, g_message );
779:
780: BEGIN
781: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_delete_count);
782: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table' ;
783: write_log(g_pkg_name, l_proc_name, g_message );
784: EXCEPTION
785: WHEN OTHERS THEN

Line 782: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table' ;

778: write_log(g_pkg_name, l_proc_name, g_message );
779:
780: BEGIN
781: delete_in_chunks('BIX_DM_AGENT_SESSBYCAMP_SUM', 2, l_delete_count);
782: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table' ;
783: write_log(g_pkg_name, l_proc_name, g_message );
784: EXCEPTION
785: WHEN OTHERS THEN
786: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ';

Line 786: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ';

782: g_message := 'Finished rolling back data in BIX_DM_AGENT_SESSBYCAMP_SUM table' ;
783: write_log(g_pkg_name, l_proc_name, g_message );
784: EXCEPTION
785: WHEN OTHERS THEN
786: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ';
787: write_log(g_pkg_name, l_proc_name, g_message );
788: END;
789:
790: g_run_end_date := sysdate;