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

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

Line: 291


procedure UPDATE_RESOURCE_DEFINITION
  (p_supplied_resource_id          in number
  ,p_vendor_id                    in number
  ,p_business_group_id            in number
  ,p_resource_definition_id       in number
  ,p_consumable_flag              in varchar2
  ,p_object_version_number        in out nocopy number
  ,p_resource_type                in varchar2
  ,p_start_date                   in date default hr_api.g_date
  ,p_comments                     in varchar2
  ,p_cost                         in number
  ,p_cost_unit                    in varchar2
  ,p_currency_code                in varchar2
  ,p_end_date                     in date default hr_api.g_date
  ,p_internal_address_line        in varchar2
  ,p_lead_time                    in number
  ,p_name                         in varchar2
  ,p_supplier_reference           in varchar2
  ,p_tsr_information_category     in varchar2
  ,p_tsr_information1             in varchar2
  ,p_tsr_information2             in varchar2
  ,p_tsr_information3             in varchar2
  ,p_tsr_information4             in varchar2
  ,p_tsr_information5             in varchar2
  ,p_tsr_information6             in varchar2
  ,p_tsr_information7             in varchar2
  ,p_tsr_information8             in varchar2
  ,p_tsr_information9             in varchar2
  ,p_tsr_information10            in varchar2
  ,p_tsr_information11            in varchar2
  ,p_tsr_information12            in varchar2
  ,p_tsr_information13            in varchar2
  ,p_tsr_information14            in varchar2
  ,p_tsr_information15            in varchar2
  ,p_tsr_information16            in varchar2
  ,p_tsr_information17            in varchar2
  ,p_tsr_information18            in varchar2
  ,p_tsr_information19            in varchar2
  ,p_tsr_information20            in varchar2
  ,p_training_center_id           in number
  ,p_location_id	          in number
  ,p_trainer_id                   in number
  ,p_special_instruction          in varchar2
  ,p_validate                     in boolean
  ,p_effective_date               in date
  ,p_data_source                  in varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Resource Definition';

Line: 350


  savepoint UPDATE_RESOURCE_DEFINITION;

Line: 361


    OTA_RESOURCE_DEFINITION_BK2.UPDATE_RESOURCE_DEFINITION_B
  ( p_supplied_resource_id        => p_supplied_resource_id
,p_vendor_id                   => p_vendor_id
,p_business_group_id           => p_business_group_id
,p_resource_definition_id      => p_resource_definition_id
,p_consumable_flag             => p_consumable_flag
,p_object_version_number       => p_object_version_number
,p_resource_type               => p_resource_type
,p_start_date                  => p_start_date
,p_comments                    => p_comments
,p_cost                        => p_cost
,p_cost_unit                   => p_cost_unit
,p_currency_code               => p_currency_code
,p_end_date                    => p_end_date
,p_internal_address_line       => p_internal_address_line
,p_lead_time                   => p_lead_time
,p_name                        => p_name
,p_supplier_reference          => p_supplier_reference
,p_tsr_information_category    => p_tsr_information_category
,p_tsr_information1            => p_tsr_information1
,p_tsr_information2            => p_tsr_information2
,p_tsr_information3            => p_tsr_information3
,p_tsr_information4            => p_tsr_information4
,p_tsr_information5            => p_tsr_information5
,p_tsr_information6            => p_tsr_information6
,p_tsr_information7            => p_tsr_information7
,p_tsr_information8            => p_tsr_information8
,p_tsr_information9            => p_tsr_information9
,p_tsr_information10           => p_tsr_information10
,p_tsr_information11           => p_tsr_information11
,p_tsr_information12           => p_tsr_information12
,p_tsr_information13           => p_tsr_information13
,p_tsr_information14           => p_tsr_information14
,p_tsr_information15           => p_tsr_information15
,p_tsr_information16           => p_tsr_information16
,p_tsr_information17           => p_tsr_information17
,p_tsr_information18           => p_tsr_information18
,p_tsr_information19           => p_tsr_information19
,p_tsr_information20           => p_tsr_information20
,p_training_center_id          => p_training_center_id
,p_location_id	               => p_location_id
,p_trainer_id                  => p_trainer_id
,p_special_instruction         => p_special_instruction
,p_effective_date              => l_effective_date
,p_data_source                 => p_data_source
  );

Line: 410


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

Line: 475


  OTA_RESOURCE_DEFINITION_BK2.UPDATE_RESOURCE_DEFINITION_A
  ( p_supplied_resource_id        => p_supplied_resource_id
,p_vendor_id                   => p_vendor_id
,p_business_group_id           => p_business_group_id
,p_resource_definition_id      => p_resource_definition_id
,p_consumable_flag             => p_consumable_flag
,p_object_version_number       => p_object_version_number
,p_resource_type               => p_resource_type
,p_start_date                  => p_start_date
,p_comments                    => p_comments
,p_cost                        => p_cost
,p_cost_unit                   => p_cost_unit
,p_currency_code               => p_currency_code
,p_end_date                    => p_end_date
,p_internal_address_line       => p_internal_address_line
,p_lead_time                   => p_lead_time
,p_name                        => p_name
,p_supplier_reference          => p_supplier_reference
,p_tsr_information_category    => p_tsr_information_category
,p_tsr_information1            => p_tsr_information1
,p_tsr_information2            => p_tsr_information2
,p_tsr_information3            => p_tsr_information3
,p_tsr_information4            => p_tsr_information4
,p_tsr_information5            => p_tsr_information5
,p_tsr_information6            => p_tsr_information6
,p_tsr_information7            => p_tsr_information7
,p_tsr_information8            => p_tsr_information8
,p_tsr_information9            => p_tsr_information9
,p_tsr_information10           => p_tsr_information10
,p_tsr_information11           => p_tsr_information11
,p_tsr_information12           => p_tsr_information12
,p_tsr_information13           => p_tsr_information13
,p_tsr_information14           => p_tsr_information14
,p_tsr_information15           => p_tsr_information15
,p_tsr_information16           => p_tsr_information16
,p_tsr_information17           => p_tsr_information17
,p_tsr_information18           => p_tsr_information18
,p_tsr_information19           => p_tsr_information19
,p_tsr_information20           => p_tsr_information20
,p_training_center_id          => p_training_center_id
,p_location_id	               => p_location_id
,p_trainer_id                  => p_trainer_id
,p_special_instruction         => p_special_instruction
,p_effective_date              => l_effective_date
,p_data_source                 => p_data_source
  );

Line: 524


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

Line: 545


    rollback to UPDATE_RESOURCE_DEFINITION;

Line: 557


    rollback to UPDATE_RESOURCE_DEFINITION;

Line: 561


end update_RESOURCE_DEFINITION;

Line: 567


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

Line: 584


  savepoint DELETE_RESOURCE_DEFINITION;

Line: 593


    OTA_RESOURCE_DEFINITION_BK3.DELETE_RESOURCE_DEFINITION_B
  (p_supplied_resource_id            => p_supplied_resource_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 600


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

Line: 623


  OTA_RESOURCE_DEFINITION_BK3.DELETE_RESOURCE_DEFINITION_A
  (p_supplied_resource_id            => p_supplied_resource_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 630


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

Line: 652


    rollback to DELETE_RESOURCE_DEFINITION;

Line: 663


    rollback to DELETE_RESOURCE_DEFINITION;

Line: 666


end delete_RESOURCE_DEFINITION;