APPS.BEN_ECC_UPD dependencies on HR_API

Line 122: When hr_api.check_integrity_violated Then

118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: --
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
125: ben_ecc_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
125: ben_ecc_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
130: ben_ecc_shd.constraint_error

Line 127: When hr_api.parent_integrity_violated Then

123: -- A check constraint has been violated
124: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
125: ben_ecc_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
130: ben_ecc_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
130: ben_ecc_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
135: ben_ecc_shd.constraint_error

Line 132: When hr_api.unique_integrity_violated Then

128: -- Parent integrity has been violated
129: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
130: ben_ecc_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
135: ben_ecc_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
135: ben_ecc_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
139: Raise;
140: End update_dml;

Line 323: when hr_api.cannot_find_prog_unit then

319: );
320: --
321: exception
322: --
323: when hr_api.cannot_find_prog_unit then
324: --
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'ben_elctbl_chc_ctfn'
327: ,p_hook_type => 'AU');

Line 325: hr_api.cannot_find_prog_unit_error

321: exception
322: --
323: when hr_api.cannot_find_prog_unit then
324: --
325: hr_api.cannot_find_prog_unit_error
326: (p_module_name => 'ben_elctbl_chc_ctfn'
327: ,p_hook_type => 'AU');
328: --
329: end;

Line 393: If (p_rec.enrt_ctfn_typ_cd = hr_api.g_varchar2) then

389: -- p_rec plsql record structure
390: -- to see if a system default is being used. If a system default
391: -- is being used then we must set to the 'current' argument value.
392: --
393: If (p_rec.enrt_ctfn_typ_cd = hr_api.g_varchar2) then
394: p_rec.enrt_ctfn_typ_cd :=
395: ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd;
396: End If;
397: If (p_rec.rqd_flag = hr_api.g_varchar2) then

Line 397: If (p_rec.rqd_flag = hr_api.g_varchar2) then

393: If (p_rec.enrt_ctfn_typ_cd = hr_api.g_varchar2) then
394: p_rec.enrt_ctfn_typ_cd :=
395: ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd;
396: End If;
397: If (p_rec.rqd_flag = hr_api.g_varchar2) then
398: p_rec.rqd_flag :=
399: ben_ecc_shd.g_old_rec.rqd_flag;
400: End If;
401: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then

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

397: If (p_rec.rqd_flag = hr_api.g_varchar2) then
398: p_rec.rqd_flag :=
399: ben_ecc_shd.g_old_rec.rqd_flag;
400: End If;
401: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
402: p_rec.elig_per_elctbl_chc_id :=
403: ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id;
404: End If;
405: If (p_rec.enrt_bnft_id = hr_api.g_number) then

Line 405: If (p_rec.enrt_bnft_id = hr_api.g_number) then

401: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
402: p_rec.elig_per_elctbl_chc_id :=
403: ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id;
404: End If;
405: If (p_rec.enrt_bnft_id = hr_api.g_number) then
406: p_rec.enrt_bnft_id :=
407: ben_ecc_shd.g_old_rec.enrt_bnft_id;
408: End If;
409: If (p_rec.business_group_id = hr_api.g_number) then

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

405: If (p_rec.enrt_bnft_id = hr_api.g_number) then
406: p_rec.enrt_bnft_id :=
407: ben_ecc_shd.g_old_rec.enrt_bnft_id;
408: End If;
409: If (p_rec.business_group_id = hr_api.g_number) then
410: p_rec.business_group_id :=
411: ben_ecc_shd.g_old_rec.business_group_id;
412: End If;
413: If (p_rec.ecc_attribute_category = hr_api.g_varchar2) then

Line 413: If (p_rec.ecc_attribute_category = hr_api.g_varchar2) then

409: If (p_rec.business_group_id = hr_api.g_number) then
410: p_rec.business_group_id :=
411: ben_ecc_shd.g_old_rec.business_group_id;
412: End If;
413: If (p_rec.ecc_attribute_category = hr_api.g_varchar2) then
414: p_rec.ecc_attribute_category :=
415: ben_ecc_shd.g_old_rec.ecc_attribute_category;
416: End If;
417: If (p_rec.ecc_attribute1 = hr_api.g_varchar2) then

Line 417: If (p_rec.ecc_attribute1 = hr_api.g_varchar2) then

413: If (p_rec.ecc_attribute_category = hr_api.g_varchar2) then
414: p_rec.ecc_attribute_category :=
415: ben_ecc_shd.g_old_rec.ecc_attribute_category;
416: End If;
417: If (p_rec.ecc_attribute1 = hr_api.g_varchar2) then
418: p_rec.ecc_attribute1 :=
419: ben_ecc_shd.g_old_rec.ecc_attribute1;
420: End If;
421: If (p_rec.ecc_attribute2 = hr_api.g_varchar2) then

Line 421: If (p_rec.ecc_attribute2 = hr_api.g_varchar2) then

417: If (p_rec.ecc_attribute1 = hr_api.g_varchar2) then
418: p_rec.ecc_attribute1 :=
419: ben_ecc_shd.g_old_rec.ecc_attribute1;
420: End If;
421: If (p_rec.ecc_attribute2 = hr_api.g_varchar2) then
422: p_rec.ecc_attribute2 :=
423: ben_ecc_shd.g_old_rec.ecc_attribute2;
424: End If;
425: If (p_rec.ecc_attribute3 = hr_api.g_varchar2) then

Line 425: If (p_rec.ecc_attribute3 = hr_api.g_varchar2) then

421: If (p_rec.ecc_attribute2 = hr_api.g_varchar2) then
422: p_rec.ecc_attribute2 :=
423: ben_ecc_shd.g_old_rec.ecc_attribute2;
424: End If;
425: If (p_rec.ecc_attribute3 = hr_api.g_varchar2) then
426: p_rec.ecc_attribute3 :=
427: ben_ecc_shd.g_old_rec.ecc_attribute3;
428: End If;
429: If (p_rec.ecc_attribute4 = hr_api.g_varchar2) then

Line 429: If (p_rec.ecc_attribute4 = hr_api.g_varchar2) then

425: If (p_rec.ecc_attribute3 = hr_api.g_varchar2) then
426: p_rec.ecc_attribute3 :=
427: ben_ecc_shd.g_old_rec.ecc_attribute3;
428: End If;
429: If (p_rec.ecc_attribute4 = hr_api.g_varchar2) then
430: p_rec.ecc_attribute4 :=
431: ben_ecc_shd.g_old_rec.ecc_attribute4;
432: End If;
433: If (p_rec.ecc_attribute5 = hr_api.g_varchar2) then

Line 433: If (p_rec.ecc_attribute5 = hr_api.g_varchar2) then

429: If (p_rec.ecc_attribute4 = hr_api.g_varchar2) then
430: p_rec.ecc_attribute4 :=
431: ben_ecc_shd.g_old_rec.ecc_attribute4;
432: End If;
433: If (p_rec.ecc_attribute5 = hr_api.g_varchar2) then
434: p_rec.ecc_attribute5 :=
435: ben_ecc_shd.g_old_rec.ecc_attribute5;
436: End If;
437: If (p_rec.ecc_attribute6 = hr_api.g_varchar2) then

Line 437: If (p_rec.ecc_attribute6 = hr_api.g_varchar2) then

433: If (p_rec.ecc_attribute5 = hr_api.g_varchar2) then
434: p_rec.ecc_attribute5 :=
435: ben_ecc_shd.g_old_rec.ecc_attribute5;
436: End If;
437: If (p_rec.ecc_attribute6 = hr_api.g_varchar2) then
438: p_rec.ecc_attribute6 :=
439: ben_ecc_shd.g_old_rec.ecc_attribute6;
440: End If;
441: If (p_rec.ecc_attribute7 = hr_api.g_varchar2) then

Line 441: If (p_rec.ecc_attribute7 = hr_api.g_varchar2) then

437: If (p_rec.ecc_attribute6 = hr_api.g_varchar2) then
438: p_rec.ecc_attribute6 :=
439: ben_ecc_shd.g_old_rec.ecc_attribute6;
440: End If;
441: If (p_rec.ecc_attribute7 = hr_api.g_varchar2) then
442: p_rec.ecc_attribute7 :=
443: ben_ecc_shd.g_old_rec.ecc_attribute7;
444: End If;
445: If (p_rec.ecc_attribute8 = hr_api.g_varchar2) then

Line 445: If (p_rec.ecc_attribute8 = hr_api.g_varchar2) then

441: If (p_rec.ecc_attribute7 = hr_api.g_varchar2) then
442: p_rec.ecc_attribute7 :=
443: ben_ecc_shd.g_old_rec.ecc_attribute7;
444: End If;
445: If (p_rec.ecc_attribute8 = hr_api.g_varchar2) then
446: p_rec.ecc_attribute8 :=
447: ben_ecc_shd.g_old_rec.ecc_attribute8;
448: End If;
449: If (p_rec.ecc_attribute9 = hr_api.g_varchar2) then

Line 449: If (p_rec.ecc_attribute9 = hr_api.g_varchar2) then

445: If (p_rec.ecc_attribute8 = hr_api.g_varchar2) then
446: p_rec.ecc_attribute8 :=
447: ben_ecc_shd.g_old_rec.ecc_attribute8;
448: End If;
449: If (p_rec.ecc_attribute9 = hr_api.g_varchar2) then
450: p_rec.ecc_attribute9 :=
451: ben_ecc_shd.g_old_rec.ecc_attribute9;
452: End If;
453: If (p_rec.ecc_attribute10 = hr_api.g_varchar2) then

Line 453: If (p_rec.ecc_attribute10 = hr_api.g_varchar2) then

449: If (p_rec.ecc_attribute9 = hr_api.g_varchar2) then
450: p_rec.ecc_attribute9 :=
451: ben_ecc_shd.g_old_rec.ecc_attribute9;
452: End If;
453: If (p_rec.ecc_attribute10 = hr_api.g_varchar2) then
454: p_rec.ecc_attribute10 :=
455: ben_ecc_shd.g_old_rec.ecc_attribute10;
456: End If;
457: If (p_rec.ecc_attribute11 = hr_api.g_varchar2) then

Line 457: If (p_rec.ecc_attribute11 = hr_api.g_varchar2) then

453: If (p_rec.ecc_attribute10 = hr_api.g_varchar2) then
454: p_rec.ecc_attribute10 :=
455: ben_ecc_shd.g_old_rec.ecc_attribute10;
456: End If;
457: If (p_rec.ecc_attribute11 = hr_api.g_varchar2) then
458: p_rec.ecc_attribute11 :=
459: ben_ecc_shd.g_old_rec.ecc_attribute11;
460: End If;
461: If (p_rec.ecc_attribute12 = hr_api.g_varchar2) then

Line 461: If (p_rec.ecc_attribute12 = hr_api.g_varchar2) then

457: If (p_rec.ecc_attribute11 = hr_api.g_varchar2) then
458: p_rec.ecc_attribute11 :=
459: ben_ecc_shd.g_old_rec.ecc_attribute11;
460: End If;
461: If (p_rec.ecc_attribute12 = hr_api.g_varchar2) then
462: p_rec.ecc_attribute12 :=
463: ben_ecc_shd.g_old_rec.ecc_attribute12;
464: End If;
465: If (p_rec.ecc_attribute13 = hr_api.g_varchar2) then

Line 465: If (p_rec.ecc_attribute13 = hr_api.g_varchar2) then

461: If (p_rec.ecc_attribute12 = hr_api.g_varchar2) then
462: p_rec.ecc_attribute12 :=
463: ben_ecc_shd.g_old_rec.ecc_attribute12;
464: End If;
465: If (p_rec.ecc_attribute13 = hr_api.g_varchar2) then
466: p_rec.ecc_attribute13 :=
467: ben_ecc_shd.g_old_rec.ecc_attribute13;
468: End If;
469: If (p_rec.ecc_attribute14 = hr_api.g_varchar2) then

Line 469: If (p_rec.ecc_attribute14 = hr_api.g_varchar2) then

465: If (p_rec.ecc_attribute13 = hr_api.g_varchar2) then
466: p_rec.ecc_attribute13 :=
467: ben_ecc_shd.g_old_rec.ecc_attribute13;
468: End If;
469: If (p_rec.ecc_attribute14 = hr_api.g_varchar2) then
470: p_rec.ecc_attribute14 :=
471: ben_ecc_shd.g_old_rec.ecc_attribute14;
472: End If;
473: If (p_rec.ecc_attribute15 = hr_api.g_varchar2) then

Line 473: If (p_rec.ecc_attribute15 = hr_api.g_varchar2) then

469: If (p_rec.ecc_attribute14 = hr_api.g_varchar2) then
470: p_rec.ecc_attribute14 :=
471: ben_ecc_shd.g_old_rec.ecc_attribute14;
472: End If;
473: If (p_rec.ecc_attribute15 = hr_api.g_varchar2) then
474: p_rec.ecc_attribute15 :=
475: ben_ecc_shd.g_old_rec.ecc_attribute15;
476: End If;
477: If (p_rec.ecc_attribute16 = hr_api.g_varchar2) then

Line 477: If (p_rec.ecc_attribute16 = hr_api.g_varchar2) then

473: If (p_rec.ecc_attribute15 = hr_api.g_varchar2) then
474: p_rec.ecc_attribute15 :=
475: ben_ecc_shd.g_old_rec.ecc_attribute15;
476: End If;
477: If (p_rec.ecc_attribute16 = hr_api.g_varchar2) then
478: p_rec.ecc_attribute16 :=
479: ben_ecc_shd.g_old_rec.ecc_attribute16;
480: End If;
481: If (p_rec.ecc_attribute17 = hr_api.g_varchar2) then

Line 481: If (p_rec.ecc_attribute17 = hr_api.g_varchar2) then

477: If (p_rec.ecc_attribute16 = hr_api.g_varchar2) then
478: p_rec.ecc_attribute16 :=
479: ben_ecc_shd.g_old_rec.ecc_attribute16;
480: End If;
481: If (p_rec.ecc_attribute17 = hr_api.g_varchar2) then
482: p_rec.ecc_attribute17 :=
483: ben_ecc_shd.g_old_rec.ecc_attribute17;
484: End If;
485: If (p_rec.ecc_attribute18 = hr_api.g_varchar2) then

Line 485: If (p_rec.ecc_attribute18 = hr_api.g_varchar2) then

481: If (p_rec.ecc_attribute17 = hr_api.g_varchar2) then
482: p_rec.ecc_attribute17 :=
483: ben_ecc_shd.g_old_rec.ecc_attribute17;
484: End If;
485: If (p_rec.ecc_attribute18 = hr_api.g_varchar2) then
486: p_rec.ecc_attribute18 :=
487: ben_ecc_shd.g_old_rec.ecc_attribute18;
488: End If;
489: If (p_rec.ecc_attribute19 = hr_api.g_varchar2) then

Line 489: If (p_rec.ecc_attribute19 = hr_api.g_varchar2) then

485: If (p_rec.ecc_attribute18 = hr_api.g_varchar2) then
486: p_rec.ecc_attribute18 :=
487: ben_ecc_shd.g_old_rec.ecc_attribute18;
488: End If;
489: If (p_rec.ecc_attribute19 = hr_api.g_varchar2) then
490: p_rec.ecc_attribute19 :=
491: ben_ecc_shd.g_old_rec.ecc_attribute19;
492: End If;
493: If (p_rec.ecc_attribute20 = hr_api.g_varchar2) then

Line 493: If (p_rec.ecc_attribute20 = hr_api.g_varchar2) then

489: If (p_rec.ecc_attribute19 = hr_api.g_varchar2) then
490: p_rec.ecc_attribute19 :=
491: ben_ecc_shd.g_old_rec.ecc_attribute19;
492: End If;
493: If (p_rec.ecc_attribute20 = hr_api.g_varchar2) then
494: p_rec.ecc_attribute20 :=
495: ben_ecc_shd.g_old_rec.ecc_attribute20;
496: End If;
497: If (p_rec.ecc_attribute21 = hr_api.g_varchar2) then

Line 497: If (p_rec.ecc_attribute21 = hr_api.g_varchar2) then

493: If (p_rec.ecc_attribute20 = hr_api.g_varchar2) then
494: p_rec.ecc_attribute20 :=
495: ben_ecc_shd.g_old_rec.ecc_attribute20;
496: End If;
497: If (p_rec.ecc_attribute21 = hr_api.g_varchar2) then
498: p_rec.ecc_attribute21 :=
499: ben_ecc_shd.g_old_rec.ecc_attribute21;
500: End If;
501: If (p_rec.ecc_attribute22 = hr_api.g_varchar2) then

Line 501: If (p_rec.ecc_attribute22 = hr_api.g_varchar2) then

497: If (p_rec.ecc_attribute21 = hr_api.g_varchar2) then
498: p_rec.ecc_attribute21 :=
499: ben_ecc_shd.g_old_rec.ecc_attribute21;
500: End If;
501: If (p_rec.ecc_attribute22 = hr_api.g_varchar2) then
502: p_rec.ecc_attribute22 :=
503: ben_ecc_shd.g_old_rec.ecc_attribute22;
504: End If;
505: If (p_rec.ecc_attribute23 = hr_api.g_varchar2) then

Line 505: If (p_rec.ecc_attribute23 = hr_api.g_varchar2) then

501: If (p_rec.ecc_attribute22 = hr_api.g_varchar2) then
502: p_rec.ecc_attribute22 :=
503: ben_ecc_shd.g_old_rec.ecc_attribute22;
504: End If;
505: If (p_rec.ecc_attribute23 = hr_api.g_varchar2) then
506: p_rec.ecc_attribute23 :=
507: ben_ecc_shd.g_old_rec.ecc_attribute23;
508: End If;
509: If (p_rec.ecc_attribute24 = hr_api.g_varchar2) then

Line 509: If (p_rec.ecc_attribute24 = hr_api.g_varchar2) then

505: If (p_rec.ecc_attribute23 = hr_api.g_varchar2) then
506: p_rec.ecc_attribute23 :=
507: ben_ecc_shd.g_old_rec.ecc_attribute23;
508: End If;
509: If (p_rec.ecc_attribute24 = hr_api.g_varchar2) then
510: p_rec.ecc_attribute24 :=
511: ben_ecc_shd.g_old_rec.ecc_attribute24;
512: End If;
513: If (p_rec.ecc_attribute25 = hr_api.g_varchar2) then

Line 513: If (p_rec.ecc_attribute25 = hr_api.g_varchar2) then

509: If (p_rec.ecc_attribute24 = hr_api.g_varchar2) then
510: p_rec.ecc_attribute24 :=
511: ben_ecc_shd.g_old_rec.ecc_attribute24;
512: End If;
513: If (p_rec.ecc_attribute25 = hr_api.g_varchar2) then
514: p_rec.ecc_attribute25 :=
515: ben_ecc_shd.g_old_rec.ecc_attribute25;
516: End If;
517: If (p_rec.ecc_attribute26 = hr_api.g_varchar2) then

Line 517: If (p_rec.ecc_attribute26 = hr_api.g_varchar2) then

513: If (p_rec.ecc_attribute25 = hr_api.g_varchar2) then
514: p_rec.ecc_attribute25 :=
515: ben_ecc_shd.g_old_rec.ecc_attribute25;
516: End If;
517: If (p_rec.ecc_attribute26 = hr_api.g_varchar2) then
518: p_rec.ecc_attribute26 :=
519: ben_ecc_shd.g_old_rec.ecc_attribute26;
520: End If;
521: If (p_rec.ecc_attribute27 = hr_api.g_varchar2) then

Line 521: If (p_rec.ecc_attribute27 = hr_api.g_varchar2) then

517: If (p_rec.ecc_attribute26 = hr_api.g_varchar2) then
518: p_rec.ecc_attribute26 :=
519: ben_ecc_shd.g_old_rec.ecc_attribute26;
520: End If;
521: If (p_rec.ecc_attribute27 = hr_api.g_varchar2) then
522: p_rec.ecc_attribute27 :=
523: ben_ecc_shd.g_old_rec.ecc_attribute27;
524: End If;
525: If (p_rec.ecc_attribute28 = hr_api.g_varchar2) then

Line 525: If (p_rec.ecc_attribute28 = hr_api.g_varchar2) then

521: If (p_rec.ecc_attribute27 = hr_api.g_varchar2) then
522: p_rec.ecc_attribute27 :=
523: ben_ecc_shd.g_old_rec.ecc_attribute27;
524: End If;
525: If (p_rec.ecc_attribute28 = hr_api.g_varchar2) then
526: p_rec.ecc_attribute28 :=
527: ben_ecc_shd.g_old_rec.ecc_attribute28;
528: End If;
529: If (p_rec.ecc_attribute29 = hr_api.g_varchar2) then

Line 529: If (p_rec.ecc_attribute29 = hr_api.g_varchar2) then

525: If (p_rec.ecc_attribute28 = hr_api.g_varchar2) then
526: p_rec.ecc_attribute28 :=
527: ben_ecc_shd.g_old_rec.ecc_attribute28;
528: End If;
529: If (p_rec.ecc_attribute29 = hr_api.g_varchar2) then
530: p_rec.ecc_attribute29 :=
531: ben_ecc_shd.g_old_rec.ecc_attribute29;
532: End If;
533: If (p_rec.ecc_attribute30 = hr_api.g_varchar2) then

Line 533: If (p_rec.ecc_attribute30 = hr_api.g_varchar2) then

529: If (p_rec.ecc_attribute29 = hr_api.g_varchar2) then
530: p_rec.ecc_attribute29 :=
531: ben_ecc_shd.g_old_rec.ecc_attribute29;
532: End If;
533: If (p_rec.ecc_attribute30 = hr_api.g_varchar2) then
534: p_rec.ecc_attribute30 :=
535: ben_ecc_shd.g_old_rec.ecc_attribute30;
536: End If;
537: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then

Line 537: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then

533: If (p_rec.ecc_attribute30 = hr_api.g_varchar2) then
534: p_rec.ecc_attribute30 :=
535: ben_ecc_shd.g_old_rec.ecc_attribute30;
536: End If;
537: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then
538: p_rec.susp_if_ctfn_not_prvd_flag :=
539: ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
540: End If;
541: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then

Line 541: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then

537: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then
538: p_rec.susp_if_ctfn_not_prvd_flag :=
539: ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
540: End If;
541: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then
542: p_rec.ctfn_determine_cd :=
543: ben_ecc_shd.g_old_rec.ctfn_determine_cd;
544: End If;
545: If (p_rec.request_id = hr_api.g_number) then

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

541: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then
542: p_rec.ctfn_determine_cd :=
543: ben_ecc_shd.g_old_rec.ctfn_determine_cd;
544: End If;
545: If (p_rec.request_id = hr_api.g_number) then
546: p_rec.request_id :=
547: ben_ecc_shd.g_old_rec.request_id;
548: End If;
549: If (p_rec.program_application_id = hr_api.g_number) then

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

545: If (p_rec.request_id = hr_api.g_number) then
546: p_rec.request_id :=
547: ben_ecc_shd.g_old_rec.request_id;
548: End If;
549: If (p_rec.program_application_id = hr_api.g_number) then
550: p_rec.program_application_id :=
551: ben_ecc_shd.g_old_rec.program_application_id;
552: End If;
553: If (p_rec.program_id = hr_api.g_number) then

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

549: If (p_rec.program_application_id = hr_api.g_number) then
550: p_rec.program_application_id :=
551: ben_ecc_shd.g_old_rec.program_application_id;
552: End If;
553: If (p_rec.program_id = hr_api.g_number) then
554: p_rec.program_id :=
555: ben_ecc_shd.g_old_rec.program_id;
556: End If;
557: If (p_rec.program_update_date = hr_api.g_date) then

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

553: If (p_rec.program_id = hr_api.g_number) then
554: p_rec.program_id :=
555: ben_ecc_shd.g_old_rec.program_id;
556: End If;
557: If (p_rec.program_update_date = hr_api.g_date) then
558: p_rec.program_update_date :=
559: ben_ecc_shd.g_old_rec.program_update_date;
560: End If;
561:

Line 620: p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2,

616: Procedure upd
617: (
618: p_effective_date in date,
619: p_elctbl_chc_ctfn_id in number,
620: p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2,
621: p_rqd_flag in varchar2 default hr_api.g_varchar2,
622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,

Line 621: p_rqd_flag in varchar2 default hr_api.g_varchar2,

617: (
618: p_effective_date in date,
619: p_elctbl_chc_ctfn_id in number,
620: p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2,
621: p_rqd_flag in varchar2 default hr_api.g_varchar2,
622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,

Line 622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,

618: p_effective_date in date,
619: p_elctbl_chc_ctfn_id in number,
620: p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2,
621: p_rqd_flag in varchar2 default hr_api.g_varchar2,
622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,

Line 623: p_enrt_bnft_id in number default hr_api.g_number,

619: p_elctbl_chc_ctfn_id in number,
620: p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2,
621: p_rqd_flag in varchar2 default hr_api.g_varchar2,
622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,

Line 624: p_business_group_id in number default hr_api.g_number,

620: p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2,
621: p_rqd_flag in varchar2 default hr_api.g_varchar2,
622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,

Line 625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,

621: p_rqd_flag in varchar2 default hr_api.g_varchar2,
622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,

Line 626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,

622: p_elig_per_elctbl_chc_id in number default hr_api.g_number,
623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,

Line 627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,

623: p_enrt_bnft_id in number default hr_api.g_number,
624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,

Line 628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,

624: p_business_group_id in number default hr_api.g_number,
625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,

Line 629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,

625: p_ecc_attribute_category in varchar2 default hr_api.g_varchar2,
626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,

Line 630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,

626: p_ecc_attribute1 in varchar2 default hr_api.g_varchar2,
627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,

Line 631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,

627: p_ecc_attribute2 in varchar2 default hr_api.g_varchar2,
628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,

Line 632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,

628: p_ecc_attribute3 in varchar2 default hr_api.g_varchar2,
629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,

Line 633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,

629: p_ecc_attribute4 in varchar2 default hr_api.g_varchar2,
630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,

Line 634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,

630: p_ecc_attribute5 in varchar2 default hr_api.g_varchar2,
631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,

Line 635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,

631: p_ecc_attribute6 in varchar2 default hr_api.g_varchar2,
632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,

Line 636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,

632: p_ecc_attribute7 in varchar2 default hr_api.g_varchar2,
633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,

Line 637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,

633: p_ecc_attribute8 in varchar2 default hr_api.g_varchar2,
634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,

Line 638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,

634: p_ecc_attribute9 in varchar2 default hr_api.g_varchar2,
635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,

Line 639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,

635: p_ecc_attribute10 in varchar2 default hr_api.g_varchar2,
636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,

Line 640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,

636: p_ecc_attribute11 in varchar2 default hr_api.g_varchar2,
637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,

Line 641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,

637: p_ecc_attribute12 in varchar2 default hr_api.g_varchar2,
638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,

Line 642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,

638: p_ecc_attribute13 in varchar2 default hr_api.g_varchar2,
639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,

Line 643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,

639: p_ecc_attribute14 in varchar2 default hr_api.g_varchar2,
640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,

Line 644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,

640: p_ecc_attribute15 in varchar2 default hr_api.g_varchar2,
641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,

Line 645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,

641: p_ecc_attribute16 in varchar2 default hr_api.g_varchar2,
642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,

Line 646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,

642: p_ecc_attribute17 in varchar2 default hr_api.g_varchar2,
643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,

Line 647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,

643: p_ecc_attribute18 in varchar2 default hr_api.g_varchar2,
644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,

Line 648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,

644: p_ecc_attribute19 in varchar2 default hr_api.g_varchar2,
645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,

Line 649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,

645: p_ecc_attribute20 in varchar2 default hr_api.g_varchar2,
646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,

Line 650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,

646: p_ecc_attribute21 in varchar2 default hr_api.g_varchar2,
647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,

Line 651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,

647: p_ecc_attribute22 in varchar2 default hr_api.g_varchar2,
648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,

Line 652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,

648: p_ecc_attribute23 in varchar2 default hr_api.g_varchar2,
649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,

Line 653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,

649: p_ecc_attribute24 in varchar2 default hr_api.g_varchar2,
650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,

Line 654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,

650: p_ecc_attribute25 in varchar2 default hr_api.g_varchar2,
651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,

Line 655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,

651: p_ecc_attribute26 in varchar2 default hr_api.g_varchar2,
652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,
659: p_program_application_id in number default hr_api.g_number,

Line 656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,

652: p_ecc_attribute27 in varchar2 default hr_api.g_varchar2,
653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,
659: p_program_application_id in number default hr_api.g_number,
660: p_program_id in number default hr_api.g_number,

Line 657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,

653: p_ecc_attribute28 in varchar2 default hr_api.g_varchar2,
654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,
659: p_program_application_id in number default hr_api.g_number,
660: p_program_id in number default hr_api.g_number,
661: p_program_update_date in date default hr_api.g_date,

Line 658: p_request_id in number default hr_api.g_number,

654: p_ecc_attribute29 in varchar2 default hr_api.g_varchar2,
655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,
659: p_program_application_id in number default hr_api.g_number,
660: p_program_id in number default hr_api.g_number,
661: p_program_update_date in date default hr_api.g_date,
662: p_object_version_number in out nocopy number

Line 659: p_program_application_id in number default hr_api.g_number,

655: p_ecc_attribute30 in varchar2 default hr_api.g_varchar2,
656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,
659: p_program_application_id in number default hr_api.g_number,
660: p_program_id in number default hr_api.g_number,
661: p_program_update_date in date default hr_api.g_date,
662: p_object_version_number in out nocopy number
663: ) is

Line 660: p_program_id in number default hr_api.g_number,

656: p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2,
657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,
659: p_program_application_id in number default hr_api.g_number,
660: p_program_id in number default hr_api.g_number,
661: p_program_update_date in date default hr_api.g_date,
662: p_object_version_number in out nocopy number
663: ) is
664: --

Line 661: p_program_update_date in date default hr_api.g_date,

657: p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
658: p_request_id in number default hr_api.g_number,
659: p_program_application_id in number default hr_api.g_number,
660: p_program_id in number default hr_api.g_number,
661: p_program_update_date in date default hr_api.g_date,
662: p_object_version_number in out nocopy number
663: ) is
664: --
665: l_rec ben_ecc_shd.g_rec_type;