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

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

Line: 53


    SELECT cagr_api_id
	  FROM per_cagr_api_parameters p
	 WHERE p.cagr_api_param_id = p_cagr_api_param_id;

Line: 279


procedure update_cagr_entitlement_item
  (p_validate                       in     boolean   default false
  ,p_effective_date                 in     date
  ,p_language_code                  in     varchar2  DEFAULT hr_api.userenv_lang
  ,p_cagr_entitlement_item_id       in     number    default hr_api.g_number
  ,p_business_group_id              in     number    default hr_api.g_number
  ,p_item_name                      in     varchar2  default hr_api.g_varchar2
  ,p_element_type_id                in     number    default hr_api.g_number
  ,p_input_value_id                 in     varchar2  default hr_api.g_varchar2
  ,p_column_type                    in     varchar2  default hr_api.g_varchar2
  ,p_column_size                    in     number    default hr_api.g_number
  ,p_legislation_code               in     varchar2  default hr_api.g_varchar2
  ,p_beneficial_rule                in     varchar2  default hr_api.g_varchar2
  ,p_cagr_api_param_id              in     number    default hr_api.g_number
  ,p_category_name                  in     varchar2  default hr_api.g_varchar2
  ,p_beneficial_formula_id          in     number    default hr_api.g_number
  ,p_uom                            in     varchar2  default hr_api.g_varchar2
  ,p_flex_value_set_id              in     number    default hr_api.g_number
  ,p_ben_rule_value_set_id	        in     number    default hr_api.g_number
  ,p_mult_entries_allowed_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) := g_package||'update_cagr_entitlement_item';

Line: 311


    SELECT cagr_api_id
	  FROM per_cagr_api_parameters p
	 WHERE p.cagr_api_param_id = p_cagr_api_param_id;

Line: 321


  savepoint update_cagr_entitlement_item;

Line: 369


    hr_cagr_ent_item_bk2.update_cagr_entitlement_item_b
      (p_cagr_entitlement_item_id       =>  p_cagr_entitlement_item_id
       ,p_language_code		            =>  p_language_code
      ,p_business_group_id              =>  p_business_group_id
      ,p_item_name                      =>  p_item_name
      ,p_element_type_id                =>  p_element_type_id
      ,p_input_value_id                 =>  p_input_value_id
	  ,p_column_type                    =>  p_column_type
	  ,p_column_size                    =>  p_column_size
      ,p_legislation_code               =>  p_legislation_code
      ,p_beneficial_rule                =>  p_beneficial_rule
      ,p_cagr_api_id                    =>  l_cagr_api_id
      ,p_cagr_api_param_id              =>  p_cagr_api_param_id
      ,p_category_name                  =>  p_category_name
      ,p_beneficial_formula_id          =>  p_beneficial_formula_id
      ,p_uom                            =>  p_uom
      ,p_flex_value_set_id              =>  p_flex_value_set_id
      ,p_ben_rule_value_set_id	        =>  p_ben_rule_value_set_id
      ,p_mult_entries_allowed_flag      =>  p_mult_entries_allowed_flag
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 393


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

Line: 432


    hr_cagr_ent_item_bk2.update_cagr_entitlement_item_a
      (p_cagr_entitlement_item_id       =>  p_cagr_entitlement_item_id
      ,p_language_code		            =>  p_language_code
      ,p_business_group_id              =>  p_business_group_id
      ,p_item_name                      =>  p_item_name
      ,p_element_type_id                =>  p_element_type_id
      ,p_input_value_id                 =>  p_input_value_id
	  ,p_column_type                    =>  p_column_type
	  ,p_column_size                    =>  p_column_size
      ,p_legislation_code               =>  p_legislation_code
      ,p_beneficial_rule                =>  p_beneficial_rule
      ,p_cagr_api_id                    =>  l_cagr_api_id
      ,p_cagr_api_param_id              =>  p_cagr_api_param_id
      ,p_category_name                  =>  p_category_name
      ,p_beneficial_formula_id          =>  p_beneficial_formula_id
      ,p_uom                            =>  p_uom
      ,p_flex_value_set_id              =>  p_flex_value_set_id
      ,p_ben_rule_value_set_id	        =>  p_ben_rule_value_set_id
      ,p_mult_entries_allowed_flag      =>  p_mult_entries_allowed_flag
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 456


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

Line: 485


    ROLLBACK TO update_cagr_entitlement_item;

Line: 497


    ROLLBACK TO update_cagr_entitlement_item;

Line: 500


end update_cagr_entitlement_item;

Line: 505


procedure delete_cagr_entitlement_item
  (p_validate                       in     boolean  default false
  ,p_effective_date                 in     date
  ,p_cagr_entitlement_item_id       in     number
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_cagr_entitlement_item';

Line: 523


      SELECT b.opt_id,
  	       b.object_version_number
  	  FROM ben_opt_f b,
  	       PER_CAGR_ENTITLEMENT_ITEMS cagitems
  	 WHERE b.opt_id = cagitems.opt_Id
	   AND cagitems.CAGR_ENTITLEMENT_ITEM_ID = p_cagr_entitlement_item_id;

Line: 536


  savepoint delete_cagr_entitlement_item;

Line: 551


    hr_cagr_ent_item_bk3.delete_cagr_entitlement_item_b
      (p_cagr_entitlement_item_id       =>  p_cagr_entitlement_item_id
      ,p_effective_date                 =>  l_effective_date
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 559


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

Line: 582


  	ben_option_definition_api.delete_option_definition
	  (p_validate                       => p_validate
	  ,p_opt_id                         => l_opt_id
	  ,p_effective_start_date           => l_effective_start_date
	  ,p_effective_end_date             => l_effective_end_date
	  ,p_object_version_number          => l_opt_ovn
	  ,p_effective_date                 => p_effective_date
	  ,p_datetrack_mode                 => 'ZAP'
  	);

Line: 610


    hr_cagr_ent_item_bk3.delete_cagr_entitlement_item_a
      (p_cagr_entitlement_item_id       =>  p_cagr_entitlement_item_id
      ,p_effective_date                 =>  l_effective_date
      ,p_object_version_number          =>  l_object_version_number);

Line: 618


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

Line: 643


    ROLLBACK TO delete_cagr_entitlement_item;

Line: 654


    ROLLBACK TO delete_cagr_entitlement_item;

Line: 657


end delete_cagr_entitlement_item;