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_SUM

Line 171: elsif upper(table_name) = 'BIX_DM_GROUP_SUM'

167: DELETE BIX_DM_AGENT_SUM
168: WHERE period_start_date_time BETWEEN g_min_call_begin_date
169: AND g_max_call_begin_date
170: AND rownum <= g_commit_chunk_size;
171: elsif upper(table_name) = 'BIX_DM_GROUP_SUM'
172: then
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

Line 173: DELETE BIX_DM_GROUP_SUM

169: AND g_max_call_begin_date
170: AND rownum <= g_commit_chunk_size;
171: elsif upper(table_name) = 'BIX_DM_GROUP_SUM'
172: then
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'

Line 3257: -- the BIX_DM_GROUP_SUM table. If an agent is in two or more groups the

3253:
3254:
3255:
3256: -- Summarizing the BIX_DM_AGENT_SUM table by group and inserting rows into
3257: -- the BIX_DM_GROUP_SUM table. If an agent is in two or more groups the
3258: -- numbers will be double-counted. Therefore this table is not additive.
3259:
3260: PROCEDURE SUM_GROUP AS
3261:

Line 3386: DELETE_IN_CHUNKS('BIX_DM_GROUP_SUM',

3382: END IF;
3383:
3384: -- Delete the rows from summary table for the date range specified
3385:
3386: DELETE_IN_CHUNKS('BIX_DM_GROUP_SUM',
3387: 'period_start_date_time BETWEEN '||' to_date('||
3388: ''''||
3389: to_char(g_min_call_begin_date,'YYYY/MM/DDHH24:MI:SS')||
3390: ''''||

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

3400: COMMIT;
3401:
3402: IF (g_debug_flag = 'Y') THEN
3403:
3404: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP: '||' Finished Deleting rows in BIX_DM_GROUP_SUM table: ' || 'Row Count:' || g_delete_count, g_proc_name);
3405:
3406: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'BIX_DM_AGENT_CALL_SUMMARY_PKG.AGENT_SUM: '||' Start inserting rows into BIX_DM_AGENT_SUM table: ', g_proc_name);
3407:
3408: END IF;

Line 3414: SELECT BIX_DM_GROUP_SUM_S.NEXTVAL INTO l_bix_group_seq FROM DUAL;

3410:
3411: for gr_row in group_data LOOP
3412:
3413:
3414: SELECT BIX_DM_GROUP_SUM_S.NEXTVAL INTO l_bix_group_seq FROM DUAL;
3415:
3416: INSERT INTO BIX_DM_GROUP_SUM
3417: (
3418: GROUP_SUMMARY_ID,

Line 3416: INSERT INTO BIX_DM_GROUP_SUM

3412:
3413:
3414: SELECT BIX_DM_GROUP_SUM_S.NEXTVAL INTO l_bix_group_seq FROM DUAL;
3415:
3416: INSERT INTO BIX_DM_GROUP_SUM
3417: (
3418: GROUP_SUMMARY_ID,
3419: LAST_UPDATE_DATE,
3420: LAST_UPDATED_BY,

Line 3566: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_GROUP: '|| ' Failed to Rolled back data in BIX_DM_GROUP_SUM table ', g_proc_name);

3562: WHEN OTHERS THEN
3563:
3564: IF (g_debug_flag = 'Y') THEN
3565:
3566: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||' BIX_DM_AGENT_SUMMARY_PKG.SUM_GROUP: '|| ' Failed to Rolled back data in BIX_DM_GROUP_SUM table ', g_proc_name);
3567:
3568: END IF;
3569:
3570: g_proc_name := 'BIX_DM_AGENT_CALL_SUMMARY_PKG.SUM_GROUP';

Line 4330: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|

4326: | COLLECT_CALLS_SUMMARY procedure is main procedure calls other procedures to collect the data |
4327: | The following procedures are invoked from this procedure to collect the data. |
4328: | 1. GET_CALLS : Which populates the BIX_DM_INTERFACE staging table |
4329: | 2. AGENT_SUM : Summarizes agent data and inserts it into the BIX_DM_AGENT_SUM table |
4330: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|
4331: | 4. BIX_POP_AO_SUM_PKG.populate: Summarizes adv. outbound data and inserts it into the BIX_DM_AO_SUM tbl |
4332: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |
4333: | |
4334: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |

Line 4470: g_table_name := 'BIX_DM_GROUP_SUM';

4466: /* Procedure collects all the calls information for the GROUP data */
4467:
4468: SUM_GROUP;
4469: g_status := 'SUCCESS';
4470: g_table_name := 'BIX_DM_GROUP_SUM';
4471: insert_log;
4472:
4473: /* Procedure collects all the calls information for the GROUP data */
4474:

Line 4550: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|

4546: | COLLECT_CALLS_SUMMARY procedure is main procedure calls other procedures to collect the data |
4547: | The following procedures are invoked from this procedure to collect the data. |
4548: | 1. GET_CALLS : Which populates the BIX_DM_INTERFACE staging table |
4549: | 2. AGENT_SUM : Summarizes agent data and inserts it into the BIX_DM_AGENT_SUM table |
4550: | 3. GROUP_SUM : Summarizes agent group data and inserts it into the BIX_DM_GROUP_SUM table|
4551: | 4. BIX_POP_AO_SUM_PKG.populate: Summarizes adv. outbound data and inserts it into the BIX_DM_AO_SUM tbl |
4552: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |
4553: | |
4554: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |

Line 4694: g_table_name := 'BIX_DM_GROUP_SUM';

4690: /* Procedure collects all the calls information for the GROUP data */
4691:
4692: SUM_GROUP;
4693: g_status := 'SUCCESS';
4694: g_table_name := 'BIX_DM_GROUP_SUM';
4695: insert_log;
4696:
4697: /* Procedure collects all the calls information for the CALL data */
4698: