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 338: From Per_Spinal_Point_Steps_F

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

Line 487: from Per_Spinal_Point_Steps_f

483: into l_Plcmt_Cnt
484: from Per_Spinal_POint_Placements_f
485: Where Step_Id in
486: (Select Step_Id
487: from Per_Spinal_Point_Steps_f
488: Where Grade_Spine_id = L_hr_Grade_Scale_id);
489:
490: If l_Plcmt_Cnt <> 0 Then
491: l_Datetrack_Mode := 'DELETE';

Line 678: From Per_Spinal_Point_Steps_F

674: Where Spinal_Point_Id = P_Point_id;
675:
676: Cursor Csr_Step (P_Point_id IN Number) Is
677: Select Step_id
678: From Per_Spinal_Point_Steps_F
679: Where Spinal_Point_Id = P_Point_id;
680:
681: Cursor Csr_Parent_Spine (P_Parent_Spine_Id IN Number) is
682: Select Object_Version_Number

Line 690: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;

686: --
687:
688: l_Point_Id Per_Spinal_points.spinal_point_id%TYPE;
689: l_parent_Spine_id Per_Parent_Spines.Parent_Spine_Id%TYPE;
690: l_Step_id Per_Spinal_POint_Steps_F.Step_Id%TYPE;
691: l_Point_ovn Per_Spinal_Points.Object_Version_Number%TYPE;
692: L_Spinal_Cnt Number;
693: l_Prnt_ovn Per_Parent_Spines.Object_Version_Number%TYPE;
694: --