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_AGENT_CALL_SUMMARY_PKG dependencies on BIX_DM_EXCEL

Line 189: elsif upper(table_name) = 'BIX_DM_EXCEL'

185: DELETE BIX_DM_GROUP_OUTCOME_SUM
186: WHERE period_start_date_time BETWEEN g_min_call_begin_date
187: AND g_max_call_begin_date
188: AND rownum <= g_commit_chunk_size;
189: elsif upper(table_name) = 'BIX_DM_EXCEL'
190: then
191: DELETE BIX_DM_EXCEL
192: WHERE creation_date < SYSDATE-2/24
193: AND rownum <= g_commit_chunk_size;

Line 191: DELETE BIX_DM_EXCEL

187: AND g_max_call_begin_date
188: AND rownum <= g_commit_chunk_size;
189: elsif upper(table_name) = 'BIX_DM_EXCEL'
190: then
191: DELETE BIX_DM_EXCEL
192: WHERE creation_date < SYSDATE-2/24
193: AND rownum <= g_commit_chunk_size;
194: else
195: RAISE e_invalid_condition;

Line 4404: /* Delete the rows from BIX_DM_EXCEL table which are older than 2 hours */

4400: ELSE
4401: g_debug_flag := 'N';
4402: END IF;
4403:
4404: /* Delete the rows from BIX_DM_EXCEL table which are older than 2 hours */
4405:
4406: IF (g_debug_flag = 'Y') THEN
4407: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);
4408: END IF;

Line 4407: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);

4403:
4404: /* Delete the rows from BIX_DM_EXCEL table which are older than 2 hours */
4405:
4406: IF (g_debug_flag = 'Y') THEN
4407: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);
4408: END IF;
4409:
4410: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);
4411: COMMIT;

Line 4410: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);

4406: IF (g_debug_flag = 'Y') THEN
4407: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);
4408: END IF;
4409:
4410: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);
4411: COMMIT;
4412:
4413: IF (g_debug_flag = 'Y') THEN
4414: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' End delete of BIX_DM_EXCEL table ' || g_delete_count, g_proc_name);

Line 4414: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' End delete of BIX_DM_EXCEL table ' || g_delete_count, g_proc_name);

4410: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);
4411: COMMIT;
4412:
4413: IF (g_debug_flag = 'Y') THEN
4414: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' End delete of BIX_DM_EXCEL table ' || g_delete_count, g_proc_name);
4415: END IF;
4416:
4417: loop
4418: if (g_collect_end_date - g_collect_start_date) > 1 then

Line 4624: /* Delete the rows from BIX_DM_EXCEL table which are older than 2 hours */

4620: ELSE
4621: g_debug_flag := 'N';
4622: END IF;
4623:
4624: /* Delete the rows from BIX_DM_EXCEL table which are older than 2 hours */
4625:
4626: IF (g_debug_flag = 'Y') THEN
4627: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);
4628: END IF;

Line 4627: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);

4623:
4624: /* Delete the rows from BIX_DM_EXCEL table which are older than 2 hours */
4625:
4626: IF (g_debug_flag = 'Y') THEN
4627: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);
4628: END IF;
4629:
4630: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);
4631: COMMIT;

Line 4630: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);

4626: IF (g_debug_flag = 'Y') THEN
4627: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' Start delete of BIX_DM_EXCEL table', g_proc_name);
4628: END IF;
4629:
4630: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);
4631: COMMIT;
4632:
4633: IF (g_debug_flag = 'Y') THEN
4634: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' End delete of BIX_DM_EXCEL table ' || g_delete_count, g_proc_name);

Line 4634: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' End delete of BIX_DM_EXCEL table ' || g_delete_count, g_proc_name);

4630: DELETE_IN_CHUNKS('BIX_DM_EXCEL',' creation_date < SYSDATE-2/24',g_delete_count);
4631: COMMIT;
4632:
4633: IF (g_debug_flag = 'Y') THEN
4634: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' End delete of BIX_DM_EXCEL table ' || g_delete_count, g_proc_name);
4635: END IF;
4636:
4637: loop
4638: if (g_collect_end_date - g_collect_start_date) > 1 then