[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NULL
INTO l_result
FROM per_budget_values bv
WHERE X_Budget_Element_Id = bv.budget_element_id
AND X_Time_Period_Id = bv.time_period_id
AND X_Business_group_Id = bv.Business_Group_Id + 0
AND (bv.Rowid <> X_Rowid or X_Rowid is null);
SELECT budget_version_id
INTO x_budget_version_id
FROM per_budget_elements pbe
WHERE pbe.budget_element_id = x_budget_element_id
AND pbe.business_group_id = x_business_group_id;
SELECT NULL
INTO l_result
FROM per_budget_values pbv
WHERE pbv.budget_value_id = x_budget_value_id
AND (pbv.rowid <> X_rowid OR X_rowid IS NULL);
'select ''Y'' from all_tables where table_name = ''OTA_TP_MEASUREMENT_TYPES''
and owner = '''||l_owner||'''';
l_stmt_get_tpc_rows varchar2(32000) := 'select ''Y'' from OTA_TP_MEASUREMENT_TYPES ota
where UPPER(ota.tp_measurement_code) = (select UPPER(unit)
FROM per_budgets
WHERE budget_id = (SELECT budget_id
FROM per_budget_versions
WHERE budget_version_id = '
||x_budget_version_id || '))
AND ota.many_budget_values_flag = ''Y''
AND ota.business_group_id = ' ||x_business_group_id;
PROCEDURE Insert_Row(x_Rowid IN OUT NOCOPY VARCHAR2,
x_Budget_Value_Id IN OUT NOCOPY NUMBER,
x_Business_Group_Id IN NUMBER,
x_Budget_Element_Id IN NUMBER,
x_Time_Period_Id IN NUMBER,
x_Value IN NUMBER,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2,
x_attribute21 IN VARCHAR2,
x_attribute22 IN VARCHAR2,
x_attribute23 IN VARCHAR2,
x_attribute24 IN VARCHAR2,
x_attribute25 IN VARCHAR2,
x_attribute26 IN VARCHAR2,
x_attribute27 IN VARCHAR2,
x_attribute28 IN VARCHAR2,
x_attribute29 IN VARCHAR2,
x_attribute30 IN VARCHAR2,
x_information_category IN VARCHAR2,
x_information1 IN VARCHAR2,
x_information2 IN VARCHAR2,
x_information3 IN VARCHAR2,
x_information4 IN VARCHAR2,
x_information5 IN VARCHAR2,
x_information6 IN VARCHAR2,
x_information7 IN VARCHAR2,
x_information8 IN VARCHAR2,
x_information9 IN VARCHAR2,
x_information10 IN VARCHAR2,
x_information11 IN VARCHAR2,
x_information12 IN VARCHAR2,
x_information13 IN VARCHAR2,
x_information14 IN VARCHAR2,
x_information15 IN VARCHAR2,
x_information16 IN VARCHAR2,
x_information17 IN VARCHAR2,
x_information18 IN VARCHAR2,
x_information19 IN VARCHAR2,
x_information20 IN VARCHAR2,
x_information21 IN vARCHAR2,
x_information22 IN VARCHAR2,
x_information23 IN VARCHAR2,
x_information24 IN VARCHAR2,
x_information25 IN VARCHAR2,
x_information26 IN VARCHAR2,
x_information27 IN VARCHAR2,
x_information28 IN VARCHAR2,
x_information29 IN VARCHAR2,
x_information30 IN VARCHAR2
) IS
CURSOR C1 IS SELECT rowid FROM per_budget_values
WHERE budget_value_id = X_Budget_Value_Id;
CURSOR C2 IS SELECT per_budget_values_s.nextval FROM dual;
SELECT null
from per_budget_values pb
where pb.budget_element_id = x_budget_element_id;
l_proc VARCHAR2(72) := g_package||'Insert_Row';
INSERT INTO per_budget_values(
budget_value_id,
business_group_id,
budget_element_id,
time_period_id,
value,
information_category,
budget_information1,
budget_information2,
budget_information3,
budget_information4,
budget_information5,
budget_information6,
budget_information7,
budget_information8,
budget_information9,
budget_information10,
budget_information11,
budget_information12,
budget_information13,
budget_information14,
budget_information15,
budget_information16,
budget_information17,
budget_information18,
budget_information19,
budget_information20,
budget_information21,
budget_information22,
budget_information23,
budget_information24,
budget_information25,
budget_information26,
budget_information27,
budget_information28,
budget_information29,
budget_information30,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30
) VALUES (
x_budget_value_id,
x_business_group_id,
x_budget_element_id,
x_time_period_id,
x_value,
x_information_category,
x_information1,
x_information2,
x_information3,
x_information4,
x_information5,
x_information6,
x_information7,
x_information8,
x_information9,
x_information10,
x_information11,
x_information12,
x_information13,
x_information14,
x_information15,
x_information16,
x_information17,
x_information18,
x_information19,
x_information20,
x_information21,
x_information22,
x_information23,
x_information24,
x_information25,
x_information26,
x_information27,
x_information28,
x_information29,
x_information30,
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,
x_attribute21,
x_attribute22,
x_attribute23,
x_attribute24,
x_attribute25,
x_Attribute26,
x_attribute27,
x_attribute28,
x_attribute29,
x_attribute30);
hr_utility.set_message_token('PROCEDURE','Insert_Row');
END Insert_Row;
SELECT *
FROM per_budget_values
WHERE rowid = X_Rowid
FOR UPDATE of Budget_Element_Id NOWAIT;
PROCEDURE Update_Row(X_Rowid IN VARCHAR2,
X_Budget_Value_Id IN NUMBER,
X_Business_Group_Id IN NUMBER,
X_Budget_Element_Id IN NUMBER,
X_Time_Period_Id IN NUMBER,
X_Value IN NUMBER,
X_attribute_category IN VARCHAR2,
X_attribute1 IN VARCHAR2,
X_attribute2 IN VARCHAR2,
X_attribute3 IN VARCHAR2,
X_attribute4 IN VARCHAR2,
X_attribute5 IN VARCHAR2,
X_attribute6 IN VARCHAR2,
X_attribute7 IN VARCHAR2,
X_attribute8 IN VARCHAR2,
X_attribute9 IN VARCHAR2,
X_attribute10 IN VARCHAR2,
X_attribute11 IN VARCHAR2,
X_attribute12 IN VARCHAR2,
X_attribute13 IN VARCHAR2,
X_attribute14 IN VARCHAR2,
X_attribute15 IN VARCHAR2,
X_attribute16 IN VARCHAR2,
X_attribute17 IN VARCHAR2,
X_attribute18 IN VARCHAR2,
X_attribute19 IN VARCHAR2,
X_attribute20 IN VARCHAR2,
X_attribute21 IN VARCHAR2,
X_attribute22 IN VARCHAR2,
X_attribute23 IN VARCHAR2,
X_attribute24 IN VARCHAR2,
X_attribute25 IN VARCHAR2,
X_attribute26 IN VARCHAR2,
X_attribute27 IN VARCHAR2,
X_attribute28 IN VARCHAR2,
X_attribute29 IN VARCHAR2,
X_attribute30 IN VARCHAR2,
X_information_category IN VARCHAR2,
X_information1 IN VARCHAR2,
X_information2 IN VARCHAR2,
X_information3 IN VARCHAR2,
X_information4 IN VARCHAR2,
X_information5 IN VARCHAR2,
X_information6 IN VARCHAR2,
X_information7 IN VARCHAR2,
X_information8 IN VARCHAR2,
X_information9 IN VARCHAR2,
X_information10 IN VARCHAR2,
X_information11 IN VARCHAR2,
X_information12 IN VARCHAR2,
X_information13 IN VARCHAR2,
X_information14 IN VARCHAR2,
X_information15 IN VARCHAR2,
X_information16 IN VARCHAR2,
X_information17 IN VARCHAR2,
X_information18 IN VARCHAR2,
X_information19 IN VARCHAR2,
X_information20 IN VARCHAR2,
X_information21 IN vARCHAR2,
X_information22 IN VARCHAR2,
X_information23 IN VARCHAR2,
X_information24 IN VARCHAR2,
X_information25 IN VARCHAR2,
X_information26 IN VARCHAR2,
X_information27 IN VARCHAR2,
X_information28 IN VARCHAR2,
X_information29 IN VARCHAR2,
X_information30 IN VARCHAR2
) IS
CURSOR C3 IS
SELECT null
from per_budget_values pb
where pb.budget_element_id = x_budget_element_id;
l_proc VARCHAR2(72) := g_package||'Update_Row';
UPDATE per_budget_values
SET
budget_value_id = X_Budget_Value_Id,
business_group_id = X_Business_Group_Id,
budget_element_id = X_Budget_Element_Id,
time_period_id = X_Time_Period_Id,
value = X_Value,
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,
attribute21 = X_attribute21,
attribute22 = X_attribute22,
attribute23 = X_attribute23,
attribute24 = X_attribute24,
attribute25 = X_attribute25,
attribute26 = X_attribute26,
attribute27 = X_attribute27,
attribute28 = X_attribute28,
attribute29 = X_attribute29,
attribute30 = X_attribute30,
information_category = X_information_category,
budget_information1 = X_information1,
budget_information2 = X_information2,
budget_information3 = X_information3,
budget_information4 = X_information4,
budget_information5 = X_information5,
budget_information6 = X_information6,
budget_information7 = X_information7,
budget_information8 = X_information8,
budget_information9 = X_information9,
budget_information10 = X_information10,
budget_information11 = X_information11,
budget_information12 = X_information12,
budget_information13 = X_information13,
budget_information14 = X_information14,
budget_information15 = X_information15,
budget_information16 = X_information16,
budget_information17 = X_information17,
budget_information18 = X_information18,
budget_information19 = X_information19,
budget_information20 = X_information20,
budget_information21 = X_information21,
budget_information22 = X_information22,
budget_information23 = X_information23,
budget_information24 = X_information24,
budget_information25 = X_information25,
budget_information26 = X_information26,
budget_information27 = X_information27,
budget_information28 = X_information28,
budget_information29 = X_information29,
budget_information30 = X_information30
WHERE rowid = X_rowid;
hr_utility.set_message_token('PROCEDURE','Update_Row');
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
l_proc VARCHAR2(72) := g_package||'Delete_Row';
SELECT budget_version_id
INTO l_budget_version_id
FROM per_budget_elements
WHERE budget_element_id = (SELECT budget_element_id
FROM per_budget_values
WHERE rowid = X_Rowid);
SELECT count(rowid)
INTO l_count
FROM per_budget_values
WHERE budget_element_id = (SELECT budget_element_id
FROM per_budget_values
WHERE rowid = X_Rowid);
SELECT rowid
INTO l_ele_rowid
FROM per_budget_elements
WHERE budget_element_id = (SELECT budget_element_id
FROM per_budget_values
WHERE rowid = X_Rowid);
hr_utility.set_message_token('PROCEDURE','Delete_Row');
DELETE FROM per_budget_values
WHERE rowid = X_Rowid;
hr_utility.set_message_token('PROCEDURE','Delete_Row');
DELETE FROM per_budget_elements
WHERE rowid = l_ele_rowid;
hr_utility.set_message_token('PROCEDURE','Delete_Row');
END Delete_Row;