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.10.12010000.2 2008/08/06 08:34:30 ubhat 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 2085: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);

2081: END IF; --p_report_type
2082: --}
2083: ELSIF p_format = 'CUSTOM' THEN
2084: --{
2085: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2086:
2087: IF p_record_name = 'H' THEN -- p_record_name
2088: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2089: return_value :=

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

2084: --{
2085: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2086:
2087: IF p_record_name = 'H' THEN -- p_record_name
2088: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2089: return_value :=
2090: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYER(
2091: p_effective_date,
2092: p_report_type,

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

2144: l_exclude_from_output_chk
2145: );
2146:
2147: ELSIF p_record_name = 'D' THEN
2148: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2149: return_value :=
2150: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYEE(
2151: p_effective_date,
2152: p_report_type,

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

2911:
2912:
2913: BEGIN
2914: lv_return_value := 0;
2915: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2916:
2917: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2918: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2919:

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

2962: p_state varchar2 default null
2963: ) RETURN number IS
2964: lv_employee_count number ;
2965: BEGIN
2966: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2967: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2968: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2969:
2970: select count(*)

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

3141: i NUMBER ;
3142:
3143: BEGIN
3144:
3145: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3146: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3147: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3148: hr_utility.trace('p_state := ' || p_state) ;
3149: hr_utility.trace('p_report_type := ' || p_report_type) ;

Line 3383: END pay_us_reporting_utils_pkg;

3379: END GET_SUI_WAGES;
3380: --BEGIN
3381: --hr_utility.trace_on(null,'MMREF');
3382:
3383: END pay_us_reporting_utils_pkg;