APPS.BIX_DM_SESSIONINFO_SUMMARY_PKG dependencies on BIX_DM_COLLECT_LOG

Line 50: INSERT INTO BIX_DM_COLLECT_LOG

46: l_proc_name VARCHAR2(20) := 'INSERT_LOG_TABLE';
47: BEGIN
48:
49: /* Insert status into log table */
50: INSERT INTO BIX_DM_COLLECT_LOG
51: (
52: collect_id,
53: collect_concur_id,
54: object_name,

Line 77: BIX_DM_COLLECT_LOG_S.NEXTVAL,

73: program_update_date
74: )
75: VALUES
76: (
77: BIX_DM_COLLECT_LOG_S.NEXTVAL,
78: null,
79: g_table_name,
80: 'TABLE',
81: g_run_start_date,

Line 825: UPDATE BIX_DM_COLLECT_LOG

821: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSION_SUM table ';
822: write_log(g_pkg_name, l_proc_name, g_message );
823: END;
824:
825: UPDATE BIX_DM_COLLECT_LOG
826: SET collect_status = 'FAILURE',
827: rows_inserted = 0,
828: rows_updated = 0,
829: collect_excep_mesg = g_error_msg

Line 862: /* Insert the status into BIX_DM_COLLECT_LOG table */

858: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS
859: ,IEU_SH_ACTIVITIES tables */
860: collect_agent_avail_time;
861:
862: /* Insert the status into BIX_DM_COLLECT_LOG table */
863: g_run_end_date := sysdate;
864: g_status := 'SUCCESS';
865: insert_log_table;
866: