APPS.PQH_GSP_STAGE_TO_HR dependencies on PER_SPINAL_POINT_STEPS_F

Line 232: from per_spinal_point_steps_f

228: procedure delete_steps(p_grade_spine_id in number,
229: p_effective_date in date) is
230: cursor csr_steps is
231: select step_id,object_version_number,effective_start_date,effective_end_date
232: from per_spinal_point_steps_f
233: where grade_spine_id = p_grade_spine_id
234: and p_effective_date between effective_start_date and effective_end_date;
235: l_step_id number;
236: l_step_ovn number;

Line 305: l_Step_Id Per_Spinal_Point_Steps_F.Step_Id%TYPE;

301: p_effective_date in date,
302: p_date_track_mode in varchar2 default null) Is
303: --
304:
305: l_Step_Id Per_Spinal_Point_Steps_F.Step_Id%TYPE;
306: l_Effective_Start_Date Per_Spinal_Point_Steps_F.Effective_Start_Date%TYPE;
307: l_Effective_End_Date Per_Spinal_Point_Steps_F.Effective_End_Date%TYPE;
308: l_Step_Ovn Per_Spinal_Point_Steps_F.Object_Version_Number%TYPE;
309: l_datetrack_mode Varchar2(30);

Line 306: l_Effective_Start_Date Per_Spinal_Point_Steps_F.Effective_Start_Date%TYPE;

302: p_date_track_mode in varchar2 default null) Is
303: --
304:
305: l_Step_Id Per_Spinal_Point_Steps_F.Step_Id%TYPE;
306: l_Effective_Start_Date Per_Spinal_Point_Steps_F.Effective_Start_Date%TYPE;
307: l_Effective_End_Date Per_Spinal_Point_Steps_F.Effective_End_Date%TYPE;
308: l_Step_Ovn Per_Spinal_Point_Steps_F.Object_Version_Number%TYPE;
309: l_datetrack_mode Varchar2(30);
310: l_Scale_Delete Varchar2(1) := 'N';

Line 307: l_Effective_End_Date Per_Spinal_Point_Steps_F.Effective_End_Date%TYPE;

303: --
304:
305: l_Step_Id Per_Spinal_Point_Steps_F.Step_Id%TYPE;
306: l_Effective_Start_Date Per_Spinal_Point_Steps_F.Effective_Start_Date%TYPE;
307: l_Effective_End_Date Per_Spinal_Point_Steps_F.Effective_End_Date%TYPE;
308: l_Step_Ovn Per_Spinal_Point_Steps_F.Object_Version_Number%TYPE;
309: l_datetrack_mode Varchar2(30);
310: l_Scale_Delete Varchar2(1) := 'N';
311: l_Effective_Date Date;

Line 308: l_Step_Ovn Per_Spinal_Point_Steps_F.Object_Version_Number%TYPE;

304:
305: l_Step_Id Per_Spinal_Point_Steps_F.Step_Id%TYPE;
306: l_Effective_Start_Date Per_Spinal_Point_Steps_F.Effective_Start_Date%TYPE;
307: l_Effective_End_Date Per_Spinal_Point_Steps_F.Effective_End_Date%TYPE;
308: l_Step_Ovn Per_Spinal_Point_Steps_F.Object_Version_Number%TYPE;
309: l_datetrack_mode Varchar2(30);
310: l_Scale_Delete Varchar2(1) := 'N';
311: l_Effective_Date Date;
312: L_Hr_parent_Spine Per_grade_Spines_F.Parent_Spine_Id%TYPE;

Line 335: From Per_Spinal_Point_Steps_F

331: Cursor Csr_Step_Dtl(P_Step_Id IN Number) is
332: Select Effective_Start_Date,
333: Effective_End_Date,
334: Object_Version_Number
335: From Per_Spinal_Point_Steps_F
336: Where Step_Id = P_Step_Id
337: and P_Effective_Date
338: Between Effective_Start_Date
339: and Effective_End_Date;

Line 471: from Per_Spinal_Point_Steps_f

467: into l_Plcmt_Cnt
468: from Per_Spinal_POint_Placements_f
469: Where Step_Id in
470: (Select Step_Id
471: from Per_Spinal_Point_Steps_f
472: Where Grade_Spine_id = L_hr_Grade_Scale_id);
473:
474: If l_Plcmt_Cnt <> 0 Then
475: l_Datetrack_Mode := 'DELETE';

Line 645: From Per_Spinal_Point_Steps_F

641: Where Spinal_Point_Id = P_Point_id;
642:
643: Cursor Csr_Step (P_Point_id IN Number) Is
644: Select Step_id
645: From Per_Spinal_Point_Steps_F
646: Where Spinal_Point_Id = P_Point_id;
647:
648: Cursor Csr_Parent_Spine (P_Parent_Spine_Id IN Number) is
649: Select Object_Version_Number

Line 657: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;

653: --
654:
655: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;
656: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;
657: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
658: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;
659: L_Spinal_Cnt Number;
660: l_Prnt_ovn Per_Parent_Spines.Object_Version_Number%TYPE;
661: --