DBA Data[Home] [Help]

APPS.CE_BANK_STATEMENT_LOADER dependencies on FND_GLOBAL

Line 260: '||fnd_global.local_chr(13)),

256: removal along with linefeed character(^M - ascii 10)*/
257:
258: UPDATE CE_STMT_INT_TMP
259: SET REC_NO = rtrim(REC_NO, '
260: '||fnd_global.local_chr(13)),
261: REC_ID_NO = rtrim(REC_ID_NO, '
262: '||fnd_global.local_chr(13)),
263: COLUMN1 = rtrim(COLUMN1, '
264: '||fnd_global.local_chr(13)),

Line 262: '||fnd_global.local_chr(13)),

258: UPDATE CE_STMT_INT_TMP
259: SET REC_NO = rtrim(REC_NO, '
260: '||fnd_global.local_chr(13)),
261: REC_ID_NO = rtrim(REC_ID_NO, '
262: '||fnd_global.local_chr(13)),
263: COLUMN1 = rtrim(COLUMN1, '
264: '||fnd_global.local_chr(13)),
265: COLUMN2 = rtrim(COLUMN2, '
266: '||fnd_global.local_chr(13)),

Line 264: '||fnd_global.local_chr(13)),

260: '||fnd_global.local_chr(13)),
261: REC_ID_NO = rtrim(REC_ID_NO, '
262: '||fnd_global.local_chr(13)),
263: COLUMN1 = rtrim(COLUMN1, '
264: '||fnd_global.local_chr(13)),
265: COLUMN2 = rtrim(COLUMN2, '
266: '||fnd_global.local_chr(13)),
267: COLUMN3 = rtrim(COLUMN3, '
268: '||fnd_global.local_chr(13)),

Line 266: '||fnd_global.local_chr(13)),

262: '||fnd_global.local_chr(13)),
263: COLUMN1 = rtrim(COLUMN1, '
264: '||fnd_global.local_chr(13)),
265: COLUMN2 = rtrim(COLUMN2, '
266: '||fnd_global.local_chr(13)),
267: COLUMN3 = rtrim(COLUMN3, '
268: '||fnd_global.local_chr(13)),
269: COLUMN4 = rtrim(COLUMN4, '
270: '||fnd_global.local_chr(13)),

Line 268: '||fnd_global.local_chr(13)),

264: '||fnd_global.local_chr(13)),
265: COLUMN2 = rtrim(COLUMN2, '
266: '||fnd_global.local_chr(13)),
267: COLUMN3 = rtrim(COLUMN3, '
268: '||fnd_global.local_chr(13)),
269: COLUMN4 = rtrim(COLUMN4, '
270: '||fnd_global.local_chr(13)),
271: COLUMN5 = rtrim(COLUMN5, '
272: '||fnd_global.local_chr(13)),

Line 270: '||fnd_global.local_chr(13)),

266: '||fnd_global.local_chr(13)),
267: COLUMN3 = rtrim(COLUMN3, '
268: '||fnd_global.local_chr(13)),
269: COLUMN4 = rtrim(COLUMN4, '
270: '||fnd_global.local_chr(13)),
271: COLUMN5 = rtrim(COLUMN5, '
272: '||fnd_global.local_chr(13)),
273: COLUMN6 = rtrim(COLUMN6, '
274: '||fnd_global.local_chr(13)),

Line 272: '||fnd_global.local_chr(13)),

268: '||fnd_global.local_chr(13)),
269: COLUMN4 = rtrim(COLUMN4, '
270: '||fnd_global.local_chr(13)),
271: COLUMN5 = rtrim(COLUMN5, '
272: '||fnd_global.local_chr(13)),
273: COLUMN6 = rtrim(COLUMN6, '
274: '||fnd_global.local_chr(13)),
275: COLUMN7 = rtrim(COLUMN7, '
276: '||fnd_global.local_chr(13)),

Line 274: '||fnd_global.local_chr(13)),

270: '||fnd_global.local_chr(13)),
271: COLUMN5 = rtrim(COLUMN5, '
272: '||fnd_global.local_chr(13)),
273: COLUMN6 = rtrim(COLUMN6, '
274: '||fnd_global.local_chr(13)),
275: COLUMN7 = rtrim(COLUMN7, '
276: '||fnd_global.local_chr(13)),
277: COLUMN8 = rtrim(COLUMN8, '
278: '||fnd_global.local_chr(13)),

Line 276: '||fnd_global.local_chr(13)),

272: '||fnd_global.local_chr(13)),
273: COLUMN6 = rtrim(COLUMN6, '
274: '||fnd_global.local_chr(13)),
275: COLUMN7 = rtrim(COLUMN7, '
276: '||fnd_global.local_chr(13)),
277: COLUMN8 = rtrim(COLUMN8, '
278: '||fnd_global.local_chr(13)),
279: COLUMN9 = rtrim(COLUMN9, '
280: '||fnd_global.local_chr(13)),

Line 278: '||fnd_global.local_chr(13)),

274: '||fnd_global.local_chr(13)),
275: COLUMN7 = rtrim(COLUMN7, '
276: '||fnd_global.local_chr(13)),
277: COLUMN8 = rtrim(COLUMN8, '
278: '||fnd_global.local_chr(13)),
279: COLUMN9 = rtrim(COLUMN9, '
280: '||fnd_global.local_chr(13)),
281: COLUMN10 = rtrim(COLUMN10, '
282: '||fnd_global.local_chr(13)),

Line 280: '||fnd_global.local_chr(13)),

276: '||fnd_global.local_chr(13)),
277: COLUMN8 = rtrim(COLUMN8, '
278: '||fnd_global.local_chr(13)),
279: COLUMN9 = rtrim(COLUMN9, '
280: '||fnd_global.local_chr(13)),
281: COLUMN10 = rtrim(COLUMN10, '
282: '||fnd_global.local_chr(13)),
283: COLUMN11 = rtrim(COLUMN11, '
284: '||fnd_global.local_chr(13)),

Line 282: '||fnd_global.local_chr(13)),

278: '||fnd_global.local_chr(13)),
279: COLUMN9 = rtrim(COLUMN9, '
280: '||fnd_global.local_chr(13)),
281: COLUMN10 = rtrim(COLUMN10, '
282: '||fnd_global.local_chr(13)),
283: COLUMN11 = rtrim(COLUMN11, '
284: '||fnd_global.local_chr(13)),
285: COLUMN12 = rtrim(COLUMN12, '
286: '||fnd_global.local_chr(13)),

Line 284: '||fnd_global.local_chr(13)),

280: '||fnd_global.local_chr(13)),
281: COLUMN10 = rtrim(COLUMN10, '
282: '||fnd_global.local_chr(13)),
283: COLUMN11 = rtrim(COLUMN11, '
284: '||fnd_global.local_chr(13)),
285: COLUMN12 = rtrim(COLUMN12, '
286: '||fnd_global.local_chr(13)),
287: COLUMN13 = rtrim(COLUMN13, '
288: '||fnd_global.local_chr(13)),

Line 286: '||fnd_global.local_chr(13)),

282: '||fnd_global.local_chr(13)),
283: COLUMN11 = rtrim(COLUMN11, '
284: '||fnd_global.local_chr(13)),
285: COLUMN12 = rtrim(COLUMN12, '
286: '||fnd_global.local_chr(13)),
287: COLUMN13 = rtrim(COLUMN13, '
288: '||fnd_global.local_chr(13)),
289: COLUMN14 = rtrim(COLUMN14, '
290: '||fnd_global.local_chr(13)),

Line 288: '||fnd_global.local_chr(13)),

284: '||fnd_global.local_chr(13)),
285: COLUMN12 = rtrim(COLUMN12, '
286: '||fnd_global.local_chr(13)),
287: COLUMN13 = rtrim(COLUMN13, '
288: '||fnd_global.local_chr(13)),
289: COLUMN14 = rtrim(COLUMN14, '
290: '||fnd_global.local_chr(13)),
291: COLUMN15 = rtrim(COLUMN15, '
292: '||fnd_global.local_chr(13)),

Line 290: '||fnd_global.local_chr(13)),

286: '||fnd_global.local_chr(13)),
287: COLUMN13 = rtrim(COLUMN13, '
288: '||fnd_global.local_chr(13)),
289: COLUMN14 = rtrim(COLUMN14, '
290: '||fnd_global.local_chr(13)),
291: COLUMN15 = rtrim(COLUMN15, '
292: '||fnd_global.local_chr(13)),
293: COLUMN16 = rtrim(COLUMN16, '
294: '||fnd_global.local_chr(13)),

Line 292: '||fnd_global.local_chr(13)),

288: '||fnd_global.local_chr(13)),
289: COLUMN14 = rtrim(COLUMN14, '
290: '||fnd_global.local_chr(13)),
291: COLUMN15 = rtrim(COLUMN15, '
292: '||fnd_global.local_chr(13)),
293: COLUMN16 = rtrim(COLUMN16, '
294: '||fnd_global.local_chr(13)),
295: COLUMN17 = rtrim(COLUMN17, '
296: '||fnd_global.local_chr(13)),

Line 294: '||fnd_global.local_chr(13)),

290: '||fnd_global.local_chr(13)),
291: COLUMN15 = rtrim(COLUMN15, '
292: '||fnd_global.local_chr(13)),
293: COLUMN16 = rtrim(COLUMN16, '
294: '||fnd_global.local_chr(13)),
295: COLUMN17 = rtrim(COLUMN17, '
296: '||fnd_global.local_chr(13)),
297: COLUMN18 = rtrim(COLUMN18, '
298: '||fnd_global.local_chr(13)),

Line 296: '||fnd_global.local_chr(13)),

292: '||fnd_global.local_chr(13)),
293: COLUMN16 = rtrim(COLUMN16, '
294: '||fnd_global.local_chr(13)),
295: COLUMN17 = rtrim(COLUMN17, '
296: '||fnd_global.local_chr(13)),
297: COLUMN18 = rtrim(COLUMN18, '
298: '||fnd_global.local_chr(13)),
299: COLUMN19 = rtrim(COLUMN19, '
300: '||fnd_global.local_chr(13)),

Line 298: '||fnd_global.local_chr(13)),

294: '||fnd_global.local_chr(13)),
295: COLUMN17 = rtrim(COLUMN17, '
296: '||fnd_global.local_chr(13)),
297: COLUMN18 = rtrim(COLUMN18, '
298: '||fnd_global.local_chr(13)),
299: COLUMN19 = rtrim(COLUMN19, '
300: '||fnd_global.local_chr(13)),
301: COLUMN20 = rtrim(COLUMN20, '
302: '||fnd_global.local_chr(13)),

Line 300: '||fnd_global.local_chr(13)),

296: '||fnd_global.local_chr(13)),
297: COLUMN18 = rtrim(COLUMN18, '
298: '||fnd_global.local_chr(13)),
299: COLUMN19 = rtrim(COLUMN19, '
300: '||fnd_global.local_chr(13)),
301: COLUMN20 = rtrim(COLUMN20, '
302: '||fnd_global.local_chr(13)),
303: COLUMN21 = rtrim(COLUMN21, '
304: '||fnd_global.local_chr(13)),

Line 302: '||fnd_global.local_chr(13)),

298: '||fnd_global.local_chr(13)),
299: COLUMN19 = rtrim(COLUMN19, '
300: '||fnd_global.local_chr(13)),
301: COLUMN20 = rtrim(COLUMN20, '
302: '||fnd_global.local_chr(13)),
303: COLUMN21 = rtrim(COLUMN21, '
304: '||fnd_global.local_chr(13)),
305: COLUMN22 = rtrim(COLUMN22, '
306: '||fnd_global.local_chr(13)),

Line 304: '||fnd_global.local_chr(13)),

300: '||fnd_global.local_chr(13)),
301: COLUMN20 = rtrim(COLUMN20, '
302: '||fnd_global.local_chr(13)),
303: COLUMN21 = rtrim(COLUMN21, '
304: '||fnd_global.local_chr(13)),
305: COLUMN22 = rtrim(COLUMN22, '
306: '||fnd_global.local_chr(13)),
307: COLUMN23 = rtrim(COLUMN23, '
308: '||fnd_global.local_chr(13)),

Line 306: '||fnd_global.local_chr(13)),

302: '||fnd_global.local_chr(13)),
303: COLUMN21 = rtrim(COLUMN21, '
304: '||fnd_global.local_chr(13)),
305: COLUMN22 = rtrim(COLUMN22, '
306: '||fnd_global.local_chr(13)),
307: COLUMN23 = rtrim(COLUMN23, '
308: '||fnd_global.local_chr(13)),
309: COLUMN24 = rtrim(COLUMN24, '
310: '||fnd_global.local_chr(13)),

Line 308: '||fnd_global.local_chr(13)),

304: '||fnd_global.local_chr(13)),
305: COLUMN22 = rtrim(COLUMN22, '
306: '||fnd_global.local_chr(13)),
307: COLUMN23 = rtrim(COLUMN23, '
308: '||fnd_global.local_chr(13)),
309: COLUMN24 = rtrim(COLUMN24, '
310: '||fnd_global.local_chr(13)),
311: COLUMN25 = rtrim(COLUMN25, '
312: '||fnd_global.local_chr(13)),

Line 310: '||fnd_global.local_chr(13)),

306: '||fnd_global.local_chr(13)),
307: COLUMN23 = rtrim(COLUMN23, '
308: '||fnd_global.local_chr(13)),
309: COLUMN24 = rtrim(COLUMN24, '
310: '||fnd_global.local_chr(13)),
311: COLUMN25 = rtrim(COLUMN25, '
312: '||fnd_global.local_chr(13)),
313: COLUMN26 = rtrim(COLUMN26, '
314: '||fnd_global.local_chr(13)),

Line 312: '||fnd_global.local_chr(13)),

308: '||fnd_global.local_chr(13)),
309: COLUMN24 = rtrim(COLUMN24, '
310: '||fnd_global.local_chr(13)),
311: COLUMN25 = rtrim(COLUMN25, '
312: '||fnd_global.local_chr(13)),
313: COLUMN26 = rtrim(COLUMN26, '
314: '||fnd_global.local_chr(13)),
315: COLUMN27 = rtrim(COLUMN27, '
316: '||fnd_global.local_chr(13)),

Line 314: '||fnd_global.local_chr(13)),

310: '||fnd_global.local_chr(13)),
311: COLUMN25 = rtrim(COLUMN25, '
312: '||fnd_global.local_chr(13)),
313: COLUMN26 = rtrim(COLUMN26, '
314: '||fnd_global.local_chr(13)),
315: COLUMN27 = rtrim(COLUMN27, '
316: '||fnd_global.local_chr(13)),
317: COLUMN28 = rtrim(COLUMN28, '
318: '||fnd_global.local_chr(13)),

Line 316: '||fnd_global.local_chr(13)),

312: '||fnd_global.local_chr(13)),
313: COLUMN26 = rtrim(COLUMN26, '
314: '||fnd_global.local_chr(13)),
315: COLUMN27 = rtrim(COLUMN27, '
316: '||fnd_global.local_chr(13)),
317: COLUMN28 = rtrim(COLUMN28, '
318: '||fnd_global.local_chr(13)),
319: COLUMN29 = rtrim(COLUMN29, '
320: '||fnd_global.local_chr(13)),

Line 318: '||fnd_global.local_chr(13)),

314: '||fnd_global.local_chr(13)),
315: COLUMN27 = rtrim(COLUMN27, '
316: '||fnd_global.local_chr(13)),
317: COLUMN28 = rtrim(COLUMN28, '
318: '||fnd_global.local_chr(13)),
319: COLUMN29 = rtrim(COLUMN29, '
320: '||fnd_global.local_chr(13)),
321: COLUMN30 = rtrim(COLUMN30, '
322: '||fnd_global.local_chr(13)),

Line 320: '||fnd_global.local_chr(13)),

316: '||fnd_global.local_chr(13)),
317: COLUMN28 = rtrim(COLUMN28, '
318: '||fnd_global.local_chr(13)),
319: COLUMN29 = rtrim(COLUMN29, '
320: '||fnd_global.local_chr(13)),
321: COLUMN30 = rtrim(COLUMN30, '
322: '||fnd_global.local_chr(13)),
323: COLUMN31 = rtrim(COLUMN31, '
324: '||fnd_global.local_chr(13)),

Line 322: '||fnd_global.local_chr(13)),

318: '||fnd_global.local_chr(13)),
319: COLUMN29 = rtrim(COLUMN29, '
320: '||fnd_global.local_chr(13)),
321: COLUMN30 = rtrim(COLUMN30, '
322: '||fnd_global.local_chr(13)),
323: COLUMN31 = rtrim(COLUMN31, '
324: '||fnd_global.local_chr(13)),
325: COLUMN32 = rtrim(COLUMN32, '
326: '||fnd_global.local_chr(13)),

Line 324: '||fnd_global.local_chr(13)),

320: '||fnd_global.local_chr(13)),
321: COLUMN30 = rtrim(COLUMN30, '
322: '||fnd_global.local_chr(13)),
323: COLUMN31 = rtrim(COLUMN31, '
324: '||fnd_global.local_chr(13)),
325: COLUMN32 = rtrim(COLUMN32, '
326: '||fnd_global.local_chr(13)),
327: COLUMN33 = rtrim(COLUMN33, '
328: '||fnd_global.local_chr(13)),

Line 326: '||fnd_global.local_chr(13)),

322: '||fnd_global.local_chr(13)),
323: COLUMN31 = rtrim(COLUMN31, '
324: '||fnd_global.local_chr(13)),
325: COLUMN32 = rtrim(COLUMN32, '
326: '||fnd_global.local_chr(13)),
327: COLUMN33 = rtrim(COLUMN33, '
328: '||fnd_global.local_chr(13)),
329: COLUMN34 = rtrim(COLUMN34, '
330: '||fnd_global.local_chr(13)),

Line 328: '||fnd_global.local_chr(13)),

324: '||fnd_global.local_chr(13)),
325: COLUMN32 = rtrim(COLUMN32, '
326: '||fnd_global.local_chr(13)),
327: COLUMN33 = rtrim(COLUMN33, '
328: '||fnd_global.local_chr(13)),
329: COLUMN34 = rtrim(COLUMN34, '
330: '||fnd_global.local_chr(13)),
331: COLUMN35 = rtrim(COLUMN35, '
332: '||fnd_global.local_chr(13));

Line 330: '||fnd_global.local_chr(13)),

326: '||fnd_global.local_chr(13)),
327: COLUMN33 = rtrim(COLUMN33, '
328: '||fnd_global.local_chr(13)),
329: COLUMN34 = rtrim(COLUMN34, '
330: '||fnd_global.local_chr(13)),
331: COLUMN35 = rtrim(COLUMN35, '
332: '||fnd_global.local_chr(13));
333: END Remove_Return_Char;
334:

Line 332: '||fnd_global.local_chr(13));

328: '||fnd_global.local_chr(13)),
329: COLUMN34 = rtrim(COLUMN34, '
330: '||fnd_global.local_chr(13)),
331: COLUMN35 = rtrim(COLUMN35, '
332: '||fnd_global.local_chr(13));
333: END Remove_Return_Char;
334:
335: /* ---------------------------------------------------------------------
336: | PRIVATE PROCEDURE |

Line 734: fnd_global.local_chr(0),

730: G_display_debug,
731: G_debug_path,
732: l_debug_file,
733: G_intra_day_flag,
734: fnd_global.local_chr(0),
735: '','',
736: '','','','','','','','','','',
737: '','','','','','','','','','',
738: '','','','','','','','','','',

Line 1988: '||fnd_global.local_chr(13));

1984: SELECT column36 INTO l_str
1985: FROM ce_stmt_int_tmp WHERE rec_no = X_rec_no;
1986:
1987: l_str:= rtrim(l_str, '
1988: '||fnd_global.local_chr(13));
1989:
1990: END IF;
1991: /*End of 13324534*/
1992:

Line 3478: G_user_id := FND_GLOBAL.user_id;

3474: G_bank_account_id := X_bank_account_id;
3475: G_org_id := X_org_id;
3476:
3477: G_map_id := X_MAP_ID;
3478: G_user_id := FND_GLOBAL.user_id;
3479:
3480: IF (G_gl_date_source = 'USER') THEN
3481: G_gl_date := to_date(X_gl_date,'YYYY/MM/DD HH24:MI:SS');
3482: ELSIF (G_gl_date_source = 'SYSTEM') THEN