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_ELIG_PROFILES dependencies on BEN_PERSON_OBJECT

Line 2546: p_per_per_typ in ben_person_object.

2542: p_business_group_id in number,
2543: p_score_compute_mode in boolean default false,
2544: p_profile_score_tab in out nocopy scoreTab,
2545: p_effective_date in date,
2546: p_per_per_typ in ben_person_object.
2547: g_cache_typ_table) is
2548: --
2549: l_proc varchar2(100) := g_package||'check_per_typ_elig';
2550: --

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

3843: --
3844: hr_utility.set_location('Entering : '||l_proc,10);
3845: --
3846: if p_postal_code is null then
3847: ben_person_object.get_object(p_person_id => p_person_id,
3848: p_rec => l_pad_rec);
3849: else
3850: l_pad_rec.postal_code := p_postal_code;
3851: end if;

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

3988: -- Getting eligibility profile zip code range by eligibility profile
3989: --
3990: --
3991: if p_postal_code is null then
3992: ben_person_object.get_object(p_person_id => p_person_id,
3993: p_rec => l_pad_rec);
3994: else
3995: l_pad_rec.postal_code := p_postal_code;
3996: end if;

Line 4951: ben_person_object.get_object(p_assignment_id => p_assignment_id,

4947: else
4948: --
4949: /* Start of Changes for WWBUG: 2141209 */
4950: if p_assignment_id is not null then
4951: ben_person_object.get_object(p_assignment_id => p_assignment_id,
4952: p_rec => l_aei_rec);
4953: --
4954: l_ok1 := nvl((nvl(l_aei_rec.aei_information11,'-1') =
4955: l_inst_dets(l_insttorrw_num).absence_attendance_type_id),FALSE);

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

5556: ,p_inst_count => l_inst_count);
5557: --
5558: if l_inst_count > 0 then
5559: --
5560: ben_person_object.get_object(p_person_id => p_person_id,
5561: p_rec => l_ass_rec);
5562: --
5563: for l_count in l_inst_dets.first .. l_inst_dets.last loop
5564: --

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

5885: -- =========
5886: -- 1) Grab all profiles for this eligibility profile id
5887: -- 2) Check that the flag corresponds to the person record. If not error.
5888: --
5889: ben_person_object.get_object(p_person_id => p_person_id,
5890: p_rec => l_rec);
5891: --
5892: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
5893: --

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

5960: -- 2) If the leaving reason code is excluded then person is not eligible
5961: -- 3) If the leaving reason code is not excluded then person is eligible.
5962: --
5963: if p_leaving_reason is null then
5964: ben_person_object.get_object(p_person_id => p_person_id,
5965: p_rec => l_rec);
5966: else
5967: l_rec.leaving_reason := p_leaving_reason;
5968: end if;

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

6077: -- 1) Grab all profiles for this eligibility profile id
6078: -- 2) If the leaving reason code is excluded then person is not eligible
6079: -- 3) If the leaving reason code is not excluded then person is eligible.
6080: --
6081: ben_person_object.get_object(p_person_id => p_person_id,
6082: p_rec => l_rec);
6083: --
6084: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
6085: --

Line 8916: l_typ_rec ben_person_object.g_cache_typ_table;

8912: l_pil_row ben_per_in_ler%rowtype;
8913: --
8914: l_cagrelig_cnt pls_integer;
8915: l_pl_typ_id number;
8916: l_typ_rec ben_person_object.g_cache_typ_table;
8917: l_appass_rec ben_person_object.g_cache_ass_table;
8918: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
8919: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
8920: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;

Line 8917: l_appass_rec ben_person_object.g_cache_ass_table;

8913: --
8914: l_cagrelig_cnt pls_integer;
8915: l_pl_typ_id number;
8916: l_typ_rec ben_person_object.g_cache_typ_table;
8917: l_appass_rec ben_person_object.g_cache_ass_table;
8918: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
8919: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
8920: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
8921: --

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

9389: --
9390: if l_eligprof_dets.count > 0 then
9391: --
9392: if p_person_id is not null then
9393: ben_person_object.get_object(p_person_id => p_person_id,
9394: p_rec => l_typ_rec);
9395: --
9396: ben_person_object.get_object(p_person_id => p_person_id,
9397: p_rec => l_per_rec);

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

9392: if p_person_id is not null then
9393: ben_person_object.get_object(p_person_id => p_person_id,
9394: p_rec => l_typ_rec);
9395: --
9396: ben_person_object.get_object(p_person_id => p_person_id,
9397: p_rec => l_per_rec);
9398: --
9399: -- if the person cache is not in the date range, clear the cahce
9400: --

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

9406: hr_utility.set_location('cache end'||l_per_rec.effective_end_date ,10);
9407:
9408: ben_use_cvg_rt_date.fonm_clear_down_cache;
9409: --
9410: ben_person_object.get_object(p_person_id => p_person_id,
9411: p_rec => l_typ_rec);
9412: --
9413: ben_person_object.get_object(p_person_id => p_person_id,
9414: p_rec => l_per_rec);

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

9409: --
9410: ben_person_object.get_object(p_person_id => p_person_id,
9411: p_rec => l_typ_rec);
9412: --
9413: ben_person_object.get_object(p_person_id => p_person_id,
9414: p_rec => l_per_rec);
9415:
9416: hr_utility.set_location('nw cache start'||l_per_rec.effective_start_date ,10);
9417: hr_utility.set_location('nw cache end'||l_per_rec.effective_end_date ,10);

Line 9421: /* ben_person_object.get_object(p_person_id => p_person_id,

9417: hr_utility.set_location('nw cache end'||l_per_rec.effective_end_date ,10);
9418: else
9419:
9420: -- Bug 6399423
9421: /* ben_person_object.get_object(p_person_id => p_person_id,
9422: p_rec => l_ass_rec);
9423: */
9424:
9425: ben_person_object.get_object(p_person_id => p_person_id,

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

9421: /* ben_person_object.get_object(p_person_id => p_person_id,
9422: p_rec => l_ass_rec);
9423: */
9424:
9425: ben_person_object.get_object(p_person_id => p_person_id,
9426: p_rec => l_ass_rec1);
9427: -- Bug 6399423
9428:
9429: hr_utility.set_location('cache asg start'||l_ass_rec1.effective_start_date ,10);

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

9503: if l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd = 'EAO' then
9504: --
9505: -- Employee assignment only
9506: --
9507: ben_person_object.get_object(p_person_id => p_person_id,
9508: p_rec => l_ass_rec);
9509: --
9510: elsif l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd = 'BAO' then
9511: --

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

9510: elsif l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd = 'BAO' then
9511: --
9512: -- Benefit assignment only
9513: --
9514: ben_person_object.get_benass_object(p_person_id => p_person_id,
9515: p_rec => l_ass_rec);
9516: --
9517: elsif l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd = 'AAO' then
9518: --

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

9528: l_appass_rec.delete;
9529: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9530: else
9531: --
9532: ben_person_object.get_object(p_person_id => p_person_id,
9533: p_rec => l_appass_rec);
9534: --
9535: end if;
9536: --

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

9571: hr_utility.set_location(' p_effective_date :' || p_effective_date,99);
9572:
9573:
9574: else
9575: ben_person_object.get_allass_object(p_person_id => p_person_id,
9576: p_rec => l_appass_rec);
9577: end if; -- 4958846 :irec
9578: --
9579: if not l_appass_rec.exists(1) then

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

9594: elsif l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd = 'ETB' then
9595: --
9596: -- Employee then Benefits assignment only
9597: --
9598: ben_person_object.get_object(p_person_id => p_person_id,
9599: p_rec => l_ass_rec);
9600: --
9601: if l_ass_rec.assignment_id is null then
9602: --

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

9601: if l_ass_rec.assignment_id is null then
9602: --
9603: -- Get Benefits Assignment
9604: --
9605: ben_person_object.get_benass_object(p_person_id => p_person_id,
9606: p_rec => l_ass_rec);
9607: --
9608: end if;
9609: --

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

9610: elsif l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd = 'BTE' then
9611: --
9612: -- Benefits then Employee assignment only
9613: --
9614: ben_person_object.get_benass_object(p_person_id => p_person_id,
9615: p_rec => l_ass_rec);
9616: --
9617: if l_ass_rec.assignment_id is null then
9618: --

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

9617: if l_ass_rec.assignment_id is null then
9618: --
9619: -- Get Employee Assignment
9620: --
9621: ben_person_object.get_object(p_person_id => p_person_id,
9622: p_rec => l_ass_rec);
9623: --
9624: end if;
9625: --

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

9626: elsif l_eligprof_dets(l_elptorrw_num).asmt_to_use_cd = 'EBA' then
9627: --
9628: -- Employee then Benefits then Applicant assignment only
9629: --
9630: ben_person_object.get_object(p_person_id => p_person_id,
9631: p_rec => l_ass_rec);
9632: --
9633: if l_ass_rec.assignment_id is null then
9634: --

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

9633: if l_ass_rec.assignment_id is null then
9634: --
9635: -- Get Benefits Assignment
9636: --
9637: ben_person_object.get_benass_object(p_person_id => p_person_id,
9638: p_rec => l_ass_rec);
9639: --
9640: if l_ass_rec.assignment_id is null then
9641: --

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

9651: l_appass_rec.delete;
9652: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9653: else
9654: --
9655: ben_person_object.get_object(p_person_id => p_person_id,
9656: p_rec => l_appass_rec);
9657: --
9658: end if;
9659: --

Line 9970: ben_person_object.get_object

9966: --
9967: hr_utility.set_location(' here 2 ',999);
9968: if l_ass_rec.soft_coding_keyflex_id is not null then
9969: --
9970: ben_person_object.get_object
9971: (p_soft_coding_keyflex_id => l_ass_rec.soft_coding_keyflex_id,
9972: p_rec => l_hsc_rec);
9973: --
9974: if l_hsc_rec.segment1 is not null and