The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT assignment_id
FROM per_all_assignments_f
WHERE person_id = p_person_id
AND p_effective_date between effective_start_date AND effective_end_date;
select code from ghr_nature_of_actions
where nature_of_action_id = p_noa_id;
SELECT pei_information1 From_Date,
pei_information2 To_date,
pei_information3,
pei_information4,
pei_information5,
pei_information6,
pei_information7,
pei_information8,
pei_information9,
person_extra_info_id
FROM per_people_extra_info pei,
pay_user_tables put
WHERE pei.person_id = p_person_id
AND pei.information_type = 'GHR_US_RETAINED_GRADE'
AND put.user_table_id = ghr_general.return_number(pei.pei_information6)
AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
<= p_effective_date
AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
>= p_effective_date
UNION
SELECT pei_information1 From_Date,
pei_information2 To_date,
pei_information3,
pei_information4,
pei_information5,
pei_information6,
pei_information7,
pei_information8,
pei_information9,
person_extra_info_id
FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
pay_user_tables put
WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
AND rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
AND pei2.person_extra_info_id
= ghr_general.return_number(rei.rei_information3)
AND (rei.rei_information5 = 'Y' or rei.rei_information5 is NULL )
AND put.user_table_id
= ghr_general.return_number(pei2.pei_information6)
AND rei.pa_request_id = l_altered_pa_request_id
order by 1;
SELECT pei_information1,
pei_information2,
pei_information3,
pei_information4,
pei_information5,
pei_information6,
pei_information7,
pei_information8,
pei_information9,
person_extra_info_id
FROM per_people_extra_info pei
WHERE pei.person_extra_info_id = p_person_extra_info_id;
SELECT pei_information1,
pei_information2,
pei_information3,
pei_information4,
pei_information5,
pei_information6,
pei_information7,
pei_information8,
pei_information9,
person_extra_info_id
FROM per_people_extra_info pei
WHERE pei.person_extra_info_id in (
SELECT rei_information3
FROM ghr_pa_request_extra_info
WHERE pa_request_id = l_altered_pa_request_id
AND information_type = 'GHR_US_PAR_TERM_RET_GRADE');
SELECT pei_information1 From_Date,
pei_information2 To_date,
pei_information3 ,
pei_information4,
pei_information5,
pei_information6,
pei_information7,
pei_information8,
pei_information9,
person_extra_info_id,
null terminate_flag,
null original_rpa
FROM per_people_extra_info pei,pay_user_tables put
WHERE pei.person_id = p_person_id
AND pei.information_type = 'GHR_US_RETAINED_GRADE'
AND put.user_table_id = pei.pei_information6
AND p_effective_date
BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
UNION
SELECT pei_information1 From_Date,
pei_information2 To_date,
pei_information3,
pei_information4,
pei_information5,
pei_information6,
pei_information7,
pei_information8,
pei_information9,
person_extra_info_id,
rei_information5 terminate_flag,
'Original RPA' origianl_rpa
FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
pay_user_tables put
WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
AND pei2.person_extra_info_id
= ghr_general.return_number(rei.rei_information3)
AND put.user_table_id
= ghr_general.return_number(pei2.pei_information6)
AND rei.rei_information5 = 'Y'
AND rei.pa_request_id = l_altered_pa_request_id
order by 1;
select rei_information3,rei_information4
from ghr_pa_request_extra_info
where pa_request_id = p_pa_request_id
and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG';
select rei_information3,rei_information4
from ghr_pa_request_extra_info
where pa_request_id = p_pa_request_id
and information_type = 'GHR_US_PAR_TERM_RG_PROMO';
select altered_pa_request_id from ghr_pa_requests
where pa_request_id = p_pa_request_id;
SELECT from_position_id,to_position_id
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
DELETE ghr_pa_request_extra_info
WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
'GHR_US_PAR_TERM_RG_PROMO',
'GHR_US_PAR_TERM_RG_POSN_CHG')
AND PA_REQUEST_ID = p_pa_request_id;
DELETE ghr_pa_request_ei_shadow
WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
'GHR_US_PAR_TERM_RG_PROMO',
'GHR_US_PAR_TERM_RG_POSN_CHG')
AND PA_REQUEST_ID = p_pa_request_id;
DELETE ghr_pa_request_extra_info
WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
AND PA_REQUEST_ID = p_pa_request_id;
DELETE ghr_pa_request_ei_shadow
WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
AND PA_REQUEST_ID = p_pa_request_id;
DELETE ghr_pa_request_extra_info
WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
AND PA_REQUEST_ID = p_pa_request_id;
DELETE ghr_pa_request_ei_shadow
WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
AND PA_REQUEST_ID = p_pa_request_id;
select rei.pa_request_extra_info_id,
rei.object_version_number
from ghr_pa_request_extra_info rei
where rei.pa_request_id = p_pa_request_id
and rei.information_type NOT IN ('GHR_US_PAR_PAYROLL_TYPE',
'GHR_US_PAR_PERF_APPRAISAL',
'GHR_US_PAR_GEN_AGENCY_DATA',
'GHR_US_PD_GEN_EMP')
and rei.information_type not in
(Select pit.information_type
from ghr_pa_request_info_types pit,
ghr_noa_families nfa,
ghr_families fam
where nfa.nature_of_action_id in (p_first_noa_id, p_second_noa_id)
and nfa.noa_family_code = fam.noa_family_code
and fam.pa_info_type_flag = 'Y'
and pit.noa_family_code = fam.noa_family_code);
select code from ghr_nature_of_actions
where nature_of_action_id = p_noa_id;
select altered_pa_request_id from ghr_pa_requests
where pa_request_id = p_pa_request_id;
select *
from ghr_pa_request_extra_info a
where a.pa_request_id = l_altered_pa_request_id
and a.information_type like 'GHR_US%'
and a.information_type not in (
select information_type from
ghr_pa_request_extra_info b
where b.pa_request_id = p_pa_request_id );
l_update_rei varchar2(1) := 'N';
l_rei_rec ghr_pa_request_extra_info%rowtype; -- as in the ddf and then subsequently overwrittwn with data to be updated
SELECT second_noa_code
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
select pa_request_extra_info_id,
rei_information1,
rei_information2,
rei_information3,
rei_information4,
rei_information5,
rei_information6,
rei_information7,
rei_information8,
rei_information9,
rei_information10,
rei_information11,
rei_information12,
rei_information13,
rei_information14,
rei_information15,
rei_information16,
rei_information17,
rei_information18,
rei_information19,
rei_information20,
rei_information21,
rei_information22,
rei_information23,
rei_information24,
rei_information25,
rei_information26,
rei_information27,
rei_information28,
rei_information29,
rei_information30,
object_version_number
from ghr_pa_request_extra_info
where pa_request_id = p_pa_request_id
and information_type = l_information_type;
select pa_request_extra_info_id,
rei_information1,
rei_information2,
rei_information3,
rei_information4,
rei_information5,
rei_information6,
rei_information7,
rei_information8,
rei_information9,
rei_information10,
rei_information11,
rei_information12,
rei_information13,
rei_information14,
rei_information15,
rei_information16,
rei_information17,
rei_information18,
rei_information19,
rei_information20,
rei_information21,
rei_information22,
rei_information23,
rei_information24,
rei_information25,
rei_information26,
rei_information27,
rei_information28,
rei_information29,
rei_information30
from ghr_pa_request_ei_shadow
where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
Select pit.information_type
from ghr_pa_request_info_types pit,
ghr_noa_families nfa,
ghr_families fam
where nfa.nature_of_action_id = p_noa_id
and nfa.noa_family_code = fam.noa_family_code
and p_effective_date between NVL(nfa.start_date_active,p_effective_date)
and NVL(nfa.end_date_active,p_effective_date)
and fam.pa_info_type_flag = 'Y'
and pit.noa_family_code = fam.noa_family_code
and pit.information_type like 'GHR_US%'
--Bug#3942126 Added the following clause.
and pit.active_inactive_flag = 'Y'
and pit.information_type IN
(SELECT information_type
from per_info_type_security
where application_id = c_application_id
and responsibility_id = c_resp_id);
Select effective_date
from ghr_pa_requests
where pa_request_id = p_pa_request_id;
select par.noa_family_code noa_family_code,
par.first_noa_code first_noa_code,
par.first_action_la_code1 la_code1,
par.pa_incentive_payment_option payment_option
from ghr_pa_requests par
where pa_request_id = p_pa_request_id;
SELECT par.effective_date
FROM ghr_nature_of_actions noa,
ghr_pa_requests par,
ghr_pay_plans pp
WHERE noa.nature_of_action_id = par.first_noa_id
and par.pa_request_id = p_pa_request_id
and pp.pay_plan = par.to_pay_plan
and pp.equivalent_pay_plan in ('GS','FW')
and substr(noa.code,1,1) = '1'
AND noa.code <> '130';
SELECT par.effective_date
FROM ghr_nature_of_actions noa,
ghr_pa_requests par,
ghr_pay_plans pp
WHERE noa.nature_of_action_id = par.first_noa_id
and par.pa_request_id = p_pa_request_id
and pp.pay_plan = par.to_pay_plan
and pp.equivalent_pay_plan in ('GS','FW')
and substr(noa.code,1,1) = '5'
AND noa.code not in ('542','543','546','548','549');
SELECT par.effective_date
FROM ghr_nature_of_actions noa,
ghr_pa_requests par,
ghr_pay_plans pp
WHERE noa.nature_of_action_id = par.first_noa_id
and par.pa_request_id = p_pa_request_id
and pp.pay_plan = par.to_pay_plan
and pp.equivalent_pay_plan in ('GS','FW')
AND noa.code = '130'
AND par.first_action_la_code1 = 'KVM';
SELECT par.effective_date
FROM ghr_nature_of_actions noa,
ghr_pa_requests par,
ghr_pay_plans pp
WHERE noa.nature_of_action_id = par.first_noa_id
AND par.pa_request_id = p_pa_request_id
AND pp.pay_plan = par.to_pay_plan
AND pp.equivalent_pay_plan in ('GS','FW')
AND code in ('702','703','891','893');
SELECT par.effective_date
FROM ghr_pa_requests par
WHERE par.pa_request_id = p_pa_request_id
AND par.first_noa_code IN ('890','891','892','893');
SELECT to_pay_plan,to_grade_or_level,
from_pay_plan,from_grade_or_level
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
SELECT from_position_id,to_position_id
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
select request_number from ghr_pa_requests
where pa_request_id = p_pa_request_id;
SELECT assignment_id
FROM per_all_assignments_f
WHERE person_id = p_person_id
AND p_effective_date between effective_start_date AND effective_end_date;
SELECT *
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
SELECT rei_information3 payroll_id
FROM ghr_pa_request_extra_info
WHERE pa_request_id = c_pa_request_id
AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
SELECT min(start_date) start_date
FROM per_time_periods
WHERE payroll_id = c_payroll_id
AND TO_CHAR(start_date,'YYYY') = c_year
AND TO_CHAR(start_date,'MM') = c_month;
SELECT 1
FROM pay_element_entries_f ele
WHERE ele.assignment_id = c_assignment_id
AND c_effective_date BETWEEN ele.effective_start_date AND effective_end_date
AND ele.element_type_id = (SELECT elt.element_type_id
FROM pay_element_types_f elt
WHERE element_name = c_element_name
AND c_effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date);
SELECT a.element_name element_name,
b.NAME ipv_name,
f.input_value_id input_value_id,
e.effective_start_date effective_start_date,
e.effective_end_date effective_end_date,
e.element_entry_id element_entry_id,
e.assignment_id assignment_id,
e.object_version_number object_version_number,
f.element_entry_value_id element_entry_value_id,
f.screen_entry_value screen_entry_value
FROM pay_element_types_f a,
pay_input_values_f b,
pay_element_entries_f e,
pay_element_entry_values_f f
WHERE a.element_type_id = b.element_type_id AND
e.element_type_id = a.element_type_id AND
f.element_entry_id = e.element_entry_id AND
f.input_value_id = b.input_value_id AND
e.assignment_id = c_assignment_id AND a.element_name = c_element_name AND
c_effective_date BETWEEN e.effective_start_date AND e.effective_end_date AND
/*Start Bug#6082557 Added three more condition in the where clause.*/
c_effective_date BETWEEN b.effective_start_date AND b.effective_end_date AND
c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date AND
c_effective_date BETWEEN f.effective_start_date AND f.effective_end_date;
Procedure appt_transfer is -- set / reset l_update_rei
Begin
-- Read from history if person id is not null
hr_utility.set_location('appt_transfer - person id ' || l_person_id,1);
SELECT business_group_id
FROM per_positions
WHERE position_id = l_position_id;
SELECT business_group_id
FROM per_positions
WHERE position_id = p_position_id;
SELECT 'X'
FROM ghr_nature_of_actions
WHERE nature_of_action_id = p_noa_id
and code in ('825','840','841','842','843','844','845','846',
'847','848','849','878','879' ); -- Bug 3266198 Added 848 and 849 to the NOA codes.
select work_schedule
from ghr_pa_requests
where pa_request_id = p_pa_request_id;
SELECT tenure,position_occupied
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
SELECT position_occupied
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
SELECT retirement_plan,service_comp_date
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
hr_utility.set_location('l_update_rei is Y ',1);
l_update_rei := 'Y';
l_update_rei := 'N';
hr_utility.set_location('l_update_rei is N ',1);
p_update_rei => l_update_rei,
p_rei_rec => l_rei_rec,
p_operation_flag => l_flag,
p_pa_request_extra_info_id => l_rei_rec.pa_request_extra_info_id,
p_object_version_number => l_rei_rec.object_version_number
);
l_update_rei varchar2(1) := 'N';
select business_group_id
from per_people_f
where person_id = p_person_id
and nvl(p_effective_date,sysdate) between
effective_start_date and effective_end_date;
select pa_request_extra_info_id,
rei_information1,
rei_information2,
rei_information3,
rei_information4,
rei_information5,
rei_information6,
rei_information7,
rei_information8,
rei_information9,
rei_information10,
rei_information11,
rei_information12,
rei_information13,
rei_information14,
rei_information15,
rei_information16,
rei_information17,
rei_information18,
rei_information19,
rei_information20,
rei_information21,
rei_information22,
rei_information23,
rei_information24,
rei_information25,
rei_information26,
rei_information27,
rei_information28,
rei_information29,
rei_information30,
object_version_number
from ghr_pa_request_extra_info
where pa_request_id = p_pa_request_id
and information_type = l_information_type;
select pa_request_extra_info_id,
rei_information1,
rei_information2,
rei_information3,
rei_information4,
rei_information5,
rei_information6,
rei_information7,
rei_information8,
rei_information9,
rei_information10,
rei_information11,
rei_information12,
rei_information13,
rei_information14,
rei_information15,
rei_information16,
rei_information17,
rei_information18,
rei_information19,
rei_information20,
rei_information21,
rei_information22,
rei_information23,
rei_information24,
rei_information25,
rei_information26,
rei_information27,
rei_information28,
rei_information29,
rei_information30
from ghr_pa_request_ei_shadow
where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
select payroll_id
from per_assignments_f asg
where asg.assignment_id = l_assignment_id
and trunc(nvl(p_effective_date,sysdate))
between asg.effective_start_date
and asg.effective_end_date;
select par.noa_family_code
from ghr_pa_requests par
where pa_request_id = p_pa_request_id;
select pay.payroll_id
from pay_payrolls_f pay
where payroll_name = 'Biweekly'
and nvl(p_effective_date,sysdate) between
pay.effective_start_date and pay.effective_end_date
and business_group_id = l_business_group_id;
select ppt.system_person_type
from per_person_types ppt,
per_people_f ppf
where ppf.person_id = p_person_id
and ppt.person_type_id = ppf.person_type_id
and p_effective_date
between ppf.effective_start_date
and ppf.effective_end_date;
l_update_rei := 'N';
l_update_rei := 'Y';
p_update_rei => l_update_rei,
p_rei_rec => l_rei_rec,
p_operation_flag => l_flag,
p_pa_request_extra_info_id => l_rei_rec.pa_request_extra_info_id,
p_object_version_number => l_rei_rec.object_version_number
);
l_update_rei := 'N';
l_update_rei := 'Y';
l_update_rei := 'N';
-- and we will never have to delete this record from the Extra info table.!!
---Added for bug 3187894
l_update_rei := 'Y';
p_update_rei => l_update_rei,
p_rei_rec => l_rei_rec,
p_operation_flag => l_flag,
p_pa_request_extra_info_id => l_rei_rec.pa_request_extra_info_id,
p_object_version_number => l_rei_rec.object_version_number
);
Select pit.information_type
from ghr_pa_request_info_types pit,
ghr_noa_families nfa,
ghr_families fam
where nfa.nature_of_action_id = p_noa_id
and nfa.noa_family_code = fam.noa_family_code
and fam.pa_info_type_flag = 'Y'
and pit.noa_family_code = fam.noa_family_code
and pit.information_type like 'GHR_US%';
p_update_rei in varchar2,
p_rei_rec in ghr_pa_request_extra_info%rowtype,
p_operation_flag out NOCOPY varchar2,
p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
) is
l_proc varchar2(72) := 'determine_operation';
select rei.pa_request_extra_info_id,
rei.object_version_number,
rei.rei_information1,
rei.rei_information2,
rei.rei_information3,
rei.rei_information4,
rei.rei_information5,
rei.rei_information6,
rei.rei_information7,
rei.rei_information8,
rei.rei_information9,
rei.rei_information10,
rei.rei_information11,
rei.rei_information12,
rei.rei_information13,
rei.rei_information14,
rei.rei_information15,
rei.rei_information16,
rei.rei_information17,
rei.rei_information18,
rei.rei_information19,
rei.rei_information20,
rei.rei_information21,
rei.rei_information22,
rei.rei_information23,
rei.rei_information24,
rei.rei_information25,
rei.rei_information26,
rei.rei_information27,
rei.rei_information28,
rei.rei_information29,
rei.rei_information30
from ghr_pa_request_extra_info rei
where rei.pa_request_id = p_pa_request_id
and rei.information_type = p_information_type;
If p_update_rei = 'Y' then
hr_utility.set_location(' Update ',1);
hr_utility.set_location('operation is Update',1);
hr_utility.set_location(' Delete ',1);
If p_update_rei = 'Y' then
hr_utility.set_location(l_proc,35);
insert into ghr_pa_request_ei_shadow
(
pa_request_extra_info_id ,
pa_request_id ,
information_type,
rei_information1 ,
rei_information2 ,
rei_information3 ,
rei_information4 ,
rei_information5 ,
rei_information6 ,
rei_information7 ,
rei_information8 ,
rei_information9 ,
rei_information10 ,
rei_information11 ,
rei_information12 ,
rei_information13 ,
rei_information14 ,
rei_information15 ,
rei_information16 ,
rei_information17 ,
rei_information18 ,
rei_information19 ,
rei_information20 ,
rei_information21 ,
rei_information22 ,
rei_information23 ,
rei_information24 ,
rei_information25 ,
rei_information26 ,
rei_information27 ,
rei_information28 ,
rei_information29 ,
rei_information30
) values
(l_rei_rec.pa_request_extra_info_id,
l_rei_rec.pa_request_id,
l_rei_rec.information_type,
l_rei_rec.rei_information1,
l_rei_rec.rei_information2,
l_rei_rec.rei_information3,
l_rei_rec.rei_information4,
l_rei_rec.rei_information5,
l_rei_rec.rei_information6,
l_rei_rec.rei_information7,
l_rei_rec.rei_information8,
l_rei_rec.rei_information9,
l_rei_rec.rei_information10,
l_rei_rec.rei_information11,
l_rei_rec.rei_information12,
l_rei_rec.rei_information13,
l_rei_rec.rei_information14,
l_rei_rec.rei_information15,
l_rei_rec.rei_information16,
l_rei_rec.rei_information17,
l_rei_rec.rei_information18,
l_rei_rec.rei_information19,
l_rei_rec.rei_information20,
l_rei_rec.rei_information21,
l_rei_rec.rei_information22,
l_rei_rec.rei_information23,
l_rei_rec.rei_information24,
l_rei_rec.rei_information25,
l_rei_rec.rei_information26,
l_rei_rec.rei_information27,
l_rei_rec.rei_information28,
l_rei_rec.rei_information29,
l_rei_rec.rei_information30
);
hr_utility.set_location('update extra info',1);
ghr_par_extra_info_api.update_pa_request_extra_info
(P_PA_REQUEST_EXTRA_INFO_ID => l_rei_rec.pa_request_extra_info_id,
P_OBJECT_VERSION_NUMBER => l_rei_rec.object_version_number ,
p_rei_information1 => l_rei_rec.rei_information1,
p_rei_information2 => l_rei_rec.rei_information2,
p_rei_information3 => l_rei_rec.rei_information3,
p_rei_information4 => l_rei_rec.rei_information4,
p_rei_information5 => l_rei_rec.rei_information5,
p_rei_information6 => l_rei_rec.rei_information6,
p_rei_information7 => l_rei_rec.rei_information7,
p_rei_information8 => l_rei_rec.rei_information8,
p_rei_information9 => l_rei_rec.rei_information9,
p_rei_information10 => l_rei_rec.rei_information10,
p_rei_information11 => l_rei_rec.rei_information11,
p_rei_information12 => l_rei_rec.rei_information12,
p_rei_information13 => l_rei_rec.rei_information13,
p_rei_information14 => l_rei_rec.rei_information14,
p_rei_information15 => l_rei_rec.rei_information15,
p_rei_information16 => l_rei_rec.rei_information16,
p_rei_information17 => l_rei_rec.rei_information17,
p_rei_information18 => l_rei_rec.rei_information18,
p_rei_information19 => l_rei_rec.rei_information19,
p_rei_information20 => l_rei_rec.rei_information20,
p_rei_information21 => l_rei_rec.rei_information21,
p_rei_information22 => l_rei_rec.rei_information22,
p_rei_information23 => l_rei_rec.rei_information23,
p_rei_information24 => l_rei_rec.rei_information24,
p_rei_information25 => l_rei_rec.rei_information25,
p_rei_information26 => l_rei_rec.rei_information26,
p_rei_information27 => l_rei_rec.rei_information27,
p_rei_information28 => l_rei_rec.rei_information28,
p_rei_information29 => l_rei_rec.rei_information29,
p_rei_information30 => l_rei_rec.rei_information30
);
update ghr_pa_request_ei_shadow set
rei_information1 = p_org_rec.rei_information1,
rei_information2 = p_org_rec.rei_information2,
rei_information3 = p_org_rec.rei_information3,
rei_information4 = p_org_rec.rei_information4,
rei_information5 = p_org_rec.rei_information5,
rei_information6 = p_org_rec.rei_information6,
rei_information7 = p_org_rec.rei_information7,
rei_information8 = p_org_rec.rei_information8,
rei_information9 = p_org_rec.rei_information9,
rei_information10 = p_org_rec.rei_information10,
rei_information11 = p_org_rec.rei_information11,
rei_information12 = p_org_rec.rei_information12,
rei_information13 = p_org_rec.rei_information13,
rei_information14 = p_org_rec.rei_information14,
rei_information15 = p_org_rec.rei_information15,
rei_information16 = p_org_rec.rei_information16,
rei_information17 = p_org_rec.rei_information17,
rei_information18 = p_org_rec.rei_information18,
rei_information19 = p_org_rec.rei_information19,
rei_information20 = p_org_rec.rei_information20,
rei_information21 = p_org_rec.rei_information21,
rei_information22 = p_org_rec.rei_information22,
rei_information23 = p_org_rec.rei_information23,
rei_information24 = p_org_rec.rei_information24,
rei_information25 = p_org_rec.rei_information25,
rei_information26 = p_org_rec.rei_information26,
rei_information27 = p_org_rec.rei_information27,
rei_information28 = p_org_rec.rei_information28,
rei_information29 = p_org_rec.rei_information29,
rei_information30 = p_org_rec.rei_information30
where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
hr_utility.set_location('delete extra info',1);
ghr_par_extra_info_api.delete_pa_request_extra_info
(p_pa_request_extra_info_id => l_rei_rec.pa_request_extra_info_id,
p_object_version_number => l_rei_rec.object_version_number
);
delete from ghr_pa_request_ei_shadow
where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;