120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: EXCEPTION
124: WHEN hr_api.check_integrity_violated THEN
125: -- A check constraint has been violated
126: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
127: ota_tps_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: WHEN hr_api.check_integrity_violated THEN
125: -- A check constraint has been violated
126: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
127: ota_tps_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: WHEN hr_api.parent_integrity_violated THEN
130: -- Parent integrity has been violated
131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
132: ota_tps_shd.constraint_error
125: -- A check constraint has been violated
126: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
127: ota_tps_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: WHEN hr_api.parent_integrity_violated THEN
130: -- Parent integrity has been violated
131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
132: ota_tps_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: WHEN hr_api.parent_integrity_violated THEN
130: -- Parent integrity has been violated
131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
132: ota_tps_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: WHEN hr_api.unique_integrity_violated THEN
135: -- Unique integrity has been violated
136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
137: ota_tps_shd.constraint_error
130: -- Parent integrity has been violated
131: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
132: ota_tps_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: WHEN hr_api.unique_integrity_violated THEN
135: -- Unique integrity has been violated
136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
137: ota_tps_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: WHEN hr_api.unique_integrity_violated THEN
135: -- Unique integrity has been violated
136: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
137: ota_tps_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: WHEN Others THEN
140: ota_tps_shd.g_api_dml := FALSE; -- Unset the api dml status
141: RAISE;
142: END update_dml;
409: );
410: --
411: EXCEPTION
412: --
413: WHEN hr_api.cannot_find_prog_unit THEN
414: --
415: hr_api.cannot_find_prog_unit_error
416: (p_module_name => 'OTA_TRAINING_PLANS'
417: ,p_hook_type => 'AU');
411: EXCEPTION
412: --
413: WHEN hr_api.cannot_find_prog_unit THEN
414: --
415: hr_api.cannot_find_prog_unit_error
416: (p_module_name => 'OTA_TRAINING_PLANS'
417: ,p_hook_type => 'AU');
418: --
419: END;
474: -- p_rec plsql record structure
475: -- to see if a system default is being used. If a system default
476: -- is being used then we must set to the 'current' argument value.
477: --
478: IF (p_rec.training_plan_id = hr_api.g_number) THEN
479: p_rec.training_plan_id :=
480: ota_tps_shd.g_old_rec.training_plan_id;
481: END IF;
482: IF (p_rec.time_period_id = hr_api.g_number) THEN
478: IF (p_rec.training_plan_id = hr_api.g_number) THEN
479: p_rec.training_plan_id :=
480: ota_tps_shd.g_old_rec.training_plan_id;
481: END IF;
482: IF (p_rec.time_period_id = hr_api.g_number) THEN
483: p_rec.time_period_id :=
484: ota_tps_shd.g_old_rec.time_period_id;
485: END IF;
486: IF (p_rec.plan_status_type_id = hr_api.g_varchar2) THEN
482: IF (p_rec.time_period_id = hr_api.g_number) THEN
483: p_rec.time_period_id :=
484: ota_tps_shd.g_old_rec.time_period_id;
485: END IF;
486: IF (p_rec.plan_status_type_id = hr_api.g_varchar2) THEN
487: p_rec.plan_status_type_id :=
488: ota_tps_shd.g_old_rec.plan_status_type_id;
489: END IF;
490: IF (p_rec.organization_id = hr_api.g_number) THEN
486: IF (p_rec.plan_status_type_id = hr_api.g_varchar2) THEN
487: p_rec.plan_status_type_id :=
488: ota_tps_shd.g_old_rec.plan_status_type_id;
489: END IF;
490: IF (p_rec.organization_id = hr_api.g_number) THEN
491: p_rec.organization_id :=
492: ota_tps_shd.g_old_rec.organization_id;
493: END IF;
494: IF (p_rec.person_id = hr_api.g_number) THEN
490: IF (p_rec.organization_id = hr_api.g_number) THEN
491: p_rec.organization_id :=
492: ota_tps_shd.g_old_rec.organization_id;
493: END IF;
494: IF (p_rec.person_id = hr_api.g_number) THEN
495: p_rec.person_id :=
496: ota_tps_shd.g_old_rec.person_id;
497: END IF;
498: IF (p_rec.budget_currency = hr_api.g_varchar2) THEN
494: IF (p_rec.person_id = hr_api.g_number) THEN
495: p_rec.person_id :=
496: ota_tps_shd.g_old_rec.person_id;
497: END IF;
498: IF (p_rec.budget_currency = hr_api.g_varchar2) THEN
499: p_rec.budget_currency :=
500: ota_tps_shd.g_old_rec.budget_currency;
501: END IF;
502: IF (p_rec.name = hr_api.g_varchar2) THEN
498: IF (p_rec.budget_currency = hr_api.g_varchar2) THEN
499: p_rec.budget_currency :=
500: ota_tps_shd.g_old_rec.budget_currency;
501: END IF;
502: IF (p_rec.name = hr_api.g_varchar2) THEN
503: p_rec.name :=
504: ota_tps_shd.g_old_rec.name;
505: END IF;
506: IF (p_rec.description = hr_api.g_varchar2) THEN
502: IF (p_rec.name = hr_api.g_varchar2) THEN
503: p_rec.name :=
504: ota_tps_shd.g_old_rec.name;
505: END IF;
506: IF (p_rec.description = hr_api.g_varchar2) THEN
507: p_rec.description :=
508: ota_tps_shd.g_old_rec.description;
509: END IF;
510: IF (p_rec.business_group_id = hr_api.g_number) THEN
506: IF (p_rec.description = hr_api.g_varchar2) THEN
507: p_rec.description :=
508: ota_tps_shd.g_old_rec.description;
509: END IF;
510: IF (p_rec.business_group_id = hr_api.g_number) THEN
511: p_rec.business_group_id :=
512: ota_tps_shd.g_old_rec.business_group_id;
513: END IF;
514: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
510: IF (p_rec.business_group_id = hr_api.g_number) THEN
511: p_rec.business_group_id :=
512: ota_tps_shd.g_old_rec.business_group_id;
513: END IF;
514: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
515: p_rec.attribute_category :=
516: ota_tps_shd.g_old_rec.attribute_category;
517: END IF;
518: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
514: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
515: p_rec.attribute_category :=
516: ota_tps_shd.g_old_rec.attribute_category;
517: END IF;
518: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
519: p_rec.attribute1 :=
520: ota_tps_shd.g_old_rec.attribute1;
521: END IF;
522: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
518: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
519: p_rec.attribute1 :=
520: ota_tps_shd.g_old_rec.attribute1;
521: END IF;
522: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
523: p_rec.attribute2 :=
524: ota_tps_shd.g_old_rec.attribute2;
525: END IF;
526: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
522: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
523: p_rec.attribute2 :=
524: ota_tps_shd.g_old_rec.attribute2;
525: END IF;
526: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
527: p_rec.attribute3 :=
528: ota_tps_shd.g_old_rec.attribute3;
529: END IF;
530: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
526: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
527: p_rec.attribute3 :=
528: ota_tps_shd.g_old_rec.attribute3;
529: END IF;
530: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
531: p_rec.attribute4 :=
532: ota_tps_shd.g_old_rec.attribute4;
533: END IF;
534: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
530: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
531: p_rec.attribute4 :=
532: ota_tps_shd.g_old_rec.attribute4;
533: END IF;
534: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
535: p_rec.attribute5 :=
536: ota_tps_shd.g_old_rec.attribute5;
537: END IF;
538: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
534: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
535: p_rec.attribute5 :=
536: ota_tps_shd.g_old_rec.attribute5;
537: END IF;
538: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
539: p_rec.attribute6 :=
540: ota_tps_shd.g_old_rec.attribute6;
541: END IF;
542: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
538: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
539: p_rec.attribute6 :=
540: ota_tps_shd.g_old_rec.attribute6;
541: END IF;
542: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
543: p_rec.attribute7 :=
544: ota_tps_shd.g_old_rec.attribute7;
545: END IF;
546: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
542: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
543: p_rec.attribute7 :=
544: ota_tps_shd.g_old_rec.attribute7;
545: END IF;
546: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
547: p_rec.attribute8 :=
548: ota_tps_shd.g_old_rec.attribute8;
549: END IF;
550: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
546: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
547: p_rec.attribute8 :=
548: ota_tps_shd.g_old_rec.attribute8;
549: END IF;
550: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
551: p_rec.attribute9 :=
552: ota_tps_shd.g_old_rec.attribute9;
553: END IF;
554: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
550: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
551: p_rec.attribute9 :=
552: ota_tps_shd.g_old_rec.attribute9;
553: END IF;
554: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
555: p_rec.attribute10 :=
556: ota_tps_shd.g_old_rec.attribute10;
557: END IF;
558: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
554: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
555: p_rec.attribute10 :=
556: ota_tps_shd.g_old_rec.attribute10;
557: END IF;
558: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
559: p_rec.attribute11 :=
560: ota_tps_shd.g_old_rec.attribute11;
561: END IF;
562: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
558: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
559: p_rec.attribute11 :=
560: ota_tps_shd.g_old_rec.attribute11;
561: END IF;
562: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
563: p_rec.attribute12 :=
564: ota_tps_shd.g_old_rec.attribute12;
565: END IF;
566: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
562: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
563: p_rec.attribute12 :=
564: ota_tps_shd.g_old_rec.attribute12;
565: END IF;
566: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
567: p_rec.attribute13 :=
568: ota_tps_shd.g_old_rec.attribute13;
569: END IF;
570: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
566: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
567: p_rec.attribute13 :=
568: ota_tps_shd.g_old_rec.attribute13;
569: END IF;
570: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
571: p_rec.attribute14 :=
572: ota_tps_shd.g_old_rec.attribute14;
573: END IF;
574: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
570: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
571: p_rec.attribute14 :=
572: ota_tps_shd.g_old_rec.attribute14;
573: END IF;
574: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
575: p_rec.attribute15 :=
576: ota_tps_shd.g_old_rec.attribute15;
577: END IF;
578: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
574: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
575: p_rec.attribute15 :=
576: ota_tps_shd.g_old_rec.attribute15;
577: END IF;
578: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
579: p_rec.attribute16 :=
580: ota_tps_shd.g_old_rec.attribute16;
581: END IF;
582: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
578: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
579: p_rec.attribute16 :=
580: ota_tps_shd.g_old_rec.attribute16;
581: END IF;
582: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
583: p_rec.attribute17 :=
584: ota_tps_shd.g_old_rec.attribute17;
585: END IF;
586: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
582: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
583: p_rec.attribute17 :=
584: ota_tps_shd.g_old_rec.attribute17;
585: END IF;
586: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
587: p_rec.attribute18 :=
588: ota_tps_shd.g_old_rec.attribute18;
589: END IF;
590: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
586: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
587: p_rec.attribute18 :=
588: ota_tps_shd.g_old_rec.attribute18;
589: END IF;
590: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
591: p_rec.attribute19 :=
592: ota_tps_shd.g_old_rec.attribute19;
593: END IF;
594: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
590: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
591: p_rec.attribute19 :=
592: ota_tps_shd.g_old_rec.attribute19;
593: END IF;
594: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
595: p_rec.attribute20 :=
596: ota_tps_shd.g_old_rec.attribute20;
597: END IF;
598: IF (p_rec.attribute21 = hr_api.g_varchar2) THEN
594: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
595: p_rec.attribute20 :=
596: ota_tps_shd.g_old_rec.attribute20;
597: END IF;
598: IF (p_rec.attribute21 = hr_api.g_varchar2) THEN
599: p_rec.attribute21 :=
600: ota_tps_shd.g_old_rec.attribute21;
601: END IF;
602: IF (p_rec.attribute22 = hr_api.g_varchar2) THEN
598: IF (p_rec.attribute21 = hr_api.g_varchar2) THEN
599: p_rec.attribute21 :=
600: ota_tps_shd.g_old_rec.attribute21;
601: END IF;
602: IF (p_rec.attribute22 = hr_api.g_varchar2) THEN
603: p_rec.attribute22 :=
604: ota_tps_shd.g_old_rec.attribute22;
605: END IF;
606: IF (p_rec.attribute23 = hr_api.g_varchar2) THEN
602: IF (p_rec.attribute22 = hr_api.g_varchar2) THEN
603: p_rec.attribute22 :=
604: ota_tps_shd.g_old_rec.attribute22;
605: END IF;
606: IF (p_rec.attribute23 = hr_api.g_varchar2) THEN
607: p_rec.attribute23 :=
608: ota_tps_shd.g_old_rec.attribute23;
609: END IF;
610: IF (p_rec.attribute24 = hr_api.g_varchar2) THEN
606: IF (p_rec.attribute23 = hr_api.g_varchar2) THEN
607: p_rec.attribute23 :=
608: ota_tps_shd.g_old_rec.attribute23;
609: END IF;
610: IF (p_rec.attribute24 = hr_api.g_varchar2) THEN
611: p_rec.attribute24 :=
612: ota_tps_shd.g_old_rec.attribute24;
613: END IF;
614: IF (p_rec.attribute25 = hr_api.g_varchar2) THEN
610: IF (p_rec.attribute24 = hr_api.g_varchar2) THEN
611: p_rec.attribute24 :=
612: ota_tps_shd.g_old_rec.attribute24;
613: END IF;
614: IF (p_rec.attribute25 = hr_api.g_varchar2) THEN
615: p_rec.attribute25 :=
616: ota_tps_shd.g_old_rec.attribute25;
617: END IF;
618: IF (p_rec.attribute26 = hr_api.g_varchar2) THEN
614: IF (p_rec.attribute25 = hr_api.g_varchar2) THEN
615: p_rec.attribute25 :=
616: ota_tps_shd.g_old_rec.attribute25;
617: END IF;
618: IF (p_rec.attribute26 = hr_api.g_varchar2) THEN
619: p_rec.attribute26 :=
620: ota_tps_shd.g_old_rec.attribute26;
621: END IF;
622: IF (p_rec.attribute27 = hr_api.g_varchar2) THEN
618: IF (p_rec.attribute26 = hr_api.g_varchar2) THEN
619: p_rec.attribute26 :=
620: ota_tps_shd.g_old_rec.attribute26;
621: END IF;
622: IF (p_rec.attribute27 = hr_api.g_varchar2) THEN
623: p_rec.attribute27 :=
624: ota_tps_shd.g_old_rec.attribute27;
625: END IF;
626: IF (p_rec.attribute28 = hr_api.g_varchar2) THEN
622: IF (p_rec.attribute27 = hr_api.g_varchar2) THEN
623: p_rec.attribute27 :=
624: ota_tps_shd.g_old_rec.attribute27;
625: END IF;
626: IF (p_rec.attribute28 = hr_api.g_varchar2) THEN
627: p_rec.attribute28 :=
628: ota_tps_shd.g_old_rec.attribute28;
629: END IF;
630: IF (p_rec.attribute29 = hr_api.g_varchar2) THEN
626: IF (p_rec.attribute28 = hr_api.g_varchar2) THEN
627: p_rec.attribute28 :=
628: ota_tps_shd.g_old_rec.attribute28;
629: END IF;
630: IF (p_rec.attribute29 = hr_api.g_varchar2) THEN
631: p_rec.attribute29 :=
632: ota_tps_shd.g_old_rec.attribute29;
633: END IF;
634: IF (p_rec.attribute30 = hr_api.g_varchar2) THEN
630: IF (p_rec.attribute29 = hr_api.g_varchar2) THEN
631: p_rec.attribute29 :=
632: ota_tps_shd.g_old_rec.attribute29;
633: END IF;
634: IF (p_rec.attribute30 = hr_api.g_varchar2) THEN
635: p_rec.attribute30 :=
636: ota_tps_shd.g_old_rec.attribute30;
637: END IF;
638: IF (p_rec.plan_source = hr_api.g_varchar2) THEN --cahnged
634: IF (p_rec.attribute30 = hr_api.g_varchar2) THEN
635: p_rec.attribute30 :=
636: ota_tps_shd.g_old_rec.attribute30;
637: END IF;
638: IF (p_rec.plan_source = hr_api.g_varchar2) THEN --cahnged
639: p_rec.plan_source :=
640: ota_tps_shd.g_old_rec.plan_source;
641: END IF;
642: IF (p_rec.start_date = hr_api.g_date) THEN
638: IF (p_rec.plan_source = hr_api.g_varchar2) THEN --cahnged
639: p_rec.plan_source :=
640: ota_tps_shd.g_old_rec.plan_source;
641: END IF;
642: IF (p_rec.start_date = hr_api.g_date) THEN
643: p_rec.start_date :=
644: ota_tps_shd.g_old_rec.start_date;
645: END IF;
646: IF (p_rec.end_date = hr_api.g_date) THEN
642: IF (p_rec.start_date = hr_api.g_date) THEN
643: p_rec.start_date :=
644: ota_tps_shd.g_old_rec.start_date;
645: END IF;
646: IF (p_rec.end_date = hr_api.g_date) THEN
647: p_rec.end_date :=
648: ota_tps_shd.g_old_rec.end_date;
649: END IF;
650: IF (p_rec.creator_person_id = hr_api.g_number) THEN
646: IF (p_rec.end_date = hr_api.g_date) THEN
647: p_rec.end_date :=
648: ota_tps_shd.g_old_rec.end_date;
649: END IF;
650: IF (p_rec.creator_person_id = hr_api.g_number) THEN
651: p_rec.creator_person_id :=
652: ota_tps_shd.g_old_rec.creator_person_id;
653: END IF;
654: IF (p_rec.additional_member_flag = hr_api.g_varchar2) THEN --cahnged
650: IF (p_rec.creator_person_id = hr_api.g_number) THEN
651: p_rec.creator_person_id :=
652: ota_tps_shd.g_old_rec.creator_person_id;
653: END IF;
654: IF (p_rec.additional_member_flag = hr_api.g_varchar2) THEN --cahnged
655: p_rec.additional_member_flag :=
656: ota_tps_shd.g_old_rec.additional_member_flag;
657: END IF;
658: IF (p_rec.learning_path_id = hr_api.g_number) THEN --new
654: IF (p_rec.additional_member_flag = hr_api.g_varchar2) THEN --cahnged
655: p_rec.additional_member_flag :=
656: ota_tps_shd.g_old_rec.additional_member_flag;
657: END IF;
658: IF (p_rec.learning_path_id = hr_api.g_number) THEN --new
659: p_rec.learning_path_id :=
660: ota_tps_shd.g_old_rec.learning_path_id;
661: END IF;
662: IF (p_rec.contact_id = hr_api.g_number) THEN --new
658: IF (p_rec.learning_path_id = hr_api.g_number) THEN --new
659: p_rec.learning_path_id :=
660: ota_tps_shd.g_old_rec.learning_path_id;
661: END IF;
662: IF (p_rec.contact_id = hr_api.g_number) THEN --new
663: p_rec.contact_id :=
664: ota_tps_shd.g_old_rec.contact_id;
665: END IF;
666: --
728: PROCEDURE upd
729: (p_effective_date IN date
730: ,p_training_plan_id IN number
731: ,p_object_version_number IN OUT NOCOPY number
732: ,p_time_period_id IN number DEFAULT hr_api.g_number
733: ,p_plan_status_type_id IN varchar2 DEFAULT hr_api.g_varchar2
734: ,p_budget_currency IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
729: (p_effective_date IN date
730: ,p_training_plan_id IN number
731: ,p_object_version_number IN OUT NOCOPY number
732: ,p_time_period_id IN number DEFAULT hr_api.g_number
733: ,p_plan_status_type_id IN varchar2 DEFAULT hr_api.g_varchar2
734: ,p_budget_currency IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
730: ,p_training_plan_id IN number
731: ,p_object_version_number IN OUT NOCOPY number
732: ,p_time_period_id IN number DEFAULT hr_api.g_number
733: ,p_plan_status_type_id IN varchar2 DEFAULT hr_api.g_varchar2
734: ,p_budget_currency IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
731: ,p_object_version_number IN OUT NOCOPY number
732: ,p_time_period_id IN number DEFAULT hr_api.g_number
733: ,p_plan_status_type_id IN varchar2 DEFAULT hr_api.g_varchar2
734: ,p_budget_currency IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
732: ,p_time_period_id IN number DEFAULT hr_api.g_number
733: ,p_plan_status_type_id IN varchar2 DEFAULT hr_api.g_varchar2
734: ,p_budget_currency IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
733: ,p_plan_status_type_id IN varchar2 DEFAULT hr_api.g_varchar2
734: ,p_budget_currency IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
734: ,p_budget_currency IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
735: ,p_name IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
736: ,p_description IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
737: ,p_attribute_category IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
738: ,p_attribute1 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
739: ,p_attribute2 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
740: ,p_attribute3 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
741: ,p_attribute4 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
742: ,p_attribute5 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
743: ,p_attribute6 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
744: ,p_attribute7 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
745: ,p_attribute8 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
746: ,p_attribute9 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
747: ,p_attribute10 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
748: ,p_attribute11 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
749: ,p_attribute12 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
750: ,p_attribute13 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
751: ,p_attribute14 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
752: ,p_attribute15 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
753: ,p_attribute16 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
754: ,p_attribute17 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
755: ,p_attribute18 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
756: ,p_attribute19 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
757: ,p_attribute20 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
758: ,p_attribute21 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
759: ,p_attribute22 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
760: ,p_attribute23 IN varchar2 DEFAULT hr_api.g_varchar2
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
761: ,p_attribute24 IN varchar2 DEFAULT hr_api.g_varchar2
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
762: ,p_attribute25 IN varchar2 DEFAULT hr_api.g_varchar2
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
763: ,p_attribute26 IN varchar2 DEFAULT hr_api.g_varchar2
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
764: ,p_attribute27 IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
772: ,p_additional_member_flag IN varchar2 DEFAULT hr_api.g_varchar2
765: ,p_attribute28 IN varchar2 DEFAULT hr_api.g_varchar2
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
772: ,p_additional_member_flag IN varchar2 DEFAULT hr_api.g_varchar2
773: ,p_learning_path_id IN number DEFAULT hr_api.g_number
766: ,p_attribute29 IN varchar2 DEFAULT hr_api.g_varchar2
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
772: ,p_additional_member_flag IN varchar2 DEFAULT hr_api.g_varchar2
773: ,p_learning_path_id IN number DEFAULT hr_api.g_number
774: ,p_contact_id IN number DEFAULT hr_api.g_number
767: ,p_attribute30 IN varchar2 DEFAULT hr_api.g_varchar2
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
772: ,p_additional_member_flag IN varchar2 DEFAULT hr_api.g_varchar2
773: ,p_learning_path_id IN number DEFAULT hr_api.g_number
774: ,p_contact_id IN number DEFAULT hr_api.g_number
775: ) IS
768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
772: ,p_additional_member_flag IN varchar2 DEFAULT hr_api.g_varchar2
773: ,p_learning_path_id IN number DEFAULT hr_api.g_number
774: ,p_contact_id IN number DEFAULT hr_api.g_number
775: ) IS
776: --
769: ,p_start_date IN date DEFAULT hr_api.g_date
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
772: ,p_additional_member_flag IN varchar2 DEFAULT hr_api.g_varchar2
773: ,p_learning_path_id IN number DEFAULT hr_api.g_number
774: ,p_contact_id IN number DEFAULT hr_api.g_number
775: ) IS
776: --
777: l_rec ota_tps_shd.g_rec_type;
770: ,p_end_date IN date DEFAULT hr_api.g_date
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number
772: ,p_additional_member_flag IN varchar2 DEFAULT hr_api.g_varchar2
773: ,p_learning_path_id IN number DEFAULT hr_api.g_number
774: ,p_contact_id IN number DEFAULT hr_api.g_number
775: ) IS
776: --
777: l_rec ota_tps_shd.g_rec_type;
778: l_proc varchar2(72) := g_package||'upd';
787: ota_tps_shd.convert_args
788: (p_training_plan_id
789: ,p_time_period_id
790: ,p_plan_status_type_id
791: ,hr_api.g_number
792: ,hr_api.g_number
793: ,p_budget_currency
794: ,p_name
795: ,p_description
788: (p_training_plan_id
789: ,p_time_period_id
790: ,p_plan_status_type_id
791: ,hr_api.g_number
792: ,hr_api.g_number
793: ,p_budget_currency
794: ,p_name
795: ,p_description
796: ,hr_api.g_number
792: ,hr_api.g_number
793: ,p_budget_currency
794: ,p_name
795: ,p_description
796: ,hr_api.g_number
797: ,p_object_version_number
798: ,p_attribute_category
799: ,p_attribute1
800: ,p_attribute2