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_FIELD_NAME_MASKS_B_PKG SQL Statements

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

Line: 7


   Insert_Row

 DESCRIPTION:
   This PL/SQL procedure is used to insert data into the table
   GR_FIELD_NAME_MASKS_B

 PARAMETERS:
   p_commit            IN   VARCHAR2,
   p_called_by_form    IN   VARCHAR2,
   p_item_code         IN   VARCHAR2,
   p_disclosure_code   IN   VARCHAR2,
   p_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  VARCHAR2,
   x_return_status     OUT  VARCHAR2,
   x_oracle_error      OUT  NUMBER,
   x_msg_data          OUT  VARCHAR2

 HISTORY
 ===================================================================== */
PROCEDURE Insert_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_item_code IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_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: 72


   SAVEPOINT Insert_Row;

Line: 104


   INSERT INTO gr_item_field_name_masks_b
   		  	     (item_code,
				  disclosure_code,
				  label_code,
				  created_by,
				  creation_date,
				  last_updated_by,
				  last_update_date,
				  last_update_login)
          VALUES
		         (p_item_code,
				  p_disclosure_code,
				  p_label_code,
				  p_created_by,
				  p_creation_date,
				  p_last_updated_by,
				  p_last_update_date,
				  p_last_update_login);

Line: 123


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

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

Line: 148


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 163


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 178


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 182


                           'GR_NO_RECORD_INSERTED');

Line: 193


      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 208


END Insert_Row;

Line: 213


   Update_Row

 DESCRIPTION:
   This PL/SQL procedure is used to update data in the table
   GR_FIELD_NAME_MASKS_B

 PARAMETERS:
   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_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  VARCHAR2,
   x_oracle_error      OUT  NUMBER,
   x_msg_data          OUT  VARCHAR2

 HISTORY
 ===================================================================== */
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_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: 272


   SAVEPOINT Update_Row;

Line: 290


      UPDATE gr_item_field_name_masks_b
      SET	 item_code	   = p_item_code,
		 disclosure_code   = p_disclosure_code,
		 label_code        = p_label_code,
		 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: 314


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 329


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 333


                           'GR_NO_RECORD_INSERTED');

Line: 344


      ROLLBACK TO SAVEPOINT Update_Row;

Line: 359


END Update_Row;

Line: 380


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

 HISTORY
 ===================================================================== */
PROCEDURE Lock_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_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: 425


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

Line: 503


   Delete_Row

 DESCRIPTION:
   This PL/SQL procedure is used to delete a row in the table
   GR_FIELD_NAME_MASKS_B

 PARAMETERS:
   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_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  VARCHAR2,
   x_oracle_error      OUT  NUMBER,
   x_msg_data          OUT  VARCHAR2

 HISTORY
 ===================================================================== */
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_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: 565


   SAVEPOINT Delete_Row;

Line: 587


   DELETE FROM gr_item_field_name_masks_b
   WHERE  	   rowid = p_rowid;

Line: 599


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 614


      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 629


END Delete_Row;

Line: 649


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

 HISTORY
 ===================================================================== */
PROCEDURE Check_Foreign_Keys
	   			 (p_item_code IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_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: 684


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

Line: 693


  SELECT lc.label_code
  FROM   gr_labels_b lc
  WHERE  lc.label_code = p_label_code;

Line: 795


   SELECT dc.rowid
   FROM	  gr_item_field_name_masks_b dc
   WHERE  dc.item_code = p_item_code
   AND    dc.disclosure_code = p_disclosure_code
   AND    dc.label_code = p_label_code;