DBA Data[Home] [Help]

APPS.CZ_POPULATORS_PKG dependencies on CZ_DB_LOGS

Line 65: INSERT INTO CZ_DB_LOGS

61: var_error BOOLEAN;
62: var_status INTEGER;
63: BEGIN
64: var_status:=11276;
65: INSERT INTO CZ_DB_LOGS
66: (RUN_ID,
67: LOGTIME,
68: LOGUSER,
69: URGENCY,

Line 88: -- this method add log message to the CZ_DB_LOGS table

84: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
85: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
86:
87: --
88: -- this method add log message to the CZ_DB_LOGS table
89: --
90: PROCEDURE SECURITY_REPORT
91: (p_run_id IN VARCHAR2,
92: p_count IN NUMBER DEFAULT NULL) IS

Line 99: INSERT INTO CZ_DB_LOGS

95: IF (p_count>0) THEN
96: FOR i IN 1..p_count
97: LOOP
98: mCOUNTER:=mCOUNTER+1;
99: INSERT INTO CZ_DB_LOGS
100: (RUN_ID,
101: LOGTIME,
102: LOGUSER,
103: URGENCY,

Line 1489: -- just one CZ_DB_LOGS.run_id should be used by Developer

1485: END;
1486: END LOOP;
1487:
1488: --
1489: -- just one CZ_DB_LOGS.run_id should be used by Developer
1490: --
1491: IF t_errors.Count>0 THEN
1492: FORALL i IN 1..t_errors.Count
1493: UPDATE CZ_DB_LOGS SET run_id=mRUN_ID

Line 1493: UPDATE CZ_DB_LOGS SET run_id=mRUN_ID

1489: -- just one CZ_DB_LOGS.run_id should be used by Developer
1490: --
1491: IF t_errors.Count>0 THEN
1492: FORALL i IN 1..t_errors.Count
1493: UPDATE CZ_DB_LOGS SET run_id=mRUN_ID
1494: WHERE run_id=t_errors(i);
1495: p_err:=var_err_id;
1496: END IF;
1497: