DBA Data[Home] [Help]

APPS.BEN_RT_ASNT_CACHE dependencies on HR_UTILITY

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

63: l_instance c_asr%rowtype;
64: --
65: begin
66: --
67: hr_utility.set_location(' Entering '||l_proc,10);
68: --
69: -- Get the instance details
70: --
71: l_hv := mod(nvl(p_vrbl_rt_prfl_id,1),g_hash_key);

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

113: --
114: end if;
115: g_asntlookup(l_hv).id := p_vrbl_rt_prfl_id;
116: --
117: hr_utility.set_location(' Dn Look '||l_proc,10);
118: --
119: l_starttorele_num := nvl(g_nxelenum,0);
120: l_torrwnum := l_starttorele_num;
121: --

Line 129: hr_utility.set_location('C Asr',11);

125: if c_asr%notfound then
126: exit;
127: end if;
128: --
129: hr_utility.set_location('C Asr',11);
130: g_asntinst(l_torrwnum).id := l_instance.vrbl_rt_prfl_id;
131: g_asntinst(l_torrwnum).formula_id := l_instance.formula_id;
132: g_asntinst(l_torrwnum).excld_flag := l_instance.excld_flag;
133: --

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

154: p_hv := null;
155: --
156: end if;
157: --
158: hr_utility.set_location(' Leaving '||l_proc,10);
159: end write_asntcache;
160: --
161: procedure get_rt_asnt_cache
162: (p_vrbl_rt_prfl_id in number

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

189: --
190: g_asntcached := 1;
191: --
192: end if;
193: -- hr_utility.set_location(' Derive hv '||l_proc,10);
194: ---- Get the instance details
195: --
196: l_hv := mod(nvl(p_vrbl_rt_prfl_id,1),g_hash_key);
197: --

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

273: );
274: --
275: end if;
276: --
277: hr_utility.set_location(' Got hv '||l_proc,10);
278: --
279: if l_hv is not null then
280: --
281: l_torrwnum := 0;

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

279: if l_hv is not null then
280: --
281: l_torrwnum := 0;
282: --
283: hr_utility.set_location(' Get loop '||l_proc,10);
284: for l_insttorrw_num in g_asntlookup(l_hv).starttorele_num ..
285: g_asntlookup(l_hv).endtorele_num
286: loop
287: --

Line 288: hr_utility.set_location('Instance set'||g_asntinst(l_insttorrw_num).formula_id,12);

284: for l_insttorrw_num in g_asntlookup(l_hv).starttorele_num ..
285: g_asntlookup(l_hv).endtorele_num
286: loop
287: --
288: hr_utility.set_location('Instance set'||g_asntinst(l_insttorrw_num).formula_id,12);
289: l_inst_set(l_torrwnum) := g_asntinst(l_insttorrw_num);
290: l_torrwnum := l_torrwnum+1;
291: --
292: end loop;

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

290: l_torrwnum := l_torrwnum+1;
291: --
292: end loop;
293: --
294: hr_utility.set_location(' Dn Get loop '||l_proc,10);
295: --
296: end if;
297: --
298: p_inst_set := l_inst_set;

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

297: --
298: p_inst_set := l_inst_set;
299: p_inst_count := l_inst_set.count;
300: --
301: hr_utility.set_location(' Leaving '||l_proc,10);
302: exception
303: --
304: when no_data_found then
305: --