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.BENUTILS dependencies on BENUTILS

Line 1: package body benutils as

1: package body benutils as
2: /* $Header: benutils.pkb 120.20 2008/01/24 07:00:12 sallumwa ship $ */
3: --
4: g_package varchar2(80) := 'benutils';
5:

Line 2: /* $Header: benutils.pkb 120.20 2008/01/24 07:00:12 sallumwa ship $ */

1: package body benutils as
2: /* $Header: benutils.pkb 120.20 2008/01/24 07:00:12 sallumwa ship $ */
3: --
4: g_package varchar2(80) := 'benutils';
5:
6: type t_pkey_table is table of varchar2(30) index by binary_integer;

Line 4: g_package varchar2(80) := 'benutils';

1: package body benutils as
2: /* $Header: benutils.pkb 120.20 2008/01/24 07:00:12 sallumwa ship $ */
3: --
4: g_package varchar2(80) := 'benutils';
5:
6: type t_pkey_table is table of varchar2(30) index by binary_integer;
7: --
8: g_part_of_pkey t_pkey_table;

Line 129: l_lwr_outputs := benutils.formula

125: */
126: --
127: if p_lwr_lmt_calc_rl is not NULL then
128: --
129: l_lwr_outputs := benutils.formula
130: (p_formula_id => p_lwr_lmt_calc_rl,
131: p_effective_date => p_effective_date,
132: p_assignment_id => p_assignment_id,
133: p_organization_id => p_organization_id,

Line 153: l_upr_outputs := benutils.formula

149: end if;
150: --
151: if p_upr_lmt_calc_rl is not NULL then
152: --
153: l_upr_outputs := benutils.formula
154: (p_formula_id => p_upr_lmt_calc_rl,
155: p_effective_date => p_effective_date,
156: p_assignment_id => p_assignment_id,
157: p_organization_id => p_organization_id,

Line 216: l_proc varchar2(80) := 'benutils.init_lookups';

212: p_lookup_type_9 in varchar2 ,
213: p_lookup_type_10 in varchar2 ,
214: p_effective_date in date) is
215: --
216: l_proc varchar2(80) := 'benutils.init_lookups';
217: l_count number := 0;
218: --
219: cursor c_lookups is
220: select lookup_type,

Line 281: l_proc varchar2(80) := 'benutils.get_lf_evt_ocrd_dt';

277: p_business_group_id in number,
278: p_ler_id in number ,
279: p_effective_date in date) return date is
280: --
281: l_proc varchar2(80) := 'benutils.get_lf_evt_ocrd_dt';
282: l_lf_evt_ocrd_dt date;
283: --
284: cursor c_lf_evt_ocrd_dt is
285: select pil.lf_evt_ocrd_dt

Line 319: l_proc varchar2(80) := 'benutils.get_per_in_ler_id';

315: p_business_group_id in number,
316: p_ler_id in number ,
317: p_effective_date in date) return number is
318: --
319: l_proc varchar2(80) := 'benutils.get_per_in_ler_id';
320: l_per_in_ler_id number;
321: --
322: cursor c_per_in_ler_id is
323: select pil.per_in_ler_id

Line 362: l_proc varchar2(80) := 'benutils.get_active_life_event';

358: p_lf_evt_ocrd_dt in date,
359: p_ler_id in number,
360: p_rec out nocopy g_active_life_event) is
361: --
362: l_proc varchar2(80) := 'benutils.get_active_life_event';
363: --
364: cursor c_active_life_event is
365: select pil.per_in_ler_id,
366: pil.lf_evt_ocrd_dt,

Line 411: l_proc varchar2(80) := 'benutils.get_per_in_ler_id_u';

407: p_ler_id in number ,
408: p_lf_event_mode in varchar2 ,
409: p_effective_date in date) return number is
410: --
411: l_proc varchar2(80) := 'benutils.get_per_in_ler_id_u';
412: l_per_in_ler_id number;
413: --
414: cursor c_per_in_ler_id is
415: select pil.per_in_ler_id

Line 450: l_proc varchar2(80) := 'benutils.get_active_life_event';

446: p_business_group_id in number,
447: p_effective_date in date,
448: p_rec out nocopy g_active_life_event) is
449: --
450: l_proc varchar2(80) := 'benutils.get_active_life_event';
451: --
452: cursor c_active_life_event is
453: select pil.per_in_ler_id,
454: pil.lf_evt_ocrd_dt,

Line 501: l_proc varchar2(80) := 'benutils.get_active_life_event';

497: p_effective_date in date,
498: p_lf_event_mode in varchar2 ,
499: p_rec out nocopy g_active_life_event) is
500: --
501: l_proc varchar2(80) := 'benutils.get_active_life_event';
502: --
503: cursor c_active_life_event is
504: select pil.per_in_ler_id,
505: pil.lf_evt_ocrd_dt,

Line 555: l_proc varchar2(80) := 'benutils.get_ler';

551: p_ler_id in number,
552: p_effective_date in date,
553: p_rec out nocopy g_ler) is
554: --
555: l_proc varchar2(80) := 'benutils.get_ler';
556: --
557: cursor c_ler is
558: select ler.ler_id,
559: ler.ler_eval_rl,

Line 588: l_proc varchar2(80) := 'benutils.get_ler';

584: p_effective_date in date,
585: p_lf_evt_oper_cd in varchar2 default null, /* GSP Rate Sync */
586: p_rec out nocopy g_ler) is
587: --
588: l_proc varchar2(80) := 'benutils.get_ler';
589: --
590: cursor c_ler is
591: select ler.ler_id,
592: ler.ler_eval_rl,

Line 631: l_proc varchar2(80) := 'benutils.get_ptnl_ler';

627: p_ler_id in number,
628: p_effective_date in date,
629: p_rec out nocopy g_ptnl_ler) is
630: --
631: l_proc varchar2(80) := 'benutils.get_ptnl_ler';
632: --
633: cursor c_ptnl is
634: select ptnl_ler_for_per_id,
635: object_version_number

Line 663: l_proc varchar2(80) := 'benutils.get_assignment_id';

659: function get_assignment_id(p_person_id in number,
660: p_business_group_id in number,
661: p_effective_date in date) return number is
662: --
663: l_proc varchar2(80) := 'benutils.get_assignment_id';
664: l_assignment_id number;
665: --
666: cursor c_assignment is
667: select paf.assignment_id

Line 727: l_proc varchar2(80) := 'benutils.not_exists_in_hr_lookups';

723: ------------------------------------------------------------------------
724: function not_exists_in_hr_lookups(p_lookup_type in varchar2,
725: p_lookup_code in varchar2) return boolean is
726: --
727: l_proc varchar2(80) := 'benutils.not_exists_in_hr_lookups';
728: --
729: begin
730: --
731: hr_utility.set_location('Entering:'||l_proc, 5);

Line 760: l_proc varchar2(80) := 'benutils.formula_exists';

756: p_formula_type_id in number,
757: p_business_group_id in number,
758: p_effective_date in date) return boolean is
759: --
760: l_proc varchar2(80) := 'benutils.formula_exists';
761: l_dummy varchar2(1);
762: --
763: cursor c1 is
764: select null

Line 833: l_proc varchar2(80) := 'benutils.set_cache_record_position';

829: -- set_cache_record_position
830: ------------------------------------------------------------------------
831: procedure set_cache_record_position is
832: --
833: l_proc varchar2(80) := 'benutils.set_cache_record_position';
834: --
835: begin
836: --
837: hr_utility.set_location('Entering:'||l_proc, 5);

Line 862: l_proc varchar2(80) := 'benutils.rollback_cache';

858: -- rollback_cache
859: ------------------------------------------------------------------------
860: procedure rollback_cache is
861: --
862: l_proc varchar2(80) := 'benutils.rollback_cache';
863: --
864: begin
865: hr_utility.set_location('Entering:'||l_proc, 5);
866:

Line 953: l_proc varchar2(80) := 'benutils.write_table_and_file';

949: ------------------------------------------------------------------------
950: procedure write_table_and_file(p_table in boolean ,
951: p_file in boolean ) is
952: --
953: l_proc varchar2(80) := 'benutils.write_table_and_file';
954: l_num1_col g_number_table := g_number_table();
955: l_num2_col g_number_table := g_number_table();
956: l_num3_col g_number_table := g_number_table();
957: l_num4_col g_number_table := g_number_table();

Line 1938: l_proc varchar2(80) := 'benutils.write 1';

1934: procedure write(p_rec in out nocopy ben_type.g_report_rec) is
1935: --
1936: l_reporting_id number(38);
1937: l_object_version_number number(38);
1938: l_proc varchar2(80) := 'benutils.write 1';
1939: l_rec ben_type.g_report_rec;
1940: l_count number := 1;
1941: --
1942: begin

Line 1992: l_proc varchar2(80) := 'benutils.get_batch_parameters';

1988: ------------------------------------------------------------------------
1989: procedure get_batch_parameters(p_benefit_action_id in number,
1990: p_rec in out nocopy g_batch_param_rec) is
1991: --
1992: l_proc varchar2(80) := 'benutils.get_batch_parameters';
1993: --
1994: cursor c1 is
1995: select PROCESS_DATE,
1996: MODE_CD,

Line 2081: l_proc varchar2(80) := 'benutils.write 2';

2077: procedure write(p_rec in out nocopy g_batch_elig_rec) is
2078: --
2079: l_batch_elig_id number(38);
2080: l_object_version_number number(38);
2081: l_proc varchar2(80) := 'benutils.write 2';
2082: l_rec g_batch_elig_rec;
2083: l_count number := 1;
2084: l_oipl_rec ben_oipl_f%rowtype;
2085: l_params g_batch_param_rec;

Line 2147: l_proc varchar2(80) := 'benutils.write 3';

2143: end write;
2144: --
2145: procedure write(p_rec in out nocopy ben_type.g_batch_action_rec) is
2146: --
2147: l_proc varchar2(80) := 'benutils.write 3';
2148: l_rec ben_type.g_batch_action_rec;
2149: l_count number := 1;
2150: --
2151: begin

Line 2174: l_proc varchar2(80) := 'benutils.write 4';

2170: end write;
2171: --
2172: procedure write(p_rec in out nocopy g_batch_elctbl_rec) is
2173: --
2174: l_proc varchar2(80) := 'benutils.write 4';
2175: l_rec g_batch_elctbl_rec;
2176: l_count number := 1;
2177: l_params g_batch_param_rec;
2178: --

Line 2232: l_proc varchar2(80) := 'benutils.write 5';

2228: end write;
2229: --
2230: procedure write(p_rec in out nocopy g_batch_rate_rec) is
2231: --
2232: l_proc varchar2(80) := 'benutils.write 5';
2233: l_rec g_batch_rate_rec;
2234: l_count number := 1;
2235: l_params g_batch_param_rec;
2236: --

Line 2298: l_proc varchar2(80) := 'benutils.write 6';

2294: end write;
2295: --
2296: procedure write(p_rec in out nocopy g_batch_dpnt_rec) is
2297: --
2298: l_proc varchar2(80) := 'benutils.write 6';
2299: l_rec g_batch_dpnt_rec;
2300: l_count number := 1;
2301: l_params g_batch_param_rec;
2302: --

Line 2352: l_proc varchar2(80) := 'benutils.write 7';

2348: end write;
2349: --
2350: procedure write(p_rec in out nocopy ben_type.g_batch_commu_rec) is
2351: --
2352: l_proc varchar2(80) := 'benutils.write 7';
2353: l_rec ben_type.g_batch_commu_rec;
2354: l_count number := 1;
2355: --
2356: begin

Line 2387: l_proc varchar2(80) := 'benutils.write 8';

2383: procedure write(p_rec in out nocopy g_batch_ler_rec) is
2384: --
2385: l_batch_ler_id number(38);
2386: l_object_version_number number(38);
2387: l_proc varchar2(80) := 'benutils.write 8';
2388: l_rec g_batch_ler_rec;
2389: l_count number := 1;
2390: l_params g_batch_param_rec;
2391: --

Line 2435: l_proc varchar2(80) := 'benutils.write 9';

2431: procedure write(p_rec in out nocopy ben_type.g_batch_proc_rec) is
2432: --
2433: l_batch_proc_id number(38);
2434: l_object_version_number number(38);
2435: l_proc varchar2(80) := 'benutils.write 9';
2436: l_rec ben_type.g_batch_proc_rec;
2437: l_count number := 1;
2438: --
2439: begin

Line 2473: l_proc varchar2(80) := 'benutils.write 10';

2469: p_validate in boolean ) is
2470: --
2471: l_reporting_id number(38);
2472: l_object_version_number number(38);
2473: l_proc varchar2(80) := 'benutils.write 10';
2474: l_count number := 1;
2475: --
2476: begin
2477: --

Line 2545: l_proc varchar2(80) := 'benutils.update_life_event_cache';

2541: ------------------------------------------------------------------------
2542: procedure update_life_event_cache
2543: (p_open_and_closed in varchar2 ) is
2544: --
2545: l_proc varchar2(80) := 'benutils.update_life_event_cache';
2546: --
2547: begin
2548: --
2549: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2586: l_proc varchar2(80) := 'benutils.get_parameter';

2582: p_threads out nocopy number,
2583: p_chunk_size out nocopy number,
2584: p_max_errors out nocopy number) is
2585: --
2586: l_proc varchar2(80) := 'benutils.get_parameter';
2587: --
2588: cursor c1 is
2589: select nvl(bbp.thread_cnt_num,
2590: decode(p_batch_exe_cd,'BENGCMOD',1,3)),

Line 2638: l_proc varchar2(80) := 'benutils.iftrue';

2634: function iftrue(p_expression in boolean,
2635: p_true in varchar2,
2636: p_false in varchar2) return varchar2 is
2637: --
2638: l_proc varchar2(80) := 'benutils.iftrue';
2639: --
2640: begin
2641: --
2642: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2664: l_proc varchar2(80) := 'benutils.zero_to_null';

2660: ------------------------------------------------------------------------
2661: function zero_to_null(p_value in number) return number is
2662: --
2663: l_value number;
2664: l_proc varchar2(80) := 'benutils.zero_to_null';
2665: --
2666: begin
2667: --
2668: --hr_utility.set_location('Entering:'||l_proc, 5);

Line 2700: l_proc varchar2(80) := 'benutils.get_bp_name';

2696: --
2697: l_comments varchar2(2000);
2698: l_start number(9) := 0;
2699: l_end number(9) := 0;
2700: l_proc varchar2(80) := 'benutils.get_bp_name';
2701: --
2702: begin
2703: --
2704: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2747: l_proc varchar2(80) := 'benutils.part_of_pkey';

2743: -- part_of_pkey
2744: ------------------------------------------------------------------------
2745: function part_of_pkey(p_column_name in varchar2) return boolean is
2746: --
2747: l_proc varchar2(80) := 'benutils.part_of_pkey';
2748: --
2749: begin
2750: --
2751: --hr_utility.set_location('Entering:'||l_proc, 5);

Line 2800: l_proc varchar2(80) := 'benutils.define_primary_key';

2796: order by c.position;
2797: --
2798: l_column varchar2(30);
2799: l_number_of_columns number(9) := 0;
2800: l_proc varchar2(80) := 'benutils.define_primary_key';
2801: --
2802: begin
2803: --
2804: hr_utility.set_location('Entering:'||l_proc, 5);

Line 2862: l_proc varchar2(80) := 'benutils.lookups_exist';

2858: or substr(t.column_name,length(t.column_name)-4,5) = '_FLAG')
2859: and t.owner = upper(l_oracle_schema);
2860: --
2861: l_dummy varchar2(1);
2862: l_proc varchar2(80) := 'benutils.lookups_exist';
2863: --
2864: begin
2865: --
2866: --hr_utility.set_location('Entering:'||l_proc, 5);

Line 2898: l_proc varchar2(80) := 'benutils.get_primary_key';

2894: ------------------------------------------------------------------------
2895: function get_primary_key(p_tablename in varchar2) return varchar2 is
2896: --
2897: l_primary_key all_cons_columns.column_name%type;
2898: l_proc varchar2(80) := 'benutils.get_primary_key';
2899: l_status varchar2(1);
2900: l_industry varchar2(1);
2901: l_application_short_name varchar2(30);
2902: l_oracle_schema varchar2(30);

Line 2964: l_proc varchar2(80) := 'benutils.business_group_exists';

2960: and a.owner = upper(l_oracle_schema);
2961: --
2962: l_dummy varchar2(1);
2963: l_result boolean := false;
2964: l_proc varchar2(80) := 'benutils.business_group_exists';
2965: --
2966: begin
2967: --
2968: --hr_utility.set_location('Entering:'||l_proc, 5);

Line 2999: l_proc varchar2(80) := 'benutils.table_datetracked';

2995: -- table_datetracked
2996: ------------------------------------------------------------------------
2997: function table_datetracked(p_tablename in varchar2) return boolean is
2998: --
2999: l_proc varchar2(80) := 'benutils.table_datetracked';
3000: --
3001: begin
3002: --
3003: --hr_utility.set_location('Entering:'||l_proc, 5);

Line 3035: l_proc varchar2(80) := 'benutils.attributes_exist';

3031: and utc.owner = upper(l_oracle_schema);
3032: --
3033: l_dummy varchar2(1);
3034: l_found boolean := false;
3035: l_proc varchar2(80) := 'benutils.attributes_exist';
3036: --
3037: begin
3038: --
3039: --hr_utility.set_location('Entering:'||l_proc, 5);

Line 3085: l_proc varchar2(80) := 'benutils.get_pk_constraint_name';

3081: and con.constraint_type = 'P'
3082: and con.owner = upper(l_oracle_schema);
3083: --
3084: l_constraint_name all_constraints.constraint_name%type;
3085: l_proc varchar2(80) := 'benutils.get_pk_constraint_name';
3086: --
3087: begin
3088: --
3089: --hr_utility.set_location('Entering:'||l_proc, 5);

Line 3257: l_proc varchar2(72) := 'benutils.do_rounding';

3253: p_assignment_id in number ,
3254: p_value in number,
3255: p_effective_date in date) return number is
3256: --
3257: l_proc varchar2(72) := 'benutils.do_rounding';
3258: --
3259: l_rndg_fctr number;
3260: l_rndg_type varchar2(10);
3261: l_modulus number;

Line 3284: l_outputs := benutils.formula

3280: elsif p_rounding_cd = 'RL' then
3281: --
3282: -- Call formula initialise routine
3283: --
3284: l_outputs := benutils.formula
3285: (p_formula_id => p_rounding_rl,
3286: p_effective_date => p_effective_date,
3287: p_assignment_id => p_assignment_id,
3288: p_param1 => 'VALUE',

Line 3456: l_proc varchar2(72) := 'benutils.derive_date';

3452: p_max in number,
3453: p_value in varchar2,
3454: p_decimal_level in varchar2 ) return date is
3455: --
3456: l_proc varchar2(72) := 'benutils.derive_date';
3457: l_value date;
3458: l_val number;
3459: l_fractional number;
3460: --

Line 3567: l_proc varchar2(72) := 'benutils.do_uom';

3563: p_date2 in date,
3564: p_uom in varchar2) return number is
3565: --
3566: l_value number;
3567: l_proc varchar2(72) := 'benutils.do_uom';
3568: --
3569: begin
3570: --
3571: hr_utility.set_location('Entering:'||l_proc, 5);

Line 3634: l_proc varchar2(80) := 'benutils.id';

3630: ------------------------------------------------------------------------
3631: function id(p_value in number) return varchar2 is
3632: --
3633: l_value varchar2(30);
3634: l_proc varchar2(80) := 'benutils.id';
3635: --
3636: begin
3637: --
3638: hr_utility.set_location('Entering:'||l_proc, 5);

Line 3667: l_package varchar2(80) := 'benutils.min_max_breach';

3663: p_new_value in number,
3664: p_break out nocopy varchar2,
3665: p_decimal_level in varchar2 ) return boolean is
3666: --
3667: l_package varchar2(80) := 'benutils.min_max_breach';
3668: --
3669: l_return boolean := false;
3670: l_min_value number;
3671: l_max_value number;

Line 3844: l_package varchar2(80) := 'benutils.eot_to_null';

3840: ------------------------------------------------------------------------
3841: function eot_to_null(p_date in date) return date is
3842: --
3843: l_date date := null;
3844: l_package varchar2(80) := 'benutils.eot_to_null';
3845: --
3846: begin
3847: --
3848: hr_utility.set_location ('Entering '||l_package,10);

Line 3868: l_package varchar2(80) := 'benutils.eot_to_null';

3864: --
3865: function eot_to_null(p_date in varchar2) return varchar2 is
3866: --
3867: l_date date := null;
3868: l_package varchar2(80) := 'benutils.eot_to_null';
3869: --
3870: begin
3871: --
3872: hr_utility.set_location ('Entering '||l_package,5);

Line 3874: l_date := benutils.eot_to_null(to_date(p_date,'DD/MM/YYYY'));

3870: begin
3871: --
3872: hr_utility.set_location ('Entering '||l_package,5);
3873: --
3874: l_date := benutils.eot_to_null(to_date(p_date,'DD/MM/YYYY'));
3875: --
3876: hr_utility.set_location ('Leaving '||l_package,5);
3877: return(to_char(l_date,'DD/MM/YYYY'));
3878: --

Line 4544: -- benutils.formula call.

4540: --
4541: end if;
4542: --
4543: -- Bug 1949361 : jurisdiction_code is fetched inside the
4544: -- benutils.formula call.
4545: --
4546: /*
4547: if l_ass_rec.location_id is not null then
4548: --

Line 4564: l_outputs := benutils.formula

4560: end if;
4561: */
4562: --
4563: hr_utility.set_location('assignment_id '||l_ass_rec.assignment_id , 13);
4564: l_outputs := benutils.formula
4565: (p_formula_id => p_formula_id,
4566: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
4567: p_assignment_id => l_ass_rec.assignment_id,
4568: p_organization_id => l_ass_rec.organization_id,

Line 5550: -- This function has been added to benutils as part of fix for bug 2599034

5546: -- Description:
5547: -- Returns the display concatenated string for the segments1..30.
5548: -- The function calls hr_api.return_concat_kf_segments to get the
5549: -- concatenated segments.
5550: -- This function has been added to benutils as part of fix for bug 2599034
5551: -- Since there is a package HR_API present in PLD library and backend, it is
5552: -- conflicting with each other when we try to use the backend package from
5553: -- form. But hard-coding Apps. is not a good practice.
5554: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in

Line 5555: -- benutils to accomplish the same.

5551: -- Since there is a package HR_API present in PLD library and backend, it is
5552: -- conflicting with each other when we try to use the backend package from
5553: -- form. But hard-coding Apps. is not a good practice.
5554: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in
5555: -- benutils to accomplish the same.
5556: --
5557: -- Pre-conditions:
5558: -- The id_flex_num and segments have been fully validated.
5559: --

Line 5696: if benutils.g_ben_dspl_name_basis is null then

5692: l_session_date date := p_session_date;
5693: --
5694: begin
5695: --
5696: if benutils.g_ben_dspl_name_basis is null then
5697: benutils.g_ben_dspl_name_basis := fnd_profile.value('BEN_DSPL_NAME_BASIS');
5698: end if;
5699: --
5700: if l_session_date is null then

Line 5697: benutils.g_ben_dspl_name_basis := fnd_profile.value('BEN_DSPL_NAME_BASIS');

5693: --
5694: begin
5695: --
5696: if benutils.g_ben_dspl_name_basis is null then
5697: benutils.g_ben_dspl_name_basis := fnd_profile.value('BEN_DSPL_NAME_BASIS');
5698: end if;
5699: --
5700: if l_session_date is null then
5701: open c_session_date;

Line 5706: if benutils.g_ben_dspl_name_basis = 'SESSION' then

5702: fetch c_session_date into l_session_date;
5703: close c_session_date;
5704: end if;
5705: --
5706: if benutils.g_ben_dspl_name_basis = 'SESSION' then
5707: return l_session_date;
5708: elsif benutils.g_ben_dspl_name_basis = 'LEOD' then
5709: return nvl(p_lf_evt_ocrd_dt,l_session_date);
5710: elsif benutils.g_ben_dspl_name_basis = 'MXLECVG' then

Line 5708: elsif benutils.g_ben_dspl_name_basis = 'LEOD' then

5704: end if;
5705: --
5706: if benutils.g_ben_dspl_name_basis = 'SESSION' then
5707: return l_session_date;
5708: elsif benutils.g_ben_dspl_name_basis = 'LEOD' then
5709: return nvl(p_lf_evt_ocrd_dt,l_session_date);
5710: elsif benutils.g_ben_dspl_name_basis = 'MXLECVG' then
5711: -- return greatest(nvl(p_cvg_strt_dt,l_session_date),nvl(p_lf_evt_ocrd_dt,l_session_date));
5712: return l_session_date;

Line 5710: elsif benutils.g_ben_dspl_name_basis = 'MXLECVG' then

5706: if benutils.g_ben_dspl_name_basis = 'SESSION' then
5707: return l_session_date;
5708: elsif benutils.g_ben_dspl_name_basis = 'LEOD' then
5709: return nvl(p_lf_evt_ocrd_dt,l_session_date);
5710: elsif benutils.g_ben_dspl_name_basis = 'MXLECVG' then
5711: -- return greatest(nvl(p_cvg_strt_dt,l_session_date),nvl(p_lf_evt_ocrd_dt,l_session_date));
5712: return l_session_date;
5713: else
5714: return l_session_date;

Line 5745: l_comp_obj_disp_dt := benutils.get_comp_obj_disp_dt(

5741: fetch c_per_in_ler into l_lf_evt_ocrd_dt;
5742: close c_per_in_ler;
5743: end if;
5744: --
5745: l_comp_obj_disp_dt := benutils.get_comp_obj_disp_dt(
5746: p_session_date => p_session_date,
5747: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
5748: p_cvg_strt_dt => p_cvg_strt_dt);
5749: --

Line 5759: l_proc varchar2(80) := 'benutils.run_osb_benmngle_flag';

5755: function run_osb_benmngle_flag( p_person_id in number,
5756: p_business_group_id in number,
5757: p_effective_date in date) return boolean is
5758: --
5759: l_proc varchar2(80) := 'benutils.run_osb_benmngle_flag';
5760: l_per_last_upd_date date;
5761: l_pil_last_upd_date date;
5762: l_pil_lf_evt_ocrd_dt date;
5763: l_run_benmngle boolean := false;

Line 6053: end benutils;

6049: return l_exists_prev ;
6050: --
6051: end get_dpnt_prev_cvrd_flag;
6052: --
6053: end benutils;