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_ON_LINE_LF_EVT dependencies on BENUTILS

Line 509: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;

505: --
506: cursor c_ler is
507: select ler_id
508: from ben_person_actions
509: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
510: --
511: cursor c_ptnl_ler is
512: select count(*)
513: from ben_ptnl_ler_for_per ptn

Line 660: (p_benefit_action_id => benutils.g_benefit_action_id,

656: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),
657: p_lf_evt_ocrd_dt => l_effective_date );
658: --
659: ben_comp_object_list.build_comp_object_list
660: (p_benefit_action_id => benutils.g_benefit_action_id,
661: p_comp_selection_rule_id => null,
662: p_effective_date => l_effective_date,
663: p_pgm_id => null,
664: p_business_group_id => l_business_group_id,

Line 735: l_benefit_action_id := to_char(benutils.g_benefit_action_id);

731: --
732: end loop;
733: --
734: -- Now is the time to rollback;
735: l_benefit_action_id := to_char(benutils.g_benefit_action_id);
736: rollback to process_lf_evts;
737: --
738: /* ben_manage_life_events.process_comp_objects
739: (p_person_id => l_person_id,

Line 845: -- avalue => to_char(benutils.g_benefit_action_id));

841: itemtype => itemtype,
842: itemkey => itemkey,
843: aname => 'BEN_IA_BENEFIT_ACTION_ID',
844: avalue => l_benefit_action_id);
845: -- avalue => to_char(benutils.g_benefit_action_id));
846: --
847: -- Successfully completed.
848: --
849: resultout := 'COMPLETE:COMPLETE';

Line 992: avalue => to_char(benutils.g_benefit_action_id));

988: wf_engine.SetItemAttrTEXT(
989: itemtype => itemtype,
990: itemkey => itemkey,
991: aname => 'BEN_IA_BENEFIT_ACTION_ID',
992: avalue => to_char(benutils.g_benefit_action_id));
993: --
994: -- Successfully completed.
995: resultout := 'COMPLETE:COMPLETE';
996: return;

Line 1310: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;

1306: --
1307: cursor c_ler is
1308: select ler_id
1309: from ben_person_actions
1310: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1311: --
1312: begin
1313: --
1314: /* ben_manage_life_events.process

Line 1348: (p_benefit_action_id => benutils.g_benefit_action_id,

1344: p_payroll_id => null,
1345: p_commit_data => 'N' ); */
1346: --
1347: /* ben_comp_object_list.build_comp_object_list
1348: (p_benefit_action_id => benutils.g_benefit_action_id,
1349: p_comp_selection_rule_id => null,
1350: p_effective_date => p_effective_date,
1351: p_pgm_id => null,
1352: p_business_group_id => p_business_group_id,

Line 1440: l_rec benutils.g_active_life_event;

1436: l_lf_evt_ocrd_dt varchar2(30);
1437: l_chunk_size number := 0;
1438: l_threads number := 0;
1439: l_max_errors_allowed number ;
1440: l_rec benutils.g_active_life_event;
1441: --
1442: cursor c_ler is
1443: select ler_id
1444: from ben_person_actions

Line 1445: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;

1441: --
1442: cursor c_ler is
1443: select ler_id
1444: from ben_person_actions
1445: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1446: --
1447: l_bft_id number;
1448: l_assignment_id number;
1449: l_encoded_message varchar2(2000);

Line 1495: benutils.get_assignment_id(p_person_id=> p_person_id

1491: --
1492: if p_mode in ('L', 'C','U') then
1493: l_assignment_id := null;
1494: l_assignment_id :=
1495: benutils.get_assignment_id(p_person_id=> p_person_id
1496: ,p_business_group_id => p_business_group_id
1497: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date));
1498: --
1499: if l_assignment_id is null

Line 1549: benutils.get_parameter

1545: --
1546: hr_utility.set_location('After process',10);
1547: hr_utility.set_location('Before get_parameter',21);
1548: --
1549: benutils.get_parameter
1550: (p_business_group_id => p_business_group_id,
1551: p_batch_exe_cd => 'BENMNGLE',
1552: p_threads => l_threads,
1553: p_chunk_size => l_chunk_size,

Line 1567: ,p_benefit_action_id => benutils.g_benefit_action_id

1563: ,p_effective_date => p_effective_date
1564: ,p_threads => l_threads
1565: ,p_chunk_size => l_chunk_size
1566: ,p_max_errors => l_max_errors_allowed
1567: ,p_benefit_action_id => benutils.g_benefit_action_id
1568: ,p_thread_id => 1
1569: );
1570: hr_utility.set_location('After clear_init_benmngle_caches',24);
1571: hr_utility.set_location('Before Build Comp Object List',30);

Line 1576: (p_benefit_action_id => benutils.g_benefit_action_id,

1572: --
1573: if (p_mode = 'U')
1574: then
1575: ben_comp_object_list.build_comp_object_list
1576: (p_benefit_action_id => benutils.g_benefit_action_id,
1577: p_comp_selection_rule_id => null,
1578: p_effective_date => p_effective_date,
1579: p_pgm_id => p_pgm_id,
1580: p_business_group_id => p_business_group_id,

Line 1629: g_benefit_action_id := benutils.g_benefit_action_id;

1625: hr_utility.set_location('After evaluate life events',50);
1626: --
1627: -- save the benefit action id to be used by process_comp_objects.
1628: --
1629: g_benefit_action_id := benutils.g_benefit_action_id;
1630: --
1631: -- To synchronize with process_life_events procedure
1632: -- ben_manage_life_events.person_header is moved here.
1633: --

Line 1638: benutils.get_active_life_event

1634: hr_utility.set_location('Before Person Header',51);
1635: --
1636: if p_mode = 'W' then
1637: -- GLOBAL CWB : Call diferent procedures for different modes.
1638: benutils.get_active_life_event
1639: (p_person_id => p_person_id,
1640: p_business_group_id => p_business_group_id,
1641: p_effective_date => p_effective_date,
1642: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 1649: benutils.get_active_life_event

1645: --
1646: -- GSP : Call diferent procedures for different modes.
1647: elsif p_mode = 'G' then
1648: --
1649: benutils.get_active_life_event
1650: (p_person_id => p_person_id,
1651: p_business_group_id => p_business_group_id,
1652: p_effective_date => p_effective_date,
1653: p_lf_event_mode => 'G',

Line 1658: benutils.get_active_life_event

1654: p_rec => l_rec);
1655: --
1656: elsif p_mode = 'U' then
1657: --
1658: benutils.get_active_life_event
1659: (p_person_id => p_person_id,
1660: p_business_group_id => p_business_group_id,
1661: p_effective_date => p_effective_date,
1662: p_lf_event_mode => 'U',

Line 1666: benutils.get_active_life_event

1662: p_lf_event_mode => 'U',
1663: p_rec => l_rec);
1664: elsif p_mode = 'M' then
1665: --
1666: benutils.get_active_life_event
1667: (p_person_id => p_person_id,
1668: p_business_group_id => p_business_group_id,
1669: p_effective_date => p_effective_date,
1670: p_lf_event_mode => 'M',

Line 1675: benutils.get_active_life_event

1671: p_rec => l_rec);
1672: --
1673: else
1674: --
1675: benutils.get_active_life_event
1676: (p_person_id => p_person_id,
1677: p_business_group_id => p_business_group_id,
1678: p_effective_date => p_effective_date,
1679: p_rec => l_rec);

Line 1879: l_rec benutils.g_active_life_event;

1875: l_lf_evt_ocrd_dt varchar2(30);
1876: l_chunk_size number := 0;
1877: l_threads number := 0;
1878: l_max_errors_allowed number;
1879: l_rec benutils.g_active_life_event;
1880: l_assignment_id number;
1881: --
1882: l_bft_id number;
1883: --

Line 1887: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;

1883: --
1884: cursor c_ler is
1885: select ler_id
1886: from ben_person_actions
1887: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1888: --
1889: begin
1890: --
1891: hr_utility.set_location(l_package || ' Before Process',5);

Line 1914: benutils.get_assignment_id(p_person_id=> p_person_id

1910: --
1911: if p_mode in ('L', 'C','U') then
1912: l_assignment_id := null;
1913: l_assignment_id :=
1914: benutils.get_assignment_id(p_person_id=> p_person_id
1915: ,p_business_group_id => p_business_group_id
1916: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date));
1917: --
1918: if l_assignment_id is null

Line 1964: benutils.get_parameter

1960: hr_utility.set_location(l_package ||' After process',10);
1961: --
1962: hr_utility.set_location('Before get_parameter',21);
1963: --
1964: benutils.get_parameter
1965: (p_business_group_id => p_business_group_id,
1966: p_batch_exe_cd => 'BENMNGLE',
1967: p_threads => l_threads,
1968: p_chunk_size => l_chunk_size,

Line 1983: ,p_benefit_action_id => benutils.g_benefit_action_id

1979: ,p_effective_date => p_effective_date
1980: ,p_threads => l_threads
1981: ,p_chunk_size => l_chunk_size
1982: ,p_max_errors => l_max_errors_allowed
1983: ,p_benefit_action_id => benutils.g_benefit_action_id
1984: ,p_thread_id => 1
1985: );
1986: --
1987: hr_utility.set_location('After ben_manage_life_events.clear_init_benmngle_caches',24);

Line 2024: g_benefit_action_id := benutils.g_benefit_action_id;

2020: hr_utility.set_location('After evaluate life events',50);
2021: --
2022: -- save the benefit action id to be used by process_comp_objects.
2023: --
2024: g_benefit_action_id := benutils.g_benefit_action_id;
2025: --
2026: -- To synchronize with process_life_events procedure
2027: -- ben_manage_life_events.person_header is moved here.
2028: --

Line 2034: benutils.get_active_life_event

2030: --
2031: -- GSP : Call diferent procedures for different modes.
2032: if p_mode = 'G' then
2033: --
2034: benutils.get_active_life_event
2035: (p_person_id => p_person_id,
2036: p_business_group_id => p_business_group_id,
2037: p_effective_date => p_effective_date,
2038: p_lf_event_mode => 'G',

Line 2043: benutils.get_active_life_event

2039: p_rec => l_rec);
2040: --
2041: elsif p_mode = 'U' then
2042: --
2043: benutils.get_active_life_event
2044: (p_person_id => p_person_id,
2045: p_business_group_id => p_business_group_id,
2046: p_effective_date => p_effective_date,
2047: p_lf_event_mode => 'U',

Line 2051: benutils.get_active_life_event

2047: p_lf_event_mode => 'U',
2048: p_rec => l_rec);
2049: elsif p_mode = 'M' then
2050: --
2051: benutils.get_active_life_event
2052: (p_person_id => p_person_id,
2053: p_business_group_id => p_business_group_id,
2054: p_effective_date => p_effective_date,
2055: p_lf_event_mode => 'M',

Line 2060: benutils.get_active_life_event

2056: p_rec => l_rec);
2057: --
2058: else
2059: --
2060: benutils.get_active_life_event
2061: (p_person_id => p_person_id,
2062: p_business_group_id => p_business_group_id,
2063: p_effective_date => p_effective_date,
2064: p_rec => l_rec);

Line 2145: p_benefit_action_id := benutils.g_benefit_action_id;

2141: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2142: -- p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id,
2143: p_effective_date => p_effective_date
2144: );
2145: p_benefit_action_id := benutils.g_benefit_action_id;
2146: --
2147: -- Write results to log
2148: --
2149: benutils.WRITE_TABLE_AND_FILE(P_TABLE => TRUE, P_FILE => FALSE);

Line 2149: benutils.WRITE_TABLE_AND_FILE(P_TABLE => TRUE, P_FILE => FALSE);

2145: p_benefit_action_id := benutils.g_benefit_action_id;
2146: --
2147: -- Write results to log
2148: --
2149: benutils.WRITE_TABLE_AND_FILE(P_TABLE => TRUE, P_FILE => FALSE);
2150: --
2151: ben_cobj_cache.clear_down_cache;
2152: hr_utility.set_location('After process comp objects',60);
2153: --

Line 2198: l_rec benutils.g_active_life_event;

2194: l_chunk_size number := 0;
2195: l_threads number := 0;
2196: l_max_errors_allowed number;
2197: --
2198: l_rec benutils.g_active_life_event;
2199: --
2200: l_bft_id number;
2201: --
2202: cursor c_ler is

Line 2205: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;

2201: --
2202: cursor c_ler is
2203: select ler_id
2204: from ben_person_actions
2205: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
2206: --
2207: begin
2208: --
2209: hr_utility.set_location('Before Process',5);

Line 2258: benutils.get_parameter

2254: --
2255: hr_utility.set_location('After process',10);
2256: hr_utility.set_location('Before get_parameter',21);
2257: --
2258: benutils.get_parameter
2259: (p_business_group_id => p_business_group_id,
2260: p_batch_exe_cd => 'BENMNGLE',
2261: p_threads => l_threads,
2262: p_chunk_size => l_chunk_size,

Line 2277: ,p_benefit_action_id => benutils.g_benefit_action_id

2273: ,p_effective_date => p_effective_date
2274: ,p_threads => l_threads
2275: ,p_chunk_size => l_chunk_size
2276: ,p_max_errors => l_max_errors_allowed
2277: ,p_benefit_action_id => benutils.g_benefit_action_id
2278: ,p_thread_id => 1
2279: );
2280: --
2281: hr_utility.set_location('After ben_manage_life_events.clear_init_benmngle_caches',24);

Line 2314: benutils.get_active_life_event

2310: --
2311: -- GSP : Call diferent procedures for different modes.
2312: if p_mode = 'G' then
2313: --
2314: benutils.get_active_life_event
2315: (p_person_id => p_person_id,
2316: p_business_group_id => p_business_group_id,
2317: p_effective_date => p_effective_date,
2318: p_lf_event_mode => 'G',

Line 2323: benutils.get_active_life_event

2319: p_rec => l_rec);
2320: --
2321: elsif p_mode = 'U' then
2322: --
2323: benutils.get_active_life_event
2324: (p_person_id => p_person_id,
2325: p_business_group_id => p_business_group_id,
2326: p_effective_date => p_effective_date,
2327: p_lf_event_mode => 'U',

Line 2331: benutils.get_active_life_event

2327: p_lf_event_mode => 'U',
2328: p_rec => l_rec);
2329: elsif p_mode = 'M' then
2330: --
2331: benutils.get_active_life_event
2332: (p_person_id => p_person_id,
2333: p_business_group_id => p_business_group_id,
2334: p_effective_date => p_effective_date,
2335: p_lf_event_mode => 'M',

Line 2340: benutils.get_active_life_event

2336: p_rec => l_rec);
2337: --
2338: else
2339: --
2340: benutils.get_active_life_event
2341: (p_person_id => p_person_id,
2342: p_business_group_id => p_business_group_id,
2343: p_effective_date => p_effective_date,
2344: p_rec => l_rec);

Line 2359: p_person_action_id => benutils.g_benefit_action_id, -- null,

2355: hr_utility.set_location('Before process comp objects',55);
2356: --
2357: ben_manage_life_events.process_comp_objects
2358: (p_person_id => p_person_id,
2359: p_person_action_id => benutils.g_benefit_action_id, -- null,
2360: p_object_version_number => l_object_version_number,
2361: p_business_group_id => p_business_group_id,
2362: p_mode => p_mode,
2363: p_ler_id => p_ler_id,

Line 2604: l_outputs := benutils.formula

2600: else
2601: --
2602: -- Call formula initialise routine
2603: --
2604: l_outputs := benutils.formula
2605: (p_formula_id => l_rule_rec.formula_id
2606: ,p_effective_date => p_effective_date
2607: ,p_assignment_id => l_asn.assignment_id
2608: ,p_organization_id => l_asn.organization_id

Line 2811: benutils.run_osb_benmngle_flag

2807: 1. If set to Y, it will always run Unrestricted Benmngle
2808: 2. If set to P, [P for performance] it will not run unrestricted Benmngle at
2809: most of the cases (except when the person's data which affects eligibility has
2810: got changed since the last time Unrestricted was run). This is determined by calling
2811: benutils.run_osb_benmngle_flag
2812: 3. If set to N, it will not run Unrestricted at all and it will also prevent the user
2813: from making any changes to his elections for programs enrolled into through Unrestricted LE.
2814: */
2815:

Line 2821: (benutils.run_osb_benmngle_flag(p_person_id,p_business_group_id,

2817: or
2818: (p_mode = 'U' and p_ss_process_unrestricted <> 'N'
2819: and (p_ss_process_unrestricted = 'Y'
2820: or (p_ss_process_unrestricted = 'P' and
2821: (benutils.run_osb_benmngle_flag(p_person_id,p_business_group_id,
2822: p_effective_date)))))) then
2823: --
2824: hr_utility.set_location ('Calling p_manage_life_events in '||p_mode||' p_mode ', 20);
2825: --

Line 2848: l_rec benutils.g_active_life_event;

2844: l_test number;
2845:
2846: record_locked EXCEPTION;
2847: PRAGMA EXCEPTION_INIT (record_locked, -54);
2848: l_rec benutils.g_active_life_event;
2849:
2850: begin
2851: savepoint ben_popl_lock_savepoint;
2852:

Line 2853: benutils.get_active_life_event

2849:
2850: begin
2851: savepoint ben_popl_lock_savepoint;
2852:
2853: benutils.get_active_life_event
2854: (p_person_id => p_person_id,
2855: p_business_group_id => p_business_group_id,
2856: p_effective_date => l_effective_date,
2857: p_lf_event_mode => 'U',