DBA Data[Home] [Help]

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on HR_GENERAL

Line 3397: l_status_mode := hr_general.g_data_migrator_mode;

3393: hr_utility.trace('| Global Names Count = ' || l_jp_global_names_tab.COUNT);
3394: hr_utility.trace('+----------------------------------+ ');
3395: end if;
3396: --
3397: l_status_mode := hr_general.g_data_migrator_mode;
3398: --
3399: hr_utility.trace('hr_general.g_data_migrator_mode : '||l_status_mode);
3400: --
3401: if nvl(l_status_mode,'N') <> 'Y' then

Line 3399: hr_utility.trace('hr_general.g_data_migrator_mode : '||l_status_mode);

3395: end if;
3396: --
3397: l_status_mode := hr_general.g_data_migrator_mode;
3398: --
3399: hr_utility.trace('hr_general.g_data_migrator_mode : '||l_status_mode);
3400: --
3401: if nvl(l_status_mode,'N') <> 'Y' then
3402: --
3403: -- this is required to set for FF_GLOBALS_F_BRU trigger

Line 3407: hr_general.g_data_migrator_mode := 'Y';

3403: -- this is required to set for FF_GLOBALS_F_BRU trigger
3404: -- FF_GLOBALS_F_MNT_TL_ARU also will be disabled
3405: -- but global tl will be set finally by subsequent step, ldt load
3406: -- so it can be skipped.
3407: hr_general.g_data_migrator_mode := 'Y';
3408: --
3409: end if;
3410: --
3411: FORALL l_tab_cnt IN 1..l_jp_global_names_tab.COUNT

Line 3420: hr_general.g_data_migrator_mode := l_status_mode;

3416: WHERE global_name LIKE hr_jp_standard_pkg.hextochar(l_jp_global_names_tab(l_tab_cnt),'AL32UTF8')
3417: AND legislation_code = 'JP';
3418: --
3419: -- unset for subsequent procedure to enable trigger
3420: hr_general.g_data_migrator_mode := l_status_mode;
3421: --
3422: UPDATE ff_globals_f
3423: SET global_description = global_description || 'Obsoleted'
3424: WHERE ASCII(global_description) > 127

Line 6212: l_status_mode := hr_general.g_data_migrator_mode;

6208: -- if (g_dbg) then
6209: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
6210: -- end if;
6211: --
6212: l_status_mode := hr_general.g_data_migrator_mode;
6213: --
6214: if nvl(l_status_mode,'N') <> 'Y' then
6215: --
6216: -- this is required to set for FF_GLOBALS_F_BRU trigger

Line 6219: hr_general.g_data_migrator_mode := 'Y';

6215: --
6216: -- this is required to set for FF_GLOBALS_F_BRU trigger
6217: -- FF_GLOBALS_F_MNT_TL_ARU also will be disabled
6218: --
6219: hr_general.g_data_migrator_mode := 'Y';
6220: --
6221: end if;
6222: --
6223: -- use bulk collect

Line 6232: hr_general.g_data_migrator_mode := l_status_mode;

6228: where global_name = l_glb_tbl(l_glb_ind)
6229: and legislation_code = 'JP';
6230: --
6231: -- unset for subsequent procedure to enable trigger
6232: hr_general.g_data_migrator_mode := l_status_mode;
6233: --
6234: if (g_dbg) then
6235: hr_utility.set_location(l_proc,55);
6236: end if;

Line 6783: l_status_mode := hr_general.g_data_migrator_mode;

6779: end if;
6780: --
6781: if l_corrupt_dbi_tl_cnt > 0 then
6782: --
6783: l_status_mode := hr_general.g_data_migrator_mode;
6784: --
6785: -- for unset FF_DATABASE_ITEMS_TL084714_WHO
6786: if nvl(l_status_mode,'N') <> 'Y' then
6787: --

Line 6788: hr_general.g_data_migrator_mode := 'Y';

6784: --
6785: -- for unset FF_DATABASE_ITEMS_TL084714_WHO
6786: if nvl(l_status_mode,'N') <> 'Y' then
6787: --
6788: hr_general.g_data_migrator_mode := 'Y';
6789: --
6790: end if;
6791: --
6792: update ff_database_items_tl ufdit

Line 6828: hr_general.g_data_migrator_mode := l_status_mode;

6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6825: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1));
6826: --
6827: -- unset for subsequent procedure to enable trigger
6828: hr_general.g_data_migrator_mode := l_status_mode;
6829: --
6830: end if;
6831: --
6832: if (g_dbg) then