eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_GLOBALS_F

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

3267: procedure migrate_globals is
3268: --
3269: type t_jp_global_names_tab is table of VARCHAR2(200) index by binary_integer;
3270:
3271: type t_global_names_tab is table of ff_globals_f.global_name%TYPE index by binary_integer;
3272:
3273: type t_global_desc_tab is table of ff_globals_f.global_description%TYPE index by binary_integer;
3274:
3275: l_jp_global_names_tab t_jp_global_names_tab;

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

3269: type t_jp_global_names_tab is table of VARCHAR2(200) index by binary_integer;
3270:
3271: type t_global_names_tab is table of ff_globals_f.global_name%TYPE index by binary_integer;
3272:
3273: type t_global_desc_tab is table of ff_globals_f.global_description%TYPE index by binary_integer;
3274:
3275: l_jp_global_names_tab t_jp_global_names_tab;
3276: l_global_names_tab t_global_names_tab;
3277: l_global_desc_tab t_global_desc_tab;

Line 3403: -- this is required to set for FF_GLOBALS_F_BRU trigger

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
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';

Line 3404: -- FF_GLOBALS_F_MNT_TL_ARU also will be disabled

3400: --
3401: if nvl(l_status_mode,'N') <> 'Y' then
3402: --
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: --

Line 3413: UPDATE ff_globals_f

3409: end if;
3410: --
3411: FORALL l_tab_cnt IN 1..l_jp_global_names_tab.COUNT
3412:
3413: UPDATE ff_globals_f
3414: SET global_name = l_global_names_tab(l_tab_cnt),
3415: global_description = l_global_desc_tab(l_tab_cnt)
3416: WHERE global_name LIKE hr_jp_standard_pkg.hextochar(l_jp_global_names_tab(l_tab_cnt),'AL32UTF8')
3417: AND legislation_code = 'JP';

Line 3422: UPDATE ff_globals_f

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
3425: AND legislation_code = 'JP';
3426:

Line 4664: from ff_globals_f g

4660: g.business_group_id,
4661: g.legislation_code,
4662: g.created_by,
4663: g.creation_date
4664: from ff_globals_f g
4665: where g.legislation_code = 'JP'
4666: and not exists(
4667: select null
4668: from ff_globals_f g2

Line 4668: from ff_globals_f g2

4664: from ff_globals_f g
4665: where g.legislation_code = 'JP'
4666: and not exists(
4667: select null
4668: from ff_globals_f g2
4669: where g2.global_id = g.global_id
4670: and g2.effective_start_date < g.effective_start_date);
4671: --
4672: cursor csr_corrupt_dbi_tl

Line 4675: from ff_globals_f fg,

4671: --
4672: cursor csr_corrupt_dbi_tl
4673: is
4674: select fdit.rowid row_id
4675: from ff_globals_f fg,
4676: ff_globals_f_tl fgt,
4677: ff_database_items_tl fdit
4678: where fg.legislation_code = 'JP'
4679: and fg.effective_start_date = (

Line 4676: ff_globals_f_tl fgt,

4672: cursor csr_corrupt_dbi_tl
4673: is
4674: select fdit.rowid row_id
4675: from ff_globals_f fg,
4676: ff_globals_f_tl fgt,
4677: ff_database_items_tl fdit
4678: where fg.legislation_code = 'JP'
4679: and fg.effective_start_date = (
4680: select max(fg2.effective_start_date)

Line 4681: from ff_globals_f fg2

4677: ff_database_items_tl fdit
4678: where fg.legislation_code = 'JP'
4679: and fg.effective_start_date = (
4680: select max(fg2.effective_start_date)
4681: from ff_globals_f fg2
4682: where fg2.global_id = fg.global_id)
4683: and fgt.global_id = fg.global_id
4684: and fgt.language in ('US','JA')
4685: --there is translation bug so workaround

Line 4702: from ff_globals_f fg,

4698: is
4699: select fdi.user_entity_id,
4700: fdi.user_name,
4701: fdi.description
4702: from ff_globals_f fg,
4703: ff_user_entities fue,
4704: ff_database_items fdi
4705: where fg.legislation_code = 'JP'
4706: and fg.effective_start_date = (

Line 4708: from ff_globals_f fg2

4704: ff_database_items fdi
4705: where fg.legislation_code = 'JP'
4706: and fg.effective_start_date = (
4707: select max(fg2.effective_start_date)
4708: from ff_globals_f fg2
4709: where fg2.global_id = fg.global_id)
4710: and fue.legislation_code = 'JP'
4711: and fue.creator_id = fg.global_id
4712: and fue.creator_type = 'S'

Line 5237: from ff_globals_f fg

5233: --
5234: cursor csr_glb_cnt
5235: is
5236: select count(fg.global_id)
5237: from ff_globals_f fg
5238: where fg.legislation_code = 'JP'
5239: and ascii(substr(fg.global_name,3,1)) <= 127
5240: and fg.global_name not in (
5241: 'G_TRM_LTX_SP_WITHHOLD_DCTBL_RATE',

Line 5246: from ff_globals_f fg2

5242: 'G_TRM_LTX_SP_WITHHOLD_MUNICIPAL_TAX_RATE',
5243: 'G_TRM_LTX_SP_WITHHOLD_PREFECTURAL_TAX_RATE')
5244: and exists(
5245: select null
5246: from ff_globals_f fg2
5247: where fg2.legislation_code = 'JP'
5248: and ascii(substr(fg2.global_name,3,1)) > 127
5249: and fg2.global_description not like '%Obsoleted');
5250: --

Line 5300: from ff_globals_f fg

5296: is
5297: select fg.global_id,
5298: fg.global_name,
5299: fg.global_description
5300: from ff_globals_f fg
5301: where fg.global_name = substrb(p_glb_name,1,80-4)||'_OBS'
5302: and fg.global_description like '% (Obsolete)'
5303: and fg.legislation_code = 'JP'
5304: and fg.effective_start_date = (

Line 5306: from ff_globals_f fg2

5302: and fg.global_description like '% (Obsolete)'
5303: and fg.legislation_code = 'JP'
5304: and fg.effective_start_date = (
5305: select max(fg2.effective_start_date)
5306: from ff_globals_f fg2
5307: where fg2.global_id = fg.global_id);
5308: --
5309: begin
5310: --

Line 6173: -- from ff_globals_f fg

6169: -- l_dummy := null;
6170: -- --
6171: -- select fg.global_name
6172: -- into l_dummy
6173: -- from ff_globals_f fg
6174: -- where fg.global_name = l_glb_tbl(l_glb_ind)
6175: -- and fg.legislation_code = 'JP'
6176: -- and fg.effective_start_date = (
6177: -- select max(fg2.effective_start_date)

Line 6178: -- from ff_globals_f fg2

6174: -- where fg.global_name = l_glb_tbl(l_glb_ind)
6175: -- and fg.legislation_code = 'JP'
6176: -- and fg.effective_start_date = (
6177: -- select max(fg2.effective_start_date)
6178: -- from ff_globals_f fg2
6179: -- where fg2.global_id = fg.global_id);
6180: -- --
6181: -- if (g_dbg) then
6182: -- hr_utility.trace('fix_hr_corrupt, update glb : '||l_dummy);

Line 6216: -- this is required to set for FF_GLOBALS_F_BRU trigger

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
6217: -- FF_GLOBALS_F_MNT_TL_ARU also will be disabled
6218: --
6219: hr_general.g_data_migrator_mode := 'Y';
6220: --

Line 6217: -- FF_GLOBALS_F_MNT_TL_ARU also will be disabled

6213: --
6214: if nvl(l_status_mode,'N') <> 'Y' then
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;

Line 6225: update ff_globals_f

6221: end if;
6222: --
6223: -- use bulk collect
6224: forall l_glb_ind in 1..l_glb_tbl.count
6225: update ff_globals_f
6226: set global_name = substrb(global_name,1,80-4)||'_OBS',
6227: global_description = substrb(global_description,1,240-11)||' (Obsolete)'
6228: where global_name = l_glb_tbl(l_glb_ind)
6229: and legislation_code = 'JP';

Line 6953: FROM ff_globals_f

6949: hr_utility.set_location(l_proc, 70);
6950:
6951: SELECT COUNT(1)
6952: INTO l_count
6953: FROM ff_globals_f
6954: WHERE legislation_code = 'JP'
6955: AND ASCII(SUBSTR(global_name,3,1)) > 127
6956: AND global_description NOT LIKE '%Obsoleted';
6957: