[Home] [Help]
525: l_spp_eff_start_date date;
526: l_spp_eff_end_date date;
527: l_object_version_number number;
528: l_grade_id per_grades.grade_id%type;
529: l_step_id per_spinal_point_steps_f.step_id%type;
530: l_dummy varchar2(2);
531: l_effective_start_date date;
532: l_effective_end_date date;
533: --
781: ) is
782: --
783: l_proc varchar2(72) := g_package||'post_insert';
784: -- Code changes start for bug 7457065
785: l_step_end_date per_spinal_point_steps_f.effective_end_date%type;
786:
787: cursor c_step_end_date is
788: select max(effective_end_date)
789: from per_spinal_point_steps_f
785: l_step_end_date per_spinal_point_steps_f.effective_end_date%type;
786:
787: cursor c_step_end_date is
788: select max(effective_end_date)
789: from per_spinal_point_steps_f
790: where step_id = p_rec.step_id;
791: -- Code changes end for bug 7457065
792:
793: Begin
971: ,p_datetrack_mode => p_datetrack_mode
972: ,p_base_table_name => 'per_spinal_point_placements_f'
973: ,p_base_key_column => 'placement_id'
974: ,p_base_key_value => p_rec.placement_id
975: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
976: ,p_parent_key_column1 => 'step_id'
977: ,p_parent_key_value1 => p_rec.step_id
978: -- ,p_parent_table_name2 => 'per_all_assignments_f'
979: -- ,p_parent_key_column2 => 'assignment_id'
990: ,p_datetrack_mode => p_datetrack_mode
991: ,p_base_table_name => 'per_spinal_point_placements_f'
992: ,p_base_key_column => 'placement_id'
993: ,p_base_key_value => p_rec.placement_id
994: --,p_parent_table_name1 => 'per_spinal_point_steps_f'
995: --,p_parent_key_column1 => 'step_id'
996: --,p_parent_key_value1 => p_rec.step_id
997: ,p_parent_table_name2 => 'per_all_assignments_f'
998: ,p_parent_key_column2 => 'assignment_id'