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

APPS.BEN_CAGR_CHECK_ELIGIBILITY dependencies on BEN_EVALUATE_ELIG_PROFILES

Line 10: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

6: --
7: procedure check_gndr_elig
8: (p_eligy_prfl_id in number
9: ,p_score_compute_mode in boolean default false
10: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
11: ,p_effective_date in date
12: ,p_per_sex in varchar2
13: )
14: is

Line 25: l_score_tab ben_evaluate_elig_profiles.scoreTab;

21: l_rows_found boolean := false;
22: --
23: l_ele_num pls_integer;
24: l_crit_passed boolean;
25: l_score_tab ben_evaluate_elig_profiles.scoreTab;
26: --
27: begin
28: --
29: hr_utility.set_location('Entering : '||l_proc,10);

Line 52: ben_evaluate_elig_profiles.write(l_score_tab,

48: if p_score_compute_mode then
49: if l_crit_passed is null then
50: l_crit_passed := true;
51: end if;
52: ben_evaluate_elig_profiles.write(l_score_tab,
53: l_inst_set(l_ele_num).eligy_prfl_id,
54: l_inst_set(l_ele_num).short_code,
55: l_inst_set(l_ele_num).pk_id,
56: nvl(l_inst_set(l_ele_num).criteria_score,

Line 73: ben_evaluate_elig_profiles.write(l_score_tab,

69: --
70: l_rows_found := true;
71: l_ok := true;
72: if p_score_compute_mode then
73: ben_evaluate_elig_profiles.write(l_score_tab,
74: l_inst_set(l_ele_num).eligy_prfl_id,
75: l_inst_set(l_ele_num).short_code,
76: l_inst_set(l_ele_num).pk_id,
77: nvl(l_inst_set(l_ele_num).criteria_score,

Line 99: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EGN';

95: if l_rows_found
96: and not l_ok
97: then
98: --
99: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EGN';
100: fnd_message.set_name('BEN','BEN_92814_GNDR_PRFL_FAIL');
101: hr_utility.set_location('Criteria Failed: '||l_proc,20);
102: raise ben_evaluate_elig_profiles.g_criteria_failed;
103: --

Line 102: raise ben_evaluate_elig_profiles.g_criteria_failed;

98: --
99: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EGN';
100: fnd_message.set_name('BEN','BEN_92814_GNDR_PRFL_FAIL');
101: hr_utility.set_location('Criteria Failed: '||l_proc,20);
102: raise ben_evaluate_elig_profiles.g_criteria_failed;
103: --
104: end if;
105: end if;
106: --

Line 110: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

106: --
107: if p_score_compute_mode
108: then
109: hr_utility.set_location('count '||l_score_tab.count,20);
110: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
111: end if;
112: hr_utility.set_location('Leaving: '||l_proc,20);
113: --
114: end check_gndr_elig;

Line 119: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

115: --
116: procedure check_mrtl_sts_elig
117: (p_eligy_prfl_id in number
118: ,p_score_compute_mode in boolean default false
119: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
120: ,p_effective_date in date
121: ,p_per_mar_status in varchar2
122: )
123: is

Line 135: l_score_tab ben_evaluate_elig_profiles.scoreTab;

131: --
132: l_ele_num pls_integer;
133: --
134: l_crit_passed boolean;
135: l_score_tab ben_evaluate_elig_profiles.scoreTab;
136: begin
137: --
138: hr_utility.set_location('Entering : '||l_proc,10);
139: --

Line 161: ben_evaluate_elig_profiles.write(l_score_tab,

157: if p_score_compute_mode then
158: if l_crit_passed is null then
159: l_crit_passed := true;
160: end if;
161: ben_evaluate_elig_profiles.write(l_score_tab,
162: l_inst_set(l_ele_num).eligy_prfl_id,
163: l_inst_set(l_ele_num).short_code,
164: l_inst_set(l_ele_num).pk_id,
165: nvl(l_inst_set(l_ele_num).criteria_score,

Line 183: ben_evaluate_elig_profiles.write(l_score_tab,

179: l_rows_found := true;
180: l_ok := true;
181: --
182: if p_score_compute_mode then
183: ben_evaluate_elig_profiles.write(l_score_tab,
184: l_inst_set(l_ele_num).eligy_prfl_id,
185: l_inst_set(l_ele_num).short_code,
186: l_inst_set(l_ele_num).pk_id,
187: nvl(l_inst_set(l_ele_num).criteria_score,

Line 208: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EMP';

204: if l_rows_found
205: and not l_ok
206: then
207: --
208: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EMP';
209: fnd_message.set_name('BEN','BEN_92815_MARSTAT_PRFL_FAIL');
210: hr_utility.set_location('Criteria Failed: '||l_proc,20);
211: raise ben_evaluate_elig_profiles.g_criteria_failed;
212: --

Line 211: raise ben_evaluate_elig_profiles.g_criteria_failed;

207: --
208: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EMP';
209: fnd_message.set_name('BEN','BEN_92815_MARSTAT_PRFL_FAIL');
210: hr_utility.set_location('Criteria Failed: '||l_proc,20);
211: raise ben_evaluate_elig_profiles.g_criteria_failed;
212: --
213: end if;
214: end if;
215: --

Line 219: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

215: --
216: if p_score_compute_mode
217: then
218: hr_utility.set_location('count '||l_score_tab.count,20);
219: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
220: end if;
221: hr_utility.set_location('Leaving: '||l_proc,20);
222: --
223: end check_mrtl_sts_elig;

Line 228: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

224: --
225: procedure check_dsblty_ctg_elig
226: (p_eligy_prfl_id in number
227: ,p_score_compute_mode in boolean default false
228: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
229: ,p_effective_date in date
230: ,p_per_dsblty_ctg in varchar2
231: )
232: is

Line 244: l_score_tab ben_evaluate_elig_profiles.scoreTab;

240: --
241: l_ele_num pls_integer;
242: --
243: l_crit_passed boolean;
244: l_score_tab ben_evaluate_elig_profiles.scoreTab;
245: begin
246: --
247: hr_utility.set_location('Entering : '||l_proc,10);
248: --

Line 270: ben_evaluate_elig_profiles.write(l_score_tab,

266: if p_score_compute_mode then
267: if l_crit_passed is null then
268: l_crit_passed := true;
269: end if;
270: ben_evaluate_elig_profiles.write(l_score_tab,
271: l_inst_set(l_ele_num).eligy_prfl_id,
272: l_inst_set(l_ele_num).short_code,
273: l_inst_set(l_ele_num).pk_id,
274: nvl(l_inst_set(l_ele_num).criteria_score,

Line 292: ben_evaluate_elig_profiles.write(l_score_tab,

288: l_rows_found := true;
289: l_ok := true;
290: --
291: if p_score_compute_mode then
292: ben_evaluate_elig_profiles.write(l_score_tab,
293: l_inst_set(l_ele_num).eligy_prfl_id,
294: l_inst_set(l_ele_num).short_code,
295: l_inst_set(l_ele_num).pk_id,
296: nvl(l_inst_set(l_ele_num).criteria_score,

Line 317: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ECT';

313: if l_rows_found
314: and not l_ok
315: then
316: --
317: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ECT';
318: fnd_message.set_name('BEN','BEN_92816_DSBLCAT_PRFL_FAIL');
319: hr_utility.set_location('Criteria Failed: '||l_proc,20);
320: raise ben_evaluate_elig_profiles.g_criteria_failed;
321: --

Line 320: raise ben_evaluate_elig_profiles.g_criteria_failed;

316: --
317: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ECT';
318: fnd_message.set_name('BEN','BEN_92816_DSBLCAT_PRFL_FAIL');
319: hr_utility.set_location('Criteria Failed: '||l_proc,20);
320: raise ben_evaluate_elig_profiles.g_criteria_failed;
321: --
322: end if;
323: end if;
324: --

Line 328: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

324: --
325: if p_score_compute_mode
326: then
327: hr_utility.set_location('count '||l_score_tab.count,20);
328: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
329: end if;
330: hr_utility.set_location('Leaving: '||l_proc,20);
331: --
332: end check_dsblty_ctg_elig;

Line 337: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

333: --
334: procedure check_dsblty_rsn_elig
335: (p_eligy_prfl_id in number
336: ,p_score_compute_mode in boolean default false
337: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
338: ,p_effective_date in date
339: ,p_per_dsblty_rsn in varchar2
340: )
341: is

Line 353: l_score_tab ben_evaluate_elig_profiles.scoreTab;

349: --
350: l_ele_num pls_integer;
351: --
352: l_crit_passed boolean;
353: l_score_tab ben_evaluate_elig_profiles.scoreTab;
354: begin
355: --
356: hr_utility.set_location('Entering : '||l_proc,10);
357: --

Line 379: ben_evaluate_elig_profiles.write(l_score_tab,

375: if p_score_compute_mode then
376: if l_crit_passed is null then
377: l_crit_passed := true;
378: end if;
379: ben_evaluate_elig_profiles.write(l_score_tab,
380: l_inst_set(l_ele_num).eligy_prfl_id,
381: l_inst_set(l_ele_num).short_code,
382: l_inst_set(l_ele_num).pk_id,
383: nvl(l_inst_set(l_ele_num).criteria_score,

Line 401: ben_evaluate_elig_profiles.write(l_score_tab,

397: l_rows_found := true;
398: l_ok := true;
399: --
400: if p_score_compute_mode then
401: ben_evaluate_elig_profiles.write(l_score_tab,
402: l_inst_set(l_ele_num).eligy_prfl_id,
403: l_inst_set(l_ele_num).short_code,
404: l_inst_set(l_ele_num).pk_id,
405: nvl(l_inst_set(l_ele_num).criteria_score,

Line 426: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDR';

422: if l_rows_found
423: and not l_ok
424: then
425: --
426: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDR';
427: fnd_message.set_name('BEN','BEN_92817_DSBLRSN_PRFL_FAIL');
428: hr_utility.set_location('Criteria Failed: '||l_proc,20);
429: raise ben_evaluate_elig_profiles.g_criteria_failed;
430: --

Line 429: raise ben_evaluate_elig_profiles.g_criteria_failed;

425: --
426: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDR';
427: fnd_message.set_name('BEN','BEN_92817_DSBLRSN_PRFL_FAIL');
428: hr_utility.set_location('Criteria Failed: '||l_proc,20);
429: raise ben_evaluate_elig_profiles.g_criteria_failed;
430: --
431: end if;
432: end if;
433: --

Line 437: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

433: --
434: if p_score_compute_mode
435: then
436: hr_utility.set_location('count '||l_score_tab.count,20);
437: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
438: end if;
439: hr_utility.set_location('Leaving: '||l_proc,20);
440: --
441: end check_dsblty_rsn_elig;

Line 446: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

442: --
443: procedure check_dsblty_dgr_elig
444: (p_eligy_prfl_id in number
445: ,p_score_compute_mode in boolean default false
446: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
447: ,p_effective_date in date
448: ,p_per_degree in number
449: )
450: is

Line 462: l_score_tab ben_evaluate_elig_profiles.scoreTab;

458: --
459: l_ele_num pls_integer;
460: --
461: l_crit_passed boolean;
462: l_score_tab ben_evaluate_elig_profiles.scoreTab;
463: begin
464: --
465: hr_utility.set_location('Entering : '||l_proc,10);
466: --

Line 488: ben_evaluate_elig_profiles.write(l_score_tab,

484: if p_score_compute_mode then
485: if l_crit_passed is null then
486: l_crit_passed := true;
487: end if;
488: ben_evaluate_elig_profiles.write(l_score_tab,
489: l_inst_set(l_ele_num).eligy_prfl_id,
490: l_inst_set(l_ele_num).short_code,
491: l_inst_set(l_ele_num).pk_id,
492: nvl(l_inst_set(l_ele_num).criteria_score,

Line 510: ben_evaluate_elig_profiles.write(l_score_tab,

506: l_rows_found := true;
507: l_ok := true;
508: --
509: if p_score_compute_mode then
510: ben_evaluate_elig_profiles.write(l_score_tab,
511: l_inst_set(l_ele_num).eligy_prfl_id,
512: l_inst_set(l_ele_num).short_code,
513: l_inst_set(l_ele_num).pk_id,
514: nvl(l_inst_set(l_ele_num).criteria_score,

Line 535: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';

531: if l_rows_found
532: and not l_ok
533: then
534: --
535: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';
536: fnd_message.set_name('BEN','BEN_92818_DSBDGR_PRFL_FAIL');
537: hr_utility.set_location('Criteria Failed: '||l_proc,20);
538: raise ben_evaluate_elig_profiles.g_criteria_failed;
539: --

Line 538: raise ben_evaluate_elig_profiles.g_criteria_failed;

534: --
535: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';
536: fnd_message.set_name('BEN','BEN_92818_DSBDGR_PRFL_FAIL');
537: hr_utility.set_location('Criteria Failed: '||l_proc,20);
538: raise ben_evaluate_elig_profiles.g_criteria_failed;
539: --
540: end if;
541: end if;
542: --

Line 546: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

542: --
543: if p_score_compute_mode
544: then
545: hr_utility.set_location('count '||l_score_tab.count,20);
546: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
547: end if;
548: hr_utility.set_location('Leaving: '||l_proc,20);
549: --
550: end check_dsblty_dgr_elig;

Line 555: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

551: --
552: procedure check_suppl_role_elig
553: (p_eligy_prfl_id in number
554: ,p_score_compute_mode in boolean default false
555: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
556: ,p_effective_date in date
557: ,p_asg_job_id in number
558: ,p_asg_job_group_id in number
559: )

Line 572: l_score_tab ben_evaluate_elig_profiles.scoreTab;

568: --
569: l_ele_num pls_integer;
570: --
571: l_crit_passed boolean;
572: l_score_tab ben_evaluate_elig_profiles.scoreTab;
573: begin
574: --
575: hr_utility.set_location('Entering : '||l_proc,10);
576: --

Line 599: ben_evaluate_elig_profiles.write(l_score_tab,

595: if p_score_compute_mode then
596: if l_crit_passed is null then
597: l_crit_passed := true;
598: end if;
599: ben_evaluate_elig_profiles.write(l_score_tab,
600: l_inst_set(l_ele_num).eligy_prfl_id,
601: l_inst_set(l_ele_num).short_code,
602: l_inst_set(l_ele_num).pk_id,
603: nvl(l_inst_set(l_ele_num).criteria_score,

Line 621: ben_evaluate_elig_profiles.write(l_score_tab,

617: l_rows_found := true;
618: l_ok := true;
619: --
620: if p_score_compute_mode then
621: ben_evaluate_elig_profiles.write(l_score_tab,
622: l_inst_set(l_ele_num).eligy_prfl_id,
623: l_inst_set(l_ele_num).short_code,
624: l_inst_set(l_ele_num).pk_id,
625: nvl(l_inst_set(l_ele_num).criteria_score,

Line 646: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EST';

642: if l_rows_found
643: and not l_ok
644: then
645: --
646: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EST';
647: fnd_message.set_name('BEN','BEN_92819_SUPPLROLE_PRFL_FAIL');
648: hr_utility.set_location('Criteria Failed: '||l_proc,20);
649: raise ben_evaluate_elig_profiles.g_criteria_failed;
650: --

Line 649: raise ben_evaluate_elig_profiles.g_criteria_failed;

645: --
646: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EST';
647: fnd_message.set_name('BEN','BEN_92819_SUPPLROLE_PRFL_FAIL');
648: hr_utility.set_location('Criteria Failed: '||l_proc,20);
649: raise ben_evaluate_elig_profiles.g_criteria_failed;
650: --
651: end if;
652: end if;
653: --

Line 657: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

653: --
654: if p_score_compute_mode
655: then
656: hr_utility.set_location('count '||l_score_tab.count,20);
657: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
658: end if;
659: hr_utility.set_location('Leaving: '||l_proc,20);
660: --
661: end check_suppl_role_elig;

Line 666: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

662: --
663: procedure check_qual_titl_elig
664: (p_eligy_prfl_id in number
665: ,p_score_compute_mode in boolean default false
666: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
667: ,p_effective_date in date
668: ,p_per_qual_title in varchar2
669: ,p_per_qual_typ_id in number
670: )

Line 683: l_score_tab ben_evaluate_elig_profiles.scoreTab;

679: --
680: l_ele_num pls_integer;
681: --
682: l_crit_passed boolean;
683: l_score_tab ben_evaluate_elig_profiles.scoreTab;
684: begin
685: --
686: hr_utility.set_location('Entering : '||l_proc,10);
687: --

Line 715: ben_evaluate_elig_profiles.write(l_score_tab,

711: if p_score_compute_mode then
712: if l_crit_passed is null then
713: l_crit_passed := true;
714: end if;
715: ben_evaluate_elig_profiles.write(l_score_tab,
716: l_inst_set(l_ele_num).eligy_prfl_id,
717: l_inst_set(l_ele_num).short_code,
718: l_inst_set(l_ele_num).pk_id,
719: nvl(l_inst_set(l_ele_num).criteria_score,

Line 737: ben_evaluate_elig_profiles.write(l_score_tab,

733: l_rows_found := true;
734: l_ok := true;
735: --
736: if p_score_compute_mode then
737: ben_evaluate_elig_profiles.write(l_score_tab,
738: l_inst_set(l_ele_num).eligy_prfl_id,
739: l_inst_set(l_ele_num).short_code,
740: l_inst_set(l_ele_num).pk_id,
741: nvl(l_inst_set(l_ele_num).criteria_score,

Line 762: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EQT';

758: if l_rows_found
759: and not l_ok
760: then
761: --
762: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EQT';
763: fnd_message.set_name('BEN','BEN_92820_QUALTITL_PRFL_FAIL');
764: hr_utility.set_location('Criteria Failed: '||l_proc,20);
765: raise ben_evaluate_elig_profiles.g_criteria_failed;
766: --

Line 765: raise ben_evaluate_elig_profiles.g_criteria_failed;

761: --
762: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EQT';
763: fnd_message.set_name('BEN','BEN_92820_QUALTITL_PRFL_FAIL');
764: hr_utility.set_location('Criteria Failed: '||l_proc,20);
765: raise ben_evaluate_elig_profiles.g_criteria_failed;
766: --
767: end if;
768: end if;
769: --

Line 773: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

769: --
770: if p_score_compute_mode
771: then
772: hr_utility.set_location('count '||l_score_tab.count,20);
773: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
774: end if;
775: hr_utility.set_location('Leaving: '||l_proc,20);
776: --
777: end check_qual_titl_elig;

Line 782: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

778: --
779: procedure check_pstn_elig
780: (p_eligy_prfl_id in number
781: ,p_score_compute_mode in boolean default false
782: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
783: ,p_effective_date in date
784: ,p_asg_position_id in varchar2
785: )
786: is

Line 798: l_score_tab ben_evaluate_elig_profiles.scoreTab;

794: --
795: l_ele_num pls_integer;
796: --
797: l_crit_passed boolean;
798: l_score_tab ben_evaluate_elig_profiles.scoreTab;
799: begin
800: --
801: hr_utility.set_location('Entering : '||l_proc,10);
802: --

Line 824: ben_evaluate_elig_profiles.write(l_score_tab,

820: if p_score_compute_mode then
821: if l_crit_passed is null then
822: l_crit_passed := true;
823: end if;
824: ben_evaluate_elig_profiles.write(l_score_tab,
825: l_inst_set(l_ele_num).eligy_prfl_id,
826: l_inst_set(l_ele_num).short_code,
827: l_inst_set(l_ele_num).pk_id,
828: nvl(l_inst_set(l_ele_num).criteria_score,

Line 846: ben_evaluate_elig_profiles.write(l_score_tab,

842: l_rows_found := true;
843: l_ok := true;
844: --
845: if p_score_compute_mode then
846: ben_evaluate_elig_profiles.write(l_score_tab,
847: l_inst_set(l_ele_num).eligy_prfl_id,
848: l_inst_set(l_ele_num).short_code,
849: l_inst_set(l_ele_num).pk_id,
850: nvl(l_inst_set(l_ele_num).criteria_score,

Line 871: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EPS';

867: if l_rows_found
868: and not l_ok
869: then
870: --
871: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EPS';
872: fnd_message.set_name('BEN','BEN_92821_PSTN_PRFL_FAIL');
873: hr_utility.set_location('Criteria Failed: '||l_proc,20);
874: raise ben_evaluate_elig_profiles.g_criteria_failed;
875: --

Line 874: raise ben_evaluate_elig_profiles.g_criteria_failed;

870: --
871: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EPS';
872: fnd_message.set_name('BEN','BEN_92821_PSTN_PRFL_FAIL');
873: hr_utility.set_location('Criteria Failed: '||l_proc,20);
874: raise ben_evaluate_elig_profiles.g_criteria_failed;
875: --
876: end if;
877: end if;
878: --

Line 882: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

878: --
879: if p_score_compute_mode
880: then
881: hr_utility.set_location('count '||l_score_tab.count,20);
882: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
883: end if;
884: hr_utility.set_location('Leaving: '||l_proc,20);
885: --
886: end check_pstn_elig;

Line 891: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

887: --
888: procedure check_prbtn_perd_elig
889: (p_eligy_prfl_id in number
890: ,p_score_compute_mode in boolean default false
891: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
892: ,p_effective_date in date
893: ,p_asg_prob_perd in number
894: ,p_asg_prob_unit in varchar2
895: )

Line 908: l_score_tab ben_evaluate_elig_profiles.scoreTab;

904: --
905: l_ele_num pls_integer;
906: --
907: l_crit_passed boolean;
908: l_score_tab ben_evaluate_elig_profiles.scoreTab;
909: begin
910: --
911: ben_cagrelp_cache.elpepn_getdets
912: (p_effective_date => p_effective_date

Line 933: ben_evaluate_elig_profiles.write(l_score_tab,

929: if p_score_compute_mode then
930: if l_crit_passed is null then
931: l_crit_passed := true;
932: end if;
933: ben_evaluate_elig_profiles.write(l_score_tab,
934: l_inst_set(l_ele_num).eligy_prfl_id,
935: l_inst_set(l_ele_num).short_code,
936: l_inst_set(l_ele_num).pk_id,
937: nvl(l_inst_set(l_ele_num).criteria_score,

Line 955: ben_evaluate_elig_profiles.write(l_score_tab,

951: l_rows_found := true;
952: l_ok := true;
953: --
954: if p_score_compute_mode then
955: ben_evaluate_elig_profiles.write(l_score_tab,
956: l_inst_set(l_ele_num).eligy_prfl_id,
957: l_inst_set(l_ele_num).short_code,
958: l_inst_set(l_ele_num).pk_id,
959: nvl(l_inst_set(l_ele_num).criteria_score,

Line 980: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';

976: if l_rows_found
977: and not l_ok
978: then
979: --
980: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';
981: fnd_message.set_name('BEN','BEN_92822_PRBNPERD_PRFL_FAIL');
982: hr_utility.set_location('Criteria Failed: '||l_proc,20);
983: raise ben_evaluate_elig_profiles.g_criteria_failed;
984: --

Line 983: raise ben_evaluate_elig_profiles.g_criteria_failed;

979: --
980: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';
981: fnd_message.set_name('BEN','BEN_92822_PRBNPERD_PRFL_FAIL');
982: hr_utility.set_location('Criteria Failed: '||l_proc,20);
983: raise ben_evaluate_elig_profiles.g_criteria_failed;
984: --
985: end if;
986: end if;
987: --

Line 991: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

987: --
988: if p_score_compute_mode
989: then
990: hr_utility.set_location('count '||l_score_tab.count,20);
991: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
992: end if;
993: hr_utility.set_location('Leaving: '||l_proc,20);
994: --
995: end check_prbtn_perd_elig;

Line 1000: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

996: --
997: procedure check_sp_clng_prg_elig
998: (p_eligy_prfl_id in number
999: ,p_score_compute_mode in boolean default false
1000: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
1001: ,p_effective_date in date
1002: ,p_asg_sps_id in varchar2
1003: )
1004: is

Line 1016: l_score_tab ben_evaluate_elig_profiles.scoreTab;

1012: --
1013: l_ele_num pls_integer;
1014: --
1015: l_crit_passed boolean;
1016: l_score_tab ben_evaluate_elig_profiles.scoreTab;
1017: begin
1018: --
1019: hr_utility.set_location('Entering : '||l_proc,10);
1020: --

Line 1042: ben_evaluate_elig_profiles.write(l_score_tab,

1038: if p_score_compute_mode then
1039: if l_crit_passed is null then
1040: l_crit_passed := true;
1041: end if;
1042: ben_evaluate_elig_profiles.write(l_score_tab,
1043: l_inst_set(l_ele_num).eligy_prfl_id,
1044: l_inst_set(l_ele_num).short_code,
1045: l_inst_set(l_ele_num).pk_id,
1046: nvl(l_inst_set(l_ele_num).criteria_score,

Line 1064: ben_evaluate_elig_profiles.write(l_score_tab,

1060: l_rows_found := true;
1061: l_ok := true;
1062: --
1063: if p_score_compute_mode then
1064: ben_evaluate_elig_profiles.write(l_score_tab,
1065: l_inst_set(l_ele_num).eligy_prfl_id,
1066: l_inst_set(l_ele_num).short_code,
1067: l_inst_set(l_ele_num).pk_id,
1068: nvl(l_inst_set(l_ele_num).criteria_score,

Line 1089: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ESP';

1085: if l_rows_found
1086: and not l_ok
1087: then
1088: --
1089: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ESP';
1090: fnd_message.set_name('BEN','BEN_92823_SPCLNGPRG_PRFL_FAIL');
1091: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1092: raise ben_evaluate_elig_profiles.g_criteria_failed;
1093: --

Line 1092: raise ben_evaluate_elig_profiles.g_criteria_failed;

1088: --
1089: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ESP';
1090: fnd_message.set_name('BEN','BEN_92823_SPCLNGPRG_PRFL_FAIL');
1091: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1092: raise ben_evaluate_elig_profiles.g_criteria_failed;
1093: --
1094: end if;
1095: end if;
1096: --

Line 1100: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);

1096: --
1097: if p_score_compute_mode
1098: then
1099: hr_utility.set_location('count '||l_score_tab.count,20);
1100: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
1101: end if;
1102: hr_utility.set_location('Leaving: '||l_proc,20);
1103: --
1104: end check_sp_clng_prg_elig;

Line 1112: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab

1108: ,p_effective_date in date
1109: --
1110: ,p_person_id in number
1111: ,p_score_compute_mode in boolean
1112: ,p_profile_score_tab in out nocopy ben_evaluate_elig_profiles.scoreTab
1113: ,p_per_sex in varchar2
1114: ,p_per_mar_status in varchar2
1115: ,p_per_qualification_type_id in varchar2 default null
1116: ,p_per_title in varchar2 default null