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.PQH_FR_ASSIGNMENT_SWI SQL Statements

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

Line: 161


PROCEDURE update_affectation
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_datetrack_update_mode        in     varchar2
  ,p_effective_date               in     date
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_position_id                  in     number    default hr_api.g_number
  ,p_person_id                    in     number
  ,p_job_id                       in     number    default hr_api.g_number
  ,p_supervisor_id                in     number    default hr_api.g_number
  ,p_assignment_number            in     varchar2  default hr_api.g_varchar2
  ,p_assignment_status_type_id    in     number    default hr_api.g_number
  ,p_identifier                   in     varchar2  default hr_api.g_varchar2
  ,p_affectation_type             in     varchar2  default hr_api.g_varchar2
  ,p_percent_effected             in     varchar2  default hr_api.g_varchar2
  ,p_primary_affectation          in     varchar2  default hr_api.g_varchar2
  ,p_group_name                      out nocopy varchar2
  ,p_scl_concat_segments          in     varchar2  default hr_api.g_varchar2
  ,p_assignment_id                in     number
  ,p_soft_coding_keyflex_id          out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_assignment_sequence             out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 194


  l_proc    varchar2(72) := g_package ||'update_affectation';

Line: 200


  savepoint update_affectation_swi;

Line: 221


  pqh_fr_assignment_api.update_affectation
    (p_validate                     => l_validate
    ,p_datetrack_update_mode        => p_datetrack_update_mode
    ,p_effective_date               => p_effective_date
    ,p_organization_id              => p_organization_id
    ,p_position_id                  => p_position_id
    ,p_person_id                    => p_person_id
    ,p_job_id                       => p_job_id
    ,p_supervisor_id                => p_supervisor_id
    ,p_assignment_number            => p_assignment_number
    ,p_assignment_status_type_id    => p_assignment_status_type_id
    ,p_identifier                   => p_identifier
    ,p_affectation_type             => p_affectation_type
    ,p_percent_effected             => p_percent_effected
    ,p_primary_affectation          => p_primary_affectation
    ,p_group_name                   => p_group_name
    ,p_scl_concat_segments          => p_scl_concat_segments
    ,p_assignment_id                => p_assignment_id
    ,p_soft_coding_keyflex_id       => p_soft_coding_keyflex_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    ,p_assignment_sequence          => p_assignment_sequence
    );

Line: 267


    rollback to update_affectation_swi;

Line: 287


    rollback to update_affectation_swi;

Line: 303


end update_affectation;

Line: 307


PROCEDURE update_employment_terms
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_datetrack_update_mode        in     varchar2
  ,p_effective_date               in     date
  ,p_assignment_id                in     number
  ,p_establishment_id             in     number
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_assignment_category          in     varchar2
  ,p_reason_for_parttime          in     varchar2  default hr_api.g_varchar2
  ,p_working_hours_share          in     varchar2  default hr_api.g_varchar2
  ,p_contract_id                  in     number    default hr_api.g_number
  ,p_change_reason                in     varchar2  default hr_api.g_varchar2
  ,p_normal_hours                 in     number    default hr_api.g_number
  ,p_frequency                    in     varchar2  default hr_api.g_varchar2
  ,p_soft_coding_keyflex_id          out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_assignment_sequence             out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 336


  l_proc    varchar2(72) := g_package ||'update_employment_terms';

Line: 342


  savepoint update_employment_terms_swi;

Line: 363


  pqh_fr_assignment_api.update_employment_terms
    (p_validate                     => l_validate
    ,p_datetrack_update_mode        => p_datetrack_update_mode
    ,p_effective_date               => p_effective_date
    ,p_assignment_id                => p_assignment_id
    ,p_establishment_id             => p_establishment_id
    ,p_comments                     => p_comments
    ,p_assignment_category          => p_assignment_category
    ,p_reason_for_parttime          => p_reason_for_parttime
    ,p_working_hours_share          => p_working_hours_share
    ,p_contract_id                  => p_contract_id
    ,p_change_reason                => p_change_reason
    ,p_normal_hours                 => p_normal_hours
    ,p_frequency                    => p_frequency
    ,p_soft_coding_keyflex_id       => p_soft_coding_keyflex_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    ,p_assignment_sequence          => p_assignment_sequence
    );

Line: 405


    rollback to update_employment_terms_swi;

Line: 424


    rollback to update_employment_terms_swi;

Line: 439


end update_employment_terms;

Line: 443


PROCEDURE update_administrative_career
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_datetrack_update_mode        in     varchar2
  ,p_effective_date               in     date
  ,p_assignment_id                in     number
  ,p_corps_id                     in     number
  ,p_grade_id                     in     number
  ,p_step_id                      in     number
  ,p_progression_speed           in     varchar2
  ,p_personal_gross_index         in     varchar2
  ,p_employee_category            in     varchar2
  ,p_soft_coding_keyflex_id          out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_assignment_sequence             out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 469


  l_proc    varchar2(72) := g_package ||'update_administrative_career';

Line: 475


  savepoint update_admin_career_swi;

Line: 496


  pqh_fr_assignment_api.update_administrative_career
    (p_validate                     => l_validate
    ,p_datetrack_update_mode        => p_datetrack_update_mode
    ,p_effective_date               => p_effective_date
    ,p_assignment_id                => p_assignment_id
    ,p_corps_id                     => p_corps_id
    ,p_grade_id                     => p_grade_id
    ,p_step_id                      => p_step_id
    ,p_progression_speed            => p_progression_speed
    ,p_personal_gross_index         => p_personal_gross_index
    ,p_employee_category            => p_employee_category
    ,p_soft_coding_keyflex_id       => p_soft_coding_keyflex_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    ,p_assignment_sequence          => p_assignment_sequence
    );

Line: 535


    rollback to update_admin_career_swi;

Line: 554


    rollback to update_admin_career_swi;

Line: 569


end update_administrative_career;