APPS.CE_LINE_INTERFACE_ERRORS_PKG SQL Statements

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

Line: 17

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
  		       X_statement_number	 VARCHAR2,
		       X_bank_account_num	 VARCHAR2,
		       X_line_number		 NUMBER,
		       X_message_name	         VARCHAR2) IS
   BEGIN
     INSERT INTO CE_LINE_INTERFACE_ERRORS(
	      application_short_name,
              statement_number,
              bank_account_num,
	      line_number,
              message_name,
              creation_date,
              created_by)
              VALUES (
	      'CE',
              X_statement_number,
              X_bank_account_num,
	      X_line_number,
              X_message_name,
	      sysdate,
	      NVL(FND_GLOBAL.user_id,-1));

Line: 39

  END Insert_Row;

Line: 41

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
  		       X_statement_number	 VARCHAR2,
		       X_bank_account_num	 VARCHAR2,
		       X_line_number		 NUMBER,
		       X_message_name	         VARCHAR2,
		       X_application_short_name  VARCHAR2) IS
   BEGIN
     INSERT INTO CE_LINE_INTERFACE_ERRORS(
	      application_short_name,
              statement_number,
              bank_account_num,
	      line_number,
              message_name,
              creation_date,
              created_by)
              VALUES (
	      X_application_short_name,
              X_statement_number,
              X_bank_account_num,
	      X_line_number,
              X_message_name,
	      sysdate,
	      NVL(FND_GLOBAL.user_id,-1));

Line: 64

  END Insert_Row;

Line: 66

  PROCEDURE Delete_Row(X_statement_number VARCHAR2,
		       X_bank_account_num VARCHAR2,
		       X_line_number	  NUMBER) IS
  BEGIN
    IF (X_line_number IS NOT NULL) THEN
      DELETE FROM CE_LINE_INTERFACE_ERRORS
      WHERE statement_number  = X_statement_number AND
	    bank_account_num  = X_bank_account_num AND
	    line_number	      = X_line_number;

Line: 76

      DELETE FROM CE_LINE_INTERFACE_ERRORS
      WHERE statement_number  = X_statement_number AND
	    bank_account_num  = X_bank_account_num;

Line: 80

  END Delete_Row;