APPS.BIX_SESSION_LOAD_PKG dependencies on BIX_AGENT_SESSION_STG

Line 115: Truncate_Table('BIX_AGENT_SESSION_STG');

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:
118: write_log('Setting the sort and hash are size');
119: execute immediate 'alter session set sort_area_size=1048576000';

Line 138: Truncate_Table('BIX_AGENT_SESSION_STG');

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'));
141: EXCEPTION
142: WHEN OTHERS THEN

Line 152: INSERT /*+ append parallel(bss) */ INTO bix_agent_session_stg bss

148: BEGIN
149:
150: write_log('Start of the procedure collect_idle_time at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
151:
152: INSERT /*+ append parallel(bss) */ INTO bix_agent_session_stg bss
153: (bss.agent_id,
154: bss.server_group_id,
155: bss.schedule_id,
156: bss.campaign_id,

Line 193: FROM bix_agent_session_stg bas

189: g_request_id,
190: g_program_appl_id,
191: g_program_id,
192: g_sysdate
193: FROM bix_agent_session_stg bas
194: WHERE bas.application_id = 696
195: GROUP BY
196: bas.agent_id,
197: bas.server_group_id,

Line 313: INSERT /*+ append */ INTO bix_agent_session_stg bas (

309:
310: /* Bulk insert all the rows in the staging area */
311: IF (l_agent_id.COUNT > 0) THEN
312: FORALL i IN l_agent_id.FIRST .. l_agent_id.LAST
313: INSERT /*+ append */ INTO bix_agent_session_stg bas (
314: bas.agent_id
315: ,bas.server_group_id
316: ,bas.schedule_id
317: ,bas.campaign_id

Line 569: INSERT /*+ append */ INTO bix_agent_session_stg bas (

565:
566: /* Bulk insert all the rows in the staging area */
567: IF (l_agent_id.COUNT > 0) THEN
568: FORALL i IN l_agent_id.FIRST .. l_agent_id.LAST
569: INSERT /*+ append */ INTO bix_agent_session_stg bas (
570: bas.agent_id
571: ,bas.server_group_id
572: ,bas.schedule_id
573: ,bas.campaign_id

Line 832: INSERT /*+ append */ INTO bix_agent_session_stg bas (

828:
829: /* Bulk insert all the rows in the staging area */
830: IF (l_agent_id.COUNT > 0) THEN
831: FORALL i IN l_agent_id.FIRST .. l_agent_id.LAST
832: INSERT /*+ append */ INTO bix_agent_session_stg bas (
833: bas.agent_id
834: ,bas.server_group_id
835: ,bas.schedule_id
836: ,bas.campaign_id

Line 1112: FROM bix_agent_session_stg bstg

1108: g_request_id,
1109: g_program_appl_id,
1110: g_program_id,
1111: g_sysdate
1112: FROM bix_agent_session_stg bstg
1113: GROUP BY
1114: bstg.agent_id,
1115: bstg.server_group_id,
1116: bstg.schedule_id,

Line 1425: write_log('Truncating the table bix_agent_session_stg');

1421: write_log('Calling procedure summarize_data');
1422: summarize_data;
1423: write_log('End procedure summarize_data');
1424:
1425: write_log('Truncating the table bix_agent_session_stg');
1426: Truncate_Table('BIX_AGENT_SESSION_STG');
1427: write_log('Done truncating the table bix_agent_session_stg');
1428:
1429: write_log('Finished Procedure BIX_SESSION_LOAD_PKG with success at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));

Line 1426: Truncate_Table('BIX_AGENT_SESSION_STG');

1422: summarize_data;
1423: write_log('End procedure summarize_data');
1424:
1425: write_log('Truncating the table bix_agent_session_stg');
1426: Truncate_Table('BIX_AGENT_SESSION_STG');
1427: write_log('Done truncating the table bix_agent_session_stg');
1428:
1429: write_log('Finished Procedure BIX_SESSION_LOAD_PKG with success at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1430:

Line 1427: write_log('Done truncating the table bix_agent_session_stg');

1423: write_log('End procedure summarize_data');
1424:
1425: write_log('Truncating the table bix_agent_session_stg');
1426: Truncate_Table('BIX_AGENT_SESSION_STG');
1427: write_log('Done truncating the table bix_agent_session_stg');
1428:
1429: write_log('Finished Procedure BIX_SESSION_LOAD_PKG with success at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1430:
1431: write_log('Calling procedure WRAPUP');