626: /* if p_data is null then
627: return null;
628: end if; */
629: SELECT
630: fnd_global.local_chr(13) || fnd_global.local_chr(10)
631: INTO EOL
632: FROM dual;
633: IF p_null_allowed = 'N'
634: AND (TRIM(p_data) IS NULL
729: DECLARE
730:
731: l_final_xml VARCHAR2(32000);
732: l_context1 ff_archive_items.context1%TYPE;
733: EOL VARCHAR2(5) := fnd_global.local_chr(13)
734: || fnd_global.local_chr(10);
735: l_return ff_archive_items.value%TYPE;
736: l_status BOOLEAN := TRUE;
737: l_field_name VARCHAR2(50);
730:
731: l_final_xml VARCHAR2(32000);
732: l_context1 ff_archive_items.context1%TYPE;
733: EOL VARCHAR2(5) := fnd_global.local_chr(13)
734: || fnd_global.local_chr(10);
735: l_return ff_archive_items.value%TYPE;
736: l_status BOOLEAN := TRUE;
737: l_field_name VARCHAR2(50);
738:
956: PROCEDURE t4_amend_employer_start IS
957: BEGIN
958: DECLARE
959: l_final_xml_string VARCHAR2(32000);
960: EOL VARCHAR2(5) := fnd_global.local_chr(13)
961: || fnd_global.local_chr(10);
962:
963: BEGIN
964: hr_utility.trace('+==========================================================+');
957: BEGIN
958: DECLARE
959: l_final_xml_string VARCHAR2(32000);
960: EOL VARCHAR2(5) := fnd_global.local_chr(13)
961: || fnd_global.local_chr(10);
962:
963: BEGIN
964: hr_utility.trace('+==========================================================+');
965: hr_utility.trace('Entering t4_amend_employer_start');
977: DECLARE
978: l_final_xml_string VARCHAR2(32000);
979: l_context1 ff_archive_items.context1%TYPE;
980: l_return ff_archive_items.value%TYPE;
981: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
982: l_transfer_pact_id VARCHAR2(15);
983: l_transfer_tax_unit_id VARCHAR2(15);
984: l_transfer_ei_er_rate VARCHAR2(15);
985: lv_ppreg_no1 pay_action_information.action_information4%TYPE;
1201: lv_ei_display_flag NUMBER :=1;
1202: l_payroll_actid NUMBER;
1203: l_mag_asg_action_id NUMBER;
1204: l_jurisdiction_code ff_archive_items.value%TYPE;
1205: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1206: || fnd_global.local_chr(10);
1207: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1209: -- l_asg_id NUMBER;
1202: l_payroll_actid NUMBER;
1203: l_mag_asg_action_id NUMBER;
1204: l_jurisdiction_code ff_archive_items.value%TYPE;
1205: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1206: || fnd_global.local_chr(10);
1207: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1208: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1209: -- l_asg_id NUMBER;
1210: l_neg_bal_exists BOOLEAN := FALSE;