[Home] [Help]
369: used for it (1633284,1558809,1584238)
370: 115.156 15-Mar-01 kmahendr Bug#1684498 - added enrt_cvg_thru_dt condition
371: in the cursor c_prtt_total_bnft_amt in procedure
372: multi_rows_edit
373: 115.157 23-Mar-01 maagrawa Call to ben_env_object.init added to
374: delete_enrollment.
375: 115.158 26-Apr-01 maagrawa Performance changes.
376: Bypass dependent,beneficiary,flex credit,
377: premium logic based on plan design.
374: delete_enrollment.
375: 115.158 26-Apr-01 maagrawa Performance changes.
376: Bypass dependent,beneficiary,flex credit,
377: premium logic based on plan design.
378: 115.159 30-Apr-01 maagrawa Call ben_env_object.init to initialize
379: cache variables.
380: 115.160 04-May-01 ikasire 1712890 Added the validation conditions for
381: attribute columns in UPDATE routine
382: 115.161 08-May-01 jcarpent Bug 158783. Reset l_ppe.prtt_prem_id before
503: 115.218 19-apr-04 bmanyam Bug# 3573173 : In c_prem cursor, added
504: condition NVL(ecr.enrt_bnft_id, -1) = NVL(p_enrt_bnft_id, -1) to
505: make sure the ben_enrt_prem record refers to the correct ben_enrt_bnft_f
506: record while creating ben_prtt_prem.
507: 115.219 21-Apr-04 kmahendr Bug#3568529 - ben_env_object.init is called only if the
508: object was not initialised.
509: 115.220 04-May-04 bmanyam Bug: 3574168 - In void_enrollment, delete_enrollment and
510: unhook_dpnt procedures, added code to delete the assigned
511: Primary-Care-Providers for the enrollment.
2606: --
2607: if fnd_global.conc_request_id in (0,-1) then
2608: --
2609: --
2610: ben_env_object.init(p_business_group_id => p_business_group_id,
2611: p_effective_date => p_effective_date,
2612: p_thread_id => 1,
2613: p_chunk_size => 1,
2614: p_threads => 1,
4617: and c_cvg_thru_dt = ENRT_CVG_THRU_DT
4618: and nvl(c_pen_stat_cd,'-1') = nvl(PRTT_ENRT_RSLT_STAT_CD,'-1')
4619: ;
4620:
4621: l_env_rec ben_env_object.g_global_env_rec_type;
4622:
4623: l_dummy varchar2(1) ;
4624:
4625: --
4639: if fnd_global.conc_request_id in (0,-1) and
4640: p_business_group_id <> hr_api.g_number then
4641: --
4642: --bug#3568529
4643: ben_env_object.get(p_rec => l_env_rec);
4644: if l_env_rec.benefit_action_id is null then
4645: --
4646: ben_env_object.init(p_business_group_id => p_business_group_id,
4647: p_effective_date => p_effective_date,
4642: --bug#3568529
4643: ben_env_object.get(p_rec => l_env_rec);
4644: if l_env_rec.benefit_action_id is null then
4645: --
4646: ben_env_object.init(p_business_group_id => p_business_group_id,
4647: p_effective_date => p_effective_date,
4648: p_thread_id => 1,
4649: p_chunk_size => 1,
4650: p_threads => 1,
5536: and p_effective_date between
5537: chg.effective_start_date and chg.effective_end_date
5538: ;
5539: l_chg c_ler_chg_dep%rowtype;
5540: l_env_rec ben_env_object.g_global_env_rec_type;
5541: --
5542: begin
5543: g_debug := hr_utility.debug_enabled;
5544: if g_debug then
5548: l_step := 10;
5549: if fnd_global.conc_request_id in (0,-1) then
5550: --
5551: --bug#3568529
5552: ben_env_object.get(p_rec => l_env_rec);
5553: if l_env_rec.benefit_action_id is null then
5554: --
5555: ben_env_object.init(p_business_group_id => p_business_group_id,
5556: p_effective_date => p_effective_date,
5551: --bug#3568529
5552: ben_env_object.get(p_rec => l_env_rec);
5553: if l_env_rec.benefit_action_id is null then
5554: --
5555: ben_env_object.init(p_business_group_id => p_business_group_id,
5556: p_effective_date => p_effective_date,
5557: p_thread_id => 1,
5558: p_chunk_size => 1,
5559: p_threads => 1,
7131: l_pl_rec ben_cobj_cache.g_pl_inst_row;
7132: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
7133: l_deenrol_dt date;
7134: l_prv_count number;
7135: l_env_rec ben_env_object.g_global_env_rec_type;
7136: l_benmngle_parm_rec benutils.g_batch_param_rec;
7137: l_enrt_perd_id number ;
7138: l_lee_rsn_id number := null ;
7139: /* Start of Changes WWBUG: 1646442: added */
7490: --
7491: -- Work out if we are being called from a concurrent program
7492: -- otherwise we need to initialize the environment
7493: --
7494: ben_env_object.get(p_rec => l_env_rec);
7495: if fnd_global.conc_request_id in (0,-1) then
7496: --bug#3568529
7497: -- ben_env_object.get(p_rec => l_env_rec);
7498: if l_env_rec.benefit_action_id is null then
7493: --
7494: ben_env_object.get(p_rec => l_env_rec);
7495: if fnd_global.conc_request_id in (0,-1) then
7496: --bug#3568529
7497: -- ben_env_object.get(p_rec => l_env_rec);
7498: if l_env_rec.benefit_action_id is null then
7499: --
7500: hr_utility.set_location('Intialise env object',11);
7501: ben_env_object.init(p_business_group_id => p_business_group_id,
7497: -- ben_env_object.get(p_rec => l_env_rec);
7498: if l_env_rec.benefit_action_id is null then
7499: --
7500: hr_utility.set_location('Intialise env object',11);
7501: ben_env_object.init(p_business_group_id => p_business_group_id,
7502: p_effective_date => p_effective_date,
7503: p_thread_id => 1,
7504: p_chunk_size => 1,
7505: p_threads => 1,
7508: end if;
7509: --
7510: else
7511: -- to check whether it is called in benmngle selection mode
7512: ben_env_object.get(p_rec => l_env_rec);
7513: --
7514: -- If enrollment api's are called from concurrent manager for
7515: -- conversion or ivr kind of interfaces, call raises error.
7516: --
11935: --
11936: l_needs_dpnts c_needs_dpnts%rowtype;
11937: l_process_dpnt boolean := false;
11938: l_process_bnf boolean := false;
11939: l_env_rec ben_env_object.g_global_env_rec_type;
11940: --
11941: -- Bug 6656136
11942: cursor c_ler_typ_cd is
11943: --
11970: --
11971: if fnd_global.conc_request_id in (0,-1) then
11972: --
11973: --bug#3568529
11974: ben_env_object.get(p_rec => l_env_rec);
11975: if l_env_rec.benefit_action_id is null then
11976: --
11977: ben_env_object.init(p_business_group_id => p_business_group_id,
11978: p_effective_date => p_effective_date,
11973: --bug#3568529
11974: ben_env_object.get(p_rec => l_env_rec);
11975: if l_env_rec.benefit_action_id is null then
11976: --
11977: ben_env_object.init(p_business_group_id => p_business_group_id,
11978: p_effective_date => p_effective_date,
11979: p_thread_id => 1,
11980: p_chunk_size => 1,
11981: p_threads => 1,