APPS.OTA_TPS_UPD dependencies on HR_API

Line 124: WHEN hr_api.check_integrity_violated THEN

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));

Line 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

Line 129: WHEN hr_api.parent_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
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 134: WHEN hr_api.unique_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
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 413: WHEN hr_api.cannot_find_prog_unit THEN

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');

Line 415: hr_api.cannot_find_prog_unit_error

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;

Line 478: IF (p_rec.training_plan_id = hr_api.g_number) THEN

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 732: ,p_time_period_id IN number DEFAULT hr_api.g_number

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

Line 733: ,p_plan_status_type_id 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

Line 734: ,p_budget_currency 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

Line 735: ,p_name 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

Line 736: ,p_description 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

Line 737: ,p_attribute_category 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

Line 738: ,p_attribute1 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

Line 739: ,p_attribute2 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

Line 740: ,p_attribute3 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

Line 741: ,p_attribute4 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

Line 742: ,p_attribute5 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

Line 743: ,p_attribute6 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

Line 744: ,p_attribute7 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

Line 745: ,p_attribute8 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

Line 746: ,p_attribute9 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

Line 747: ,p_attribute10 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

Line 748: ,p_attribute11 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

Line 749: ,p_attribute12 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

Line 750: ,p_attribute13 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

Line 751: ,p_attribute14 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

Line 752: ,p_attribute15 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

Line 753: ,p_attribute16 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

Line 754: ,p_attribute17 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

Line 755: ,p_attribute18 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

Line 756: ,p_attribute19 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

Line 757: ,p_attribute20 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

Line 758: ,p_attribute21 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

Line 759: ,p_attribute22 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

Line 760: ,p_attribute23 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

Line 761: ,p_attribute24 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

Line 762: ,p_attribute25 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

Line 763: ,p_attribute26 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

Line 764: ,p_attribute27 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

Line 765: ,p_attribute28 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
769: ,p_start_date IN date DEFAULT hr_api.g_date

Line 766: ,p_attribute29 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
770: ,p_end_date IN date DEFAULT hr_api.g_date

Line 767: ,p_attribute30 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
771: ,p_creator_person_id IN number DEFAULT hr_api.g_number

Line 768: ,p_plan_source IN varchar2 DEFAULT hr_api.g_varchar2 --changed

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

Line 769: ,p_start_date IN date DEFAULT hr_api.g_date

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

Line 770: ,p_end_date IN date DEFAULT hr_api.g_date

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

Line 771: ,p_creator_person_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

Line 772: ,p_additional_member_flag 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
776: --

Line 773: ,p_learning_path_id IN number DEFAULT hr_api.g_number

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;

Line 774: ,p_contact_id IN number DEFAULT hr_api.g_number

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';

Line 791: ,hr_api.g_number

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

Line 792: ,hr_api.g_number

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

Line 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