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 1496: benutils.get_assignment_id(p_person_id=> p_person_id

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

Line 1550: benutils.get_parameter

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

Line 1568: ,p_benefit_action_id => benutils.g_benefit_action_id

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

Line 1577: (p_benefit_action_id => benutils.g_benefit_action_id,

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

Line 1630: g_benefit_action_id := benutils.g_benefit_action_id;

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

Line 1639: benutils.get_active_life_event

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

Line 1650: benutils.get_active_life_event

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

Line 1659: benutils.get_active_life_event

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

Line 1667: benutils.get_active_life_event

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

Line 1676: benutils.get_active_life_event

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

Line 1891: l_rec benutils.g_active_life_event;

1887: l_lf_evt_ocrd_dt varchar2(30);
1888: l_chunk_size number := 0;
1889: l_threads number := 0;
1890: l_max_errors_allowed number;
1891: l_rec benutils.g_active_life_event;
1892: l_assignment_id number;
1893: --
1894: l_bft_id number;
1895: --

Line 1899: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;

1895: --
1896: cursor c_ler is
1897: select ler_id
1898: from ben_person_actions
1899: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
1900: --
1901: begin
1902: --
1903: hr_utility.set_location(l_package || ' Before Process',5);

Line 1926: benutils.get_assignment_id(p_person_id=> p_person_id

1922: --
1923: if p_mode in ('L', 'C','U') then
1924: l_assignment_id := null;
1925: l_assignment_id :=
1926: benutils.get_assignment_id(p_person_id=> p_person_id
1927: ,p_business_group_id => p_business_group_id
1928: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date));
1929: --
1930: if l_assignment_id is null

Line 1976: benutils.get_parameter

1972: hr_utility.set_location(l_package ||' After process',10);
1973: --
1974: hr_utility.set_location('Before get_parameter',21);
1975: --
1976: benutils.get_parameter
1977: (p_business_group_id => p_business_group_id,
1978: p_batch_exe_cd => 'BENMNGLE',
1979: p_threads => l_threads,
1980: p_chunk_size => l_chunk_size,

Line 1995: ,p_benefit_action_id => benutils.g_benefit_action_id

1991: ,p_effective_date => p_effective_date
1992: ,p_threads => l_threads
1993: ,p_chunk_size => l_chunk_size
1994: ,p_max_errors => l_max_errors_allowed
1995: ,p_benefit_action_id => benutils.g_benefit_action_id
1996: ,p_thread_id => 1
1997: );
1998: --
1999: hr_utility.set_location('After ben_manage_life_events.clear_init_benmngle_caches',24);

Line 2036: g_benefit_action_id := benutils.g_benefit_action_id;

2032: hr_utility.set_location('After evaluate life events',50);
2033: --
2034: -- save the benefit action id to be used by process_comp_objects.
2035: --
2036: g_benefit_action_id := benutils.g_benefit_action_id;
2037: --
2038: -- To synchronize with process_life_events procedure
2039: -- ben_manage_life_events.person_header is moved here.
2040: --

Line 2046: benutils.get_active_life_event

2042: --
2043: -- GSP : Call diferent procedures for different modes.
2044: if p_mode = 'G' then
2045: --
2046: benutils.get_active_life_event
2047: (p_person_id => p_person_id,
2048: p_business_group_id => p_business_group_id,
2049: p_effective_date => p_effective_date,
2050: p_lf_event_mode => 'G',

Line 2055: benutils.get_active_life_event

2051: p_rec => l_rec);
2052: --
2053: elsif p_mode = 'U' then
2054: --
2055: benutils.get_active_life_event
2056: (p_person_id => p_person_id,
2057: p_business_group_id => p_business_group_id,
2058: p_effective_date => p_effective_date,
2059: p_lf_event_mode => 'U',

Line 2063: benutils.get_active_life_event

2059: p_lf_event_mode => 'U',
2060: p_rec => l_rec);
2061: elsif p_mode = 'M' then
2062: --
2063: benutils.get_active_life_event
2064: (p_person_id => p_person_id,
2065: p_business_group_id => p_business_group_id,
2066: p_effective_date => p_effective_date,
2067: p_lf_event_mode => 'M',

Line 2072: benutils.get_active_life_event

2068: p_rec => l_rec);
2069: --
2070: else
2071: --
2072: benutils.get_active_life_event
2073: (p_person_id => p_person_id,
2074: p_business_group_id => p_business_group_id,
2075: p_effective_date => p_effective_date,
2076: p_rec => l_rec);

Line 2157: p_benefit_action_id := benutils.g_benefit_action_id;

2153: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2154: -- p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id,
2155: p_effective_date => p_effective_date
2156: );
2157: p_benefit_action_id := benutils.g_benefit_action_id;
2158: --
2159: -- Write results to log
2160: --
2161: benutils.WRITE_TABLE_AND_FILE(P_TABLE => TRUE, P_FILE => FALSE);

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

2157: p_benefit_action_id := benutils.g_benefit_action_id;
2158: --
2159: -- Write results to log
2160: --
2161: benutils.WRITE_TABLE_AND_FILE(P_TABLE => TRUE, P_FILE => FALSE);
2162: --
2163: ben_cobj_cache.clear_down_cache;
2164: hr_utility.set_location('After process comp objects',60);
2165: --

Line 2210: l_rec benutils.g_active_life_event;

2206: l_chunk_size number := 0;
2207: l_threads number := 0;
2208: l_max_errors_allowed number;
2209: --
2210: l_rec benutils.g_active_life_event;
2211: --
2212: l_bft_id number;
2213: --
2214: cursor c_ler is

Line 2217: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;

2213: --
2214: cursor c_ler is
2215: select ler_id
2216: from ben_person_actions
2217: where BENEFIT_ACTION_ID = benutils.g_benefit_action_id;
2218: --
2219: begin
2220: --
2221: hr_utility.set_location('Before Process',5);

Line 2270: benutils.get_parameter

2266: --
2267: hr_utility.set_location('After process',10);
2268: hr_utility.set_location('Before get_parameter',21);
2269: --
2270: benutils.get_parameter
2271: (p_business_group_id => p_business_group_id,
2272: p_batch_exe_cd => 'BENMNGLE',
2273: p_threads => l_threads,
2274: p_chunk_size => l_chunk_size,

Line 2289: ,p_benefit_action_id => benutils.g_benefit_action_id

2285: ,p_effective_date => p_effective_date
2286: ,p_threads => l_threads
2287: ,p_chunk_size => l_chunk_size
2288: ,p_max_errors => l_max_errors_allowed
2289: ,p_benefit_action_id => benutils.g_benefit_action_id
2290: ,p_thread_id => 1
2291: );
2292: --
2293: hr_utility.set_location('After ben_manage_life_events.clear_init_benmngle_caches',24);

Line 2326: benutils.get_active_life_event

2322: --
2323: -- GSP : Call diferent procedures for different modes.
2324: if p_mode = 'G' then
2325: --
2326: benutils.get_active_life_event
2327: (p_person_id => p_person_id,
2328: p_business_group_id => p_business_group_id,
2329: p_effective_date => p_effective_date,
2330: p_lf_event_mode => 'G',

Line 2335: benutils.get_active_life_event

2331: p_rec => l_rec);
2332: --
2333: elsif p_mode = 'U' then
2334: --
2335: benutils.get_active_life_event
2336: (p_person_id => p_person_id,
2337: p_business_group_id => p_business_group_id,
2338: p_effective_date => p_effective_date,
2339: p_lf_event_mode => 'U',

Line 2343: benutils.get_active_life_event

2339: p_lf_event_mode => 'U',
2340: p_rec => l_rec);
2341: elsif p_mode = 'M' then
2342: --
2343: benutils.get_active_life_event
2344: (p_person_id => p_person_id,
2345: p_business_group_id => p_business_group_id,
2346: p_effective_date => p_effective_date,
2347: p_lf_event_mode => 'M',

Line 2352: benutils.get_active_life_event

2348: p_rec => l_rec);
2349: --
2350: else
2351: --
2352: benutils.get_active_life_event
2353: (p_person_id => p_person_id,
2354: p_business_group_id => p_business_group_id,
2355: p_effective_date => p_effective_date,
2356: p_rec => l_rec);

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

2367: hr_utility.set_location('Before process comp objects',55);
2368: --
2369: ben_manage_life_events.process_comp_objects
2370: (p_person_id => p_person_id,
2371: p_person_action_id => benutils.g_benefit_action_id, -- null,
2372: p_object_version_number => l_object_version_number,
2373: p_business_group_id => p_business_group_id,
2374: p_mode => p_mode,
2375: p_ler_id => p_ler_id,

Line 2616: l_outputs := benutils.formula

2612: else
2613: --
2614: -- Call formula initialise routine
2615: --
2616: l_outputs := benutils.formula
2617: (p_formula_id => l_rule_rec.formula_id
2618: ,p_effective_date => p_effective_date
2619: ,p_assignment_id => l_asn.assignment_id
2620: ,p_organization_id => l_asn.organization_id

Line 2846: benutils.run_osb_benmngle_flag

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

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

2852: or
2853: (p_mode = 'U' and p_ss_process_unrestricted <> 'N'
2854: and (p_ss_process_unrestricted = 'Y'
2855: or (p_ss_process_unrestricted = 'P' and
2856: (benutils.run_osb_benmngle_flag(p_person_id,p_business_group_id,
2857: p_effective_date)))))) then
2858: --
2859: hr_utility.set_location ('Calling p_manage_life_events in '||p_mode||' p_mode ', 20);
2860: --

Line 2883: l_rec benutils.g_active_life_event;

2879: l_test number;
2880:
2881: record_locked EXCEPTION;
2882: PRAGMA EXCEPTION_INIT (record_locked, -54);
2883: l_rec benutils.g_active_life_event;
2884:
2885: begin
2886: savepoint ben_popl_lock_savepoint;
2887:

Line 2888: benutils.get_active_life_event

2884:
2885: begin
2886: savepoint ben_popl_lock_savepoint;
2887:
2888: benutils.get_active_life_event
2889: (p_person_id => p_person_id,
2890: p_business_group_id => p_business_group_id,
2891: p_effective_date => l_effective_date,
2892: p_lf_event_mode => 'U',