343: ,p_pcg_attribute30 => p_pcg_attribute30
344: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (
350: p_module_name => 'CREATE_PRTT_CLM_GD_R_SVC_TYP'
351: ,p_hook_type => 'BP'
344: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (
350: p_module_name => 'CREATE_PRTT_CLM_GD_R_SVC_TYP'
351: ,p_hook_type => 'BP'
352: );
467: ,p_object_version_number => l_object_version_number
468: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
469: );
470: exception
471: when hr_api.cannot_find_prog_unit then
472: hr_api.cannot_find_prog_unit_error
473: (p_module_name => 'CREATE_PRTT_CLM_GD_R_SVC_TYP'
474: ,p_hook_type => 'AP'
475: );
468: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
469: );
470: exception
471: when hr_api.cannot_find_prog_unit then
472: hr_api.cannot_find_prog_unit_error
473: (p_module_name => 'CREATE_PRTT_CLM_GD_R_SVC_TYP'
474: ,p_hook_type => 'AP'
475: );
476: --
482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --
485: if p_validate then
486: raise hr_api.validate_enabled;
487: end if;
488: --
489: -- Set all output arguments
490: --
494: hr_utility.set_location(' Leaving:'||l_proc, 70);
495: --
496: exception
497: --
498: when hr_api.validate_enabled then
499: --
500: -- As the Validate_Enabled exception has been raised
501: -- we must rollback to the savepoint
502: --
527: --
528: procedure update_PRTT_CLM_GD_R_SVC_TYP
529: (p_validate in boolean default false
530: ,p_prtt_clm_gd_or_svc_typ_id in number
531: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
532: ,p_gd_or_svc_typ_id in number default hr_api.g_number
533: ,p_business_group_id in number default hr_api.g_number
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
528: procedure update_PRTT_CLM_GD_R_SVC_TYP
529: (p_validate in boolean default false
530: ,p_prtt_clm_gd_or_svc_typ_id in number
531: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
532: ,p_gd_or_svc_typ_id in number default hr_api.g_number
533: ,p_business_group_id in number default hr_api.g_number
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
529: (p_validate in boolean default false
530: ,p_prtt_clm_gd_or_svc_typ_id in number
531: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
532: ,p_gd_or_svc_typ_id in number default hr_api.g_number
533: ,p_business_group_id in number default hr_api.g_number
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
530: ,p_prtt_clm_gd_or_svc_typ_id in number
531: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
532: ,p_gd_or_svc_typ_id in number default hr_api.g_number
533: ,p_business_group_id in number default hr_api.g_number
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
531: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
532: ,p_gd_or_svc_typ_id in number default hr_api.g_number
533: ,p_business_group_id in number default hr_api.g_number
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
532: ,p_gd_or_svc_typ_id in number default hr_api.g_number
533: ,p_business_group_id in number default hr_api.g_number
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
533: ,p_business_group_id in number default hr_api.g_number
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
534: ,p_pcg_attribute_category in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
535: ,p_pcg_attribute1 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
536: ,p_pcg_attribute2 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
537: ,p_pcg_attribute3 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
538: ,p_pcg_attribute4 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
539: ,p_pcg_attribute5 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
540: ,p_pcg_attribute6 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
541: ,p_pcg_attribute7 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
542: ,p_pcg_attribute8 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
543: ,p_pcg_attribute9 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
544: ,p_pcg_attribute10 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
545: ,p_pcg_attribute11 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
546: ,p_pcg_attribute12 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
547: ,p_pcg_attribute13 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
548: ,p_pcg_attribute14 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
549: ,p_pcg_attribute15 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
550: ,p_pcg_attribute16 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
551: ,p_pcg_attribute17 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
552: ,p_pcg_attribute18 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
553: ,p_pcg_attribute19 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
554: ,p_pcg_attribute20 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
555: ,p_pcg_attribute21 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
563: ,p_pcg_attribute29 in varchar2 default hr_api.g_varchar2
556: ,p_pcg_attribute22 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
563: ,p_pcg_attribute29 in varchar2 default hr_api.g_varchar2
564: ,p_pcg_attribute30 in varchar2 default hr_api.g_varchar2
557: ,p_pcg_attribute23 in varchar2 default hr_api.g_varchar2
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
563: ,p_pcg_attribute29 in varchar2 default hr_api.g_varchar2
564: ,p_pcg_attribute30 in varchar2 default hr_api.g_varchar2
565: ,p_object_version_number in out nocopy number
558: ,p_pcg_attribute24 in varchar2 default hr_api.g_varchar2
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
563: ,p_pcg_attribute29 in varchar2 default hr_api.g_varchar2
564: ,p_pcg_attribute30 in varchar2 default hr_api.g_varchar2
565: ,p_object_version_number in out nocopy number
566: ,p_pl_gd_or_svc_id in number default hr_api.g_number
559: ,p_pcg_attribute25 in varchar2 default hr_api.g_varchar2
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
563: ,p_pcg_attribute29 in varchar2 default hr_api.g_varchar2
564: ,p_pcg_attribute30 in varchar2 default hr_api.g_varchar2
565: ,p_object_version_number in out nocopy number
566: ,p_pl_gd_or_svc_id in number default hr_api.g_number
567: ,p_effective_date in date default null
560: ,p_pcg_attribute26 in varchar2 default hr_api.g_varchar2
561: ,p_pcg_attribute27 in varchar2 default hr_api.g_varchar2
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
563: ,p_pcg_attribute29 in varchar2 default hr_api.g_varchar2
564: ,p_pcg_attribute30 in varchar2 default hr_api.g_varchar2
565: ,p_object_version_number in out nocopy number
566: ,p_pl_gd_or_svc_id in number default hr_api.g_number
567: ,p_effective_date in date default null
568: ) is
562: ,p_pcg_attribute28 in varchar2 default hr_api.g_varchar2
563: ,p_pcg_attribute29 in varchar2 default hr_api.g_varchar2
564: ,p_pcg_attribute30 in varchar2 default hr_api.g_varchar2
565: ,p_object_version_number in out nocopy number
566: ,p_pl_gd_or_svc_id in number default hr_api.g_number
567: ,p_effective_date in date default null
568: ) is
569: --
570: -- Declare cursors and local variables
642: ,p_object_version_number => p_object_version_number
643: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
644: );
645: exception
646: when hr_api.cannot_find_prog_unit then
647: hr_api.cannot_find_prog_unit_error
648: (p_module_name => 'UPDATE_PRTT_CLM_GD_R_SVC_TYP'
649: ,p_hook_type => 'BP'
650: );
643: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
644: );
645: exception
646: when hr_api.cannot_find_prog_unit then
647: hr_api.cannot_find_prog_unit_error
648: (p_module_name => 'UPDATE_PRTT_CLM_GD_R_SVC_TYP'
649: ,p_hook_type => 'BP'
650: );
651: --
766: ,p_object_version_number => l_object_version_number
767: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
768: );
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'UPDATE_PRTT_CLM_GD_R_SVC_TYP'
773: ,p_hook_type => 'AP'
774: );
767: ,p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
768: );
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'UPDATE_PRTT_CLM_GD_R_SVC_TYP'
773: ,p_hook_type => 'AP'
774: );
775: --
781: --
782: -- When in validation only mode raise the Validate_Enabled exception
783: --
784: if p_validate then
785: raise hr_api.validate_enabled;
786: end if;
787: --
788: -- Set all output arguments
789: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: --
794: exception
795: --
796: when hr_api.validate_enabled then
797: --
798: -- As the Validate_Enabled exception has been raised
799: -- we must rollback to the savepoint
800: --
855: p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id
856: ,p_object_version_number => p_object_version_number
857: );
858: exception
859: when hr_api.cannot_find_prog_unit then
860: hr_api.cannot_find_prog_unit_error
861: (p_module_name => 'DELETE_PRTT_CLM_GD_R_SVC_TYP'
862: ,p_hook_type => 'BP'
863: );
856: ,p_object_version_number => p_object_version_number
857: );
858: exception
859: when hr_api.cannot_find_prog_unit then
860: hr_api.cannot_find_prog_unit_error
861: (p_module_name => 'DELETE_PRTT_CLM_GD_R_SVC_TYP'
862: ,p_hook_type => 'BP'
863: );
864: --
884: p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id
885: ,p_object_version_number => l_object_version_number
886: );
887: exception
888: when hr_api.cannot_find_prog_unit then
889: hr_api.cannot_find_prog_unit_error
890: (p_module_name => 'DELETE_PRTT_CLM_GD_R_SVC_TYP'
891: ,p_hook_type => 'AP'
892: );
885: ,p_object_version_number => l_object_version_number
886: );
887: exception
888: when hr_api.cannot_find_prog_unit then
889: hr_api.cannot_find_prog_unit_error
890: (p_module_name => 'DELETE_PRTT_CLM_GD_R_SVC_TYP'
891: ,p_hook_type => 'AP'
892: );
893: --
899: --
900: -- When in validation only mode raise the Validate_Enabled exception
901: --
902: if p_validate then
903: raise hr_api.validate_enabled;
904: end if;
905: --
906: hr_utility.set_location(' Leaving:'||l_proc, 70);
907: --
906: hr_utility.set_location(' Leaving:'||l_proc, 70);
907: --
908: exception
909: --
910: when hr_api.validate_enabled then
911: --
912: -- As the Validate_Enabled exception has been raised
913: -- we must rollback to the savepoint
914: --