APPS.HXC_ALIAS_TRANSLATOR SQL Statements

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

Line: 23

l_index_to_delete 	NUMBER;

Line: 38

l_att_to_delete			BOOLEAN;

Line: 149

     l_att_to_delete := FALSE;

Line: 157

     				  ,p_att_to_delete		=> l_att_to_delete);

Line: 208

        IF l_attribute_found = FALSE AND l_att_to_delete = FALSE THEN

if g_debug then
	hr_utility.trace('create');

Line: 306

	  -- update the attribute
          -- now we need to place the id of this alias at the right place
           IF l_att_to_delete = FALSE THEN
             hxc_alias_utility.set_attribute_information
  		(p_attributes 	=> p_attributes,
        	 p_index_in_table	=> l_attribute_index,
		 p_attribute_to_set	=> l_segment,
		 p_value_to_set		=> l_value);

Line: 316

	hr_utility.trace('DELETE');

Line: 345

       l_index_to_delete := l_index_attribute;

Line: 352

IF p_attributes.exists(l_index_to_delete) THEN
 p_attributes.delete(l_index_to_delete);

Line: 440

    IS SELECT format_type
         FROM fnd_flex_value_sets
        WHERE flex_value_set_id = p_reference_object;

Line: 746

          p_attributes.delete(to_number(p_alias_att_ref(l_time_building_block_id).ATTRIBUTE_INDEX));

Line: 978

select  alias_value_id ,alias_value_name
from  hxc_alias_values
where alias_definition_id = p_alias_definition_id
and   enabled_flag	  = 'Y'
and   date_from <= p_stop_time
and   nvl(date_to,hr_general.end_of_time) >= p_start_time;

Line: 1150

      l_alias_att_ref.delete;

Line: 1153

      l_alias_att_ref.delete;

Line: 1174

  l_alias_val_att_to_match.delete;

Line: 1188

     l_alias_val_att_to_match.delete;