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

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

Line: 145


    select non_payments_flag, default_priority
      from pay_element_classifications
     where classification_id = p_classification_id;

Line: 151


    select contributions_used
      from ben_benefit_classifications
     where benefit_classification_id = p_benefit_classification_id;

Line: 518


  pay_sub_class_rules_pkg.insert_defaults
    (l_element_type_id
    ,p_classification_id
    ,l_effective_start_date
    ,l_effective_end_date
    ,p_business_group_id
    ,null);

Line: 693


procedure UPDATE_ELEMENT_TYPE
  (p_validate                        in     boolean  default false
  ,p_effective_date                  in     date
  ,p_datetrack_update_mode	     in     varchar2
  ,p_element_type_id        	     in     number
  ,p_object_version_number  	     in out nocopy number
  ,p_formula_id                      in     number   default hr_api.g_number
  ,p_benefit_classification_id       in     number   default hr_api.g_number
  ,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_reporting_name                  in     varchar2 default hr_api.g_varchar2
  ,p_description                     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_processing_priority             in     number   default hr_api.g_number
  ,p_standard_link_flag              in     varchar2 default hr_api.g_varchar2
  ,p_comments                        in     varchar2 default hr_api.g_varchar2
  ,p_third_party_pay_only_flag       in	    varchar2 default hr_api.g_varchar2
  ,p_iterative_flag                  in	    varchar2 default hr_api.g_varchar2
  ,p_iterative_formula_id            in	    number   default hr_api.g_number
  ,p_iterative_priority              in	    number   default hr_api.g_number
  ,p_creator_type                    in	    varchar2 default hr_api.g_varchar2
  ,p_retro_summ_ele_id               in     number   default hr_api.g_number
  ,p_grossup_flag                    in	    varchar2 default hr_api.g_varchar2
  ,p_process_mode                    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_id              in	    number   default hr_api.g_number
  ,p_proration_formula_id            in	    number   default hr_api.g_number
  ,p_recalc_event_group_id 	     in	    number   default hr_api.g_number
  ,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_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_once_each_period_flag           in     varchar2 default hr_api.g_varchar2
  ,p_language_code                   in     varchar2 default hr_api.userenv_lang
  ,p_time_definition_type	     in     varchar2 default hr_api.g_varchar2
  ,p_time_definition_id		     in     number   default hr_api.g_number
  ,p_advance_element_type_id	     in     number   default hr_api.g_number
  ,p_deduction_element_type_id	     in     number   default hr_api.g_number
  ,p_effective_start_date               out nocopy date
  ,p_effective_end_date                 out nocopy date
  ,p_comment_id                         out nocopy number
  ,p_processing_priority_warning        out nocopy boolean
  ,p_element_name_warning               out nocopy boolean
  ,p_element_name_change_warning        out nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc               		varchar2(72):=g_package||'UPDATE_ELEMENT_TYPE';

Line: 800


  l_datetrack_update_mode	varchar2(30) := p_datetrack_update_mode;

Line: 811


    select etp.*
      from pay_element_types_f etp
     where element_type_id = p_element_type_id
       and nvl(v_effective_date,effective_start_date) >= effective_start_date
       and nvl(v_effective_date,effective_end_date) <= effective_end_date;

Line: 819


    SELECT source_lang, element_name, element_type_id
      FROM pay_element_types_f_tl ett
     WHERE ett.element_type_id = p_element_type_id
       AND ett.language = nvl(p_language_code,ett.language);

Line: 829


  savepoint UPDATE_ELEMENT_TYPE;

Line: 849


    PAY_ELEMENT_TYPES_BK2.UPDATE_ELEMENT_TYPE_b
     (p_effective_date                  =>   l_effective_date
     ,p_datetrack_update_mode		=>   p_datetrack_update_mode
     ,p_element_type_id        	        =>   p_element_type_id
     ,p_object_version_number  		=>   l_object_version_number
     ,p_formula_id                  	=>   p_formula_id
     ,p_benefit_classification_id   	=>   p_benefit_classification_id
     ,p_additional_entry_allowed_fla    =>   p_additional_entry_allowed_fla
     ,p_adjustment_only_flag        	=>   p_adjustment_only_flag
     ,p_closed_for_entry_flag       	=>   p_closed_for_entry_flag
     ,p_element_name                	=>   p_element_name
     ,p_reporting_name              	=>   p_reporting_name
     ,p_description                 	=>   p_description
     ,p_indirect_only_flag          	=>   p_indirect_only_flag
     ,p_multiple_entries_allowed_fla    =>   p_multiple_entries_allowed_fla
     ,p_multiply_value_flag         	=>   p_multiply_value_flag
     ,p_post_termination_rule       	=>   p_post_termination_rule
     ,p_process_in_run_flag         	=>   p_process_in_run_flag
     ,p_processing_priority         	=>   p_processing_priority
     ,p_standard_link_flag          	=>   p_standard_link_flag
     ,p_comments                    	=>   p_comments
     ,p_qualifying_age              	=>   p_qualifying_age
     ,p_qualifying_length_of_service    =>   p_qualifying_length_of_service
     ,p_qualifying_units            	=>   p_qualifying_units
     ,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_element_information_category    =>   p_element_information_category
     ,p_element_information1        	=>   p_element_information1
     ,p_element_information2        	=>   p_element_information2
     ,p_element_information3        	=>   p_element_information3
     ,p_element_information4        	=>   p_element_information4
     ,p_element_information5        	=>   p_element_information5
     ,p_element_information6        	=>   p_element_information6
     ,p_element_information7        	=>   p_element_information7
     ,p_element_information8        	=>   p_element_information8
     ,p_element_information9        	=>   p_element_information9
     ,p_element_information10       	=>   p_element_information10
     ,p_element_information11       	=>   p_element_information11
     ,p_element_information12       	=>   p_element_information12
     ,p_element_information13       	=>   p_element_information13
     ,p_element_information14       	=>   p_element_information14
     ,p_element_information15       	=>   p_element_information15
     ,p_element_information16       	=>   p_element_information16
     ,p_element_information17       	=>   p_element_information17
     ,p_element_information18       	=>   p_element_information18
     ,p_element_information19       	=>   p_element_information19
     ,p_element_information20       	=>   p_element_information20
     ,p_third_party_pay_only_flag   	=>   p_third_party_pay_only_flag
     ,p_iterative_flag              	=>   p_iterative_flag
     ,p_iterative_formula_id        	=>   p_iterative_formula_id
     ,p_iterative_priority          	=>   p_iterative_priority
     ,p_creator_type                	=>   p_creator_type
     ,p_retro_summ_ele_id           	=>   p_retro_summ_ele_id
     ,p_grossup_flag                	=>   p_grossup_flag
     ,p_process_mode                	=>   p_process_mode
     ,p_advance_indicator           	=>   p_advance_indicator
     ,p_advance_payable             	=>   p_advance_payable
     ,p_advance_deduction           	=>   p_advance_deduction
     ,p_process_advance_entry       	=>   p_process_advance_entry
     ,p_proration_group_id          	=>   p_proration_group_id
     ,p_proration_formula_id        	=>   p_proration_formula_id
     ,p_recalc_event_group_id 		=>   p_recalc_event_group_id
     ,p_once_each_period_flag           =>   p_once_each_period_flag
     ,p_language_code                   =>   l_language_code
     ,p_time_definition_type	        =>   p_time_definition_type
     ,p_time_definition_id		=>   p_time_definition_id
     ,p_advance_element_type_id		=>   p_advance_element_type_id
     ,p_deduction_element_type_id	=>   p_deduction_element_type_id
     );

Line: 940


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

Line: 1011


    If nvl(p_datetrack_update_mode,hr_api.g_correction)
  	   <> hr_api.g_correction Then
      l_datetrack_update_mode := hr_api.g_correction;

Line: 1054


    ,p_datetrack_mode               	=>	 l_datetrack_update_mode
    ,p_element_type_id              	=>	 p_element_type_id
    ,p_object_version_number        	=>	 l_object_version_number
    ,p_additional_entry_allowed_fla 	=>	 p_additional_entry_allowed_fla
    ,p_adjustment_only_flag         	=>	 p_adjustment_only_flag
    ,p_closed_for_entry_flag        	=>	 p_closed_for_entry_flag
    ,p_element_name                 	=>	 l_base_element_name
    ,p_indirect_only_flag           	=>	 p_indirect_only_flag
    ,p_multiple_entries_allowed_fla 	=>	 p_multiple_entries_allowed_fla
    ,p_multiply_value_flag          	=>	 p_multiply_value_flag
    ,p_post_termination_rule        	=>	 p_post_termination_rule
    ,p_process_in_run_flag          	=>	 p_process_in_run_flag
    ,p_processing_priority          	=>	 p_processing_priority
    ,p_standard_link_flag           	=>	 p_standard_link_flag
    ,p_formula_id                   	=>	 p_formula_id
    ,p_benefit_classification_id    	=>	 p_benefit_classification_id
    ,p_description                  	=>	 p_description
    ,p_qualifying_age               	=>	 p_qualifying_age
    ,p_qualifying_length_of_service 	=>	 p_qualifying_length_of_service
    ,p_qualifying_units             	=>	 p_qualifying_units
    ,p_reporting_name               	=>	 p_reporting_name
    ,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_element_information_category 	=>	 p_element_information_category
    ,p_element_information1         	=>	 p_element_information1
    ,p_element_information2         	=>	 p_element_information2
    ,p_element_information3         	=>	 p_element_information3
    ,p_element_information4         	=>	 p_element_information4
    ,p_element_information5         	=>	 p_element_information5
    ,p_element_information6         	=>	 p_element_information6
    ,p_element_information7         	=>	 p_element_information7
    ,p_element_information8         	=>	 p_element_information8
    ,p_element_information9         	=>	 p_element_information9
    ,p_element_information10        	=>	 p_element_information10
    ,p_element_information11        	=>	 p_element_information11
    ,p_element_information12        	=>	 p_element_information12
    ,p_element_information13        	=>	 p_element_information13
    ,p_element_information14        	=>	 p_element_information14
    ,p_element_information15        	=>	 p_element_information15
    ,p_element_information16        	=>	 p_element_information16
    ,p_element_information17        	=>	 p_element_information17
    ,p_element_information18        	=>	 p_element_information18
    ,p_element_information19        	=>	 p_element_information19
    ,p_element_information20        	=>	 p_element_information20
    ,p_third_party_pay_only_flag    	=>	 p_third_party_pay_only_flag
    ,p_iterative_flag               	=>	 p_iterative_flag
    ,p_iterative_formula_id         	=>	 p_iterative_formula_id
    ,p_iterative_priority           	=>	 p_iterative_priority
    ,p_creator_type                 	=>	 p_creator_type
    ,p_retro_summ_ele_id            	=>	 p_retro_summ_ele_id
    ,p_grossup_flag                 	=>	 p_grossup_flag
    ,p_process_mode                 	=>	 p_process_mode
    ,p_advance_indicator            	=>	 p_advance_indicator
    ,p_advance_payable              	=>	 p_advance_payable
    ,p_advance_deduction            	=>	 p_advance_deduction
    ,p_process_advance_entry        	=>	 p_process_advance_entry
    ,p_proration_group_id           	=>	 p_proration_group_id
    ,p_proration_formula_id         	=>	 p_proration_formula_id
    ,p_recalc_event_group_id        	=>	 p_recalc_event_group_id
    ,p_once_each_period_flag            =>       p_once_each_period_flag
    ,p_time_definition_type	        =>       p_time_definition_type
    ,p_time_definition_id		=>       p_time_definition_id
    ,p_advance_element_type_id		=>       p_advance_element_type_id
    ,p_deduction_element_type_id	=>       p_deduction_element_type_id
    ,p_effective_start_date         	=>	 l_effective_start_date
    ,p_effective_end_date           	=>	 l_effective_end_date
    ,p_comment_id                   	=>	 l_comment_id
    ,p_processing_priority_warning	=>       l_processing_priority_warning
    );

Line: 1173


    PAY_ELEMENT_TYPES_BK2.UPDATE_ELEMENT_TYPE_a
     (p_effective_date                  =>   l_effective_date
     ,p_datetrack_update_mode		=>   l_datetrack_update_mode
     ,p_element_type_id        	        =>   p_element_type_id
     ,p_object_version_number  		=>   l_object_version_number
     ,p_formula_id                  	=>   p_formula_id
     ,p_benefit_classification_id   	=>   p_benefit_classification_id
     ,p_additional_entry_allowed_fla    =>   p_additional_entry_allowed_fla
     ,p_adjustment_only_flag        	=>   p_adjustment_only_flag
     ,p_closed_for_entry_flag       	=>   p_closed_for_entry_flag
     ,p_element_name                	=>   p_element_name
     ,p_reporting_name              	=>   p_reporting_name
     ,p_description                 	=>   p_description
     ,p_indirect_only_flag          	=>   p_indirect_only_flag
     ,p_multiple_entries_allowed_fla    =>   p_multiple_entries_allowed_fla
     ,p_multiply_value_flag         	=>   p_multiply_value_flag
     ,p_post_termination_rule       	=>   p_post_termination_rule
     ,p_process_in_run_flag         	=>   p_process_in_run_flag
     ,p_processing_priority         	=>   p_processing_priority
     ,p_standard_link_flag          	=>   p_standard_link_flag
     ,p_comments                    	=>   p_comments
     ,p_comment_id			=>   l_comment_id
     ,p_qualifying_age              	=>   p_qualifying_age
     ,p_qualifying_length_of_service    =>   p_qualifying_length_of_service
     ,p_qualifying_units            	=>   p_qualifying_units
     ,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_element_information_category    =>   p_element_information_category
     ,p_element_information1        	=>   p_element_information1
     ,p_element_information2        	=>   p_element_information2
     ,p_element_information3        	=>   p_element_information3
     ,p_element_information4        	=>   p_element_information4
     ,p_element_information5        	=>   p_element_information5
     ,p_element_information6        	=>   p_element_information6
     ,p_element_information7        	=>   p_element_information7
     ,p_element_information8        	=>   p_element_information8
     ,p_element_information9        	=>   p_element_information9
     ,p_element_information10       	=>   p_element_information10
     ,p_element_information11       	=>   p_element_information11
     ,p_element_information12       	=>   p_element_information12
     ,p_element_information13       	=>   p_element_information13
     ,p_element_information14       	=>   p_element_information14
     ,p_element_information15       	=>   p_element_information15
     ,p_element_information16       	=>   p_element_information16
     ,p_element_information17       	=>   p_element_information17
     ,p_element_information18       	=>   p_element_information18
     ,p_element_information19       	=>   p_element_information19
     ,p_element_information20       	=>   p_element_information20
     ,p_third_party_pay_only_flag   	=>   p_third_party_pay_only_flag
     ,p_iterative_flag              	=>   p_iterative_flag
     ,p_iterative_formula_id        	=>   p_iterative_formula_id
     ,p_iterative_priority          	=>   p_iterative_priority
     ,p_creator_type                	=>   p_creator_type
     ,p_retro_summ_ele_id           	=>   p_retro_summ_ele_id
     ,p_grossup_flag                	=>   p_grossup_flag
     ,p_process_mode                	=>   p_process_mode
     ,p_advance_indicator           	=>   p_advance_indicator
     ,p_advance_payable             	=>   p_advance_payable
     ,p_advance_deduction           	=>   p_advance_deduction
     ,p_process_advance_entry       	=>   p_process_advance_entry
     ,p_proration_group_id          	=>   p_proration_group_id
     ,p_proration_formula_id        	=>   p_proration_formula_id
     ,p_recalc_event_group_id 		=>   p_recalc_event_group_id
     ,p_once_each_period_flag           =>   p_once_each_period_flag
     ,p_language_code                   =>   l_language_code
     ,p_time_definition_type	        =>   p_time_definition_type
     ,p_time_definition_id		=>   p_time_definition_id
     ,p_advance_element_type_id		=>   p_advance_element_type_id
     ,p_deduction_element_type_id	=>   p_deduction_element_type_id
     ,p_effective_start_date            =>   l_effective_start_date
     ,p_effective_end_date         	=>   l_effective_end_date
     ,p_processing_priority_warning	=>   l_processing_priority_warning
     ,p_element_name_warning            =>   l_element_name_warning
     ,p_element_name_change_warning     =>   l_element_name_change_warning
     );

Line: 1270


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

Line: 1298


    rollback to UPDATE_ELEMENT_TYPE;

Line: 1317


    rollback to UPDATE_ELEMENT_TYPE;

Line: 1320


end UPDATE_ELEMENT_TYPE;

Line: 1326


procedure DELETE_ELEMENT_TYPE
  (p_validate                        in     boolean default false
  ,p_effective_date                  in     date
  ,p_datetrack_delete_mode           in     varchar2
  ,p_element_type_id                 in     number
  ,p_object_version_number           in out nocopy number
  ,p_effective_start_date               out nocopy date
  ,p_effective_end_date                 out nocopy date
  ,p_balance_feeds_warning              out nocopy boolean
  ,p_processing_rules_warning           out nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                	varchar2(72):=g_package||'DELETE_ELEMENT_TYP';

Line: 1354


  savepoint DELETE_ELEMENT_TYPE;

Line: 1364


    PAY_ELEMENT_TYPES_BK3.DELETE_ELEMENT_TYPE_b
      (p_effective_date              =>  l_effective_date
      ,p_datetrack_delete_mode       =>  p_datetrack_delete_mode
      ,p_element_type_id             =>  p_element_type_id
      ,p_object_version_number       =>  l_object_version_number
      );

Line: 1373


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

Line: 1386


    ,p_datetrack_mode 		=>  p_datetrack_delete_mode
    ,p_element_type_id		=>  p_element_type_id
    ,p_object_version_number    =>  l_object_version_number
    ,p_effective_start_date     =>  l_effective_start_date
    ,p_effective_end_date       =>  l_effective_end_date
    ,p_balance_feeds_warning    =>  l_balance_feeds_warning
    ,p_processing_rules_warning =>  l_processing_rules_warning
    );

Line: 1399


    PAY_ELEMENT_TYPES_BK3.DELETE_ELEMENT_TYPE_a
      (p_effective_date              =>  p_effective_date
      ,p_datetrack_delete_mode       =>  p_datetrack_delete_mode
      ,p_element_type_id             =>  p_element_type_id
      ,p_object_version_number       =>  l_object_version_number
      ,p_effective_start_date        =>  l_effective_start_date
      ,p_effective_end_date          =>  l_effective_end_date
      ,p_balance_feeds_warning       =>  l_balance_feeds_warning
      ,p_processing_rules_warning    =>  l_processing_rules_warning
      );

Line: 1412


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

Line: 1438


    rollback to DELETE_ELEMENT_TYPE;

Line: 1455


    rollback to DELETE_ELEMENT_TYPE;

Line: 1458


end DELETE_ELEMENT_TYPE;