APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_USER_TABLES

Line 4164: FROM pay_user_tables

4160: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E78E87','AL32UTF8')
4161: AND legislation_code = 'JP'
4162: AND user_table_id IN (
4163: SELECT user_table_id
4164: FROM pay_user_tables
4165: WHERE user_table_name IN (
4166: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),
4167: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE7949FE591BDE4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),
4168: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE995B7E69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),

Line 4180: FROM pay_user_tables

4176: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4177: AND legislation_code = 'JP'
4178: AND user_table_id IN (
4179: SELECT user_table_id
4180: FROM pay_user_tables
4181: WHERE user_table_name IN (
4182: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE59084E7A8AEE68980E5BE97E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),
4183: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE9858DE581B6E88085E789B9E588A5E68EA7E999A4E9A18DE697A9E8A68BE8A1A8','AL32UTF8'))
4184: AND legislation_code = 'JP');

Line 4194: FROM pay_user_tables

4190: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4191: AND legislation_code = 'JP'
4192: AND user_table_id = (
4193: SELECT user_table_id
4194: FROM pay_user_tables
4195: WHERE user_table_name LIKE hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE7B5A6E4B88EE7AD89E381AEE98791E9A18DE8A1A832','AL32UTF8')
4196: AND legislation_code = 'JP');
4197:
4198: hr_utility.set_location(l_proc, 50);

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

4392: procedure migrate_user_tables is
4393: --
4394: type t_jp_table_names_tab is table of VARCHAR2(200) index by binary_integer;
4395:
4396: type t_table_names_tab is table of pay_user_tables.user_table_name%TYPE index by binary_integer;
4397:
4398: type t_row_titles_tab is table of pay_user_tables.user_row_title%TYPE index by binary_integer;
4399:
4400: l_jp_table_names_tab t_jp_table_names_tab;

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

4394: type t_jp_table_names_tab is table of VARCHAR2(200) index by binary_integer;
4395:
4396: type t_table_names_tab is table of pay_user_tables.user_table_name%TYPE index by binary_integer;
4397:
4398: type t_row_titles_tab is table of pay_user_tables.user_row_title%TYPE index by binary_integer;
4399:
4400: l_jp_table_names_tab t_jp_table_names_tab;
4401: l_table_names_tab t_table_names_tab;
4402: l_row_titles_tab t_row_titles_tab;

Line 4564: UPDATE pay_user_tables

4560: --
4561:
4562: FORALL l_tab_cnt IN 1..l_jp_table_names_tab.COUNT
4563:
4564: UPDATE pay_user_tables
4565: SET user_table_name = l_table_names_tab(l_tab_cnt),
4566: user_row_title = l_row_titles_tab(l_tab_cnt)
4567: WHERE user_table_name LIKE hr_jp_standard_pkg.hextochar(l_jp_table_names_tab(l_tab_cnt),'AL32UTF8')
4568: AND legislation_code = 'JP';

Line 5026: FROM pay_user_tables

5022: hr_utility.set_location(l_proc, 120);
5023:
5024: SELECT COUNT(1)
5025: INTO l_count
5026: FROM pay_user_tables
5027: WHERE legislation_code = 'JP'
5028: AND ASCII(SUBSTR(user_table_name,3,1)) > 127;
5029:
5030: IF (l_count > 0) THEN