APPS.IRC_REFERRAL_INFO_SWI SQL Statements

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

Line: 70

  is SELECT PARTY_ID FROM PER_ALL_PEOPLE_F
  WHERE PERSON_ID=p_object_id;

Line: 219

PROCEDURE update_referral_info
  (p_validate                       in       number   default hr_api.g_false_num
  ,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
  ,p_return_status                  out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 272

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

Line: 278

  savepoint update_referral_info_swi;

Line: 299

  irc_referral_info_api.update_referral_info
    (p_validate                  => l_validate
    ,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
    ,p_start_date                => p_start_date
    ,p_end_date                  => p_end_date
    );

Line: 365

    rollback to update_referral_info_swi;

Line: 382

    rollback to update_referral_info_swi;

Line: 395

end update_referral_info;