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_GROUP_SESSBYCAMP_SUM

Line 144: ELSIF(p_type = 1 AND p_table_name = 'BIX_DM_GROUP_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
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;

Line 145: DELETE FROM BIX_DM_GROUP_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
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

Line 153: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_GROUP_SESSBYCAMP_SUM') THEN

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
155: WHERE request_id = g_request_id
156: AND rownum <= g_commit_chunk_size;
157: ELSE

Line 154: DELETE FROM BIX_DM_GROUP_SESSBYCAMP_SUM

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
155: WHERE request_id = g_request_id
156: AND rownum <= g_commit_chunk_size;
157: ELSE
158: RAISE e_invalid_condition;

Line 625: g_table_name := 'BIX_DM_GROUP_SESSBYCAMP_SUM';

621: g_insert_count := 0;
622: g_delete_count := 0;
623: g_update_count := 0;
624: g_proc_name := l_proc_name ;
625: g_table_name := 'BIX_DM_GROUP_SESSBYCAMP_SUM';
626:
627: /* Delete data between these dates and re-compute */
628: delete_in_chunks( 'BIX_DM_GROUP_SESSBYCAMP_SUM', 1, g_delete_count);
629:

Line 628: delete_in_chunks( 'BIX_DM_GROUP_SESSBYCAMP_SUM', 1, g_delete_count);

624: g_proc_name := l_proc_name ;
625: g_table_name := 'BIX_DM_GROUP_SESSBYCAMP_SUM';
626:
627: /* Delete data between these dates and re-compute */
628: delete_in_chunks( 'BIX_DM_GROUP_SESSBYCAMP_SUM', 1, g_delete_count);
629:
630: g_message := 'Start Inserting rows into BIX_DM_GROUP_SESSION_SUM table';
631: write_log(g_pkg_name, l_proc_name, g_message );
632:

Line 635: INSERT INTO BIX_DM_GROUP_SESSBYCAMP_SUM

631: write_log(g_pkg_name, l_proc_name, g_message );
632:
633: FOR groupinfo IN group_agents
634: LOOP
635: INSERT INTO BIX_DM_GROUP_SESSBYCAMP_SUM
636: ( group_sessbycamp_sum_id
637: ,group_id
638: ,server_group_id
639: ,campaign_id

Line 684: g_message := 'Finished inserting rows into BIX_DM_GROUP_SESSBYCAMP_SUM. Inserted ' || l_row_count || ' rows ';

680: END IF;
681:
682: END LOOP;
683:
684: g_message := 'Finished inserting rows into BIX_DM_GROUP_SESSBYCAMP_SUM. Inserted ' || l_row_count || ' rows ';
685: write_log(g_pkg_name, l_proc_name, g_message );
686:
687: g_insert_count := l_row_count;
688:

Line 701: g_message :='Start rolling back data in BIX_DM_GROUP_SESSBYCAMP_SUM table';

697: g_error_msg := 'Failed while executing ' || g_proc_name || ':'
698: || sqlcode ||':'|| sqlerrm;
699: write_log(g_pkg_name, l_proc_name, g_message);
700:
701: g_message :='Start rolling back data in BIX_DM_GROUP_SESSBYCAMP_SUM table';
702: write_log(g_pkg_name, l_proc_name, g_message );
703:
704: BEGIN
705: delete_in_chunks('BIX_DM_GROUP_SESSBYCAMP_SUM', 2, l_row_count);

Line 705: delete_in_chunks('BIX_DM_GROUP_SESSBYCAMP_SUM', 2, l_row_count);

701: g_message :='Start rolling back data in BIX_DM_GROUP_SESSBYCAMP_SUM table';
702: write_log(g_pkg_name, l_proc_name, g_message );
703:
704: BEGIN
705: delete_in_chunks('BIX_DM_GROUP_SESSBYCAMP_SUM', 2, l_row_count);
706: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSBYCAMP_SUM table';
707: write_log(g_pkg_name, l_proc_name, g_message );
708: EXCEPTION
709: WHEN OTHERS THEN

Line 706: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSBYCAMP_SUM table';

702: write_log(g_pkg_name, l_proc_name, g_message );
703:
704: BEGIN
705: delete_in_chunks('BIX_DM_GROUP_SESSBYCAMP_SUM', 2, l_row_count);
706: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSBYCAMP_SUM table';
707: write_log(g_pkg_name, l_proc_name, g_message );
708: EXCEPTION
709: WHEN OTHERS THEN
710: g_message := 'Failed to roll back data in BIX_DM_GROUP_SESSBYCAMP_SUM table ';

Line 710: g_message := 'Failed to roll back data in BIX_DM_GROUP_SESSBYCAMP_SUM table ';

706: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSBYCAMP_SUM table';
707: write_log(g_pkg_name, l_proc_name, g_message );
708: EXCEPTION
709: WHEN OTHERS THEN
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';

Line 733: AND object_name = 'BIX_DM_GROUP_SESSBYCAMP_SUM';

729: rows_inserted = 0,
730: rows_updated = 0,
731: collect_excep_mesg = g_error_msg
732: WHERE request_id = g_request_id
733: AND object_name = 'BIX_DM_GROUP_SESSBYCAMP_SUM';
734:
735: g_run_end_date := sysdate;
736: g_status := 'FAILURE';
737: insert_log_table;