DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on PAY_MAGTAPE_GENERIC

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

322: --{
323: --
324: -- Fetch all Context or Parameters set at the Transmitter Cursor
325: --
326: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
327: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
328: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
329: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
330:

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

323: --
324: -- Fetch all Context or Parameters set at the Transmitter Cursor
325: --
326: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
327: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
328: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
329: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
330:
331: l_tax_unit_id := p_tax_unit_id;

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

324: -- Fetch all Context or Parameters set at the Transmitter Cursor
325: --
326: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
327: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
328: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
329: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
330:
331: l_tax_unit_id := p_tax_unit_id;
332: l_payroll_action_id := p_payroll_action_id;

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

325: --
326: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
327: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
328: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
329: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
330:
331: l_tax_unit_id := p_tax_unit_id;
332: l_payroll_action_id := p_payroll_action_id;
333: l_date_earned := p_date_earned;

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

336:
337: --
338: -- Fetch SRS Parameter
339: --
340: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
341: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
342:
343: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
344:

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

337: --
338: -- Fetch SRS Parameter
339: --
340: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
341: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
342:
343: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
344:
345: --

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

339: --
340: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
341: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
342:
343: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
344:
345: --
346: -- Fetch Archived Values of various DBIs used in submitter Record
347: --

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

371: /* =========================================================
372: Get Submitted Information to be used for extracting MMREF-1 RA record type
373: ========================================================== */
374: input_sbmtr_name := 'ER_ADDRESS';
375: input_sbmtr_1 := pay_magtape_generic.get_parameter_value('TRANSFER_TRANS_LEGAL_CO_ID');
376: input_sbmtr_validiate_flag := 'Y';
377: sbmtr_exclude_output_flag := 'N';
378:
379: submitter_data := pay_us_reporting_utils_pkg.get_item_data(

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

830: --{
831: --
832: -- Fetch all Context or Parameters set at the Transmitter Cursor
833: --
834: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
835: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
836: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
837: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
838:

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

831: --
832: -- Fetch all Context or Parameters set at the Transmitter Cursor
833: --
834: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
835: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
836: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
837: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
838:
839: l_tax_unit_id := p_tax_unit_id;

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

832: -- Fetch all Context or Parameters set at the Transmitter Cursor
833: --
834: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
835: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
836: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
837: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
838:
839: l_tax_unit_id := p_tax_unit_id;
840: /* Bug 7438273 Start */

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

833: --
834: --l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
835: --l_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
836: --l_date_earned := pay_magtape_generic.get_parameter_value('DATE_EARNED');
837: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
838:
839: l_tax_unit_id := p_tax_unit_id;
840: /* Bug 7438273 Start */
841: l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');

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

837: --l_reporting_date := '31-DEC-'||pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
838:
839: l_tax_unit_id := p_tax_unit_id;
840: /* Bug 7438273 Start */
841: l_tax_unit_id := pay_magtape_generic.get_parameter_value('TAX_UNIT_ID');
842: /* Bug 7438273 End */
843: l_payroll_action_id := p_payroll_action_id;
844: l_date_earned := p_date_earned;
845: l_reporting_date := '31-DEC-'||p_reporting_year;

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

847:
848: --
849: -- Fetch SRS Parameter
850: --
851: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
852: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
853:
854: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
855:

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

848: --
849: -- Fetch SRS Parameter
850: --
851: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
852: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
853:
854: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
855:
856: i := 0;

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

850: --
851: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
852: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
853:
854: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
855:
856: i := 0;
857: --
858: -- Fetch Archived Values of various DBIs used in submitter Record

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

1737:
1738: --
1739: -- Fetch SRS Parameter
1740: --
1741: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
1742: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
1743:
1744: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
1745:

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

1738: --
1739: -- Fetch SRS Parameter
1740: --
1741: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
1742: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
1743:
1744: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
1745:
1746: ltr_ue_name_table.delete;

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

1740: --
1741: l_srs_trns_pin := pay_magtape_generic.get_parameter_value('TRNS_PIN');
1742: l_srs_trns_tlcn := pay_magtape_generic.get_parameter_value('TRNS_TLCN');
1743:
1744: l_input_report_qualifier := pay_magtape_generic.get_parameter_value('TRANSFER_STATE');
1745:
1746: ltr_ue_name_table.delete;
1747: i := 0;
1748: --