APPS.HR_CAGR_ENTITLEMENT_API SQL Statements

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

Line: 168

PROCEDURE update_cagr_entitlement
  (p_validate                       IN    BOOLEAN   DEFAULT false
  ,p_effective_date                 IN    DATE
  ,p_cagr_entitlement_id            IN    NUMBER    DEFAULT hr_api.g_number
  ,p_cagr_entitlement_item_id       IN    NUMBER    DEFAULT hr_api.g_number
  ,p_collective_agreement_id        IN    NUMBER    DEFAULT hr_api.g_number
  ,p_status                         IN    VARCHAR2  DEFAULT hr_api.g_varchar2
  ,p_end_date                       IN    DATE      DEFAULT hr_api.g_date
  ,p_formula_criteria               IN    VARCHAR2  DEFAULT hr_api.g_varchar2
  ,p_formula_id                     IN    NUMBER    DEFAULT hr_api.g_number
  ,p_units_of_measure               IN    VARCHAR2  DEFAULT hr_api.g_varchar2
  ,p_message_level                  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';

Line: 196

  SAVEPOINT update_cagr_entitlement;

Line: 212

    hr_cagr_entitlement_bk2.update_cagr_entitlement_b
      (
       p_cagr_entitlement_id            =>  p_cagr_entitlement_id
      ,p_cagr_entitlement_item_id       =>  p_cagr_entitlement_item_id
      ,p_collective_agreement_id        =>  p_collective_agreement_id
      ,p_status                         =>  p_status
	  ,p_end_date                       =>  p_end_date
      ,p_formula_criteria               =>  p_formula_criteria
      ,p_formula_id                     =>  p_formula_id
      ,p_units_of_measure               =>  p_units_of_measure
	  ,p_message_level                  =>  p_message_level
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 228

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

Line: 255

    hr_cagr_entitlement_bk2.update_cagr_entitlement_a
      (
       p_cagr_entitlement_id            =>  p_cagr_entitlement_id
      ,p_cagr_entitlement_item_id       =>  p_cagr_entitlement_item_id
      ,p_collective_agreement_id        =>  p_collective_agreement_id
      ,p_status                         =>  p_status
	  ,p_end_date                       =>  p_end_date
      ,p_formula_criteria               =>  p_formula_criteria
      ,p_formula_id                     =>  p_formula_id
      ,p_units_of_measure               =>  p_units_of_measure
	  ,p_message_level                  =>  p_message_level
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 271

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

Line: 303

    ROLLBACK TO update_cagr_entitlement;

Line: 315

    ROLLBACK TO update_cagr_entitlement;

Line: 322

END update_cagr_entitlement;

Line: 327

PROCEDURE delete_cagr_entitlement
  (p_validate              IN     BOOLEAN  DEFAULT false
  ,p_effective_date        IN     DATE
  ,p_cagr_entitlement_id   IN     per_cagr_entitlements.cagr_entitlement_id%TYPE
  ,p_object_version_number IN OUT NOCOPY NUMBER
  ) IS
  --
  -- Declare cursors and local variables
  --
  CURSOR csr_entitlement_lines IS
    SELECT cagr_entitlement_line_id,
	       object_version_number
	  FROM per_cagr_entitlement_lines_f pcl
	 WHERE pcl.cagr_entitlement_id = p_cagr_entitlement_id;

Line: 342

  l_proc                     VARCHAR2(72) := g_package||'update_cagr_entitlement';

Line: 356

  SAVEPOINT delete_cagr_entitlement;

Line: 371

    hr_cagr_entitlement_bk3.delete_cagr_entitlement_b
      (p_effective_date        => l_effective_date
      ,p_cagr_entitlement_id   => p_cagr_entitlement_id
      ,p_object_version_number => p_object_version_number
      );

Line: 380

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

Line: 400

	hr_cagr_ent_lines_api.delete_entitlement_line
	 (p_validate                       => FALSE
     ,p_cagr_entitlement_line_id       => c1.cagr_entitlement_line_id
     ,p_effective_start_date           => l_pcl_start_date
     ,p_effective_END_date             => l_pcl_end_date
     ,p_object_version_number          => l_pcl_ovn
     ,p_effective_date                 => p_effective_date
     ,p_datetrack_mode                 => 'ZAP');

Line: 420

    hr_cagr_entitlement_bk3.delete_cagr_entitlement_a
      (p_effective_date        => l_effective_date
      ,p_cagr_entitlement_id   => p_cagr_entitlement_id
      ,p_object_version_number => l_object_version_number
      );

Line: 429

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

Line: 454

    ROLLBACK TO delete_cagr_entitlement;

Line: 465

    ROLLBACK TO delete_cagr_entitlement;

Line: 472

END delete_cagr_entitlement;