[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE pre_insert
(p_rec IN OUT NOCOPY pay_naf_shd.g_rec_type) IS
l_proc varchar2(72) DEFAULT g_package
|| 'pre_insert';
SELECT pay_no_altinn_transfers_s.nextval
FROM sys.dual;
END pre_insert;
PROCEDURE post_insert
(p_rec IN pay_naf_shd.g_rec_type) IS
l_proc varchar2(72) DEFAULT g_package
|| 'post_insert';
END post_insert;
PROCEDURE insert_dml
(p_rec IN OUT NOCOPY pay_naf_shd.g_rec_type) IS
l_proc varchar2(72) DEFAULT g_package
|| 'insert_dml';
INSERT
INTO pay_no_altinn_transfers
(transfer_id
,transfer_status
,concurrent_request_id
,payroll_action_id
,report_name
,run_effective_date
,shipment_reference
,organization_id
,business_group_id
,receipt_id
,receipt_status
,receipt_text
,receipt_last_updated
,alt_element_id
,alt_archive_ref
,curr_state
,next_state
,object_version_number
,tfr_information_category
,tfr_information1
,tfr_information2
,tfr_information3
,tfr_information4
,tfr_information5
,tfr_information6
,tfr_information7
,tfr_information8
,tfr_information9
,tfr_information10
,tfr_information11
,tfr_information12
,tfr_information13
,tfr_information14
,tfr_information15
,tfr_information16
,tfr_information17
,tfr_information18
,tfr_information19
,tfr_information20)
VALUES
(p_rec.transfer_id
,p_rec.transfer_status
,p_rec.concurrent_request_id
,p_rec.payroll_action_id
,p_rec.report_name
,p_rec.run_effective_date
,p_rec.shipment_reference
,p_rec.organization_id
,p_rec.business_group_id
,p_rec.receipt_id
,p_rec.receipt_status
,p_rec.receipt_text
,p_rec.receipt_last_updated
,p_rec.alt_element_id
,p_rec.alt_archive_ref
,p_rec.curr_state
,p_rec.next_state
,p_rec.object_version_number
,p_rec.tfr_information_category
,p_rec.tfr_information1
,p_rec.tfr_information2
,p_rec.tfr_information3
,p_rec.tfr_information4
,p_rec.tfr_information5
,p_rec.tfr_information6
,p_rec.tfr_information7
,p_rec.tfr_information8
,p_rec.tfr_information9
,p_rec.tfr_information10
,p_rec.tfr_information11
,p_rec.tfr_information12
,p_rec.tfr_information13
,p_rec.tfr_information14
,p_rec.tfr_information15
,p_rec.tfr_information16
,p_rec.tfr_information17
,p_rec.tfr_information18
,p_rec.tfr_information19
,p_rec.tfr_information20);
END insert_dml;
pay_naf_bus.insert_validate (p_rec);
pre_insert (p_rec);
insert_dml (p_rec);
post_insert (p_rec);
,p_reciept_last_updated IN date DEFAULT NULL
,p_alt_element_id IN number DEFAULT NULL
,p_alt_archive_referencce IN varchar2 DEFAULT NULL
,p_curr_state IN varchar2 DEFAULT NULL
,p_next_state IN varchar2 DEFAULT NULL
,p_tfr_information_category IN varchar2 DEFAULT NULL
,p_tfr_information1 IN varchar2 DEFAULT NULL
,p_tfr_information2 IN varchar2 DEFAULT NULL
,p_tfr_information3 IN varchar2 DEFAULT NULL
,p_tfr_information4 IN varchar2 DEFAULT NULL
,p_tfr_information5 IN varchar2 DEFAULT NULL
,p_tfr_information6 IN varchar2 DEFAULT NULL
,p_tfr_information7 IN varchar2 DEFAULT NULL
,p_tfr_information8 IN varchar2 DEFAULT NULL
,p_tfr_information9 IN varchar2 DEFAULT NULL
,p_tfr_information10 IN varchar2 DEFAULT NULL
,p_tfr_information11 IN varchar2 DEFAULT NULL
,p_tfr_information12 IN varchar2 DEFAULT NULL
,p_tfr_information13 IN varchar2 DEFAULT NULL
,p_tfr_information14 IN varchar2 DEFAULT NULL
,p_tfr_information15 IN varchar2 DEFAULT NULL
,p_tfr_information16 IN varchar2 DEFAULT NULL
,p_tfr_information17 IN varchar2 DEFAULT NULL
,p_tfr_information18 IN varchar2 DEFAULT NULL
,p_tfr_information19 IN varchar2 DEFAULT NULL
,p_tfr_information20 IN varchar2 DEFAULT NULL
,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_referencce
,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_information5
,p_tfr_information16
,p_tfr_information17
,p_tfr_information18
,p_tfr_information19
,p_tfr_information20);