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.

[Home] [Help]

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on HR_JP_STANDARD_PKG

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

1089: --
1090: -- update COM_LTX_LUMP_SUM_WITHHOLD_PROC elm from ITX to LTX for l_jp_input_names_tab(263) update
1091: UPDATE pay_input_values_f
1092: SET name = 'LTX'
1093: WHERE name LIKE hr_jp_standard_pkg.hextochar('E5BEB4E58F8EE7A88EE9A18D','AL32UTF8')
1094: AND legislation_code = 'JP'
1095: AND element_type_id IN (
1096: SELECT element_type_id
1097: FROM pay_element_types_f

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

1094: AND legislation_code = 'JP'
1095: AND element_type_id IN (
1096: SELECT element_type_id
1097: FROM pay_element_types_f
1098: WHERE element_name LIKE hr_jp_standard_pkg.hextochar('E585B1EFBCBFE59FBAE69CACEFBCBFE4BD8FE6B091E7A88EEFBCBFE4B880E68BACE5BEB4E58F8E','AL32UTF8')
1099: AND legislation_code = 'JP' );
1100:
1101: -- update BON_WP_PREM_PROC (, SAL_HI_PREM_PROC, BON_HI_PREM_PROC) elm from WP_PREM_ER to INS_PREM_ER for l_jp_input_names_tab(173) update
1102: -- however looks this is not required if l_jp_input_names_tab(173) update to INS_PREM_ER from first..but keep this for safe

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

1101: -- update BON_WP_PREM_PROC (, SAL_HI_PREM_PROC, BON_HI_PREM_PROC) elm from WP_PREM_ER to INS_PREM_ER for l_jp_input_names_tab(173) update
1102: -- however looks this is not required if l_jp_input_names_tab(173) update to INS_PREM_ER from first..but keep this for safe
1103: UPDATE pay_input_values_f
1104: SET name = 'INS_PREM_ER'
1105: WHERE name LIKE hr_jp_standard_pkg.hextochar('E4BA8BE6A5ADE4B8BBE58886E4BF9DE999BAE69699','AL32UTF8')
1106: AND legislation_code = 'JP'
1107: AND element_type_id IN (
1108: SELECT element_type_id
1109: FROM pay_element_types_f

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

1107: AND element_type_id IN (
1108: SELECT element_type_id
1109: FROM pay_element_types_f
1110: WHERE element_name IN
1111: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1112: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1113: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1114: AND legislation_code = 'JP' );
1115:

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

1108: SELECT element_type_id
1109: FROM pay_element_types_f
1110: WHERE element_name IN
1111: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1112: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1113: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1114: AND legislation_code = 'JP' );
1115:
1116: -- update BON_WP_PREM_PROC (, SAL_HI_PREM_PROC, BON_HI_PREM_PROC) elm from WP_PREM_EE to INS_PREM_EE for l_jp_input_names_tab(308) update

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

1109: FROM pay_element_types_f
1110: WHERE element_name IN
1111: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1112: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1113: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1114: AND legislation_code = 'JP' );
1115:
1116: -- update BON_WP_PREM_PROC (, SAL_HI_PREM_PROC, BON_HI_PREM_PROC) elm from WP_PREM_EE to INS_PREM_EE for l_jp_input_names_tab(308) update
1117: -- however looks this is not required if l_jp_input_names_tab(308) update to INS_PREM_EE from first..but keep this for safe

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

1116: -- update BON_WP_PREM_PROC (, SAL_HI_PREM_PROC, BON_HI_PREM_PROC) elm from WP_PREM_EE to INS_PREM_EE for l_jp_input_names_tab(308) update
1117: -- however looks this is not required if l_jp_input_names_tab(308) update to INS_PREM_EE from first..but keep this for safe
1118: UPDATE pay_input_values_f
1119: SET name = 'INS_PREM_EE'
1120: WHERE name LIKE hr_jp_standard_pkg.hextochar('E8A2ABE4BF9DE999BAE88085E58886E4BF9DE999BAE69699','AL32UTF8')
1121: AND legislation_code = 'JP'
1122: AND element_type_id IN (
1123: SELECT element_type_id
1124: FROM pay_element_types_f

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

1122: AND element_type_id IN (
1123: SELECT element_type_id
1124: FROM pay_element_types_f
1125: WHERE element_name IN
1126: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1127: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1128: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1129: AND legislation_code = 'JP' );
1130:

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

1123: SELECT element_type_id
1124: FROM pay_element_types_f
1125: WHERE element_name IN
1126: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1127: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1128: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1129: AND legislation_code = 'JP' );
1130:
1131:

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

1124: FROM pay_element_types_f
1125: WHERE element_name IN
1126: (hr_jp_standard_pkg.hextochar('E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1127: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699','AL32UTF8'),
1128: hr_jp_standard_pkg.hextochar('E8B39EEFBCBFE59FBAE69CACEFBCBFE58E9AE5B9B4EFBCBFE4BF9DE999BAE69699','AL32UTF8'))
1129: AND legislation_code = 'JP' );
1130:
1131:
1132: FORALL l_tab_cnt IN 1..l_jp_input_names_tab.COUNT

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

1132: FORALL l_tab_cnt IN 1..l_jp_input_names_tab.COUNT
1133:
1134: UPDATE pay_input_values_f
1135: SET name = l_input_names_tab(l_tab_cnt)
1136: WHERE name LIKE hr_jp_standard_pkg.hextochar(l_jp_input_names_tab(l_tab_cnt),'AL32UTF8')
1137: AND legislation_code = 'JP';
1138:
1139:
1140: hr_utility.set_location(l_proc, 30);

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

2044: UPDATE pay_element_types_f
2045: SET element_name = l_element_names_tab(l_tab_cnt),
2046: description = l_element_desc_tab(l_tab_cnt),
2047: reporting_name = l_element_rep_tab(l_tab_cnt)
2048: WHERE element_name LIKE hr_jp_standard_pkg.hextochar(l_jp_element_names_tab(l_tab_cnt),'AL32UTF8')
2049: AND legislation_code = 'JP';
2050:
2051: UPDATE pay_element_types_f
2052: SET description = description || 'Obsoleted'

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

3041:
3042: UPDATE pay_balance_types
3043: SET balance_name = l_bal_names_tab(l_tab_cnt),
3044: reporting_name = l_bal_rep_tab(l_tab_cnt)
3045: WHERE balance_name LIKE hr_jp_standard_pkg.hextochar(l_jp_bal_names_tab(l_tab_cnt),'AL32UTF8')
3046: AND legislation_code = 'JP';
3047:
3048: UPDATE pay_balance_types
3049: SET reporting_name = reporting_name || 'Obsoleted'

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

3175: UPDATE pay_balance_dimensions
3176: SET dimension_name = l_dim_names_tab(l_tab_cnt),
3177: database_item_suffix = l_dim_suffix_tab(l_tab_cnt),
3178: description = l_dim_desc_tab(l_tab_cnt)
3179: WHERE dimension_name LIKE hr_jp_standard_pkg.hextochar(l_jp_dim_names_tab(l_tab_cnt),'AL32UTF8')
3180: AND legislation_code = 'JP';
3181:
3182: hr_utility.set_location(l_proc, 30);
3183:

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

3239: FORALL l_tab_cnt IN 1..l_jp_ele_set_names_tab.COUNT
3240:
3241: UPDATE pay_element_sets
3242: SET element_set_name = l_ele_set_names_tab(l_tab_cnt)
3243: WHERE element_set_name LIKE hr_jp_standard_pkg.hextochar(l_jp_ele_set_names_tab(l_tab_cnt),'AL32UTF8')
3244: AND legislation_code = 'JP';
3245:
3246: hr_utility.set_location(l_proc, 30);
3247:

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

3412:
3413: UPDATE ff_globals_f
3414: SET global_name = l_global_names_tab(l_tab_cnt),
3415: global_description = l_global_desc_tab(l_tab_cnt)
3416: WHERE global_name LIKE hr_jp_standard_pkg.hextochar(l_jp_global_names_tab(l_tab_cnt),'AL32UTF8')
3417: AND legislation_code = 'JP';
3418: --
3419: -- unset for subsequent procedure to enable trigger
3420: hr_general.g_data_migrator_mode := l_status_mode;

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

3817:
3818: UPDATE ff_formulas_f
3819: SET formula_name = l_formula_names_tab(l_tab_cnt),
3820: description = l_formula_desc_tab(l_tab_cnt)
3821: WHERE formula_name LIKE hr_jp_standard_pkg.hextochar(l_jp_formula_names_tab(l_tab_cnt),'AL32UTF8')
3822: AND legislation_code = 'JP';
3823:
3824: UPDATE ff_formulas_f
3825: SET description = description || 'Obsoleted'

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

3887: FORALL l_tab_cnt IN 1..l_jp_monetary_name_tab.COUNT
3888:
3889: UPDATE pay_monetary_units
3890: SET monetary_unit_name = l_monetary_name_tab(l_tab_cnt)
3891: WHERE monetary_unit_name LIKE hr_jp_standard_pkg.hextochar(l_jp_monetary_name_tab(l_tab_cnt),'AL32UTF8')
3892: AND legislation_code = 'JP';
3893:
3894: hr_utility.set_location(l_proc, 30);
3895:

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

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 (
4202: SELECT user_table_id
4203: FROM pay_user_tables

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

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

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

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

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

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'),
4208: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE79FADE69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'))
4209: AND legislation_code = 'JP');
4210:
4211: hr_utility.set_location(l_proc, 30);

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

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'),
4208: hr_jp_standard_pkg.hextochar('54EFBCBFE5B9B4EFBCBFE79FADE69C9FE6908DE5AEB3E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8','AL32UTF8'))
4209: AND legislation_code = 'JP');
4210:
4211: hr_utility.set_location(l_proc, 30);
4212:

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

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 (
4218: SELECT user_table_id
4219: FROM pay_user_tables

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

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

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

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');
4224:
4225: hr_utility.set_location(l_proc, 40);
4226:

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

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 = (
4232: SELECT user_table_id
4233: FROM pay_user_tables

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

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

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

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

4412: FORALL l_tab_cnt IN 1..l_jp_row_names_tab.COUNT
4413:
4414: UPDATE pay_user_rows_f
4415: SET row_low_range_or_name = l_row_names_tab(l_tab_cnt)
4416: WHERE row_low_range_or_name LIKE hr_jp_standard_pkg.hextochar(l_jp_row_names_tab(l_tab_cnt),'AL32UTF8')
4417: AND legislation_code = 'JP';
4418:
4419: hr_utility.set_location(l_proc, 30);
4420:

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

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';
4617:
4618: hr_utility.set_location(l_proc, 30);
4619:

Line 4689: decode(fgt.global_name,hr_jp_standard_pkg.sjhextochar('478151944E815192E897A68CB890C597A6'),

4685: --there is translation bug so workaround
4686: --and fdit.user_name = decode(fgt.language,'US',fg.global_name,'JA',fgt.global_name,null)
4687: and fdit.user_name in (
4688: decode(fgt.language,'US',fg.global_name,'JA',fgt.global_name,null),
4689: decode(fgt.global_name,hr_jp_standard_pkg.sjhextochar('478151944E815192E897A68CB890C597A6'),
4690: hr_jp_standard_pkg.sjhextochar('478151944E815192E897A68CB890C597BF97A6'),null))
4691: and not exists(
4692: select null
4693: from ff_database_items fdi

Line 4690: hr_jp_standard_pkg.sjhextochar('478151944E815192E897A68CB890C597BF97A6'),null))

4686: --and fdit.user_name = decode(fgt.language,'US',fg.global_name,'JA',fgt.global_name,null)
4687: and fdit.user_name in (
4688: decode(fgt.language,'US',fg.global_name,'JA',fgt.global_name,null),
4689: decode(fgt.global_name,hr_jp_standard_pkg.sjhextochar('478151944E815192E897A68CB890C597A6'),
4690: hr_jp_standard_pkg.sjhextochar('478151944E815192E897A68CB890C597BF97A6'),null))
4691: and not exists(
4692: select null
4693: from ff_database_items fdi
4694: where fdi.user_entity_id = fdit.user_entity_id

Line 6752: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),

6748: '_BASIC_ITX_E2',''),
6749: '_ITX_E2',''),
6750: '_BASIC_AMT_E2','')),-1)
6751: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6752: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6753: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),

Line 6753: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),

6749: '_ITX_E2',''),
6750: '_BASIC_AMT_E2','')),-1)
6751: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6752: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6753: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),

Line 6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),

6750: '_BASIC_AMT_E2','')),-1)
6751: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6752: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6753: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6758: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),

Line 6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),

6751: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6752: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6753: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6758: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6759: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1);

Line 6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),

6752: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6753: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6758: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6759: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1);
6760: --

Line 6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),

6753: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6758: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6759: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1);
6760: --
6761: begin

Line 6758: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),

6754: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6758: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6759: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1);
6760: --
6761: begin
6762: --

Line 6759: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1);

6755: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6756: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6757: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6758: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6759: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1);
6760: --
6761: begin
6762: --
6763: if (g_dbg) then

Line 6818: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),

6814: '_BASIC_ITX_E2',''),
6815: '_ITX_E2',''),
6816: '_BASIC_AMT_E2','')),-1)
6817: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6818: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6819: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),

Line 6819: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),

6815: '_ITX_E2',''),
6816: '_BASIC_AMT_E2','')),-1)
6817: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6818: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6819: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),

Line 6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),

6816: '_BASIC_AMT_E2','')),-1)
6817: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6818: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6819: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),

Line 6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),

6817: <> nvl(to_single_byte(replace(replace(replace(replace(replace(replace(replace(replace(fdit.translated_user_name,
6818: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6819: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6825: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1));

Line 6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),

6818: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C315F8D629793'),''),
6819: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6825: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1));
6826: --

Line 6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),

6819: hr_jp_standard_pkg.sjhextochar('5481518B8B81518CB990F292A58EFB90C58A7A955C815193FA8A7A955C325F8D629793'),''),
6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6825: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1));
6826: --
6827: -- unset for subsequent procedure to enable trigger

Line 6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),

6820: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC58FAC'),''),
6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6825: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1));
6826: --
6827: -- unset for subsequent procedure to enable trigger
6828: hr_general.g_data_migrator_mode := l_status_mode;

Line 6825: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1));

6821: hr_jp_standard_pkg.sjhextochar('906C81518AEE8F8090C58A7A5F8DC591E5'),''),
6822: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC58FAC'),''),
6823: hr_jp_standard_pkg.sjhextochar('906C815190C58A7A5F8DC591E5'),''),
6824: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC58FAC'),''),
6825: hr_jp_standard_pkg.sjhextochar('81518AEE8F808A7A5F8DC591E5'),'')),-1));
6826: --
6827: -- unset for subsequent procedure to enable trigger
6828: hr_general.g_data_migrator_mode := l_status_mode;
6829: --