APPS.BEN_CCT_UPD dependencies on HR_API

Line 165: When hr_api.check_integrity_violated Then

161: End If;
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 15);
164: Exception
165: When hr_api.check_integrity_violated Then
166: -- A check constraint has been violated
167: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
168: ben_cct_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

165: When hr_api.check_integrity_violated Then
166: -- A check constraint has been violated
167: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
168: ben_cct_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
173: ben_cct_shd.constraint_error

Line 170: When hr_api.unique_integrity_violated Then

166: -- A check constraint has been violated
167: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
168: ben_cct_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
173: ben_cct_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

170: When hr_api.unique_integrity_violated Then
171: -- Unique integrity has been violated
172: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
173: ben_cct_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When Others Then
176: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
177: Raise;
178: End dt_update_dml;

Line 544: when hr_api.cannot_find_prog_unit then

540: ,p_object_version_number_o =>ben_cct_shd.g_old_rec.object_version_number);
541: --
542: exception
543: --
544: when hr_api.cannot_find_prog_unit then
545: --
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'ben_cm_typ_f'
548: ,p_hook_type => 'AU');

Line 546: hr_api.cannot_find_prog_unit_error

542: exception
543: --
544: when hr_api.cannot_find_prog_unit then
545: --
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'ben_cm_typ_f'
548: ,p_hook_type => 'AU');
549: --
550: end;

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

610: -- p_rec plsql record structure
611: -- to see if a system default is being used. If a system default
612: -- is being used then we must set to the 'current' argument value.
613: --
614: If (p_rec.name = hr_api.g_varchar2) then
615: p_rec.name :=
616: ben_cct_shd.g_old_rec.name;
617: End If;
618: If (p_rec.desc_txt = hr_api.g_varchar2) then

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

614: If (p_rec.name = hr_api.g_varchar2) then
615: p_rec.name :=
616: ben_cct_shd.g_old_rec.name;
617: End If;
618: If (p_rec.desc_txt = hr_api.g_varchar2) then
619: p_rec.desc_txt :=
620: ben_cct_shd.g_old_rec.desc_txt;
621: End If;
622: If (p_rec.inactive_flag = hr_api.g_varchar2) then

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

618: If (p_rec.desc_txt = hr_api.g_varchar2) then
619: p_rec.desc_txt :=
620: ben_cct_shd.g_old_rec.desc_txt;
621: End If;
622: If (p_rec.inactive_flag = hr_api.g_varchar2) then
623: p_rec.inactive_flag :=
624: ben_cct_shd.g_old_rec.inactive_flag;
625: End If;
626: If (p_rec.cm_typ_rl = hr_api.g_number) then

Line 626: If (p_rec.cm_typ_rl = hr_api.g_number) then

622: If (p_rec.inactive_flag = hr_api.g_varchar2) then
623: p_rec.inactive_flag :=
624: ben_cct_shd.g_old_rec.inactive_flag;
625: End If;
626: If (p_rec.cm_typ_rl = hr_api.g_number) then
627: p_rec.cm_typ_rl :=
628: ben_cct_shd.g_old_rec.cm_typ_rl;
629: End If;
630: If (p_rec.cm_usg_cd = hr_api.g_varchar2) then

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

626: If (p_rec.cm_typ_rl = hr_api.g_number) then
627: p_rec.cm_typ_rl :=
628: ben_cct_shd.g_old_rec.cm_typ_rl;
629: End If;
630: If (p_rec.cm_usg_cd = hr_api.g_varchar2) then
631: p_rec.cm_usg_cd :=
632: ben_cct_shd.g_old_rec.cm_usg_cd;
633: End If;
634: If (p_rec.whnvr_trgrd_flag = hr_api.g_varchar2) then

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

630: If (p_rec.cm_usg_cd = hr_api.g_varchar2) then
631: p_rec.cm_usg_cd :=
632: ben_cct_shd.g_old_rec.cm_usg_cd;
633: End If;
634: If (p_rec.whnvr_trgrd_flag = hr_api.g_varchar2) then
635: p_rec.whnvr_trgrd_flag :=
636: ben_cct_shd.g_old_rec.whnvr_trgrd_flag;
637: End If;
638: If (p_rec.shrt_name = hr_api.g_varchar2) then

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

634: If (p_rec.whnvr_trgrd_flag = hr_api.g_varchar2) then
635: p_rec.whnvr_trgrd_flag :=
636: ben_cct_shd.g_old_rec.whnvr_trgrd_flag;
637: End If;
638: If (p_rec.shrt_name = hr_api.g_varchar2) then
639: p_rec.shrt_name :=
640: ben_cct_shd.g_old_rec.shrt_name;
641: End If;
642: If (p_rec.pc_kit_cd = hr_api.g_varchar2) then

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

638: If (p_rec.shrt_name = hr_api.g_varchar2) then
639: p_rec.shrt_name :=
640: ben_cct_shd.g_old_rec.shrt_name;
641: End If;
642: If (p_rec.pc_kit_cd = hr_api.g_varchar2) then
643: p_rec.pc_kit_cd :=
644: ben_cct_shd.g_old_rec.pc_kit_cd;
645: End If;
646: If (p_rec.trk_mlg_flag = hr_api.g_varchar2) then

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

642: If (p_rec.pc_kit_cd = hr_api.g_varchar2) then
643: p_rec.pc_kit_cd :=
644: ben_cct_shd.g_old_rec.pc_kit_cd;
645: End If;
646: If (p_rec.trk_mlg_flag = hr_api.g_varchar2) then
647: p_rec.trk_mlg_flag :=
648: ben_cct_shd.g_old_rec.trk_mlg_flag;
649: End If;
650: If (p_rec.mx_num_avlbl_val = hr_api.g_number) then

Line 650: If (p_rec.mx_num_avlbl_val = hr_api.g_number) then

646: If (p_rec.trk_mlg_flag = hr_api.g_varchar2) then
647: p_rec.trk_mlg_flag :=
648: ben_cct_shd.g_old_rec.trk_mlg_flag;
649: End If;
650: If (p_rec.mx_num_avlbl_val = hr_api.g_number) then
651: p_rec.mx_num_avlbl_val :=
652: ben_cct_shd.g_old_rec.mx_num_avlbl_val;
653: End If;
654: If (p_rec.to_be_sent_dt_cd = hr_api.g_varchar2) then

Line 654: If (p_rec.to_be_sent_dt_cd = hr_api.g_varchar2) then

650: If (p_rec.mx_num_avlbl_val = hr_api.g_number) then
651: p_rec.mx_num_avlbl_val :=
652: ben_cct_shd.g_old_rec.mx_num_avlbl_val;
653: End If;
654: If (p_rec.to_be_sent_dt_cd = hr_api.g_varchar2) then
655: p_rec.to_be_sent_dt_cd :=
656: ben_cct_shd.g_old_rec.to_be_sent_dt_cd;
657: End If;
658: If (p_rec.to_be_sent_dt_rl = hr_api.g_number) then

Line 658: If (p_rec.to_be_sent_dt_rl = hr_api.g_number) then

654: If (p_rec.to_be_sent_dt_cd = hr_api.g_varchar2) then
655: p_rec.to_be_sent_dt_cd :=
656: ben_cct_shd.g_old_rec.to_be_sent_dt_cd;
657: End If;
658: If (p_rec.to_be_sent_dt_rl = hr_api.g_number) then
659: p_rec.to_be_sent_dt_rl :=
660: ben_cct_shd.g_old_rec.to_be_sent_dt_rl;
661: End If;
662: If (p_rec.inspn_rqd_flag = hr_api.g_varchar2) then

Line 662: If (p_rec.inspn_rqd_flag = hr_api.g_varchar2) then

658: If (p_rec.to_be_sent_dt_rl = hr_api.g_number) then
659: p_rec.to_be_sent_dt_rl :=
660: ben_cct_shd.g_old_rec.to_be_sent_dt_rl;
661: End If;
662: If (p_rec.inspn_rqd_flag = hr_api.g_varchar2) then
663: p_rec.inspn_rqd_flag :=
664: ben_cct_shd.g_old_rec.inspn_rqd_flag;
665: End If;
666: If (p_rec.inspn_rqd_rl = hr_api.g_number) then

Line 666: If (p_rec.inspn_rqd_rl = hr_api.g_number) then

662: If (p_rec.inspn_rqd_flag = hr_api.g_varchar2) then
663: p_rec.inspn_rqd_flag :=
664: ben_cct_shd.g_old_rec.inspn_rqd_flag;
665: End If;
666: If (p_rec.inspn_rqd_rl = hr_api.g_number) then
667: p_rec.inspn_rqd_rl :=
668: ben_cct_shd.g_old_rec.inspn_rqd_rl;
669: End If;
670: If (p_rec.rcpent_cd = hr_api.g_varchar2) then

Line 670: If (p_rec.rcpent_cd = hr_api.g_varchar2) then

666: If (p_rec.inspn_rqd_rl = hr_api.g_number) then
667: p_rec.inspn_rqd_rl :=
668: ben_cct_shd.g_old_rec.inspn_rqd_rl;
669: End If;
670: If (p_rec.rcpent_cd = hr_api.g_varchar2) then
671: p_rec.rcpent_cd :=
672: ben_cct_shd.g_old_rec.rcpent_cd;
673: End If;
674: If (p_rec.parnt_cm_typ_id = hr_api.g_number) then

Line 674: If (p_rec.parnt_cm_typ_id = hr_api.g_number) then

670: If (p_rec.rcpent_cd = hr_api.g_varchar2) then
671: p_rec.rcpent_cd :=
672: ben_cct_shd.g_old_rec.rcpent_cd;
673: End If;
674: If (p_rec.parnt_cm_typ_id = hr_api.g_number) then
675: p_rec.parnt_cm_typ_id :=
676: ben_cct_shd.g_old_rec.parnt_cm_typ_id;
677: End If;
678: If (p_rec.business_group_id = hr_api.g_number) then

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

674: If (p_rec.parnt_cm_typ_id = hr_api.g_number) then
675: p_rec.parnt_cm_typ_id :=
676: ben_cct_shd.g_old_rec.parnt_cm_typ_id;
677: End If;
678: If (p_rec.business_group_id = hr_api.g_number) then
679: p_rec.business_group_id :=
680: ben_cct_shd.g_old_rec.business_group_id;
681: End If;
682: If (p_rec.cct_attribute_category = hr_api.g_varchar2) then

Line 682: If (p_rec.cct_attribute_category = hr_api.g_varchar2) then

678: If (p_rec.business_group_id = hr_api.g_number) then
679: p_rec.business_group_id :=
680: ben_cct_shd.g_old_rec.business_group_id;
681: End If;
682: If (p_rec.cct_attribute_category = hr_api.g_varchar2) then
683: p_rec.cct_attribute_category :=
684: ben_cct_shd.g_old_rec.cct_attribute_category;
685: End If;
686: If (p_rec.cct_attribute1 = hr_api.g_varchar2) then

Line 686: If (p_rec.cct_attribute1 = hr_api.g_varchar2) then

682: If (p_rec.cct_attribute_category = hr_api.g_varchar2) then
683: p_rec.cct_attribute_category :=
684: ben_cct_shd.g_old_rec.cct_attribute_category;
685: End If;
686: If (p_rec.cct_attribute1 = hr_api.g_varchar2) then
687: p_rec.cct_attribute1 :=
688: ben_cct_shd.g_old_rec.cct_attribute1;
689: End If;
690: If (p_rec.cct_attribute10 = hr_api.g_varchar2) then

Line 690: If (p_rec.cct_attribute10 = hr_api.g_varchar2) then

686: If (p_rec.cct_attribute1 = hr_api.g_varchar2) then
687: p_rec.cct_attribute1 :=
688: ben_cct_shd.g_old_rec.cct_attribute1;
689: End If;
690: If (p_rec.cct_attribute10 = hr_api.g_varchar2) then
691: p_rec.cct_attribute10 :=
692: ben_cct_shd.g_old_rec.cct_attribute10;
693: End If;
694: If (p_rec.cct_attribute11 = hr_api.g_varchar2) then

Line 694: If (p_rec.cct_attribute11 = hr_api.g_varchar2) then

690: If (p_rec.cct_attribute10 = hr_api.g_varchar2) then
691: p_rec.cct_attribute10 :=
692: ben_cct_shd.g_old_rec.cct_attribute10;
693: End If;
694: If (p_rec.cct_attribute11 = hr_api.g_varchar2) then
695: p_rec.cct_attribute11 :=
696: ben_cct_shd.g_old_rec.cct_attribute11;
697: End If;
698: If (p_rec.cct_attribute12 = hr_api.g_varchar2) then

Line 698: If (p_rec.cct_attribute12 = hr_api.g_varchar2) then

694: If (p_rec.cct_attribute11 = hr_api.g_varchar2) then
695: p_rec.cct_attribute11 :=
696: ben_cct_shd.g_old_rec.cct_attribute11;
697: End If;
698: If (p_rec.cct_attribute12 = hr_api.g_varchar2) then
699: p_rec.cct_attribute12 :=
700: ben_cct_shd.g_old_rec.cct_attribute12;
701: End If;
702: If (p_rec.cct_attribute13 = hr_api.g_varchar2) then

Line 702: If (p_rec.cct_attribute13 = hr_api.g_varchar2) then

698: If (p_rec.cct_attribute12 = hr_api.g_varchar2) then
699: p_rec.cct_attribute12 :=
700: ben_cct_shd.g_old_rec.cct_attribute12;
701: End If;
702: If (p_rec.cct_attribute13 = hr_api.g_varchar2) then
703: p_rec.cct_attribute13 :=
704: ben_cct_shd.g_old_rec.cct_attribute13;
705: End If;
706: If (p_rec.cct_attribute14 = hr_api.g_varchar2) then

Line 706: If (p_rec.cct_attribute14 = hr_api.g_varchar2) then

702: If (p_rec.cct_attribute13 = hr_api.g_varchar2) then
703: p_rec.cct_attribute13 :=
704: ben_cct_shd.g_old_rec.cct_attribute13;
705: End If;
706: If (p_rec.cct_attribute14 = hr_api.g_varchar2) then
707: p_rec.cct_attribute14 :=
708: ben_cct_shd.g_old_rec.cct_attribute14;
709: End If;
710: If (p_rec.cct_attribute15 = hr_api.g_varchar2) then

Line 710: If (p_rec.cct_attribute15 = hr_api.g_varchar2) then

706: If (p_rec.cct_attribute14 = hr_api.g_varchar2) then
707: p_rec.cct_attribute14 :=
708: ben_cct_shd.g_old_rec.cct_attribute14;
709: End If;
710: If (p_rec.cct_attribute15 = hr_api.g_varchar2) then
711: p_rec.cct_attribute15 :=
712: ben_cct_shd.g_old_rec.cct_attribute15;
713: End If;
714: If (p_rec.cct_attribute16 = hr_api.g_varchar2) then

Line 714: If (p_rec.cct_attribute16 = hr_api.g_varchar2) then

710: If (p_rec.cct_attribute15 = hr_api.g_varchar2) then
711: p_rec.cct_attribute15 :=
712: ben_cct_shd.g_old_rec.cct_attribute15;
713: End If;
714: If (p_rec.cct_attribute16 = hr_api.g_varchar2) then
715: p_rec.cct_attribute16 :=
716: ben_cct_shd.g_old_rec.cct_attribute16;
717: End If;
718: If (p_rec.cct_attribute17 = hr_api.g_varchar2) then

Line 718: If (p_rec.cct_attribute17 = hr_api.g_varchar2) then

714: If (p_rec.cct_attribute16 = hr_api.g_varchar2) then
715: p_rec.cct_attribute16 :=
716: ben_cct_shd.g_old_rec.cct_attribute16;
717: End If;
718: If (p_rec.cct_attribute17 = hr_api.g_varchar2) then
719: p_rec.cct_attribute17 :=
720: ben_cct_shd.g_old_rec.cct_attribute17;
721: End If;
722: If (p_rec.cct_attribute18 = hr_api.g_varchar2) then

Line 722: If (p_rec.cct_attribute18 = hr_api.g_varchar2) then

718: If (p_rec.cct_attribute17 = hr_api.g_varchar2) then
719: p_rec.cct_attribute17 :=
720: ben_cct_shd.g_old_rec.cct_attribute17;
721: End If;
722: If (p_rec.cct_attribute18 = hr_api.g_varchar2) then
723: p_rec.cct_attribute18 :=
724: ben_cct_shd.g_old_rec.cct_attribute18;
725: End If;
726: If (p_rec.cct_attribute19 = hr_api.g_varchar2) then

Line 726: If (p_rec.cct_attribute19 = hr_api.g_varchar2) then

722: If (p_rec.cct_attribute18 = hr_api.g_varchar2) then
723: p_rec.cct_attribute18 :=
724: ben_cct_shd.g_old_rec.cct_attribute18;
725: End If;
726: If (p_rec.cct_attribute19 = hr_api.g_varchar2) then
727: p_rec.cct_attribute19 :=
728: ben_cct_shd.g_old_rec.cct_attribute19;
729: End If;
730: If (p_rec.cct_attribute2 = hr_api.g_varchar2) then

Line 730: If (p_rec.cct_attribute2 = hr_api.g_varchar2) then

726: If (p_rec.cct_attribute19 = hr_api.g_varchar2) then
727: p_rec.cct_attribute19 :=
728: ben_cct_shd.g_old_rec.cct_attribute19;
729: End If;
730: If (p_rec.cct_attribute2 = hr_api.g_varchar2) then
731: p_rec.cct_attribute2 :=
732: ben_cct_shd.g_old_rec.cct_attribute2;
733: End If;
734: If (p_rec.cct_attribute20 = hr_api.g_varchar2) then

Line 734: If (p_rec.cct_attribute20 = hr_api.g_varchar2) then

730: If (p_rec.cct_attribute2 = hr_api.g_varchar2) then
731: p_rec.cct_attribute2 :=
732: ben_cct_shd.g_old_rec.cct_attribute2;
733: End If;
734: If (p_rec.cct_attribute20 = hr_api.g_varchar2) then
735: p_rec.cct_attribute20 :=
736: ben_cct_shd.g_old_rec.cct_attribute20;
737: End If;
738: If (p_rec.cct_attribute21 = hr_api.g_varchar2) then

Line 738: If (p_rec.cct_attribute21 = hr_api.g_varchar2) then

734: If (p_rec.cct_attribute20 = hr_api.g_varchar2) then
735: p_rec.cct_attribute20 :=
736: ben_cct_shd.g_old_rec.cct_attribute20;
737: End If;
738: If (p_rec.cct_attribute21 = hr_api.g_varchar2) then
739: p_rec.cct_attribute21 :=
740: ben_cct_shd.g_old_rec.cct_attribute21;
741: End If;
742: If (p_rec.cct_attribute22 = hr_api.g_varchar2) then

Line 742: If (p_rec.cct_attribute22 = hr_api.g_varchar2) then

738: If (p_rec.cct_attribute21 = hr_api.g_varchar2) then
739: p_rec.cct_attribute21 :=
740: ben_cct_shd.g_old_rec.cct_attribute21;
741: End If;
742: If (p_rec.cct_attribute22 = hr_api.g_varchar2) then
743: p_rec.cct_attribute22 :=
744: ben_cct_shd.g_old_rec.cct_attribute22;
745: End If;
746: If (p_rec.cct_attribute23 = hr_api.g_varchar2) then

Line 746: If (p_rec.cct_attribute23 = hr_api.g_varchar2) then

742: If (p_rec.cct_attribute22 = hr_api.g_varchar2) then
743: p_rec.cct_attribute22 :=
744: ben_cct_shd.g_old_rec.cct_attribute22;
745: End If;
746: If (p_rec.cct_attribute23 = hr_api.g_varchar2) then
747: p_rec.cct_attribute23 :=
748: ben_cct_shd.g_old_rec.cct_attribute23;
749: End If;
750: If (p_rec.cct_attribute24 = hr_api.g_varchar2) then

Line 750: If (p_rec.cct_attribute24 = hr_api.g_varchar2) then

746: If (p_rec.cct_attribute23 = hr_api.g_varchar2) then
747: p_rec.cct_attribute23 :=
748: ben_cct_shd.g_old_rec.cct_attribute23;
749: End If;
750: If (p_rec.cct_attribute24 = hr_api.g_varchar2) then
751: p_rec.cct_attribute24 :=
752: ben_cct_shd.g_old_rec.cct_attribute24;
753: End If;
754: If (p_rec.cct_attribute25 = hr_api.g_varchar2) then

Line 754: If (p_rec.cct_attribute25 = hr_api.g_varchar2) then

750: If (p_rec.cct_attribute24 = hr_api.g_varchar2) then
751: p_rec.cct_attribute24 :=
752: ben_cct_shd.g_old_rec.cct_attribute24;
753: End If;
754: If (p_rec.cct_attribute25 = hr_api.g_varchar2) then
755: p_rec.cct_attribute25 :=
756: ben_cct_shd.g_old_rec.cct_attribute25;
757: End If;
758: If (p_rec.cct_attribute26 = hr_api.g_varchar2) then

Line 758: If (p_rec.cct_attribute26 = hr_api.g_varchar2) then

754: If (p_rec.cct_attribute25 = hr_api.g_varchar2) then
755: p_rec.cct_attribute25 :=
756: ben_cct_shd.g_old_rec.cct_attribute25;
757: End If;
758: If (p_rec.cct_attribute26 = hr_api.g_varchar2) then
759: p_rec.cct_attribute26 :=
760: ben_cct_shd.g_old_rec.cct_attribute26;
761: End If;
762: If (p_rec.cct_attribute27 = hr_api.g_varchar2) then

Line 762: If (p_rec.cct_attribute27 = hr_api.g_varchar2) then

758: If (p_rec.cct_attribute26 = hr_api.g_varchar2) then
759: p_rec.cct_attribute26 :=
760: ben_cct_shd.g_old_rec.cct_attribute26;
761: End If;
762: If (p_rec.cct_attribute27 = hr_api.g_varchar2) then
763: p_rec.cct_attribute27 :=
764: ben_cct_shd.g_old_rec.cct_attribute27;
765: End If;
766: If (p_rec.cct_attribute28 = hr_api.g_varchar2) then

Line 766: If (p_rec.cct_attribute28 = hr_api.g_varchar2) then

762: If (p_rec.cct_attribute27 = hr_api.g_varchar2) then
763: p_rec.cct_attribute27 :=
764: ben_cct_shd.g_old_rec.cct_attribute27;
765: End If;
766: If (p_rec.cct_attribute28 = hr_api.g_varchar2) then
767: p_rec.cct_attribute28 :=
768: ben_cct_shd.g_old_rec.cct_attribute28;
769: End If;
770: If (p_rec.cct_attribute29 = hr_api.g_varchar2) then

Line 770: If (p_rec.cct_attribute29 = hr_api.g_varchar2) then

766: If (p_rec.cct_attribute28 = hr_api.g_varchar2) then
767: p_rec.cct_attribute28 :=
768: ben_cct_shd.g_old_rec.cct_attribute28;
769: End If;
770: If (p_rec.cct_attribute29 = hr_api.g_varchar2) then
771: p_rec.cct_attribute29 :=
772: ben_cct_shd.g_old_rec.cct_attribute29;
773: End If;
774: If (p_rec.cct_attribute3 = hr_api.g_varchar2) then

Line 774: If (p_rec.cct_attribute3 = hr_api.g_varchar2) then

770: If (p_rec.cct_attribute29 = hr_api.g_varchar2) then
771: p_rec.cct_attribute29 :=
772: ben_cct_shd.g_old_rec.cct_attribute29;
773: End If;
774: If (p_rec.cct_attribute3 = hr_api.g_varchar2) then
775: p_rec.cct_attribute3 :=
776: ben_cct_shd.g_old_rec.cct_attribute3;
777: End If;
778: If (p_rec.cct_attribute30 = hr_api.g_varchar2) then

Line 778: If (p_rec.cct_attribute30 = hr_api.g_varchar2) then

774: If (p_rec.cct_attribute3 = hr_api.g_varchar2) then
775: p_rec.cct_attribute3 :=
776: ben_cct_shd.g_old_rec.cct_attribute3;
777: End If;
778: If (p_rec.cct_attribute30 = hr_api.g_varchar2) then
779: p_rec.cct_attribute30 :=
780: ben_cct_shd.g_old_rec.cct_attribute30;
781: End If;
782: If (p_rec.cct_attribute4 = hr_api.g_varchar2) then

Line 782: If (p_rec.cct_attribute4 = hr_api.g_varchar2) then

778: If (p_rec.cct_attribute30 = hr_api.g_varchar2) then
779: p_rec.cct_attribute30 :=
780: ben_cct_shd.g_old_rec.cct_attribute30;
781: End If;
782: If (p_rec.cct_attribute4 = hr_api.g_varchar2) then
783: p_rec.cct_attribute4 :=
784: ben_cct_shd.g_old_rec.cct_attribute4;
785: End If;
786: If (p_rec.cct_attribute5 = hr_api.g_varchar2) then

Line 786: If (p_rec.cct_attribute5 = hr_api.g_varchar2) then

782: If (p_rec.cct_attribute4 = hr_api.g_varchar2) then
783: p_rec.cct_attribute4 :=
784: ben_cct_shd.g_old_rec.cct_attribute4;
785: End If;
786: If (p_rec.cct_attribute5 = hr_api.g_varchar2) then
787: p_rec.cct_attribute5 :=
788: ben_cct_shd.g_old_rec.cct_attribute5;
789: End If;
790: If (p_rec.cct_attribute6 = hr_api.g_varchar2) then

Line 790: If (p_rec.cct_attribute6 = hr_api.g_varchar2) then

786: If (p_rec.cct_attribute5 = hr_api.g_varchar2) then
787: p_rec.cct_attribute5 :=
788: ben_cct_shd.g_old_rec.cct_attribute5;
789: End If;
790: If (p_rec.cct_attribute6 = hr_api.g_varchar2) then
791: p_rec.cct_attribute6 :=
792: ben_cct_shd.g_old_rec.cct_attribute6;
793: End If;
794: If (p_rec.cct_attribute7 = hr_api.g_varchar2) then

Line 794: If (p_rec.cct_attribute7 = hr_api.g_varchar2) then

790: If (p_rec.cct_attribute6 = hr_api.g_varchar2) then
791: p_rec.cct_attribute6 :=
792: ben_cct_shd.g_old_rec.cct_attribute6;
793: End If;
794: If (p_rec.cct_attribute7 = hr_api.g_varchar2) then
795: p_rec.cct_attribute7 :=
796: ben_cct_shd.g_old_rec.cct_attribute7;
797: End If;
798: If (p_rec.cct_attribute8 = hr_api.g_varchar2) then

Line 798: If (p_rec.cct_attribute8 = hr_api.g_varchar2) then

794: If (p_rec.cct_attribute7 = hr_api.g_varchar2) then
795: p_rec.cct_attribute7 :=
796: ben_cct_shd.g_old_rec.cct_attribute7;
797: End If;
798: If (p_rec.cct_attribute8 = hr_api.g_varchar2) then
799: p_rec.cct_attribute8 :=
800: ben_cct_shd.g_old_rec.cct_attribute8;
801: End If;
802: If (p_rec.cct_attribute9 = hr_api.g_varchar2) then

Line 802: If (p_rec.cct_attribute9 = hr_api.g_varchar2) then

798: If (p_rec.cct_attribute8 = hr_api.g_varchar2) then
799: p_rec.cct_attribute8 :=
800: ben_cct_shd.g_old_rec.cct_attribute8;
801: End If;
802: If (p_rec.cct_attribute9 = hr_api.g_varchar2) then
803: p_rec.cct_attribute9 :=
804: ben_cct_shd.g_old_rec.cct_attribute9;
805: End If;
806: --

Line 892: p_name in varchar2 default hr_api.g_varchar2,

888: (
889: p_cm_typ_id in number,
890: p_effective_start_date out nocopy date,
891: p_effective_end_date out nocopy date,
892: p_name in varchar2 default hr_api.g_varchar2,
893: p_desc_txt in varchar2 default hr_api.g_varchar2,
894: p_inactive_flag in varchar2 default hr_api.g_varchar2,
895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,

Line 893: p_desc_txt in varchar2 default hr_api.g_varchar2,

889: p_cm_typ_id in number,
890: p_effective_start_date out nocopy date,
891: p_effective_end_date out nocopy date,
892: p_name in varchar2 default hr_api.g_varchar2,
893: p_desc_txt in varchar2 default hr_api.g_varchar2,
894: p_inactive_flag in varchar2 default hr_api.g_varchar2,
895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,

Line 894: p_inactive_flag in varchar2 default hr_api.g_varchar2,

890: p_effective_start_date out nocopy date,
891: p_effective_end_date out nocopy date,
892: p_name in varchar2 default hr_api.g_varchar2,
893: p_desc_txt in varchar2 default hr_api.g_varchar2,
894: p_inactive_flag in varchar2 default hr_api.g_varchar2,
895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,

Line 895: p_cm_typ_rl in number default hr_api.g_number,

891: p_effective_end_date out nocopy date,
892: p_name in varchar2 default hr_api.g_varchar2,
893: p_desc_txt in varchar2 default hr_api.g_varchar2,
894: p_inactive_flag in varchar2 default hr_api.g_varchar2,
895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,

Line 896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,

892: p_name in varchar2 default hr_api.g_varchar2,
893: p_desc_txt in varchar2 default hr_api.g_varchar2,
894: p_inactive_flag in varchar2 default hr_api.g_varchar2,
895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,

Line 897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,

893: p_desc_txt in varchar2 default hr_api.g_varchar2,
894: p_inactive_flag in varchar2 default hr_api.g_varchar2,
895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,

Line 898: p_shrt_name in varchar2 default hr_api.g_varchar2,

894: p_inactive_flag in varchar2 default hr_api.g_varchar2,
895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,

Line 899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,

895: p_cm_typ_rl in number default hr_api.g_number,
896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,

Line 900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,

896: p_cm_usg_cd in varchar2 default hr_api.g_varchar2,
897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,

Line 901: p_mx_num_avlbl_val in number default hr_api.g_number,

897: p_whnvr_trgrd_flag in varchar2 default hr_api.g_varchar2,
898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,

Line 902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,

898: p_shrt_name in varchar2 default hr_api.g_varchar2,
899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,

Line 903: p_to_be_sent_dt_rl in number default hr_api.g_number,

899: p_pc_kit_cd in varchar2 default hr_api.g_varchar2,
900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,

Line 904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,

900: p_trk_mlg_flag in varchar2 default hr_api.g_varchar2,
901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,

Line 905: p_inspn_rqd_rl in number default hr_api.g_number,

901: p_mx_num_avlbl_val in number default hr_api.g_number,
902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,

Line 906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,

902: p_to_be_sent_dt_cd in varchar2 default hr_api.g_varchar2,
903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,

Line 907: p_parnt_cm_typ_id in number default hr_api.g_number,

903: p_to_be_sent_dt_rl in number default hr_api.g_number,
904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,

Line 908: p_business_group_id in number default hr_api.g_number,

904: p_inspn_rqd_flag in varchar2 default hr_api.g_varchar2,
905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,

Line 909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,

905: p_inspn_rqd_rl in number default hr_api.g_number,
906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,

Line 910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,

906: p_rcpent_cd in varchar2 default hr_api.g_varchar2,
907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,

Line 911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,

907: p_parnt_cm_typ_id in number default hr_api.g_number,
908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,

Line 912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,

908: p_business_group_id in number default hr_api.g_number,
909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,

Line 913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,

909: p_cct_attribute_category in varchar2 default hr_api.g_varchar2,
910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,

Line 914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,

910: p_cct_attribute1 in varchar2 default hr_api.g_varchar2,
911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,

Line 915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,

911: p_cct_attribute10 in varchar2 default hr_api.g_varchar2,
912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,

Line 916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,

912: p_cct_attribute11 in varchar2 default hr_api.g_varchar2,
913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,

Line 917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,

913: p_cct_attribute12 in varchar2 default hr_api.g_varchar2,
914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,

Line 918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,

914: p_cct_attribute13 in varchar2 default hr_api.g_varchar2,
915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,

Line 919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,

915: p_cct_attribute14 in varchar2 default hr_api.g_varchar2,
916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,

Line 920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,

916: p_cct_attribute15 in varchar2 default hr_api.g_varchar2,
917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,

Line 921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,

917: p_cct_attribute16 in varchar2 default hr_api.g_varchar2,
918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,

Line 922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,

918: p_cct_attribute17 in varchar2 default hr_api.g_varchar2,
919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,

Line 923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,

919: p_cct_attribute18 in varchar2 default hr_api.g_varchar2,
920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,

Line 924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,

920: p_cct_attribute19 in varchar2 default hr_api.g_varchar2,
921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,

Line 925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,

921: p_cct_attribute2 in varchar2 default hr_api.g_varchar2,
922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,

Line 926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,

922: p_cct_attribute20 in varchar2 default hr_api.g_varchar2,
923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,

Line 927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,

923: p_cct_attribute21 in varchar2 default hr_api.g_varchar2,
924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,

Line 928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,

924: p_cct_attribute22 in varchar2 default hr_api.g_varchar2,
925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,

Line 929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,

925: p_cct_attribute23 in varchar2 default hr_api.g_varchar2,
926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,

Line 930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,

926: p_cct_attribute24 in varchar2 default hr_api.g_varchar2,
927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,

Line 931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,

927: p_cct_attribute25 in varchar2 default hr_api.g_varchar2,
928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,

Line 932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,

928: p_cct_attribute26 in varchar2 default hr_api.g_varchar2,
929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,

Line 933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,

929: p_cct_attribute27 in varchar2 default hr_api.g_varchar2,
930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,
937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,

Line 934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,

930: p_cct_attribute28 in varchar2 default hr_api.g_varchar2,
931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,
937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,
938: p_cct_attribute8 in varchar2 default hr_api.g_varchar2,

Line 935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,

931: p_cct_attribute29 in varchar2 default hr_api.g_varchar2,
932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,
937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,
938: p_cct_attribute8 in varchar2 default hr_api.g_varchar2,
939: p_cct_attribute9 in varchar2 default hr_api.g_varchar2,

Line 936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,

932: p_cct_attribute3 in varchar2 default hr_api.g_varchar2,
933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,
937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,
938: p_cct_attribute8 in varchar2 default hr_api.g_varchar2,
939: p_cct_attribute9 in varchar2 default hr_api.g_varchar2,
940: p_object_version_number in out nocopy number,

Line 937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,

933: p_cct_attribute30 in varchar2 default hr_api.g_varchar2,
934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,
937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,
938: p_cct_attribute8 in varchar2 default hr_api.g_varchar2,
939: p_cct_attribute9 in varchar2 default hr_api.g_varchar2,
940: p_object_version_number in out nocopy number,
941: p_effective_date in date,

Line 938: p_cct_attribute8 in varchar2 default hr_api.g_varchar2,

934: p_cct_attribute4 in varchar2 default hr_api.g_varchar2,
935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,
937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,
938: p_cct_attribute8 in varchar2 default hr_api.g_varchar2,
939: p_cct_attribute9 in varchar2 default hr_api.g_varchar2,
940: p_object_version_number in out nocopy number,
941: p_effective_date in date,
942: p_datetrack_mode in varchar2

Line 939: p_cct_attribute9 in varchar2 default hr_api.g_varchar2,

935: p_cct_attribute5 in varchar2 default hr_api.g_varchar2,
936: p_cct_attribute6 in varchar2 default hr_api.g_varchar2,
937: p_cct_attribute7 in varchar2 default hr_api.g_varchar2,
938: p_cct_attribute8 in varchar2 default hr_api.g_varchar2,
939: p_cct_attribute9 in varchar2 default hr_api.g_varchar2,
940: p_object_version_number in out nocopy number,
941: p_effective_date in date,
942: p_datetrack_mode in varchar2
943: ) is