[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
pay_pss_tx_steps_pkg.insert_row
(p_transaction_id => p_ppm.transaction_id
,p_transaction_step_id => p_ppm.transaction_step_id
,p_source_table => p_ppm.source_table
,p_state => p_ppm.state
,p_personal_payment_method_id => p_ppm.personal_payment_method_id
,p_update_ovn => p_ppm.update_ovn
,p_delete_ovn => p_ppm.delete_ovn
,p_update_datetrack_mode => p_ppm.update_datetrack_mode
,p_delete_datetrack_mode => p_ppm.delete_datetrack_mode
,p_delete_disabled => p_ppm.delete_disabled
,p_effective_date => p_ppm.effective_date
,p_org_payment_method_id => p_ppm.org_payment_method_id
,p_assignment_id => p_ppm.assignment_id
,p_payment_type => p_ppm.payment_type
,p_currency_code => p_ppm.currency_code
,p_territory_code => p_ppm.territory_code
,p_run_type_id => p_ppm.run_type_id
,p_real_priority => p_ppm.real_priority
,p_logical_priority => p_ppm.logical_priority
,p_amount_type => p_ppm.amount_type
,p_amount => p_ppm.amount
,p_external_account_id => p_ppm.external_account_id
,p_attribute_category => p_ppm.attribute_category
,p_attribute1 => p_ppm.attribute1
,p_attribute2 => p_ppm.attribute2
,p_attribute3 => p_ppm.attribute3
,p_attribute4 => p_ppm.attribute4
,p_attribute5 => p_ppm.attribute5
,p_attribute6 => p_ppm.attribute6
,p_attribute7 => p_ppm.attribute7
,p_attribute8 => p_ppm.attribute8
,p_attribute9 => p_ppm.attribute9
,p_attribute10 => p_ppm.attribute10
,p_attribute11 => p_ppm.attribute11
,p_attribute12 => p_ppm.attribute12
,p_attribute13 => p_ppm.attribute13
,p_attribute14 => p_ppm.attribute14
,p_attribute15 => p_ppm.attribute15
,p_attribute16 => p_ppm.attribute16
,p_attribute17 => p_ppm.attribute17
,p_attribute18 => p_ppm.attribute18
,p_attribute19 => p_ppm.attribute19
,p_attribute20 => p_ppm.attribute20
,p_o_real_priority => p_ppm.o_real_priority
,p_o_logical_priority => p_ppm.o_logical_priority
,p_o_amount_type => p_ppm.o_amount_type
,p_o_amount => p_ppm.o_amount
,p_o_external_account_id => p_ppm.o_external_account_id
,p_o_attribute_category => p_ppm.o_attribute_category
,p_o_attribute1 => p_ppm.o_attribute1
,p_o_attribute2 => p_ppm.o_attribute2
,p_o_attribute3 => p_ppm.o_attribute3
,p_o_attribute4 => p_ppm.o_attribute4
,p_o_attribute5 => p_ppm.o_attribute5
,p_o_attribute6 => p_ppm.o_attribute6
,p_o_attribute7 => p_ppm.o_attribute7
,p_o_attribute8 => p_ppm.o_attribute8
,p_o_attribute9 => p_ppm.o_attribute9
,p_o_attribute10 => p_ppm.o_attribute10
,p_o_attribute11 => p_ppm.o_attribute11
,p_o_attribute12 => p_ppm.o_attribute12
,p_o_attribute13 => p_ppm.o_attribute13
,p_o_attribute14 => p_ppm.o_attribute14
,p_o_attribute15 => p_ppm.o_attribute15
,p_o_attribute16 => p_ppm.o_attribute16
,p_o_attribute17 => p_ppm.o_attribute17
,p_o_attribute18 => p_ppm.o_attribute18
,p_o_attribute19 => p_ppm.o_attribute19
,p_o_attribute20 => p_ppm.o_attribute20
,p_ppm_information_category => p_ppm.ppm_information_category
,p_ppm_information1 => p_ppm.ppm_information1
,p_ppm_information2 => p_ppm.ppm_information2
,p_ppm_information3 => p_ppm.ppm_information3
,p_ppm_information4 => p_ppm.ppm_information4
,p_ppm_information5 => p_ppm.ppm_information5
,p_ppm_information6 => p_ppm.ppm_information6
,p_ppm_information7 => p_ppm.ppm_information7
,p_ppm_information8 => p_ppm.ppm_information8
,p_ppm_information9 => p_ppm.ppm_information9
,p_ppm_information10 => p_ppm.ppm_information10
,p_ppm_information11 => p_ppm.ppm_information11
,p_ppm_information12 => p_ppm.ppm_information12
,p_ppm_information13 => p_ppm.ppm_information13
,p_ppm_information14 => p_ppm.ppm_information14
,p_ppm_information15 => p_ppm.ppm_information15
,p_ppm_information16 => p_ppm.ppm_information16
,p_ppm_information17 => p_ppm.ppm_information17
,p_ppm_information18 => p_ppm.ppm_information18
,p_ppm_information19 => p_ppm.ppm_information19
,p_ppm_information20 => p_ppm.ppm_information20
,p_ppm_information21 => p_ppm.ppm_information21
,p_ppm_information22 => p_ppm.ppm_information22
,p_ppm_information23 => p_ppm.ppm_information23
,p_ppm_information24 => p_ppm.ppm_information24
,p_ppm_information25 => p_ppm.ppm_information25
,p_ppm_information26 => p_ppm.ppm_information26
,p_ppm_information27 => p_ppm.ppm_information27
,p_ppm_information28 => p_ppm.ppm_information28
,p_ppm_information29 => p_ppm.ppm_information29
,p_ppm_information30 => p_ppm.ppm_information30
,p_o_ppm_information_category => p_ppm.o_ppm_information_category
,p_o_ppm_information1 => p_ppm.o_ppm_information1
,p_o_ppm_information2 => p_ppm.o_ppm_information2
,p_o_ppm_information3 => p_ppm.o_ppm_information3
,p_o_ppm_information4 => p_ppm.o_ppm_information4
,p_o_ppm_information5 => p_ppm.o_ppm_information5
,p_o_ppm_information6 => p_ppm.o_ppm_information6
,p_o_ppm_information7 => p_ppm.o_ppm_information7
,p_o_ppm_information8 => p_ppm.o_ppm_information8
,p_o_ppm_information9 => p_ppm.o_ppm_information9
,p_o_ppm_information10 => p_ppm.o_ppm_information10
,p_o_ppm_information11 => p_ppm.o_ppm_information11
,p_o_ppm_information12 => p_ppm.o_ppm_information12
,p_o_ppm_information13 => p_ppm.o_ppm_information13
,p_o_ppm_information14 => p_ppm.o_ppm_information14
,p_o_ppm_information15 => p_ppm.o_ppm_information15
,p_o_ppm_information16 => p_ppm.o_ppm_information16
,p_o_ppm_information17 => p_ppm.o_ppm_information17
,p_o_ppm_information18 => p_ppm.o_ppm_information18
,p_o_ppm_information19 => p_ppm.o_ppm_information19
,p_o_ppm_information20 => p_ppm.o_ppm_information20
,p_o_ppm_information21 => p_ppm.o_ppm_information21
,p_o_ppm_information22 => p_ppm.o_ppm_information22
,p_o_ppm_information23 => p_ppm.o_ppm_information23
,p_o_ppm_information24 => p_ppm.o_ppm_information24
,p_o_ppm_information25 => p_ppm.o_ppm_information25
,p_o_ppm_information26 => p_ppm.o_ppm_information26
,p_o_ppm_information27 => p_ppm.o_ppm_information27
,p_o_ppm_information28 => p_ppm.o_ppm_information28
,p_o_ppm_information29 => p_ppm.o_ppm_information29
,p_o_ppm_information30 => p_ppm.o_ppm_information30
);
pay_pss_tx_steps_pkg.update_row
(p_transaction_step_id => p_ppm.transaction_step_id
,p_source_table => p_ppm.source_table
,p_state => p_ppm.state
,p_personal_payment_method_id => p_ppm.personal_payment_method_id
,p_update_ovn => p_ppm.update_ovn
,p_delete_ovn => p_ppm.delete_ovn
,p_update_datetrack_mode => p_ppm.update_datetrack_mode
,p_delete_datetrack_mode => p_ppm.delete_datetrack_mode
,p_delete_disabled => p_ppm.delete_disabled
,p_effective_date => p_ppm.effective_date
,p_org_payment_method_id => p_ppm.org_payment_method_id
,p_assignment_id => p_ppm.assignment_id
,p_payment_type => p_ppm.payment_type
,p_currency_code => p_ppm.currency_code
,p_territory_code => p_ppm.territory_code
,p_run_type_id => p_ppm.run_type_id
,p_real_priority => p_ppm.real_priority
,p_logical_priority => p_ppm.logical_priority
,p_amount_type => p_ppm.amount_type
,p_amount => p_ppm.amount
,p_external_account_id => p_ppm.external_account_id
,p_attribute_category => p_ppm.attribute_category
,p_attribute1 => p_ppm.attribute1
,p_attribute2 => p_ppm.attribute2
,p_attribute3 => p_ppm.attribute3
,p_attribute4 => p_ppm.attribute4
,p_attribute5 => p_ppm.attribute5
,p_attribute6 => p_ppm.attribute6
,p_attribute7 => p_ppm.attribute7
,p_attribute8 => p_ppm.attribute8
,p_attribute9 => p_ppm.attribute9
,p_attribute10 => p_ppm.attribute10
,p_attribute11 => p_ppm.attribute11
,p_attribute12 => p_ppm.attribute12
,p_attribute13 => p_ppm.attribute13
,p_attribute14 => p_ppm.attribute14
,p_attribute15 => p_ppm.attribute15
,p_attribute16 => p_ppm.attribute16
,p_attribute17 => p_ppm.attribute17
,p_attribute18 => p_ppm.attribute18
,p_attribute19 => p_ppm.attribute19
,p_attribute20 => p_ppm.attribute20
,p_o_real_priority => p_ppm.o_real_priority
,p_o_logical_priority => p_ppm.o_logical_priority
,p_o_amount_type => p_ppm.o_amount_type
,p_o_amount => p_ppm.o_amount
,p_o_external_account_id => p_ppm.o_external_account_id
,p_o_attribute_category => p_ppm.o_attribute_category
,p_o_attribute1 => p_ppm.o_attribute1
,p_o_attribute2 => p_ppm.o_attribute2
,p_o_attribute3 => p_ppm.o_attribute3
,p_o_attribute4 => p_ppm.o_attribute4
,p_o_attribute5 => p_ppm.o_attribute5
,p_o_attribute6 => p_ppm.o_attribute6
,p_o_attribute7 => p_ppm.o_attribute7
,p_o_attribute8 => p_ppm.o_attribute8
,p_o_attribute9 => p_ppm.o_attribute9
,p_o_attribute10 => p_ppm.o_attribute10
,p_o_attribute11 => p_ppm.o_attribute11
,p_o_attribute12 => p_ppm.o_attribute12
,p_o_attribute13 => p_ppm.o_attribute13
,p_o_attribute14 => p_ppm.o_attribute14
,p_o_attribute15 => p_ppm.o_attribute15
,p_o_attribute16 => p_ppm.o_attribute16
,p_o_attribute17 => p_ppm.o_attribute17
,p_o_attribute18 => p_ppm.o_attribute18
,p_o_attribute19 => p_ppm.o_attribute19
,p_o_attribute20 => p_ppm.o_attribute20
,p_ppm_information_category => p_ppm.ppm_information_category
,p_ppm_information1 => p_ppm.ppm_information1
,p_ppm_information2 => p_ppm.ppm_information2
,p_ppm_information3 => p_ppm.ppm_information3
,p_ppm_information4 => p_ppm.ppm_information4
,p_ppm_information5 => p_ppm.ppm_information5
,p_ppm_information6 => p_ppm.ppm_information6
,p_ppm_information7 => p_ppm.ppm_information7
,p_ppm_information8 => p_ppm.ppm_information8
,p_ppm_information9 => p_ppm.ppm_information9
,p_ppm_information10 => p_ppm.ppm_information10
,p_ppm_information11 => p_ppm.ppm_information11
,p_ppm_information12 => p_ppm.ppm_information12
,p_ppm_information13 => p_ppm.ppm_information13
,p_ppm_information14 => p_ppm.ppm_information14
,p_ppm_information15 => p_ppm.ppm_information15
,p_ppm_information16 => p_ppm.ppm_information16
,p_ppm_information17 => p_ppm.ppm_information17
,p_ppm_information18 => p_ppm.ppm_information18
,p_ppm_information19 => p_ppm.ppm_information19
,p_ppm_information20 => p_ppm.ppm_information20
,p_ppm_information21 => p_ppm.ppm_information21
,p_ppm_information22 => p_ppm.ppm_information22
,p_ppm_information23 => p_ppm.ppm_information23
,p_ppm_information24 => p_ppm.ppm_information24
,p_ppm_information25 => p_ppm.ppm_information25
,p_ppm_information26 => p_ppm.ppm_information26
,p_ppm_information27 => p_ppm.ppm_information27
,p_ppm_information28 => p_ppm.ppm_information28
,p_ppm_information29 => p_ppm.ppm_information29
,p_ppm_information30 => p_ppm.ppm_information30
,p_o_ppm_information_category => p_ppm.o_ppm_information_category
,p_o_ppm_information1 => p_ppm.o_ppm_information1
,p_o_ppm_information2 => p_ppm.o_ppm_information2
,p_o_ppm_information3 => p_ppm.o_ppm_information3
,p_o_ppm_information4 => p_ppm.o_ppm_information4
,p_o_ppm_information5 => p_ppm.o_ppm_information5
,p_o_ppm_information6 => p_ppm.o_ppm_information6
,p_o_ppm_information7 => p_ppm.o_ppm_information7
,p_o_ppm_information8 => p_ppm.o_ppm_information8
,p_o_ppm_information9 => p_ppm.o_ppm_information9
,p_o_ppm_information10 => p_ppm.o_ppm_information10
,p_o_ppm_information11 => p_ppm.o_ppm_information11
,p_o_ppm_information12 => p_ppm.o_ppm_information12
,p_o_ppm_information13 => p_ppm.o_ppm_information13
,p_o_ppm_information14 => p_ppm.o_ppm_information14
,p_o_ppm_information15 => p_ppm.o_ppm_information15
,p_o_ppm_information16 => p_ppm.o_ppm_information16
,p_o_ppm_information17 => p_ppm.o_ppm_information17
,p_o_ppm_information18 => p_ppm.o_ppm_information18
,p_o_ppm_information19 => p_ppm.o_ppm_information19
,p_o_ppm_information20 => p_ppm.o_ppm_information20
,p_o_ppm_information21 => p_ppm.o_ppm_information21
,p_o_ppm_information22 => p_ppm.o_ppm_information22
,p_o_ppm_information23 => p_ppm.o_ppm_information23
,p_o_ppm_information24 => p_ppm.o_ppm_information24
,p_o_ppm_information25 => p_ppm.o_ppm_information25
,p_o_ppm_information26 => p_ppm.o_ppm_information26
,p_o_ppm_information27 => p_ppm.o_ppm_information27
,p_o_ppm_information28 => p_ppm.o_ppm_information28
,p_o_ppm_information29 => p_ppm.o_ppm_information29
,p_o_ppm_information30 => p_ppm.o_ppm_information30
);
select p.transaction_id
,p.transaction_step_id
,p.source_table
,p.state
,p.personal_payment_method_id
,p.update_ovn
,p.delete_ovn
,p.update_datetrack_mode
,p.delete_datetrack_mode
,p.delete_disabled
,p.effective_date
,p.org_payment_method_id
,p.assignment_id
,p.payment_type
,p.currency_code
,p.territory_code
,p.real_priority
,p.logical_priority
,p.amount_type
,p.amount
,p.external_account_id
,p.attribute_category
,p.attribute1
,p.attribute2
,p.attribute3
,p.attribute4
,p.attribute5
,p.attribute6
,p.attribute7
,p.attribute8
,p.attribute9
,p.attribute10
,p.attribute11
,p.attribute12
,p.attribute13
,p.attribute14
,p.attribute15
,p.attribute16
,p.attribute17
,p.attribute18
,p.attribute19
,p.attribute20
,p.o_real_priority
,p.o_logical_priority
,p.o_amount_type
,p.o_amount
,p.o_external_account_id
,p.o_attribute_category
,p.o_attribute1
,p.o_attribute2
,p.o_attribute3
,p.o_attribute4
,p.o_attribute5
,p.o_attribute6
,p.o_attribute7
,p.o_attribute8
,p.o_attribute9
,p.o_attribute10
,p.o_attribute11
,p.o_attribute12
,p.o_attribute13
,p.o_attribute14
,p.o_attribute15
,p.o_attribute16
,p.o_attribute17
,p.o_attribute18
,p.o_attribute19
,p.o_attribute20
,p.run_type_id
,p.ppm_information_category
,p.ppm_information1
,p.ppm_information2
,p.ppm_information3
,p.ppm_information4
,p.ppm_information5
,p.ppm_information6
,p.ppm_information7
,p.ppm_information8
,p.ppm_information9
,p.ppm_information10
,p.ppm_information11
,p.ppm_information12
,p.ppm_information13
,p.ppm_information14
,p.ppm_information15
,p.ppm_information16
,p.ppm_information17
,p.ppm_information18
,p.ppm_information19
,p.ppm_information20
,p.ppm_information21
,p.ppm_information22
,p.ppm_information23
,p.ppm_information24
,p.ppm_information25
,p.ppm_information26
,p.ppm_information27
,p.ppm_information28
,p.ppm_information29
,p.ppm_information30
,p.o_ppm_information_category
,p.o_ppm_information1
,p.o_ppm_information2
,p.o_ppm_information3
,p.o_ppm_information4
,p.o_ppm_information5
,p.o_ppm_information6
,p.o_ppm_information7
,p.o_ppm_information8
,p.o_ppm_information9
,p.o_ppm_information10
,p.o_ppm_information11
,p.o_ppm_information12
,p.o_ppm_information13
,p.o_ppm_information14
,p.o_ppm_information15
,p.o_ppm_information16
,p.o_ppm_information17
,p.o_ppm_information18
,p.o_ppm_information19
,p.o_ppm_information20
,p.o_ppm_information21
,p.o_ppm_information22
,p.o_ppm_information23
,p.o_ppm_information24
,p.o_ppm_information25
,p.o_ppm_information26
,p.o_ppm_information27
,p.o_ppm_information28
,p.o_ppm_information29
,p.o_ppm_information30
from pay_pss_transaction_steps p
where p.transaction_step_id = p_transaction_step_id;
, p_ppm.update_ovn
, p_ppm.delete_ovn
, p_ppm.update_datetrack_mode
, p_ppm.delete_datetrack_mode
, p_ppm.delete_disabled
, p_ppm.effective_date
, p_ppm.org_payment_method_id
, p_ppm.assignment_id
, p_ppm.payment_type
, p_ppm.currency_code
, p_ppm.territory_code
, p_ppm.real_priority
, p_ppm.logical_priority
, p_ppm.amount_type
, p_ppm.amount
, p_ppm.external_account_id
, p_ppm.attribute_category
, p_ppm.attribute1
, p_ppm.attribute2
, p_ppm.attribute3
, p_ppm.attribute4
, p_ppm.attribute5
, p_ppm.attribute6
, p_ppm.attribute7
, p_ppm.attribute8
, p_ppm.attribute9
, p_ppm.attribute10
, p_ppm.attribute11
, p_ppm.attribute12
, p_ppm.attribute13
, p_ppm.attribute14
, p_ppm.attribute15
, p_ppm.attribute16
, p_ppm.attribute17
, p_ppm.attribute18
, p_ppm.attribute19
, p_ppm.attribute20
, p_ppm.o_real_priority
, p_ppm.o_logical_priority
, p_ppm.o_amount_type
, p_ppm.o_amount
, p_ppm.o_external_account_id
, p_ppm.o_attribute_category
, p_ppm.o_attribute1
, p_ppm.o_attribute2
, p_ppm.o_attribute3
, p_ppm.o_attribute4
, p_ppm.o_attribute5
, p_ppm.o_attribute6
, p_ppm.o_attribute7
, p_ppm.o_attribute8
, p_ppm.o_attribute9
, p_ppm.o_attribute10
, p_ppm.o_attribute11
, p_ppm.o_attribute12
, p_ppm.o_attribute13
, p_ppm.o_attribute14
, p_ppm.o_attribute15
, p_ppm.o_attribute16
, p_ppm.o_attribute17
, p_ppm.o_attribute18
, p_ppm.o_attribute19
, p_ppm.o_attribute20
, p_ppm.run_type_id
, p_ppm.ppm_information_category
, p_ppm.ppm_information1
, p_ppm.ppm_information2
, p_ppm.ppm_information3
, p_ppm.ppm_information4
, p_ppm.ppm_information5
, p_ppm.ppm_information6
, p_ppm.ppm_information7
, p_ppm.ppm_information8
, p_ppm.ppm_information9
, p_ppm.ppm_information10
, p_ppm.ppm_information11
, p_ppm.ppm_information12
, p_ppm.ppm_information13
, p_ppm.ppm_information14
, p_ppm.ppm_information15
, p_ppm.ppm_information16
, p_ppm.ppm_information17
, p_ppm.ppm_information18
, p_ppm.ppm_information19
, p_ppm.ppm_information20
, p_ppm.ppm_information21
, p_ppm.ppm_information22
, p_ppm.ppm_information23
, p_ppm.ppm_information24
, p_ppm.ppm_information25
, p_ppm.ppm_information26
, p_ppm.ppm_information27
, p_ppm.ppm_information28
, p_ppm.ppm_information29
, p_ppm.ppm_information30
, p_ppm.o_ppm_information_category
, p_ppm.o_ppm_information1
, p_ppm.o_ppm_information2
, p_ppm.o_ppm_information3
, p_ppm.o_ppm_information4
, p_ppm.o_ppm_information5
, p_ppm.o_ppm_information6
, p_ppm.o_ppm_information7
, p_ppm.o_ppm_information8
, p_ppm.o_ppm_information9
, p_ppm.o_ppm_information10
, p_ppm.o_ppm_information11
, p_ppm.o_ppm_information12
, p_ppm.o_ppm_information13
, p_ppm.o_ppm_information14
, p_ppm.o_ppm_information15
, p_ppm.o_ppm_information16
, p_ppm.o_ppm_information17
, p_ppm.o_ppm_information18
, p_ppm.o_ppm_information19
, p_ppm.o_ppm_information20
, p_ppm.o_ppm_information21
, p_ppm.o_ppm_information22
, p_ppm.o_ppm_information23
, p_ppm.o_ppm_information24
, p_ppm.o_ppm_information25
, p_ppm.o_ppm_information26
, p_ppm.o_ppm_information27
, p_ppm.o_ppm_information28
, p_ppm.o_ppm_information29
, p_ppm.o_ppm_information30
;
select ppm.priority priority
from pay_personal_payment_methods_f ppm
, pay_org_payment_methods_f opm
where ppm.assignment_id = p_assignment_id
and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
and p_effective_date between
ppm.effective_start_date and ppm.effective_end_date
and opm.org_payment_method_id = ppm.org_payment_method_id
and opm.defined_balance_id is not null
and p_effective_date between
opm.effective_start_date and opm.effective_end_date
order by priority
;
,p_update_datetrack_mode in varchar2 default null
,p_effective_date in date default null
,p_org_payment_method_id in number default null
,p_assignment_id in number default null
,p_run_type_id in number default null
,p_payment_type in varchar2 default null
,p_territory_code in varchar2 default null
,p_amount_type in varchar2 default null
,p_amount in number default null
,p_external_account_id in number default null
,p_attribute_category in varchar2 default null
,p_attribute1 in varchar2 default null
,p_attribute2 in varchar2 default null
,p_attribute3 in varchar2 default null
,p_attribute4 in varchar2 default null
,p_attribute5 in varchar2 default null
,p_attribute6 in varchar2 default null
,p_attribute7 in varchar2 default null
,p_attribute8 in varchar2 default null
,p_attribute9 in varchar2 default null
,p_attribute10 in varchar2 default null
,p_attribute11 in varchar2 default null
,p_attribute12 in varchar2 default null
,p_attribute13 in varchar2 default null
,p_attribute14 in varchar2 default null
,p_attribute15 in varchar2 default null
,p_attribute16 in varchar2 default null
,p_attribute17 in varchar2 default null
,p_attribute18 in varchar2 default null
,p_attribute19 in varchar2 default null
,p_attribute20 in varchar2 default null
,p_segment1 in varchar2 default null
,p_segment2 in varchar2 default null
,p_segment3 in varchar2 default null
,p_segment4 in varchar2 default null
,p_segment5 in varchar2 default null
,p_segment6 in varchar2 default null
,p_segment7 in varchar2 default null
,p_segment8 in varchar2 default null
,p_segment9 in varchar2 default null
,p_segment10 in varchar2 default null
,p_segment11 in varchar2 default null
,p_segment12 in varchar2 default null
,p_segment13 in varchar2 default null
,p_segment14 in varchar2 default null
,p_segment15 in varchar2 default null
,p_segment16 in varchar2 default null
,p_segment17 in varchar2 default null
,p_segment18 in varchar2 default null
,p_segment19 in varchar2 default null
,p_segment20 in varchar2 default null
,p_segment21 in varchar2 default null
,p_segment22 in varchar2 default null
,p_segment23 in varchar2 default null
,p_segment24 in varchar2 default null
,p_segment25 in varchar2 default null
,p_segment26 in varchar2 default null
,p_segment27 in varchar2 default null
,p_segment28 in varchar2 default null
,p_segment29 in varchar2 default null
,p_segment30 in varchar2 default null
,p_ppm_information_category in varchar2 default null
,p_ppm_information1 in varchar2 default null
,p_ppm_information2 in varchar2 default null
,p_ppm_information3 in varchar2 default null
,p_ppm_information4 in varchar2 default null
,p_ppm_information5 in varchar2 default null
,p_ppm_information6 in varchar2 default null
,p_ppm_information7 in varchar2 default null
,p_ppm_information8 in varchar2 default null
,p_ppm_information9 in varchar2 default null
,p_ppm_information10 in varchar2 default null
,p_ppm_information11 in varchar2 default null
,p_ppm_information12 in varchar2 default null
,p_ppm_information13 in varchar2 default null
,p_ppm_information14 in varchar2 default null
,p_ppm_information15 in varchar2 default null
,p_ppm_information16 in varchar2 default null
,p_ppm_information17 in varchar2 default null
,p_ppm_information18 in varchar2 default null
,p_ppm_information19 in varchar2 default null
,p_ppm_information20 in varchar2 default null
,p_ppm_information21 in varchar2 default null
,p_ppm_information22 in varchar2 default null
,p_ppm_information23 in varchar2 default null
,p_ppm_information24 in varchar2 default null
,p_ppm_information25 in varchar2 default null
,p_ppm_information26 in varchar2 default null
,p_ppm_information27 in varchar2 default null
,p_ppm_information28 in varchar2 default null
,p_ppm_information29 in varchar2 default null
,p_ppm_information30 in varchar2 default null
,p_return_status out nocopy varchar2
,p_msg_count out nocopy number
,p_msg_data out nocopy varchar2
) is
--
-- Cursor to get business_group_id from assignment_id and
-- effective_date. This is required for the INSERT operation.
--
cursor csr_asg_busgrp
(p_assignment_id in number
,p_effective_date in date
) is
select asg.business_group_id
from per_all_assignments_f asg
where asg.assignment_id = p_assignment_id
and p_effective_date between
asg.effective_start_date and asg.effective_end_date
;
select ppm.business_group_id
from pay_personal_payment_methods_f ppm
where ppm.personal_payment_method_id = p_personal_payment_method_id
and p_effective_date between
ppm.effective_start_date and ppm.effective_end_date
;
l_datetrack_mode := hr_api.g_insert;
elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
seterrorstage(l_proc, 'C_STATE_UPDATED', 20);
l_datetrack_mode := p_update_datetrack_mode;
elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
--
-- Check for (fatal) business_group_id error. If this error
-- occurs then the module is broken.
--
seterrorstage(l_proc, 'PPM_BUSGRPID', 90);
elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
--
-- Do the record locking. If this code fails then it is fatal
-- error within the module.
--
seterrorstage(l_proc, 'UPD:INITIAL', 120);
seterrorstage(l_proc, 'CHK_NON_UPDATEABLE', 130);
pay_ppm_bus.check_non_updateable_args
(p_rec => l_rec
,p_effective_date => p_effective_date
);
,p_delete_ovn in number default null
,p_update_datetrack_mode in varchar2 default null
,p_delete_datetrack_mode in varchar2 default null
,p_effective_date in date default null
,p_org_payment_method_id in number default null
,p_assignment_id in number default null
,p_run_type_id in number default null
,p_territory_code in varchar2 default null
,p_real_priority in number default null
,p_amount_type in varchar2 default null
,p_amount in number default null
,p_attribute_category in varchar2 default null
,p_attribute1 in varchar2 default null
,p_attribute2 in varchar2 default null
,p_attribute3 in varchar2 default null
,p_attribute4 in varchar2 default null
,p_attribute5 in varchar2 default null
,p_attribute6 in varchar2 default null
,p_attribute7 in varchar2 default null
,p_attribute8 in varchar2 default null
,p_attribute9 in varchar2 default null
,p_attribute10 in varchar2 default null
,p_attribute11 in varchar2 default null
,p_attribute12 in varchar2 default null
,p_attribute13 in varchar2 default null
,p_attribute14 in varchar2 default null
,p_attribute15 in varchar2 default null
,p_attribute16 in varchar2 default null
,p_attribute17 in varchar2 default null
,p_attribute18 in varchar2 default null
,p_attribute19 in varchar2 default null
,p_attribute20 in varchar2 default null
,p_segment1 in varchar2 default null
,p_segment2 in varchar2 default null
,p_segment3 in varchar2 default null
,p_segment4 in varchar2 default null
,p_segment5 in varchar2 default null
,p_segment6 in varchar2 default null
,p_segment7 in varchar2 default null
,p_segment8 in varchar2 default null
,p_segment9 in varchar2 default null
,p_segment10 in varchar2 default null
,p_segment11 in varchar2 default null
,p_segment12 in varchar2 default null
,p_segment13 in varchar2 default null
,p_segment14 in varchar2 default null
,p_segment15 in varchar2 default null
,p_segment16 in varchar2 default null
,p_segment17 in varchar2 default null
,p_segment18 in varchar2 default null
,p_segment19 in varchar2 default null
,p_segment20 in varchar2 default null
,p_segment21 in varchar2 default null
,p_segment22 in varchar2 default null
,p_segment23 in varchar2 default null
,p_segment24 in varchar2 default null
,p_segment25 in varchar2 default null
,p_segment26 in varchar2 default null
,p_segment27 in varchar2 default null
,p_segment28 in varchar2 default null
,p_segment29 in varchar2 default null
,p_segment30 in varchar2 default null
,p_o_real_priority in number default null
,p_validate in boolean default false
,p_ppm_information_category in varchar2 default null
,p_ppm_information1 in varchar2 default null
,p_ppm_information2 in varchar2 default null
,p_ppm_information3 in varchar2 default null
,p_ppm_information4 in varchar2 default null
,p_ppm_information5 in varchar2 default null
,p_ppm_information6 in varchar2 default null
,p_ppm_information7 in varchar2 default null
,p_ppm_information8 in varchar2 default null
,p_ppm_information9 in varchar2 default null
,p_ppm_information10 in varchar2 default null
,p_ppm_information11 in varchar2 default null
,p_ppm_information12 in varchar2 default null
,p_ppm_information13 in varchar2 default null
,p_ppm_information14 in varchar2 default null
,p_ppm_information15 in varchar2 default null
,p_ppm_information16 in varchar2 default null
,p_ppm_information17 in varchar2 default null
,p_ppm_information18 in varchar2 default null
,p_ppm_information19 in varchar2 default null
,p_ppm_information20 in varchar2 default null
,p_ppm_information21 in varchar2 default null
,p_ppm_information22 in varchar2 default null
,p_ppm_information23 in varchar2 default null
,p_ppm_information24 in varchar2 default null
,p_ppm_information25 in varchar2 default null
,p_ppm_information26 in varchar2 default null
,p_ppm_information27 in varchar2 default null
,p_ppm_information28 in varchar2 default null
,p_ppm_information29 in varchar2 default null
,p_ppm_information30 in varchar2 default null
) is
l_effective_date date;
select parameter_value
into v_check_value
from pay_action_parameters pap
where pap.parameter_name = 'PPM_PERC_GTR_100';
elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
l_percentage := hr_api.g_number;
elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
seterrorstage(l_proc, 'Calling ...hr_personal_pay_method_api.update_personal_pay_method', 30);
hr_personal_pay_method_api.update_personal_pay_method
(p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_update_mode => p_update_datetrack_mode
,p_personal_payment_method_id => p_personal_payment_method_id
,p_object_version_number => l_object_version_number
,p_amount => l_amount
,p_percentage => l_percentage
,p_priority => p_real_priority
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_territory_code => p_territory_code
,p_segment1 => p_segment1
,p_segment2 => p_segment2
,p_segment3 => p_segment3
,p_segment4 => p_segment4
,p_segment5 => p_segment5
,p_segment6 => p_segment6
,p_segment7 => p_segment7
,p_segment8 => p_segment8
,p_segment9 => p_segment9
,p_segment10 => p_segment10
,p_segment11 => p_segment11
,p_segment12 => p_segment12
,p_segment13 => p_segment13
,p_segment14 => p_segment14
,p_segment15 => p_segment15
,p_segment16 => p_segment16
,p_segment17 => p_segment17
,p_segment18 => p_segment18
,p_segment19 => p_segment19
,p_segment20 => p_segment20
,p_segment21 => p_segment21
,p_segment22 => p_segment22
,p_segment23 => p_segment23
,p_segment24 => p_segment24
,p_segment25 => p_segment25
,p_segment26 => p_segment26
,p_segment27 => p_segment27
,p_segment28 => p_segment28
,p_segment29 => p_segment29
,p_segment30 => p_segment30
,p_ppm_information_category => p_ppm_information_category
,p_ppm_information1 => p_ppm_information1
,p_ppm_information2 => p_ppm_information2
,p_ppm_information3 => p_ppm_information3
,p_ppm_information4 => p_ppm_information4
,p_ppm_information5 => p_ppm_information5
,p_ppm_information6 => p_ppm_information6
,p_ppm_information7 => p_ppm_information7
,p_ppm_information8 => p_ppm_information8
,p_ppm_information9 => p_ppm_information9
,p_ppm_information10 => p_ppm_information10
,p_ppm_information11 => p_ppm_information11
,p_ppm_information12 => p_ppm_information12
,p_ppm_information13 => p_ppm_information13
,p_ppm_information14 => p_ppm_information14
,p_ppm_information15 => p_ppm_information15
,p_ppm_information16 => p_ppm_information16
,p_ppm_information17 => p_ppm_information17
,p_ppm_information18 => p_ppm_information18
,p_ppm_information19 => p_ppm_information19
,p_ppm_information20 => p_ppm_information20
,p_ppm_information21 => p_ppm_information21
,p_ppm_information22 => p_ppm_information22
,p_ppm_information23 => p_ppm_information23
,p_ppm_information24 => p_ppm_information24
,p_ppm_information25 => p_ppm_information25
,p_ppm_information26 => p_ppm_information26
,p_ppm_information27 => p_ppm_information27
,p_ppm_information28 => p_ppm_information28
,p_ppm_information29 => p_ppm_information29
,p_ppm_information30 => p_ppm_information30
,p_external_account_id => l_external_account_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_comment_id => l_comment_id
);
elsif p_state = pay_pss_tx_steps_pkg.C_STATE_DELETED then
l_object_version_number := p_delete_ovn;
if p_delete_datetrack_mode = hr_api.g_zap then
l_effective_date := p_effective_date;
seterrorstage(l_proc,'Calling ...hr_personal_pay_method_api.delete_personal_pay_method',40);
hr_personal_pay_method_api.delete_personal_pay_method
(p_validate => p_validate
,p_effective_date => l_effective_date
,p_datetrack_delete_mode => p_delete_datetrack_mode
,p_personal_payment_method_id => p_personal_payment_method_id
,p_object_version_number => l_object_version_number
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
);
seterrorstage(l_proc,'Calling ...hr_personal_pay_method_api.update_personal_pay_method',50);
hr_personal_pay_method_api.update_personal_pay_method
(p_validate => p_validate
,p_personal_payment_method_id => p_personal_payment_method_id
,p_object_version_number => l_object_version_number
,p_effective_date => p_effective_date
,p_datetrack_update_mode => p_update_datetrack_mode
,p_priority => p_real_priority
,p_external_account_id => l_external_account_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_comment_id => l_comment_id
);
select segment1
, segment2
, segment3
, segment4
, segment5
, segment6
, segment7
, segment8
, segment9
, segment10
, segment11
, segment12
, segment13
, segment14
, segment15
, segment16
, segment17
, segment18
, segment19
, segment20
, segment21
, segment22
, segment23
, segment24
, segment25
, segment26
, segment27
, segment28
, segment29
, segment30
into p_segment1
, p_segment2
, p_segment3
, p_segment4
, p_segment5
, p_segment6
, p_segment7
, p_segment8
, p_segment9
, p_segment10
, p_segment11
, p_segment12
, p_segment13
, p_segment14
, p_segment15
, p_segment16
, p_segment17
, p_segment18
, p_segment19
, p_segment20
, p_segment21
, p_segment22
, p_segment23
, p_segment24
, p_segment25
, p_segment26
, p_segment27
, p_segment28
, p_segment29
, p_segment30
from pay_external_accounts
where external_account_id = p_external_account_id;