DBA Data[Home] [Help]

APPS.OTA_LME_UPD dependencies on HR_API

Line 121: When hr_api.check_integrity_violated Then

117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: ota_lme_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: ota_lme_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
129: ota_lme_shd.constraint_error

Line 126: When hr_api.parent_integrity_violated Then

122: -- A check constraint has been violated
123: --
124: ota_lme_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
129: ota_lme_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
129: ota_lme_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: --
134: ota_lme_shd.constraint_error

Line 131: When hr_api.unique_integrity_violated Then

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

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

131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: --
134: ota_lme_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: --
138: Raise;
139: End update_dml;

Line 400: when hr_api.cannot_find_prog_unit then

396: );
397: --
398: exception
399: --
400: when hr_api.cannot_find_prog_unit then
401: --
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'OTA_LP_MEMBER_ENROLLMENTS'
404: ,p_hook_type => 'AU');

Line 402: hr_api.cannot_find_prog_unit_error

398: exception
399: --
400: when hr_api.cannot_find_prog_unit then
401: --
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'OTA_LP_MEMBER_ENROLLMENTS'
404: ,p_hook_type => 'AU');
405: --
406: end;

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

461: -- p_rec plsql record structure
462: -- to see if a system default is being used. If a system default
463: -- is being used then we must set to the 'current' argument value.
464: --
465: If (p_rec.lp_enrollment_id = hr_api.g_number) then
466: p_rec.lp_enrollment_id :=
467: ota_lme_shd.g_old_rec.lp_enrollment_id;
468: End If;
469: If (p_rec.learning_path_section_id = hr_api.g_number) then

Line 469: If (p_rec.learning_path_section_id = hr_api.g_number) then

465: If (p_rec.lp_enrollment_id = hr_api.g_number) then
466: p_rec.lp_enrollment_id :=
467: ota_lme_shd.g_old_rec.lp_enrollment_id;
468: End If;
469: If (p_rec.learning_path_section_id = hr_api.g_number) then
470: p_rec.learning_path_section_id :=
471: ota_lme_shd.g_old_rec.learning_path_section_id;
472: End If;
473: If (p_rec.learning_path_member_id = hr_api.g_number) then

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

469: If (p_rec.learning_path_section_id = hr_api.g_number) then
470: p_rec.learning_path_section_id :=
471: ota_lme_shd.g_old_rec.learning_path_section_id;
472: End If;
473: If (p_rec.learning_path_member_id = hr_api.g_number) then
474: p_rec.learning_path_member_id :=
475: ota_lme_shd.g_old_rec.learning_path_member_id;
476: End If;
477: If (p_rec.member_status_code = hr_api.g_varchar2) then

Line 477: If (p_rec.member_status_code = hr_api.g_varchar2) then

473: If (p_rec.learning_path_member_id = hr_api.g_number) then
474: p_rec.learning_path_member_id :=
475: ota_lme_shd.g_old_rec.learning_path_member_id;
476: End If;
477: If (p_rec.member_status_code = hr_api.g_varchar2) then
478: p_rec.member_status_code :=
479: ota_lme_shd.g_old_rec.member_status_code;
480: End If;
481: If (p_rec.completion_target_date = hr_api.g_date) then

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

477: If (p_rec.member_status_code = hr_api.g_varchar2) then
478: p_rec.member_status_code :=
479: ota_lme_shd.g_old_rec.member_status_code;
480: End If;
481: If (p_rec.completion_target_date = hr_api.g_date) then
482: p_rec.completion_target_date :=
483: ota_lme_shd.g_old_rec.completion_target_date;
484: End If;
485: If (p_rec.completion_date = hr_api.g_date) then

Line 485: If (p_rec.completion_date = hr_api.g_date) then

481: If (p_rec.completion_target_date = hr_api.g_date) then
482: p_rec.completion_target_date :=
483: ota_lme_shd.g_old_rec.completion_target_date;
484: End If;
485: If (p_rec.completion_date = hr_api.g_date) then
486: p_rec.completion_date :=
487: ota_lme_shd.g_old_rec.completion_date;
488: End If;
489: If (p_rec.business_group_id = hr_api.g_number) then

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

485: If (p_rec.completion_date = hr_api.g_date) then
486: p_rec.completion_date :=
487: ota_lme_shd.g_old_rec.completion_date;
488: End If;
489: If (p_rec.business_group_id = hr_api.g_number) then
490: p_rec.business_group_id :=
491: ota_lme_shd.g_old_rec.business_group_id;
492: End If;
493: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

489: If (p_rec.business_group_id = hr_api.g_number) then
490: p_rec.business_group_id :=
491: ota_lme_shd.g_old_rec.business_group_id;
492: End If;
493: If (p_rec.attribute_category = hr_api.g_varchar2) then
494: p_rec.attribute_category :=
495: ota_lme_shd.g_old_rec.attribute_category;
496: End If;
497: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

493: If (p_rec.attribute_category = hr_api.g_varchar2) then
494: p_rec.attribute_category :=
495: ota_lme_shd.g_old_rec.attribute_category;
496: End If;
497: If (p_rec.attribute1 = hr_api.g_varchar2) then
498: p_rec.attribute1 :=
499: ota_lme_shd.g_old_rec.attribute1;
500: End If;
501: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

497: If (p_rec.attribute1 = hr_api.g_varchar2) then
498: p_rec.attribute1 :=
499: ota_lme_shd.g_old_rec.attribute1;
500: End If;
501: If (p_rec.attribute2 = hr_api.g_varchar2) then
502: p_rec.attribute2 :=
503: ota_lme_shd.g_old_rec.attribute2;
504: End If;
505: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

501: If (p_rec.attribute2 = hr_api.g_varchar2) then
502: p_rec.attribute2 :=
503: ota_lme_shd.g_old_rec.attribute2;
504: End If;
505: If (p_rec.attribute3 = hr_api.g_varchar2) then
506: p_rec.attribute3 :=
507: ota_lme_shd.g_old_rec.attribute3;
508: End If;
509: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

505: If (p_rec.attribute3 = hr_api.g_varchar2) then
506: p_rec.attribute3 :=
507: ota_lme_shd.g_old_rec.attribute3;
508: End If;
509: If (p_rec.attribute4 = hr_api.g_varchar2) then
510: p_rec.attribute4 :=
511: ota_lme_shd.g_old_rec.attribute4;
512: End If;
513: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

509: If (p_rec.attribute4 = hr_api.g_varchar2) then
510: p_rec.attribute4 :=
511: ota_lme_shd.g_old_rec.attribute4;
512: End If;
513: If (p_rec.attribute5 = hr_api.g_varchar2) then
514: p_rec.attribute5 :=
515: ota_lme_shd.g_old_rec.attribute5;
516: End If;
517: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

513: If (p_rec.attribute5 = hr_api.g_varchar2) then
514: p_rec.attribute5 :=
515: ota_lme_shd.g_old_rec.attribute5;
516: End If;
517: If (p_rec.attribute6 = hr_api.g_varchar2) then
518: p_rec.attribute6 :=
519: ota_lme_shd.g_old_rec.attribute6;
520: End If;
521: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

517: If (p_rec.attribute6 = hr_api.g_varchar2) then
518: p_rec.attribute6 :=
519: ota_lme_shd.g_old_rec.attribute6;
520: End If;
521: If (p_rec.attribute7 = hr_api.g_varchar2) then
522: p_rec.attribute7 :=
523: ota_lme_shd.g_old_rec.attribute7;
524: End If;
525: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

521: If (p_rec.attribute7 = hr_api.g_varchar2) then
522: p_rec.attribute7 :=
523: ota_lme_shd.g_old_rec.attribute7;
524: End If;
525: If (p_rec.attribute8 = hr_api.g_varchar2) then
526: p_rec.attribute8 :=
527: ota_lme_shd.g_old_rec.attribute8;
528: End If;
529: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

525: If (p_rec.attribute8 = hr_api.g_varchar2) then
526: p_rec.attribute8 :=
527: ota_lme_shd.g_old_rec.attribute8;
528: End If;
529: If (p_rec.attribute9 = hr_api.g_varchar2) then
530: p_rec.attribute9 :=
531: ota_lme_shd.g_old_rec.attribute9;
532: End If;
533: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

529: If (p_rec.attribute9 = hr_api.g_varchar2) then
530: p_rec.attribute9 :=
531: ota_lme_shd.g_old_rec.attribute9;
532: End If;
533: If (p_rec.attribute10 = hr_api.g_varchar2) then
534: p_rec.attribute10 :=
535: ota_lme_shd.g_old_rec.attribute10;
536: End If;
537: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

533: If (p_rec.attribute10 = hr_api.g_varchar2) then
534: p_rec.attribute10 :=
535: ota_lme_shd.g_old_rec.attribute10;
536: End If;
537: If (p_rec.attribute11 = hr_api.g_varchar2) then
538: p_rec.attribute11 :=
539: ota_lme_shd.g_old_rec.attribute11;
540: End If;
541: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

537: If (p_rec.attribute11 = hr_api.g_varchar2) then
538: p_rec.attribute11 :=
539: ota_lme_shd.g_old_rec.attribute11;
540: End If;
541: If (p_rec.attribute12 = hr_api.g_varchar2) then
542: p_rec.attribute12 :=
543: ota_lme_shd.g_old_rec.attribute12;
544: End If;
545: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

541: If (p_rec.attribute12 = hr_api.g_varchar2) then
542: p_rec.attribute12 :=
543: ota_lme_shd.g_old_rec.attribute12;
544: End If;
545: If (p_rec.attribute13 = hr_api.g_varchar2) then
546: p_rec.attribute13 :=
547: ota_lme_shd.g_old_rec.attribute13;
548: End If;
549: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

545: If (p_rec.attribute13 = hr_api.g_varchar2) then
546: p_rec.attribute13 :=
547: ota_lme_shd.g_old_rec.attribute13;
548: End If;
549: If (p_rec.attribute14 = hr_api.g_varchar2) then
550: p_rec.attribute14 :=
551: ota_lme_shd.g_old_rec.attribute14;
552: End If;
553: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

549: If (p_rec.attribute14 = hr_api.g_varchar2) then
550: p_rec.attribute14 :=
551: ota_lme_shd.g_old_rec.attribute14;
552: End If;
553: If (p_rec.attribute15 = hr_api.g_varchar2) then
554: p_rec.attribute15 :=
555: ota_lme_shd.g_old_rec.attribute15;
556: End If;
557: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

553: If (p_rec.attribute15 = hr_api.g_varchar2) then
554: p_rec.attribute15 :=
555: ota_lme_shd.g_old_rec.attribute15;
556: End If;
557: If (p_rec.attribute16 = hr_api.g_varchar2) then
558: p_rec.attribute16 :=
559: ota_lme_shd.g_old_rec.attribute16;
560: End If;
561: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

557: If (p_rec.attribute16 = hr_api.g_varchar2) then
558: p_rec.attribute16 :=
559: ota_lme_shd.g_old_rec.attribute16;
560: End If;
561: If (p_rec.attribute17 = hr_api.g_varchar2) then
562: p_rec.attribute17 :=
563: ota_lme_shd.g_old_rec.attribute17;
564: End If;
565: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

561: If (p_rec.attribute17 = hr_api.g_varchar2) then
562: p_rec.attribute17 :=
563: ota_lme_shd.g_old_rec.attribute17;
564: End If;
565: If (p_rec.attribute18 = hr_api.g_varchar2) then
566: p_rec.attribute18 :=
567: ota_lme_shd.g_old_rec.attribute18;
568: End If;
569: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

565: If (p_rec.attribute18 = hr_api.g_varchar2) then
566: p_rec.attribute18 :=
567: ota_lme_shd.g_old_rec.attribute18;
568: End If;
569: If (p_rec.attribute19 = hr_api.g_varchar2) then
570: p_rec.attribute19 :=
571: ota_lme_shd.g_old_rec.attribute19;
572: End If;
573: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

569: If (p_rec.attribute19 = hr_api.g_varchar2) then
570: p_rec.attribute19 :=
571: ota_lme_shd.g_old_rec.attribute19;
572: End If;
573: If (p_rec.attribute20 = hr_api.g_varchar2) then
574: p_rec.attribute20 :=
575: ota_lme_shd.g_old_rec.attribute20;
576: End If;
577: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

573: If (p_rec.attribute20 = hr_api.g_varchar2) then
574: p_rec.attribute20 :=
575: ota_lme_shd.g_old_rec.attribute20;
576: End If;
577: If (p_rec.attribute21 = hr_api.g_varchar2) then
578: p_rec.attribute21 :=
579: ota_lme_shd.g_old_rec.attribute21;
580: End If;
581: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

577: If (p_rec.attribute21 = hr_api.g_varchar2) then
578: p_rec.attribute21 :=
579: ota_lme_shd.g_old_rec.attribute21;
580: End If;
581: If (p_rec.attribute22 = hr_api.g_varchar2) then
582: p_rec.attribute22 :=
583: ota_lme_shd.g_old_rec.attribute22;
584: End If;
585: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

581: If (p_rec.attribute22 = hr_api.g_varchar2) then
582: p_rec.attribute22 :=
583: ota_lme_shd.g_old_rec.attribute22;
584: End If;
585: If (p_rec.attribute23 = hr_api.g_varchar2) then
586: p_rec.attribute23 :=
587: ota_lme_shd.g_old_rec.attribute23;
588: End If;
589: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 589: If (p_rec.attribute24 = hr_api.g_varchar2) then

585: If (p_rec.attribute23 = hr_api.g_varchar2) then
586: p_rec.attribute23 :=
587: ota_lme_shd.g_old_rec.attribute23;
588: End If;
589: If (p_rec.attribute24 = hr_api.g_varchar2) then
590: p_rec.attribute24 :=
591: ota_lme_shd.g_old_rec.attribute24;
592: End If;
593: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 593: If (p_rec.attribute25 = hr_api.g_varchar2) then

589: If (p_rec.attribute24 = hr_api.g_varchar2) then
590: p_rec.attribute24 :=
591: ota_lme_shd.g_old_rec.attribute24;
592: End If;
593: If (p_rec.attribute25 = hr_api.g_varchar2) then
594: p_rec.attribute25 :=
595: ota_lme_shd.g_old_rec.attribute25;
596: End If;
597: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 597: If (p_rec.attribute26 = hr_api.g_varchar2) then

593: If (p_rec.attribute25 = hr_api.g_varchar2) then
594: p_rec.attribute25 :=
595: ota_lme_shd.g_old_rec.attribute25;
596: End If;
597: If (p_rec.attribute26 = hr_api.g_varchar2) then
598: p_rec.attribute26 :=
599: ota_lme_shd.g_old_rec.attribute26;
600: End If;
601: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 601: If (p_rec.attribute27 = hr_api.g_varchar2) then

597: If (p_rec.attribute26 = hr_api.g_varchar2) then
598: p_rec.attribute26 :=
599: ota_lme_shd.g_old_rec.attribute26;
600: End If;
601: If (p_rec.attribute27 = hr_api.g_varchar2) then
602: p_rec.attribute27 :=
603: ota_lme_shd.g_old_rec.attribute27;
604: End If;
605: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 605: If (p_rec.attribute28 = hr_api.g_varchar2) then

601: If (p_rec.attribute27 = hr_api.g_varchar2) then
602: p_rec.attribute27 :=
603: ota_lme_shd.g_old_rec.attribute27;
604: End If;
605: If (p_rec.attribute28 = hr_api.g_varchar2) then
606: p_rec.attribute28 :=
607: ota_lme_shd.g_old_rec.attribute28;
608: End If;
609: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 609: If (p_rec.attribute29 = hr_api.g_varchar2) then

605: If (p_rec.attribute28 = hr_api.g_varchar2) then
606: p_rec.attribute28 :=
607: ota_lme_shd.g_old_rec.attribute28;
608: End If;
609: If (p_rec.attribute29 = hr_api.g_varchar2) then
610: p_rec.attribute29 :=
611: ota_lme_shd.g_old_rec.attribute29;
612: End If;
613: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 613: If (p_rec.attribute30 = hr_api.g_varchar2) then

609: If (p_rec.attribute29 = hr_api.g_varchar2) then
610: p_rec.attribute29 :=
611: ota_lme_shd.g_old_rec.attribute29;
612: End If;
613: If (p_rec.attribute30 = hr_api.g_varchar2) then
614: p_rec.attribute30 :=
615: ota_lme_shd.g_old_rec.attribute30;
616: End If;
617: If (p_rec.creator_person_id = hr_api.g_number) then

Line 617: If (p_rec.creator_person_id = hr_api.g_number) then

613: If (p_rec.attribute30 = hr_api.g_varchar2) then
614: p_rec.attribute30 :=
615: ota_lme_shd.g_old_rec.attribute30;
616: End If;
617: If (p_rec.creator_person_id = hr_api.g_number) then
618: p_rec.creator_person_id :=
619: ota_lme_shd.g_old_rec.creator_person_id;
620: End If;
621: If (p_rec.event_id = hr_api.g_number) then

Line 621: If (p_rec.event_id = hr_api.g_number) then

617: If (p_rec.creator_person_id = hr_api.g_number) then
618: p_rec.creator_person_id :=
619: ota_lme_shd.g_old_rec.creator_person_id;
620: End If;
621: If (p_rec.event_id = hr_api.g_number) then
622: p_rec.event_id :=
623: ota_lme_shd.g_old_rec.event_id;
624: End If;
625: --

Line 689: ,p_lp_enrollment_id in number default hr_api.g_number

685: Procedure upd
686: (p_effective_date in date
687: ,p_lp_member_enrollment_id in number
688: ,p_object_version_number in out nocopy number
689: ,p_lp_enrollment_id in number default hr_api.g_number
690: ,p_learning_path_section_id in number default hr_api.g_number
691: ,p_learning_path_member_id in number default hr_api.g_number
692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number

Line 690: ,p_learning_path_section_id in number default hr_api.g_number

686: (p_effective_date in date
687: ,p_lp_member_enrollment_id in number
688: ,p_object_version_number in out nocopy number
689: ,p_lp_enrollment_id in number default hr_api.g_number
690: ,p_learning_path_section_id in number default hr_api.g_number
691: ,p_learning_path_member_id in number default hr_api.g_number
692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date

Line 691: ,p_learning_path_member_id in number default hr_api.g_number

687: ,p_lp_member_enrollment_id in number
688: ,p_object_version_number in out nocopy number
689: ,p_lp_enrollment_id in number default hr_api.g_number
690: ,p_learning_path_section_id in number default hr_api.g_number
691: ,p_learning_path_member_id in number default hr_api.g_number
692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date

Line 692: ,p_member_status_code in varchar2 default hr_api.g_varchar2

688: ,p_object_version_number in out nocopy number
689: ,p_lp_enrollment_id in number default hr_api.g_number
690: ,p_learning_path_section_id in number default hr_api.g_number
691: ,p_learning_path_member_id in number default hr_api.g_number
692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 693: ,p_business_group_id in number default hr_api.g_number

689: ,p_lp_enrollment_id in number default hr_api.g_number
690: ,p_learning_path_section_id in number default hr_api.g_number
691: ,p_learning_path_member_id in number default hr_api.g_number
692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 694: ,p_completion_target_date in date default hr_api.g_date

690: ,p_learning_path_section_id in number default hr_api.g_number
691: ,p_learning_path_member_id in number default hr_api.g_number
692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 695: ,p_completion_date in date default hr_api.g_date

691: ,p_learning_path_member_id in number default hr_api.g_number
692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 696: ,p_attribute_category in varchar2 default hr_api.g_varchar2

692: ,p_member_status_code in varchar2 default hr_api.g_varchar2
693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 697: ,p_attribute1 in varchar2 default hr_api.g_varchar2

693: ,p_business_group_id in number default hr_api.g_number
694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 698: ,p_attribute2 in varchar2 default hr_api.g_varchar2

694: ,p_completion_target_date in date default hr_api.g_date
695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 699: ,p_attribute3 in varchar2 default hr_api.g_varchar2

695: ,p_completion_date in date default hr_api.g_date
696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 700: ,p_attribute4 in varchar2 default hr_api.g_varchar2

696: ,p_attribute_category in varchar2 default hr_api.g_varchar2
697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 701: ,p_attribute5 in varchar2 default hr_api.g_varchar2

697: ,p_attribute1 in varchar2 default hr_api.g_varchar2
698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 702: ,p_attribute6 in varchar2 default hr_api.g_varchar2

698: ,p_attribute2 in varchar2 default hr_api.g_varchar2
699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 703: ,p_attribute7 in varchar2 default hr_api.g_varchar2

699: ,p_attribute3 in varchar2 default hr_api.g_varchar2
700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 704: ,p_attribute8 in varchar2 default hr_api.g_varchar2

700: ,p_attribute4 in varchar2 default hr_api.g_varchar2
701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 705: ,p_attribute9 in varchar2 default hr_api.g_varchar2

701: ,p_attribute5 in varchar2 default hr_api.g_varchar2
702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 706: ,p_attribute10 in varchar2 default hr_api.g_varchar2

702: ,p_attribute6 in varchar2 default hr_api.g_varchar2
703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 707: ,p_attribute11 in varchar2 default hr_api.g_varchar2

703: ,p_attribute7 in varchar2 default hr_api.g_varchar2
704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 708: ,p_attribute12 in varchar2 default hr_api.g_varchar2

704: ,p_attribute8 in varchar2 default hr_api.g_varchar2
705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 709: ,p_attribute13 in varchar2 default hr_api.g_varchar2

705: ,p_attribute9 in varchar2 default hr_api.g_varchar2
706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 710: ,p_attribute14 in varchar2 default hr_api.g_varchar2

706: ,p_attribute10 in varchar2 default hr_api.g_varchar2
707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 711: ,p_attribute15 in varchar2 default hr_api.g_varchar2

707: ,p_attribute11 in varchar2 default hr_api.g_varchar2
708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 712: ,p_attribute16 in varchar2 default hr_api.g_varchar2

708: ,p_attribute12 in varchar2 default hr_api.g_varchar2
709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 713: ,p_attribute17 in varchar2 default hr_api.g_varchar2

709: ,p_attribute13 in varchar2 default hr_api.g_varchar2
710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 714: ,p_attribute18 in varchar2 default hr_api.g_varchar2

710: ,p_attribute14 in varchar2 default hr_api.g_varchar2
711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 715: ,p_attribute19 in varchar2 default hr_api.g_varchar2

711: ,p_attribute15 in varchar2 default hr_api.g_varchar2
712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 716: ,p_attribute20 in varchar2 default hr_api.g_varchar2

712: ,p_attribute16 in varchar2 default hr_api.g_varchar2
713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 717: ,p_attribute21 in varchar2 default hr_api.g_varchar2

713: ,p_attribute17 in varchar2 default hr_api.g_varchar2
714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 718: ,p_attribute22 in varchar2 default hr_api.g_varchar2

714: ,p_attribute18 in varchar2 default hr_api.g_varchar2
715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 719: ,p_attribute23 in varchar2 default hr_api.g_varchar2

715: ,p_attribute19 in varchar2 default hr_api.g_varchar2
716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 720: ,p_attribute24 in varchar2 default hr_api.g_varchar2

716: ,p_attribute20 in varchar2 default hr_api.g_varchar2
717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 721: ,p_attribute25 in varchar2 default hr_api.g_varchar2

717: ,p_attribute21 in varchar2 default hr_api.g_varchar2
718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 722: ,p_attribute26 in varchar2 default hr_api.g_varchar2

718: ,p_attribute22 in varchar2 default hr_api.g_varchar2
719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2
726: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 723: ,p_attribute27 in varchar2 default hr_api.g_varchar2

719: ,p_attribute23 in varchar2 default hr_api.g_varchar2
720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2
726: ,p_attribute30 in varchar2 default hr_api.g_varchar2
727: ,p_creator_person_id in number default hr_api.g_number

Line 724: ,p_attribute28 in varchar2 default hr_api.g_varchar2

720: ,p_attribute24 in varchar2 default hr_api.g_varchar2
721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2
726: ,p_attribute30 in varchar2 default hr_api.g_varchar2
727: ,p_creator_person_id in number default hr_api.g_number
728: ,p_event_id in number default hr_api.g_number

Line 725: ,p_attribute29 in varchar2 default hr_api.g_varchar2

721: ,p_attribute25 in varchar2 default hr_api.g_varchar2
722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2
726: ,p_attribute30 in varchar2 default hr_api.g_varchar2
727: ,p_creator_person_id in number default hr_api.g_number
728: ,p_event_id in number default hr_api.g_number
729: ) is

Line 726: ,p_attribute30 in varchar2 default hr_api.g_varchar2

722: ,p_attribute26 in varchar2 default hr_api.g_varchar2
723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2
726: ,p_attribute30 in varchar2 default hr_api.g_varchar2
727: ,p_creator_person_id in number default hr_api.g_number
728: ,p_event_id in number default hr_api.g_number
729: ) is
730: --

Line 727: ,p_creator_person_id in number default hr_api.g_number

723: ,p_attribute27 in varchar2 default hr_api.g_varchar2
724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2
726: ,p_attribute30 in varchar2 default hr_api.g_varchar2
727: ,p_creator_person_id in number default hr_api.g_number
728: ,p_event_id in number default hr_api.g_number
729: ) is
730: --
731: l_rec ota_lme_shd.g_rec_type;

Line 728: ,p_event_id in number default hr_api.g_number

724: ,p_attribute28 in varchar2 default hr_api.g_varchar2
725: ,p_attribute29 in varchar2 default hr_api.g_varchar2
726: ,p_attribute30 in varchar2 default hr_api.g_varchar2
727: ,p_creator_person_id in number default hr_api.g_number
728: ,p_event_id in number default hr_api.g_number
729: ) is
730: --
731: l_rec ota_lme_shd.g_rec_type;
732: l_proc varchar2(72) := g_package||'upd';