DBA Data[Home] [Help]

APPS.GR_RECIPIENT_INFO_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_recipient_code IN VARCHAR2,
				  p_recipient_name IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_territory_code IN VARCHAR2,
				  p_print_recipient_product_code IN VARCHAR2,
				  p_update_address_flag IN VARCHAR2,
				  p_disclose_all_ingred_flag IN VARCHAR2,
				  p_address_to_print IN VARCHAR2,
				  p_document_print_frequency IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_region_code IN VARCHAR2,
				  p_cover_letter_id IN VARCHAR2,
				  p_additional_documents_flag IN VARCHAR2,
				  p_additional_address_flag IN VARCHAR2,
				  p_shipping_address IN VARCHAR2,
				  p_invoice_address IN VARCHAR2,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 86

   SAVEPOINT Insert_Row;
Line: 99

				  p_update_address_flag,
				  p_disclose_all_ingred_flag,
				  p_address_to_print,
				  p_document_print_frequency,
				  p_disclosure_code,
				  p_region_code,
				  p_cover_letter_id,
				  p_additional_documents_flag,
				  p_additional_address_flag,
				  p_shipping_address,
				  p_invoice_address,
				  p_attribute_category,
				  p_attribute1,
				  p_attribute2,
				  p_attribute3,
				  p_attribute4,
				  p_attribute5,
				  p_attribute6,
				  p_attribute7,
				  p_attribute8,
				  p_attribute9,
				  p_attribute10,
				  p_attribute11,
				  p_attribute12,
				  p_attribute13,
				  p_attribute14,
				  p_attribute15,
				  p_attribute16,
				  p_attribute17,
				  p_attribute18,
				  p_attribute19,
				  p_attribute20,
				  p_attribute21,
				  p_attribute22,
				  p_attribute23,
				  p_attribute24,
				  p_attribute25,
				  p_attribute26,
				  p_attribute27,
				  p_attribute28,
				  p_attribute29,
				  p_attribute30,
				  l_return_status,
				  l_oracle_error,
				  l_msg_data);
Line: 160

   INSERT INTO gr_recipient_info
   		  	     (recipient_code,
				  recipient_name,
				  document_code,
				  territory_code,
				  print_recipient_product_code,
				  update_address_flag,
				  disclose_all_ingredients_flag,
				  address_to_print,
				  document_print_frequency,
				  disclosure_code,
				  region_code,
				  cover_letter_id,
				  additional_documents_flag,
				  additional_address_flag,
				  shipping_address,
				  invoice_address,
				  attribute_category,
				  attribute1,
				  attribute2,
				  attribute3,
				  attribute4,
				  attribute5,
				  attribute6,
				  attribute7,
				  attribute8,
				  attribute9,
				  attribute10,
				  attribute11,
				  attribute12,
				  attribute13,
				  attribute14,
				  attribute15,
				  attribute16,
				  attribute17,
				  attribute18,
				  attribute19,
				  attribute20,
				  attribute21,
				  attribute22,
				  attribute23,
				  attribute24,
				  attribute25,
				  attribute26,
				  attribute27,
				  attribute28,
				  attribute29,
				  attribute30,
				  created_by,
				  creation_date,
				  last_updated_by,
				  last_update_date,
				  last_update_login)
          VALUES
		         (p_recipient_code,
				  p_recipient_name,
				  p_document_code,
				  p_territory_code,
				  p_print_recipient_product_code,
				  p_update_address_flag,
				  p_disclose_all_ingred_flag,
				  p_address_to_print,
				  p_document_print_frequency,
				  p_disclosure_code,
				  p_region_code,
				  p_cover_letter_id,
				  p_additional_documents_flag,
				  p_additional_address_flag,
				  p_shipping_address,
				  p_invoice_address,
				  p_attribute_category,
				  p_attribute1,
				  p_attribute2,
				  p_attribute3,
				  p_attribute4,
				  p_attribute5,
				  p_attribute6,
				  p_attribute7,
				  p_attribute8,
				  p_attribute9,
				  p_attribute10,
				  p_attribute11,
				  p_attribute12,
				  p_attribute13,
				  p_attribute14,
				  p_attribute15,
				  p_attribute16,
				  p_attribute17,
				  p_attribute18,
				  p_attribute19,
				  p_attribute20,
				  p_attribute21,
				  p_attribute22,
				  p_attribute23,
				  p_attribute24,
				  p_attribute25,
				  p_attribute26,
				  p_attribute27,
				  p_attribute28,
				  p_attribute29,
				  p_attribute30,
				  p_created_by,
				  p_creation_date,
				  p_last_updated_by,
				  p_last_update_date,
				  p_last_update_login);
Line: 267

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

   Check_Primary_Key
   	   	   		 (p_recipient_code,
				  'F',
				  l_rowid,
				  l_key_exists);
Line: 290

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 305

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 320

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 324

                           'GR_NO_RECORD_INSERTED');
Line: 335

      ROLLBACK TO SAVEPOINT Insert_Row;
Line: 350

END Insert_Row;
Line: 352

PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_recipient_code IN VARCHAR2,
				  p_recipient_name IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_territory_code IN VARCHAR2,
				  p_print_recipient_product_code IN VARCHAR2,
				  p_update_address_flag IN VARCHAR2,
				  p_disclose_all_ingred_flag IN VARCHAR2,
				  p_address_to_print IN VARCHAR2,
				  p_document_print_frequency IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_region_code IN VARCHAR2,
				  p_cover_letter_id IN VARCHAR2,
				  p_additional_documents_flag IN VARCHAR2,
				  p_additional_address_flag IN VARCHAR2,
				  p_shipping_address IN VARCHAR2,
				  p_invoice_address IN VARCHAR2,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 431

   SAVEPOINT Update_Row;
Line: 444

				  p_update_address_flag,
				  p_disclose_all_ingred_flag,
				  p_address_to_print,
				  p_document_print_frequency,
				  p_disclosure_code,
				  p_region_code,
				  p_cover_letter_id,
				  p_additional_documents_flag,
				  p_additional_address_flag,
				  p_shipping_address,
				  p_invoice_address,
				  p_attribute_category,
				  p_attribute1,
				  p_attribute2,
				  p_attribute3,
				  p_attribute4,
				  p_attribute5,
				  p_attribute6,
				  p_attribute7,
				  p_attribute8,
				  p_attribute9,
				  p_attribute10,
				  p_attribute11,
				  p_attribute12,
				  p_attribute13,
				  p_attribute14,
				  p_attribute15,
				  p_attribute16,
				  p_attribute17,
				  p_attribute18,
				  p_attribute19,
				  p_attribute20,
				  p_attribute21,
				  p_attribute22,
				  p_attribute23,
				  p_attribute24,
				  p_attribute25,
				  p_attribute26,
				  p_attribute27,
				  p_attribute28,
				  p_attribute29,
				  p_attribute30,
				  l_return_status,
				  l_oracle_error,
				  l_msg_data);
Line: 493

      UPDATE gr_recipient_info
	  SET	 recipient_code 	 	 	 	 = p_recipient_code,
			 recipient_name	  				 = p_recipient_name,
			 document_code	  				 = p_document_code,
			 territory_code	  				 = p_territory_code,
			 print_recipient_product_code	 = p_print_recipient_product_code,
			 update_address_flag	  		 = p_update_address_flag,
			 disclose_all_ingredients_flag	 = p_disclose_all_ingred_flag,
			 address_to_print	  			 = p_address_to_print,
			 document_print_frequency	  	 = p_document_print_frequency,
			 disclosure_code	  			 = p_disclosure_code,
			 region_code	  				 = p_region_code,
			 cover_letter_id	  			 = p_cover_letter_id,
			 additional_documents_flag	  	 = p_additional_documents_flag,
			 additional_address_flag	     = p_additional_address_flag,
			 shipping_address	  			 = p_shipping_address,
			 invoice_address	  			 = p_invoice_address,
			 attribute_category				 = p_attribute_category,
			 attribute1						 = p_attribute1,
			 attribute2						 = p_attribute2,
			 attribute3						 = p_attribute3,
			 attribute4						 = p_attribute4,
			 attribute5						 = p_attribute5,
			 attribute6						 = p_attribute6,
			 attribute7						 = p_attribute7,
			 attribute8						 = p_attribute8,
			 attribute9						 = p_attribute9,
			 attribute10					 = p_attribute10,
			 attribute11					 = p_attribute11,
			 attribute12					 = p_attribute12,
			 attribute13					 = p_attribute13,
			 attribute14					 = p_attribute14,
			 attribute15					 = p_attribute15,
			 attribute16					 = p_attribute16,
			 attribute17					 = p_attribute17,
			 attribute18					 = p_attribute18,
			 attribute19					 = p_attribute19,
			 attribute20					 = p_attribute20,
			 attribute21					 = p_attribute11,
			 attribute22					 = p_attribute22,
			 attribute23					 = p_attribute23,
			 attribute24					 = p_attribute24,
			 attribute25					 = p_attribute25,
			 attribute26					 = p_attribute26,
			 attribute27					 = p_attribute27,
			 attribute28					 = p_attribute28,
			 attribute29					 = p_attribute29,
			 attribute30					 = p_attribute30,
			 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: 561

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 576

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 580

                           'GR_NO_RECORD_INSERTED');
Line: 591

      ROLLBACK TO SAVEPOINT Update_Row;
Line: 606

END Update_Row;
Line: 617

				  p_update_address_flag IN VARCHAR2,
				  p_disclose_all_ingred_flag IN VARCHAR2,
				  p_address_to_print IN VARCHAR2,
				  p_document_print_frequency IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_region_code IN VARCHAR2,
				  p_cover_letter_id IN VARCHAR2,
				  p_additional_documents_flag IN VARCHAR2,
				  p_additional_address_flag IN VARCHAR2,
				  p_shipping_address IN VARCHAR2,
				  p_invoice_address IN VARCHAR2,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 687

   SELECT	last_update_date
   FROM		gr_recipient_info
   WHERE	rowid = p_rowid
   FOR UPDATE NOWAIT;
Line: 713

   IF LockRecipientRcd.last_update_date <> p_last_update_date THEN
     RAISE RECORD_CHANGED_ERROR;
Line: 775

PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_recipient_code IN VARCHAR2,
				  p_recipient_name IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_territory_code IN VARCHAR2,
				  p_print_recipient_product_code IN VARCHAR2,
				  p_update_address_flag IN VARCHAR2,
				  p_disclose_all_ingred_flag IN VARCHAR2,
				  p_address_to_print IN VARCHAR2,
				  p_document_print_frequency IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_region_code IN VARCHAR2,
				  p_cover_letter_id IN VARCHAR2,
				  p_additional_documents_flag IN VARCHAR2,
				  p_additional_address_flag IN VARCHAR2,
				  p_shipping_address IN VARCHAR2,
				  p_invoice_address IN VARCHAR2,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 856

   SAVEPOINT Delete_Row;
Line: 871

				  p_update_address_flag,
				  p_disclose_all_ingred_flag,
				  p_address_to_print,
				  p_document_print_frequency,
				  p_disclosure_code,
				  p_region_code,
				  p_cover_letter_id,
				  p_additional_documents_flag,
				  p_additional_address_flag,
				  p_shipping_address,
				  p_invoice_address,
				  p_attribute_category,
				  p_attribute1,
				  p_attribute2,
				  p_attribute3,
				  p_attribute4,
				  p_attribute5,
				  p_attribute6,
				  p_attribute7,
				  p_attribute8,
				  p_attribute9,
				  p_attribute10,
				  p_attribute11,
				  p_attribute12,
				  p_attribute13,
				  p_attribute14,
				  p_attribute15,
				  p_attribute16,
				  p_attribute17,
				  p_attribute18,
				  p_attribute19,
				  p_attribute20,
				  p_attribute21,
				  p_attribute22,
				  p_attribute23,
				  p_attribute24,
				  p_attribute25,
				  p_attribute26,
				  p_attribute27,
				  p_attribute28,
				  p_attribute29,
				  p_attribute30,
				  l_return_status,
				  l_oracle_error,
				  l_msg_data);
Line: 921

   DELETE FROM gr_recipient_info
   WHERE  	   rowid = p_rowid;
Line: 933

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 943

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 958

      ROLLBACK TO SAVEPOINT Delete_Row;
Line: 974

END Delete_Row;
Line: 982

				  p_update_address_flag IN VARCHAR2,
				  p_disclose_all_ingred_flag IN VARCHAR2,
				  p_address_to_print IN VARCHAR2,
				  p_document_print_frequency IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_region_code IN VARCHAR2,
				  p_cover_letter_id IN VARCHAR2,
				  p_additional_documents_flag IN VARCHAR2,
				  p_additional_address_flag IN VARCHAR2,
				  p_shipping_address IN VARCHAR2,
				  p_invoice_address IN VARCHAR2,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 1044

   SELECT	dc.disclosure_code
   FROM		gr_disclosures dc
   WHERE	dc.disclosure_code = p_disclosure_code;
Line: 1051

   SELECT	ter.territory_code
   FROM		fnd_territories ter
   WHERE	ter.territory_code = p_territory_code;
Line: 1164

				  p_update_address_flag IN VARCHAR2,
				  p_disclose_all_ingred_flag IN VARCHAR2,
				  p_address_to_print IN VARCHAR2,
				  p_document_print_frequency IN VARCHAR2,
				  p_disclosure_code IN VARCHAR2,
				  p_region_code IN VARCHAR2,
				  p_cover_letter_id IN VARCHAR2,
				  p_additional_documents_flag IN VARCHAR2,
				  p_additional_address_flag IN VARCHAR2,
				  p_shipping_address IN VARCHAR2,
				  p_invoice_address IN VARCHAR2,
				  p_attribute_category IN VARCHAR2,
				  p_attribute1 IN VARCHAR2,
				  p_attribute2 IN VARCHAR2,
				  p_attribute3 IN VARCHAR2,
				  p_attribute4 IN VARCHAR2,
				  p_attribute5 IN VARCHAR2,
				  p_attribute6 IN VARCHAR2,
				  p_attribute7 IN VARCHAR2,
				  p_attribute8 IN VARCHAR2,
				  p_attribute9 IN VARCHAR2,
				  p_attribute10 IN VARCHAR2,
				  p_attribute11 IN VARCHAR2,
				  p_attribute12 IN VARCHAR2,
				  p_attribute13 IN VARCHAR2,
				  p_attribute14 IN VARCHAR2,
				  p_attribute15 IN VARCHAR2,
				  p_attribute16 IN VARCHAR2,
				  p_attribute17 IN VARCHAR2,
				  p_attribute18 IN VARCHAR2,
				  p_attribute19 IN VARCHAR2,
				  p_attribute20 IN VARCHAR2,
				  p_attribute21 IN VARCHAR2,
				  p_attribute22 IN VARCHAR2,
				  p_attribute23 IN VARCHAR2,
				  p_attribute24 IN VARCHAR2,
				  p_attribute25 IN VARCHAR2,
				  p_attribute26 IN VARCHAR2,
				  p_attribute27 IN VARCHAR2,
				  p_attribute28 IN VARCHAR2,
				  p_attribute29 IN VARCHAR2,
				  p_attribute30 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: 1227

   SELECT	COUNT(*)
   FROM		gr_dispatch_histories
   WHERE	recipient_code = p_recipient_code;
Line: 1308

   SELECT rec.rowid
   FROM	  gr_recipient_info rec
   WHERE  rec.recipient_code = p_recipient_code;