DBA Data[Home] [Help]

APPS.BEN_DM_CREATE_CONTROL_FILES dependencies on FND_GLOBAL

Line 255: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');

251: utl_file.put_line(l_file_handle,')');
252: end if;
253: utl_file.put_line(l_file_handle,'into table '||c1_rec.table_name);
254: utl_file.put_line(l_file_handle,'when fillertabname="'||c1_rec.table_name||'"');
255: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');
256: utl_file.put_line(l_file_handle,'TRAILING NULLCOLS');
257: utl_file.put_line(l_file_handle,'(fillertabname FILLER POSITION(1) CHAR');
258: l_prev_tab_name := c1_rec.table_name;
259: end if;

Line 308: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');

304: utl_file.put_line(l_file_handle,l_in_file(i));
305: end loop;
306: utl_file.put_line(l_file_handle,'replace');
307: utl_file.put_line(l_file_handle,'into table '||c2_rec.table_name);
308: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');
309: utl_file.put_line(l_file_handle,'TRAILING NULLCOLS');
310: utl_file.put_line(l_file_handle,'('||c2_rec.column_name);
311: else
312: utl_file.put_line(l_file_handle,','||c2_rec.column_name);

Line 354: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');

350: end loop;
351: utl_file.put_line(l_file_handle,'append');
352: utl_file.put_line(l_file_handle,'into table '||c3_rec.table_name);
353: utl_file.put_line(l_file_handle,'when fillertabname="'||c3_rec.table_name||'"');
354: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');
355: utl_file.put_line(l_file_handle,'TRAILING NULLCOLS');
356: utl_file.put_line(l_file_handle,'(fillertabname FILLER POSITION(1) CHAR');
357: utl_file.put_line(l_file_handle,','||c3_rec.column_name||' "ben_dm_create_control_files.set_dm_flag(:'||c3_rec.column_name||')"');
358: else

Line 395: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');

391: end if;
392: utl_file.put_line(l_file_handle,'into table '||c4_rec.table_name);
393: utl_file.put_line(l_file_handle,'reenable');
394: utl_file.put_line(l_file_handle,'when fillertabname="'||c4_rec.table_name||'"');
395: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');
396: utl_file.put_line(l_file_handle,'TRAILING NULLCOLS');
397: utl_file.put_line(l_file_handle,'(fillertabname FILLER POSITION(1) CHAR');
398: l_prev_tab_name := c4_rec.table_name;
399: end if;

Line 447: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');

443: end if;
444: utl_file.put_line(l_file_handle,'into table '||c5_rec.table_name);
445: utl_file.put_line(l_file_handle,'reenable');
446: utl_file.put_line(l_file_handle,'when fillertabname="'||c5_rec.table_name||'"');
447: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');
448: utl_file.put_line(l_file_handle,'TRAILING NULLCOLS');
449: utl_file.put_line(l_file_handle,'(fillertabname FILLER POSITION(1) CHAR');
450: l_prev_tab_name := c5_rec.table_name;
451: end if;

Line 499: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');

495: end if;
496: utl_file.put_line(l_file_handle,'into table '||c6_rec.table_name);
497: utl_file.put_line(l_file_handle,'reenable');
498: utl_file.put_line(l_file_handle,'when fillertabname="'||c6_rec.table_name||'"');
499: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');
500: utl_file.put_line(l_file_handle,'TRAILING NULLCOLS');
501: utl_file.put_line(l_file_handle,'(fillertabname FILLER POSITION(1) CHAR');
502: l_prev_tab_name := c6_rec.table_name;
503: end if;

Line 543: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');

539: utl_file.put_line(l_file_handle,'append');
540: utl_file.put_line(l_file_handle,'into table '||c7_rec.table_name);
541: utl_file.put_line(l_file_handle,'reenable');
542: utl_file.put_line(l_file_handle,'when fillertabname="'||c7_rec.table_name||'"');
543: utl_file.put_line(l_file_handle,'fields terminated by '||''''||fnd_global.local_chr(01)||'''');
544: utl_file.put_line(l_file_handle,'TRAILING NULLCOLS');
545: utl_file.put_line(l_file_handle,'(fillertabname FILLER POSITION(1) CHAR');
546: end if;
547: utl_file.put_line(l_file_handle,','||c7_rec.column_name);