DBA Data[Home] [Help]

APPS.GHR_APPLICANT_API SQL Statements

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

Line: 108

  ,p_resume_last_updated          in     date     default null
  ,p_work_schedule                in     varchar2 default null
  ,p_suffix                       in     varchar2 default null
  ,p_person_id                       out number
  ,p_assignment_id                   out number
  ,p_application_id                  out number
  ,p_per_object_version_number       out number
  ,p_asg_object_version_number       out number
  ,p_apl_object_version_number       out number
  ,p_per_effective_start_date        out date
  ,p_per_effective_end_date          out date
  ,p_full_name                       out varchar2
  ,p_per_comment_id                  out number
  ,p_assignment_sequence             out number
  ,p_name_combination_warning        out boolean
  ,p_orig_hire_warning               out boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||'create_applicant';
Line: 251

              ,p_resume_last_updated          => p_resume_last_updated
              ,p_work_schedule                => p_work_schedule
              ,p_suffix                       => p_suffix
              ,p_validate                     => FALSE
              ,p_person_id                    => l_person_id
              ,p_assignment_id                => l_assignment_id
              ,p_application_id               => l_application_id
              ,p_per_object_version_number    => p_per_object_version_number
              ,p_asg_object_version_number    => p_asg_object_version_number
              ,p_apl_object_version_number    => p_apl_object_version_number
              ,p_per_effective_start_date     => p_per_effective_start_date
              ,p_per_effective_end_date       => p_per_effective_end_date
              ,p_full_name                    => p_full_name
              ,p_per_comment_id               => p_per_comment_id
              ,p_assignment_sequence          => p_assignment_sequence
              ,p_name_combination_warning     => p_name_combination_warning
              ,p_orig_hire_warning            => p_orig_hire_warning
              );
Line: 272

    ghr_history_api.post_update_process;