APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_GLOBALS_F

Line 3249: type t_global_names_tab is table of ff_globals_f.global_name%TYPE index by binary_integer;

3245: procedure migrate_globals is
3246: --
3247: type t_jp_global_names_tab is table of VARCHAR2(200) index by binary_integer;
3248:
3249: type t_global_names_tab is table of ff_globals_f.global_name%TYPE index by binary_integer;
3250:
3251: type t_global_desc_tab is table of ff_globals_f.global_description%TYPE index by binary_integer;
3252:
3253: l_jp_global_names_tab t_jp_global_names_tab;

Line 3251: type t_global_desc_tab is table of ff_globals_f.global_description%TYPE index by binary_integer;

3247: type t_jp_global_names_tab is table of VARCHAR2(200) index by binary_integer;
3248:
3249: type t_global_names_tab is table of ff_globals_f.global_name%TYPE index by binary_integer;
3250:
3251: type t_global_desc_tab is table of ff_globals_f.global_description%TYPE index by binary_integer;
3252:
3253: l_jp_global_names_tab t_jp_global_names_tab;
3254: l_global_names_tab t_global_names_tab;
3255: l_global_desc_tab t_global_desc_tab;

Line 3378: UPDATE ff_globals_f

3374: hr_general.g_data_migrator_mode := 'Y';
3375:
3376: FORALL l_tab_cnt IN 1..l_jp_global_names_tab.COUNT
3377:
3378: UPDATE ff_globals_f
3379: SET global_name = l_global_names_tab(l_tab_cnt),
3380: global_description = l_global_desc_tab(l_tab_cnt)
3381: WHERE global_name LIKE hr_jp_standard_pkg.hextochar(l_jp_global_names_tab(l_tab_cnt),'AL32UTF8')
3382: AND legislation_code = 'JP';

Line 3384: UPDATE ff_globals_f

3380: global_description = l_global_desc_tab(l_tab_cnt)
3381: WHERE global_name LIKE hr_jp_standard_pkg.hextochar(l_jp_global_names_tab(l_tab_cnt),'AL32UTF8')
3382: AND legislation_code = 'JP';
3383:
3384: UPDATE ff_globals_f
3385: SET global_description = global_description || 'Obsoleted'
3386: WHERE ASCII(global_description) > 127
3387: AND legislation_code = 'JP';
3388:

Line 4612: from ff_globals_f g

4608: g.business_group_id,
4609: g.legislation_code,
4610: g.created_by,
4611: g.creation_date
4612: from ff_globals_f g
4613: where g.legislation_code = 'JP'
4614: and not exists(
4615: select null
4616: from ff_globals_f g2

Line 4616: from ff_globals_f g2

4612: from ff_globals_f g
4613: where g.legislation_code = 'JP'
4614: and not exists(
4615: select null
4616: from ff_globals_f g2
4617: where g2.global_id = g.global_id
4618: and g2.effective_start_date < g.effective_start_date);
4619: --
4620: begin

Line 4964: FROM ff_globals_f

4960: hr_utility.set_location(l_proc, 70);
4961:
4962: SELECT COUNT(1)
4963: INTO l_count
4964: FROM ff_globals_f
4965: WHERE legislation_code = 'JP'
4966: AND ASCII(SUBSTR(global_name,3,1)) > 127
4967: AND global_description NOT LIKE '%Obsoleted';
4968: