APPS.HXC_BLOCK_ATTRIBUTE_UPDATE SQL Statements

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

Line: 21

  select scope
    from hxc_time_building_blocks
   where time_building_block_id = p_id
     and object_version_number = p_ovn;

Line: 177

  hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 0');

Line: 178

  hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

Line: 192

	   hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 1');

Line: 195

     hxc_block_attribute_update.g_tc_api_flag := 'N'; -- Added for Bug  12774447

Line: 198

	   hr_utility.trace('In  hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);

Line: 215

        hr_utility.trace('In hxc_block_attribute_update.set_block_process_flags 2');

Line: 237

        hr_utility.trace('In  hxc_block_attribute_update.g_tc_api_flag ::'|| hxc_block_attribute_update.g_tc_api_flag);

Line: 273

  hr_utility.trace('In hxc_block_attribute_update.set_attribute_process_flags 0');

Line: 274

  hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

Line: 290

      hr_utility.trace('In hxc_block_attribute_update.set_attribute_process_flags 1');

Line: 293

    hxc_block_attribute_update.g_tc_api_flag := 'N'; -- Added for Bug 12774447

Line: 296

	  hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

Line: 334

        hr_utility.trace('hxc_block_attribute_update.g_tc_api_flag is set to ::'|| hxc_block_attribute_update.g_tc_api_flag);

Line: 484

  hr_utility.trace('In hxc_block_attribute_update.set_process_flage 0');

Line: 487

hxc_block_attribute_update.g_tc_api_flag := null; -- Added for Bug 12774447