[Home] [Help]
259: g_cache_ptip_rec(l_index):=p_rec;
260: --
261: end set_object;
262: --
263: procedure set_object(p_rec in out nocopy ben_opt_f%rowtype) is
264: --
265: l_proc varchar2(80) := g_package||'set_object opt ';
266: l_index pls_integer;
267: --l_not_hash_found boolean;
636: --
637: procedure set_object(p_opt_id in number,
638: p_business_group_id in number,
639: p_effective_date in date,
640: p_rec in out nocopy ben_opt_f%rowtype) is
641: --
642: l_proc varchar2(80) := g_package||'set_object alt opt';
643: --
644: cursor c1 is
642: l_proc varchar2(80) := g_package||'set_object alt opt';
643: --
644: cursor c1 is
645: select opt.*
646: from ben_opt_f opt
647: where opt.opt_id = p_opt_id
648: and opt.business_group_id = p_business_group_id
649: and p_effective_date
650: between opt.effective_start_date
649: and p_effective_date
650: between opt.effective_start_date
651: and opt.effective_end_date;
652: --
653: --l_rec ben_opt_f%rowtype;
654: --
655: begin
656: --
657: -- 1) Get record from database.
1084: --
1085: end get_object;
1086: --
1087: procedure get_object(p_opt_id in number,
1088: p_rec in out NOCOPY ben_opt_f%rowtype) is
1089: --
1090: l_proc varchar2(80) := g_package||'get_object opt';
1091: l_index pls_integer;
1092: --l_not_hash_found boolean;
1090: l_proc varchar2(80) := g_package||'get_object opt';
1091: l_index pls_integer;
1092: --l_not_hash_found boolean;
1093: l_env ben_env_object.g_global_env_rec_type;
1094: --l_rec ben_opt_f%rowtype;
1095: --
1096: begin
1097: --
1098: -- hr_utility.set_location('Entering '||l_proc,10);
1455: end get_object_set_cobra;
1456: --
1457: procedure clear_down_cache is
1458: --
1459: l_opt_rec ben_opt_f%rowtype;
1460: l_oiplip_rec ben_oiplip_f%rowtype;
1461: l_pgm_rec ben_pgm_f%rowtype;
1462: l_pl_rec ben_pl_f%rowtype;
1463: l_plip_rec ben_plip_f%rowtype;