APPS.CN_MESSAGE_PKG dependencies on CN_PROCESS_AUDITS

Line 252: SELECT cn_process_audits_s.nextval

248: IS
249: PRAGMA AUTONOMOUS_TRANSACTION;
250: BEGIN
251:
252: SELECT cn_process_audits_s.nextval
253: INTO g_process_audit_id
254: FROM sys.dual;
255:
256: x_process_audit_id := g_process_audit_id;

Line 258: INSERT INTO cn_process_audits_all

254: FROM sys.dual;
255:
256: x_process_audit_id := g_process_audit_id;
257:
258: INSERT INTO cn_process_audits_all
259: ( process_audit_id
260: ,parent_process_audit_id
261: ,concurrent_request_id
262: ,process_type

Line 530: UPDATE cn_process_audits_all

526: PRAGMA AUTONOMOUS_TRANSACTION;
527: BEGIN
528: flush;
529:
530: UPDATE cn_process_audits_all
531: SET timestamp_end = sysdate
532: WHERE process_audit_id = x_process_audit_id;
533:
534: close_file;

Line 596: DELETE FROM cn_process_audits_all

592: IF x_process_audit_id IS NOT NULL THEN
593: DELETE FROM cn_process_audit_lines_all
594: WHERE process_audit_id = x_process_audit_id;
595:
596: DELETE FROM cn_process_audits_all
597: WHERE process_audit_id = x_process_audit_id;
598:
599: ELSIF x_creation_date IS NOT NULL THEN
600: DELETE FROM cn_process_audit_lines

Line 603: DELETE FROM cn_process_audits

599: ELSIF x_creation_date IS NOT NULL THEN
600: DELETE FROM cn_process_audit_lines
601: WHERE creation_date <= x_creation_date;
602:
603: DELETE FROM cn_process_audits
604: WHERE creation_date <= x_creation_date;
605: END IF;
606:
607: END purge;