DBA Data[Home] [Help]

APPS.BEN_DM_CREATE_CONTROL_FILES dependencies on BEN_DM_CREATE_CONTROL_FILES

Line 1: PACKAGE BODY ben_dm_create_control_files AS

1: PACKAGE BODY ben_dm_create_control_files AS
2: /* $Header: benfdmmctl.pkb 120.1 2006/05/04 07:02:53 nkkrishn noship $ */
3:
4: procedure get_no_of_inp_files
5: (p_dir_name in varchar2,

Line 227: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.main', 5);

223: l_dummy number;
224:
225: begin
226:
227: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.main', 5);
228:
229: touch_files
230: (p_dir_name => p_dir_name,
231: p_no_of_threads => p_no_of_threads,

Line 357: utl_file.put_line(l_file_handle,','||c3_rec.column_name||' "ben_dm_create_control_files.set_dm_flag(:'||c3_rec.column_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
359: utl_file.put_line(l_file_handle,','||c3_rec.column_name);
360: end if;
361:

Line 555: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.main', 5);

551: close c7;
552: utl_file.put_line(l_file_handle,')');
553: utl_file.fclose(l_file_handle);
554:
555: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.main', 5);
556:
557: end main;
558:
559: procedure rebuild_indexes is

Line 574: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.rebuild_indexes', 5);

570: c1_rec c1%rowtype;
571:
572: begin
573:
574: ben_dm_utility.message('ROUT','entry:ben_dm_create_control_files.rebuild_indexes', 5);
575: open c1;
576: loop
577: fetch c1 into c1_rec;
578: if c1%notfound then

Line 595: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.rebuild_indexes', 5);

591: ben_dm_utility.message('INFO','some indexes failed to rebuild',5);
592: end if;
593: close c1;
594:
595: ben_dm_utility.message('ROUT','exit:ben_dm_create_control_files.rebuild_indexes', 5);
596: end rebuild_indexes;
597:
598: function set_dm_flag(p_person_id number)
599: return number is

Line 605: end ben_dm_create_control_files;

601: hr_general.g_data_migrator_mode := 'Y';
602: return p_person_id;
603: end set_dm_flag;
604:
605: end ben_dm_create_control_files;