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_YREND_REPORTS_PKG dependencies on PAY_YREND_REPORTS_PKG

Line 1: package body pay_yrend_reports_pkg as

1: package body pay_yrend_reports_pkg as
2: /* $Header: pyusw2cu.pkb 120.7 2011/09/15 17:52:44 sgotlasw ship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5:

Line 64: c_package constant varchar2(31) := 'pay_yrend_reports_pkg.';

60: Assignment ID of the employee in range_cursor code
61: and action_creation code.
62: */
63: --
64: c_package constant varchar2(31) := 'pay_yrend_reports_pkg.';
65: c_commit_num constant number := 1000;
66: --
67: g_debug boolean := hr_utility.debug_enabled;
68: --

Line 96: select pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),

92: /* year end pre-processor stores person id in serial number */
93: -- Query is added to fetch the tax_unit_id, year, EOY payroll_action_id to be
94: -- passed to the sqlstring to improve the performance.
95: --
96: select pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
97: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
98: ppa.payroll_action_id
99: into l_tax_unit_id,
100: l_assign_year,

Line 97: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),

93: -- Query is added to fetch the tax_unit_id, year, EOY payroll_action_id to be
94: -- passed to the sqlstring to improve the performance.
95: --
96: select pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
97: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
98: ppa.payroll_action_id
99: into l_tax_unit_id,
100: l_assign_year,
101: l_eoy_payroll_action_id

Line 106: pay_yrend_reports_pkg.get_parameter

102: from pay_payroll_actions ppa, /* EOY payroll action id */
103: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
104: where ppa1.payroll_action_id = pactid
105: and ppa.effective_date = to_date('31-DEC-'||
106: pay_yrend_reports_pkg.get_parameter
107: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
108: and ppa.report_type = 'YREND'
109: and pay_yrend_reports_pkg.get_parameter
110: ('T_U_ID',ppa1.legislative_parameters) =

Line 109: and pay_yrend_reports_pkg.get_parameter

105: and ppa.effective_date = to_date('31-DEC-'||
106: pay_yrend_reports_pkg.get_parameter
107: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
108: and ppa.report_type = 'YREND'
109: and pay_yrend_reports_pkg.get_parameter
110: ('T_U_ID',ppa1.legislative_parameters) =
111: pay_yrend_reports_pkg.get_parameter
112: ('TRANSFER_GRE',ppa.legislative_parameters);
113:

Line 111: pay_yrend_reports_pkg.get_parameter

107: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
108: and ppa.report_type = 'YREND'
109: and pay_yrend_reports_pkg.get_parameter
110: ('T_U_ID',ppa1.legislative_parameters) =
111: pay_yrend_reports_pkg.get_parameter
112: ('TRANSFER_GRE',ppa.legislative_parameters);
113:
114: sqlstr := 'select distinct to_number(act.serial_number)
115: from pay_assignment_actions act /* W2 Register Information */

Line 255: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),

251: l_procedure_name := 'action_creation';
252: hr_utility.set_location(l_procedure_name, 1);
253: --
254: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor
255: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),
256: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
257: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
258: ppa.payroll_action_id,
259: ppa.effective_date,

Line 256: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),

252: hr_utility.set_location(l_procedure_name, 1);
253: --
254: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor
255: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),
256: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
257: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
258: ppa.payroll_action_id,
259: ppa.effective_date,
260: ppa.start_date

Line 257: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),

253: --
254: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor
255: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),
256: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
257: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
258: ppa.payroll_action_id,
259: ppa.effective_date,
260: ppa.start_date
261: ,hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters)

Line 274: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter

270: ,l_locality_code
271: from pay_payroll_actions ppa, /* W2 payroll action id */
272: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
273: where ppa1.payroll_action_id = pactid
274: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
275: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
276: and ppa.report_type = 'YREND'
277: and pay_yrend_reports_pkg.get_parameter
278: ('T_U_ID',ppa1.legislative_parameters) =

Line 277: and pay_yrend_reports_pkg.get_parameter

273: where ppa1.payroll_action_id = pactid
274: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
275: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
276: and ppa.report_type = 'YREND'
277: and pay_yrend_reports_pkg.get_parameter
278: ('T_U_ID',ppa1.legislative_parameters) =
279: pay_yrend_reports_pkg.get_parameter
280: ('TRANSFER_GRE',ppa.legislative_parameters);
281:

Line 279: pay_yrend_reports_pkg.get_parameter

275: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
276: and ppa.report_type = 'YREND'
277: and pay_yrend_reports_pkg.get_parameter
278: ('T_U_ID',ppa1.legislative_parameters) =
279: pay_yrend_reports_pkg.get_parameter
280: ('TRANSFER_GRE',ppa.legislative_parameters);
281:
282: hr_utility.trace('l_assign_set= ' || l_assign_set);
283: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);

Line 822: end pay_yrend_reports_pkg;

818: end if;
819: --
820: end deinitialize_code;
821: --
822: end pay_yrend_reports_pkg;