8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_pending_data >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_pending_data
12: (p_validate in number default hr_api.g_false_num
13: ,p_email_address in varchar2
14: ,p_last_name in varchar2
15: ,p_vacancy_id in number default null
16: ,p_first_name in varchar2 default null
90: --
91: -- Convert constant values to their corresponding boolean value
92: --
93: l_validate :=
94: hr_api.constant_to_boolean
95: (p_constant_value => p_validate);
96: --
97: -- Register Surrogate ID or user key values
98: --
210: -- ----------------------------------------------------------------------------
211: -- |--------------------------< update_pending_data >-------------------------|
212: -- ----------------------------------------------------------------------------
213: PROCEDURE update_pending_data
214: (p_validate in number default hr_api.g_false_num
215: ,p_pending_data_id in number
216: ,p_email_address in varchar2 default hr_api.g_varchar2
217: ,p_last_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
212: -- ----------------------------------------------------------------------------
213: PROCEDURE update_pending_data
214: (p_validate in number default hr_api.g_false_num
215: ,p_pending_data_id in number
216: ,p_email_address in varchar2 default hr_api.g_varchar2
217: ,p_last_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
213: PROCEDURE update_pending_data
214: (p_validate in number default hr_api.g_false_num
215: ,p_pending_data_id in number
216: ,p_email_address in varchar2 default hr_api.g_varchar2
217: ,p_last_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
214: (p_validate in number default hr_api.g_false_num
215: ,p_pending_data_id in number
216: ,p_email_address in varchar2 default hr_api.g_varchar2
217: ,p_last_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
215: ,p_pending_data_id in number
216: ,p_email_address in varchar2 default hr_api.g_varchar2
217: ,p_last_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
216: ,p_email_address in varchar2 default hr_api.g_varchar2
217: ,p_last_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
217: ,p_last_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
218: ,p_vacancy_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
219: ,p_first_name in varchar2 default hr_api.g_varchar2
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
220: ,p_user_password in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
221: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
222: ,p_resume_description in varchar2 default hr_api.g_varchar2
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
224: ,p_source_type in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
225: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
226: ,p_posting_content_id in number default hr_api.g_number
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
227: ,p_person_id in number default hr_api.g_number
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
228: ,p_processed in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
229: ,p_sex in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
230: ,p_date_of_birth in date default hr_api.g_date
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
231: ,p_per_information_category in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
232: ,p_per_information1 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
233: ,p_per_information2 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
234: ,p_per_information3 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
235: ,p_per_information4 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
236: ,p_per_information5 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
237: ,p_per_information6 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
238: ,p_per_information7 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
239: ,p_per_information8 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
240: ,p_per_information9 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
241: ,p_per_information10 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
242: ,p_per_information11 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
243: ,p_per_information12 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
244: ,p_per_information13 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
245: ,p_per_information14 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
246: ,p_per_information15 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
247: ,p_per_information16 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
248: ,p_per_information17 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
249: ,p_per_information18 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
250: ,p_per_information19 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
251: ,p_per_information20 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
252: ,p_per_information21 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
253: ,p_per_information22 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
254: ,p_per_information23 in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
255: ,p_per_information24 in varchar2 default hr_api.g_varchar2
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
256: ,p_per_information25 in varchar2 default hr_api.g_varchar2
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
264: ,p_last_update_date in date default hr_api.g_date
257: ,p_per_information26 in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
264: ,p_last_update_date in date default hr_api.g_date
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
258: ,p_per_information27 in varchar2 default hr_api.g_varchar2
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
264: ,p_last_update_date in date default hr_api.g_date
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
266: ,p_user_guid in raw default null
259: ,p_per_information28 in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
264: ,p_last_update_date in date default hr_api.g_date
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
266: ,p_user_guid in raw default null
267: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
260: ,p_per_information29 in varchar2 default hr_api.g_varchar2
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
264: ,p_last_update_date in date default hr_api.g_date
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
266: ,p_user_guid in raw default null
267: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
268: ,p_visitor_resp_appl_id in number default hr_api.g_number
261: ,p_per_information30 in varchar2 default hr_api.g_varchar2
262: ,p_error_message in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
264: ,p_last_update_date in date default hr_api.g_date
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
266: ,p_user_guid in raw default null
267: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
268: ,p_visitor_resp_appl_id in number default hr_api.g_number
269: ,p_security_group_key in varchar2 default hr_api.g_varchar2
263: ,p_creation_date in date default hr_api.g_date
264: ,p_last_update_date in date default hr_api.g_date
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
266: ,p_user_guid in raw default null
267: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
268: ,p_visitor_resp_appl_id in number default hr_api.g_number
269: ,p_security_group_key in varchar2 default hr_api.g_varchar2
270: ,p_return_status out nocopy varchar2
271: ) is
264: ,p_last_update_date in date default hr_api.g_date
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
266: ,p_user_guid in raw default null
267: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
268: ,p_visitor_resp_appl_id in number default hr_api.g_number
269: ,p_security_group_key in varchar2 default hr_api.g_varchar2
270: ,p_return_status out nocopy varchar2
271: ) is
272: --
265: ,p_allow_access in varchar2 default hr_api.g_varchar2
266: ,p_user_guid in raw default null
267: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
268: ,p_visitor_resp_appl_id in number default hr_api.g_number
269: ,p_security_group_key in varchar2 default hr_api.g_varchar2
270: ,p_return_status out nocopy varchar2
271: ) is
272: --
273: -- Variables for API Boolean parameters
290: --
291: -- Convert constant values to their corresponding boolean value
292: --
293: l_validate :=
294: hr_api.constant_to_boolean
295: (p_constant_value => p_validate);
296: --
297: -- Call API
298: --
404: -- ----------------------------------------------------------------------------
405: -- |--------------------------< delete_pending_data >-------------------------|
406: -- ----------------------------------------------------------------------------
407: PROCEDURE delete_pending_data
408: (p_validate in number default hr_api.g_false_num
409: ,p_pending_data_id in number
410: ,p_return_status out nocopy varchar2
411: ) is
412: --
430: --
431: -- Convert constant values to their corresponding boolean value
432: --
433: l_validate :=
434: hr_api.constant_to_boolean
435: (p_constant_value => p_validate);
436: --
437: -- Call API
438: --