APPS.PQH_CRITERIA_RATE_DEFN_API SQL Statements

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

Line: 333

procedure update_criteria_rate_defn
  (p_validate                      in     boolean      default false
  ,p_effective_date                in     date
  ,p_business_group_id             in     number
  ,p_criteria_rate_defn_id         in     number
  ,p_short_name		           in     varchar2     default hr_api.g_varchar2
  ,p_name                          in     varchar2
  ,p_language_code                 in     varchar2     default hr_api.userenv_lang
  ,p_uom                           in     varchar2
  ,p_currency_code		   in     varchar2     default hr_api.g_varchar2
  ,p_reference_period_cd           in     varchar2     default hr_api.g_varchar2
  ,p_define_max_rate_flag          in	  varchar2     default hr_api.g_varchar2
  ,p_define_min_rate_flag          in	  varchar2     default hr_api.g_varchar2
  ,p_define_mid_rate_flag          in	  varchar2     default hr_api.g_varchar2
  ,p_define_std_rate_flag          in	  varchar2     default hr_api.g_varchar2
  ,p_rate_calc_cd		   in     varchar2
  ,p_rate_calc_rule		   in     number       default hr_api.g_number
  ,p_preferential_rate_cd          in	  varchar2
  ,p_preferential_rate_rule        in 	  number       default hr_api.g_number
  ,p_rounding_cd                   in     varchar2
  ,p_rounding_rule		   in     number       default hr_api.g_number
  ,p_legislation_code 	           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_attribute21                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2     default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2     default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 394

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

Line: 400

  savepoint update_criteria_rate_defn;

Line: 416

  pqh_criteria_rate_defn_bk2.update_criteria_rate_defn_b
  (p_effective_date                => l_effective_date
  ,p_business_group_id             => p_business_group_id
  ,p_criteria_rate_defn_id         => p_criteria_rate_defn_id
  ,p_short_name		           => p_short_name
  ,p_uom                           => p_uom
  ,p_currency_code		   => p_currency_code
  ,p_reference_period_cd           => p_reference_period_cd
  ,p_define_max_rate_flag          => p_define_max_rate_flag
  ,p_define_min_rate_flag          => p_define_min_rate_flag
  ,p_define_mid_rate_flag          => p_define_mid_rate_flag
  ,p_define_std_rate_flag          => p_define_std_rate_flag
  ,p_rate_calc_cd		   => p_rate_calc_cd
  ,p_rate_calc_rule		   => p_rate_calc_rule
  ,p_preferential_rate_cd          => p_preferential_rate_cd
  ,p_preferential_rate_rule        => p_preferential_rate_rule
  ,p_rounding_cd                   => p_rounding_cd
  ,p_rounding_rule		   => p_rounding_rule
  ,p_legislation_code 	           => p_legislation_code
  ,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_attribute21                   => p_attribute21
  ,p_attribute22                   => p_attribute22
  ,p_attribute23                   => p_attribute23
  ,p_attribute24                   => p_attribute24
  ,p_attribute25                   => p_attribute25
  ,p_attribute26                   => p_attribute26
  ,p_attribute27                   => p_attribute27
  ,p_attribute28                   => p_attribute28
  ,p_attribute29                   => p_attribute29
  ,p_attribute30                   => p_attribute30
  ,p_object_version_number         => p_object_version_number
  );

Line: 548

  pqh_criteria_rate_defn_bk2.update_criteria_rate_defn_a
  (p_effective_date                => l_effective_date
  ,p_business_group_id             => p_business_group_id
  ,p_criteria_rate_defn_id         => p_criteria_rate_defn_id
  ,p_short_name		           => p_short_name
  ,p_uom                           => p_uom
  ,p_currency_code		   => p_currency_code
  ,p_reference_period_cd           => p_reference_period_cd
  ,p_define_max_rate_flag          => p_define_max_rate_flag
  ,p_define_min_rate_flag          => p_define_min_rate_flag
  ,p_define_mid_rate_flag          => p_define_mid_rate_flag
  ,p_define_std_rate_flag          => p_define_std_rate_flag
  ,p_rate_calc_cd		   => p_rate_calc_cd
  ,p_rate_calc_rule		   => p_rate_calc_rule
  ,p_preferential_rate_cd          => p_preferential_rate_cd
  ,p_preferential_rate_rule        => p_preferential_rate_rule
  ,p_rounding_cd                   => p_rounding_cd
  ,p_rounding_rule		   => p_rounding_rule
  ,p_legislation_code 	           => p_legislation_code
  ,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_attribute21                   => p_attribute21
  ,p_attribute22                   => p_attribute22
  ,p_attribute23                   => p_attribute23
  ,p_attribute24                   => p_attribute24
  ,p_attribute25                   => p_attribute25
  ,p_attribute26                   => p_attribute26
  ,p_attribute27                   => p_attribute27
  ,p_attribute28                   => p_attribute28
  ,p_attribute29                   => p_attribute29
  ,p_attribute30                   => p_attribute30
  ,p_object_version_number         => l_object_version_number );

Line: 624

    rollback to update_criteria_rate_defn;

Line: 637

    rollback to update_criteria_rate_defn;

Line: 646

end update_criteria_rate_defn;

Line: 653

procedure delete_criteria_rate_defn
  (p_validate                      in     boolean           default false
  ,p_effective_date                in     date
  ,p_criteria_rate_defn_id         in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 666

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

Line: 672

  savepoint delete_criteria_rate_defn;

Line: 688

  pqh_criteria_rate_defn_bk3.delete_criteria_rate_defn_b
  (p_effective_date                => l_effective_date
  ,p_criteria_rate_defn_id         => p_criteria_rate_defn_id
  ,p_object_version_number         => l_object_version_number
  );

Line: 721

  pqh_criteria_rate_defn_bk3.delete_criteria_rate_defn_a
  (p_effective_date                => l_effective_date
  ,p_criteria_rate_defn_id         => p_criteria_rate_defn_id
  ,p_object_version_number         => l_object_version_number );

Line: 749

    rollback to delete_criteria_rate_defn;

Line: 760

    rollback to delete_criteria_rate_defn;

Line: 767

end delete_criteria_rate_defn;