DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on PAY_MAGTAPE_GENERIC

Line 296: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');

292: --{
293: --
294: -- Fetch all Context or Parameters set at the Transmitter Cursor
295: --
296: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
297: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
298: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
299: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
300:

Line 297: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

293: --
294: -- Fetch all Context or Parameters set at the Transmitter Cursor
295: --
296: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
297: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
298: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
299: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
300:
301: l_tax_unit_id := p_tax_unit_id;

Line 298: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');

294: -- Fetch all Context or Parameters set at the Transmitter Cursor
295: --
296: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
297: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
298: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
299: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
300:
301: l_tax_unit_id := p_tax_unit_id;
302: l_payroll_action_id := p_payroll_action_id;

Line 299: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');

295: --
296: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
297: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
298: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
299: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
300:
301: l_tax_unit_id := p_tax_unit_id;
302: l_payroll_action_id := p_payroll_action_id;
303: l_date_earned := p_date_earned;

Line 310: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');

306:
307: --
308: -- Fetch SRS Parameter
309: --
310: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
311: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
312:
313: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
314:

Line 311: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');

307: --
308: -- Fetch SRS Parameter
309: --
310: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
311: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
312:
313: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
314:
315: --

Line 313: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');

309: --
310: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
311: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
312:
313: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
314:
315: --
316: -- Fetch Archived Values of various DBIs used in submitter Record
317: --

Line 345: input_sbmtr_1 := pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID');

341: /* =========================================================
342: Get Submitted Information to be used for extracting MMREF-1 RA record type
343: ========================================================== */
344: input_sbmtr_name := 'ER_ADDRESS';
345: input_sbmtr_1 := pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID');
346: input_sbmtr_validiate_flag := 'Y';
347: sbmtr_exclude_output_flag := 'N';
348:
349: submitter_data := pay_us_reporting_utils_pkg.get_item_data(

Line 800: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');

796: --{
797: --
798: -- Fetch all Context or Parameters set at the Transmitter Cursor
799: --
800: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
801: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
802: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
803: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
804:

Line 801: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

797: --
798: -- Fetch all Context or Parameters set at the Transmitter Cursor
799: --
800: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
801: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
802: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
803: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
804:
805: l_tax_unit_id := p_tax_unit_id;

Line 802: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');

798: -- Fetch all Context or Parameters set at the Transmitter Cursor
799: --
800: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
801: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
802: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
803: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
804:
805: l_tax_unit_id := p_tax_unit_id;
806: l_payroll_action_id := p_payroll_action_id;

Line 803: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');

799: --
800: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
801: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
802: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
803: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
804:
805: l_tax_unit_id := p_tax_unit_id;
806: l_payroll_action_id := p_payroll_action_id;
807: l_date_earned := p_date_earned;

Line 814: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');

810:
811: --
812: -- Fetch SRS Parameter
813: --
814: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
815: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
816:
817: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
818:

Line 815: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');

811: --
812: -- Fetch SRS Parameter
813: --
814: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
815: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
816:
817: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
818:
819: i := 0;

Line 817: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');

813: --
814: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
815: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
816:
817: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
818:
819: i := 0;
820: --
821: -- Fetch Archived Values of various DBIs used in submitter Record

Line 1657: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');

1653:
1654: --
1655: -- Fetch SRS Parameter
1656: --
1657: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
1658: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
1659:
1660: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
1661:

Line 1658: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');

1654: --
1655: -- Fetch SRS Parameter
1656: --
1657: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
1658: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
1659:
1660: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
1661:
1662: ltr_ue_name_table.delete;

Line 1660: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');

1656: --
1657: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
1658: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
1659:
1660: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
1661:
1662: ltr_ue_name_table.delete;
1663: i := 0;
1664: --