[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure delete_row ( p_rowid varchar2) is
begin
delete from pay_payroll_actions
where rowid = p_rowid;
end delete_row;
procedure insert_row ( p_rowid IN out nocopy varchar2,
p_payroll_action_id IN out nocopy number,
p_action_type varchar2,
p_business_group_id number,
p_consolidation_set_id number,
p_payroll_id number,
p_action_population_status varchar2,
p_action_status varchar2,
p_effective_date date,
p_comments varchar2,
p_legislative_parameters varchar2,
p_run_type_id number,
p_element_set_id number,
p_assignment_set_id number,
p_date_earned date,
p_display_run_number number,
p_pay_advice_date date,
p_pay_advice_message varchar2,
p_attribute_category varchar2,
p_attribute1 varchar2, p_attribute2 varchar2,
p_attribute3 varchar2, p_attribute4 varchar2,
p_attribute5 varchar2, p_attribute6 varchar2,
p_attribute7 varchar2, p_attribute8 varchar2,
p_attribute9 varchar2, p_attribute10 varchar2,
p_attribute11 varchar2, p_attribute12 varchar2,
p_attribute13 varchar2, p_attribute14 varchar2,
p_attribute15 varchar2, p_attribute16 varchar2,
p_attribute17 varchar2, p_attribute18 varchar2,
p_attribute19 varchar2, p_attribute20 varchar2 ) is
cursor c1 is
select pay_payroll_actions_s.nextval
from sys.dual;
select rowid
from pay_payroll_actions
where payroll_action_id = p_payroll_action_id;
insert into pay_payroll_actions ( payroll_action_id,
action_type,
business_group_id,
consolidation_set_id,
payroll_id,
action_population_status,
action_status,
effective_date,
comments,
legislative_parameters,
run_type_id,
element_set_id,
assignment_set_id,
date_earned,
display_run_number,
pay_advice_date,
pay_advice_message,
attribute_category,
attribute1, attribute2,
attribute3, attribute4,
attribute5, attribute6,
attribute7, attribute8,
attribute9, attribute10,
attribute11, attribute12,
attribute13, attribute14,
attribute15, attribute16,
attribute17, attribute18,
attribute19, attribute20 )
values ( p_payroll_action_id,
p_action_type,
p_business_group_id,
p_consolidation_set_id,
p_payroll_id,
p_action_population_status,
p_action_status,
p_effective_date,
p_comments,
p_legislative_parameters,
p_run_type_id,
p_element_set_id,
p_assignment_set_id,
p_date_earned,
p_display_run_number,
p_pay_advice_date,
p_pay_advice_message,
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 );
end insert_row;
select *
from pay_payroll_actions
where rowid = p_rowid for update of payroll_action_id nowait;
procedure update_row ( p_rowid IN varchar2,
p_payroll_action_id number,
p_action_type varchar2,
p_business_group_id number,
p_consolidation_set_id number,
p_payroll_id number,
p_action_population_status varchar2,
p_action_status varchar2,
p_effective_date date,
p_comments varchar2,
p_legislative_parameters varchar2,
p_run_type_id number,
p_element_set_id number,
p_assignment_set_id number,
p_date_earned date,
p_display_run_number number,
p_pay_advice_date date,
p_pay_advice_message varchar2,
p_attribute_category varchar2,
p_attribute1 varchar2, p_attribute2 varchar2,
p_attribute3 varchar2, p_attribute4 varchar2,
p_attribute5 varchar2, p_attribute6 varchar2,
p_attribute7 varchar2, p_attribute8 varchar2,
p_attribute9 varchar2, p_attribute10 varchar2,
p_attribute11 varchar2, p_attribute12 varchar2,
p_attribute13 varchar2, p_attribute14 varchar2,
p_attribute15 varchar2, p_attribute16 varchar2,
p_attribute17 varchar2, p_attribute18 varchar2,
p_attribute19 varchar2, p_attribute20 varchar2 ) is
begin
update pay_payroll_actions
set payroll_action_id = p_payroll_action_id,
action_type = p_action_type,
business_group_id = p_business_group_id,
consolidation_set_id = p_consolidation_set_id,
payroll_id = p_payroll_id,
action_population_status = action_population_status,
action_status = p_action_status,
effective_date = p_effective_date,
comments = p_comments,
legislative_parameters = p_legislative_parameters,
run_type_id = p_run_type_id,
element_set_id = p_element_set_id,
assignment_set_id = p_assignment_set_id,
date_earned = p_date_earned,
display_run_number = p_display_run_number,
pay_advice_date = p_pay_advice_date,
pay_advice_message = p_pay_advice_message,
attribute_category = p_attribute_category,
attribute1 = p_attribute1,
attribute2 = p_attribute2,
attribute3 = p_attribute3,
attribute4 = p_attribute4,
attribute5 = p_attribute5,
attribute6 = p_attribute6,
attribute7 = p_attribute7,
attribute8 = p_attribute8,
attribute9 = p_attribute9,
attribute10 = p_attribute10,
attribute11 = p_attribute11,
attribute12 = p_attribute12,
attribute13 = p_attribute13,
attribute14 = p_attribute14,
attribute15 = p_attribute15,
attribute16 = p_attribute16,
attribute17 = p_attribute17,
attribute18 = p_attribute18,
attribute19 = p_attribute19,
attribute20 = p_attribute20
where rowid = p_rowid;
end update_row;