[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT distinct a.person_id person_id
FROM per_all_people_f a,hr_organization_information hoi
WHERE a.business_group_id = hoi.organization_id
AND hoi.org_information_context = 'GHR_US_ORG_INFORMATION';
SELECT COUNT(distinct a.person_id) person_count
FROM per_all_people_f a,hr_organization_information hoi
WHERE a.business_group_id = hoi.organization_id
AND hoi.org_information_context = 'GHR_US_ORG_INFORMATION';
SELECT max(completion_status) max_status
FROM GHR_MTS_TEMP
WHERE session_id = c_session_id;
l_update_name pay_upgrade_definitions.short_name%type;
g_person_ids.DELETE;
l_update_name := 'GHR_ELT_BEN_CONV';
DELETE FROM pay_upgrade_status
WHERE upgrade_definition_id = (SELECT upgrade_definition_id
FROM pay_upgrade_definitions
WHERE short_name = l_update_name);
-- Loop through the person records and insert them into the appropriate batch.
-- If the batch size exceeds the limit, then insert the following records into the next batch.
FOR l_c_per_records IN c_per_records
LOOP
l_result := NULL;
INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)
VALUES(l_session_id,l_batch_no,l_c_per_records.person_id, NULL);
hr_update_utility.setUpdateProcessing(p_update_name => l_update_name);
hr_update_utility.setUpdateComplete(p_update_name => l_update_name);
-- Delete the temporary table data.
DELETE FROM GHR_MTS_TEMP
WHERE session_id = l_session_id;
DELETE FROM GHR_MTS_TEMP
WHERE session_id = l_session_id;
SELECT 'x'
FROM per_people_info_types
WHERE information_type = 'GHR_US_PER_BENEFIT_INFO';
SELECT pa_request_id person_id, batch_no
FROM GHR_MTS_TEMP
WHERE session_id = c_session_id
AND batch_no = c_batch_no;
SELECT userenv('sessionid') sesid
FROM dual;
SELECT *
FROM ghr_pa_history
WHERE person_id = p_person_id
AND (
(table_name = 'PER_PEOPLE_EXTRA_INFO' and information5 = 'GHR_US_PER_GROUP1') OR
(table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
AND information4 IN (SELECT b.input_value_id
FROM pay_element_types_f a,pay_input_values_f b
WHERE a.element_type_id = b.element_type_id
AND (
(a.element_name = 'FEGLI' AND b.NAME = 'Eligibility Expiration') OR
(a.element_name = 'Retirement Plan' AND b.NAME = 'FERS Eligibility Expires') OR
(a.element_name = 'Health Benefits' and b.NAME in('LWOP Contingncy Strt Date','LWOP Contingncy End Date',
'Child Eq Court Ord Date')) OR
(a.element_name = 'Health Benefits Pre tax' and b.NAME in('LWOP Contingncy Strt Date','LWOP Contingncy End Date',
'Child Eq Court Ord Date')) OR
(a.element_name = 'TSP' and b.NAME in('Agncy Contrib Elig Date','Emp Contrib Elig Date'))
)
)
)
)
ORDER BY effective_date,table_name,process_date,information1,pa_history_id;
SELECT per.full_name
,per.national_identifier
FROM per_all_people_f per
WHERE per.person_id = p_person_id
AND NVL(p_effective_date,TRUNC(sysdate)) between per.effective_start_date
and per.effective_end_date;
SELECT a.element_name element, b.name input_value
FROM pay_element_types_f a,pay_input_values_f b
WHERE a.element_type_id = b.element_type_id
AND b.input_value_id = p_input_value_id;
PROCEDURE insert_benefits_eit_rec(p_person_id IN NUMBER,
p_benefits_eit_rec IN ghr_api.per_benefit_info_type,
p_effective_date IN DATE) IS
l_information_type per_people_extra_info.information_type%type;
SELECT person_extra_info_id,
object_version_number
FROM per_people_extra_info
WHERE person_id = p_person_id
AND information_type = 'GHR_US_PER_BENEFIT_INFO';
hr_utility.set_location('Entering Insert benefits EIT REC',0);
ghr_person_extra_info_api.update_person_extra_info
(p_person_extra_info_id => l_person_extra_info_id
,p_object_version_number => l_object_version_number
,p_effective_date => p_effective_date
,p_pei_information3 => p_benefits_eit_rec.FEGLI_Date_Eligibility_Expires
,p_pei_information4 => p_benefits_eit_rec.FEHB_Date_Eligibility_expires
,p_pei_information5 => p_benefits_eit_rec.FEHB_Date_temp_eligibility
,p_pei_information6 => p_benefits_eit_rec.FEHB_Date_dependent_cert_expir
,p_pei_information7 => p_benefits_eit_rec.FEHB_LWOP_contingency_st_date
,p_pei_information8 => p_benefits_eit_rec.FEHB_LWOP_contingency_end_date
,p_pei_information10 => p_benefits_eit_rec.FEHB_Child_equiry_court_date
,p_pei_information11 => p_benefits_eit_rec.FERS_Date_eligibility_expires
,p_pei_information12 => p_benefits_eit_rec.FERS_Election_Date
,p_pei_information13 => p_benefits_eit_rec.FERS_Election_Indicator
,p_pei_information14 => p_benefits_eit_rec.TSP_Agncy_Contrib_Elig_date
,p_pei_information15 => p_benefits_eit_rec.TSP_Emp_Contrib_Elig_date
);
hr_utility.set_location('Leaving Insert Benefits EIT REC',40);
END insert_benefits_eit_rec;
UPDATE fnd_sessions SET SESSION_ID = l_sid
WHERE SESSION_ID = l_sid;
INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)
VALUES (l_sid,sysdate);
insert_benefits_eit_rec(l_current_person_id,l_benefits_eit_rec,l_old_effective_date);
insert_benefits_eit_rec(l_current_person_id,l_benefits_eit_rec,l_old_effective_date);
UPDATE GHR_MTS_TEMP
SET completion_status = p_retcode
WHERE session_id = p_session_id
AND batch_no = p_batch_no;
select status
from fnd_product_installations
where application_id = GHR_APPLICATION_ID;
select business_group_id from per_assignments_f
where assignment_id = l_assignment_id;
SELECT ppf.national_identifier
FROM per_assignments_f paf, per_people_f ppf
WHERE ppf.person_id = paf.person_id
AND paf.primary_flag = 'Y'
AND paf.assignment_type <> 'B'
AND to_date('2009/01/04','YYYY/MM/DD') BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND to_date('2009/01/04','YYYY/MM/DD') BETWEEN ppf.effective_start_date
AND ppf.effective_end_date
AND paf.assignment_id =l_assignment_id;
l_update_flag number := 0;
l_datetrack_update_mode varchar2(25);
l_out_update_warning boolean;
select b.name 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,
c.business_group_id business_group_id,--Bug# 6735031
e.object_version_number object_version_number,
f.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(p_business_group_id,c.business_group_id)--Bug# 6735031
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits'
and b.name = 'Health Plan'
and f.screen_entry_value in
('2L','4N','5M','5W','6Y','8J','9E','BW','DV','FB','FT','GN','GT','HZ','IE','JA','KS','LN','LT','MP','PU','SA','VW','YN','9F','2C','53');
select b.name 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,
c.business_group_id business_group_id, --Bug# 6735031
e.object_version_number object_version_number,
f.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(p_business_group_id,c.business_group_id) --Bug#6735031
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits Pre tax'
and b.name = 'Health Plan'
and f.screen_entry_value in
('2L','4N','5M','5W','6Y','8J','9E','BW','DV','FB','FT','GN','GT','HZ','IE','JA','KS','LN','LT','MP','PU','SA','VW','YN','9F','2C','53');
select b.name 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.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > l_check_date
and e.element_entry_id = l_element_entry_id
and a.element_name = 'Health Benefits'
and b.name = 'Health Plan'
and f.screen_entry_value in
('2L','4N','5M','5W','6Y','8J','9E','BW','DV','FB','FT','GN','GT','HZ','IE','JA','KS','LN','LT','MP','PU','SA','VW','YN','9F','2C','53');
select b.name 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.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > l_check_date
and e.element_entry_id = l_element_entry_id
and a.element_name = 'Health Benefits Pre tax'
and b.name = 'Health Plan'
and f.screen_entry_value in
('2L','4N','5M','5W','6Y','8J','9E','BW','DV','FB','FT','GN','GT','HZ','IE','JA','KS','LN','LT','MP','PU','SA','VW','YN','9F','2C','53');
select f.input_value_id input_value_id,
f.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and f.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits'
and b.name = 'Enrollment'
and e.element_entry_id = l_element_entry_id;
select f.input_value_id input_value_id,
f.screen_entry_value screen_entry_value,
f.effective_start_date effective_start_date,
f.effective_end_date effective_end_date
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and f.effective_start_date = l_effective_start_date
and f.effective_end_date = l_effective_end_date
and f.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits Pre tax'
and b.name = 'Enrollment'
and e.element_entry_id = l_element_entry_id;
l_update_flag := 0;
l_update_flag := 1;
l_update_flag := 1;
l_update_flag := 1;
l_datetrack_update_mode := 'CORRECTION';
l_datetrack_update_mode := 'UPDATE';
for update_mode_a in cur_hb_fr loop
l_exists := true;
l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
l_datetrack_update_mode := 'UPDATE';
if l_update_flag = 1 then
l_update_flag := 0;
ghr_element_entry_api.update_element_entry
( p_datetrack_update_mode => l_datetrack_update_mode
,p_effective_date => l_effective_date
,p_business_group_id => l_business_group_id
,p_element_entry_id => l_element_entry_id
,p_object_version_number => l_object_version_number
,p_input_value_id1 => l_input_value_id_enrol
,p_entry_value1 => l_screen_entry_value_enrol
,p_input_value_id2 => l_input_value_id
,p_entry_value2 => l_screen_entry_value
,p_effective_start_date => l_out_effective_start_date
,p_effective_end_date => l_out_effective_end_date
,p_update_warning => l_out_update_warning
);
l_update_flag := 0;
l_update_flag := 1;
l_update_flag := 1;
l_update_flag := 1;
l_datetrack_update_mode := 'CORRECTION';
l_datetrack_update_mode := 'UPDATE';
for update_mode in cur_hb_pt_fr loop
l_exists := true;
l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
l_datetrack_update_mode := 'UPDATE';
if l_update_flag = 1 then
BEGIN --B2
l_update_flag := 0;
ghr_element_entry_api.update_element_entry
( p_datetrack_update_mode => l_datetrack_update_mode
,p_effective_date => l_effective_date
,p_business_group_id => l_business_group_id
,p_element_entry_id => l_element_entry_id
,p_object_version_number => l_object_version_number
,p_input_value_id1 => l_input_value_id_enrol
,p_entry_value1 => l_screen_entry_value_enrol
,p_input_value_id2 => l_input_value_id
,p_entry_value2 => l_screen_entry_value
,p_effective_start_date => l_out_effective_start_date
,p_effective_end_date => l_out_effective_end_date
,p_update_warning => l_out_update_warning
);
select b.name 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,
c.business_group_id business_group_id,--Bug# 6735031
e.object_version_number object_version_number,
f.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(p_business_group_id,c.business_group_id)--Bug# 6735031
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits'
and b.name = 'Health Plan'
and f.screen_entry_value in ('53','HQ','JV');
select b.name 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,
c.business_group_id business_group_id,--Bug# 6735031
e.object_version_number object_version_number,
f.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(p_business_group_id,c.business_group_id)--Bug# 6735031
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits Pre tax'
and b.name = 'Health Plan'
and f.screen_entry_value in ('53','HQ','JV');
select b.name 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.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > l_check_date
and e.element_entry_id = l_element_entry_id
and a.element_name = 'Health Benefits'
and b.name = 'Health Plan'
and f.screen_entry_value in ('53','HQ','JV');
select b.name 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.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and e.effective_end_date > l_check_date
and e.element_entry_id = l_element_entry_id
and a.element_name = 'Health Benefits Pre tax'
and b.name = 'Health Plan'
and f.screen_entry_value in ('53','HQ','JV');
select f.input_value_id input_value_id,
f.screen_entry_value screen_entry_value
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and f.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits'
and b.name = 'Enrollment'
and e.element_entry_id = l_element_entry_id;
select f.input_value_id input_value_id,
f.screen_entry_value screen_entry_value,
f.effective_start_date effective_start_date,
f.effective_end_date effective_end_date
from pay_element_types_f a,
pay_input_values_f b,
pay_element_links_f c,
pay_link_input_values_f d,
pay_element_entries_f e,
pay_element_entry_values_f f
where a.element_type_id = b.element_type_id
and a.element_type_id = c.element_type_id
and c.element_link_id = d.element_link_id
and b.input_value_id = d.input_value_id
and e.element_link_id = c.element_link_id
and f.element_entry_id = e.element_entry_id
and f.input_value_id = b.input_value_id
and c.business_group_id = nvl(l_business_group_id,c.business_group_id)
and e.effective_start_date = f.effective_start_date
and e.effective_end_date = f.effective_end_date
and f.effective_start_date = l_effective_start_date
and f.effective_end_date = l_effective_end_date
and f.effective_end_date > to_date('2009/01/03','YYYY/MM/DD')
and a.element_name = 'Health Benefits Pre tax'
and b.name = 'Enrollment'
and e.element_entry_id = l_element_entry_id;
l_update_flag := 0;
l_update_flag := 1;
l_update_flag := 1;
l_datetrack_update_mode := 'CORRECTION';
l_datetrack_update_mode := 'UPDATE';
for update_mode_a in cur_hb_fr loop
l_exists := true;
l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
l_datetrack_update_mode := 'UPDATE';
if l_update_flag = 1 then
BEGIN --D2
l_update_flag := 0;
ghr_element_entry_api.update_element_entry
( p_datetrack_update_mode => l_datetrack_update_mode
,p_effective_date => l_effective_date
,p_business_group_id => l_business_group_id
,p_element_entry_id => l_element_entry_id
,p_object_version_number => l_object_version_number
,p_input_value_id1 => l_input_value_id
,p_entry_value1 => l_screen_entry_value
,p_effective_start_date => l_out_effective_start_date
,p_effective_end_date => l_out_effective_end_date
,p_update_warning => l_out_update_warning
);
l_update_flag := 0;
l_update_flag := 1;
l_update_flag := 1;
l_datetrack_update_mode := 'CORRECTION';
l_datetrack_update_mode := 'UPDATE';
for update_mode in cur_hb_pt_fr loop
l_exists := true;
l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
l_datetrack_update_mode := 'UPDATE';
if l_update_flag = 1 then
BEGIN --D5
l_update_flag := 0;
ghr_element_entry_api.update_element_entry
( p_datetrack_update_mode => l_datetrack_update_mode
,p_effective_date => l_effective_date
,p_business_group_id => l_business_group_id
,p_element_entry_id => l_element_entry_id
,p_object_version_number => l_object_version_number
,p_input_value_id1 => l_input_value_id
,p_entry_value1 => l_screen_entry_value
,p_effective_start_date => l_out_effective_start_date
,p_effective_end_date => l_out_effective_end_date
,p_update_warning => l_out_update_warning
);