DBA Data[Home] [Help]

APPS.GR_LABEL_PROPERTIES_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_sequence_number IN NUMBER,
				  p_property_id IN VARCHAR2,
				  p_label_code IN VARCHAR2,
				  P_rollup_type IN NUMBER,
				  p_property_required 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_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: 46

   SAVEPOINT Insert_Row;
Line: 78

   INSERT INTO gr_label_properties
   		  	     (sequence_number,
				  property_id,
   		  	          label_code,
   		  	          rollup_type,
   		  	          property_required,
				  created_by,
				  creation_date,
				  last_updated_by,
				  last_update_date,
				  last_update_login)
          VALUES
		         (gr_label_properties_s.nextval,
				  p_property_id,
		                  p_label_code,
		                  P_rollup_type,
				  p_property_required,
				  p_created_by,
				  p_creation_date,
				  p_last_updated_by,
				  p_last_update_date,
				  p_last_update_login);
Line: 103

   SELECT gr_label_properties_s.currval
   INTO   l_current_seq
   FROM	  dual;
Line: 107

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

   Check_Primary_Key
   	   	   		 (l_current_seq,
				  p_property_id,
			      p_label_code,
				  'F',
				  l_rowid,
				  l_key_exists);
Line: 132

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 147

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 163

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 168

                           'GR_NO_RECORD_INSERTED');
Line: 179

      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_sequence_number IN NUMBER,
				  p_property_id IN VARCHAR2,
				  p_label_code IN VARCHAR2,
				  P_rollup_type IN NUMBER,
				  p_property_required 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: 254

      UPDATE gr_label_properties
	  SET	 property_id					 = p_property_id,
	  		 label_code		 	 	 = p_label_code,
	  		 rollup_type				 = P_rollup_type,
			 property_required 			 = p_property_required,
			 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: 279

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 294

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 298

                           'GR_NO_RECORD_INSERTED');
Line: 309

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 324

END Update_Row;
Line: 337

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

   SELECT	*
   FROM		gr_label_properties
   WHERE	rowid = p_rowid
   FOR UPDATE NOWAIT;
Line: 441

PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_sequence_number IN NUMBER,
				  p_property_id IN VARCHAR2,
				  p_label_code IN VARCHAR2,
				  P_rollup_type IN NUMBER,
				  p_property_required 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: 483

   SAVEPOINT Delete_Row;
Line: 505

   DELETE FROM gr_label_properties
   WHERE  	   rowid = p_rowid;
Line: 517

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 527

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 542

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 558

END Delete_Row;
Line: 560

**		p_delete_option has one of two values
**		'P' - Delete all rows for the specified property.
**		'L' - Delete all rows for the specified label.
*/
PROCEDURE Delete_Rows
	             (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_delete_option IN VARCHAR2,
				  p_property_id 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: 587

NULL_DELETE_OPTION_ERROR	EXCEPTION;
Line: 595

   SAVEPOINT Delete_Rows;
Line: 600

   IF p_delete_option = 'L' THEN
      IF p_label_code IS NULL THEN
	     l_msg_token := 'Label Code';
Line: 603

	     RAISE Null_Delete_Option_Error;
Line: 607

         DELETE FROM	gr_label_properties
         WHERE 	  	label_code = p_label_code;
Line: 610

   ELSIF p_delete_option = 'P' THEN
      IF p_property_id IS NULL THEN
	     l_msg_token := 'Property id';
Line: 613

	     RAISE Null_Delete_Option_Error;
Line: 617

 	     DELETE FROM	gr_label_properties
	     WHERE			property_id = p_property_id;
Line: 621

      l_msg_token := 'Invalid Delete Option';
Line: 622

	  RAISE Null_Delete_Option_Error;
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: 837

   SELECT lp.rowid
   FROM	  gr_label_properties lp
   WHERE  lp.sequence_number = p_sequence_number
   AND	  lp.property_id = p_property_id
   AND	  lp.label_code = p_label_code;