114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: ota_tmt_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: ota_tmt_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --
126: ota_tmt_shd.constraint_error
119: -- A check constraint has been violated
120: --
121: ota_tmt_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --
126: ota_tmt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --
126: ota_tmt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --
131: ota_tmt_shd.constraint_error
124: -- Parent integrity has been violated
125: --
126: ota_tmt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --
131: ota_tmt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --
131: ota_tmt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: --
135: Raise;
136: End update_dml;
389: );
390: --
391: exception
392: --
393: when hr_api.cannot_find_prog_unit then
394: --
395: hr_api.cannot_find_prog_unit_error
396: (p_module_name => 'OTA_TP_MEASUREMENT_TYPES'
397: ,p_hook_type => 'AU');
391: exception
392: --
393: when hr_api.cannot_find_prog_unit then
394: --
395: hr_api.cannot_find_prog_unit_error
396: (p_module_name => 'OTA_TP_MEASUREMENT_TYPES'
397: ,p_hook_type => 'AU');
398: --
399: end;
454: -- p_rec plsql record structure
455: -- to see if a system default is being used. If a system default
456: -- is being used then we must set to the 'current' argument value.
457: --
458: If (p_rec.tp_measurement_code = hr_api.g_varchar2) then
459: p_rec.tp_measurement_code :=
460: ota_tmt_shd.g_old_rec.tp_measurement_code;
461: End If;
462: If (p_rec.unit = hr_api.g_varchar2) then
458: If (p_rec.tp_measurement_code = hr_api.g_varchar2) then
459: p_rec.tp_measurement_code :=
460: ota_tmt_shd.g_old_rec.tp_measurement_code;
461: End If;
462: If (p_rec.unit = hr_api.g_varchar2) then
463: p_rec.unit :=
464: ota_tmt_shd.g_old_rec.unit;
465: End If;
466: If (p_rec.reporting_sequence = hr_api.g_number) then
462: If (p_rec.unit = hr_api.g_varchar2) then
463: p_rec.unit :=
464: ota_tmt_shd.g_old_rec.unit;
465: End If;
466: If (p_rec.reporting_sequence = hr_api.g_number) then
467: p_rec.reporting_sequence :=
468: ota_tmt_shd.g_old_rec.reporting_sequence;
469: End If;
470: If (p_rec.budget_level = hr_api.g_varchar2) then
466: If (p_rec.reporting_sequence = hr_api.g_number) then
467: p_rec.reporting_sequence :=
468: ota_tmt_shd.g_old_rec.reporting_sequence;
469: End If;
470: If (p_rec.budget_level = hr_api.g_varchar2) then
471: p_rec.budget_level :=
472: ota_tmt_shd.g_old_rec.budget_level;
473: End If;
474: If (p_rec.cost_level = hr_api.g_varchar2) then
470: If (p_rec.budget_level = hr_api.g_varchar2) then
471: p_rec.budget_level :=
472: ota_tmt_shd.g_old_rec.budget_level;
473: End If;
474: If (p_rec.cost_level = hr_api.g_varchar2) then
475: p_rec.cost_level :=
476: ota_tmt_shd.g_old_rec.cost_level;
477: End If;
478: If (p_rec.many_budget_values_flag = hr_api.g_varchar2) then
474: If (p_rec.cost_level = hr_api.g_varchar2) then
475: p_rec.cost_level :=
476: ota_tmt_shd.g_old_rec.cost_level;
477: End If;
478: If (p_rec.many_budget_values_flag = hr_api.g_varchar2) then
479: p_rec.many_budget_values_flag :=
480: ota_tmt_shd.g_old_rec.many_budget_values_flag;
481: End If;
482: If (p_rec.item_type_usage_id = hr_api.g_number) then
478: If (p_rec.many_budget_values_flag = hr_api.g_varchar2) then
479: p_rec.many_budget_values_flag :=
480: ota_tmt_shd.g_old_rec.many_budget_values_flag;
481: End If;
482: If (p_rec.item_type_usage_id = hr_api.g_number) then
483: p_rec.item_type_usage_id :=
484: ota_tmt_shd.g_old_rec.item_type_usage_id;
485: End If;
486: If (p_rec.business_group_id = hr_api.g_number) then
482: If (p_rec.item_type_usage_id = hr_api.g_number) then
483: p_rec.item_type_usage_id :=
484: ota_tmt_shd.g_old_rec.item_type_usage_id;
485: End If;
486: If (p_rec.business_group_id = hr_api.g_number) then
487: p_rec.business_group_id :=
488: ota_tmt_shd.g_old_rec.business_group_id;
489: End If;
490: If (p_rec.attribute_category = hr_api.g_varchar2) then
486: If (p_rec.business_group_id = hr_api.g_number) then
487: p_rec.business_group_id :=
488: ota_tmt_shd.g_old_rec.business_group_id;
489: End If;
490: If (p_rec.attribute_category = hr_api.g_varchar2) then
491: p_rec.attribute_category :=
492: ota_tmt_shd.g_old_rec.attribute_category;
493: End If;
494: If (p_rec.attribute1 = hr_api.g_varchar2) then
490: If (p_rec.attribute_category = hr_api.g_varchar2) then
491: p_rec.attribute_category :=
492: ota_tmt_shd.g_old_rec.attribute_category;
493: End If;
494: If (p_rec.attribute1 = hr_api.g_varchar2) then
495: p_rec.attribute1 :=
496: ota_tmt_shd.g_old_rec.attribute1;
497: End If;
498: If (p_rec.attribute2 = hr_api.g_varchar2) then
494: If (p_rec.attribute1 = hr_api.g_varchar2) then
495: p_rec.attribute1 :=
496: ota_tmt_shd.g_old_rec.attribute1;
497: End If;
498: If (p_rec.attribute2 = hr_api.g_varchar2) then
499: p_rec.attribute2 :=
500: ota_tmt_shd.g_old_rec.attribute2;
501: End If;
502: If (p_rec.attribute3 = hr_api.g_varchar2) then
498: If (p_rec.attribute2 = hr_api.g_varchar2) then
499: p_rec.attribute2 :=
500: ota_tmt_shd.g_old_rec.attribute2;
501: End If;
502: If (p_rec.attribute3 = hr_api.g_varchar2) then
503: p_rec.attribute3 :=
504: ota_tmt_shd.g_old_rec.attribute3;
505: End If;
506: If (p_rec.attribute4 = hr_api.g_varchar2) then
502: If (p_rec.attribute3 = hr_api.g_varchar2) then
503: p_rec.attribute3 :=
504: ota_tmt_shd.g_old_rec.attribute3;
505: End If;
506: If (p_rec.attribute4 = hr_api.g_varchar2) then
507: p_rec.attribute4 :=
508: ota_tmt_shd.g_old_rec.attribute4;
509: End If;
510: If (p_rec.attribute5 = hr_api.g_varchar2) then
506: If (p_rec.attribute4 = hr_api.g_varchar2) then
507: p_rec.attribute4 :=
508: ota_tmt_shd.g_old_rec.attribute4;
509: End If;
510: If (p_rec.attribute5 = hr_api.g_varchar2) then
511: p_rec.attribute5 :=
512: ota_tmt_shd.g_old_rec.attribute5;
513: End If;
514: If (p_rec.attribute6 = hr_api.g_varchar2) then
510: If (p_rec.attribute5 = hr_api.g_varchar2) then
511: p_rec.attribute5 :=
512: ota_tmt_shd.g_old_rec.attribute5;
513: End If;
514: If (p_rec.attribute6 = hr_api.g_varchar2) then
515: p_rec.attribute6 :=
516: ota_tmt_shd.g_old_rec.attribute6;
517: End If;
518: If (p_rec.attribute7 = hr_api.g_varchar2) then
514: If (p_rec.attribute6 = hr_api.g_varchar2) then
515: p_rec.attribute6 :=
516: ota_tmt_shd.g_old_rec.attribute6;
517: End If;
518: If (p_rec.attribute7 = hr_api.g_varchar2) then
519: p_rec.attribute7 :=
520: ota_tmt_shd.g_old_rec.attribute7;
521: End If;
522: If (p_rec.attribute8 = hr_api.g_varchar2) then
518: If (p_rec.attribute7 = hr_api.g_varchar2) then
519: p_rec.attribute7 :=
520: ota_tmt_shd.g_old_rec.attribute7;
521: End If;
522: If (p_rec.attribute8 = hr_api.g_varchar2) then
523: p_rec.attribute8 :=
524: ota_tmt_shd.g_old_rec.attribute8;
525: End If;
526: If (p_rec.attribute9 = hr_api.g_varchar2) then
522: If (p_rec.attribute8 = hr_api.g_varchar2) then
523: p_rec.attribute8 :=
524: ota_tmt_shd.g_old_rec.attribute8;
525: End If;
526: If (p_rec.attribute9 = hr_api.g_varchar2) then
527: p_rec.attribute9 :=
528: ota_tmt_shd.g_old_rec.attribute9;
529: End If;
530: If (p_rec.attribute10 = hr_api.g_varchar2) then
526: If (p_rec.attribute9 = hr_api.g_varchar2) then
527: p_rec.attribute9 :=
528: ota_tmt_shd.g_old_rec.attribute9;
529: End If;
530: If (p_rec.attribute10 = hr_api.g_varchar2) then
531: p_rec.attribute10 :=
532: ota_tmt_shd.g_old_rec.attribute10;
533: End If;
534: If (p_rec.attribute11 = hr_api.g_varchar2) then
530: If (p_rec.attribute10 = hr_api.g_varchar2) then
531: p_rec.attribute10 :=
532: ota_tmt_shd.g_old_rec.attribute10;
533: End If;
534: If (p_rec.attribute11 = hr_api.g_varchar2) then
535: p_rec.attribute11 :=
536: ota_tmt_shd.g_old_rec.attribute11;
537: End If;
538: If (p_rec.attribute12 = hr_api.g_varchar2) then
534: If (p_rec.attribute11 = hr_api.g_varchar2) then
535: p_rec.attribute11 :=
536: ota_tmt_shd.g_old_rec.attribute11;
537: End If;
538: If (p_rec.attribute12 = hr_api.g_varchar2) then
539: p_rec.attribute12 :=
540: ota_tmt_shd.g_old_rec.attribute12;
541: End If;
542: If (p_rec.attribute13 = hr_api.g_varchar2) then
538: If (p_rec.attribute12 = hr_api.g_varchar2) then
539: p_rec.attribute12 :=
540: ota_tmt_shd.g_old_rec.attribute12;
541: End If;
542: If (p_rec.attribute13 = hr_api.g_varchar2) then
543: p_rec.attribute13 :=
544: ota_tmt_shd.g_old_rec.attribute13;
545: End If;
546: If (p_rec.attribute14 = hr_api.g_varchar2) then
542: If (p_rec.attribute13 = hr_api.g_varchar2) then
543: p_rec.attribute13 :=
544: ota_tmt_shd.g_old_rec.attribute13;
545: End If;
546: If (p_rec.attribute14 = hr_api.g_varchar2) then
547: p_rec.attribute14 :=
548: ota_tmt_shd.g_old_rec.attribute14;
549: End If;
550: If (p_rec.attribute15 = hr_api.g_varchar2) then
546: If (p_rec.attribute14 = hr_api.g_varchar2) then
547: p_rec.attribute14 :=
548: ota_tmt_shd.g_old_rec.attribute14;
549: End If;
550: If (p_rec.attribute15 = hr_api.g_varchar2) then
551: p_rec.attribute15 :=
552: ota_tmt_shd.g_old_rec.attribute15;
553: End If;
554: If (p_rec.attribute16 = hr_api.g_varchar2) then
550: If (p_rec.attribute15 = hr_api.g_varchar2) then
551: p_rec.attribute15 :=
552: ota_tmt_shd.g_old_rec.attribute15;
553: End If;
554: If (p_rec.attribute16 = hr_api.g_varchar2) then
555: p_rec.attribute16 :=
556: ota_tmt_shd.g_old_rec.attribute16;
557: End If;
558: If (p_rec.attribute17 = hr_api.g_varchar2) then
554: If (p_rec.attribute16 = hr_api.g_varchar2) then
555: p_rec.attribute16 :=
556: ota_tmt_shd.g_old_rec.attribute16;
557: End If;
558: If (p_rec.attribute17 = hr_api.g_varchar2) then
559: p_rec.attribute17 :=
560: ota_tmt_shd.g_old_rec.attribute17;
561: End If;
562: If (p_rec.attribute18 = hr_api.g_varchar2) then
558: If (p_rec.attribute17 = hr_api.g_varchar2) then
559: p_rec.attribute17 :=
560: ota_tmt_shd.g_old_rec.attribute17;
561: End If;
562: If (p_rec.attribute18 = hr_api.g_varchar2) then
563: p_rec.attribute18 :=
564: ota_tmt_shd.g_old_rec.attribute18;
565: End If;
566: If (p_rec.attribute19 = hr_api.g_varchar2) then
562: If (p_rec.attribute18 = hr_api.g_varchar2) then
563: p_rec.attribute18 :=
564: ota_tmt_shd.g_old_rec.attribute18;
565: End If;
566: If (p_rec.attribute19 = hr_api.g_varchar2) then
567: p_rec.attribute19 :=
568: ota_tmt_shd.g_old_rec.attribute19;
569: End If;
570: If (p_rec.attribute20 = hr_api.g_varchar2) then
566: If (p_rec.attribute19 = hr_api.g_varchar2) then
567: p_rec.attribute19 :=
568: ota_tmt_shd.g_old_rec.attribute19;
569: End If;
570: If (p_rec.attribute20 = hr_api.g_varchar2) then
571: p_rec.attribute20 :=
572: ota_tmt_shd.g_old_rec.attribute20;
573: End If;
574: If (p_rec.attribute21 = hr_api.g_varchar2) then
570: If (p_rec.attribute20 = hr_api.g_varchar2) then
571: p_rec.attribute20 :=
572: ota_tmt_shd.g_old_rec.attribute20;
573: End If;
574: If (p_rec.attribute21 = hr_api.g_varchar2) then
575: p_rec.attribute21 :=
576: ota_tmt_shd.g_old_rec.attribute21;
577: End If;
578: If (p_rec.attribute22 = hr_api.g_varchar2) then
574: If (p_rec.attribute21 = hr_api.g_varchar2) then
575: p_rec.attribute21 :=
576: ota_tmt_shd.g_old_rec.attribute21;
577: End If;
578: If (p_rec.attribute22 = hr_api.g_varchar2) then
579: p_rec.attribute22 :=
580: ota_tmt_shd.g_old_rec.attribute22;
581: End If;
582: If (p_rec.attribute23 = hr_api.g_varchar2) then
578: If (p_rec.attribute22 = hr_api.g_varchar2) then
579: p_rec.attribute22 :=
580: ota_tmt_shd.g_old_rec.attribute22;
581: End If;
582: If (p_rec.attribute23 = hr_api.g_varchar2) then
583: p_rec.attribute23 :=
584: ota_tmt_shd.g_old_rec.attribute23;
585: End If;
586: If (p_rec.attribute24 = hr_api.g_varchar2) then
582: If (p_rec.attribute23 = hr_api.g_varchar2) then
583: p_rec.attribute23 :=
584: ota_tmt_shd.g_old_rec.attribute23;
585: End If;
586: If (p_rec.attribute24 = hr_api.g_varchar2) then
587: p_rec.attribute24 :=
588: ota_tmt_shd.g_old_rec.attribute24;
589: End If;
590: If (p_rec.attribute25 = hr_api.g_varchar2) then
586: If (p_rec.attribute24 = hr_api.g_varchar2) then
587: p_rec.attribute24 :=
588: ota_tmt_shd.g_old_rec.attribute24;
589: End If;
590: If (p_rec.attribute25 = hr_api.g_varchar2) then
591: p_rec.attribute25 :=
592: ota_tmt_shd.g_old_rec.attribute25;
593: End If;
594: If (p_rec.attribute26 = hr_api.g_varchar2) then
590: If (p_rec.attribute25 = hr_api.g_varchar2) then
591: p_rec.attribute25 :=
592: ota_tmt_shd.g_old_rec.attribute25;
593: End If;
594: If (p_rec.attribute26 = hr_api.g_varchar2) then
595: p_rec.attribute26 :=
596: ota_tmt_shd.g_old_rec.attribute26;
597: End If;
598: If (p_rec.attribute27 = hr_api.g_varchar2) then
594: If (p_rec.attribute26 = hr_api.g_varchar2) then
595: p_rec.attribute26 :=
596: ota_tmt_shd.g_old_rec.attribute26;
597: End If;
598: If (p_rec.attribute27 = hr_api.g_varchar2) then
599: p_rec.attribute27 :=
600: ota_tmt_shd.g_old_rec.attribute27;
601: End If;
602: If (p_rec.attribute28 = hr_api.g_varchar2) then
598: If (p_rec.attribute27 = hr_api.g_varchar2) then
599: p_rec.attribute27 :=
600: ota_tmt_shd.g_old_rec.attribute27;
601: End If;
602: If (p_rec.attribute28 = hr_api.g_varchar2) then
603: p_rec.attribute28 :=
604: ota_tmt_shd.g_old_rec.attribute28;
605: End If;
606: If (p_rec.attribute29 = hr_api.g_varchar2) then
602: If (p_rec.attribute28 = hr_api.g_varchar2) then
603: p_rec.attribute28 :=
604: ota_tmt_shd.g_old_rec.attribute28;
605: End If;
606: If (p_rec.attribute29 = hr_api.g_varchar2) then
607: p_rec.attribute29 :=
608: ota_tmt_shd.g_old_rec.attribute29;
609: End If;
610: If (p_rec.attribute30 = hr_api.g_varchar2) then
606: If (p_rec.attribute29 = hr_api.g_varchar2) then
607: p_rec.attribute29 :=
608: ota_tmt_shd.g_old_rec.attribute29;
609: End If;
610: If (p_rec.attribute30 = hr_api.g_varchar2) then
611: p_rec.attribute30 :=
612: ota_tmt_shd.g_old_rec.attribute30;
613: End If;
614: --
668: Procedure upd
669: (p_effective_date in date
670: ,p_tp_measurement_type_id in number
671: ,p_object_version_number in out nocopy number
672: ,p_unit in varchar2 default hr_api.g_varchar2
673: ,p_budget_level in varchar2 default hr_api.g_varchar2
674: ,p_cost_level in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
669: (p_effective_date in date
670: ,p_tp_measurement_type_id in number
671: ,p_object_version_number in out nocopy number
672: ,p_unit in varchar2 default hr_api.g_varchar2
673: ,p_budget_level in varchar2 default hr_api.g_varchar2
674: ,p_cost_level in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
670: ,p_tp_measurement_type_id in number
671: ,p_object_version_number in out nocopy number
672: ,p_unit in varchar2 default hr_api.g_varchar2
673: ,p_budget_level in varchar2 default hr_api.g_varchar2
674: ,p_cost_level in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
671: ,p_object_version_number in out nocopy number
672: ,p_unit in varchar2 default hr_api.g_varchar2
673: ,p_budget_level in varchar2 default hr_api.g_varchar2
674: ,p_cost_level in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
672: ,p_unit in varchar2 default hr_api.g_varchar2
673: ,p_budget_level in varchar2 default hr_api.g_varchar2
674: ,p_cost_level in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
673: ,p_budget_level in varchar2 default hr_api.g_varchar2
674: ,p_cost_level in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
674: ,p_cost_level in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
675: ,p_many_budget_values_flag in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
676: ,p_reporting_sequence in number default hr_api.g_number
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
677: ,p_item_type_usage_id in number default hr_api.g_number
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
678: ,p_attribute_category in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
679: ,p_attribute1 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
680: ,p_attribute2 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
681: ,p_attribute3 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
682: ,p_attribute4 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
683: ,p_attribute5 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
684: ,p_attribute6 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
685: ,p_attribute7 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
686: ,p_attribute8 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
687: ,p_attribute9 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
688: ,p_attribute10 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
689: ,p_attribute11 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
690: ,p_attribute12 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
691: ,p_attribute13 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
692: ,p_attribute14 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
693: ,p_attribute15 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
694: ,p_attribute16 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
695: ,p_attribute17 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
696: ,p_attribute18 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
697: ,p_attribute19 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
698: ,p_attribute20 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
706: ,p_attribute28 in varchar2 default hr_api.g_varchar2
699: ,p_attribute21 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
706: ,p_attribute28 in varchar2 default hr_api.g_varchar2
707: ,p_attribute29 in varchar2 default hr_api.g_varchar2
700: ,p_attribute22 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
706: ,p_attribute28 in varchar2 default hr_api.g_varchar2
707: ,p_attribute29 in varchar2 default hr_api.g_varchar2
708: ,p_attribute30 in varchar2 default hr_api.g_varchar2
701: ,p_attribute23 in varchar2 default hr_api.g_varchar2
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
706: ,p_attribute28 in varchar2 default hr_api.g_varchar2
707: ,p_attribute29 in varchar2 default hr_api.g_varchar2
708: ,p_attribute30 in varchar2 default hr_api.g_varchar2
709: ) is
702: ,p_attribute24 in varchar2 default hr_api.g_varchar2
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
706: ,p_attribute28 in varchar2 default hr_api.g_varchar2
707: ,p_attribute29 in varchar2 default hr_api.g_varchar2
708: ,p_attribute30 in varchar2 default hr_api.g_varchar2
709: ) is
710: --
703: ,p_attribute25 in varchar2 default hr_api.g_varchar2
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
706: ,p_attribute28 in varchar2 default hr_api.g_varchar2
707: ,p_attribute29 in varchar2 default hr_api.g_varchar2
708: ,p_attribute30 in varchar2 default hr_api.g_varchar2
709: ) is
710: --
711: l_rec ota_tmt_shd.g_rec_type;
704: ,p_attribute26 in varchar2 default hr_api.g_varchar2
705: ,p_attribute27 in varchar2 default hr_api.g_varchar2
706: ,p_attribute28 in varchar2 default hr_api.g_varchar2
707: ,p_attribute29 in varchar2 default hr_api.g_varchar2
708: ,p_attribute30 in varchar2 default hr_api.g_varchar2
709: ) is
710: --
711: l_rec ota_tmt_shd.g_rec_type;
712: l_proc varchar2(72) := g_package||'upd';
719: --
720: l_rec :=
721: ota_tmt_shd.convert_args
722: (p_tp_measurement_type_id
723: ,hr_api.g_varchar2
724: ,p_unit
725: ,p_reporting_sequence
726: ,p_budget_level
727: ,p_cost_level
726: ,p_budget_level
727: ,p_cost_level
728: ,p_many_budget_values_flag
729: ,p_item_type_usage_id
730: ,hr_api.g_number
731: ,p_object_version_number
732: ,p_attribute_category
733: ,p_attribute1
734: ,p_attribute2