APPS.BEN_CLF_UPD dependencies on HR_API

Line 133: When hr_api.check_integrity_violated Then

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

Line 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

Line 138: When hr_api.parent_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
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 143: When hr_api.unique_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
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 356: when hr_api.cannot_find_prog_unit then

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

Line 358: hr_api.cannot_find_prog_unit_error

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;

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 491: If (p_rec.proration_flag = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

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

Line 512: If (p_rec.clf_attribute_category = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 698: p_business_group_id in number default hr_api.g_number,

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,

Line 699: p_name 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,

Line 700: p_comp_lvl_det_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,

Line 701: p_comp_lvl_det_rl 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,

Line 702: p_comp_lvl_uom 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,

Line 703: p_comp_src_cd 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,

Line 704: p_defined_balance_id 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,

Line 705: p_no_mn_comp_flag 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,
709: p_rndg_cd in varchar2 default hr_api.g_varchar2,

Line 706: p_no_mx_comp_flag 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,

Line 707: p_mx_comp_val 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,

Line 708: p_mn_comp_val 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,

Line 709: p_rndg_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,

Line 710: p_rndg_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,

Line 711: p_bnfts_bal_id in number default hr_api.g_number,

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,

Line 712: p_comp_alt_val_to_use_cd 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,

Line 713: p_comp_calc_rl 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,
717: p_start_year in Varchar2 default hr_api.g_varchar2,

Line 714: p_proration_flag 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,

Line 715: p_start_day_mo 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,

Line 716: p_end_day_mo 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,

Line 717: p_start_year 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,

Line 718: p_end_year 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,

Line 719: p_clf_attribute_category 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,

Line 720: p_clf_attribute1 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,

Line 721: p_clf_attribute2 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,

Line 722: p_clf_attribute3 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,

Line 723: p_clf_attribute4 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,

Line 724: p_clf_attribute5 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,

Line 725: p_clf_attribute6 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,

Line 726: p_clf_attribute7 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,

Line 727: p_clf_attribute8 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,

Line 728: p_clf_attribute9 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,

Line 729: p_clf_attribute10 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,

Line 730: p_clf_attribute11 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,

Line 731: p_clf_attribute12 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,

Line 732: p_clf_attribute13 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,

Line 733: p_clf_attribute14 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,

Line 734: p_clf_attribute15 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,

Line 735: p_clf_attribute16 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,

Line 736: p_clf_attribute17 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,

Line 737: p_clf_attribute18 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,

Line 738: p_clf_attribute19 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,

Line 739: p_clf_attribute20 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,

Line 740: p_clf_attribute21 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,

Line 741: p_clf_attribute22 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,

Line 742: p_clf_attribute23 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,

Line 743: p_clf_attribute24 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,

Line 744: p_clf_attribute25 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,

Line 745: p_clf_attribute26 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,

Line 746: p_clf_attribute27 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,

Line 747: p_clf_attribute28 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,
751: p_sttd_sal_prdcty_cd in varchar2 default hr_api.g_varchar2

Line 748: p_clf_attribute29 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:

Line 749: p_clf_attribute30 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:
753: ) is

Line 751: p_sttd_sal_prdcty_cd 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
754: --
755: l_rec ben_clf_shd.g_rec_type;