DBA Data[Home] [Help]

APPS.PAY_CA_T4A_CANCEL_MAG dependencies on PAY_MAGTAPE_GENERIC

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

694: pay_assignment_actions paa1,
695: pay_action_interlocks int
696: where int.locking_action_id = paa.assignment_action_id
697: and paa1.assignment_action_id = int.locked_action_id
698: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
699: exception
700: when no_data_found then
701: raise;
702: end;

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

700: when no_data_found then
701: raise;
702: end;
703:
704: -- l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
705: hr_utility.trace('PAYROLL_ACTION_ID l_context1 ='||l_context1);
706:
707: l_return := pay_ca_archive_utils.get_archive_value(l_context1,
708: 'CAEOY_TRANSMITTER_NUMBER');

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

714: tab_transmitter(T619_trnmtr_nbr)
715: := convert_2_xml(nvl(l_return,' '),'trnmtr_nbr');
716: ----
717: /* # 11074583
718: l_return := pay_magtape_generic.get_parameter_value('SBMT_REF_ID');*/
719: l_return := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
720: tab_transmitter(T619_sbmt_ref_id)
721: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
722: ----

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

715: := convert_2_xml(nvl(l_return,' '),'trnmtr_nbr');
716: ----
717: /* # 11074583
718: l_return := pay_magtape_generic.get_parameter_value('SBMT_REF_ID');*/
719: l_return := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
720: tab_transmitter(T619_sbmt_ref_id)
721: := convert_2_xml(nvl(l_return,' '),'sbmt_ref_id');
722: ----
723: l_return := pay_ca_archive_utils.get_archive_value(l_context1,

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

961:
962: BEGIN
963: hr_utility.trace('+==========================================================+');
964: hr_utility.trace('Entering t4a_amend_employer_record');
965: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
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_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

962: BEGIN
963: hr_utility.trace('+==========================================================+');
964: hr_utility.trace('Entering t4a_amend_employer_record');
965: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
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 967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');

963: hr_utility.trace('+==========================================================+');
964: hr_utility.trace('Entering t4a_amend_employer_record');
965: l_context1 := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
966: l_transfer_pact_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
967: l_transfer_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE');
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);
971: ----

Line 1243: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value

1239: BEGIN
1240: hr_utility.trace('+==========================================================+');
1241: hr_utility.trace('Employee Record');
1242:
1243: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1244: ('TRANSFER_PAYROLL_ACTION_ID'));
1245: hr_utility.trace('T4A_CANCEL_MAG Payroll action ='||l_payroll_actid);
1246:
1247: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

Line 1247: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value

1243: l_payroll_actid := to_number(pay_magtape_generic.get_parameter_value
1244: ('TRANSFER_PAYROLL_ACTION_ID'));
1245: hr_utility.trace('T4A_CANCEL_MAG Payroll action ='||l_payroll_actid);
1246:
1247: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value
1248: ('TRANSFER_ACT_ID'));
1249: hr_utility.trace('T4A_CANCEL_MAG Assignment action ='|| to_char(l_mag_asg_action_id));
1250:
1251: OPEN c_get_payroll_asg_actid(l_mag_asg_action_id);