[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF (p_rec.receipt_last_updated = hr_api.g_date) THEN
p_rec.receipt_last_updated := pay_naf_shd.g_old_rec.receipt_last_updated;
PROCEDURE pre_update
(p_rec IN pay_naf_shd.g_rec_type) IS
l_proc varchar2(72) DEFAULT g_package
|| 'pre_update';
END pre_update;
PROCEDURE update_dml
(p_rec IN OUT NOCOPY pay_naf_shd.g_rec_type) IS
l_proc varchar2(72) DEFAULT g_package
|| 'update_dml';
hr_utility.set_location ('update_dml:'
|| p_rec.transfer_id
|| '-'
,5);
UPDATE pay_no_altinn_transfers
SET transfer_status = p_rec.transfer_status
,concurrent_request_id = p_rec.concurrent_request_id
,payroll_action_id = p_rec.payroll_action_id
,report_name = p_rec.report_name
,run_effective_date = p_rec.run_effective_date
,shipment_reference = p_rec.shipment_reference
,receipt_id = p_rec.receipt_id
,receipt_status = p_rec.receipt_status
,receipt_text = p_rec.receipt_text
,receipt_last_updated = p_rec.receipt_last_updated
,alt_element_id = p_rec.alt_element_id
,alt_archive_ref = p_rec.alt_archive_ref
,object_version_number = p_rec.object_version_number
,curr_state = p_rec.curr_state
,next_state = p_rec.next_state
,tfr_information1 = p_rec.tfr_information1
,tfr_information2 = p_rec.tfr_information2
,tfr_information3 = p_rec.tfr_information3
,tfr_information4 = p_rec.tfr_information4
,tfr_information5 = p_rec.tfr_information5
,tfr_information6 = p_rec.tfr_information6
,tfr_information7 = p_rec.tfr_information7
,tfr_information8 = p_rec.tfr_information8
,tfr_information9 = p_rec.tfr_information9
,tfr_information10 = p_rec.tfr_information10
,tfr_information11 = p_rec.tfr_information11
,tfr_information12 = p_rec.tfr_information12
,tfr_information13 = p_rec.tfr_information13
,tfr_information14 = p_rec.tfr_information14
,tfr_information15 = p_rec.tfr_information15
,tfr_information16 = p_rec.tfr_information16
,tfr_information17 = p_rec.tfr_information17
,tfr_information18 = p_rec.tfr_information18
,tfr_information19 = p_rec.tfr_information19
,tfr_information20 = p_rec.tfr_information20
WHERE transfer_id = p_rec.transfer_id;
END update_dml;
PROCEDURE post_update
(p_rec IN pay_naf_shd.g_rec_type) IS
l_proc varchar2(72) DEFAULT g_package
|| 'post_update';
END post_update;
pay_naf_bus.update_validate (p_rec);
pre_update (p_rec);
update_dml (p_rec);
post_update (p_rec);
,p_reciept_last_updated IN date DEFAULT hr_api.g_date
,p_alt_element_id IN number DEFAULT hr_api.g_number
,p_alt_archive_ref IN varchar2 DEFAULT hr_api.g_varchar2
,p_curr_state IN varchar2 DEFAULT hr_api.g_varchar2
,p_next_state IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information_category IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information1 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information2 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information3 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information4 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information5 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information6 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information7 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information8 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information9 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information10 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information11 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information12 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information13 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information14 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information15 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information16 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information17 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information18 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information19 IN varchar2 DEFAULT hr_api.g_varchar2
,p_tfr_information20 IN varchar2 DEFAULT hr_api.g_varchar2
,p_validate IN boolean DEFAULT FALSE) IS
l_rec pay_naf_shd.g_rec_type;
,p_reciept_last_updated
,p_alt_element_id
,p_alt_archive_ref
,p_curr_state
,p_next_state
,p_object_version_number
,p_tfr_information_category
,p_tfr_information1
,p_tfr_information2
,p_tfr_information3
,p_tfr_information4
,p_tfr_information5
,p_tfr_information6
,p_tfr_information7
,p_tfr_information8
,p_tfr_information9
,p_tfr_information10
,p_tfr_information11
,p_tfr_information12
,p_tfr_information13
,p_tfr_information14
,p_tfr_information15
,p_tfr_information16
,p_tfr_information17
,p_tfr_information18
,p_tfr_information19
,p_tfr_information20);