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.PAY_FR_ARC_PKG dependencies on PAY_BALANCE_PKG

Line 1928: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',to_char(p_assignment_action_id));

1924: hr_utility.set_location(' Entering ' || l_proc, 10);
1925: --
1926: -- set the contexts
1927: --
1928: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',to_char(p_assignment_action_id));
1929: pay_balance_pkg.set_context ('TAX_UNIT_ID',to_char(p_context_id));
1930: --
1931: -- Get all the defined balance values for this assignment
1932: --

Line 1929: pay_balance_pkg.set_context ('TAX_UNIT_ID',to_char(p_context_id));

1925: --
1926: -- set the contexts
1927: --
1928: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',to_char(p_assignment_action_id));
1929: pay_balance_pkg.set_context ('TAX_UNIT_ID',to_char(p_context_id));
1930: --
1931: -- Get all the defined balance values for this assignment
1932: --
1933: -- BALANCE 1 total gross pay

Line 1934: l_balance_value1 := pay_balance_pkg.get_value (

1930: --
1931: -- Get all the defined balance values for this assignment
1932: --
1933: -- BALANCE 1 total gross pay
1934: l_balance_value1 := pay_balance_pkg.get_value (
1935: p_defined_balance_id => g_1total_gross_pay_db,
1936: p_assignment_action_id => p_assignment_action_id);
1937: hr_utility.set_location('Balance 1 is ' || to_char(l_balance_value1), 15);
1938: -- BALANCE 2 ss ceiling

Line 1939: l_balance_value2 := pay_balance_pkg.get_value (

1935: p_defined_balance_id => g_1total_gross_pay_db,
1936: p_assignment_action_id => p_assignment_action_id);
1937: hr_utility.set_location('Balance 1 is ' || to_char(l_balance_value1), 15);
1938: -- BALANCE 2 ss ceiling
1939: l_balance_value2 := pay_balance_pkg.get_value (
1940: p_defined_balance_id => g_2ss_ceiling_db
1941: ,p_assignment_action_id => p_assignment_action_id);
1942: hr_utility.set_location('Balance 2 is ' || to_char(l_balance_value2), 20);
1943: -- BALANCE 3 employees total contributions

Line 1944: l_balance_value3 := pay_balance_pkg.get_value (

1940: p_defined_balance_id => g_2ss_ceiling_db
1941: ,p_assignment_action_id => p_assignment_action_id);
1942: hr_utility.set_location('Balance 2 is ' || to_char(l_balance_value2), 20);
1943: -- BALANCE 3 employees total contributions
1944: l_balance_value3 := pay_balance_pkg.get_value (
1945: p_defined_balance_id => g_3es_total_contributions_db
1946: ,p_assignment_action_id => p_assignment_action_id);
1947: hr_utility.set_location('Balance 3 is ' || to_char(l_balance_value3), 30);
1948: -- BALANCE 4 statutory employer charges

Line 1949: l_balance_value4 := pay_balance_pkg.get_value (

1945: p_defined_balance_id => g_3es_total_contributions_db
1946: ,p_assignment_action_id => p_assignment_action_id);
1947: hr_utility.set_location('Balance 3 is ' || to_char(l_balance_value3), 30);
1948: -- BALANCE 4 statutory employer charges
1949: l_balance_value4 := pay_balance_pkg.get_value (
1950: p_defined_balance_id => g_4statutory_er_charges_db
1951: ,p_assignment_action_id => p_assignment_action_id);
1952: hr_utility.set_location('Balance 4 is ' || to_char(l_balance_value4), 40);
1953: -- BALANCE 5 conventional employer charges

Line 1954: l_balance_value5 := pay_balance_pkg.get_value (

1950: p_defined_balance_id => g_4statutory_er_charges_db
1951: ,p_assignment_action_id => p_assignment_action_id);
1952: hr_utility.set_location('Balance 4 is ' || to_char(l_balance_value4), 40);
1953: -- BALANCE 5 conventional employer charges
1954: l_balance_value5 := pay_balance_pkg.get_value (
1955: p_defined_balance_id => g_5conventional_er_charges_db
1956: ,p_assignment_action_id => p_assignment_action_id);
1957: hr_utility.set_location('Balance 5 is ' || to_char(l_balance_value5), 50);
1958: -- BALANCE 6 t1 arrco band

Line 1959: l_balance_value6 := pay_balance_pkg.get_value (

1955: p_defined_balance_id => g_5conventional_er_charges_db
1956: ,p_assignment_action_id => p_assignment_action_id);
1957: hr_utility.set_location('Balance 5 is ' || to_char(l_balance_value5), 50);
1958: -- BALANCE 6 t1 arrco band
1959: l_balance_value6 := pay_balance_pkg.get_value (
1960: p_defined_balance_id => g_6t1_arrco_band_db
1961: ,p_assignment_action_id => p_assignment_action_id);
1962: hr_utility.set_location('Balance 6 is ' || to_char(l_balance_value6), 60);
1963: -- BALANCE 7 t2 arrco band

Line 1964: l_balance_value7 := pay_balance_pkg.get_value (

1960: p_defined_balance_id => g_6t1_arrco_band_db
1961: ,p_assignment_action_id => p_assignment_action_id);
1962: hr_utility.set_location('Balance 6 is ' || to_char(l_balance_value6), 60);
1963: -- BALANCE 7 t2 arrco band
1964: l_balance_value7 := pay_balance_pkg.get_value (
1965: p_defined_balance_id => g_7t2_arrco_band_db
1966: ,p_assignment_action_id => p_assignment_action_id);
1967: hr_utility.set_location('Balance 7 is ' || to_char(l_balance_value7), 70);
1968: -- BALANCE 8 tb arrco band

Line 1969: l_balance_value8 := pay_balance_pkg.get_value (

1965: p_defined_balance_id => g_7t2_arrco_band_db
1966: ,p_assignment_action_id => p_assignment_action_id);
1967: hr_utility.set_location('Balance 7 is ' || to_char(l_balance_value7), 70);
1968: -- BALANCE 8 tb arrco band
1969: l_balance_value8 := pay_balance_pkg.get_value (
1970: p_defined_balance_id => g_8tb_argic_band_db
1971: ,p_assignment_action_id => p_assignment_action_id);
1972: hr_utility.set_location('Balance 8 is ' || to_char(l_balance_value8), 80);
1973: -- BALANCE 9 tc arrco band

Line 1974: l_balance_value9 := pay_balance_pkg.get_value (

1970: p_defined_balance_id => g_8tb_argic_band_db
1971: ,p_assignment_action_id => p_assignment_action_id);
1972: hr_utility.set_location('Balance 8 is ' || to_char(l_balance_value8), 80);
1973: -- BALANCE 9 tc arrco band
1974: l_balance_value9 := pay_balance_pkg.get_value (
1975: p_defined_balance_id => g_9tc_agirc_band_db
1976: ,p_assignment_action_id => p_assignment_action_id);
1977: hr_utility.set_location('Balance 9 is ' || to_char(l_balance_value9), 90);
1978: -- BALANCE 10 gmp agirc band

Line 1979: l_balance_value10 := pay_balance_pkg.get_value (

1975: p_defined_balance_id => g_9tc_agirc_band_db
1976: ,p_assignment_action_id => p_assignment_action_id);
1977: hr_utility.set_location('Balance 9 is ' || to_char(l_balance_value9), 90);
1978: -- BALANCE 10 gmp agirc band
1979: l_balance_value10 := pay_balance_pkg.get_value (
1980: p_defined_balance_id => g_10gmp_agirc_band_db
1981: ,p_assignment_action_id => p_assignment_action_id);
1982: hr_utility.set_location('Balance 10 is ' || to_char(l_balance_value10), 100);
1983: -- BALANCE 11 total cost to employer

Line 1984: l_balance_value11 := pay_balance_pkg.get_value (

1980: p_defined_balance_id => g_10gmp_agirc_band_db
1981: ,p_assignment_action_id => p_assignment_action_id);
1982: hr_utility.set_location('Balance 10 is ' || to_char(l_balance_value10), 100);
1983: -- BALANCE 11 total cost to employer
1984: l_balance_value11 := pay_balance_pkg.get_value (
1985: p_defined_balance_id => g_11total_cost_to_employer_db
1986: ,p_assignment_action_id => p_assignment_action_id);
1987: hr_utility.set_location('Balance 110 is ' || to_char(l_balance_value11), 110);
1988: --

Line 2014: l_balance_value12 := pay_balance_pkg.get_value (

2010: -- BALANCE 12 taxable income
2011: -- This is an exception, it is stored as a totals value as it appears within
2012: -- the deductions block against totals text, and is a PTD dimension
2013: --
2014: l_balance_value12 := pay_balance_pkg.get_value (
2015: p_defined_balance_id => g_12taxable_income_db
2016: ,p_assignment_action_id => p_assignment_action_id);
2017: hr_utility.set_location('Balance 12 is ' || to_char(l_balance_value12), 120);
2018: hr_utility.set_location('Balance 12 db ' || to_char(g_12taxable_income_db), 121);

Line 3402: tbl_retrieval_list pay_balance_pkg.t_balance_value_tab;

3398: tbl_base t_num_tbl;
3399: tbl_start_date t_date_tbl;
3400: tbl_end_date t_date_tbl;
3401: tbl_pos_idx t_binint_tbl;
3402: tbl_retrieval_list pay_balance_pkg.t_balance_value_tab;
3403: l_pos_offset BINARY_INTEGER;
3404: l_grouped_rate_ptr BINARY_INTEGER;
3405: l_action_ptr BINARY_INTEGER;
3406: l_current_ptr BINARY_INTEGER;

Line 3693: tbl_ee_amount(l_current_ptr) := pay_balance_pkg.get_value(

3689: --
3690: -- loop through whole table, grouping EE/ER rows
3691: WHILE l_current_ptr IS NOT NULL LOOP
3692: -- Get the balance amount (tbl_ee_amount currently stores the def bal id)
3693: tbl_ee_amount(l_current_ptr) := pay_balance_pkg.get_value(
3694: tbl_ee_amount(l_current_ptr)
3695: ,tbl_action_id(l_current_ptr)
3696: ,tbl_tax_unit_id(l_current_ptr)
3697: ,null

Line 3798: pay_balance_pkg.get_value(tbl_action_id(l_action_ptr)

3794: then
3795: -- if there were deductions with bases against previous action then
3796: if tbl_pos_idx.count > 0 then
3797: -- fetch tbl_retrieval_list for previous action id
3798: pay_balance_pkg.get_value(tbl_action_id(l_action_ptr)
3799: ,tbl_retrieval_list);
3800: -- copy each tbl_retrieval_list(i).balance_value to tbl_base(i+offset)
3801: for i in tbl_retrieval_list.first..tbl_retrieval_list.last loop
3802: tbl_base(i+l_pos_offset):=nvl(tbl_retrieval_list(i).balance_value,0);