[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Y'
from hr_organization_information
where ORG_INFORMATION_CONTEXT like p_org_information_context
and org_information1 = p_org_information1
and organization_id = p_organization_id
;
SELECT 0
FROM hr_organization_units org
,per_business_groups bgp
WHERE bgp.name = org.name
AND bgp.organization_id <> org.organization_id
AND org.organization_id = p_organization_id;
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Org_Information_Id IN OUT NOCOPY NUMBER,
X_Org_Information_Context VARCHAR2,
X_Organization_Id NUMBER,
X_Org_Information1 VARCHAR2,
X_Org_Information10 VARCHAR2,
X_Org_Information11 VARCHAR2,
X_Org_Information12 VARCHAR2,
X_Org_Information13 VARCHAR2,
X_Org_Information14 VARCHAR2,
X_Org_Information15 VARCHAR2,
X_Org_Information16 VARCHAR2,
X_Org_Information17 VARCHAR2,
X_Org_Information18 VARCHAR2,
X_Org_Information19 VARCHAR2,
X_Org_Information2 VARCHAR2,
X_Org_Information20 VARCHAR2,
X_Org_Information3 VARCHAR2,
X_Org_Information4 VARCHAR2,
X_Org_Information5 VARCHAR2,
X_Org_Information6 VARCHAR2,
X_Org_Information7 VARCHAR2,
X_Org_Information8 VARCHAR2,
X_Org_Information9 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
) IS
CURSOR C (p_org_info_id number)IS SELECT rowid FROM HR_ORGANIZATION_INFORMATION
WHERE org_information_id = p_org_info_id;
CURSOR C2 IS SELECT hr_organization_information_s.nextval FROM sys.dual;
INSERT INTO HR_ORGANIZATION_INFORMATION(
org_information_id,
org_information_context,
organization_id,
org_information1,
org_information10,
org_information11,
org_information12,
org_information13,
org_information14,
org_information15,
org_information16,
org_information17,
org_information18,
org_information19,
org_information2,
org_information20,
org_information3,
org_information4,
org_information5,
org_information6,
org_information7,
org_information8,
org_information9,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
) VALUES (
X_Org_Information_Id,
X_Org_Information_Context,
X_Organization_Id,
X_Org_Information1,
X_Org_Information10,
X_Org_Information11,
X_Org_Information12,
X_Org_Information13,
X_Org_Information14,
X_Org_Information15,
X_Org_Information16,
X_Org_Information17,
X_Org_Information18,
X_Org_Information19,
X_Org_Information2,
X_Org_Information20,
X_Org_Information3,
X_Org_Information4,
X_Org_Information5,
X_Org_Information6,
X_Org_Information7,
X_Org_Information8,
X_Org_Information9,
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
);
hr_utility.set_message_token('PROCEDURE','Insert_Row');
END Insert_Row;
SELECT *
FROM HR_ORGANIZATION_INFORMATION
WHERE rowid = X_Rowid
FOR UPDATE of Org_Information_Id NOWAIT;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Org_Information_Id NUMBER,
X_Org_Information_Context VARCHAR2,
X_Organization_Id NUMBER,
X_Org_Information1 VARCHAR2,
X_Org_Information10 VARCHAR2,
X_Org_Information11 VARCHAR2,
X_Org_Information12 VARCHAR2,
X_Org_Information13 VARCHAR2,
X_Org_Information14 VARCHAR2,
X_Org_Information15 VARCHAR2,
X_Org_Information16 VARCHAR2,
X_Org_Information17 VARCHAR2,
X_Org_Information18 VARCHAR2,
X_Org_Information19 VARCHAR2,
X_Org_Information2 VARCHAR2,
X_Org_Information20 VARCHAR2,
X_Org_Information3 VARCHAR2,
X_Org_Information4 VARCHAR2,
X_Org_Information5 VARCHAR2,
X_Org_Information6 VARCHAR2,
X_Org_Information7 VARCHAR2,
X_Org_Information8 VARCHAR2,
X_Org_Information9 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
) IS
--
-- declare local variables
--
l_dummy VARCHAR2(1);
select
org_information1,
org_information8
from
hr_organization_information
where
org_information_id = X_org_information_id;
SELECT
'x'
FROM
pay_wc_rates wcr,
pay_wc_funds wcf
WHERE
wcf.carrier_id = l_carrier_id AND
wcf.state_code = l_state_code AND
wcr.fund_id = wcf.fund_id
AND EXISTS
( SELECT 'code referenced in override'
FROM per_assignments_f a,
fnd_id_flex_structures_vl ifs,
hr_soft_coding_keyflex sck
WHERE sck.segment1 = to_char(X_organization_id) -- #1683897
AND segment8 = to_char(wcr.wc_code)
AND ifs.id_flex_structure_name = 'GREs and other data'
AND sck.id_flex_num = ifs.id_flex_num
AND a.assignment_type = 'E'
AND a.soft_coding_keyflex_id = sck.soft_coding_keyflex_id );
hr_utility.set_location ('hr_org_information_pkg.update_row', 1);
hr_utility.set_location ('hr_org_information_pkg.update_row', 2);
hr_utility.set_location ('hr_org_information_pkg.update_row', 3);
hr_utility.set_location ('hr_org_information_pkg.update_row', 4);
hr_utility.set_location ('hr_org_information_pkg.update_row', 5);
UPDATE HR_ORGANIZATION_INFORMATION
SET
org_information_id = X_Org_Information_Id,
org_information_context = X_Org_Information_Context,
organization_id = X_Organization_Id,
org_information1 = X_Org_Information1,
org_information10 = X_Org_Information10,
org_information11 = X_Org_Information11,
org_information12 = X_Org_Information12,
org_information13 = X_Org_Information13,
org_information14 = X_Org_Information14,
org_information15 = X_Org_Information15,
org_information16 = X_Org_Information16,
org_information17 = X_Org_Information17,
org_information18 = X_Org_Information18,
org_information19 = X_Org_Information19,
org_information2 = X_Org_Information2,
org_information20 = X_Org_Information20,
org_information3 = X_Org_Information3,
org_information4 = X_Org_Information4,
org_information5 = X_Org_Information5,
org_information6 = X_Org_Information6,
org_information7 = X_Org_Information7,
org_information8 = X_Org_Information8,
org_information9 = X_Org_Information9,
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
WHERE rowid = X_rowid;
hr_utility.set_message_token('PROCEDURE','Update_Row');
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM HR_ORGANIZATION_INFORMATION
WHERE rowid = X_Rowid;
hr_utility.set_message_token('PROCEDURE','Delete_Row');
END Delete_Row;