The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_datetrack_update_mode VARCHAR2(80);
select batch_name from hr_pump_batch_headers where batch_name = p_batch_name;
SELECT legislation_code, name
FROM per_business_groups_perf
WHERE business_group_id = v_bg_id;
SELECT PAA.ASSIGNMENT_ID
FROM per_all_assignments_f PAA
, per_all_people_f PAP
WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
AND PAP.per_information_category ='DK'
AND PAP.NATIONAL_IDENTIFIER = p_cpr
AND PAA.PERSON_ID = PAP.PERSON_ID
AND PAA.PRIMARY_FLAG = 'Y'
AND p_date between PAA.EFFECTIVE_START_DATE and PAA.EFFECTIVE_END_DATE
AND p_date between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE ;
SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
from pay_element_entries_f pee
, pay_element_types_f pet
, pay_element_links_f pel
, per_all_assignments_f paa
where pet.ELEMENT_NAME = 'Tax Card'
and pet.legislation_code = 'DK'
and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID
and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
and pee.ASSIGNMENT_ID = p_assignment_id
and p_date between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
and p_date between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
and p_date between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
and p_date between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;
SELECT user_key_value, unique_key_id
FROM hr_pump_batch_line_user_keys
WHERE user_key_value = p_user_key_value;
SELECT hoi.org_information1, hoi.org_information5
FROM hr_organization_units hru, hr_organization_information hoi
WHERE business_group_id = v_bg_id
and hru.organization_id = hoi.organization_id
and hoi.ORG_INFORMATION_CONTEXT = 'DK_LEGAL_ENTITY_DETAILS';
INSERT INTO fnd_sessions(SESSION_ID, EFFECTIVE_DATE)
VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;
select tl.name
into l_input_value_name1
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name1
and tl.language ='US';
select tl.name
into l_input_value_name2
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name2
and tl.language ='US';
select tl.name
into l_input_value_name3
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name3
and tl.language ='US';
select tl.name
into l_input_value_name4
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name4
and tl.language ='US';
select tl.name
into l_input_value_name5
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name5
and tl.language ='US';
select tl.name
into l_input_value_name6
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name6
and tl.language ='US';
select tl.name
into l_input_value_name7
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name7
and tl.language ='US';
select tl.name
into l_input_value_name8
from pay_input_values_f_tl tl, pay_input_values_f t
where t.input_value_id = tl.input_value_id
and t.legislation_code ='DK'
and t.name = l_input_value_name8
and tl.language ='US';
select ELEMENTTL.element_name
into l_element_name_tl
from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
and ELEMENT.LEGISLATION_CODE ='DK'
and ELEMENT.ELEMENT_NAME = 'Tax Card'
AND ELEMENTTL.LANGUAGE = USERENV('LANG');
select ELEMENTTL.element_name
into l_element_name
from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
and ELEMENT.LEGISLATION_CODE ='DK'
and ELEMENT.ELEMENT_NAME = 'Tax Card'
AND ELEMENTTL.LANGUAGE = 'US';
l_datetrack_update_mode := 'CORRECTION';
l_datetrack_update_mode := 'UPDATE_OVERRIDE';
l_datetrack_update_mode := 'UPDATE';
--fnd_file.put_line(fnd_file.LOG,'l_datetrack_update_mode : '||l_datetrack_update_mode);
hr_utility.set_location ( ' Datetrack Update Mode:' || l_datetrack_update_mode, 90);
-- Data Pump procedure called to create batch lines to update element entries
-- Bug fix 4215700
hrdpp_update_element_entry.insert_batch_lines
(p_batch_id => l_batch_id
,p_data_pump_business_grp_name => l_bg_name
,P_DATETRACK_UPDATE_MODE => l_datetrack_update_mode
,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(l_effective_date)
,P_ENTRY_VALUE1 => l_entry_value1
,P_ENTRY_VALUE2 => l_entry_value2
,P_ENTRY_VALUE3 => l_entry_value3
,P_ENTRY_VALUE4 => l_entry_value4
,P_ENTRY_VALUE5 => l_entry_value5
,P_ENTRY_VALUE6 => l_entry_value6
,P_ENTRY_VALUE7 => l_entry_value7
,P_ENTRY_VALUE8 => l_entry_value8
,P_ENTRY_VALUE9 => l_entry_value9
,P_ENTRY_VALUE10 => NULL
,P_ENTRY_VALUE11 => NULL
,P_ENTRY_VALUE12 => NULL
,P_ENTRY_VALUE13 => NULL
,P_ENTRY_VALUE14 => NULL
,P_ENTRY_VALUE15 => NULL
,P_ELEMENT_ENTRY_USER_KEY => l_ee_user_key
,P_ELEMENT_NAME => l_element_name
,P_LANGUAGE_CODE =>'US'
,P_INPUT_VALUE_NAME1 =>l_input_value_name1
,P_INPUT_VALUE_NAME2 =>l_input_value_name2
,P_INPUT_VALUE_NAME3 =>l_input_value_name3
,P_INPUT_VALUE_NAME4 =>l_input_value_name4
,P_INPUT_VALUE_NAME5 =>l_input_value_name5
,P_INPUT_VALUE_NAME6 =>l_input_value_name6
,P_INPUT_VALUE_NAME7 =>l_input_value_name7
,P_INPUT_VALUE_NAME8 =>l_input_value_name8
,P_INPUT_VALUE_NAME9 =>l_input_value_name9
,P_INPUT_VALUE_NAME10 =>l_input_value_name10
,P_INPUT_VALUE_NAME11 =>l_input_value_name11
,P_INPUT_VALUE_NAME12 =>l_input_value_name12
,P_INPUT_VALUE_NAME13 =>l_input_value_name13
,P_INPUT_VALUE_NAME14 =>l_input_value_name14
,P_INPUT_VALUE_NAME15 =>l_input_value_name15);
-- fnd_file.put_line (fnd_file.LOG,'After hrdpp_update_element_entry.insert_batch_lines 1');
--DELETE the key
IF csr_get_user_key%FOUND THEN
begin
DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;
hrdpp_create_element_entry.insert_batch_lines
(p_batch_id => l_batch_id
,p_data_pump_business_grp_name => l_bg_name
,P_EFFECTIVE_DATE => fnd_date.canonical_to_date(l_effective_date)
,P_ENTRY_TYPE => 'E'
,P_CREATOR_TYPE => 'F'
,P_ENTRY_VALUE1 => l_entry_value1
,P_ENTRY_VALUE2 => l_entry_value2
,P_ENTRY_VALUE3 => l_entry_value3
,P_ENTRY_VALUE4 => l_entry_value4
,P_ENTRY_VALUE5 => l_entry_value5
,P_ENTRY_VALUE6 => l_entry_value6
,P_ENTRY_VALUE7 => l_entry_value7
,P_ENTRY_VALUE8 => l_entry_value8
,P_ENTRY_VALUE9 => l_entry_value9
,P_ENTRY_VALUE10 => NULL
,P_ENTRY_VALUE11 => NULL
,P_ENTRY_VALUE12 => NULL
,P_ENTRY_VALUE13 => NULL
,P_ENTRY_VALUE14 => NULL
,P_ENTRY_VALUE15 => NULL
,P_ELEMENT_ENTRY_USER_KEY => l_ee_user_key
,P_ASSIGNMENT_USER_KEY => L_ASSIGNMENT_USER_KEY
,P_ELEMENT_LINK_USER_KEY => L_ELEMENT_LINK_USER_KEY
,P_ELEMENT_NAME => l_element_name
,P_LANGUAGE_CODE =>'US'
,P_INPUT_VALUE_NAME1 =>l_input_value_name1
,P_INPUT_VALUE_NAME2 =>l_input_value_name2
,P_INPUT_VALUE_NAME3 =>l_input_value_name3
,P_INPUT_VALUE_NAME4 =>l_input_value_name4
,P_INPUT_VALUE_NAME5 =>l_input_value_name5
,P_INPUT_VALUE_NAME6 =>l_input_value_name6
,P_INPUT_VALUE_NAME7 =>l_input_value_name7
,P_INPUT_VALUE_NAME8 =>l_input_value_name8
,P_INPUT_VALUE_NAME9 =>l_input_value_name9
,P_INPUT_VALUE_NAME10 =>l_input_value_name10
,P_INPUT_VALUE_NAME11 =>l_input_value_name11
,P_INPUT_VALUE_NAME12 =>l_input_value_name12
,P_INPUT_VALUE_NAME13 =>l_input_value_name13
,P_INPUT_VALUE_NAME14 =>l_input_value_name14
,P_INPUT_VALUE_NAME15 =>l_input_value_name15);
SELECT payroll_id
FROM per_all_assignments_f
WHERE business_group_id = p_business_group_id
AND assignment_id = p_assignment_id
AND p_date
BETWEEN effective_start_date AND effective_end_date ;
SELECT element.element_link_id
FROM pay_paywsmee_elements_lov element
WHERE element.assignment_id = p_assignment_id
AND element.element_name = p_element_name
AND (element.business_group_id = p_business_group_id
OR (element.business_group_id is null and element.legislation_code = 'DK'))
AND ( element.multiple_entries_allowed_flag = 'Y'
OR (element.normal_exists = 'N'
OR (p_payroll_id is not null
AND ( (element.additional_entry_allowed_flag = 'Y'
AND element.additional_exists = 'N' )
OR (element.overridden = 'N' and element.adjusted = 'N' ))))) ;