APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_USER_TABLES

Line 4203: FROM pay_user_tables

4199: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E78E87','AL32UTF8')
4200: AND legislation_code = 'JP'
4201: AND user_table_id IN (
4202: SELECT user_table_id
4203: FROM pay_user_tables
4204: WHERE user_table_name IN (
4205: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),
4206: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE7949FE591BDE4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),
4207: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE995B7E69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),

Line 4219: FROM pay_user_tables

4215: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4216: AND legislation_code = 'JP'
4217: AND user_table_id IN (
4218: SELECT user_table_id
4219: FROM pay_user_tables
4220: WHERE user_table_name IN (
4221: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE59084E7A8AEE68980E5BE97E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),
4222: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE9858DE581B6E88085E789B9E588A5E68EA7E999A4E9A18DE697A9E8A68BE8A1A8','AL32UTF8'))
4223: AND legislation_code = 'JP');

Line 4233: FROM pay_user_tables

4229: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4230: AND legislation_code = 'JP'
4231: AND user_table_id = (
4232: SELECT user_table_id
4233: FROM pay_user_tables
4234: WHERE user_table_name LIKE hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE7B5A6E4B88EE7AD89E381AEE98791E9A18DE8A1A832','AL32UTF8')
4235: AND legislation_code = 'JP');
4236:
4237: hr_utility.set_location(l_proc, 50);

Line 4444: type t_table_names_tab is table of pay_user_tables.user_table_name%TYPE index by binary_integer;

4440: procedure migrate_user_tables is
4441: --
4442: type t_jp_table_names_tab is table of VARCHAR2(200) index by binary_integer;
4443:
4444: type t_table_names_tab is table of pay_user_tables.user_table_name%TYPE index by binary_integer;
4445:
4446: type t_row_titles_tab is table of pay_user_tables.user_row_title%TYPE index by binary_integer;
4447:
4448: l_jp_table_names_tab t_jp_table_names_tab;

Line 4446: type t_row_titles_tab is table of pay_user_tables.user_row_title%TYPE index by binary_integer;

4442: type t_jp_table_names_tab is table of VARCHAR2(200) index by binary_integer;
4443:
4444: type t_table_names_tab is table of pay_user_tables.user_table_name%TYPE index by binary_integer;
4445:
4446: type t_row_titles_tab is table of pay_user_tables.user_row_title%TYPE index by binary_integer;
4447:
4448: l_jp_table_names_tab t_jp_table_names_tab;
4449: l_table_names_tab t_table_names_tab;
4450: l_row_titles_tab t_row_titles_tab;

Line 4612: UPDATE pay_user_tables

4608: --
4609:
4610: FORALL l_tab_cnt IN 1..l_jp_table_names_tab.COUNT
4611:
4612: UPDATE pay_user_tables
4613: SET user_table_name = l_table_names_tab(l_tab_cnt),
4614: user_row_title = l_row_titles_tab(l_tab_cnt)
4615: WHERE user_table_name LIKE hr_jp_standard_pkg.hextochar(l_jp_table_names_tab(l_tab_cnt),'AL32UTF8')
4616: AND legislation_code = 'JP';

Line 5285: from pay_user_tables put

5281: --
5282: cursor csr_udt_cnt
5283: is
5284: select count(put.user_table_id)
5285: from pay_user_tables put
5286: where put.legislation_code = 'JP'
5287: and ascii(substr(put.user_table_name,3,1)) <= 127
5288: and exists(
5289: select null

Line 5290: from pay_user_tables put2

5286: where put.legislation_code = 'JP'
5287: and ascii(substr(put.user_table_name,3,1)) <= 127
5288: and exists(
5289: select null
5290: from pay_user_tables put2
5291: where put2.legislation_code = 'JP'
5292: and ascii(substr(put2.user_table_name,3,1)) > 127);
5293: --
5294: cursor csr_glb(

Line 6583: -- from pay_user_tables put

6579: -- l_dummy := null;
6580: -- --
6581: -- select put.user_table_name
6582: -- into l_dummy
6583: -- from pay_user_tables put
6584: -- where put.user_table_name = l_udt_tbl(l_udt_ind)
6585: -- and put.legislation_code = 'JP';
6586: -- --
6587: -- if (g_dbg) then

Line 6620: update pay_user_tables

6616: -- end if;
6617: --
6618: -- use bulk collect
6619: forall l_udt_ind in 1..l_udt_tbl.count
6620: update pay_user_tables
6621: set user_table_name = substrb(user_table_name,1,80-4)||'_OBS',
6622: user_row_title = substrb(user_row_title,1,80-4)||'_OBS'
6623: where user_table_name = l_udt_tbl(l_udt_ind)
6624: and legislation_code = 'JP';

Line 7015: FROM pay_user_tables

7011: hr_utility.set_location(l_proc, 120);
7012:
7013: SELECT COUNT(1)
7014: INTO l_count
7015: FROM pay_user_tables
7016: WHERE legislation_code = 'JP'
7017: AND ASCII(SUBSTR(user_table_name,3,1)) > 127;
7018:
7019: IF (l_count > 0) THEN