DBA Data[Home] [Help]

APPS.PAY_ELE_INS SQL Statements

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

Line: 57

Procedure dt_insert_dml
  (p_rec                     in out nocopy pay_ele_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
-- Cursor to select 'old' created AOL who column values
--
  Cursor C_Sel1 Is
    select t.created_by,
           t.creation_date
    from   pay_element_entries_f t
    where  t.element_entry_id       = p_rec.element_entry_id
    and    t.effective_start_date =
             pay_ele_shd.g_old_rec.effective_start_date
    and    t.effective_end_date   = (p_validation_start_date - 1);
Line: 75

  l_proc                varchar2(72) := g_package||'dt_insert_dml';
Line: 78

  l_last_update_date   	pay_element_entries_f.last_update_date%TYPE;
Line: 79

  l_last_updated_by     pay_element_entries_f.last_updated_by%TYPE;
Line: 80

  l_last_update_login   pay_element_entries_f.last_update_login%TYPE;
Line: 103

  If (p_datetrack_mode <> hr_api.g_insert) then
    hr_utility.set_location(l_proc, 10);
Line: 125

    l_last_update_date   := sysdate;
Line: 126

    l_last_updated_by    := fnd_global.user_id;
Line: 127

    l_last_update_login  := fnd_global.login_id;
Line: 134

  insert into pay_element_entries_f
      (element_entry_id
      ,effective_start_date
      ,effective_end_date
      ,cost_allocation_keyflex_id
      ,assignment_id
      ,updating_action_id
      ,updating_action_type
      ,element_link_id
      ,original_entry_id
      ,creator_type
      ,entry_type
      ,comment_id
      ,creator_id
      ,reason
      ,target_entry_id
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,subpriority
      ,personal_payment_method_id
      ,date_earned
      ,object_version_number
      ,source_id
      ,balance_adj_cost_flag
      ,element_type_id
      ,all_entry_values_null
      ,created_by
      ,creation_date
      ,last_update_date
      ,last_updated_by
      ,last_update_login
      )
  Values
    (p_rec.element_entry_id
    ,p_rec.effective_start_date
    ,p_rec.effective_end_date
    ,p_rec.cost_allocation_keyflex_id
    ,p_rec.assignment_id
    ,p_rec.updating_action_id
    ,p_rec.updating_action_type
    ,p_rec.element_link_id
    ,p_rec.original_entry_id
    ,p_rec.creator_type
    ,p_rec.entry_type
    ,p_rec.comment_id
    ,p_rec.creator_id
    ,p_rec.reason
    ,p_rec.target_entry_id
    ,p_rec.attribute_category
    ,p_rec.attribute1
    ,p_rec.attribute2
    ,p_rec.attribute3
    ,p_rec.attribute4
    ,p_rec.attribute5
    ,p_rec.attribute6
    ,p_rec.attribute7
    ,p_rec.attribute8
    ,p_rec.attribute9
    ,p_rec.attribute10
    ,p_rec.attribute11
    ,p_rec.attribute12
    ,p_rec.attribute13
    ,p_rec.attribute14
    ,p_rec.attribute15
    ,p_rec.attribute16
    ,p_rec.attribute17
    ,p_rec.attribute18
    ,p_rec.attribute19
    ,p_rec.attribute20
    ,p_rec.subpriority
    ,p_rec.personal_payment_method_id
    ,p_rec.date_earned
    ,p_rec.object_version_number
    ,p_rec.source_id
    ,p_rec.balance_adj_cost_flag
    ,p_rec.element_type_id
    ,p_rec.all_entry_values_null
    ,l_created_by
    ,l_creation_date
    ,l_last_update_date
    ,l_last_updated_by
    ,l_last_update_login
    );
Line: 254

End dt_insert_dml;
Line: 259

Procedure insert_dml
  (p_rec                   in out nocopy pay_ele_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||'insert_dml';
Line: 272

  pay_ele_ins.dt_insert_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: 281

End insert_dml;
Line: 322

Procedure pre_insert
  (p_rec                   in out nocopy pay_ele_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_insert';
Line: 332

  Cursor C_Sel1 is select pay_element_entries_s.nextval from sys.dual;
Line: 355

End pre_insert;
Line: 389

Procedure post_insert
  (p_rec                   in pay_ele_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_insert';
Line: 404

    pay_ele_rki.after_insert
      (p_effective_date
      => p_effective_date
      ,p_validation_start_date
      => p_validation_start_date
      ,p_validation_end_date
      => p_validation_end_date
      ,p_element_entry_id
      => p_rec.element_entry_id
      ,p_effective_start_date
      => p_rec.effective_start_date
      ,p_effective_end_date
      => p_rec.effective_end_date
      ,p_cost_allocation_keyflex_id
      => p_rec.cost_allocation_keyflex_id
      ,p_assignment_id
      => p_rec.assignment_id
      ,p_updating_action_id
      => p_rec.updating_action_id
      ,p_updating_action_type
      => p_rec.updating_action_type
      ,p_element_link_id
      => p_rec.element_link_id
      ,p_original_entry_id
      => p_rec.original_entry_id
      ,p_creator_type
      => p_rec.creator_type
      ,p_entry_type
      => p_rec.entry_type
      ,p_comment_id
      => p_rec.comment_id
      ,p_comments
      => p_rec.comments
      ,p_creator_id
      => p_rec.creator_id
      ,p_reason
      => p_rec.reason
      ,p_target_entry_id
      => p_rec.target_entry_id
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
-- --
  ,
  p_entry_information_category => p_rec.entry_information_category,
  p_entry_information1 => p_rec.entry_information1,
  p_entry_information2 => p_rec.entry_information2,
  p_entry_information3 => p_rec.entry_information3,
  p_entry_information4 => p_rec.entry_information4,
  p_entry_information5 => p_rec.entry_information5,
  p_entry_information6 => p_rec.entry_information6,
  p_entry_information7 => p_rec.entry_information7,
  p_entry_information8 => p_rec.entry_information8,
  p_entry_information9 => p_rec.entry_information9,
  p_entry_information10 => p_rec.entry_information10,
  p_entry_information11 => p_rec.entry_information11,
  p_entry_information12 => p_rec.entry_information12,
  p_entry_information13 => p_rec.entry_information13,
  p_entry_information14 => p_rec.entry_information14,
  p_entry_information15 => p_rec.entry_information15,
  p_entry_information16 => p_rec.entry_information16,
  p_entry_information17 => p_rec.entry_information17,
  p_entry_information18 => p_rec.entry_information18,
  p_entry_information19 => p_rec.entry_information19,
  p_entry_information20 => p_rec.entry_information20,
  p_entry_information21 => p_rec.entry_information21,
  p_entry_information22 => p_rec.entry_information22,
  p_entry_information23 => p_rec.entry_information23,
  p_entry_information24 => p_rec.entry_information24,
  p_entry_information25 => p_rec.entry_information25,
  p_entry_information26 => p_rec.entry_information26,
  p_entry_information27 => p_rec.entry_information27,
  p_entry_information28 => p_rec.entry_information28,
  p_entry_information29 => p_rec.entry_information29,
  p_entry_information30 => p_rec.entry_information30
      ,p_subpriority
      => p_rec.subpriority
      ,p_personal_payment_method_id
      => p_rec.personal_payment_method_id
      ,p_date_earned
      => p_rec.date_earned
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_source_id
      => p_rec.source_id
      ,p_balance_adj_cost_flag => p_rec.balance_adj_cost_flag
      ,p_element_type_id => p_rec.element_type_id
      ,p_all_entry_values_null => p_rec.all_entry_values_null
      );
Line: 548

End post_insert;
Line: 639

  l_datetrack_mode              varchar2(30) := hr_api.g_insert;
Line: 658

  pay_ele_bus.insert_validate
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );
Line: 668

  pay_ele_ins.pre_insert
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );
Line: 678

  pay_ele_ins.insert_dml
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );
Line: 688

  pay_ele_ins.post_insert
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => l_datetrack_mode
    ,p_validation_start_date => l_validation_start_date
    ,p_validation_end_date   => l_validation_end_date
    );