APPS.BIX_DM_SESSBYCAMP_PKG dependencies on BIX_DM_COLLECT_LOG

Line 49: INSERT INTO BIX_DM_COLLECT_LOG

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

Line 76: BIX_DM_COLLECT_LOG_S.NEXTVAL,

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

Line 727: UPDATE BIX_DM_COLLECT_LOG

723: g_message := 'Failed to roll back data in BIX_DM_AGENT_SESSBYCAMP_SUM table ';
724: write_log(g_pkg_name, l_proc_name, g_message );
725: END;
726:
727: UPDATE BIX_DM_COLLECT_LOG
728: SET collect_status = 'FAILURE',
729: rows_inserted = 0,
730: rows_updated = 0,
731: collect_excep_mesg = g_error_msg

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

760: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS
761: ,IEU_SH_ACTIVITIES tables */
762: collect_agent_avail_time;
763:
764: /* Insert the status into BIX_DM_COLLECT_LOG table */
765: g_run_end_date := sysdate;
766: g_status := 'SUCCESS';
767: insert_log_table;
768: