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_CORPS_DEFINITIONS_API SQL Statements

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

Line: 488


procedure update_corps_definition
  (
  p_validate                      in    boolean    default false
  ,p_effective_date               in    date
  ,p_corps_definition_id          in    number
  ,p_business_group_id            in    number     default hr_api.g_number
  ,p_name                         in    varchar2   default hr_api.g_varchar2
  ,p_status_cd                    in    varchar2   default hr_api.g_varchar2
  ,p_retirement_age               in    number     default hr_api.g_number
  ,p_category_cd                  in    varchar2   default hr_api.g_varchar2
  ,p_starting_grade_step_id       in    number     default hr_api.g_number
  ,p_type_of_ps               in    varchar2   default hr_api.g_varchar2
  ,p_corps_type_cd                in    varchar2   default hr_api.g_varchar2
  ,p_date_from         in    date       default hr_api.g_date
  ,p_date_to           in    date       default hr_api.g_date
  ,p_recruitment_end_date         in    date       default hr_api.g_date
  ,p_task_desc                    in    varchar2   default hr_api.g_varchar2
  ,p_secondment_threshold         in    number     default hr_api.g_number
  ,p_normal_hours                 in    number     default hr_api.g_number
  ,p_normal_hours_frequency       in    varchar2   default hr_api.g_varchar2
  ,p_minimum_hours                in    number     default hr_api.g_number
  ,p_minimum_hours_frequency      in    varchar2   default hr_api.g_varchar2
  ,p_attribute1                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute2                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute3                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute4                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute5                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute6                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute7                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute8                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute9                   in    varchar2   default hr_api.g_varchar2
  ,p_attribute10                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute11                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute12                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute13                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute14                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute15                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute16                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute17                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute18                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute19                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute20                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute21                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute22                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute23                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute24                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute25                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute26                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute27                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute28                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute29                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute30                  in    varchar2   default hr_api.g_varchar2
  ,p_attribute_category           in    varchar2   default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy   number
  ,p_primary_prof_field_id          in number      default hr_api.g_number
  ,p_starting_grade_id              in number      default hr_api.g_number
  ,p_ben_pgm_id                     in number      default hr_api.g_number
  ,p_probation_period               in number      default hr_api.g_number
  ,p_probation_units                in varchar2    default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_corps_definition';

Line: 560


  savepoint update_corps_definition;

Line: 570


  pqh_corps_definitions_bk2.update_corps_definition_b
 (
  p_effective_date                =>    trunc(p_effective_date)
  ,p_corps_definition_id          =>    p_corps_definition_id
  ,p_business_group_id            =>    p_business_group_id
  ,p_object_version_number        =>    p_object_version_number
  ,p_name                         =>    p_name
  ,p_status_cd                    =>    p_status_cd
  ,p_retirement_age               =>    p_retirement_age
  ,p_category_cd                  =>    p_category_cd
  ,p_starting_grade_step_id       =>    p_starting_grade_step_id
  ,p_corps_type_cd                =>    p_corps_type_cd
  ,p_date_from         =>    p_date_from
  ,p_date_to           =>    p_date_to
  ,p_recruitment_end_date         =>    p_recruitment_end_date
  ,p_type_of_ps               =>    p_type_of_ps
  ,p_task_desc                    =>    p_task_desc
  ,p_secondment_threshold         =>    p_secondment_threshold
  ,p_normal_hours                 =>    p_normal_hours
  ,p_normal_hours_frequency       =>    p_normal_hours_frequency
  ,p_minimum_hours                =>    p_minimum_hours
  ,p_minimum_hours_frequency      =>    p_minimum_hours_frequency
  ,p_attribute1                   =>    p_attribute1
  ,p_attribute2                   =>    p_attribute2
  ,p_attribute3                   =>    p_attribute3
  ,p_attribute4                   =>    p_attribute4
  ,p_attribute5                   =>    p_attribute5
  ,p_attribute6                   =>    p_attribute6
  ,p_attribute7                   =>    p_attribute7
  ,p_attribute8                   =>    p_attribute8
  ,p_attribute9                   =>    p_attribute9
  ,p_attribute10                  =>    p_attribute10
  ,p_attribute11                  =>    p_attribute11
  ,p_attribute12                  =>    p_attribute12
  ,p_attribute13                  =>    p_attribute13
  ,p_attribute14                  =>    p_attribute14
  ,p_attribute15                  =>    p_attribute15
  ,p_attribute16                  =>    p_attribute16
  ,p_attribute17                  =>    p_attribute17
  ,p_attribute18                  =>    p_attribute18
  ,p_attribute19                  =>    p_attribute19
  ,p_attribute20                  =>    p_attribute20
  ,p_attribute21                  =>    p_attribute21
  ,p_attribute22                  =>    p_attribute22
  ,p_attribute23                  =>    p_attribute23
  ,p_attribute24                  =>    p_attribute24
  ,p_attribute25                  =>    p_attribute25
  ,p_attribute26                  =>    p_attribute26
  ,p_attribute27                  =>    p_attribute27
  ,p_attribute28                  =>    p_attribute28
  ,p_attribute29                  =>    p_attribute29
  ,p_attribute30                  =>    p_attribute30
  ,p_attribute_category           =>    p_attribute_category
  ,p_primary_prof_field_id        =>    p_primary_prof_field_id
  ,p_starting_grade_id            =>    p_starting_grade_id
  ,p_ben_pgm_id                   =>    p_ben_pgm_id
  ,p_probation_period             =>    p_probation_period
  ,p_probation_units              =>    p_probation_units
);

Line: 633


         p_module_name => 'update_corps_definition'
        ,p_hook_type   => 'BP'
        );

Line: 703


  pqh_corps_definitions_bk2.update_corps_definition_a
 (
  p_effective_date                =>    trunc(p_effective_date)
  ,p_corps_definition_id          =>    p_corps_definition_id
  ,p_business_group_id            =>    p_business_group_id
  ,p_object_version_number        =>    l_object_version_number
  ,p_name                         =>    p_name
  ,p_status_cd                    =>    p_status_cd
  ,p_retirement_age               =>    p_retirement_age
  ,p_category_cd                  =>    p_category_cd
  ,p_corps_type_cd                =>    p_corps_type_cd
  ,p_date_from         =>    p_date_from
  ,p_date_to           =>    p_date_to
  ,p_recruitment_end_date         =>    p_recruitment_end_date
  ,p_starting_grade_step_id       =>    p_starting_grade_step_id
  ,p_type_of_ps               =>    p_type_of_ps
  ,p_task_desc                    =>    p_task_desc
  ,p_secondment_threshold         =>    p_secondment_threshold
  ,p_normal_hours                 =>    p_normal_hours
  ,p_normal_hours_frequency       =>    p_normal_hours_frequency
  ,p_minimum_hours                =>    p_minimum_hours
  ,p_minimum_hours_frequency      =>    p_minimum_hours_frequency
  ,p_attribute1                   =>    p_attribute1
  ,p_attribute2                   =>    p_attribute2
  ,p_attribute3                   =>    p_attribute3
  ,p_attribute4                   =>    p_attribute4
  ,p_attribute5                   =>    p_attribute5
  ,p_attribute6                   =>    p_attribute6
  ,p_attribute7                   =>    p_attribute7
  ,p_attribute8                   =>    p_attribute8
  ,p_attribute9                   =>    p_attribute9
  ,p_attribute10                  =>    p_attribute10
  ,p_attribute11                  =>    p_attribute11
  ,p_attribute12                  =>    p_attribute12
  ,p_attribute13                  =>    p_attribute13
  ,p_attribute14                  =>    p_attribute14
  ,p_attribute15                  =>    p_attribute15
  ,p_attribute16                  =>    p_attribute16
  ,p_attribute17                  =>    p_attribute17
  ,p_attribute18                  =>    p_attribute18
  ,p_attribute19                  =>    p_attribute19
  ,p_attribute20                  =>    p_attribute20
  ,p_attribute21                  =>    p_attribute21
  ,p_attribute22                  =>    p_attribute22
  ,p_attribute23                  =>    p_attribute23
  ,p_attribute24                  =>    p_attribute24
  ,p_attribute25                  =>    p_attribute25
  ,p_attribute26                  =>    p_attribute26
  ,p_attribute27                  =>    p_attribute27
  ,p_attribute28                  =>    p_attribute28
  ,p_attribute29                  =>    p_attribute29
  ,p_attribute30                  =>    p_attribute30
  ,p_attribute_category           =>    p_attribute_category
  ,p_primary_prof_field_id        =>    p_primary_prof_field_id
  ,p_starting_grade_id            =>    p_starting_grade_id
  ,p_ben_pgm_id                   =>    p_ben_pgm_id
  ,p_probation_period             =>    p_probation_period
  ,p_probation_units              =>    p_probation_units
);

Line: 766


         p_module_name => 'update_corps_definition'
        ,p_hook_type   => 'AP'
        );

Line: 796


    ROLLBACK TO update_corps_definition;

Line: 809


    ROLLBACK TO update_corps_definition;

Line: 843


procedure delete_corps_definition
  (
  p_validate                        in boolean        default false
  ,p_corps_definition_id            in  number
  ,p_object_version_number          in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_corps_definition';

Line: 861


  savepoint delete_corps_definition;

Line: 874


    pqh_corps_definitions_bk3.delete_corps_definition_b
      (
       p_corps_definition_id            =>  p_corps_definition_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 882


        (p_module_name => 'delete_corps_definition'
        ,p_hook_type   => 'BP'
        );

Line: 900


    pqh_corps_definitions_bk3.delete_corps_definition_a
      (
       p_corps_definition_id            =>  p_corps_definition_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 908


        (p_module_name => 'delete_corps_definition'
        ,p_hook_type   => 'AP'
        );

Line: 933


    ROLLBACK TO delete_corps_definition;

Line: 944


    ROLLBACK TO delete_corps_definition;

Line: 947


end delete_corps_definition;