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_SAFETY_PHRASES_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_safety_phrase_code IN VARCHAR2,
				  p_temperature IN NUMBER,
				  p_temperature_scale IN VARCHAR2,
				  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,
				  p_phrase_code IN VARCHAR2,
				  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: 61


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

Line: 85


   INSERT INTO gr_item_safety_phrases
   		  	     (item_code,
				  safety_phrase_code,
				  temperature,
				  temperature_scale,
				  created_by,
				  creation_date,
				  last_update_date,
				  last_updated_by,
				  last_update_login,
				  phrase_code)
          VALUES
		         (p_item_code,
			  p_safety_phrase_code,
			  p_temperature,
			  p_temperature_scale,
			  p_created_by,
			  p_creation_date,
			  p_last_update_date,
			  p_last_updated_by,
			  p_last_update_login,
			  p_phrase_code);

Line: 108


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

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

Line: 132


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 147


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 162


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 166


                           'GR_NO_RECORD_INSERTED');

Line: 177


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 192


END Insert_Row;

Line: 194


PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_item_code IN VARCHAR2,
				  p_safety_phrase_code IN VARCHAR2,
				  p_temperature IN NUMBER,
				  p_temperature_scale IN VARCHAR2,
				  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,
				  p_phrase_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: 231


   SAVEPOINT Update_Row;

Line: 246


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

Line: 257


      UPDATE gr_item_safety_phrases
	  SET	 item_code		 	 	 		 = p_item_code,
			 safety_phrase_code		  		 = p_safety_phrase_code,
			 temperature	  				 = p_temperature,
			 temperature_scale	  			 = p_temperature_scale,
			 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,
			 phrase_code                                     = p_phrase_code
	  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: 340


				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  p_last_update_login IN NUMBER,
				  p_phrase_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: 369


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

Line: 444


PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_item_code IN VARCHAR2,
				  p_safety_phrase_code IN VARCHAR2,
				  p_temperature IN NUMBER,
				  p_temperature_scale IN VARCHAR2,
				  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,
				  p_phrase_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: 483


   SAVEPOINT Delete_Row;

Line: 500


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

Line: 512


   DELETE FROM gr_item_safety_phrases
   WHERE  	   rowid = p_rowid;

Line: 524


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 533


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 548


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 564


END Delete_Row;

Line: 566


PROCEDURE Delete_Rows
	             (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
	              p_delete_option IN VARCHAR2,
	              p_item_code IN VARCHAR2,
				  p_safety_phrase_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: 589


NULL_DELETE_OPTION_ERROR	EXCEPTION;

Line: 597


   SAVEPOINT Delete_Rows;

Line: 603


**		p delete option has one of two values
**		'I' - Delete all rows for the specified item.
**		'S' - Delete all rows for the specified safety phrase.
*/
   IF p_delete_option = 'I' THEN
      IF p_item_code IS NULL THEN
	     l_msg_token := 'Item Code';

Line: 610


	     RAISE Null_Delete_Option_Error;

Line: 614


         DELETE FROM  gr_item_safety_phrases
         WHERE		  item_code = p_item_code;

Line: 617


   ELSIF p_delete_option = 'S' THEN
      IF p_safety_phrase_code IS NULL THEN
	     l_msg_token := 'Safety Phrase Code';

Line: 620


		 RAISE Null_Delete_Option_Error;

Line: 624


         DELETE FROM	gr_item_safety_phrases
         WHERE			safety_phrase_code = p_safety_phrase_code;

Line: 631


   WHEN Null_Delete_Option_Error THEN
	  x_return_status := 'E';

Line: 646


      ROLLBACK TO SAVEPOINT Delete_Rows;

Line: 661


END Delete_Rows;

Line: 670


				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  p_last_update_login IN NUMBER,
				  p_phrase_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: 783


				  p_last_update_date IN DATE,
				  p_last_updated_by IN NUMBER,
				  p_last_update_login IN NUMBER,
				  p_phrase_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: 859


   SELECT isp.rowid
   FROM	  gr_item_safety_phrases isp
   WHERE  isp.item_code = p_item_code
   AND	  isp.safety_phrase_code = p_safety_phrase_code;