DBA Data[Home] [Help]

APPS.PAY_US_REPORTING_UTILS_PKG dependencies on PAY_US_REPORTING_UTILS_PKG

Line 1: PACKAGE BODY pay_us_reporting_utils_pkg AS

1: PACKAGE BODY pay_us_reporting_utils_pkg AS
2: /* $Header: pyusmref.pkb 120.18.12020000.3 2012/07/05 03:26:07 amnaraya ship $ */
3:
4: /*===========================================================================+
5: | Copyright (c) 2001 Oracle Corporation |

Line 10: pay_us_reporting_utils_pkg

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +============================================================================+
9: Name
10: pay_us_reporting_utils_pkg
11:
12: Purpose
13: The purpose of this package is to support the generation of magnetic tape W2
14: reports for US legilsative requirements incorporating magtape resilience

Line 2102: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);

2098: END IF; --p_report_type
2099: --}
2100: ELSIF p_format = 'CUSTOM' THEN
2101: --{
2102: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2103:
2104: IF p_record_name = 'H' THEN -- p_record_name
2105: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2106: return_value :=

Line 2105: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);

2101: --{
2102: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2103:
2104: IF p_record_name = 'H' THEN -- p_record_name
2105: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2106: return_value :=
2107: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYER(
2108: p_effective_date,
2109: p_report_type,

Line 2165: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);

2161: l_exclude_from_output_chk
2162: );
2163:
2164: ELSIF p_record_name = 'D' THEN
2165: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2166: return_value :=
2167: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYEE(
2168: p_effective_date,
2169: p_report_type,

Line 2934: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');

2930:
2931:
2932: BEGIN
2933: lv_return_value := 0;
2934: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2935:
2936: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2937: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2938:

Line 2985: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;

2981: p_state varchar2 default null
2982: ) RETURN number IS
2983: lv_employee_count number ;
2984: BEGIN
2985: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2986: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2987: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2988:
2989: select count(*)

Line 3305: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;

3301: i NUMBER ;
3302:
3303: BEGIN
3304:
3305: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3306: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3307: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3308: hr_utility.trace('p_state := ' || p_state) ;
3309: hr_utility.trace('p_report_type := ' || p_report_type) ;

Line 3643: END pay_us_reporting_utils_pkg;

3639: END GET_SUI_WAGES;
3640: --BEGIN
3641: --hr_utility.trace_on(null,'MMREF');
3642:
3643: END pay_us_reporting_utils_pkg;