DBA Data[Home] [Help]

APPS.BIX_UWQ_SUMMARY_PKG dependencies on BIX_DM_COLLECT_LOG

Line 172: DELETE FROM bix_dm_collect_log

168: END IF;
169:
170: END LOOP;
171:
172: DELETE FROM bix_dm_collect_log
173: WHERE last_update_date >= v_sysdate;
174:
175: COMMIT;
176:

Line 837: --This procedure performs inserts into the BIX_DM_COLLECT_LOG table

833: END write_log;
834:
835: PROCEDURE insert_log_table
836: --
837: --This procedure performs inserts into the BIX_DM_COLLECT_LOG table
838: --so that statistics about the collection run can be stored.
839: --
840: IS
841: BEGIN

Line 845: INSERT INTO BIX_DM_COLLECT_LOG

841: BEGIN
842:
843: v_proc_name := 'insert_log_table';
844:
845: INSERT INTO BIX_DM_COLLECT_LOG
846: (
847: COLLECT_ID,
848: COLLECT_CONCUR_ID,
849: OBJECT_NAME,

Line 871: BIX_DM_COLLECT_LOG_S.NEXTVAL,

867: PROGRAM_UPDATE_DATE
868: )
869: VALUES
870: (
871: BIX_DM_COLLECT_LOG_S.NEXTVAL,
872: NULL,
873: v_table_name,
874: 'TABLE',
875: v_run_start_date,