APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_USER_COLUMNS

Line 3881: type t_column_names_tab is table of pay_user_columns.user_column_name%TYPE index by binary_integer;

3877: procedure migrate_user_columns is
3878: --
3879: type t_jp_column_names_tab is table of VARCHAR2(200) index by binary_integer;
3880:
3881: type t_column_names_tab is table of pay_user_columns.user_column_name%TYPE index by binary_integer;
3882:
3883: l_jp_column_names_tab t_jp_column_names_tab;
3884: l_column_names_tab t_column_names_tab;
3885:

Line 4158: UPDATE pay_user_columns

4154: hr_utility.trace('+----------------------------------+ ');
4155: end if;
4156: --
4157:
4158: UPDATE pay_user_columns
4159: SET user_column_name = 'RATE'
4160: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E78E87','AL32UTF8')
4161: AND legislation_code = 'JP'
4162: AND user_table_id IN (

Line 4174: UPDATE pay_user_columns

4170: AND legislation_code = 'JP');
4171:
4172: hr_utility.set_location(l_proc, 30);
4173:
4174: UPDATE pay_user_columns
4175: SET user_column_name = 'EXM'
4176: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4177: AND legislation_code = 'JP'
4178: AND user_table_id IN (

Line 4188: UPDATE pay_user_columns

4184: AND legislation_code = 'JP');
4185:
4186: hr_utility.set_location(l_proc, 40);
4187:
4188: UPDATE pay_user_columns
4189: SET user_column_name = 'STD_DCT'
4190: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4191: AND legislation_code = 'JP'
4192: AND user_table_id = (

Line 4202: UPDATE pay_user_columns

4198: hr_utility.set_location(l_proc, 50);
4199:
4200: FORALL l_tab_cnt IN 1..l_jp_column_names_tab.COUNT
4201:
4202: UPDATE pay_user_columns
4203: SET user_column_name = l_column_names_tab(l_tab_cnt)
4204: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar(l_jp_column_names_tab(l_tab_cnt),'AL32UTF8')
4205: AND legislation_code = 'JP';
4206:

Line 5002: FROM pay_user_columns

4998: hr_utility.set_location(l_proc, 100);
4999:
5000: SELECT COUNT(1)
5001: INTO l_count
5002: FROM pay_user_columns
5003: WHERE legislation_code = 'JP'
5004: AND ASCII(user_column_name) > 127;
5005:
5006: IF (l_count > 0) THEN