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 623: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');

619: p_final_xml_string VARCHAR2(32767);
620: BEGIN
621: --{
622: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
623: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
624: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
625: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
626: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
627: --

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

620: BEGIN
621: --{
622: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
623: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
624: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
625: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
626: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
627: --
628: -- Following Procedure Call will form the RA Record Structure in XML format

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

621: --{
622: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
623: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
624: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
625: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
626: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
627: --
628: -- Following Procedure Call will form the RA Record Structure in XML format
629: --

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

622: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
623: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
624: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
625: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
626: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
627: --
628: -- Following Procedure Call will form the RA Record Structure in XML format
629: --
630: pay_us_w2_generic_extract.populate_arch_transmitter(

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

676: p_final_xml_string VARCHAR2(32767);
677: BEGIN
678: --{
679: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
680: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
681: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
682: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
683: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
684: --

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

677: BEGIN
678: --{
679: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
680: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
681: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
682: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
683: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
684: --
685: -- Following Procedure Call will form the RE Record Structure in XML format

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

678: --{
679: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
680: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
681: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
682: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
683: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
684: --
685: -- Following Procedure Call will form the RE Record Structure in XML format
686: --

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

679: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
680: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
681: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
682: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
683: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
684: --
685: -- Following Procedure Call will form the RE Record Structure in XML format
686: --
687: pay_us_w2_generic_extract.populate_arch_employer(

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

752: pay_action_interlocks pai,
753: pay_assignment_actions paa1,
754: pay_payroll_actions ppa1
755: where ppa.payroll_action_id = paa.payroll_action_id
756: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
757: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
758: and pai.locking_action_id = paa.assignment_action_id
759: and pai.locked_action_id = paa1.assignment_action_id
760: and paa1.payroll_action_id = ppa1.payroll_action_id

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

753: pay_assignment_actions paa1,
754: pay_payroll_actions ppa1
755: where ppa.payroll_action_id = paa.payroll_action_id
756: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
757: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
758: and pai.locking_action_id = paa.assignment_action_id
759: and pai.locked_action_id = paa1.assignment_action_id
760: and paa1.payroll_action_id = ppa1.payroll_action_id
761: and ppa1.report_type = 'YREND'

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

774: BEGIN
775: --{
776: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
777: HR_UTILITY_TRACE('Constructing XML for Employee ->');
778: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));
779: OPEN c_get_params;
780: FETCH c_get_params INTO p_ye_assignment_action_id,
781: p_tax_unit_id,
782: p_payroll_action_id,

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

788: p_locality_code,
789: p_state_abbreviation;
790: CLOSE c_get_params;
791: /*
792: p_tax_unit_id := pay_magtape_generic.get_parameter_value('YE_TAX_UNIT_ID');
793: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
794: p_assignment_action_id :=
795: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
796: p_ye_assignment_action_id :=

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

789: p_state_abbreviation;
790: CLOSE c_get_params;
791: /*
792: p_tax_unit_id := pay_magtape_generic.get_parameter_value('YE_TAX_UNIT_ID');
793: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
794: p_assignment_action_id :=
795: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
796: p_ye_assignment_action_id :=
797: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');

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

791: /*
792: p_tax_unit_id := pay_magtape_generic.get_parameter_value('YE_TAX_UNIT_ID');
793: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
794: p_assignment_action_id :=
795: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
796: p_ye_assignment_action_id :=
797: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
798: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
799: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');

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

793: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
794: p_assignment_action_id :=
795: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
796: p_ye_assignment_action_id :=
797: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
798: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
799: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
800: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');

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

794: p_assignment_action_id :=
795: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
796: p_ye_assignment_action_id :=
797: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
798: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
799: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
800: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');

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

795: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
796: p_ye_assignment_action_id :=
797: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
798: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
799: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
800: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
803: */

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

796: p_ye_assignment_action_id :=
797: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
798: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
799: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
800: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
803: */
804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');

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

797: pay_magtape_generic.get_parameter_value('YE_ASSIGNMENT_ACTION_ID');
798: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
799: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
800: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
803: */
804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));

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

798: p_assignment_id := pay_magtape_generic.get_parameter_value('EE_ASSIGNMENT_ID');
799: p_date_earned := pay_magtape_generic.get_parameter_value('EE_DATE_EARNED');
800: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
803: */
804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));