DBA Data[Home] [Help]

APPS.CZ_POPULATORS_PKG dependencies on CZ_DB_LOGS

Line 62: INSERT INTO CZ_DB_LOGS

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

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

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

Line 96: INSERT INTO CZ_DB_LOGS

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

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

1459: END;
1460: END LOOP;
1461:
1462: --
1463: -- just one CZ_DB_LOGS.run_id should be used by Developer
1464: --
1465: IF t_errors.Count>0 THEN
1466: FORALL i IN 1..t_errors.Count
1467: UPDATE CZ_DB_LOGS SET run_id=mRUN_ID

Line 1467: UPDATE CZ_DB_LOGS SET run_id=mRUN_ID

1463: -- just one CZ_DB_LOGS.run_id should be used by Developer
1464: --
1465: IF t_errors.Count>0 THEN
1466: FORALL i IN 1..t_errors.Count
1467: UPDATE CZ_DB_LOGS SET run_id=mRUN_ID
1468: WHERE run_id=t_errors(i);
1469: p_err:=var_err_id;
1470: END IF;
1471: