261: order by apr.ordr_num;
262: --
263: begin
264: --
265: hr_utility.set_location(' Entering '||l_proc,10);
266: hr_utility.set_location(' p_acty_base_rt_id '||p_acty_base_rt_id,10);
267: hr_utility.set_location(' p_cvg_amt_calc_mthd_id '||p_cvg_amt_calc_mthd_id,10);
268: hr_utility.set_location(' p_actl_prem_id '||p_actl_prem_id,10);
269: --
262: --
263: begin
264: --
265: hr_utility.set_location(' Entering '||l_proc,10);
266: hr_utility.set_location(' p_acty_base_rt_id '||p_acty_base_rt_id,10);
267: hr_utility.set_location(' p_cvg_amt_calc_mthd_id '||p_cvg_amt_calc_mthd_id,10);
268: hr_utility.set_location(' p_actl_prem_id '||p_actl_prem_id,10);
269: --
270: -- Get the instance details
263: begin
264: --
265: hr_utility.set_location(' Entering '||l_proc,10);
266: hr_utility.set_location(' p_acty_base_rt_id '||p_acty_base_rt_id,10);
267: hr_utility.set_location(' p_cvg_amt_calc_mthd_id '||p_cvg_amt_calc_mthd_id,10);
268: hr_utility.set_location(' p_actl_prem_id '||p_actl_prem_id,10);
269: --
270: -- Get the instance details
271: --
264: --
265: hr_utility.set_location(' Entering '||l_proc,10);
266: hr_utility.set_location(' p_acty_base_rt_id '||p_acty_base_rt_id,10);
267: hr_utility.set_location(' p_cvg_amt_calc_mthd_id '||p_cvg_amt_calc_mthd_id,10);
268: hr_utility.set_location(' p_actl_prem_id '||p_actl_prem_id,10);
269: --
270: -- Get the instance details
271: --
272: l_hv := mod(nvl(p_acty_base_rt_id,1)+
327: g_copcep_odlookup(l_hv).id := p_acty_base_rt_id;
328: g_copcep_odlookup(l_hv).fk_id := p_cvg_amt_calc_mthd_id;
329: g_copcep_odlookup(l_hv).fk1_id := p_actl_prem_id;
330: --
331: hr_utility.set_location(' Dn Look '||l_proc,10);
332: --
333: l_starttorele_num := nvl(g_copcep_nxelenum,1);
334: l_torrwnum := l_starttorele_num;
335: --
332: --
333: l_starttorele_num := nvl(g_copcep_nxelenum,1);
334: l_torrwnum := l_starttorele_num;
335: --
336: hr_utility.set_location(' Bef inst loop '||l_proc,10);
337: --
338: if p_acty_base_rt_id is not null then
339: --
340: open c_profile_abr
376: exit when c_profile_apr%NOTFOUND;
377: --
378: end if;
379: --
380: hr_utility.set_location(' Assign inst '||l_proc,10);
381: --
382: g_copcep_odinst.extend(1);
383: g_copcep_odinst(l_torrwnum).acty_base_rt_id := p_acty_base_rt_id;
384: g_copcep_odinst(l_torrwnum).cvg_amt_calc_mthd_id := p_cvg_amt_calc_mthd_id;
443: g_copcep_odinst(l_torrwnum).rt_perf_rtng_flag := l_instance.rt_perf_rtng_flag;
444: g_copcep_odinst(l_torrwnum).asmt_to_use_cd := l_instance.asmt_to_use_cd;
445: g_copcep_odinst(l_torrwnum).ordr_num := l_instance.ordr_num;
446: g_copcep_odinst(l_torrwnum).rt_elig_prfl_flag := l_instance.rt_elig_prfl_flag;
447: hr_utility.set_location(' Dn Assign inst '||l_proc,10);
448: --
449: l_torrwnum := l_torrwnum+1;
450: --
451: end loop;
485: p_hv := null;
486: --
487: end if;
488: --
489: hr_utility.set_location(' Leaving '||l_proc,10);
490: end write_abravr_odcache;
491: --
492: procedure clear_down_cache
493: is
534: l_clash_count pls_integer;
535: --
536: begin
537: --
538: hr_utility.set_location(' Entering '||l_proc,10);
539: --
540: if g_copcep_odcached = 0
541: then
542: --
642: if l_hv is not null then
643: --
644: l_torrwnum := 1;
645: --
646: hr_utility.set_location(' Get loop '||l_proc,10);
647: for l_insttorrw_num in g_copcep_odlookup(l_hv).starttorele_num ..
648: g_copcep_odlookup(l_hv).endtorele_num
649: loop
650: --
657: end if;
658: --
659: p_inst_set := l_inst_set;
660: --
661: hr_utility.set_location(' Leaving '||l_proc,10);
662: exception
663: --
664: when no_data_found then
665: --