DBA Data[Home] [Help]

APPS.PAY_CA_T4A_CANCEL_MAG dependencies on FND_GLOBAL

Line 555: fnd_global.local_chr(13) || fnd_global.local_chr(10)

551: /* if p_data is null then
552: return null;
553: end if; */
554: SELECT
555: fnd_global.local_chr(13) || fnd_global.local_chr(10)
556: INTO EOL
557: FROM dual;
558: IF p_null_allowed = 'N'
559: AND (TRIM(p_data) IS NULL

Line 657: EOL VARCHAR2(5) := fnd_global.local_chr(13)

653: DECLARE
654:
655: l_final_xml VARCHAR2(32000);
656: l_context1 ff_archive_items.context1%TYPE;
657: EOL VARCHAR2(5) := fnd_global.local_chr(13)
658: || fnd_global.local_chr(10);
659: l_return VARCHAR2(240);
660: l_status BOOLEAN := TRUE;
661: l_field_name VARCHAR2(250);

Line 658: || fnd_global.local_chr(10);

654:
655: l_final_xml VARCHAR2(32000);
656: l_context1 ff_archive_items.context1%TYPE;
657: EOL VARCHAR2(5) := fnd_global.local_chr(13)
658: || fnd_global.local_chr(10);
659: l_return VARCHAR2(240);
660: l_status BOOLEAN := TRUE;
661: l_field_name VARCHAR2(250);
662:

Line 908: EOL VARCHAR2(5) := fnd_global.local_chr(13)

904: PROCEDURE t4a_cancel_employer_start IS
905: BEGIN
906: DECLARE
907: l_final_xml_string VARCHAR2(32000);
908: EOL VARCHAR2(5) := fnd_global.local_chr(13)
909: || fnd_global.local_chr(10);
910:
911: BEGIN
912: hr_utility.trace('+==========================================================+');

Line 909: || fnd_global.local_chr(10);

905: BEGIN
906: DECLARE
907: l_final_xml_string VARCHAR2(32000);
908: EOL VARCHAR2(5) := fnd_global.local_chr(13)
909: || fnd_global.local_chr(10);
910:
911: BEGIN
912: hr_utility.trace('+==========================================================+');
913: hr_utility.trace('Entering t4a_amend_employer_start');

Line 929: EOL varchar2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);

925: DECLARE
926: l_final_xml_string VARCHAR2(32000);
927: l_context1 ff_archive_items.context1%TYPE;
928: l_return VARCHAR2(240);
929: EOL varchar2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
930: l_transfer_pact_id VARCHAR2(15);
931: l_transfer_tax_unit_id VARCHAR2(10);
932: lv_ppreg_no1 VARCHAR2(20);
933: lv_ppreg_no2 VARCHAR2(20);

Line 1156: EOL VARCHAR2(5) := fnd_global.local_chr(13)

1152: BEGIN
1153: DECLARE
1154: l_payroll_actid NUMBER;
1155: l_mag_asg_action_id NUMBER;
1156: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1157: || fnd_global.local_chr(10);
1158: l_arch_action_id NUMBER;
1159: l_arch_pay_actid NUMBER;
1160: l_asg_id NUMBER;

Line 1157: || fnd_global.local_chr(10);

1153: DECLARE
1154: l_payroll_actid NUMBER;
1155: l_mag_asg_action_id NUMBER;
1156: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1157: || fnd_global.local_chr(10);
1158: l_arch_action_id NUMBER;
1159: l_arch_pay_actid NUMBER;
1160: l_asg_id NUMBER;
1161: l_neg_bal_exists BOOLEAN := FALSE;