DBA Data[Home] [Help]

APPS.PAY_CA_T4_CANCEL_MAG dependencies on PAY_MAGTAPE_GENERIC

Line 703: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

699: pay_action_interlocks int,
700: pay_payroll_actions ppa
701: where int.locking_action_id = paa.assignment_action_id
702: and paa1.assignment_action_id = int.locked_action_id
703: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
704: and ppa.payroll_action_id = paa1.payroll_action_id
705: and ppa.report_type in ('T4','CAEOY_T4_AMEND_PP');
706: exception
707: when no_data_found then

Line 724: l_return := pay_magtape_generic.get_parameter_value('SBMT_REF_ID');*/

720: tab_transmitter(T619_trnmtr_nbr)
721: := convert_2_xml(nvl(l_return,' '),'trnmtr_nbr');
722: ----
723: /* # 11074583
724: l_return := pay_magtape_generic.get_parameter_value('SBMT_REF_ID');*/
725: l_return := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
726: tab_transmitter(T619_sbmt_ref_id)
727: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
728: ----

Line 725: l_return := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

721: := convert_2_xml(nvl(l_return,' '),'trnmtr_nbr');
722: ----
723: /* # 11074583
724: l_return := pay_magtape_generic.get_parameter_value('SBMT_REF_ID');*/
725: l_return := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
726: tab_transmitter(T619_sbmt_ref_id)
727: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
728: ----
729: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

Line 963: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

959:
960: BEGIN
961: hr_utility.trace('+==========================================================+');
962: hr_utility.trace('Entering t4_cancel_employer_record');
963: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
964: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
965: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
966: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');
967:

Line 964: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

960: BEGIN
961: hr_utility.trace('+==========================================================+');
962: hr_utility.trace('Entering t4_cancel_employer_record');
963: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
964: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
965: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
966: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');
967:
968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);

Line 965: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');

961: hr_utility.trace('+==========================================================+');
962: hr_utility.trace('Entering t4_cancel_employer_record');
963: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
964: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
965: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
966: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');
967:
968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
969: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);

Line 966: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');

962: hr_utility.trace('Entering t4_cancel_employer_record');
963: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
964: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
965: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
966: l_transfer_ei_er_rate := pay_magtape_generic.get_parameter_value('TRANSFER_EI_ER_RATE');
967:
968: hr_utility.trace('PAYROLL_ACTION_ID l_context1 = ' ||l_context1);
969: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID l_transfer_pact_id = ' ||l_transfer_pact_id);
970: hr_utility.trace('TRANSMITTER_GRE l_transfer_tax_unit_id = ' ||l_transfer_tax_unit_id);

Line 1403: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value

1399: tab_other_info_tag(33) := 'epaid_hlth_pln_amt';
1400: tab_other_info_tag(34) := 'stok_opt_csh_out_eamt';
1401: tab_other_info_tag(35) := 'vlntr_firefighter_xmpt_amt'; -- for bug 13087483
1402: --
1403: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1404: ('TRANSFER_PAYROLL_ACTION_ID'));
1405: hr_utility.trace('T4_CANCEL_MAG Payroll action ='||l_payroll_actid);
1406: --
1407: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

Line 1407: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1403: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1404: ('TRANSFER_PAYROLL_ACTION_ID'));
1405: hr_utility.trace('T4_CANCEL_MAG Payroll action ='||l_payroll_actid);
1406: --
1407: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1408: ('TRANSFER_ACT_ID'));
1409: hr_utility.trace('T4_CANCEL_MAG Assignment action ='|| to_char(l_mag_asg_action_id));
1410:
1411: --

Line 1432: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

1428: CLOSE c_get_t4_ei_earn_display;
1429: hr_utility.trace('lv_ei_display_flag ='||lv_ei_display_flag);
1430: /*Removed this as this is not required.
1431: l_arch_pay_actid
1432: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
1433: */
1434: ----
1435: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1436: ,'CAEOY_T4_NEGATIVE_BALANCE_EXISTS');

Line 1710: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),

1706: tab_employee(T4_AMT_itx_ddct_amt) :=convert_2_xml(nvl(l_return,'0'),'itx_ddct_amt','C');
1707:
1708: ----7
1709: lv_year := pay_ca_archive_utils.get_archive_value(
1710: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),
1711: 'CAEOY_TAXATION_YEAR'); -- bug 13087483
1712: l_return := pay_ca_archive_utils.get_archive_value(l_arch_action_id
1713: ,l_jurisdiction_code,'JURISDICTION_CODE'
1714: ,'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD');