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

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

Line: 13


procedure update_shadow_element
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_element_type_id               in     number
  ,p_classification_name           in     varchar2 default hr_api.g_varchar2
  ,p_additional_entry_allowed_fla  in     varchar2 default hr_api.g_varchar2
  ,p_adjustment_only_flag          in     varchar2 default hr_api.g_varchar2
  ,p_closed_for_entry_flag         in     varchar2 default hr_api.g_varchar2
  ,p_element_name                  in     varchar2 default hr_api.g_varchar2
  ,p_indirect_only_flag            in     varchar2 default hr_api.g_varchar2
  ,p_multiple_entries_allowed_fla  in     varchar2 default hr_api.g_varchar2
  ,p_multiply_value_flag           in     varchar2 default hr_api.g_varchar2
  ,p_post_termination_rule         in     varchar2 default hr_api.g_varchar2
  ,p_process_in_run_flag           in     varchar2 default hr_api.g_varchar2
  ,p_relative_processing_priority  in     number   default hr_api.g_number
  ,p_processing_type               in     varchar2 default hr_api.g_varchar2
  ,p_standard_link_flag            in     varchar2 default hr_api.g_varchar2
  ,p_input_currency_code           in     varchar2 default hr_api.g_varchar2
  ,p_output_currency_code          in     varchar2 default hr_api.g_varchar2
  ,p_benefit_classification_name   in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_qualifying_age                in     number   default hr_api.g_number
  ,p_qualifying_length_of_service  in     number   default hr_api.g_number
  ,p_qualifying_units              in     varchar2 default hr_api.g_varchar2
  ,p_reporting_name                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_element_information_category  in     varchar2 default hr_api.g_varchar2
  ,p_element_information1          in     varchar2 default hr_api.g_varchar2
  ,p_element_information2          in     varchar2 default hr_api.g_varchar2
  ,p_element_information3          in     varchar2 default hr_api.g_varchar2
  ,p_element_information4          in     varchar2 default hr_api.g_varchar2
  ,p_element_information5          in     varchar2 default hr_api.g_varchar2
  ,p_element_information6          in     varchar2 default hr_api.g_varchar2
  ,p_element_information7          in     varchar2 default hr_api.g_varchar2
  ,p_element_information8          in     varchar2 default hr_api.g_varchar2
  ,p_element_information9          in     varchar2 default hr_api.g_varchar2
  ,p_element_information10         in     varchar2 default hr_api.g_varchar2
  ,p_element_information11         in     varchar2 default hr_api.g_varchar2
  ,p_element_information12         in     varchar2 default hr_api.g_varchar2
  ,p_element_information13         in     varchar2 default hr_api.g_varchar2
  ,p_element_information14         in     varchar2 default hr_api.g_varchar2
  ,p_element_information15         in     varchar2 default hr_api.g_varchar2
  ,p_element_information16         in     varchar2 default hr_api.g_varchar2
  ,p_element_information17         in     varchar2 default hr_api.g_varchar2
  ,p_element_information18         in     varchar2 default hr_api.g_varchar2
  ,p_element_information19         in     varchar2 default hr_api.g_varchar2
  ,p_element_information20         in     varchar2 default hr_api.g_varchar2
  ,p_third_party_pay_only_flag     in     varchar2 default hr_api.g_varchar2
  ,p_skip_formula                  in     varchar2 default hr_api.g_varchar2
  ,p_payroll_formula_id            in     number   default hr_api.g_number
  ,p_exclusion_rule_id             in     number   default hr_api.g_number
  ,p_iterative_flag                in     varchar2 default hr_api.g_varchar2
  ,p_iterative_priority            in     number   default hr_api.g_number
  ,p_iterative_formula_name        in     varchar2 default hr_api.g_varchar2
  ,p_process_mode                  in     varchar2 default hr_api.g_varchar2
  ,p_grossup_flag                  in     varchar2 default hr_api.g_varchar2
  ,p_advance_indicator             in     varchar2 default hr_api.g_varchar2
  ,p_advance_payable               in     varchar2 default hr_api.g_varchar2
  ,p_advance_deduction             in     varchar2 default hr_api.g_varchar2
  ,p_process_advance_entry         in     varchar2 default hr_api.g_varchar2
  ,p_proration_group               in     varchar2 default hr_api.g_varchar2
  ,p_proration_formula             in     varchar2 default hr_api.g_varchar2
  ,p_recalc_event_group            in     varchar2 default hr_api.g_varchar2
  ,p_once_each_period_flag         in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72);

Line: 108


     l_proc := g_package||'update_shadow_element';

Line: 114


  savepoint update_shadow_element;

Line: 262


    rollback to update_shadow_element;

Line: 276


    rollback to update_shadow_element;

Line: 282


end update_shadow_element;