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.HR_US_W2_MT dependencies on HR_US_W2_MT

Line 1: PACKAGE body hr_us_w2_mt AS

1: PACKAGE body hr_us_w2_mt AS
2: /* $Header: pyusw2mt.pkb 120.13.12010000.3 2008/08/06 08:42:50 ubhat ship $ */
3:
4: /*
5: +=====================================================================+

Line 46: hr_us_w2_mt.get_parameter

42: procedure while selecting the l_eoy_payroll_action_id
43: Also changed to ppa.effective_date=ppa1.effective_date
44: instead of
45: ppa.effective_date = to_date('31-DEC-'||
46: hr_us_w2_mt.get_parameter
47: ('Year',ppa1.legislative_parameters), 'DD-MON-YYYY')
48: 115.11 11-DEC-01 meshah changed the assignment_action cursor for
49: performance reason. There was a dramatic performance
50: gain at inhouse. No each selection criteria are

Line 184: , to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters))

180:
181: begin
182: select ppa.payroll_action_id
183: , ppa.business_group_id
184: , to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters))
185: , ppa1.report_type
186: into l_eoy_payroll_action_id
187: ,l_business_group_id
188: ,l_year

Line 195: and hr_us_w2_mt.get_parameter

191: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
192: where ppa1.payroll_action_id = pactid
193: and ppa.effective_date = ppa1.effective_date
194: and ppa.report_type = 'YREND'
195: and hr_us_w2_mt.get_parameter
196: ('GRE_ID',ppa1.legislative_parameters) =
197: hr_us_w2_mt.get_parameter
198: ('TRANSFER_GRE',ppa.legislative_parameters);
199: exception

Line 197: hr_us_w2_mt.get_parameter

193: and ppa.effective_date = ppa1.effective_date
194: and ppa.report_type = 'YREND'
195: and hr_us_w2_mt.get_parameter
196: ('GRE_ID',ppa1.legislative_parameters) =
197: hr_us_w2_mt.get_parameter
198: ('TRANSFER_GRE',ppa.legislative_parameters);
199: exception
200: when others then
201: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

Line 2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),

2101: -- hr_utility.trace_on(null,'ORACLE');
2102: hr_utility.set_location('procpyr',1);
2103: hr_utility.trace('In the action cursor');
2104: Begin
2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),

Line 2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),

2102: hr_utility.set_location('procpyr',1);
2103: hr_utility.trace('In the action cursor');
2104: Begin
2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),

Line 2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),

2103: hr_utility.trace('In the action cursor');
2104: Begin
2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2111: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),

Line 2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),

2104: Begin
2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2111: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2112: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),

Line 2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),

2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2111: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2112: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2113: ppa.effective_date,

Line 2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),

2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2111: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2112: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2113: ppa.effective_date,
2114: ppa.payroll_action_id,

Line 2111: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),

2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2111: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2112: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2113: ppa.effective_date,
2114: ppa.payroll_action_id,
2115: ppa.start_date,

Line 2112: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),

2108: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2109: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2110: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2111: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2112: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2113: ppa.effective_date,
2114: ppa.payroll_action_id,
2115: ppa.start_date,
2116: ppa1.report_type

Line 2118: ,hr_us_w2_mt.get_parameter('LOCALITY',ppa1.legislative_parameters)

2114: ppa.payroll_action_id,
2115: ppa.start_date,
2116: ppa1.report_type
2117: --,ppa1.legislative_parameters
2118: ,hr_us_w2_mt.get_parameter('LOCALITY',ppa1.legislative_parameters)
2119: ,hr_us_w2_mt.get_parameter('PRINT_TERM',ppa1.legislative_parameters)
2120: into l_year,
2121: l_gre_id,
2122: l_org_id,

Line 2119: ,hr_us_w2_mt.get_parameter('PRINT_TERM',ppa1.legislative_parameters)

2115: ppa.start_date,
2116: ppa1.report_type
2117: --,ppa1.legislative_parameters
2118: ,hr_us_w2_mt.get_parameter('LOCALITY',ppa1.legislative_parameters)
2119: ,hr_us_w2_mt.get_parameter('PRINT_TERM',ppa1.legislative_parameters)
2120: into l_year,
2121: l_gre_id,
2122: l_org_id,
2123: l_loc_id,

Line 2139: and hr_us_w2_mt.get_parameter

2135: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
2136: where ppa1.payroll_action_id = pactid
2137: and ppa.effective_date = ppa1.effective_date
2138: and ppa.report_type = 'YREND'
2139: and hr_us_w2_mt.get_parameter
2140: ('GRE_ID',ppa1.legislative_parameters) =
2141: hr_us_w2_mt.get_parameter
2142: ('TRANSFER_GRE',ppa.legislative_parameters);
2143: Exception

Line 2141: hr_us_w2_mt.get_parameter

2137: and ppa.effective_date = ppa1.effective_date
2138: and ppa.report_type = 'YREND'
2139: and hr_us_w2_mt.get_parameter
2140: ('GRE_ID',ppa1.legislative_parameters) =
2141: hr_us_w2_mt.get_parameter
2142: ('TRANSFER_GRE',ppa.legislative_parameters);
2143: Exception
2144: when no_data_found then
2145: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

Line 2227: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),

2223:
2224: begin
2225:
2226: begin
2227: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2228: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),

Line 2228: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),

2224: begin
2225:
2226: begin
2227: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2228: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),

Line 2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),

2225:
2226: begin
2227: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2228: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),

Line 2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),

2226: begin
2227: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2228: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),

Line 2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),

2227: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2228: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),

Line 2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),

2228: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2236: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),

Line 2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),

2229: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2236: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2237: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),

Line 2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),

2230: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2236: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2237: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2238: ppa.effective_date,

Line 2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),

2231: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2236: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2237: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2238: ppa.effective_date,
2239: ppa.business_group_id

Line 2236: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),

2232: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2236: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2237: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2238: ppa.effective_date,
2239: ppa.business_group_id
2240: into l_year,

Line 2237: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),

2233: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2234: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2235: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2236: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2237: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2238: ppa.effective_date,
2239: ppa.business_group_id
2240: into l_year,
2241: l_gre_id,

Line 2368: end hr_us_w2_mt;

2364: return par_value;
2365: --
2366: end get_parameter;
2367:
2368: end hr_us_w2_mt;