APPS.BEN_ELIG_RL_CACHE dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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