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.OTA_CRT_UPD dependencies on HR_API

Line 117: When hr_api.check_integrity_violated Then

113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ota_crt_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.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ota_crt_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_crt_shd.constraint_error

Line 122: When hr_api.parent_integrity_violated Then

118: -- A check constraint has been violated
119: --
120: ota_crt_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_crt_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.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_crt_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_crt_shd.constraint_error

Line 127: When hr_api.unique_integrity_violated Then

123: -- Parent integrity has been violated
124: --
125: ota_crt_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_crt_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_crt_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;
135: End update_dml;

Line 380: when hr_api.cannot_find_prog_unit then

376: );
377: --
378: exception
379: --
380: when hr_api.cannot_find_prog_unit then
381: --
382: hr_api.cannot_find_prog_unit_error
383: (p_module_name => 'OTA_CERTIFICATIONS_B'
384: ,p_hook_type => 'AU');

Line 382: hr_api.cannot_find_prog_unit_error

378: exception
379: --
380: when hr_api.cannot_find_prog_unit then
381: --
382: hr_api.cannot_find_prog_unit_error
383: (p_module_name => 'OTA_CERTIFICATIONS_B'
384: ,p_hook_type => 'AU');
385: --
386: end;

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

441: -- p_rec plsql record structure
442: -- to see if a system default is being used. If a system default
443: -- is being used then we must set to the 'current' argument value.
444: --
445: If (p_rec.business_group_id = hr_api.g_number) then
446: p_rec.business_group_id :=
447: ota_crt_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.public_flag = hr_api.g_varchar2) then

Line 449: If (p_rec.public_flag = hr_api.g_varchar2) then

445: If (p_rec.business_group_id = hr_api.g_number) then
446: p_rec.business_group_id :=
447: ota_crt_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.public_flag = hr_api.g_varchar2) then
450: p_rec.public_flag :=
451: ota_crt_shd.g_old_rec.public_flag;
452: End If;
453: If (p_rec.initial_completion_date = hr_api.g_date) then

Line 453: If (p_rec.initial_completion_date = hr_api.g_date) then

449: If (p_rec.public_flag = hr_api.g_varchar2) then
450: p_rec.public_flag :=
451: ota_crt_shd.g_old_rec.public_flag;
452: End If;
453: If (p_rec.initial_completion_date = hr_api.g_date) then
454: p_rec.initial_completion_date :=
455: ota_crt_shd.g_old_rec.initial_completion_date;
456: End If;
457: If (p_rec.initial_completion_duration = hr_api.g_number) then

Line 457: If (p_rec.initial_completion_duration = hr_api.g_number) then

453: If (p_rec.initial_completion_date = hr_api.g_date) then
454: p_rec.initial_completion_date :=
455: ota_crt_shd.g_old_rec.initial_completion_date;
456: End If;
457: If (p_rec.initial_completion_duration = hr_api.g_number) then
458: p_rec.initial_completion_duration :=
459: ota_crt_shd.g_old_rec.initial_completion_duration;
460: End If;
461: If (p_rec.initial_compl_duration_units = hr_api.g_varchar2) then

Line 461: If (p_rec.initial_compl_duration_units = hr_api.g_varchar2) then

457: If (p_rec.initial_completion_duration = hr_api.g_number) then
458: p_rec.initial_completion_duration :=
459: ota_crt_shd.g_old_rec.initial_completion_duration;
460: End If;
461: If (p_rec.initial_compl_duration_units = hr_api.g_varchar2) then
462: p_rec.initial_compl_duration_units :=
463: ota_crt_shd.g_old_rec.initial_compl_duration_units;
464: End If;
465: If (p_rec.renewal_duration = hr_api.g_number) then

Line 465: If (p_rec.renewal_duration = hr_api.g_number) then

461: If (p_rec.initial_compl_duration_units = hr_api.g_varchar2) then
462: p_rec.initial_compl_duration_units :=
463: ota_crt_shd.g_old_rec.initial_compl_duration_units;
464: End If;
465: If (p_rec.renewal_duration = hr_api.g_number) then
466: p_rec.renewal_duration :=
467: ota_crt_shd.g_old_rec.renewal_duration;
468: End If;
469: If (p_rec.renewal_duration_units = hr_api.g_varchar2) then

Line 469: If (p_rec.renewal_duration_units = hr_api.g_varchar2) then

465: If (p_rec.renewal_duration = hr_api.g_number) then
466: p_rec.renewal_duration :=
467: ota_crt_shd.g_old_rec.renewal_duration;
468: End If;
469: If (p_rec.renewal_duration_units = hr_api.g_varchar2) then
470: p_rec.renewal_duration_units :=
471: ota_crt_shd.g_old_rec.renewal_duration_units;
472: End If;
473: If (p_rec.notify_days_before_expire = hr_api.g_number) then

Line 473: If (p_rec.notify_days_before_expire = hr_api.g_number) then

469: If (p_rec.renewal_duration_units = hr_api.g_varchar2) then
470: p_rec.renewal_duration_units :=
471: ota_crt_shd.g_old_rec.renewal_duration_units;
472: End If;
473: If (p_rec.notify_days_before_expire = hr_api.g_number) then
474: p_rec.notify_days_before_expire :=
475: ota_crt_shd.g_old_rec.notify_days_before_expire;
476: End If;
477: If (p_rec.start_date_active = hr_api.g_date) then

Line 477: If (p_rec.start_date_active = hr_api.g_date) then

473: If (p_rec.notify_days_before_expire = hr_api.g_number) then
474: p_rec.notify_days_before_expire :=
475: ota_crt_shd.g_old_rec.notify_days_before_expire;
476: End If;
477: If (p_rec.start_date_active = hr_api.g_date) then
478: p_rec.start_date_active :=
479: ota_crt_shd.g_old_rec.start_date_active;
480: End If;
481: If (p_rec.end_date_active = hr_api.g_date) then

Line 481: If (p_rec.end_date_active = hr_api.g_date) then

477: If (p_rec.start_date_active = hr_api.g_date) then
478: p_rec.start_date_active :=
479: ota_crt_shd.g_old_rec.start_date_active;
480: End If;
481: If (p_rec.end_date_active = hr_api.g_date) then
482: p_rec.end_date_active :=
483: ota_crt_shd.g_old_rec.end_date_active;
484: End If;
485: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 485: If (p_rec.attribute_category = hr_api.g_varchar2) then

481: If (p_rec.end_date_active = hr_api.g_date) then
482: p_rec.end_date_active :=
483: ota_crt_shd.g_old_rec.end_date_active;
484: End If;
485: If (p_rec.attribute_category = hr_api.g_varchar2) then
486: p_rec.attribute_category :=
487: ota_crt_shd.g_old_rec.attribute_category;
488: End If;
489: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 489: If (p_rec.attribute1 = hr_api.g_varchar2) then

485: If (p_rec.attribute_category = hr_api.g_varchar2) then
486: p_rec.attribute_category :=
487: ota_crt_shd.g_old_rec.attribute_category;
488: End If;
489: If (p_rec.attribute1 = hr_api.g_varchar2) then
490: p_rec.attribute1 :=
491: ota_crt_shd.g_old_rec.attribute1;
492: End If;
493: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 493: If (p_rec.attribute2 = hr_api.g_varchar2) then

489: If (p_rec.attribute1 = hr_api.g_varchar2) then
490: p_rec.attribute1 :=
491: ota_crt_shd.g_old_rec.attribute1;
492: End If;
493: If (p_rec.attribute2 = hr_api.g_varchar2) then
494: p_rec.attribute2 :=
495: ota_crt_shd.g_old_rec.attribute2;
496: End If;
497: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 497: If (p_rec.attribute3 = hr_api.g_varchar2) then

493: If (p_rec.attribute2 = hr_api.g_varchar2) then
494: p_rec.attribute2 :=
495: ota_crt_shd.g_old_rec.attribute2;
496: End If;
497: If (p_rec.attribute3 = hr_api.g_varchar2) then
498: p_rec.attribute3 :=
499: ota_crt_shd.g_old_rec.attribute3;
500: End If;
501: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 501: If (p_rec.attribute4 = hr_api.g_varchar2) then

497: If (p_rec.attribute3 = hr_api.g_varchar2) then
498: p_rec.attribute3 :=
499: ota_crt_shd.g_old_rec.attribute3;
500: End If;
501: If (p_rec.attribute4 = hr_api.g_varchar2) then
502: p_rec.attribute4 :=
503: ota_crt_shd.g_old_rec.attribute4;
504: End If;
505: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 505: If (p_rec.attribute5 = hr_api.g_varchar2) then

501: If (p_rec.attribute4 = hr_api.g_varchar2) then
502: p_rec.attribute4 :=
503: ota_crt_shd.g_old_rec.attribute4;
504: End If;
505: If (p_rec.attribute5 = hr_api.g_varchar2) then
506: p_rec.attribute5 :=
507: ota_crt_shd.g_old_rec.attribute5;
508: End If;
509: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 509: If (p_rec.attribute6 = hr_api.g_varchar2) then

505: If (p_rec.attribute5 = hr_api.g_varchar2) then
506: p_rec.attribute5 :=
507: ota_crt_shd.g_old_rec.attribute5;
508: End If;
509: If (p_rec.attribute6 = hr_api.g_varchar2) then
510: p_rec.attribute6 :=
511: ota_crt_shd.g_old_rec.attribute6;
512: End If;
513: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 513: If (p_rec.attribute7 = hr_api.g_varchar2) then

509: If (p_rec.attribute6 = hr_api.g_varchar2) then
510: p_rec.attribute6 :=
511: ota_crt_shd.g_old_rec.attribute6;
512: End If;
513: If (p_rec.attribute7 = hr_api.g_varchar2) then
514: p_rec.attribute7 :=
515: ota_crt_shd.g_old_rec.attribute7;
516: End If;
517: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 517: If (p_rec.attribute8 = hr_api.g_varchar2) then

513: If (p_rec.attribute7 = hr_api.g_varchar2) then
514: p_rec.attribute7 :=
515: ota_crt_shd.g_old_rec.attribute7;
516: End If;
517: If (p_rec.attribute8 = hr_api.g_varchar2) then
518: p_rec.attribute8 :=
519: ota_crt_shd.g_old_rec.attribute8;
520: End If;
521: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 521: If (p_rec.attribute9 = hr_api.g_varchar2) then

517: If (p_rec.attribute8 = hr_api.g_varchar2) then
518: p_rec.attribute8 :=
519: ota_crt_shd.g_old_rec.attribute8;
520: End If;
521: If (p_rec.attribute9 = hr_api.g_varchar2) then
522: p_rec.attribute9 :=
523: ota_crt_shd.g_old_rec.attribute9;
524: End If;
525: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 525: If (p_rec.attribute10 = hr_api.g_varchar2) then

521: If (p_rec.attribute9 = hr_api.g_varchar2) then
522: p_rec.attribute9 :=
523: ota_crt_shd.g_old_rec.attribute9;
524: End If;
525: If (p_rec.attribute10 = hr_api.g_varchar2) then
526: p_rec.attribute10 :=
527: ota_crt_shd.g_old_rec.attribute10;
528: End If;
529: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 529: If (p_rec.attribute11 = hr_api.g_varchar2) then

525: If (p_rec.attribute10 = hr_api.g_varchar2) then
526: p_rec.attribute10 :=
527: ota_crt_shd.g_old_rec.attribute10;
528: End If;
529: If (p_rec.attribute11 = hr_api.g_varchar2) then
530: p_rec.attribute11 :=
531: ota_crt_shd.g_old_rec.attribute11;
532: End If;
533: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 533: If (p_rec.attribute12 = hr_api.g_varchar2) then

529: If (p_rec.attribute11 = hr_api.g_varchar2) then
530: p_rec.attribute11 :=
531: ota_crt_shd.g_old_rec.attribute11;
532: End If;
533: If (p_rec.attribute12 = hr_api.g_varchar2) then
534: p_rec.attribute12 :=
535: ota_crt_shd.g_old_rec.attribute12;
536: End If;
537: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 537: If (p_rec.attribute13 = hr_api.g_varchar2) then

533: If (p_rec.attribute12 = hr_api.g_varchar2) then
534: p_rec.attribute12 :=
535: ota_crt_shd.g_old_rec.attribute12;
536: End If;
537: If (p_rec.attribute13 = hr_api.g_varchar2) then
538: p_rec.attribute13 :=
539: ota_crt_shd.g_old_rec.attribute13;
540: End If;
541: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 541: If (p_rec.attribute14 = hr_api.g_varchar2) then

537: If (p_rec.attribute13 = hr_api.g_varchar2) then
538: p_rec.attribute13 :=
539: ota_crt_shd.g_old_rec.attribute13;
540: End If;
541: If (p_rec.attribute14 = hr_api.g_varchar2) then
542: p_rec.attribute14 :=
543: ota_crt_shd.g_old_rec.attribute14;
544: End If;
545: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 545: If (p_rec.attribute15 = hr_api.g_varchar2) then

541: If (p_rec.attribute14 = hr_api.g_varchar2) then
542: p_rec.attribute14 :=
543: ota_crt_shd.g_old_rec.attribute14;
544: End If;
545: If (p_rec.attribute15 = hr_api.g_varchar2) then
546: p_rec.attribute15 :=
547: ota_crt_shd.g_old_rec.attribute15;
548: End If;
549: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 549: If (p_rec.attribute16 = hr_api.g_varchar2) then

545: If (p_rec.attribute15 = hr_api.g_varchar2) then
546: p_rec.attribute15 :=
547: ota_crt_shd.g_old_rec.attribute15;
548: End If;
549: If (p_rec.attribute16 = hr_api.g_varchar2) then
550: p_rec.attribute16 :=
551: ota_crt_shd.g_old_rec.attribute16;
552: End If;
553: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 553: If (p_rec.attribute17 = hr_api.g_varchar2) then

549: If (p_rec.attribute16 = hr_api.g_varchar2) then
550: p_rec.attribute16 :=
551: ota_crt_shd.g_old_rec.attribute16;
552: End If;
553: If (p_rec.attribute17 = hr_api.g_varchar2) then
554: p_rec.attribute17 :=
555: ota_crt_shd.g_old_rec.attribute17;
556: End If;
557: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 557: If (p_rec.attribute18 = hr_api.g_varchar2) then

553: If (p_rec.attribute17 = hr_api.g_varchar2) then
554: p_rec.attribute17 :=
555: ota_crt_shd.g_old_rec.attribute17;
556: End If;
557: If (p_rec.attribute18 = hr_api.g_varchar2) then
558: p_rec.attribute18 :=
559: ota_crt_shd.g_old_rec.attribute18;
560: End If;
561: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 561: If (p_rec.attribute19 = hr_api.g_varchar2) then

557: If (p_rec.attribute18 = hr_api.g_varchar2) then
558: p_rec.attribute18 :=
559: ota_crt_shd.g_old_rec.attribute18;
560: End If;
561: If (p_rec.attribute19 = hr_api.g_varchar2) then
562: p_rec.attribute19 :=
563: ota_crt_shd.g_old_rec.attribute19;
564: End If;
565: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 565: If (p_rec.attribute20 = hr_api.g_varchar2) then

561: If (p_rec.attribute19 = hr_api.g_varchar2) then
562: p_rec.attribute19 :=
563: ota_crt_shd.g_old_rec.attribute19;
564: End If;
565: If (p_rec.attribute20 = hr_api.g_varchar2) then
566: p_rec.attribute20 :=
567: ota_crt_shd.g_old_rec.attribute20;
568: End If;
569: If (p_rec.VALIDITY_DURATION = hr_api.g_number) then

Line 569: If (p_rec.VALIDITY_DURATION = hr_api.g_number) then

565: If (p_rec.attribute20 = hr_api.g_varchar2) then
566: p_rec.attribute20 :=
567: ota_crt_shd.g_old_rec.attribute20;
568: End If;
569: If (p_rec.VALIDITY_DURATION = hr_api.g_number) then
570: p_rec.VALIDITY_DURATION :=
571: ota_crt_shd.g_old_rec.VALIDITY_DURATION;
572: End If;
573: If (p_rec.VALIDITY_DURATION_UNITS = hr_api.g_varchar2) then

Line 573: If (p_rec.VALIDITY_DURATION_UNITS = hr_api.g_varchar2) then

569: If (p_rec.VALIDITY_DURATION = hr_api.g_number) then
570: p_rec.VALIDITY_DURATION :=
571: ota_crt_shd.g_old_rec.VALIDITY_DURATION;
572: End If;
573: If (p_rec.VALIDITY_DURATION_UNITS = hr_api.g_varchar2) then
574: p_rec.VALIDITY_DURATION_UNITS :=
575: ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS;
576: End If;
577: If (p_rec.RENEWABLE_FLAG = hr_api.g_varchar2) then

Line 577: If (p_rec.RENEWABLE_FLAG = hr_api.g_varchar2) then

573: If (p_rec.VALIDITY_DURATION_UNITS = hr_api.g_varchar2) then
574: p_rec.VALIDITY_DURATION_UNITS :=
575: ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS;
576: End If;
577: If (p_rec.RENEWABLE_FLAG = hr_api.g_varchar2) then
578: p_rec.RENEWABLE_FLAG :=
579: ota_crt_shd.g_old_rec.RENEWABLE_FLAG;
580: End If;
581: If (p_rec.VALIDITY_START_TYPE = hr_api.g_varchar2) then

Line 581: If (p_rec.VALIDITY_START_TYPE = hr_api.g_varchar2) then

577: If (p_rec.RENEWABLE_FLAG = hr_api.g_varchar2) then
578: p_rec.RENEWABLE_FLAG :=
579: ota_crt_shd.g_old_rec.RENEWABLE_FLAG;
580: End If;
581: If (p_rec.VALIDITY_START_TYPE = hr_api.g_varchar2) then
582: p_rec.VALIDITY_START_TYPE :=
583: ota_crt_shd.g_old_rec.VALIDITY_START_TYPE;
584: End If;
585: If (p_rec.COMPETENCY_UPDATE_LEVEL = hr_api.g_varchar2) then

Line 585: If (p_rec.COMPETENCY_UPDATE_LEVEL = hr_api.g_varchar2) then

581: If (p_rec.VALIDITY_START_TYPE = hr_api.g_varchar2) then
582: p_rec.VALIDITY_START_TYPE :=
583: ota_crt_shd.g_old_rec.VALIDITY_START_TYPE;
584: End If;
585: If (p_rec.COMPETENCY_UPDATE_LEVEL = hr_api.g_varchar2) then
586: p_rec.COMPETENCY_UPDATE_LEVEL :=
587: ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL;
588: End If;
589:

Line 654: ,p_business_group_id in number default hr_api.g_number

650: Procedure upd
651: (p_effective_date in date
652: ,p_certification_id in number
653: ,p_object_version_number in out nocopy number
654: ,p_business_group_id in number default hr_api.g_number
655: ,p_public_flag in varchar2 default hr_api.g_varchar2
656: ,p_initial_completion_date in date default hr_api.g_date
657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2

Line 655: ,p_public_flag in varchar2 default hr_api.g_varchar2

651: (p_effective_date in date
652: ,p_certification_id in number
653: ,p_object_version_number in out nocopy number
654: ,p_business_group_id in number default hr_api.g_number
655: ,p_public_flag in varchar2 default hr_api.g_varchar2
656: ,p_initial_completion_date in date default hr_api.g_date
657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number

Line 656: ,p_initial_completion_date in date default hr_api.g_date

652: ,p_certification_id in number
653: ,p_object_version_number in out nocopy number
654: ,p_business_group_id in number default hr_api.g_number
655: ,p_public_flag in varchar2 default hr_api.g_varchar2
656: ,p_initial_completion_date in date default hr_api.g_date
657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2

Line 657: ,p_initial_completion_duration in number default hr_api.g_number

653: ,p_object_version_number in out nocopy number
654: ,p_business_group_id in number default hr_api.g_number
655: ,p_public_flag in varchar2 default hr_api.g_varchar2
656: ,p_initial_completion_date in date default hr_api.g_date
657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number

Line 658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2

654: ,p_business_group_id in number default hr_api.g_number
655: ,p_public_flag in varchar2 default hr_api.g_varchar2
656: ,p_initial_completion_date in date default hr_api.g_date
657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date

Line 659: ,p_renewal_duration in number default hr_api.g_number

655: ,p_public_flag in varchar2 default hr_api.g_varchar2
656: ,p_initial_completion_date in date default hr_api.g_date
657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date

Line 660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2

656: ,p_initial_completion_date in date default hr_api.g_date
657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 661: ,p_notify_days_before_expire in number default hr_api.g_number

657: ,p_initial_completion_duration in number default hr_api.g_number
658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 662: ,p_start_date_active in date default hr_api.g_date

658: ,p_initial_compl_duration_units in varchar2 default hr_api.g_varchar2
659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 663: ,p_end_date_active in date default hr_api.g_date

659: ,p_renewal_duration in number default hr_api.g_number
660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 664: ,p_attribute_category in varchar2 default hr_api.g_varchar2

660: ,p_renewal_duration_units in varchar2 default hr_api.g_varchar2
661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 665: ,p_attribute1 in varchar2 default hr_api.g_varchar2

661: ,p_notify_days_before_expire in number default hr_api.g_number
662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 666: ,p_attribute2 in varchar2 default hr_api.g_varchar2

662: ,p_start_date_active in date default hr_api.g_date
663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 667: ,p_attribute3 in varchar2 default hr_api.g_varchar2

663: ,p_end_date_active in date default hr_api.g_date
664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 668: ,p_attribute4 in varchar2 default hr_api.g_varchar2

664: ,p_attribute_category in varchar2 default hr_api.g_varchar2
665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 669: ,p_attribute5 in varchar2 default hr_api.g_varchar2

665: ,p_attribute1 in varchar2 default hr_api.g_varchar2
666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 670: ,p_attribute6 in varchar2 default hr_api.g_varchar2

666: ,p_attribute2 in varchar2 default hr_api.g_varchar2
667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 671: ,p_attribute7 in varchar2 default hr_api.g_varchar2

667: ,p_attribute3 in varchar2 default hr_api.g_varchar2
668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 672: ,p_attribute8 in varchar2 default hr_api.g_varchar2

668: ,p_attribute4 in varchar2 default hr_api.g_varchar2
669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 673: ,p_attribute9 in varchar2 default hr_api.g_varchar2

669: ,p_attribute5 in varchar2 default hr_api.g_varchar2
670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 674: ,p_attribute10 in varchar2 default hr_api.g_varchar2

670: ,p_attribute6 in varchar2 default hr_api.g_varchar2
671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 675: ,p_attribute11 in varchar2 default hr_api.g_varchar2

671: ,p_attribute7 in varchar2 default hr_api.g_varchar2
672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 676: ,p_attribute12 in varchar2 default hr_api.g_varchar2

672: ,p_attribute8 in varchar2 default hr_api.g_varchar2
673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 677: ,p_attribute13 in varchar2 default hr_api.g_varchar2

673: ,p_attribute9 in varchar2 default hr_api.g_varchar2
674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 678: ,p_attribute14 in varchar2 default hr_api.g_varchar2

674: ,p_attribute10 in varchar2 default hr_api.g_varchar2
675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 679: ,p_attribute15 in varchar2 default hr_api.g_varchar2

675: ,p_attribute11 in varchar2 default hr_api.g_varchar2
676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 680: ,p_attribute16 in varchar2 default hr_api.g_varchar2

676: ,p_attribute12 in varchar2 default hr_api.g_varchar2
677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 681: ,p_attribute17 in varchar2 default hr_api.g_varchar2

677: ,p_attribute13 in varchar2 default hr_api.g_varchar2
678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number

Line 682: ,p_attribute18 in varchar2 default hr_api.g_varchar2

678: ,p_attribute14 in varchar2 default hr_api.g_varchar2
679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2

Line 683: ,p_attribute19 in varchar2 default hr_api.g_varchar2

679: ,p_attribute15 in varchar2 default hr_api.g_varchar2
680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2

Line 684: ,p_attribute20 in varchar2 default hr_api.g_varchar2

680: ,p_attribute16 in varchar2 default hr_api.g_varchar2
681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2

Line 685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number

681: ,p_attribute17 in varchar2 default hr_api.g_varchar2
682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
689: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2

Line 686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2

682: ,p_attribute18 in varchar2 default hr_api.g_varchar2
683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
689: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
690: ) is

Line 687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2

683: ,p_attribute19 in varchar2 default hr_api.g_varchar2
684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
689: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
690: ) is
691: --

Line 688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2

684: ,p_attribute20 in varchar2 default hr_api.g_varchar2
685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
689: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
690: ) is
691: --
692: l_rec ota_crt_shd.g_rec_type;

Line 689: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2

685: ,p_VALIDITY_DURATION in NUMBER default hr_api.g_number
686: ,p_VALIDITY_DURATION_UNITS in VARCHAR2 default hr_api.g_varchar2
687: ,p_RENEWABLE_FLAG in VARCHAR2 default hr_api.g_varchar2
688: ,p_VALIDITY_START_TYPE in VARCHAR2 default hr_api.g_varchar2
689: ,p_COMPETENCY_UPDATE_LEVEL in VARCHAR2 default hr_api.g_varchar2
690: ) is
691: --
692: l_rec ota_crt_shd.g_rec_type;
693: l_proc varchar2(72) := g_package||'upd';