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_ITEM_DISCLOSURES_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_item_code IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_print_on_document_flag IN VARCHAR2,
				  p_minimum_reporting_level IN NUMBER,
				  p_text_reporting_level IN NUMBER,
				  p_label_reporting_level IN NUMBER,
				  p_exposure_reporting_level IN NUMBER,
				  p_toxicity_reporting_level IN NUMBER,
				  p_created_by IN NUMBER,
				  p_creation_date IN DATE,
				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  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: 48


   SAVEPOINT Insert_Row;

Line: 68


				  p_last_update_date,
				  p_last_updated_by,
				  p_last_update_login,
				  l_return_status,
				  l_oracle_error,
				  l_msg_data);

Line: 91


   INSERT INTO gr_item_disclosures
   		  	     (item_code,
				  disclosure_code,
				  print_on_document_flag,
				  minimum_reporting_level,
				  text_reporting_level,
				  label_reporting_level,
				  exposure_reporting_level,
				  toxicity_reporting_level,
				  created_by,
				  creation_date,
				  last_update_date,
				  last_updated_by,
				  last_update_login)
          VALUES
		         (p_item_code,
				  p_disclosure_code,
				  p_print_on_document_flag,
				  p_minimum_reporting_level,
				  p_text_reporting_level,
				  p_label_reporting_level,
				  p_exposure_reporting_level,
				  p_toxicity_reporting_level,
				  p_created_by,
				  p_creation_date,
				  p_last_update_date,
				  p_last_updated_by,
				  p_last_update_login);

Line: 120


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

   Check_Primary_Key
   	   	   		 (p_item_code,
				  p_disclosure_code,
				  'F',
				  l_rowid,
				  l_key_exists);

Line: 144


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 159


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 174


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 178


                           'GR_NO_RECORD_INSERTED');

Line: 189


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 204


END Insert_Row;

Line: 206


PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_item_code IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_print_on_document_flag IN VARCHAR2,
				  p_minimum_reporting_level IN NUMBER,
				  p_text_reporting_level IN NUMBER,
				  p_label_reporting_level IN NUMBER,
				  p_exposure_reporting_level IN NUMBER,
				  p_toxicity_reporting_level IN NUMBER,
				  p_created_by IN NUMBER,
				  p_creation_date IN DATE,
				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  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: 246


   SAVEPOINT Update_Row;

Line: 265


				  p_last_update_date,
				  p_last_updated_by,
				  p_last_update_login,
				  l_return_status,
				  l_oracle_error,
				  l_msg_data);

Line: 275


      UPDATE gr_item_disclosures
	  SET	 item_code		 	 	 		 = p_item_code,
			 disclosure_code		  		 = p_disclosure_code,
			 print_on_document_flag			 = p_print_on_document_flag,
			 minimum_reporting_level	  	 = p_minimum_reporting_level,
			 text_reporting_level		  	 = p_text_reporting_level,
			 label_reporting_level	  		 = p_label_reporting_level,
			 exposure_reporting_level	  	 = p_exposure_reporting_level,
			 toxicity_reporting_level	  	 = p_toxicity_reporting_level,
			 created_by	  					 = p_created_by,
			 creation_date	  				 = p_creation_date,
			 last_update_date	  			 = p_last_update_date,
			 last_updated_by	  			 = p_last_updated_by,
			 last_update_login	  			 = p_last_update_login
	  WHERE  rowid = p_rowid;

Line: 304


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 319


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 323


                           'GR_NO_RECORD_INSERTED');

Line: 334


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 349


END Update_Row;

Line: 365


				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  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: 393


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

Line: 468


PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_item_code IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_print_on_document_flag IN VARCHAR2,
				  p_minimum_reporting_level IN NUMBER,
				  p_text_reporting_level IN NUMBER,
				  p_label_reporting_level IN NUMBER,
				  p_exposure_reporting_level IN NUMBER,
				  p_toxicity_reporting_level IN NUMBER,
				  p_created_by IN NUMBER,
				  p_creation_date IN DATE,
				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  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: 510


   SAVEPOINT Delete_Row;

Line: 531


				  p_last_update_date,
				  p_last_updated_by,
				  p_last_update_login,
				  l_return_status,
				  l_oracle_error,
				  l_msg_data);

Line: 542


   DELETE FROM gr_item_disclosures
   WHERE  	   rowid = p_rowid;

Line: 554


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 563


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 578


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 594


END Delete_Row;

Line: 596


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


   SAVEPOINT Delete_Rows;

Line: 627


   DELETE FROM gr_item_disclosures
   WHERE 	   item_code = p_item_code;

Line: 637


      ROLLBACK TO SAVEPOINT Delete_Rows;

Line: 652


END Delete_Rows;

Line: 665


				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  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: 689


   SELECT	dc.disclosure_code
   FROM		gr_disclosures dc
   WHERE	dc.disclosure_code = p_disclosure_code;

Line: 769


				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  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: 845


   SELECT dc.rowid
   FROM	  gr_item_disclosures dc
   WHERE  dc.item_code = p_item_code
   AND	  dc.disclosure_code = p_disclosure_code;