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.3.12010000.3 2008/09/16 11:34:15 asgugupt ship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5:

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

58: 16-SEP-2008 asgugupt 115.25 Changed where Clause in action_creation procedure
59: when state_code is passed
60: */
61: --
62: c_package constant varchar2(31) := 'pay_yrend_reports_pkg.';
63: c_commit_num constant number := 1000;
64: --
65: g_debug boolean := hr_utility.debug_enabled;
66: --

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

77: /* year end pre-processor stores person id in serial number */
78: -- Query is added to fetch the tax_unit_id, year, EOY payroll_action_id to be
79: -- passed to the sqlstring to improve the performance.
80: --
81: select pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
82: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
83: ppa.payroll_action_id
84: into l_tax_unit_id,
85: l_assign_year,

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

78: -- Query is added to fetch the tax_unit_id, year, EOY payroll_action_id to be
79: -- passed to the sqlstring to improve the performance.
80: --
81: select pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
82: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
83: ppa.payroll_action_id
84: into l_tax_unit_id,
85: l_assign_year,
86: l_eoy_payroll_action_id

Line 91: pay_yrend_reports_pkg.get_parameter

87: from pay_payroll_actions ppa, /* EOY payroll action id */
88: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
89: where ppa1.payroll_action_id = pactid
90: and ppa.effective_date = to_date('31-DEC-'||
91: pay_yrend_reports_pkg.get_parameter
92: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
93: and ppa.report_type = 'YREND'
94: and pay_yrend_reports_pkg.get_parameter
95: ('T_U_ID',ppa1.legislative_parameters) =

Line 94: and pay_yrend_reports_pkg.get_parameter

90: and ppa.effective_date = to_date('31-DEC-'||
91: pay_yrend_reports_pkg.get_parameter
92: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
93: and ppa.report_type = 'YREND'
94: and pay_yrend_reports_pkg.get_parameter
95: ('T_U_ID',ppa1.legislative_parameters) =
96: pay_yrend_reports_pkg.get_parameter
97: ('TRANSFER_GRE',ppa.legislative_parameters);
98:

Line 96: pay_yrend_reports_pkg.get_parameter

92: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
93: and ppa.report_type = 'YREND'
94: and pay_yrend_reports_pkg.get_parameter
95: ('T_U_ID',ppa1.legislative_parameters) =
96: pay_yrend_reports_pkg.get_parameter
97: ('TRANSFER_GRE',ppa.legislative_parameters);
98:
99: sqlstr := 'select distinct to_number(act.serial_number)
100: from pay_assignment_actions act /* W2 Register Information */

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

222: l_procedure_name := 'action_creation';
223: hr_utility.set_location(l_procedure_name, 1);
224: --
225: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor
226: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),
227: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
228: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
229: ppa.payroll_action_id,
230: ppa.effective_date,

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

223: hr_utility.set_location(l_procedure_name, 1);
224: --
225: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor
226: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),
227: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
228: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
229: ppa.payroll_action_id,
230: ppa.effective_date,
231: ppa.start_date

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

224: --
225: -- Query has been added to fetch tax_unit_id, year to be passed to the cursor
226: select pay_yrend_reports_pkg.get_parameter('ASSIGN_SET',ppa1.legislative_parameters),
227: pay_yrend_reports_pkg.get_parameter('T_U_ID',ppa1.legislative_parameters),
228: pay_yrend_reports_pkg.get_parameter('P_YEAR',ppa1.legislative_parameters),
229: ppa.payroll_action_id,
230: ppa.effective_date,
231: ppa.start_date
232: ,hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters)

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

241: ,l_locality_code
242: from pay_payroll_actions ppa, /* W2 payroll action id */
243: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
244: where ppa1.payroll_action_id = pactid
245: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
246: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
247: and ppa.report_type = 'YREND'
248: and pay_yrend_reports_pkg.get_parameter
249: ('T_U_ID',ppa1.legislative_parameters) =

Line 248: and pay_yrend_reports_pkg.get_parameter

244: where ppa1.payroll_action_id = pactid
245: and ppa.effective_date = to_date('31-DEC-'|| pay_yrend_reports_pkg.get_parameter
246: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
247: and ppa.report_type = 'YREND'
248: and pay_yrend_reports_pkg.get_parameter
249: ('T_U_ID',ppa1.legislative_parameters) =
250: pay_yrend_reports_pkg.get_parameter
251: ('TRANSFER_GRE',ppa.legislative_parameters);
252:

Line 250: pay_yrend_reports_pkg.get_parameter

246: ('P_YEAR',ppa1.legislative_parameters), 'DD-MON-YYYY')
247: and ppa.report_type = 'YREND'
248: and pay_yrend_reports_pkg.get_parameter
249: ('T_U_ID',ppa1.legislative_parameters) =
250: pay_yrend_reports_pkg.get_parameter
251: ('TRANSFER_GRE',ppa.legislative_parameters);
252:
253: hr_utility.trace('l_assign_set= ' || l_assign_set);
254: hr_utility.trace('l_tax_unit_id=' || l_tax_unit_id);

Line 784: end pay_yrend_reports_pkg;

780: end if;
781: --
782: end deinitialize_code;
783: --
784: end pay_yrend_reports_pkg;