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_SESSION_LOAD_PKG dependencies on BIX_AGENT_SESSION_F

Line 67: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_AGENT_SESSION_F') = FALSE) THEN

63: l_status VARCHAR2(30);
64: l_industry VARCHAR2(30);
65: BEGIN
66:
67: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_AGENT_SESSION_F') = FALSE) THEN
68: RAISE_APPLICATION_ERROR(-20000, 'BIS_COLLECTION_UTILITIES.setup has failed');
69: END IF;
70:
71: write_log('Start of the procedure init at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));

Line 112: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_AGENT_SESSION_F');

108: END IF;
109: write_log('BIX Schema : ' || g_bix_schema);
110:
111: write_log('Truncating tables');
112: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_AGENT_SESSION_F');
113: Truncate_Table('BIX_AGENT_SESSION_F');
114: Truncate_Table('BIX_SESSIONS');
115: Truncate_Table('BIX_AGENT_SESSION_STG');
116:

Line 113: Truncate_Table('BIX_AGENT_SESSION_F');

109: write_log('BIX Schema : ' || g_bix_schema);
110:
111: write_log('Truncating tables');
112: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_AGENT_SESSION_F');
113: Truncate_Table('BIX_AGENT_SESSION_F');
114: Truncate_Table('BIX_SESSIONS');
115: Truncate_Table('BIX_AGENT_SESSION_STG');
116:
117:

Line 135: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_AGENT_SESSION_F');

131: BEGIN
132: write_log('Start of the procedure clean_up at ' || to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));
133:
134: write_log('Truncating the tables');
135: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_AGENT_SESSION_F');
136: Truncate_Table('BIX_AGENT_SESSION_F');
137: Truncate_Table('BIX_SESSIONS');
138: Truncate_Table('BIX_AGENT_SESSION_STG');
139:

Line 136: Truncate_Table('BIX_AGENT_SESSION_F');

132: write_log('Start of the procedure clean_up at ' || to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));
133:
134: write_log('Truncating the tables');
135: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_AGENT_SESSION_F');
136: Truncate_Table('BIX_AGENT_SESSION_F');
137: Truncate_Table('BIX_SESSIONS');
138: Truncate_Table('BIX_AGENT_SESSION_STG');
139:
140: write_log('Finished procedure clean_up at ' || to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));

Line 223: TYPE available_time_tab is TABLE OF bix_agent_session_f.available_time%TYPE;

219: p_application_id in g_application_id_tab,
220: p_schedule_id in g_schedule_id_tab,
221: p_campaign_id in g_campaign_id_tab)
222: IS
223: TYPE available_time_tab is TABLE OF bix_agent_session_f.available_time%TYPE;
224:
225: l_agent_id g_resource_id_tab;
226: l_period_start_date g_begin_date_time_tab;
227: l_available_time available_time_tab;

Line 479: TYPE work_time_tab is TABLE OF bix_agent_session_f.work_time%TYPE;

475: p_application_id in g_application_id_tab,
476: p_schedule_id in g_schedule_id_tab,
477: p_campaign_id in g_campaign_id_tab)
478: IS
479: TYPE work_time_tab is TABLE OF bix_agent_session_f.work_time%TYPE;
480:
481: l_agent_id g_resource_id_tab;
482: l_period_start_date g_begin_date_time_tab;
483: l_work_time work_time_tab;

Line 735: TYPE login_time_tab is TABLE OF bix_agent_session_f.login_time%TYPE;

731: p_session_end_date in g_end_date_time_tab,
732: p_server_group_id in g_server_group_id_tab,
733: p_application_id in g_application_id_tab)
734: IS
735: TYPE login_time_tab is TABLE OF bix_agent_session_f.login_time%TYPE;
736: TYPE session_id_tab is TABLE OF ieu_sh_sessions.session_id%TYPE;
737: TYPE collect_date_tab is TABLE OF ieu_sh_sessions.end_date_time%TYPE;
738:
739: l_agent_id g_resource_id_tab;

Line 1062: /* Move the data from the staging area to the summary table bix_agent_session_f */

1058: BEGIN
1059:
1060: write_log('Start of the procedure merge_data at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1061:
1062: /* Move the data from the staging area to the summary table bix_agent_session_f */
1063: INSERT /*+ append parallel(bas) */ INTO bix_agent_session_f bas
1064: (bas.agent_id,
1065: bas.server_group_id,
1066: bas.schedule_id,

Line 1063: INSERT /+ append parallel(bas) / INTO bix_agent_session_f bas

1059:
1060: write_log('Start of the procedure merge_data at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1061:
1062: /* Move the data from the staging area to the summary table bix_agent_session_f */
1063: INSERT /*+ append parallel(bas) */ INTO bix_agent_session_f bas
1064: (bas.agent_id,
1065: bas.server_group_id,
1066: bas.schedule_id,
1067: bas.campaign_id,

Line 1126: write_log('Total rows merged in bix_agent_session_f : ' || to_char(g_rows_ins_upd));

1122: bstg.period_start_time,
1123: bstg.day_of_week);
1124:
1125: g_rows_ins_upd := g_rows_ins_upd + SQL%ROWCOUNT;
1126: write_log('Total rows merged in bix_agent_session_f : ' || to_char(g_rows_ins_upd));
1127:
1128: COMMIT;
1129:
1130: write_log('Finished procedure merge_data at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));

Line 1178: INSERT /+ APPEND PARALLEL(bea) / INTO BIX_AGENT_SESSION_F bea

1174:
1175: /* Rollup the half-hour information to day, week, month, quarter and year time bucket */
1176: /* An outer query is necessary after rolling up to day, week, month, quarter and year */
1177: /* as rollup function produces two rows for weeks spanning two months */
1178: INSERT /*+ APPEND PARALLEL(bea) */ INTO BIX_AGENT_SESSION_F bea
1179: (bea.agent_id,
1180: bea.server_group_id,
1181: bea.schedule_id,
1182: bea.campaign_id,

Line 1248: FROM BIX_AGENT_SESSION_F bes,

1244: sum(bes.work_time) work_time,
1245: sum(bes.available_time) available_time,
1246: sum(bes.idle_time) idle_time,
1247: sum(bes.agent_cost) agent_cost
1248: FROM BIX_AGENT_SESSION_F bes,
1249: fii_time_day ftd
1250: WHERE bes.time_id = ftd.report_date_julian
1251: AND bes.period_type_id = 1
1252: GROUP BY

Line 1282: write_log('Total rows inserted after rolling up in BIX_AGENT_SESSION_F : ' || to_char(g_rows_ins_upd));

1278: g_rows_ins_upd := g_rows_ins_upd + SQL%ROWCOUNT;
1279:
1280: COMMIT;
1281:
1282: write_log('Total rows inserted after rolling up in BIX_AGENT_SESSION_F : ' || to_char(g_rows_ins_upd));
1283:
1284: write_log('Finished procedure summarize_data at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1285: EXCEPTION
1286: WHEN OTHERS THEN