APPS.OTA_TPM_UPD dependencies on HR_API

Line 127: When hr_api.check_integrity_violated Then

123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: ota_tpm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: ota_tpm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
135: ota_tpm_shd.constraint_error

Line 132: When hr_api.parent_integrity_violated Then

128: -- A check constraint has been violated
129: --
130: ota_tpm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
135: ota_tpm_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: --
135: ota_tpm_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: ota_tpm_shd.constraint_error

Line 137: When hr_api.unique_integrity_violated Then

133: -- Parent integrity has been violated
134: --
135: ota_tpm_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: ota_tpm_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: --
140: ota_tpm_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: --
144: Raise;
145: End update_dml;

Line 406: when hr_api.cannot_find_prog_unit then

402: );
403: --
404: exception
405: --
406: when hr_api.cannot_find_prog_unit then
407: --
408: hr_api.cannot_find_prog_unit_error
409: (p_module_name => 'OTA_TRAINING_PLAN_MEMBERS'
410: ,p_hook_type => 'AU');

Line 408: hr_api.cannot_find_prog_unit_error

404: exception
405: --
406: when hr_api.cannot_find_prog_unit then
407: --
408: hr_api.cannot_find_prog_unit_error
409: (p_module_name => 'OTA_TRAINING_PLAN_MEMBERS'
410: ,p_hook_type => 'AU');
411: --
412: end;

Line 471: If (p_rec.training_plan_id = hr_api.g_number) then

467: -- p_rec plsql record structure
468: -- to see if a system default is being used. If a system default
469: -- is being used then we must set to the 'current' argument value.
470: --
471: If (p_rec.training_plan_id = hr_api.g_number) then
472: p_rec.training_plan_id :=
473: ota_tpm_shd.g_old_rec.training_plan_id;
474: End If;
475: If (p_rec.activity_version_id = hr_api.g_number) then

Line 475: If (p_rec.activity_version_id = hr_api.g_number) then

471: If (p_rec.training_plan_id = hr_api.g_number) then
472: p_rec.training_plan_id :=
473: ota_tpm_shd.g_old_rec.training_plan_id;
474: End If;
475: If (p_rec.activity_version_id = hr_api.g_number) then
476: p_rec.activity_version_id :=
477: ota_tpm_shd.g_old_rec.activity_version_id;
478: End If;
479: If (p_rec.activity_definition_id = hr_api.g_number) then

Line 479: If (p_rec.activity_definition_id = hr_api.g_number) then

475: If (p_rec.activity_version_id = hr_api.g_number) then
476: p_rec.activity_version_id :=
477: ota_tpm_shd.g_old_rec.activity_version_id;
478: End If;
479: If (p_rec.activity_definition_id = hr_api.g_number) then
480: p_rec.activity_definition_id :=
481: ota_tpm_shd.g_old_rec.activity_definition_id;
482: End If;
483: If (p_rec.member_status_type_id = hr_api.g_varchar2) then

Line 483: If (p_rec.member_status_type_id = hr_api.g_varchar2) then

479: If (p_rec.activity_definition_id = hr_api.g_number) then
480: p_rec.activity_definition_id :=
481: ota_tpm_shd.g_old_rec.activity_definition_id;
482: End If;
483: If (p_rec.member_status_type_id = hr_api.g_varchar2) then
484: p_rec.member_status_type_id :=
485: ota_tpm_shd.g_old_rec.member_status_type_id;
486: End If;
487: If (p_rec.target_completion_date = hr_api.g_date) then

Line 487: If (p_rec.target_completion_date = hr_api.g_date) then

483: If (p_rec.member_status_type_id = hr_api.g_varchar2) then
484: p_rec.member_status_type_id :=
485: ota_tpm_shd.g_old_rec.member_status_type_id;
486: End If;
487: If (p_rec.target_completion_date = hr_api.g_date) then
488: p_rec.target_completion_date :=
489: ota_tpm_shd.g_old_rec.target_completion_date;
490: End If;
491: If (p_rec.business_group_id = hr_api.g_number) then

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

487: If (p_rec.target_completion_date = hr_api.g_date) then
488: p_rec.target_completion_date :=
489: ota_tpm_shd.g_old_rec.target_completion_date;
490: End If;
491: If (p_rec.business_group_id = hr_api.g_number) then
492: p_rec.business_group_id :=
493: ota_tpm_shd.g_old_rec.business_group_id;
494: End If;
495: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

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

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

495: If (p_rec.attribute_category = hr_api.g_varchar2) then
496: p_rec.attribute_category :=
497: ota_tpm_shd.g_old_rec.attribute_category;
498: End If;
499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=
501: ota_tpm_shd.g_old_rec.attribute1;
502: End If;
503: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

499: If (p_rec.attribute1 = hr_api.g_varchar2) then
500: p_rec.attribute1 :=
501: ota_tpm_shd.g_old_rec.attribute1;
502: End If;
503: If (p_rec.attribute2 = hr_api.g_varchar2) then
504: p_rec.attribute2 :=
505: ota_tpm_shd.g_old_rec.attribute2;
506: End If;
507: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

503: If (p_rec.attribute2 = hr_api.g_varchar2) then
504: p_rec.attribute2 :=
505: ota_tpm_shd.g_old_rec.attribute2;
506: End If;
507: If (p_rec.attribute3 = hr_api.g_varchar2) then
508: p_rec.attribute3 :=
509: ota_tpm_shd.g_old_rec.attribute3;
510: End If;
511: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

507: If (p_rec.attribute3 = hr_api.g_varchar2) then
508: p_rec.attribute3 :=
509: ota_tpm_shd.g_old_rec.attribute3;
510: End If;
511: If (p_rec.attribute4 = hr_api.g_varchar2) then
512: p_rec.attribute4 :=
513: ota_tpm_shd.g_old_rec.attribute4;
514: End If;
515: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

511: If (p_rec.attribute4 = hr_api.g_varchar2) then
512: p_rec.attribute4 :=
513: ota_tpm_shd.g_old_rec.attribute4;
514: End If;
515: If (p_rec.attribute5 = hr_api.g_varchar2) then
516: p_rec.attribute5 :=
517: ota_tpm_shd.g_old_rec.attribute5;
518: End If;
519: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

515: If (p_rec.attribute5 = hr_api.g_varchar2) then
516: p_rec.attribute5 :=
517: ota_tpm_shd.g_old_rec.attribute5;
518: End If;
519: If (p_rec.attribute6 = hr_api.g_varchar2) then
520: p_rec.attribute6 :=
521: ota_tpm_shd.g_old_rec.attribute6;
522: End If;
523: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

519: If (p_rec.attribute6 = hr_api.g_varchar2) then
520: p_rec.attribute6 :=
521: ota_tpm_shd.g_old_rec.attribute6;
522: End If;
523: If (p_rec.attribute7 = hr_api.g_varchar2) then
524: p_rec.attribute7 :=
525: ota_tpm_shd.g_old_rec.attribute7;
526: End If;
527: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

523: If (p_rec.attribute7 = hr_api.g_varchar2) then
524: p_rec.attribute7 :=
525: ota_tpm_shd.g_old_rec.attribute7;
526: End If;
527: If (p_rec.attribute8 = hr_api.g_varchar2) then
528: p_rec.attribute8 :=
529: ota_tpm_shd.g_old_rec.attribute8;
530: End If;
531: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

527: If (p_rec.attribute8 = hr_api.g_varchar2) then
528: p_rec.attribute8 :=
529: ota_tpm_shd.g_old_rec.attribute8;
530: End If;
531: If (p_rec.attribute9 = hr_api.g_varchar2) then
532: p_rec.attribute9 :=
533: ota_tpm_shd.g_old_rec.attribute9;
534: End If;
535: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

531: If (p_rec.attribute9 = hr_api.g_varchar2) then
532: p_rec.attribute9 :=
533: ota_tpm_shd.g_old_rec.attribute9;
534: End If;
535: If (p_rec.attribute10 = hr_api.g_varchar2) then
536: p_rec.attribute10 :=
537: ota_tpm_shd.g_old_rec.attribute10;
538: End If;
539: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

535: If (p_rec.attribute10 = hr_api.g_varchar2) then
536: p_rec.attribute10 :=
537: ota_tpm_shd.g_old_rec.attribute10;
538: End If;
539: If (p_rec.attribute11 = hr_api.g_varchar2) then
540: p_rec.attribute11 :=
541: ota_tpm_shd.g_old_rec.attribute11;
542: End If;
543: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

539: If (p_rec.attribute11 = hr_api.g_varchar2) then
540: p_rec.attribute11 :=
541: ota_tpm_shd.g_old_rec.attribute11;
542: End If;
543: If (p_rec.attribute12 = hr_api.g_varchar2) then
544: p_rec.attribute12 :=
545: ota_tpm_shd.g_old_rec.attribute12;
546: End If;
547: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

543: If (p_rec.attribute12 = hr_api.g_varchar2) then
544: p_rec.attribute12 :=
545: ota_tpm_shd.g_old_rec.attribute12;
546: End If;
547: If (p_rec.attribute13 = hr_api.g_varchar2) then
548: p_rec.attribute13 :=
549: ota_tpm_shd.g_old_rec.attribute13;
550: End If;
551: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

547: If (p_rec.attribute13 = hr_api.g_varchar2) then
548: p_rec.attribute13 :=
549: ota_tpm_shd.g_old_rec.attribute13;
550: End If;
551: If (p_rec.attribute14 = hr_api.g_varchar2) then
552: p_rec.attribute14 :=
553: ota_tpm_shd.g_old_rec.attribute14;
554: End If;
555: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

551: If (p_rec.attribute14 = hr_api.g_varchar2) then
552: p_rec.attribute14 :=
553: ota_tpm_shd.g_old_rec.attribute14;
554: End If;
555: If (p_rec.attribute15 = hr_api.g_varchar2) then
556: p_rec.attribute15 :=
557: ota_tpm_shd.g_old_rec.attribute15;
558: End If;
559: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

555: If (p_rec.attribute15 = hr_api.g_varchar2) then
556: p_rec.attribute15 :=
557: ota_tpm_shd.g_old_rec.attribute15;
558: End If;
559: If (p_rec.attribute16 = hr_api.g_varchar2) then
560: p_rec.attribute16 :=
561: ota_tpm_shd.g_old_rec.attribute16;
562: End If;
563: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

559: If (p_rec.attribute16 = hr_api.g_varchar2) then
560: p_rec.attribute16 :=
561: ota_tpm_shd.g_old_rec.attribute16;
562: End If;
563: If (p_rec.attribute17 = hr_api.g_varchar2) then
564: p_rec.attribute17 :=
565: ota_tpm_shd.g_old_rec.attribute17;
566: End If;
567: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

563: If (p_rec.attribute17 = hr_api.g_varchar2) then
564: p_rec.attribute17 :=
565: ota_tpm_shd.g_old_rec.attribute17;
566: End If;
567: If (p_rec.attribute18 = hr_api.g_varchar2) then
568: p_rec.attribute18 :=
569: ota_tpm_shd.g_old_rec.attribute18;
570: End If;
571: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

567: If (p_rec.attribute18 = hr_api.g_varchar2) then
568: p_rec.attribute18 :=
569: ota_tpm_shd.g_old_rec.attribute18;
570: End If;
571: If (p_rec.attribute19 = hr_api.g_varchar2) then
572: p_rec.attribute19 :=
573: ota_tpm_shd.g_old_rec.attribute19;
574: End If;
575: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

571: If (p_rec.attribute19 = hr_api.g_varchar2) then
572: p_rec.attribute19 :=
573: ota_tpm_shd.g_old_rec.attribute19;
574: End If;
575: If (p_rec.attribute20 = hr_api.g_varchar2) then
576: p_rec.attribute20 :=
577: ota_tpm_shd.g_old_rec.attribute20;
578: End If;
579: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

575: If (p_rec.attribute20 = hr_api.g_varchar2) then
576: p_rec.attribute20 :=
577: ota_tpm_shd.g_old_rec.attribute20;
578: End If;
579: If (p_rec.attribute21 = hr_api.g_varchar2) then
580: p_rec.attribute21 :=
581: ota_tpm_shd.g_old_rec.attribute21;
582: End If;
583: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

579: If (p_rec.attribute21 = hr_api.g_varchar2) then
580: p_rec.attribute21 :=
581: ota_tpm_shd.g_old_rec.attribute21;
582: End If;
583: If (p_rec.attribute22 = hr_api.g_varchar2) then
584: p_rec.attribute22 :=
585: ota_tpm_shd.g_old_rec.attribute22;
586: End If;
587: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

583: If (p_rec.attribute22 = hr_api.g_varchar2) then
584: p_rec.attribute22 :=
585: ota_tpm_shd.g_old_rec.attribute22;
586: End If;
587: If (p_rec.attribute23 = hr_api.g_varchar2) then
588: p_rec.attribute23 :=
589: ota_tpm_shd.g_old_rec.attribute23;
590: End If;
591: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

587: If (p_rec.attribute23 = hr_api.g_varchar2) then
588: p_rec.attribute23 :=
589: ota_tpm_shd.g_old_rec.attribute23;
590: End If;
591: If (p_rec.attribute24 = hr_api.g_varchar2) then
592: p_rec.attribute24 :=
593: ota_tpm_shd.g_old_rec.attribute24;
594: End If;
595: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

591: If (p_rec.attribute24 = hr_api.g_varchar2) then
592: p_rec.attribute24 :=
593: ota_tpm_shd.g_old_rec.attribute24;
594: End If;
595: If (p_rec.attribute25 = hr_api.g_varchar2) then
596: p_rec.attribute25 :=
597: ota_tpm_shd.g_old_rec.attribute25;
598: End If;
599: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

595: If (p_rec.attribute25 = hr_api.g_varchar2) then
596: p_rec.attribute25 :=
597: ota_tpm_shd.g_old_rec.attribute25;
598: End If;
599: If (p_rec.attribute26 = hr_api.g_varchar2) then
600: p_rec.attribute26 :=
601: ota_tpm_shd.g_old_rec.attribute26;
602: End If;
603: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

599: If (p_rec.attribute26 = hr_api.g_varchar2) then
600: p_rec.attribute26 :=
601: ota_tpm_shd.g_old_rec.attribute26;
602: End If;
603: If (p_rec.attribute27 = hr_api.g_varchar2) then
604: p_rec.attribute27 :=
605: ota_tpm_shd.g_old_rec.attribute27;
606: End If;
607: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

603: If (p_rec.attribute27 = hr_api.g_varchar2) then
604: p_rec.attribute27 :=
605: ota_tpm_shd.g_old_rec.attribute27;
606: End If;
607: If (p_rec.attribute28 = hr_api.g_varchar2) then
608: p_rec.attribute28 :=
609: ota_tpm_shd.g_old_rec.attribute28;
610: End If;
611: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

607: If (p_rec.attribute28 = hr_api.g_varchar2) then
608: p_rec.attribute28 :=
609: ota_tpm_shd.g_old_rec.attribute28;
610: End If;
611: If (p_rec.attribute29 = hr_api.g_varchar2) then
612: p_rec.attribute29 :=
613: ota_tpm_shd.g_old_rec.attribute29;
614: End If;
615: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

611: If (p_rec.attribute29 = hr_api.g_varchar2) then
612: p_rec.attribute29 :=
613: ota_tpm_shd.g_old_rec.attribute29;
614: End If;
615: If (p_rec.attribute30 = hr_api.g_varchar2) then
616: p_rec.attribute30 :=
617: ota_tpm_shd.g_old_rec.attribute30;
618: End If;
619: If (p_rec.assignment_id = hr_api.g_number) then

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

615: If (p_rec.attribute30 = hr_api.g_varchar2) then
616: p_rec.attribute30 :=
617: ota_tpm_shd.g_old_rec.attribute30;
618: End If;
619: If (p_rec.assignment_id = hr_api.g_number) then
620: p_rec.assignment_id :=
621: ota_tpm_shd.g_old_rec.assignment_id;
622: End If;
623: If (p_rec.source_id = hr_api.g_number) then

Line 623: If (p_rec.source_id = hr_api.g_number) then

619: If (p_rec.assignment_id = hr_api.g_number) then
620: p_rec.assignment_id :=
621: ota_tpm_shd.g_old_rec.assignment_id;
622: End If;
623: If (p_rec.source_id = hr_api.g_number) then
624: p_rec.source_id :=
625: ota_tpm_shd.g_old_rec.source_id;
626: End If;
627: If (p_rec.source_function = hr_api.g_varchar2) then

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

623: If (p_rec.source_id = hr_api.g_number) then
624: p_rec.source_id :=
625: ota_tpm_shd.g_old_rec.source_id;
626: End If;
627: If (p_rec.source_function = hr_api.g_varchar2) then
628: p_rec.source_function :=
629: ota_tpm_shd.g_old_rec.source_function;
630: End If;
631: If (p_rec.cancellation_reason = hr_api.g_varchar2) then

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

627: If (p_rec.source_function = hr_api.g_varchar2) then
628: p_rec.source_function :=
629: ota_tpm_shd.g_old_rec.source_function;
630: End If;
631: If (p_rec.cancellation_reason = hr_api.g_varchar2) then
632: p_rec.cancellation_reason :=
633: ota_tpm_shd.g_old_rec.cancellation_reason;
634: End If;
635: If (p_rec.earliest_start_date = hr_api.g_date) then

Line 635: If (p_rec.earliest_start_date = hr_api.g_date) then

631: If (p_rec.cancellation_reason = hr_api.g_varchar2) then
632: p_rec.cancellation_reason :=
633: ota_tpm_shd.g_old_rec.cancellation_reason;
634: End If;
635: If (p_rec.earliest_start_date = hr_api.g_date) then
636: p_rec.earliest_start_date :=
637: ota_tpm_shd.g_old_rec.earliest_start_date;
638: End If;
639: If (p_rec.creator_person_id = hr_api.g_number) then

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

635: If (p_rec.earliest_start_date = hr_api.g_date) then
636: p_rec.earliest_start_date :=
637: ota_tpm_shd.g_old_rec.earliest_start_date;
638: End If;
639: If (p_rec.creator_person_id = hr_api.g_number) then
640: p_rec.creator_person_id :=
641: ota_tpm_shd.g_old_rec.creator_person_id;
642: End If;
643: --

Line 705: ,p_member_status_type_id in varchar2 default hr_api.g_varchar2

701: Procedure upd
702: (p_effective_date in date
703: ,p_training_plan_member_id in number
704: ,p_object_version_number in out nocopy number
705: ,p_member_status_type_id in varchar2 default hr_api.g_varchar2
706: ,p_activity_version_id in number default hr_api.g_number
707: ,p_activity_definition_id in number default hr_api.g_number
708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 706: ,p_activity_version_id in number default hr_api.g_number

702: (p_effective_date in date
703: ,p_training_plan_member_id in number
704: ,p_object_version_number in out nocopy number
705: ,p_member_status_type_id in varchar2 default hr_api.g_varchar2
706: ,p_activity_version_id in number default hr_api.g_number
707: ,p_activity_definition_id in number default hr_api.g_number
708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 707: ,p_activity_definition_id in number default hr_api.g_number

703: ,p_training_plan_member_id in number
704: ,p_object_version_number in out nocopy number
705: ,p_member_status_type_id in varchar2 default hr_api.g_varchar2
706: ,p_activity_version_id in number default hr_api.g_number
707: ,p_activity_definition_id in number default hr_api.g_number
708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 708: ,p_target_completion_date in date default hr_api.g_date

704: ,p_object_version_number in out nocopy number
705: ,p_member_status_type_id in varchar2 default hr_api.g_varchar2
706: ,p_activity_version_id in number default hr_api.g_number
707: ,p_activity_definition_id in number default hr_api.g_number
708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 709: ,p_attribute_category in varchar2 default hr_api.g_varchar2

705: ,p_member_status_type_id in varchar2 default hr_api.g_varchar2
706: ,p_activity_version_id in number default hr_api.g_number
707: ,p_activity_definition_id in number default hr_api.g_number
708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 710: ,p_attribute1 in varchar2 default hr_api.g_varchar2

706: ,p_activity_version_id in number default hr_api.g_number
707: ,p_activity_definition_id in number default hr_api.g_number
708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 711: ,p_attribute2 in varchar2 default hr_api.g_varchar2

707: ,p_activity_definition_id in number default hr_api.g_number
708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 712: ,p_attribute3 in varchar2 default hr_api.g_varchar2

708: ,p_target_completion_date in date default hr_api.g_date
709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 713: ,p_attribute4 in varchar2 default hr_api.g_varchar2

709: ,p_attribute_category in varchar2 default hr_api.g_varchar2
710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 714: ,p_attribute5 in varchar2 default hr_api.g_varchar2

710: ,p_attribute1 in varchar2 default hr_api.g_varchar2
711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 715: ,p_attribute6 in varchar2 default hr_api.g_varchar2

711: ,p_attribute2 in varchar2 default hr_api.g_varchar2
712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 716: ,p_attribute7 in varchar2 default hr_api.g_varchar2

712: ,p_attribute3 in varchar2 default hr_api.g_varchar2
713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 717: ,p_attribute8 in varchar2 default hr_api.g_varchar2

713: ,p_attribute4 in varchar2 default hr_api.g_varchar2
714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 718: ,p_attribute9 in varchar2 default hr_api.g_varchar2

714: ,p_attribute5 in varchar2 default hr_api.g_varchar2
715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 719: ,p_attribute10 in varchar2 default hr_api.g_varchar2

715: ,p_attribute6 in varchar2 default hr_api.g_varchar2
716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 720: ,p_attribute11 in varchar2 default hr_api.g_varchar2

716: ,p_attribute7 in varchar2 default hr_api.g_varchar2
717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 721: ,p_attribute12 in varchar2 default hr_api.g_varchar2

717: ,p_attribute8 in varchar2 default hr_api.g_varchar2
718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 722: ,p_attribute13 in varchar2 default hr_api.g_varchar2

718: ,p_attribute9 in varchar2 default hr_api.g_varchar2
719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 723: ,p_attribute14 in varchar2 default hr_api.g_varchar2

719: ,p_attribute10 in varchar2 default hr_api.g_varchar2
720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 724: ,p_attribute15 in varchar2 default hr_api.g_varchar2

720: ,p_attribute11 in varchar2 default hr_api.g_varchar2
721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 725: ,p_attribute16 in varchar2 default hr_api.g_varchar2

721: ,p_attribute12 in varchar2 default hr_api.g_varchar2
722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 726: ,p_attribute17 in varchar2 default hr_api.g_varchar2

722: ,p_attribute13 in varchar2 default hr_api.g_varchar2
723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 727: ,p_attribute18 in varchar2 default hr_api.g_varchar2

723: ,p_attribute14 in varchar2 default hr_api.g_varchar2
724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 728: ,p_attribute19 in varchar2 default hr_api.g_varchar2

724: ,p_attribute15 in varchar2 default hr_api.g_varchar2
725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 729: ,p_attribute20 in varchar2 default hr_api.g_varchar2

725: ,p_attribute16 in varchar2 default hr_api.g_varchar2
726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 730: ,p_attribute21 in varchar2 default hr_api.g_varchar2

726: ,p_attribute17 in varchar2 default hr_api.g_varchar2
727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 731: ,p_attribute22 in varchar2 default hr_api.g_varchar2

727: ,p_attribute18 in varchar2 default hr_api.g_varchar2
728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 732: ,p_attribute23 in varchar2 default hr_api.g_varchar2

728: ,p_attribute19 in varchar2 default hr_api.g_varchar2
729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 733: ,p_attribute24 in varchar2 default hr_api.g_varchar2

729: ,p_attribute20 in varchar2 default hr_api.g_varchar2
730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 734: ,p_attribute25 in varchar2 default hr_api.g_varchar2

730: ,p_attribute21 in varchar2 default hr_api.g_varchar2
731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 735: ,p_attribute26 in varchar2 default hr_api.g_varchar2

731: ,p_attribute22 in varchar2 default hr_api.g_varchar2
732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 736: ,p_attribute27 in varchar2 default hr_api.g_varchar2

732: ,p_attribute23 in varchar2 default hr_api.g_varchar2
733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number

Line 737: ,p_attribute28 in varchar2 default hr_api.g_varchar2

733: ,p_attribute24 in varchar2 default hr_api.g_varchar2
734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number

Line 738: ,p_attribute29 in varchar2 default hr_api.g_varchar2

734: ,p_attribute25 in varchar2 default hr_api.g_varchar2
735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2

Line 739: ,p_attribute30 in varchar2 default hr_api.g_varchar2

735: ,p_attribute26 in varchar2 default hr_api.g_varchar2
736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2
743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2

Line 740: ,p_assignment_id in number default hr_api.g_number

736: ,p_attribute27 in varchar2 default hr_api.g_varchar2
737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2
743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2
744: ,P_earliest_start_date in date default hr_api.g_date

Line 741: ,p_source_id in number default hr_api.g_number

737: ,p_attribute28 in varchar2 default hr_api.g_varchar2
738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2
743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2
744: ,P_earliest_start_date in date default hr_api.g_date
745: ,p_creator_person_id in number default hr_api.g_number

Line 742: ,p_source_function in varchar2 default hr_api.g_varchar2

738: ,p_attribute29 in varchar2 default hr_api.g_varchar2
739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2
743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2
744: ,P_earliest_start_date in date default hr_api.g_date
745: ,p_creator_person_id in number default hr_api.g_number
746: ) is

Line 743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2

739: ,p_attribute30 in varchar2 default hr_api.g_varchar2
740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2
743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2
744: ,P_earliest_start_date in date default hr_api.g_date
745: ,p_creator_person_id in number default hr_api.g_number
746: ) is
747: --

Line 744: ,P_earliest_start_date in date default hr_api.g_date

740: ,p_assignment_id in number default hr_api.g_number
741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2
743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2
744: ,P_earliest_start_date in date default hr_api.g_date
745: ,p_creator_person_id in number default hr_api.g_number
746: ) is
747: --
748: l_rec ota_tpm_shd.g_rec_type;

Line 745: ,p_creator_person_id in number default hr_api.g_number

741: ,p_source_id in number default hr_api.g_number
742: ,p_source_function in varchar2 default hr_api.g_varchar2
743: ,p_cancellation_reason in varchar2 default hr_api.g_varchar2
744: ,P_earliest_start_date in date default hr_api.g_date
745: ,p_creator_person_id in number default hr_api.g_number
746: ) is
747: --
748: l_rec ota_tpm_shd.g_rec_type;
749: l_proc varchar2(72) := g_package||'upd';

Line 760: ,hr_api.g_number

756: --
757: l_rec :=
758: ota_tpm_shd.convert_args
759: (p_training_plan_member_id
760: ,hr_api.g_number
761: ,p_activity_version_id
762: ,p_activity_definition_id
763: ,p_member_status_type_id
764: ,p_target_completion_date

Line 765: ,hr_api.g_number

761: ,p_activity_version_id
762: ,p_activity_definition_id
763: ,p_member_status_type_id
764: ,p_target_completion_date
765: ,hr_api.g_number
766: ,p_object_version_number
767: ,p_attribute_category
768: ,p_attribute1
769: ,p_attribute2