1: PACKAGE BODY BIX_SESSION_LOAD_PKG AS
2: /*$Header: bixagtlb.plb 120.1 2006/03/28 22:34:53 pubalasu noship $ */
3:
4: g_request_id NUMBER;
5: g_program_appl_id NUMBER;
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');
1432: bis_collection_utilities.wrapup(
1433: p_status => TRUE,
1479: WHEN OTHERS THEN
1480: RAISE;
1481: END load;
1482:
1483: END BIX_SESSION_LOAD_PKG;