DBA Data[Home] [Help]

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 4323: ben_person_object.get_object(p_person_id => p_person_id,

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

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

4373: ,p_inst_count => l_inst_count);
4374:
4375: --
4376: if l_inst_count > 0 then
4377: ben_person_object.get_object(p_person_id => p_person_id,
4378: p_rec => l_rec);
4379: --
4380: for i in l_inst_set.first..l_inst_set.last loop
4381: --

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

4466: ,p_inst_count => l_inst_count);
4467:
4468: --
4469: if l_inst_count > 0 then
4470: ben_person_object.get_object(p_person_id => p_person_id,
4471: p_rec => l_rec);
4472: --
4473: for i in l_inst_set.first..l_inst_set.last loop
4474: --

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

6185: ,p_inst_count => l_inst_count);
6186:
6187: --
6188: if l_inst_count > 0 then
6189: ben_person_object.get_object(p_person_id => p_person_id,
6190: p_rec => l_rec);
6191: --
6192: for i in l_inst_set.first..l_inst_set.last loop
6193: --

Line 7260: l_typ_rec ben_person_object.g_cache_typ_table;

7256: l_all_ctr number := 0;
7257: l_ttl_cvg number;
7258: l_ttl_prtt number;
7259: l_loop_count number;
7260: l_typ_rec ben_person_object.g_cache_typ_table;
7261: l_ast_rec per_assignment_status_types%rowtype;
7262: l_appass_rec ben_person_object.g_cache_ass_table;
7263: --
7264: l_effective_date date;

Line 7262: l_appass_rec ben_person_object.g_cache_ass_table;

7258: l_ttl_prtt number;
7259: l_loop_count number;
7260: l_typ_rec ben_person_object.g_cache_typ_table;
7261: l_ast_rec per_assignment_status_types%rowtype;
7262: l_appass_rec ben_person_object.g_cache_ass_table;
7263: --
7264: l_effective_date date;
7265: l_eligible boolean;
7266: -- FONM

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

7374: end if;
7375:
7376: if p_per_row.person_id is null then
7377: --
7378: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7379: (p_person_id => p_person_id
7380: ,p_rec => l_per_rec
7381: );
7382: --

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

7395: hr_utility.set_location('cache end ' || l_per_rec.effective_end_date ,10);
7396:
7397: ben_use_cvg_rt_date.fonm_clear_down_cache;
7398: --
7399: ben_person_object.get_object(p_person_id => p_person_id,
7400: p_rec => l_per_rec);
7401:
7402: hr_utility.set_location('nw cache start ' || l_per_rec.effective_start_date ,10);
7403: hr_utility.set_location('nw cache end ' || l_per_rec.effective_end_date ,10);

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

7406:
7407:
7408: if p_asg_row.assignment_id is null then
7409: --
7410: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7411: (p_person_id => p_person_id
7412: ,p_rec => l_asg_rec );
7413: --
7414: else

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

7422: --
7423:
7424: if l_asg_rec.assignment_id is null then
7425: --
7426: ben_person_object.get_benass_object -- FONM : 9999 do we need to rebuild the cache
7427: (p_person_id => p_person_id
7428: ,p_rec => l_asg_rec );
7429: --
7430: -- If benefit assignment not found, get applicant assignment.

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

7430: -- If benefit assignment not found, get applicant assignment.
7431: --
7432: if l_asg_rec.assignment_id is null then
7433: --
7434: ben_person_object.get_object(p_person_id => p_person_id, -- FONM : 9999 do we need to rebuild the cache
7435: p_rec => l_appass_rec );
7436: --
7437: else
7438: --

Line 7439: ben_person_object.get_object

7435: p_rec => l_appass_rec );
7436: --
7437: else
7438: --
7439: ben_person_object.get_object
7440: (p_assignment_status_type_id => l_asg_rec.assignment_status_type_id -- FONM : 9999 do we need to rebuild the cache
7441: ,p_rec => l_ast_rec );
7442: --
7443: end if;

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

7445: else
7446: --
7447: if p_ast_row.assignment_status_type_id is null then
7448: --
7449: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7450: (p_assignment_status_type_id => l_asg_rec.assignment_status_type_id
7451: ,p_rec => l_ast_rec
7452: );
7453: --

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

7462: -- Check if the address row is passed in
7463: --
7464: if p_adr_row.address_id is null then
7465: --
7466: ben_person_object.get_object -- FONM : 9999 do we need to rebuild the cache
7467: (p_person_id => p_person_id
7468: ,p_rec => l_adr_rec
7469: );
7470: --

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

7647: end if;
7648: --
7649: end if;
7650: --
7651: ben_person_object.get_object(p_person_id => p_person_id, -- FONM 9999
7652: p_rec => l_typ_rec);
7653: --
7654: hr_utility.set_location('l_profile.vrbl_rt_prfl_id -> '||l_profile.vrbl_rt_prfl_id,11);
7655: hr_utility.set_location('l_profile.rt_per_typ_flag -> '||l_profile.rt_per_typ_flag,11);

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

7714: --
7715: -- Employee assignment only
7716: --
7717: l_asg_rec := NULL; --Bug 6399423
7718: ben_person_object.get_object(p_person_id => p_person_id,
7719: p_rec => l_asg_rec);
7720: --
7721: elsif l_profile.asmt_to_use_cd = 'BAO' then
7722: --

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

7722: --
7723: -- Benefit assignment only
7724: --
7725: l_asg_rec := NULL; --Bug 6399423
7726: ben_person_object.get_benass_object(p_person_id => p_person_id,
7727: p_rec => l_asg_rec);
7728: --
7729: elsif l_profile.asmt_to_use_cd = 'ANY' then
7730: --

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

7729: elsif l_profile.asmt_to_use_cd = 'ANY' then
7730: --
7731: -- First assignment only
7732: --
7733: ben_person_object.get_allass_object(p_person_id => p_person_id,
7734: p_rec => l_appass_rec);
7735: --
7736: if not l_appass_rec.exists(1) then
7737: --

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

7747: elsif l_profile.asmt_to_use_cd = 'AAO' then
7748: --
7749: -- Applicant assignment only
7750: --
7751: ben_person_object.get_object(p_person_id => p_person_id,
7752: p_rec => l_appass_rec);
7753: --
7754: if not l_appass_rec.exists(1) then
7755: --

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

7765: elsif l_profile.asmt_to_use_cd = 'ETB' then
7766: --
7767: -- Employee then Benefits assignment only
7768: --
7769: ben_person_object.get_object(p_person_id => p_person_id,
7770: p_rec => l_asg_rec);
7771: --
7772: if l_asg_rec.assignment_id is null then
7773: --

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

7772: if l_asg_rec.assignment_id is null then
7773: --
7774: -- Get Benefits Assignment
7775: --
7776: ben_person_object.get_benass_object(p_person_id => p_person_id,
7777: p_rec => l_asg_rec);
7778: --
7779: end if;
7780: --

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

7781: elsif l_profile.asmt_to_use_cd = 'BTE' then
7782: --
7783: -- Benefits then Employee assignment only
7784: --
7785: ben_person_object.get_benass_object(p_person_id => p_person_id,
7786: p_rec => l_asg_rec);
7787: --
7788: if l_asg_rec.assignment_id is null then
7789: --

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

7788: if l_asg_rec.assignment_id is null then
7789: --
7790: -- Get Employee Assignment
7791: --
7792: ben_person_object.get_object(p_person_id => p_person_id,
7793: p_rec => l_asg_rec);
7794: --
7795: end if;
7796: --

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

7797: elsif l_profile.asmt_to_use_cd = 'EBA' then
7798: --
7799: -- Employee then Benefits then Applicant assignment only
7800: --
7801: ben_person_object.get_object(p_person_id => p_person_id,
7802: p_rec => l_asg_rec);
7803: --
7804: if l_asg_rec.assignment_id is null then
7805: --

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

7804: if l_asg_rec.assignment_id is null then
7805: --
7806: -- Get Benefits Assignment
7807: --
7808: ben_person_object.get_benass_object(p_person_id => p_person_id,
7809: p_rec => l_asg_rec);
7810: --
7811: if l_asg_rec.assignment_id is null then
7812: --

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

7811: if l_asg_rec.assignment_id is null then
7812: --
7813: -- Applicant assignment only
7814: --
7815: ben_person_object.get_object(p_person_id => p_person_id,
7816: p_rec => l_appass_rec);
7817: --
7818: if not l_appass_rec.exists(1) then
7819: --