APPS.BEN_ELIG_RL_CACHE dependencies on HR_UTILITY

Line 185: hr_utility.set_location(' Entering '||l_proc,10);

181: tab2.ordr_to_aply_num;
182: --
183: begin
184: --
185: hr_utility.set_location(' Entering '||l_proc,10);
186: --
187: -- Get the instance details
188: --
189: l_hv := mod(nvl(p_pgm_id,1)+nvl(p_ptip_id,2)+nvl(p_plip_id,3)

Line 253: hr_utility.set_location(' Dn Look '||l_proc,10);

249: g_odlookup(l_hv).fk1_id := p_plip_id;
250: g_odlookup(l_hv).fk2_id := p_pl_id;
251: g_odlookup(l_hv).fk3_id := p_oipl_id;
252: --
253: hr_utility.set_location(' Dn Look '||l_proc,10);
254: --
255: l_starttorele_num := nvl(g_nxelenum,0);
256: l_torrwnum := l_starttorele_num;
257: --

Line 258: hr_utility.set_location(' Bef inst loop '||l_proc,10);

254: --
255: l_starttorele_num := nvl(g_nxelenum,0);
256: l_torrwnum := l_starttorele_num;
257: --
258: hr_utility.set_location(' Bef inst loop '||l_proc,10);
259: --
260: if p_pgm_id is not null then
261: --
262: open c_pgminstance

Line 326: hr_utility.set_location(' Assign inst '||l_proc,10);

322: exit when c_oiplinstance%NOTFOUND;
323: --
324: end if;
325: --
326: hr_utility.set_location(' Assign inst '||l_proc,10);
327: --
328: g_odinst(l_torrwnum).id := l_instance.prtn_elig_id;
329: g_odinst(l_torrwnum).pgm_id := l_instance.pgm_id;
330: g_odinst(l_torrwnum).pl_id := l_instance.pl_id;

Line 386: hr_utility.set_location(' Leaving '||l_proc,10);

382: p_hv := null;
383: --
384: end if;
385: --
386: hr_utility.set_location(' Leaving '||l_proc,10);
387: end write_odcache;
388: --
389: procedure get_elig_rl_cache
390: (p_pgm_id in number

Line 426: -- hr_utility.set_location(' Derive hv '||l_proc,10);

422: --
423: g_odcached := 1;
424: --
425: end if;
426: -- hr_utility.set_location(' Derive hv '||l_proc,10);
427: if ben_manage_life_events.fonm = 'Y'
428: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
429: --
430: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

Line 532: -- hr_utility.set_location(' Got hv '||l_proc,10);

528: );
529: --
530: end if;
531: --
532: -- hr_utility.set_location(' Got hv '||l_proc,10);
533: --
534: if l_hv is not null then
535: --
536: l_torrwnum := 0;

Line 538: -- hr_utility.set_location(' Get loop '||l_proc,10);

534: if l_hv is not null then
535: --
536: l_torrwnum := 0;
537: --
538: -- hr_utility.set_location(' Get loop '||l_proc,10);
539: for l_insttorrw_num in g_odlookup(l_hv).starttorele_num ..
540: g_odlookup(l_hv).endtorele_num
541: loop
542: --

Line 548: -- hr_utility.set_location(' Dn Get loop '||l_proc,10);

544: l_torrwnum := l_torrwnum+1;
545: --
546: end loop;
547: --
548: -- hr_utility.set_location(' Dn Get loop '||l_proc,10);
549: --
550: end if;
551: --
552: p_inst_set := l_inst_set;

Line 555: -- hr_utility.set_location(' Leaving '||l_proc,10);

551: --
552: p_inst_set := l_inst_set;
553: p_inst_count := l_inst_set.count;
554: --
555: -- hr_utility.set_location(' Leaving '||l_proc,10);
556: exception
557: --
558: when no_data_found then
559: --