DBA Data[Home] [Help]

APPS.BEN_PRTT_CLM_GD_R_SVC_TYP_API dependencies on HR_API

Line 347: when hr_api.cannot_find_prog_unit then

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'

Line 348: hr_api.cannot_find_prog_unit_error

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

Line 471: when hr_api.cannot_find_prog_unit then

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

Line 472: hr_api.cannot_find_prog_unit_error

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

Line 486: raise hr_api.validate_enabled;

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

Line 498: when hr_api.validate_enabled then

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

Line 531: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number

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

Line 532: ,p_gd_or_svc_typ_id in number default hr_api.g_number

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

Line 533: ,p_business_group_id in number default hr_api.g_number

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

Line 534: ,p_pcg_attribute_category 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

Line 535: ,p_pcg_attribute1 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

Line 536: ,p_pcg_attribute2 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

Line 537: ,p_pcg_attribute3 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

Line 538: ,p_pcg_attribute4 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

Line 539: ,p_pcg_attribute5 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

Line 540: ,p_pcg_attribute6 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

Line 541: ,p_pcg_attribute7 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

Line 542: ,p_pcg_attribute8 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

Line 543: ,p_pcg_attribute9 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

Line 544: ,p_pcg_attribute10 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

Line 545: ,p_pcg_attribute11 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

Line 546: ,p_pcg_attribute12 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

Line 547: ,p_pcg_attribute13 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

Line 548: ,p_pcg_attribute14 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

Line 549: ,p_pcg_attribute15 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

Line 550: ,p_pcg_attribute16 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

Line 551: ,p_pcg_attribute17 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

Line 552: ,p_pcg_attribute18 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

Line 553: ,p_pcg_attribute19 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

Line 554: ,p_pcg_attribute20 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

Line 555: ,p_pcg_attribute21 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

Line 556: ,p_pcg_attribute22 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

Line 557: ,p_pcg_attribute23 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

Line 558: ,p_pcg_attribute24 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

Line 559: ,p_pcg_attribute25 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

Line 560: ,p_pcg_attribute26 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

Line 561: ,p_pcg_attribute27 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

Line 562: ,p_pcg_attribute28 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
566: ,p_pl_gd_or_svc_id in number default hr_api.g_number

Line 563: ,p_pcg_attribute29 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
567: ,p_effective_date in date default null

Line 564: ,p_pcg_attribute30 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
568: ) is

Line 566: ,p_pl_gd_or_svc_id in number default hr_api.g_number

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

Line 646: when hr_api.cannot_find_prog_unit then

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

Line 647: hr_api.cannot_find_prog_unit_error

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

Line 770: when hr_api.cannot_find_prog_unit then

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

Line 771: hr_api.cannot_find_prog_unit_error

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

Line 785: raise hr_api.validate_enabled;

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

Line 796: when hr_api.validate_enabled then

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

Line 859: when hr_api.cannot_find_prog_unit then

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

Line 860: hr_api.cannot_find_prog_unit_error

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

Line 888: when hr_api.cannot_find_prog_unit then

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

Line 889: hr_api.cannot_find_prog_unit_error

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

Line 903: raise hr_api.validate_enabled;

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

Line 910: when hr_api.validate_enabled then

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