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_GROUP_OUTCOME_SUM

Line 183: elsif upper(table_name) = 'BIX_DM_GROUP_OUTCOME_SUM'

179: DELETE BIX_DM_AGENT_OUTCOME_SUM
180: WHERE period_start_date_time BETWEEN g_min_call_begin_date
181: AND g_max_call_begin_date
182: AND rownum <= g_commit_chunk_size;
183: elsif upper(table_name) = 'BIX_DM_GROUP_OUTCOME_SUM'
184: then
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

Line 185: DELETE BIX_DM_GROUP_OUTCOME_SUM

181: AND g_max_call_begin_date
182: AND rownum <= g_commit_chunk_size;
183: elsif upper(table_name) = 'BIX_DM_GROUP_OUTCOME_SUM'
184: then
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'

Line 4091: *SUM_GROUP_OUTCOME will populate the BIX_DM_GROUP_OUTCOME_SUM table.

4087: /******************End SUM_AGENT_OUTCOME **************************************************/
4088:
4089: /******************************************************************************************
4090: *
4091: *SUM_GROUP_OUTCOME will populate the BIX_DM_GROUP_OUTCOME_SUM table.
4092: *
4093: *****************************************************************************************/
4094:
4095:

Line 4097: -- the BIX_DM_GROUP_OUTCOME_SUM table

4093: *****************************************************************************************/
4094:
4095:
4096: -- Summarizing the interface table by and inserting into the
4097: -- the BIX_DM_GROUP_OUTCOME_SUM table
4098:
4099: PROCEDURE SUM_GROUP_OUTCOME AS
4100:
4101: CURSOR outcome_data IS

Line 4219: DELETE_IN_CHUNKS('BIX_DM_GROUP_OUTCOME_SUM',

4215: END IF;
4216:
4217: -- Delete the rows from summary table for the date range specified
4218:
4219: DELETE_IN_CHUNKS('BIX_DM_GROUP_OUTCOME_SUM',
4220: 'period_start_date_time BETWEEN '||' to_date('||
4221: ''''||
4222: to_char(g_min_call_begin_date,'YYYY/MM/DDHH24:MI:SS')||
4223: ''''||

Line 4236: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Finished Deleting rows in BIX_DM_GROUP_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);

4232:
4233: COMMIT;
4234:
4235: IF (g_debug_flag = 'Y') THEN
4236: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Finished Deleting rows in BIX_DM_GROUP_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4237:
4238: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start inserting rows into BIX_DM_GROUP_OUTCOME_SUM table: ', g_proc_name);
4239: END IF;
4240:

Line 4238: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start inserting rows into BIX_DM_GROUP_OUTCOME_SUM table: ', g_proc_name);

4234:
4235: IF (g_debug_flag = 'Y') THEN
4236: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Finished Deleting rows in BIX_DM_GROUP_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4237:
4238: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME: '||' Start inserting rows into BIX_DM_GROUP_OUTCOME_SUM table: ', g_proc_name);
4239: END IF;
4240:
4241:
4242: for outcome_row in outcome_data LOOP

Line 4244: INSERT INTO BIX_DM_GROUP_OUTCOME_SUM

4240:
4241:
4242: for outcome_row in outcome_data LOOP
4243:
4244: INSERT INTO BIX_DM_GROUP_OUTCOME_SUM
4245: (
4246: GROUP_OUTCOME_SUM_ID,
4247: LAST_UPDATE_DATE,
4248: LAST_UPDATED_BY,

Line 4270: BIX_DM_GROUP_OUTCOME_SUM_S.NEXTVAL,

4266: NUMBER_OF_CALLS
4267: )
4268: VALUES
4269: (
4270: BIX_DM_GROUP_OUTCOME_SUM_S.NEXTVAL,
4271: SYSDATE,
4272: g_user_id,
4273: SYSDATE,
4274: g_user_id,

Line 4304: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_GROUP_OUTCOME: '|| ' Failed to Roll back data in BIX_DM_GROUP_OUTCOME_SUM table ', g_proc_name);

4300: EXCEPTION
4301: WHEN OTHERS THEN
4302:
4303: IF (g_debug_flag = 'Y') THEN
4304: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_GROUP_OUTCOME: '|| ' Failed to Roll back data in BIX_DM_GROUP_OUTCOME_SUM table ', g_proc_name);
4305: END IF;
4306:
4307: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP_OUTCOME';
4308: g_error_mesg := g_proc_name ||' : '|| sqlerrm;

Line 4507: g_table_name := 'BIX_DM_GROUP_OUTCOME_SUM';

4503:
4504: SUM_GROUP_OUTCOME;
4505:
4506: g_status := 'SUCCESS';
4507: g_table_name := 'BIX_DM_GROUP_OUTCOME_SUM';
4508: insert_log;
4509:
4510: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */
4511:

Line 4732: g_table_name := 'BIX_DM_GROUP_OUTCOME_SUM';

4728:
4729: SUM_GROUP_OUTCOME;
4730:
4731: g_status := 'SUCCESS';
4732: g_table_name := 'BIX_DM_GROUP_OUTCOME_SUM';
4733: insert_log;
4734:
4735: /* Cleanup: Delete all from the BIX_DM_INTERFACE table */
4736: