APPS.CN_MESSAGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 133

    INSERT INTO cn_process_audit_lines_all
	  ( process_audit_id
	   ,process_audit_line_id
	   ,message_text
	   ,message_type_code
       ,org_id)
    VALUES( g_process_audit_id
	   ,cn_process_audit_lines_s1.nextval
	   ,substrb(x_message_text,1, 239)
	   ,x_message_type
       ,g_org_id)
    ;

Line: 148

    	rollback_errormsg_commit('cn_message.insert_audit_line');

Line: 252

   SELECT cn_process_audits_s.nextval
     INTO g_process_audit_id
     FROM sys.dual;

Line: 258

   INSERT INTO cn_process_audits_all
	(  process_audit_id
	  ,parent_process_audit_id
	  ,concurrent_request_id
	  ,process_type
	  ,timestamp_start
      ,org_id)
   VALUES( x_process_audit_id
	  ,nvl(x_parent_proc_audit_id,x_process_audit_id)
	  ,x_request_id
  	  ,x_process_type
	  ,sysdate
      ,g_org_id) ;

Line: 278

        rollback_errormsg_commit('cn_message.insert_audit_batch');

Line: 477

       SELECT CN_PROCESS_AUDIT_LINES_S1.NEXTVAL
	 INTO seq_key(i)  FROM dual;

Line: 482

      INSERT INTO cn_process_audit_lines
      ( process_audit_id
	,process_audit_line_id
	,message_text
	,message_type_code
	,creation_date
    ,org_id)
      VALUES( g_process_audit_id
	      ,seq_key(i)
	      ,substrb(g_msg_stack(i),1, 239)
	      ,g_msg_type_stack(i)
	      ,g_msg_date_stack(i)
          ,g_org_id);

Line: 514

       debug('cn_message.insert_audit_line : '||SQLCODE||SQLERRM);

Line: 530

  UPDATE cn_process_audits_all
    SET timestamp_end 	  = sysdate
    WHERE process_audit_id = x_process_audit_id;

Line: 593

     DELETE FROM cn_process_audit_lines_all
     WHERE  process_audit_id = x_process_audit_id;

Line: 596

     DELETE FROM cn_process_audits_all
     WHERE  process_audit_id = x_process_audit_id;

Line: 600

     DELETE FROM cn_process_audit_lines
     WHERE  creation_date <= x_creation_date;

Line: 603

     DELETE FROM cn_process_audits
     WHERE  creation_date <= x_creation_date;