The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hsc.soft_coding_keyflex_id
from hr_soft_coding_keyflex hsc
where hsc.soft_coding_keyflex_id = p_soft_coding_keyflex_id;
select s.soft_coding_keyflex_id
into v_soft_coding_keyflex_id
from hr_soft_coding_keyflex s
where s.id_flex_num = p_scl_structure
and s.enabled_flag = 'Y'
and (s.segment1 = p_segment1
or (s.segment1 is null
and p_segment1 is null))
and (s.segment2 = p_segment2
or (s.segment2 is null
and p_segment2 is null))
and (s.segment3 = p_segment3
or (s.segment3 is null
and p_segment3 is null))
and (s.segment4 = p_segment4
or (s.segment4 is null
and p_segment4 is null))
and (s.segment5 = p_segment5
or (s.segment5 is null
and p_segment5 is null))
and (s.segment6 = p_segment6
or (s.segment6 is null
and p_segment6 is null))
and (s.segment7 = p_segment7
or (s.segment7 is null
and p_segment7 is null))
and (s.segment8 = p_segment8
or (s.segment8 is null
and p_segment8 is null))
and (s.segment9 = p_segment9
or (s.segment9 is null
and p_segment9 is null))
and (s.segment10 = p_segment10
or (s.segment10 is null
and p_segment10 is null))
and (s.segment11 = p_segment11
or (s.segment11 is null
and p_segment11 is null))
and (s.segment12 = p_segment12
or (s.segment12 is null
and p_segment12 is null))
and (s.segment13 = p_segment13
or (s.segment13 is null
and p_segment13 is null))
and (s.segment14 = p_segment14
or (s.segment14 is null
and p_segment14 is null))
and (s.segment15 = p_segment15
or (s.segment15 is null
and p_segment15 is null))
and (s.segment16 = p_segment16
or (s.segment16 is null
and p_segment16 is null))
and (s.segment17 = p_segment17
or (s.segment17 is null
and p_segment17 is null))
and (s.segment18 = p_segment18
or (s.segment18 is null
and p_segment18 is null))
and (s.segment19 = p_segment19
or (s.segment19 is null
and p_segment19 is null))
and (s.segment20 = p_segment20
or (s.segment20 is null
and p_segment20 is null))
and (s.segment21 = p_segment21
or (s.segment21 is null
and p_segment21 is null))
and (s.segment22 = p_segment22
or (s.segment22 is null
and p_segment22 is null))
and (s.segment23 = p_segment23
or (s.segment23 is null
and p_segment23 is null))
and (s.segment24 = p_segment24
or (s.segment24 is null
and p_segment24 is null))
and (s.segment25 = p_segment25
or (s.segment25 is null
and p_segment25 is null))
and (s.segment26 = p_segment26
or (s.segment26 is null
and p_segment26 is null))
and (s.segment27 = p_segment27
or (s.segment27 is null
and p_segment27 is null))
and (s.segment28 = p_segment28
or (s.segment28 is null
and p_segment28 is null))
and (s.segment29 = p_segment29
or (s.segment29 is null
and p_segment29 is null))
and (s.segment30 = p_segment30
or (s.segment30 is null
and p_segment30 is null));
select hr_soft_coding_keyflex_s.nextval
into v_soft_coding_keyflex_id
from sys.dual;
insert into hr_soft_coding_keyflex
(soft_coding_keyflex_id
,concatenated_segments
,id_flex_num
,last_update_date
,last_updated_by
,summary_flag
,enabled_flag
,start_date_active
,end_date_active
,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)
values
(v_soft_coding_keyflex_id
,p_concatenated_segments
,p_scl_structure
,null
,null
,p_summary_flag
,'Y'
,p_start_date_active
,p_end_date_active
,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);
select prl.payroll_name,
prl.number_of_years,
prl.default_payment_method_id
from pay_payrolls_f prl
where prl.rowid = p_rowid;
select prl.payroll_id
from pay_payrolls_f prl
where prl.payroll_id = p_payroll_id
for update;
SELECT prl.payroll_id
from pay_all_payrolls_f prl
where upper(prl.payroll_name) = upper(p_payroll_name)
and (prl.payroll_id <> p_payroll_id or
p_payroll_id is null)
and prl.business_group_id + 0 = p_business_group_id;
select prl.payroll_name,
prl.number_of_years
from pay_payrolls_f prl
where prl.payroll_id = p_payroll_id
for update;
update pay_payrolls_f prl
set prl.payroll_name = nvl(p_payroll_name,
v_prl_rec.payroll_name),
prl.number_of_years = nvl(p_number_of_years,
v_prl_rec.number_of_years)
where current of csr_payroll_rows;
select bg.cost_allocation_structure
from per_business_groups bg
where bg.business_group_id + 0 = p_business_group_id;
select lr.rule_type,
lr.rule_mode
from pay_legislation_rules lr
where lr.legislation_code = p_legislation_code;
select lr.rule_type,
lr.rule_mode
from pay_legislative_field_info lr
where lr.legislation_code = p_legislation_code
and lr.field_name = 'PAYSLIP_VIEW_DATE'
and lr.rule_type = 'UPDATE';
select opm.effective_start_date,
opm.effective_end_date
from pay_org_payment_methods_f opm
where opm.org_payment_method_id = p_default_payment_method_id
order by opm.effective_start_date
for update;
select opmu.effective_start_date,
opmu.effective_end_date
from pay_org_pay_method_usages_f opmu
where opmu.payroll_id = p_payroll_id
and opmu.org_payment_method_id = p_default_payment_method_id
and opmu.effective_start_date <= p_validation_end_date
and opmu.effective_end_date >= p_validation_start_date
order by opmu.effective_start_date
for update;
v_insert_record boolean := TRUE;
v_insert_record := FALSE;
update pay_org_pay_method_usages_f opmu
set opmu.effective_end_date = p_validation_start_date - 1
where current of csr_payroll_opmu;
update pay_org_pay_method_usages_f opmu
set opmu.effective_start_date = p_validation_end_date + 1
where current of csr_payroll_opmu;
delete from pay_org_pay_method_usages_f
where current of csr_payroll_opmu;
if v_insert_record then
--
-- Create opmu to represent the default payment method selected for the
-- payroll.
insert into pay_org_pay_method_usages_f
(org_pay_method_usage_id,
effective_start_date,
effective_end_date,
payroll_id,
org_payment_method_id,
last_update_date,
last_updated_by,
last_update_login,
created_by,
creation_date)
values
(pay_org_pay_method_usages_s.nextval,
p_validation_start_date,
p_validation_end_date,
p_payroll_id,
p_default_payment_method_id,
trunc(sysdate),
0,
0,
0,
trunc(sysdate));
select *
from hr_soft_coding_keyflex kf
where exists
(select null
from hr_all_organization_units org
where org.organization_id = p_business_group_id
and org.soft_coding_keyflex_id = kf.soft_coding_keyflex_id);
procedure validate_insert_payroll
(
p_business_group_id number,
p_payroll_name varchar2,
p_default_payment_method_id number,
p_validation_start_date date,
p_validation_end_date date
) is
--
begin
-- Make sure payroll name is unique within the business group.
chk_payroll_unique
(null,
p_payroll_name,
p_business_group_id);
end validate_insert_payroll;
procedure insert_payroll
(
p_payroll_id number,
p_default_payment_method_id number,
p_validation_start_date date,
p_validation_end_date date
) is
--
begin
-- Create payroll time periods based on the payroll definition.
hr_payrolls.create_payroll_proc_periods
(p_payroll_id,
null, -- last_update_date
null, -- last_updated_by
null, -- last_update_login
null, -- created_by
null); -- creation_date
end insert_payroll;
procedure validate_update_payroll
(
p_business_group_id number,
p_payroll_id number,
p_payroll_name varchar2,
p_s_payroll_name varchar2,
p_default_payment_method_id number,
p_s_default_payment_method_id number,
p_validation_start_date date,
p_validation_end_date date
) is
--
begin
--
-- Make sure payroll name is unique within the business group.
if p_payroll_name <> p_s_payroll_name then
--
chk_payroll_unique
(p_payroll_id,
p_payroll_name,
p_business_group_id);
end validate_update_payroll;
procedure update_payroll
(
p_business_group_id number,
p_payroll_id number,
p_payroll_name varchar2,
p_s_payroll_name varchar2,
p_default_payment_method_id number,
p_s_default_payment_method_id number,
p_number_of_years number,
p_s_number_of_years number,
p_validation_start_date date,
p_validation_end_date date
) is
--
begin
--
-- Copy new payroll_name to all rows for the payroll ie,. this should not be
-- datetracked.
if p_payroll_name <> p_s_payroll_name then
--
propagate_changes
(p_payroll_id,
p_payroll_name,
null); -- number of years
null, -- last_update_date
null, -- last_updated_by
null, -- last_update_login
null, -- created_by
null); -- creation_date
end update_payroll;
procedure validate_delete_payroll
(
p_payroll_id number,
p_default_payment_method_id number,
p_dt_delete_mode varchar2,
p_validation_start_date date,
p_validation_end_date date
) is
--
cursor csr_chk_assignment is
select 'found'
from per_all_assignments_f asg
where asg.payroll_id = p_payroll_id
and asg.effective_start_date <= p_validation_end_date
and asg.effective_end_date >= p_validation_start_date;
select 'found'
from pay_element_links_f el
where el.payroll_id = p_payroll_id
and el.effective_start_date <= p_validation_end_date
and el.effective_end_date >= p_validation_start_date;
select 'found'
from hr_all_positions_f po
where po.pay_freq_payroll_id = p_payroll_id
and po.effective_start_date <= p_validation_end_date
and po.effective_end_date >= p_validation_start_date;
select 'found'
from pay_payroll_actions ppa
where ppa.payroll_id = p_payroll_id;
select 'found'
from hr_assignment_sets a
where a.payroll_id = p_payroll_id;
select 'found'
from pay_security_payrolls psp
where psp.payroll_id = p_payroll_id;
select 'found'
from pay_message_lines pml
where pml.payroll_id = p_payroll_id;
if p_dt_delete_mode = 'DELETE_NEXT_CHANGE' and
p_default_payment_method_id is not null then
--
validate_dflt_payment_method
(p_default_payment_method_id,
p_validation_start_date,
p_validation_end_date);
if p_dt_delete_mode in ('ZAP','DELETE') then
--
open csr_chk_assignment;
if p_dt_delete_mode = 'ZAP' then
--
open csr_chk_payroll_action;
end validate_delete_payroll;
procedure delete_payroll
(
p_payroll_id number,
p_default_payment_method_id number,
p_dt_delete_mode varchar2,
p_validation_start_date date,
p_validation_end_date date
) is
--
cursor csr_comment_rows_zap is
select com.comment_id
from pay_payrolls_f prl,
hr_comments com
where prl.payroll_id = p_payroll_id
and com.comment_id = prl.comment_id
for update of com.comment_id;
cursor csr_comment_rows_delete is
select com.comment_id
from pay_payrolls_f prl,
hr_comments com
where prl.payroll_id = p_payroll_id
and prl.effective_start_date >= p_validation_start_date
and com.comment_id = prl.comment_id
and not exists
(select null
from pay_payrolls_f prl2
where prl2.payroll_id = prl.payroll_id
and prl2.effective_start_date < p_validation_start_date
and prl2.comment_id = prl.comment_id)
for update of com.comment_id;
select max(tpe.end_date), min(tpe.start_date)
from per_time_periods tpe
where tpe.payroll_id = p_payroll_id;
if p_dt_delete_mode = 'ZAP' then
--
delete from per_time_periods tpe
where tpe.payroll_id = p_payroll_id;
delete from pay_org_pay_method_usages_f opu
where opu.payroll_id = p_payroll_id;
delete from pay_payroll_gl_flex_maps gfm
where gfm.payroll_id = p_payroll_id;
delete from hr_comments
where current of csr_comment_rows_zap;
hr_security.delete_payroll_from_list(p_payroll_id);
elsif p_dt_delete_mode = 'DELETE_NEXT_CHANGE' then
-- If default payment method is being extended then make sure that the
-- opmu is extended to represent the default payment method.
if p_default_payment_method_id is not null then
--
maintain_dflt_payment_method
(p_payroll_id,
p_default_payment_method_id,
p_validation_start_date,
p_validation_end_date);
null, -- last_update_date
null, -- last_updated_by
null, -- last_update_login
null, -- created_by
null); -- creation_date
elsif p_dt_delete_mode = 'DELETE' then
--
-- All opmu's for a payroll must exist within the lifetime of the payroll
-- so any opmus that exist outisde the new dates will be removed /
-- shortened.
delete from pay_org_pay_method_usages_f opu
where opu.payroll_id = p_payroll_id
and opu.effective_start_date >= p_validation_start_date;
update pay_org_pay_method_usages_f opu
set opu.effective_end_date = p_validation_start_date - 1
where opu.payroll_id = p_payroll_id
and opu.effective_end_date >= p_validation_start_date;
delete from per_time_periods tpe
where tpe.payroll_id = p_payroll_id
and tpe.end_date >= p_validation_start_date;
update pay_payrolls_f
set number_of_years =
round(months_between(l_last_period_end_date,l_first_period_start_date))/12
where payroll_id = p_payroll_id;
for v_com_rec in csr_comment_rows_delete loop
delete from hr_comments
where current of csr_comment_rows_delete;
end delete_payroll;
PROCEDURE Insert_Row(X_Rowid IN out nocopy VARCHAR2,
X_Payroll_Id IN out nocopy NUMBER,
X_Effective_Start_Date DATE,
X_Effective_End_Date DATE,
X_Default_Payment_Method_Id NUMBER,
X_Business_Group_Id NUMBER,
X_Consolidation_Set_Id NUMBER,
X_Cost_Allocation_Keyflex_Id NUMBER,
X_Suspense_Account_Keyflex_Id NUMBER,
X_Gl_Set_Of_Books_Id NUMBER,
X_Soft_Coding_Keyflex_Id NUMBER,
X_Period_Type VARCHAR2,
X_Organization_Id NUMBER,
X_Cut_Off_Date_Offset NUMBER,
X_Direct_Deposit_Date_Offset NUMBER,
X_First_Period_End_Date DATE,
X_Negative_Pay_Allowed_Flag VARCHAR2,
X_Number_Of_Years NUMBER,
X_Pay_Advice_Date_Offset NUMBER,
X_Pay_Date_Offset NUMBER,
X_Payroll_Name VARCHAR2,
X_Workload_Shifting_Level VARCHAR2,
X_Comment_Id NUMBER,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2,
-- Payroll Developer DF
X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
X_Prl_Information1 VARCHAR2 DEFAULT NULL,
X_Prl_Information2 VARCHAR2 DEFAULT NULL,
X_Prl_Information3 VARCHAR2 DEFAULT NULL,
X_Prl_Information4 VARCHAR2 DEFAULT NULL,
X_Prl_Information5 VARCHAR2 DEFAULT NULL,
X_Prl_Information6 VARCHAR2 DEFAULT NULL,
X_Prl_Information7 VARCHAR2 DEFAULT NULL,
X_Prl_Information8 VARCHAR2 DEFAULT NULL,
X_Prl_Information9 VARCHAR2 DEFAULT NULL,
X_Prl_Information10 VARCHAR2 DEFAULT NULL,
X_Prl_Information11 VARCHAR2 DEFAULT NULL,
X_Prl_Information12 VARCHAR2 DEFAULT NULL,
X_Prl_Information13 VARCHAR2 DEFAULT NULL,
X_Prl_Information14 VARCHAR2 DEFAULT NULL,
X_Prl_Information15 VARCHAR2 DEFAULT NULL,
X_Prl_Information16 VARCHAR2 DEFAULT NULL,
X_Prl_Information17 VARCHAR2 DEFAULT NULL,
X_Prl_Information18 VARCHAR2 DEFAULT NULL,
X_Prl_Information19 VARCHAR2 DEFAULT NULL,
X_Prl_Information20 VARCHAR2 DEFAULT NULL,
X_Prl_Information21 VARCHAR2 DEFAULT NULL,
X_Prl_Information22 VARCHAR2 DEFAULT NULL,
X_Prl_Information23 VARCHAR2 DEFAULT NULL,
X_Prl_Information24 VARCHAR2 DEFAULT NULL,
X_Prl_Information25 VARCHAR2 DEFAULT NULL,
X_Prl_Information26 VARCHAR2 DEFAULT NULL,
X_Prl_Information27 VARCHAR2 DEFAULT NULL,
X_Prl_Information28 VARCHAR2 DEFAULT NULL,
X_Prl_Information29 VARCHAR2 DEFAULT NULL,
X_Prl_Information30 VARCHAR2 DEFAULT NULL,
-- Extra Columns
X_Validation_Start_date DATE,
X_Validation_End_date DATE,
X_Arrears_Flag VARCHAR2,
X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
X_payslip_view_date_offset NUMBER DEFAULT NULL
) IS
--
CURSOR C IS SELECT rowid FROM PAY_ALL_PAYROLLS_F
WHERE payroll_id = X_Payroll_Id;
CURSOR C2 IS SELECT pay_payrolls_s.nextval FROM sys.dual;
pay_payrolls_f_pkg.validate_insert_payroll
(x_business_group_id,
x_payroll_name,
x_default_payment_method_id,
x_validation_start_date,
x_validation_end_date);
INSERT INTO PAY_PAYROLLS_F
(payroll_id,
effective_start_date,
effective_end_date,
default_payment_method_id,
business_group_id,
consolidation_set_id,
cost_allocation_keyflex_id,
suspense_account_keyflex_id,
gl_set_of_books_id,
soft_coding_keyflex_id,
period_type,
organization_id,
cut_off_date_offset,
direct_deposit_date_offset,
first_period_end_date,
midpoint_offset,
negative_pay_allowed_flag,
number_of_years,
pay_advice_date_offset,
pay_date_offset,
payroll_name,
workload_shifting_level,
comment_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
prl_information_category,
prl_information1,
prl_information2,
prl_information3,
prl_information4,
prl_information5,
prl_information6,
prl_information7,
prl_information8,
prl_information9,
prl_information10,
prl_information11,
prl_information12,
prl_information13,
prl_information14,
prl_information15,
prl_information16,
prl_information17,
prl_information18,
prl_information19,
prl_information20,
prl_information21,
prl_information22,
prl_information23,
prl_information24,
prl_information25,
prl_information26,
prl_information27,
prl_information28,
prl_information29,
prl_information30,
arrears_flag,
multi_assignments_flag,
period_reset_years,
payslip_view_date_offset)
VALUES
(X_Payroll_Id,
X_Effective_Start_Date,
X_Effective_End_Date,
X_Default_Payment_Method_Id,
X_Business_Group_Id,
X_Consolidation_Set_Id,
X_Cost_Allocation_Keyflex_Id,
X_Suspense_Account_Keyflex_Id,
X_Gl_Set_Of_Books_Id,
X_Soft_Coding_Keyflex_Id,
X_Period_Type,
X_Organization_Id,
X_Cut_Off_Date_Offset,
X_Direct_Deposit_Date_Offset,
X_First_Period_End_Date,
l_midpoint_offset,
X_Negative_Pay_Allowed_Flag,
X_Number_Of_Years,
X_Pay_Advice_Date_Offset,
X_Pay_Date_Offset,
X_Payroll_Name,
X_Workload_Shifting_Level,
X_Comment_Id,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Attribute16,
X_Attribute17,
X_Attribute18,
X_Attribute19,
X_Attribute20,
X_Prl_Information_Category,
X_Prl_Information1,
X_Prl_Information2,
X_Prl_Information3,
X_Prl_Information4,
X_Prl_Information5,
X_Prl_Information6,
X_Prl_Information7,
X_Prl_Information8,
X_Prl_Information9,
X_Prl_Information10,
X_Prl_Information11,
X_Prl_Information12,
X_Prl_Information13,
X_Prl_Information14,
X_Prl_Information15,
X_Prl_Information16,
X_Prl_Information17,
X_Prl_Information18,
X_Prl_Information19,
X_Prl_Information20,
X_Prl_Information21,
X_Prl_Information22,
X_Prl_Information23,
X_Prl_Information24,
X_Prl_Information25,
X_Prl_Information26,
X_Prl_Information27,
X_Prl_Information28,
X_Prl_Information29,
X_Prl_Information30,
X_Arrears_Flag,
X_Multi_Assignments_Flag,
X_Period_Reset_Years,
X_payslip_view_date_offset);
'pay_payrolls_f_pkg.insert_row');
pay_payrolls_f_pkg.insert_payroll
(x_payroll_id,
x_default_payment_method_id,
x_validation_start_date,
x_validation_end_date);
END Insert_Row;
PROCEDURE Insert_Row(X_Rowid IN out nocopy VARCHAR2,
X_Payroll_Id IN out nocopy NUMBER,
X_Default_Payment_Method_Id NUMBER,
X_Business_Group_Id NUMBER,
X_Consolidation_Set_Id NUMBER,
X_Cost_Allocation_Keyflex_Id NUMBER,
X_Suspense_Account_Keyflex_Id NUMBER,
X_Gl_Set_Of_Books_Id NUMBER,
X_Soft_Coding_Keyflex_Id NUMBER,
X_Period_Type VARCHAR2,
X_Organization_Id NUMBER,
X_Cut_Off_Date_Offset NUMBER,
X_Direct_Deposit_Date_Offset NUMBER,
X_First_Period_End_Date DATE,
X_Negative_Pay_Allowed_Flag VARCHAR2,
X_Number_Of_Years NUMBER,
X_Pay_Advice_Date_Offset NUMBER,
X_Pay_Date_Offset NUMBER,
X_Payroll_Name VARCHAR2,
X_Workload_Shifting_Level VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2,
-- Payroll Developer DF
X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
X_Prl_Information1 VARCHAR2 DEFAULT NULL,
X_Prl_Information2 VARCHAR2 DEFAULT NULL,
X_Prl_Information3 VARCHAR2 DEFAULT NULL,
X_Prl_Information4 VARCHAR2 DEFAULT NULL,
X_Prl_Information5 VARCHAR2 DEFAULT NULL,
X_Prl_Information6 VARCHAR2 DEFAULT NULL,
X_Prl_Information7 VARCHAR2 DEFAULT NULL,
X_Prl_Information8 VARCHAR2 DEFAULT NULL,
X_Prl_Information9 VARCHAR2 DEFAULT NULL,
X_Prl_Information10 VARCHAR2 DEFAULT NULL,
X_Prl_Information11 VARCHAR2 DEFAULT NULL,
X_Prl_Information12 VARCHAR2 DEFAULT NULL,
X_Prl_Information13 VARCHAR2 DEFAULT NULL,
X_Prl_Information14 VARCHAR2 DEFAULT NULL,
X_Prl_Information15 VARCHAR2 DEFAULT NULL,
X_Prl_Information16 VARCHAR2 DEFAULT NULL,
X_Prl_Information17 VARCHAR2 DEFAULT NULL,
X_Prl_Information18 VARCHAR2 DEFAULT NULL,
X_Prl_Information19 VARCHAR2 DEFAULT NULL,
X_Prl_Information20 VARCHAR2 DEFAULT NULL,
X_Prl_Information21 VARCHAR2 DEFAULT NULL,
X_Prl_Information22 VARCHAR2 DEFAULT NULL,
X_Prl_Information23 VARCHAR2 DEFAULT NULL,
X_Prl_Information24 VARCHAR2 DEFAULT NULL,
X_Prl_Information25 VARCHAR2 DEFAULT NULL,
X_Prl_Information26 VARCHAR2 DEFAULT NULL,
X_Prl_Information27 VARCHAR2 DEFAULT NULL,
X_Prl_Information28 VARCHAR2 DEFAULT NULL,
X_Prl_Information29 VARCHAR2 DEFAULT NULL,
X_Prl_Information30 VARCHAR2 DEFAULT NULL,
-- Extra Columns
X_Validation_Start_date DATE,
X_Validation_End_date DATE,
X_Arrears_Flag VARCHAR2,
X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
X_payslip_view_date_offset NUMBER DEFAULT NULL
--bug 5609830 / 5144323 TEST starts
,X_Effective_Date DATE --new
,X_payroll_type VARCHAR2 DEFAULT NULL --new
,X_comments VARCHAR2 DEFAULT NULL --new
,X_Effective_Start_Date OUT nocopy DATE --out type added
,X_Effective_End_Date OUT nocopy DATE --out type added
,X_Comment_Id OUT nocopy NUMBER --out type added
--bug 5609830 / 5144323 TEST ends
) IS
--
CURSOR C IS SELECT rowid, comment_id FROM PAY_ALL_PAYROLLS_F
WHERE payroll_id = X_Payroll_Id;
pay_payrolls_f_pkg.validate_insert_payroll
(x_business_group_id,
x_payroll_name,
x_default_payment_method_id,
x_validation_start_date,
x_validation_end_date);
'pay_payrolls_f_pkg.insert_row');
pay_payrolls_f_pkg.insert_payroll
(x_payroll_id,
x_default_payment_method_id,
x_validation_start_date,
x_validation_end_date);
END Insert_Row;
CURSOR C IS SELECT * FROM PAY_PAYROLLS_F
WHERE rowid = X_Rowid FOR UPDATE of Payroll_Id NOWAIT;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Payroll_Id NUMBER,
X_Effective_Start_Date DATE,
X_Effective_End_Date DATE,
X_Default_Payment_Method_Id NUMBER,
X_Business_Group_Id NUMBER,
X_Consolidation_Set_Id NUMBER,
X_Cost_Allocation_Keyflex_Id NUMBER,
X_Suspense_Account_Keyflex_Id NUMBER,
X_Gl_Set_Of_Books_Id NUMBER,
X_Soft_Coding_Keyflex_Id NUMBER,
X_Period_Type VARCHAR2,
X_Organization_Id NUMBER,
X_Cut_Off_Date_Offset NUMBER,
X_Direct_Deposit_Date_Offset NUMBER,
X_First_Period_End_Date DATE,
X_Negative_Pay_Allowed_Flag VARCHAR2,
X_Number_Of_Years NUMBER,
X_Pay_Advice_Date_Offset NUMBER,
X_Pay_Date_Offset NUMBER,
X_Payroll_Name VARCHAR2,
X_Workload_Shifting_Level VARCHAR2,
X_Comment_Id NUMBER,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2,
-- Payroll Developer DF
X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
X_Prl_Information1 VARCHAR2 DEFAULT NULL,
X_Prl_Information2 VARCHAR2 DEFAULT NULL,
X_Prl_Information3 VARCHAR2 DEFAULT NULL,
X_Prl_Information4 VARCHAR2 DEFAULT NULL,
X_Prl_Information5 VARCHAR2 DEFAULT NULL,
X_Prl_Information6 VARCHAR2 DEFAULT NULL,
X_Prl_Information7 VARCHAR2 DEFAULT NULL,
X_Prl_Information8 VARCHAR2 DEFAULT NULL,
X_Prl_Information9 VARCHAR2 DEFAULT NULL,
X_Prl_Information10 VARCHAR2 DEFAULT NULL,
X_Prl_Information11 VARCHAR2 DEFAULT NULL,
X_Prl_Information12 VARCHAR2 DEFAULT NULL,
X_Prl_Information13 VARCHAR2 DEFAULT NULL,
X_Prl_Information14 VARCHAR2 DEFAULT NULL,
X_Prl_Information15 VARCHAR2 DEFAULT NULL,
X_Prl_Information16 VARCHAR2 DEFAULT NULL,
X_Prl_Information17 VARCHAR2 DEFAULT NULL,
X_Prl_Information18 VARCHAR2 DEFAULT NULL,
X_Prl_Information19 VARCHAR2 DEFAULT NULL,
X_Prl_Information20 VARCHAR2 DEFAULT NULL,
X_Prl_Information21 VARCHAR2 DEFAULT NULL,
X_Prl_Information22 VARCHAR2 DEFAULT NULL,
X_Prl_Information23 VARCHAR2 DEFAULT NULL,
X_Prl_Information24 VARCHAR2 DEFAULT NULL,
X_Prl_Information25 VARCHAR2 DEFAULT NULL,
X_Prl_Information26 VARCHAR2 DEFAULT NULL,
X_Prl_Information27 VARCHAR2 DEFAULT NULL,
X_Prl_Information28 VARCHAR2 DEFAULT NULL,
X_Prl_Information29 VARCHAR2 DEFAULT NULL,
X_Prl_Information30 VARCHAR2 DEFAULT NULL,
-- Extra Columns
X_Validation_Start_date DATE,
X_Validation_End_date DATE,
X_Arrears_Flag VARCHAR2,
X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
X_payslip_view_date_offset NUMBER DEFAULT NULL
) IS
--
v_payroll_name varchar2(80);
pay_payrolls_F_pkg.validate_update_payroll
(X_Business_Group_id,
X_Payroll_Id,
X_Payroll_Name,
v_payroll_name, -- Current payroll name
X_Default_Payment_Method_Id,
v_default_payment_method_id, -- Current default payment method
X_Validation_Start_Date,
X_Validation_End_Date);
UPDATE PAY_PAYROLLS_F
SET payroll_id = X_Payroll_Id,
effective_start_date = X_Effective_Start_Date,
effective_end_date = X_Effective_End_Date,
default_payment_method_id = X_Default_Payment_Method_Id,
business_group_id = X_Business_Group_Id,
consolidation_set_id = X_Consolidation_Set_Id,
cost_allocation_keyflex_id = X_Cost_Allocation_Keyflex_Id,
suspense_account_keyflex_id = X_Suspense_Account_Keyflex_Id,
gl_set_of_books_id = X_Gl_Set_Of_Books_Id,
soft_coding_keyflex_id = X_Soft_Coding_Keyflex_Id,
period_type = X_Period_Type,
organization_id = X_Organization_Id,
cut_off_date_offset = X_Cut_Off_Date_Offset,
direct_deposit_date_offset = X_Direct_Deposit_Date_Offset,
first_period_end_date = X_First_Period_End_Date,
negative_pay_allowed_flag = X_Negative_Pay_Allowed_Flag,
number_of_years = X_Number_Of_Years,
pay_advice_date_offset = X_Pay_Advice_Date_Offset,
pay_date_offset = X_Pay_Date_Offset,
payroll_name = X_Payroll_Name,
workload_shifting_level = X_Workload_Shifting_Level,
comment_id = X_Comment_Id,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
attribute16 = X_Attribute16,
attribute17 = X_Attribute17,
attribute18 = X_Attribute18,
attribute19 = X_Attribute19,
attribute20 = X_Attribute20,
prl_information_category = X_Prl_Information_Category,
prl_information1 = X_Prl_Information1,
prl_information2 = X_Prl_Information2,
prl_information3 = X_Prl_Information3,
prl_information4 = X_Prl_Information4,
prl_information5 = X_Prl_Information5,
prl_information6 = X_Prl_Information6,
prl_information7 = X_Prl_Information7,
prl_information8 = X_Prl_Information8,
prl_information9 = X_Prl_Information9,
prl_information10 = X_Prl_Information10,
prl_information11 = X_Prl_Information11,
prl_information12 = X_Prl_Information12,
prl_information13 = X_Prl_Information13,
prl_information14 = X_Prl_Information14,
prl_information15 = X_Prl_Information15,
prl_information16 = X_Prl_Information16,
prl_information17 = X_Prl_Information17,
prl_information18 = X_Prl_Information18,
prl_information19 = X_Prl_Information19,
prl_information20 = X_Prl_Information20,
prl_information21 = X_Prl_Information21,
prl_information22 = X_Prl_Information22,
prl_information23 = X_Prl_Information23,
prl_information24 = X_Prl_Information24,
prl_information25 = X_Prl_Information25,
prl_information26 = X_Prl_Information26,
prl_information27 = X_Prl_Information27,
prl_information28 = X_Prl_Information28,
prl_information29 = X_Prl_Information29,
prl_information30 = X_Prl_Information30,
arrears_flag = X_Arrears_Flag,
multi_assignments_flag = X_Multi_Assignments_Flag,
period_reset_years = X_Period_Reset_Years,
payslip_view_date_offset = X_payslip_view_date_offset
WHERE rowid = X_rowid;
'pay_payrolls_f_pkg.update_row');
pay_payrolls_f_pkg.update_payroll
(x_business_group_id,
x_payroll_id,
x_payroll_name,
v_payroll_name, -- Current payroll name
x_default_payment_method_id,
v_default_payment_method_id, -- Current default payment method
x_number_of_years,
v_number_of_years, -- Current number of years
x_validation_start_date,
x_validation_end_date);
END Update_Row;
PROCEDURE Update_Row(X_Default_Payment_Method_Id NUMBER,
X_Business_Group_Id NUMBER,
X_Consolidation_Set_Id NUMBER,
X_Cost_Allocation_Keyflex_Id NUMBER,
X_Suspense_Account_Keyflex_Id NUMBER,
X_Gl_Set_Of_Books_Id NUMBER,
X_Soft_Coding_Keyflex_Id NUMBER,
X_Period_Type VARCHAR2,
X_Organization_Id NUMBER,
X_Cut_Off_Date_Offset NUMBER,
X_Direct_Deposit_Date_Offset NUMBER,
X_First_Period_End_Date DATE,
X_Negative_Pay_Allowed_Flag VARCHAR2,
X_Number_Of_Years NUMBER,
X_Pay_Advice_Date_Offset NUMBER,
X_Pay_Date_Offset NUMBER,
X_Payroll_Name VARCHAR2,
X_Workload_Shifting_Level VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2,
-- Payroll Developer DF
X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
X_Prl_Information1 VARCHAR2 DEFAULT NULL,
X_Prl_Information2 VARCHAR2 DEFAULT NULL,
X_Prl_Information3 VARCHAR2 DEFAULT NULL,
X_Prl_Information4 VARCHAR2 DEFAULT NULL,
X_Prl_Information5 VARCHAR2 DEFAULT NULL,
X_Prl_Information6 VARCHAR2 DEFAULT NULL,
X_Prl_Information7 VARCHAR2 DEFAULT NULL,
X_Prl_Information8 VARCHAR2 DEFAULT NULL,
X_Prl_Information9 VARCHAR2 DEFAULT NULL,
X_Prl_Information10 VARCHAR2 DEFAULT NULL,
X_Prl_Information11 VARCHAR2 DEFAULT NULL,
X_Prl_Information12 VARCHAR2 DEFAULT NULL,
X_Prl_Information13 VARCHAR2 DEFAULT NULL,
X_Prl_Information14 VARCHAR2 DEFAULT NULL,
X_Prl_Information15 VARCHAR2 DEFAULT NULL,
X_Prl_Information16 VARCHAR2 DEFAULT NULL,
X_Prl_Information17 VARCHAR2 DEFAULT NULL,
X_Prl_Information18 VARCHAR2 DEFAULT NULL,
X_Prl_Information19 VARCHAR2 DEFAULT NULL,
X_Prl_Information20 VARCHAR2 DEFAULT NULL,
X_Prl_Information21 VARCHAR2 DEFAULT NULL,
X_Prl_Information22 VARCHAR2 DEFAULT NULL,
X_Prl_Information23 VARCHAR2 DEFAULT NULL,
X_Prl_Information24 VARCHAR2 DEFAULT NULL,
X_Prl_Information25 VARCHAR2 DEFAULT NULL,
X_Prl_Information26 VARCHAR2 DEFAULT NULL,
X_Prl_Information27 VARCHAR2 DEFAULT NULL,
X_Prl_Information28 VARCHAR2 DEFAULT NULL,
X_Prl_Information29 VARCHAR2 DEFAULT NULL,
X_Prl_Information30 VARCHAR2 DEFAULT NULL,
-- Extra Columns
X_Validation_Start_date DATE,
X_Validation_End_date DATE,
X_Arrears_Flag VARCHAR2,
X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
X_payslip_view_date_offset NUMBER DEFAULT NULL
--bug 5609830 / 5144323 TEST starts contents
,X_Dt_Update_Mode VARCHAR2 --new
,X_effective_date DATE --new
,X_Comments VARCHAR2 DEFAULT NULL --new
,X_effective_start_date OUT nocopy DATE --type out added
,X_effective_end_date OUT nocopy DATE --type out added
,X_Comment_Id OUT nocopy NUMBER --type out added
,X_Rowid in OUT nocopy VARCHAR2 --type in out added
,X_Payroll_Id in OUT nocopy NUMBER --type in out added
--bug 5609830 / 5144323 TEST ends contents
) IS
--
v_payroll_name varchar2(80);
select object_version_number
from pay_all_payrolls_f
where rowid = X_Rowid;
select rowid
from pay_all_payrolls_f
where payroll_id = l_Payroll_id
and object_version_number = l_prl_object_version_number;
pay_payrolls_F_pkg.validate_update_payroll
(X_Business_Group_id,
X_Payroll_Id,
X_Payroll_Name,
v_payroll_name, -- Current payroll name
X_Default_Payment_Method_Id,
v_default_payment_method_id, -- Current default payment method
X_Validation_Start_Date,
X_Validation_End_Date);
pay_payroll_api.update_payroll(
p_validate => FALSE
,p_effective_date => X_effective_date
,p_datetrack_mode => X_Dt_Update_Mode
,p_payroll_name => X_payroll_name
,p_consolidation_set_id => X_consolidation_set_id
,p_number_of_years => X_number_of_years
,p_default_payment_method_id => X_default_payment_method_id
,p_cost_alloc_keyflex_id_in => X_cost_allocation_keyflex_id
,p_susp_account_keyflex_id_in => X_suspense_account_keyflex_id
,p_negative_pay_allowed_flag => X_negative_pay_allowed_flag
,p_soft_coding_keyflex_id_in => X_soft_coding_keyflex_id
,p_comments => X_comments
,p_attribute_category => X_attribute_category
,p_attribute1 => X_attribute1
,p_attribute2 => X_attribute2
,p_attribute3 => X_attribute3
,p_attribute4 => X_attribute4
,p_attribute5 => X_attribute5
,p_attribute6 => X_attribute6
,p_attribute7 => X_attribute7
,p_attribute8 => X_attribute8
,p_attribute9 => X_attribute9
,p_attribute10 => X_attribute10
,p_attribute11 => X_attribute11
,p_attribute12 => X_attribute12
,p_attribute13 => X_attribute13
,p_attribute14 => X_attribute14
,p_attribute15 => X_attribute15
,p_attribute16 => X_attribute16
,p_attribute17 => X_attribute17
,p_attribute18 => X_attribute18
,p_attribute19 => X_attribute19
,p_attribute20 => X_attribute20
,p_arrears_flag => X_arrears_flag
,p_multi_assignments_flag => X_multi_assignments_flag
,p_prl_information1 => X_prl_information1
,p_prl_information2 => X_prl_information2
,p_prl_information3 => X_prl_information3
,p_prl_information4 => X_prl_information4
,p_prl_information5 => X_prl_information5
,p_prl_information6 => X_prl_information6
,p_prl_information7 => X_prl_information7
,p_prl_information8 => X_prl_information8
,p_prl_information9 => X_prl_information9
,p_prl_information10 => X_prl_information10
,p_prl_information11 => X_prl_information11
,p_prl_information12 => X_prl_information12
,p_prl_information13 => X_prl_information13
,p_prl_information14 => X_prl_information14
,p_prl_information15 => X_prl_information15
,p_prl_information16 => X_prl_information16
,p_prl_information17 => X_prl_information17
,p_prl_information18 => X_prl_information18
,p_prl_information19 => X_prl_information19
,p_prl_information20 => X_prl_information20
,p_prl_information21 => X_prl_information21
,p_prl_information22 => X_prl_information22
,p_prl_information23 => X_prl_information23
,p_prl_information24 => X_prl_information24
,p_prl_information25 => X_prl_information25
,p_prl_information26 => X_prl_information26
,p_prl_information27 => X_prl_information27
,p_prl_information28 => X_prl_information28
,p_prl_information29 => X_prl_information29
,p_prl_information30 => X_prl_information30
--
,p_workload_shifting_level => X_Workload_Shifting_Level
,p_payslip_view_date_offset => X_payslip_view_date_offset
--
,p_payroll_id => l_Payroll_Id
,p_object_version_number => l_prl_object_version_number
,p_effective_start_date => X_effective_start_date
,p_effective_end_date => X_effective_end_date
,p_comment_id => X_comment_id
--
,p_cost_alloc_keyflex_id_out => l_cost_allocation_keyflex_id
,p_susp_account_keyflex_id_out => l_suspense_account_keyflex_id
,p_soft_coding_keyflex_id_out => l_soft_coding_keyflex_id
,p_cost_concat_segments_out => l_cost_concat_segments
,p_susp_concat_segments_out => l_susp_concat_segments
,p_scl_concat_segments_out => l_scl_concat_segments
--
);
pay_payrolls_f_pkg.update_payroll
(x_business_group_id,
x_payroll_id,
x_payroll_name,
v_payroll_name, -- Current payroll name
x_default_payment_method_id,
v_default_payment_method_id, -- Current default payment method
x_number_of_years,
v_number_of_years, -- Current number of years
x_validation_start_date,
x_validation_end_date);
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
-- Extra Columns
X_Payroll_Id NUMBER,
X_Default_Payment_Method_Id NUMBER,
X_Dt_Delete_Mode VARCHAR2,
X_Validation_Start_date DATE,
X_Validation_End_date DATE) IS
BEGIN
--
pay_payrolls_f_pkg.validate_delete_payroll
(x_payroll_id,
x_default_payment_method_id,
x_dt_delete_mode,
x_validation_start_date,
x_validation_end_date);
DELETE FROM PAY_PAYROLLS_F
WHERE rowid = X_Rowid;
'pay_payrolls_f_pkg.delete_row');
pay_payrolls_F_pkg.delete_payroll
(x_payroll_id,
x_default_payment_method_id,
x_dt_delete_mode,
x_validation_start_date,
x_validation_end_date);
END Delete_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
-- Extra Columns
X_Payroll_Id NUMBER,
X_Default_Payment_Method_Id NUMBER,
X_Dt_Delete_Mode VARCHAR2,
X_Validation_Start_date DATE,
X_Validation_End_date DATE
-- bug 5609830 / 5144323 TEST starts contents
,X_effective_date DATE
-- bug 5609830 / 5144323 TEST ends contents
) IS
--
l_effective_start_date date;
select object_version_number
from pay_all_payrolls_f
where rowid = X_Rowid;
pay_payrolls_f_pkg.validate_delete_payroll
(x_payroll_id,
x_default_payment_method_id,
x_dt_delete_mode,
x_validation_start_date,
x_validation_end_date);
pay_payroll_api.delete_payroll
(p_validate => FALSE,
p_effective_date => X_effective_date,
p_datetrack_mode => X_Dt_Delete_Mode,
p_payroll_id => X_payroll_id,
p_object_version_number => l_prl_object_version_number,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date
);
pay_payrolls_F_pkg.delete_payroll
(x_payroll_id,
x_default_payment_method_id,
x_dt_delete_mode,
x_validation_start_date,
x_validation_end_date);
END Delete_Row;
SELECT 'X'
FROM pay_legislation_rules
WHERE legislation_code = p_legislation_code
AND rule_type = 'ADVANCE';
SELECT 1
FROM fnd_descr_flex_column_usages
WHERE application_id = 801
AND descriptive_flexfield_name = p_ddf_name
AND descriptive_flex_context_code = p_legislation_code;