APPS.BEN_EGD_UPD dependencies on HR_API

Line 129: When hr_api.check_integrity_violated Then

125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: --
128: Exception
129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
132: ben_egd_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

129: When hr_api.check_integrity_violated Then
130: -- A check constraint has been violated
131: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
132: ben_egd_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
137: ben_egd_shd.constraint_error

Line 134: When hr_api.parent_integrity_violated Then

130: -- A check constraint has been violated
131: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
132: ben_egd_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
137: ben_egd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

134: When hr_api.parent_integrity_violated Then
135: -- Parent integrity has been violated
136: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
137: ben_egd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_egd_shd.constraint_error

Line 139: When hr_api.unique_integrity_violated Then

135: -- Parent integrity has been violated
136: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
137: ben_egd_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
146: Raise;
147: End update_dml;

Line 372: when hr_api.cannot_find_prog_unit then

368: );
369: --
370: exception
371: --
372: when hr_api.cannot_find_prog_unit then
373: --
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'ben_elig_dpnt'
376: ,p_hook_type => 'AU');

Line 374: hr_api.cannot_find_prog_unit_error

370: exception
371: --
372: when hr_api.cannot_find_prog_unit then
373: --
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'ben_elig_dpnt'
376: ,p_hook_type => 'AU');
377: --
378: end;

Line 442: If (p_rec.create_dt = hr_api.g_date) then

438: -- p_rec plsql record structure
439: -- to see if a system default is being used. If a system default
440: -- is being used then we must set to the 'current' argument value.
441: --
442: If (p_rec.create_dt = hr_api.g_date) then
443: p_rec.create_dt :=
444: ben_egd_shd.g_old_rec.create_dt;
445: End If;
446: If (p_rec.elig_strt_dt = hr_api.g_date) then

Line 446: If (p_rec.elig_strt_dt = hr_api.g_date) then

442: If (p_rec.create_dt = hr_api.g_date) then
443: p_rec.create_dt :=
444: ben_egd_shd.g_old_rec.create_dt;
445: End If;
446: If (p_rec.elig_strt_dt = hr_api.g_date) then
447: p_rec.elig_strt_dt :=
448: ben_egd_shd.g_old_rec.elig_strt_dt;
449: End If;
450: If (p_rec.elig_thru_dt = hr_api.g_date) then

Line 450: If (p_rec.elig_thru_dt = hr_api.g_date) then

446: If (p_rec.elig_strt_dt = hr_api.g_date) then
447: p_rec.elig_strt_dt :=
448: ben_egd_shd.g_old_rec.elig_strt_dt;
449: End If;
450: If (p_rec.elig_thru_dt = hr_api.g_date) then
451: p_rec.elig_thru_dt :=
452: ben_egd_shd.g_old_rec.elig_thru_dt;
453: End If;
454: If (p_rec.ovrdn_flag = hr_api.g_varchar2) then

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

450: If (p_rec.elig_thru_dt = hr_api.g_date) then
451: p_rec.elig_thru_dt :=
452: ben_egd_shd.g_old_rec.elig_thru_dt;
453: End If;
454: If (p_rec.ovrdn_flag = hr_api.g_varchar2) then
455: p_rec.ovrdn_flag :=
456: ben_egd_shd.g_old_rec.ovrdn_flag;
457: End If;
458: If (p_rec.ovrdn_thru_dt = hr_api.g_date) then

Line 458: If (p_rec.ovrdn_thru_dt = hr_api.g_date) then

454: If (p_rec.ovrdn_flag = hr_api.g_varchar2) then
455: p_rec.ovrdn_flag :=
456: ben_egd_shd.g_old_rec.ovrdn_flag;
457: End If;
458: If (p_rec.ovrdn_thru_dt = hr_api.g_date) then
459: p_rec.ovrdn_thru_dt :=
460: ben_egd_shd.g_old_rec.ovrdn_thru_dt;
461: End If;
462: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then

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

458: If (p_rec.ovrdn_thru_dt = hr_api.g_date) then
459: p_rec.ovrdn_thru_dt :=
460: ben_egd_shd.g_old_rec.ovrdn_thru_dt;
461: End If;
462: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
463: p_rec.inelg_rsn_cd :=
464: ben_egd_shd.g_old_rec.inelg_rsn_cd;
465: End If;
466: If (p_rec.dpnt_inelig_flag = hr_api.g_varchar2) then

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

462: If (p_rec.inelg_rsn_cd = hr_api.g_varchar2) then
463: p_rec.inelg_rsn_cd :=
464: ben_egd_shd.g_old_rec.inelg_rsn_cd;
465: End If;
466: If (p_rec.dpnt_inelig_flag = hr_api.g_varchar2) then
467: p_rec.dpnt_inelig_flag :=
468: ben_egd_shd.g_old_rec.dpnt_inelig_flag;
469: End If;
470: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then

Line 470: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then

466: If (p_rec.dpnt_inelig_flag = hr_api.g_varchar2) then
467: p_rec.dpnt_inelig_flag :=
468: ben_egd_shd.g_old_rec.dpnt_inelig_flag;
469: End If;
470: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
471: p_rec.elig_per_elctbl_chc_id :=
472: ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id;
473: End If;
474: If (p_rec.per_in_ler_id = hr_api.g_number) then

Line 474: If (p_rec.per_in_ler_id = hr_api.g_number) then

470: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
471: p_rec.elig_per_elctbl_chc_id :=
472: ben_egd_shd.g_old_rec.elig_per_elctbl_chc_id;
473: End If;
474: If (p_rec.per_in_ler_id = hr_api.g_number) then
475: p_rec.per_in_ler_id :=
476: ben_egd_shd.g_old_rec.per_in_ler_id;
477: End If;
478: If (p_rec.elig_per_id = hr_api.g_number) then

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

474: If (p_rec.per_in_ler_id = hr_api.g_number) then
475: p_rec.per_in_ler_id :=
476: ben_egd_shd.g_old_rec.per_in_ler_id;
477: End If;
478: If (p_rec.elig_per_id = hr_api.g_number) then
479: p_rec.elig_per_id :=
480: ben_egd_shd.g_old_rec.elig_per_id;
481: End If;
482: If (p_rec.elig_per_opt_id = hr_api.g_number) then

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

478: If (p_rec.elig_per_id = hr_api.g_number) then
479: p_rec.elig_per_id :=
480: ben_egd_shd.g_old_rec.elig_per_id;
481: End If;
482: If (p_rec.elig_per_opt_id = hr_api.g_number) then
483: p_rec.elig_per_opt_id :=
484: ben_egd_shd.g_old_rec.elig_per_opt_id;
485: End If;
486: If (p_rec.elig_cvrd_dpnt_id = hr_api.g_number) then

Line 486: If (p_rec.elig_cvrd_dpnt_id = hr_api.g_number) then

482: If (p_rec.elig_per_opt_id = hr_api.g_number) then
483: p_rec.elig_per_opt_id :=
484: ben_egd_shd.g_old_rec.elig_per_opt_id;
485: End If;
486: If (p_rec.elig_cvrd_dpnt_id = hr_api.g_number) then
487: p_rec.elig_cvrd_dpnt_id :=
488: ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id;
489: End If;
490: If (p_rec.dpnt_person_id = hr_api.g_number) then

Line 490: If (p_rec.dpnt_person_id = hr_api.g_number) then

486: If (p_rec.elig_cvrd_dpnt_id = hr_api.g_number) then
487: p_rec.elig_cvrd_dpnt_id :=
488: ben_egd_shd.g_old_rec.elig_cvrd_dpnt_id;
489: End If;
490: If (p_rec.dpnt_person_id = hr_api.g_number) then
491: p_rec.dpnt_person_id :=
492: ben_egd_shd.g_old_rec.dpnt_person_id;
493: End If;
494: If (p_rec.business_group_id = hr_api.g_number) then

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

490: If (p_rec.dpnt_person_id = hr_api.g_number) then
491: p_rec.dpnt_person_id :=
492: ben_egd_shd.g_old_rec.dpnt_person_id;
493: End If;
494: If (p_rec.business_group_id = hr_api.g_number) then
495: p_rec.business_group_id :=
496: ben_egd_shd.g_old_rec.business_group_id;
497: End If;
498: If (p_rec.egd_attribute_category = hr_api.g_varchar2) then

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

494: If (p_rec.business_group_id = hr_api.g_number) then
495: p_rec.business_group_id :=
496: ben_egd_shd.g_old_rec.business_group_id;
497: End If;
498: If (p_rec.egd_attribute_category = hr_api.g_varchar2) then
499: p_rec.egd_attribute_category :=
500: ben_egd_shd.g_old_rec.egd_attribute_category;
501: End If;
502: If (p_rec.egd_attribute1 = hr_api.g_varchar2) then

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

498: If (p_rec.egd_attribute_category = hr_api.g_varchar2) then
499: p_rec.egd_attribute_category :=
500: ben_egd_shd.g_old_rec.egd_attribute_category;
501: End If;
502: If (p_rec.egd_attribute1 = hr_api.g_varchar2) then
503: p_rec.egd_attribute1 :=
504: ben_egd_shd.g_old_rec.egd_attribute1;
505: End If;
506: If (p_rec.egd_attribute2 = hr_api.g_varchar2) then

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

502: If (p_rec.egd_attribute1 = hr_api.g_varchar2) then
503: p_rec.egd_attribute1 :=
504: ben_egd_shd.g_old_rec.egd_attribute1;
505: End If;
506: If (p_rec.egd_attribute2 = hr_api.g_varchar2) then
507: p_rec.egd_attribute2 :=
508: ben_egd_shd.g_old_rec.egd_attribute2;
509: End If;
510: If (p_rec.egd_attribute3 = hr_api.g_varchar2) then

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

506: If (p_rec.egd_attribute2 = hr_api.g_varchar2) then
507: p_rec.egd_attribute2 :=
508: ben_egd_shd.g_old_rec.egd_attribute2;
509: End If;
510: If (p_rec.egd_attribute3 = hr_api.g_varchar2) then
511: p_rec.egd_attribute3 :=
512: ben_egd_shd.g_old_rec.egd_attribute3;
513: End If;
514: If (p_rec.egd_attribute4 = hr_api.g_varchar2) then

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

510: If (p_rec.egd_attribute3 = hr_api.g_varchar2) then
511: p_rec.egd_attribute3 :=
512: ben_egd_shd.g_old_rec.egd_attribute3;
513: End If;
514: If (p_rec.egd_attribute4 = hr_api.g_varchar2) then
515: p_rec.egd_attribute4 :=
516: ben_egd_shd.g_old_rec.egd_attribute4;
517: End If;
518: If (p_rec.egd_attribute5 = hr_api.g_varchar2) then

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

514: If (p_rec.egd_attribute4 = hr_api.g_varchar2) then
515: p_rec.egd_attribute4 :=
516: ben_egd_shd.g_old_rec.egd_attribute4;
517: End If;
518: If (p_rec.egd_attribute5 = hr_api.g_varchar2) then
519: p_rec.egd_attribute5 :=
520: ben_egd_shd.g_old_rec.egd_attribute5;
521: End If;
522: If (p_rec.egd_attribute6 = hr_api.g_varchar2) then

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

518: If (p_rec.egd_attribute5 = hr_api.g_varchar2) then
519: p_rec.egd_attribute5 :=
520: ben_egd_shd.g_old_rec.egd_attribute5;
521: End If;
522: If (p_rec.egd_attribute6 = hr_api.g_varchar2) then
523: p_rec.egd_attribute6 :=
524: ben_egd_shd.g_old_rec.egd_attribute6;
525: End If;
526: If (p_rec.egd_attribute7 = hr_api.g_varchar2) then

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

522: If (p_rec.egd_attribute6 = hr_api.g_varchar2) then
523: p_rec.egd_attribute6 :=
524: ben_egd_shd.g_old_rec.egd_attribute6;
525: End If;
526: If (p_rec.egd_attribute7 = hr_api.g_varchar2) then
527: p_rec.egd_attribute7 :=
528: ben_egd_shd.g_old_rec.egd_attribute7;
529: End If;
530: If (p_rec.egd_attribute8 = hr_api.g_varchar2) then

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

526: If (p_rec.egd_attribute7 = hr_api.g_varchar2) then
527: p_rec.egd_attribute7 :=
528: ben_egd_shd.g_old_rec.egd_attribute7;
529: End If;
530: If (p_rec.egd_attribute8 = hr_api.g_varchar2) then
531: p_rec.egd_attribute8 :=
532: ben_egd_shd.g_old_rec.egd_attribute8;
533: End If;
534: If (p_rec.egd_attribute9 = hr_api.g_varchar2) then

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

530: If (p_rec.egd_attribute8 = hr_api.g_varchar2) then
531: p_rec.egd_attribute8 :=
532: ben_egd_shd.g_old_rec.egd_attribute8;
533: End If;
534: If (p_rec.egd_attribute9 = hr_api.g_varchar2) then
535: p_rec.egd_attribute9 :=
536: ben_egd_shd.g_old_rec.egd_attribute9;
537: End If;
538: If (p_rec.egd_attribute10 = hr_api.g_varchar2) then

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

534: If (p_rec.egd_attribute9 = hr_api.g_varchar2) then
535: p_rec.egd_attribute9 :=
536: ben_egd_shd.g_old_rec.egd_attribute9;
537: End If;
538: If (p_rec.egd_attribute10 = hr_api.g_varchar2) then
539: p_rec.egd_attribute10 :=
540: ben_egd_shd.g_old_rec.egd_attribute10;
541: End If;
542: If (p_rec.egd_attribute11 = hr_api.g_varchar2) then

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

538: If (p_rec.egd_attribute10 = hr_api.g_varchar2) then
539: p_rec.egd_attribute10 :=
540: ben_egd_shd.g_old_rec.egd_attribute10;
541: End If;
542: If (p_rec.egd_attribute11 = hr_api.g_varchar2) then
543: p_rec.egd_attribute11 :=
544: ben_egd_shd.g_old_rec.egd_attribute11;
545: End If;
546: If (p_rec.egd_attribute12 = hr_api.g_varchar2) then

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

542: If (p_rec.egd_attribute11 = hr_api.g_varchar2) then
543: p_rec.egd_attribute11 :=
544: ben_egd_shd.g_old_rec.egd_attribute11;
545: End If;
546: If (p_rec.egd_attribute12 = hr_api.g_varchar2) then
547: p_rec.egd_attribute12 :=
548: ben_egd_shd.g_old_rec.egd_attribute12;
549: End If;
550: If (p_rec.egd_attribute13 = hr_api.g_varchar2) then

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

546: If (p_rec.egd_attribute12 = hr_api.g_varchar2) then
547: p_rec.egd_attribute12 :=
548: ben_egd_shd.g_old_rec.egd_attribute12;
549: End If;
550: If (p_rec.egd_attribute13 = hr_api.g_varchar2) then
551: p_rec.egd_attribute13 :=
552: ben_egd_shd.g_old_rec.egd_attribute13;
553: End If;
554: If (p_rec.egd_attribute14 = hr_api.g_varchar2) then

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

550: If (p_rec.egd_attribute13 = hr_api.g_varchar2) then
551: p_rec.egd_attribute13 :=
552: ben_egd_shd.g_old_rec.egd_attribute13;
553: End If;
554: If (p_rec.egd_attribute14 = hr_api.g_varchar2) then
555: p_rec.egd_attribute14 :=
556: ben_egd_shd.g_old_rec.egd_attribute14;
557: End If;
558: If (p_rec.egd_attribute15 = hr_api.g_varchar2) then

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

554: If (p_rec.egd_attribute14 = hr_api.g_varchar2) then
555: p_rec.egd_attribute14 :=
556: ben_egd_shd.g_old_rec.egd_attribute14;
557: End If;
558: If (p_rec.egd_attribute15 = hr_api.g_varchar2) then
559: p_rec.egd_attribute15 :=
560: ben_egd_shd.g_old_rec.egd_attribute15;
561: End If;
562: If (p_rec.egd_attribute16 = hr_api.g_varchar2) then

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

558: If (p_rec.egd_attribute15 = hr_api.g_varchar2) then
559: p_rec.egd_attribute15 :=
560: ben_egd_shd.g_old_rec.egd_attribute15;
561: End If;
562: If (p_rec.egd_attribute16 = hr_api.g_varchar2) then
563: p_rec.egd_attribute16 :=
564: ben_egd_shd.g_old_rec.egd_attribute16;
565: End If;
566: If (p_rec.egd_attribute17 = hr_api.g_varchar2) then

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

562: If (p_rec.egd_attribute16 = hr_api.g_varchar2) then
563: p_rec.egd_attribute16 :=
564: ben_egd_shd.g_old_rec.egd_attribute16;
565: End If;
566: If (p_rec.egd_attribute17 = hr_api.g_varchar2) then
567: p_rec.egd_attribute17 :=
568: ben_egd_shd.g_old_rec.egd_attribute17;
569: End If;
570: If (p_rec.egd_attribute18 = hr_api.g_varchar2) then

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

566: If (p_rec.egd_attribute17 = hr_api.g_varchar2) then
567: p_rec.egd_attribute17 :=
568: ben_egd_shd.g_old_rec.egd_attribute17;
569: End If;
570: If (p_rec.egd_attribute18 = hr_api.g_varchar2) then
571: p_rec.egd_attribute18 :=
572: ben_egd_shd.g_old_rec.egd_attribute18;
573: End If;
574: If (p_rec.egd_attribute19 = hr_api.g_varchar2) then

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

570: If (p_rec.egd_attribute18 = hr_api.g_varchar2) then
571: p_rec.egd_attribute18 :=
572: ben_egd_shd.g_old_rec.egd_attribute18;
573: End If;
574: If (p_rec.egd_attribute19 = hr_api.g_varchar2) then
575: p_rec.egd_attribute19 :=
576: ben_egd_shd.g_old_rec.egd_attribute19;
577: End If;
578: If (p_rec.egd_attribute20 = hr_api.g_varchar2) then

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

574: If (p_rec.egd_attribute19 = hr_api.g_varchar2) then
575: p_rec.egd_attribute19 :=
576: ben_egd_shd.g_old_rec.egd_attribute19;
577: End If;
578: If (p_rec.egd_attribute20 = hr_api.g_varchar2) then
579: p_rec.egd_attribute20 :=
580: ben_egd_shd.g_old_rec.egd_attribute20;
581: End If;
582: If (p_rec.egd_attribute21 = hr_api.g_varchar2) then

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

578: If (p_rec.egd_attribute20 = hr_api.g_varchar2) then
579: p_rec.egd_attribute20 :=
580: ben_egd_shd.g_old_rec.egd_attribute20;
581: End If;
582: If (p_rec.egd_attribute21 = hr_api.g_varchar2) then
583: p_rec.egd_attribute21 :=
584: ben_egd_shd.g_old_rec.egd_attribute21;
585: End If;
586: If (p_rec.egd_attribute22 = hr_api.g_varchar2) then

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

582: If (p_rec.egd_attribute21 = hr_api.g_varchar2) then
583: p_rec.egd_attribute21 :=
584: ben_egd_shd.g_old_rec.egd_attribute21;
585: End If;
586: If (p_rec.egd_attribute22 = hr_api.g_varchar2) then
587: p_rec.egd_attribute22 :=
588: ben_egd_shd.g_old_rec.egd_attribute22;
589: End If;
590: If (p_rec.egd_attribute23 = hr_api.g_varchar2) then

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

586: If (p_rec.egd_attribute22 = hr_api.g_varchar2) then
587: p_rec.egd_attribute22 :=
588: ben_egd_shd.g_old_rec.egd_attribute22;
589: End If;
590: If (p_rec.egd_attribute23 = hr_api.g_varchar2) then
591: p_rec.egd_attribute23 :=
592: ben_egd_shd.g_old_rec.egd_attribute23;
593: End If;
594: If (p_rec.egd_attribute24 = hr_api.g_varchar2) then

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

590: If (p_rec.egd_attribute23 = hr_api.g_varchar2) then
591: p_rec.egd_attribute23 :=
592: ben_egd_shd.g_old_rec.egd_attribute23;
593: End If;
594: If (p_rec.egd_attribute24 = hr_api.g_varchar2) then
595: p_rec.egd_attribute24 :=
596: ben_egd_shd.g_old_rec.egd_attribute24;
597: End If;
598: If (p_rec.egd_attribute25 = hr_api.g_varchar2) then

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

594: If (p_rec.egd_attribute24 = hr_api.g_varchar2) then
595: p_rec.egd_attribute24 :=
596: ben_egd_shd.g_old_rec.egd_attribute24;
597: End If;
598: If (p_rec.egd_attribute25 = hr_api.g_varchar2) then
599: p_rec.egd_attribute25 :=
600: ben_egd_shd.g_old_rec.egd_attribute25;
601: End If;
602: If (p_rec.egd_attribute26 = hr_api.g_varchar2) then

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

598: If (p_rec.egd_attribute25 = hr_api.g_varchar2) then
599: p_rec.egd_attribute25 :=
600: ben_egd_shd.g_old_rec.egd_attribute25;
601: End If;
602: If (p_rec.egd_attribute26 = hr_api.g_varchar2) then
603: p_rec.egd_attribute26 :=
604: ben_egd_shd.g_old_rec.egd_attribute26;
605: End If;
606: If (p_rec.egd_attribute27 = hr_api.g_varchar2) then

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

602: If (p_rec.egd_attribute26 = hr_api.g_varchar2) then
603: p_rec.egd_attribute26 :=
604: ben_egd_shd.g_old_rec.egd_attribute26;
605: End If;
606: If (p_rec.egd_attribute27 = hr_api.g_varchar2) then
607: p_rec.egd_attribute27 :=
608: ben_egd_shd.g_old_rec.egd_attribute27;
609: End If;
610: If (p_rec.egd_attribute28 = hr_api.g_varchar2) then

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

606: If (p_rec.egd_attribute27 = hr_api.g_varchar2) then
607: p_rec.egd_attribute27 :=
608: ben_egd_shd.g_old_rec.egd_attribute27;
609: End If;
610: If (p_rec.egd_attribute28 = hr_api.g_varchar2) then
611: p_rec.egd_attribute28 :=
612: ben_egd_shd.g_old_rec.egd_attribute28;
613: End If;
614: If (p_rec.egd_attribute29 = hr_api.g_varchar2) then

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

610: If (p_rec.egd_attribute28 = hr_api.g_varchar2) then
611: p_rec.egd_attribute28 :=
612: ben_egd_shd.g_old_rec.egd_attribute28;
613: End If;
614: If (p_rec.egd_attribute29 = hr_api.g_varchar2) then
615: p_rec.egd_attribute29 :=
616: ben_egd_shd.g_old_rec.egd_attribute29;
617: End If;
618: If (p_rec.egd_attribute30 = hr_api.g_varchar2) then

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

614: If (p_rec.egd_attribute29 = hr_api.g_varchar2) then
615: p_rec.egd_attribute29 :=
616: ben_egd_shd.g_old_rec.egd_attribute29;
617: End If;
618: If (p_rec.egd_attribute30 = hr_api.g_varchar2) then
619: p_rec.egd_attribute30 :=
620: ben_egd_shd.g_old_rec.egd_attribute30;
621: End If;
622: If (p_rec.request_id = hr_api.g_number) then

Line 622: If (p_rec.request_id = hr_api.g_number) then

618: If (p_rec.egd_attribute30 = hr_api.g_varchar2) then
619: p_rec.egd_attribute30 :=
620: ben_egd_shd.g_old_rec.egd_attribute30;
621: End If;
622: If (p_rec.request_id = hr_api.g_number) then
623: p_rec.request_id :=
624: ben_egd_shd.g_old_rec.request_id;
625: End If;
626: If (p_rec.program_application_id = hr_api.g_number) then

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

622: If (p_rec.request_id = hr_api.g_number) then
623: p_rec.request_id :=
624: ben_egd_shd.g_old_rec.request_id;
625: End If;
626: If (p_rec.program_application_id = hr_api.g_number) then
627: p_rec.program_application_id :=
628: ben_egd_shd.g_old_rec.program_application_id;
629: End If;
630: If (p_rec.program_id = hr_api.g_number) then

Line 630: If (p_rec.program_id = hr_api.g_number) then

626: If (p_rec.program_application_id = hr_api.g_number) then
627: p_rec.program_application_id :=
628: ben_egd_shd.g_old_rec.program_application_id;
629: End If;
630: If (p_rec.program_id = hr_api.g_number) then
631: p_rec.program_id :=
632: ben_egd_shd.g_old_rec.program_id;
633: End If;
634: If (p_rec.program_update_date = hr_api.g_date) then

Line 634: If (p_rec.program_update_date = hr_api.g_date) then

630: If (p_rec.program_id = hr_api.g_number) then
631: p_rec.program_id :=
632: ben_egd_shd.g_old_rec.program_id;
633: End If;
634: If (p_rec.program_update_date = hr_api.g_date) then
635: p_rec.program_update_date :=
636: ben_egd_shd.g_old_rec.program_update_date;
637: End If;
638:

Line 697: p_create_dt in date default hr_api.g_date,

693: Procedure upd
694: (
695: p_effective_date in date,
696: p_elig_dpnt_id in number,
697: p_create_dt in date default hr_api.g_date,
698: p_elig_strt_dt in date default hr_api.g_date,
699: p_elig_thru_dt in date default hr_api.g_date,
700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,

Line 698: p_elig_strt_dt in date default hr_api.g_date,

694: (
695: p_effective_date in date,
696: p_elig_dpnt_id in number,
697: p_create_dt in date default hr_api.g_date,
698: p_elig_strt_dt in date default hr_api.g_date,
699: p_elig_thru_dt in date default hr_api.g_date,
700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,

Line 699: p_elig_thru_dt in date default hr_api.g_date,

695: p_effective_date in date,
696: p_elig_dpnt_id in number,
697: p_create_dt in date default hr_api.g_date,
698: p_elig_strt_dt in date default hr_api.g_date,
699: p_elig_thru_dt in date default hr_api.g_date,
700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,

Line 700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,

696: p_elig_dpnt_id in number,
697: p_create_dt in date default hr_api.g_date,
698: p_elig_strt_dt in date default hr_api.g_date,
699: p_elig_thru_dt in date default hr_api.g_date,
700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,

Line 701: p_ovrdn_thru_dt in date default hr_api.g_date,

697: p_create_dt in date default hr_api.g_date,
698: p_elig_strt_dt in date default hr_api.g_date,
699: p_elig_thru_dt in date default hr_api.g_date,
700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,

Line 702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,

698: p_elig_strt_dt in date default hr_api.g_date,
699: p_elig_thru_dt in date default hr_api.g_date,
700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,

Line 703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,

699: p_elig_thru_dt in date default hr_api.g_date,
700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,

Line 704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,

700: p_ovrdn_flag in varchar2 default hr_api.g_varchar2,
701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,

Line 705: p_per_in_ler_id in number default hr_api.g_number,

701: p_ovrdn_thru_dt in date default hr_api.g_date,
702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,

Line 706: p_elig_per_id in number default hr_api.g_number,

702: p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2,
703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,

Line 707: p_elig_per_opt_id in number default hr_api.g_number,

703: p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2,
704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,

Line 708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,

704: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,

Line 709: p_dpnt_person_id in number default hr_api.g_number,

705: p_per_in_ler_id in number default hr_api.g_number,
706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,

Line 710: p_business_group_id in number default hr_api.g_number,

706: p_elig_per_id in number default hr_api.g_number,
707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,

Line 711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,

707: p_elig_per_opt_id in number default hr_api.g_number,
708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,

Line 712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,

708: p_elig_cvrd_dpnt_id in number default hr_api.g_number,
709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,

Line 713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,

709: p_dpnt_person_id in number default hr_api.g_number,
710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,

Line 714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,

710: p_business_group_id in number default hr_api.g_number,
711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,

Line 715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,

711: p_egd_attribute_category in varchar2 default hr_api.g_varchar2,
712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,

Line 716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,

712: p_egd_attribute1 in varchar2 default hr_api.g_varchar2,
713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,

Line 717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,

713: p_egd_attribute2 in varchar2 default hr_api.g_varchar2,
714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,

Line 718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,

714: p_egd_attribute3 in varchar2 default hr_api.g_varchar2,
715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,

Line 719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,

715: p_egd_attribute4 in varchar2 default hr_api.g_varchar2,
716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,

Line 720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,

716: p_egd_attribute5 in varchar2 default hr_api.g_varchar2,
717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,

Line 721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,

717: p_egd_attribute6 in varchar2 default hr_api.g_varchar2,
718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,

Line 722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,

718: p_egd_attribute7 in varchar2 default hr_api.g_varchar2,
719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,

Line 723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,

719: p_egd_attribute8 in varchar2 default hr_api.g_varchar2,
720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,

Line 724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,

720: p_egd_attribute9 in varchar2 default hr_api.g_varchar2,
721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,

Line 725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,

721: p_egd_attribute10 in varchar2 default hr_api.g_varchar2,
722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,

Line 726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,

722: p_egd_attribute11 in varchar2 default hr_api.g_varchar2,
723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,

Line 727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,

723: p_egd_attribute12 in varchar2 default hr_api.g_varchar2,
724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,

Line 728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,

724: p_egd_attribute13 in varchar2 default hr_api.g_varchar2,
725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,

Line 729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,

725: p_egd_attribute14 in varchar2 default hr_api.g_varchar2,
726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,

Line 730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,

726: p_egd_attribute15 in varchar2 default hr_api.g_varchar2,
727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,

Line 731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,

727: p_egd_attribute16 in varchar2 default hr_api.g_varchar2,
728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,

Line 732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,

728: p_egd_attribute17 in varchar2 default hr_api.g_varchar2,
729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,

Line 733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,

729: p_egd_attribute18 in varchar2 default hr_api.g_varchar2,
730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,

Line 734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,

730: p_egd_attribute19 in varchar2 default hr_api.g_varchar2,
731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,

Line 735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,

731: p_egd_attribute20 in varchar2 default hr_api.g_varchar2,
732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,

Line 736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,

732: p_egd_attribute21 in varchar2 default hr_api.g_varchar2,
733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,

Line 737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,

733: p_egd_attribute22 in varchar2 default hr_api.g_varchar2,
734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,

Line 738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,

734: p_egd_attribute23 in varchar2 default hr_api.g_varchar2,
735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,

Line 739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,

735: p_egd_attribute24 in varchar2 default hr_api.g_varchar2,
736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,
743: p_program_application_id in number default hr_api.g_number,

Line 740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,

736: p_egd_attribute25 in varchar2 default hr_api.g_varchar2,
737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,
743: p_program_application_id in number default hr_api.g_number,
744: p_program_id in number default hr_api.g_number,

Line 741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,

737: p_egd_attribute26 in varchar2 default hr_api.g_varchar2,
738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,
743: p_program_application_id in number default hr_api.g_number,
744: p_program_id in number default hr_api.g_number,
745: p_program_update_date in date default hr_api.g_date,

Line 742: p_request_id in number default hr_api.g_number,

738: p_egd_attribute27 in varchar2 default hr_api.g_varchar2,
739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,
743: p_program_application_id in number default hr_api.g_number,
744: p_program_id in number default hr_api.g_number,
745: p_program_update_date in date default hr_api.g_date,
746: p_object_version_number in out nocopy number

Line 743: p_program_application_id in number default hr_api.g_number,

739: p_egd_attribute28 in varchar2 default hr_api.g_varchar2,
740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,
743: p_program_application_id in number default hr_api.g_number,
744: p_program_id in number default hr_api.g_number,
745: p_program_update_date in date default hr_api.g_date,
746: p_object_version_number in out nocopy number
747: ) is

Line 744: p_program_id in number default hr_api.g_number,

740: p_egd_attribute29 in varchar2 default hr_api.g_varchar2,
741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,
743: p_program_application_id in number default hr_api.g_number,
744: p_program_id in number default hr_api.g_number,
745: p_program_update_date in date default hr_api.g_date,
746: p_object_version_number in out nocopy number
747: ) is
748: --

Line 745: p_program_update_date in date default hr_api.g_date,

741: p_egd_attribute30 in varchar2 default hr_api.g_varchar2,
742: p_request_id in number default hr_api.g_number,
743: p_program_application_id in number default hr_api.g_number,
744: p_program_id in number default hr_api.g_number,
745: p_program_update_date in date default hr_api.g_date,
746: p_object_version_number in out nocopy number
747: ) is
748: --
749: l_rec ben_egd_shd.g_rec_type;