eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIMESTORE_DEPOSIT SQL Statements

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

Line: 1649


      p_app_attributes (l_attribute_count).updated := hxc_timecard.c_no;

Line: 1684


   PROCEDURE update_building_block (
      p_building_block_id   IN              hxc_time_building_blocks.time_building_block_id%TYPE,
      p_measure             IN              hxc_time_building_blocks.measure%TYPE,
      p_unit_of_measure     IN              hxc_time_building_blocks.unit_of_measure%TYPE,
      p_start_time          IN              hxc_time_building_blocks.start_time%TYPE,
      p_stop_time           IN              hxc_time_building_blocks.stop_time%TYPE,
      p_comment_text        IN              hxc_time_building_blocks.comment_text%TYPE,
      -- p_time_recipient_id   IN       NUMBER,
      p_deposit_process     IN              hxc_deposit_processes.NAME%TYPE,
      p_app_blocks          IN OUT NOCOPY   hxc_block_table_type,
      p_app_attributes      IN OUT NOCOPY   hxc_self_service_time_deposit.app_attributes_info
   )
   IS
      l_proc                   VARCHAR2 (72);

Line: 1705


         l_proc := g_package || 'update_building_block';

Line: 1815


   END update_building_block;

Line: 1835


   PROCEDURE update_building_block (
      p_building_block_id   IN              hxc_time_building_blocks.time_building_block_id%TYPE,
      p_measure             IN              hxc_time_building_blocks.measure%TYPE,
      p_unit_of_measure     IN              hxc_time_building_blocks.unit_of_measure%TYPE,
      p_start_time          IN              hxc_time_building_blocks.start_time%TYPE,
      p_stop_time           IN              hxc_time_building_blocks.stop_time%TYPE,
      p_comment_text        IN              hxc_time_building_blocks.comment_text%TYPE,
      -- p_time_recipient_id   IN       NUMBER,
      p_deposit_process     IN              hxc_deposit_processes.NAME%TYPE,
      p_app_blocks          IN OUT NOCOPY   hxc_self_service_time_deposit.timecard_info,
      p_app_attributes      IN OUT NOCOPY   hxc_self_service_time_deposit.app_attributes_info
   )
   IS
      l_proc     VARCHAR2 (72);

Line: 1855


         l_proc := g_package || 'update_building_block (Overloaded)';

Line: 1862


      update_building_block (p_building_block_id      => p_building_block_id,
                             p_measure                => p_measure,
                             p_unit_of_measure        => p_unit_of_measure,
                             p_start_time             => p_start_time,
                             p_stop_time              => p_stop_time,
                             p_comment_text           => p_comment_text,
                             -- p_time_recipient_id  => p_time_recipient_id,
                             p_deposit_process        => p_deposit_process,
                             p_app_blocks             => l_blocks,
                             p_app_attributes         => p_app_attributes
                            );

Line: 1880


   END update_building_block;

Line: 1905


   PROCEDURE delete_detail_bb (
      p_building_block_id   IN              hxc_time_building_blocks.time_building_block_id%TYPE,
      -- p_time_recipient_id   IN       NUMBER,
      p_deposit_process     IN              hxc_deposit_processes.NAME%TYPE,
      p_effective_date      IN              hxc_time_building_blocks.stop_time%TYPE,
      p_app_blocks          IN OUT NOCOPY   hxc_block_table_type,
      p_app_attributes      IN OUT NOCOPY   hxc_self_service_time_deposit.app_attributes_info
   )
   IS
      l_proc                   VARCHAR2 (72);

Line: 1921


         l_proc := g_package || 'delete_detail_bb';

Line: 1954


   END delete_detail_bb;

Line: 1974


   PROCEDURE delete_detail_bb (
      p_building_block_id   IN              hxc_time_building_blocks.time_building_block_id%TYPE,
      -- p_time_recipient_id   IN       NUMBER,
      p_deposit_process     IN              hxc_deposit_processes.NAME%TYPE,
      p_effective_date      IN              hxc_time_building_blocks.stop_time%TYPE,
      p_app_blocks          IN OUT NOCOPY   hxc_self_service_time_deposit.timecard_info,
      p_app_attributes      IN OUT NOCOPY   hxc_self_service_time_deposit.app_attributes_info
   )
   IS
      l_proc     VARCHAR2 (72);

Line: 1990


         l_proc := g_package || 'delete_detail_bb (Overloaded)';

Line: 1997


      delete_detail_bb (p_building_block_id      => p_building_block_id,
                        -- p_time_recipient_id   => p_time_recipient_id,
                        p_deposit_process        => p_deposit_process,
                        p_effective_date         => p_effective_date,
                        p_app_blocks             => l_blocks,
                        p_app_attributes         => p_app_attributes
                       );

Line: 2011


   END delete_detail_bb;

Line: 2037


   PROCEDURE delete_timecard (
      p_building_block_id   IN   hxc_time_building_blocks.time_building_block_id%TYPE,
      p_mode                IN   VARCHAR2,
      p_deposit_process     IN   hxc_deposit_processes.NAME%TYPE,
      -- Not used anymore, left in for backwards compatibility
      p_retrieval_process   IN   VARCHAR2,
      -- Not used anymore, left in for backwards compatibility
      p_effective_date      IN   hxc_time_building_blocks.stop_time%TYPE,
      -- Not used anymore, left in for backwards compatibility
      p_template            IN   VARCHAR2
   )
   IS
      l_proc    VARCHAR2 (72);

Line: 2057


         l_proc := g_package || 'delete_timecard';

Line: 2065


         hxc_timecard.delete_timecard (p_mode             => p_mode,
                                       p_template         => p_template,
                                       p_timecard_id      => p_building_block_id,
                                       p_timecard_ok      => l_dummy
                                      );

Line: 2078


   END delete_timecard;

Line: 2099


   PROCEDURE update_attribute (
      p_time_attribute_id   IN              hxc_time_attributes.time_attribute_id%TYPE,
      -- p_building_block_id   IN       hxc_time_building_blocks.time_building_block_id%TYPE,
      p_attribute_name      IN              hxc_mapping_components.field_name%TYPE,
      p_attribute_value     IN              hxc_time_attributes.attribute1%TYPE,
      -- p_category            IN       hxc_bld_blk_info_type_usages.building_block_category%TYPE,
      -- p_time_recipient_id   IN       NUMBER,
      p_deposit_process     IN              hxc_deposit_processes.NAME%TYPE,
      p_app_blocks          IN OUT NOCOPY   hxc_block_table_type,
      p_app_attributes      IN OUT NOCOPY   hxc_self_service_time_deposit.app_attributes_info
   )
   IS
      l_proc                VARCHAR2 (72);

Line: 2120


         SELECT time_building_block_id
           FROM hxc_time_attribute_usages
          WHERE time_attribute_id = v_time_attribute_id;

Line: 2131


         l_proc := g_package || 'update_attribute';

Line: 2226


         p_app_attributes (l_attribute_index).updated := hxc_timecard.c_no;

Line: 2248


   END update_attribute;

Line: 2268


   PROCEDURE update_attribute (
      p_time_attribute_id   IN              hxc_time_attributes.time_attribute_id%TYPE,
      -- p_building_block_id   IN       hxc_time_building_blocks.time_building_block_id%TYPE,
      p_attribute_name      IN              hxc_mapping_components.field_name%TYPE,
      p_attribute_value     IN              hxc_time_attributes.attribute1%TYPE,
      -- p_category            IN       hxc_bld_blk_info_type_usages.building_block_category%TYPE,
      -- p_time_recipient_id   IN       NUMBER,
      p_deposit_process     IN              hxc_deposit_processes.NAME%TYPE,
      p_app_blocks          IN OUT NOCOPY   hxc_self_service_time_deposit.timecard_info,
      p_app_attributes      IN OUT NOCOPY   hxc_self_service_time_deposit.app_attributes_info
   )
   IS
      l_proc     VARCHAR2 (72);

Line: 2287


         l_proc := g_package || 'update_attribute';

Line: 2294


      update_attribute (p_time_attribute_id      => p_time_attribute_id,
                        -- p_building_block_id   => p_building_block_id,
                        p_attribute_name         => p_attribute_name,
                        p_attribute_value        => p_attribute_value,
                        -- p_category            => p_category,
                        -- p_time_recipient_id  => p_time_recipient_id,
                        p_deposit_process        => p_deposit_process,
                        p_app_blocks             => l_blocks,
                        p_app_attributes         => p_app_attributes
                       );

Line: 2311


   END update_attribute;