APPS.GR_EIN_ASL_RISKS_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_risk_phrase_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
/* Declare Alpha Variables */

L_RETURN_STATUS VARCHAR2(1) := 'S';

Line: 40

   SAVEPOINT Insert_Row;

Line: 46

  This will check that any codes being inserted into this table do indeed
  exist in the tables that they reference.  */

   Check_Foreign_Keys
			     (p_sequence_number,
			      p_risk_phrase_code,
                              l_return_status,
                              l_oracle_error,
                              l_msg_data);

Line: 75

   INSERT INTO gr_ein_asl_risks
   		  	     (    sequence_number,
   		  	          risk_phrase_code,
				  created_by,
				  creation_date,
				  last_updated_by,
				  last_update_date,
				  last_update_login)

          VALUES
		                 (p_sequence_number,
		                  p_risk_phrase_code,
				  p_created_by,
				  p_creation_date,
				  p_last_updated_by,
				  p_last_update_date,
				  p_last_update_login);

Line: 93

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

   Check_Primary_Key
   	   	   		 (p_sequence_number,
   	   	   		  p_risk_phrase_code,
				  'F',
				  l_rowid,
				  l_key_exists);

Line: 117

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 132

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 147

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 151

                           'GR_NO_RECORD_INSERTED');

Line: 162

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 177

END Insert_Row;

Line: 204

   SELECT	rp.risk_phrase_code
   FROM		gr_risk_phrases_b rp
   WHERE	rp.risk_phrase_code = p_risk_phrase_code;

Line: 259

PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_sequence_number IN NUMBER,
				  p_risk_phrase_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: 295

   SAVEPOINT Delete_Row;

Line: 303

   DELETE FROM gr_ein_asl_risks
   WHERE       rowid = p_rowid;

Line: 315

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 325

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 341

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 356

END Delete_Row;

Line: 381

   SELECT ear.rowid
   FROM	  gr_ein_asl_risks ear
   WHERE  ear.sequence_number = p_sequence_number
     AND  ear.risk_phrase_code = p_risk_phrase_code;