APPS.CE_RECONCILIATION_ERRORS_PKG SQL Statements

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

Line: 17

  PROCEDURE Insert_Row(X_statement_header_id     NUMBER,
		       X_statement_line_id	 NUMBER,
		       X_message_name	         VARCHAR2) IS
   BEGIN
     INSERT INTO CE_RECONCILIATION_ERRORS(
	      application_short_name,
 	      statement_header_id,
              statement_line_id,
              message_name,
              creation_date,
              created_by)
              VALUES (
	      'CE',
 	      X_statement_header_id,
              X_statement_line_id,
              X_message_name,
	      sysdate,
	      NVL(FND_GLOBAL.user_id,-1));

Line: 35

  END Insert_Row;

Line: 37

  PROCEDURE Insert_Row(X_statement_header_id     NUMBER,
		       X_statement_line_id	 NUMBER,
		       X_message_name	         VARCHAR2,
		       X_application_short_name	 VARCHAR2) IS
   BEGIN
     INSERT INTO CE_RECONCILIATION_ERRORS(
	      application_short_name,
              statement_header_id,
              statement_line_id,
              message_name,
              creation_date,
              created_by)
              VALUES (
	      X_application_short_name,
	      X_statement_header_id,
              X_statement_line_id,
              X_message_name,
	      sysdate,
	      NVL(FND_GLOBAL.user_id,-1));

Line: 56

  END Insert_Row;

Line: 58

  PROCEDURE Delete_Row(X_statement_header_id    NUMBER,
		       X_statement_line_id      NUMBER) IS
  BEGIN
    DELETE FROM CE_RECONCILIATION_ERRORS
    WHERE nvl(statement_line_id,999999)  = nvl(X_statement_line_id,999999)
    AND   statement_header_id = X_statement_header_id;

Line: 64

  END Delete_Row;