APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PAY_USER_COLUMNS

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

3915: procedure migrate_user_columns is
3916: --
3917: type t_jp_column_names_tab is table of VARCHAR2(200) index by binary_integer;
3918:
3919: type t_column_names_tab is table of pay_user_columns.user_column_name%TYPE index by binary_integer;
3920:
3921: l_jp_column_names_tab t_jp_column_names_tab;
3922: l_column_names_tab t_column_names_tab;
3923:

Line 4197: UPDATE pay_user_columns

4193: hr_utility.trace('+----------------------------------+ ');
4194: end if;
4195: --
4196:
4197: UPDATE pay_user_columns
4198: SET user_column_name = 'RATE'
4199: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E78E87','AL32UTF8')
4200: AND legislation_code = 'JP'
4201: AND user_table_id IN (

Line 4213: UPDATE pay_user_columns

4209: AND legislation_code = 'JP');
4210:
4211: hr_utility.set_location(l_proc, 30);
4212:
4213: UPDATE pay_user_columns
4214: SET user_column_name = 'EXM'
4215: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4216: AND legislation_code = 'JP'
4217: AND user_table_id IN (

Line 4227: UPDATE pay_user_columns

4223: AND legislation_code = 'JP');
4224:
4225: hr_utility.set_location(l_proc, 40);
4226:
4227: UPDATE pay_user_columns
4228: SET user_column_name = 'STD_DCT'
4229: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')
4230: AND legislation_code = 'JP'
4231: AND user_table_id = (

Line 4241: UPDATE pay_user_columns

4237: hr_utility.set_location(l_proc, 50);
4238:
4239: FORALL l_tab_cnt IN 1..l_jp_column_names_tab.COUNT
4240:
4241: UPDATE pay_user_columns
4242: SET user_column_name = l_column_names_tab(l_tab_cnt)
4243: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar(l_jp_column_names_tab(l_tab_cnt),'AL32UTF8')
4244: AND legislation_code = 'JP';
4245:

Line 6991: FROM pay_user_columns

6987: hr_utility.set_location(l_proc, 100);
6988:
6989: SELECT COUNT(1)
6990: INTO l_count
6991: FROM pay_user_columns
6992: WHERE legislation_code = 'JP'
6993: AND ASCII(user_column_name) > 127;
6994:
6995: IF (l_count > 0) THEN