APPS.CE_HEADER_INTERFACE_ERRORS_PKG SQL Statements

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

Line: 18

  PROCEDURE Insert_Row( X_statement_number	 VARCHAR2,
		       X_bank_account_num	 VARCHAR2,
		       X_message_name	         VARCHAR2) IS
   BEGIN
     INSERT INTO CE_HEADER_INTERFACE_ERRORS(
	      application_short_name,
              statement_number,
              bank_account_num,
              message_name,
              creation_date,
              created_by)
              VALUES ('CE',
              NVL(X_statement_number,'NONE'),
              NVL(X_bank_account_num,'NONE'),
              NVL(X_message_name,'NONE'),
	      sysdate,
	      NVL(FND_GLOBAL.user_id,-1));

Line: 35

  END Insert_Row;

Line: 37

  PROCEDURE Insert_Row( X_statement_number	 VARCHAR2,
		       X_bank_account_num	 VARCHAR2,
		       X_message_name	         VARCHAR2,
		       x_application_short_name  VARCHAR2) IS
   BEGIN
     INSERT INTO CE_HEADER_INTERFACE_ERRORS(
	      application_short_name,
              statement_number,
              bank_account_num,
              message_name,
              creation_date,
              created_by)
              VALUES (NVL(X_application_short_name,'NONE'),
              NVL(X_statement_number,'NONE'),
              NVL(X_bank_account_num,'NONE'),
              NVL(X_message_name,'NONE'),
	      sysdate,
	      NVL(FND_GLOBAL.user_id,-1));

Line: 55

  END Insert_Row;

Line: 57

  PROCEDURE Delete_Row(X_statement_number VARCHAR2,
		       X_bank_account_num VARCHAR2) IS
  BEGIN
    DELETE FROM CE_HEADER_INTERFACE_ERRORS
    WHERE statement_number  = X_statement_number AND
	  ((bank_account_num  = X_bank_account_num) OR
	   (bank_account_num = 'NONE'));

Line: 64

  END Delete_Row;