APPS.BIX_SESSION_LOAD_PKG dependencies on BIX_SESSIONS

Line 114: Truncate_Table('BIX_SESSIONS');

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:
118: write_log('Setting the sort and hash are size');

Line 137: Truncate_Table('BIX_SESSIONS');

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'));
141: EXCEPTION

Line 880: INSERT /*+ append */ INTO bix_sessions bis1 (

876: write_log('Total rows inserted in the staging area for half hour time bucket : ' || to_char(l_agent_id.COUNT));
877:
878: IF (l_session_id.COUNT > 0) THEN
879: FORALL i IN l_session_id.FIRST .. l_session_id.LAST
880: INSERT /*+ append */ INTO bix_sessions bis1 (
881: bis1.session_id,
882: bis1.created_by,
883: bis1.creation_date,
884: bis1.last_updated_by,