APPS.PAY_ELEMENT_CLASS_SWI SQL Statements

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

Line: 11

PROCEDURE delete_row
  (x_classification_id            in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  --
  -- Other variables
  l_proc    varchar2(72) := g_package ||'delete_row';

Line: 27

  savepoint delete_row_swi;

Line: 44

  pay_element_class_pkg.delete_row
    (x_classification_id            => x_classification_id
    );

Line: 69

    rollback to delete_row_swi;

Line: 83

    rollback to delete_row_swi;

Line: 93

end delete_row;

Line: 97

PROCEDURE insert_row
  (x_rowid                        in out nocopy varchar2
  ,x_classification_id            in     number
  ,x_business_group_id            in     number
  ,x_legislation_code             in     varchar2
  ,x_legislation_subgroup         in     varchar2
  ,x_costable_flag                in     varchar2
  ,x_default_high_priority        in     number
  ,x_default_low_priority         in     number
  ,x_default_priority             in     number
  ,x_distributable_over_flag      in     varchar2
  ,x_non_payments_flag            in     varchar2
  ,x_costing_debit_or_credit      in     varchar2
  ,x_parent_classification_id     in     number
  ,x_create_by_default_flag       in     varchar2
  ,x_balance_initialization_flag  in     varchar2
  ,x_object_version_number        in     number
  ,x_classification_name          in     varchar2
  ,x_description                  in     varchar2
  ,x_creation_date                in     date
  ,x_created_by                   in     number
  ,x_last_update_date             in     date
  ,x_last_updated_by              in     number
  ,x_last_update_login            in     number
  ,x_freq_rule_enabled            in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  l_rowid                         varchar2(60);

Line: 131

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

Line: 137

  savepoint insert_row_swi;

Line: 155

  pay_element_class_pkg.insert_row
    (x_rowid                        => l_rowid
    ,x_classification_id            => x_classification_id
    ,x_business_group_id            => x_business_group_id
    ,x_legislation_code             => x_legislation_code
    ,x_legislation_subgroup         => x_legislation_subgroup
    ,x_costable_flag                => x_costable_flag
    ,x_default_high_priority        => x_default_high_priority
    ,x_default_low_priority         => x_default_low_priority
    ,x_default_priority             => x_default_priority
    ,x_distributable_over_flag      => x_distributable_over_flag
    ,x_non_payments_flag            => x_non_payments_flag
    ,x_costing_debit_or_credit      => x_costing_debit_or_credit
    ,x_parent_classification_id     => x_parent_classification_id
    ,x_create_by_default_flag       => x_create_by_default_flag
    ,x_balance_initialization_flag  => x_balance_initialization_flag
    ,x_object_version_number        => x_object_version_number
    ,x_classification_name          => x_classification_name
    ,x_description                  => x_description
    ,x_creation_date                => x_creation_date
    ,x_created_by                   => x_created_by
    ,x_last_update_date             => x_last_update_date
    ,x_last_updated_by              => x_last_updated_by
    ,x_last_update_login            => x_last_update_login
    ,x_freq_rule_enabled            => x_freq_rule_enabled
    );

Line: 203

    rollback to insert_row_swi;

Line: 218

    rollback to insert_row_swi;

Line: 229

end insert_row;

Line: 535

PROCEDURE update_row
  (x_classification_id            in     number
  ,x_business_group_id            in     number
  ,x_legislation_code             in     varchar2
  ,x_legislation_subgroup         in     varchar2
  ,x_costable_flag                in     varchar2
  ,x_default_high_priority        in     number
  ,x_default_low_priority         in     number
  ,x_default_priority             in     number
  ,x_distributable_over_flag      in     varchar2
  ,x_non_payments_flag            in     varchar2
  ,x_costing_debit_or_credit      in     varchar2
  ,x_parent_classification_id     in     number
  ,x_create_by_default_flag       in     varchar2
  ,x_balance_initialization_flag  in     varchar2
  ,x_object_version_number        in     number
  ,x_classification_name          in     varchar2
  ,x_description                  in     varchar2
  ,x_last_update_date             in     date
  ,x_last_updated_by              in     number
  ,x_last_update_login            in     number
  ,x_mesg_flg                        out nocopy number
  ,x_freq_rule_enabled            in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_mesg_flg                      boolean;

Line: 567

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

Line: 573

  savepoint update_row_swi;

Line: 593

  pay_element_class_pkg.update_row
    (x_classification_id            => x_classification_id
    ,x_business_group_id            => x_business_group_id
    ,x_legislation_code             => x_legislation_code
    ,x_legislation_subgroup         => x_legislation_subgroup
    ,x_costable_flag                => x_costable_flag
    ,x_default_high_priority        => x_default_high_priority
    ,x_default_low_priority         => x_default_low_priority
    ,x_default_priority             => x_default_priority
    ,x_distributable_over_flag      => x_distributable_over_flag
    ,x_non_payments_flag            => x_non_payments_flag
    ,x_costing_debit_or_credit      => x_costing_debit_or_credit
    ,x_parent_classification_id     => x_parent_classification_id
    ,x_create_by_default_flag       => x_create_by_default_flag
    ,x_balance_initialization_flag  => x_balance_initialization_flag
    ,x_object_version_number        => x_object_version_number
    ,x_classification_name          => x_classification_name
    ,x_description                  => x_description
    ,x_last_update_date             => x_last_update_date
    ,x_last_updated_by              => x_last_updated_by
    ,x_last_update_login            => x_last_update_login
    ,x_mesg_flg                     => l_mesg_flg
    ,x_freq_rule_enabled            => x_freq_rule_enabled
    );

Line: 643

    rollback to update_row_swi;

Line: 658

    rollback to update_row_swi;

Line: 669

end update_row;