APPS.GR_DOC_HDR_FTR_PKG SQL Statements

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

Line: 3

PROCEDURE Insert_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_line_type IN NUMBER,
				  p_line_no IN NUMBER,
				  p_left_label_code IN VARCHAR2,
				  p_right_label_code IN VARCHAR2,
				  p_created_by IN NUMBER,
				  p_creation_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  p_last_update_date IN DATE,
				  p_last_update_login IN NUMBER,
				  x_rowid OUT NOCOPY VARCHAR2,
				  x_return_status OUT NOCOPY VARCHAR2,
				  x_oracle_error OUT NOCOPY NUMBER,
				  x_msg_data OUT NOCOPY VARCHAR2)
	IS

/*   Alpha Variables */

L_RETURN_STATUS VARCHAR2(1) := 'S';

Line: 45

   SAVEPOINT Insert_Row;

Line: 80

   INSERT INTO gr_doc_hdr_ftr
  	     (document_code,
	      line_type,
	      line_no,
	      left_label_code,
	      right_label_code,
	      created_by,
	      creation_date,
	      last_updated_by,
	      last_update_date,
	      last_update_login)
          VALUES
	     (p_document_code,
 	      p_line_type,
	      p_line_no,
	      p_left_label_code,
	      p_right_label_code,
              p_created_by,
              p_creation_date,
              p_last_updated_by,
              p_last_update_date,
              p_last_update_login);

Line: 103

/*   Now get the row id of the inserted record */

   Check_Primary_Key
    	 (p_document_code,
	  p_line_type,
	  p_line_no,
	  p_left_label_code,
	  p_right_label_code,
	  'F',
	  l_rowid,
	  l_key_exists);

Line: 130

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 145

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 160

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 164

                           'GR_NO_RECORD_INSERTED');

Line: 176

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 191

END Insert_Row;

Line: 193

PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_line_type IN NUMBER,
				  p_line_no IN NUMBER,
				  p_left_label_code IN VARCHAR2,
				  p_right_label_code IN VARCHAR2,
				  p_created_by IN NUMBER,
				  p_creation_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  p_last_update_date IN DATE,
				  p_last_update_login IN NUMBER,
				  x_return_status OUT NOCOPY VARCHAR2,
				  x_oracle_error OUT NOCOPY NUMBER,
				  x_msg_data OUT NOCOPY VARCHAR2)
 IS

/*   Alpha Variables */

L_RETURN_STATUS	  VARCHAR2(1) := 'S';

Line: 230

   SAVEPOINT Update_Row;

Line: 248

       UPDATE	gr_doc_hdr_ftr
	  SET	left_label_code            = p_left_label_code,
	        right_label_code	   = p_right_label_code,
		last_updated_by	           = p_last_updated_by,
		last_update_date           = p_last_update_date,
		last_update_login          = p_last_update_login
	 WHERE	rowid = p_rowid;

Line: 270

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 285

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 289

                           'GR_NO_RECORD_INSERTED');

Line: 300

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 315

END Update_Row;

Line: 328

				  p_last_updated_by IN NUMBER,
				  p_last_update_date IN DATE,
				  p_last_update_login IN NUMBER,
				  x_return_status OUT NOCOPY VARCHAR2,
				  x_oracle_error OUT NOCOPY NUMBER,
				  x_msg_data OUT NOCOPY VARCHAR2)
 IS

/*  Alpha Variables */

L_RETURN_STATUS	  VARCHAR2(1) := 'S';

Line: 355

   SELECT	last_update_date
   FROM		gr_doc_hdr_ftr
   WHERE	rowid = p_rowid
   FOR UPDATE NOWAIT;

Line: 379

   IF LockDHFRcd.last_update_date <> p_last_update_date THEN
     RAISE RECORD_CHANGED_ERROR;

Line: 439

PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_line_type IN NUMBER,
				  p_line_no IN NUMBER,
				  p_left_label_code IN VARCHAR2,
				  p_right_label_code IN VARCHAR2,
				  x_return_status OUT NOCOPY VARCHAR2,
				  x_oracle_error OUT NOCOPY NUMBER,
				  x_msg_data OUT NOCOPY VARCHAR2)
 IS
/*   Alpha Variables */

L_RETURN_STATUS	  VARCHAR2(1) := 'S';

Line: 471

   SAVEPOINT Delete_Row;

Line: 493

   DELETE FROM gr_doc_hdr_ftr
   WHERE  	   rowid = p_rowid;

Line: 505

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 515

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 530

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 545

END Delete_Row;

Line: 571

   SELECT document_code
   FROM   gr_document_codes
   WHERE  document_code = p_document_code;

Line: 577

   SELECT label_code
   FROM   gr_labels_b
   WHERE  label_code = V_label_code;

Line: 755

   SELECT dhf.rowid
   FROM	  gr_doc_hdr_ftr dhf
   WHERE  document_code = p_document_code
   AND    line_type     = p_line_type
   AND    line_no       = p_line_no;