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.0.12000000.1 2007/02/23 10:17:11 sackumar noship $
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 85: ('pay_us_mmref_local_xml.bal_db_item - opening cursor', 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

440: l_gre_id := -1;
441: l_error_flag := 'N';
442:
443: -- Get the report parameters. These define the report being run.
444: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 10);
445: get_report_parameters( p_pactid,
446: l_year_start,
447: l_year_end,
448: l_state_abbrev,

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

457:
458: --Currently all reports group by GRE
459: l_group_by_gre := TRUE;
460: --Open the appropriate cursor
461: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 20);
462: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);
463: IF l_report_type = 'W2_MAG_XML' THEN
464: OPEN c_local(l_state_code,
465: l_locality_code);

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

471: l_effective_end_date,
472: l_assignment_action_id,
473: l_w2_box17;
474: hr_utility.set_location(
475: 'pay_us_mmref_local_xml.create_assignement_act', 40);
476: EXIT WHEN c_local%NOTFOUND;
477: --Based on the groupin criteria, check if the record is the same
478: --as the previous record.
479: --Grouping by GRE requires a unique person/GRE combination for

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

489: ) THEN
490: --{
491: --Do Nothing
492: hr_utility.set_location(
493: 'pay_us_mmref_local_xml.create_assignement_act', 50);
494: NULL;
495: --}
496: ELSE
497: --{

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

505: SELECT pay_assignment_actions_s.nextval
506: INTO lockingactid
507: FROM dual;
508: hr_utility.set_location(
509: 'pay_us_mmref_local_xml.create_assignement_act', 60);
510: hr_nonrun_asact.insact( lockingactid,
511: l_assignment_id,
512: p_pactid,
513: p_chunk,

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

512: p_pactid,
513: p_chunk,
514: l_tax_unit_id);
515: hr_utility.set_location(
516: 'pay_us_mmref_local_xml.create_assignement_act', 70);
517: hr_nonrun_asact.insint(lockingactid,
518: l_assignment_action_id);
519: hr_utility.set_location(
520: 'pay_us_mmref_local_xml.create_assignement_act', 80);

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

516: 'pay_us_mmref_local_xml.create_assignement_act', 70);
517: hr_nonrun_asact.insint(lockingactid,
518: l_assignment_action_id);
519: hr_utility.set_location(
520: 'pay_us_mmref_local_xml.create_assignement_act', 80);
521: hr_utility.trace('Interlock Created - ');
522: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
523: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
524: --Store the current person/GRE for comparision during the

Line 683: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',

679: ppa.payroll_action_id, -- Main Payroll Action Id
680: paa.assignment_action_id, -- Main Asg Action Id
681: paa.assignment_id,
682: ppa.effective_date, -- Date Earned
683: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
684: ppa.legislative_parameters),
685: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
686: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
687: FROM pay_assignment_actions paa,

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

681: paa.assignment_id,
682: ppa.effective_date, -- Date Earned
683: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
684: ppa.legislative_parameters),
685: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
686: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
687: FROM pay_assignment_actions paa,
688: pay_payroll_actions ppa,
689: pay_action_interlocks pai,

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

682: ppa.effective_date, -- Date Earned
683: pay_us_mmref_local_xml.get_parameter('TRANSFER_REPORTING_YEAR',
684: ppa.legislative_parameters),
685: pay_us_mmref_local_xml.get_parameter('LC',ppa.legislative_parameters),
686: pay_us_mmref_local_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters)
687: FROM pay_assignment_actions paa,
688: pay_payroll_actions ppa,
689: pay_action_interlocks pai,
690: pay_assignment_actions paa1,

Line 871: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';

867: end get_parameter;
868:
869: BEGIN
870: -- hr_utility.trace_on(null, 'USLOCALW2');
871: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';
872: g_debug := hr_utility.debug_enabled;
873: g_document_type := 'LOCAL_W2_XML';
874:
875: END pay_us_mmref_local_xml;

Line 875: END pay_us_mmref_local_xml;

871: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';
872: g_debug := hr_utility.debug_enabled;
873: g_document_type := 'LOCAL_W2_XML';
874:
875: END pay_us_mmref_local_xml;