[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ogi.org_information_context context
,ogi.org_information1 ogi1
,ogi.org_information2 ogi2
,ogi.org_information3 ogi3
,ogi.org_information4 ogi4
,ogi.org_information5 ogi5
,ogi.org_information6 ogi6
,ogi.org_information7 ogi7
,ogi.org_information8 ogi8
,ogi.org_information9 ogi9
,ogi.org_information10 ogi10
,ogi.org_information11 ogi11
,ogi.org_information12 ogi12
,ogi.org_information13 ogi13
,ogi.org_information14 ogi14
,ogi.org_information15 ogi15
,ogi.org_information16 ogi16
,ogi.org_information17 ogi17
,ogi.org_information18 ogi18
,ogi.org_information19 ogi19
,ogi.org_information20 ogi20
FROM hr_h2pi_organization_info ogi
WHERE ogi.org_information_id = p_org_information_id;
SELECT column_seq_num,
application_column_name col_name
FROM fnd_descr_flex_column_usages
WHERE application_id = 800
AND descriptive_flex_context_code = p_context
ORDER BY column_seq_num;
select fnd_flex_descval.segment_id(idx+1),
fnd_flex_descval.segment_value(idx+1),
fnd_flex_descval.segment_description(idx+1)
into l_seg_id,
l_seg_value,
l_seg_desc
from dual;
SELECT *
FROM hr_h2pi_locations
WHERE client_id = p_bg_id
AND (status IS NULL OR status <> 'C');
SELECT loc.object_version_number
INTO l_ovn
FROM hr_locations_all loc
WHERE loc.location_id = l_location_id;
hr_location_api.update_location
(p_validate => FALSE
,p_effective_date => SYSDATE
,p_location_id => l_location_id
,p_object_version_number=> l_ovn
,p_location_code => v_ud_loc.location_code
,p_description => v_ud_loc.description
,p_address_line_1 => v_ud_loc.address_line_1
,p_address_line_2 => v_ud_loc.address_line_2
,p_address_line_3 => v_ud_loc.address_line_3
,p_town_or_city => v_ud_loc.town_or_city
,p_country => v_ud_loc.country
,p_inactive_date => v_ud_loc.inactive_date
,p_postal_code => v_ud_loc.postal_code
,p_region_1 => v_ud_loc.region_1
,p_region_2 => v_ud_loc.region_2
,p_region_3 => v_ud_loc.region_3
,p_style => v_ud_loc.style
,p_telephone_number_1 => v_ud_loc.telephone_number_1
,p_telephone_number_2 => v_ud_loc.telephone_number_2
,p_telephone_number_3 => v_ud_loc.telephone_number_3
,p_loc_information13 => v_ud_loc.loc_information13
,p_loc_information14 => v_ud_loc.loc_information14
,p_loc_information15 => v_ud_loc.loc_information15
,p_loc_information16 => v_ud_loc.loc_information16
,p_loc_information17 => v_ud_loc.loc_information17
,p_loc_information18 => v_ud_loc.loc_information18
,p_loc_information19 => v_ud_loc.loc_information19
,p_loc_information20 => v_ud_loc.loc_information20
,p_attribute_category => v_ud_loc.attribute_category
,p_attribute1 => v_ud_loc.attribute1
,p_attribute2 => v_ud_loc.attribute2
,p_attribute3 => v_ud_loc.attribute3
,p_attribute4 => v_ud_loc.attribute4
,p_attribute5 => v_ud_loc.attribute5
,p_attribute6 => v_ud_loc.attribute6
,p_attribute7 => v_ud_loc.attribute7
,p_attribute8 => v_ud_loc.attribute8
,p_attribute9 => v_ud_loc.attribute9
,p_attribute10 => v_ud_loc.attribute10
,p_attribute11 => v_ud_loc.attribute11
,p_attribute12 => v_ud_loc.attribute12
,p_attribute13 => v_ud_loc.attribute13
,p_attribute14 => v_ud_loc.attribute14
,p_attribute15 => v_ud_loc.attribute15
,p_attribute16 => v_ud_loc.attribute16
,p_attribute17 => v_ud_loc.attribute17
,p_attribute18 => v_ud_loc.attribute18
,p_attribute19 => v_ud_loc.attribute19
,p_attribute20 => v_ud_loc.attribute20
);
UPDATE hr_h2pi_locations
SET status = 'C'
WHERE location_id = v_ud_loc.location_id
AND client_id = p_from_client_id;
SELECT DISTINCT organization_id,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 1) hr_org,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 2) class,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 3) info
FROM hr_h2pi_hr_organizations
WHERE (status IS NULL OR status <> 'C')
AND client_id = p_bg_id
UNION
SELECT DISTINCT organization_id,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 1) hr_org,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 2) class,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 3) info
FROM hr_h2pi_organization_class
WHERE (status IS NULL OR status <> 'C')
AND client_id = p_bg_id
UNION
SELECT DISTINCT organization_id,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 1) hr_org,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 2) class,
hr_h2pi_bg_upload.org_exists(p_from_client_id,organization_id, 3) info
FROM hr_h2pi_organization_info
WHERE (status IS NULL OR status <> 'C')
AND client_id = p_bg_id
ORDER BY organization_id;
SELECT DISTINCT *
FROM hr_h2pi_hr_organizations
WHERE organization_id = p_org_id
AND (status IS NULL OR status <> 'C')
AND client_id = p_from_client_id;
SELECT DISTINCT *
FROM hr_h2pi_organization_class
WHERE organization_id = p_org_id
AND (status IS NULL OR status <> 'C')
AND client_id = p_from_client_id;
SELECT DISTINCT *
FROM hr_h2pi_organization_info
WHERE organization_id = p_org_id
AND (status IS NULL OR status <> 'C')
AND client_id = p_from_client_id;
SELECT effective_date
FROM fnd_sessions
WHERE session_id = userenv('sessionid');
insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE)
values(userenv('sessionid'), trunc(SYSDATE));
SELECT org.object_version_number
INTO l_ovn
FROM hr_all_organization_units org
WHERE org.organization_id = l_hr_org_id;
hr_organization_api.update_organization
(p_effective_date => SYSDATE
,p_organization_id => l_hr_org_id
,p_date_from => v_ud_hr_org.date_from
,p_date_to => v_ud_hr_org.date_to
,p_location_id => l_location_id
,p_attribute_category => v_ud_hr_org.attribute_category
,p_attribute1 => v_ud_hr_org.attribute1
,p_attribute2 => v_ud_hr_org.attribute2
,p_attribute3 => v_ud_hr_org.attribute3
,p_attribute4 => v_ud_hr_org.attribute4
,p_attribute5 => v_ud_hr_org.attribute5
,p_attribute6 => v_ud_hr_org.attribute6
,p_attribute7 => v_ud_hr_org.attribute7
,p_attribute8 => v_ud_hr_org.attribute8
,p_attribute9 => v_ud_hr_org.attribute9
,p_attribute10 => v_ud_hr_org.attribute10
,p_attribute11 => v_ud_hr_org.attribute11
,p_attribute12 => v_ud_hr_org.attribute12
,p_attribute13 => v_ud_hr_org.attribute13
,p_attribute14 => v_ud_hr_org.attribute14
,p_attribute15 => v_ud_hr_org.attribute15
,p_attribute16 => v_ud_hr_org.attribute16
,p_attribute17 => v_ud_hr_org.attribute17
,p_attribute18 => v_ud_hr_org.attribute18
,p_attribute19 => v_ud_hr_org.attribute19
,p_attribute20 => v_ud_hr_org.attribute20
,p_object_version_number=> l_ovn
);
UPDATE hr_h2pi_hr_organizations
SET status = 'C'
WHERE organization_id = v_ud_hr_org.organization_id
AND client_id = p_from_client_id;
SELECT org_information2,
object_version_number
INTO l_org_info2,
l_ovn
FROM hr_organization_information
WHERE org_information_id = l_hr_org_class_id;
UPDATE hr_h2pi_organization_class
SET status = 'C'
WHERE org_information_id = v_ud_hr_org_class.org_information_id
AND client_id = p_from_client_id;
SELECT org_information2,
object_version_number
INTO l_org_info2,
l_ovn
FROM hr_organization_information
WHERE org_information_id = l_hr_org_info_id;
hr_organization_api.update_org_information
(p_effective_date => SYSDATE
,p_org_info_type_code
=> v_ud_hr_org_info.org_information_context
,p_org_information1 => l_org_info1
,p_org_information2 => v_ud_hr_org_info.org_information2
,p_org_information3 => v_ud_hr_org_info.org_information3
,p_org_information4 => v_ud_hr_org_info.org_information4
,p_org_information5 => v_ud_hr_org_info.org_information5
,p_org_information6 => v_ud_hr_org_info.org_information6
,p_org_information7 => v_ud_hr_org_info.org_information7
,p_org_information8 => l_org_info8
,p_org_information9 => l_org_info9
,p_org_information10 => l_org_info10
,p_org_information11 => v_ud_hr_org_info.org_information11
,p_org_information12 => l_org_info12
,p_org_information13 => l_org_info13
,p_org_information14 => v_ud_hr_org_info.org_information14
,p_org_information15 => v_ud_hr_org_info.org_information15
,p_org_information16 => v_ud_hr_org_info.org_information16
,p_org_information17 => v_ud_hr_org_info.org_information17
,p_org_information18 => v_ud_hr_org_info.org_information18
,p_org_information19 => v_ud_hr_org_info.org_information19
,p_org_information20 => v_ud_hr_org_info.org_information20
,p_org_information_id => l_hr_org_info_id
,p_object_version_number=> l_ovn
);
UPDATE hr_h2pi_organization_info
SET status = 'C'
WHERE org_information_id = v_ud_hr_org_info.org_information_id
AND client_id = p_from_client_id;
SELECT *
FROM hr_h2pi_element_names
WHERE client_id = p_bg_id
AND (status IS NULL OR status <> 'C');
SELECT elt.element_name
INTO l_element_name
FROM pay_element_types_f elt
WHERE elt.element_type_id = l_ele_type_id
AND SYSDATE BETWEEN elt.effective_start_date
AND elt.effective_end_date;
UPDATE hr_h2pi_element_names
SET status = 'C'
WHERE element_type_id = v_ud_ele_name.element_type_id
AND client_id = p_from_client_id;
SELECT 1
FROM hr_h2pi_hr_organizations
WHERE organization_id = p_id
AND (status IS NULL OR status <> 'C')
AND client_id = p_from_client_id;
SELECT 1
FROM hr_h2pi_organization_class
WHERE organization_id = p_id
AND (status IS NULL OR status <> 'C')
AND client_id = p_from_client_id;
SELECT 1
FROM hr_h2pi_organization_info
WHERE organization_id = p_id
AND (status IS NULL OR status <> 'C')
AND client_id = p_from_client_id;