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_REP

Line 25: clauses, b) calls to hr_us_w2_rep

21: action procedures. Bug fixes:
22: 1850043, 1488083, 1894165.
23: 115.5 01-AUG-01 irgonzal Modified ACTION_CREATION cursor:
24: Removed a)'order by' and 'for update'
25: clauses, b) calls to hr_us_w2_rep
26: functions (added queries to retrieve
27: the values).
28: Modified RANGE_CURSOR and removed
29: calls to get_parameter function.

Line 33: hr_us_w2_rep.get_w2_arch_bal function.

29: calls to get_parameter function.
30:
31: 115.6 10-AUG-01 irgonzal Modified action_creation cursor and
32: removed reference to
33: hr_us_w2_rep.get_w2_arch_bal function.
34: 115.7 30-AUG-01 irgonzal Modified range_cursor and added
35: condition that includes :payroll_action_id
36: parameter.
37: Remove identation in SORT cursor.

Line 77: 115.22 10-SEP-02 kthirmiy Added hr_us_w2_rep.get_agent_tax_unit_id

73: procedures are called for Employee and Employer
74: W2. This is because state paramter is required
75: for Employer W2 and optional for Employee W2.
76: 115.21 19-Aug-02 fusman Added Puerto Rico W-2 report type.
77: 115.22 10-SEP-02 kthirmiy Added hr_us_w2_rep.get_agent_tax_unit_id
78: for Agent GRE setup validation check
79: in the range_cursor
80: 115.23 11-SEP-02 kthirmiy changed ppa1.report_type instead of ppa.report_type
81: changed update of mt.assignment_action_id instead of

Line 217: hr_us_w2_rep.get_agent_tax_unit_id ( l_business_group_id

213:
214: -- If it is not a PR W2 Report then only do the preprocess Agent GRE check
215: if l_report_type <> 'PRW2PAPER' then
216: hr_utility.trace('Checking for Preprocess Agent GRE setup');
217: hr_us_w2_rep.get_agent_tax_unit_id ( l_business_group_id
218: ,l_year
219: ,l_agent_tax_unit_id
220: ,l_error_mesg ) ;
221:

Line 2400: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),

2396: and pps.person_id = paf.person_id and hl.location_id = paf.location_id
2397: and hou.organization_id = paf.organization_id and hou.business_group_id + 0 = '''||l_bg_id||'''
2398: order by decode('''||l_sort1||''', ''Employee_Name'',
2399: /* Bug 8353425 */
2400: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2401: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2402: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2403: ''Organization'',hou.name, ''Location'',hl.location_code,
2404: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 2401: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),

2397: and hou.organization_id = paf.organization_id and hou.business_group_id + 0 = '''||l_bg_id||'''
2398: order by decode('''||l_sort1||''', ''Employee_Name'',
2399: /* Bug 8353425 */
2400: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2401: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2402: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2403: ''Organization'',hou.name, ''Location'',hl.location_code,
2404: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2405: /* Bug 8353425 */

Line 2402: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

2398: order by decode('''||l_sort1||''', ''Employee_Name'',
2399: /* Bug 8353425 */
2400: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2401: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2402: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2403: ''Organization'',hou.name, ''Location'',hl.location_code,
2404: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2405: /* Bug 8353425 */
2406: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),

Line 2404: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

2400: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2401: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2402: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2403: ''Organization'',hou.name, ''Location'',hl.location_code,
2404: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2405: /* Bug 8353425 */
2406: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2407: decode('''||l_sort2||''', ''Employee_Name'',
2408: /* Bug 8353425 */

Line 2406: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),

2402: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2403: ''Organization'',hou.name, ''Location'',hl.location_code,
2404: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2405: /* Bug 8353425 */
2406: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2407: decode('''||l_sort2||''', ''Employee_Name'',
2408: /* Bug 8353425 */
2409: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2410: ''SSN'',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),

Line 2409: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),

2405: /* Bug 8353425 */
2406: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2407: decode('''||l_sort2||''', ''Employee_Name'',
2408: /* Bug 8353425 */
2409: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2410: ''SSN'',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2411: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2412: ''Organization'',hou.name, ''Location'',hl.location_code,
2413: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 2410: ''SSN'',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),

2406: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2407: decode('''||l_sort2||''', ''Employee_Name'',
2408: /* Bug 8353425 */
2409: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2410: ''SSN'',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2411: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2412: ''Organization'',hou.name, ''Location'',hl.location_code,
2413: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2414: /* Bug 8353425 */

Line 2411: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

2407: decode('''||l_sort2||''', ''Employee_Name'',
2408: /* Bug 8353425 */
2409: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2410: ''SSN'',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2411: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2412: ''Organization'',hou.name, ''Location'',hl.location_code,
2413: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2414: /* Bug 8353425 */
2415: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),

Line 2413: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

2409: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2410: ''SSN'',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2411: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2412: ''Organization'',hou.name, ''Location'',hl.location_code,
2413: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2414: /* Bug 8353425 */
2415: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2416: decode('''||l_sort3||''', ''Employee_Name'',
2417: /* Bug 8353425 */

Line 2415: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),

2411: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2412: ''Organization'',hou.name, ''Location'',hl.location_code,
2413: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2414: /* Bug 8353425 */
2415: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2416: decode('''||l_sort3||''', ''Employee_Name'',
2417: /* Bug 8353425 */
2418: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2419: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),

Line 2418: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),

2414: /* Bug 8353425 */
2415: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2416: decode('''||l_sort3||''', ''Employee_Name'',
2417: /* Bug 8353425 */
2418: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2419: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2420: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2421: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2422: /* Bug 8353425 */

Line 2419: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),

2415: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||''')),
2416: decode('''||l_sort3||''', ''Employee_Name'',
2417: /* Bug 8353425 */
2418: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2419: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2420: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2421: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2422: /* Bug 8353425 */
2423: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''))

Line 2420: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

2416: decode('''||l_sort3||''', ''Employee_Name'',
2417: /* Bug 8353425 */
2418: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2419: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2420: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2421: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2422: /* Bug 8353425 */
2423: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''))
2424: for update of mt.assignment_action_id' ;

Line 2421: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

2417: /* Bug 8353425 */
2418: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''),
2419: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2420: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2421: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2422: /* Bug 8353425 */
2423: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''))
2424: for update of mt.assignment_action_id' ;
2425:

Line 2423: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''))

2419: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2420: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2421: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2422: /* Bug 8353425 */
2423: hr_us_w2_rep.get_w2_employee_name(paf.person_id,'''||l_dt||'''))
2424: for update of mt.assignment_action_id' ;
2425:
2426: -- changed on 11sep02
2427: -- for update of paf.assignment_id';