129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: --
132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_clf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_clf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_clf_shd.constraint_error
134: -- A check constraint has been violated
135: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
136: ben_clf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_clf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_clf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
146: ben_clf_shd.constraint_error
139: -- Parent integrity has been violated
140: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
141: ben_clf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
146: ben_clf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
146: ben_clf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_clf_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
151: End update_dml;
352: );
353: --
354: exception
355: --
356: when hr_api.cannot_find_prog_unit then
357: --
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'ben_comp_lvl_fctr'
360: ,p_hook_type => 'AU');
354: exception
355: --
356: when hr_api.cannot_find_prog_unit then
357: --
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'ben_comp_lvl_fctr'
360: ,p_hook_type => 'AU');
361: --
362: end;
422: -- p_rec plsql record structure
423: -- to see if a system default is being used. If a system default
424: -- is being used then we must set to the 'current' argument value.
425: --
426: If (p_rec.business_group_id = hr_api.g_number) then
427: p_rec.business_group_id :=
428: ben_clf_shd.g_old_rec.business_group_id;
429: End If;
430: If (p_rec.name = hr_api.g_varchar2) then
426: If (p_rec.business_group_id = hr_api.g_number) then
427: p_rec.business_group_id :=
428: ben_clf_shd.g_old_rec.business_group_id;
429: End If;
430: If (p_rec.name = hr_api.g_varchar2) then
431: p_rec.name :=
432: ben_clf_shd.g_old_rec.name;
433: End If;
434: If (p_rec.comp_lvl_det_cd = hr_api.g_varchar2) then
430: If (p_rec.name = hr_api.g_varchar2) then
431: p_rec.name :=
432: ben_clf_shd.g_old_rec.name;
433: End If;
434: If (p_rec.comp_lvl_det_cd = hr_api.g_varchar2) then
435: p_rec.comp_lvl_det_cd :=
436: ben_clf_shd.g_old_rec.comp_lvl_det_cd;
437: End If;
438: If (p_rec.comp_lvl_det_rl = hr_api.g_number) then
434: If (p_rec.comp_lvl_det_cd = hr_api.g_varchar2) then
435: p_rec.comp_lvl_det_cd :=
436: ben_clf_shd.g_old_rec.comp_lvl_det_cd;
437: End If;
438: If (p_rec.comp_lvl_det_rl = hr_api.g_number) then
439: p_rec.comp_lvl_det_rl :=
440: ben_clf_shd.g_old_rec.comp_lvl_det_rl;
441: End If;
442: If (p_rec.comp_lvl_uom = hr_api.g_varchar2) then
438: If (p_rec.comp_lvl_det_rl = hr_api.g_number) then
439: p_rec.comp_lvl_det_rl :=
440: ben_clf_shd.g_old_rec.comp_lvl_det_rl;
441: End If;
442: If (p_rec.comp_lvl_uom = hr_api.g_varchar2) then
443: p_rec.comp_lvl_uom :=
444: ben_clf_shd.g_old_rec.comp_lvl_uom;
445: End If;
446: If (p_rec.comp_src_cd = hr_api.g_varchar2) then
442: If (p_rec.comp_lvl_uom = hr_api.g_varchar2) then
443: p_rec.comp_lvl_uom :=
444: ben_clf_shd.g_old_rec.comp_lvl_uom;
445: End If;
446: If (p_rec.comp_src_cd = hr_api.g_varchar2) then
447: p_rec.comp_src_cd :=
448: ben_clf_shd.g_old_rec.comp_src_cd;
449: End If;
450: If (p_rec.defined_balance_id = hr_api.g_number) then
446: If (p_rec.comp_src_cd = hr_api.g_varchar2) then
447: p_rec.comp_src_cd :=
448: ben_clf_shd.g_old_rec.comp_src_cd;
449: End If;
450: If (p_rec.defined_balance_id = hr_api.g_number) then
451: p_rec.defined_balance_id :=
452: ben_clf_shd.g_old_rec.defined_balance_id;
453: End If;
454: If (p_rec.no_mn_comp_flag = hr_api.g_varchar2) then
450: If (p_rec.defined_balance_id = hr_api.g_number) then
451: p_rec.defined_balance_id :=
452: ben_clf_shd.g_old_rec.defined_balance_id;
453: End If;
454: If (p_rec.no_mn_comp_flag = hr_api.g_varchar2) then
455: p_rec.no_mn_comp_flag :=
456: ben_clf_shd.g_old_rec.no_mn_comp_flag;
457: End If;
458: If (p_rec.no_mx_comp_flag = hr_api.g_varchar2) then
454: If (p_rec.no_mn_comp_flag = hr_api.g_varchar2) then
455: p_rec.no_mn_comp_flag :=
456: ben_clf_shd.g_old_rec.no_mn_comp_flag;
457: End If;
458: If (p_rec.no_mx_comp_flag = hr_api.g_varchar2) then
459: p_rec.no_mx_comp_flag :=
460: ben_clf_shd.g_old_rec.no_mx_comp_flag;
461: End If;
462: If (p_rec.mx_comp_val = hr_api.g_number) then
458: If (p_rec.no_mx_comp_flag = hr_api.g_varchar2) then
459: p_rec.no_mx_comp_flag :=
460: ben_clf_shd.g_old_rec.no_mx_comp_flag;
461: End If;
462: If (p_rec.mx_comp_val = hr_api.g_number) then
463: p_rec.mx_comp_val :=
464: ben_clf_shd.g_old_rec.mx_comp_val;
465: End If;
466: If (p_rec.mn_comp_val = hr_api.g_number) then
462: If (p_rec.mx_comp_val = hr_api.g_number) then
463: p_rec.mx_comp_val :=
464: ben_clf_shd.g_old_rec.mx_comp_val;
465: End If;
466: If (p_rec.mn_comp_val = hr_api.g_number) then
467: p_rec.mn_comp_val :=
468: ben_clf_shd.g_old_rec.mn_comp_val;
469: End If;
470: If (p_rec.rndg_cd = hr_api.g_varchar2) then
466: If (p_rec.mn_comp_val = hr_api.g_number) then
467: p_rec.mn_comp_val :=
468: ben_clf_shd.g_old_rec.mn_comp_val;
469: End If;
470: If (p_rec.rndg_cd = hr_api.g_varchar2) then
471: p_rec.rndg_cd :=
472: ben_clf_shd.g_old_rec.rndg_cd;
473: End If;
474: If (p_rec.rndg_rl = hr_api.g_number) then
470: If (p_rec.rndg_cd = hr_api.g_varchar2) then
471: p_rec.rndg_cd :=
472: ben_clf_shd.g_old_rec.rndg_cd;
473: End If;
474: If (p_rec.rndg_rl = hr_api.g_number) then
475: p_rec.rndg_rl :=
476: ben_clf_shd.g_old_rec.rndg_rl;
477: End If;
478: If (p_rec.bnfts_bal_id = hr_api.g_number) then
474: If (p_rec.rndg_rl = hr_api.g_number) then
475: p_rec.rndg_rl :=
476: ben_clf_shd.g_old_rec.rndg_rl;
477: End If;
478: If (p_rec.bnfts_bal_id = hr_api.g_number) then
479: p_rec.bnfts_bal_id :=
480: ben_clf_shd.g_old_rec.bnfts_bal_id;
481: End If;
482: If (p_rec.comp_alt_val_to_use_cd = hr_api.g_varchar2) then
478: If (p_rec.bnfts_bal_id = hr_api.g_number) then
479: p_rec.bnfts_bal_id :=
480: ben_clf_shd.g_old_rec.bnfts_bal_id;
481: End If;
482: If (p_rec.comp_alt_val_to_use_cd = hr_api.g_varchar2) then
483: p_rec.comp_alt_val_to_use_cd :=
484: ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd;
485: End If;
486: If (p_rec.comp_calc_rl = hr_api.g_number) then
482: If (p_rec.comp_alt_val_to_use_cd = hr_api.g_varchar2) then
483: p_rec.comp_alt_val_to_use_cd :=
484: ben_clf_shd.g_old_rec.comp_alt_val_to_use_cd;
485: End If;
486: If (p_rec.comp_calc_rl = hr_api.g_number) then
487: p_rec.comp_calc_rl :=
488: ben_clf_shd.g_old_rec.comp_calc_rl;
489: End If;
490:
487: p_rec.comp_calc_rl :=
488: ben_clf_shd.g_old_rec.comp_calc_rl;
489: End If;
490:
491: If (p_rec.proration_flag = hr_api.g_varchar2) then
492: p_rec.proration_flag :=
493: ben_clf_shd.g_old_rec.proration_flag;
494: End If;
495: If (p_rec.start_day_mo = hr_api.g_varchar2) then
491: If (p_rec.proration_flag = hr_api.g_varchar2) then
492: p_rec.proration_flag :=
493: ben_clf_shd.g_old_rec.proration_flag;
494: End If;
495: If (p_rec.start_day_mo = hr_api.g_varchar2) then
496: p_rec.start_day_mo :=
497: ben_clf_shd.g_old_rec.start_day_mo;
498: End If;
499: If (p_rec.end_day_mo = hr_api.g_varchar2) then
495: If (p_rec.start_day_mo = hr_api.g_varchar2) then
496: p_rec.start_day_mo :=
497: ben_clf_shd.g_old_rec.start_day_mo;
498: End If;
499: If (p_rec.end_day_mo = hr_api.g_varchar2) then
500: p_rec.end_day_mo :=
501: ben_clf_shd.g_old_rec.end_day_mo;
502: End If;
503: If (p_rec.start_year = hr_api.g_varchar2) then
499: If (p_rec.end_day_mo = hr_api.g_varchar2) then
500: p_rec.end_day_mo :=
501: ben_clf_shd.g_old_rec.end_day_mo;
502: End If;
503: If (p_rec.start_year = hr_api.g_varchar2) then
504: p_rec.start_year :=
505: ben_clf_shd.g_old_rec.start_year;
506: End If;
507: If (p_rec.end_year = hr_api.g_varchar2) then
503: If (p_rec.start_year = hr_api.g_varchar2) then
504: p_rec.start_year :=
505: ben_clf_shd.g_old_rec.start_year;
506: End If;
507: If (p_rec.end_year = hr_api.g_varchar2) then
508: p_rec.end_year :=
509: ben_clf_shd.g_old_rec.end_year;
510: End If;
511:
508: p_rec.end_year :=
509: ben_clf_shd.g_old_rec.end_year;
510: End If;
511:
512: If (p_rec.clf_attribute_category = hr_api.g_varchar2) then
513: p_rec.clf_attribute_category :=
514: ben_clf_shd.g_old_rec.clf_attribute_category;
515: End If;
516: If (p_rec.clf_attribute1 = hr_api.g_varchar2) then
512: If (p_rec.clf_attribute_category = hr_api.g_varchar2) then
513: p_rec.clf_attribute_category :=
514: ben_clf_shd.g_old_rec.clf_attribute_category;
515: End If;
516: If (p_rec.clf_attribute1 = hr_api.g_varchar2) then
517: p_rec.clf_attribute1 :=
518: ben_clf_shd.g_old_rec.clf_attribute1;
519: End If;
520: If (p_rec.clf_attribute2 = hr_api.g_varchar2) then
516: If (p_rec.clf_attribute1 = hr_api.g_varchar2) then
517: p_rec.clf_attribute1 :=
518: ben_clf_shd.g_old_rec.clf_attribute1;
519: End If;
520: If (p_rec.clf_attribute2 = hr_api.g_varchar2) then
521: p_rec.clf_attribute2 :=
522: ben_clf_shd.g_old_rec.clf_attribute2;
523: End If;
524: If (p_rec.clf_attribute3 = hr_api.g_varchar2) then
520: If (p_rec.clf_attribute2 = hr_api.g_varchar2) then
521: p_rec.clf_attribute2 :=
522: ben_clf_shd.g_old_rec.clf_attribute2;
523: End If;
524: If (p_rec.clf_attribute3 = hr_api.g_varchar2) then
525: p_rec.clf_attribute3 :=
526: ben_clf_shd.g_old_rec.clf_attribute3;
527: End If;
528: If (p_rec.clf_attribute4 = hr_api.g_varchar2) then
524: If (p_rec.clf_attribute3 = hr_api.g_varchar2) then
525: p_rec.clf_attribute3 :=
526: ben_clf_shd.g_old_rec.clf_attribute3;
527: End If;
528: If (p_rec.clf_attribute4 = hr_api.g_varchar2) then
529: p_rec.clf_attribute4 :=
530: ben_clf_shd.g_old_rec.clf_attribute4;
531: End If;
532: If (p_rec.clf_attribute5 = hr_api.g_varchar2) then
528: If (p_rec.clf_attribute4 = hr_api.g_varchar2) then
529: p_rec.clf_attribute4 :=
530: ben_clf_shd.g_old_rec.clf_attribute4;
531: End If;
532: If (p_rec.clf_attribute5 = hr_api.g_varchar2) then
533: p_rec.clf_attribute5 :=
534: ben_clf_shd.g_old_rec.clf_attribute5;
535: End If;
536: If (p_rec.clf_attribute6 = hr_api.g_varchar2) then
532: If (p_rec.clf_attribute5 = hr_api.g_varchar2) then
533: p_rec.clf_attribute5 :=
534: ben_clf_shd.g_old_rec.clf_attribute5;
535: End If;
536: If (p_rec.clf_attribute6 = hr_api.g_varchar2) then
537: p_rec.clf_attribute6 :=
538: ben_clf_shd.g_old_rec.clf_attribute6;
539: End If;
540: If (p_rec.clf_attribute7 = hr_api.g_varchar2) then
536: If (p_rec.clf_attribute6 = hr_api.g_varchar2) then
537: p_rec.clf_attribute6 :=
538: ben_clf_shd.g_old_rec.clf_attribute6;
539: End If;
540: If (p_rec.clf_attribute7 = hr_api.g_varchar2) then
541: p_rec.clf_attribute7 :=
542: ben_clf_shd.g_old_rec.clf_attribute7;
543: End If;
544: If (p_rec.clf_attribute8 = hr_api.g_varchar2) then
540: If (p_rec.clf_attribute7 = hr_api.g_varchar2) then
541: p_rec.clf_attribute7 :=
542: ben_clf_shd.g_old_rec.clf_attribute7;
543: End If;
544: If (p_rec.clf_attribute8 = hr_api.g_varchar2) then
545: p_rec.clf_attribute8 :=
546: ben_clf_shd.g_old_rec.clf_attribute8;
547: End If;
548: If (p_rec.clf_attribute9 = hr_api.g_varchar2) then
544: If (p_rec.clf_attribute8 = hr_api.g_varchar2) then
545: p_rec.clf_attribute8 :=
546: ben_clf_shd.g_old_rec.clf_attribute8;
547: End If;
548: If (p_rec.clf_attribute9 = hr_api.g_varchar2) then
549: p_rec.clf_attribute9 :=
550: ben_clf_shd.g_old_rec.clf_attribute9;
551: End If;
552: If (p_rec.clf_attribute10 = hr_api.g_varchar2) then
548: If (p_rec.clf_attribute9 = hr_api.g_varchar2) then
549: p_rec.clf_attribute9 :=
550: ben_clf_shd.g_old_rec.clf_attribute9;
551: End If;
552: If (p_rec.clf_attribute10 = hr_api.g_varchar2) then
553: p_rec.clf_attribute10 :=
554: ben_clf_shd.g_old_rec.clf_attribute10;
555: End If;
556: If (p_rec.clf_attribute11 = hr_api.g_varchar2) then
552: If (p_rec.clf_attribute10 = hr_api.g_varchar2) then
553: p_rec.clf_attribute10 :=
554: ben_clf_shd.g_old_rec.clf_attribute10;
555: End If;
556: If (p_rec.clf_attribute11 = hr_api.g_varchar2) then
557: p_rec.clf_attribute11 :=
558: ben_clf_shd.g_old_rec.clf_attribute11;
559: End If;
560: If (p_rec.clf_attribute12 = hr_api.g_varchar2) then
556: If (p_rec.clf_attribute11 = hr_api.g_varchar2) then
557: p_rec.clf_attribute11 :=
558: ben_clf_shd.g_old_rec.clf_attribute11;
559: End If;
560: If (p_rec.clf_attribute12 = hr_api.g_varchar2) then
561: p_rec.clf_attribute12 :=
562: ben_clf_shd.g_old_rec.clf_attribute12;
563: End If;
564: If (p_rec.clf_attribute13 = hr_api.g_varchar2) then
560: If (p_rec.clf_attribute12 = hr_api.g_varchar2) then
561: p_rec.clf_attribute12 :=
562: ben_clf_shd.g_old_rec.clf_attribute12;
563: End If;
564: If (p_rec.clf_attribute13 = hr_api.g_varchar2) then
565: p_rec.clf_attribute13 :=
566: ben_clf_shd.g_old_rec.clf_attribute13;
567: End If;
568: If (p_rec.clf_attribute14 = hr_api.g_varchar2) then
564: If (p_rec.clf_attribute13 = hr_api.g_varchar2) then
565: p_rec.clf_attribute13 :=
566: ben_clf_shd.g_old_rec.clf_attribute13;
567: End If;
568: If (p_rec.clf_attribute14 = hr_api.g_varchar2) then
569: p_rec.clf_attribute14 :=
570: ben_clf_shd.g_old_rec.clf_attribute14;
571: End If;
572: If (p_rec.clf_attribute15 = hr_api.g_varchar2) then
568: If (p_rec.clf_attribute14 = hr_api.g_varchar2) then
569: p_rec.clf_attribute14 :=
570: ben_clf_shd.g_old_rec.clf_attribute14;
571: End If;
572: If (p_rec.clf_attribute15 = hr_api.g_varchar2) then
573: p_rec.clf_attribute15 :=
574: ben_clf_shd.g_old_rec.clf_attribute15;
575: End If;
576: If (p_rec.clf_attribute16 = hr_api.g_varchar2) then
572: If (p_rec.clf_attribute15 = hr_api.g_varchar2) then
573: p_rec.clf_attribute15 :=
574: ben_clf_shd.g_old_rec.clf_attribute15;
575: End If;
576: If (p_rec.clf_attribute16 = hr_api.g_varchar2) then
577: p_rec.clf_attribute16 :=
578: ben_clf_shd.g_old_rec.clf_attribute16;
579: End If;
580: If (p_rec.clf_attribute17 = hr_api.g_varchar2) then
576: If (p_rec.clf_attribute16 = hr_api.g_varchar2) then
577: p_rec.clf_attribute16 :=
578: ben_clf_shd.g_old_rec.clf_attribute16;
579: End If;
580: If (p_rec.clf_attribute17 = hr_api.g_varchar2) then
581: p_rec.clf_attribute17 :=
582: ben_clf_shd.g_old_rec.clf_attribute17;
583: End If;
584: If (p_rec.clf_attribute18 = hr_api.g_varchar2) then
580: If (p_rec.clf_attribute17 = hr_api.g_varchar2) then
581: p_rec.clf_attribute17 :=
582: ben_clf_shd.g_old_rec.clf_attribute17;
583: End If;
584: If (p_rec.clf_attribute18 = hr_api.g_varchar2) then
585: p_rec.clf_attribute18 :=
586: ben_clf_shd.g_old_rec.clf_attribute18;
587: End If;
588: If (p_rec.clf_attribute19 = hr_api.g_varchar2) then
584: If (p_rec.clf_attribute18 = hr_api.g_varchar2) then
585: p_rec.clf_attribute18 :=
586: ben_clf_shd.g_old_rec.clf_attribute18;
587: End If;
588: If (p_rec.clf_attribute19 = hr_api.g_varchar2) then
589: p_rec.clf_attribute19 :=
590: ben_clf_shd.g_old_rec.clf_attribute19;
591: End If;
592: If (p_rec.clf_attribute20 = hr_api.g_varchar2) then
588: If (p_rec.clf_attribute19 = hr_api.g_varchar2) then
589: p_rec.clf_attribute19 :=
590: ben_clf_shd.g_old_rec.clf_attribute19;
591: End If;
592: If (p_rec.clf_attribute20 = hr_api.g_varchar2) then
593: p_rec.clf_attribute20 :=
594: ben_clf_shd.g_old_rec.clf_attribute20;
595: End If;
596: If (p_rec.clf_attribute21 = hr_api.g_varchar2) then
592: If (p_rec.clf_attribute20 = hr_api.g_varchar2) then
593: p_rec.clf_attribute20 :=
594: ben_clf_shd.g_old_rec.clf_attribute20;
595: End If;
596: If (p_rec.clf_attribute21 = hr_api.g_varchar2) then
597: p_rec.clf_attribute21 :=
598: ben_clf_shd.g_old_rec.clf_attribute21;
599: End If;
600: If (p_rec.clf_attribute22 = hr_api.g_varchar2) then
596: If (p_rec.clf_attribute21 = hr_api.g_varchar2) then
597: p_rec.clf_attribute21 :=
598: ben_clf_shd.g_old_rec.clf_attribute21;
599: End If;
600: If (p_rec.clf_attribute22 = hr_api.g_varchar2) then
601: p_rec.clf_attribute22 :=
602: ben_clf_shd.g_old_rec.clf_attribute22;
603: End If;
604: If (p_rec.clf_attribute23 = hr_api.g_varchar2) then
600: If (p_rec.clf_attribute22 = hr_api.g_varchar2) then
601: p_rec.clf_attribute22 :=
602: ben_clf_shd.g_old_rec.clf_attribute22;
603: End If;
604: If (p_rec.clf_attribute23 = hr_api.g_varchar2) then
605: p_rec.clf_attribute23 :=
606: ben_clf_shd.g_old_rec.clf_attribute23;
607: End If;
608: If (p_rec.clf_attribute24 = hr_api.g_varchar2) then
604: If (p_rec.clf_attribute23 = hr_api.g_varchar2) then
605: p_rec.clf_attribute23 :=
606: ben_clf_shd.g_old_rec.clf_attribute23;
607: End If;
608: If (p_rec.clf_attribute24 = hr_api.g_varchar2) then
609: p_rec.clf_attribute24 :=
610: ben_clf_shd.g_old_rec.clf_attribute24;
611: End If;
612: If (p_rec.clf_attribute25 = hr_api.g_varchar2) then
608: If (p_rec.clf_attribute24 = hr_api.g_varchar2) then
609: p_rec.clf_attribute24 :=
610: ben_clf_shd.g_old_rec.clf_attribute24;
611: End If;
612: If (p_rec.clf_attribute25 = hr_api.g_varchar2) then
613: p_rec.clf_attribute25 :=
614: ben_clf_shd.g_old_rec.clf_attribute25;
615: End If;
616: If (p_rec.clf_attribute26 = hr_api.g_varchar2) then
612: If (p_rec.clf_attribute25 = hr_api.g_varchar2) then
613: p_rec.clf_attribute25 :=
614: ben_clf_shd.g_old_rec.clf_attribute25;
615: End If;
616: If (p_rec.clf_attribute26 = hr_api.g_varchar2) then
617: p_rec.clf_attribute26 :=
618: ben_clf_shd.g_old_rec.clf_attribute26;
619: End If;
620: If (p_rec.clf_attribute27 = hr_api.g_varchar2) then
616: If (p_rec.clf_attribute26 = hr_api.g_varchar2) then
617: p_rec.clf_attribute26 :=
618: ben_clf_shd.g_old_rec.clf_attribute26;
619: End If;
620: If (p_rec.clf_attribute27 = hr_api.g_varchar2) then
621: p_rec.clf_attribute27 :=
622: ben_clf_shd.g_old_rec.clf_attribute27;
623: End If;
624: If (p_rec.clf_attribute28 = hr_api.g_varchar2) then
620: If (p_rec.clf_attribute27 = hr_api.g_varchar2) then
621: p_rec.clf_attribute27 :=
622: ben_clf_shd.g_old_rec.clf_attribute27;
623: End If;
624: If (p_rec.clf_attribute28 = hr_api.g_varchar2) then
625: p_rec.clf_attribute28 :=
626: ben_clf_shd.g_old_rec.clf_attribute28;
627: End If;
628: If (p_rec.clf_attribute29 = hr_api.g_varchar2) then
624: If (p_rec.clf_attribute28 = hr_api.g_varchar2) then
625: p_rec.clf_attribute28 :=
626: ben_clf_shd.g_old_rec.clf_attribute28;
627: End If;
628: If (p_rec.clf_attribute29 = hr_api.g_varchar2) then
629: p_rec.clf_attribute29 :=
630: ben_clf_shd.g_old_rec.clf_attribute29;
631: End If;
632: If (p_rec.clf_attribute30 = hr_api.g_varchar2) then
628: If (p_rec.clf_attribute29 = hr_api.g_varchar2) then
629: p_rec.clf_attribute29 :=
630: ben_clf_shd.g_old_rec.clf_attribute29;
631: End If;
632: If (p_rec.clf_attribute30 = hr_api.g_varchar2) then
633: p_rec.clf_attribute30 :=
634: ben_clf_shd.g_old_rec.clf_attribute30;
635: End If;
636: If (p_rec.sttd_sal_prdcty_cd = hr_api.g_varchar2) then
632: If (p_rec.clf_attribute30 = hr_api.g_varchar2) then
633: p_rec.clf_attribute30 :=
634: ben_clf_shd.g_old_rec.clf_attribute30;
635: End If;
636: If (p_rec.sttd_sal_prdcty_cd = hr_api.g_varchar2) then
637: p_rec.sttd_sal_prdcty_cd :=
638: ben_clf_shd.g_old_rec.sttd_sal_prdcty_cd;
639: End If;
640: --
694: Procedure upd
695: (
696: p_effective_date in date,
697: p_comp_lvl_fctr_id in number,
698: p_business_group_id in number default hr_api.g_number,
699: p_name in varchar2 default hr_api.g_varchar2,
700: p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
695: (
696: p_effective_date in date,
697: p_comp_lvl_fctr_id in number,
698: p_business_group_id in number default hr_api.g_number,
699: p_name in varchar2 default hr_api.g_varchar2,
700: p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
696: p_effective_date in date,
697: p_comp_lvl_fctr_id in number,
698: p_business_group_id in number default hr_api.g_number,
699: p_name in varchar2 default hr_api.g_varchar2,
700: p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
697: p_comp_lvl_fctr_id in number,
698: p_business_group_id in number default hr_api.g_number,
699: p_name in varchar2 default hr_api.g_varchar2,
700: p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
698: p_business_group_id in number default hr_api.g_number,
699: p_name in varchar2 default hr_api.g_varchar2,
700: p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
699: p_name in varchar2 default hr_api.g_varchar2,
700: p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
700: p_comp_lvl_det_cd in varchar2 default hr_api.g_varchar2,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
701: p_comp_lvl_det_rl in number default hr_api.g_number,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
702: p_comp_lvl_uom in varchar2 default hr_api.g_varchar2,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
703: p_comp_src_cd in varchar2 default hr_api.g_varchar2,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
704: p_defined_balance_id in number default hr_api.g_number,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
705: p_no_mn_comp_flag in varchar2 default hr_api.g_varchar2,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
706: p_no_mx_comp_flag in varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
707: p_mx_comp_val in number default hr_api.g_number,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
708: p_mn_comp_val in number default hr_api.g_number,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
710: p_rndg_rl in number default hr_api.g_number,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
711: p_bnfts_bal_id in number default hr_api.g_number,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_comp_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_comp_calc_rl in number default hr_api.g_number,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_proration_flag in Varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_start_day_mo in Varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_end_day_mo in Varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_start_year in Varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_end_year in Varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_clf_attribute_category in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_clf_attribute1 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_clf_attribute2 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_clf_attribute3 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_clf_attribute4 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_clf_attribute5 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_clf_attribute6 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_clf_attribute7 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_clf_attribute8 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_clf_attribute9 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_clf_attribute10 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_clf_attribute11 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_clf_attribute12 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_clf_attribute13 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_clf_attribute14 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_clf_attribute15 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_clf_attribute16 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_clf_attribute17 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_clf_attribute18 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_clf_attribute19 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_clf_attribute20 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_clf_attribute21 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
748: p_clf_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_clf_attribute22 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
748: p_clf_attribute29 in varchar2 default hr_api.g_varchar2,
749: p_clf_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_clf_attribute23 in varchar2 default hr_api.g_varchar2,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
748: p_clf_attribute29 in varchar2 default hr_api.g_varchar2,
749: p_clf_attribute30 in varchar2 default hr_api.g_varchar2,
750: p_object_version_number in out nocopy number,
743: p_clf_attribute24 in varchar2 default hr_api.g_varchar2,
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
748: p_clf_attribute29 in varchar2 default hr_api.g_varchar2,
749: p_clf_attribute30 in varchar2 default hr_api.g_varchar2,
750: p_object_version_number in out nocopy number,
751: p_sttd_sal_prdcty_cd in varchar2 default hr_api.g_varchar2
744: p_clf_attribute25 in varchar2 default hr_api.g_varchar2,
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
748: p_clf_attribute29 in varchar2 default hr_api.g_varchar2,
749: p_clf_attribute30 in varchar2 default hr_api.g_varchar2,
750: p_object_version_number in out nocopy number,
751: p_sttd_sal_prdcty_cd in varchar2 default hr_api.g_varchar2
752:
745: p_clf_attribute26 in varchar2 default hr_api.g_varchar2,
746: p_clf_attribute27 in varchar2 default hr_api.g_varchar2,
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
748: p_clf_attribute29 in varchar2 default hr_api.g_varchar2,
749: p_clf_attribute30 in varchar2 default hr_api.g_varchar2,
750: p_object_version_number in out nocopy number,
751: p_sttd_sal_prdcty_cd in varchar2 default hr_api.g_varchar2
752:
753: ) is
747: p_clf_attribute28 in varchar2 default hr_api.g_varchar2,
748: p_clf_attribute29 in varchar2 default hr_api.g_varchar2,
749: p_clf_attribute30 in varchar2 default hr_api.g_varchar2,
750: p_object_version_number in out nocopy number,
751: p_sttd_sal_prdcty_cd in varchar2 default hr_api.g_varchar2
752:
753: ) is
754: --
755: l_rec ben_clf_shd.g_rec_type;