DBA Data[Home] [Help]

APPS.CZ_BASE_MGR dependencies on CZ_DB_LOGS

Line 148: insert into cz_db_logs (caller, message, logtime) values ('cz_base_mgr', 'exec_it failure: '|| p_table_name, sysdate);

144: );
145:
146: EXCEPTION
147: WHEN OTHERS THEN
148: insert into cz_db_logs (caller, message, logtime) values ('cz_base_mgr', 'exec_it failure: '|| p_table_name, sysdate);
149: raise;
150: END exec_it;
151:
152: PROCEDURE exec

Line 286: select nvl(max(run_id), 0) into db_logs_run_id from cz_db_logs;

282: if (TableName = 'CZ_XFR_RUN_INFOS') then
283: declare
284: db_logs_run_id integer;
285: begin
286: select nvl(max(run_id), 0) into db_logs_run_id from cz_db_logs;
287: if (db_logs_run_id > var_key) then
288: var_key := db_logs_run_id;
289: end if;
290: end;

Line 619: ,'CZ_DB_LOGS'

615: for i in Tables.First..Tables.Last loop
616: begin
617:
618: if Tables(i).name IN ( 'CZ_ATP_REQUESTS'
619: ,'CZ_DB_LOGS'
620: ,'CZ_DB_SETTINGS'
621: ,'CZ_DB_SIZES'
622: ,'CZ_DES_CHART_COLUMNS'
623: ,'CZ_EXP_TMP_LINES'

Line 881: INSERT INTO cz_db_logs (logtime, caller, message, loguser, message_id, run_id)

877: inRunId IN NUMBER DEFAULT NULL) IS
878:
879: PRAGMA AUTONOMOUS_TRANSACTION;
880: BEGIN
881: INSERT INTO cz_db_logs (logtime, caller, message, loguser, message_id, run_id)
882: VALUES (sysdate, inCaller, inMessage, inTableName, inMessageId, inRunId);
883:
884: COMMIT;
885: END;

Line 952: Tables(1).name:='CZ_DB_LOGS';Tables(1).pk_name:=null;

948: Tables(8).name:='CZ_PB_LANGUAGES'; Tables(8).pk_name:=NULL;
949: end if;
950:
951: if upper(SubSchema)='GN' then
952: Tables(1).name:='CZ_DB_LOGS';Tables(1).pk_name:=null;
953: Tables(2).name:='CZ_DB_SETTINGS';Tables(2).pk_name:=null;
954: end if;
955:
956: if upper(SubSchema)='XF' then