APPS.CN_MESSAGE_PKG dependencies on CN_PROCESS_AUDIT_LINES

Line 133: INSERT INTO cn_process_audit_lines_all

129: PROCEDURE ins_audit_line( x_message_text VARCHAR2
130: ,x_message_type VARCHAR2) IS
131: BEGIN
132:
133: INSERT INTO cn_process_audit_lines_all
134: ( process_audit_id
135: ,process_audit_line_id
136: ,message_text
137: ,message_type_code

Line 140: ,cn_process_audit_lines_s1.nextval

136: ,message_text
137: ,message_type_code
138: ,org_id)
139: VALUES( g_process_audit_id
140: ,cn_process_audit_lines_s1.nextval
141: ,substrb(x_message_text,1, 239)
142: ,x_message_type
143: ,g_org_id)
144: ;

Line 477: SELECT CN_PROCESS_AUDIT_LINES_S1.NEXTVAL

473:
474: BEGIN
475: -- Build sequence collection
476: FOR i IN 1 .. g_msg_count LOOP
477: SELECT CN_PROCESS_AUDIT_LINES_S1.NEXTVAL
478: INTO seq_key(i) FROM dual;
479: END LOOP;
480:
481: forall i IN 1 .. g_msg_count

Line 482: INSERT INTO cn_process_audit_lines

478: INTO seq_key(i) FROM dual;
479: END LOOP;
480:
481: forall i IN 1 .. g_msg_count
482: INSERT INTO cn_process_audit_lines
483: ( process_audit_id
484: ,process_audit_line_id
485: ,message_text
486: ,message_type_code

Line 593: DELETE FROM cn_process_audit_lines_all

589: PROCEDURE purge( x_process_audit_id NUMBER
590: ,x_creation_date DATE) IS
591: BEGIN
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;

Line 600: DELETE FROM cn_process_audit_lines

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
601: WHERE creation_date <= x_creation_date;
602:
603: DELETE FROM cn_process_audits
604: WHERE creation_date <= x_creation_date;