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_PSD_XML dependencies on PAY_MAGTAPE_GENERIC

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

459: p_final_xml_string VARCHAR2(32767);
460: BEGIN
461: --{
462: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
463: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
464: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
465: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
466: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
467: --

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

460: BEGIN
461: --{
462: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
463: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
464: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
465: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
466: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
467: --
468: -- Following Procedure Call will form the RA Record Structure in XML format

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

461: --{
462: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
463: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
464: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
465: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
466: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
467: --
468: -- Following Procedure Call will form the RA Record Structure in XML format
469: --

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

462: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
463: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
464: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
465: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
466: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
467: --
468: -- Following Procedure Call will form the RA Record Structure in XML format
469: --
470: pay_us_psd_generic_extract.populate_arch_transmitter(

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

515: BEGIN
516: --{
517: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
518:
519: --p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
520:
521: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
522: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
523: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');

Line 521: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');

517: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
518:
519: --p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
520:
521: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
522: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
523: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
524: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
525: --

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

518:
519: --p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
520:
521: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
522: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
523: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
524: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
525: --
526: -- Following Procedure Call will form the RE Record Structure in XML format

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

519: --p_tax_unit_id := pay_magtape_generic.get_parameter_value('TR_TAX_UNIT_ID');
520:
521: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
522: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
523: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
524: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
525: --
526: -- Following Procedure Call will form the RE Record Structure in XML format
527: --

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

520:
521: p_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
522: p_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
523: p_date_earned := pay_magtape_generic.get_parameter_value('TR_DATE_EARNED');
524: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
525: --
526: -- Following Procedure Call will form the RE Record Structure in XML format
527: --
528:

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

590: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters) */ --Modified for Bug 14799833
591: FROM pay_assignment_actions paa,
592: pay_payroll_actions ppa
593: where ppa.payroll_action_id = paa.payroll_action_id
594: -- and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
595: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
596: and ppa.report_type in ('PSD_MAG_XML')
597: and ppa.action_type = 'X'
598: and ppa.action_status = 'P';

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

591: FROM pay_assignment_actions paa,
592: pay_payroll_actions ppa
593: where ppa.payroll_action_id = paa.payroll_action_id
594: -- and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
595: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
596: and ppa.report_type in ('PSD_MAG_XML')
597: and ppa.action_type = 'X'
598: and ppa.action_status = 'P';
599:

Line 610: and paa.assignment_action_id = act_id--pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

606: ppa.effective_date
607: FROM pay_assignment_actions paa,
608: pay_payroll_actions ppa
609: where ppa.payroll_action_id = paa.payroll_action_id
610: and paa.assignment_action_id = act_id--pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
611: and ppa.report_type ='YREND'
612: and ppa.action_type = 'X';
613:
614: CURSOR c_get_report_params_ytd IS

Line 619: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

615: SELECT pay_us_psd_xml.get_parameter('TRANSFER_REPORTING_YEAR',ppa.legislative_parameters),
616: pay_us_psd_xml.get_parameter('TRANSFER_STATE',ppa.legislative_parameters),
617: pay_us_psd_xml.get_parameter('TRANSFER_PERIOD_TYPE',ppa.legislative_parameters)
618: FROM pay_payroll_actions ppa
619: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
620: and ppa.report_type in ('PSD_MAG_XML')
621: and ppa.action_type = 'X'
622: and ppa.action_status = 'P';
623:

Line 630: WHERE AA.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

626: FROM pay_assignment_actions AA,
627: pay_payroll_actions PA,
628: pay_assignment_actions AA1,
629: pay_payroll_actions PA1
630: WHERE AA.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
631: AND AA.payroll_action_id = PA.payroll_action_id
632: AND AA.tax_unit_id = AA1.tax_unit_id
633: AND AA1.assignment_id = AA.assignment_id
634: AND AA1.payroll_action_id = PA1.payroll_action_id

Line 642: where pai.locking_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');

638: and to_char(pa1.effective_date, 'YYYY') = pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(PA.payroll_action_id,
639: 'TRANSFER_REPORTING_YEAR') */
640: SELECT pai.locked_action_id
641: FROM pay_action_interlocks pai
642: where pai.locking_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
643:
644: /*cursor c_get_jurisdiction (p_assignment_id number
645: ,p_tax_unit_id number) is
646: select puar.jurisdiction_code

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

662: BEGIN
663: --{
664: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
665: HR_UTILITY_TRACE('Constructing XML for Employee ->');
666: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));
667: HR_UTILITY_TRACE('TRANSFER_PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')));
668: HR_UTILITY_TRACE('PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')));
669:
670: --Added for Bug 14799833

Line 667: HR_UTILITY_TRACE('TRANSFER_PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')));

663: --{
664: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
665: HR_UTILITY_TRACE('Constructing XML for Employee ->');
666: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));
667: HR_UTILITY_TRACE('TRANSFER_PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')));
668: HR_UTILITY_TRACE('PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')));
669:
670: --Added for Bug 14799833
671:

Line 668: HR_UTILITY_TRACE('PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')));

664: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
665: HR_UTILITY_TRACE('Constructing XML for Employee ->');
666: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));
667: HR_UTILITY_TRACE('TRANSFER_PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')));
668: HR_UTILITY_TRACE('PAYROLL_ACTION_ID :'||to_char(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')));
669:
670: --Added for Bug 14799833
671:
672: OPEN c_get_report_params_ytd;

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

725: END IF;
726:
727:
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:
727:
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_period_type := pay_magtape_generic.get_parameter_value('TRANSFER_PERIOD_TYPE');

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_period_type := pay_magtape_generic.get_parameter_value('TRANSFER_PERIOD_TYPE');
739:

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_period_type := pay_magtape_generic.get_parameter_value('TRANSFER_PERIOD_TYPE');
739:
740: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');

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_period_type := pay_magtape_generic.get_parameter_value('TRANSFER_PERIOD_TYPE');
739:
740: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
741: */

Line 738: p_period_type := pay_magtape_generic.get_parameter_value('TRANSFER_PERIOD_TYPE');

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_period_type := pay_magtape_generic.get_parameter_value('TRANSFER_PERIOD_TYPE');
739:
740: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
741: */
742:

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

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_period_type := pay_magtape_generic.get_parameter_value('TRANSFER_PERIOD_TYPE');
739:
740: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
741: */
742:
743: select pay_magtape_generic.get_parameter_value('TRANSFER_EE_JD_CODE')
744: into p_jurisdiction_code

Line 743: select pay_magtape_generic.get_parameter_value('TRANSFER_EE_JD_CODE')

739:
740: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
741: */
742:
743: select pay_magtape_generic.get_parameter_value('TRANSFER_EE_JD_CODE')
744: into p_jurisdiction_code
745: from dual;
746:
747: HR_UTILITY_TRACE('Prameter Used for Employee level XML');

Line 758: get_report_parameters( to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')),--Modified for Bug#14799833

754: HR_UTILITY_TRACE('p_state_abbreviation :'||p_state_abbreviation);
755: HR_UTILITY_TRACE('p_period_type :'||p_period_type);
756: HR_UTILITY_TRACE('p_jurisdiction_code :'||p_jurisdiction_code);
757:
758: get_report_parameters( to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')),--Modified for Bug#14799833
759: l_year_start,
760: l_year_end,
761: l_state_abbrev,
762: l_state_code,

Line 2932: IF pay_magtape_generic.get_parameter_value

2928: hr_utility.trace('p_assactid is : ' || to_char(p_assactid));
2929:
2930:
2931: --Added by skchalla for PSD year end reporting bug 14799833
2932: IF pay_magtape_generic.get_parameter_value
2933: ('TRANSFER_PERIOD_TYPE') <> 'Yearly' Then
2934:
2935: SELECT aa.assignment_id,
2936: pay_magtape_generic.date_earned (p_effective_date,aa.assignment_id),

Line 2936: pay_magtape_generic.date_earned (p_effective_date,aa.assignment_id),

2932: IF pay_magtape_generic.get_parameter_value
2933: ('TRANSFER_PERIOD_TYPE') <> 'Yearly' Then
2934:
2935: SELECT aa.assignment_id,
2936: pay_magtape_generic.date_earned (p_effective_date,aa.assignment_id),
2937: aa.tax_unit_id,
2938: aa.chunk_number,
2939: aa.payroll_action_id
2940: into l_asgid,