APPS.OTA_TPC_API SQL Statements

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

Line: 393

procedure update_cost
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_training_plan_cost_id         in     number
  ,p_object_version_number         in out nocopy number
  ,p_amount                        in     number   default hr_api.g_number
  ,p_currency_code                 in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category            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_information_category          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information1          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information2          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information3          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information4          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information5          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information6          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information7          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information8          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information9          in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information10         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information11         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information12         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information13         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information14         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information15         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information16         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information17         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information18         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information19         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information20         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information21         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information22         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information23         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information24         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information25         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information26         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information27         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information28         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information29         in     varchar2 default hr_api.g_varchar2
  ,p_tp_cost_information30         in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Cost';

Line: 474

  savepoint update_cost;

Line: 483

    ota_tpc_api_bk2.update_cost_b
  (p_effective_date              => l_effective_date
  ,p_training_plan_cost_id       => p_training_plan_cost_id
  ,p_object_version_number       => p_object_version_number
  ,p_amount                      => p_amount
  ,p_currency_code               => p_currency_code
  ,p_attribute_category          => p_attribute_category
  ,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_information_category        => p_information_category
  ,p_tp_cost_information1        => p_tp_cost_information1
  ,p_tp_cost_information2        => p_tp_cost_information2
  ,p_tp_cost_information3        => p_tp_cost_information3
  ,p_tp_cost_information4        => p_tp_cost_information4
  ,p_tp_cost_information5        => p_tp_cost_information5
  ,p_tp_cost_information6        => p_tp_cost_information6
  ,p_tp_cost_information7        => p_tp_cost_information7
  ,p_tp_cost_information8        => p_tp_cost_information8
  ,p_tp_cost_information9        => p_tp_cost_information9
  ,p_tp_cost_information10       => p_tp_cost_information10
  ,p_tp_cost_information11       => p_tp_cost_information11
  ,p_tp_cost_information12       => p_tp_cost_information12
  ,p_tp_cost_information13       => p_tp_cost_information13
  ,p_tp_cost_information14       => p_tp_cost_information14
  ,p_tp_cost_information15       => p_tp_cost_information15
  ,p_tp_cost_information16       => p_tp_cost_information16
  ,p_tp_cost_information17       => p_tp_cost_information17
  ,p_tp_cost_information18       => p_tp_cost_information18
  ,p_tp_cost_information19       => p_tp_cost_information19
  ,p_tp_cost_information20       => p_tp_cost_information20
  ,p_tp_cost_information21       => p_tp_cost_information21
  ,p_tp_cost_information22       => p_tp_cost_information22
  ,p_tp_cost_information23       => p_tp_cost_information23
  ,p_tp_cost_information24       => p_tp_cost_information24
  ,p_tp_cost_information25       => p_tp_cost_information25
  ,p_tp_cost_information26       => p_tp_cost_information26
  ,p_tp_cost_information27       => p_tp_cost_information27
  ,p_tp_cost_information28       => p_tp_cost_information28
  ,p_tp_cost_information29       => p_tp_cost_information29
  ,p_tp_cost_information30       => p_tp_cost_information30
  );

Line: 555

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

Line: 637

  ota_tpc_api_bk2.update_cost_a
  (p_effective_date              => l_effective_date
  ,p_training_plan_cost_id       => p_training_plan_cost_id
  ,p_object_version_number       => l_object_version_number
  ,p_amount                      => p_amount
  ,p_currency_code               => p_currency_code
  ,p_attribute_category          => p_attribute_category
  ,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_information_category        => p_information_category
  ,p_tp_cost_information1        => p_tp_cost_information1
  ,p_tp_cost_information2        => p_tp_cost_information2
  ,p_tp_cost_information3        => p_tp_cost_information3
  ,p_tp_cost_information4        => p_tp_cost_information4
  ,p_tp_cost_information5        => p_tp_cost_information5
  ,p_tp_cost_information6        => p_tp_cost_information6
  ,p_tp_cost_information7        => p_tp_cost_information7
  ,p_tp_cost_information8        => p_tp_cost_information8
  ,p_tp_cost_information9        => p_tp_cost_information9
  ,p_tp_cost_information10       => p_tp_cost_information10
  ,p_tp_cost_information11       => p_tp_cost_information11
  ,p_tp_cost_information12       => p_tp_cost_information12
  ,p_tp_cost_information13       => p_tp_cost_information13
  ,p_tp_cost_information14       => p_tp_cost_information14
  ,p_tp_cost_information15       => p_tp_cost_information15
  ,p_tp_cost_information16       => p_tp_cost_information16
  ,p_tp_cost_information17       => p_tp_cost_information17
  ,p_tp_cost_information18       => p_tp_cost_information18
  ,p_tp_cost_information19       => p_tp_cost_information19
  ,p_tp_cost_information20       => p_tp_cost_information20
  ,p_tp_cost_information21       => p_tp_cost_information21
  ,p_tp_cost_information22       => p_tp_cost_information22
  ,p_tp_cost_information23       => p_tp_cost_information23
  ,p_tp_cost_information24       => p_tp_cost_information24
  ,p_tp_cost_information25       => p_tp_cost_information25
  ,p_tp_cost_information26       => p_tp_cost_information26
  ,p_tp_cost_information27       => p_tp_cost_information27
  ,p_tp_cost_information28       => p_tp_cost_information28
  ,p_tp_cost_information29       => p_tp_cost_information29
  ,p_tp_cost_information30       => p_tp_cost_information30
  );

Line: 709

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

Line: 731

    rollback to update_cost;

Line: 743

    rollback to update_cost;

Line: 747

end update_cost;

Line: 753

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

Line: 768

  savepoint delete_cost;

Line: 776

  ota_tpc_api_bk3.delete_cost_b
  (p_training_plan_cost_id       => p_training_plan_cost_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 783

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

Line: 801

  ota_tpc_api_bk3.delete_cost_a
  (p_training_plan_cost_id       => p_training_plan_cost_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 808

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

Line: 829

    rollback to delete_cost;

Line: 840

    rollback to delete_cost;

Line: 843

end delete_cost;