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.26.12020000.2 2012/11/15 12:02:19 usaraswa ship $ */
3: --
4: g_package varchar2(80) := 'benutils';
5:

Line 2: /* $Header: benutils.pkb 120.26.12020000.2 2012/11/15 12:02:19 usaraswa ship $ */

1: package body benutils as
2: /* $Header: benutils.pkb 120.26.12020000.2 2012/11/15 12:02:19 usaraswa 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.26.12020000.2 2012/11/15 12:02:19 usaraswa 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 730: l_proc varchar2(80) := 'benutils.not_exists_in_hr_lookups';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2825: -- Bug 15876152 end
2826: --
2827: l_column varchar2(30);
2828: l_number_of_columns number(9) := 0;
2829: l_proc varchar2(80) := 'benutils.define_primary_key';
2830: --
2831: begin
2832: --
2833: hr_utility.set_location('Entering:'||l_proc, 5);

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

2902: and col.owner = upper(l_oracle_schema);
2903: -- Bug 15876152 end
2904: --
2905: l_dummy varchar2(1);
2906: l_proc varchar2(80) := 'benutils.lookups_exist';
2907: --
2908: begin
2909: --
2910: --hr_utility.set_location('Entering:'||l_proc, 5);

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

2938: ------------------------------------------------------------------------
2939: function get_primary_key(p_tablename in varchar2) return varchar2 is
2940: --
2941: l_primary_key all_cons_columns.column_name%type;
2942: l_proc varchar2(80) := 'benutils.get_primary_key';
2943: l_status varchar2(1);
2944: l_industry varchar2(1);
2945: l_application_short_name varchar2(30);
2946: l_oracle_schema varchar2(30);

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

3034: -- Bug 15876152 end
3035: --
3036: l_dummy varchar2(1);
3037: l_result boolean := false;
3038: l_proc varchar2(80) := 'benutils.business_group_exists';
3039: --
3040: begin
3041: --
3042: --hr_utility.set_location('Entering:'||l_proc, 5);

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

3069: -- table_datetracked
3070: ------------------------------------------------------------------------
3071: function table_datetracked(p_tablename in varchar2) return boolean is
3072: --
3073: l_proc varchar2(80) := 'benutils.table_datetracked';
3074: --
3075: begin
3076: --
3077: --hr_utility.set_location('Entering:'||l_proc, 5);

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

3115: -- Bug 15876152 end
3116: --
3117: l_dummy varchar2(1);
3118: l_found boolean := false;
3119: l_proc varchar2(80) := 'benutils.attributes_exist';
3120: --
3121: begin
3122: --
3123: --hr_utility.set_location('Entering:'||l_proc, 5);

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

3165: and con.constraint_type = 'P'
3166: and con.owner = upper(l_oracle_schema);
3167: --
3168: l_constraint_name all_constraints.constraint_name%type;
3169: l_proc varchar2(80) := 'benutils.get_pk_constraint_name';
3170: --
3171: begin
3172: --
3173: --hr_utility.set_location('Entering:'||l_proc, 5);

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

3337: p_assignment_id in number ,
3338: p_value in number,
3339: p_effective_date in date) return number is
3340: --
3341: l_proc varchar2(72) := 'benutils.do_rounding';
3342: --
3343: l_rndg_fctr number;
3344: l_rndg_type varchar2(10);
3345: l_modulus number;

Line 3368: l_outputs := benutils.formula

3364: elsif p_rounding_cd = 'RL' then
3365: --
3366: -- Call formula initialise routine
3367: --
3368: l_outputs := benutils.formula
3369: (p_formula_id => p_rounding_rl,
3370: p_effective_date => p_effective_date,
3371: p_assignment_id => p_assignment_id,
3372: p_param1 => 'VALUE',

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

3536: p_max in number,
3537: p_value in varchar2,
3538: p_decimal_level in varchar2 ) return date is
3539: --
3540: l_proc varchar2(72) := 'benutils.derive_date';
3541: l_value date;
3542: l_val number;
3543: l_fractional number;
3544: --

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

3659: p_date2 in date,
3660: p_uom in varchar2) return number is
3661: --
3662: l_value number;
3663: l_proc varchar2(72) := 'benutils.do_uom';
3664: --
3665: begin
3666: --
3667: hr_utility.set_location('Entering:'||l_proc, 5);

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

3726: ------------------------------------------------------------------------
3727: function id(p_value in number) return varchar2 is
3728: --
3729: l_value varchar2(30);
3730: l_proc varchar2(80) := 'benutils.id';
3731: --
3732: begin
3733: --
3734: hr_utility.set_location('Entering:'||l_proc, 5);

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

3759: p_new_value in number,
3760: p_break out nocopy varchar2,
3761: p_decimal_level in varchar2 ) return boolean is
3762: --
3763: l_package varchar2(80) := 'benutils.min_max_breach';
3764: --
3765: l_return boolean := false;
3766: l_min_value number;
3767: l_max_value number;

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

3936: ------------------------------------------------------------------------
3937: function eot_to_null(p_date in date) return date is
3938: --
3939: l_date date := null;
3940: l_package varchar2(80) := 'benutils.eot_to_null';
3941: --
3942: begin
3943: --
3944: hr_utility.set_location ('Entering '||l_package,10);

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

3960: --
3961: function eot_to_null(p_date in varchar2) return varchar2 is
3962: --
3963: l_date date := null;
3964: l_package varchar2(80) := 'benutils.eot_to_null';
3965: --
3966: begin
3967: --
3968: hr_utility.set_location ('Entering '||l_package,5);

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

3966: begin
3967: --
3968: hr_utility.set_location ('Entering '||l_package,5);
3969: --
3970: l_date := benutils.eot_to_null(to_date(p_date,'DD/MM/YYYY'));
3971: --
3972: hr_utility.set_location ('Leaving '||l_package,5);
3973: return(to_char(l_date,'DD/MM/YYYY'));
3974: --

Line 4669: -- benutils.formula call.

4665: --
4666: end if;
4667: --
4668: -- Bug 1949361 : jurisdiction_code is fetched inside the
4669: -- benutils.formula call.
4670: --
4671: /*
4672: if l_ass_rec.location_id is not null then
4673: --

Line 4689: l_outputs := benutils.formula

4685: end if;
4686: */
4687: --
4688: hr_utility.set_location('assignment_id '||l_ass_rec.assignment_id , 13);
4689: l_outputs := benutils.formula
4690: (p_formula_id => p_formula_id,
4691: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
4692: p_assignment_id => l_ass_rec.assignment_id,
4693: p_organization_id => l_ass_rec.organization_id,

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

5671: -- Description:
5672: -- Returns the display concatenated string for the segments1..30.
5673: -- The function calls hr_api.return_concat_kf_segments to get the
5674: -- concatenated segments.
5675: -- This function has been added to benutils as part of fix for bug 2599034
5676: -- Since there is a package HR_API present in PLD library and backend, it is
5677: -- conflicting with each other when we try to use the backend package from
5678: -- form. But hard-coding Apps. is not a good practice.
5679: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in

Line 5680: -- benutils to accomplish the same.

5676: -- Since there is a package HR_API present in PLD library and backend, it is
5677: -- conflicting with each other when we try to use the backend package from
5678: -- form. But hard-coding Apps. is not a good practice.
5679: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in
5680: -- benutils to accomplish the same.
5681: --
5682: -- Pre-conditions:
5683: -- The id_flex_num and segments have been fully validated.
5684: --

Line 5821: if benutils.g_ben_dspl_name_basis is null then

5817: l_session_date date := p_session_date;
5818: --
5819: begin
5820: --
5821: if benutils.g_ben_dspl_name_basis is null then
5822: benutils.g_ben_dspl_name_basis := fnd_profile.value('BEN_DSPL_NAME_BASIS');
5823: end if;
5824: --
5825: if l_session_date is null then

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

5818: --
5819: begin
5820: --
5821: if benutils.g_ben_dspl_name_basis is null then
5822: benutils.g_ben_dspl_name_basis := fnd_profile.value('BEN_DSPL_NAME_BASIS');
5823: end if;
5824: --
5825: if l_session_date is null then
5826: open c_session_date;

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

5827: fetch c_session_date into l_session_date;
5828: close c_session_date;
5829: end if;
5830: --
5831: if benutils.g_ben_dspl_name_basis = 'SESSION' then
5832: return l_session_date;
5833: elsif benutils.g_ben_dspl_name_basis = 'LEOD' then
5834: return nvl(p_lf_evt_ocrd_dt,l_session_date);
5835: elsif benutils.g_ben_dspl_name_basis = 'MXLECVG' then

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

5829: end if;
5830: --
5831: if benutils.g_ben_dspl_name_basis = 'SESSION' then
5832: return l_session_date;
5833: elsif benutils.g_ben_dspl_name_basis = 'LEOD' then
5834: return nvl(p_lf_evt_ocrd_dt,l_session_date);
5835: elsif benutils.g_ben_dspl_name_basis = 'MXLECVG' then
5836: -- return greatest(nvl(p_cvg_strt_dt,l_session_date),nvl(p_lf_evt_ocrd_dt,l_session_date));
5837: return l_session_date;

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

5831: if benutils.g_ben_dspl_name_basis = 'SESSION' then
5832: return l_session_date;
5833: elsif benutils.g_ben_dspl_name_basis = 'LEOD' then
5834: return nvl(p_lf_evt_ocrd_dt,l_session_date);
5835: elsif benutils.g_ben_dspl_name_basis = 'MXLECVG' then
5836: -- return greatest(nvl(p_cvg_strt_dt,l_session_date),nvl(p_lf_evt_ocrd_dt,l_session_date));
5837: return l_session_date;
5838: else
5839: return l_session_date;

Line 5870: l_comp_obj_disp_dt := benutils.get_comp_obj_disp_dt(

5866: fetch c_per_in_ler into l_lf_evt_ocrd_dt;
5867: close c_per_in_ler;
5868: end if;
5869: --
5870: l_comp_obj_disp_dt := benutils.get_comp_obj_disp_dt(
5871: p_session_date => p_session_date,
5872: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
5873: p_cvg_strt_dt => p_cvg_strt_dt);
5874: --

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

5880: function run_osb_benmngle_flag( p_person_id in number,
5881: p_business_group_id in number,
5882: p_effective_date in date) return boolean is
5883: --
5884: l_proc varchar2(80) := 'benutils.run_osb_benmngle_flag';
5885: l_per_last_upd_date date;
5886: l_pil_last_upd_date date;
5887: l_pil_lf_evt_ocrd_dt date;
5888: l_run_benmngle boolean := false;

Line 6179: end benutils;

6175: return l_exists_prev ;
6176: --
6177: end get_dpnt_prev_cvrd_flag;
6178: --
6179: end benutils;