APPS.GHR_ASSIGNMENT_API SQL Statements

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

Line: 14

  ,p_datetrack_update_mode        in     varchar2
  ,p_assignment_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_assignment_status_type_id    in     number   default hr_api.g_number
  ,p_change_reason                in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  )
--
is

 l_proc                     varchar2(72);

Line: 52

     ,p_datetrack_update_mode      =>   p_datetrack_update_mode
     ,p_assignment_id              =>   p_assignment_id
     ,p_object_version_number      =>   l_object_version_number
     ,p_assignment_status_type_id  =>   p_assignment_status_type_id
     ,p_change_reason              =>   p_change_reason
     ,p_effective_start_date       =>   p_effective_start_date
     ,p_effective_end_date         =>   p_effective_end_date
    );

Line: 62

 ghr_history_api.post_update_process;