[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Step_Id IN OUT NOCOPY NUMBER,
X_Effective_Start_Date DATE,
X_Effective_End_Date DATE,
X_Business_Group_Id NUMBER,
X_Spinal_Point_Id NUMBER,
X_Grade_Spine_Id NUMBER,
X_Sequence NUMBER,
X_request_id NUMBER,
X_program_application_id NUMBER,
X_program_id NUMBER,
X_program_update_date DATE,
X_Information1 VARCHAR2,
X_Information2 VARCHAR2,
X_Information3 VARCHAR2,
X_Information4 VARCHAR2,
X_Information5 VARCHAR2,
X_Information6 VARCHAR2,
X_Information7 VARCHAR2,
X_Information8 VARCHAR2,
X_Information9 VARCHAR2,
X_Information10 VARCHAR2,
X_Information11 VARCHAR2,
X_Information12 VARCHAR2,
X_Information13 VARCHAR2,
X_Information14 VARCHAR2,
X_Information15 VARCHAR2,
X_Information16 VARCHAR2,
X_Information17 VARCHAR2,
X_Information18 VARCHAR2,
X_Information19 VARCHAR2,
X_Information20 VARCHAR2,
X_Information21 VARCHAR2,
X_Information22 VARCHAR2,
X_Information23 VARCHAR2,
X_Information24 VARCHAR2,
X_Information25 VARCHAR2,
X_Information26 VARCHAR2,
X_Information27 VARCHAR2,
X_Information28 VARCHAR2,
X_Information29 VARCHAR2,
X_Information30 VARCHAR2,
X_Information_category VARCHAR2
) IS
CURSOR C IS SELECT rowid FROM per_spinal_point_steps
WHERE step_id = X_step_id;
CURSOR C2 IS SELECT per_spinal_point_steps_s.nextval FROM sys.dual;
INSERT INTO per_spinal_point_steps(
step_id,
effective_start_date,
effective_end_date,
business_group_id,
spinal_point_id,
grade_spine_id,
sequence,
request_id,
program_application_id,
program_id,
program_update_date,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25,
information26,
information27,
information28,
information29,
information30,
information_category
) VALUES (
X_Step_Id,
X_Effective_Start_Date,
X_Effective_End_Date,
X_Business_Group_Id,
X_Spinal_Point_Id,
X_Grade_Spine_Id,
X_Sequence,
X_request_id,
X_program_application_id,
X_program_id,
X_program_update_date,
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_Information_category
);
END Insert_Row;
X_program_update_date DATE,
X_Information1 VARCHAR2,
X_Information2 VARCHAR2,
X_Information3 VARCHAR2,
X_Information4 VARCHAR2,
X_Information5 VARCHAR2,
X_Information6 VARCHAR2,
X_Information7 VARCHAR2,
X_Information8 VARCHAR2,
X_Information9 VARCHAR2,
X_Information10 VARCHAR2,
X_Information11 VARCHAR2,
X_Information12 VARCHAR2,
X_Information13 VARCHAR2,
X_Information14 VARCHAR2,
X_Information15 VARCHAR2,
X_Information16 VARCHAR2,
X_Information17 VARCHAR2,
X_Information18 VARCHAR2,
X_Information19 VARCHAR2,
X_Information20 VARCHAR2,
X_Information21 VARCHAR2,
X_Information22 VARCHAR2,
X_Information23 VARCHAR2,
X_Information24 VARCHAR2,
X_Information25 VARCHAR2,
X_Information26 VARCHAR2,
X_Information27 VARCHAR2,
X_Information28 VARCHAR2,
X_Information29 VARCHAR2,
X_Information30 VARCHAR2,
X_Information_category VARCHAR2
) IS
CURSOR C IS
SELECT *
FROM per_spinal_point_steps
WHERE rowid = chartorowid(X_Rowid)
FOR UPDATE of step_id NOWAIT;
AND ( (Recinfo.program_update_date = X_program_update_date)
OR ( (Recinfo.program_update_date IS NULL)
AND (X_program_update_date IS NULL)))
) then
return;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Step_Id NUMBER,
X_Effective_Start_Date DATE,
X_Effective_End_Date DATE,
X_Business_Group_Id NUMBER,
X_Spinal_Point_Id NUMBER,
X_Grade_Spine_Id NUMBER,
X_Sequence NUMBER,
X_request_id NUMBER,
X_program_application_id NUMBER,
X_program_id NUMBER,
X_program_update_date DATE,
X_Information1 VARCHAR2,
X_Information2 VARCHAR2,
X_Information3 VARCHAR2,
X_Information4 VARCHAR2,
X_Information5 VARCHAR2,
X_Information6 VARCHAR2,
X_Information7 VARCHAR2,
X_Information8 VARCHAR2,
X_Information9 VARCHAR2,
X_Information10 VARCHAR2,
X_Information11 VARCHAR2,
X_Information12 VARCHAR2,
X_Information13 VARCHAR2,
X_Information14 VARCHAR2,
X_Information15 VARCHAR2,
X_Information16 VARCHAR2,
X_Information17 VARCHAR2,
X_Information18 VARCHAR2,
X_Information19 VARCHAR2,
X_Information20 VARCHAR2,
X_Information21 VARCHAR2,
X_Information22 VARCHAR2,
X_Information23 VARCHAR2,
X_Information24 VARCHAR2,
X_Information25 VARCHAR2,
X_Information26 VARCHAR2,
X_Information27 VARCHAR2,
X_Information28 VARCHAR2,
X_Information29 VARCHAR2,
X_Information30 VARCHAR2,
X_Information_category VARCHAR2
) IS
BEGIN
UPDATE per_spinal_point_steps
SET
step_id = X_Step_Id,
effective_start_date = X_Effective_Start_Date,
effective_end_date = X_Effective_End_Date,
business_group_id = X_Business_Group_Id,
spinal_point_id = X_Spinal_Point_Id,
grade_spine_id = X_Grade_Spine_Id,
sequence = X_Sequence,
request_id = X_request_id,
program_application_id = X_program_application_id,
program_id = X_program_id,
program_update_date = X_program_update_date,
information1 = X_Information1,
information2 = X_Information2,
information3 = X_Information3,
information4 = X_Information4,
information5 = X_Information5,
information6 = X_Information6,
information7 = X_Information7,
information8 = X_Information8,
information9 = X_Information9,
information10 = X_Information10,
information11 = X_Information11,
information12 = X_Information12,
information13 = X_Information13,
information14 = X_Information14,
information15 = X_Information15,
information16 = X_Information16,
information17 = X_Information17,
information18 = X_Information18,
information19 = X_Information19,
information20 = X_Information20,
information21 = X_Information21,
information22 = X_Information22,
information23 = X_Information23,
information24 = X_Information24,
information25 = X_Information25,
information26 = X_Information26,
information27 = X_Information27,
information28 = X_Information28,
information29 = X_Information29,
information30 = X_Information30,
information_category = X_Information_category
WHERE rowid = chartorowid(X_rowid);
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM per_spinal_point_steps
WHERE rowid = chartorowid(X_Rowid);
END Delete_Row;
select 'x'
from per_spinal_point_placements_f
where step_id = p_step_id
and p_sess < effective_end_date;
select 'x'
from per_all_assignments_f
where special_ceiling_step_id = p_step_id
and p_sess < effective_end_date;
select 'x'
from per_spinal_point_placements_f
where step_id = p_step_id;
select 'x'
from per_all_assignments_f
where special_ceiling_step_id = p_step_id
and special_ceiling_step_id is not null;
select 'x'
from sys.dual
where exists
(select null
from per_spinal_point_steps_f sp
-- per_grade_spines_f gs Bug fix:3648542
where sp.grade_spine_id = p_gspine_id
and sp.spinal_point_id = p_spoint_id
and sp.step_id <> p_step_id);
select count(*)
from per_spinal_points p1,
per_spinal_points p2,
per_spinal_point_steps_f s2
where s2.spinal_point_id = p2.spinal_point_id
and p1.sequence >= p2.sequence
and p_sess between
s2.effective_start_date and s2.effective_end_date
and p1.spinal_point_id = p_spoint_id
and s2.grade_spine_id = p_gspine_id
group by p1.sequence,p1.spinal_point;