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 STANDARD

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

1304:
1305: l_jp_element_names_tab(29) := 'E585B1EFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
1306: l_element_names_tab(29) := 'COM_HI_SMR_INFO';
1307: l_element_desc_tab(29) := 'Monthly Remuneration Information of Health Insurance';
1308: l_element_rep_tab(29) := 'Standard Monthly Remuneration (Health Insurance)';
1309:
1310: l_jp_element_names_tab(30) := 'E585B1EFBCBFE99B87E4BF9DEFBCBFE8B387E6A0BCE68385E5A0B1';
1311: l_element_names_tab(30) := 'COM_EI_QUALIFY_INFO';
1312: l_element_desc_tab(30) := 'Qualification Information of Employment Insurance';

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

1319:
1320: l_jp_element_names_tab(32) := 'E585B1EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
1321: l_element_names_tab(32) := 'COM_WP_SMR_INFO';
1322: l_element_desc_tab(32) := 'Monthly Remuneration Information of Welfare Pension Insurance';
1323: l_element_rep_tab(32) := 'Standard Monthly Remuneration (Welfare Pension Insurance)';
1324:
1325: l_jp_element_names_tab(33) := 'E585B1EFBCBFE7A4BEE4BF9DEFBCBFE8B387E6A0BCE58F96E5BE97E69982EFBCBFE5A0B1E985AC';
1326: l_element_names_tab(33) := 'COM_SI_MR_AT_QUALIFY_INFO';
1327: l_element_desc_tab(33) := 'Monthly Remuneration Information of Social Insurance at Qualified';

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

1368: l_element_rep_tab(41) := 'Labor Insurance Information';
1369:
1370: l_jp_element_names_tab(42) := 'E69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
1371: l_element_names_tab(42) := 'GEP_MR_PROC';
1372: l_element_desc_tab(42) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';
1373: l_element_rep_tab(42) := 'Monthly Remuneration (Geppen)';
1374:
1375: l_jp_element_names_tab(43) := 'E69C88EFBCBFE7B590E69E9C';
1376: l_element_names_tab(43) := 'GEP_RSLT';

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

1374:
1375: l_jp_element_names_tab(43) := 'E69C88EFBCBFE7B590E69E9C';
1376: l_element_names_tab(43) := 'GEP_RSLT';
1377: l_element_desc_tab(43) := 'Monthly Remuneration etc on Unscheduled Revision';
1378: l_element_rep_tab(43) := 'Standard Monthly Remuneration (Geppen)';
1379:
1380: l_jp_element_names_tab(44) := 'E69C88EFBCBFE7B590E69E9CEFBCBFE59BBAE5AE9AE79A84E8B383E98791';
1381: l_element_names_tab(44) := 'GEP_FIXED_WAGE_RSLT';
1382: l_element_desc_tab(44) := 'Fixed Wage Result on Unscheduled Revision';

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

1393: l_element_rep_tab(46) := 'Liquidation Amount';
1394:
1395: l_jp_element_names_tab(47) := 'E7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
1396: l_element_names_tab(47) := 'SAN_MR_PROC';
1397: l_element_desc_tab(47) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';
1398: l_element_rep_tab(47) := 'Monthly Remuneration (Santei)';
1399:
1400: l_jp_element_names_tab(48) := 'E7AE97EFBCBFE7B590E69E9CEFBCBF32303033E5B9B433E69C883331E697A5E4BBA5E5898D';
1401: l_element_names_tab(48) := 'SAN_BEFORE_20030331_RSLT';

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

1399:
1400: l_jp_element_names_tab(48) := 'E7AE97EFBCBFE7B590E69E9CEFBCBF32303033E5B9B433E69C883331E697A5E4BBA5E5898D';
1401: l_element_names_tab(48) := 'SAN_BEFORE_20030331_RSLT';
1402: l_element_desc_tab(48) := 'Scheduled Revision Result before 31 Mar 2003';
1403: l_element_rep_tab(48) := 'Standard Monthly Remuneration (Santei)';
1404:
1405: l_jp_element_names_tab(49) := 'E7AE97EFBCBFE7B590E69E9CEFBCBFE69C88E5A489E4BA88E5AE9AE69C88';
1406: l_element_names_tab(49) := 'SAN_GEP_MTH_RSLT';
1407: l_element_desc_tab(49) := 'Unscheduled Revision Projected Month Result on Scheduled Revision';

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

1693: l_element_rep_tab(106) := 'Welfare Pension Fund Insurance Premium (Employer)';
1694:
1695: l_jp_element_names_tab(107) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1696: l_element_names_tab(107) := 'BON_HI_STD_BON';
1697: l_element_desc_tab(107) := 'Standard Bonus Amount on Bonus subject to Health Insurance';
1698: l_element_rep_tab(107) := 'Standard Bonus (Health Insurance)';
1699:
1700: l_jp_element_names_tab(108) := 'E7AE97EFBCBFE8AABFE695B4E68385E5A0B1';
1701: l_element_names_tab(108) := 'SAN_ADJ_INFO';

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

1694:
1695: l_jp_element_names_tab(107) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1696: l_element_names_tab(107) := 'BON_HI_STD_BON';
1697: l_element_desc_tab(107) := 'Standard Bonus Amount on Bonus subject to Health Insurance';
1698: l_element_rep_tab(107) := 'Standard Bonus (Health Insurance)';
1699:
1700: l_jp_element_names_tab(108) := 'E7AE97EFBCBFE8AABFE695B4E68385E5A0B1';
1701: l_element_names_tab(108) := 'SAN_ADJ_INFO';
1702: l_element_desc_tab(108) := 'Adjustment Information of Remuneration Amount on Scheduled Revision';

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

1714:
1715: l_jp_element_names_tab(111) := 'E7AE97EFBCBFE7B590E69E9C';
1716: l_element_names_tab(111) := 'SAN_RSLT';
1717: l_element_desc_tab(111) := 'Monthly renumeration etc on Scheduled Revision';
1718: l_element_rep_tab(111) := 'Standard Monthly Remuneration (Santei)';
1719:
1720: l_jp_element_names_tab(112) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1721: l_element_names_tab(112) := 'BON_WP_STD_BON';
1722: l_element_desc_tab(112) := 'Standard Bonus Amount on Bonus subject to Welfare Pension Insurance';

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

1718: l_element_rep_tab(111) := 'Standard Monthly Remuneration (Santei)';
1719:
1720: l_jp_element_names_tab(112) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1721: l_element_names_tab(112) := 'BON_WP_STD_BON';
1722: l_element_desc_tab(112) := 'Standard Bonus Amount on Bonus subject to Welfare Pension Insurance';
1723: l_element_rep_tab(112) := 'Standard Bonus (Welfare Pension Insurancee)';
1724:
1725: l_jp_element_names_tab(113) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE4BB8BE4BF9DEFBCBFE8A2ABE4BF9DE999BAE88085';
1726: l_element_names_tab(113) := 'BON_CI_PREM_EE';

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

1719:
1720: l_jp_element_names_tab(112) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E8B39EE4B88EE9A18D';
1721: l_element_names_tab(112) := 'BON_WP_STD_BON';
1722: l_element_desc_tab(112) := 'Standard Bonus Amount on Bonus subject to Welfare Pension Insurance';
1723: l_element_rep_tab(112) := 'Standard Bonus (Welfare Pension Insurancee)';
1724:
1725: l_jp_element_names_tab(113) := 'E8B39EEFBCBFE7B590E69E9CEFBCBFE4BB8BE4BF9DEFBCBFE8A2ABE4BF9DE999BAE88085';
1726: l_element_names_tab(113) := 'BON_CI_PREM_EE';
1727: l_element_desc_tab(113) := 'Care Insurance Premium on Bonus (Insured Burden)';

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

1983: l_element_rep_tab(164) := 'Non Resident Information';
1984:
1985: l_jp_element_names_tab(165) := 'E882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
1986: l_element_names_tab(165) := 'IKU_MR_PROC';
1987: l_element_desc_tab(165) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';
1988: l_element_rep_tab(165) := 'Monthly Remuneration (Ikukai)';
1989:
1990: l_jp_element_names_tab(166) := 'E882B2E694B9EFBCBFE7B590E69E9C';
1991: l_element_names_tab(166) := 'IKU_RSLT';

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

1989:
1990: l_jp_element_names_tab(166) := 'E882B2E694B9EFBCBFE7B590E69E9C';
1991: l_element_names_tab(166) := 'IKU_RSLT';
1992: l_element_desc_tab(166) := 'Monthly Remuneration etc on Unscheduled Revision after Child-Care Leave';
1993: l_element_rep_tab(166) := 'Standard Monthly Remuneration (Ikukai)';
1994:
1995: l_jp_element_names_tab(167) := 'E882B2E694B9EFBCBFE8AABFE695B4E68385E5A0B1';
1996: l_element_names_tab(167) := 'IKU_ADJ_INFO';
1997: l_element_desc_tab(167) := 'Adjustment Information of Remuneration Amount for Unscheduled Revision after Child-Care Leave';

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

3329: l_global_desc_tab(16) := 'Care Insurance Premium Rate on Salary (Insured)';
3330:
3331: l_jp_global_names_tab(17) := '47EFBCBFE8B39EEFBCBFE581A5E5BAB7E4BF9DE999BAEFBCBFE6A899E6BA96E8B39EE4B88EEFBCBFE4B88AE99990E9A18D';
3332: l_global_names_tab(17) := 'G_BON_HI_STD_BON_MAX';
3333: l_global_desc_tab(17) := 'Maximum Standard Bonus Amount (Health Insurance)';
3334:
3335: l_jp_global_names_tab(18) := '47EFBCBFE8B39EEFBCBFE58E9AE7949FE5B9B4E98791E4BF9DE999BAEFBCBFE6A899E6BA96E8B39EE4B88EEFBCBFE4B88AE99990E9A18D';
3336: l_global_names_tab(18) := 'G_BON_WP_STD_BON_MAX';
3337: l_global_desc_tab(18) := 'Maximum Standard Bonus Amount (Welfare Pension Insurance)';

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

3333: l_global_desc_tab(17) := 'Maximum Standard Bonus Amount (Health Insurance)';
3334:
3335: l_jp_global_names_tab(18) := '47EFBCBFE8B39EEFBCBFE58E9AE7949FE5B9B4E98791E4BF9DE999BAEFBCBFE6A899E6BA96E8B39EE4B88EEFBCBFE4B88AE99990E9A18D';
3336: l_global_names_tab(18) := 'G_BON_WP_STD_BON_MAX';
3337: l_global_desc_tab(18) := 'Maximum Standard Bonus Amount (Welfare Pension Insurance)';
3338:
3339: l_jp_global_names_tab(19) := '47EFBCBFE7B5A6EFBCBFE4BAA4E9809AE6A99FE996A2EFBCBFE99D9EE8AAB2E7A88EE99990E5BAA6E9A18D';
3340: l_global_names_tab(19) := 'G_SAL_CMA_PUBLIC_TRANSPORT_NTXBL_ERN_MAX';
3341: l_global_desc_tab(19) := 'Non Assessable Limited Amount per One Month in case of utilizing Public Transportation';

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

3430: hr_utility.set_location(l_proc, 10);
3431:
3432: l_jp_formula_names_tab(1) := '46EFBCBFE69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3433: l_formula_names_tab(1) := 'GEP_MR_PROC';
3434: l_formula_desc_tab(1) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';
3435:
3436: l_jp_formula_names_tab(2) := '46EFBCBFE7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3437: l_formula_names_tab(2) := 'SAN_MR_PROC';
3438: l_formula_desc_tab(2) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';

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

3434: l_formula_desc_tab(1) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision';
3435:
3436: l_jp_formula_names_tab(2) := '46EFBCBFE7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3437: l_formula_names_tab(2) := 'SAN_MR_PROC';
3438: l_formula_desc_tab(2) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';
3439:
3440: l_jp_formula_names_tab(3) := '4653EFBCBFE69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3441: l_formula_names_tab(3) := 'GEP_MR_PROC_SKIP';
3442: l_formula_desc_tab(3) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision';

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

3438: l_formula_desc_tab(2) := 'Calculation of Standard Monthly Remuneration on Scheduled Revision';
3439:
3440: l_jp_formula_names_tab(3) := '4653EFBCBFE69C88EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3441: l_formula_names_tab(3) := 'GEP_MR_PROC_SKIP';
3442: l_formula_desc_tab(3) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision';
3443:
3444: l_jp_formula_names_tab(4) := '4656EFBCBFE585B1EFBCBFE4BD8FE6B091E7A88EEFBCBFE68385E5A0B1EFBCBFE5B882E58CBAE794BAE69D91E382B3E383BCE38389';
3445: l_formula_names_tab(4) := 'LTX_MUNICIPAL_CODE_VALIDATION';
3446: l_formula_desc_tab(4) := 'Validation of Local Tax Paying Municipal Code';

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

3454: l_formula_desc_tab(6) := 'Validation of Local Tax Withholding Agent Number';
3455:
3456: l_jp_formula_names_tab(7) := '4653EFBCBFE7AE97EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3457: l_formula_names_tab(7) := 'SAN_MR_PROC_SKIP';
3458: l_formula_desc_tab(7) := 'Judgement of Calculation of Standard Monthly Renumeration on Scheduled Revision';
3459:
3460: l_jp_formula_names_tab(8) := '46EFBCBFE7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699';
3461: l_formula_names_tab(8) := 'SAL_HI_PREM_PROC';
3462: l_formula_desc_tab(8) := 'Calculation of Health Insurance Premium on Salary Process';

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

3718: l_formula_desc_tab(72) := 'Calculation of Welfare Pension Insurance Premium on Bonus Process';
3719:
3720: l_jp_formula_names_tab(73) := '4656EFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
3721: l_formula_names_tab(73) := 'HI_REVISED_SMR_VALIDATION';
3722: l_formula_desc_tab(73) := 'Validation of Hi Standard Monthly Remuneration';
3723:
3724: l_jp_formula_names_tab(74) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
3725: l_formula_names_tab(74) := 'WP_REVISED_SMR_VALIDATION';
3726: l_formula_desc_tab(74) := 'Validation of Wp Standard Monthly Remuneration';

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

3722: l_formula_desc_tab(73) := 'Validation of Hi Standard Monthly Remuneration';
3723:
3724: l_jp_formula_names_tab(74) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18D';
3725: l_formula_names_tab(74) := 'WP_REVISED_SMR_VALIDATION';
3726: l_formula_desc_tab(74) := 'Validation of Wp Standard Monthly Remuneration';
3727:
3728: l_jp_formula_names_tab(75) := '4656EFBCBFE8BB8AE4B8A1E68385E5A0B1';
3729: l_formula_names_tab(75) := 'VEHICLE_INFO_VALIDATION';
3730: l_formula_desc_tab(75) := 'Validation of Vehicle Information';

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

3734: l_formula_desc_tab(76) := 'Calculation of Commutation Allowance on Salary Process';
3735:
3736: l_jp_formula_names_tab(77) := '4656EFBCBFE581A5E4BF9DEFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18DEFBCBFE5BE93E5898D';
3737: l_formula_names_tab(77) := 'HI_PRIOR_SMR_VALIDATION';
3738: l_formula_desc_tab(77) := 'Validation of Hi Prior Standard Monthly Remuneration';
3739:
3740: l_jp_formula_names_tab(78) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18DEFBCBFE5BE93E5898D';
3741: l_formula_names_tab(78) := 'WP_PRIOR_SMR_VALIDATION';
3742: l_formula_desc_tab(78) := 'Validation of Wp Prior Standard Monthly Remuneration';

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

3738: l_formula_desc_tab(77) := 'Validation of Hi Prior Standard Monthly Remuneration';
3739:
3740: l_jp_formula_names_tab(78) := '4656EFBCBFE58E9AE5B9B4EFBCBFE6A899E6BA96E5A0B1E985ACE69C88E9A18DEFBCBFE5BE93E5898D';
3741: l_formula_names_tab(78) := 'WP_PRIOR_SMR_VALIDATION';
3742: l_formula_desc_tab(78) := 'Validation of Wp Prior Standard Monthly Remuneration';
3743:
3744: l_jp_formula_names_tab(79) := '4642EFBCBFE5B9B4EFBCBFE9818EE4B88DE8B6B3E7A88EE9A18D';
3745: l_formula_names_tab(79) := 'YEA_ITX';
3746: l_formula_desc_tab(79) := 'Calculation of Over and Short Tax Amount on Year End Adjustment';

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

3746: l_formula_desc_tab(79) := 'Calculation of Over and Short Tax Amount on Year End Adjustment';
3747:
3748: l_jp_formula_names_tab(80) := '4653EFBCBFE882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3749: l_formula_names_tab(80) := 'IKU_MR_PROC_SKIP';
3750: l_formula_desc_tab(80) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision after Chid-Care Leave';
3751:
3752: l_jp_formula_names_tab(81) := '46EFBCBFE882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3753: l_formula_names_tab(81) := 'IKU_MR_PROC';
3754: l_formula_desc_tab(81) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';

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

3750: l_formula_desc_tab(80) := 'Judgement of Calculation of Standard Monthly Renumeration on Unscheduled Revision after Chid-Care Leave';
3751:
3752: l_jp_formula_names_tab(81) := '46EFBCBFE882B2E694B9EFBCBFE59FBAE69CACEFBCBFE5A0B1E985ACE69C88E9A18D';
3753: l_formula_names_tab(81) := 'IKU_MR_PROC';
3754: l_formula_desc_tab(81) := 'Calculation of Standard Monthly Remuneration on Unscheduled Revision after Child-Care Leave';
3755:
3756: l_jp_formula_names_tab(82) := '4A505F4C495F4749505F5052454D';
3757: l_formula_names_tab(82) := 'LIFE_INS_GIP_PREM_TEMPLATE';
3758: l_formula_desc_tab(82) := 'Calculation Template of Group Life Insurance Premium Total for Insurance Premium and Spouse Special Exemption Declaration';

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: