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.22 2011/11/25 05:38:35 pkoduri 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 193: , to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters))

189:
190: begin
191: select ppa.payroll_action_id
192: , ppa.business_group_id
193: , to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters))
194: , ppa1.report_type
195: into l_eoy_payroll_action_id
196: ,l_business_group_id
197: ,l_year

Line 204: and hr_us_w2_mt.get_parameter

200: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
201: where ppa1.payroll_action_id = pactid
202: and ppa.effective_date = ppa1.effective_date
203: and ppa.report_type = 'YREND'
204: and hr_us_w2_mt.get_parameter
205: ('GRE_ID',ppa1.legislative_parameters) =
206: hr_us_w2_mt.get_parameter
207: ('TRANSFER_GRE',ppa.legislative_parameters);
208: exception

Line 206: hr_us_w2_mt.get_parameter

202: and ppa.effective_date = ppa1.effective_date
203: and ppa.report_type = 'YREND'
204: and hr_us_w2_mt.get_parameter
205: ('GRE_ID',ppa1.legislative_parameters) =
206: hr_us_w2_mt.get_parameter
207: ('TRANSFER_GRE',ppa.legislative_parameters);
208: exception
209: when others then
210: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

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

2202: -- hr_utility.trace_on(null,'ORACLE');
2203: hr_utility.set_location('procpyr',1);
2204: hr_utility.trace('In the action cursor');
2205: Begin
2206: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2207: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2208: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),

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

2203: hr_utility.set_location('procpyr',1);
2204: hr_utility.trace('In the action cursor');
2205: Begin
2206: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2207: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2208: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2211: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),

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

2204: hr_utility.trace('In the action cursor');
2205: Begin
2206: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2207: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2208: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2211: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2212: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),

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

2205: Begin
2206: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2207: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2208: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2211: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2212: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2213: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),

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

2206: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2207: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2208: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2211: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2212: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2213: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2214: ppa.effective_date,

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

2207: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2208: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2211: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2212: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2213: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2214: ppa.effective_date,
2215: ppa.payroll_action_id,

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

2208: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),
2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2211: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2212: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2213: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2214: ppa.effective_date,
2215: ppa.payroll_action_id,
2216: ppa.start_date,

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

2209: to_number(hr_us_w2_mt.get_parameter('LOC_ID',ppa1.legislative_parameters)),
2210: to_number(hr_us_w2_mt.get_parameter('PER_ID',ppa1.legislative_parameters)),
2211: hr_us_w2_mt.get_parameter('SSN',ppa1.legislative_parameters),
2212: hr_us_w2_mt.get_parameter('STATE',ppa1.legislative_parameters),
2213: to_number(hr_us_w2_mt.get_parameter('ASG_SET',ppa1.legislative_parameters)),
2214: ppa.effective_date,
2215: ppa.payroll_action_id,
2216: ppa.start_date,
2217: ppa1.report_type

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

2215: ppa.payroll_action_id,
2216: ppa.start_date,
2217: ppa1.report_type
2218: --,ppa1.legislative_parameters
2219: ,hr_us_w2_mt.get_parameter('LOCALITY',ppa1.legislative_parameters)
2220: ,hr_us_w2_mt.get_parameter('PRINT_TERM',ppa1.legislative_parameters)
2221: into l_year,
2222: l_gre_id,
2223: l_org_id,

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

2216: ppa.start_date,
2217: ppa1.report_type
2218: --,ppa1.legislative_parameters
2219: ,hr_us_w2_mt.get_parameter('LOCALITY',ppa1.legislative_parameters)
2220: ,hr_us_w2_mt.get_parameter('PRINT_TERM',ppa1.legislative_parameters)
2221: into l_year,
2222: l_gre_id,
2223: l_org_id,
2224: l_loc_id,

Line 2240: and hr_us_w2_mt.get_parameter

2236: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
2237: where ppa1.payroll_action_id = pactid
2238: and ppa.effective_date = ppa1.effective_date
2239: and ppa.report_type = 'YREND'
2240: and hr_us_w2_mt.get_parameter
2241: ('GRE_ID',ppa1.legislative_parameters) =
2242: hr_us_w2_mt.get_parameter
2243: ('TRANSFER_GRE',ppa.legislative_parameters);
2244: Exception

Line 2242: hr_us_w2_mt.get_parameter

2238: and ppa.effective_date = ppa1.effective_date
2239: and ppa.report_type = 'YREND'
2240: and hr_us_w2_mt.get_parameter
2241: ('GRE_ID',ppa1.legislative_parameters) =
2242: hr_us_w2_mt.get_parameter
2243: ('TRANSFER_GRE',ppa.legislative_parameters);
2244: Exception
2245: when no_data_found then
2246: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

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

2324:
2325: begin
2326:
2327: begin
2328: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2329: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2330: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),

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

2325: begin
2326:
2327: begin
2328: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2329: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2330: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),

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

2326:
2327: begin
2328: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2329: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2330: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),

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

2327: begin
2328: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2329: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2330: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),

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

2328: select hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
2329: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2330: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2336: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),

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

2329: hr_us_w2_mt.get_parameter('GRE_ID',ppa.legislative_parameters),
2330: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2336: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2337: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),

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

2330: hr_us_w2_mt.get_parameter('ORG_ID',ppa.legislative_parameters),
2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2336: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2337: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2338: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),

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

2331: hr_us_w2_mt.get_parameter('LOC_ID',ppa.legislative_parameters),
2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2336: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2337: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2338: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2339: ppa.effective_date,

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

2332: hr_us_w2_mt.get_parameter('PER_ID',ppa.legislative_parameters),
2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2336: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2337: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2338: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2339: ppa.effective_date,
2340: ppa.business_group_id

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

2333: hr_us_w2_mt.get_parameter('SSN',ppa.legislative_parameters),
2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2336: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2337: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2338: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2339: ppa.effective_date,
2340: ppa.business_group_id
2341: into l_year,

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

2334: hr_us_w2_mt.get_parameter('STATE',ppa.legislative_parameters),
2335: hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters),
2336: hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters),
2337: hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters),
2338: to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'),
2339: ppa.effective_date,
2340: ppa.business_group_id
2341: into l_year,
2342: l_gre_id,

Line 2465: end hr_us_w2_mt;

2461: return par_value;
2462: --
2463: end get_parameter;
2464:
2465: end hr_us_w2_mt;