APPS.GR_DOCUMENT_CODES_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_document_code IN VARCHAR2,
				  p_user_id IN NUMBER,
				  p_document_version IN NUMBER,
				  p_document_description IN VARCHAR2,
				  p_document_history_flag IN VARCHAR2,
				  p_allow_user_override IN VARCHAR2,
				  p_document_date_format IN VARCHAR2,
				  p_print_ingredients_flag IN VARCHAR2,
				  p_ingredient_header_label IN VARCHAR2,
				  p_ingredient_conc_ind IN VARCHAR2,
				  p_cas_number_seq IN NUMBER,
				  p_msds_name_seq IN NUMBER,
				  p_concentration_seq IN NUMBER,
				  p_hmis_code_seq IN NUMBER,
				  p_nfpa_code_seq IN NUMBER,
				  p_user_code_seq IN NUMBER,
				  p_eec_number_seq IN NUMBER,
				  p_hazard_symbol_seq IN NUMBER,
				  p_risk_phrase_seq IN NUMBER,
				  p_safety_phrase_seq IN NUMBER,
				  p_print_toxic_info_flag IN VARCHAR2,
				  p_toxic_header_label IN VARCHAR2,
				  p_toxic_cas_number_seq IN NUMBER,
				  p_toxic_msds_name_seq IN NUMBER,
				  p_toxic_route_seq IN NUMBER,
				  p_toxic_species_seq IN NUMBER,
				  p_toxic_exposure_seq IN NUMBER,
				  p_toxic_dose_seq IN NUMBER,
				  p_toxic_note_seq IN NUMBER,
				  p_print_exposure_flag IN VARCHAR2,
				  p_exposure_header_label IN VARCHAR2,
				  p_exposure_cas_number_seq IN NUMBER,
				  p_exposure_msds_name_seq IN NUMBER,
				  p_exposure_authority_seq IN NUMBER,
				  p_exposure_type_seq IN NUMBER,
				  p_exposure_dose_seq IN NUMBER,
				  p_exposure_note_seq IN NUMBER,
				  p_include_qc_data_flag IN VARCHAR2,
				  p_prop_65_conc_ind IN VARCHAR2,
				  p_sara_312_conc_ind IN VARCHAR2,
				  p_print_rtk_on_document IN VARCHAR2,
				  p_rtk_header IN VARCHAR2,
				  p_print_all_state_indicator IN VARCHAR2,
				  p_approval_process_flag 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: 114

   SAVEPOINT Insert_Row;

Line: 216

   INSERT INTO gr_document_codes
   		  	     (document_code,
				  user_id,
				  document_version,
				  document_description,
				  document_history_flag,
				  allow_user_override,
				  document_date_format,
				  print_ingredients_flag,
				  ingredient_header_label,
				  ingredient_conc_ind,
				  cas_number_seq,
				  msds_name_seq,
				  concentration_seq,
				  hmis_code_seq,
				  nfpa_code_seq,
				  user_code_seq,
				  eec_number_seq,
				  hazard_symbol_seq,
				  risk_phrase_seq,
				  safety_phrase_seq,
				  print_toxic_info_flag,
				  toxic_header_label,
				  toxic_cas_number_seq,
				  toxic_msds_name_seq,
				  toxic_route_seq,
				  toxic_species_seq,
				  toxic_exposure_seq,
				  toxic_dose_seq,
				  toxic_note_seq,
				  print_exposure_flag,
				  exposure_header_label,
				  exposure_cas_number_seq,
				  exposure_msds_name_seq,
				  exposure_authority_seq,
				  exposure_type_seq,
				  exposure_dose_seq,
				  exposure_note_seq,
				  include_qc_data_flag,
				  prop_65_conc_ind,
				  sara_312_conc_ind,
				  print_rtk_on_document,
				  rtk_header,
				  print_all_state_indicator,
				  approval_process_flag,
				  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_document_code,
				  p_user_id,
				  p_document_version,
				  p_document_description,
				  p_document_history_flag,
				  p_allow_user_override,
				  p_document_date_format,
				  p_print_ingredients_flag,
				  p_ingredient_header_label,
				  p_ingredient_conc_ind,
				  p_cas_number_seq,
				  p_msds_name_seq,
				  p_concentration_seq,
				  p_hmis_code_seq,
				  p_nfpa_code_seq,
				  p_user_code_seq,
				  p_eec_number_seq,
				  p_hazard_symbol_seq,
				  p_risk_phrase_seq,
				  p_safety_phrase_seq,
				  p_print_toxic_info_flag,
				  p_toxic_header_label,
				  p_toxic_cas_number_seq,
				  p_toxic_msds_name_seq,
				  p_toxic_route_seq,
				  p_toxic_species_seq,
				  p_toxic_exposure_seq,
				  p_toxic_dose_seq,
				  p_toxic_note_seq,
				  p_print_exposure_flag,
				  p_exposure_header_label,
				  p_exposure_cas_number_seq,
				  p_exposure_msds_name_seq,
				  p_exposure_authority_seq,
				  p_exposure_type_seq,
				  p_exposure_dose_seq,
				  p_exposure_note_seq,
				  p_include_qc_data_flag,
				  p_prop_65_conc_ind,
				  p_sara_312_conc_ind,
				  p_print_rtk_on_document,
				  p_rtk_header,
				  p_print_all_state_indicator,
				  p_approval_process_flag,
		          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: 379

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

   Check_Primary_Key
   	   	   		 (p_document_code,
				  'F',
				  l_rowid,
				  l_key_exists);

Line: 402

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 417

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 432

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 436

                           'GR_NO_RECORD_INSERTED');

Line: 447

      ROLLBACK TO SAVEPOINT Insert_Row;

Line: 462

END Insert_Row;

Line: 464

PROCEDURE Update_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_user_id IN NUMBER,
				  p_document_version IN NUMBER,
				  p_document_description IN VARCHAR2,
				  p_document_history_flag IN VARCHAR2,
				  p_allow_user_override IN VARCHAR2,
				  p_document_date_format IN VARCHAR2,
				  p_print_ingredients_flag IN VARCHAR2,
				  p_ingredient_header_label IN VARCHAR2,
				  p_ingredient_conc_ind IN VARCHAR2,
				  p_cas_number_seq IN NUMBER,
				  p_msds_name_seq IN NUMBER,
				  p_concentration_seq IN NUMBER,
				  p_hmis_code_seq IN NUMBER,
				  p_nfpa_code_seq IN NUMBER,
				  p_user_code_seq IN NUMBER,
				  p_eec_number_seq IN NUMBER,
				  p_hazard_symbol_seq IN NUMBER,
				  p_risk_phrase_seq IN NUMBER,
				  p_safety_phrase_seq IN NUMBER,
				  p_print_toxic_info_flag IN VARCHAR2,
				  p_toxic_header_label IN VARCHAR2,
				  p_toxic_cas_number_seq IN NUMBER,
				  p_toxic_msds_name_seq IN NUMBER,
				  p_toxic_route_seq IN NUMBER,
				  p_toxic_species_seq IN NUMBER,
				  p_toxic_exposure_seq IN NUMBER,
				  p_toxic_dose_seq IN NUMBER,
				  p_toxic_note_seq IN NUMBER,
				  p_print_exposure_flag IN VARCHAR2,
				  p_exposure_header_label IN VARCHAR2,
				  p_exposure_cas_number_seq IN NUMBER,
				  p_exposure_msds_name_seq IN NUMBER,
				  p_exposure_authority_seq IN NUMBER,
				  p_exposure_type_seq IN NUMBER,
				  p_exposure_dose_seq IN NUMBER,
				  p_exposure_note_seq IN NUMBER,
				  p_include_qc_data_flag IN VARCHAR2,
				  p_prop_65_conc_ind IN VARCHAR2,
				  p_sara_312_conc_ind IN VARCHAR2,
				  p_print_rtk_on_document IN VARCHAR2,
				  p_rtk_header IN VARCHAR2,
				  p_print_all_state_indicator IN VARCHAR2,
				  p_approval_process_flag 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: 571

   SAVEPOINT Update_Row;

Line: 661

      UPDATE gr_document_codes
      SET	 document_code				  	 = p_document_code,
			 user_id	  					 = p_user_id,
			 document_version	  			 = p_document_version,
			 document_description	  		 = p_document_description,
			 document_history_flag	  		 = p_document_history_flag,
			 allow_user_override	  		 = p_allow_user_override,
			 document_date_format	  		 = p_document_date_format,
			 print_ingredients_flag	  		 = p_print_ingredients_flag,
			 ingredient_header_label	  	 = p_ingredient_header_label,
			 ingredient_conc_ind	  		 = p_ingredient_conc_ind,
			 cas_number_seq	  				 = p_cas_number_seq,
			 msds_name_seq	  				 = p_msds_name_seq,
			 concentration_seq	  			 = p_concentration_seq,
			 hmis_code_seq	  				 = p_hmis_code_seq,
			 nfpa_code_seq				  	 = p_nfpa_code_seq,
			 user_code_seq	  				 = p_user_code_seq,
			 eec_number_seq	  				 = p_eec_number_seq,
			 hazard_symbol_seq	  			 = p_hazard_symbol_seq,
			 risk_phrase_seq	  			 = p_risk_phrase_seq,
			 safety_phrase_seq	  			 = p_safety_phrase_seq,
			 print_toxic_info_flag	  		 = p_print_toxic_info_flag,
			 toxic_header_label	  			 = p_toxic_header_label,
			 toxic_cas_number_seq	  		 = p_toxic_cas_number_seq,
			 toxic_msds_name_seq	  		 = p_toxic_msds_name_seq,
			 toxic_route_seq	  			 = p_toxic_route_seq,
		         toxic_species_seq                               = p_toxic_species_seq,
			 toxic_exposure_seq	  			 = p_toxic_exposure_seq,
			 toxic_dose_seq	  				 = p_toxic_dose_seq,
			 toxic_note_seq	  				 = p_toxic_note_seq,
			 print_exposure_flag	  		 = p_print_exposure_flag,
			 exposure_header_label	  		 = p_exposure_header_label,
			 exposure_cas_number_seq	  	 = p_exposure_cas_number_seq,
			 exposure_msds_name_seq	  	 	 = p_exposure_msds_name_seq,
			 exposure_authority_seq	  		 = p_exposure_authority_seq,
			 exposure_type_seq	  			 = p_exposure_type_seq,
			 exposure_dose_seq	  			 = p_exposure_dose_seq,
			 exposure_note_seq	  			 = p_exposure_note_seq,
			 include_qc_data_flag	  		 = p_include_qc_data_flag,
			 prop_65_conc_ind	  			 = p_prop_65_conc_ind,
			 sara_312_conc_ind	  			 = p_sara_312_conc_ind,
			 print_rtk_on_document	  		 = p_print_rtk_on_document,
			 rtk_header	  					 = p_rtk_header,
			 print_all_state_indicator	  	 = p_print_all_state_indicator,
			 approval_process_flag	  		 = p_approval_process_flag,
			 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: 757

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 772

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 776

                           'GR_NO_RECORD_INSERTED');

Line: 787

      ROLLBACK TO SAVEPOINT Update_Row;

Line: 802

END Update_Row;

Line: 885

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

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

Line: 987

PROCEDURE Delete_Row
	   			 (p_commit IN VARCHAR2,
				  p_called_by_form IN VARCHAR2,
				  p_rowid IN VARCHAR2,
				  p_document_code IN VARCHAR2,
				  p_user_id IN NUMBER,
				  p_document_version IN NUMBER,
				  p_document_description IN VARCHAR2,
				  p_document_history_flag IN VARCHAR2,
				  p_allow_user_override IN VARCHAR2,
				  p_document_date_format IN VARCHAR2,
				  p_print_ingredients_flag IN VARCHAR2,
				  p_ingredient_header_label IN VARCHAR2,
				  p_ingredient_conc_ind IN VARCHAR2,
				  p_cas_number_seq IN NUMBER,
				  p_msds_name_seq IN NUMBER,
				  p_concentration_seq IN NUMBER,
				  p_hmis_code_seq IN NUMBER,
				  p_nfpa_code_seq IN NUMBER,
				  p_user_code_seq IN NUMBER,
				  p_eec_number_seq IN NUMBER,
				  p_hazard_symbol_seq IN NUMBER,
				  p_risk_phrase_seq IN NUMBER,
				  p_safety_phrase_seq IN NUMBER,
				  p_print_toxic_info_flag IN VARCHAR2,
				  p_toxic_header_label IN VARCHAR2,
				  p_toxic_cas_number_seq IN NUMBER,
				  p_toxic_msds_name_seq IN NUMBER,
				  p_toxic_route_seq IN NUMBER,
				  p_toxic_species_seq IN NUMBER,
				  p_toxic_exposure_seq IN NUMBER,
				  p_toxic_dose_seq IN NUMBER,
				  p_toxic_note_seq IN NUMBER,
				  p_print_exposure_flag IN VARCHAR2,
				  p_exposure_header_label IN VARCHAR2,
				  p_exposure_cas_number_seq IN NUMBER,
				  p_exposure_msds_name_seq IN NUMBER,
				  p_exposure_authority_seq IN NUMBER,
				  p_exposure_type_seq IN NUMBER,
				  p_exposure_dose_seq IN NUMBER,
				  p_exposure_note_seq IN NUMBER,
				  p_include_qc_data_flag IN VARCHAR2,
				  p_prop_65_conc_ind IN VARCHAR2,
				  p_sara_312_conc_ind IN VARCHAR2,
				  p_print_rtk_on_document IN VARCHAR2,
				  p_rtk_header IN VARCHAR2,
				  p_print_all_state_indicator IN VARCHAR2,
				  p_approval_process_flag 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: 1096

   SAVEPOINT Delete_Row;

Line: 1189

   DELETE FROM gr_document_codes
   WHERE  	   rowid = p_rowid;

Line: 1201

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 1211

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 1226

      ROLLBACK TO SAVEPOINT Delete_Row;

Line: 1241

END Delete_Row;

Line: 1341

   SELECT	mh.main_heading_code
   FROM		gr_main_headings_b mh
   WHERE	mh.main_heading_code = l_heading;

Line: 1350

   SELECT	fnu.user_id
   FROM		fnd_user fnu
   WHERE	fnu.user_id = p_user_id;

Line: 1551

   SELECT	COUNT(*)
   FROM		gr_dispatch_histories
   WHERE	document_code = p_document_code;

Line: 1559

   SELECT	COUNT(*)
   FROM		gr_document_print
   WHERE	document_code = p_document_code;

Line: 1567

   SELECT	COUNT(*)
   FROM		gr_item_document_dtls
   WHERE	document_code = p_document_code;

Line: 1575

   SELECT	COUNT(*)
   FROM		gr_item_doc_statuses
   WHERE	document_code = p_document_code;

Line: 1583

   SELECT	COUNT(*)
   FROM		gr_recipient_documents
   WHERE	document_code = p_document_code;

Line: 1591

   SELECT	COUNT(*)
   FROM		gr_recipient_info
   WHERE	document_code = p_document_code;

Line: 1731

   SELECT dc.rowid
   FROM	  gr_document_codes dc
   WHERE  dc.document_code = p_document_code;