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 HR_JP_STANDARD_PKG

Line 1075: WHERE name LIKE hr_jp_standard_pkg.hextochar('E5BEB4E58F8EE7A88EE9A18D','AL32UTF8')

1071: --
1072:
1073: UPDATE pay_input_values_f
1074: SET name = 'LTX'
1075: WHERE name LIKE hr_jp_standard_pkg.hextochar('E5BEB4E58F8EE7A88EE9A18D','AL32UTF8')
1076: AND legislation_code = 'JP'
1077: AND element_type_id IN (
1078: SELECT element_type_id
1079: FROM pay_element_types_f

Line 1080: WHERE element_name LIKE hr_jp_standard_pkg.hextochar('E585B1EFBCBFE59FBAE69CACEFBCBFE4BD8FE6B091E7A88EEFBCBFE4B880E68BACE5BEB4E58F8E','AL32UTF8')

1076: AND legislation_code = 'JP'
1077: AND element_type_id IN (
1078: SELECT element_type_id
1079: FROM pay_element_types_f
1080: WHERE element_name LIKE hr_jp_standard_pkg.hextochar('E585B1EFBCBFE59FBAE69CACEFBCBFE4BD8FE6B091E7A88EEFBCBFE4B880E68BACE5BEB4E58F8E','AL32UTF8')
1081: AND legislation_code = 'JP' );
1082:
1083: UPDATE pay_input_values_f
1084: SET name = 'INS_PREM_ER'

Line 1085: WHERE name LIKE hr_jp_standard_pkg.hextochar('E4BA8BE6A5ADE4B8BBE58886E4BF9DE999BAE69699','AL32UTF8')

1081: AND legislation_code = 'JP' );
1082:
1083: UPDATE pay_input_values_f
1084: SET name = 'INS_PREM_ER'
1085: WHERE name LIKE hr_jp_standard_pkg.hextochar('E4BA8BE6A5ADE4B8BBE58886E4BF9DE999BAE69699','AL32UTF8')
1086: AND legislation_code = 'JP'
1087: AND element_type_id IN (
1088: SELECT element_type_id
1089: FROM pay_element_types_f

Line 1091: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),

1087: AND element_type_id IN (
1088: SELECT element_type_id
1089: FROM pay_element_types_f
1090: WHERE element_name IN
1091: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1092: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1093: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1094: AND legislation_code = 'JP' );
1095:

Line 1092: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),

1088: SELECT element_type_id
1089: FROM pay_element_types_f
1090: WHERE element_name IN
1091: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1092: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1093: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1094: AND legislation_code = 'JP' );
1095:
1096: UPDATE pay_input_values_f

Line 1093: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))

1089: FROM pay_element_types_f
1090: WHERE element_name IN
1091: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1092: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1093: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1094: AND legislation_code = 'JP' );
1095:
1096: UPDATE pay_input_values_f
1097: SET name = 'INS_PREM_EE'

Line 1098: WHERE name LIKE hr_jp_standard_pkg.hextochar('E8A2ABE4BF9DE999BAE88085E58886E4BF9DE999BAE69699','AL32UTF8')

1094: AND legislation_code = 'JP' );
1095:
1096: UPDATE pay_input_values_f
1097: SET name = 'INS_PREM_EE'
1098: WHERE name LIKE hr_jp_standard_pkg.hextochar('E8A2ABE4BF9DE999BAE88085E58886E4BF9DE999BAE69699','AL32UTF8')
1099: AND legislation_code = 'JP'
1100: AND element_type_id IN (
1101: SELECT element_type_id
1102: FROM pay_element_types_f

Line 1104: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),

1100: AND element_type_id IN (
1101: SELECT element_type_id
1102: FROM pay_element_types_f
1103: WHERE element_name IN
1104: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1105: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1106: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1107: AND legislation_code = 'JP' );
1108:

Line 1105: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),

1101: SELECT element_type_id
1102: FROM pay_element_types_f
1103: WHERE element_name IN
1104: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1105: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1106: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1107: AND legislation_code = 'JP' );
1108:
1109:

Line 1106: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))

1102: FROM pay_element_types_f
1103: WHERE element_name IN
1104: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1105: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1106: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1107: AND legislation_code = 'JP' );
1108:
1109:
1110: FORALL l_tab_cnt IN 1..l_jp_input_names_tab.COUNT

Line 1114: WHERE name LIKE hr_jp_standard_pkg.hextochar(l_jp_input_names_tab(l_tab_cnt),'AL32UTF8')

1110: FORALL l_tab_cnt IN 1..l_jp_input_names_tab.COUNT
1111:
1112: UPDATE pay_input_values_f
1113: SET name = l_input_names_tab(l_tab_cnt)
1114: WHERE name LIKE hr_jp_standard_pkg.hextochar(l_jp_input_names_tab(l_tab_cnt),'AL32UTF8')
1115: AND legislation_code = 'JP';
1116:
1117:
1118: hr_utility.set_location(l_proc, 30);

Line 2026: WHERE element_name LIKE hr_jp_standard_pkg.hextochar(l_jp_element_names_tab(l_tab_cnt),'AL32UTF8')

2022: UPDATE pay_element_types_f
2023: SET element_name = l_element_names_tab(l_tab_cnt),
2024: description = l_element_desc_tab(l_tab_cnt),
2025: reporting_name = l_element_rep_tab(l_tab_cnt)
2026: WHERE element_name LIKE hr_jp_standard_pkg.hextochar(l_jp_element_names_tab(l_tab_cnt),'AL32UTF8')
2027: AND legislation_code = 'JP';
2028:
2029: UPDATE pay_element_types_f
2030: SET description = description || 'Obsoleted'

Line 3023: WHERE balance_name LIKE hr_jp_standard_pkg.hextochar(l_jp_bal_names_tab(l_tab_cnt),'AL32UTF8')

3019:
3020: UPDATE pay_balance_types
3021: SET balance_name = l_bal_names_tab(l_tab_cnt),
3022: reporting_name = l_bal_rep_tab(l_tab_cnt)
3023: WHERE balance_name LIKE hr_jp_standard_pkg.hextochar(l_jp_bal_names_tab(l_tab_cnt),'AL32UTF8')
3024: AND legislation_code = 'JP';
3025:
3026: UPDATE pay_balance_types
3027: SET reporting_name = reporting_name || 'Obsoleted'

Line 3157: WHERE dimension_name LIKE hr_jp_standard_pkg.hextochar(l_jp_dim_names_tab(l_tab_cnt),'AL32UTF8')

3153: UPDATE pay_balance_dimensions
3154: SET dimension_name = l_dim_names_tab(l_tab_cnt),
3155: database_item_suffix = l_dim_suffix_tab(l_tab_cnt),
3156: description = l_dim_desc_tab(l_tab_cnt)
3157: WHERE dimension_name LIKE hr_jp_standard_pkg.hextochar(l_jp_dim_names_tab(l_tab_cnt),'AL32UTF8')
3158: AND legislation_code = 'JP';
3159:
3160: hr_utility.set_location(l_proc, 30);
3161:

Line 3221: WHERE element_set_name LIKE hr_jp_standard_pkg.hextochar(l_jp_ele_set_names_tab(l_tab_cnt),'AL32UTF8')

3217: FORALL l_tab_cnt IN 1..l_jp_ele_set_names_tab.COUNT
3218:
3219: UPDATE pay_element_sets
3220: SET element_set_name = l_ele_set_names_tab(l_tab_cnt)
3221: WHERE element_set_name LIKE hr_jp_standard_pkg.hextochar(l_jp_ele_set_names_tab(l_tab_cnt),'AL32UTF8')
3222: AND legislation_code = 'JP';
3223:
3224: hr_utility.set_location(l_proc, 30);
3225:

Line 3381: WHERE global_name LIKE hr_jp_standard_pkg.hextochar(l_jp_global_names_tab(l_tab_cnt),'AL32UTF8')

3377:
3378: UPDATE ff_globals_f
3379: SET global_name = l_global_names_tab(l_tab_cnt),
3380: global_description = l_global_desc_tab(l_tab_cnt)
3381: WHERE global_name LIKE hr_jp_standard_pkg.hextochar(l_jp_global_names_tab(l_tab_cnt),'AL32UTF8')
3382: AND legislation_code = 'JP';
3383:
3384: UPDATE ff_globals_f
3385: SET global_description = global_description || 'Obsoleted'

Line 3783: WHERE formula_name LIKE hr_jp_standard_pkg.hextochar(l_jp_formula_names_tab(l_tab_cnt),'AL32UTF8')

3779:
3780: UPDATE ff_formulas_f
3781: SET formula_name = l_formula_names_tab(l_tab_cnt),
3782: description = l_formula_desc_tab(l_tab_cnt)
3783: WHERE formula_name LIKE hr_jp_standard_pkg.hextochar(l_jp_formula_names_tab(l_tab_cnt),'AL32UTF8')
3784: AND legislation_code = 'JP';
3785:
3786: UPDATE ff_formulas_f
3787: SET description = description || 'Obsoleted'

Line 3853: WHERE monetary_unit_name LIKE hr_jp_standard_pkg.hextochar(l_jp_monetary_name_tab(l_tab_cnt),'AL32UTF8')

3849: FORALL l_tab_cnt IN 1..l_jp_monetary_name_tab.COUNT
3850:
3851: UPDATE pay_monetary_units
3852: SET monetary_unit_name = l_monetary_name_tab(l_tab_cnt)
3853: WHERE monetary_unit_name LIKE hr_jp_standard_pkg.hextochar(l_jp_monetary_name_tab(l_tab_cnt),'AL32UTF8')
3854: AND legislation_code = 'JP';
3855:
3856: hr_utility.set_location(l_proc, 30);
3857:

Line 4160: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E78E87','AL32UTF8')

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 (
4163: SELECT user_table_id
4164: FROM pay_user_tables

Line 4166: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),

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'),
4169: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE79FADE69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'))
4170: AND legislation_code = 'JP');

Line 4167: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE7949FE591BDE4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),

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'),
4169: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE79FADE69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'))
4170: AND legislation_code = 'JP');
4171:

Line 4168: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE995B7E69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),

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'),
4169: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE79FADE69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'))
4170: AND legislation_code = 'JP');
4171:
4172: hr_utility.set_location(l_proc, 30);

Line 4169: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE79FADE69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'))

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'),
4169: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE79FADE69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'))
4170: AND legislation_code = 'JP');
4171:
4172: hr_utility.set_location(l_proc, 30);
4173:

Line 4176: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')

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 (
4179: SELECT user_table_id
4180: FROM pay_user_tables

Line 4182: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE59084E7A8AEE68980E5BE97E68EA7E999A4E9A18DE8A1A8','AL32UTF8'),

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');
4185:
4186: hr_utility.set_location(l_proc, 40);

Line 4183: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE9858DE581B6E88085E789B9E588A5E68EA7E999A4E9A18DE697A9E8A68BE8A1A8','AL32UTF8'))

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');
4185:
4186: hr_utility.set_location(l_proc, 40);
4187:

Line 4190: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')

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 = (
4193: SELECT user_table_id
4194: FROM pay_user_tables

Line 4195: WHERE user_table_name LIKE hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68980E5BE97E68EA7E999A4E5BE8CE381AEE7B5A6E4B88EE7AD89E381AEE98791E9A18DE8A1A832','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);
4199:

Line 4204: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar(l_jp_column_names_tab(l_tab_cnt),'AL32UTF8')

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:
4207: hr_utility.set_location(l_proc, 60);
4208:

Line 4368: WHERE row_low_range_or_name LIKE hr_jp_standard_pkg.hextochar(l_jp_row_names_tab(l_tab_cnt),'AL32UTF8')

4364: FORALL l_tab_cnt IN 1..l_jp_row_names_tab.COUNT
4365:
4366: UPDATE pay_user_rows_f
4367: SET row_low_range_or_name = l_row_names_tab(l_tab_cnt)
4368: WHERE row_low_range_or_name LIKE hr_jp_standard_pkg.hextochar(l_jp_row_names_tab(l_tab_cnt),'AL32UTF8')
4369: AND legislation_code = 'JP';
4370:
4371: hr_utility.set_location(l_proc, 30);
4372:

Line 4567: WHERE user_table_name LIKE hr_jp_standard_pkg.hextochar(l_jp_table_names_tab(l_tab_cnt),'AL32UTF8')

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';
4569:
4570: hr_utility.set_location(l_proc, 30);
4571: