DBA Data[Home] [Help]

APPS.BIX_DM_SESSIONINFO_SUMMARY_PKG dependencies on BIX_DM_GROUP_SESSION_SUM

Line 123: ELSIF(p_type = 1 AND p_table_name = 'BIX_DM_GROUP_SESSION_SUM') THEN

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

Line 124: DELETE FROM BIX_DM_GROUP_SESSION_SUM

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

Line 131: ELSIF(p_type = 2 AND p_table_name = 'BIX_DM_GROUP_SESSION_SUM') THEN

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
133: WHERE request_id = g_request_id
134: AND rownum <= g_commit_chunk_size;
135: END IF;

Line 132: DELETE FROM BIX_DM_GROUP_SESSION_SUM

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
133: WHERE request_id = g_request_id
134: AND rownum <= g_commit_chunk_size;
135: END IF;
136:

Line 725: g_table_name := 'BIX_DM_GROUP_SESSION_SUM';

721: g_insert_count := 0;
722: g_delete_count := 0;
723: g_update_count := 0;
724: g_proc_name := l_proc_name ;
725: g_table_name := 'BIX_DM_GROUP_SESSION_SUM';
726:
727: /* Delete data between these dates and re-compute */
728: delete_in_chunks( 'BIX_DM_GROUP_SESSION_SUM', 1, g_delete_count);
729:

Line 728: delete_in_chunks( 'BIX_DM_GROUP_SESSION_SUM', 1, g_delete_count);

724: g_proc_name := l_proc_name ;
725: g_table_name := 'BIX_DM_GROUP_SESSION_SUM';
726:
727: /* Delete data between these dates and re-compute */
728: delete_in_chunks( 'BIX_DM_GROUP_SESSION_SUM', 1, g_delete_count);
729:
730: g_message := 'Start Inserting rows into BIX_DM_GROUP_SESSION_SUM table';
731: write_log(g_pkg_name, l_proc_name, g_message );
732:

Line 730: g_message := 'Start Inserting rows into BIX_DM_GROUP_SESSION_SUM table';

726:
727: /* Delete data between these dates and re-compute */
728: delete_in_chunks( 'BIX_DM_GROUP_SESSION_SUM', 1, g_delete_count);
729:
730: g_message := 'Start Inserting rows into BIX_DM_GROUP_SESSION_SUM table';
731: write_log(g_pkg_name, l_proc_name, g_message );
732:
733: FOR groupinfo IN group_agents
734: LOOP

Line 735: INSERT INTO BIX_DM_GROUP_SESSION_SUM

731: write_log(g_pkg_name, l_proc_name, g_message );
732:
733: FOR groupinfo IN group_agents
734: LOOP
735: INSERT INTO BIX_DM_GROUP_SESSION_SUM
736: ( group_session_summary_id
737: ,group_id
738: ,period_start_date
739: ,period_start_time

Line 782: g_message := 'Finished inserting rows into BIX_DM_GROUP_SESSION_SUM. Inserted ' || l_row_count || ' rows ';

778: END IF;
779:
780: END LOOP;
781:
782: g_message := 'Finished inserting rows into BIX_DM_GROUP_SESSION_SUM. Inserted ' || l_row_count || ' rows ';
783: write_log(g_pkg_name, l_proc_name, g_message );
784:
785: g_insert_count := l_row_count;
786:

Line 799: g_message :='Start rolling back data in BIX_DM_GROUP_SESSION_SUM table';

795: g_error_msg := 'Failed while executing ' || g_proc_name || ':'
796: || sqlcode ||':'|| sqlerrm;
797: write_log(g_pkg_name, l_proc_name, g_message);
798:
799: g_message :='Start rolling back data in BIX_DM_GROUP_SESSION_SUM table';
800: write_log(g_pkg_name, l_proc_name, g_message );
801:
802: BEGIN
803: delete_in_chunks('BIX_DM_GROUP_SESSION_SUM', 2, l_row_count);

Line 803: delete_in_chunks('BIX_DM_GROUP_SESSION_SUM', 2, l_row_count);

799: g_message :='Start rolling back data in BIX_DM_GROUP_SESSION_SUM table';
800: write_log(g_pkg_name, l_proc_name, g_message );
801:
802: BEGIN
803: delete_in_chunks('BIX_DM_GROUP_SESSION_SUM', 2, l_row_count);
804: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSION_SUM table';
805: write_log(g_pkg_name, l_proc_name, g_message );
806: EXCEPTION
807: WHEN OTHERS THEN

Line 804: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSION_SUM table';

800: write_log(g_pkg_name, l_proc_name, g_message );
801:
802: BEGIN
803: delete_in_chunks('BIX_DM_GROUP_SESSION_SUM', 2, l_row_count);
804: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSION_SUM table';
805: write_log(g_pkg_name, l_proc_name, g_message );
806: EXCEPTION
807: WHEN OTHERS THEN
808: g_message := 'Failed to roll back data in BIX_DM_GROUP_SESSION_SUM table ';

Line 808: g_message := 'Failed to roll back data in BIX_DM_GROUP_SESSION_SUM table ';

804: g_message := 'Finished rolling back data in BIX_DM_GROUP_SESSION_SUM table';
805: write_log(g_pkg_name, l_proc_name, g_message );
806: EXCEPTION
807: WHEN OTHERS THEN
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';