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_MAGTAPE_GENERIC

Line 560: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');

556: p_final_xml_string VARCHAR2(32767);
557: BEGIN
558: --{
559: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
560: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
561: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
562: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
563: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
564: --

Line 561: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

557: BEGIN
558: --{
559: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
560: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
561: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
562: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
563: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
564: --
565: -- Following Procedure Call will form the RA Record Structure in XML format

Line 562: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');

558: --{
559: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
560: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
561: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
562: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
563: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
564: --
565: -- Following Procedure Call will form the RA Record Structure in XML format
566: --

Line 563: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');

559: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
560: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
561: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
562: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
563: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
564: --
565: -- Following Procedure Call will form the RA Record Structure in XML format
566: --
567: pay_us_w2_generic_extract.populate_arch_transmitter(

Line 617: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');

613: p_final_xml_string VARCHAR2(32767);
614: BEGIN
615: --{
616: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
617: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
618: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
619: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
620: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
621: --

Line 618: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

614: BEGIN
615: --{
616: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
617: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
618: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
619: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
620: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
621: --
622: -- Following Procedure Call will form the RE Record Structure in XML format

Line 619: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');

615: --{
616: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
617: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
618: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
619: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
620: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
621: --
622: -- Following Procedure Call will form the RE Record Structure in XML format
623: --

Line 620: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');

616: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
617: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
618: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
619: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
620: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
621: --
622: -- Following Procedure Call will form the RE Record Structure in XML format
623: --
624: pay_us_w2_generic_extract.populate_arch_employer(

Line 693: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

689: pay_action_interlocks pai,
690: pay_assignment_actions paa1,
691: pay_payroll_actions ppa1
692: where ppa.payroll_action_id = paa.payroll_action_id
693: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
694: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
695: and pai.locking_action_id = paa.assignment_action_id
696: and pai.locked_action_id = paa1.assignment_action_id
697: and paa1.payroll_action_id = ppa1.payroll_action_id

Line 694: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

690: pay_assignment_actions paa1,
691: pay_payroll_actions ppa1
692: where ppa.payroll_action_id = paa.payroll_action_id
693: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
694: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
695: and pai.locking_action_id = paa.assignment_action_id
696: and pai.locked_action_id = paa1.assignment_action_id
697: and paa1.payroll_action_id = ppa1.payroll_action_id
698: and ppa1.report_type = 'YREND'

Line 715: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));

711: BEGIN
712: --{
713: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
714: HR_UTILITY_TRACE('Constructing XML for Employee ->');
715: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));
716: OPEN c_get_params;
717: FETCH c_get_params INTO p_ye_assignment_action_id,
718: p_tax_unit_id,
719: p_payroll_action_id,

Line 729: p_tax_unit_id := pay_magtape_generic.get_parameter_value('YE_TAX_UNIT_ID');

725: p_locality_code,
726: p_state_abbreviation;
727: CLOSE c_get_params;
728: /*
729: p_tax_unit_id := pay_magtape_generic.get_parameter_value('YE_TAX_UNIT_ID');
730: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
731: p_assignment_action_id :=
732: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
733: p_ye_assignment_action_id :=

Line 730: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

726: p_state_abbreviation;
727: CLOSE c_get_params;
728: /*
729: p_tax_unit_id := pay_magtape_generic.get_parameter_value('YE_TAX_UNIT_ID');
730: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
731: p_assignment_action_id :=
732: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
733: p_ye_assignment_action_id :=
734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');

Line 732: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');

728: /*
729: p_tax_unit_id := pay_magtape_generic.get_parameter_value('YE_TAX_UNIT_ID');
730: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
731: p_assignment_action_id :=
732: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
733: p_ye_assignment_action_id :=
734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');

Line 734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');

730: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
731: p_assignment_action_id :=
732: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
733: p_ye_assignment_action_id :=
734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
737: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
738: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');

Line 735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');

731: p_assignment_action_id :=
732: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
733: p_ye_assignment_action_id :=
734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
737: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
738: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
739: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');

Line 736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');

732: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
733: p_ye_assignment_action_id :=
734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
737: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
738: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
739: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
740: */

Line 737: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');

733: p_ye_assignment_action_id :=
734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
737: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
738: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
739: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
740: */
741: HR_UTILITY_TRACE('Prameter Used for Employee level XML');

Line 738: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');

734: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
737: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
738: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
739: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
740: */
741: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
742: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));

Line 739: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');

735: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
736: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
737: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
738: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
739: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
740: */
741: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
742: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
743: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));