eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_SEARCH_CRITERIA_API SQL Statements

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

Line: 477


procedure UPDATE_SAVED_SEARCH
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_search_criteria_id            in     number
  ,p_person_id                     in     number   default hr_api.g_number
  ,p_search_name                   in     varchar2 default hr_api.g_varchar2
  ,p_location                      in     varchar2 default hr_api.g_varchar2
  ,p_distance_to_location          in     varchar2 default hr_api.g_varchar2
  ,p_geocode_location              in     varchar2 default hr_api.g_varchar2
  ,p_geocode_country               in     varchar2 default hr_api.g_varchar2
  ,p_derived_location              in     varchar2 default hr_api.g_varchar2
  ,p_location_id                   in     number   default hr_api.g_number
  ,p_longitude                     in     number   default hr_api.g_number
  ,p_latitude                      in     number   default hr_api.g_number
  ,p_employee                      in     varchar2 default hr_api.g_varchar2
  ,p_contractor                    in     varchar2 default hr_api.g_varchar2
  ,p_employment_category           in     varchar2 default hr_api.g_varchar2
  ,p_keywords                      in     varchar2 default hr_api.g_varchar2
  ,p_travel_percentage             in     number   default hr_api.g_number
  ,p_min_salary                    in     number   default hr_api.g_number
  ,p_salary_currency               in     varchar2 default hr_api.g_varchar2
  ,p_salary_period                 in     varchar2 default hr_api.g_varchar2
  ,p_match_competence              in     varchar2 default hr_api.g_varchar2
  ,p_match_qualification           in     varchar2 default hr_api.g_varchar2
  ,p_work_at_home                  in     varchar2 default hr_api.g_varchar2
  ,p_job_title                     in     varchar2 default hr_api.g_varchar2
  ,p_department                    in     varchar2 default hr_api.g_varchar2
  ,p_professional_area             in     varchar2 default hr_api.g_varchar2
  ,p_use_for_matching              in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ,p_isc_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_isc_information1              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information2              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information3              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information4              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information5              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information6              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information7              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information8              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information9              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information10             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information11             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information12             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information13             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information14             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information15             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information16             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information17             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information18             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information19             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information20             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information21             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information22             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information23             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information24             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information25             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information26             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information27             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information28             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information29             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information30             in     varchar2 default hr_api.g_varchar2
  ,p_date_posted                   in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                 varchar2(72) := g_package||'UPDATE_SAVED_SEARCH';

Line: 586


  savepoint UPDATE_SAVED_SEARCH;

Line: 595


  IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_B
  (p_effective_date             =>     l_effective_date
  ,p_search_criteria_id         =>     p_search_criteria_id
  ,p_person_id                  =>     p_person_id
  ,p_search_name                =>     p_search_name
  ,p_location                   =>     p_location
  ,p_distance_to_location       =>     p_distance_to_location
  ,p_geocode_location           =>     p_geocode_location
  ,p_geocode_country            =>     p_geocode_country
  ,p_derived_location           =>     p_derived_location
  ,p_location_id                =>     p_location_id
  ,p_longitude                  =>     p_longitude
  ,p_latitude                   =>     p_latitude
  ,p_contractor                 =>     p_contractor
  ,p_employee                   =>     p_employee
  ,p_employment_category        =>     p_employment_category
  ,p_keywords                   =>     p_keywords
  ,p_travel_percentage          =>     p_travel_percentage
  ,p_min_salary                 =>     p_min_salary
  ,p_salary_currency            =>     p_salary_currency
  ,p_salary_period              =>     p_salary_period
  ,p_match_competence           =>     p_match_competence
  ,p_match_qualification        =>     p_match_qualification
  ,p_work_at_home               =>     p_work_at_home
  ,p_job_title                  =>     p_job_title
  ,p_department                 =>     p_department
  ,p_professional_area          =>     p_professional_area
  ,p_use_for_matching           =>     p_use_for_matching
  ,p_description                =>     p_description
  ,p_attribute_category         =>     p_attribute_category
  ,p_attribute1                 =>     p_attribute1
  ,p_attribute2                 =>     p_attribute2
  ,p_attribute3                 =>     p_attribute3
  ,p_attribute4                 =>     p_attribute4
  ,p_attribute5                 =>     p_attribute5
  ,p_attribute6                 =>     p_attribute6
  ,p_attribute7                 =>     p_attribute7
  ,p_attribute8                 =>     p_attribute8
  ,p_attribute9                 =>     p_attribute9
  ,p_attribute10                =>     p_attribute10
  ,p_attribute11                =>     p_attribute11
  ,p_attribute12                =>     p_attribute12
  ,p_attribute13                =>     p_attribute13
  ,p_attribute14                =>     p_attribute14
  ,p_attribute15                =>     p_attribute15
  ,p_attribute16                =>     p_attribute16
  ,p_attribute17                =>     p_attribute17
  ,p_attribute18                =>     p_attribute18
  ,p_attribute19                =>     p_attribute19
  ,p_attribute20                =>     p_attribute20
  ,p_attribute21                =>     p_attribute21
  ,p_attribute22                =>     p_attribute22
  ,p_attribute23                =>     p_attribute23
  ,p_attribute24                =>     p_attribute24
  ,p_attribute25                =>     p_attribute25
  ,p_attribute26                =>     p_attribute26
  ,p_attribute27                =>     p_attribute27
  ,p_attribute28                =>     p_attribute28
  ,p_attribute29                =>     p_attribute29
  ,p_attribute30                =>     p_attribute30
  ,p_isc_information_category   =>     p_isc_information_category
  ,p_isc_information1           =>     p_isc_information1
  ,p_isc_information2           =>     p_isc_information2
  ,p_isc_information3           =>     p_isc_information3
  ,p_isc_information4           =>     p_isc_information4
  ,p_isc_information5           =>     p_isc_information5
  ,p_isc_information6           =>     p_isc_information6
  ,p_isc_information7           =>     p_isc_information7
  ,p_isc_information8           =>     p_isc_information8
  ,p_isc_information9           =>     p_isc_information9
  ,p_isc_information10          =>     p_isc_information10
  ,p_isc_information11          =>     p_isc_information11
  ,p_isc_information12          =>     p_isc_information12
  ,p_isc_information13          =>     p_isc_information13
  ,p_isc_information14          =>     p_isc_information14
  ,p_isc_information15          =>     p_isc_information15
  ,p_isc_information16          =>     p_isc_information16
  ,p_isc_information17          =>     p_isc_information17
  ,p_isc_information18          =>     p_isc_information18
  ,p_isc_information19          =>     p_isc_information19
  ,p_isc_information20          =>     p_isc_information20
  ,p_isc_information21          =>     p_isc_information21
  ,p_isc_information22          =>     p_isc_information22
  ,p_isc_information23          =>     p_isc_information23
  ,p_isc_information24          =>     p_isc_information24
  ,p_isc_information25          =>     p_isc_information25
  ,p_isc_information26          =>     p_isc_information26
  ,p_isc_information27          =>     p_isc_information27
  ,p_isc_information28          =>     p_isc_information28
  ,p_isc_information29          =>     p_isc_information29
  ,p_isc_information30          =>     p_isc_information30
  ,p_date_posted                =>     p_date_posted
  ,p_object_version_number      =>     l_object_version_number
  );

Line: 692


        (p_module_name => 'UPDATE_SAVED_SEARCH'
        ,p_hook_type   => 'BP'
        );

Line: 800


  IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_A
  (p_effective_date                =>     l_effective_date
  ,p_search_criteria_id            =>     p_search_criteria_id
  ,p_person_id                     =>     p_person_id
  ,p_search_name                   =>     p_search_name
  ,p_location                      =>     p_location
  ,p_distance_to_location          =>     p_distance_to_location
  ,p_geocode_location              =>     p_geocode_location
  ,p_geocode_country               =>     p_geocode_country
  ,p_derived_location              =>     p_derived_location
  ,p_location_id                   =>     p_location_id
  ,p_longitude                     =>     p_longitude
  ,p_latitude                      =>     p_latitude
  ,p_contractor                    =>     p_contractor
  ,p_employee                      =>     p_employee
  ,p_employment_category           =>     p_employment_category
  ,p_keywords                      =>     p_keywords
  ,p_travel_percentage             =>     p_travel_percentage
  ,p_min_salary                    =>     p_min_salary
  ,p_salary_currency               =>     p_salary_currency
  ,p_salary_period                 =>     p_salary_period
  ,p_match_competence              =>     p_match_competence
  ,p_match_qualification           =>     p_match_qualification
  ,p_work_at_home                  =>     p_work_at_home
  ,p_job_title                     =>     p_job_title
  ,p_department                    =>     p_department
  ,p_professional_area             =>     p_professional_area
  ,p_use_for_matching              =>     p_use_for_matching
  ,p_description                   =>     p_description
  ,p_attribute_category            =>     p_attribute_category
  ,p_attribute1                    =>     p_attribute1
  ,p_attribute2                    =>     p_attribute2
  ,p_attribute3                    =>     p_attribute3
  ,p_attribute4                    =>     p_attribute4
  ,p_attribute5                    =>     p_attribute5
  ,p_attribute6                    =>     p_attribute6
  ,p_attribute7                    =>     p_attribute7
  ,p_attribute8                    =>     p_attribute8
  ,p_attribute9                    =>     p_attribute9
  ,p_attribute10                   =>     p_attribute10
  ,p_attribute11                   =>     p_attribute11
  ,p_attribute12                   =>     p_attribute12
  ,p_attribute13                   =>     p_attribute13
  ,p_attribute14                   =>     p_attribute14
  ,p_attribute15                   =>     p_attribute15
  ,p_attribute16                   =>     p_attribute16
  ,p_attribute17                   =>     p_attribute17
  ,p_attribute18                   =>     p_attribute18
  ,p_attribute19                   =>     p_attribute19
  ,p_attribute20                   =>     p_attribute20
  ,p_attribute21                   =>     p_attribute21
  ,p_attribute22                   =>     p_attribute22
  ,p_attribute23                   =>     p_attribute23
  ,p_attribute24                   =>     p_attribute24
  ,p_attribute25                   =>     p_attribute25
  ,p_attribute26                   =>     p_attribute26
  ,p_attribute27                   =>     p_attribute27
  ,p_attribute28                   =>     p_attribute28
  ,p_attribute29                   =>     p_attribute29
  ,p_attribute30                   =>     p_attribute30
  ,p_isc_information_category      =>     p_isc_information_category
  ,p_isc_information1              =>     p_isc_information1
  ,p_isc_information2              =>     p_isc_information2
  ,p_isc_information3              =>     p_isc_information3
  ,p_isc_information4              =>     p_isc_information4
  ,p_isc_information5              =>     p_isc_information5
  ,p_isc_information6              =>     p_isc_information6
  ,p_isc_information7              =>     p_isc_information7
  ,p_isc_information8              =>     p_isc_information8
  ,p_isc_information9              =>     p_isc_information9
  ,p_isc_information10             =>     p_isc_information10
  ,p_isc_information11             =>     p_isc_information11
  ,p_isc_information12             =>     p_isc_information12
  ,p_isc_information13             =>     p_isc_information13
  ,p_isc_information14             =>     p_isc_information14
  ,p_isc_information15             =>     p_isc_information15
  ,p_isc_information16             =>     p_isc_information16
  ,p_isc_information17             =>     p_isc_information17
  ,p_isc_information18             =>     p_isc_information18
  ,p_isc_information19             =>     p_isc_information19
  ,p_isc_information20             =>     p_isc_information20
  ,p_isc_information21             =>     p_isc_information21
  ,p_isc_information22             =>     p_isc_information22
  ,p_isc_information23             =>     p_isc_information23
  ,p_isc_information24             =>     p_isc_information24
  ,p_isc_information25             =>     p_isc_information25
  ,p_isc_information26             =>     p_isc_information26
  ,p_isc_information27             =>     p_isc_information27
  ,p_isc_information28             =>     p_isc_information28
  ,p_isc_information29             =>     p_isc_information29
  ,p_isc_information30             =>     p_isc_information30
  ,p_date_posted                   =>     p_date_posted
  ,p_object_version_number         =>     l_object_version_number
  );

Line: 897


        (p_module_name => 'UPDATE_SAVED_SEARCH'
        ,p_hook_type   => 'AP'
        );

Line: 919


    rollback to UPDATE_SAVED_SEARCH;

Line: 934


    rollback to UPDATE_SAVED_SEARCH;

Line: 941


end UPDATE_SAVED_SEARCH;

Line: 947


procedure DELETE_SAVED_SEARCH
  (p_validate                      in     boolean  default false
  ,p_search_criteria_id            in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                 varchar2(72) := g_package||'DELETE_SAVED_SEARCH';

Line: 963


  savepoint DELETE_SAVED_SEARCH;

Line: 970


  IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_B
  (p_search_criteria_id         =>     p_search_criteria_id
  ,p_object_version_number      =>     p_object_version_number
  );

Line: 977


        (p_module_name => 'DELETE_SAVED_SEARCH'
        ,p_hook_type   => 'BP'
        );

Line: 994


  IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_A
  (p_search_criteria_id         =>     p_search_criteria_id
  ,p_object_version_number      =>     p_object_version_number
  );

Line: 1001


        (p_module_name => 'DELETE_SAVED_SEARCH'
        ,p_hook_type   => 'AP'
        );

Line: 1022


    rollback to DELETE_SAVED_SEARCH;

Line: 1033


    rollback to DELETE_SAVED_SEARCH;

Line: 1036


end DELETE_SAVED_SEARCH;

Line: 1462


procedure UPDATE_VACANCY_CRITERIA
  (p_validate                      in     boolean  default false
  ,p_search_criteria_id            in     number
  ,p_vacancy_id                    in     number   default hr_api.g_number
  ,p_effective_date                in     date
  ,p_location                      in     varchar2 default hr_api.g_varchar2
  ,p_employee                      in     varchar2 default hr_api.g_varchar2
  ,p_contractor                    in     varchar2 default hr_api.g_varchar2
  ,p_employment_category           in     varchar2 default hr_api.g_varchar2
  ,p_keywords                      in     varchar2 default hr_api.g_varchar2
  ,p_travel_percentage             in     number   default hr_api.g_number
  ,p_min_salary                    in     number   default hr_api.g_number
  ,p_max_salary                    in     number   default hr_api.g_number
  ,p_salary_currency               in     varchar2 default hr_api.g_varchar2
  ,p_salary_period                 in     varchar2 default hr_api.g_varchar2
  ,p_professional_area             in     varchar2 default hr_api.g_varchar2
  ,p_work_at_home                  in     varchar2 default hr_api.g_varchar2
  ,p_min_qual_level                in     number   default hr_api.g_number
  ,p_max_qual_level                in     number   default hr_api.g_number
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ,p_isc_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_isc_information1              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information2              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information3              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information4              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information5              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information6              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information7              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information8              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information9              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information10             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information11             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information12             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information13             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information14             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information15             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information16             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information17             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information18             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information19             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information20             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information21             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information22             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information23             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information24             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information25             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information26             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information27             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information28             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information29             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information30             in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                 varchar2(72) := g_package||'UPDATE_VACANCY_CRITERIA';

Line: 1560


  savepoint UPDATE_VACANCY_CRITERIA;

Line: 1569


  IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_B
  (p_vacancy_id                 =>     p_vacancy_id
  ,p_search_criteria_id         =>     p_search_criteria_id
  ,p_effective_date             =>     l_effective_date
  ,p_location                   =>     p_location
  ,p_contractor                 =>     p_contractor
  ,p_employee                   =>     p_employee
  ,p_employment_category        =>     p_employment_category
  ,p_keywords                   =>     p_keywords
  ,p_travel_percentage          =>     p_travel_percentage
  ,p_min_salary                 =>     p_min_salary
  ,p_max_salary                 =>     p_max_salary
  ,p_salary_currency            =>     p_salary_currency
  ,p_salary_period              =>     p_salary_period
  ,p_professional_area          =>     p_professional_area
  ,p_work_at_home               =>     p_work_at_home
  ,p_min_qual_level             =>     p_min_qual_level
  ,p_max_qual_level             =>     p_max_qual_level
  ,p_description                =>     p_description
  ,p_attribute_category         =>     p_attribute_category
  ,p_attribute1                 =>     p_attribute1
  ,p_attribute2                 =>     p_attribute2
  ,p_attribute3                 =>     p_attribute3
  ,p_attribute4                 =>     p_attribute4
  ,p_attribute5                 =>     p_attribute5
  ,p_attribute6                 =>     p_attribute6
  ,p_attribute7                 =>     p_attribute7
  ,p_attribute8                 =>     p_attribute8
  ,p_attribute9                 =>     p_attribute9
  ,p_attribute10                =>     p_attribute10
  ,p_attribute11                =>     p_attribute11
  ,p_attribute12                =>     p_attribute12
  ,p_attribute13                =>     p_attribute13
  ,p_attribute14                =>     p_attribute14
  ,p_attribute15                =>     p_attribute15
  ,p_attribute16                =>     p_attribute16
  ,p_attribute17                =>     p_attribute17
  ,p_attribute18                =>     p_attribute18
  ,p_attribute19                =>     p_attribute19
  ,p_attribute20                =>     p_attribute20
  ,p_attribute21                =>     p_attribute21
  ,p_attribute22                =>     p_attribute22
  ,p_attribute23                =>     p_attribute23
  ,p_attribute24                =>     p_attribute24
  ,p_attribute25                =>     p_attribute25
  ,p_attribute26                =>     p_attribute26
  ,p_attribute27                =>     p_attribute27
  ,p_attribute28                =>     p_attribute28
  ,p_attribute29                =>     p_attribute29
  ,p_attribute30                =>     p_attribute30
  ,p_isc_information_category   =>     p_isc_information_category
  ,p_isc_information1           =>     p_isc_information1
  ,p_isc_information2           =>     p_isc_information2
  ,p_isc_information3           =>     p_isc_information3
  ,p_isc_information4           =>     p_isc_information4
  ,p_isc_information5           =>     p_isc_information5
  ,p_isc_information6           =>     p_isc_information6
  ,p_isc_information7           =>     p_isc_information7
  ,p_isc_information8           =>     p_isc_information8
  ,p_isc_information9           =>     p_isc_information9
  ,p_isc_information10          =>     p_isc_information10
  ,p_isc_information11          =>     p_isc_information11
  ,p_isc_information12          =>     p_isc_information12
  ,p_isc_information13          =>     p_isc_information13
  ,p_isc_information14          =>     p_isc_information14
  ,p_isc_information15          =>     p_isc_information15
  ,p_isc_information16          =>     p_isc_information16
  ,p_isc_information17          =>     p_isc_information17
  ,p_isc_information18          =>     p_isc_information18
  ,p_isc_information19          =>     p_isc_information19
  ,p_isc_information20          =>     p_isc_information20
  ,p_isc_information21          =>     p_isc_information21
  ,p_isc_information22          =>     p_isc_information22
  ,p_isc_information23          =>     p_isc_information23
  ,p_isc_information24          =>     p_isc_information24
  ,p_isc_information25          =>     p_isc_information25
  ,p_isc_information26          =>     p_isc_information26
  ,p_isc_information27          =>     p_isc_information27
  ,p_isc_information28          =>     p_isc_information28
  ,p_isc_information29          =>     p_isc_information29
  ,p_isc_information30          =>     p_isc_information30
  ,p_object_version_number      =>     l_object_version_number
  );

Line: 1655


        (p_module_name => 'UPDATE_VACANCY_CRITERIA'
        ,p_hook_type   => 'BP'
        );

Line: 1752


  IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_A
  (p_vacancy_id                 =>     p_vacancy_id
  ,p_search_criteria_id         =>     p_search_criteria_id
  ,p_effective_date             =>     l_effective_date
  ,p_location                   =>     p_location
  ,p_contractor                 =>     p_contractor
  ,p_employee                   =>     p_employee
  ,p_employment_category        =>     p_employment_category
  ,p_keywords                   =>     p_keywords
  ,p_travel_percentage          =>     p_travel_percentage
  ,p_min_salary                 =>     p_min_salary
  ,p_max_salary                 =>     p_max_salary
  ,p_salary_currency            =>     p_salary_currency
  ,p_salary_period              =>     p_salary_period
  ,p_professional_area          =>     p_professional_area
  ,p_work_at_home               =>     p_work_at_home
  ,p_min_qual_level             =>     p_min_qual_level
  ,p_max_qual_level             =>     p_max_qual_level
  ,p_description                =>     p_description
  ,p_attribute_category         =>     p_attribute_category
  ,p_attribute1                 =>     p_attribute1
  ,p_attribute2                 =>     p_attribute2
  ,p_attribute3                 =>     p_attribute3
  ,p_attribute4                 =>     p_attribute4
  ,p_attribute5                 =>     p_attribute5
  ,p_attribute6                 =>     p_attribute6
  ,p_attribute7                 =>     p_attribute7
  ,p_attribute8                 =>     p_attribute8
  ,p_attribute9                 =>     p_attribute9
  ,p_attribute10                =>     p_attribute10
  ,p_attribute11                =>     p_attribute11
  ,p_attribute12                =>     p_attribute12
  ,p_attribute13                =>     p_attribute13
  ,p_attribute14                =>     p_attribute14
  ,p_attribute15                =>     p_attribute15
  ,p_attribute16                =>     p_attribute16
  ,p_attribute17                =>     p_attribute17
  ,p_attribute18                =>     p_attribute18
  ,p_attribute19                =>     p_attribute19
  ,p_attribute20                =>     p_attribute20
  ,p_attribute21                =>     p_attribute21
  ,p_attribute22                =>     p_attribute22
  ,p_attribute23                =>     p_attribute23
  ,p_attribute24                =>     p_attribute24
  ,p_attribute25                =>     p_attribute25
  ,p_attribute26                =>     p_attribute26
  ,p_attribute27                =>     p_attribute27
  ,p_attribute28                =>     p_attribute28
  ,p_attribute29                =>     p_attribute29
  ,p_attribute30                =>     p_attribute30
  ,p_isc_information_category   =>     p_isc_information_category
  ,p_isc_information1           =>     p_isc_information1
  ,p_isc_information2           =>     p_isc_information2
  ,p_isc_information3           =>     p_isc_information3
  ,p_isc_information4           =>     p_isc_information4
  ,p_isc_information5           =>     p_isc_information5
  ,p_isc_information6           =>     p_isc_information6
  ,p_isc_information7           =>     p_isc_information7
  ,p_isc_information8           =>     p_isc_information8
  ,p_isc_information9           =>     p_isc_information9
  ,p_isc_information10          =>     p_isc_information10
  ,p_isc_information11          =>     p_isc_information11
  ,p_isc_information12          =>     p_isc_information12
  ,p_isc_information13          =>     p_isc_information13
  ,p_isc_information14          =>     p_isc_information14
  ,p_isc_information15          =>     p_isc_information15
  ,p_isc_information16          =>     p_isc_information16
  ,p_isc_information17          =>     p_isc_information17
  ,p_isc_information18          =>     p_isc_information18
  ,p_isc_information19          =>     p_isc_information19
  ,p_isc_information20          =>     p_isc_information20
  ,p_isc_information21          =>     p_isc_information21
  ,p_isc_information22          =>     p_isc_information22
  ,p_isc_information23          =>     p_isc_information23
  ,p_isc_information24          =>     p_isc_information24
  ,p_isc_information25          =>     p_isc_information25
  ,p_isc_information26          =>     p_isc_information26
  ,p_isc_information27          =>     p_isc_information27
  ,p_isc_information28          =>     p_isc_information28
  ,p_isc_information29          =>     p_isc_information29
  ,p_isc_information30          =>     p_isc_information30
  ,p_object_version_number      =>     l_object_version_number
  );

Line: 1838


        (p_module_name => 'UPDATE_VACANCY_CRITERIA'
        ,p_hook_type   => 'AP'
        );

Line: 1860


    rollback to UPDATE_VACANCY_CRITERIA;

Line: 1875


    rollback to UPDATE_VACANCY_CRITERIA;

Line: 1882


end UPDATE_VACANCY_CRITERIA;

Line: 1888


procedure DELETE_VACANCY_CRITERIA
  (p_validate                      in     boolean  default false
  ,p_search_criteria_id            in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                 varchar2(72) := g_package||'DELETE_VACANCY_CRITERIA';

Line: 1904


  savepoint DELETE_VACANCY_CRITERIA;

Line: 1911


 IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_B
  (p_search_criteria_id         =>     p_search_criteria_id
  ,p_object_version_number      =>     p_object_version_number
  );

Line: 1918


        (p_module_name => 'DELETE_VACANCY_CRITERIA'
        ,p_hook_type   => 'BP'
        );

Line: 1935


  IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_A
  (p_search_criteria_id         =>     p_search_criteria_id
  ,p_object_version_number      =>     p_object_version_number
  );

Line: 1942


        (p_module_name => 'DELETE_VACANCY_CRITERIA'
        ,p_hook_type   => 'AP'
        );

Line: 1963


    rollback to DELETE_VACANCY_CRITERIA;

Line: 1974


    rollback to DELETE_VACANCY_CRITERIA;

Line: 1977


end DELETE_VACANCY_CRITERIA;

Line: 2438


procedure UPDATE_WORK_CHOICES
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_search_criteria_id            in     number
  ,p_location                      in     varchar2 default hr_api.g_varchar2
  ,p_distance_to_location          in     varchar2 default hr_api.g_varchar2
  ,p_geocode_location              in     varchar2 default hr_api.g_varchar2
  ,p_geocode_country               in     varchar2 default hr_api.g_varchar2
  ,p_derived_location              in     varchar2 default hr_api.g_varchar2
  ,p_location_id                   in     number   default hr_api.g_number
  ,p_longitude                     in     number   default hr_api.g_number
  ,p_latitude                      in     number   default hr_api.g_number
  ,p_employee                      in     varchar2 default hr_api.g_varchar2
  ,p_contractor                    in     varchar2 default hr_api.g_varchar2
  ,p_employment_category           in     varchar2 default hr_api.g_varchar2
  ,p_keywords                      in     varchar2 default hr_api.g_varchar2
  ,p_travel_percentage             in     number   default hr_api.g_number
  ,p_min_salary                    in     number   default hr_api.g_number
  ,p_salary_currency               in     varchar2 default hr_api.g_varchar2
  ,p_salary_period                 in     varchar2 default hr_api.g_varchar2
  ,p_match_competence              in     varchar2 default hr_api.g_varchar2
  ,p_match_qualification           in     varchar2 default hr_api.g_varchar2
  ,p_work_at_home                  in     varchar2 default hr_api.g_varchar2
  ,p_job_title                     in     varchar2 default hr_api.g_varchar2
  ,p_department                    in     varchar2 default hr_api.g_varchar2
  ,p_professional_area             in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ,p_isc_information_category      in     varchar2 default hr_api.g_varchar2
  ,p_isc_information1              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information2              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information3              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information4              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information5              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information6              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information7              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information8              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information9              in     varchar2 default hr_api.g_varchar2
  ,p_isc_information10             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information11             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information12             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information13             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information14             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information15             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information16             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information17             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information18             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information19             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information20             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information21             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information22             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information23             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information24             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information25             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information26             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information27             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information28             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information29             in     varchar2 default hr_api.g_varchar2
  ,p_isc_information30             in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                 varchar2(72) := g_package||'UPDATE_WORK_CHOICES';

Line: 2543


  savepoint UPDATE_WORK_CHOICES;

Line: 2552


  IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_B
  (p_effective_date             =>     l_effective_date
  ,p_search_criteria_id         =>     p_search_criteria_id
  ,p_location                   =>     p_location
  ,p_distance_to_location       =>     p_distance_to_location
  ,p_geocode_location           =>     p_geocode_location
  ,p_geocode_country            =>     p_geocode_country
  ,p_derived_location           =>     p_derived_location
  ,p_location_id                =>     p_location_id
  ,p_longitude                  =>     p_longitude
  ,p_latitude                   =>     p_latitude
  ,p_contractor                 =>     p_contractor
  ,p_employee                   =>     p_employee
  ,p_employment_category        =>     p_employment_category
  ,p_keywords                   =>     p_keywords
  ,p_travel_percentage          =>     p_travel_percentage
  ,p_min_salary                 =>     p_min_salary
  ,p_salary_currency            =>     p_salary_currency
  ,p_salary_period              =>     p_salary_period
  ,p_match_competence           =>     p_match_competence
  ,p_match_qualification        =>     p_match_qualification
  ,p_work_at_home               =>     p_work_at_home
  ,p_job_title                  =>     p_job_title
  ,p_department                 =>     p_department
  ,p_professional_area          =>     p_professional_area
  ,p_description                =>     p_description
  ,p_attribute_category         =>     p_attribute_category
  ,p_attribute1                 =>     p_attribute1
  ,p_attribute2                 =>     p_attribute2
  ,p_attribute3                 =>     p_attribute3
  ,p_attribute4                 =>     p_attribute4
  ,p_attribute5                 =>     p_attribute5
  ,p_attribute6                 =>     p_attribute6
  ,p_attribute7                 =>     p_attribute7
  ,p_attribute8                 =>     p_attribute8
  ,p_attribute9                 =>     p_attribute9
  ,p_attribute10                =>     p_attribute10
  ,p_attribute11                =>     p_attribute11
  ,p_attribute12                =>     p_attribute12
  ,p_attribute13                =>     p_attribute13
  ,p_attribute14                =>     p_attribute14
  ,p_attribute15                =>     p_attribute15
  ,p_attribute16                =>     p_attribute16
  ,p_attribute17                =>     p_attribute17
  ,p_attribute18                =>     p_attribute18
  ,p_attribute19                =>     p_attribute19
  ,p_attribute20                =>     p_attribute20
  ,p_attribute21                =>     p_attribute21
  ,p_attribute22                =>     p_attribute22
  ,p_attribute23                =>     p_attribute23
  ,p_attribute24                =>     p_attribute24
  ,p_attribute25                =>     p_attribute25
  ,p_attribute26                =>     p_attribute26
  ,p_attribute27                =>     p_attribute27
  ,p_attribute28                =>     p_attribute28
  ,p_attribute29                =>     p_attribute29
  ,p_attribute30                =>     p_attribute30
  ,p_isc_information_category   =>     p_isc_information_category
  ,p_isc_information1           =>     p_isc_information1
  ,p_isc_information2           =>     p_isc_information2
  ,p_isc_information3           =>     p_isc_information3
  ,p_isc_information4           =>     p_isc_information4
  ,p_isc_information5           =>     p_isc_information5
  ,p_isc_information6           =>     p_isc_information6
  ,p_isc_information7           =>     p_isc_information7
  ,p_isc_information8           =>     p_isc_information8
  ,p_isc_information9           =>     p_isc_information9
  ,p_isc_information10          =>     p_isc_information10
  ,p_isc_information11          =>     p_isc_information11
  ,p_isc_information12          =>     p_isc_information12
  ,p_isc_information13          =>     p_isc_information13
  ,p_isc_information14          =>     p_isc_information14
  ,p_isc_information15          =>     p_isc_information15
  ,p_isc_information16          =>     p_isc_information16
  ,p_isc_information17          =>     p_isc_information17
  ,p_isc_information18          =>     p_isc_information18
  ,p_isc_information19          =>     p_isc_information19
  ,p_isc_information20          =>     p_isc_information20
  ,p_isc_information21          =>     p_isc_information21
  ,p_isc_information22          =>     p_isc_information22
  ,p_isc_information23          =>     p_isc_information23
  ,p_isc_information24          =>     p_isc_information24
  ,p_isc_information25          =>     p_isc_information25
  ,p_isc_information26          =>     p_isc_information26
  ,p_isc_information27          =>     p_isc_information27
  ,p_isc_information28          =>     p_isc_information28
  ,p_isc_information29          =>     p_isc_information29
  ,p_isc_information30          =>     p_isc_information30
  ,p_object_version_number      =>     l_object_version_number
  );

Line: 2645


        (p_module_name => 'UPDATE_WORK_CHOICES'
        ,p_hook_type   => 'BP'
        );

Line: 2749


  IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_A
  (p_effective_date                =>     l_effective_date
  ,p_search_criteria_id            =>     p_search_criteria_id
  ,p_location                      =>     p_location
  ,p_distance_to_location          =>     p_distance_to_location
  ,p_geocode_location              =>     p_geocode_location
  ,p_geocode_country               =>     p_geocode_country
  ,p_derived_location              =>     p_derived_location
  ,p_location_id                   =>     p_location_id
  ,p_longitude                     =>     p_longitude
  ,p_latitude                      =>     p_latitude
  ,p_contractor                    =>     p_contractor
  ,p_employee                      =>     p_employee
  ,p_employment_category           =>     p_employment_category
  ,p_keywords                      =>     p_keywords
  ,p_travel_percentage             =>     p_travel_percentage
  ,p_min_salary                    =>     p_min_salary
  ,p_salary_currency               =>     p_salary_currency
  ,p_salary_period                 =>     p_salary_period
  ,p_match_competence              =>     p_match_competence
  ,p_match_qualification           =>     p_match_qualification
  ,p_work_at_home                  =>     p_work_at_home
  ,p_job_title                     =>     p_job_title
  ,p_department                    =>     p_department
  ,p_professional_area             =>     p_professional_area
  ,p_description                   =>     p_description
  ,p_attribute_category            =>     p_attribute_category
  ,p_attribute1                    =>     p_attribute1
  ,p_attribute2                    =>     p_attribute2
  ,p_attribute3                    =>     p_attribute3
  ,p_attribute4                    =>     p_attribute4
  ,p_attribute5                    =>     p_attribute5
  ,p_attribute6                    =>     p_attribute6
  ,p_attribute7                    =>     p_attribute7
  ,p_attribute8                    =>     p_attribute8
  ,p_attribute9                    =>     p_attribute9
  ,p_attribute10                   =>     p_attribute10
  ,p_attribute11                   =>     p_attribute11
  ,p_attribute12                   =>     p_attribute12
  ,p_attribute13                   =>     p_attribute13
  ,p_attribute14                   =>     p_attribute14
  ,p_attribute15                   =>     p_attribute15
  ,p_attribute16                   =>     p_attribute16
  ,p_attribute17                   =>     p_attribute17
  ,p_attribute18                   =>     p_attribute18
  ,p_attribute19                   =>     p_attribute19
  ,p_attribute20                   =>     p_attribute20
  ,p_attribute21                   =>     p_attribute21
  ,p_attribute22                   =>     p_attribute22
  ,p_attribute23                   =>     p_attribute23
  ,p_attribute24                   =>     p_attribute24
  ,p_attribute25                   =>     p_attribute25
  ,p_attribute26                   =>     p_attribute26
  ,p_attribute27                   =>     p_attribute27
  ,p_attribute28                   =>     p_attribute28
  ,p_attribute29                   =>     p_attribute29
  ,p_attribute30                   =>     p_attribute30
  ,p_isc_information_category      =>     p_isc_information_category
  ,p_isc_information1              =>     p_isc_information1
  ,p_isc_information2              =>     p_isc_information2
  ,p_isc_information3              =>     p_isc_information3
  ,p_isc_information4              =>     p_isc_information4
  ,p_isc_information5              =>     p_isc_information5
  ,p_isc_information6              =>     p_isc_information6
  ,p_isc_information7              =>     p_isc_information7
  ,p_isc_information8              =>     p_isc_information8
  ,p_isc_information9              =>     p_isc_information9
  ,p_isc_information10             =>     p_isc_information10
  ,p_isc_information11             =>     p_isc_information11
  ,p_isc_information12             =>     p_isc_information12
  ,p_isc_information13             =>     p_isc_information13
  ,p_isc_information14             =>     p_isc_information14
  ,p_isc_information15             =>     p_isc_information15
  ,p_isc_information16             =>     p_isc_information16
  ,p_isc_information17             =>     p_isc_information17
  ,p_isc_information18             =>     p_isc_information18
  ,p_isc_information19             =>     p_isc_information19
  ,p_isc_information20             =>     p_isc_information20
  ,p_isc_information21             =>     p_isc_information21
  ,p_isc_information22             =>     p_isc_information22
  ,p_isc_information23             =>     p_isc_information23
  ,p_isc_information24             =>     p_isc_information24
  ,p_isc_information25             =>     p_isc_information25
  ,p_isc_information26             =>     p_isc_information26
  ,p_isc_information27             =>     p_isc_information27
  ,p_isc_information28             =>     p_isc_information28
  ,p_isc_information29             =>     p_isc_information29
  ,p_isc_information30             =>     p_isc_information30
  ,p_object_version_number         =>     l_object_version_number
  );

Line: 2842


        (p_module_name => 'UPDATE_WORK_CHOICES'
        ,p_hook_type   => 'AP'
        );

Line: 2864


    rollback to UPDATE_WORK_CHOICES;

Line: 2879


    rollback to UPDATE_WORK_CHOICES;

Line: 2886


end UPDATE_WORK_CHOICES;

Line: 2892


procedure DELETE_WORK_CHOICES
  (p_validate                      in     boolean  default false
  ,p_search_criteria_id            in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                 varchar2(72) := g_package||'DELETE_WORK_CHOICES';

Line: 2908


  savepoint DELETE_WORK_CHOICES;

Line: 2915


  IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_B
  (p_search_criteria_id         =>     p_search_criteria_id
  ,p_object_version_number      =>     p_object_version_number
  );

Line: 2922


        (p_module_name => 'DELETE_WORK_CHOICES'
        ,p_hook_type   => 'BP'
        );

Line: 2939


  IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_A
  (p_search_criteria_id         =>     p_search_criteria_id
  ,p_object_version_number      =>     p_object_version_number
  );

Line: 2946


        (p_module_name => 'DELETE_WORK_CHOICES'
        ,p_hook_type   => 'AP'
        );

Line: 2967


    rollback to DELETE_WORK_CHOICES;

Line: 2978


    rollback to DELETE_WORK_CHOICES;

Line: 2981


end DELETE_WORK_CHOICES;