APPS.HXC_TIMECARD_BLOCK_UTILS SQL Statements

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

Line: 242

  select 'Y'
    from hxc_time_building_blocks tbb
   where tbb.time_building_block_id = p_block_id
     and tbb.object_version_number = p_block_ovn;

Line: 312

Function is_updated_block
          (p_block in HXC_BLOCK_TYPE)
          return BOOLEAN is

l_prev_block hxc_block_type;

Line: 343

End is_updated_block;

Line: 424

select *
  from hxc_time_building_blocks
 where time_building_block_id = p_time_building_block_id
   and object_version_number = p_time_building_block_ovn;

Line: 513

       hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 517

       hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 521

       hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 528

      hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 533

      hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 539

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 544

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 549

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 556

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 561

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 566

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 571

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 591

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

Line: 593

      if hxc_block_attribute_update.g_tc_api_flag is null then
     	  hxc_block_attribute_update.g_tc_api_flag := 'Y';

Line: 595

      elsif hxc_block_attribute_update.g_tc_api_flag <> 'N' then
        hxc_block_attribute_update.g_tc_api_flag := 'Y';

Line: 599

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

Line: 603

        hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 611

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 616

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 621

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 626

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 632

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 637

    hxc_block_attribute_update.g_tc_api_flag := 'N';

Line: 642

    hxc_block_attribute_update.g_tc_api_flag := 'N';