APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_PKG

Line 1: package body pay_retro_pkg

1: package body pay_retro_pkg
2: /* $Header: pyretpay.pkb 120.39.12020000.3 2012/09/21 09:50:09 panumala ship $ */
3: as
4: --
5: --

Line 163: where pay_retro_pkg.process_retro_value(

159: begin
160: select 1
161: into l_result
162: from dual
163: where pay_retro_pkg.process_retro_value(
164: p_element_entry_id,
165: p_element_type_id,
166: p_retro_comp_id,
167: p_retro_asg_id

Line 408: return pay_retro_pkg.is_retro_entry(l_creator_type);

404: where element_entry_id = p_element_entry_id
405: and p_date between effective_start_date
406: and effective_end_date;
407: --
408: return pay_retro_pkg.is_retro_entry(l_creator_type);
409: --
410: exception
411: when no_data_found then
412: return 0;

Line 1515: AND pay_retro_pkg.latest_replace_ovl_ee (pee.element_entry_id) = 'Y'

1511: */
1512: ( prc.recalculation_style = 'R'
1513: AND
1514: ( (pee.creator_type = 'PR'
1515: AND pay_retro_pkg.latest_replace_ovl_ee (pee.element_entry_id) = 'Y'
1516: )
1517: OR
1518: (pee.creator_type = 'NR'
1519: AND pay_retro_pkg.latest_replace_ovl_del_ee (pee.element_entry_id) = 'Y'

Line 1519: AND pay_retro_pkg.latest_replace_ovl_del_ee (pee.element_entry_id) = 'Y'

1515: AND pay_retro_pkg.latest_replace_ovl_ee (pee.element_entry_id) = 'Y'
1516: )
1517: OR
1518: (pee.creator_type = 'NR'
1519: AND pay_retro_pkg.latest_replace_ovl_del_ee (pee.element_entry_id) = 'Y'
1520: )
1521: )
1522: )
1523: )

Line 1640: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',10);

1636: l_rr_id number;
1637: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
1638: --
1639: begin
1640: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',10);
1641: select pay_payroll_actions_s.nextval,
1642: ppa.business_group_id,
1643: ppa.consolidation_set_id,
1644: ppa.payroll_id,

Line 1744: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',20);

1740: end if;
1741:
1742:
1743: --
1744: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',20);
1745: l_ee_id := -1;
1746: l_run_type := -1;
1747: l_tax_unit_id := -1;
1748: l_asg_act_id := -1;

Line 1837: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',30);

1833: );
1834: --
1835: end loop;
1836: --
1837: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',30);
1838: /* Bug 8614449 */
1839: if (l_asg_act_id <> -1) then
1840: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1841:

Line 1975: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',40);

1971: --
1972: if (l_asg_act_id <> -1) then
1973: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1974: end if;
1975: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',40);
1976: --
1977: end overlap_adjustments;
1978: --
1979: -- Note in process_recorded_date, we're using the serial_number column to

Line 2135: end pay_retro_pkg;

2131: hr_utility.set_location('reset_recorded_request', 30);
2132: --
2133: end reset_recorded_request;
2134: --
2135: end pay_retro_pkg;