eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PERSON_OBJECT

Line 1354: ben_person_object.get_object(p_person_id => p_person_id,

1350: --
1351: hr_utility.set_location('Int COunt'||l_inst_count,11);
1352: if l_inst_count > 0 then
1353: --
1354: ben_person_object.get_object(p_person_id => p_person_id,
1355: p_rec => l_ass_rec);
1356: --
1357: for l_count in l_inst_dets.first .. l_inst_dets.last loop
1358: --

Line 2000: ,p_person_type in ben_person_object.

1996: ,p_person_id in number
1997: ,p_business_group_id in number
1998: ,p_effective_date in date
1999: ,p_lf_evt_ocrd_dt in date
2000: ,p_person_type in ben_person_object.
2001: g_cache_typ_table) is
2002: --
2003: l_inst_set ben_rt_prfl_cache.g_pertyp_inst_tbl;
2004: l_inst_count number;

Line 4270: ben_person_object.get_object(p_person_id => p_person_id,

4266: ,p_inst_count => l_inst_count);
4267:
4268: --
4269: if l_inst_count > 0 then
4270: ben_person_object.get_object(p_person_id => p_person_id,
4271: p_rec => l_rec);
4272: --
4273: for l_num in l_inst_set.first .. l_inst_set.last loop
4274: --

Line 4324: ben_person_object.get_object(p_person_id => p_person_id,

4320: ,p_inst_count => l_inst_count);
4321:
4322: --
4323: if l_inst_count > 0 then
4324: ben_person_object.get_object(p_person_id => p_person_id,
4325: p_rec => l_rec);
4326: --
4327: for i in l_inst_set.first..l_inst_set.last loop
4328: --

Line 4417: ben_person_object.get_object(p_person_id => p_person_id,

4413: ,p_inst_count => l_inst_count);
4414:
4415: --
4416: if l_inst_count > 0 then
4417: ben_person_object.get_object(p_person_id => p_person_id,
4418: p_rec => l_rec);
4419: --
4420: for i in l_inst_set.first..l_inst_set.last loop
4421: --

Line 6132: ben_person_object.get_object(p_person_id => p_person_id,

6128: ,p_inst_count => l_inst_count);
6129:
6130: --
6131: if l_inst_count > 0 then
6132: ben_person_object.get_object(p_person_id => p_person_id,
6133: p_rec => l_rec);
6134: --
6135: for i in l_inst_set.first..l_inst_set.last loop
6136: --

Line 7203: l_typ_rec ben_person_object.g_cache_typ_table;

7199: l_all_ctr number := 0;
7200: l_ttl_cvg number;
7201: l_ttl_prtt number;
7202: l_loop_count number;
7203: l_typ_rec ben_person_object.g_cache_typ_table;
7204: l_ast_rec per_assignment_status_types%rowtype;
7205: l_appass_rec ben_person_object.g_cache_ass_table;
7206: --
7207: l_effective_date date;

Line 7205: l_appass_rec ben_person_object.g_cache_ass_table;

7201: l_ttl_prtt number;
7202: l_loop_count number;
7203: l_typ_rec ben_person_object.g_cache_typ_table;
7204: l_ast_rec per_assignment_status_types%rowtype;
7205: l_appass_rec ben_person_object.g_cache_ass_table;
7206: --
7207: l_effective_date date;
7208: l_eligible boolean;
7209: -- FONM

Line 7321: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache

7317: end if;
7318:
7319: if p_per_row.person_id is null then
7320: --
7321: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7322: (p_person_id => p_person_id
7323: ,p_rec => l_per_rec
7324: );
7325: --

Line 7342: ben_person_object.get_object(p_person_id => p_person_id,

7338: hr_utility.set_location('cache end ' || l_per_rec.effective_end_date ,10);
7339:
7340: ben_use_cvg_rt_date.fonm_clear_down_cache;
7341: --
7342: ben_person_object.get_object(p_person_id => p_person_id,
7343: p_rec => l_per_rec);
7344:
7345: hr_utility.set_location('nw cache start ' || l_per_rec.effective_start_date ,10);
7346: hr_utility.set_location('nw cache end ' || l_per_rec.effective_end_date ,10);

Line 7353: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache

7349:
7350:
7351: if p_asg_row.assignment_id is null then
7352: --
7353: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7354: (p_person_id => p_person_id
7355: ,p_rec => l_asg_rec );
7356: --
7357: else

Line 7369: ben_person_object.get_benass_object -- FONM : 9999 do we need to rebuild the cache

7365: --
7366:
7367: if l_asg_rec.assignment_id is null then
7368: --
7369: ben_person_object.get_benass_object -- FONM : 9999 do we need to rebuild the cache
7370: (p_person_id => p_person_id
7371: ,p_rec => l_asg_rec );
7372: --
7373: -- If benefit assignment not found, get applicant assignment.

Line 7377: ben_person_object.get_object(p_person_id => p_person_id, -- FONM : 9999 do we need to rebuild the cache

7373: -- If benefit assignment not found, get applicant assignment.
7374: --
7375: if l_asg_rec.assignment_id is null then
7376: --
7377: ben_person_object.get_object(p_person_id => p_person_id, -- FONM : 9999 do we need to rebuild the cache
7378: p_rec => l_appass_rec );
7379: --
7380: else
7381: --

Line 7382: ben_person_object.get_object

7378: p_rec => l_appass_rec );
7379: --
7380: else
7381: --
7382: ben_person_object.get_object
7383: (p_assignment_status_type_id => l_asg_rec.assignment_status_type_id -- FONM : 9999 do we need to rebuild the cache
7384: ,p_rec => l_ast_rec );
7385: --
7386: end if;

Line 7392: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache

7388: else
7389: --
7390: if p_ast_row.assignment_status_type_id is null then
7391: --
7392: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7393: (p_assignment_status_type_id => l_asg_rec.assignment_status_type_id
7394: ,p_rec => l_ast_rec
7395: );
7396: --

Line 7409: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache

7405: -- Check if the address row is passed in
7406: --
7407: if p_adr_row.address_id is null then
7408: --
7409: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7410: (p_person_id => p_person_id
7411: ,p_rec => l_adr_rec
7412: );
7413: --

Line 7590: ben_person_object.get_object(p_person_id => p_person_id, -- FONM 9999

7586: end if;
7587: --
7588: end if;
7589: --
7590: ben_person_object.get_object(p_person_id => p_person_id, -- FONM 9999
7591: p_rec => l_typ_rec);
7592: --
7593: hr_utility.set_location('l_profile.vrbl_rt_prfl_id -> '||l_profile.vrbl_rt_prfl_id,11);
7594: hr_utility.set_location('l_profile.rt_per_typ_flag -> '||l_profile.rt_per_typ_flag,11);

Line 7657: ben_person_object.get_object(p_person_id => p_person_id,

7653: --
7654: -- Employee assignment only
7655: --
7656: l_asg_rec := NULL; --Bug 6399423
7657: ben_person_object.get_object(p_person_id => p_person_id,
7658: p_rec => l_asg_rec);
7659: --
7660: elsif l_profile.asmt_to_use_cd = 'BAO' then
7661: --

Line 7665: ben_person_object.get_benass_object(p_person_id => p_person_id,

7661: --
7662: -- Benefit assignment only
7663: --
7664: l_asg_rec := NULL; --Bug 6399423
7665: ben_person_object.get_benass_object(p_person_id => p_person_id,
7666: p_rec => l_asg_rec);
7667: --
7668: elsif l_profile.asmt_to_use_cd = 'ANY' then
7669: --

Line 7672: ben_person_object.get_allass_object(p_person_id => p_person_id,

7668: elsif l_profile.asmt_to_use_cd = 'ANY' then
7669: --
7670: -- First assignment only
7671: --
7672: ben_person_object.get_allass_object(p_person_id => p_person_id,
7673: p_rec => l_appass_rec);
7674: --
7675: if not l_appass_rec.exists(1) then
7676: --

Line 7690: ben_person_object.get_object(p_person_id => p_person_id,

7686: elsif l_profile.asmt_to_use_cd = 'AAO' then
7687: --
7688: -- Applicant assignment only
7689: --
7690: ben_person_object.get_object(p_person_id => p_person_id,
7691: p_rec => l_appass_rec);
7692: --
7693: if not l_appass_rec.exists(1) then
7694: --

Line 7708: ben_person_object.get_object(p_person_id => p_person_id,

7704: elsif l_profile.asmt_to_use_cd = 'ETB' then
7705: --
7706: -- Employee then Benefits assignment only
7707: --
7708: ben_person_object.get_object(p_person_id => p_person_id,
7709: p_rec => l_asg_rec);
7710: --
7711: if l_asg_rec.assignment_id is null then
7712: --

Line 7715: ben_person_object.get_benass_object(p_person_id => p_person_id,

7711: if l_asg_rec.assignment_id is null then
7712: --
7713: -- Get Benefits Assignment
7714: --
7715: ben_person_object.get_benass_object(p_person_id => p_person_id,
7716: p_rec => l_asg_rec);
7717: --
7718: end if;
7719: --

Line 7724: ben_person_object.get_benass_object(p_person_id => p_person_id,

7720: elsif l_profile.asmt_to_use_cd = 'BTE' then
7721: --
7722: -- Benefits then Employee assignment only
7723: --
7724: ben_person_object.get_benass_object(p_person_id => p_person_id,
7725: p_rec => l_asg_rec);
7726: --
7727: if l_asg_rec.assignment_id is null then
7728: --

Line 7731: ben_person_object.get_object(p_person_id => p_person_id,

7727: if l_asg_rec.assignment_id is null then
7728: --
7729: -- Get Employee Assignment
7730: --
7731: ben_person_object.get_object(p_person_id => p_person_id,
7732: p_rec => l_asg_rec);
7733: --
7734: end if;
7735: --

Line 7740: ben_person_object.get_object(p_person_id => p_person_id,

7736: elsif l_profile.asmt_to_use_cd = 'EBA' then
7737: --
7738: -- Employee then Benefits then Applicant assignment only
7739: --
7740: ben_person_object.get_object(p_person_id => p_person_id,
7741: p_rec => l_asg_rec);
7742: --
7743: if l_asg_rec.assignment_id is null then
7744: --

Line 7747: ben_person_object.get_benass_object(p_person_id => p_person_id,

7743: if l_asg_rec.assignment_id is null then
7744: --
7745: -- Get Benefits Assignment
7746: --
7747: ben_person_object.get_benass_object(p_person_id => p_person_id,
7748: p_rec => l_asg_rec);
7749: --
7750: if l_asg_rec.assignment_id is null then
7751: --

Line 7754: ben_person_object.get_object(p_person_id => p_person_id,

7750: if l_asg_rec.assignment_id is null then
7751: --
7752: -- Applicant assignment only
7753: --
7754: ben_person_object.get_object(p_person_id => p_person_id,
7755: p_rec => l_appass_rec);
7756: --
7757: if not l_appass_rec.exists(1) then
7758: --