eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_ITEM_SAFETY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27


   SELECT lp.property_id,
	  lp.label_code,
	  lp.sequence_number,
	  pro.property_type_indicator,
	  pro.length,
	  pro.precision,
	  pro.range_min,
	  pro.range_max,
	  pd.description
   FROM	  gr_properties_tl pd,
   	  gr_label_properties lp,
          gr_properties_b pro
   WHERE  lp.label_code = p_label_code
   AND    lp.property_id = pro.property_id
   AND	  pd.property_id = lp.property_id
   AND    pd.language = USERENV('LANG')
   ORDER BY lp.sequence_number;

Line: 49


   SELECT ip.rowid,
          ip.organization_id,
          ip.inventory_item_id,
	  ip.number_value,
	  ip.alpha_value,
	  ip.date_value,
	  ip.created_by,
	  ip.creation_date,
	  ip.last_updated_by,
	  ip.last_update_date,
	  ip.last_update_login
   FROM	  gr_inv_item_properties ip
   WHERE  ip.organization_id   = p_organization_id
   AND    ip.inventory_item_id = p_inventory_item_id
   AND 	  ip.label_code        = p_label_code
   AND    ip.property_id       = PropRecord.property_id;

Line: 71


   SELECT   pv.meaning
   FROM	    gr_property_values_tl pv
   WHERE    pv.property_id = PropRecord.property_id
   AND	    pv.language = USERENV('LANG')
   AND	    pv.value = ItemPropRecord.alpha_value;

Line: 83


   x_prop_data.DELETE;

Line: 127


	    x_prop_data(l_record_number).last_updated_by   := ItemPropRecord.last_updated_by;

Line: 128


	    x_prop_data(l_record_number).last_update_date  := ItemPropRecord.last_update_date;

Line: 129


	    x_prop_data(l_record_number).last_update_login := ItemPropRecord.last_update_login;

Line: 197


INSERT_ROWS_ERROR       EXCEPTION;

Line: 198


UPDATE_ROWS_ERROR       EXCEPTION;

Line: 207


   SELECT  ig1.ROWID,
	   ig1.ingredient_flag,
	   ig1.explode_ingredient_flag,
	   ig1.organization_id,
	   ig1.inventory_item_id,
	   ig1.actual_hazard
   FROM    gr_item_explosion_properties ig1
   WHERE   ig1.organization_id   = p_organization_id
   AND     ig1.inventory_item_id = p_copy_from_item;

Line: 226


   SELECT  ig1.ROWID
   FROM    gr_item_explosion_properties ig1
   WHERE   ig1.organization_id   = p_organization_id
   AND     ig1.inventory_item_id = p_paste_to_item;

Line: 237


   SELECT  ip.sequence_number,
           ip.property_id,
	   ip.label_code,
	   ip.number_value,
	   ip.alpha_value,
	   ip.date_value
   FROM    gr_inv_item_properties ip
   WHERE   ip.organization_id   = p_organization_id
   AND     ip.inventory_item_id = p_copy_from_item;

Line: 253


   SELECT  ip.rowid
   FROM    gr_inv_item_properties ip
   WHERE   ip.organization_id   = p_organization_id
   AND     ip.inventory_item_id = p_paste_to_item
   AND     ip.label_code        = V_label_code
   AND     ip.property_id       = V_property_id
   AND     ip.sequence_number   = V_sequence_number;

Line: 269


select item_code
from gr_item_general_v
where organization_id = p_organization_id
and   inventory_item_id = V_item_id;

Line: 330


      l_code_block := ' table - Update gr_item_explosion_properties';

Line: 339


      GR_ITEM_EXPLOSION_PROP_PKG.Update_Row
	   			    (l_commit,
				     l_called_by_form,
                     LocalPItemRecord.rowid,
				     LocalItemRecord.ingredient_flag,
				     LocalItemRecord.explode_ingredient_flag,
				     p_organization_id,
				     p_paste_to_item,
				     LocalItemRecord.actual_hazard,
				     l_user_id,
				     l_current_date,
				     l_user_id,
				     l_current_date,
				     l_user_id,
				     l_return_status,
				     l_oracle_error,
				     l_msg_data);

Line: 358


        RAISE Update_Rows_Error;

Line: 368


      l_code_block := ' table - Insert gr_item_explosion_properties';

Line: 369


      GR_ITEM_EXPLOSION_PROP_PKG.Insert_Row
	   			    (l_commit,
				     l_called_by_form,
				     LocalItemRecord.ingredient_flag,
				     LocalItemRecord.explode_ingredient_flag,
				     p_organization_id,
				     p_paste_to_item,
				     LocalItemRecord.actual_hazard,
				     l_user_id,
				     l_current_date,
				     l_user_id,
				     l_current_date,
				     l_user_id,
                     l_rowid,
				     l_return_status,
				     l_oracle_error,
				     l_msg_data);

Line: 388


        RAISE Insert_Rows_Error;

Line: 407


            l_code_block := ' Insert table - gr_inv_item_properties ';

Line: 408


            GR_INV_ITEM_PROPERTIES_PKG.Insert_Row
         	   			 (l_commit,
				          l_called_by_form,
				          p_organization_id,
				          p_paste_to_item,
				          LocalItemPropRecord.sequence_number,
     				      LocalItemPropRecord.property_id,
				          LocalItemPropRecord.label_code,
				          LocalItemPropRecord.number_value,
				          LocalItemPropRecord.alpha_value,
				          LocalItemPropRecord.date_value,
				          l_user_id,
				          l_current_date,
				          l_user_id,
				          l_current_date,
				          l_user_id,
				          l_rowid,
				          l_return_status,
				          l_oracle_error,
				          l_msg_data);

Line: 430


               RAISE Insert_Rows_Error;

Line: 433


            l_code_block := ' Update table - gr_inv_item_properties ';

Line: 434


            GR_INV_ITEM_PROPERTIES_PKG.Update_Row
         	   			 (l_commit,
				          l_called_by_form,
				          LocalPItemPropRecord.rowid,
				          p_organization_id,
				          p_paste_to_item,
				          LocalItemPropRecord.sequence_number,
     				      LocalItemPropRecord.property_id,
				          LocalItemPropRecord.label_code,
				          LocalItemPropRecord.number_value,
				          LocalItemPropRecord.alpha_value,
				          LocalItemPropRecord.date_value,
				          l_user_id,
				          l_current_date,
				          l_user_id,
				          l_current_date,
				          l_user_id,
				          l_return_status,
				          l_oracle_error,
				          l_msg_data);

Line: 456


               RAISE Update_Rows_Error;

Line: 494


   WHEN Insert_Rows_Error THEN
      l_oracle_error := APP_EXCEPTION.Get_Code;

Line: 498


	                        'GR_NO_RECORD_INSERTED');

Line: 504


   WHEN Update_Rows_Error THEN
      l_oracle_error := APP_EXCEPTION.Get_Code;

Line: 508


	                        'GR_NO_RECORD_INSERTED');

Line: 526


PROCEDURE delete_item_safety
				(p_delete_item IN VARCHAR2,
				 x_return_status OUT NOCOPY VARCHAR2,
				 x_oracle_error OUT NOCOPY NUMBER,
				 x_msg_data OUT NOCOPY VARCHAR2)

 IS

/*
**	Alpha Variables
*/
L_CODE_BLOCK		VARCHAR2(2000);

Line: 541


L_DELETE_OPTION   VARCHAR2(1);

Line: 567


   SELECT      ig1.ROWID,
               ig1.item_group_code,
				   ig1.primary_cas_number,
				   ig1.ingredient_flag,
				   ig1.explode_ingredient_flag,
				   ig1.formula_source_indicator,
				   ig1.user_id,
				   ig1.internal_reference_number,
				   ig1.product_label_code,
				   ig1.version_code,
				   ig1.last_version_code,
				   ig1.product_class,
				   ig1.item_code,
				   ig1.actual_hazard,
				   ig1.print_ingredient_phrases_flag,
				   ig1.attribute_category,
				   ig1.attribute1,
				   ig1.attribute2,
				   ig1.attribute3,
				   ig1.attribute4,
				   ig1.attribute5,
				   ig1.attribute6,
				   ig1.attribute7,
				   ig1.attribute8,
				   ig1.attribute9,
				   ig1.attribute10,
				   ig1.attribute11,
				   ig1.attribute12,
				   ig1.attribute13,
				   ig1.attribute14,
				   ig1.attribute15,
				   ig1.attribute16,
				   ig1.attribute17,
				   ig1.attribute18,
				   ig1.attribute19,
				   ig1.attribute20,
				   ig1.attribute21,
				   ig1.attribute22,
				   ig1.attribute23,
				   ig1.attribute24,
				   ig1.attribute25,
				   ig1.attribute26,
				   ig1.attribute27,
				   ig1.attribute28,
				   ig1.attribute29,
				   ig1.attribute30,
				   ig1.created_by,
				   ig1.creation_date,
				   ig1.last_updated_by,
				   ig1.last_update_date,
				   ig1.last_update_login
   FROM        gr_item_general ig1
   WHERE       ig1.item_code = p_delete_item;

Line: 626


	SELECT     em.ROWID,
				  em.item_code,
				  em.european_index_number,
				  em.eec_number,
				  em.consolidated_risk_phrase,
				  em.consolidated_safety_phrase,
				  em.approved_supply_list_conc,
				  em.attribute_category,
				  em.attribute1,
				  em.attribute2,
				  em.attribute3,
				  em.attribute4,
				  em.attribute5,
				  em.attribute6,
				  em.attribute7,
				  em.attribute8,
				  em.attribute9,
				  em.attribute10,
				  em.attribute11,
				  em.attribute12,
				  em.attribute13,
				  em.attribute14,
				  em.attribute15,
				  em.attribute16,
				  em.attribute17,
				  em.attribute18,
				  em.attribute19,
				  em.attribute20,
				  em.attribute21,
				  em.attribute22,
				  em.attribute23,
				  em.attribute24,
				  em.attribute25,
				  em.attribute26,
				  em.attribute27,
				  em.attribute28,
				  em.attribute29,
				  em.attribute30,
				  em.created_by,
				  em.creation_date,
				  em.last_updated_by,
				  em.last_update_date,
				  em.last_update_login
   FROM       gr_emea em
   WHERE      em.item_code = p_delete_item;

Line: 679


   IF p_delete_item IS NULL THEN
      RAISE Item_Null_Error;

Line: 746


				     LocalItemRecord.last_updated_by,
				     LocalItemRecord.last_update_date,
				     LocalItemRecord.last_update_login,
				     l_return_status,
				     l_oracle_error,
				     l_msg_data);

Line: 757


** Main row locked ok, now delete the subsidiary tables
*/
   l_delete_option := 'I';

Line: 761


   GR_OTHER_NAMES_TL_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 775


   l_delete_option := 'I';

Line: 777


   GR_MULTILINGUAL_NAME_TL_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 791


   l_delete_option := 'I';

Line: 793


   GR_ITEM_SAFETY_PHRASES_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 811


   l_delete_option := 'I';

Line: 813


   GR_ITEM_RISK_PHRASES_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 828


   GR_ITEM_RIGHT_TO_KNOW_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   p_delete_item,
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 840


   l_delete_option := 'I';

Line: 842


   GR_ITEM_SAFETY.Delete_item_document
                  (p_delete_item,
                   '',
			 l_delete_option,
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 854


   l_delete_option := 'I';

Line: 856


   GR_ITEM_CLASSNS_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 871


   GR_ITEM_DISCLOSURES_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   p_delete_item,
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 884


   GR_ITEM_CONC_DETAILS_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   p_delete_item,
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 897


   GR_ITEM_CONCENTRATIONS_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   p_delete_item,
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 909


   l_delete_option := 'I';

Line: 911


   GR_ITEM_PROPERTIES_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 925


   l_delete_option := 'I';

Line: 927


   GR_ITEM_TOXIC_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   '',
                   '',
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 944


   l_delete_option := 'I';

Line: 946


   GR_ITEM_EXPOSURE_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   '',
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 962


   l_delete_option := 'G';

Line: 964


   GR_GENERIC_ML_NAME_TL_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 978


   l_delete_option := 'G';

Line: 980


   GR_GENERIC_ITEMS_B_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   l_delete_option,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 1004


      GR_EMEA_PKG.Delete_Row
	   			 (l_commit,
				     l_called_by_form,
				     LocalEmeaRecord.ROWID,
				     LocalEmeaRecord.item_code,
				     LocalEmeaRecord.european_index_number,
				     LocalEmeaRecord.eec_number,
				     LocalEmeaRecord.consolidated_risk_phrase,
				     LocalEmeaRecord.consolidated_safety_phrase,
				     LocalEmeaRecord.approved_supply_list_conc,
				     LocalEmeaRecord.attribute_category,
				     LocalEmeaRecord.attribute1,
				     LocalEmeaRecord.attribute2,
				     LocalEmeaRecord.attribute3,
				     LocalEmeaRecord.attribute4,
				     LocalEmeaRecord.attribute5,
				     LocalEmeaRecord.attribute6,
				     LocalEmeaRecord.attribute7,
				     LocalEmeaRecord.attribute8,
				     LocalEmeaRecord.attribute9,
				     LocalEmeaRecord.attribute10,
				     LocalEmeaRecord.attribute11,
				     LocalEmeaRecord.attribute12,
				     LocalEmeaRecord.attribute13,
				     LocalEmeaRecord.attribute14,
				     LocalEmeaRecord.attribute15,
				     LocalEmeaRecord.attribute16,
				     LocalEmeaRecord.attribute17,
				     LocalEmeaRecord.attribute18,
				     LocalEmeaRecord.attribute19,
				     LocalEmeaRecord.attribute20,
				     LocalEmeaRecord.attribute21,
				     LocalEmeaRecord.attribute22,
				     LocalEmeaRecord.attribute23,
				     LocalEmeaRecord.attribute24,
				     LocalEmeaRecord.attribute25,
				     LocalEmeaRecord.attribute26,
				     LocalEmeaRecord.attribute27,
				     LocalEmeaRecord.attribute28,
				     LocalEmeaRecord.attribute29,
				     LocalEmeaRecord.attribute30,
				     LocalEmeaRecord.created_by,
				     LocalEmeaRecord.creation_date,
				     LocalEmeaRecord.last_updated_by,
				     LocalEmeaRecord.last_update_date,
				     LocalEmeaRecord.last_update_login,
				     l_return_status,
				     l_oracle_error,
				     l_msg_data);

Line: 1059


** Delete the item general row
*/
   l_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1062


   GR_ITEM_GENERAL_PKG.Delete_Row
	   			 (l_commit,
				     l_called_by_form,
				     LocalItemRecord.ROWID,
				     LocalItemRecord.item_group_code,
				     LocalItemRecord.primary_cas_number,
				     LocalItemRecord.ingredient_flag,
				     LocalItemRecord.explode_ingredient_flag,
				     LocalItemRecord.formula_source_indicator,
				     LocalItemRecord.user_id,
				     LocalItemRecord.internal_reference_number,
				     LocalItemRecord.product_label_code,
				     LocalItemRecord.version_code,
				     LocalItemRecord.last_version_code,
				     LocalItemRecord.product_class,
				     LocalItemRecord.item_code,
				     LocalItemRecord.actual_hazard,
				     LocalItemRecord.print_ingredient_phrases_flag,
				     LocalItemRecord.attribute_category,
				     LocalItemRecord.attribute1,
				     LocalItemRecord.attribute2,
				     LocalItemRecord.attribute3,
				     LocalItemRecord.attribute4,
				     LocalItemRecord.attribute5,
				     LocalItemRecord.attribute6,
				     LocalItemRecord.attribute7,
				     LocalItemRecord.attribute8,
				     LocalItemRecord.attribute9,
				     LocalItemRecord.attribute10,
				     LocalItemRecord.attribute11,
				     LocalItemRecord.attribute12,
				     LocalItemRecord.attribute13,
				     LocalItemRecord.attribute14,
				     LocalItemRecord.attribute15,
				     LocalItemRecord.attribute16,
				     LocalItemRecord.attribute17,
				     LocalItemRecord.attribute18,
				     LocalItemRecord.attribute19,
				     LocalItemRecord.attribute20,
				     LocalItemRecord.attribute21,
				     LocalItemRecord.attribute22,
				     LocalItemRecord.attribute23,
				     LocalItemRecord.attribute24,
				     LocalItemRecord.attribute25,
				     LocalItemRecord.attribute26,
				     LocalItemRecord.attribute27,
				     LocalItemRecord.attribute28,
				     LocalItemRecord.attribute29,
				     LocalItemRecord.attribute30,
				     LocalItemRecord.created_by,
				     LocalItemRecord.creation_date,
				     LocalItemRecord.last_updated_by,
				     LocalItemRecord.last_update_date,
				     LocalItemRecord.last_update_login,
				     l_return_status,
				     l_oracle_error,
				     l_msg_data);

Line: 1142


	                         p_delete_item,
	                         FALSE);

Line: 1174


END delete_item_safety;

Line: 1176


PROCEDURE delete_item_document
				(p_delete_item IN VARCHAR2,
                         p_document_code IN VARCHAR2,
                         p_delete_option IN VARCHAR2,
				 x_return_status OUT NOCOPY VARCHAR2,
				 x_oracle_error OUT NOCOPY NUMBER,
				 x_msg_data OUT NOCOPY VARCHAR2)
 IS

/*
**	Alpha Variables
*/
L_CODE_BLOCK		VARCHAR2(2000);

Line: 1213


   SELECT      dp.document_text_id
   FROM        gr_document_print dp
   WHERE       dp.item_code = p_delete_item
     AND	   (p_document_code IS NULL OR
               dp.document_code = p_document_code);

Line: 1226


   IF p_delete_item IS NULL THEN
      RAISE Item_Null_Error;

Line: 1232


   GR_ITEM_DOCUMENT_DTLS_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   p_delete_option,
                   p_delete_item,
                   p_document_code,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 1248


   GR_ITEM_DOC_STATUSES_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   p_delete_option,
                   p_delete_item,
                   p_document_code,
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 1263


** Delete from dispatch history
*/
   l_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1266


   GR_DISPATCH_HISTORIES_PKG.Delete_Rows
                  (l_commit,
                   l_called_by_form,
                   p_delete_option,
                   p_document_code,
                   p_delete_item,
                   '',
                   l_return_status,
                   l_oracle_error,
                   l_msg_data);

Line: 1277


** Delete from document print tables.
*/
   OPEN c_get_document_print;

Line: 1284


         GR_DOCUMENT_DETAILS_PKG.Delete_Rows
                            (l_commit,
                             l_called_by_form,
                             LocalDocumentPrint.document_text_id,
                             l_return_status,
                             l_oracle_error,
                             l_msg_data);

Line: 1301


   GR_DOCUMENT_PRINT_PKG.Delete_Rows
                    (l_commit,
                     l_called_by_form,
                     p_delete_option,
                     p_document_code,
                     p_delete_item,
                     '',
                     '',
                     l_return_status,
                     l_oracle_error,
                     l_msg_data);

Line: 1348


END delete_item_document;