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 433: from per_spinal_point_placements_f

429: where step_id = p_rec.step_id;
430:
431: cursor c_next_placement_st_date is
432: select min(effective_start_date)
433: from per_spinal_point_placements_f
434: where assignment_id = p_rec.assignment_id
435: and effective_start_date > p_rec.effective_start_date;
436: -- code changes end for bug 7457065
437:

Line 461: update per_spinal_point_placements_f

457: end if;
458: hr_utility.set_location(l_proc, 9);
459: else
460: hr_utility.set_location(l_proc, 10);
461: update per_spinal_point_placements_f
462: set effective_end_date = l_step_end_date
463: where placement_id = p_rec.placement_id
464: and effective_start_date = p_rec.effective_start_date;
465: hr_utility.set_location(l_proc, 11);

Line 610: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'

606: --
607: when hr_api.cannot_find_prog_unit then
608: --
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
611: ,p_hook_type => 'AU');
612: --
613: end;
614: --

Line 953: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

949: ) is
950: --
951: l_rec per_spp_shd.g_rec_type;
952: l_proc varchar2(72) := g_package||'upd';
953: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
954: --
955: Begin
956: hr_utility.set_location('Entering:'||l_proc, 5);
957: hr_utility.set_location('assignment_id :'||p_assignment_id,5);

Line 1031: from per_spinal_point_placements_f

1027: hr_utility.set_location('Entering:'||l_proc, 7);
1028: /*
1029: select effective_start_date,effective_end_date
1030: into l_rec.effective_start_date, l_rec.effective_end_date
1031: from per_spinal_point_placements_f
1032: where placement_id = p_placement_id
1033: and p_effective_date between effective_start_date
1034: and effective_end_date;
1035: */