APPS.PER_SPP_UPD dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 78: (p_base_table_name => 'per_spinal_point_placements_f'

74: -- version number.
75: --
76: p_rec.object_version_number :=
77: dt_api.get_object_version_number
78: (p_base_table_name => 'per_spinal_point_placements_f'
79: ,p_base_key_column => 'placement_id'
80: ,p_base_key_value => p_rec.placement_id
81: );
82: --

Line 93: -- Update the per_spinal_point_placements_f Row

89: hr_utility.set_location('End Date '||p_validation_end_date, 10);
90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);
91: per_spp_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Update the per_spinal_point_placements_f Row
94: --
95: update per_spinal_point_placements_f
96: set
97: placement_id = p_rec.placement_id

Line 95: update per_spinal_point_placements_f

91: per_spp_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Update the per_spinal_point_placements_f Row
94: --
95: update per_spinal_point_placements_f
96: set
97: placement_id = p_rec.placement_id
98: ,business_group_id = p_rec.business_group_id
99: ,assignment_id = p_rec.assignment_id

Line 563: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'

559: --
560: when hr_api.cannot_find_prog_unit then
561: --
562: hr_api.cannot_find_prog_unit_error
563: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
564: ,p_hook_type => 'AU');
565: --
566: end;
567: --

Line 906: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

902: ) is
903: --
904: l_rec per_spp_shd.g_rec_type;
905: l_proc varchar2(72) := g_package||'upd';
906: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
907: --
908: Begin
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: hr_utility.set_location('assignment_id :'||p_assignment_id,5);

Line 984: from per_spinal_point_placements_f

980: hr_utility.set_location('Entering:'||l_proc, 7);
981: /*
982: select effective_start_date,effective_end_date
983: into l_rec.effective_start_date, l_rec.effective_end_date
984: from per_spinal_point_placements_f
985: where placement_id = p_placement_id
986: and p_effective_date between effective_start_date
987: and effective_end_date;
988: */