eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_DOCUMENT_STRUCTURES_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_structures_seqno IN NUMBER,
				  p_document_headings_seqno IN NUMBER,
				  p_label_code IN VARCHAR2,
				  p_phrase_group_code IN VARCHAR2,
				  p_phrase_code IN VARCHAR2,
				  p_print_font IN VARCHAR2,
				  p_data_position_indicator IN VARCHAR2,
				  p_display_order IN NUMBER,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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_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: 80


   SAVEPOINT Insert_Row;

Line: 147


   INSERT INTO gr_document_structures
   		  	     (document_structures_seqno,
				  document_headings_seqno,
				  label_code,
				  phrase_group_code,
				  phrase_code,
				  print_font,
				  data_position_indicator,
				  display_order,
				  attribute_category,
				  attribute1,
				  attribute2,
				  attribute3,
				  attribute4,
				  attribute5,
				  attribute6,
				  attribute7,
				  attribute8,
				  attribute9,
				  attribute10,
				  attribute11,
				  attribute12,
				  attribute13,
				  attribute14,
				  attribute15,
				  attribute16,
				  attribute17,
				  attribute18,
				  attribute19,
				  attribute20,
				  attribute21,
				  attribute22,
				  attribute23,
				  attribute24,
				  attribute25,
				  attribute26,
				  attribute27,
				  attribute28,
				  attribute29,
				  attribute30,
				  created_by,
				  creation_date,
				  last_updated_by,
				  last_update_date,
				  last_update_login)
          VALUES
		         (gr_document_structures_s.nextval,
				  p_document_headings_seqno,
				  p_label_code,
				  p_phrase_group_code,
				  p_phrase_code,
				  p_print_font,
				  p_data_position_indicator,
				  p_display_order,
		          p_attribute_category,
				  p_attribute1,
				  p_attribute2,
				  p_attribute3,
				  p_attribute4,
				  p_attribute5,
				  p_attribute6,
				  p_attribute7,
				  p_attribute8,
				  p_attribute9,
				  p_attribute10,
				  p_attribute11,
				  p_attribute12,
				  p_attribute13,
				  p_attribute14,
				  p_attribute15,
				  p_attribute16,
				  p_attribute17,
				  p_attribute18,
				  p_attribute19,
				  p_attribute20,
				  p_attribute21,
				  p_attribute22,
				  p_attribute23,
				  p_attribute24,
				  p_attribute25,
				  p_attribute26,
				  p_attribute27,
				  p_attribute28,
				  p_attribute29,
				  p_attribute30,
				  p_created_by,
				  p_creation_date,
				  p_last_updated_by,
				  p_last_update_date,
				  p_last_update_login);

Line: 240


   SELECT gr_document_structures_s.currval
   INTO   l_current_seq
   FROM	  dual;

Line: 244


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

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

Line: 269


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 284


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 299


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 304


                           'GR_NO_RECORD_INSERTED');

Line: 315


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 330


END Insert_Row;

Line: 332


PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_structures_seqno IN NUMBER,
				  p_document_headings_seqno IN NUMBER,
				  p_label_code IN VARCHAR2,
				  p_phrase_group_code IN VARCHAR2,
				  p_phrase_code IN VARCHAR2,
				  p_print_font IN VARCHAR2,
				  p_data_position_indicator IN VARCHAR2,
				  p_display_order IN NUMBER,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 403


   SAVEPOINT Update_Row;

Line: 457


      UPDATE gr_document_structures
      SET	 document_structures_seqno		 = p_document_structures_seqno,
			 document_headings_seqno	  	 = p_document_headings_seqno,
			 label_code	  					 = p_label_code,
			 phrase_group_code	  			 = p_phrase_group_code,
			 phrase_code	  				 = p_phrase_code,
			 print_font	  					 = p_print_font,
			 data_position_indicator	  	 = p_data_position_indicator,
			 display_order	  				 = p_display_order,
			 attribute_category				 = p_attribute_category,
			 attribute1						 = p_attribute1,
			 attribute2						 = p_attribute2,
			 attribute3						 = p_attribute3,
			 attribute4						 = p_attribute4,
			 attribute5						 = p_attribute5,
			 attribute6						 = p_attribute6,
			 attribute7						 = p_attribute7,
			 attribute8						 = p_attribute8,
			 attribute9						 = p_attribute9,
			 attribute10					 = p_attribute10,
			 attribute11					 = p_attribute11,
			 attribute12					 = p_attribute12,
			 attribute13					 = p_attribute13,
			 attribute14					 = p_attribute14,
			 attribute15					 = p_attribute15,
			 attribute16					 = p_attribute16,
			 attribute17					 = p_attribute17,
			 attribute18					 = p_attribute18,
			 attribute19					 = p_attribute19,
			 attribute20					 = p_attribute20,
			 attribute21					 = p_attribute11,
			 attribute22					 = p_attribute22,
			 attribute23					 = p_attribute23,
			 attribute24					 = p_attribute24,
			 attribute25					 = p_attribute25,
			 attribute26					 = p_attribute26,
			 attribute27					 = p_attribute27,
			 attribute28					 = p_attribute28,
			 attribute29					 = p_attribute29,
			 attribute30					 = p_attribute30,
			 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: 517


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 532


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 537


                           'GR_NO_RECORD_INSERTED');

Line: 548


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 563


END Update_Row;

Line: 568


  PROCEDURE Update_Display_Columns
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_document_structures_seqno IN NUMBER,
				  p_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: 599


   SAVEPOINT Update_Display_Columns;

Line: 604


/* Update the table */

      UPDATE		 gr_document_structures
      SET		 display_order				 = p_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_structures_seqno = p_document_structures_seqno;

Line: 625


      ROLLBACK TO SAVEPOINT Update_Display_Columns;

Line: 629


                           'GR_NO_RECORD_INSERTED');

Line: 640


      ROLLBACK TO SAVEPOINT Update_Display_Columns;

Line: 655


END Update_Display_Columns;

Line: 704


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


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

Line: 807


PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_structures_seqno IN NUMBER,
				  p_document_headings_seqno IN NUMBER,
				  p_label_code IN VARCHAR2,
				  p_phrase_group_code IN VARCHAR2,
				  p_phrase_code IN VARCHAR2,
				  p_print_font IN VARCHAR2,
				  p_data_position_indicator IN VARCHAR2,
				  p_display_order IN NUMBER,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 880


   SAVEPOINT Delete_Row;

Line: 937


   DELETE FROM gr_document_structures
--   WHERE  	   rowid = p_rowid;

Line: 950


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 960


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 976


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 992


END Delete_Row;

Line: 1283


   SELECT ds.rowid
   FROM	  gr_document_structures ds
   WHERE  ds.document_structures_seqno = p_document_structures_seqno
   AND	  ds.document_headings_seqno = p_document_headings_seqno;