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_AGENT_OUTCOME_SUM

Line 177: elsif upper(table_name) = 'BIX_DM_AGENT_OUTCOME_SUM'

173: DELETE BIX_DM_GROUP_SUM
174: WHERE period_start_date_time BETWEEN g_min_call_begin_date
175: AND g_max_call_begin_date
176: AND rownum <= g_commit_chunk_size;
177: elsif upper(table_name) = 'BIX_DM_AGENT_OUTCOME_SUM'
178: then
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

Line 179: DELETE BIX_DM_AGENT_OUTCOME_SUM

175: AND g_max_call_begin_date
176: AND rownum <= g_commit_chunk_size;
177: elsif upper(table_name) = 'BIX_DM_AGENT_OUTCOME_SUM'
178: then
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'

Line 3905: *SUM_AGENT_OUTCOME will populate the BIX_DM_AGENT_OUTCOME_SUM table.

3901: END SUM_CALL;
3902:
3903: /******************************************************************************************
3904: *
3905: *SUM_AGENT_OUTCOME will populate the BIX_DM_AGENT_OUTCOME_SUM table.
3906: *
3907: *****************************************************************************************/
3908:
3909: -- Summarizing the interface table by and inserting into the

Line 3910: -- the BIX_DM_AGENT_OUTCOME_SUM table

3906: *
3907: *****************************************************************************************/
3908:
3909: -- Summarizing the interface table by and inserting into the
3910: -- the BIX_DM_AGENT_OUTCOME_SUM table
3911:
3912: PROCEDURE SUM_AGENT_OUTCOME AS
3913:
3914: CURSOR outcome_data IS

Line 3983: DELETE_IN_CHUNKS('BIX_DM_AGENT_OUTCOME_SUM',

3979: END IF;
3980:
3981: -- Delete the rows from summary table for the date range specified
3982:
3983: DELETE_IN_CHUNKS('BIX_DM_AGENT_OUTCOME_SUM',
3984: 'period_start_date_time BETWEEN '||' to_date('||
3985: ''''||
3986: to_char(g_min_call_begin_date,'YYYY/MM/DDHH24:MI:SS')||
3987: ''''||

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

3997: COMMIT;
3998:
3999: IF (g_debug_flag = 'Y') THEN
4000:
4001: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Finished Deleting rows in BIX_DM_AGENT_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4002:
4003: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Start inserting rows into BIX_DM_AGENT_OUTCOME_SUM table: ', g_proc_name);
4004:
4005: END IF;

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

3999: IF (g_debug_flag = 'Y') THEN
4000:
4001: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Finished Deleting rows in BIX_DM_AGENT_OUTCOME_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
4002:
4003: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_AGENT_OUTCOME: '||' Start inserting rows into BIX_DM_AGENT_OUTCOME_SUM table: ', g_proc_name);
4004:
4005: END IF;
4006:
4007:

Line 4010: INSERT INTO BIX_DM_AGENT_OUTCOME_SUM

4006:
4007:
4008: for outcome_row in outcome_data LOOP
4009:
4010: INSERT INTO BIX_DM_AGENT_OUTCOME_SUM
4011: (
4012: AGENT_OUTCOME_SUM_ID,
4013: LAST_UPDATE_DATE,
4014: LAST_UPDATED_BY,

Line 4036: BIX_DM_AGENT_OUTCOME_SUM_S.NEXTVAL,

4032: NUMBER_OF_CALLS
4033: )
4034: VALUES
4035: (
4036: BIX_DM_AGENT_OUTCOME_SUM_S.NEXTVAL,
4037: SYSDATE,
4038: g_user_id,
4039: SYSDATE,
4040: g_user_id,

Line 4117: FROM bix_dm_agent_outcome_sum call_stage,

4113: call_stage.connect_flag CONNECT_FLAG,
4114: call_stage.contact_flag CONTACT_FLAG,
4115: call_stage.positive_response_flag POSITIVE_RESPONSE_FLAG,
4116: sum(call_stage.number_of_calls) NUMBER_OF_CALLS
4117: FROM bix_dm_agent_outcome_sum call_stage,
4118: jtf_rs_group_members groups,
4119: jtf_rs_groups_denorm group_denorm
4120: WHERE call_stage.resource_id = groups.resource_id
4121: AND call_stage.period_start_date_time BETWEEN g_min_call_begin_date AND g_max_call_begin_date

Line 4178: FROM bix_dm_agent_outcome_sum call_stage

4174: call_stage.connect_flag CONNECT_FLAG,
4175: call_stage.contact_flag CONTACT_FLAG,
4176: call_stage.positive_response_flag POSITIVE_RESPONSE_FLAG,
4177: sum(call_stage.number_of_calls) NUMBER_OF_CALLS
4178: FROM bix_dm_agent_outcome_sum call_stage
4179: WHERE call_stage.resource_id IS NULL --calls with no agents
4180: AND call_stage.period_start_date_time BETWEEN g_min_call_begin_date AND g_max_call_begin_date
4181: GROUP BY call_stage.campaign_id,
4182: call_stage.campaign_schedule_id,

Line 4495: g_table_name := 'BIX_DM_AGENT_OUTCOME_SUM';

4491:
4492: SUM_AGENT_OUTCOME;
4493:
4494: g_status := 'SUCCESS';
4495: g_table_name := 'BIX_DM_AGENT_OUTCOME_SUM';
4496: insert_log;
4497:
4498: /* Procedure collects all the outcomes information for the GROUP data */
4499:

Line 4720: g_table_name := 'BIX_DM_AGENT_OUTCOME_SUM';

4716:
4717: SUM_AGENT_OUTCOME;
4718:
4719: g_status := 'SUCCESS';
4720: g_table_name := 'BIX_DM_AGENT_OUTCOME_SUM';
4721: insert_log;
4722:
4723: /* Procedure collects all the outcomes information for the GROUP data */
4724: