APPS.PAY_GB_ENROLL_INFO_GENE dependencies on FND_GLOBAL

Line 257: EOL VARCHAR2(5) := fnd_global.local_chr(10);

253: l_global_value c_get_global_value%rowtype;
254:
255: l_string VARCHAR2(32767) := NULL;
256: l_xml CLOB;
257: EOL VARCHAR2(5) := fnd_global.local_chr(10);
258: l_pension_age number := 65;
259: l_not varchar2(3) :='not';
260: --------------------------------------
261: l_employer_name VARCHAR2(150):= NULL;

Line 1183: EOL VARCHAR2(5) := fnd_global.local_chr(10);

1179: l_pension_entry_values c_pension_entry_values%rowtype;
1180: l_string VARCHAR2(32767) := NULL;
1181: t_string VARCHAR2(32767) := NULL;
1182: l_xml CLOB;
1183: EOL VARCHAR2(5) := fnd_global.local_chr(10);
1184: l_req_id varchar2(20);
1185: l_assignment_number per_all_assignments_f.assignment_number%type;
1186: l_employee_name per_all_people_f.full_name%type;
1187: /*

Line 1199: EOL VARCHAR2(5) := fnd_global.local_chr(10);

1195: l_global_value c_get_global_value%rowtype;
1196:
1197: l_string VARCHAR2(32767) := NULL;
1198: l_xml CLOB;
1199: EOL VARCHAR2(5) := fnd_global.local_chr(10);
1200: l_pension_age number := 65;
1201: l_not varchar2(3) :='not';
1202:
1203: --------------------------------------

Line 1577: l_req_id := fnd_global.conc_request_id ;

1573: END IF;--Element Attached Check
1574: END IF;-- Assignment Set Check
1575: END LOOP;--Loop Every Assignment
1576: IF P_MODE = 'GENMAIL' THEN --Mode = Generate and Mail Inner
1577: l_req_id := fnd_global.conc_request_id ;
1578: l_string := l_string || ''||EOL;
1579:
1580: fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);
1581: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);

Line 1588: p_request_id :=fnd_global.conc_request_id;

1584:
1585: ---------------------------------------------------------------------------------------
1586: fnd_file.put_line(fnd_file.OUTPUT,l_string);
1587: -- Working Section For XML BUrsting
1588: p_request_id :=fnd_global.conc_request_id;
1589: UPDATE fnd_concurrent_requests
1590: SET output_file_type = 'XML'
1591: WHERE request_id = p_request_id;
1592:

Line 1704: EOL VARCHAR2(5) := fnd_global.local_chr(10);

1700: l_pension_entry_values c_pension_entry_values%rowtype;
1701: l_string VARCHAR2(32767) := NULL;
1702: t_string VARCHAR2(32767) := NULL;
1703: l_xml CLOB;
1704: EOL VARCHAR2(5) := fnd_global.local_chr(10);
1705:
1706:
1707:
1708:

Line 1822: --l_req_id := fnd_global.conc_request_id ;

1818: l_string := l_string || ''||EOL;
1819: END IF;
1820: */
1821: l_string := l_string || ''||EOL;
1822: --l_req_id := fnd_global.conc_request_id ;
1823:
1824: --fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);
1825: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);
1826: /*