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.

[Home] [Help]

APPS.HR_GBNIDIR dependencies on HR_UTILITY

Line 791: hr_utility.trace('Calling set_defined_balances');

787: Begin
788: --
789: -- Set up the defined balances for all NI balances _PER_TD_DIR_YTD
790: if g_defined_director_set = FALSE then
791: hr_utility.trace('Calling set_defined_balances');
792: set_defined_balances('_PER_TD_DIR_YTD');
793: end if;
794: hr_utility.trace('example defbal:'||to_char(g_comp_min_ers_defbal));
795: --

Line 794: hr_utility.trace('example defbal:'||to_char(g_comp_min_ers_defbal));

790: if g_defined_director_set = FALSE then
791: hr_utility.trace('Calling set_defined_balances');
792: set_defined_balances('_PER_TD_DIR_YTD');
793: end if;
794: hr_utility.trace('example defbal:'||to_char(g_comp_min_ers_defbal));
795: --
796: if g_ni_able_id is null then
797: select balance_type_id
798: into g_ni_able_id

Line 995: hr_utility.trace('No data found on call to pay_balance_pkg');

991: BEGIN
992: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
993: p_defined_balance_lst => l_balance_list);
994: EXCEPTION WHEN NO_DATA_FOUND THEN
995: hr_utility.trace('No data found on call to pay_balance_pkg');
996: null;
997: END;
998: --
999: -- Set the Global variables to the values just retrieved from the bulk call to

Line 1868: hr_utility.trace('Calling set_defined_balances');

1864: Begin
1865: --
1866: -- Set up the defined balances for all NI balances _PER_NI_PTD
1867: if g_defined_ptd_set = FALSE then
1868: hr_utility.trace('Calling set_defined_balances');
1869: set_defined_balances('_PER_NI_PTD');
1870: end if;
1871: hr_utility.trace('example defbal:'||to_char(g_comp_min_ers_defbal));
1872: --

Line 1871: hr_utility.trace('example defbal:'||to_char(g_comp_min_ers_defbal));

1867: if g_defined_ptd_set = FALSE then
1868: hr_utility.trace('Calling set_defined_balances');
1869: set_defined_balances('_PER_NI_PTD');
1870: end if;
1871: hr_utility.trace('example defbal:'||to_char(g_comp_min_ers_defbal));
1872: --
1873: if g_ni_able_id is null then
1874: select balance_type_id
1875: into g_ni_able_id

Line 1912: hr_utility.trace('Assignment Action: '||to_char(g_assignment_action_id));

1908: --
1909: l_stat_period_start := hr_gbnidir.STATUTORY_PERIOD_START_DATE(p_assignment_action_id);
1910: g_statutory_period_start_date := l_stat_period_start;
1911: g_assignment_action_id := p_assignment_action_id;
1912: hr_utility.trace('Assignment Action: '||to_char(g_assignment_action_id));
1913: --
1914: /* NI ABLE CURSOR WHICH REMAINS DUE TO USING VARIANT ROUTE AND STYLE */
1915: /* OF SELECTION FROM BALANCE TABLES. */
1916: select /*+ ORDERED INDEX(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK,

Line 2064: hr_utility.trace('No data found on call to pay_balance_pkg');

2060: BEGIN
2061: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
2062: p_defined_balance_lst => l_balance_list);
2063: EXCEPTION WHEN NO_DATA_FOUND THEN
2064: hr_utility.trace('No data found on call to pay_balance_pkg');
2065: null;
2066: END;
2067: --
2068: -- Set the Global variables to the values just retrieved from the bulk

Line 2264: hr_utility.set_location('hr_gbnidir.niable_bands', 10);

2260: -- L_ET: employers earnings threshold for the period.
2261: -- L_UEL: upper earnings threshold
2262: NI_ABLE NUMBER;
2263: begin
2264: hr_utility.set_location('hr_gbnidir.niable_bands', 10);
2265: NI_ABLE := 0; -- niable up to the UEL for current category
2266: NI_ABLE_LEL := 0; -- niable up to the LEL for current category if niable is >LEL
2267: NI_ABLE_EET := 0; -- Now obsolete, set to zero.
2268: NI_ABLE_ET := 0; -- niable between the LEL and the ET for category

Line 2273: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2269: NI_ABLE_UEL := 0; -- niable bwteen the ET and UEL for category
2270: NI_UPPER := 0; -- earnings above the UEL for category, ie Above UEL (AUEL).
2271: NI_LOWER := 0; -- earnings below the LEL for category
2272: if l_ni_cat_able > 0 then
2273: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2274: NI_LOWER := greatest(0,(least(l_lel,l_niable)
2275: - (l_niable - l_ni_cat_able)));
2276: -- if Employees total earnings subject to NI is over the Lower Earnings limit
2277: -- work out how much of those LEL earnings are for Niable for the category

Line 2283: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2279: -- highest priority category will attract the LEL earnings. Subsequent
2280: -- categories start their calculating at higher thresholds as NIABLE already
2281: -- calculated is taken into account.
2282: if l_tot_niable > l_lel then
2283: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2284: ni_able_lel := ni_lower;
2285: --
2286: ni_able_et := greatest(0,((least(l_et,l_niable)) -
2287: (greatest(l_lel,(l_niable - l_ni_cat_able)))));

Line 2294: hr_utility.trace('NIABLE_BANDS ni_able_lel='||to_char(ni_able_lel)||

2290: (greatest(l_et,(l_niable - l_ni_cat_able)))));
2291: ni_upper := greatest(0,(l_niable - (greatest(l_uel,
2292: (l_niable - l_ni_cat_able)))));
2293: ni_able := ni_able_lel + ni_able_et + ni_able_uel;
2294: hr_utility.trace('NIABLE_BANDS ni_able_lel='||to_char(ni_able_lel)||
2295: ' ni_able_et='||to_char(ni_able_et)||
2296: ' ni_able_uel='||to_char(ni_able_uel)||
2297: ' ni_upper='||to_char(ni_upper)||
2298: ' ni_lower='||to_char(ni_lower)||