DBA Data[Home] [Help]

APPS.PQP_AAT_API SQL Statements

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

Line: 467

procedure update_assignment_attribute
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_mode                in     varchar2
  ,p_assignment_attribute_id       in     number
  ,p_business_group_id             in     number
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ,p_assignment_id                 in     number   default hr_api.g_number
  ,p_contract_type                 in     varchar2 default hr_api.g_varchar2
  ,p_work_pattern                  in     varchar2 default hr_api.g_varchar2
  ,p_start_day                     in     varchar2 default hr_api.g_varchar2
  ,p_primary_company_car           in     number   default hr_api.g_number
  ,p_primary_car_fuel_benefit      in     varchar2 default hr_api.g_varchar2
  ,p_primary_capital_contribution  in     number    default hr_api.g_number
  ,p_primary_class_1a              in     varchar2 default hr_api.g_varchar2
  ,p_secondary_company_car         in     number   default hr_api.g_number
  ,p_secondary_car_fuel_benefit    in     varchar2 default hr_api.g_varchar2
  ,p_secondary_capital_contributi  in     number    default hr_api.g_number
  ,p_secondary_class_1a            in     varchar2 default hr_api.g_varchar2
  ,p_company_car_calc_method       in     varchar2 default hr_api.g_varchar2
  ,p_company_car_rates_table_id    in     number default hr_api.g_number
  ,p_company_car_secondary_table   in     number default hr_api.g_number
  ,p_private_car                   in     number    default hr_api.g_number
  ,p_private_car_calc_method       in     varchar2 default hr_api.g_varchar2
  ,p_private_car_rates_table_id    in     number default hr_api.g_number
  ,p_private_car_essential_table   in     number default hr_api.g_number
  ,p_primary_private_contribution  in     number  default hr_api.g_number
  ,p_secondary_private_contributi  in     number  default hr_api.g_number
  ,p_tp_is_teacher                 in     varchar2  default hr_api.g_varchar2
  --added for head Teacher seconded location for salary scale calculation
  ,p_tp_headteacher_grp_code       in     number  default hr_api.g_number
  ,p_tp_safeguarded_grade          in     varchar2  default hr_api.g_varchar2
  ,p_tp_safeguarded_grade_id       in     number    default hr_api.g_number
  ,p_tp_safeguarded_rate_type      in     varchar2  default hr_api.g_varchar2
  ,p_tp_safeguarded_rate_id        in     number    default hr_api.g_number
  ,p_tp_spinal_point_id            in     number  default hr_api.g_number
  ,p_tp_elected_pension            in     varchar2  default hr_api.g_varchar2
  ,p_tp_fast_track                 in     varchar2  default hr_api.g_varchar2
  ,p_aat_attribute_category     in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute1             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute2             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute3             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute4             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute5             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute6             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute7             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute8             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute9             in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute10            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute11            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute12            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute13            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute14            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute15            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute16            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute17            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute18            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute19            in varchar2  default hr_api.g_varchar2
  ,p_aat_attribute20            in varchar2  default hr_api.g_varchar2
  ,p_aat_information_category   in varchar2  default hr_api.g_varchar2
  ,p_aat_information1           in varchar2  default hr_api.g_varchar2
  ,p_aat_information2           in varchar2  default hr_api.g_varchar2
  ,p_aat_information3           in varchar2  default hr_api.g_varchar2
  ,p_aat_information4           in varchar2  default hr_api.g_varchar2
  ,p_aat_information5           in varchar2  default hr_api.g_varchar2
  ,p_aat_information6           in varchar2  default hr_api.g_varchar2
  ,p_aat_information7           in varchar2  default hr_api.g_varchar2
  ,p_aat_information8           in varchar2  default hr_api.g_varchar2
  ,p_aat_information9           in varchar2  default hr_api.g_varchar2
  ,p_aat_information10          in varchar2  default hr_api.g_varchar2
  ,p_aat_information11          in varchar2  default hr_api.g_varchar2
  ,p_aat_information12          in varchar2  default hr_api.g_varchar2
  ,p_aat_information13          in varchar2  default hr_api.g_varchar2
  ,p_aat_information14          in varchar2  default hr_api.g_varchar2
  ,p_aat_information15          in varchar2  default hr_api.g_varchar2
  ,p_aat_information16          in varchar2  default hr_api.g_varchar2
  ,p_aat_information17          in varchar2  default hr_api.g_varchar2
  ,p_aat_information18          in varchar2  default hr_api.g_varchar2
  ,p_aat_information19          in varchar2  default hr_api.g_varchar2
  ,p_aat_information20          in varchar2  default hr_api.g_varchar2
  ,p_lgps_process_flag          in varchar2  default hr_api.g_varchar2
  ,p_lgps_exclusion_type        in varchar2  default hr_api.g_varchar2
  ,p_lgps_pensionable_pay       in varchar2  default hr_api.g_varchar2
  ,p_lgps_trans_arrang_flag     in varchar2  default hr_api.g_varchar2
  ,p_lgps_membership_number     in varchar2  default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declaring cursors and local variables
  --
  l_object_version_number       number;
Line: 559

  l_proc                        varchar2(72) := g_package||'update_assignment_attribute';
Line: 568

  savepoint update_assignment_attribute;
Line: 582

    pqp_aat_api_bk2.update_assignment_attribute_b
      (p_effective_date         => l_effective_date
      ,p_datetrack_mode         => p_datetrack_mode
      ,p_business_group_id      => p_business_group_id
      ,p_effective_start_date   => l_effective_start_date
      ,p_effective_end_date     => l_effective_end_date
      ,p_assignment_id          => p_assignment_id
      ,p_contract_type          => p_contract_type
      ,p_work_pattern           => p_work_pattern
      ,p_start_day              => p_start_day
      ,p_primary_company_car        => p_primary_company_car
      ,p_primary_car_fuel_benefit   => p_primary_car_fuel_benefit
      ,p_primary_capital_contribution => p_primary_capital_contribution
      ,p_primary_class_1a           => p_primary_class_1a
      ,p_secondary_company_car      => p_secondary_company_car
      ,p_secondary_car_fuel_benefit => p_secondary_car_fuel_benefit
      ,p_secondary_capital_contributi => p_secondary_capital_contributi
      ,p_secondary_class_1a         => p_secondary_class_1a
      ,p_company_car_calc_method    => p_company_car_calc_method
      ,p_company_car_rates_table_id    => p_company_car_rates_table_id
      ,p_company_car_secondary_table => p_company_car_secondary_table
      ,p_private_car                => p_private_car
      ,p_private_car_calc_method    => p_private_car_calc_method
      ,p_private_car_rates_table_id    => p_private_car_rates_table_id
      ,p_private_car_essential_table => p_private_car_essential_table
      ,p_primary_private_contribution   => p_primary_private_contribution
      ,p_secondary_private_contributi   => p_secondary_private_contributi
      ,p_tp_is_teacher                  => p_tp_is_teacher
       --added for head Teacher seconded location for salary scale calculation
      ,p_tp_headteacher_grp_code        => p_tp_headteacher_grp_code
      ,p_tp_safeguarded_grade           => p_tp_safeguarded_grade
      ,p_tp_safeguarded_grade_id        => p_tp_safeguarded_grade_id
      ,p_tp_safeguarded_rate_type       => p_tp_safeguarded_rate_type
      ,p_tp_safeguarded_rate_id         => p_tp_safeguarded_rate_id
      ,p_tp_spinal_point_id             => p_tp_spinal_point_id
      ,p_tp_elected_pension             => p_tp_elected_pension
      ,p_tp_fast_track                  => p_tp_fast_track
      ,p_aat_attribute_category         => p_aat_attribute_category
      ,p_aat_attribute1                 => p_aat_attribute1
      ,p_aat_attribute2                 => p_aat_attribute2
      ,p_aat_attribute3                 => p_aat_attribute3
      ,p_aat_attribute4                 => p_aat_attribute4
      ,p_aat_attribute5                 => p_aat_attribute5
      ,p_aat_attribute6                 => p_aat_attribute6
      ,p_aat_attribute7                 => p_aat_attribute7
      ,p_aat_attribute8                 => p_aat_attribute8
      ,p_aat_attribute9                 => p_aat_attribute9
      ,p_aat_attribute10                => p_aat_attribute10
      ,p_aat_attribute11                => p_aat_attribute11
      ,p_aat_attribute12                => p_aat_attribute12
      ,p_aat_attribute13                => p_aat_attribute13
      ,p_aat_attribute14                => p_aat_attribute14
      ,p_aat_attribute15                => p_aat_attribute15
      ,p_aat_attribute16                => p_aat_attribute16
      ,p_aat_attribute17                => p_aat_attribute17
      ,p_aat_attribute18                => p_aat_attribute18
      ,p_aat_attribute19                => p_aat_attribute19
      ,p_aat_attribute20                => p_aat_attribute20
      ,p_aat_information_category       => p_aat_information_category
      ,p_aat_information1               => p_aat_information1
      ,p_aat_information2               => p_aat_information2
      ,p_aat_information3               => p_aat_information3
      ,p_aat_information4               => p_aat_information4
      ,p_aat_information5               => p_aat_information5
      ,p_aat_information6               => p_aat_information6
      ,p_aat_information7               => p_aat_information7
      ,p_aat_information8               => p_aat_information8
      ,p_aat_information9               => p_aat_information9
      ,p_aat_information10              => p_aat_information10
      ,p_aat_information11              => p_aat_information11
      ,p_aat_information12              => p_aat_information12
      ,p_aat_information13              => p_aat_information13
      ,p_aat_information14              => p_aat_information14
      ,p_aat_information15              => p_aat_information15
      ,p_aat_information16              => p_aat_information16
      ,p_aat_information17              => p_aat_information17
      ,p_aat_information18              => p_aat_information18
      ,p_aat_information19              => p_aat_information19
      ,p_aat_information20              => p_aat_information20
      ,p_lgps_process_flag              => p_lgps_process_flag
      ,p_lgps_exclusion_type            => p_lgps_exclusion_type
      ,p_lgps_pensionable_pay           => p_lgps_pensionable_pay
      ,p_lgps_trans_arrang_flag         => p_lgps_trans_arrang_flag
      ,p_lgps_membership_number         => p_lgps_membership_number
      ,p_assignment_attribute_id =>p_assignment_attribute_id
      ,p_object_version_number  => p_object_version_number
      );
Line: 672

        (p_module_name => 'update_assignment_attribute'
        ,p_hook_type   => 'BP'
        );
Line: 779

    pqp_aat_api_bk2.update_assignment_attribute_a
      (p_effective_date         => l_effective_date
      ,p_datetrack_mode         => p_datetrack_mode
      ,p_business_group_id      => p_business_group_id
      ,p_effective_start_date   => l_effective_start_date
      ,p_effective_end_date     => l_effective_end_date
      ,p_assignment_id          => p_assignment_id
      ,p_contract_type          => p_contract_type
      ,p_work_pattern           => p_work_pattern
      ,p_start_day              => p_start_day
      ,p_primary_company_car        => p_primary_company_car
      ,p_primary_car_fuel_benefit   => p_primary_car_fuel_benefit
      ,p_primary_capital_contribution => p_primary_capital_contribution
      ,p_primary_class_1a           => p_primary_class_1a
      ,p_secondary_company_car      => p_secondary_company_car
      ,p_secondary_car_fuel_benefit => p_secondary_car_fuel_benefit
      ,p_secondary_capital_contributi => p_secondary_capital_contributi
      ,p_secondary_class_1a         => p_secondary_class_1a
      ,p_company_car_calc_method    => p_company_car_calc_method
      ,p_company_car_rates_table_id    => p_company_car_rates_table_id
      ,p_company_car_secondary_table => p_company_car_secondary_table
      ,p_private_car                => p_private_car
      ,p_private_car_calc_method    => p_private_car_calc_method
      ,p_private_car_rates_table_id    => p_private_car_rates_table_id
      ,p_private_car_essential_table => p_private_car_essential_table
      ,p_primary_private_contribution   => p_primary_private_contribution
      ,p_secondary_private_contributi   => p_secondary_private_contributi
      ,p_tp_is_teacher                  => p_tp_is_teacher
       --added for head Teacher seconded location for salary scale calculation
      ,p_tp_headteacher_grp_code        => p_tp_headteacher_grp_code
      ,p_tp_safeguarded_grade           => p_tp_safeguarded_grade
      ,p_tp_safeguarded_grade_id        => p_tp_safeguarded_grade_id
      ,p_tp_safeguarded_rate_type       => p_tp_safeguarded_rate_type
      ,p_tp_safeguarded_rate_id         => p_tp_safeguarded_rate_id
      ,p_tp_spinal_point_id             => p_tp_spinal_point_id
      ,p_tp_elected_pension             => p_tp_elected_pension
      ,p_tp_fast_track                  => p_tp_fast_track
      ,p_aat_attribute_category         => p_aat_attribute_category
      ,p_aat_attribute1                 => p_aat_attribute1
      ,p_aat_attribute2                 => p_aat_attribute2
      ,p_aat_attribute3                 => p_aat_attribute3
      ,p_aat_attribute4                 => p_aat_attribute4
      ,p_aat_attribute5                 => p_aat_attribute5
      ,p_aat_attribute6                 => p_aat_attribute6
      ,p_aat_attribute7                 => p_aat_attribute7
      ,p_aat_attribute8                 => p_aat_attribute8
      ,p_aat_attribute9                 => p_aat_attribute9
      ,p_aat_attribute10                => p_aat_attribute10
      ,p_aat_attribute11                => p_aat_attribute11
      ,p_aat_attribute12                => p_aat_attribute12
      ,p_aat_attribute13                => p_aat_attribute13
      ,p_aat_attribute14                => p_aat_attribute14
      ,p_aat_attribute15                => p_aat_attribute15
      ,p_aat_attribute16                => p_aat_attribute16
      ,p_aat_attribute17                => p_aat_attribute17
      ,p_aat_attribute18                => p_aat_attribute18
      ,p_aat_attribute19                => p_aat_attribute19
      ,p_aat_attribute20                => p_aat_attribute20
      ,p_aat_information_category       => p_aat_information_category
      ,p_aat_information1               => p_aat_information1
      ,p_aat_information2               => p_aat_information2
      ,p_aat_information3               => p_aat_information3
      ,p_aat_information4               => p_aat_information4
      ,p_aat_information5               => p_aat_information5
      ,p_aat_information6               => p_aat_information6
      ,p_aat_information7               => p_aat_information7
      ,p_aat_information8               => p_aat_information8
      ,p_aat_information9               => p_aat_information9
      ,p_aat_information10              => p_aat_information10
      ,p_aat_information11              => p_aat_information11
      ,p_aat_information12              => p_aat_information12
      ,p_aat_information13              => p_aat_information13
      ,p_aat_information14              => p_aat_information14
      ,p_aat_information15              => p_aat_information15
      ,p_aat_information16              => p_aat_information16
      ,p_aat_information17              => p_aat_information17
      ,p_aat_information18              => p_aat_information18
      ,p_aat_information19              => p_aat_information19
      ,p_aat_information20              => p_aat_information20
      ,p_lgps_process_flag              => p_lgps_process_flag
      ,p_lgps_exclusion_type            => p_lgps_exclusion_type
      ,p_lgps_pensionable_pay           => p_lgps_pensionable_pay
      ,p_lgps_trans_arrang_flag         => p_lgps_trans_arrang_flag
      ,p_lgps_membership_number         => p_lgps_membership_number
      ,p_assignment_attribute_id =>p_assignment_attribute_id
      ,p_object_version_number  => l_object_version_number
      );
Line: 869

        (p_module_name => 'update_assignment_attribute'
        ,p_hook_type   => 'AP'
        );
Line: 894

    rollback to update_assignment_attribute;
Line: 909

    rollback to update_assignment_attribute;
Line: 915

end update_assignment_attribute;
Line: 922

procedure delete_assignment_attribute
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_mode                in     varchar2
  ,p_business_group_id             in     number
  ,p_assignment_attribute_id       in     number
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'delete_assignment_attribute';
Line: 947

  savepoint delete_assignment_attribute;
Line: 960

    pqp_aat_api_bk3.delete_assignment_attribute_b
      (p_effective_date                => l_effective_date
      ,p_datetrack_mode                => p_datetrack_mode
      ,p_assignment_attribute_id       => p_assignment_attribute_id
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      ,p_object_version_number         => p_object_version_number
      );
Line: 971

        (p_module_name => 'delete_assignment_attribute'
        ,p_hook_type   => 'BP'
        );
Line: 1000

    pqp_aat_api_bk3.delete_assignment_attribute_a
      (p_effective_date                => l_effective_date
      ,p_datetrack_mode                => p_datetrack_mode
      ,p_assignment_attribute_id       => p_assignment_attribute_id
      ,p_effective_start_date          => l_effective_start_date
      ,p_effective_end_date            => l_effective_end_date
      ,p_object_version_number         => l_object_version_number
      );
Line: 1011

        (p_module_name => 'delete_assignment_attribute'
        ,p_hook_type   => 'AP'
        );
Line: 1035

    rollback to delete_assignment_attribute;
Line: 1049

    rollback to delete_assignment_attribute;
Line: 1055

end delete_assignment_attribute;