APPS.PAY_ELEMENT_TEMPLATE_GEN SQL Statements

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

Line: 106

  select formula_type_id
  from   ff_formula_types
  where formula_type_name = p_formula_type
  ;

Line: 150

select classification_id
,      non_payments_flag
from   pay_element_classifications
where  upper(classification_name) = p_classification
and
(
  (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 196

select benefit_classification_id
from   ben_benefit_classifications
where  upper(benefit_classification_name) = p_ben_classification
and
(
  (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 242

  select formula_id
  from ff_formulas_f
  where formula_type_id = p_formula_type_id
  and   upper(formula_name) = p_formula
  and (p_effective_date between
       effective_start_date and nvl(effective_end_date, hr_api.g_eot))
  and
  (
    (business_group_id is null and legislation_code is null)
    or (legislation_code is null and business_group_id = p_business_group_id)
    or (business_group_id is null and legislation_code = p_legislation_code)
  );

Line: 289

select balance_type_id
from pay_balance_types
where upper(balance_name) = p_balance
and
(
  (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 332

select element_type_id
from  pay_element_types_f
where upper(element_name) = p_element_name
and   p_effective_date between
      effective_start_date and nvl(effective_end_date, hr_api.g_eot)
and
(
  (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 379

select event_group_id
from pay_event_groups
where event_group_type = p_event_group_type
and   upper(event_group_name) = p_event_group
and
(
  (business_group_id is null and legislation_code is null) or
  (legislation_code is null and business_group_id = p_business_group_id) or
  (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 423

select balance_dimension_id
from   pay_balance_dimensions
where  upper(dimension_name) = p_bal_dimension
and
(
 (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 467

select run_type_id
from  pay_run_types_f
where upper(run_type_name) = p_run_type
and   p_effective_date between
      effective_start_date and nvl(effective_end_date, hr_api.g_eot)
and
(
  (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 514

select balance_category_id
from   pay_balance_categories_f
where  upper(category_name) = p_bal_category
and    p_effective_date between
       effective_start_date and effective_end_date
and
(
  (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 559

select attribute_id
from pay_bal_attribute_definitions
where upper(attribute_name) = p_attribute
and
(
  (business_group_id is null and legislation_code is null)
  or (legislation_code is null and business_group_id = p_business_group_id)
  or (business_group_id is null and legislation_code = p_legislation_code)
);

Line: 607

  p_sf_core_objects.delete;

Line: 608

  p_sbt_core_objects.delete;

Line: 609

  p_sdb_core_objects.delete;

Line: 610

  p_set_core_objects.delete;

Line: 611

  p_ssr_core_objects.delete;

Line: 612

  p_sbc_core_objects.delete;

Line: 613

  p_siv_core_objects.delete;

Line: 614

  p_sbf_core_objects.delete;

Line: 615

  p_spr_core_objects.delete;

Line: 616

  p_sfr_core_objects.delete;

Line: 617

  p_sir_core_objects.delete;

Line: 618

  p_seu_core_objects.delete;

Line: 619

  p_sgb_core_objects.delete;

Line: 620

  p_sba_core_objects.delete;

Line: 734

  select count(0)
  from   ff_formulas_f
  where  formula_id = p_core_object_id;

Line: 739

  select count(0)
  from   pay_element_types_f
  where  element_type_id = p_core_object_id;

Line: 744

  select count(0)
  from   pay_balance_types
  where  balance_type_id = p_core_object_id;

Line: 749

  select count(0)
  from   pay_defined_balances
  where  defined_balance_id = p_core_object_id;

Line: 754

  select count(0)
  from   pay_sub_classification_rules_f
  where  sub_classification_rule_id = p_core_object_id;

Line: 759

  select count(0)
  from   pay_balance_classifications
  where  balance_classification_id = p_core_object_id;

Line: 764

  select count(0)
  from   pay_input_values_f
  where  input_value_id = p_core_object_id;

Line: 769

  select count(0)
  from   pay_balance_feeds_f
  where  balance_feed_id = p_core_object_id;

Line: 774

  select count(0)
  from   pay_formula_result_rules_f
  where  formula_result_rule_id = p_core_object_id;

Line: 779

  select count(0)
  from   pay_status_processing_rules_f
  where  status_processing_rule_id = p_core_object_id;

Line: 784

  select count(0)
  from   pay_iterative_rules_f
  where  iterative_rule_id = p_core_object_id;

Line: 789

  select count(0)
  from   pay_element_type_usages_f
  where  element_type_usage_id = p_core_object_id;

Line: 794

  select count(0)
  from   pay_grossup_bal_exclusions
  where  grossup_balances_id = p_core_object_id;

Line: 799

  select count(0)
  from   pay_balance_attributes
  where  balance_attribute_id = p_core_object_id;

Line: 972

procedure update_core_objects
  (p_effective_date       in     date
  ,p_template_id          in     number
  ,p_core_object_type     in     varchar2
  ,p_shadow_object_id     in     number
  ,p_core_object_id       in     number
  ,p_core_objects         in out nocopy pay_element_template_util.t_core_objects
  ) is
  l_proc                varchar2(72) := g_package||'update_core_objects';

Line: 1002

end update_core_objects;

Line: 1034

  l_last_update_date    date;

Line: 1069

      l_last_update_date := hr_api.g_sys;

Line: 1084

      ff_formulas_f_pkg.insert_row
      (x_rowid                      => l_rowid
      ,x_formula_id                 => l_formula_id
      ,x_effective_start_date       => p_effective_date
      ,x_effective_end_date         => hr_api.g_eot
      ,x_business_group_id          => p_formulas(i).business_group_id
      ,x_legislation_code           => null
      ,x_formula_type_id            => l_formula_type_id
      ,x_formula_name               => l_formula_name
      ,x_description                => p_formulas(i).description
      ,x_formula_text               => p_formulas(i).formula_text
      ,x_sticky_flag                => 'N'
      ,x_last_update_date           => l_last_update_date
      );

Line: 1102

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_sf_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_formula_id
      ,p_core_objects               => p_sf_core_objects
      );

Line: 1222

    pay_balance_types_pkg.insert_row
    (x_rowid                        => l_rowid
    ,x_balance_type_id              => l_balance_type_id
    ,x_business_group_id            => p_business_group_id
    ,x_legislation_code             => null
    ,x_currency_code                => p_balance_types(l_id).currency_code
    ,x_assignment_remuneration_flag =>
     p_balance_types(l_id).assignment_remuneration_flag
    ,x_balance_name                 => p_balance_types(l_id).balance_name
    ,x_base_balance_name            => p_balance_types(l_id).balance_name
    ,x_balance_uom                  => p_balance_types(l_id).balance_uom
    ,x_comments                     => p_balance_types(l_id).comments
    ,x_legislation_subgroup         => null
    ,x_reporting_name               => p_balance_types(l_id).reporting_name
    ,x_attribute_category           => p_balance_types(l_id).attribute_category
    ,x_attribute1                   => p_balance_types(l_id).attribute1
    ,x_attribute2                   => p_balance_types(l_id).attribute2
    ,x_attribute3                   => p_balance_types(l_id).attribute3
    ,x_attribute4                   => p_balance_types(l_id).attribute4
    ,x_attribute5                   => p_balance_types(l_id).attribute5
    ,x_attribute6                   => p_balance_types(l_id).attribute6
    ,x_attribute7                   => p_balance_types(l_id).attribute7
    ,x_attribute8                   => p_balance_types(l_id).attribute8
    ,x_attribute9                   => p_balance_types(l_id).attribute9
    ,x_attribute10                  => p_balance_types(l_id).attribute10
    ,x_attribute11                  => p_balance_types(l_id).attribute11
    ,x_attribute12                  => p_balance_types(l_id).attribute12
    ,x_attribute13                  => p_balance_types(l_id).attribute13
    ,x_attribute14                  => p_balance_types(l_id).attribute14
    ,x_attribute15                  => p_balance_types(l_id).attribute15
    ,x_attribute16                  => p_balance_types(l_id).attribute16
    ,x_attribute17                  => p_balance_types(l_id).attribute17
    ,x_attribute18                  => p_balance_types(l_id).attribute18
    ,x_attribute19                  => p_balance_types(l_id).attribute19
    ,x_attribute20                  => p_balance_types(l_id).attribute20
    ,x_balance_category_id          => l_balance_category_id
    ,x_base_balance_type_id         => l_base_balance_type_id
    ,x_input_value_id               => l_input_value_id
    );

Line: 1265

    update_core_objects
    (p_effective_date             => p_effective_date
    ,p_template_id                => p_template_id
    ,p_core_object_type           => g_sbt_lookup_type
    ,p_shadow_object_id           => p_balance_type_id
    ,p_core_object_id             => l_balance_type_id
    ,p_core_objects               => p_sbt_core_objects
    );

Line: 1376

      pay_defined_balances_pkg.insert_row
      (x_rowid                        => l_rowid
      ,x_defined_balance_id           => l_defined_balance_id
      ,x_business_group_id            => p_business_group_id
      ,x_legislation_code             => null
      ,x_balance_type_id              => l_balance_type_id
      ,x_balance_dimension_id         => l_balance_dimension_id
      ,x_force_latest_balance_flag    =>
             p_defined_balances(i).force_latest_balance_flag
      ,x_legislation_subgroup         => null
      ,x_grossup_allowed_flag         =>
             nvl(p_defined_balances(i).grossup_allowed_flag, 'N')
      );

Line: 1393

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_sdb_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_defined_balance_id
      ,p_core_objects               => p_sdb_core_objects
      );

Line: 1580

      pay_element_types_pkg.insert_row
      (p_rowid                        => l_rowid
      ,p_element_type_id              => l_element_type_id
      ,p_effective_start_date         => p_effective_date
      ,p_effective_end_date           => hr_api.g_eot
      ,p_business_group_id            => p_business_group_id
      ,p_legislation_code             => null
      ,p_formula_id                   => l_formula_id
      ,p_input_currency_code          => p_element_types(i).input_currency_code
      ,p_output_currency_code         => p_element_types(i).output_currency_code
      ,p_classification_id            => l_ele_classification_id
      ,p_benefit_classification_id    => l_ben_classification_id
      ,p_additional_entry_allowed     =>
       p_element_types(i).additional_entry_allowed_flag
      ,p_adjustment_only_flag         => p_element_types(i).adjustment_only_flag
      ,p_closed_for_entry_flag        =>
       p_element_types(i).closed_for_entry_flag
      ,p_element_name                 => p_element_types(i).element_name
      ,p_base_element_name            => p_element_types(i).element_name
      ,p_indirect_only_flag           => p_element_types(i).indirect_only_flag
      ,p_multiple_entries_allowed     =>
       p_element_types(i).multiple_entries_allowed_flag
      ,p_multiply_value_flag          => p_element_types(i).multiply_value_flag
      ,p_post_termination_rule        =>
       p_element_types(i).post_termination_rule
      ,p_process_in_run_flag          => p_element_types(i).process_in_run_flag
      ,p_processing_priority          => l_processing_priority
      ,p_processing_type              => p_element_types(i).processing_type
      ,p_standard_link_flag           => p_element_types(i).standard_link_flag
      ,p_comment_id                   => null
      ,p_description                  => p_element_types(i).description
      ,p_legislation_subgroup         => null
      ,p_qualifying_age               => p_element_types(i).qualifying_age
      ,p_qualifying_length_of_service =>
       p_element_types(i).qualifying_length_of_service
      ,p_qualifying_units             => p_element_types(i).qualifying_units
      ,p_reporting_name               => p_element_types(i).reporting_name
      ,p_attribute_category           => p_element_types(i).attribute_category
      ,p_attribute1                   => p_element_types(i).attribute1
      ,p_attribute2                   => p_element_types(i).attribute2
      ,p_attribute3                   => p_element_types(i).attribute3
      ,p_attribute4                   => p_element_types(i).attribute4
      ,p_attribute5                   => p_element_types(i).attribute5
      ,p_attribute6                   => p_element_types(i).attribute6
      ,p_attribute7                   => p_element_types(i).attribute7
      ,p_attribute8                   => p_element_types(i).attribute8
      ,p_attribute9                   => p_element_types(i).attribute9
      ,p_attribute10                  => p_element_types(i).attribute10
      ,p_attribute11                  => p_element_types(i).attribute11
      ,p_attribute12                  => p_element_types(i).attribute12
      ,p_attribute13                  => p_element_types(i).attribute13
      ,p_attribute14                  => p_element_types(i).attribute14
      ,p_attribute15                  => p_element_types(i).attribute15
      ,p_attribute16                  => p_element_types(i).attribute16
      ,p_attribute17                  => p_element_types(i).attribute17
      ,p_attribute18                  => p_element_types(i).attribute18
      ,p_attribute19                  => p_element_types(i).attribute19
      ,p_attribute20                  => p_element_types(i).attribute20
      ,p_element_information_category =>
       p_element_types(i).element_information_category
      ,p_element_information1        => p_element_types(i).element_information1
      ,p_element_information2        => p_element_types(i).element_information2
      ,p_element_information3        => p_element_types(i).element_information3
      ,p_element_information4        => p_element_types(i).element_information4
      ,p_element_information5        => p_element_types(i).element_information5
      ,p_element_information6        => p_element_types(i).element_information6
      ,p_element_information7        => p_element_types(i).element_information7
      ,p_element_information8        => p_element_types(i).element_information8
      ,p_element_information9        => p_element_types(i).element_information9
      ,p_element_information10       => p_element_types(i).element_information10
      ,p_element_information11       => p_element_types(i).element_information11
      ,p_element_information12       => p_element_types(i).element_information12
      ,p_element_information13       => p_element_types(i).element_information13
      ,p_element_information14       => p_element_types(i).element_information14
      ,p_element_information15       => p_element_types(i).element_information15
      ,p_element_information16       => p_element_types(i).element_information16
      ,p_element_information17       => p_element_types(i).element_information17
      ,p_element_information18       => p_element_types(i).element_information18
      ,p_element_information19       => p_element_types(i).element_information19
      ,p_element_information20       => p_element_types(i).element_information20
      ,p_non_payments_flag           => l_non_payments_flag
      --
      -- Don't generate the additional input values for benefits. They should
      -- be defined in the template.
      --
      ,p_default_benefit_uom         => null
      ,p_contributions_used          => 'N'
      ,p_third_party_pay_only_flag   =>
       p_element_types(i).third_party_pay_only_flag
      ,p_retro_summ_ele_id           => null
      ,p_iterative_flag              => p_element_types(i).iterative_flag
      ,p_iterative_formula_id        => l_iterative_formula_id
      ,p_iterative_priority          => p_element_types(i).iterative_priority
      ,p_process_mode                => p_element_types(i).process_mode
      ,p_grossup_flag                => p_element_types(i).grossup_flag
      ,p_advance_indicator           => p_element_types(i).advance_indicator
      ,p_advance_payable             => p_element_types(i).advance_payable
      ,p_advance_deduction           => p_element_types(i).advance_deduction
      ,p_process_advance_entry       => p_element_types(i).process_advance_entry
      ,p_proration_group_id          => l_proration_group_id
      ,p_proration_formula_id        => l_proration_formula_id
      ,p_recalc_event_group_id       => l_recalc_event_group_id
      ,p_once_each_period_flag       => p_element_types(i).once_each_period_flag
      );

Line: 1688

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_set_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_element_type_id
      ,p_core_objects               => p_set_core_objects
      );

Line: 1717

      pay_status_rules_pkg.insert_row
      (x_rowid                      => l_rowid
      ,x_status_processing_rule_id  => l_status_processing_rule_id
      ,x_effective_start_date       => p_effective_date
      ,x_effective_end_date         => hr_api.g_eot
      ,x_business_group_id          => p_business_group_id
      ,x_legislation_code           => null
      ,x_element_type_id            => l_element_type_id
      ,x_assignment_status_type_id  => null
      ,x_formula_id                 => l_formula_id
      ,x_processing_rule            => 'P'
      ,x_comment_id                 => null
      ,x_legislation_subgroup       => null
      ,x_last_update_date           => hr_api.g_sys
      ,x_last_updated_by            => -1
      ,x_last_update_login          => -1
      ,x_created_by                 => -1
      ,x_creation_date              => hr_api.g_sys
      );

Line: 1740

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_spr_lookup_type
      ,p_shadow_object_id           => i
      ,p_core_object_id             => l_status_processing_rule_id
      ,p_core_objects               => p_spr_core_objects
      );

Line: 1786

select sub_classification_rule_id
from   pay_sub_classification_rules_f
where  element_type_id = p_element_type_id
and    classification_id = p_classification_id;

Line: 1829

        update_core_objects
        (p_effective_date             => p_effective_date
        ,p_template_id                => p_template_id
        ,p_core_object_type           => g_ssr_lookup_type
        ,p_shadow_object_id           => l_shadow_object_id
        ,p_core_object_id             => l_sub_classification_rule_id
        ,p_core_objects               => p_ssr_core_objects
        );

Line: 1914

      pay_sub_class_rules_pkg.insert_row
      (p_rowid                        => l_rowid
      ,p_sub_classification_rule_id   => l_sub_classification_rule_id
      ,p_effective_start_date         => p_effective_date
      ,p_effective_end_date           => hr_api.g_eot
      ,p_element_type_id              => l_element_type_id
      ,p_classification_id            => l_ele_classification_id
      ,p_business_group_id            => p_business_group_id
      ,p_legislation_code             => null
      ,p_last_update_date             => hr_api.g_sys
      ,p_last_updated_by              => -1
      ,p_last_update_login            => -1
      ,p_created_by                   => -1
      ,p_creation_date                => hr_api.g_sys
      );

Line: 1933

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_ssr_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_sub_classification_rule_id
      ,p_core_objects               => p_ssr_core_objects
      );

Line: 2009

      pay_bal_classifications_pkg.insert_row
      (x_rowid                        => l_rowid
      ,x_balance_classification_id    => l_balance_classification_id
      ,x_business_group_id            => p_business_group_id
      ,x_legislation_code             => null
      ,x_balance_type_id              => l_balance_type_id
      ,x_classification_id            => l_ele_classification_id
      ,x_scale                        => p_balance_classis(i).scale
      ,x_legislation_subgroup         => null
      );

Line: 2023

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_sbc_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_balance_classification_id
      ,p_core_objects               => p_sbc_core_objects
      );

Line: 2066

  select rowid
  ,      input_value_id
  ,      effective_start_date
  ,      effective_end_date
  ,      element_type_id
  ,      lookup_type
  ,      business_group_id
  ,      display_sequence
  ,      generate_db_items_flag
  ,      hot_default_flag
  ,      mandatory_flag
  ,      name
  ,      uom
  ,      default_value
  ,      max_value
  ,      min_value
  ,      warning_or_error
  from   pay_input_values_f
  where  element_type_id = p_element_type_id
  and    name = 'Pay Value';

Line: 2119

        update_core_objects
        (p_effective_date             => p_effective_date
        ,p_template_id                => p_template_id
        ,p_core_object_type           => g_siv_lookup_type
        ,p_shadow_object_id           => p_input_values(i).input_value_id
        ,p_core_object_id             => l_input_value.input_value_id
        ,p_core_objects               => p_siv_core_objects
        );

Line: 2134

          pay_input_values_pkg.update_row
          (p_rowid                  => l_input_value.rowid
          ,p_input_value_id         => l_input_value.input_value_id
          ,p_effective_start_date   => l_input_value.effective_start_date
          ,p_effective_end_date     => l_input_value.effective_end_date
          ,p_element_type_id        => l_input_value.element_type_id
          ,p_lookup_type            => l_input_value.lookup_type
          ,p_business_group_id      => l_input_value.business_group_id
          ,p_legislation_code       => null
          ,p_formula_id             => null
          ,p_display_sequence       => l_input_value.display_sequence
          ,p_generate_db_items_flag => l_input_value.generate_db_items_flag
          ,p_hot_default_flag       => l_input_value.hot_default_flag
          ,p_mandatory_flag         => p_input_values(i).mandatory_flag
          ,p_name                   => l_input_value.name
          ,p_uom                    => l_input_value.uom
          ,p_default_value          => l_input_value.default_value
          ,p_legislation_subgroup   => null
          ,p_max_value              => l_input_value.max_value
          ,p_min_value              => l_input_value.min_value
          ,p_warning_or_error       => l_input_value.warning_or_error
          ,p_recreate_db_items      => 'Y'
          ,p_base_name              => l_input_value.name
          );

Line: 2260

      pay_input_values_pkg.insert_row
      (p_rowid                        => l_rowid
      ,p_input_value_id               => l_input_value_id
      ,p_effective_start_date         => p_effective_date
      ,p_effective_end_date           => hr_api.g_eot
      ,p_element_type_id              => l_element_type_id
      ,p_lookup_type                  => p_input_values(i).lookup_type
      ,p_business_group_id            => p_business_group_id
      ,p_legislation_code             => null
      ,p_formula_id                   => l_formula_id
      ,p_display_sequence             => p_input_values(i).display_sequence
      ,p_generate_db_items_flag       => p_input_values(i).generate_db_items_flag
      ,p_hot_default_flag             => p_input_values(i).hot_default_flag
      ,p_mandatory_flag               => p_input_values(i).mandatory_flag
      ,p_name                         => p_input_values(i).name
      ,p_base_name                    => p_input_values(i).name
      ,p_uom                          => p_input_values(i).uom
      ,p_default_value                => l_default_value
      ,p_legislation_subgroup         => null
      ,p_min_value                    => l_min_value
      ,p_max_value                    => l_max_value
      ,p_warning_or_error             => p_input_values(i).warning_or_error
      );

Line: 2287

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_siv_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_input_value_id
      ,p_core_objects               => p_siv_core_objects
      );

Line: 2383

        pay_balance_feeds_f_pkg.insert_row
        (x_rowid                        => l_rowid
        ,x_balance_feed_id              => l_balance_feed_id
        ,x_effective_start_date         => p_effective_date
        ,x_effective_end_date           => hr_api.g_eot
        ,x_business_group_id            => p_business_group_id
        ,x_legislation_code             => null
        ,x_balance_type_id              => l_balance_type_id
        ,x_input_value_id               => l_input_value_id
        ,x_scale                        => p_balance_feeds(i).scale
        ,x_legislation_subgroup         => null
        );

Line: 2414

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_sbf_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_balance_feed_id
      ,p_core_objects               => p_sbf_core_objects
      );

Line: 2545

      pay_formula_result_rules_pkg.insert_row
      (p_rowid                        => l_rowid
      ,p_formula_result_rule_id       => l_formula_result_rule_id
      ,p_effective_start_date         => p_effective_date
      ,p_effective_end_date           => hr_api.g_eot
      ,p_business_group_id            => p_business_group_id
      ,p_legislation_code             => null
      ,p_element_type_id              => l_element_type_id
      ,p_status_processing_rule_id    => l_status_processing_rule_id
      ,p_result_name                  => upper(p_formula_rules(i).result_name)
      ,p_result_rule_type             => p_formula_rules(i).result_rule_type
      ,p_legislation_subgroup         => null
      ,p_severity_level               => p_formula_rules(i).severity_level
      ,p_input_value_id               => l_input_value_id
      ,p_created_by                   => -1
      ,p_session_date                 => hr_api.g_sys
      );

Line: 2566

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_sfr_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_formula_result_rule_id
      ,p_core_objects               => p_sfr_core_objects
      );

Line: 2689

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_sir_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_iterative_rule_id
      ,p_core_objects               => p_sir_core_objects
      );

Line: 2785

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_seu_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_element_type_usage_id
      ,p_core_objects               => p_seu_core_objects
      );

Line: 2911

      update_core_objects
      (p_effective_date             => p_effective_date
      ,p_template_id                => p_template_id
      ,p_core_object_type           => g_sgb_lookup_type
      ,p_shadow_object_id           => l_shadow_object_id
      ,p_core_object_id             => l_grossup_balances_id
      ,p_core_objects               => p_sgb_core_objects
      );

Line: 2991

      update_core_objects
      (p_effective_date   => p_effective_date
      ,p_template_id      => p_template_id
      ,p_core_object_type => g_sba_lookup_type
      ,p_shadow_object_id => l_shadow_object_id
      ,p_core_object_id   => l_balance_attribute_id
      ,p_core_objects     => p_sba_core_objects
      );

Line: 3469

  select formula_id
  ,      rowid
  ,      effective_start_date
  from   ff_formulas_f
  where  formula_id = p_formula_id
  for    update of formula_id;

Line: 3477

  select balance_type_id
  ,      rowid
  ,      null
  from   pay_balance_types
  where  balance_type_id = p_balance_type_id
  for    update of balance_type_id;

Line: 3485

  select defined_balance_id
  ,      rowid
  ,      null
  from   pay_defined_balances
  where  defined_balance_id = p_defined_balance_id
  for    update of defined_balance_id;

Line: 3493

  select element_type_id
  ,      rowid
  ,      effective_start_date
  from   pay_element_types_f
  where  element_type_id = p_element_type_id
  for    update of element_type_id;

Line: 3501

  select balance_feed_id
  ,      rowid
  ,      effective_start_date
  from   pay_balance_feeds_f
  where  balance_feed_id = p_balance_feed_id
  for    update of balance_feed_id;

Line: 3509

  select sub_classification_rule_id
  ,      rowid
  ,      effective_start_date
  from   pay_sub_classification_rules_f
  where  sub_classification_rule_id = p_sub_classification_rule_id
  for    update of sub_classification_rule_id;

Line: 3517

  select balance_classification_id
  ,      rowid
  ,      null
  from   pay_balance_classifications
  where  balance_classification_id = p_balance_classification_id
  for    update of balance_classification_id;

Line: 3525

  select input_value_id
  ,      rowid
  ,      effective_start_date
  from   pay_input_values_f
  where  input_value_id = p_input_value_id
  for    update of input_value_id;

Line: 3533

  select status_processing_rule_id
  ,      rowid
  ,      effective_start_date
  from   pay_status_processing_rules_f
  where  status_processing_rule_id = p_status_processing_rule_id
  for    update of status_processing_rule_id;

Line: 3541

  select formula_result_rule_id
  ,      rowid
  ,      effective_start_date
  from   pay_formula_result_rules_f
  where  formula_result_rule_id = p_formula_result_rule_id
  for    update of formula_result_rule_id;

Line: 3549

  select iterative_rule_id
  ,      object_version_number
  ,      effective_start_date
  from   pay_iterative_rules_f
  where  iterative_rule_id = p_iterative_rule_id
  for    update of iterative_rule_id;

Line: 3557

  select element_type_usage_id
  ,      object_version_number
  ,      effective_start_date
  from   pay_element_type_usages_f
  where  element_type_usage_id = p_element_type_usage_id
  for    update of element_type_usage_id;

Line: 3565

  select grossup_balances_id
  ,      object_version_number
  ,      null
  from   pay_grossup_bal_exclusions
  where  grossup_balances_id = p_grossup_balances_id
  for    update of grossup_balances_id;

Line: 3573

  select balance_attribute_id
  ,      to_number(null)
  ,      null
  from   pay_balance_attributes
  where  balance_attribute_id = p_balance_attribute_id
  for    update of balance_attribute_id;

Line: 3968

select pbt.balance_type_id
,      pbt.balance_name
from   pay_balance_types pbt
where  pbt.base_balance_type_id = p_balance_type_id;

Line: 3985

    p_remaining_recs.delete(p_balance_type_id);

Line: 4004

        select pbt.balance_name
        into   l_balance_name
        from   pay_balance_types pbt
        where  pbt.balance_type_id = p_balance_type_id
        ;

Line: 4018

    pay_balance_types_pkg.delete_row
    (x_rowid           => p_rowid_id_recs(p_balance_type_id).rowid
    ,x_balance_type_id => p_balance_type_id
    );

Line: 4065

      pay_defined_balances_pkg.delete_row
      (x_rowid                        => p_rowid_id_recs(i).rowid
      ,x_defined_balance_id           => p_rowid_id_recs(i).id
      );

Line: 4090

      pay_element_types_pkg.delete_row
      (p_rowid                        => p_rowid_id_recs(i).rowid
      ,p_element_type_id              => p_rowid_id_recs(i).id
      ,p_session_date                 => p_rowid_id_recs(i).effective_date
      ,p_processing_priority          => null
      ,p_delete_mode                  => g_zap_deletion_mode
      );

Line: 4118

      pay_sub_class_rules_pkg.delete_row
      (p_rowid                        => p_rowid_id_recs(i).rowid
      ,p_sub_classification_rule_id   => p_rowid_id_recs(i).id
      ,p_delete_mode                  => g_zap_deletion_mode
      ,p_validation_start_date        => hr_api.g_sot
      ,p_validation_end_date          => hr_api.g_eot
      );

Line: 4144

      pay_bal_classifications_pkg.delete_row
      (x_rowid                        => p_rowid_id_recs(i).rowid
      ,x_balance_classification_id    => p_rowid_id_recs(i).id
      );

Line: 4169

      pay_input_values_pkg.delete_row
      (p_rowid                        => p_rowid_id_recs(i).rowid
      ,p_input_value_id               => p_rowid_id_recs(i).id
      ,p_delete_mode                  => g_zap_deletion_mode
      ,p_session_date                 => p_rowid_id_recs(i).effective_date
      ,p_validation_start_date        => hr_api.g_sot
      ,p_validation_end_date          => hr_api.g_eot
      );

Line: 4198

      pay_formula_result_rules_pkg.delete_row
      (p_rowid                        => p_rowid_id_recs(i).rowid
      );

Line: 4222

      pay_status_rules_pkg.delete_row
      (x_rowid                     => p_rowid_id_recs(i).rowid
      ,p_session_date              => p_rowid_id_recs(i).effective_date
      ,p_delete_mode               => g_zap_deletion_mode
      ,p_status_processing_rule_id => p_rowid_id_recs(i).id
      );

Line: 4360

      pay_balance_attribute_api.delete_balance_attribute
      (p_balance_attribute_id => p_id_ovn_recs(i).id
      );

Line: 4387

      ff_formulas_f_pkg.delete_row
      (x_rowid                        => p_rowid_id_recs(i).rowid
      ,x_formula_id                   => l_formula_id
      ,x_dt_delete_mode               => g_zap_deletion_mode
      ,x_validation_start_date        => hr_api.g_sot
      ,x_validation_end_date          => hr_api.g_eot
      );

Line: 4422

    delete from ff_compiled_info_f where formula_id = l_formula_id;

Line: 4424

    delete from ff_fdi_usages_f where formula_id = l_formula_id;

Line: 4448

  select object_name package_name
  from   user_objects
  where  object_name like p_package_name
  and    object_type = p_object_type
  ;

Line: 4469

        p_rowid_id_recs.delete(k);