DBA Data[Home] [Help]

APPS.HR_SP_PLACEMENT_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

  ,p_program_update_date           in     date default null
  ,p_increment_number              in     number default null
  ,p_information1                  in     varchar2 default null
  ,p_information2                  in     varchar2 default null
  ,p_information3                  in     varchar2 default null
  ,p_information4                  in     varchar2 default null
  ,p_information5                  in     varchar2 default null
  ,p_information6                  in     varchar2 default null
  ,p_information7                  in     varchar2 default null
  ,p_information8                  in     varchar2 default null
  ,p_information9                  in     varchar2 default null
  ,p_information10                 in     varchar2 default null
  ,p_information11                 in     varchar2 default null
  ,p_information12                 in     varchar2 default null
  ,p_information13                 in     varchar2 default null
  ,p_information14                 in     varchar2 default null
  ,p_information15                 in     varchar2 default null
  ,p_information16                 in     varchar2 default null
  ,p_information17                 in     varchar2 default null
  ,p_information18                 in     varchar2 default null
  ,p_information19                 in     varchar2 default null
  ,p_information20                 in     varchar2 default null
  ,p_information21                 in     varchar2 default null
  ,p_information22                 in     varchar2 default null
  ,p_information23                 in     varchar2 default null
  ,p_information24                 in     varchar2 default null
  ,p_information25                 in     varchar2 default null
  ,p_information26                 in     varchar2 default null
  ,p_information27                 in     varchar2 default null
  ,p_information28                 in     varchar2 default null
  ,p_information29                 in     varchar2 default null
  ,p_information30                 in     varchar2 default null
  ,p_information_category          in     varchar2 default null
  ,p_placement_id                     out nocopy number
  ,p_object_version_number            out nocopy number
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ,p_replace_future_spp            in     boolean default false --Bug 2977842.
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date	   date;
Line: 89

  ,p_program_update_date           => p_program_update_date
  ,p_increment_number              => p_increment_number
  ,p_information1                  => p_information1
  ,p_information2                  => p_information2
  ,p_information3                  => p_information3
  ,p_information4                  => p_information4
  ,p_information5                  => p_information5
  ,p_information6                  => p_information6
  ,p_information7                  => p_information7
  ,p_information8                  => p_information8
  ,p_information9                  => p_information9
  ,p_information10                 => p_information10
  ,p_information11                 => p_information11
  ,p_information12                 => p_information12
  ,p_information13                 => p_information13
  ,p_information14                 => p_information14
  ,p_information15                 => p_information15
  ,p_information16                 => p_information16
  ,p_information17                 => p_information17
  ,p_information18                 => p_information18
  ,p_information19                 => p_information19
  ,p_information20                 => p_information20
  ,p_information21                 => p_information21
  ,p_information22                 => p_information22
  ,p_information23                 => p_information23
  ,p_information24                 => p_information24
  ,p_information25                 => p_information25
  ,p_information26                 => p_information26
  ,p_information27                 => p_information27
  ,p_information28                 => p_information28
  ,p_information29                 => p_information29
  ,p_information30                 => p_information30
  ,p_information_category          => p_information_category
  ,p_placement_id                  => l_placement_id
  ,p_object_version_number         => l_object_version_number
  ,p_effective_start_date          => l_effective_start_date
  ,p_effective_end_date            => l_effective_end_date
  ,p_replace_future_spp            => p_replace_future_spp --Bug 2977842.
  ,p_gsp_post_process_warning      => l_gsp_post_process_warning
  );
Line: 154

  ,p_program_update_date           in     date default null
  ,p_increment_number              in     number default null
  ,p_information1                  in     varchar2 default null
  ,p_information2                  in     varchar2 default null
  ,p_information3                  in     varchar2 default null
  ,p_information4                  in     varchar2 default null
  ,p_information5                  in     varchar2 default null
  ,p_information6                  in     varchar2 default null
  ,p_information7                  in     varchar2 default null
  ,p_information8                  in     varchar2 default null
  ,p_information9                  in     varchar2 default null
  ,p_information10                 in     varchar2 default null
  ,p_information11                 in     varchar2 default null
  ,p_information12                 in     varchar2 default null
  ,p_information13                 in     varchar2 default null
  ,p_information14                 in     varchar2 default null
  ,p_information15                 in     varchar2 default null
  ,p_information16                 in     varchar2 default null
  ,p_information17                 in     varchar2 default null
  ,p_information18                 in     varchar2 default null
  ,p_information19                 in     varchar2 default null
  ,p_information20                 in     varchar2 default null
  ,p_information21                 in     varchar2 default null
  ,p_information22                 in     varchar2 default null
  ,p_information23                 in     varchar2 default null
  ,p_information24                 in     varchar2 default null
  ,p_information25                 in     varchar2 default null
  ,p_information26                 in     varchar2 default null
  ,p_information27                 in     varchar2 default null
  ,p_information28                 in     varchar2 default null
  ,p_information29                 in     varchar2 default null
  ,p_information30                 in     varchar2 default null
  ,p_information_category          in     varchar2 default null
  ,p_placement_id                     out nocopy number
  ,p_object_version_number            out nocopy number
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ,p_replace_future_spp            in     boolean default false --Bug 2977842.
  ,p_gsp_post_process_warning         out nocopy varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date	   date;
Line: 268

  ,p_program_update_date	   =>   p_program_update_date
  ,p_increment_number		   =>   p_increment_number
  ,p_information1                  =>   p_information1
  ,p_information2                  =>   p_information2
  ,p_information3                  =>   p_information3
  ,p_information4                  =>   p_information4
  ,p_information5                  =>   p_information5
  ,p_information6                  =>   p_information6
  ,p_information7                  =>   p_information7
  ,p_information8                  =>   p_information8
  ,p_information9                  =>   p_information9
  ,p_information10                 =>   p_information10
  ,p_information11                 =>   p_information11
  ,p_information12                 =>   p_information12
  ,p_information13                 =>   p_information13
  ,p_information14                 =>   p_information14
  ,p_information15                 =>   p_information15
  ,p_information16                 =>   p_information16
  ,p_information17                 =>   p_information17
  ,p_information18                 =>   p_information18
  ,p_information19                 =>   p_information19
  ,p_information20                 =>   p_information20
  ,p_information21                 =>   p_information21
  ,p_information22                 =>   p_information22
  ,p_information23                 =>   p_information23
  ,p_information24                 =>   p_information24
  ,p_information25                 =>   p_information25
  ,p_information26                 =>   p_information26
  ,p_information27                 =>   p_information27
  ,p_information28                 =>   p_information28
  ,p_information29                 =>   p_information29
  ,p_information30                 =>   p_information30
  ,p_information_category          =>   p_information_category
  );
Line: 324

  ,p_program_update_date	   =>   p_program_update_date
  ,p_increment_number		   =>   p_increment_number
  ,p_placement_id		   =>   l_placement_id
  ,p_object_version_number	   =>	l_object_version_number
  ,p_effective_start_date	   =>   l_effective_start_date
  ,p_effective_end_date		   =>   l_effective_end_date
  ,p_information1                  =>   p_information1
  ,p_information2                  =>   p_information2
  ,p_information3                  =>   p_information3
  ,p_information4                  =>   p_information4
  ,p_information5                  =>   p_information5
  ,p_information6                  =>   p_information6
  ,p_information7                  =>   p_information7
  ,p_information8                  =>   p_information8
  ,p_information9                  =>   p_information9
  ,p_information10                 =>   p_information10
  ,p_information11                 =>   p_information11
  ,p_information12                 =>   p_information12
  ,p_information13                 =>   p_information13
  ,p_information14                 =>   p_information14
  ,p_information15                 =>   p_information15
  ,p_information16                 =>   p_information16
  ,p_information17                 =>   p_information17
  ,p_information18                 =>   p_information18
  ,p_information19                 =>   p_information19
  ,p_information20                 =>   p_information20
  ,p_information21                 =>   p_information21
  ,p_information22                 =>   p_information22
  ,p_information23                 =>   p_information23
  ,p_information24                 =>   p_information24
  ,p_information25                 =>   p_information25
  ,p_information26                 =>   p_information26
  ,p_information27                 =>   p_information27
  ,p_information28                 =>   p_information28
  ,p_information29                 =>   p_information29
  ,p_information30                 =>   p_information30
  ,p_information_category          =>   p_information_category
  ,p_replace_future_spp            =>   p_replace_future_spp  -- bug 8762555
  );
Line: 378

  ,p_program_update_date           =>   p_program_update_date
  ,p_increment_number              =>   p_increment_number
  ,p_placement_id                  =>   l_placement_id
  ,p_object_version_number         =>   l_object_version_number
  ,p_effective_start_date          =>   l_effective_start_date
  ,p_effective_end_date            =>   l_effective_end_date
  ,p_information1                  =>   p_information1
  ,p_information2                  =>   p_information2
  ,p_information3                  =>   p_information3
  ,p_information4                  =>   p_information4
  ,p_information5                  =>   p_information5
  ,p_information6                  =>   p_information6
  ,p_information7                  =>   p_information7
  ,p_information8                  =>   p_information8
  ,p_information9                  =>   p_information9
  ,p_information10                 =>   p_information10
  ,p_information11                 =>   p_information11
  ,p_information12                 =>   p_information12
  ,p_information13                 =>   p_information13
  ,p_information14                 =>   p_information14
  ,p_information15                 =>   p_information15
  ,p_information16                 =>   p_information16
  ,p_information17                 =>   p_information17
  ,p_information18                 =>   p_information18
  ,p_information19                 =>   p_information19
  ,p_information20                 =>   p_information20
  ,p_information21                 =>   p_information21
  ,p_information22                 =>   p_information22
  ,p_information23                 =>   p_information23
  ,p_information24                 =>   p_information24
  ,p_information25                 =>   p_information25
  ,p_information26                 =>   p_information26
  ,p_information27                 =>   p_information27
  ,p_information28                 =>   p_information28
  ,p_information29                 =>   p_information29
  ,p_information30                 =>   p_information30
  ,p_information_category          =>   p_information_category
  );
Line: 489

procedure update_spp
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_mode		   in     varchar2 default hr_api.g_update
  ,p_placement_id                  in     number
  ,p_object_version_number	   in out nocopy number
  ,p_step_id                       in     number   default hr_api.g_number
  ,p_auto_increment_flag           in     varchar2 default hr_api.g_varchar2
  ,p_reason                        in     varchar2 default hr_api.g_varchar2
  ,p_request_id                    in     number   default hr_api.g_number
  ,p_program_application_id        in     number   default hr_api.g_number
  ,p_program_id                    in     number   default hr_api.g_number
  ,p_program_update_date           in     date     default hr_api.g_date
  ,p_increment_number              in     number   default hr_api.g_number
  ,p_information1                  in     varchar2 default hr_api.g_varchar2
  ,p_information2                  in     varchar2 default hr_api.g_varchar2
  ,p_information3                  in     varchar2 default hr_api.g_varchar2
  ,p_information4                  in     varchar2 default hr_api.g_varchar2
  ,p_information5                  in     varchar2 default hr_api.g_varchar2
  ,p_information6                  in     varchar2 default hr_api.g_varchar2
  ,p_information7                  in     varchar2 default hr_api.g_varchar2
  ,p_information8                  in     varchar2 default hr_api.g_varchar2
  ,p_information9                  in     varchar2 default hr_api.g_varchar2
  ,p_information10                 in     varchar2 default hr_api.g_varchar2
  ,p_information11                 in     varchar2 default hr_api.g_varchar2
  ,p_information12                 in     varchar2 default hr_api.g_varchar2
  ,p_information13                 in     varchar2 default hr_api.g_varchar2
  ,p_information14                 in     varchar2 default hr_api.g_varchar2
  ,p_information15                 in     varchar2 default hr_api.g_varchar2
  ,p_information16                 in     varchar2 default hr_api.g_varchar2
  ,p_information17                 in     varchar2 default hr_api.g_varchar2
  ,p_information18                 in     varchar2 default hr_api.g_varchar2
  ,p_information19                 in     varchar2 default hr_api.g_varchar2
  ,p_information20                 in     varchar2 default hr_api.g_varchar2
  ,p_information21                 in     varchar2 default hr_api.g_varchar2
  ,p_information22                 in     varchar2 default hr_api.g_varchar2
  ,p_information23                 in     varchar2 default hr_api.g_varchar2
  ,p_information24                 in     varchar2 default hr_api.g_varchar2
  ,p_information25                 in     varchar2 default hr_api.g_varchar2
  ,p_information26                 in     varchar2 default hr_api.g_varchar2
  ,p_information27                 in     varchar2 default hr_api.g_varchar2
  ,p_information28                 in     varchar2 default hr_api.g_varchar2
  ,p_information29                 in     varchar2 default hr_api.g_varchar2
  ,p_information30                 in     varchar2 default hr_api.g_varchar2
  ,p_information_category          in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date          in out nocopy date
  ,p_effective_end_date            in out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
   l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
Line: 564

  l_proc                varchar2(72) := g_package||'update_spinal_point_placement';
Line: 574

  hr_sp_placement_api.update_spp
  (p_validate                      =>   p_validate
  ,p_effective_date                =>   l_effective_date
  ,p_datetrack_mode                =>   p_datetrack_mode
  ,p_placement_id		   =>   p_placement_id
  ,p_object_version_number	   =>	l_object_version_number
  ,p_step_id                       =>   p_step_id
  ,p_auto_increment_flag           =>   p_auto_increment_flag
  ,p_reason                        =>   p_reason
  ,p_request_id                    =>   p_request_id
  ,p_program_application_id        =>   p_program_application_id
  ,p_program_id                    =>   p_program_id
  ,p_program_update_date           =>   p_program_update_date
  ,p_increment_number              =>   p_increment_number
  ,p_information1                  =>   p_information1
  ,p_information2                  =>   p_information2
  ,p_information3                  =>   p_information3
  ,p_information4                  =>   p_information4
  ,p_information5                  =>   p_information5
  ,p_information6                  =>   p_information6
  ,p_information7                  =>   p_information7
  ,p_information8                  =>   p_information8
  ,p_information9                  =>   p_information9
  ,p_information10                 =>   p_information10
  ,p_information11                 =>   p_information11
  ,p_information12                 =>   p_information12
  ,p_information13                 =>   p_information13
  ,p_information14                 =>   p_information14
  ,p_information15                 =>   p_information15
  ,p_information16                 =>   p_information16
  ,p_information17                 =>   p_information17
  ,p_information18                 =>   p_information18
  ,p_information19                 =>   p_information19
  ,p_information20                 =>   p_information20
  ,p_information21                 =>   p_information21
  ,p_information22                 =>   p_information22
  ,p_information23                 =>   p_information23
  ,p_information24                 =>   p_information24
  ,p_information25                 =>   p_information25
  ,p_information26                 =>   p_information26
  ,p_information27                 =>   p_information27
  ,p_information28                 =>   p_information28
  ,p_information29                 =>   p_information29
  ,p_information30                 =>   p_information30
  ,p_information_category          =>   p_information_category
  ,p_effective_start_date 	   =>   l_effective_start_date
  ,p_effective_end_date		   =>   l_effective_end_date
  ,p_gsp_post_process_warning      =>   l_gsp_post_process_warning
  );
Line: 630

end update_spp;
Line: 637

procedure update_spp
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_mode		   in     varchar2 default hr_api.g_update
  ,p_placement_id                  in     number
  ,p_object_version_number	   in out nocopy number
  ,p_step_id                       in     number   default hr_api.g_number
  ,p_auto_increment_flag           in     varchar2 default hr_api.g_varchar2
  ,p_reason                        in     varchar2 default hr_api.g_varchar2
  ,p_request_id                    in     number   default hr_api.g_number
  ,p_program_application_id        in     number   default hr_api.g_number
  ,p_program_id                    in     number   default hr_api.g_number
  ,p_program_update_date           in     date     default hr_api.g_date
  ,p_increment_number              in     number   default hr_api.g_number
  ,p_information1                  in     varchar2 default hr_api.g_varchar2
  ,p_information2                  in     varchar2 default hr_api.g_varchar2
  ,p_information3                  in     varchar2 default hr_api.g_varchar2
  ,p_information4                  in     varchar2 default hr_api.g_varchar2
  ,p_information5                  in     varchar2 default hr_api.g_varchar2
  ,p_information6                  in     varchar2 default hr_api.g_varchar2
  ,p_information7                  in     varchar2 default hr_api.g_varchar2
  ,p_information8                  in     varchar2 default hr_api.g_varchar2
  ,p_information9                  in     varchar2 default hr_api.g_varchar2
  ,p_information10                 in     varchar2 default hr_api.g_varchar2
  ,p_information11                 in     varchar2 default hr_api.g_varchar2
  ,p_information12                 in     varchar2 default hr_api.g_varchar2
  ,p_information13                 in     varchar2 default hr_api.g_varchar2
  ,p_information14                 in     varchar2 default hr_api.g_varchar2
  ,p_information15                 in     varchar2 default hr_api.g_varchar2
  ,p_information16                 in     varchar2 default hr_api.g_varchar2
  ,p_information17                 in     varchar2 default hr_api.g_varchar2
  ,p_information18                 in     varchar2 default hr_api.g_varchar2
  ,p_information19                 in     varchar2 default hr_api.g_varchar2
  ,p_information20                 in     varchar2 default hr_api.g_varchar2
  ,p_information21                 in     varchar2 default hr_api.g_varchar2
  ,p_information22                 in     varchar2 default hr_api.g_varchar2
  ,p_information23                 in     varchar2 default hr_api.g_varchar2
  ,p_information24                 in     varchar2 default hr_api.g_varchar2
  ,p_information25                 in     varchar2 default hr_api.g_varchar2
  ,p_information26                 in     varchar2 default hr_api.g_varchar2
  ,p_information27                 in     varchar2 default hr_api.g_varchar2
  ,p_information28                 in     varchar2 default hr_api.g_varchar2
  ,p_information29                 in     varchar2 default hr_api.g_varchar2
  ,p_information30                 in     varchar2 default hr_api.g_varchar2
  ,p_information_category          in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date          in out nocopy date
  ,p_effective_end_date            in out nocopy date
  ,p_gsp_post_process_warning         out nocopy varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
   l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
Line: 713

  l_proc                varchar2(72) := g_package||'update_spinal_point_placement';
Line: 720

  savepoint update_spinal_point_placement;
Line: 747

  hr_utility.set_location('Entering: call - update_spinal_point_placement_b ', 30);
Line: 760

  select parent_spine_id, business_group_id, assignment_id
  into l_parent_spine_id, l_business_group_id, l_assignment_id
  from per_spinal_point_placements_f
  where placement_id = p_placement_id
  and l_effective_date between effective_start_date
                           and effective_end_date;
Line: 773

hr_sp_placement_api_bk2.update_sp_placement_b
  (p_effective_date                =>   l_effective_date
  ,p_datetrack_mode                =>   p_datetrack_mode
  ,p_placement_id		   =>   p_placement_id
  ,p_object_version_number	   =>	p_object_version_number
  ,p_business_group_id             =>   l_business_group_id
  ,p_assignment_id                 =>   l_assignment_id
  ,p_step_id                       =>   p_step_id
  ,p_auto_increment_flag           =>   p_auto_increment_flag
  ,p_parent_spine_id               =>   l_parent_spine_id
  ,p_reason                        =>   p_reason
  ,p_request_id                    =>   p_request_id
  ,p_program_application_id        =>   p_program_application_id
  ,p_program_id                    =>   p_program_id
  ,p_program_update_date           =>   p_program_update_date
  ,p_increment_number              =>   p_increment_number
  ,p_information1                  =>   p_information1
  ,p_information2                  =>   p_information2
  ,p_information3                  =>   p_information3
  ,p_information4                  =>   p_information4
  ,p_information5                  =>   p_information5
  ,p_information6                  =>   p_information6
  ,p_information7                  =>   p_information7
  ,p_information8                  =>   p_information8
  ,p_information9                  =>   p_information9
  ,p_information10                 =>   p_information10
  ,p_information11                 =>   p_information11
  ,p_information12                 =>   p_information12
  ,p_information13                 =>   p_information13
  ,p_information14                 =>   p_information14
  ,p_information15                 =>   p_information15
  ,p_information16                 =>   p_information16
  ,p_information17                 =>   p_information17
  ,p_information18                 =>   p_information18
  ,p_information19                 =>   p_information19
  ,p_information20                 =>   p_information20
  ,p_information21                 =>   p_information21
  ,p_information22                 =>   p_information22
  ,p_information23                 =>   p_information23
  ,p_information24                 =>   p_information24
  ,p_information25                 =>   p_information25
  ,p_information26                 =>   p_information26
  ,p_information27                 =>   p_information27
  ,p_information28                 =>   p_information28
  ,p_information29                 =>   p_information29
  ,p_information30                 =>   p_information30
  ,p_information_category          =>   p_information_category
  -- ,p_effective_start_date 	   =>   l_effective_start_date
  -- ,p_effetcive_end_date		   =>   l_effective_end_date
  );
Line: 826

        (p_module_name => 'UPDATE_SPINAL_POINT_PLACEMENT'
        ,p_hook_type   => 'BP'
        );
Line: 847

  ,p_program_update_date           =>   p_program_update_date
  ,p_increment_number              =>   p_increment_number
  ,p_effective_start_date	   =>   l_effective_start_date
  ,p_effective_end_date		   =>   l_effective_end_date
  ,p_information1                  =>   p_information1
  ,p_information2                  =>   p_information2
  ,p_information3                  =>   p_information3
  ,p_information4                  =>   p_information4
  ,p_information5                  =>   p_information5
  ,p_information6                  =>   p_information6
  ,p_information7                  =>   p_information7
  ,p_information8                  =>   p_information8
  ,p_information9                  =>   p_information9
  ,p_information10                 =>   p_information10
  ,p_information11                 =>   p_information11
  ,p_information12                 =>   p_information12
  ,p_information13                 =>   p_information13
  ,p_information14                 =>   p_information14
  ,p_information15                 =>   p_information15
  ,p_information16                 =>   p_information16
  ,p_information17                 =>   p_information17
  ,p_information18                 =>   p_information18
  ,p_information19                 =>   p_information19
  ,p_information20                 =>   p_information20
  ,p_information21                 =>   p_information21
  ,p_information22                 =>   p_information22
  ,p_information23                 =>   p_information23
  ,p_information24                 =>   p_information24
  ,p_information25                 =>   p_information25
  ,p_information26                 =>   p_information26
  ,p_information27                 =>   p_information27
  ,p_information28                 =>   p_information28
  ,p_information29                 =>   p_information29
  ,p_information30                 =>   p_information30
  ,p_information_category          =>   p_information_category
  );
Line: 893

  hr_utility.set_location('Entering: call - update_spinal_point_placement_a', 50);
Line: 898

hr_sp_placement_api_bk2.update_sp_placement_a
  (p_effective_date                =>   l_effective_date
  ,p_datetrack_mode		   =>   p_datetrack_mode
  ,p_placement_id                  =>   p_placement_id
  ,p_object_version_number         =>   p_object_version_number
  ,p_business_group_id             =>   l_business_group_id
  ,p_assignment_id                 =>   l_assignment_id
  ,p_step_id                       =>   p_step_id
  ,p_auto_increment_flag           =>   p_auto_increment_flag
  ,p_parent_spine_id               =>   l_parent_spine_id
  ,p_reason                        =>   p_reason
  ,p_request_id                    =>   p_request_id
  ,p_program_application_id        =>   p_program_application_id
  ,p_program_id                    =>   p_program_id
  ,p_program_update_date           =>   p_program_update_date
  ,p_increment_number              =>   p_increment_number
  ,p_effective_start_date          =>   l_effective_start_date
  ,p_effective_end_date            =>   l_effective_end_date
  ,p_information1                  =>   p_information1
  ,p_information2                  =>   p_information2
  ,p_information3                  =>   p_information3
  ,p_information4                  =>   p_information4
  ,p_information5                  =>   p_information5
  ,p_information6                  =>   p_information6
  ,p_information7                  =>   p_information7
  ,p_information8                  =>   p_information8
  ,p_information9                  =>   p_information9
  ,p_information10                 =>   p_information10
  ,p_information11                 =>   p_information11
  ,p_information12                 =>   p_information12
  ,p_information13                 =>   p_information13
  ,p_information14                 =>   p_information14
  ,p_information15                 =>   p_information15
  ,p_information16                 =>   p_information16
  ,p_information17                 =>   p_information17
  ,p_information18                 =>   p_information18
  ,p_information19                 =>   p_information19
  ,p_information20                 =>   p_information20
  ,p_information21                 =>   p_information21
  ,p_information22                 =>   p_information22
  ,p_information23                 =>   p_information23
  ,p_information24                 =>   p_information24
  ,p_information25                 =>   p_information25
  ,p_information26                 =>   p_information26
  ,p_information27                 =>   p_information27
  ,p_information28                 =>   p_information28
  ,p_information29                 =>   p_information29
  ,p_information30                 =>   p_information30
  ,p_information_category          =>   p_information_category
  );
Line: 952

        (p_module_name => 'UPDATE_SPINAL_POINT_PLACEMENT'
        ,p_hook_type   => 'AP'
        );
Line: 989

    rollback to update_spinal_point_placement;
Line: 1006

    rollback to update_spinal_point_placement;
Line: 1009

end update_spp;
Line: 1015

procedure delete_spp
  (p_validate			    in	   boolean  default false
  ,p_effective_date		    in	   date
  ,p_datetrack_mode		    in     varchar2 default hr_api.g_delete
  ,p_placement_id		    in     number
  ,p_object_version_number          in out nocopy number
  ,p_effective_start_date	       out nocopy date
  ,p_effective_end_date		       out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := (g_package||'delete_spinal_point_placement');
Line: 1050

  savepoint delete_spinal_point_placement;
Line: 1063

    hr_sp_placement_api_bk3.delete_sp_placement_b
      (p_effective_date			=>  l_effective_date
      ,p_datetrack_mode			=>  p_datetrack_mode
      ,p_placement_id			=>  p_placement_id
      ,p_object_version_number          =>  p_object_version_number
      );
Line: 1072

        (p_module_name => 'delete_spinal_point_placement'
        ,p_hook_type   => 'BP'
        );
Line: 1095

    hr_sp_placement_api_bk3.delete_sp_placement_a
      (p_effective_date                 =>  l_effective_date
      ,p_datetrack_mode                 =>  p_datetrack_mode
      ,p_placement_id                   =>  p_placement_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      );
Line: 1106

        (p_module_name => 'delete_spinal_point_placement'
        ,p_hook_type   => 'AP'
        );
Line: 1132

    ROLLBACK TO delete_spinal_point_placement;
Line: 1146

    ROLLBACK TO delete_spinal_point_placement;
Line: 1149

end delete_spp;