DBA Data[Home] [Help]

APPS.PQP_PTY_DEL SQL Statements

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

Line: 53

Procedure dt_delete_dml
  (p_rec                     in out nocopy pqp_pty_shd.g_rec_type
  ,p_effective_date          in date
  ,p_datetrack_mode          in varchar2
  ,p_validation_start_date   in date
  ,p_validation_end_date     in date
  ) is
--
  l_proc        varchar2(72) := g_package||'dt_delete_dml';
Line: 65

  If (p_datetrack_mode = hr_api.g_delete_next_change) then
    --
    --
    -- Delete the where the effective start date is equal
    -- to the validation end date.
    --
    delete from pqp_pension_types_f
    where       pension_type_id = p_rec.pension_type_id
    and   effective_start_date = p_validation_start_date;
Line: 82

    delete from pqp_pension_types_f
    where        pension_type_id = p_rec.pension_type_id
    and   effective_start_date >= p_validation_start_date;
Line: 91

End dt_delete_dml;
Line: 102

PROCEDURE delete_app_ownerships(p_pk_column  IN  varchar2
                               ,p_pk_value   IN  varchar2
                               ,p_datetrack_mode IN varchar2) IS
--
BEGIN
  --
  IF ((hr_startup_data_api_support.return_startup_mode
                           IN ('STARTUP','GENERIC')) AND
      p_datetrack_mode = 'ZAP') THEN
     --
     DELETE FROM hr_application_ownerships
      WHERE key_name = p_pk_column
        AND key_value = p_pk_value;
Line: 117

END delete_app_ownerships;
Line: 122

PROCEDURE delete_app_ownerships(p_pk_column IN varchar2
                               ,p_pk_value  IN number
                               ,p_datetrack_mode IN varchar2) IS
--
BEGIN
  delete_app_ownerships(p_pk_column,
                        to_char(p_pk_value),
                        p_datetrack_mode
                       );
Line: 131

END delete_app_ownerships;
Line: 136

Procedure delete_dml
  (p_rec                     in out nocopy pqp_pty_shd.g_rec_type
  ,p_effective_date          in date
  ,p_datetrack_mode          in varchar2
  ,p_validation_start_date   in date
  ,p_validation_end_date     in date
  ) is
--
  l_proc        varchar2(72) := g_package||'delete_dml';
Line: 149

  pqp_pty_del.dt_delete_dml
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => p_datetrack_mode
    ,p_validation_start_date => p_validation_start_date
    ,p_validation_end_date   => p_validation_end_date
    );
Line: 158

End delete_dml;
Line: 193

Procedure dt_pre_delete
  (p_rec                     in out nocopy pqp_pty_shd.g_rec_type
  ,p_effective_date          in date
  ,p_datetrack_mode          in varchar2
  ,p_validation_start_date   in date
  ,p_validation_end_date     in date
  ) is
--
  l_proc        varchar2(72) := g_package||'dt_pre_delete';
Line: 211

    If (p_datetrack_mode = hr_api.g_delete) then
      p_rec.effective_end_date := p_validation_start_date - 1;
Line: 232

End dt_pre_delete;
Line: 267

Procedure pre_delete
  (p_rec                   in out nocopy pqp_pty_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  l_proc        varchar2(72) := g_package||'pre_delete';
Line: 284

  pqp_pty_del.dt_pre_delete
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => p_datetrack_mode
    ,p_validation_start_date => p_validation_start_date
    ,p_validation_end_date   => p_validation_end_date
    );
Line: 293

End pre_delete;
Line: 327

Procedure post_delete
  (p_rec                   in pqp_pty_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  l_proc        varchar2(72) := g_package||'post_delete';
Line: 342

    delete_app_ownerships
      ('PENSION_TYPE_ID', p_rec.pension_type_id
      ,p_datetrack_mode
      );
Line: 347

    pqp_pty_rkd.after_delete
      (p_effective_date
      => p_effective_date
      ,p_datetrack_mode
      => p_datetrack_mode
      ,p_validation_start_date
      => p_validation_start_date
      ,p_validation_end_date
      => p_validation_end_date
      ,p_pension_type_id
      => p_rec.pension_type_id
      ,p_effective_start_date
      => p_rec.effective_start_date
      ,p_effective_end_date
      => p_rec.effective_end_date
      ,p_effective_start_date_o
      => pqp_pty_shd.g_old_rec.effective_start_date
      ,p_effective_end_date_o
      => pqp_pty_shd.g_old_rec.effective_end_date
      ,p_pension_type_name_o
      => pqp_pty_shd.g_old_rec.pension_type_name
      ,p_pension_category_o
      => pqp_pty_shd.g_old_rec.pension_category
      ,p_pension_provider_type_o
      => pqp_pty_shd.g_old_rec.pension_provider_type
      ,p_salary_calculation_method_o
      => pqp_pty_shd.g_old_rec.salary_calculation_method
      ,p_threshold_conversion_rule_o
      => pqp_pty_shd.g_old_rec.threshold_conversion_rule
      ,p_contribution_conversion_ru_o
      => pqp_pty_shd.g_old_rec.contribution_conversion_rule
      ,p_er_annual_limit_o
      => pqp_pty_shd.g_old_rec.er_annual_limit
      ,p_ee_annual_limit_o
      => pqp_pty_shd.g_old_rec.ee_annual_limit
      ,p_er_annual_salary_threshold_o
      => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
      ,p_ee_annual_salary_threshold_o
      => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
      ,p_object_version_number_o
      => pqp_pty_shd.g_old_rec.object_version_number
      ,p_business_group_id_o
      => pqp_pty_shd.g_old_rec.business_group_id
      ,p_legislation_code_o
      => pqp_pty_shd.g_old_rec.legislation_code
      ,p_description_o
      => pqp_pty_shd.g_old_rec.description
      ,p_minimum_age_o
      => pqp_pty_shd.g_old_rec.minimum_age
      ,p_ee_contribution_percent_o
      => pqp_pty_shd.g_old_rec.ee_contribution_percent
      ,p_maximum_age_o
      => pqp_pty_shd.g_old_rec.maximum_age
      ,p_er_contribution_percent_o
      => pqp_pty_shd.g_old_rec.er_contribution_percent
      ,p_ee_annual_contribution_o
      => pqp_pty_shd.g_old_rec.ee_annual_contribution
      ,p_er_annual_contribution_o
      => pqp_pty_shd.g_old_rec.er_annual_contribution
      ,p_annual_premium_amount_o
      => pqp_pty_shd.g_old_rec.annual_premium_amount
      ,p_ee_contribution_bal_type_i_o
      => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
      ,p_er_contribution_bal_type_i_o
      => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
      ,p_balance_init_element_type__o
      => pqp_pty_shd.g_old_rec.balance_init_element_type_id
     ,p_ee_contribution_fixed_rate_o  => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
     ,p_er_contribution_fixed_rate_o  => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate
      ,p_pty_attribute_category_o
      => pqp_pty_shd.g_old_rec.pty_attribute_category
      ,p_pty_attribute1_o
      => pqp_pty_shd.g_old_rec.pty_attribute1
      ,p_pty_attribute2_o
      => pqp_pty_shd.g_old_rec.pty_attribute2
      ,p_pty_attribute3_o
      => pqp_pty_shd.g_old_rec.pty_attribute3
      ,p_pty_attribute4_o
      => pqp_pty_shd.g_old_rec.pty_attribute4
      ,p_pty_attribute5_o
      => pqp_pty_shd.g_old_rec.pty_attribute5
      ,p_pty_attribute6_o
      => pqp_pty_shd.g_old_rec.pty_attribute6
      ,p_pty_attribute7_o
      => pqp_pty_shd.g_old_rec.pty_attribute7
      ,p_pty_attribute8_o
      => pqp_pty_shd.g_old_rec.pty_attribute8
      ,p_pty_attribute9_o
      => pqp_pty_shd.g_old_rec.pty_attribute9
      ,p_pty_attribute10_o
      => pqp_pty_shd.g_old_rec.pty_attribute10
      ,p_pty_attribute11_o
      => pqp_pty_shd.g_old_rec.pty_attribute11
      ,p_pty_attribute12_o
      => pqp_pty_shd.g_old_rec.pty_attribute12
      ,p_pty_attribute13_o
      => pqp_pty_shd.g_old_rec.pty_attribute13
      ,p_pty_attribute14_o
      => pqp_pty_shd.g_old_rec.pty_attribute14
      ,p_pty_attribute15_o
      => pqp_pty_shd.g_old_rec.pty_attribute15
      ,p_pty_attribute16_o
      => pqp_pty_shd.g_old_rec.pty_attribute16
      ,p_pty_attribute17_o
      => pqp_pty_shd.g_old_rec.pty_attribute17
      ,p_pty_attribute18_o
      => pqp_pty_shd.g_old_rec.pty_attribute18
      ,p_pty_attribute19_o
      => pqp_pty_shd.g_old_rec.pty_attribute19
      ,p_pty_attribute20_o
      => pqp_pty_shd.g_old_rec.pty_attribute20
      ,p_pty_information_category_o
      => pqp_pty_shd.g_old_rec.pty_information_category
      ,p_pty_information1_o
      => pqp_pty_shd.g_old_rec.pty_information1
      ,p_pty_information2_o
      => pqp_pty_shd.g_old_rec.pty_information2
      ,p_pty_information3_o
      => pqp_pty_shd.g_old_rec.pty_information3
      ,p_pty_information4_o
      => pqp_pty_shd.g_old_rec.pty_information4
      ,p_pty_information5_o
      => pqp_pty_shd.g_old_rec.pty_information5
      ,p_pty_information6_o
      => pqp_pty_shd.g_old_rec.pty_information6
      ,p_pty_information7_o
      => pqp_pty_shd.g_old_rec.pty_information7
      ,p_pty_information8_o
      => pqp_pty_shd.g_old_rec.pty_information8
      ,p_pty_information9_o
      => pqp_pty_shd.g_old_rec.pty_information9
      ,p_pty_information10_o
      => pqp_pty_shd.g_old_rec.pty_information10
      ,p_pty_information11_o
      => pqp_pty_shd.g_old_rec.pty_information11
      ,p_pty_information12_o
      => pqp_pty_shd.g_old_rec.pty_information12
      ,p_pty_information13_o
      => pqp_pty_shd.g_old_rec.pty_information13
      ,p_pty_information14_o
      => pqp_pty_shd.g_old_rec.pty_information14
      ,p_pty_information15_o
      => pqp_pty_shd.g_old_rec.pty_information15
      ,p_pty_information16_o
      => pqp_pty_shd.g_old_rec.pty_information16
      ,p_pty_information17_o
      => pqp_pty_shd.g_old_rec.pty_information17
      ,p_pty_information18_o
      => pqp_pty_shd.g_old_rec.pty_information18
      ,p_pty_information19_o
      => pqp_pty_shd.g_old_rec.pty_information19
      ,p_pty_information20_o
      => pqp_pty_shd.g_old_rec.pty_information20
      ,p_special_pension_type_code_o
      => pqp_pty_shd.g_old_rec.special_pension_type_code
      ,p_pension_sub_category_o
      => pqp_pty_shd.g_old_rec.pension_sub_category
      ,p_pension_basis_calc_method_o
      => pqp_pty_shd.g_old_rec.pension_basis_calc_method
      ,p_pension_salary_balance_o
      => pqp_pty_shd.g_old_rec.pension_salary_balance
      ,p_recurring_bonus_percent_o
      => pqp_pty_shd.g_old_rec.recurring_bonus_percent
      ,p_non_recur_bonus_percent_o
      => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
      ,p_recurring_bonus_balance_o
      => pqp_pty_shd.g_old_rec.recurring_bonus_balance
      ,p_non_recur_bonus_balance_o
      => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
      ,p_std_tax_reduction_o
      => pqp_pty_shd.g_old_rec.std_tax_reduction
      ,p_spl_tax_reduction_o
      => pqp_pty_shd.g_old_rec.spl_tax_reduction
      ,p_sig_sal_spl_tax_reduction_o
      => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
      ,p_sig_sal_non_tax_reduction_o
      => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
      ,p_sig_sal_std_tax_reduction_o
      => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
      ,p_sii_std_tax_reduction_o
      => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
      ,p_sii_spl_tax_reduction_o
      => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
      ,p_sii_non_tax_reduction_o
      => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
      ,p_prev_year_bonus_include_o
      => pqp_pty_shd.g_old_rec.previous_year_bonus_included
      ,p_recurring_bonus_period_o
      => pqp_pty_shd.g_old_rec.recurring_bonus_period
      ,p_non_recurring_bonus_period_o
      => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
      ,p_ee_age_threshold_o
      => pqp_pty_shd.g_old_rec.ee_age_threshold
      ,p_er_age_threshold_o
      => pqp_pty_shd.g_old_rec.er_age_threshold
      ,p_ee_age_contribution_o
      => pqp_pty_shd.g_old_rec.ee_age_contribution
      ,p_er_age_contribution_o
      => pqp_pty_shd.g_old_rec.er_age_contribution
      );
Line: 559

End post_delete;
Line: 594

  pqp_pty_bus.delete_validate
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date              => l_validation_end_date
    );
Line: 607

  pqp_pty_del.pre_delete
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date              => l_validation_end_date
    );
Line: 617

  pqp_pty_del.delete_dml
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date              => l_validation_end_date
    );
Line: 626

  pqp_pty_del.post_delete
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date              => l_validation_end_date
    );
Line: 656

    select
    business_group_id,
    pension_type_id
    from pqp_pension_types_f
    where
    pension_type_id =  c_pension_type_id;