[Home] [Help]
366: --
367: l_proc varchar2(80) := g_package||'get_object';
368: l_index binary_integer;
369: l_not_hash_found boolean;
370: l_env_rec ben_env_object.g_global_env_rec_type;
371: --
372: begin
373: --
374: -- hr_utility.set_location('Entering '||l_proc,10);
434: --
435: -- At this point we have the master record so we can derive the set of
436: -- children by looping through the relevant records.
437: --
438: ben_env_object.get(p_rec => l_env_rec);
439: --
440: if g_cache_ler_ler_rec(l_index).starttorele_num is not null then
441: --
442: for l_count in g_cache_ler_ler_rec(l_index).starttorele_num..
460: exception
461: --
462: when no_data_found then
463: --
464: ben_env_object.get(p_rec => l_env_rec);
465: --
466: set_ler_object(p_ler_id => p_ler_id,
467: p_business_group_id => l_env_rec.business_group_id,
468: p_effective_date => nvl(l_env_rec.lf_evt_ocrd_dt,
476: --
477: l_proc varchar2(80) := g_package||'get_object';
478: l_index binary_integer;
479: l_not_hash_found boolean;
480: l_env_rec ben_env_object.g_global_env_rec_type;
481: l_rec ben_life_object.g_cache_css_table;
482: --
483: begin
484: --
545: --
546: -- At this point we have the master record so we can derive the set of
547: -- children by looping through the relevant records.
548: --
549: ben_env_object.get(p_rec => l_env_rec);
550: --
551: if g_cache_css_ler_rec(l_index).starttorele_num is not null then
552: --
553: for l_count in g_cache_css_ler_rec(l_index).starttorele_num..
575: exception
576: --
577: when no_data_found then
578: --
579: ben_env_object.get(p_rec => l_env_rec);
580: --
581: set_css_object(p_ler_id => p_ler_id,
582: p_business_group_id => l_env_rec.business_group_id,
583: p_effective_date => nvl(l_env_rec.lf_evt_ocrd_dt,