[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.
2496: --
2497: if fnd_global.conc_request_id in (0,-1) then
2498: --
2499: --
2500: ben_env_object.init(p_business_group_id => p_business_group_id,
2501: p_effective_date => p_effective_date,
2502: p_thread_id => 1,
2503: p_chunk_size => 1,
2504: p_threads => 1,
4328: and c_cvg_thru_dt = ENRT_CVG_THRU_DT
4329: and nvl(c_pen_stat_cd,'-1') = nvl(PRTT_ENRT_RSLT_STAT_CD,'-1')
4330: ;
4331:
4332: l_env_rec ben_env_object.g_global_env_rec_type;
4333:
4334: l_dummy varchar2(1) ;
4335:
4336: --
4350: if fnd_global.conc_request_id in (0,-1) and
4351: p_business_group_id <> hr_api.g_number then
4352: --
4353: --bug#3568529
4354: ben_env_object.get(p_rec => l_env_rec);
4355: if l_env_rec.benefit_action_id is null then
4356: --
4357: ben_env_object.init(p_business_group_id => p_business_group_id,
4358: p_effective_date => p_effective_date,
4353: --bug#3568529
4354: ben_env_object.get(p_rec => l_env_rec);
4355: if l_env_rec.benefit_action_id is null then
4356: --
4357: ben_env_object.init(p_business_group_id => p_business_group_id,
4358: p_effective_date => p_effective_date,
4359: p_thread_id => 1,
4360: p_chunk_size => 1,
4361: p_threads => 1,
5247: and p_effective_date between
5248: chg.effective_start_date and chg.effective_end_date
5249: ;
5250: l_chg c_ler_chg_dep%rowtype;
5251: l_env_rec ben_env_object.g_global_env_rec_type;
5252: --
5253: begin
5254: g_debug := hr_utility.debug_enabled;
5255: if g_debug then
5259: l_step := 10;
5260: if fnd_global.conc_request_id in (0,-1) then
5261: --
5262: --bug#3568529
5263: ben_env_object.get(p_rec => l_env_rec);
5264: if l_env_rec.benefit_action_id is null then
5265: --
5266: ben_env_object.init(p_business_group_id => p_business_group_id,
5267: p_effective_date => p_effective_date,
5262: --bug#3568529
5263: ben_env_object.get(p_rec => l_env_rec);
5264: if l_env_rec.benefit_action_id is null then
5265: --
5266: ben_env_object.init(p_business_group_id => p_business_group_id,
5267: p_effective_date => p_effective_date,
5268: p_thread_id => 1,
5269: p_chunk_size => 1,
5270: p_threads => 1,
6752: l_pl_rec ben_cobj_cache.g_pl_inst_row;
6753: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
6754: l_deenrol_dt date;
6755: l_prv_count number;
6756: l_env_rec ben_env_object.g_global_env_rec_type;
6757: l_benmngle_parm_rec benutils.g_batch_param_rec;
6758: l_enrt_perd_id number ;
6759: l_lee_rsn_id number := null ;
6760: /* Start of Changes WWBUG: 1646442: added */
6847: --
6848: -- Work out if we are being called from a concurrent program
6849: -- otherwise we need to initialize the environment
6850: --
6851: ben_env_object.get(p_rec => l_env_rec);
6852: if fnd_global.conc_request_id in (0,-1) then
6853: --bug#3568529
6854: -- ben_env_object.get(p_rec => l_env_rec);
6855: if l_env_rec.benefit_action_id is null then
6850: --
6851: ben_env_object.get(p_rec => l_env_rec);
6852: if fnd_global.conc_request_id in (0,-1) then
6853: --bug#3568529
6854: -- ben_env_object.get(p_rec => l_env_rec);
6855: if l_env_rec.benefit_action_id is null then
6856: --
6857: hr_utility.set_location('Intialise env object',11);
6858: ben_env_object.init(p_business_group_id => p_business_group_id,
6854: -- ben_env_object.get(p_rec => l_env_rec);
6855: if l_env_rec.benefit_action_id is null then
6856: --
6857: hr_utility.set_location('Intialise env object',11);
6858: ben_env_object.init(p_business_group_id => p_business_group_id,
6859: p_effective_date => p_effective_date,
6860: p_thread_id => 1,
6861: p_chunk_size => 1,
6862: p_threads => 1,
6865: end if;
6866: --
6867: else
6868: -- to check whether it is called in benmngle selection mode
6869: ben_env_object.get(p_rec => l_env_rec);
6870: --
6871: -- If enrollment api's are called from concurrent manager for
6872: -- conversion or ivr kind of interfaces, call raises error.
6873: --
10337: --
10338: l_needs_dpnts c_needs_dpnts%rowtype;
10339: l_process_dpnt boolean := false;
10340: l_process_bnf boolean := false;
10341: l_env_rec ben_env_object.g_global_env_rec_type;
10342: --
10343: -- Bug 6656136
10344: cursor c_ler_typ_cd is
10345: --
10372: --
10373: if fnd_global.conc_request_id in (0,-1) then
10374: --
10375: --bug#3568529
10376: ben_env_object.get(p_rec => l_env_rec);
10377: if l_env_rec.benefit_action_id is null then
10378: --
10379: ben_env_object.init(p_business_group_id => p_business_group_id,
10380: p_effective_date => p_effective_date,
10375: --bug#3568529
10376: ben_env_object.get(p_rec => l_env_rec);
10377: if l_env_rec.benefit_action_id is null then
10378: --
10379: ben_env_object.init(p_business_group_id => p_business_group_id,
10380: p_effective_date => p_effective_date,
10381: p_thread_id => 1,
10382: p_chunk_size => 1,
10383: p_threads => 1,