DBA Data[Home] [Help]

APPS.HXC_TIMECARD_APPROVAL SQL Statements

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

Line: 46

      select hxc_approval_item_key_s.nextval
        into l_item_key
        from dual;
Line: 66

      select 'YES'
        from hxc_time_building_blocks
       where time_building_block_id = p_timecard_id
         and object_version_number <= p_max_ovn
         and approval_status = 'SUBMITTED';
Line: 78

      select 'YES'
        from hxc_time_building_blocks
       where time_building_block_id <> p_timecard_id
         and approval_status = 'SUBMITTED'
         and start_time <= p_stop_time
         and stop_time >= p_start_time
         and resource_id = p_resource_id
         and scope = 'TIMECARD';
Line: 149

      select timecard_id,
             application_period_id
        from hxc_tc_ap_links
       where timecard_id = p_tc_bb_id;
Line: 158

      select creation_date
        from hxc_time_building_blocks
       where time_building_block_id = l_app_id
         and object_version_number = l_app_ovn;
Line: 169

      select application_period_id
        from hxc_app_period_summary
       where resource_id = p_resource_id
         and trunc(start_time) = trunc(p_start_time)
         and trunc(stop_time) = trunc(p_stop_time)
         and time_recipient_id  = p_time_recipient_id
         and recipient_sequence IS NULL
         and time_category_id IS NULL
         and category_sequence IS NULL
         and approval_comp_id IS NULL;
Line: 182

      select htr.time_recipient_id
        from hxc_application_sets_v has,
             hxc_application_set_comps_v hasc,
             hxc_time_recipients htr
       where has.application_set_id = p_app_set
         and hasc.application_set_id = has.application_set_id
         and hasc.time_recipient_id = htr.time_recipient_id;
Line: 245

* been deleted in the hxc_timecard package      */

    hxc_tc_ap_links_pkg.remove_timecard_links
      (p_timecard_id => p_tc_bb_id );
Line: 282

            hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));
Line: 284

            hxc_app_period_summary_pkg.delete_summary_row(p_app_period_id => l_app_period_info(l_dup_index) );
Line: 364

      hxc_app_period_summary_pkg.insert_summary_row
        (p_application_period_id => l_time_building_block_id,
         p_application_period_ovn=> l_object_version_number,
         p_approval_status       => 'APPROVED',
         p_time_recipient_id     => l_appl_recipients(l_index),
         p_time_category_id      => NULL,
         p_start_time	       => l_timecard_start_time,
         p_stop_time	       => l_timecard_stop_time,
         p_resource_id	       => l_resource_id,
         p_recipient_sequence    => null,
         p_category_sequence     => null,
         p_creation_date         => l_creation_date,
         p_notification_status   => 'FINISHED',
         p_approver_id           => null,
         p_approval_comp_id      => null,
         p_approval_item_type    => NULL,
         p_approval_process_name => NULL,
         p_approval_item_key     => NULL,
         p_data_set_id 	       => null	----- Passing data set id as null explicitly.,
         );
Line: 387

      hxc_tc_ap_links_pkg.insert_summary_row
        (p_timecard_id           => p_tc_bb_id,
         p_application_period_id => l_time_building_block_id
         );
Line: 402

   /* Bulk insert the nested array into the hxc_ap_detail_links table */
      --Fix the bug 4506258. Added the if condition to take care of empty PL/SQL table when empty TC is submitted
      if(l_detail_array.application_period_id.count>0) then
        forall l_dup_index in l_detail_array.application_period_id.first .. l_detail_array.application_period_id.last
          insert into hxc_ap_detail_links
          values ( l_detail_array.APPLICATION_PERIOD_ID(l_dup_index),
                   l_detail_array.TIME_BUILDING_BLOCK_ID(l_dup_index),
                   l_detail_array.TIME_BUILDING_BLOCK_OVN(l_dup_index)
                   );
Line: 417

      update hxc_timecard_summary
         set approval_status = hxc_timecard.c_approved_status
       where timecard_id = p_tc_bb_id;
Line: 498

      Select APPROVAL_STYLE_ID
        from hxc_approval_styles
       where NAME = 'Approval on Submit' ;