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

Line 163: when hr_api.cannot_find_prog_unit then

159: ,p_visitor_resp_appl_id => p_visitor_resp_appl_id
160: ,p_security_group_key => p_security_group_key
161: );
162: exception
163: when hr_api.cannot_find_prog_unit then
164: hr_api.cannot_find_prog_unit_error
165: (p_module_name => 'CREATE_PENDING_DATA'
166: ,p_hook_type => 'BP'
167: );

Line 164: hr_api.cannot_find_prog_unit_error

160: ,p_security_group_key => p_security_group_key
161: );
162: exception
163: when hr_api.cannot_find_prog_unit then
164: hr_api.cannot_find_prog_unit_error
165: (p_module_name => 'CREATE_PENDING_DATA'
166: ,p_hook_type => 'BP'
167: );
168: end;

Line 315: when hr_api.cannot_find_prog_unit then

311: ,p_visitor_resp_appl_id => p_visitor_resp_appl_id
312: ,p_security_group_key => p_security_group_key
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'CREATE_PENDING_DATA'
318: ,p_hook_type => 'AP'
319: );

Line 316: hr_api.cannot_find_prog_unit_error

312: ,p_security_group_key => p_security_group_key
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'CREATE_PENDING_DATA'
318: ,p_hook_type => 'AP'
319: );
320: end;

Line 326: raise hr_api.validate_enabled;

322: --
323: -- When in validation only mode raise the Validate_Enabled exception
324: --
325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;
328: --
329: -- Set all OUT parameters with out values
330: --

Line 335: when hr_api.validate_enabled then

331: p_pending_data_id := l_pending_data_id;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 70);
334: exception
335: when hr_api.validate_enabled then
336: --
337: -- As the Validate_Enabled exception has been raised
338: -- we must rollback to the savepoint
339: --

Line 369: ,p_email_address in varchar2 default hr_api.g_varchar2

365: --
366: procedure UPDATE_PENDING_DATA
367: (p_validate in boolean default false
368: ,p_pending_data_id in number
369: ,p_email_address in varchar2 default hr_api.g_varchar2
370: ,p_last_name in varchar2 default hr_api.g_varchar2
371: ,p_vacancy_id in number default hr_api.g_number
372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2

Line 370: ,p_last_name in varchar2 default hr_api.g_varchar2

366: procedure UPDATE_PENDING_DATA
367: (p_validate in boolean default false
368: ,p_pending_data_id in number
369: ,p_email_address in varchar2 default hr_api.g_varchar2
370: ,p_last_name in varchar2 default hr_api.g_varchar2
371: ,p_vacancy_id in number default hr_api.g_number
372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2

Line 371: ,p_vacancy_id in number default hr_api.g_number

367: (p_validate in boolean default false
368: ,p_pending_data_id in number
369: ,p_email_address in varchar2 default hr_api.g_varchar2
370: ,p_last_name in varchar2 default hr_api.g_varchar2
371: ,p_vacancy_id in number default hr_api.g_number
372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2

Line 372: ,p_first_name in varchar2 default hr_api.g_varchar2

368: ,p_pending_data_id in number
369: ,p_email_address in varchar2 default hr_api.g_varchar2
370: ,p_last_name in varchar2 default hr_api.g_varchar2
371: ,p_vacancy_id in number default hr_api.g_number
372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2

Line 373: ,p_user_password in varchar2 default hr_api.g_varchar2

369: ,p_email_address in varchar2 default hr_api.g_varchar2
370: ,p_last_name in varchar2 default hr_api.g_varchar2
371: ,p_vacancy_id in number default hr_api.g_number
372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2

Line 374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2

370: ,p_last_name in varchar2 default hr_api.g_varchar2
371: ,p_vacancy_id in number default hr_api.g_number
372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

Line 375: ,p_resume_description in varchar2 default hr_api.g_varchar2

371: ,p_vacancy_id in number default hr_api.g_number
372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number

Line 376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2

372: ,p_first_name in varchar2 default hr_api.g_varchar2
373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number

Line 377: ,p_source_type in varchar2 default hr_api.g_varchar2

373: ,p_user_password in varchar2 default hr_api.g_varchar2
374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2

Line 378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2

374: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2

Line 379: ,p_posting_content_id in number default hr_api.g_number

375: ,p_resume_description in varchar2 default hr_api.g_varchar2
376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date

Line 380: ,p_person_id in number default hr_api.g_number

376: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2

Line 381: ,p_processed in varchar2 default hr_api.g_varchar2

377: ,p_source_type in varchar2 default hr_api.g_varchar2
378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2

Line 382: ,p_sex in varchar2 default hr_api.g_varchar2

378: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 383: ,p_date_of_birth in date default hr_api.g_date

379: ,p_posting_content_id in number default hr_api.g_number
380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 384: ,p_per_information_category in varchar2 default hr_api.g_varchar2

380: ,p_person_id in number default hr_api.g_number
381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 385: ,p_per_information1 in varchar2 default hr_api.g_varchar2

381: ,p_processed in varchar2 default hr_api.g_varchar2
382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 386: ,p_per_information2 in varchar2 default hr_api.g_varchar2

382: ,p_sex in varchar2 default hr_api.g_varchar2
383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 387: ,p_per_information3 in varchar2 default hr_api.g_varchar2

383: ,p_date_of_birth in date default hr_api.g_date
384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 388: ,p_per_information4 in varchar2 default hr_api.g_varchar2

384: ,p_per_information_category in varchar2 default hr_api.g_varchar2
385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 389: ,p_per_information5 in varchar2 default hr_api.g_varchar2

385: ,p_per_information1 in varchar2 default hr_api.g_varchar2
386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 390: ,p_per_information6 in varchar2 default hr_api.g_varchar2

386: ,p_per_information2 in varchar2 default hr_api.g_varchar2
387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 391: ,p_per_information7 in varchar2 default hr_api.g_varchar2

387: ,p_per_information3 in varchar2 default hr_api.g_varchar2
388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 392: ,p_per_information8 in varchar2 default hr_api.g_varchar2

388: ,p_per_information4 in varchar2 default hr_api.g_varchar2
389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 393: ,p_per_information9 in varchar2 default hr_api.g_varchar2

389: ,p_per_information5 in varchar2 default hr_api.g_varchar2
390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 394: ,p_per_information10 in varchar2 default hr_api.g_varchar2

390: ,p_per_information6 in varchar2 default hr_api.g_varchar2
391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 395: ,p_per_information11 in varchar2 default hr_api.g_varchar2

391: ,p_per_information7 in varchar2 default hr_api.g_varchar2
392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 396: ,p_per_information12 in varchar2 default hr_api.g_varchar2

392: ,p_per_information8 in varchar2 default hr_api.g_varchar2
393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 397: ,p_per_information13 in varchar2 default hr_api.g_varchar2

393: ,p_per_information9 in varchar2 default hr_api.g_varchar2
394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 398: ,p_per_information14 in varchar2 default hr_api.g_varchar2

394: ,p_per_information10 in varchar2 default hr_api.g_varchar2
395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 399: ,p_per_information15 in varchar2 default hr_api.g_varchar2

395: ,p_per_information11 in varchar2 default hr_api.g_varchar2
396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 400: ,p_per_information16 in varchar2 default hr_api.g_varchar2

396: ,p_per_information12 in varchar2 default hr_api.g_varchar2
397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 401: ,p_per_information17 in varchar2 default hr_api.g_varchar2

397: ,p_per_information13 in varchar2 default hr_api.g_varchar2
398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 402: ,p_per_information18 in varchar2 default hr_api.g_varchar2

398: ,p_per_information14 in varchar2 default hr_api.g_varchar2
399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 403: ,p_per_information19 in varchar2 default hr_api.g_varchar2

399: ,p_per_information15 in varchar2 default hr_api.g_varchar2
400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 404: ,p_per_information20 in varchar2 default hr_api.g_varchar2

400: ,p_per_information16 in varchar2 default hr_api.g_varchar2
401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 405: ,p_per_information21 in varchar2 default hr_api.g_varchar2

401: ,p_per_information17 in varchar2 default hr_api.g_varchar2
402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 406: ,p_per_information22 in varchar2 default hr_api.g_varchar2

402: ,p_per_information18 in varchar2 default hr_api.g_varchar2
403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 407: ,p_per_information23 in varchar2 default hr_api.g_varchar2

403: ,p_per_information19 in varchar2 default hr_api.g_varchar2
404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 408: ,p_per_information24 in varchar2 default hr_api.g_varchar2

404: ,p_per_information20 in varchar2 default hr_api.g_varchar2
405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 409: ,p_per_information25 in varchar2 default hr_api.g_varchar2

405: ,p_per_information21 in varchar2 default hr_api.g_varchar2
406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 410: ,p_per_information26 in varchar2 default hr_api.g_varchar2

406: ,p_per_information22 in varchar2 default hr_api.g_varchar2
407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 411: ,p_per_information27 in varchar2 default hr_api.g_varchar2

407: ,p_per_information23 in varchar2 default hr_api.g_varchar2
408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2

Line 412: ,p_per_information28 in varchar2 default hr_api.g_varchar2

408: ,p_per_information24 in varchar2 default hr_api.g_varchar2
409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2
416: ,p_creation_date in date default hr_api.g_date

Line 413: ,p_per_information29 in varchar2 default hr_api.g_varchar2

409: ,p_per_information25 in varchar2 default hr_api.g_varchar2
410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2
416: ,p_creation_date in date default hr_api.g_date
417: ,p_last_update_date in date default hr_api.g_date

Line 414: ,p_per_information30 in varchar2 default hr_api.g_varchar2

410: ,p_per_information26 in varchar2 default hr_api.g_varchar2
411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2
416: ,p_creation_date in date default hr_api.g_date
417: ,p_last_update_date in date default hr_api.g_date
418: ,p_allow_access in varchar2 default hr_api.g_varchar2

Line 415: ,p_error_message in varchar2 default hr_api.g_varchar2

411: ,p_per_information27 in varchar2 default hr_api.g_varchar2
412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2
416: ,p_creation_date in date default hr_api.g_date
417: ,p_last_update_date in date default hr_api.g_date
418: ,p_allow_access in varchar2 default hr_api.g_varchar2
419: ,p_user_guid in raw default null

Line 416: ,p_creation_date in date default hr_api.g_date

412: ,p_per_information28 in varchar2 default hr_api.g_varchar2
413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2
416: ,p_creation_date in date default hr_api.g_date
417: ,p_last_update_date in date default hr_api.g_date
418: ,p_allow_access in varchar2 default hr_api.g_varchar2
419: ,p_user_guid in raw default null
420: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2

Line 417: ,p_last_update_date in date default hr_api.g_date

413: ,p_per_information29 in varchar2 default hr_api.g_varchar2
414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2
416: ,p_creation_date in date default hr_api.g_date
417: ,p_last_update_date in date default hr_api.g_date
418: ,p_allow_access in varchar2 default hr_api.g_varchar2
419: ,p_user_guid in raw default null
420: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
421: ,p_visitor_resp_appl_id in number default hr_api.g_number

Line 418: ,p_allow_access in varchar2 default hr_api.g_varchar2

414: ,p_per_information30 in varchar2 default hr_api.g_varchar2
415: ,p_error_message in varchar2 default hr_api.g_varchar2
416: ,p_creation_date in date default hr_api.g_date
417: ,p_last_update_date in date default hr_api.g_date
418: ,p_allow_access in varchar2 default hr_api.g_varchar2
419: ,p_user_guid in raw default null
420: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
421: ,p_visitor_resp_appl_id in number default hr_api.g_number
422: ,p_security_group_key in varchar2 default hr_api.g_varchar2

Line 420: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2

416: ,p_creation_date in date default hr_api.g_date
417: ,p_last_update_date in date default hr_api.g_date
418: ,p_allow_access in varchar2 default hr_api.g_varchar2
419: ,p_user_guid in raw default null
420: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
421: ,p_visitor_resp_appl_id in number default hr_api.g_number
422: ,p_security_group_key in varchar2 default hr_api.g_varchar2
423: ) is
424: --

Line 421: ,p_visitor_resp_appl_id in number default hr_api.g_number

417: ,p_last_update_date in date default hr_api.g_date
418: ,p_allow_access in varchar2 default hr_api.g_varchar2
419: ,p_user_guid in raw default null
420: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
421: ,p_visitor_resp_appl_id in number default hr_api.g_number
422: ,p_security_group_key in varchar2 default hr_api.g_varchar2
423: ) is
424: --
425: -- Declare cursors and local variables

Line 422: ,p_security_group_key in varchar2 default hr_api.g_varchar2

418: ,p_allow_access in varchar2 default hr_api.g_varchar2
419: ,p_user_guid in raw default null
420: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
421: ,p_visitor_resp_appl_id in number default hr_api.g_number
422: ,p_security_group_key in varchar2 default hr_api.g_varchar2
423: ) is
424: --
425: -- Declare cursors and local variables
426: --

Line 506: when hr_api.cannot_find_prog_unit then

502: ,p_visitor_resp_appl_id => p_visitor_resp_appl_id
503: ,p_security_group_key => p_security_group_key
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'UPDATE_PENDING_DATA'
509: ,p_hook_type => 'BP'
510: );

Line 507: hr_api.cannot_find_prog_unit_error

503: ,p_security_group_key => p_security_group_key
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'UPDATE_PENDING_DATA'
509: ,p_hook_type => 'BP'
510: );
511: end;

Line 632: when hr_api.cannot_find_prog_unit then

628: ,p_visitor_resp_appl_id => p_visitor_resp_appl_id
629: ,p_security_group_key => p_security_group_key
630: );
631: exception
632: when hr_api.cannot_find_prog_unit then
633: hr_api.cannot_find_prog_unit_error
634: (p_module_name => 'UPDATE_PENDING_DATA'
635: ,p_hook_type => 'AP'
636: );

Line 633: hr_api.cannot_find_prog_unit_error

629: ,p_security_group_key => p_security_group_key
630: );
631: exception
632: when hr_api.cannot_find_prog_unit then
633: hr_api.cannot_find_prog_unit_error
634: (p_module_name => 'UPDATE_PENDING_DATA'
635: ,p_hook_type => 'AP'
636: );
637: end;

Line 643: raise hr_api.validate_enabled;

639: --
640: -- When in validation only mode raise the Validate_Enabled exception
641: --
642: if p_validate then
643: raise hr_api.validate_enabled;
644: end if;
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 70);
647: exception

Line 648: when hr_api.validate_enabled then

644: end if;
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 70);
647: exception
648: when hr_api.validate_enabled then
649: --
650: -- As the Validate_Enabled exception has been raised
651: -- we must rollback to the savepoint
652: --

Line 695: when hr_api.cannot_find_prog_unit then

691: IRC_PENDING_DATA_BK3.DELETE_PENDING_DATA_b
692: (p_pending_data_id => p_pending_data_id
693: );
694: exception
695: when hr_api.cannot_find_prog_unit then
696: hr_api.cannot_find_prog_unit_error
697: (p_module_name => 'DELETE_PENDING_DATA'
698: ,p_hook_type => 'BP'
699: );

Line 696: hr_api.cannot_find_prog_unit_error

692: (p_pending_data_id => p_pending_data_id
693: );
694: exception
695: when hr_api.cannot_find_prog_unit then
696: hr_api.cannot_find_prog_unit_error
697: (p_module_name => 'DELETE_PENDING_DATA'
698: ,p_hook_type => 'BP'
699: );
700: end;

Line 713: when hr_api.cannot_find_prog_unit then

709: IRC_PENDING_DATA_BK3.DELETE_PENDING_DATA_a
710: (p_pending_data_id => p_pending_data_id
711: );
712: exception
713: when hr_api.cannot_find_prog_unit then
714: hr_api.cannot_find_prog_unit_error
715: (p_module_name => 'DELETE_PENDING_DATA'
716: ,p_hook_type => 'AP'
717: );

Line 714: hr_api.cannot_find_prog_unit_error

710: (p_pending_data_id => p_pending_data_id
711: );
712: exception
713: when hr_api.cannot_find_prog_unit then
714: hr_api.cannot_find_prog_unit_error
715: (p_module_name => 'DELETE_PENDING_DATA'
716: ,p_hook_type => 'AP'
717: );
718: end;

Line 725: raise hr_api.validate_enabled;

721: --
722: -- When in validation only mode raise the Validate_Enabled exception
723: --
724: if p_validate then
725: raise hr_api.validate_enabled;
726: end if;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 70);
729: exception

Line 730: when hr_api.validate_enabled then

726: end if;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 70);
729: exception
730: when hr_api.validate_enabled then
731: --
732: -- As the Validate_Enabled exception has been raised
733: -- we must rollback to the savepoint
734: --

Line 1271: ,p_date_of_birth => nvl(l_data.date_of_birth,hr_api.g_date)

1267: ,p_person_id => l_applicant_person_id
1268: ,p_datetrack_update_mode => 'CORRECTION'
1269: ,p_object_version_number => l_per_ovn
1270: ,p_last_name => l_data.last_name
1271: ,p_date_of_birth => nvl(l_data.date_of_birth,hr_api.g_date)
1272: ,p_email_address => l_data.email_address
1273: ,p_first_name => l_data.first_name
1274: ,p_sex => nvl(l_data.sex,hr_api.g_varchar2)
1275: ,p_employee_number => l_emp_number

Line 1274: ,p_sex => nvl(l_data.sex,hr_api.g_varchar2)

1270: ,p_last_name => l_data.last_name
1271: ,p_date_of_birth => nvl(l_data.date_of_birth,hr_api.g_date)
1272: ,p_email_address => l_data.email_address
1273: ,p_first_name => l_data.first_name
1274: ,p_sex => nvl(l_data.sex,hr_api.g_varchar2)
1275: ,p_employee_number => l_emp_number
1276: ,p_per_information_category => nvl(l_data.per_information_category,hr_api.g_varchar2)
1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)
1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)

Line 1276: ,p_per_information_category => nvl(l_data.per_information_category,hr_api.g_varchar2)

1272: ,p_email_address => l_data.email_address
1273: ,p_first_name => l_data.first_name
1274: ,p_sex => nvl(l_data.sex,hr_api.g_varchar2)
1275: ,p_employee_number => l_emp_number
1276: ,p_per_information_category => nvl(l_data.per_information_category,hr_api.g_varchar2)
1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)
1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)
1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)

Line 1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)

1273: ,p_first_name => l_data.first_name
1274: ,p_sex => nvl(l_data.sex,hr_api.g_varchar2)
1275: ,p_employee_number => l_emp_number
1276: ,p_per_information_category => nvl(l_data.per_information_category,hr_api.g_varchar2)
1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)
1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)
1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)

Line 1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)

1274: ,p_sex => nvl(l_data.sex,hr_api.g_varchar2)
1275: ,p_employee_number => l_emp_number
1276: ,p_per_information_category => nvl(l_data.per_information_category,hr_api.g_varchar2)
1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)
1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)
1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)

Line 1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)

1275: ,p_employee_number => l_emp_number
1276: ,p_per_information_category => nvl(l_data.per_information_category,hr_api.g_varchar2)
1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)
1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)
1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)

Line 1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)

1276: ,p_per_information_category => nvl(l_data.per_information_category,hr_api.g_varchar2)
1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)
1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)
1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)

Line 1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)

1277: ,p_per_information1 => nvl(l_data.per_information1,hr_api.g_varchar2)
1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)
1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)

Line 1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)

1278: ,p_per_information2 => nvl(l_data.per_information2,hr_api.g_varchar2)
1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)

Line 1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)

1279: ,p_per_information3 => nvl(l_data.per_information3,hr_api.g_varchar2)
1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)

Line 1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)

1280: ,p_per_information4 => nvl(l_data.per_information4,hr_api.g_varchar2)
1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)

Line 1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)

1281: ,p_per_information5 => nvl(l_data.per_information5,hr_api.g_varchar2)
1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)

Line 1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)

1282: ,p_per_information6 => nvl(l_data.per_information6,hr_api.g_varchar2)
1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)

Line 1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)

1283: ,p_per_information7 => nvl(l_data.per_information7,hr_api.g_varchar2)
1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)

Line 1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)

1284: ,p_per_information8 => nvl(l_data.per_information8,hr_api.g_varchar2)
1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)

Line 1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)

1285: ,p_per_information9 => nvl(l_data.per_information9,hr_api.g_varchar2)
1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)

Line 1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)

1286: ,p_per_information10 => nvl(l_data.per_information10,hr_api.g_varchar2)
1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)

Line 1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)

1287: ,p_per_information11 => nvl(l_data.per_information11,hr_api.g_varchar2)
1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)

Line 1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)

1288: ,p_per_information12 => nvl(l_data.per_information12,hr_api.g_varchar2)
1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)

Line 1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)

1289: ,p_per_information13 => nvl(l_data.per_information13,hr_api.g_varchar2)
1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)

Line 1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)

1290: ,p_per_information14 => nvl(l_data.per_information14,hr_api.g_varchar2)
1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)

Line 1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)

1291: ,p_per_information15 => nvl(l_data.per_information15,hr_api.g_varchar2)
1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)

Line 1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)

1292: ,p_per_information16 => nvl(l_data.per_information16,hr_api.g_varchar2)
1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)

Line 1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)

1293: ,p_per_information17 => nvl(l_data.per_information17,hr_api.g_varchar2)
1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)

Line 1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)

1294: ,p_per_information18 => nvl(l_data.per_information18,hr_api.g_varchar2)
1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)

Line 1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)

1295: ,p_per_information19 => nvl(l_data.per_information19,hr_api.g_varchar2)
1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)

Line 1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)

1296: ,p_per_information20 => nvl(l_data.per_information20,hr_api.g_varchar2)
1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)
1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)

Line 1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)

1297: ,p_per_information21 => nvl(l_data.per_information21,hr_api.g_varchar2)
1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)
1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)
1305: ,p_per_information29 => nvl(l_data.per_information29,hr_api.g_varchar2)

Line 1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)

1298: ,p_per_information22 => nvl(l_data.per_information22,hr_api.g_varchar2)
1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)
1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)
1305: ,p_per_information29 => nvl(l_data.per_information29,hr_api.g_varchar2)
1306: ,p_per_information30 => nvl(l_data.per_information30,hr_api.g_varchar2)

Line 1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)

1299: ,p_per_information23 => nvl(l_data.per_information23,hr_api.g_varchar2)
1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)
1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)
1305: ,p_per_information29 => nvl(l_data.per_information29,hr_api.g_varchar2)
1306: ,p_per_information30 => nvl(l_data.per_information30,hr_api.g_varchar2)
1307: ,p_effective_start_date => l_effective_start_date

Line 1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)

1300: ,p_per_information24 => nvl(l_data.per_information24,hr_api.g_varchar2)
1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)
1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)
1305: ,p_per_information29 => nvl(l_data.per_information29,hr_api.g_varchar2)
1306: ,p_per_information30 => nvl(l_data.per_information30,hr_api.g_varchar2)
1307: ,p_effective_start_date => l_effective_start_date
1308: ,p_effective_end_date => l_effective_end_date

Line 1305: ,p_per_information29 => nvl(l_data.per_information29,hr_api.g_varchar2)

1301: ,p_per_information25 => nvl(l_data.per_information25,hr_api.g_varchar2)
1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)
1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)
1305: ,p_per_information29 => nvl(l_data.per_information29,hr_api.g_varchar2)
1306: ,p_per_information30 => nvl(l_data.per_information30,hr_api.g_varchar2)
1307: ,p_effective_start_date => l_effective_start_date
1308: ,p_effective_end_date => l_effective_end_date
1309: ,p_full_name => l_full_name

Line 1306: ,p_per_information30 => nvl(l_data.per_information30,hr_api.g_varchar2)

1302: ,p_per_information26 => nvl(l_data.per_information26,hr_api.g_varchar2)
1303: ,p_per_information27 => nvl(l_data.per_information27,hr_api.g_varchar2)
1304: ,p_per_information28 => nvl(l_data.per_information28,hr_api.g_varchar2)
1305: ,p_per_information29 => nvl(l_data.per_information29,hr_api.g_varchar2)
1306: ,p_per_information30 => nvl(l_data.per_information30,hr_api.g_varchar2)
1307: ,p_effective_start_date => l_effective_start_date
1308: ,p_effective_end_date => l_effective_end_date
1309: ,p_full_name => l_full_name
1310: ,p_comment_id => l_comment_id