APPS.GR_DOCUMENT_HEADINGS_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_headings_seqno IN NUMBER,
				  p_document_code IN VARCHAR2,
				  p_main_heading_code IN VARCHAR2,
				  p_main_display_order IN NUMBER,
				  p_sub_heading_code IN VARCHAR2,
				  p_sub_display_order IN NUMBER,
				  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_current_seq OUT NOCOPY 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: 47

   SAVEPOINT Insert_Row;

Line: 80

   INSERT INTO gr_document_headings
   		  	     (document_headings_seqno,
   		  	      document_code,
				  main_heading_code,
				  main_display_order,
				  sub_heading_code,
				  sub_display_order,
				  created_by,
				  creation_date,
				  last_updated_by,
				  last_update_date,
				  last_update_login)
          VALUES
		         (gr_document_headings_s.nextval,
		          p_document_code,
				  p_main_heading_code,
				  p_main_display_order,
				  p_sub_heading_code,
				  p_sub_display_order,
				  p_created_by,
				  p_creation_date,
				  p_last_updated_by,
				  p_last_update_date,
				  p_last_update_login);

Line: 107

   SELECT gr_document_headings_s.currval
   INTO   l_current_seq
   FROM	  dual;

Line: 111

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

   Check_Primary_Key
   	   	   		 (l_current_seq,
				  'F',
				  l_rowid,
				  l_key_exists);

Line: 135

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 150

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 165

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 169

                           'GR_NO_RECORD_INSERTED');

Line: 180

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 195

END Insert_Row;

Line: 197

PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_headings_seqno IN NUMBER,
				  p_document_code IN VARCHAR2,
				  p_main_heading_code IN VARCHAR2,
				  p_main_display_order IN NUMBER,
				  p_sub_heading_code IN VARCHAR2,
				  p_sub_display_order IN NUMBER,
				  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: 235

   SAVEPOINT Update_Row;

Line: 256

      UPDATE gr_document_headings
      SET	 document_headings_seqno		 = p_document_headings_seqno,
             document_code				  	 = p_document_code,
			 main_heading_code				 = p_main_heading_code,
			 main_display_order				 = p_main_display_order,
			 sub_heading_code	  			 = p_sub_heading_code,
			 sub_display_order				 = p_sub_display_order,
			 created_by						 = p_created_by,
			 creation_date					 = p_creation_date,
			 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: 283

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 298

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 302

                           'GR_NO_RECORD_INSERTED');

Line: 313

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 328

END Update_Row;

Line: 332

  PROCEDURE Update_Display_Columns
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_document_headings_seqno IN NUMBER,
				  p_main_display_order IN NUMBER,
				  p_sub_display_order IN NUMBER,
				  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: 364

   SAVEPOINT Update_Display_Columns;

Line: 369

/* Update the table */

      UPDATE		 gr_document_headings
      SET		 main_display_order			 = p_main_display_order,
			 sub_display_order			 = p_sub_display_order,
			 last_updated_by			 = p_last_updated_by,
			 last_update_date			 = p_last_update_date,
			 last_update_login			 = p_last_update_login
      WHERE  document_headings_seqno = p_document_headings_seqno;

Line: 391

      ROLLBACK TO SAVEPOINT Update_Display_Columns;

Line: 395

                           'GR_NO_RECORD_INSERTED');

Line: 406

      ROLLBACK TO SAVEPOINT Update_Display_Columns;

Line: 421

END Update_Display_Columns;

Line: 436

				  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: 463

   SELECT	*
   FROM		gr_document_headings
   WHERE	rowid = p_rowid
   FOR UPDATE NOWAIT;

Line: 538

PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_headings_seqno IN NUMBER,
				  p_document_code IN VARCHAR2,
				  p_main_heading_code IN VARCHAR2,
				  p_main_display_order IN NUMBER,
				  p_sub_heading_code IN VARCHAR2,
				  p_sub_display_order IN NUMBER,
				  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: 578

   SAVEPOINT Delete_Row;

Line: 602

   DELETE FROM gr_document_headings
--   WHERE  	   rowid = p_rowid;

Line: 615

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 625

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 640

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 656

END Delete_Row;

Line: 658

PROCEDURE Delete_Rows
	             (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
	              p_document_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: 683

   SAVEPOINT Delete_Rows;

Line: 689

   DELETE FROM gr_document_headings
   WHERE 	   document_code = p_document_code;

Line: 699

      ROLLBACK TO SAVEPOINT Delete_Rows;

Line: 714

END Delete_Rows;

Line: 744

   SELECT	mh.main_heading_code
   FROM		gr_main_headings_b mh
   WHERE	mh.main_heading_code = p_main_heading_code;

Line: 753

   SELECT	sh.sub_heading_code
   FROM		gr_sub_headings_b sh
   WHERE	sh.sub_heading_code = p_sub_heading_code;

Line: 847

    SELECT   COUNT(*) count
    FROM     gr_item_document_dtls idd
    WHERE    idd.document_code = p_document_code
    AND      idd.main_heading_code = p_main_heading_code
    AND      idd.sub_heading_code = p_sub_heading_code;

Line: 926

   SELECT dh.rowid
   FROM	  gr_document_headings dh
   WHERE  dh.document_headings_seqno = p_document_headings_seqno;

Line: 962

				  p_last_update_date IN DATE,
				  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: 985

   SELECT	last_update_date
   FROM		gr_document_headings
   WHERE	document_code = p_document_code
   FOR UPDATE NOWAIT;

Line: 1009

   IF LockDocumentRcd.last_update_date <> p_last_update_date THEN
     RAISE RECORD_CHANGED_ERROR;