[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_row
(p_rowid in out nocopy varchar2
,p_batch_element_link_id in out nocopy number
,p_element_link_id in number
,p_effective_date in date
,p_payroll_id in number
,p_job_id in number
,p_position_id in number
,p_people_group_id in number
,p_cost_allocation_keyflex_id in number
,p_organization_id in number
,p_element_type_id in number
,p_location_id in number
,p_grade_id in number
,p_balancing_keyflex_id in number
,p_business_group_id in number
,p_element_set_id in number
,p_pay_basis_id in number
,p_costable_type in varchar2
,p_link_to_all_payrolls_flag in varchar2
,p_multiply_value_flag in varchar2
,p_standard_link_flag in varchar2
,p_transfer_to_gl_flag in varchar2
,p_comment_id in number
,p_employment_category in varchar2
,p_qualifying_age in number
,p_qualifying_length_of_service in number
,p_qualifying_units in varchar2
,p_attribute_category in varchar2
,p_attribute1 in varchar2
,p_attribute2 in varchar2
,p_attribute3 in varchar2
,p_attribute4 in varchar2
,p_attribute5 in varchar2
,p_attribute6 in varchar2
,p_attribute7 in varchar2
,p_attribute8 in varchar2
,p_attribute9 in varchar2
,p_attribute10 in varchar2
,p_attribute11 in varchar2
,p_attribute12 in varchar2
,p_attribute13 in varchar2
,p_attribute14 in varchar2
,p_attribute15 in varchar2
,p_attribute16 in varchar2
,p_attribute17 in varchar2
,p_attribute18 in varchar2
,p_attribute19 in varchar2
,p_attribute20 in varchar2
,p_object_status in varchar2
)
is
cursor csr_new_rowid is
select rowid
from pay_batch_element_links
where batch_element_link_id = p_batch_element_link_id
;
select pay_element_links_s.nextval
from sys.dual;
l_proc varchar2(72):= 'pay_batch_element_link_pkg.insert_row';
insert into pay_batch_element_links(
--
batch_element_link_id,
effective_date,
element_link_id,
payroll_id,
job_id,
position_id,
people_group_id,
cost_allocation_keyflex_id,
organization_id,
element_type_id,
location_id,
grade_id,
balancing_keyflex_id,
business_group_id,
element_set_id,
pay_basis_id,
costable_type,
link_to_all_payrolls_flag,
multiply_value_flag,
standard_link_flag,
transfer_to_gl_flag,
comment_id,
employment_category,
qualifying_age,
qualifying_length_of_service,
qualifying_units,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20)
values (
p_batch_element_link_id,
p_effective_date,
p_element_link_id,
p_payroll_id,
p_job_id,
p_position_id,
p_people_group_id,
p_cost_allocation_keyflex_id,
p_organization_id,
p_element_type_id,
p_location_id,
p_grade_id,
p_balancing_keyflex_id,
p_business_group_id,
p_element_set_id,
p_pay_basis_id,
p_costable_type,
p_link_to_all_payrolls_flag,
p_multiply_value_flag,
p_standard_link_flag,
p_transfer_to_gl_flag,
p_comment_id,
p_employment_category,
p_qualifying_age,
p_qualifying_length_of_service,
p_qualifying_units,
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_batch_element_links
where rowid = p_rowid
for update NOWAIT;
procedure update_row
(p_rowid in varchar2
,p_batch_element_link_id in number
,p_element_link_id in number
,p_effective_date in date
,p_payroll_id in number
,p_job_id in number
,p_position_id in number
,p_people_group_id in number
,p_cost_allocation_keyflex_id in number
,p_organization_id in number
,p_element_type_id in number
,p_location_id in number
,p_grade_id in number
,p_balancing_keyflex_id in number
,p_business_group_id in number
,p_element_set_id in number
,p_pay_basis_id in number
,p_costable_type in varchar2
,p_link_to_all_payrolls_flag in varchar2
,p_multiply_value_flag in varchar2
,p_standard_link_flag in varchar2
,p_transfer_to_gl_flag in varchar2
,p_comment_id in number
,p_employment_category in varchar2
,p_qualifying_age in number
,p_qualifying_length_of_service in number
,p_qualifying_units in varchar2
,p_attribute_category in varchar2
,p_attribute1 in varchar2
,p_attribute2 in varchar2
,p_attribute3 in varchar2
,p_attribute4 in varchar2
,p_attribute5 in varchar2
,p_attribute6 in varchar2
,p_attribute7 in varchar2
,p_attribute8 in varchar2
,p_attribute9 in varchar2
,p_attribute10 in varchar2
,p_attribute11 in varchar2
,p_attribute12 in varchar2
,p_attribute13 in varchar2
,p_attribute14 in varchar2
,p_attribute15 in varchar2
,p_attribute16 in varchar2
,p_attribute17 in varchar2
,p_attribute18 in varchar2
,p_attribute19 in varchar2
,p_attribute20 in varchar2
)
is
--
l_proc varchar2(72):= 'pay_batch_element_link_pkg.update_row';
update pay_batch_element_links
set
batch_element_link_id = p_batch_element_link_id
,element_link_id = p_element_link_id
,effective_date = p_effective_date
,payroll_id = p_payroll_id
,job_id = p_job_id
,position_id = p_position_id
,people_group_id = p_people_group_id
,cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
,organization_id = p_organization_id
,element_type_id = p_element_type_id
,location_id = p_location_id
,grade_id = p_grade_id
,balancing_keyflex_id = p_balancing_keyflex_id
,business_group_id = p_business_group_id
,element_set_id = p_element_set_id
,pay_basis_id = p_pay_basis_id
,costable_type = p_costable_type
,link_to_all_payrolls_flag = p_link_to_all_payrolls_flag
,multiply_value_flag = p_multiply_value_flag
,standard_link_flag = p_standard_link_flag
,transfer_to_gl_flag = p_transfer_to_gl_flag
,comment_id = p_comment_id
,employment_category = p_employment_category
,qualifying_age = p_qualifying_age
,qualifying_length_of_service = p_qualifying_length_of_service
,qualifying_units = p_qualifying_units
,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;
procedure delete_row
(p_rowid in varchar2
)
is
--
l_batch_element_link_id number;
l_proc varchar2(72):= 'pay_batch_element_link_pkg.delete_row';
select batch_element_link_id into l_batch_element_link_id
from pay_batch_element_links
where rowid = p_rowid;
pay_batch_object_status_pkg.delete_object_status
(p_object_type => 'BEL'
,p_object_id => l_batch_element_link_id
,p_payroll_action_id => null
);
delete from pay_batch_element_links
where rowid = p_rowid;
end delete_row;