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

Line 138: When hr_api.check_integrity_violated Then

134: --
135: hr_utility.set_location(' Leaving:'||l_proc, 10);
136: --
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: per_cpn_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then

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

137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: per_cpn_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: per_cpn_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 142: When hr_api.parent_integrity_violated Then

138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: per_cpn_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: per_cpn_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then

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

141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: per_cpn_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_cpn_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 146: When hr_api.unique_integrity_violated Then

142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: per_cpn_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_cpn_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then

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

145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_cpn_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: Raise;
152: End update_dml;
153: --

Line 383: when hr_api.cannot_find_prog_unit then

379: ,p_information20_o => per_cpn_shd.g_old_rec.information20
380: );
381:
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: ( p_module_name => 'PER_COMPETENCES'
386: ,p_hook_type => 'AU'
387: );

Line 384: hr_api.cannot_find_prog_unit_error

380: );
381:
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: ( p_module_name => 'PER_COMPETENCES'
386: ,p_hook_type => 'AU'
387: );
388: end;

Line 451: If (p_rec.name = hr_api.g_varchar2) then

447: -- p_rec plsql record structure
448: -- to see if a system default is being used. If a system default
449: -- is being used then we must set to the 'current' argument value.
450: --
451: If (p_rec.name = hr_api.g_varchar2) then
452: p_rec.name :=
453: per_cpn_shd.g_old_rec.name;
454: End If;
455: If (p_rec.business_group_id = hr_api.g_number) then

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

451: If (p_rec.name = hr_api.g_varchar2) then
452: p_rec.name :=
453: per_cpn_shd.g_old_rec.name;
454: End If;
455: If (p_rec.business_group_id = hr_api.g_number) then
456: p_rec.business_group_id :=
457: per_cpn_shd.g_old_rec.business_group_id;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then

Line 459: If (p_rec.description = hr_api.g_varchar2) then

455: If (p_rec.business_group_id = hr_api.g_number) then
456: p_rec.business_group_id :=
457: per_cpn_shd.g_old_rec.business_group_id;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: per_cpn_shd.g_old_rec.description;
462: End If;
463: If (p_rec.date_from = hr_api.g_date) then

Line 463: If (p_rec.date_from = hr_api.g_date) then

459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: per_cpn_shd.g_old_rec.description;
462: End If;
463: If (p_rec.date_from = hr_api.g_date) then
464: p_rec.date_from :=
465: per_cpn_shd.g_old_rec.date_from;
466: End If;
467: If (p_rec.date_to = hr_api.g_date) then

Line 467: If (p_rec.date_to = hr_api.g_date) then

463: If (p_rec.date_from = hr_api.g_date) then
464: p_rec.date_from :=
465: per_cpn_shd.g_old_rec.date_from;
466: End If;
467: If (p_rec.date_to = hr_api.g_date) then
468: p_rec.date_to :=
469: per_cpn_shd.g_old_rec.date_to;
470: End If;
471: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then

Line 471: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then

467: If (p_rec.date_to = hr_api.g_date) then
468: p_rec.date_to :=
469: per_cpn_shd.g_old_rec.date_to;
470: End If;
471: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
472: p_rec.behavioural_indicator :=
473: per_cpn_shd.g_old_rec.behavioural_indicator;
474: End If;
475: If (p_rec.certification_required = hr_api.g_varchar2) then

Line 475: If (p_rec.certification_required = hr_api.g_varchar2) then

471: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
472: p_rec.behavioural_indicator :=
473: per_cpn_shd.g_old_rec.behavioural_indicator;
474: End If;
475: If (p_rec.certification_required = hr_api.g_varchar2) then
476: p_rec.certification_required :=
477: per_cpn_shd.g_old_rec.certification_required;
478: End If;
479: If (p_rec.evaluation_method = hr_api.g_varchar2) then

Line 479: If (p_rec.evaluation_method = hr_api.g_varchar2) then

475: If (p_rec.certification_required = hr_api.g_varchar2) then
476: p_rec.certification_required :=
477: per_cpn_shd.g_old_rec.certification_required;
478: End If;
479: If (p_rec.evaluation_method = hr_api.g_varchar2) then
480: p_rec.evaluation_method :=
481: per_cpn_shd.g_old_rec.evaluation_method;
482: End If;
483: If (p_rec.renewal_period_frequency = hr_api.g_number) then

Line 483: If (p_rec.renewal_period_frequency = hr_api.g_number) then

479: If (p_rec.evaluation_method = hr_api.g_varchar2) then
480: p_rec.evaluation_method :=
481: per_cpn_shd.g_old_rec.evaluation_method;
482: End If;
483: If (p_rec.renewal_period_frequency = hr_api.g_number) then
484: p_rec.renewal_period_frequency :=
485: per_cpn_shd.g_old_rec.renewal_period_frequency;
486: End If;
487: If (p_rec.renewal_period_units = hr_api.g_varchar2) then

Line 487: If (p_rec.renewal_period_units = hr_api.g_varchar2) then

483: If (p_rec.renewal_period_frequency = hr_api.g_number) then
484: p_rec.renewal_period_frequency :=
485: per_cpn_shd.g_old_rec.renewal_period_frequency;
486: End If;
487: If (p_rec.renewal_period_units = hr_api.g_varchar2) then
488: p_rec.renewal_period_units :=
489: per_cpn_shd.g_old_rec.renewal_period_units;
490: End If;
491: If (p_rec.min_level = hr_api.g_number) then

Line 491: If (p_rec.min_level = hr_api.g_number) then

487: If (p_rec.renewal_period_units = hr_api.g_varchar2) then
488: p_rec.renewal_period_units :=
489: per_cpn_shd.g_old_rec.renewal_period_units;
490: End If;
491: If (p_rec.min_level = hr_api.g_number) then
492: p_rec.min_level :=
493: per_cpn_shd.g_old_rec.min_level;
494: End If;
495: If (p_rec.max_level = hr_api.g_number) then

Line 495: If (p_rec.max_level = hr_api.g_number) then

491: If (p_rec.min_level = hr_api.g_number) then
492: p_rec.min_level :=
493: per_cpn_shd.g_old_rec.min_level;
494: End If;
495: If (p_rec.max_level = hr_api.g_number) then
496: p_rec.max_level :=
497: per_cpn_shd.g_old_rec.max_level;
498: End If;
499: If (p_rec.rating_scale_id = hr_api.g_number) then

Line 499: If (p_rec.rating_scale_id = hr_api.g_number) then

495: If (p_rec.max_level = hr_api.g_number) then
496: p_rec.max_level :=
497: per_cpn_shd.g_old_rec.max_level;
498: End If;
499: If (p_rec.rating_scale_id = hr_api.g_number) then
500: p_rec.rating_scale_id :=
501: per_cpn_shd.g_old_rec.rating_scale_id;
502: End If;
503: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

499: If (p_rec.rating_scale_id = hr_api.g_number) then
500: p_rec.rating_scale_id :=
501: per_cpn_shd.g_old_rec.rating_scale_id;
502: End If;
503: If (p_rec.attribute_category = hr_api.g_varchar2) then
504: p_rec.attribute_category :=
505: per_cpn_shd.g_old_rec.attribute_category;
506: End If;
507: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

503: If (p_rec.attribute_category = hr_api.g_varchar2) then
504: p_rec.attribute_category :=
505: per_cpn_shd.g_old_rec.attribute_category;
506: End If;
507: If (p_rec.attribute1 = hr_api.g_varchar2) then
508: p_rec.attribute1 :=
509: per_cpn_shd.g_old_rec.attribute1;
510: End If;
511: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

507: If (p_rec.attribute1 = hr_api.g_varchar2) then
508: p_rec.attribute1 :=
509: per_cpn_shd.g_old_rec.attribute1;
510: End If;
511: If (p_rec.attribute2 = hr_api.g_varchar2) then
512: p_rec.attribute2 :=
513: per_cpn_shd.g_old_rec.attribute2;
514: End If;
515: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

511: If (p_rec.attribute2 = hr_api.g_varchar2) then
512: p_rec.attribute2 :=
513: per_cpn_shd.g_old_rec.attribute2;
514: End If;
515: If (p_rec.attribute3 = hr_api.g_varchar2) then
516: p_rec.attribute3 :=
517: per_cpn_shd.g_old_rec.attribute3;
518: End If;
519: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

515: If (p_rec.attribute3 = hr_api.g_varchar2) then
516: p_rec.attribute3 :=
517: per_cpn_shd.g_old_rec.attribute3;
518: End If;
519: If (p_rec.attribute4 = hr_api.g_varchar2) then
520: p_rec.attribute4 :=
521: per_cpn_shd.g_old_rec.attribute4;
522: End If;
523: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

519: If (p_rec.attribute4 = hr_api.g_varchar2) then
520: p_rec.attribute4 :=
521: per_cpn_shd.g_old_rec.attribute4;
522: End If;
523: If (p_rec.attribute5 = hr_api.g_varchar2) then
524: p_rec.attribute5 :=
525: per_cpn_shd.g_old_rec.attribute5;
526: End If;
527: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

523: If (p_rec.attribute5 = hr_api.g_varchar2) then
524: p_rec.attribute5 :=
525: per_cpn_shd.g_old_rec.attribute5;
526: End If;
527: If (p_rec.attribute6 = hr_api.g_varchar2) then
528: p_rec.attribute6 :=
529: per_cpn_shd.g_old_rec.attribute6;
530: End If;
531: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

527: If (p_rec.attribute6 = hr_api.g_varchar2) then
528: p_rec.attribute6 :=
529: per_cpn_shd.g_old_rec.attribute6;
530: End If;
531: If (p_rec.attribute7 = hr_api.g_varchar2) then
532: p_rec.attribute7 :=
533: per_cpn_shd.g_old_rec.attribute7;
534: End If;
535: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

531: If (p_rec.attribute7 = hr_api.g_varchar2) then
532: p_rec.attribute7 :=
533: per_cpn_shd.g_old_rec.attribute7;
534: End If;
535: If (p_rec.attribute8 = hr_api.g_varchar2) then
536: p_rec.attribute8 :=
537: per_cpn_shd.g_old_rec.attribute8;
538: End If;
539: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

535: If (p_rec.attribute8 = hr_api.g_varchar2) then
536: p_rec.attribute8 :=
537: per_cpn_shd.g_old_rec.attribute8;
538: End If;
539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=
541: per_cpn_shd.g_old_rec.attribute9;
542: End If;
543: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=
541: per_cpn_shd.g_old_rec.attribute9;
542: End If;
543: If (p_rec.attribute10 = hr_api.g_varchar2) then
544: p_rec.attribute10 :=
545: per_cpn_shd.g_old_rec.attribute10;
546: End If;
547: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

543: If (p_rec.attribute10 = hr_api.g_varchar2) then
544: p_rec.attribute10 :=
545: per_cpn_shd.g_old_rec.attribute10;
546: End If;
547: If (p_rec.attribute11 = hr_api.g_varchar2) then
548: p_rec.attribute11 :=
549: per_cpn_shd.g_old_rec.attribute11;
550: eND iF;
551: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

547: If (p_rec.attribute11 = hr_api.g_varchar2) then
548: p_rec.attribute11 :=
549: per_cpn_shd.g_old_rec.attribute11;
550: eND iF;
551: If (p_rec.attribute12 = hr_api.g_varchar2) then
552: p_rec.attribute12 :=
553: per_cpn_shd.g_old_rec.attribute12;
554: End If;
555: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

551: If (p_rec.attribute12 = hr_api.g_varchar2) then
552: p_rec.attribute12 :=
553: per_cpn_shd.g_old_rec.attribute12;
554: End If;
555: If (p_rec.attribute13 = hr_api.g_varchar2) then
556: p_rec.attribute13 :=
557: per_cpn_shd.g_old_rec.attribute13;
558: End If;
559: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

555: If (p_rec.attribute13 = hr_api.g_varchar2) then
556: p_rec.attribute13 :=
557: per_cpn_shd.g_old_rec.attribute13;
558: End If;
559: If (p_rec.attribute14 = hr_api.g_varchar2) then
560: p_rec.attribute14 :=
561: per_cpn_shd.g_old_rec.attribute14;
562: End If;
563: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

559: If (p_rec.attribute14 = hr_api.g_varchar2) then
560: p_rec.attribute14 :=
561: per_cpn_shd.g_old_rec.attribute14;
562: End If;
563: If (p_rec.attribute15 = hr_api.g_varchar2) then
564: p_rec.attribute15 :=
565: per_cpn_shd.g_old_rec.attribute15;
566: End If;
567: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

563: If (p_rec.attribute15 = hr_api.g_varchar2) then
564: p_rec.attribute15 :=
565: per_cpn_shd.g_old_rec.attribute15;
566: End If;
567: If (p_rec.attribute16 = hr_api.g_varchar2) then
568: p_rec.attribute16 :=
569: per_cpn_shd.g_old_rec.attribute16;
570: End If;
571: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

567: If (p_rec.attribute16 = hr_api.g_varchar2) then
568: p_rec.attribute16 :=
569: per_cpn_shd.g_old_rec.attribute16;
570: End If;
571: If (p_rec.attribute17 = hr_api.g_varchar2) then
572: p_rec.attribute17 :=
573: per_cpn_shd.g_old_rec.attribute17;
574: End If;
575: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

571: If (p_rec.attribute17 = hr_api.g_varchar2) then
572: p_rec.attribute17 :=
573: per_cpn_shd.g_old_rec.attribute17;
574: End If;
575: If (p_rec.attribute18 = hr_api.g_varchar2) then
576: p_rec.attribute18 :=
577: per_cpn_shd.g_old_rec.attribute18;
578: End If;
579: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

575: If (p_rec.attribute18 = hr_api.g_varchar2) then
576: p_rec.attribute18 :=
577: per_cpn_shd.g_old_rec.attribute18;
578: End If;
579: If (p_rec.attribute19 = hr_api.g_varchar2) then
580: p_rec.attribute19 :=
581: per_cpn_shd.g_old_rec.attribute19;
582: End If;
583: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

579: If (p_rec.attribute19 = hr_api.g_varchar2) then
580: p_rec.attribute19 :=
581: per_cpn_shd.g_old_rec.attribute19;
582: End If;
583: If (p_rec.attribute20 = hr_api.g_varchar2) then
584: p_rec.attribute20 :=
585: per_cpn_shd.g_old_rec.attribute20;
586: End If;
587: -- ngundura changes as per pa requirements

Line 588: If (p_rec.competence_alias = hr_api.g_varchar2) then

584: p_rec.attribute20 :=
585: per_cpn_shd.g_old_rec.attribute20;
586: End If;
587: -- ngundura changes as per pa requirements
588: If (p_rec.competence_alias = hr_api.g_varchar2) then
589: p_rec.competence_alias :=
590: per_cpn_shd.g_old_rec.competence_alias;
591: End If;
592: If (p_rec.competence_definition_id = hr_api.g_number) then

Line 592: If (p_rec.competence_definition_id = hr_api.g_number) then

588: If (p_rec.competence_alias = hr_api.g_varchar2) then
589: p_rec.competence_alias :=
590: per_cpn_shd.g_old_rec.competence_alias;
591: End If;
592: If (p_rec.competence_definition_id = hr_api.g_number) then
593: p_rec.competence_definition_id :=
594: per_cpn_shd.g_old_rec.competence_definition_id;
595: End If;
596: --

Line 599: If (p_rec.competence_cluster = hr_api.g_varchar2) then

595: End If;
596: --
597: -- BUG3356369
598: --
599: If (p_rec.competence_cluster = hr_api.g_varchar2) then
600: p_rec.competence_cluster :=
601: per_cpn_shd.g_old_rec.competence_cluster;
602: End If;
603: If (p_rec.unit_standard_id = hr_api.g_varchar2) then

Line 603: If (p_rec.unit_standard_id = hr_api.g_varchar2) then

599: If (p_rec.competence_cluster = hr_api.g_varchar2) then
600: p_rec.competence_cluster :=
601: per_cpn_shd.g_old_rec.competence_cluster;
602: End If;
603: If (p_rec.unit_standard_id = hr_api.g_varchar2) then
604: p_rec.unit_standard_id :=
605: per_cpn_shd.g_old_rec.unit_standard_id;
606: End If;
607: If (p_rec.credit_type = hr_api.g_varchar2) then

Line 607: If (p_rec.credit_type = hr_api.g_varchar2) then

603: If (p_rec.unit_standard_id = hr_api.g_varchar2) then
604: p_rec.unit_standard_id :=
605: per_cpn_shd.g_old_rec.unit_standard_id;
606: End If;
607: If (p_rec.credit_type = hr_api.g_varchar2) then
608: p_rec.credit_type :=
609: per_cpn_shd.g_old_rec.credit_type;
610: End If;
611: If (p_rec.credits = hr_api.g_number) then

Line 611: If (p_rec.credits = hr_api.g_number) then

607: If (p_rec.credit_type = hr_api.g_varchar2) then
608: p_rec.credit_type :=
609: per_cpn_shd.g_old_rec.credit_type;
610: End If;
611: If (p_rec.credits = hr_api.g_number) then
612: p_rec.credits :=
613: per_cpn_shd.g_old_rec.credits;
614: End If;
615: If (p_rec.level_type = hr_api.g_varchar2) then

Line 615: If (p_rec.level_type = hr_api.g_varchar2) then

611: If (p_rec.credits = hr_api.g_number) then
612: p_rec.credits :=
613: per_cpn_shd.g_old_rec.credits;
614: End If;
615: If (p_rec.level_type = hr_api.g_varchar2) then
616: p_rec.level_type :=
617: per_cpn_shd.g_old_rec.level_type;
618: End If;
619: If (p_rec.level_number = hr_api.g_number) then

Line 619: If (p_rec.level_number = hr_api.g_number) then

615: If (p_rec.level_type = hr_api.g_varchar2) then
616: p_rec.level_type :=
617: per_cpn_shd.g_old_rec.level_type;
618: End If;
619: If (p_rec.level_number = hr_api.g_number) then
620: p_rec.level_number :=
621: per_cpn_shd.g_old_rec.level_number;
622: End If;
623: If (p_rec.field = hr_api.g_varchar2) then

Line 623: If (p_rec.field = hr_api.g_varchar2) then

619: If (p_rec.level_number = hr_api.g_number) then
620: p_rec.level_number :=
621: per_cpn_shd.g_old_rec.level_number;
622: End If;
623: If (p_rec.field = hr_api.g_varchar2) then
624: p_rec.field :=
625: per_cpn_shd.g_old_rec.field ;
626: End If;
627: If (p_rec.sub_field = hr_api.g_varchar2) then

Line 627: If (p_rec.sub_field = hr_api.g_varchar2) then

623: If (p_rec.field = hr_api.g_varchar2) then
624: p_rec.field :=
625: per_cpn_shd.g_old_rec.field ;
626: End If;
627: If (p_rec.sub_field = hr_api.g_varchar2) then
628: p_rec.sub_field :=
629: per_cpn_shd.g_old_rec.sub_field;
630: End If;
631: If (p_rec.provider = hr_api.g_varchar2) then

Line 631: If (p_rec.provider = hr_api.g_varchar2) then

627: If (p_rec.sub_field = hr_api.g_varchar2) then
628: p_rec.sub_field :=
629: per_cpn_shd.g_old_rec.sub_field;
630: End If;
631: If (p_rec.provider = hr_api.g_varchar2) then
632: p_rec.provider :=
633: per_cpn_shd.g_old_rec.provider;
634: End If;
635: If (p_rec.qa_organization = hr_api.g_varchar2) then

Line 635: If (p_rec.qa_organization = hr_api.g_varchar2) then

631: If (p_rec.provider = hr_api.g_varchar2) then
632: p_rec.provider :=
633: per_cpn_shd.g_old_rec.provider;
634: End If;
635: If (p_rec.qa_organization = hr_api.g_varchar2) then
636: p_rec.qa_organization :=
637: per_cpn_shd.g_old_rec.qa_organization;
638: End If;
639: If (p_rec.information_category = hr_api.g_varchar2) then

Line 639: If (p_rec.information_category = hr_api.g_varchar2) then

635: If (p_rec.qa_organization = hr_api.g_varchar2) then
636: p_rec.qa_organization :=
637: per_cpn_shd.g_old_rec.qa_organization;
638: End If;
639: If (p_rec.information_category = hr_api.g_varchar2) then
640: p_rec.information_category :=
641: per_cpn_shd.g_old_rec.information_category;
642: End If;
643: If (p_rec.information1 = hr_api.g_varchar2) then

Line 643: If (p_rec.information1 = hr_api.g_varchar2) then

639: If (p_rec.information_category = hr_api.g_varchar2) then
640: p_rec.information_category :=
641: per_cpn_shd.g_old_rec.information_category;
642: End If;
643: If (p_rec.information1 = hr_api.g_varchar2) then
644: p_rec.information1 :=
645: per_cpn_shd.g_old_rec.information1;
646: End If;
647: If (p_rec.information2 = hr_api.g_varchar2) then

Line 647: If (p_rec.information2 = hr_api.g_varchar2) then

643: If (p_rec.information1 = hr_api.g_varchar2) then
644: p_rec.information1 :=
645: per_cpn_shd.g_old_rec.information1;
646: End If;
647: If (p_rec.information2 = hr_api.g_varchar2) then
648: p_rec.information2 :=
649: per_cpn_shd.g_old_rec.information2;
650: End If;
651: If (p_rec.information3 = hr_api.g_varchar2) then

Line 651: If (p_rec.information3 = hr_api.g_varchar2) then

647: If (p_rec.information2 = hr_api.g_varchar2) then
648: p_rec.information2 :=
649: per_cpn_shd.g_old_rec.information2;
650: End If;
651: If (p_rec.information3 = hr_api.g_varchar2) then
652: p_rec.information3 :=
653: per_cpn_shd.g_old_rec.information3;
654: End If;
655: If (p_rec.information4 = hr_api.g_varchar2) then

Line 655: If (p_rec.information4 = hr_api.g_varchar2) then

651: If (p_rec.information3 = hr_api.g_varchar2) then
652: p_rec.information3 :=
653: per_cpn_shd.g_old_rec.information3;
654: End If;
655: If (p_rec.information4 = hr_api.g_varchar2) then
656: p_rec.information4 :=
657: per_cpn_shd.g_old_rec.information4;
658: End If;
659: If (p_rec.information5 = hr_api.g_varchar2) then

Line 659: If (p_rec.information5 = hr_api.g_varchar2) then

655: If (p_rec.information4 = hr_api.g_varchar2) then
656: p_rec.information4 :=
657: per_cpn_shd.g_old_rec.information4;
658: End If;
659: If (p_rec.information5 = hr_api.g_varchar2) then
660: p_rec.information5 :=
661: per_cpn_shd.g_old_rec.information5;
662: End If;
663: If (p_rec.information6 = hr_api.g_varchar2) then

Line 663: If (p_rec.information6 = hr_api.g_varchar2) then

659: If (p_rec.information5 = hr_api.g_varchar2) then
660: p_rec.information5 :=
661: per_cpn_shd.g_old_rec.information5;
662: End If;
663: If (p_rec.information6 = hr_api.g_varchar2) then
664: p_rec.information6 :=
665: per_cpn_shd.g_old_rec.information6;
666: End If;
667: If (p_rec.information7 = hr_api.g_varchar2) then

Line 667: If (p_rec.information7 = hr_api.g_varchar2) then

663: If (p_rec.information6 = hr_api.g_varchar2) then
664: p_rec.information6 :=
665: per_cpn_shd.g_old_rec.information6;
666: End If;
667: If (p_rec.information7 = hr_api.g_varchar2) then
668: p_rec.information7 :=
669: per_cpn_shd.g_old_rec.information7;
670: End If;
671: If (p_rec.information8 = hr_api.g_varchar2) then

Line 671: If (p_rec.information8 = hr_api.g_varchar2) then

667: If (p_rec.information7 = hr_api.g_varchar2) then
668: p_rec.information7 :=
669: per_cpn_shd.g_old_rec.information7;
670: End If;
671: If (p_rec.information8 = hr_api.g_varchar2) then
672: p_rec.information8 :=
673: per_cpn_shd.g_old_rec.information8;
674: End If;
675: If (p_rec.information9 = hr_api.g_varchar2) then

Line 675: If (p_rec.information9 = hr_api.g_varchar2) then

671: If (p_rec.information8 = hr_api.g_varchar2) then
672: p_rec.information8 :=
673: per_cpn_shd.g_old_rec.information8;
674: End If;
675: If (p_rec.information9 = hr_api.g_varchar2) then
676: p_rec.information9 :=
677: per_cpn_shd.g_old_rec.information9;
678: End If;
679: If (p_rec.information10 = hr_api.g_varchar2) then

Line 679: If (p_rec.information10 = hr_api.g_varchar2) then

675: If (p_rec.information9 = hr_api.g_varchar2) then
676: p_rec.information9 :=
677: per_cpn_shd.g_old_rec.information9;
678: End If;
679: If (p_rec.information10 = hr_api.g_varchar2) then
680: p_rec.information10 :=
681: per_cpn_shd.g_old_rec.information10;
682: End If;
683: If (p_rec.information11 = hr_api.g_varchar2) then

Line 683: If (p_rec.information11 = hr_api.g_varchar2) then

679: If (p_rec.information10 = hr_api.g_varchar2) then
680: p_rec.information10 :=
681: per_cpn_shd.g_old_rec.information10;
682: End If;
683: If (p_rec.information11 = hr_api.g_varchar2) then
684: p_rec.information11 :=
685: per_cpn_shd.g_old_rec.information11;
686: End If;
687: If (p_rec.information12 = hr_api.g_varchar2) then

Line 687: If (p_rec.information12 = hr_api.g_varchar2) then

683: If (p_rec.information11 = hr_api.g_varchar2) then
684: p_rec.information11 :=
685: per_cpn_shd.g_old_rec.information11;
686: End If;
687: If (p_rec.information12 = hr_api.g_varchar2) then
688: p_rec.information12 :=
689: per_cpn_shd.g_old_rec.information12;
690: End If;
691: If (p_rec.information13 = hr_api.g_varchar2) then

Line 691: If (p_rec.information13 = hr_api.g_varchar2) then

687: If (p_rec.information12 = hr_api.g_varchar2) then
688: p_rec.information12 :=
689: per_cpn_shd.g_old_rec.information12;
690: End If;
691: If (p_rec.information13 = hr_api.g_varchar2) then
692: p_rec.information13 :=
693: per_cpn_shd.g_old_rec.information13;
694: End If;
695: If (p_rec.information14 = hr_api.g_varchar2) then

Line 695: If (p_rec.information14 = hr_api.g_varchar2) then

691: If (p_rec.information13 = hr_api.g_varchar2) then
692: p_rec.information13 :=
693: per_cpn_shd.g_old_rec.information13;
694: End If;
695: If (p_rec.information14 = hr_api.g_varchar2) then
696: p_rec.information14 :=
697: per_cpn_shd.g_old_rec.information14;
698: End If;
699: If (p_rec.information15 = hr_api.g_varchar2) then

Line 699: If (p_rec.information15 = hr_api.g_varchar2) then

695: If (p_rec.information14 = hr_api.g_varchar2) then
696: p_rec.information14 :=
697: per_cpn_shd.g_old_rec.information14;
698: End If;
699: If (p_rec.information15 = hr_api.g_varchar2) then
700: p_rec.information15 :=
701: per_cpn_shd.g_old_rec.information15;
702: End If;
703: If (p_rec.information16 = hr_api.g_varchar2) then

Line 703: If (p_rec.information16 = hr_api.g_varchar2) then

699: If (p_rec.information15 = hr_api.g_varchar2) then
700: p_rec.information15 :=
701: per_cpn_shd.g_old_rec.information15;
702: End If;
703: If (p_rec.information16 = hr_api.g_varchar2) then
704: p_rec.information16 :=
705: per_cpn_shd.g_old_rec.information16;
706: End If;
707: If (p_rec.information17 = hr_api.g_varchar2) then

Line 707: If (p_rec.information17 = hr_api.g_varchar2) then

703: If (p_rec.information16 = hr_api.g_varchar2) then
704: p_rec.information16 :=
705: per_cpn_shd.g_old_rec.information16;
706: End If;
707: If (p_rec.information17 = hr_api.g_varchar2) then
708: p_rec.information17 :=
709: per_cpn_shd.g_old_rec.information17;
710: End If;
711: If (p_rec.information18 = hr_api.g_varchar2) then

Line 711: If (p_rec.information18 = hr_api.g_varchar2) then

707: If (p_rec.information17 = hr_api.g_varchar2) then
708: p_rec.information17 :=
709: per_cpn_shd.g_old_rec.information17;
710: End If;
711: If (p_rec.information18 = hr_api.g_varchar2) then
712: p_rec.information18 :=
713: per_cpn_shd.g_old_rec.information18;
714: End If;
715: If (p_rec.information19 = hr_api.g_varchar2) then

Line 715: If (p_rec.information19 = hr_api.g_varchar2) then

711: If (p_rec.information18 = hr_api.g_varchar2) then
712: p_rec.information18 :=
713: per_cpn_shd.g_old_rec.information18;
714: End If;
715: If (p_rec.information19 = hr_api.g_varchar2) then
716: p_rec.information19 :=
717: per_cpn_shd.g_old_rec.information19;
718: End If;
719: If (p_rec.information20 = hr_api.g_varchar2) then

Line 719: If (p_rec.information20 = hr_api.g_varchar2) then

715: If (p_rec.information19 = hr_api.g_varchar2) then
716: p_rec.information19 :=
717: per_cpn_shd.g_old_rec.information19;
718: End If;
719: If (p_rec.information20 = hr_api.g_varchar2) then
720: p_rec.information20 :=
721: per_cpn_shd.g_old_rec.information20;
722: End If;
723: --

Line 784: Raise HR_Api.Validate_Enabled;

780: --
781: -- If we are validating then raise the Validate_Enabled exception
782: --
783: If p_validate then
784: Raise HR_Api.Validate_Enabled;
785: End If;
786: --
787: hr_utility.set_location(' Leaving:'||l_proc, 10);
788: Exception

Line 789: When HR_Api.Validate_Enabled Then

785: End If;
786: --
787: hr_utility.set_location(' Leaving:'||l_proc, 10);
788: Exception
789: When HR_Api.Validate_Enabled Then
790: --
791: -- As the Validate_Enabled exception has been raised
792: -- we must rollback to the savepoint
793: --

Line 803: p_name in varchar2 default hr_api.g_varchar2,

799: -- ----------------------------------------------------------------------------
800: Procedure upd
801: (
802: p_competence_id in number,
803: p_name in varchar2 default hr_api.g_varchar2,
804: p_object_version_number in out nocopy number,
805: p_description in varchar2 default hr_api.g_varchar2,
806: p_date_from in date default hr_api.g_date,
807: p_date_to in date default hr_api.g_date,

Line 805: p_description in varchar2 default hr_api.g_varchar2,

801: (
802: p_competence_id in number,
803: p_name in varchar2 default hr_api.g_varchar2,
804: p_object_version_number in out nocopy number,
805: p_description in varchar2 default hr_api.g_varchar2,
806: p_date_from in date default hr_api.g_date,
807: p_date_to in date default hr_api.g_date,
808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,

Line 806: p_date_from in date default hr_api.g_date,

802: p_competence_id in number,
803: p_name in varchar2 default hr_api.g_varchar2,
804: p_object_version_number in out nocopy number,
805: p_description in varchar2 default hr_api.g_varchar2,
806: p_date_from in date default hr_api.g_date,
807: p_date_to in date default hr_api.g_date,
808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,

Line 807: p_date_to in date default hr_api.g_date,

803: p_name in varchar2 default hr_api.g_varchar2,
804: p_object_version_number in out nocopy number,
805: p_description in varchar2 default hr_api.g_varchar2,
806: p_date_from in date default hr_api.g_date,
807: p_date_to in date default hr_api.g_date,
808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,

Line 808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,

804: p_object_version_number in out nocopy number,
805: p_description in varchar2 default hr_api.g_varchar2,
806: p_date_from in date default hr_api.g_date,
807: p_date_to in date default hr_api.g_date,
808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,

Line 809: p_certification_required in varchar2 default hr_api.g_varchar2,

805: p_description in varchar2 default hr_api.g_varchar2,
806: p_date_from in date default hr_api.g_date,
807: p_date_to in date default hr_api.g_date,
808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,

Line 810: p_evaluation_method in varchar2 default hr_api.g_varchar2,

806: p_date_from in date default hr_api.g_date,
807: p_date_to in date default hr_api.g_date,
808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,

Line 811: p_renewal_period_frequency in number default hr_api.g_number,

807: p_date_to in date default hr_api.g_date,
808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,

Line 812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,

808: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 813: p_min_level in number default hr_api.g_number,

809: p_certification_required in varchar2 default hr_api.g_varchar2,
810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 814: p_max_level in number default hr_api.g_number,

810: p_evaluation_method in varchar2 default hr_api.g_varchar2,
811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 815: p_rating_scale_id in number default hr_api.g_number,

811: p_renewal_period_frequency in number default hr_api.g_number,
812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 816: p_attribute_category in varchar2 default hr_api.g_varchar2,

812: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 817: p_attribute1 in varchar2 default hr_api.g_varchar2,

813: p_min_level in number default hr_api.g_number,
814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 818: p_attribute2 in varchar2 default hr_api.g_varchar2,

814: p_max_level in number default hr_api.g_number,
815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 819: p_attribute3 in varchar2 default hr_api.g_varchar2,

815: p_rating_scale_id in number default hr_api.g_number,
816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 820: p_attribute4 in varchar2 default hr_api.g_varchar2,

816: p_attribute_category in varchar2 default hr_api.g_varchar2,
817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 821: p_attribute5 in varchar2 default hr_api.g_varchar2,

817: p_attribute1 in varchar2 default hr_api.g_varchar2,
818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 822: p_attribute6 in varchar2 default hr_api.g_varchar2,

818: p_attribute2 in varchar2 default hr_api.g_varchar2,
819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 823: p_attribute7 in varchar2 default hr_api.g_varchar2,

819: p_attribute3 in varchar2 default hr_api.g_varchar2,
820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 824: p_attribute8 in varchar2 default hr_api.g_varchar2,

820: p_attribute4 in varchar2 default hr_api.g_varchar2,
821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 825: p_attribute9 in varchar2 default hr_api.g_varchar2,

821: p_attribute5 in varchar2 default hr_api.g_varchar2,
822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 826: p_attribute10 in varchar2 default hr_api.g_varchar2,

822: p_attribute6 in varchar2 default hr_api.g_varchar2,
823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 827: p_attribute11 in varchar2 default hr_api.g_varchar2,

823: p_attribute7 in varchar2 default hr_api.g_varchar2,
824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 828: p_attribute12 in varchar2 default hr_api.g_varchar2,

824: p_attribute8 in varchar2 default hr_api.g_varchar2,
825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 829: p_attribute13 in varchar2 default hr_api.g_varchar2,

825: p_attribute9 in varchar2 default hr_api.g_varchar2,
826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 830: p_attribute14 in varchar2 default hr_api.g_varchar2,

826: p_attribute10 in varchar2 default hr_api.g_varchar2,
827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,
834: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 831: p_attribute15 in varchar2 default hr_api.g_varchar2,

827: p_attribute11 in varchar2 default hr_api.g_varchar2,
828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,
834: p_attribute18 in varchar2 default hr_api.g_varchar2,
835: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 832: p_attribute16 in varchar2 default hr_api.g_varchar2,

828: p_attribute12 in varchar2 default hr_api.g_varchar2,
829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,
834: p_attribute18 in varchar2 default hr_api.g_varchar2,
835: p_attribute19 in varchar2 default hr_api.g_varchar2,
836: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 833: p_attribute17 in varchar2 default hr_api.g_varchar2,

829: p_attribute13 in varchar2 default hr_api.g_varchar2,
830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,
834: p_attribute18 in varchar2 default hr_api.g_varchar2,
835: p_attribute19 in varchar2 default hr_api.g_varchar2,
836: p_attribute20 in varchar2 default hr_api.g_varchar2,
837: p_effective_date in date ,

Line 834: p_attribute18 in varchar2 default hr_api.g_varchar2,

830: p_attribute14 in varchar2 default hr_api.g_varchar2,
831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,
834: p_attribute18 in varchar2 default hr_api.g_varchar2,
835: p_attribute19 in varchar2 default hr_api.g_varchar2,
836: p_attribute20 in varchar2 default hr_api.g_varchar2,
837: p_effective_date in date ,
838: p_validate in boolean default false,

Line 835: p_attribute19 in varchar2 default hr_api.g_varchar2,

831: p_attribute15 in varchar2 default hr_api.g_varchar2,
832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,
834: p_attribute18 in varchar2 default hr_api.g_varchar2,
835: p_attribute19 in varchar2 default hr_api.g_varchar2,
836: p_attribute20 in varchar2 default hr_api.g_varchar2,
837: p_effective_date in date ,
838: p_validate in boolean default false,
839: p_competence_alias in varchar2 default hr_api.g_varchar2,

Line 836: p_attribute20 in varchar2 default hr_api.g_varchar2,

832: p_attribute16 in varchar2 default hr_api.g_varchar2,
833: p_attribute17 in varchar2 default hr_api.g_varchar2,
834: p_attribute18 in varchar2 default hr_api.g_varchar2,
835: p_attribute19 in varchar2 default hr_api.g_varchar2,
836: p_attribute20 in varchar2 default hr_api.g_varchar2,
837: p_effective_date in date ,
838: p_validate in boolean default false,
839: p_competence_alias in varchar2 default hr_api.g_varchar2,
840: p_competence_definition_id in number

Line 839: p_competence_alias in varchar2 default hr_api.g_varchar2,

835: p_attribute19 in varchar2 default hr_api.g_varchar2,
836: p_attribute20 in varchar2 default hr_api.g_varchar2,
837: p_effective_date in date ,
838: p_validate in boolean default false,
839: p_competence_alias in varchar2 default hr_api.g_varchar2,
840: p_competence_definition_id in number
841: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
843: ,p_credit_type in varchar2 default hr_api.g_varchar2

Line 841: ,p_competence_cluster in varchar2 default hr_api.g_varchar2

837: p_effective_date in date ,
838: p_validate in boolean default false,
839: p_competence_alias in varchar2 default hr_api.g_varchar2,
840: p_competence_definition_id in number
841: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
843: ,p_credit_type in varchar2 default hr_api.g_varchar2
844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2

Line 842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2

838: p_validate in boolean default false,
839: p_competence_alias in varchar2 default hr_api.g_varchar2,
840: p_competence_definition_id in number
841: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
843: ,p_credit_type in varchar2 default hr_api.g_varchar2
844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number

Line 843: ,p_credit_type in varchar2 default hr_api.g_varchar2

839: p_competence_alias in varchar2 default hr_api.g_varchar2,
840: p_competence_definition_id in number
841: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
843: ,p_credit_type in varchar2 default hr_api.g_varchar2
844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2

Line 844: ,p_credits in number default hr_api.g_number

840: p_competence_definition_id in number
841: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
843: ,p_credit_type in varchar2 default hr_api.g_varchar2
844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2

Line 845: ,p_level_type in varchar2 default hr_api.g_varchar2

841: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
843: ,p_credit_type in varchar2 default hr_api.g_varchar2
844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2

Line 846: ,p_level_number in number default hr_api.g_number

842: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
843: ,p_credit_type in varchar2 default hr_api.g_varchar2
844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2

Line 847: ,p_field in varchar2 default hr_api.g_varchar2

843: ,p_credit_type in varchar2 default hr_api.g_varchar2
844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 848: ,p_sub_field in varchar2 default hr_api.g_varchar2

844: ,p_credits in number default hr_api.g_number
845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 849: ,p_provider in varchar2 default hr_api.g_varchar2

845: ,p_level_type in varchar2 default hr_api.g_varchar2
846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 850: ,p_qa_organization in varchar2 default hr_api.g_varchar2

846: ,p_level_number in number default hr_api.g_number
847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 851: ,p_information_category in varchar2 default hr_api.g_varchar2

847: ,p_field in varchar2 default hr_api.g_varchar2
848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 852: ,p_information1 in varchar2 default hr_api.g_varchar2

848: ,p_sub_field in varchar2 default hr_api.g_varchar2
849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 853: ,p_information2 in varchar2 default hr_api.g_varchar2

849: ,p_provider in varchar2 default hr_api.g_varchar2
850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 854: ,p_information3 in varchar2 default hr_api.g_varchar2

850: ,p_qa_organization in varchar2 default hr_api.g_varchar2
851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 855: ,p_information4 in varchar2 default hr_api.g_varchar2

851: ,p_information_category in varchar2 default hr_api.g_varchar2
852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 856: ,p_information5 in varchar2 default hr_api.g_varchar2

852: ,p_information1 in varchar2 default hr_api.g_varchar2
853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 857: ,p_information6 in varchar2 default hr_api.g_varchar2

853: ,p_information2 in varchar2 default hr_api.g_varchar2
854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 858: ,p_information7 in varchar2 default hr_api.g_varchar2

854: ,p_information3 in varchar2 default hr_api.g_varchar2
855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 859: ,p_information8 in varchar2 default hr_api.g_varchar2

855: ,p_information4 in varchar2 default hr_api.g_varchar2
856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 860: ,p_information9 in varchar2 default hr_api.g_varchar2

856: ,p_information5 in varchar2 default hr_api.g_varchar2
857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 861: ,p_information10 in varchar2 default hr_api.g_varchar2

857: ,p_information6 in varchar2 default hr_api.g_varchar2
858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 862: ,p_information11 in varchar2 default hr_api.g_varchar2

858: ,p_information7 in varchar2 default hr_api.g_varchar2
859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 863: ,p_information12 in varchar2 default hr_api.g_varchar2

859: ,p_information8 in varchar2 default hr_api.g_varchar2
860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 864: ,p_information13 in varchar2 default hr_api.g_varchar2

860: ,p_information9 in varchar2 default hr_api.g_varchar2
861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 865: ,p_information14 in varchar2 default hr_api.g_varchar2

861: ,p_information10 in varchar2 default hr_api.g_varchar2
862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2
869: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 866: ,p_information15 in varchar2 default hr_api.g_varchar2

862: ,p_information11 in varchar2 default hr_api.g_varchar2
863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2
869: ,p_information18 in varchar2 default hr_api.g_varchar2
870: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 867: ,p_information16 in varchar2 default hr_api.g_varchar2

863: ,p_information12 in varchar2 default hr_api.g_varchar2
864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2
869: ,p_information18 in varchar2 default hr_api.g_varchar2
870: ,p_information19 in varchar2 default hr_api.g_varchar2
871: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 868: ,p_information17 in varchar2 default hr_api.g_varchar2

864: ,p_information13 in varchar2 default hr_api.g_varchar2
865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2
869: ,p_information18 in varchar2 default hr_api.g_varchar2
870: ,p_information19 in varchar2 default hr_api.g_varchar2
871: ,p_information20 in varchar2 default hr_api.g_varchar2
872:

Line 869: ,p_information18 in varchar2 default hr_api.g_varchar2

865: ,p_information14 in varchar2 default hr_api.g_varchar2
866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2
869: ,p_information18 in varchar2 default hr_api.g_varchar2
870: ,p_information19 in varchar2 default hr_api.g_varchar2
871: ,p_information20 in varchar2 default hr_api.g_varchar2
872:
873: ) is

Line 870: ,p_information19 in varchar2 default hr_api.g_varchar2

866: ,p_information15 in varchar2 default hr_api.g_varchar2
867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2
869: ,p_information18 in varchar2 default hr_api.g_varchar2
870: ,p_information19 in varchar2 default hr_api.g_varchar2
871: ,p_information20 in varchar2 default hr_api.g_varchar2
872:
873: ) is
874: --

Line 871: ,p_information20 in varchar2 default hr_api.g_varchar2

867: ,p_information16 in varchar2 default hr_api.g_varchar2
868: ,p_information17 in varchar2 default hr_api.g_varchar2
869: ,p_information18 in varchar2 default hr_api.g_varchar2
870: ,p_information19 in varchar2 default hr_api.g_varchar2
871: ,p_information20 in varchar2 default hr_api.g_varchar2
872:
873: ) is
874: --
875: l_rec per_cpn_shd.g_rec_type;

Line 889: hr_api.g_number,

885: per_cpn_shd.convert_args
886: (
887: p_competence_id,
888: p_name,
889: hr_api.g_number,
890: p_object_version_number,
891: p_description,
892: p_date_from,
893: p_date_to,