APPS.BEN_PCP_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_shd.constraint_error

Line 129: When hr_api.parent_integrity_violated Then

125: -- A check constraint has been violated
126: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
127: ben_pcp_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error

Line 134: When hr_api.unique_integrity_violated Then

130: -- Parent integrity has been violated
131: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
132: ben_pcp_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_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: ben_pcp_shd.g_api_dml := false; -- Unset the api dml status
137: ben_pcp_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: ben_pcp_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 => 'BEN_PL_PCP'
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 => 'BEN_PL_PCP'
417: ,p_hook_type => 'AU');
418: --
419: end;

Line 478: If (p_rec.pl_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.pl_id = hr_api.g_number) then
479: p_rec.pl_id :=
480: ben_pcp_shd.g_old_rec.pl_id;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then

Line 482: If (p_rec.business_group_id = hr_api.g_number) then

478: If (p_rec.pl_id = hr_api.g_number) then
479: p_rec.pl_id :=
480: ben_pcp_shd.g_old_rec.pl_id;
481: End If;
482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: ben_pcp_shd.g_old_rec.business_group_id;
485: End If;
486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then

Line 486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then

482: If (p_rec.business_group_id = hr_api.g_number) then
483: p_rec.business_group_id :=
484: ben_pcp_shd.g_old_rec.business_group_id;
485: End If;
486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then
487: p_rec.pcp_strt_dt_cd :=
488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;
489: End If;
490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then

Line 490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then

486: If (p_rec.pcp_strt_dt_cd = hr_api.g_varchar2) then
487: p_rec.pcp_strt_dt_cd :=
488: ben_pcp_shd.g_old_rec.pcp_strt_dt_cd;
489: End If;
490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then
491: p_rec.pcp_dsgn_cd :=
492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;
493: End If;
494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then

Line 494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then

490: If (p_rec.pcp_dsgn_cd = hr_api.g_varchar2) then
491: p_rec.pcp_dsgn_cd :=
492: ben_pcp_shd.g_old_rec.pcp_dsgn_cd;
493: End If;
494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then
495: p_rec.pcp_dpnt_dsgn_cd :=
496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;
497: End If;
498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then

Line 498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then

494: If (p_rec.pcp_dpnt_dsgn_cd = hr_api.g_varchar2) then
495: p_rec.pcp_dpnt_dsgn_cd :=
496: ben_pcp_shd.g_old_rec.pcp_dpnt_dsgn_cd;
497: End If;
498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then
499: p_rec.pcp_rpstry_flag :=
500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;
501: End If;
502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then

Line 502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then

498: If (p_rec.pcp_rpstry_flag = hr_api.g_varchar2) then
499: p_rec.pcp_rpstry_flag :=
500: ben_pcp_shd.g_old_rec.pcp_rpstry_flag;
501: End If;
502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then
503: p_rec.pcp_can_keep_flag :=
504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;
505: End If;
506: If (p_rec.pcp_radius = hr_api.g_number) then

Line 506: If (p_rec.pcp_radius = hr_api.g_number) then

502: If (p_rec.pcp_can_keep_flag = hr_api.g_varchar2) then
503: p_rec.pcp_can_keep_flag :=
504: ben_pcp_shd.g_old_rec.pcp_can_keep_flag;
505: End If;
506: If (p_rec.pcp_radius = hr_api.g_number) then
507: p_rec.pcp_radius :=
508: ben_pcp_shd.g_old_rec.pcp_radius;
509: End If;
510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then

Line 510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then

506: If (p_rec.pcp_radius = hr_api.g_number) then
507: p_rec.pcp_radius :=
508: ben_pcp_shd.g_old_rec.pcp_radius;
509: End If;
510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then
511: p_rec.pcp_radius_uom :=
512: ben_pcp_shd.g_old_rec.pcp_radius_uom;
513: End If;
514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then

Line 514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then

510: If (p_rec.pcp_radius_uom = hr_api.g_varchar2) then
511: p_rec.pcp_radius_uom :=
512: ben_pcp_shd.g_old_rec.pcp_radius_uom;
513: End If;
514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then
515: p_rec.pcp_radius_warn_flag :=
516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;
517: End If;
518: If (p_rec.pcp_num_chgs = hr_api.g_number) then

Line 518: If (p_rec.pcp_num_chgs = hr_api.g_number) then

514: If (p_rec.pcp_radius_warn_flag = hr_api.g_varchar2) then
515: p_rec.pcp_radius_warn_flag :=
516: ben_pcp_shd.g_old_rec.pcp_radius_warn_flag;
517: End If;
518: If (p_rec.pcp_num_chgs = hr_api.g_number) then
519: p_rec.pcp_num_chgs :=
520: ben_pcp_shd.g_old_rec.pcp_num_chgs;
521: End If;
522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then

Line 522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then

518: If (p_rec.pcp_num_chgs = hr_api.g_number) then
519: p_rec.pcp_num_chgs :=
520: ben_pcp_shd.g_old_rec.pcp_num_chgs;
521: End If;
522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then
523: p_rec.pcp_num_chgs_uom :=
524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;
525: End If;
526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then

Line 526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then

522: If (p_rec.pcp_num_chgs_uom = hr_api.g_varchar2) then
523: p_rec.pcp_num_chgs_uom :=
524: ben_pcp_shd.g_old_rec.pcp_num_chgs_uom;
525: End If;
526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then
527: p_rec.pcp_attribute_category :=
528: ben_pcp_shd.g_old_rec.pcp_attribute_category;
529: End If;
530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then

Line 530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then

526: If (p_rec.pcp_attribute_category = hr_api.g_varchar2) then
527: p_rec.pcp_attribute_category :=
528: ben_pcp_shd.g_old_rec.pcp_attribute_category;
529: End If;
530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then
531: p_rec.pcp_attribute1 :=
532: ben_pcp_shd.g_old_rec.pcp_attribute1;
533: End If;
534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then

Line 534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then

530: If (p_rec.pcp_attribute1 = hr_api.g_varchar2) then
531: p_rec.pcp_attribute1 :=
532: ben_pcp_shd.g_old_rec.pcp_attribute1;
533: End If;
534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then
535: p_rec.pcp_attribute2 :=
536: ben_pcp_shd.g_old_rec.pcp_attribute2;
537: End If;
538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then

Line 538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then

534: If (p_rec.pcp_attribute2 = hr_api.g_varchar2) then
535: p_rec.pcp_attribute2 :=
536: ben_pcp_shd.g_old_rec.pcp_attribute2;
537: End If;
538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then
539: p_rec.pcp_attribute3 :=
540: ben_pcp_shd.g_old_rec.pcp_attribute3;
541: End If;
542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then

Line 542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then

538: If (p_rec.pcp_attribute3 = hr_api.g_varchar2) then
539: p_rec.pcp_attribute3 :=
540: ben_pcp_shd.g_old_rec.pcp_attribute3;
541: End If;
542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then
543: p_rec.pcp_attribute4 :=
544: ben_pcp_shd.g_old_rec.pcp_attribute4;
545: End If;
546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then

Line 546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then

542: If (p_rec.pcp_attribute4 = hr_api.g_varchar2) then
543: p_rec.pcp_attribute4 :=
544: ben_pcp_shd.g_old_rec.pcp_attribute4;
545: End If;
546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then
547: p_rec.pcp_attribute5 :=
548: ben_pcp_shd.g_old_rec.pcp_attribute5;
549: End If;
550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then

Line 550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then

546: If (p_rec.pcp_attribute5 = hr_api.g_varchar2) then
547: p_rec.pcp_attribute5 :=
548: ben_pcp_shd.g_old_rec.pcp_attribute5;
549: End If;
550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then
551: p_rec.pcp_attribute6 :=
552: ben_pcp_shd.g_old_rec.pcp_attribute6;
553: End If;
554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then

Line 554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then

550: If (p_rec.pcp_attribute6 = hr_api.g_varchar2) then
551: p_rec.pcp_attribute6 :=
552: ben_pcp_shd.g_old_rec.pcp_attribute6;
553: End If;
554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then
555: p_rec.pcp_attribute7 :=
556: ben_pcp_shd.g_old_rec.pcp_attribute7;
557: End If;
558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then

Line 558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then

554: If (p_rec.pcp_attribute7 = hr_api.g_varchar2) then
555: p_rec.pcp_attribute7 :=
556: ben_pcp_shd.g_old_rec.pcp_attribute7;
557: End If;
558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then
559: p_rec.pcp_attribute8 :=
560: ben_pcp_shd.g_old_rec.pcp_attribute8;
561: End If;
562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then

Line 562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then

558: If (p_rec.pcp_attribute8 = hr_api.g_varchar2) then
559: p_rec.pcp_attribute8 :=
560: ben_pcp_shd.g_old_rec.pcp_attribute8;
561: End If;
562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then
563: p_rec.pcp_attribute9 :=
564: ben_pcp_shd.g_old_rec.pcp_attribute9;
565: End If;
566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then

Line 566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then

562: If (p_rec.pcp_attribute9 = hr_api.g_varchar2) then
563: p_rec.pcp_attribute9 :=
564: ben_pcp_shd.g_old_rec.pcp_attribute9;
565: End If;
566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then
567: p_rec.pcp_attribute10 :=
568: ben_pcp_shd.g_old_rec.pcp_attribute10;
569: End If;
570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then

Line 570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then

566: If (p_rec.pcp_attribute10 = hr_api.g_varchar2) then
567: p_rec.pcp_attribute10 :=
568: ben_pcp_shd.g_old_rec.pcp_attribute10;
569: End If;
570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then
571: p_rec.pcp_attribute11 :=
572: ben_pcp_shd.g_old_rec.pcp_attribute11;
573: End If;
574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then

Line 574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then

570: If (p_rec.pcp_attribute11 = hr_api.g_varchar2) then
571: p_rec.pcp_attribute11 :=
572: ben_pcp_shd.g_old_rec.pcp_attribute11;
573: End If;
574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then
575: p_rec.pcp_attribute12 :=
576: ben_pcp_shd.g_old_rec.pcp_attribute12;
577: End If;
578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then

Line 578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then

574: If (p_rec.pcp_attribute12 = hr_api.g_varchar2) then
575: p_rec.pcp_attribute12 :=
576: ben_pcp_shd.g_old_rec.pcp_attribute12;
577: End If;
578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then
579: p_rec.pcp_attribute13 :=
580: ben_pcp_shd.g_old_rec.pcp_attribute13;
581: End If;
582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then

Line 582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then

578: If (p_rec.pcp_attribute13 = hr_api.g_varchar2) then
579: p_rec.pcp_attribute13 :=
580: ben_pcp_shd.g_old_rec.pcp_attribute13;
581: End If;
582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then
583: p_rec.pcp_attribute14 :=
584: ben_pcp_shd.g_old_rec.pcp_attribute14;
585: End If;
586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then

Line 586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then

582: If (p_rec.pcp_attribute14 = hr_api.g_varchar2) then
583: p_rec.pcp_attribute14 :=
584: ben_pcp_shd.g_old_rec.pcp_attribute14;
585: End If;
586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then
587: p_rec.pcp_attribute15 :=
588: ben_pcp_shd.g_old_rec.pcp_attribute15;
589: End If;
590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then

Line 590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then

586: If (p_rec.pcp_attribute15 = hr_api.g_varchar2) then
587: p_rec.pcp_attribute15 :=
588: ben_pcp_shd.g_old_rec.pcp_attribute15;
589: End If;
590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then
591: p_rec.pcp_attribute16 :=
592: ben_pcp_shd.g_old_rec.pcp_attribute16;
593: End If;
594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then

Line 594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then

590: If (p_rec.pcp_attribute16 = hr_api.g_varchar2) then
591: p_rec.pcp_attribute16 :=
592: ben_pcp_shd.g_old_rec.pcp_attribute16;
593: End If;
594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then
595: p_rec.pcp_attribute17 :=
596: ben_pcp_shd.g_old_rec.pcp_attribute17;
597: End If;
598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then

Line 598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then

594: If (p_rec.pcp_attribute17 = hr_api.g_varchar2) then
595: p_rec.pcp_attribute17 :=
596: ben_pcp_shd.g_old_rec.pcp_attribute17;
597: End If;
598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then
599: p_rec.pcp_attribute18 :=
600: ben_pcp_shd.g_old_rec.pcp_attribute18;
601: End If;
602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then

Line 602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then

598: If (p_rec.pcp_attribute18 = hr_api.g_varchar2) then
599: p_rec.pcp_attribute18 :=
600: ben_pcp_shd.g_old_rec.pcp_attribute18;
601: End If;
602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then
603: p_rec.pcp_attribute19 :=
604: ben_pcp_shd.g_old_rec.pcp_attribute19;
605: End If;
606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then

Line 606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then

602: If (p_rec.pcp_attribute19 = hr_api.g_varchar2) then
603: p_rec.pcp_attribute19 :=
604: ben_pcp_shd.g_old_rec.pcp_attribute19;
605: End If;
606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then
607: p_rec.pcp_attribute20 :=
608: ben_pcp_shd.g_old_rec.pcp_attribute20;
609: End If;
610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then

Line 610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then

606: If (p_rec.pcp_attribute20 = hr_api.g_varchar2) then
607: p_rec.pcp_attribute20 :=
608: ben_pcp_shd.g_old_rec.pcp_attribute20;
609: End If;
610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then
611: p_rec.pcp_attribute21 :=
612: ben_pcp_shd.g_old_rec.pcp_attribute21;
613: End If;
614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then

Line 614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then

610: If (p_rec.pcp_attribute21 = hr_api.g_varchar2) then
611: p_rec.pcp_attribute21 :=
612: ben_pcp_shd.g_old_rec.pcp_attribute21;
613: End If;
614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then
615: p_rec.pcp_attribute22 :=
616: ben_pcp_shd.g_old_rec.pcp_attribute22;
617: End If;
618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then

Line 618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then

614: If (p_rec.pcp_attribute22 = hr_api.g_varchar2) then
615: p_rec.pcp_attribute22 :=
616: ben_pcp_shd.g_old_rec.pcp_attribute22;
617: End If;
618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then
619: p_rec.pcp_attribute23 :=
620: ben_pcp_shd.g_old_rec.pcp_attribute23;
621: End If;
622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then

Line 622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then

618: If (p_rec.pcp_attribute23 = hr_api.g_varchar2) then
619: p_rec.pcp_attribute23 :=
620: ben_pcp_shd.g_old_rec.pcp_attribute23;
621: End If;
622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then
623: p_rec.pcp_attribute24 :=
624: ben_pcp_shd.g_old_rec.pcp_attribute24;
625: End If;
626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then

Line 626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then

622: If (p_rec.pcp_attribute24 = hr_api.g_varchar2) then
623: p_rec.pcp_attribute24 :=
624: ben_pcp_shd.g_old_rec.pcp_attribute24;
625: End If;
626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then
627: p_rec.pcp_attribute25 :=
628: ben_pcp_shd.g_old_rec.pcp_attribute25;
629: End If;
630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then

Line 630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then

626: If (p_rec.pcp_attribute25 = hr_api.g_varchar2) then
627: p_rec.pcp_attribute25 :=
628: ben_pcp_shd.g_old_rec.pcp_attribute25;
629: End If;
630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then
631: p_rec.pcp_attribute26 :=
632: ben_pcp_shd.g_old_rec.pcp_attribute26;
633: End If;
634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then

Line 634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then

630: If (p_rec.pcp_attribute26 = hr_api.g_varchar2) then
631: p_rec.pcp_attribute26 :=
632: ben_pcp_shd.g_old_rec.pcp_attribute26;
633: End If;
634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then
635: p_rec.pcp_attribute27 :=
636: ben_pcp_shd.g_old_rec.pcp_attribute27;
637: End If;
638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then

Line 638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then

634: If (p_rec.pcp_attribute27 = hr_api.g_varchar2) then
635: p_rec.pcp_attribute27 :=
636: ben_pcp_shd.g_old_rec.pcp_attribute27;
637: End If;
638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then
639: p_rec.pcp_attribute28 :=
640: ben_pcp_shd.g_old_rec.pcp_attribute28;
641: End If;
642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then

Line 642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then

638: If (p_rec.pcp_attribute28 = hr_api.g_varchar2) then
639: p_rec.pcp_attribute28 :=
640: ben_pcp_shd.g_old_rec.pcp_attribute28;
641: End If;
642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then
643: p_rec.pcp_attribute29 :=
644: ben_pcp_shd.g_old_rec.pcp_attribute29;
645: End If;
646: If (p_rec.pcp_attribute30 = hr_api.g_varchar2) then

Line 646: If (p_rec.pcp_attribute30 = hr_api.g_varchar2) then

642: If (p_rec.pcp_attribute29 = hr_api.g_varchar2) then
643: p_rec.pcp_attribute29 :=
644: ben_pcp_shd.g_old_rec.pcp_attribute29;
645: End If;
646: If (p_rec.pcp_attribute30 = hr_api.g_varchar2) then
647: p_rec.pcp_attribute30 :=
648: ben_pcp_shd.g_old_rec.pcp_attribute30;
649: End If;
650: --

Line 706: ,p_pl_id in number default hr_api.g_number

702: Procedure upd
703: (p_effective_date in date
704: ,p_pl_pcp_id in number
705: ,p_object_version_number in out nocopy number
706: ,p_pl_id in number default hr_api.g_number
707: ,p_business_group_id in number default hr_api.g_number
708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2
709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2

Line 707: ,p_business_group_id in number default hr_api.g_number

703: (p_effective_date in date
704: ,p_pl_pcp_id in number
705: ,p_object_version_number in out nocopy number
706: ,p_pl_id in number default hr_api.g_number
707: ,p_business_group_id in number default hr_api.g_number
708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2
709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2

Line 708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2

704: ,p_pl_pcp_id in number
705: ,p_object_version_number in out nocopy number
706: ,p_pl_id in number default hr_api.g_number
707: ,p_business_group_id in number default hr_api.g_number
708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2
709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2

705: ,p_object_version_number in out nocopy number
706: ,p_pl_id in number default hr_api.g_number
707: ,p_business_group_id in number default hr_api.g_number
708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2
709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2

706: ,p_pl_id in number default hr_api.g_number
707: ,p_business_group_id in number default hr_api.g_number
708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2
709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number

Line 711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2

707: ,p_business_group_id in number default hr_api.g_number
708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2
709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2

Line 712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2

708: ,p_pcp_rpstry_flag in varchar2 default hr_api.g_varchar2
709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number

Line 713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

709: ,p_pcp_can_keep_flag in varchar2 default hr_api.g_varchar2
710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2

Line 714: ,p_pcp_radius in number default hr_api.g_number

710: ,p_pcp_radius_warn_flag in varchar2 default hr_api.g_varchar2
711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2

Line 715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2

711: ,p_pcp_strt_dt_cd in varchar2 default hr_api.g_varchar2
712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2

Line 716: ,p_pcp_num_chgs in number default hr_api.g_number

712: ,p_pcp_dsgn_cd in varchar2 default hr_api.g_varchar2
713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2

Line 717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2

713: ,p_pcp_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2

Line 718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2

714: ,p_pcp_radius in number default hr_api.g_number
715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2

Line 719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2

715: ,p_pcp_radius_uom in varchar2 default hr_api.g_varchar2
716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2

Line 720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2

716: ,p_pcp_num_chgs in number default hr_api.g_number
717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2

Line 721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2

717: ,p_pcp_num_chgs_uom in varchar2 default hr_api.g_varchar2
718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2

Line 722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2

718: ,p_pcp_attribute_category in varchar2 default hr_api.g_varchar2
719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2

Line 723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2

719: ,p_pcp_attribute1 in varchar2 default hr_api.g_varchar2
720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2

Line 724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2

720: ,p_pcp_attribute2 in varchar2 default hr_api.g_varchar2
721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2

Line 725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2

721: ,p_pcp_attribute3 in varchar2 default hr_api.g_varchar2
722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2

Line 726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2

722: ,p_pcp_attribute4 in varchar2 default hr_api.g_varchar2
723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2

Line 727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2

723: ,p_pcp_attribute5 in varchar2 default hr_api.g_varchar2
724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2

Line 728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2

724: ,p_pcp_attribute6 in varchar2 default hr_api.g_varchar2
725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2

Line 729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2

725: ,p_pcp_attribute7 in varchar2 default hr_api.g_varchar2
726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2

Line 730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2

726: ,p_pcp_attribute8 in varchar2 default hr_api.g_varchar2
727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2

Line 731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2

727: ,p_pcp_attribute9 in varchar2 default hr_api.g_varchar2
728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2

Line 732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2

728: ,p_pcp_attribute10 in varchar2 default hr_api.g_varchar2
729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2

Line 733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2

729: ,p_pcp_attribute11 in varchar2 default hr_api.g_varchar2
730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2

Line 734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2

730: ,p_pcp_attribute12 in varchar2 default hr_api.g_varchar2
731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2

Line 735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2

731: ,p_pcp_attribute13 in varchar2 default hr_api.g_varchar2
732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2

Line 736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2

732: ,p_pcp_attribute14 in varchar2 default hr_api.g_varchar2
733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2

Line 737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2

733: ,p_pcp_attribute15 in varchar2 default hr_api.g_varchar2
734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2

Line 738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2

734: ,p_pcp_attribute16 in varchar2 default hr_api.g_varchar2
735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2

Line 739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2

735: ,p_pcp_attribute17 in varchar2 default hr_api.g_varchar2
736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2

Line 740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2

736: ,p_pcp_attribute18 in varchar2 default hr_api.g_varchar2
737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2

Line 741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2

737: ,p_pcp_attribute19 in varchar2 default hr_api.g_varchar2
738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2

Line 742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2

738: ,p_pcp_attribute20 in varchar2 default hr_api.g_varchar2
739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2

Line 743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2

739: ,p_pcp_attribute21 in varchar2 default hr_api.g_varchar2
740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2

Line 744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2

740: ,p_pcp_attribute22 in varchar2 default hr_api.g_varchar2
741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2

Line 745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2

741: ,p_pcp_attribute23 in varchar2 default hr_api.g_varchar2
742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2
749: ) is

Line 746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2

742: ,p_pcp_attribute24 in varchar2 default hr_api.g_varchar2
743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2
749: ) is
750: --

Line 747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2

743: ,p_pcp_attribute25 in varchar2 default hr_api.g_varchar2
744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2
749: ) is
750: --
751: l_rec ben_pcp_shd.g_rec_type;

Line 748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2

744: ,p_pcp_attribute26 in varchar2 default hr_api.g_varchar2
745: ,p_pcp_attribute27 in varchar2 default hr_api.g_varchar2
746: ,p_pcp_attribute28 in varchar2 default hr_api.g_varchar2
747: ,p_pcp_attribute29 in varchar2 default hr_api.g_varchar2
748: ,p_pcp_attribute30 in varchar2 default hr_api.g_varchar2
749: ) is
750: --
751: l_rec ben_pcp_shd.g_rec_type;
752: l_proc varchar2(72) := g_package||'upd';