DBA Data[Home] [Help]

APPS.PAY_CA_T4A_AMEND_MAG dependencies on FND_GLOBAL

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

637: /* if p_data is null then
638: return null;
639: end if; */
640: SELECT
641: fnd_global.local_chr(13) || fnd_global.local_chr(10)
642: INTO EOL
643: FROM dual;
644: IF p_null_allowed = 'N'
645: AND (TRIM(p_data) IS NULL

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

739: DECLARE
740:
741: l_final_xml VARCHAR2(32000);
742: l_context1 ff_archive_items.context1%TYPE;
743: EOL VARCHAR2(5) := fnd_global.local_chr(13)
744: || fnd_global.local_chr(10);
745: l_return VARCHAR2(240);
746: l_status BOOLEAN := TRUE;
747: l_field_name VARCHAR2(50);

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

740:
741: l_final_xml VARCHAR2(32000);
742: l_context1 ff_archive_items.context1%TYPE;
743: EOL VARCHAR2(5) := fnd_global.local_chr(13)
744: || fnd_global.local_chr(10);
745: l_return VARCHAR2(240);
746: l_status BOOLEAN := TRUE;
747: l_field_name VARCHAR2(50);
748:

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

974: PROCEDURE t4a_amend_employer_start IS
975: BEGIN
976: DECLARE
977: l_final_xml_string VARCHAR2(32000);
978: EOL VARCHAR2(5) := fnd_global.local_chr(13)
979: || fnd_global.local_chr(10);
980:
981: BEGIN
982: hr_utility.trace('+==========================================================+');

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

975: BEGIN
976: DECLARE
977: l_final_xml_string VARCHAR2(32000);
978: EOL VARCHAR2(5) := fnd_global.local_chr(13)
979: || fnd_global.local_chr(10);
980:
981: BEGIN
982: hr_utility.trace('+==========================================================+');
983: hr_utility.trace('Entering t4a_amend_employer_start');

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

995: DECLARE
996: l_final_xml_string VARCHAR2(32000);
997: l_context1 ff_archive_items.context1%TYPE;
998: l_return VARCHAR2(240);
999: EOL varchar2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
1000: l_transfer_pact_id VARCHAR2(15);
1001: l_transfer_tax_unit_id VARCHAR2(10);
1002: lv_ppreg_no1 VARCHAR2(20);
1003: lv_ppreg_no2 VARCHAR2(20);

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

1221: BEGIN
1222: DECLARE
1223: l_payroll_actid NUMBER;
1224: l_mag_asg_action_id NUMBER;
1225: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1226: || fnd_global.local_chr(10);
1227: l_arch_action_id NUMBER;
1228: l_arch_pay_actid NUMBER;
1229: l_asg_id NUMBER;

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

1222: DECLARE
1223: l_payroll_actid NUMBER;
1224: l_mag_asg_action_id NUMBER;
1225: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1226: || fnd_global.local_chr(10);
1227: l_arch_action_id NUMBER;
1228: l_arch_pay_actid NUMBER;
1229: l_asg_id NUMBER;
1230: l_neg_bal_exists BOOLEAN := FALSE;