APPS.GR_ITEM_PROPERTIES_PUB SQL Statements

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

Line: 17

 * Updated By              For                                   *
 *                                                               *
 * 		                                                           *
 *****************************************************************
*/

--   Global variables

G_PKG_NAME           CONSTANT  VARCHAR2(30):='GR_ITEM_PROPERTIES_PUB';

Line: 86

  l_last_update_login NUMBER(15,0) := 0;

Line: 106

SELECT    organization_id INTO l_organization_id
          FROM mtl_organizations
          WHERE organization_code = l_organization;

Line: 111

SELECT inventory_item_id into l_inventory_item_id
       FROM mtl_system_items_b_kfv
       WHERE concatenated_segments = l_item
			 AND organization_id = l_organization_id;

Line: 117

SELECT 1
 FROM mtl_system_items_b
       WHERE inventory_item_id = l_inventory_item_id
       AND organization_id = l_organization_id
       AND hazardous_material_flag = 'Y';

Line: 124

SELECT 1
FROM
GR_LABELS_B B
    where B.LABEL_CODE = l_field_name_code;

Line: 130

SELECT lcb.form_block
FROM
GR_LABELS_B B , gr_label_classes_b lcb
    where B.LABEL_CODE = l_field_name_code and
    lcb.label_class_code = b.label_class_code
    and lcb.form_block in ('SAFETY_PHRASES', 'RISK_PHRASES' );

Line: 138

  SELECT safety_phrase_code
  FROM	gr_safety_phrases_vl
  WHERE	safety_phrase_code = l_phrase_code;

Line: 143

  SELECT risk_phrase_code
  FROM	gr_risk_phrases_vl
  WHERE	risk_phrase_code = l_phrase_code;

Line: 149

  SELECT safety_phrase_code
  FROM	gr_inv_item_safety_phrases
  WHERE	safety_phrase_code = l_phrase_code
  and organization_id = l_organization_id
  and inventory_item_id = l_inventory_item_id;

Line: 157

  SELECT risk_phrase_code
  FROM	gr_inv_item_risk_phrases
  WHERE	risk_phrase_code = l_phrase_code
  and organization_id = l_organization_id
  and inventory_item_id = l_inventory_item_id;

Line: 165

SELECT lp.sequence_number
FROM	gr_label_properties lp
WHERE  lp.label_code = l_field_name_code
AND    lp.property_id = l_property_id;

Line: 171

SELECT 1
FROM
GR_PROPERTIES_B B
    where B.PROPERTY_ID = l_property_id;

Line: 177

SELECT property_type_indicator,
LENGTH,
PRECISION,
range_min,
range_max
FROM
GR_PROPERTIES_B B
    where B.PROPERTY_ID = l_property_id;

Line: 187

select 1
from GR_PROPERTY_values_TL
WHERE property_id  = l_property_id
and language = l_language_code
and value = l_alpha_value;

Line: 666

	          INSERT INTO GR_INV_ITEM_SAFETY_PHRASES
	   		  	     (organization_id,
									inventory_item_id,
									safety_phrase_code,
									created_by,
									creation_date,
									last_updated_by,
									last_update_date,
									last_update_login)
	          VALUES
			         (l_organization_id,
								l_inventory_item_id,
								l_phrase_code,
							  fnd_global.user_id,
				  	 		sysdate,
				  	 		fnd_global.user_id,
				  	 		sysdate,
				  	 		l_last_update_login);

Line: 719

	          INSERT INTO GR_INV_ITEM_RISK_PHRASES
	   		  	     (organization_id,
									inventory_item_id,
									risk_phrase_code,
									created_by,
									creation_date,
									last_updated_by,
									last_update_date,
									last_update_login)
	          VALUES
			         (l_organization_id,
								l_inventory_item_id,
								l_phrase_code,
							  fnd_global.user_id,
				  	 		sysdate,
				  	 		fnd_global.user_id,
				  	 		sysdate,
				  	 		l_last_update_login);

Line: 758

		          GR_INV_ITEM_PROPERTIES_PKG.Insert_Row (
		          p_commit                     => p_commit,
		          p_called_by_form              => 'F',
		          p_organization_id   => l_organization_id,
		          p_inventory_item_id => l_inventory_item_id,
						  p_sequence_number   => l_sequence_number,  -- populated by gr_item_safety.get_properties
						  p_property_id       => l_property_id ,
						  p_label_code        => l_field_name_code,
						  p_number_value      => l_numeric_value,
						  p_alpha_value       => l_alpha_value,
						  p_date_value        => l_date_value,
						  p_created_by   =>                FND_GLOBAL.USER_ID,
						  p_creation_date   =>             SYSDATE,
						  p_last_updated_by  =>            FND_GLOBAL.USER_ID,
						  p_last_update_date =>            SYSDATE,
						  p_last_update_login  =>          l_last_update_login,
						  x_rowid  => row_id,
						  x_return_status		=> return_status,
							x_oracle_error		=> oracle_error,
							x_msg_data			=> msg_data);

Line: 786

										                        'GR_NO_RECORD_INSERTED');

Line: 806

			          update gr_inv_item_properties
			          set number_value = l_numeric_value   ,
		              alpha_value = l_alpha_value,
		              date_value =  l_date_value,
		              last_updated_by				 = fnd_global.user_id,
				 					last_update_date				 = sysdate,
				 					last_update_login			 = l_last_update_login
				        WHERE organization_id = l_organization_id and
		            inventory_item_id = l_inventory_item_id
		            and label_code = l_field_name_code
		            and property_id =  l_property_id;

Line: 860

		          DELETE from GR_INV_ITEM_SAFETY_PHRASES
	            WHERE organization_id = l_organization_id and
	            inventory_item_id = l_inventory_item_id
	            and safety_phrase_code = l_phrase_code;

Line: 879

           		--  validate that the record exists, and delete the record from the GR_INV_ITEM_RISK_PHRASES table
           		--  An error message will be written to the log file if the record does not exist

	 				  	 OPEN c_get_item_risk_phrase;

Line: 893

		   	  	  DELETE from GR_INV_ITEM_RISK_PHRASES
	            WHERE organization_id = l_organization_id and
	            inventory_item_id = l_inventory_item_id
	            and risk_phrase_code = l_phrase_code;

Line: 913

		          GR_INV_ITEM_PROPERTIES_PKG.delete_Rows
		         (p_commit                     => p_commit,
		          p_called_by_form              => 'F',
		          p_delete_option     => 'B', --  'B' Delete all rows using the item and label combination.
  		        p_organization_id   => l_organization_id,
		          p_inventory_item_id => l_inventory_item_id,
     				  p_label_code        => l_field_name_code,
     					x_return_status		=> return_status,
							x_oracle_error		=> oracle_error,
							x_msg_data			=> msg_data);

Line: 929

										                        'GR_NO_RECORD_INSERTED');