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_US_MMREF_LOCAL_XML dependencies on PAY_US_MMREF_LOCAL_XML

Line 1: PACKAGE BODY pay_us_mmref_local_xml AS

1: PACKAGE BODY pay_us_mmref_local_xml AS
2: /*REM $Header: payusw2mmref1xml.pkb 120.3.12020000.1 2012/06/28 16:39:10 appldev ship $
3: REM +======================================================================+
4: REM | Copyright (c) 1997 Oracle Corporation |
5: REM | Redwood Shores, California, USA |

Line 9: REM pay_us_mmref_local_xml

5: REM | Redwood Shores, California, USA |
6: REM | All rights reserved. |
7: REM +======================================================================+
8: REM Name
9: REM pay_us_mmref_local_xml
10: REM File
11: REM payusw2mmref1xml.pkb
12: REM
13: REM Purpose

Line 86: ('pay_us_mmref_local_xml.bal_db_item - opening cursor', 10);

82:
83: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
84: BEGIN
85: hr_utility.set_location
86: ('pay_us_mmref_local_xml.bal_db_item - opening cursor', 10);
87: -- Open the cursor
88: OPEN csr_defined_balance;
89: -- Fetch the value
90: FETCH csr_defined_balance

Line 95: ('pay_us_mmref_local_xml.bal_db_item - no rows found from cursor', 20);

91: INTO l_defined_balance_id;
92: IF csr_defined_balance%NOTFOUND THEN
93: CLOSE csr_defined_balance;
94: hr_utility.set_location
95: ('pay_us_mmref_local_xml.bal_db_item - no rows found from cursor', 20);
96: hr_utility.raise_error;
97: ELSE
98: hr_utility.set_location
99: ('pay_us_mmref_local_xml.bal_db_item - fetched from cursor', 30);

Line 99: ('pay_us_mmref_local_xml.bal_db_item - fetched from cursor', 30);

95: ('pay_us_mmref_local_xml.bal_db_item - no rows found from cursor', 20);
96: hr_utility.raise_error;
97: ELSE
98: hr_utility.set_location
99: ('pay_us_mmref_local_xml.bal_db_item - fetched from cursor', 30);
100: CLOSE csr_defined_balance;
101: END IF;
102: -- Return the value to the call
103: RETURN (l_defined_balance_id);

Line 138: ('pay_us_mmref_local_xml.get_report_parameters', 10);

134: ) IS
135: l_state_code varchar2(200);
136: BEGIN
137: hr_utility.set_location
138: ('pay_us_mmref_local_xml.get_report_parameters', 10);
139: hr_utility.trace('Payroll_Action_Id '|| to_char(p_pactid));
140: SELECT ppa.start_date,
141: ppa.effective_date,
142: ppa.business_group_id,

Line 168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);

164: if p_locality_code = 'NULL' then
165: p_locality_code := l_state_code||'000-0000';
166: end if;
167: */
168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);
169: hr_utility.trace('Parameter Values ');
170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));

Line 178: ('pay_us_mmref_local_xml.get_report_parameters', 40);

174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);
176: hr_utility.trace('p_locality_code '|| p_locality_code);
177: hr_utility.set_location
178: ('pay_us_mmref_local_xml.get_report_parameters', 40);
179: EXCEPTION
180: WHEN OTHERS THEN
181: hr_utility.trace('get_report_parameters procedure Raised Exception ');
182: hr_utility.trace('ERROR '||substr(SQLERRM,1,40));

Line 212: ('pay_us_mmref_local_xml.get_balance_value', 10);

208: ) RETURN NUMBER IS
209: l_jurisdiction_code VARCHAR2(20);
210: BEGIN
211: hr_utility.set_location
212: ('pay_us_mmref_local_xml.get_balance_value', 10);
213: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
214: IF p_state_abbrev <> 'FED' THEN
215: SELECT jurisdiction_code
216: INTO l_jurisdiction_code

Line 220: ('pay_us_mmref_local_xml.get_balance_value', 15);

216: INTO l_jurisdiction_code
217: FROM pay_state_rules
218: WHERE state_code = p_state_abbrev;
219: hr_utility.set_location
220: ('pay_us_mmref_local_xml.get_balance_value', 15);
221: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
222: END IF;
223: hr_utility.trace(p_balance_name);
224: hr_utility.trace('Context');

Line 228: ('pay_us_mmref_local_xml.get_balance_value', 20);

224: hr_utility.trace('Context');
225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
227: hr_utility.set_location
228: ('pay_us_mmref_local_xml.get_balance_value', 20);
229: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
230: p_assignment_id,
231: p_effective_date);
232: END get_balance_value;

Line 258: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 10);

254: p_report_type VARCHAR2(200);
255: p_locality_code VARCHAR2(200);
256: BEGIN
257: -- hr_utility.trace_on(null,'LOCALXML');
258: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 10);
259:
260: get_report_parameters( p_pactid,
261: p_year_start,
262: p_year_end,

Line 269: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 20);

265: p_report_type,
266: p_business_group_id,
267: p_locality_code
268: );
269: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 20);
270:
271:
272: IF p_report_type = 'W2_MAG_XML' THEN
273: p_sqlstr := '

Line 319: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 40);

315: WHERE hoi.organization_id = paa.tax_unit_id
316: AND hoi.org_information_context = ''1099R Magnetic Report Rules''
317: )
318: ORDER BY to_number(paa.serial_number)';
319: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 40);
320: END IF;
321: hr_utility.trace( substr(p_sqlstr,1, 50));
322: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 50);
323: END range_cursor;

Line 322: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 50);

318: ORDER BY to_number(paa.serial_number)';
319: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 40);
320: END IF;
321: hr_utility.trace( substr(p_sqlstr,1, 50));
322: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 50);
323: END range_cursor;
324: --
325:
326: /****************************************************************************

Line 507: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 10);

503: l_gre_id := -1;
504: l_error_flag := 'N';
505:
506: -- Get the report parameters. These define the report being run.
507: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 10);
508: get_report_parameters( p_pactid,
509: l_year_start,
510: l_year_end,
511: l_state_abbrev,

Line 524: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 20);

520:
521: --Currently all reports group by GRE
522: l_group_by_gre := TRUE;
523: --Open the appropriate cursor
524: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 20);
525: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);
526: IF l_report_type = 'W2_MAG_XML' THEN
527: OPEN c_local(l_state_code,
528: l_locality_code);

Line 538: 'pay_us_mmref_local_xml.create_assignement_act', 40);

534: l_effective_end_date,
535: l_assignment_action_id,
536: l_w2_box17;
537: hr_utility.set_location(
538: 'pay_us_mmref_local_xml.create_assignement_act', 40);
539: EXIT WHEN c_local%NOTFOUND;
540: --Based on the groupin criteria, check if the record is the same
541: --as the previous record.
542: --Grouping by GRE requires a unique person/GRE combination for

Line 556: 'pay_us_mmref_local_xml.create_assignement_act', 50);

552: ) THEN
553: --{
554: --Do Nothing
555: hr_utility.set_location(
556: 'pay_us_mmref_local_xml.create_assignement_act', 50);
557: NULL;
558: --}
559: ELSE
560: --{

Line 572: 'pay_us_mmref_local_xml.create_assignement_act', 60);

568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid
570: FROM dual;
571: hr_utility.set_location(
572: 'pay_us_mmref_local_xml.create_assignement_act', 60);
573: hr_nonrun_asact.insact( lockingactid,
574: l_assignment_id,
575: p_pactid,
576: p_chunk,

Line 579: 'pay_us_mmref_local_xml.create_assignement_act', 70);

575: p_pactid,
576: p_chunk,
577: l_tax_unit_id);
578: hr_utility.set_location(
579: 'pay_us_mmref_local_xml.create_assignement_act', 70);
580: hr_nonrun_asact.insint(lockingactid,
581: l_assignment_action_id);
582: hr_utility.set_location(
583: 'pay_us_mmref_local_xml.create_assignement_act', 80);

Line 583: 'pay_us_mmref_local_xml.create_assignement_act', 80);

579: 'pay_us_mmref_local_xml.create_assignement_act', 70);
580: hr_nonrun_asact.insint(lockingactid,
581: l_assignment_action_id);
582: hr_utility.set_location(
583: 'pay_us_mmref_local_xml.create_assignement_act', 80);
584: hr_utility.trace('Interlock Created - ');
585: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
586: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
587: --Store the current person/GRE for comparision during the

Line 746: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',

742: ppa.payroll_action_id, -- Main Payroll Action Id
743: paa.assignment_action_id, -- Main Asg Action Id
744: paa.assignment_id,
745: ppa.effective_date, -- Date Earned
746: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
747: ppa.legislative_parameters),
748: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
749: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
750: FROM pay_assignment_actions paa,

Line 748: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),

744: paa.assignment_id,
745: ppa.effective_date, -- Date Earned
746: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
747: ppa.legislative_parameters),
748: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
749: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
750: FROM pay_assignment_actions paa,
751: pay_payroll_actions ppa,
752: pay_action_interlocks pai,

Line 749: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)

745: ppa.effective_date, -- Date Earned
746: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
747: ppa.legislative_parameters),
748: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
749: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
750: FROM pay_assignment_actions paa,
751: pay_payroll_actions ppa,
752: pay_action_interlocks pai,
753: pay_assignment_actions paa1,

Line 988: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';

984:
985: END local_non_pa_emp_data;
986: BEGIN
987: -- hr_utility.trace_on(null, 'USLOCALW2');
988: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';
989: g_debug := hr_utility.debug_enabled;
990: g_document_type := 'LOCAL_W2_XML';
991:
992: END pay_us_mmref_local_xml;

Line 992: END pay_us_mmref_local_xml;

988: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';
989: g_debug := hr_utility.debug_enabled;
990: g_document_type := 'LOCAL_W2_XML';
991:
992: END pay_us_mmref_local_xml;