3 Replies Latest reply on Sep 8, 2017 5:59 PM by stejac

    delete OTL time card

    stejac

      looking for the API to delete a OTL timecard, to be able to enter it again

       

      i know most of the table involve but i prefer to find a API

      HXC_TIME_BUILDING_BLOCKS

      HXC_LATEST_DETAILS

      HXC_TIME_ATTRIBUTE_USAGES

      HXC_DEP_TRANSACTIONS

      HXC_TIMECARD_SUMMARY

       

      EBS 12.1.3

        • 1. Re: delete OTL time card
          stejac

          does anyone ever try

          HXC_TIMESTORE_DEPOSIT.delete_timecard

          or

          HXC_SELF_SERVICE_TIME_DEPOSIT.delete_timecard

          • 2. Re: delete OTL time card
            John_K

            Yes I've used these successfully in the past - the first procedure is just a wrapper around the second anyway according to the comments.

            • 3. Re: delete OTL time card
              stejac

              for those interested by the subject

              #################

              select *

              from   hxc_time_building_blocks tbb_tim

              where  resource_id = (select person_id from per_all_people_f where full_name like '%%NAME%%')

              and    to_date('%%DATE%%','yyyymmdd') between trunc(tbb_tim.start_time) and trunc(tbb_tim.stop_time)

              and    tbb_tim.date_to = hr_general.end_of_time

              and    (tbb_tim.scope='TIMECARD' or tbb_tim.scope='TIMECARD_TEMPLATE');

               

              --API delete time_buildong_block_id

              execute HXC_TIMESTORE_DEPOSIT.delete_timecard (%time_building_block_id%);

              commit;

              --

               

              select *

              from   hxc_time_building_blocks tbb_tim

              where  tbb_tim.time_building_block_id = %%time_building_block_id%%

              and    tbb_tim.date_to = hr_general.end_of_time

              and    (tbb_tim.scope='TIMECARD' or tbb_tim.scope='TIMECARD_TEMPLATE');

              #################

              1 person found this helpful