eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EGL_UPD dependencies on HR_API

Line 142: When hr_api.check_integrity_violated Then

138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: --
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
145: ben_egl_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
145: ben_egl_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
150: ben_egl_shd.constraint_error

Line 147: When hr_api.parent_integrity_violated Then

143: -- A check constraint has been violated
144: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
145: ben_egl_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
150: ben_egl_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
150: ben_egl_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
155: ben_egl_shd.constraint_error

Line 152: When hr_api.unique_integrity_violated Then

148: -- Parent integrity has been violated
149: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
150: ben_egl_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
155: ben_egl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
155: ben_egl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When Others Then
158: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
159: Raise;
160: End update_dml;

Line 379: when hr_api.cannot_find_prog_unit then

375: );
376: --
377: exception
378: --
379: when hr_api.cannot_find_prog_unit then
380: --
381: hr_api.cannot_find_prog_unit_error
382: (p_module_name => 'ben_eligy_criteria'
383: ,p_hook_type => 'AU');

Line 381: hr_api.cannot_find_prog_unit_error

377: exception
378: --
379: when hr_api.cannot_find_prog_unit then
380: --
381: hr_api.cannot_find_prog_unit_error
382: (p_module_name => 'ben_eligy_criteria'
383: ,p_hook_type => 'AU');
384: --
385: end;

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

446: -- to see if a system default is being used. If a system default
447: -- is being used then we must set to the 'current' argument value.
448: --
449:
450: If (p_rec.name = hr_api.g_varchar2) then
451: p_rec.name :=
452: ben_egl_shd.g_old_rec.name;
453: End If;
454: If (p_rec.short_code = hr_api.g_varchar2) then

Line 454: If (p_rec.short_code = hr_api.g_varchar2) then

450: If (p_rec.name = hr_api.g_varchar2) then
451: p_rec.name :=
452: ben_egl_shd.g_old_rec.name;
453: End If;
454: If (p_rec.short_code = hr_api.g_varchar2) then
455: p_rec.short_code :=
456: ben_egl_shd.g_old_rec.short_code;
457: End If;
458: If (p_rec.description = hr_api.g_varchar2) then

Line 458: If (p_rec.description = hr_api.g_varchar2) then

454: If (p_rec.short_code = hr_api.g_varchar2) then
455: p_rec.short_code :=
456: ben_egl_shd.g_old_rec.short_code;
457: End If;
458: If (p_rec.description = hr_api.g_varchar2) then
459: p_rec.description :=
460: ben_egl_shd.g_old_rec.description;
461: End If;
462: If (p_rec.criteria_type = hr_api.g_varchar2) then

Line 462: If (p_rec.criteria_type = hr_api.g_varchar2) then

458: If (p_rec.description = hr_api.g_varchar2) then
459: p_rec.description :=
460: ben_egl_shd.g_old_rec.description;
461: End If;
462: If (p_rec.criteria_type = hr_api.g_varchar2) then
463: p_rec.criteria_type :=
464: ben_egl_shd.g_old_rec.criteria_type;
465: End If;
466: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then

Line 466: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then

462: If (p_rec.criteria_type = hr_api.g_varchar2) then
463: p_rec.criteria_type :=
464: ben_egl_shd.g_old_rec.criteria_type;
465: End If;
466: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then
467: p_rec.crit_col1_val_type_cd :=
468: ben_egl_shd.g_old_rec.crit_col1_val_type_cd;
469: End If;
470: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then

Line 470: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then

466: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then
467: p_rec.crit_col1_val_type_cd :=
468: ben_egl_shd.g_old_rec.crit_col1_val_type_cd;
469: End If;
470: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then
471: p_rec.crit_col1_datatype :=
472: ben_egl_shd.g_old_rec.crit_col1_datatype;
473: End If;
474: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then

Line 474: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then

470: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then
471: p_rec.crit_col1_datatype :=
472: ben_egl_shd.g_old_rec.crit_col1_datatype;
473: End If;
474: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then
475: p_rec.col1_lookup_type :=
476: ben_egl_shd.g_old_rec.col1_lookup_type;
477: End If;
478: If (p_rec.col1_value_set_id = hr_api.g_number) then

Line 478: If (p_rec.col1_value_set_id = hr_api.g_number) then

474: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then
475: p_rec.col1_lookup_type :=
476: ben_egl_shd.g_old_rec.col1_lookup_type;
477: End If;
478: If (p_rec.col1_value_set_id = hr_api.g_number) then
479: p_rec.col1_value_set_id :=
480: ben_egl_shd.g_old_rec.col1_value_set_id;
481: End If;
482: If (p_rec.access_table_name1 = hr_api.g_varchar2) then

Line 482: If (p_rec.access_table_name1 = hr_api.g_varchar2) then

478: If (p_rec.col1_value_set_id = hr_api.g_number) then
479: p_rec.col1_value_set_id :=
480: ben_egl_shd.g_old_rec.col1_value_set_id;
481: End If;
482: If (p_rec.access_table_name1 = hr_api.g_varchar2) then
483: p_rec.access_table_name1 :=
484: ben_egl_shd.g_old_rec.access_table_name1;
485: End If;
486: If (p_rec.access_column_name1 = hr_api.g_varchar2) then

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

482: If (p_rec.access_table_name1 = hr_api.g_varchar2) then
483: p_rec.access_table_name1 :=
484: ben_egl_shd.g_old_rec.access_table_name1;
485: End If;
486: If (p_rec.access_column_name1 = hr_api.g_varchar2) then
487: p_rec.access_column_name1 :=
488: ben_egl_shd.g_old_rec.access_column_name1;
489: End If;
490: If (p_rec.time_entry_access_tab_nam1 = hr_api.g_varchar2) then

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

486: If (p_rec.access_column_name1 = hr_api.g_varchar2) then
487: p_rec.access_column_name1 :=
488: ben_egl_shd.g_old_rec.access_column_name1;
489: End If;
490: If (p_rec.time_entry_access_tab_nam1 = hr_api.g_varchar2) then
491: p_rec.time_entry_access_tab_nam1 :=
492: ben_egl_shd.g_old_rec.time_entry_access_tab_nam1;
493: End If;
494: If (p_rec.time_entry_access_col_nam1 = hr_api.g_varchar2) then

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

490: If (p_rec.time_entry_access_tab_nam1 = hr_api.g_varchar2) then
491: p_rec.time_entry_access_tab_nam1 :=
492: ben_egl_shd.g_old_rec.time_entry_access_tab_nam1;
493: End If;
494: If (p_rec.time_entry_access_col_nam1 = hr_api.g_varchar2) then
495: p_rec.time_entry_access_col_nam1 :=
496: ben_egl_shd.g_old_rec.time_entry_access_col_nam1;
497: End If;
498: If (p_rec.crit_col2_val_type_cd = hr_api.g_varchar2) then

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

494: If (p_rec.time_entry_access_col_nam1 = hr_api.g_varchar2) then
495: p_rec.time_entry_access_col_nam1 :=
496: ben_egl_shd.g_old_rec.time_entry_access_col_nam1;
497: End If;
498: If (p_rec.crit_col2_val_type_cd = hr_api.g_varchar2) then
499: p_rec.crit_col2_val_type_cd :=
500: ben_egl_shd.g_old_rec.crit_col2_val_type_cd;
501: End If;
502: If (p_rec.crit_col2_datatype = hr_api.g_varchar2) then

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

498: If (p_rec.crit_col2_val_type_cd = hr_api.g_varchar2) then
499: p_rec.crit_col2_val_type_cd :=
500: ben_egl_shd.g_old_rec.crit_col2_val_type_cd;
501: End If;
502: If (p_rec.crit_col2_datatype = hr_api.g_varchar2) then
503: p_rec.crit_col2_datatype :=
504: ben_egl_shd.g_old_rec.crit_col2_datatype;
505: End If;
506: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then

Line 506: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then

502: If (p_rec.crit_col2_datatype = hr_api.g_varchar2) then
503: p_rec.crit_col2_datatype :=
504: ben_egl_shd.g_old_rec.crit_col2_datatype;
505: End If;
506: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then
507: p_rec.col2_lookup_type :=
508: ben_egl_shd.g_old_rec.col2_lookup_type;
509: End If;
510: If (p_rec.col2_value_set_id = hr_api.g_number) then

Line 510: If (p_rec.col2_value_set_id = hr_api.g_number) then

506: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then
507: p_rec.col2_lookup_type :=
508: ben_egl_shd.g_old_rec.col2_lookup_type;
509: End If;
510: If (p_rec.col2_value_set_id = hr_api.g_number) then
511: p_rec.col2_value_set_id :=
512: ben_egl_shd.g_old_rec.col2_value_set_id;
513: End If;
514: If (p_rec.access_table_name2 = hr_api.g_varchar2) then

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

510: If (p_rec.col2_value_set_id = hr_api.g_number) then
511: p_rec.col2_value_set_id :=
512: ben_egl_shd.g_old_rec.col2_value_set_id;
513: End If;
514: If (p_rec.access_table_name2 = hr_api.g_varchar2) then
515: p_rec.access_table_name2 :=
516: ben_egl_shd.g_old_rec.access_table_name2;
517: End If;
518: If (p_rec.access_column_name2 = hr_api.g_varchar2) then

Line 518: If (p_rec.access_column_name2 = hr_api.g_varchar2) then

514: If (p_rec.access_table_name2 = hr_api.g_varchar2) then
515: p_rec.access_table_name2 :=
516: ben_egl_shd.g_old_rec.access_table_name2;
517: End If;
518: If (p_rec.access_column_name2 = hr_api.g_varchar2) then
519: p_rec.access_column_name2 :=
520: ben_egl_shd.g_old_rec.access_column_name2;
521: End If;
522: If (p_rec.time_entry_access_tab_nam2 = hr_api.g_varchar2) then

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

518: If (p_rec.access_column_name2 = hr_api.g_varchar2) then
519: p_rec.access_column_name2 :=
520: ben_egl_shd.g_old_rec.access_column_name2;
521: End If;
522: If (p_rec.time_entry_access_tab_nam2 = hr_api.g_varchar2) then
523: p_rec.time_entry_access_tab_nam2 :=
524: ben_egl_shd.g_old_rec.time_entry_access_tab_nam2;
525: End If;
526: If (p_rec.time_entry_access_col_nam2 = hr_api.g_varchar2) then

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

522: If (p_rec.time_entry_access_tab_nam2 = hr_api.g_varchar2) then
523: p_rec.time_entry_access_tab_nam2 :=
524: ben_egl_shd.g_old_rec.time_entry_access_tab_nam2;
525: End If;
526: If (p_rec.time_entry_access_col_nam2 = hr_api.g_varchar2) then
527: p_rec.time_entry_access_col_nam2 :=
528: ben_egl_shd.g_old_rec.time_entry_access_col_nam2;
529: End If;
530: If (p_rec.access_calc_rule = hr_api.g_number) then

Line 530: If (p_rec.access_calc_rule = hr_api.g_number) then

526: If (p_rec.time_entry_access_col_nam2 = hr_api.g_varchar2) then
527: p_rec.time_entry_access_col_nam2 :=
528: ben_egl_shd.g_old_rec.time_entry_access_col_nam2;
529: End If;
530: If (p_rec.access_calc_rule = hr_api.g_number) then
531: p_rec.access_calc_rule :=
532: ben_egl_shd.g_old_rec.access_calc_rule;
533: End If;
534: If (p_rec.allow_range_validation_flg = hr_api.g_varchar2) then

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

530: If (p_rec.access_calc_rule = hr_api.g_number) then
531: p_rec.access_calc_rule :=
532: ben_egl_shd.g_old_rec.access_calc_rule;
533: End If;
534: If (p_rec.allow_range_validation_flg = hr_api.g_varchar2) then
535: p_rec.allow_range_validation_flg :=
536: ben_egl_shd.g_old_rec.allow_range_validation_flg;
537: End If;
538: If (p_rec.user_defined_flag = hr_api.g_varchar2) then

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

534: If (p_rec.allow_range_validation_flg = hr_api.g_varchar2) then
535: p_rec.allow_range_validation_flg :=
536: ben_egl_shd.g_old_rec.allow_range_validation_flg;
537: End If;
538: If (p_rec.user_defined_flag = hr_api.g_varchar2) then
539: p_rec.user_defined_flag :=
540: ben_egl_shd.g_old_rec.user_defined_flag;
541: End If;
542: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

538: If (p_rec.user_defined_flag = hr_api.g_varchar2) then
539: p_rec.user_defined_flag :=
540: ben_egl_shd.g_old_rec.user_defined_flag;
541: End If;
542: If (p_rec.legislation_code = hr_api.g_varchar2) then
543: p_rec.legislation_code :=
544: ben_egl_shd.g_old_rec.legislation_code;
545: End If;
546: If (p_rec.business_group_id = hr_api.g_number) then

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

542: If (p_rec.legislation_code = hr_api.g_varchar2) then
543: p_rec.legislation_code :=
544: ben_egl_shd.g_old_rec.legislation_code;
545: End If;
546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: ben_egl_shd.g_old_rec.business_group_id;
549: End If;
550:

Line 551: If (p_rec.egl_attribute_category = hr_api.g_varchar2) then

547: p_rec.business_group_id :=
548: ben_egl_shd.g_old_rec.business_group_id;
549: End If;
550:
551: If (p_rec.egl_attribute_category = hr_api.g_varchar2) then
552: p_rec.egl_attribute_category :=
553: ben_egl_shd.g_old_rec.egl_attribute_category;
554: End If;
555: If (p_rec.egl_attribute1 = hr_api.g_varchar2) then

Line 555: If (p_rec.egl_attribute1 = hr_api.g_varchar2) then

551: If (p_rec.egl_attribute_category = hr_api.g_varchar2) then
552: p_rec.egl_attribute_category :=
553: ben_egl_shd.g_old_rec.egl_attribute_category;
554: End If;
555: If (p_rec.egl_attribute1 = hr_api.g_varchar2) then
556: p_rec.egl_attribute1 :=
557: ben_egl_shd.g_old_rec.egl_attribute1;
558: End If;
559: If (p_rec.egl_attribute2 = hr_api.g_varchar2) then

Line 559: If (p_rec.egl_attribute2 = hr_api.g_varchar2) then

555: If (p_rec.egl_attribute1 = hr_api.g_varchar2) then
556: p_rec.egl_attribute1 :=
557: ben_egl_shd.g_old_rec.egl_attribute1;
558: End If;
559: If (p_rec.egl_attribute2 = hr_api.g_varchar2) then
560: p_rec.egl_attribute2 :=
561: ben_egl_shd.g_old_rec.egl_attribute2;
562: End If;
563: If (p_rec.egl_attribute3 = hr_api.g_varchar2) then

Line 563: If (p_rec.egl_attribute3 = hr_api.g_varchar2) then

559: If (p_rec.egl_attribute2 = hr_api.g_varchar2) then
560: p_rec.egl_attribute2 :=
561: ben_egl_shd.g_old_rec.egl_attribute2;
562: End If;
563: If (p_rec.egl_attribute3 = hr_api.g_varchar2) then
564: p_rec.egl_attribute3 :=
565: ben_egl_shd.g_old_rec.egl_attribute3;
566: End If;
567: If (p_rec.egl_attribute4 = hr_api.g_varchar2) then

Line 567: If (p_rec.egl_attribute4 = hr_api.g_varchar2) then

563: If (p_rec.egl_attribute3 = hr_api.g_varchar2) then
564: p_rec.egl_attribute3 :=
565: ben_egl_shd.g_old_rec.egl_attribute3;
566: End If;
567: If (p_rec.egl_attribute4 = hr_api.g_varchar2) then
568: p_rec.egl_attribute4 :=
569: ben_egl_shd.g_old_rec.egl_attribute4;
570: End If;
571: If (p_rec.egl_attribute5 = hr_api.g_varchar2) then

Line 571: If (p_rec.egl_attribute5 = hr_api.g_varchar2) then

567: If (p_rec.egl_attribute4 = hr_api.g_varchar2) then
568: p_rec.egl_attribute4 :=
569: ben_egl_shd.g_old_rec.egl_attribute4;
570: End If;
571: If (p_rec.egl_attribute5 = hr_api.g_varchar2) then
572: p_rec.egl_attribute5 :=
573: ben_egl_shd.g_old_rec.egl_attribute5;
574: End If;
575: If (p_rec.egl_attribute6 = hr_api.g_varchar2) then

Line 575: If (p_rec.egl_attribute6 = hr_api.g_varchar2) then

571: If (p_rec.egl_attribute5 = hr_api.g_varchar2) then
572: p_rec.egl_attribute5 :=
573: ben_egl_shd.g_old_rec.egl_attribute5;
574: End If;
575: If (p_rec.egl_attribute6 = hr_api.g_varchar2) then
576: p_rec.egl_attribute6 :=
577: ben_egl_shd.g_old_rec.egl_attribute6;
578: End If;
579: If (p_rec.egl_attribute7 = hr_api.g_varchar2) then

Line 579: If (p_rec.egl_attribute7 = hr_api.g_varchar2) then

575: If (p_rec.egl_attribute6 = hr_api.g_varchar2) then
576: p_rec.egl_attribute6 :=
577: ben_egl_shd.g_old_rec.egl_attribute6;
578: End If;
579: If (p_rec.egl_attribute7 = hr_api.g_varchar2) then
580: p_rec.egl_attribute7 :=
581: ben_egl_shd.g_old_rec.egl_attribute7;
582: End If;
583: If (p_rec.egl_attribute8 = hr_api.g_varchar2) then

Line 583: If (p_rec.egl_attribute8 = hr_api.g_varchar2) then

579: If (p_rec.egl_attribute7 = hr_api.g_varchar2) then
580: p_rec.egl_attribute7 :=
581: ben_egl_shd.g_old_rec.egl_attribute7;
582: End If;
583: If (p_rec.egl_attribute8 = hr_api.g_varchar2) then
584: p_rec.egl_attribute8 :=
585: ben_egl_shd.g_old_rec.egl_attribute8;
586: End If;
587: If (p_rec.egl_attribute9 = hr_api.g_varchar2) then

Line 587: If (p_rec.egl_attribute9 = hr_api.g_varchar2) then

583: If (p_rec.egl_attribute8 = hr_api.g_varchar2) then
584: p_rec.egl_attribute8 :=
585: ben_egl_shd.g_old_rec.egl_attribute8;
586: End If;
587: If (p_rec.egl_attribute9 = hr_api.g_varchar2) then
588: p_rec.egl_attribute9 :=
589: ben_egl_shd.g_old_rec.egl_attribute9;
590: End If;
591: If (p_rec.egl_attribute10 = hr_api.g_varchar2) then

Line 591: If (p_rec.egl_attribute10 = hr_api.g_varchar2) then

587: If (p_rec.egl_attribute9 = hr_api.g_varchar2) then
588: p_rec.egl_attribute9 :=
589: ben_egl_shd.g_old_rec.egl_attribute9;
590: End If;
591: If (p_rec.egl_attribute10 = hr_api.g_varchar2) then
592: p_rec.egl_attribute10 :=
593: ben_egl_shd.g_old_rec.egl_attribute10;
594: End If;
595: If (p_rec.egl_attribute11 = hr_api.g_varchar2) then

Line 595: If (p_rec.egl_attribute11 = hr_api.g_varchar2) then

591: If (p_rec.egl_attribute10 = hr_api.g_varchar2) then
592: p_rec.egl_attribute10 :=
593: ben_egl_shd.g_old_rec.egl_attribute10;
594: End If;
595: If (p_rec.egl_attribute11 = hr_api.g_varchar2) then
596: p_rec.egl_attribute11 :=
597: ben_egl_shd.g_old_rec.egl_attribute11;
598: End If;
599: If (p_rec.egl_attribute12 = hr_api.g_varchar2) then

Line 599: If (p_rec.egl_attribute12 = hr_api.g_varchar2) then

595: If (p_rec.egl_attribute11 = hr_api.g_varchar2) then
596: p_rec.egl_attribute11 :=
597: ben_egl_shd.g_old_rec.egl_attribute11;
598: End If;
599: If (p_rec.egl_attribute12 = hr_api.g_varchar2) then
600: p_rec.egl_attribute12 :=
601: ben_egl_shd.g_old_rec.egl_attribute12;
602: End If;
603: If (p_rec.egl_attribute13 = hr_api.g_varchar2) then

Line 603: If (p_rec.egl_attribute13 = hr_api.g_varchar2) then

599: If (p_rec.egl_attribute12 = hr_api.g_varchar2) then
600: p_rec.egl_attribute12 :=
601: ben_egl_shd.g_old_rec.egl_attribute12;
602: End If;
603: If (p_rec.egl_attribute13 = hr_api.g_varchar2) then
604: p_rec.egl_attribute13 :=
605: ben_egl_shd.g_old_rec.egl_attribute13;
606: End If;
607: If (p_rec.egl_attribute14 = hr_api.g_varchar2) then

Line 607: If (p_rec.egl_attribute14 = hr_api.g_varchar2) then

603: If (p_rec.egl_attribute13 = hr_api.g_varchar2) then
604: p_rec.egl_attribute13 :=
605: ben_egl_shd.g_old_rec.egl_attribute13;
606: End If;
607: If (p_rec.egl_attribute14 = hr_api.g_varchar2) then
608: p_rec.egl_attribute14 :=
609: ben_egl_shd.g_old_rec.egl_attribute14;
610: End If;
611: If (p_rec.egl_attribute15 = hr_api.g_varchar2) then

Line 611: If (p_rec.egl_attribute15 = hr_api.g_varchar2) then

607: If (p_rec.egl_attribute14 = hr_api.g_varchar2) then
608: p_rec.egl_attribute14 :=
609: ben_egl_shd.g_old_rec.egl_attribute14;
610: End If;
611: If (p_rec.egl_attribute15 = hr_api.g_varchar2) then
612: p_rec.egl_attribute15 :=
613: ben_egl_shd.g_old_rec.egl_attribute15;
614: End If;
615: If (p_rec.egl_attribute16 = hr_api.g_varchar2) then

Line 615: If (p_rec.egl_attribute16 = hr_api.g_varchar2) then

611: If (p_rec.egl_attribute15 = hr_api.g_varchar2) then
612: p_rec.egl_attribute15 :=
613: ben_egl_shd.g_old_rec.egl_attribute15;
614: End If;
615: If (p_rec.egl_attribute16 = hr_api.g_varchar2) then
616: p_rec.egl_attribute16 :=
617: ben_egl_shd.g_old_rec.egl_attribute16;
618: End If;
619: If (p_rec.egl_attribute17 = hr_api.g_varchar2) then

Line 619: If (p_rec.egl_attribute17 = hr_api.g_varchar2) then

615: If (p_rec.egl_attribute16 = hr_api.g_varchar2) then
616: p_rec.egl_attribute16 :=
617: ben_egl_shd.g_old_rec.egl_attribute16;
618: End If;
619: If (p_rec.egl_attribute17 = hr_api.g_varchar2) then
620: p_rec.egl_attribute17 :=
621: ben_egl_shd.g_old_rec.egl_attribute17;
622: End If;
623: If (p_rec.egl_attribute18 = hr_api.g_varchar2) then

Line 623: If (p_rec.egl_attribute18 = hr_api.g_varchar2) then

619: If (p_rec.egl_attribute17 = hr_api.g_varchar2) then
620: p_rec.egl_attribute17 :=
621: ben_egl_shd.g_old_rec.egl_attribute17;
622: End If;
623: If (p_rec.egl_attribute18 = hr_api.g_varchar2) then
624: p_rec.egl_attribute18 :=
625: ben_egl_shd.g_old_rec.egl_attribute18;
626: End If;
627: If (p_rec.egl_attribute19 = hr_api.g_varchar2) then

Line 627: If (p_rec.egl_attribute19 = hr_api.g_varchar2) then

623: If (p_rec.egl_attribute18 = hr_api.g_varchar2) then
624: p_rec.egl_attribute18 :=
625: ben_egl_shd.g_old_rec.egl_attribute18;
626: End If;
627: If (p_rec.egl_attribute19 = hr_api.g_varchar2) then
628: p_rec.egl_attribute19 :=
629: ben_egl_shd.g_old_rec.egl_attribute19;
630: End If;
631: If (p_rec.egl_attribute20 = hr_api.g_varchar2) then

Line 631: If (p_rec.egl_attribute20 = hr_api.g_varchar2) then

627: If (p_rec.egl_attribute19 = hr_api.g_varchar2) then
628: p_rec.egl_attribute19 :=
629: ben_egl_shd.g_old_rec.egl_attribute19;
630: End If;
631: If (p_rec.egl_attribute20 = hr_api.g_varchar2) then
632: p_rec.egl_attribute20 :=
633: ben_egl_shd.g_old_rec.egl_attribute20;
634: End If;
635: If (p_rec.egl_attribute21 = hr_api.g_varchar2) then

Line 635: If (p_rec.egl_attribute21 = hr_api.g_varchar2) then

631: If (p_rec.egl_attribute20 = hr_api.g_varchar2) then
632: p_rec.egl_attribute20 :=
633: ben_egl_shd.g_old_rec.egl_attribute20;
634: End If;
635: If (p_rec.egl_attribute21 = hr_api.g_varchar2) then
636: p_rec.egl_attribute21 :=
637: ben_egl_shd.g_old_rec.egl_attribute21;
638: End If;
639: If (p_rec.egl_attribute22 = hr_api.g_varchar2) then

Line 639: If (p_rec.egl_attribute22 = hr_api.g_varchar2) then

635: If (p_rec.egl_attribute21 = hr_api.g_varchar2) then
636: p_rec.egl_attribute21 :=
637: ben_egl_shd.g_old_rec.egl_attribute21;
638: End If;
639: If (p_rec.egl_attribute22 = hr_api.g_varchar2) then
640: p_rec.egl_attribute22 :=
641: ben_egl_shd.g_old_rec.egl_attribute22;
642: End If;
643: If (p_rec.egl_attribute23 = hr_api.g_varchar2) then

Line 643: If (p_rec.egl_attribute23 = hr_api.g_varchar2) then

639: If (p_rec.egl_attribute22 = hr_api.g_varchar2) then
640: p_rec.egl_attribute22 :=
641: ben_egl_shd.g_old_rec.egl_attribute22;
642: End If;
643: If (p_rec.egl_attribute23 = hr_api.g_varchar2) then
644: p_rec.egl_attribute23 :=
645: ben_egl_shd.g_old_rec.egl_attribute23;
646: End If;
647: If (p_rec.egl_attribute24 = hr_api.g_varchar2) then

Line 647: If (p_rec.egl_attribute24 = hr_api.g_varchar2) then

643: If (p_rec.egl_attribute23 = hr_api.g_varchar2) then
644: p_rec.egl_attribute23 :=
645: ben_egl_shd.g_old_rec.egl_attribute23;
646: End If;
647: If (p_rec.egl_attribute24 = hr_api.g_varchar2) then
648: p_rec.egl_attribute24 :=
649: ben_egl_shd.g_old_rec.egl_attribute24;
650: End If;
651: If (p_rec.egl_attribute25 = hr_api.g_varchar2) then

Line 651: If (p_rec.egl_attribute25 = hr_api.g_varchar2) then

647: If (p_rec.egl_attribute24 = hr_api.g_varchar2) then
648: p_rec.egl_attribute24 :=
649: ben_egl_shd.g_old_rec.egl_attribute24;
650: End If;
651: If (p_rec.egl_attribute25 = hr_api.g_varchar2) then
652: p_rec.egl_attribute25 :=
653: ben_egl_shd.g_old_rec.egl_attribute25;
654: End If;
655: If (p_rec.egl_attribute26 = hr_api.g_varchar2) then

Line 655: If (p_rec.egl_attribute26 = hr_api.g_varchar2) then

651: If (p_rec.egl_attribute25 = hr_api.g_varchar2) then
652: p_rec.egl_attribute25 :=
653: ben_egl_shd.g_old_rec.egl_attribute25;
654: End If;
655: If (p_rec.egl_attribute26 = hr_api.g_varchar2) then
656: p_rec.egl_attribute26 :=
657: ben_egl_shd.g_old_rec.egl_attribute26;
658: End If;
659: If (p_rec.egl_attribute27 = hr_api.g_varchar2) then

Line 659: If (p_rec.egl_attribute27 = hr_api.g_varchar2) then

655: If (p_rec.egl_attribute26 = hr_api.g_varchar2) then
656: p_rec.egl_attribute26 :=
657: ben_egl_shd.g_old_rec.egl_attribute26;
658: End If;
659: If (p_rec.egl_attribute27 = hr_api.g_varchar2) then
660: p_rec.egl_attribute27 :=
661: ben_egl_shd.g_old_rec.egl_attribute27;
662: End If;
663: If (p_rec.egl_attribute28 = hr_api.g_varchar2) then

Line 663: If (p_rec.egl_attribute28 = hr_api.g_varchar2) then

659: If (p_rec.egl_attribute27 = hr_api.g_varchar2) then
660: p_rec.egl_attribute27 :=
661: ben_egl_shd.g_old_rec.egl_attribute27;
662: End If;
663: If (p_rec.egl_attribute28 = hr_api.g_varchar2) then
664: p_rec.egl_attribute28 :=
665: ben_egl_shd.g_old_rec.egl_attribute28;
666: End If;
667: If (p_rec.egl_attribute29 = hr_api.g_varchar2) then

Line 667: If (p_rec.egl_attribute29 = hr_api.g_varchar2) then

663: If (p_rec.egl_attribute28 = hr_api.g_varchar2) then
664: p_rec.egl_attribute28 :=
665: ben_egl_shd.g_old_rec.egl_attribute28;
666: End If;
667: If (p_rec.egl_attribute29 = hr_api.g_varchar2) then
668: p_rec.egl_attribute29 :=
669: ben_egl_shd.g_old_rec.egl_attribute29;
670: End If;
671: If (p_rec.egl_attribute30 = hr_api.g_varchar2) then

Line 671: If (p_rec.egl_attribute30 = hr_api.g_varchar2) then

667: If (p_rec.egl_attribute29 = hr_api.g_varchar2) then
668: p_rec.egl_attribute29 :=
669: ben_egl_shd.g_old_rec.egl_attribute29;
670: End If;
671: If (p_rec.egl_attribute30 = hr_api.g_varchar2) then
672: p_rec.egl_attribute30 :=
673: ben_egl_shd.g_old_rec.egl_attribute30;
674: End If;
675: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then

Line 675: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then

671: If (p_rec.egl_attribute30 = hr_api.g_varchar2) then
672: p_rec.egl_attribute30 :=
673: ben_egl_shd.g_old_rec.egl_attribute30;
674: End If;
675: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then
676: p_rec.allow_range_validation_flag2 :=
677: ben_egl_shd.g_old_rec.allow_range_validation_flag2;
678: End If;
679: If (p_rec.access_calc_rule2 = hr_api.g_number) then

Line 679: If (p_rec.access_calc_rule2 = hr_api.g_number) then

675: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then
676: p_rec.allow_range_validation_flag2 :=
677: ben_egl_shd.g_old_rec.allow_range_validation_flag2;
678: End If;
679: If (p_rec.access_calc_rule2 = hr_api.g_number) then
680: p_rec.access_calc_rule2 :=
681: ben_egl_shd.g_old_rec.access_calc_rule2;
682: End If;
683: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then

Line 683: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then

679: If (p_rec.access_calc_rule2 = hr_api.g_number) then
680: p_rec.access_calc_rule2 :=
681: ben_egl_shd.g_old_rec.access_calc_rule2;
682: End If;
683: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then
684: p_rec.time_access_calc_rule1 :=
685: ben_egl_shd.g_old_rec.time_access_calc_rule1;
686: End If;
687: If (p_rec.time_access_calc_rule2 = hr_api.g_number) then

Line 687: If (p_rec.time_access_calc_rule2 = hr_api.g_number) then

683: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then
684: p_rec.time_access_calc_rule1 :=
685: ben_egl_shd.g_old_rec.time_access_calc_rule1;
686: End If;
687: If (p_rec.time_access_calc_rule2 = hr_api.g_number) then
688: p_rec.time_access_calc_rule2 :=
689: ben_egl_shd.g_old_rec.time_access_calc_rule2;
690: End If;
691:

Line 745: ,p_name in varchar2 default hr_api.g_varchar2

741: -- ----------------------------------------------------------------------------
742: Procedure upd
743: (
744: p_eligy_criteria_id in number
745: ,p_name in varchar2 default hr_api.g_varchar2
746: ,p_short_code in varchar2 default hr_api.g_varchar2
747: ,p_description in varchar2 default hr_api.g_varchar2
748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2

Line 746: ,p_short_code in varchar2 default hr_api.g_varchar2

742: Procedure upd
743: (
744: p_eligy_criteria_id in number
745: ,p_name in varchar2 default hr_api.g_varchar2
746: ,p_short_code in varchar2 default hr_api.g_varchar2
747: ,p_description in varchar2 default hr_api.g_varchar2
748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2

Line 747: ,p_description in varchar2 default hr_api.g_varchar2

743: (
744: p_eligy_criteria_id in number
745: ,p_name in varchar2 default hr_api.g_varchar2
746: ,p_short_code in varchar2 default hr_api.g_varchar2
747: ,p_description in varchar2 default hr_api.g_varchar2
748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2

Line 748: ,p_criteria_type in varchar2 default hr_api.g_varchar2

744: p_eligy_criteria_id in number
745: ,p_name in varchar2 default hr_api.g_varchar2
746: ,p_short_code in varchar2 default hr_api.g_varchar2
747: ,p_description in varchar2 default hr_api.g_varchar2
748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number

Line 749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2

745: ,p_name in varchar2 default hr_api.g_varchar2
746: ,p_short_code in varchar2 default hr_api.g_varchar2
747: ,p_description in varchar2 default hr_api.g_varchar2
748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2

Line 750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2

746: ,p_short_code in varchar2 default hr_api.g_varchar2
747: ,p_description in varchar2 default hr_api.g_varchar2
748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2

Line 751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2

747: ,p_description in varchar2 default hr_api.g_varchar2
748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2

Line 752: ,p_col1_value_set_id in number default hr_api.g_number

748: ,p_criteria_type in varchar2 default hr_api.g_varchar2
749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2

Line 753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2

749: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2

Line 754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2

750: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2

Line 755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2

751: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2

Line 756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2

752: ,p_col1_value_set_id in number default hr_api.g_number
753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number

Line 757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2

753: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2

Line 758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2

754: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2

Line 759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2

755: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2

Line 760: ,p_col2_value_set_id in number default hr_api.g_number

756: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2

Line 761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2

757: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number

Line 762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2

758: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2

Line 763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2

759: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2

Line 764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2

760: ,p_col2_value_set_id in number default hr_api.g_number
761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number

Line 765: ,p_access_calc_rule in number default hr_api.g_number

761: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2

762: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2

Line 767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2

763: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2

Line 768: ,p_business_group_id in number default hr_api.g_number

764: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2

Line 769: ,p_legislation_code in varchar2 default hr_api.g_varchar2

765: ,p_access_calc_rule in number default hr_api.g_number
766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2

Line 770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2

766: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2

Line 771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2

767: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2

Line 772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2

768: ,p_business_group_id in number default hr_api.g_number
769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2

Line 773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2

769: ,p_legislation_code in varchar2 default hr_api.g_varchar2
770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2

Line 774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2

770: ,p_egl_attribute_category in varchar2 default hr_api.g_varchar2
771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2

Line 775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2

771: ,p_egl_attribute1 in varchar2 default hr_api.g_varchar2
772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2

Line 776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2

772: ,p_egl_attribute2 in varchar2 default hr_api.g_varchar2
773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2

Line 777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2

773: ,p_egl_attribute3 in varchar2 default hr_api.g_varchar2
774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2

Line 778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2

774: ,p_egl_attribute4 in varchar2 default hr_api.g_varchar2
775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2

Line 779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2

775: ,p_egl_attribute5 in varchar2 default hr_api.g_varchar2
776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2

Line 780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2

776: ,p_egl_attribute6 in varchar2 default hr_api.g_varchar2
777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2

Line 781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2

777: ,p_egl_attribute7 in varchar2 default hr_api.g_varchar2
778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2

Line 782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2

778: ,p_egl_attribute8 in varchar2 default hr_api.g_varchar2
779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2

Line 783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2

779: ,p_egl_attribute9 in varchar2 default hr_api.g_varchar2
780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2

Line 784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2

780: ,p_egl_attribute10 in varchar2 default hr_api.g_varchar2
781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2

Line 785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2

781: ,p_egl_attribute11 in varchar2 default hr_api.g_varchar2
782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2

Line 786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2

782: ,p_egl_attribute12 in varchar2 default hr_api.g_varchar2
783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2

Line 787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2

783: ,p_egl_attribute13 in varchar2 default hr_api.g_varchar2
784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2

Line 788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2

784: ,p_egl_attribute14 in varchar2 default hr_api.g_varchar2
785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2

Line 789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2

785: ,p_egl_attribute15 in varchar2 default hr_api.g_varchar2
786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2

Line 790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2

786: ,p_egl_attribute16 in varchar2 default hr_api.g_varchar2
787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2

Line 791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2

787: ,p_egl_attribute17 in varchar2 default hr_api.g_varchar2
788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2

Line 792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2

788: ,p_egl_attribute18 in varchar2 default hr_api.g_varchar2
789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2

Line 793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2

789: ,p_egl_attribute19 in varchar2 default hr_api.g_varchar2
790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2

Line 794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2

790: ,p_egl_attribute20 in varchar2 default hr_api.g_varchar2
791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2

Line 795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2

791: ,p_egl_attribute21 in varchar2 default hr_api.g_varchar2
792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2

Line 796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2

792: ,p_egl_attribute22 in varchar2 default hr_api.g_varchar2
793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2

Line 797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2

793: ,p_egl_attribute23 in varchar2 default hr_api.g_varchar2
794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
801: ,p_object_version_number in out nocopy number

Line 798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2

794: ,p_egl_attribute24 in varchar2 default hr_api.g_varchar2
795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
801: ,p_object_version_number in out nocopy number
802: ,p_effective_date in date

Line 799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2

795: ,p_egl_attribute25 in varchar2 default hr_api.g_varchar2
796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
801: ,p_object_version_number in out nocopy number
802: ,p_effective_date in date
803: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2

Line 800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2

796: ,p_egl_attribute26 in varchar2 default hr_api.g_varchar2
797: ,p_egl_attribute27 in varchar2 default hr_api.g_varchar2
798: ,p_egl_attribute28 in varchar2 default hr_api.g_varchar2
799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
801: ,p_object_version_number in out nocopy number
802: ,p_effective_date in date
803: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
804: ,p_access_calc_rule2 in number default hr_api.g_number

Line 803: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2

799: ,p_egl_attribute29 in varchar2 default hr_api.g_varchar2
800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
801: ,p_object_version_number in out nocopy number
802: ,p_effective_date in date
803: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
804: ,p_access_calc_rule2 in number default hr_api.g_number
805: ,p_time_access_calc_rule1 in number default hr_api.g_number
806: ,p_time_access_calc_rule2 in number default hr_api.g_number
807: ) is

Line 804: ,p_access_calc_rule2 in number default hr_api.g_number

800: ,p_egl_attribute30 in varchar2 default hr_api.g_varchar2
801: ,p_object_version_number in out nocopy number
802: ,p_effective_date in date
803: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
804: ,p_access_calc_rule2 in number default hr_api.g_number
805: ,p_time_access_calc_rule1 in number default hr_api.g_number
806: ,p_time_access_calc_rule2 in number default hr_api.g_number
807: ) is
808: --

Line 805: ,p_time_access_calc_rule1 in number default hr_api.g_number

801: ,p_object_version_number in out nocopy number
802: ,p_effective_date in date
803: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
804: ,p_access_calc_rule2 in number default hr_api.g_number
805: ,p_time_access_calc_rule1 in number default hr_api.g_number
806: ,p_time_access_calc_rule2 in number default hr_api.g_number
807: ) is
808: --
809: l_rec ben_egl_shd.g_rec_type;

Line 806: ,p_time_access_calc_rule2 in number default hr_api.g_number

802: ,p_effective_date in date
803: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
804: ,p_access_calc_rule2 in number default hr_api.g_number
805: ,p_time_access_calc_rule1 in number default hr_api.g_number
806: ,p_time_access_calc_rule2 in number default hr_api.g_number
807: ) is
808: --
809: l_rec ben_egl_shd.g_rec_type;
810: l_proc varchar2(72) := g_package||'upd';