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 STANDARD

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 1330: l_element_rep_tab(29) := 'Standard Monthly Remuneration (Health Insurance)';

1326:
1327: l_jp_element_names_tab(29) := 'E585B1EFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
1328: l_element_names_tab(29) := 'COM_HI_SMR_INFO';
1329: l_element_desc_tab(29) := 'Monthly Remuneration Information of Health Insurance';
1330: l_element_rep_tab(29) := 'Standard Monthly Remuneration (Health Insurance)';
1331:
1332: l_jp_element_names_tab(30) := 'E585B1EFBCBFE99B87E4BF9DEFBCBFE8B387E6A0BCE68385E5A0B1';
1333: l_element_names_tab(30) := 'COM_EI_QUALIFY_INFO';
1334: l_element_desc_tab(30) := 'Qualification Information of Employment Insurance';

Line 1345: l_element_rep_tab(32) := 'Standard Monthly Remuneration (Welfare Pension Insurance)';

1341:
1342: l_jp_element_names_tab(32) := 'E585B1EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
1343: l_element_names_tab(32) := 'COM_WP_SMR_INFO';
1344: l_element_desc_tab(32) := 'Monthly Remuneration Information of Welfare Pension Insurance';
1345: l_element_rep_tab(32) := 'Standard Monthly Remuneration (Welfare Pension Insurance)';
1346:
1347: l_jp_element_names_tab(33) := 'E585B1EFBCBFE7A4BEE4BF9DEFBCBFE8B387E6A0BCE58F96E5BE97E69982EFBCBFE5A0B1E985AC';
1348: l_element_names_tab(33) := 'COM_SI_MR_AT_QUALIFY_INFO';
1349: l_element_desc_tab(33) := 'Monthly Remuneration Information of Social Insurance at Qualified';

Line 1394: l_element_desc_tab(42) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';

1390: l_element_rep_tab(41) := 'Labor Insurance Information';
1391:
1392: l_jp_element_names_tab(42) := 'E69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
1393: l_element_names_tab(42) := 'GEP_MR_PROC';
1394: l_element_desc_tab(42) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';
1395: l_element_rep_tab(42) := 'Monthly Remuneration (Geppen)';
1396:
1397: l_jp_element_names_tab(43) := 'E69C88EFBCBFE7B590E69E9C';
1398: l_element_names_tab(43) := 'GEP_RSLT';

Line 1400: l_element_rep_tab(43) := 'Standard Monthly Remuneration (Geppen)';

1396:
1397: l_jp_element_names_tab(43) := 'E69C88EFBCBFE7B590E69E9C';
1398: l_element_names_tab(43) := 'GEP_RSLT';
1399: l_element_desc_tab(43) := 'Monthly Remuneration etc on Unscheduled Revision';
1400: l_element_rep_tab(43) := 'Standard Monthly Remuneration (Geppen)';
1401:
1402: l_jp_element_names_tab(44) := 'E69C88EFBCBFE7B590E69E9CEFBCBFE59BBAE5AE9AE79A84E8B383E98791';
1403: l_element_names_tab(44) := 'GEP_FIXED_WAGE_RSLT';
1404: l_element_desc_tab(44) := 'Fixed Wage Result on Unscheduled Revision';

Line 1419: l_element_desc_tab(47) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';

1415: l_element_rep_tab(46) := 'Liquidation Amount';
1416:
1417: l_jp_element_names_tab(47) := 'E7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
1418: l_element_names_tab(47) := 'SAN_MR_PROC';
1419: l_element_desc_tab(47) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';
1420: l_element_rep_tab(47) := 'Monthly Remuneration (Santei)';
1421:
1422: l_jp_element_names_tab(48) := 'E7AE97EFBCBFE7B590E69E9CEFBCBF32303033E5B9B433E69C883331E697A5E4BBA5E5898D';
1423: l_element_names_tab(48) := 'SAN_BEFORE_20030331_RSLT';

Line 1425: l_element_rep_tab(48) := 'Standard Monthly Remuneration (Santei)';

1421:
1422: l_jp_element_names_tab(48) := 'E7AE97EFBCBFE7B590E69E9CEFBCBF32303033E5B9B433E69C883331E697A5E4BBA5E5898D';
1423: l_element_names_tab(48) := 'SAN_BEFORE_20030331_RSLT';
1424: l_element_desc_tab(48) := 'Scheduled Revision Result before 31 Mar 2003';
1425: l_element_rep_tab(48) := 'Standard Monthly Remuneration (Santei)';
1426:
1427: l_jp_element_names_tab(49) := 'E7AE97EFBCBFE7B590E69E9CEFBCBFE69C88E5A489E4BA88E5AE9AE69C88';
1428: l_element_names_tab(49) := 'SAN_GEP_MTH_RSLT';
1429: l_element_desc_tab(49) := 'Unscheduled Revision Projected Month Result on Scheduled Revision';

Line 1719: l_element_desc_tab(107) := 'Standard Bonus Amount on Bonus subject to Health Insurance';

1715: l_element_rep_tab(106) := 'Welfare Pension Fund Insurance Premium (Employer)';
1716:
1717: l_jp_element_names_tab(107) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1718: l_element_names_tab(107) := 'BON_HI_STD_BON';
1719: l_element_desc_tab(107) := 'Standard Bonus Amount on Bonus subject to Health Insurance';
1720: l_element_rep_tab(107) := 'Standard Bonus (Health Insurance)';
1721:
1722: l_jp_element_names_tab(108) := 'E7AE97EFBCBFE8AABFE695B4E68385E5A0B1';
1723: l_element_names_tab(108) := 'SAN_ADJ_INFO';

Line 1720: l_element_rep_tab(107) := 'Standard Bonus (Health Insurance)';

1716:
1717: l_jp_element_names_tab(107) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1718: l_element_names_tab(107) := 'BON_HI_STD_BON';
1719: l_element_desc_tab(107) := 'Standard Bonus Amount on Bonus subject to Health Insurance';
1720: l_element_rep_tab(107) := 'Standard Bonus (Health Insurance)';
1721:
1722: l_jp_element_names_tab(108) := 'E7AE97EFBCBFE8AABFE695B4E68385E5A0B1';
1723: l_element_names_tab(108) := 'SAN_ADJ_INFO';
1724: l_element_desc_tab(108) := 'Adjustment Information of Remuneration Amount on Scheduled Revision';

Line 1740: l_element_rep_tab(111) := 'Standard Monthly Remuneration (Santei)';

1736:
1737: l_jp_element_names_tab(111) := 'E7AE97EFBCBFE7B590E69E9C';
1738: l_element_names_tab(111) := 'SAN_RSLT';
1739: l_element_desc_tab(111) := 'Monthly renumeration etc on Scheduled Revision';
1740: l_element_rep_tab(111) := 'Standard Monthly Remuneration (Santei)';
1741:
1742: l_jp_element_names_tab(112) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1743: l_element_names_tab(112) := 'BON_WP_STD_BON';
1744: l_element_desc_tab(112) := 'Standard Bonus Amount on Bonus subject to Welfare Pension Insurance';

Line 1744: l_element_desc_tab(112) := 'Standard Bonus Amount on Bonus subject to Welfare Pension Insurance';

1740: l_element_rep_tab(111) := 'Standard Monthly Remuneration (Santei)';
1741:
1742: l_jp_element_names_tab(112) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1743: l_element_names_tab(112) := 'BON_WP_STD_BON';
1744: l_element_desc_tab(112) := 'Standard Bonus Amount on Bonus subject to Welfare Pension Insurance';
1745: l_element_rep_tab(112) := 'Standard Bonus (Welfare Pension Insurancee)';
1746:
1747: l_jp_element_names_tab(113) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE4BB8BE4BF9DEFBCBFE8A2ABE4BF9DE999BAE88085';
1748: l_element_names_tab(113) := 'BON_CI_PREM_EE';

Line 1745: l_element_rep_tab(112) := 'Standard Bonus (Welfare Pension Insurancee)';

1741:
1742: l_jp_element_names_tab(112) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1743: l_element_names_tab(112) := 'BON_WP_STD_BON';
1744: l_element_desc_tab(112) := 'Standard Bonus Amount on Bonus subject to Welfare Pension Insurance';
1745: l_element_rep_tab(112) := 'Standard Bonus (Welfare Pension Insurancee)';
1746:
1747: l_jp_element_names_tab(113) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE4BB8BE4BF9DEFBCBFE8A2ABE4BF9DE999BAE88085';
1748: l_element_names_tab(113) := 'BON_CI_PREM_EE';
1749: l_element_desc_tab(113) := 'Care Insurance Premium on Bonus (Insured Burden)';

Line 2009: l_element_desc_tab(165) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';

2005: l_element_rep_tab(164) := 'Non Resident Information';
2006:
2007: l_jp_element_names_tab(165) := 'E882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
2008: l_element_names_tab(165) := 'IKU_MR_PROC';
2009: l_element_desc_tab(165) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';
2010: l_element_rep_tab(165) := 'Monthly Remuneration (Ikukai)';
2011:
2012: l_jp_element_names_tab(166) := 'E882B2E694B9EFBCBFE7B590E69E9C';
2013: l_element_names_tab(166) := 'IKU_RSLT';

Line 2015: l_element_rep_tab(166) := 'Standard Monthly Remuneration (Ikukai)';

2011:
2012: l_jp_element_names_tab(166) := 'E882B2E694B9EFBCBFE7B590E69E9C';
2013: l_element_names_tab(166) := 'IKU_RSLT';
2014: l_element_desc_tab(166) := 'Monthly Remuneration etc on Unscheduled Revision after Child-Care Leave';
2015: l_element_rep_tab(166) := 'Standard Monthly Remuneration (Ikukai)';
2016:
2017: l_jp_element_names_tab(167) := 'E882B2E694B9EFBCBFE8AABFE695B4E68385E5A0B1';
2018: l_element_names_tab(167) := 'IKU_ADJ_INFO';
2019: l_element_desc_tab(167) := 'Adjustment Information of Remuneration Amount for Unscheduled Revision after Child-Care Leave';

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 3357: l_global_desc_tab(17) := 'Maximum Standard Bonus Amount (Health Insurance)';

3353: l_global_desc_tab(16) := 'Care Insurance Premium Rate on Salary (Insured)';
3354:
3355: l_jp_global_names_tab(17) := '47EFBCBFE8B39EEFBCBFE581A5E5BAB7E4BF9DE999BAEFBCBFE6A899E6BA96E8B39EE4B88EEFBCBFE4B88AE99990E9A18D';
3356: l_global_names_tab(17) := 'G_BON_HI_STD_BON_MAX';
3357: l_global_desc_tab(17) := 'Maximum Standard Bonus Amount (Health Insurance)';
3358:
3359: l_jp_global_names_tab(18) := '47EFBCBFE8B39EEFBCBFE58E9AE7949FE5B9B4E98791E4BF9DE999BAEFBCBFE6A899E6BA96E8B39EE4B88EEFBCBFE4B88AE99990E9A18D';
3360: l_global_names_tab(18) := 'G_BON_WP_STD_BON_MAX';
3361: l_global_desc_tab(18) := 'Maximum Standard Bonus Amount (Welfare Pension Insurance)';

Line 3361: l_global_desc_tab(18) := 'Maximum Standard Bonus Amount (Welfare Pension Insurance)';

3357: l_global_desc_tab(17) := 'Maximum Standard Bonus Amount (Health Insurance)';
3358:
3359: l_jp_global_names_tab(18) := '47EFBCBFE8B39EEFBCBFE58E9AE7949FE5B9B4E98791E4BF9DE999BAEFBCBFE6A899E6BA96E8B39EE4B88EEFBCBFE4B88AE99990E9A18D';
3360: l_global_names_tab(18) := 'G_BON_WP_STD_BON_MAX';
3361: l_global_desc_tab(18) := 'Maximum Standard Bonus Amount (Welfare Pension Insurance)';
3362:
3363: l_jp_global_names_tab(19) := '47EFBCBFE7B5A6EFBCBFE4BAA4E9809AE6A99FE996A2EFBCBFE99D9EE8AAB2E7A88EE99990E5BAA6E9A18D';
3364: l_global_names_tab(19) := 'G_SAL_CMA_PUBLIC_TRANSPORT_NTXBL_ERN_MAX';
3365: l_global_desc_tab(19) := 'Non Assessable Limited Amount per One Month in case of utilizing Public Transportation';

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 3472: l_formula_desc_tab(1) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';

3468: hr_utility.set_location(l_proc, 10);
3469:
3470: l_jp_formula_names_tab(1) := '46EFBCBFE69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3471: l_formula_names_tab(1) := 'GEP_MR_PROC';
3472: l_formula_desc_tab(1) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';
3473:
3474: l_jp_formula_names_tab(2) := '46EFBCBFE7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3475: l_formula_names_tab(2) := 'SAN_MR_PROC';
3476: l_formula_desc_tab(2) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';

Line 3476: l_formula_desc_tab(2) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';

3472: l_formula_desc_tab(1) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';
3473:
3474: l_jp_formula_names_tab(2) := '46EFBCBFE7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3475: l_formula_names_tab(2) := 'SAN_MR_PROC';
3476: l_formula_desc_tab(2) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';
3477:
3478: l_jp_formula_names_tab(3) := '4653EFBCBFE69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3479: l_formula_names_tab(3) := 'GEP_MR_PROC_SKIP';
3480: l_formula_desc_tab(3) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision';

Line 3480: l_formula_desc_tab(3) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision';

3476: l_formula_desc_tab(2) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';
3477:
3478: l_jp_formula_names_tab(3) := '4653EFBCBFE69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3479: l_formula_names_tab(3) := 'GEP_MR_PROC_SKIP';
3480: l_formula_desc_tab(3) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision';
3481:
3482: l_jp_formula_names_tab(4) := '4656EFBCBFE585B1EFBCBFE4BD8FE6B091E7A88EEFBCBFE68385E5A0B1EFBCBFE5B882E58CBAE794BAE69D91E382B3E383BCE38389';
3483: l_formula_names_tab(4) := 'LTX_MUNICIPAL_CODE_VALIDATION';
3484: l_formula_desc_tab(4) := 'Validation of Local Tax Paying Municipal Code';

Line 3496: l_formula_desc_tab(7) := 'Judgement of Calculation of Standard Monthly Renumeration on Scheduled Revision';

3492: l_formula_desc_tab(6) := 'Validation of Local Tax Withholding Agent Number';
3493:
3494: l_jp_formula_names_tab(7) := '4653EFBCBFE7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3495: l_formula_names_tab(7) := 'SAN_MR_PROC_SKIP';
3496: l_formula_desc_tab(7) := 'Judgement of Calculation of Standard Monthly Renumeration on Scheduled Revision';
3497:
3498: l_jp_formula_names_tab(8) := '46EFBCBFE7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699';
3499: l_formula_names_tab(8) := 'SAL_HI_PREM_PROC';
3500: l_formula_desc_tab(8) := 'Calculation of Health Insurance Premium on Salary Process';

Line 3760: l_formula_desc_tab(73) := 'Validation of Hi Standard Monthly Remuneration';

3756: l_formula_desc_tab(72) := 'Calculation of Welfare Pension Insurance Premium on Bonus Process';
3757:
3758: l_jp_formula_names_tab(73) := '4656EFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
3759: l_formula_names_tab(73) := 'HI_REVISED_SMR_VALIDATION';
3760: l_formula_desc_tab(73) := 'Validation of Hi Standard Monthly Remuneration';
3761:
3762: l_jp_formula_names_tab(74) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
3763: l_formula_names_tab(74) := 'WP_REVISED_SMR_VALIDATION';
3764: l_formula_desc_tab(74) := 'Validation of Wp Standard Monthly Remuneration';

Line 3764: l_formula_desc_tab(74) := 'Validation of Wp Standard Monthly Remuneration';

3760: l_formula_desc_tab(73) := 'Validation of Hi Standard Monthly Remuneration';
3761:
3762: l_jp_formula_names_tab(74) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
3763: l_formula_names_tab(74) := 'WP_REVISED_SMR_VALIDATION';
3764: l_formula_desc_tab(74) := 'Validation of Wp Standard Monthly Remuneration';
3765:
3766: l_jp_formula_names_tab(75) := '4656EFBCBFE8BB8AE4B8A1E68385E5A0B1';
3767: l_formula_names_tab(75) := 'VEHICLE_INFO_VALIDATION';
3768: l_formula_desc_tab(75) := 'Validation of Vehicle Information';

Line 3776: l_formula_desc_tab(77) := 'Validation of Hi Prior Standard Monthly Remuneration';

3772: l_formula_desc_tab(76) := 'Calculation of Commutation Allowance on Salary Process';
3773:
3774: l_jp_formula_names_tab(77) := '4656EFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18DEFBCBFE5BE93E5898D';
3775: l_formula_names_tab(77) := 'HI_PRIOR_SMR_VALIDATION';
3776: l_formula_desc_tab(77) := 'Validation of Hi Prior Standard Monthly Remuneration';
3777:
3778: l_jp_formula_names_tab(78) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18DEFBCBFE5BE93E5898D';
3779: l_formula_names_tab(78) := 'WP_PRIOR_SMR_VALIDATION';
3780: l_formula_desc_tab(78) := 'Validation of Wp Prior Standard Monthly Remuneration';

Line 3780: l_formula_desc_tab(78) := 'Validation of Wp Prior Standard Monthly Remuneration';

3776: l_formula_desc_tab(77) := 'Validation of Hi Prior Standard Monthly Remuneration';
3777:
3778: l_jp_formula_names_tab(78) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18DEFBCBFE5BE93E5898D';
3779: l_formula_names_tab(78) := 'WP_PRIOR_SMR_VALIDATION';
3780: l_formula_desc_tab(78) := 'Validation of Wp Prior Standard Monthly Remuneration';
3781:
3782: l_jp_formula_names_tab(79) := '4642EFBCBFE5B9B4EFBCBFE9818EE4B88DE8B6B3E7A88EE9A18D';
3783: l_formula_names_tab(79) := 'YEA_ITX';
3784: l_formula_desc_tab(79) := 'Calculation of Over and Short Tax Amount on Year End Adjustment';

Line 3788: l_formula_desc_tab(80) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision after Chid-Care Leave';

3784: l_formula_desc_tab(79) := 'Calculation of Over and Short Tax Amount on Year End Adjustment';
3785:
3786: l_jp_formula_names_tab(80) := '4653EFBCBFE882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3787: l_formula_names_tab(80) := 'IKU_MR_PROC_SKIP';
3788: l_formula_desc_tab(80) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision after Chid-Care Leave';
3789:
3790: l_jp_formula_names_tab(81) := '46EFBCBFE882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3791: l_formula_names_tab(81) := 'IKU_MR_PROC';
3792: l_formula_desc_tab(81) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';

Line 3792: l_formula_desc_tab(81) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';

3788: l_formula_desc_tab(80) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision after Chid-Care Leave';
3789:
3790: l_jp_formula_names_tab(81) := '46EFBCBFE882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3791: l_formula_names_tab(81) := 'IKU_MR_PROC';
3792: l_formula_desc_tab(81) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';
3793:
3794: l_jp_formula_names_tab(82) := '4A505F4C495F4749505F5052454D';
3795: l_formula_names_tab(82) := 'LIFE_INS_GIP_PREM_TEMPLATE';
3796: l_formula_desc_tab(82) := 'Calculation Template of Group Life Insurance Premium Total for Insurance Premium and Spouse Special Exemption Declaration';

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: --