APPS.PER_APL_UPD dependencies on HR_API

Line 112: When hr_api.check_integrity_violated Then

108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: --
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: per_apl_shd.g_api_dml := false; -- Unset the api dml status
115: per_apl_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: per_apl_shd.g_api_dml := false; -- Unset the api dml status
115: per_apl_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: per_apl_shd.g_api_dml := false; -- Unset the api dml status
120: per_apl_shd.constraint_error

Line 117: When hr_api.parent_integrity_violated Then

113: -- A check constraint has been violated
114: per_apl_shd.g_api_dml := false; -- Unset the api dml status
115: per_apl_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: per_apl_shd.g_api_dml := false; -- Unset the api dml status
120: per_apl_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: per_apl_shd.g_api_dml := false; -- Unset the api dml status
120: per_apl_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: per_apl_shd.g_api_dml := false; -- Unset the api dml status
125: per_apl_shd.constraint_error

Line 122: When hr_api.unique_integrity_violated Then

118: -- Parent integrity has been violated
119: per_apl_shd.g_api_dml := false; -- Unset the api dml status
120: per_apl_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: per_apl_shd.g_api_dml := false; -- Unset the api dml status
125: per_apl_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: per_apl_shd.g_api_dml := false; -- Unset the api dml status
125: per_apl_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: per_apl_shd.g_api_dml := false; -- Unset the api dml status
129: Raise;
130: End update_dml;

Line 321: when hr_api.cannot_find_prog_unit then

317: ,p_object_version_number_o
318: => per_apl_shd.g_old_rec.object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then
322: hr_api.cannot_find_prog_unit_error
323: (p_module_name => 'PER_APPLICATIONS'
324: ,p_hook_type => 'AU'
325: );

Line 322: hr_api.cannot_find_prog_unit_error

318: => per_apl_shd.g_old_rec.object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then
322: hr_api.cannot_find_prog_unit_error
323: (p_module_name => 'PER_APPLICATIONS'
324: ,p_hook_type => 'AU'
325: );
326: end;

Line 389: If (p_rec.business_group_id = hr_api.g_number) then

385: -- p_rec plsql record structure
386: -- to see if a system default is being used. If a system default
387: -- is being used then we must set to the 'current' argument value.
388: --
389: If (p_rec.business_group_id = hr_api.g_number) then
390: p_rec.business_group_id :=
391: per_apl_shd.g_old_rec.business_group_id;
392: End If;
393: If (p_rec.person_id = hr_api.g_number) then

Line 393: If (p_rec.person_id = hr_api.g_number) then

389: If (p_rec.business_group_id = hr_api.g_number) then
390: p_rec.business_group_id :=
391: per_apl_shd.g_old_rec.business_group_id;
392: End If;
393: If (p_rec.person_id = hr_api.g_number) then
394: p_rec.person_id :=
395: per_apl_shd.g_old_rec.person_id;
396: End If;
397: If (p_rec.date_received = hr_api.g_date) then

Line 397: If (p_rec.date_received = hr_api.g_date) then

393: If (p_rec.person_id = hr_api.g_number) then
394: p_rec.person_id :=
395: per_apl_shd.g_old_rec.person_id;
396: End If;
397: If (p_rec.date_received = hr_api.g_date) then
398: hr_utility.set_location(l_proc,6);
399: p_rec.date_received :=
400: per_apl_shd.g_old_rec.date_received;
401: End If;

Line 402: If (p_rec.comments = hr_api.g_varchar2) then

398: hr_utility.set_location(l_proc,6);
399: p_rec.date_received :=
400: per_apl_shd.g_old_rec.date_received;
401: End If;
402: If (p_rec.comments = hr_api.g_varchar2) then
403: p_rec.comments :=
404: per_apl_shd.g_old_rec.comments;
405: End If;
406: If (p_rec.current_employer = hr_api.g_varchar2) then

Line 406: If (p_rec.current_employer = hr_api.g_varchar2) then

402: If (p_rec.comments = hr_api.g_varchar2) then
403: p_rec.comments :=
404: per_apl_shd.g_old_rec.comments;
405: End If;
406: If (p_rec.current_employer = hr_api.g_varchar2) then
407: p_rec.current_employer :=
408: per_apl_shd.g_old_rec.current_employer;
409: End If;
410: If (p_rec.date_end = hr_api.g_date) then

Line 410: If (p_rec.date_end = hr_api.g_date) then

406: If (p_rec.current_employer = hr_api.g_varchar2) then
407: p_rec.current_employer :=
408: per_apl_shd.g_old_rec.current_employer;
409: End If;
410: If (p_rec.date_end = hr_api.g_date) then
411: p_rec.date_end :=
412: per_apl_shd.g_old_rec.date_end;
413: End If;
414: If (p_rec.projected_hire_date = hr_api.g_date) then

Line 414: If (p_rec.projected_hire_date = hr_api.g_date) then

410: If (p_rec.date_end = hr_api.g_date) then
411: p_rec.date_end :=
412: per_apl_shd.g_old_rec.date_end;
413: End If;
414: If (p_rec.projected_hire_date = hr_api.g_date) then
415: p_rec.projected_hire_date :=
416: per_apl_shd.g_old_rec.projected_hire_date;
417: End If;
418: If (p_rec.successful_flag = hr_api.g_varchar2) then

Line 418: If (p_rec.successful_flag = hr_api.g_varchar2) then

414: If (p_rec.projected_hire_date = hr_api.g_date) then
415: p_rec.projected_hire_date :=
416: per_apl_shd.g_old_rec.projected_hire_date;
417: End If;
418: If (p_rec.successful_flag = hr_api.g_varchar2) then
419: p_rec.successful_flag :=
420: per_apl_shd.g_old_rec.successful_flag;
421: End If;
422: If (p_rec.termination_reason = hr_api.g_varchar2) then

Line 422: If (p_rec.termination_reason = hr_api.g_varchar2) then

418: If (p_rec.successful_flag = hr_api.g_varchar2) then
419: p_rec.successful_flag :=
420: per_apl_shd.g_old_rec.successful_flag;
421: End If;
422: If (p_rec.termination_reason = hr_api.g_varchar2) then
423: p_rec.termination_reason :=
424: per_apl_shd.g_old_rec.termination_reason;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then

Line 426: If (p_rec.request_id = hr_api.g_number) then

422: If (p_rec.termination_reason = hr_api.g_varchar2) then
423: p_rec.termination_reason :=
424: per_apl_shd.g_old_rec.termination_reason;
425: End If;
426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_apl_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then

Line 430: If (p_rec.program_application_id = hr_api.g_number) then

426: If (p_rec.request_id = hr_api.g_number) then
427: p_rec.request_id :=
428: per_apl_shd.g_old_rec.request_id;
429: End If;
430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_apl_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then

Line 434: If (p_rec.program_id = hr_api.g_number) then

430: If (p_rec.program_application_id = hr_api.g_number) then
431: p_rec.program_application_id :=
432: per_apl_shd.g_old_rec.program_application_id;
433: End If;
434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_apl_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then

Line 438: If (p_rec.program_update_date = hr_api.g_date) then

434: If (p_rec.program_id = hr_api.g_number) then
435: p_rec.program_id :=
436: per_apl_shd.g_old_rec.program_id;
437: End If;
438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_apl_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.appl_attribute_category = hr_api.g_varchar2) then

Line 442: If (p_rec.appl_attribute_category = hr_api.g_varchar2) then

438: If (p_rec.program_update_date = hr_api.g_date) then
439: p_rec.program_update_date :=
440: per_apl_shd.g_old_rec.program_update_date;
441: End If;
442: If (p_rec.appl_attribute_category = hr_api.g_varchar2) then
443: p_rec.appl_attribute_category :=
444: per_apl_shd.g_old_rec.appl_attribute_category;
445: End If;
446: If (p_rec.appl_attribute1 = hr_api.g_varchar2) then

Line 446: If (p_rec.appl_attribute1 = hr_api.g_varchar2) then

442: If (p_rec.appl_attribute_category = hr_api.g_varchar2) then
443: p_rec.appl_attribute_category :=
444: per_apl_shd.g_old_rec.appl_attribute_category;
445: End If;
446: If (p_rec.appl_attribute1 = hr_api.g_varchar2) then
447: p_rec.appl_attribute1 :=
448: per_apl_shd.g_old_rec.appl_attribute1;
449: End If;
450: If (p_rec.appl_attribute2 = hr_api.g_varchar2) then

Line 450: If (p_rec.appl_attribute2 = hr_api.g_varchar2) then

446: If (p_rec.appl_attribute1 = hr_api.g_varchar2) then
447: p_rec.appl_attribute1 :=
448: per_apl_shd.g_old_rec.appl_attribute1;
449: End If;
450: If (p_rec.appl_attribute2 = hr_api.g_varchar2) then
451: p_rec.appl_attribute2 :=
452: per_apl_shd.g_old_rec.appl_attribute2;
453: End If;
454: If (p_rec.appl_attribute3 = hr_api.g_varchar2) then

Line 454: If (p_rec.appl_attribute3 = hr_api.g_varchar2) then

450: If (p_rec.appl_attribute2 = hr_api.g_varchar2) then
451: p_rec.appl_attribute2 :=
452: per_apl_shd.g_old_rec.appl_attribute2;
453: End If;
454: If (p_rec.appl_attribute3 = hr_api.g_varchar2) then
455: p_rec.appl_attribute3 :=
456: per_apl_shd.g_old_rec.appl_attribute3;
457: End If;
458: If (p_rec.appl_attribute4 = hr_api.g_varchar2) then

Line 458: If (p_rec.appl_attribute4 = hr_api.g_varchar2) then

454: If (p_rec.appl_attribute3 = hr_api.g_varchar2) then
455: p_rec.appl_attribute3 :=
456: per_apl_shd.g_old_rec.appl_attribute3;
457: End If;
458: If (p_rec.appl_attribute4 = hr_api.g_varchar2) then
459: p_rec.appl_attribute4 :=
460: per_apl_shd.g_old_rec.appl_attribute4;
461: End If;
462: If (p_rec.appl_attribute5 = hr_api.g_varchar2) then

Line 462: If (p_rec.appl_attribute5 = hr_api.g_varchar2) then

458: If (p_rec.appl_attribute4 = hr_api.g_varchar2) then
459: p_rec.appl_attribute4 :=
460: per_apl_shd.g_old_rec.appl_attribute4;
461: End If;
462: If (p_rec.appl_attribute5 = hr_api.g_varchar2) then
463: p_rec.appl_attribute5 :=
464: per_apl_shd.g_old_rec.appl_attribute5;
465: End If;
466: If (p_rec.appl_attribute6 = hr_api.g_varchar2) then

Line 466: If (p_rec.appl_attribute6 = hr_api.g_varchar2) then

462: If (p_rec.appl_attribute5 = hr_api.g_varchar2) then
463: p_rec.appl_attribute5 :=
464: per_apl_shd.g_old_rec.appl_attribute5;
465: End If;
466: If (p_rec.appl_attribute6 = hr_api.g_varchar2) then
467: p_rec.appl_attribute6 :=
468: per_apl_shd.g_old_rec.appl_attribute6;
469: End If;
470: If (p_rec.appl_attribute7 = hr_api.g_varchar2) then

Line 470: If (p_rec.appl_attribute7 = hr_api.g_varchar2) then

466: If (p_rec.appl_attribute6 = hr_api.g_varchar2) then
467: p_rec.appl_attribute6 :=
468: per_apl_shd.g_old_rec.appl_attribute6;
469: End If;
470: If (p_rec.appl_attribute7 = hr_api.g_varchar2) then
471: p_rec.appl_attribute7 :=
472: per_apl_shd.g_old_rec.appl_attribute7;
473: End If;
474: If (p_rec.appl_attribute8 = hr_api.g_varchar2) then

Line 474: If (p_rec.appl_attribute8 = hr_api.g_varchar2) then

470: If (p_rec.appl_attribute7 = hr_api.g_varchar2) then
471: p_rec.appl_attribute7 :=
472: per_apl_shd.g_old_rec.appl_attribute7;
473: End If;
474: If (p_rec.appl_attribute8 = hr_api.g_varchar2) then
475: p_rec.appl_attribute8 :=
476: per_apl_shd.g_old_rec.appl_attribute8;
477: End If;
478: If (p_rec.appl_attribute9 = hr_api.g_varchar2) then

Line 478: If (p_rec.appl_attribute9 = hr_api.g_varchar2) then

474: If (p_rec.appl_attribute8 = hr_api.g_varchar2) then
475: p_rec.appl_attribute8 :=
476: per_apl_shd.g_old_rec.appl_attribute8;
477: End If;
478: If (p_rec.appl_attribute9 = hr_api.g_varchar2) then
479: p_rec.appl_attribute9 :=
480: per_apl_shd.g_old_rec.appl_attribute9;
481: End If;
482: If (p_rec.appl_attribute10 = hr_api.g_varchar2) then

Line 482: If (p_rec.appl_attribute10 = hr_api.g_varchar2) then

478: If (p_rec.appl_attribute9 = hr_api.g_varchar2) then
479: p_rec.appl_attribute9 :=
480: per_apl_shd.g_old_rec.appl_attribute9;
481: End If;
482: If (p_rec.appl_attribute10 = hr_api.g_varchar2) then
483: p_rec.appl_attribute10 :=
484: per_apl_shd.g_old_rec.appl_attribute10;
485: End If;
486: If (p_rec.appl_attribute11 = hr_api.g_varchar2) then

Line 486: If (p_rec.appl_attribute11 = hr_api.g_varchar2) then

482: If (p_rec.appl_attribute10 = hr_api.g_varchar2) then
483: p_rec.appl_attribute10 :=
484: per_apl_shd.g_old_rec.appl_attribute10;
485: End If;
486: If (p_rec.appl_attribute11 = hr_api.g_varchar2) then
487: p_rec.appl_attribute11 :=
488: per_apl_shd.g_old_rec.appl_attribute11;
489: End If;
490: If (p_rec.appl_attribute12 = hr_api.g_varchar2) then

Line 490: If (p_rec.appl_attribute12 = hr_api.g_varchar2) then

486: If (p_rec.appl_attribute11 = hr_api.g_varchar2) then
487: p_rec.appl_attribute11 :=
488: per_apl_shd.g_old_rec.appl_attribute11;
489: End If;
490: If (p_rec.appl_attribute12 = hr_api.g_varchar2) then
491: p_rec.appl_attribute12 :=
492: per_apl_shd.g_old_rec.appl_attribute12;
493: End If;
494: If (p_rec.appl_attribute13 = hr_api.g_varchar2) then

Line 494: If (p_rec.appl_attribute13 = hr_api.g_varchar2) then

490: If (p_rec.appl_attribute12 = hr_api.g_varchar2) then
491: p_rec.appl_attribute12 :=
492: per_apl_shd.g_old_rec.appl_attribute12;
493: End If;
494: If (p_rec.appl_attribute13 = hr_api.g_varchar2) then
495: p_rec.appl_attribute13 :=
496: per_apl_shd.g_old_rec.appl_attribute13;
497: End If;
498: If (p_rec.appl_attribute14 = hr_api.g_varchar2) then

Line 498: If (p_rec.appl_attribute14 = hr_api.g_varchar2) then

494: If (p_rec.appl_attribute13 = hr_api.g_varchar2) then
495: p_rec.appl_attribute13 :=
496: per_apl_shd.g_old_rec.appl_attribute13;
497: End If;
498: If (p_rec.appl_attribute14 = hr_api.g_varchar2) then
499: p_rec.appl_attribute14 :=
500: per_apl_shd.g_old_rec.appl_attribute14;
501: End If;
502: If (p_rec.appl_attribute15 = hr_api.g_varchar2) then

Line 502: If (p_rec.appl_attribute15 = hr_api.g_varchar2) then

498: If (p_rec.appl_attribute14 = hr_api.g_varchar2) then
499: p_rec.appl_attribute14 :=
500: per_apl_shd.g_old_rec.appl_attribute14;
501: End If;
502: If (p_rec.appl_attribute15 = hr_api.g_varchar2) then
503: p_rec.appl_attribute15 :=
504: per_apl_shd.g_old_rec.appl_attribute15;
505: End If;
506: If (p_rec.appl_attribute16 = hr_api.g_varchar2) then

Line 506: If (p_rec.appl_attribute16 = hr_api.g_varchar2) then

502: If (p_rec.appl_attribute15 = hr_api.g_varchar2) then
503: p_rec.appl_attribute15 :=
504: per_apl_shd.g_old_rec.appl_attribute15;
505: End If;
506: If (p_rec.appl_attribute16 = hr_api.g_varchar2) then
507: p_rec.appl_attribute16 :=
508: per_apl_shd.g_old_rec.appl_attribute16;
509: End If;
510: If (p_rec.appl_attribute17 = hr_api.g_varchar2) then

Line 510: If (p_rec.appl_attribute17 = hr_api.g_varchar2) then

506: If (p_rec.appl_attribute16 = hr_api.g_varchar2) then
507: p_rec.appl_attribute16 :=
508: per_apl_shd.g_old_rec.appl_attribute16;
509: End If;
510: If (p_rec.appl_attribute17 = hr_api.g_varchar2) then
511: p_rec.appl_attribute17 :=
512: per_apl_shd.g_old_rec.appl_attribute17;
513: End If;
514: If (p_rec.appl_attribute18 = hr_api.g_varchar2) then

Line 514: If (p_rec.appl_attribute18 = hr_api.g_varchar2) then

510: If (p_rec.appl_attribute17 = hr_api.g_varchar2) then
511: p_rec.appl_attribute17 :=
512: per_apl_shd.g_old_rec.appl_attribute17;
513: End If;
514: If (p_rec.appl_attribute18 = hr_api.g_varchar2) then
515: p_rec.appl_attribute18 :=
516: per_apl_shd.g_old_rec.appl_attribute18;
517: End If;
518: If (p_rec.appl_attribute19 = hr_api.g_varchar2) then

Line 518: If (p_rec.appl_attribute19 = hr_api.g_varchar2) then

514: If (p_rec.appl_attribute18 = hr_api.g_varchar2) then
515: p_rec.appl_attribute18 :=
516: per_apl_shd.g_old_rec.appl_attribute18;
517: End If;
518: If (p_rec.appl_attribute19 = hr_api.g_varchar2) then
519: p_rec.appl_attribute19 :=
520: per_apl_shd.g_old_rec.appl_attribute19;
521: End If;
522: If (p_rec.appl_attribute20 = hr_api.g_varchar2) then

Line 522: If (p_rec.appl_attribute20 = hr_api.g_varchar2) then

518: If (p_rec.appl_attribute19 = hr_api.g_varchar2) then
519: p_rec.appl_attribute19 :=
520: per_apl_shd.g_old_rec.appl_attribute19;
521: End If;
522: If (p_rec.appl_attribute20 = hr_api.g_varchar2) then
523: p_rec.appl_attribute20 :=
524: per_apl_shd.g_old_rec.appl_attribute20;
525: End If;
526:

Line 598: Raise HR_Api.Validate_Enabled;

594: --
595: -- If we are validating then raise the Validate_Enabled exception
596: --
597: If p_validate then
598: Raise HR_Api.Validate_Enabled;
599: End If;
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: Exception

Line 603: When HR_Api.Validate_Enabled Then

599: End If;
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: Exception
603: When HR_Api.Validate_Enabled Then
604: --
605: -- As the Validate_Enabled exception has been raised
606: -- we must rollback to the savepoint
607: --

Line 617: p_date_received in date default hr_api.g_date,

613: -- ----------------------------------------------------------------------------
614: Procedure upd
615: (
616: p_application_id in number,
617: p_date_received in date default hr_api.g_date,
618: p_comments in varchar2 default hr_api.g_varchar2,
619: p_current_employer in varchar2 default hr_api.g_varchar2,
620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,

Line 618: p_comments in varchar2 default hr_api.g_varchar2,

614: Procedure upd
615: (
616: p_application_id in number,
617: p_date_received in date default hr_api.g_date,
618: p_comments in varchar2 default hr_api.g_varchar2,
619: p_current_employer in varchar2 default hr_api.g_varchar2,
620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,

Line 619: p_current_employer in varchar2 default hr_api.g_varchar2,

615: (
616: p_application_id in number,
617: p_date_received in date default hr_api.g_date,
618: p_comments in varchar2 default hr_api.g_varchar2,
619: p_current_employer in varchar2 default hr_api.g_varchar2,
620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,

Line 620: p_date_end in date default hr_api.g_date,

616: p_application_id in number,
617: p_date_received in date default hr_api.g_date,
618: p_comments in varchar2 default hr_api.g_varchar2,
619: p_current_employer in varchar2 default hr_api.g_varchar2,
620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,

Line 621: p_projected_hire_date in date default hr_api.g_date,

617: p_date_received in date default hr_api.g_date,
618: p_comments in varchar2 default hr_api.g_varchar2,
619: p_current_employer in varchar2 default hr_api.g_varchar2,
620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,

Line 622: p_successful_flag in varchar2 default hr_api.g_varchar2,

618: p_comments in varchar2 default hr_api.g_varchar2,
619: p_current_employer in varchar2 default hr_api.g_varchar2,
620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,

Line 623: p_termination_reason in varchar2 default hr_api.g_varchar2,

619: p_current_employer in varchar2 default hr_api.g_varchar2,
620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,

Line 624: p_request_id in number default hr_api.g_number,

620: p_date_end in date default hr_api.g_date,
621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,

Line 625: p_program_application_id in number default hr_api.g_number,

621: p_projected_hire_date in date default hr_api.g_date,
622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,

Line 626: p_program_id in number default hr_api.g_number,

622: p_successful_flag in varchar2 default hr_api.g_varchar2,
623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,

Line 627: p_program_update_date in date default hr_api.g_date,

623: p_termination_reason in varchar2 default hr_api.g_varchar2,
624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,

Line 628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,

624: p_request_id in number default hr_api.g_number,
625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,

Line 629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,

625: p_program_application_id in number default hr_api.g_number,
626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,

Line 630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,

626: p_program_id in number default hr_api.g_number,
627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,

Line 631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,

627: p_program_update_date in date default hr_api.g_date,
628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,

Line 632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,

628: p_appl_attribute_category in varchar2 default hr_api.g_varchar2,
629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,

Line 633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,

629: p_appl_attribute1 in varchar2 default hr_api.g_varchar2,
630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,

Line 634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,

630: p_appl_attribute2 in varchar2 default hr_api.g_varchar2,
631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,

Line 635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,

631: p_appl_attribute3 in varchar2 default hr_api.g_varchar2,
632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,

Line 636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,

632: p_appl_attribute4 in varchar2 default hr_api.g_varchar2,
633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,

Line 637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,

633: p_appl_attribute5 in varchar2 default hr_api.g_varchar2,
634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,

Line 638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,

634: p_appl_attribute6 in varchar2 default hr_api.g_varchar2,
635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,

Line 639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,

635: p_appl_attribute7 in varchar2 default hr_api.g_varchar2,
636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,

Line 640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,

636: p_appl_attribute8 in varchar2 default hr_api.g_varchar2,
637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,

Line 641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,

637: p_appl_attribute9 in varchar2 default hr_api.g_varchar2,
638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,

Line 642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,

638: p_appl_attribute10 in varchar2 default hr_api.g_varchar2,
639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,

Line 643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,

639: p_appl_attribute11 in varchar2 default hr_api.g_varchar2,
640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
647: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,

Line 644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,

640: p_appl_attribute12 in varchar2 default hr_api.g_varchar2,
641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
647: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
648: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,

Line 645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,

641: p_appl_attribute13 in varchar2 default hr_api.g_varchar2,
642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
647: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
648: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
649: p_object_version_number in out nocopy number,

Line 646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,

642: p_appl_attribute14 in varchar2 default hr_api.g_varchar2,
643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
647: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
648: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
649: p_object_version_number in out nocopy number,
650: p_effective_date in date,

Line 647: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,

643: p_appl_attribute15 in varchar2 default hr_api.g_varchar2,
644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
647: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
648: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
649: p_object_version_number in out nocopy number,
650: p_effective_date in date,
651: p_validate in boolean default false

Line 648: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,

644: p_appl_attribute16 in varchar2 default hr_api.g_varchar2,
645: p_appl_attribute17 in varchar2 default hr_api.g_varchar2,
646: p_appl_attribute18 in varchar2 default hr_api.g_varchar2,
647: p_appl_attribute19 in varchar2 default hr_api.g_varchar2,
648: p_appl_attribute20 in varchar2 default hr_api.g_varchar2,
649: p_object_version_number in out nocopy number,
650: p_effective_date in date,
651: p_validate in boolean default false
652: ) is

Line 667: hr_api.g_number,

663: l_rec :=
664: per_apl_shd.convert_args
665: (
666: p_application_id,
667: hr_api.g_number,
668: hr_api.g_number,
669: p_date_received,
670: p_comments,
671: p_current_employer,

Line 668: hr_api.g_number,

664: per_apl_shd.convert_args
665: (
666: p_application_id,
667: hr_api.g_number,
668: hr_api.g_number,
669: p_date_received,
670: p_comments,
671: p_current_employer,
672: p_date_end,