eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_OPM_INS SQL Statements

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

Line: 78


Procedure dt_insert_dml
  (p_rec                     in out nocopy pay_opm_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_org_payment_methods_f t
    where  t.org_payment_method_id       = p_rec.org_payment_method_id
    and    t.effective_start_date =
             pay_opm_shd.g_old_rec.effective_start_date
    and    t.effective_end_date   = (p_validation_start_date - 1);

Line: 96


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

Line: 99


  l_last_update_date   	pay_org_payment_methods_f.last_update_date%TYPE;

Line: 100


  l_last_updated_by     pay_org_payment_methods_f.last_updated_by%TYPE;

Line: 101


  l_last_update_login   pay_org_payment_methods_f.last_update_login%TYPE;

Line: 124


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

Line: 146


    l_last_update_date   := sysdate;

Line: 147


    l_last_updated_by    := fnd_global.user_id;

Line: 148


    l_last_update_login  := fnd_global.login_id;

Line: 155


  insert into pay_org_payment_methods_f
      (org_payment_method_id
      ,effective_start_date
      ,effective_end_date
      ,business_group_id
      ,external_account_id
      ,currency_code
      ,payment_type_id
      ,defined_balance_id
      ,org_payment_method_name
      ,comment_id
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,attribute11
      ,attribute12
      ,attribute13
      ,attribute14
      ,attribute15
      ,attribute16
      ,attribute17
      ,attribute18
      ,attribute19
      ,attribute20
      ,pmeth_information_category
      ,pmeth_information1
      ,pmeth_information2
      ,pmeth_information3
      ,pmeth_information4
      ,pmeth_information5
      ,pmeth_information6
      ,pmeth_information7
      ,pmeth_information8
      ,pmeth_information9
      ,pmeth_information10
      ,pmeth_information11
      ,pmeth_information12
      ,pmeth_information13
      ,pmeth_information14
      ,pmeth_information15
      ,pmeth_information16
      ,pmeth_information17
      ,pmeth_information18
      ,pmeth_information19
      ,pmeth_information20
      ,object_version_number
      ,created_by
      ,creation_date
      ,last_update_date
      ,last_updated_by
      ,last_update_login
      ,transfer_to_gl_flag
      ,cost_payment
      ,cost_cleared_payment
      ,cost_cleared_void_payment
      ,exclude_manual_payment
      )
  Values
    (p_rec.org_payment_method_id
    ,p_rec.effective_start_date
    ,p_rec.effective_end_date
    ,p_rec.business_group_id
    ,p_rec.external_account_id
    ,p_rec.currency_code
    ,p_rec.payment_type_id
    ,p_rec.defined_balance_id
    ,p_rec.org_payment_method_name
    ,p_rec.comment_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.pmeth_information_category
    ,p_rec.pmeth_information1
    ,p_rec.pmeth_information2
    ,p_rec.pmeth_information3
    ,p_rec.pmeth_information4
    ,p_rec.pmeth_information5
    ,p_rec.pmeth_information6
    ,p_rec.pmeth_information7
    ,p_rec.pmeth_information8
    ,p_rec.pmeth_information9
    ,p_rec.pmeth_information10
    ,p_rec.pmeth_information11
    ,p_rec.pmeth_information12
    ,p_rec.pmeth_information13
    ,p_rec.pmeth_information14
    ,p_rec.pmeth_information15
    ,p_rec.pmeth_information16
    ,p_rec.pmeth_information17
    ,p_rec.pmeth_information18
    ,p_rec.pmeth_information19
    ,p_rec.pmeth_information20
    ,p_rec.object_version_number
    ,l_created_by
    ,l_creation_date
    ,l_last_update_date
    ,l_last_updated_by
    ,l_last_update_login
    ,p_rec.transfer_to_gl_flag
    ,p_rec.cost_payment
    ,p_rec.cost_cleared_payment
    ,p_rec.cost_cleared_void_payment
    ,p_rec.exclude_manual_payment
    );

Line: 303


End dt_insert_dml;

Line: 308


Procedure insert_dml
  (p_rec                   in out nocopy pay_opm_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: 321


  pay_opm_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: 330


End insert_dml;

Line: 371


Procedure pre_insert
  (p_rec                   in out nocopy pay_opm_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 C_Sel1 is select pay_org_payment_methods_s.nextval from sys.dual;

Line: 382


    Select null
      from pay_org_payment_methods_f
      where org_payment_method_id =
             pay_opm_ins.g_org_payment_method_id_i;

Line: 387


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

Line: 437


End pre_insert;

Line: 471


Procedure post_insert
  (p_rec                   in pay_opm_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: 485


    pay_opm_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_org_payment_method_id
      => p_rec.org_payment_method_id
      ,p_effective_start_date
      => p_rec.effective_start_date
      ,p_effective_end_date
      => p_rec.effective_end_date
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_external_account_id
      => p_rec.external_account_id
      ,p_currency_code
      => p_rec.currency_code
      ,p_payment_type_id
      => p_rec.payment_type_id
      ,p_defined_balance_id
      => p_rec.defined_balance_id
      ,p_org_payment_method_name
      => p_rec.org_payment_method_name
      ,p_comment_id
      => p_rec.comment_id
      ,p_comments
      => p_rec.comments
      ,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_pmeth_information_category
      => p_rec.pmeth_information_category
      ,p_pmeth_information1
      => p_rec.pmeth_information1
      ,p_pmeth_information2
      => p_rec.pmeth_information2
      ,p_pmeth_information3
      => p_rec.pmeth_information3
      ,p_pmeth_information4
      => p_rec.pmeth_information4
      ,p_pmeth_information5
      => p_rec.pmeth_information5
      ,p_pmeth_information6
      => p_rec.pmeth_information6
      ,p_pmeth_information7
      => p_rec.pmeth_information7
      ,p_pmeth_information8
      => p_rec.pmeth_information8
      ,p_pmeth_information9
      => p_rec.pmeth_information9
      ,p_pmeth_information10
      => p_rec.pmeth_information10
      ,p_pmeth_information11
      => p_rec.pmeth_information11
      ,p_pmeth_information12
      => p_rec.pmeth_information12
      ,p_pmeth_information13
      => p_rec.pmeth_information13
      ,p_pmeth_information14
      => p_rec.pmeth_information14
      ,p_pmeth_information15
      => p_rec.pmeth_information15
      ,p_pmeth_information16
      => p_rec.pmeth_information16
      ,p_pmeth_information17
      => p_rec.pmeth_information17
      ,p_pmeth_information18
      => p_rec.pmeth_information18
      ,p_pmeth_information19
      => p_rec.pmeth_information19
      ,p_pmeth_information20
      => p_rec.pmeth_information20
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_transfer_to_gl_flag
      => p_rec.transfer_to_gl_flag
      ,p_cost_payment
      => p_rec.cost_payment
      ,p_cost_cleared_payment
      => p_rec.cost_cleared_payment
      ,p_cost_cleared_void_payment
      => p_rec.cost_cleared_void_payment
      ,p_exclude_manual_payment
      => p_rec.exclude_manual_payment
      );

Line: 623


End post_insert;

Line: 708


  l_datetrack_mode              varchar2(30) := hr_api.g_insert;

Line: 727


  pay_opm_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: 737


  pay_opm_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: 747


  pay_opm_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: 757


  pay_opm_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
    );