DBA Data[Home] [Help]

APPS.IRC_REFERRAL_INFO_API SQL Statements

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

Line: 289

procedure update_referral_info
  (p_validate                       in       boolean  default false
  ,p_referral_info_id               in       number
  ,p_source_type            		in 		 varchar2 default hr_api.g_varchar2
  ,p_source_name            		in 		 varchar2 default hr_api.g_varchar2
  ,p_source_criteria1               in 	     varchar2 default hr_api.g_varchar2
  ,p_source_value1            	    in 		 varchar2 default hr_api.g_varchar2
  ,p_source_criteria2               in 		 varchar2 default hr_api.g_varchar2
  ,p_source_value2            	    in 		 varchar2 default hr_api.g_varchar2
  ,p_source_criteria3               in 		 varchar2 default hr_api.g_varchar2
  ,p_source_value3                  in 		 varchar2 default hr_api.g_varchar2
  ,p_source_criteria4               in 		 varchar2 default hr_api.g_varchar2
  ,p_source_value4                  in 		 varchar2 default hr_api.g_varchar2
  ,p_source_criteria5               in 		 varchar2 default hr_api.g_varchar2
  ,p_source_value5                  in 		 varchar2 default hr_api.g_varchar2
  ,p_source_person_id               in 		 number   default hr_api.g_number
  ,p_candidate_comment              in 		 varchar2 default hr_api.g_varchar2
  ,p_employee_comment               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute_category         in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute1                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute2                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute3                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute4                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute5                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute6                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute7                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute8                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute9                 in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_attribute10                in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information_category       in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information1               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information2               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information3               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information4               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information5               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information6               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information7               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information8               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information9               in 		 varchar2 default hr_api.g_varchar2
  ,p_irf_information10              in 		 varchar2 default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy   number
  ,p_start_date                     out nocopy   date
  ,p_end_date                       out nocopy   date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number    number;
Line: 340

  l_proc                     varchar2(72) := g_package||'update_referral_info';
Line: 346

  savepoint update_referral_info;
Line: 351

    irc_referral_info_bk2.update_referral_info_b
                 (p_referral_info_id            =>      p_referral_info_id
                 ,p_source_type					=>		p_source_type
                 ,p_source_name					=>		p_source_name
                 ,p_source_criteria1			=>		p_source_criteria1
                 ,p_source_value1				=>		p_source_value1
                 ,p_source_criteria2			=>		p_source_criteria2
                 ,p_source_value2				=>		p_source_value2
                 ,p_source_criteria3			=>		p_source_criteria3
                 ,p_source_value3				=>		p_source_value3
                 ,p_source_criteria4			=>		p_source_criteria4
                 ,p_source_value4				=>		p_source_value4
                 ,p_source_criteria5			=>		p_source_criteria5
                 ,p_source_value5				=>		p_source_value5
                 ,p_source_person_id			=>		p_source_person_id
                 ,p_candidate_comment			=>		p_candidate_comment
                 ,p_employee_comment			=>		p_employee_comment
                 ,p_irf_attribute_category		=>		p_irf_attribute_category
                 ,p_irf_attribute1				=>		p_irf_attribute1
                 ,p_irf_attribute2				=>		p_irf_attribute2
                 ,p_irf_attribute3				=>		p_irf_attribute3
                 ,p_irf_attribute4				=>		p_irf_attribute4
                 ,p_irf_attribute5				=>		p_irf_attribute5
                 ,p_irf_attribute6				=>		p_irf_attribute6
                 ,p_irf_attribute7				=>		p_irf_attribute7
                 ,p_irf_attribute8				=>		p_irf_attribute8
                 ,p_irf_attribute9				=>		p_irf_attribute9
                 ,p_irf_attribute10				=>		p_irf_attribute10
                 ,p_irf_information_category	=>		p_irf_information_category
                 ,p_irf_information1			=>		p_irf_information1
                 ,p_irf_information2			=>		p_irf_information2
                 ,p_irf_information3			=>		p_irf_information3
                 ,p_irf_information4			=>		p_irf_information4
                 ,p_irf_information5			=>		p_irf_information5
                 ,p_irf_information6			=>		p_irf_information6
                 ,p_irf_information7			=>		p_irf_information7
                 ,p_irf_information8			=>		p_irf_information8
                 ,p_irf_information9			=>		p_irf_information9
                 ,p_irf_information10			=>		p_irf_information10
                 ,p_object_version_number       =>      p_object_version_number
                 );
Line: 395

        (p_module_name => 'update_referral_info'
        ,p_hook_type   => 'BP'
        );
Line: 411

                 ,p_datetrack_mode              =>     'UPDATE'
                 ,p_referral_info_id            =>      p_referral_info_id
                 ,p_object_version_number       =>      l_object_version_number
                 ,p_source_type					=>		p_source_type
                 ,p_source_name					=>		p_source_name
                 ,p_source_criteria1			=>		p_source_criteria1
                 ,p_source_value1				=>		p_source_value1
                 ,p_source_criteria2			=>		p_source_criteria2
                 ,p_source_value2				=>		p_source_value2
                 ,p_source_criteria3			=>		p_source_criteria3
                 ,p_source_value3				=>		p_source_value3
                 ,p_source_criteria4			=>		p_source_criteria4
                 ,p_source_value4				=>		p_source_value4
                 ,p_source_criteria5			=>		p_source_criteria5
                 ,p_source_value5				=>		p_source_value5
                 ,p_source_person_id			=>		p_source_person_id
                 ,p_candidate_comment			=>		p_candidate_comment
                 ,p_employee_comment			=>		p_employee_comment
                 ,p_irf_attribute_category		=>		p_irf_attribute_category
                 ,p_irf_attribute1				=>		p_irf_attribute1
                 ,p_irf_attribute2				=>		p_irf_attribute2
                 ,p_irf_attribute3				=>		p_irf_attribute3
                 ,p_irf_attribute4				=>		p_irf_attribute4
                 ,p_irf_attribute5				=>		p_irf_attribute5
                 ,p_irf_attribute6				=>		p_irf_attribute6
                 ,p_irf_attribute7				=>		p_irf_attribute7
                 ,p_irf_attribute8				=>		p_irf_attribute8
                 ,p_irf_attribute9				=>		p_irf_attribute9
                 ,p_irf_attribute10				=>		p_irf_attribute10
                 ,p_irf_information_category	=>		p_irf_information_category
                 ,p_irf_information1			=>		p_irf_information1
                 ,p_irf_information2			=>		p_irf_information2
                 ,p_irf_information3			=>		p_irf_information3
                 ,p_irf_information4			=>		p_irf_information4
                 ,p_irf_information5			=>		p_irf_information5
                 ,p_irf_information6			=>		p_irf_information6
                 ,p_irf_information7			=>		p_irf_information7
                 ,p_irf_information8			=>		p_irf_information8
                 ,p_irf_information9			=>		p_irf_information9
                 ,p_irf_information10			=>		p_irf_information10
                 ,p_start_date                  =>      l_start_date
                 ,p_end_date                    =>      l_end_date
                 );
Line: 458

    irc_referral_info_bk2.update_referral_info_a
                 (p_referral_info_id            =>      p_referral_info_id
                 ,p_source_type					=>		p_source_type
                 ,p_source_name					=>		p_source_name
                 ,p_source_criteria1			=>		p_source_criteria1
                 ,p_source_value1				=>		p_source_value1
                 ,p_source_criteria2			=>		p_source_criteria2
                 ,p_source_value2				=>		p_source_value2
                 ,p_source_criteria3			=>		p_source_criteria3
                 ,p_source_value3				=>		p_source_value3
                 ,p_source_criteria4			=>		p_source_criteria4
                 ,p_source_value4				=>		p_source_value4
                 ,p_source_criteria5			=>		p_source_criteria5
                 ,p_source_value5				=>		p_source_value5
                 ,p_source_person_id			=>		p_source_person_id
                 ,p_candidate_comment			=>		p_candidate_comment
                 ,p_employee_comment			=>		p_employee_comment
                 ,p_irf_attribute_category		=>		p_irf_attribute_category
                 ,p_irf_attribute1				=>		p_irf_attribute1
                 ,p_irf_attribute2				=>		p_irf_attribute2
                 ,p_irf_attribute3				=>		p_irf_attribute3
                 ,p_irf_attribute4				=>		p_irf_attribute4
                 ,p_irf_attribute5				=>		p_irf_attribute5
                 ,p_irf_attribute6				=>		p_irf_attribute6
                 ,p_irf_attribute7				=>		p_irf_attribute7
                 ,p_irf_attribute8				=>		p_irf_attribute8
                 ,p_irf_attribute9				=>		p_irf_attribute9
                 ,p_irf_attribute10				=>		p_irf_attribute10
                 ,p_irf_information_category	=>		p_irf_information_category
                 ,p_irf_information1			=>		p_irf_information1
                 ,p_irf_information2			=>		p_irf_information2
                 ,p_irf_information3			=>		p_irf_information3
                 ,p_irf_information4			=>		p_irf_information4
                 ,p_irf_information5			=>		p_irf_information5
                 ,p_irf_information6			=>		p_irf_information6
                 ,p_irf_information7			=>		p_irf_information7
                 ,p_irf_information8			=>		p_irf_information8
                 ,p_irf_information9			=>		p_irf_information9
                 ,p_irf_information10			=>		p_irf_information10
                 ,p_object_version_number       =>      p_object_version_number
                 );
Line: 502

        (p_module_name => 'update_referral_info'
        ,p_hook_type   => 'AP'
        );
Line: 526

    rollback to update_referral_info;
Line: 539

    rollback to update_referral_info;
Line: 548

end update_referral_info;