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_PENDING_DATA_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 94: hr_api.constant_to_boolean

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: --

Line 214: (p_validate in number default hr_api.g_false_num

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

Line 216: ,p_email_address in varchar2 default hr_api.g_varchar2

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

Line 217: ,p_last_name 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

Line 218: ,p_vacancy_id in number default hr_api.g_number

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

Line 219: ,p_first_name 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

Line 220: ,p_user_password 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

Line 221: ,p_resume_file_name 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

Line 222: ,p_resume_description 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

Line 223: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2

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

Line 224: ,p_source_type 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
228: ,p_processed in varchar2 default hr_api.g_varchar2

Line 225: ,p_job_post_source_name 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

Line 226: ,p_posting_content_id in number default hr_api.g_number

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

Line 227: ,p_person_id in number default hr_api.g_number

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

Line 228: ,p_processed 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

Line 229: ,p_sex 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

Line 230: ,p_date_of_birth in date default hr_api.g_date

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

Line 231: ,p_per_information_category 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

Line 232: ,p_per_information1 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

Line 233: ,p_per_information2 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

Line 234: ,p_per_information3 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

Line 235: ,p_per_information4 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

Line 236: ,p_per_information5 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

Line 237: ,p_per_information6 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

Line 238: ,p_per_information7 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

Line 239: ,p_per_information8 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

Line 240: ,p_per_information9 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

Line 241: ,p_per_information10 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

Line 242: ,p_per_information11 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

Line 243: ,p_per_information12 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

Line 244: ,p_per_information13 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

Line 245: ,p_per_information14 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

Line 246: ,p_per_information15 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

Line 247: ,p_per_information16 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

Line 248: ,p_per_information17 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

Line 249: ,p_per_information18 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

Line 250: ,p_per_information19 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

Line 251: ,p_per_information20 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

Line 252: ,p_per_information21 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

Line 253: ,p_per_information22 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

Line 254: ,p_per_information23 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

Line 255: ,p_per_information24 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

Line 256: ,p_per_information25 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

Line 257: ,p_per_information26 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

Line 258: ,p_per_information27 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

Line 259: ,p_per_information28 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

Line 260: ,p_per_information29 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
264: ,p_last_update_date in date default hr_api.g_date

Line 261: ,p_per_information30 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
265: ,p_allow_access in varchar2 default hr_api.g_varchar2

Line 262: ,p_error_message 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

Line 263: ,p_creation_date in date default hr_api.g_date

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

Line 264: ,p_last_update_date in date default hr_api.g_date

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

Line 265: ,p_allow_access 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
269: ,p_security_group_key in varchar2 default hr_api.g_varchar2

Line 267: ,p_visitor_resp_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

Line 268: ,p_visitor_resp_appl_id in number default hr_api.g_number

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: --

Line 269: ,p_security_group_key in varchar2 default hr_api.g_varchar2

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

Line 294: hr_api.constant_to_boolean

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: --

Line 408: (p_validate in number default hr_api.g_false_num

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: --

Line 434: hr_api.constant_to_boolean

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: --