DBA Data[Home] [Help]

APPS.GR_ORGANIZATION_CONTACTS_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_orgn_code IN VARCHAR2,
				  p_daytime_contact_name IN VARCHAR2,
				  p_daytime_telephone IN VARCHAR2,
				  p_daytime_extension IN VARCHAR2,
				  p_daytime_area_code IN VARCHAR2,
				  p_evening_contact_name IN VARCHAR2,
				  p_evening_telephone IN VARCHAR2,
				  p_evening_extension IN VARCHAR2,
				  p_evening_area_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,
				  p_daytime_email IN VARCHAR2,
				  p_evening_email IN VARCHAR2,
				  p_daytime_fax_no IN VARCHAR2,
				  p_evening_fax_no 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: 53

   SAVEPOINT Insert_Row;
Line: 93

   INSERT INTO gr_organization_contacts
   		  	     (orgn_code,
				  daytime_contact_name,
				  daytime_telephone,
				  daytime_extension,
				  daytime_area_code,
				  evening_contact_name,
				  evening_telephone,
				  evening_extension,
				  evening_area_code,
				  daytime_email,
				  evening_email,
				  daytime_fax_no,
				  evening_fax_no,
				  created_by,
				  creation_date,
				  last_updated_by,
				  last_update_date,
				  last_update_login)
          VALUES
		         (p_orgn_code,
				  p_daytime_contact_name,
				  p_daytime_telephone,
				  p_daytime_extension,
				  p_daytime_area_code,
				  p_evening_contact_name,
				  p_evening_telephone,
				  p_evening_extension,
				  p_evening_area_code,
				  p_daytime_email,
				  p_evening_email,
				  p_daytime_fax_no,
				  p_evening_fax_no,
				  p_created_by,
				  p_creation_date,
				  p_last_updated_by,
				  p_last_update_date,
				  p_last_update_login);
Line: 132

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

   Check_Primary_Key
   	   	   		 (p_orgn_code,
				  'F',
				  l_rowid,
				  l_key_exists);
Line: 155

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 170

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 186

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 191

                           'GR_NO_RECORD_INSERTED');
Line: 202

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 218

END Insert_Row;
Line: 220

PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_orgn_code IN VARCHAR2,
				  p_daytime_contact_name IN VARCHAR2,
				  p_daytime_telephone IN VARCHAR2,
				  p_daytime_extension IN VARCHAR2,
				  p_daytime_area_code IN VARCHAR2,
				  p_evening_contact_name IN VARCHAR2,
				  p_evening_telephone IN VARCHAR2,
				  p_evening_extension IN VARCHAR2,
				  p_evening_area_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,
				  p_daytime_email IN VARCHAR2,
				  p_evening_email IN VARCHAR2,
				  p_daytime_fax_no IN VARCHAR2,
				  p_evening_fax_no 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: 266

   SAVEPOINT Update_Row;
Line: 295

      UPDATE gr_organization_contacts
	  SET	 orgn_code                       = p_orgn_code,
	  		 daytime_contact_name		     = p_daytime_contact_name,
			 daytime_telephone	             = p_daytime_telephone,
			 daytime_extension	             = p_daytime_extension,
			 daytime_area_code               = p_daytime_area_code,
			 evening_contact_name	         = p_evening_contact_name,
			 evening_telephone	             = p_evening_telephone,
			 evening_extension	             = p_evening_extension,
			 evening_area_code	             = p_evening_area_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,
			 daytime_email					= p_daytime_email,
			 evening_email					= p_evening_email,
			 daytime_fax_no					= p_daytime_fax_no,
			 evening_fax_no					= p_evening_fax_no
	  WHERE  rowid = p_rowid;
Line: 329

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 344

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 348

                           'GR_NO_RECORD_INSERTED');
Line: 359

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 374

END Update_Row;
Line: 395

				  p_last_updated_by IN NUMBER,
				  p_last_update_date IN DATE,
				  p_last_update_login IN NUMBER,
				  p_daytime_email IN VARCHAR2,
				  p_evening_email IN VARCHAR2,
				  p_daytime_fax_no IN VARCHAR2,
				  p_evening_fax_no 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: 427

   SELECT	*
   FROM		gr_organization_contacts
   WHERE	rowid = p_rowid
   FOR UPDATE NOWAIT;
Line: 503

PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_orgn_code IN VARCHAR2,
				  p_daytime_contact_name IN VARCHAR2,
				  p_daytime_telephone IN VARCHAR2,
				  p_daytime_extension IN VARCHAR2,
				  p_daytime_area_code IN VARCHAR2,
				  p_evening_contact_name IN VARCHAR2,
				  p_evening_telephone IN VARCHAR2,
				  p_evening_extension IN VARCHAR2,
				  p_evening_area_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,
				  p_daytime_email IN VARCHAR2,
				  p_evening_email IN VARCHAR2,
				  p_daytime_fax_no IN VARCHAR2,
				  p_evening_fax_no 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: 553

   SAVEPOINT Delete_Row;
Line: 585

   DELETE FROM gr_organization_contacts
   WHERE  	   rowid = p_rowid;
Line: 597

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 607

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 622

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 637

END Delete_Row;
Line: 675

   SELECT	som.orgn_code
   FROM     sy_orgn_mst som
   WHERE    som.orgn_code = p_orgn_code;
Line: 706

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 819

   SELECT orc.rowid
   FROM	  gr_organization_contacts orc
   WHERE  orc.orgn_code = p_orgn_code;