eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on HR_UTILITY

Line 6: g_traces BOOLEAN := hr_utility.debug_enabled; --See if hr_utility.traces should be output

2: /* $Header: pyjpdatamig.pkb 120.17 2012/01/19 10:08:36 rpahune ship $ */
3: --
4: -- Global Utils
5: g_pkg VARCHAR2(30) := 'pay_jp_data_migration_pkg';
6: g_traces BOOLEAN := hr_utility.debug_enabled; --See if hr_utility.traces should be output
7: g_dbg BOOLEAN := FALSE; --Used for diagnosing issues by dev, more outputs
8: --
9: -- |-------------------------------------------------------------------|
10: -- |---------------------< migrate_input_values >----------------------|

Line 29: hr_utility.set_location(l_proc, 10);

25:
26: l_jp_input_names_tab.DELETE;
27: l_input_names_tab.DELETE;
28:
29: hr_utility.set_location(l_proc, 10);
30:
31: l_jp_input_names_tab(1) := '32E59B9EE79BAEE4BBA5E9998DE381AEE7A88EE9A18D';
32: l_input_names_tab(1) := 'SUBSEQUENT_TAX';
33:

Line 1083: hr_utility.set_location(l_proc, 20);

1079:
1080: l_jp_input_names_tab(350) := 'E7B5A6E4B88EE68EA7E999A4E5808BE4BABAE5B9B4E98791EFBCBF32303132E5B9B4E4BBA5E9998D';
1081: l_input_names_tab(350) := 'SAL_DCT_IND_PENSION_PREM_PREM_2012';
1082:
1083: hr_utility.set_location(l_proc, 20);
1084:
1085: if (g_dbg) then
1086: hr_utility.trace('| Input Value Count = ' || l_jp_input_names_tab.COUNT);
1087: hr_utility.trace('+--------------------------------------------+ ');

Line 1086: hr_utility.trace('| Input Value Count = ' || l_jp_input_names_tab.COUNT);

1082:
1083: hr_utility.set_location(l_proc, 20);
1084:
1085: if (g_dbg) then
1086: hr_utility.trace('| Input Value Count = ' || l_jp_input_names_tab.COUNT);
1087: hr_utility.trace('+--------------------------------------------+ ');
1088: end if;
1089: --
1090: -- update COM_LTX_LUMP_SUM_WITHHOLD_PROC elm from ITX to LTX for l_jp_input_names_tab(263) update

Line 1087: hr_utility.trace('+--------------------------------------------+ ');

1083: hr_utility.set_location(l_proc, 20);
1084:
1085: if (g_dbg) then
1086: hr_utility.trace('| Input Value Count = ' || l_jp_input_names_tab.COUNT);
1087: hr_utility.trace('+--------------------------------------------+ ');
1088: end if;
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

Line 1140: hr_utility.set_location(l_proc, 30);

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);
1141:
1142: if (g_dbg) then
1143: hr_utility.trace('| Total Input Values Updated = ' || SQL%ROWCOUNT);
1144: hr_utility.trace('+-------------------------------+ ');

Line 1143: hr_utility.trace('| Total Input Values Updated = ' || SQL%ROWCOUNT);

1139:
1140: hr_utility.set_location(l_proc, 30);
1141:
1142: if (g_dbg) then
1143: hr_utility.trace('| Total Input Values Updated = ' || SQL%ROWCOUNT);
1144: hr_utility.trace('+-------------------------------+ ');
1145: end if;
1146: --
1147: EXCEPTION

Line 1144: hr_utility.trace('+-------------------------------+ ');

1140: hr_utility.set_location(l_proc, 30);
1141:
1142: if (g_dbg) then
1143: hr_utility.trace('| Total Input Values Updated = ' || SQL%ROWCOUNT);
1144: hr_utility.trace('+-------------------------------+ ');
1145: end if;
1146: --
1147: EXCEPTION
1148:

Line 1151: hr_utility.set_location(l_proc, 40);

1147: EXCEPTION
1148:
1149: WHEN OTHERS THEN
1150:
1151: hr_utility.set_location(l_proc, 40);
1152:
1153: raise;
1154:
1155: END migrate_input_values;

Line 1185: hr_utility.set_location(l_proc, 10);

1181: l_element_names_tab.DELETE;
1182: l_element_desc_tab.DELETE;
1183: l_element_rep_tab.DELETE;
1184:
1185: hr_utility.set_location(l_proc, 10);
1186:
1187: l_jp_element_names_tab(1) := 'E7B5A6EFBCBFE59FBAE69CACEFBCBFE581A5E4BF9DEFBCBFE4BF9DE999BAE69699';
1188: l_element_names_tab(1) := 'SAL_HI_PREM_PROC';
1189: l_element_desc_tab(1) := 'Calculation of Health Insurance Premium on Salary';

Line 2034: hr_utility.set_location(l_proc, 20);

2030: l_element_names_tab(169) := 'YEA_INS_PREM_EXM_DECLARE_INFO';
2031: l_element_desc_tab(169) := 'Declaration Finalized Content Information of Insurance Premium Exemtion Declaration and Spouse Special Exemption Declaration';
2032: l_element_rep_tab(169) := 'Insurance Premium and Spouse Special Exemption';
2033:
2034: hr_utility.set_location(l_proc, 20);
2035:
2036: if (g_dbg) then
2037: hr_utility.trace('| Element Type Count = ' || l_jp_element_names_tab.COUNT);
2038: hr_utility.trace('+-------------------------------+ ');

Line 2037: hr_utility.trace('| Element Type Count = ' || l_jp_element_names_tab.COUNT);

2033:
2034: hr_utility.set_location(l_proc, 20);
2035:
2036: if (g_dbg) then
2037: hr_utility.trace('| Element Type Count = ' || l_jp_element_names_tab.COUNT);
2038: hr_utility.trace('+-------------------------------+ ');
2039: end if;
2040: --
2041:

Line 2038: hr_utility.trace('+-------------------------------+ ');

2034: hr_utility.set_location(l_proc, 20);
2035:
2036: if (g_dbg) then
2037: hr_utility.trace('| Element Type Count = ' || l_jp_element_names_tab.COUNT);
2038: hr_utility.trace('+-------------------------------+ ');
2039: end if;
2040: --
2041:
2042: FORALL l_tab_cnt IN 1..l_jp_element_names_tab.COUNT

Line 2056: hr_utility.set_location(l_proc, 30);

2052: SET description = description || 'Obsoleted'
2053: WHERE ASCII(description) > 127
2054: AND legislation_code = 'JP';
2055:
2056: hr_utility.set_location(l_proc, 30);
2057:
2058: if (g_dbg) then
2059: hr_utility.trace('| Total Elements Updated = ' || SQL%ROWCOUNT);
2060: hr_utility.trace('+-------------------------------+ ');

Line 2059: hr_utility.trace('| Total Elements Updated = ' || SQL%ROWCOUNT);

2055:
2056: hr_utility.set_location(l_proc, 30);
2057:
2058: if (g_dbg) then
2059: hr_utility.trace('| Total Elements Updated = ' || SQL%ROWCOUNT);
2060: hr_utility.trace('+-------------------------------+ ');
2061: end if;
2062: --
2063: EXCEPTION

Line 2060: hr_utility.trace('+-------------------------------+ ');

2056: hr_utility.set_location(l_proc, 30);
2057:
2058: if (g_dbg) then
2059: hr_utility.trace('| Total Elements Updated = ' || SQL%ROWCOUNT);
2060: hr_utility.trace('+-------------------------------+ ');
2061: end if;
2062: --
2063: EXCEPTION
2064:

Line 2067: hr_utility.set_location(l_proc, 40);

2063: EXCEPTION
2064:
2065: WHEN OTHERS THEN
2066:
2067: hr_utility.set_location(l_proc, 40);
2068:
2069: raise;
2070:
2071: END migrate_element_types;

Line 2097: hr_utility.set_location(l_proc, 10);

2093: l_jp_class_name.DELETE;
2094: l_class_names_tab.DELETE;
2095: l_class_desc_tab.DELETE;
2096:
2097: hr_utility.set_location(l_proc, 10);
2098:
2099: l_jp_class_name(1) := 'C%2401%';
2100: l_class_names_tab(1) := 'TRM_ERN_KIND_TXBL';
2101: l_class_desc_tab(1) := 'Taxable Earning in Kind for Termination Payment (Resident)';

Line 2466: hr_utility.set_location(l_proc, 20);

2462: l_jp_class_name(92) := 'C%0100%';
2463: l_class_names_tab(92) := 'BASIC_INFO';
2464: l_class_desc_tab(92) := 'Basic Information';
2465:
2466: hr_utility.set_location(l_proc, 20);
2467:
2468: if (g_dbg) then
2469: hr_utility.trace('| Element Classification Count = ' || l_jp_class_name.COUNT);
2470: hr_utility.trace('+--------------------------------------------+ ');

Line 2469: hr_utility.trace('| Element Classification Count = ' || l_jp_class_name.COUNT);

2465:
2466: hr_utility.set_location(l_proc, 20);
2467:
2468: if (g_dbg) then
2469: hr_utility.trace('| Element Classification Count = ' || l_jp_class_name.COUNT);
2470: hr_utility.trace('+--------------------------------------------+ ');
2471: end if;
2472: --
2473:

Line 2470: hr_utility.trace('+--------------------------------------------+ ');

2466: hr_utility.set_location(l_proc, 20);
2467:
2468: if (g_dbg) then
2469: hr_utility.trace('| Element Classification Count = ' || l_jp_class_name.COUNT);
2470: hr_utility.trace('+--------------------------------------------+ ');
2471: end if;
2472: --
2473:
2474: FORALL l_tab_cnt IN 1..l_jp_class_name.COUNT

Line 2482: hr_utility.set_location(l_proc, 30);

2478: description = l_class_desc_tab(l_tab_cnt)
2479: WHERE classification_name LIKE l_jp_class_name(l_tab_cnt)
2480: AND legislation_code = 'JP';
2481:
2482: hr_utility.set_location(l_proc, 30);
2483:
2484: if (g_dbg) then
2485: hr_utility.trace('| Total Classifications Updated = ' || SQL%ROWCOUNT);
2486: hr_utility.trace('+-------------------------------+ ');

Line 2485: hr_utility.trace('| Total Classifications Updated = ' || SQL%ROWCOUNT);

2481:
2482: hr_utility.set_location(l_proc, 30);
2483:
2484: if (g_dbg) then
2485: hr_utility.trace('| Total Classifications Updated = ' || SQL%ROWCOUNT);
2486: hr_utility.trace('+-------------------------------+ ');
2487: end if;
2488: --
2489: EXCEPTION

Line 2486: hr_utility.trace('+-------------------------------+ ');

2482: hr_utility.set_location(l_proc, 30);
2483:
2484: if (g_dbg) then
2485: hr_utility.trace('| Total Classifications Updated = ' || SQL%ROWCOUNT);
2486: hr_utility.trace('+-------------------------------+ ');
2487: end if;
2488: --
2489: EXCEPTION
2490:

Line 2493: hr_utility.set_location(l_proc, 40);

2489: EXCEPTION
2490:
2491: WHEN OTHERS THEN
2492:
2493: hr_utility.set_location(l_proc, 40);
2494:
2495: raise;
2496:
2497: END migrate_element_class;

Line 2523: hr_utility.set_location(l_proc, 10);

2519: l_jp_bal_names_tab.DELETE;
2520: l_bal_names_tab.DELETE;
2521: l_bal_rep_tab.DELETE;
2522:
2523: hr_utility.set_location(l_proc, 10);
2524:
2525: l_jp_bal_names_tab(1) := '42EFBCBFE585B1EFBCBFE58E9AE7949FE5B9B4E98791E4BF9DE999BAE69699E59088E8A888';
2526: l_bal_names_tab(1) := 'B_COM_WP_PREM';
2527: l_bal_rep_tab(1) := 'Welfare Pension Insurance Premium';

Line 3032: hr_utility.set_location(l_proc, 20);

3028: l_jp_bal_names_tab(126) := '42EFBCBFE5B9B4EFBCBFE7B5A6E4B88EE68EA7E999A4E58886E59CB0E99C87E4BF9DE999BAE69699';
3029: l_bal_names_tab(126) := 'B_YEA_SAL_DCT_EARTHQUAKE_INS_PREM';
3030: l_bal_rep_tab(126) := 'Earthquake Insurance Premium (Salary Deduction)';
3031:
3032: hr_utility.set_location(l_proc, 20);
3033:
3034: if (g_dbg) then
3035: hr_utility.trace('| Balance Type Count = ' || l_jp_bal_names_tab.COUNT);
3036: hr_utility.trace('+--------------------------------------------+ ');

Line 3035: hr_utility.trace('| Balance Type Count = ' || l_jp_bal_names_tab.COUNT);

3031:
3032: hr_utility.set_location(l_proc, 20);
3033:
3034: if (g_dbg) then
3035: hr_utility.trace('| Balance Type Count = ' || l_jp_bal_names_tab.COUNT);
3036: hr_utility.trace('+--------------------------------------------+ ');
3037: end if;
3038: --
3039:

Line 3036: hr_utility.trace('+--------------------------------------------+ ');

3032: hr_utility.set_location(l_proc, 20);
3033:
3034: if (g_dbg) then
3035: hr_utility.trace('| Balance Type Count = ' || l_jp_bal_names_tab.COUNT);
3036: hr_utility.trace('+--------------------------------------------+ ');
3037: end if;
3038: --
3039:
3040: FORALL l_tab_cnt IN 1..l_jp_bal_names_tab.COUNT

Line 3053: hr_utility.set_location(l_proc, 30);

3049: SET reporting_name = reporting_name || 'Obsoleted'
3050: WHERE ASCII(reporting_name) > 127
3051: AND legislation_code = 'JP';
3052:
3053: hr_utility.set_location(l_proc, 30);
3054:
3055: if (g_dbg) then
3056: hr_utility.trace('| Total Balance Types Updated = ' || SQL%ROWCOUNT);
3057: hr_utility.trace('+-------------------------------+ ');

Line 3056: hr_utility.trace('| Total Balance Types Updated = ' || SQL%ROWCOUNT);

3052:
3053: hr_utility.set_location(l_proc, 30);
3054:
3055: if (g_dbg) then
3056: hr_utility.trace('| Total Balance Types Updated = ' || SQL%ROWCOUNT);
3057: hr_utility.trace('+-------------------------------+ ');
3058: end if;
3059: --
3060: EXCEPTION

Line 3057: hr_utility.trace('+-------------------------------+ ');

3053: hr_utility.set_location(l_proc, 30);
3054:
3055: if (g_dbg) then
3056: hr_utility.trace('| Total Balance Types Updated = ' || SQL%ROWCOUNT);
3057: hr_utility.trace('+-------------------------------+ ');
3058: end if;
3059: --
3060: EXCEPTION
3061:

Line 3064: hr_utility.set_location(l_proc, 40);

3060: EXCEPTION
3061:
3062: WHEN OTHERS THEN
3063:
3064: hr_utility.set_location(l_proc, 40);
3065:
3066: raise;
3067:
3068: END migrate_balance_types;

Line 3098: hr_utility.set_location(l_proc, 10);

3094: l_dim_names_tab.DELETE;
3095: l_dim_desc_tab.DELETE;
3096: l_dim_suffix_tab.DELETE;
3097:
3098: hr_utility.set_location(l_proc, 10);
3099:
3100: l_jp_dim_names_tab(1) := '5F41EFBCBFE5BD93E7B5A6E4B88EE587A6E79086';
3101: l_dim_names_tab(1) := '_ASG_RUN';
3102: l_dim_desc_tab(1) := 'Grand Total within Current Payroll Process (Assignment)';

Line 3165: hr_utility.set_location(l_proc, 20);

3161: l_dim_names_tab(13) := '_ASG_BYTD';
3162: l_dim_desc_tab(13) := 'Grand Total until Processing Date within the Business Year Period (Assignment)';
3163: l_dim_suffix_tab(13) := '_ASG_BYTD';
3164:
3165: hr_utility.set_location(l_proc, 20);
3166:
3167: if (g_dbg) then
3168: hr_utility.trace('| Balance Dimension Count = ' || l_jp_dim_names_tab.COUNT);
3169: hr_utility.trace('+--------------------------------------------+ ');

Line 3168: hr_utility.trace('| Balance Dimension Count = ' || l_jp_dim_names_tab.COUNT);

3164:
3165: hr_utility.set_location(l_proc, 20);
3166:
3167: if (g_dbg) then
3168: hr_utility.trace('| Balance Dimension Count = ' || l_jp_dim_names_tab.COUNT);
3169: hr_utility.trace('+--------------------------------------------+ ');
3170: end if;
3171: --
3172:

Line 3169: hr_utility.trace('+--------------------------------------------+ ');

3165: hr_utility.set_location(l_proc, 20);
3166:
3167: if (g_dbg) then
3168: hr_utility.trace('| Balance Dimension Count = ' || l_jp_dim_names_tab.COUNT);
3169: hr_utility.trace('+--------------------------------------------+ ');
3170: end if;
3171: --
3172:
3173: FORALL l_tab_cnt IN 1..l_jp_dim_names_tab.COUNT

Line 3182: hr_utility.set_location(l_proc, 30);

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:
3184: if (g_dbg) then
3185: hr_utility.trace('| Total Balance Dimensions Updated = ' || SQL%ROWCOUNT);
3186: hr_utility.trace('+-----------------------------------------+ ');

Line 3185: hr_utility.trace('| Total Balance Dimensions Updated = ' || SQL%ROWCOUNT);

3181:
3182: hr_utility.set_location(l_proc, 30);
3183:
3184: if (g_dbg) then
3185: hr_utility.trace('| Total Balance Dimensions Updated = ' || SQL%ROWCOUNT);
3186: hr_utility.trace('+-----------------------------------------+ ');
3187: end if;
3188: --
3189: EXCEPTION

Line 3186: hr_utility.trace('+-----------------------------------------+ ');

3182: hr_utility.set_location(l_proc, 30);
3183:
3184: if (g_dbg) then
3185: hr_utility.trace('| Total Balance Dimensions Updated = ' || SQL%ROWCOUNT);
3186: hr_utility.trace('+-----------------------------------------+ ');
3187: end if;
3188: --
3189: EXCEPTION
3190:

Line 3193: hr_utility.set_location(l_proc, 40);

3189: EXCEPTION
3190:
3191: WHEN OTHERS THEN
3192:
3193: hr_utility.set_location(l_proc, 40);
3194:
3195: raise;
3196:
3197: END migrate_bal_dimensions;

Line 3219: hr_utility.set_location(l_proc, 10);

3215:
3216: l_jp_ele_set_names_tab.DELETE;
3217: l_ele_set_names_tab.DELETE;
3218:
3219: hr_utility.set_location(l_proc, 10);
3220:
3221: l_jp_ele_set_names_tab(1) := 'E8B39EE4B88E'; l_ele_set_names_tab(1) := 'BON';
3222: l_jp_ele_set_names_tab(2) := 'E7AE97E5AE9A'; l_ele_set_names_tab(2) := 'SAN';
3223: l_jp_ele_set_names_tab(3) := 'E7B5A6E4B88E'; l_ele_set_names_tab(3) := 'SAL';

Line 3231: hr_utility.set_location(l_proc, 20);

3227: l_jp_ele_set_names_tab(7) := 'E789B9E588A5E8B39EE4B88E'; l_ele_set_names_tab(7) := 'SPB';
3228: l_jp_ele_set_names_tab(8) := 'E5868DE5B9B4E69CABE8AABFE695B4'; l_ele_set_names_tab(8) := 'REY';
3229: l_jp_ele_set_names_tab(9) := 'E882B2E694B9'; l_ele_set_names_tab(9) := 'IKU';
3230:
3231: hr_utility.set_location(l_proc, 20);
3232:
3233: if (g_dbg) then
3234: hr_utility.trace('| Element Sets Count = ' || l_jp_ele_set_names_tab.COUNT);
3235: hr_utility.trace('+--------------------------------------------+ ');

Line 3234: hr_utility.trace('| Element Sets Count = ' || l_jp_ele_set_names_tab.COUNT);

3230:
3231: hr_utility.set_location(l_proc, 20);
3232:
3233: if (g_dbg) then
3234: hr_utility.trace('| Element Sets Count = ' || l_jp_ele_set_names_tab.COUNT);
3235: hr_utility.trace('+--------------------------------------------+ ');
3236: end if;
3237: --
3238:

Line 3235: hr_utility.trace('+--------------------------------------------+ ');

3231: hr_utility.set_location(l_proc, 20);
3232:
3233: if (g_dbg) then
3234: hr_utility.trace('| Element Sets Count = ' || l_jp_ele_set_names_tab.COUNT);
3235: hr_utility.trace('+--------------------------------------------+ ');
3236: end if;
3237: --
3238:
3239: FORALL l_tab_cnt IN 1..l_jp_ele_set_names_tab.COUNT

Line 3246: hr_utility.set_location(l_proc, 30);

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:
3248: if (g_dbg) then
3249: hr_utility.trace('| Total Element Sets Updated = ' || SQL%ROWCOUNT);
3250: hr_utility.trace('+-----------------------------------------+ ');

Line 3249: hr_utility.trace('| Total Element Sets Updated = ' || SQL%ROWCOUNT);

3245:
3246: hr_utility.set_location(l_proc, 30);
3247:
3248: if (g_dbg) then
3249: hr_utility.trace('| Total Element Sets Updated = ' || SQL%ROWCOUNT);
3250: hr_utility.trace('+-----------------------------------------+ ');
3251: end if;
3252: --
3253: EXCEPTION

Line 3250: hr_utility.trace('+-----------------------------------------+ ');

3246: hr_utility.set_location(l_proc, 30);
3247:
3248: if (g_dbg) then
3249: hr_utility.trace('| Total Element Sets Updated = ' || SQL%ROWCOUNT);
3250: hr_utility.trace('+-----------------------------------------+ ');
3251: end if;
3252: --
3253: EXCEPTION
3254:

Line 3257: hr_utility.set_location(l_proc, 40);

3253: EXCEPTION
3254:
3255: WHEN OTHERS THEN
3256:
3257: hr_utility.set_location(l_proc, 40);
3258:
3259: raise;
3260:
3261: END migrate_element_sets;

Line 3289: hr_utility.set_location(l_proc, 10);

3285: l_jp_global_names_tab.DELETE;
3286: l_global_names_tab.DELETE;
3287: l_global_desc_tab.DELETE;
3288:
3289: hr_utility.set_location(l_proc, 10);
3290:
3291: l_jp_global_names_tab(1) := '47EFBCBFE585B1EFBCBFE6BA90E6B389E5BEB4E58F8EE7A88EE9A18DE8A1A8E69C80E5A4A7E689B6E9A48AE88085E695B0';
3292: l_global_names_tab(1) := 'G_COM_ITX_TBL_NUM_OF_DEP_MAX';
3293: l_global_desc_tab(1) := 'Maximum Number of Dependent People of Withholding Tax Amount Table';

Line 3390: hr_utility.set_location(l_proc, 20);

3386: l_jp_global_names_tab(24) := '47EFBCBFE98080EFBCBFE4BD8FE6B091E7A88EEFBCBFE789B9E588A5E5BEB4E58F8EEFBCBFE68EA7E999A4E78E87';
3387: l_global_names_tab(24) := 'G_TRM_LTX_SP_WITHHOLD_DCTBL_RATE';
3388: l_global_desc_tab(24) := 'Deduction Rate of Special Collecting Local Tax on Termination Payment';
3389:
3390: hr_utility.set_location(l_proc, 20);
3391:
3392: if (g_dbg) then
3393: hr_utility.trace('| Global Names Count = ' || l_jp_global_names_tab.COUNT);
3394: hr_utility.trace('+----------------------------------+ ');

Line 3393: hr_utility.trace('| Global Names Count = ' || l_jp_global_names_tab.COUNT);

3389:
3390: hr_utility.set_location(l_proc, 20);
3391:
3392: if (g_dbg) then
3393: hr_utility.trace('| Global Names Count = ' || l_jp_global_names_tab.COUNT);
3394: hr_utility.trace('+----------------------------------+ ');
3395: end if;
3396: --
3397: l_status_mode := hr_general.g_data_migrator_mode;

Line 3394: hr_utility.trace('+----------------------------------+ ');

3390: hr_utility.set_location(l_proc, 20);
3391:
3392: if (g_dbg) then
3393: hr_utility.trace('| Global Names Count = ' || l_jp_global_names_tab.COUNT);
3394: hr_utility.trace('+----------------------------------+ ');
3395: end if;
3396: --
3397: l_status_mode := hr_general.g_data_migrator_mode;
3398: --

Line 3399: hr_utility.trace('hr_general.g_data_migrator_mode : '||l_status_mode);

3395: end if;
3396: --
3397: l_status_mode := hr_general.g_data_migrator_mode;
3398: --
3399: hr_utility.trace('hr_general.g_data_migrator_mode : '||l_status_mode);
3400: --
3401: if nvl(l_status_mode,'N') <> 'Y' then
3402: --
3403: -- this is required to set for FF_GLOBALS_F_BRU trigger

Line 3427: hr_utility.set_location(l_proc, 30);

3423: SET global_description = global_description || 'Obsoleted'
3424: WHERE ASCII(global_description) > 127
3425: AND legislation_code = 'JP';
3426:
3427: hr_utility.set_location(l_proc, 30);
3428:
3429: if (g_dbg) then
3430: hr_utility.trace('| Total Global Names Updated = ' || SQL%ROWCOUNT);
3431: hr_utility.trace('+-----------------------------------------+ ');

Line 3430: hr_utility.trace('| Total Global Names Updated = ' || SQL%ROWCOUNT);

3426:
3427: hr_utility.set_location(l_proc, 30);
3428:
3429: if (g_dbg) then
3430: hr_utility.trace('| Total Global Names Updated = ' || SQL%ROWCOUNT);
3431: hr_utility.trace('+-----------------------------------------+ ');
3432: end if;
3433: --
3434: EXCEPTION

Line 3431: hr_utility.trace('+-----------------------------------------+ ');

3427: hr_utility.set_location(l_proc, 30);
3428:
3429: if (g_dbg) then
3430: hr_utility.trace('| Total Global Names Updated = ' || SQL%ROWCOUNT);
3431: hr_utility.trace('+-----------------------------------------+ ');
3432: end if;
3433: --
3434: EXCEPTION
3435:

Line 3438: hr_utility.set_location(l_proc, 40);

3434: EXCEPTION
3435:
3436: WHEN OTHERS THEN
3437:
3438: hr_utility.set_location(l_proc, 40);
3439:
3440: raise;
3441:
3442: END migrate_globals;

Line 3468: hr_utility.set_location(l_proc, 10);

3464: l_jp_formula_names_tab.DELETE;
3465: l_formula_names_tab.DELETE;
3466: l_formula_desc_tab.DELETE;
3467:
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';

Line 3808: hr_utility.set_location(l_proc, 20);

3804: l_jp_formula_names_tab(84) := '4A505F41495F5052454D5F43414C43';
3805: l_formula_names_tab(84) := 'ACCIDENT_INS_PREM_TEMPLATE';
3806: l_formula_desc_tab(84) := 'Calculation Template of Accident Insurance Premium Total for Insurance Premium and Spouse Special Exemption Declaration';
3807:
3808: hr_utility.set_location(l_proc, 20);
3809:
3810: if (g_dbg) then
3811: hr_utility.trace('| Fast Formulas Count = ' || l_jp_formula_names_tab.COUNT);
3812: hr_utility.trace('+----------------------------------+ ');

Line 3811: hr_utility.trace('| Fast Formulas Count = ' || l_jp_formula_names_tab.COUNT);

3807:
3808: hr_utility.set_location(l_proc, 20);
3809:
3810: if (g_dbg) then
3811: hr_utility.trace('| Fast Formulas Count = ' || l_jp_formula_names_tab.COUNT);
3812: hr_utility.trace('+----------------------------------+ ');
3813: end if;
3814: --
3815:

Line 3812: hr_utility.trace('+----------------------------------+ ');

3808: hr_utility.set_location(l_proc, 20);
3809:
3810: if (g_dbg) then
3811: hr_utility.trace('| Fast Formulas Count = ' || l_jp_formula_names_tab.COUNT);
3812: hr_utility.trace('+----------------------------------+ ');
3813: end if;
3814: --
3815:
3816: FORALL l_tab_cnt IN 1..l_jp_formula_names_tab.COUNT

Line 3829: hr_utility.set_location(l_proc, 30);

3825: SET description = description || 'Obsoleted'
3826: WHERE ASCII(description) > 127
3827: AND legislation_code = 'JP';
3828:
3829: hr_utility.set_location(l_proc, 30);
3830:
3831: if (g_dbg) then
3832: hr_utility.trace('| Total Formulas Updated = ' || SQL%ROWCOUNT);
3833: hr_utility.trace('+-----------------------------------+ ');

Line 3832: hr_utility.trace('| Total Formulas Updated = ' || SQL%ROWCOUNT);

3828:
3829: hr_utility.set_location(l_proc, 30);
3830:
3831: if (g_dbg) then
3832: hr_utility.trace('| Total Formulas Updated = ' || SQL%ROWCOUNT);
3833: hr_utility.trace('+-----------------------------------+ ');
3834: end if;
3835: --
3836: EXCEPTION

Line 3833: hr_utility.trace('+-----------------------------------+ ');

3829: hr_utility.set_location(l_proc, 30);
3830:
3831: if (g_dbg) then
3832: hr_utility.trace('| Total Formulas Updated = ' || SQL%ROWCOUNT);
3833: hr_utility.trace('+-----------------------------------+ ');
3834: end if;
3835: --
3836: EXCEPTION
3837:

Line 3840: hr_utility.set_location(l_proc, 40);

3836: EXCEPTION
3837:
3838: WHEN OTHERS THEN
3839:
3840: hr_utility.set_location(l_proc, 40);
3841:
3842: raise;
3843:
3844: END migrate_formulas;

Line 3866: hr_utility.set_location(l_proc, 10);

3862:
3863: l_jp_monetary_name_tab.DELETE;
3864: l_monetary_name_tab.DELETE;
3865:
3866: hr_utility.set_location(l_proc, 10);
3867:
3868: l_jp_monetary_name_tab(1) := '3130303030E58686'; l_monetary_name_tab(1) := 'TEN_THOUSAND_YEN';
3869: l_jp_monetary_name_tab(2) := '31303030E58686'; l_monetary_name_tab(2) := 'ONE_THOUSAND_YEN';
3870: l_jp_monetary_name_tab(3) := '313030E58686'; l_monetary_name_tab(3) := 'ONE_HUNDRED_YEN';

Line 3879: hr_utility.set_location(l_proc, 20);

3875: l_jp_monetary_name_tab(8) := '353030E58686'; l_monetary_name_tab(8) := 'FIVE_HUNDRED_YEN';
3876: l_jp_monetary_name_tab(9) := '3530E58686'; l_monetary_name_tab(9) := 'FIFTY_YEN';
3877: l_jp_monetary_name_tab(10) := '35E58686'; l_monetary_name_tab(10) := 'FIVE_YEN';
3878:
3879: hr_utility.set_location(l_proc, 20);
3880:
3881: if (g_dbg) then
3882: hr_utility.trace('| Monetary Units Count = ' || l_jp_monetary_name_tab.COUNT);
3883: hr_utility.trace('+----------------------------------+ ');

Line 3882: hr_utility.trace('| Monetary Units Count = ' || l_jp_monetary_name_tab.COUNT);

3878:
3879: hr_utility.set_location(l_proc, 20);
3880:
3881: if (g_dbg) then
3882: hr_utility.trace('| Monetary Units Count = ' || l_jp_monetary_name_tab.COUNT);
3883: hr_utility.trace('+----------------------------------+ ');
3884: end if;
3885: --
3886:

Line 3883: hr_utility.trace('+----------------------------------+ ');

3879: hr_utility.set_location(l_proc, 20);
3880:
3881: if (g_dbg) then
3882: hr_utility.trace('| Monetary Units Count = ' || l_jp_monetary_name_tab.COUNT);
3883: hr_utility.trace('+----------------------------------+ ');
3884: end if;
3885: --
3886:
3887: FORALL l_tab_cnt IN 1..l_jp_monetary_name_tab.COUNT

Line 3894: hr_utility.set_location(l_proc, 30);

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:
3896: if (g_dbg) then
3897: hr_utility.trace('| Total Monetary Units Updated = ' || SQL%ROWCOUNT);
3898: hr_utility.trace('+-----------------------------------------+ ');

Line 3897: hr_utility.trace('| Total Monetary Units Updated = ' || SQL%ROWCOUNT);

3893:
3894: hr_utility.set_location(l_proc, 30);
3895:
3896: if (g_dbg) then
3897: hr_utility.trace('| Total Monetary Units Updated = ' || SQL%ROWCOUNT);
3898: hr_utility.trace('+-----------------------------------------+ ');
3899: end if;
3900: --
3901: EXCEPTION

Line 3898: hr_utility.trace('+-----------------------------------------+ ');

3894: hr_utility.set_location(l_proc, 30);
3895:
3896: if (g_dbg) then
3897: hr_utility.trace('| Total Monetary Units Updated = ' || SQL%ROWCOUNT);
3898: hr_utility.trace('+-----------------------------------------+ ');
3899: end if;
3900: --
3901: EXCEPTION
3902:

Line 3905: hr_utility.set_location(l_proc, 40);

3901: EXCEPTION
3902:
3903: WHEN OTHERS THEN
3904:
3905: hr_utility.set_location(l_proc, 40);
3906:
3907: raise;
3908:
3909: END migrate_monetary_units;

Line 3931: hr_utility.set_location(l_proc, 10);

3927:
3928: l_jp_column_names_tab.DELETE;
3929: l_column_names_tab.DELETE;
3930:
3931: hr_utility.set_location(l_proc, 10);
3932:
3933: l_jp_column_names_tab(1) := 'E4B880E888ACE98080E881B7';
3934: l_column_names_tab(1) := 'GEN_TRM';
3935:

Line 4189: hr_utility.set_location(l_proc, 20);

4185: l_jp_column_names_tab(85) := 'E78E87';
4186: l_column_names_tab(85) := 'DCTBL_RATE';
4187:
4188:
4189: hr_utility.set_location(l_proc, 20);
4190:
4191: if (g_dbg) then
4192: hr_utility.trace('| User Columns Count = ' || l_jp_column_names_tab.COUNT);
4193: hr_utility.trace('+----------------------------------+ ');

Line 4192: hr_utility.trace('| User Columns Count = ' || l_jp_column_names_tab.COUNT);

4188:
4189: hr_utility.set_location(l_proc, 20);
4190:
4191: if (g_dbg) then
4192: hr_utility.trace('| User Columns Count = ' || l_jp_column_names_tab.COUNT);
4193: hr_utility.trace('+----------------------------------+ ');
4194: end if;
4195: --
4196:

Line 4193: hr_utility.trace('+----------------------------------+ ');

4189: hr_utility.set_location(l_proc, 20);
4190:
4191: if (g_dbg) then
4192: hr_utility.trace('| User Columns Count = ' || l_jp_column_names_tab.COUNT);
4193: hr_utility.trace('+----------------------------------+ ');
4194: end if;
4195: --
4196:
4197: UPDATE pay_user_columns

Line 4211: hr_utility.set_location(l_proc, 30);

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:
4213: UPDATE pay_user_columns
4214: SET user_column_name = 'EXM'
4215: WHERE user_column_name LIKE hr_jp_standard_pkg.hextochar('E68EA7E999A4E9A18D','AL32UTF8')

Line 4225: hr_utility.set_location(l_proc, 40);

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

Line 4237: hr_utility.set_location(l_proc, 50);

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:
4239: FORALL l_tab_cnt IN 1..l_jp_column_names_tab.COUNT
4240:
4241: UPDATE pay_user_columns

Line 4246: hr_utility.set_location(l_proc, 60);

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:
4248: if (g_dbg) then
4249: hr_utility.trace('| Total User Columns Updated = ' || SQL%ROWCOUNT);
4250: hr_utility.trace('+-----------------------------------------+ ');

Line 4249: hr_utility.trace('| Total User Columns Updated = ' || SQL%ROWCOUNT);

4245:
4246: hr_utility.set_location(l_proc, 60);
4247:
4248: if (g_dbg) then
4249: hr_utility.trace('| Total User Columns Updated = ' || SQL%ROWCOUNT);
4250: hr_utility.trace('+-----------------------------------------+ ');
4251: end if;
4252:
4253: --

Line 4250: hr_utility.trace('+-----------------------------------------+ ');

4246: hr_utility.set_location(l_proc, 60);
4247:
4248: if (g_dbg) then
4249: hr_utility.trace('| Total User Columns Updated = ' || SQL%ROWCOUNT);
4250: hr_utility.trace('+-----------------------------------------+ ');
4251: end if;
4252:
4253: --
4254: EXCEPTION

Line 4258: hr_utility.set_location(l_proc, 70);

4254: EXCEPTION
4255:
4256: WHEN OTHERS THEN
4257:
4258: hr_utility.set_location(l_proc, 70);
4259:
4260: raise;
4261:
4262: END migrate_user_columns;

Line 4284: hr_utility.set_location(l_proc, 10);

4280:
4281: l_jp_row_names_tab.DELETE;
4282: l_row_names_tab.DELETE;
4283:
4284: hr_utility.set_location(l_proc, 10);
4285:
4286: l_jp_row_names_tab(1) := 'E9A790E8BB8AE5A0B4E4BBA3E7AD89';
4287: l_row_names_tab(1) := 'PARKING_FEE';
4288:

Line 4404: hr_utility.set_location(l_proc, 20);

4400:
4401: l_jp_row_names_tab(39) := 'E7949FE591BDE4BF9DE999BAE69699E68EA7E999A4EFBCBF32303132E5B9B4E4BBA5E9998D';
4402: l_row_names_tab(39) := 'LIFE_INS_EXM_2012';
4403:
4404: hr_utility.set_location(l_proc, 20);
4405:
4406: if (g_dbg) then
4407: hr_utility.trace('| User Rows Count = ' || l_jp_row_names_tab.COUNT);
4408: hr_utility.trace('+----------------------------------+ ');

Line 4407: hr_utility.trace('| User Rows Count = ' || l_jp_row_names_tab.COUNT);

4403:
4404: hr_utility.set_location(l_proc, 20);
4405:
4406: if (g_dbg) then
4407: hr_utility.trace('| User Rows Count = ' || l_jp_row_names_tab.COUNT);
4408: hr_utility.trace('+----------------------------------+ ');
4409: end if;
4410: --
4411:

Line 4408: hr_utility.trace('+----------------------------------+ ');

4404: hr_utility.set_location(l_proc, 20);
4405:
4406: if (g_dbg) then
4407: hr_utility.trace('| User Rows Count = ' || l_jp_row_names_tab.COUNT);
4408: hr_utility.trace('+----------------------------------+ ');
4409: end if;
4410: --
4411:
4412: FORALL l_tab_cnt IN 1..l_jp_row_names_tab.COUNT

Line 4419: hr_utility.set_location(l_proc, 30);

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:
4421: if (g_dbg) then
4422: hr_utility.trace('| Total User Rows Updated = ' || SQL%ROWCOUNT);
4423: hr_utility.trace('+-----------------------------------------+ ');

Line 4422: hr_utility.trace('| Total User Rows Updated = ' || SQL%ROWCOUNT);

4418:
4419: hr_utility.set_location(l_proc, 30);
4420:
4421: if (g_dbg) then
4422: hr_utility.trace('| Total User Rows Updated = ' || SQL%ROWCOUNT);
4423: hr_utility.trace('+-----------------------------------------+ ');
4424: end if;
4425: --
4426: EXCEPTION

Line 4423: hr_utility.trace('+-----------------------------------------+ ');

4419: hr_utility.set_location(l_proc, 30);
4420:
4421: if (g_dbg) then
4422: hr_utility.trace('| Total User Rows Updated = ' || SQL%ROWCOUNT);
4423: hr_utility.trace('+-----------------------------------------+ ');
4424: end if;
4425: --
4426: EXCEPTION
4427:

Line 4430: hr_utility.set_location(l_proc, 40);

4426: EXCEPTION
4427:
4428: WHEN OTHERS THEN
4429:
4430: hr_utility.set_location(l_proc, 40);
4431:
4432: raise;
4433:
4434: END migrate_user_rows;

Line 4460: hr_utility.set_location(l_proc, 10);

4456: l_jp_table_names_tab.DELETE;
4457: l_table_names_tab.DELETE;
4458: l_row_titles_tab.DELETE;
4459:
4460: hr_utility.set_location(l_proc, 10);
4461:
4462: l_jp_table_names_tab(1) := '54EFBCBFE5B9B4EFBCBFE5808BE4BABAE5B9B4E98791E4BF9DE999BAE69699E68EA7E999A4E9A18DE8A1A8';
4463: l_table_names_tab(1) := 'T_YEA_INDIVIDUAL_PENSION_INS_EXM';
4464: l_row_titles_tab(1) := 'ANNUAL_INS_PREM';

Line 4602: hr_utility.set_location(l_proc, 20);

4598: l_jp_table_names_tab(35) := '54EFBCBFE7B5A6EFBCBFE9809AE58BA4E6898BE6AEB5EFBCBFE68385E5A0B1';
4599: l_table_names_tab(35) := 'T_SAL_CMA_METHOD_INFO';
4600: l_row_titles_tab(35) := 'CMA_METHOD';
4601:
4602: hr_utility.set_location(l_proc, 20);
4603:
4604: if (g_dbg) then
4605: hr_utility.trace('| User Tables Count = ' || l_jp_table_names_tab.COUNT);
4606: hr_utility.trace('+----------------------------------+ ');

Line 4605: hr_utility.trace('| User Tables Count = ' || l_jp_table_names_tab.COUNT);

4601:
4602: hr_utility.set_location(l_proc, 20);
4603:
4604: if (g_dbg) then
4605: hr_utility.trace('| User Tables Count = ' || l_jp_table_names_tab.COUNT);
4606: hr_utility.trace('+----------------------------------+ ');
4607: end if;
4608: --
4609:

Line 4606: hr_utility.trace('+----------------------------------+ ');

4602: hr_utility.set_location(l_proc, 20);
4603:
4604: if (g_dbg) then
4605: hr_utility.trace('| User Tables Count = ' || l_jp_table_names_tab.COUNT);
4606: hr_utility.trace('+----------------------------------+ ');
4607: end if;
4608: --
4609:
4610: FORALL l_tab_cnt IN 1..l_jp_table_names_tab.COUNT

Line 4618: hr_utility.set_location(l_proc, 30);

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:
4620: if (g_dbg) then
4621: hr_utility.trace('| Total User Tables Updated = ' || SQL%ROWCOUNT);
4622: hr_utility.trace('+-----------------------------------------+ ');

Line 4621: hr_utility.trace('| Total User Tables Updated = ' || SQL%ROWCOUNT);

4617:
4618: hr_utility.set_location(l_proc, 30);
4619:
4620: if (g_dbg) then
4621: hr_utility.trace('| Total User Tables Updated = ' || SQL%ROWCOUNT);
4622: hr_utility.trace('+-----------------------------------------+ ');
4623: end if;
4624: --
4625: EXCEPTION

Line 4622: hr_utility.trace('+-----------------------------------------+ ');

4618: hr_utility.set_location(l_proc, 30);
4619:
4620: if (g_dbg) then
4621: hr_utility.trace('| Total User Tables Updated = ' || SQL%ROWCOUNT);
4622: hr_utility.trace('+-----------------------------------------+ ');
4623: end if;
4624: --
4625: EXCEPTION
4626:

Line 4629: hr_utility.set_location(l_proc, 40);

4625: EXCEPTION
4626:
4627: WHEN OTHERS THEN
4628:
4629: hr_utility.set_location(l_proc, 40);
4630:
4631: raise;
4632:
4633: END migrate_user_tables;

Line 4771: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_COMPILED_INFO_F');

4767: or (fue.creator_type = 'B'))
4768: )
4769: and bg2.business_group_id(+) = fue.business_group_id
4770: and nvl(fue.legislation_code, bg2.legislation_code) = 'JP');
4771: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_COMPILED_INFO_F');
4772: --
4773: DELETE ff_fdi_usages_f
4774: WHERE formula_id in (
4775: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */

Line 4799: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_FDI_USAGES_F');

4795: or (fue.creator_type = 'B'))
4796: )
4797: and bg2.business_group_id(+) = fue.business_group_id
4798: and nvl(fue.legislation_code, bg2.legislation_code) = 'JP');
4799: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_FDI_USAGES_F');
4800: --
4801: -- bug.5758299
4802: DELETE ff_user_entities
4803: WHERE ( legislation_code = 'JP'

Line 4810: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_USER_ENTITIES');

4806: SELECT business_group_id
4807: FROM per_business_groups_perf
4808: WHERE legislation_code = 'JP')
4809: and creator_type in ('B', 'RB'));
4810: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_USER_ENTITIES');
4811: --
4812: -- bug.6040440
4813: -- Rebuild Global Values DBIs.
4814: --

Line 4823: -- hr_utility.trace('Global Value DBI: ' || l_global_rec.global_name || ' created.');

4819: l_global_rec.business_group_id,
4820: l_global_rec.legislation_code,
4821: l_global_rec.created_by,
4822: l_global_rec.creation_date);
4823: -- hr_utility.trace('Global Value DBI: ' || l_global_rec.global_name || ' created.');
4824: end loop;
4825: --
4826: INSERT INTO pay_patch_status
4827: (id

Line 4890: hr_utility.trace('l_dbi_tl_cnt : '||to_char(l_dbi_tl_cnt));

4886: where id = rec_del_dtls.id;
4887: --
4888: if (g_dbg) then
4889: --
4890: hr_utility.trace('l_dbi_tl_cnt : '||to_char(l_dbi_tl_cnt));
4891: hr_utility.trace('l_dbi_cnt : '||to_char(l_dbi_cnt));
4892: --
4893: end if;
4894: --

Line 4891: hr_utility.trace('l_dbi_cnt : '||to_char(l_dbi_cnt));

4887: --
4888: if (g_dbg) then
4889: --
4890: hr_utility.trace('l_dbi_tl_cnt : '||to_char(l_dbi_tl_cnt));
4891: hr_utility.trace('l_dbi_cnt : '||to_char(l_dbi_cnt));
4892: --
4893: end if;
4894: --
4895: end if;

Line 4902: hr_utility.set_location( 'Error in deleting',99 );

4898: Exception
4899: --
4900: When Others Then
4901: --
4902: hr_utility.set_location( 'Error in deleting',99 );
4903: raise;
4904: --
4905: END delete_dbi;
4906: --

Line 4935: hr_utility.set_location(l_proc, 0);

4931: --
4932: begin
4933: --
4934: if (g_dbg) then
4935: hr_utility.set_location(l_proc, 0);
4936: end if;
4937: --
4938: open csr_org_df;
4939: loop

Line 4960: hr_utility.set_location(l_proc, 10);

4956: end loop;
4957: close csr_org_df;
4958: --
4959: if (g_dbg) then
4960: hr_utility.set_location(l_proc, 10);
4961: hr_utility.trace('update cnt : '||to_char(l_cnt));
4962: hr_utility.trace('p_org_information_context : '||p_org_information_context);
4963: hr_utility.trace('p_org_information3_o : '||p_org_information3_o);
4964: hr_utility.trace('p_org_information3_n : '||p_org_information3_n);

Line 4961: hr_utility.trace('update cnt : '||to_char(l_cnt));

4957: close csr_org_df;
4958: --
4959: if (g_dbg) then
4960: hr_utility.set_location(l_proc, 10);
4961: hr_utility.trace('update cnt : '||to_char(l_cnt));
4962: hr_utility.trace('p_org_information_context : '||p_org_information_context);
4963: hr_utility.trace('p_org_information3_o : '||p_org_information3_o);
4964: hr_utility.trace('p_org_information3_n : '||p_org_information3_n);
4965: end if;

Line 4962: hr_utility.trace('p_org_information_context : '||p_org_information_context);

4958: --
4959: if (g_dbg) then
4960: hr_utility.set_location(l_proc, 10);
4961: hr_utility.trace('update cnt : '||to_char(l_cnt));
4962: hr_utility.trace('p_org_information_context : '||p_org_information_context);
4963: hr_utility.trace('p_org_information3_o : '||p_org_information3_o);
4964: hr_utility.trace('p_org_information3_n : '||p_org_information3_n);
4965: end if;
4966: --

Line 4963: hr_utility.trace('p_org_information3_o : '||p_org_information3_o);

4959: if (g_dbg) then
4960: hr_utility.set_location(l_proc, 10);
4961: hr_utility.trace('update cnt : '||to_char(l_cnt));
4962: hr_utility.trace('p_org_information_context : '||p_org_information_context);
4963: hr_utility.trace('p_org_information3_o : '||p_org_information3_o);
4964: hr_utility.trace('p_org_information3_n : '||p_org_information3_n);
4965: end if;
4966: --
4967: if l_cnt > 0 then

Line 4964: hr_utility.trace('p_org_information3_n : '||p_org_information3_n);

4960: hr_utility.set_location(l_proc, 10);
4961: hr_utility.trace('update cnt : '||to_char(l_cnt));
4962: hr_utility.trace('p_org_information_context : '||p_org_information_context);
4963: hr_utility.trace('p_org_information3_o : '||p_org_information3_o);
4964: hr_utility.trace('p_org_information3_n : '||p_org_information3_n);
4965: end if;
4966: --
4967: if l_cnt > 0 then
4968: --

Line 4974: hr_utility.set_location(l_proc, 1000);

4970: --
4971: end if;
4972: --
4973: if (g_dbg) then
4974: hr_utility.set_location(l_proc, 1000);
4975: end if;
4976: --
4977: end migrate_org_df;
4978: --

Line 5008: hr_utility.set_location(l_proc, 0);

5004: --
5005: begin
5006: --
5007: if (g_dbg) then
5008: hr_utility.set_location(l_proc, 0);
5009: end if;
5010: --
5011: open csr_li_ff;
5012: fetch csr_li_ff into l_li_ff_cnt;

Line 5016: hr_utility.set_location(l_proc, 10);

5012: fetch csr_li_ff into l_li_ff_cnt;
5013: close csr_li_ff;
5014: --
5015: if (g_dbg) then
5016: hr_utility.set_location(l_proc, 10);
5017: hr_utility.trace('migrate li ff cnt : '||to_char(l_li_ff_cnt));
5018: end if;
5019: --
5020: if (l_li_ff_cnt > 0) then

Line 5017: hr_utility.trace('migrate li ff cnt : '||to_char(l_li_ff_cnt));

5013: close csr_li_ff;
5014: --
5015: if (g_dbg) then
5016: hr_utility.set_location(l_proc, 10);
5017: hr_utility.trace('migrate li ff cnt : '||to_char(l_li_ff_cnt));
5018: end if;
5019: --
5020: if (l_li_ff_cnt > 0) then
5021: --

Line 5029: hr_utility.set_location(l_proc, 1000);

5025: --
5026: end if;
5027: --
5028: if (g_dbg) then
5029: hr_utility.set_location(l_proc, 1000);
5030: end if;
5031: --
5032: end migrate_li_ff;
5033: --

Line 5074: hr_utility.set_location(l_proc,0);

5070: --
5071: begin
5072: --
5073: if (g_dbg) then
5074: hr_utility.set_location(l_proc,0);
5075: end if;
5076: --
5077: open csr_hr_only;
5078: fetch csr_hr_only into l_hr_only;

Line 5082: hr_utility.trace('chk_hr_corrupt l_hr_only : '||l_hr_only);

5078: fetch csr_hr_only into l_hr_only;
5079: close csr_hr_only;
5080: --
5081: if (g_dbg) then
5082: hr_utility.trace('chk_hr_corrupt l_hr_only : '||l_hr_only);
5083: end if;
5084: --
5085: if l_hr_only is not null
5086: and l_hr_only = 'Y' then

Line 5093: hr_utility.trace('chk_hr_corrupt l_run_script : '||l_run_script);

5089: fetch csr_run_script into l_run_script;
5090: close csr_run_script;
5091: --
5092: if (g_dbg) then
5093: hr_utility.trace('chk_hr_corrupt l_run_script : '||l_run_script);
5094: end if;
5095: --
5096: if l_run_script is null then
5097: --

Line 5105: hr_utility.trace('chk_hr_corrupt o_hr_corrupt : '||o_hr_corrupt);

5101: --
5102: end if;
5103: --
5104: if (g_dbg) then
5105: hr_utility.trace('chk_hr_corrupt o_hr_corrupt : '||o_hr_corrupt);
5106: hr_utility.set_location(l_proc,1000);
5107: end if;
5108: --
5109: return o_hr_corrupt;

Line 5106: hr_utility.set_location(l_proc,1000);

5102: end if;
5103: --
5104: if (g_dbg) then
5105: hr_utility.trace('chk_hr_corrupt o_hr_corrupt : '||o_hr_corrupt);
5106: hr_utility.set_location(l_proc,1000);
5107: end if;
5108: --
5109: return o_hr_corrupt;
5110: end chk_hr_corrupt;

Line 5312: hr_utility.set_location(l_proc,0);

5308: --
5309: begin
5310: --
5311: if (g_dbg) then
5312: hr_utility.set_location(l_proc,0);
5313: end if;
5314: --
5315: -- fix only objects which might cause conflict
5316: --

Line 5326: hr_utility.trace('fix_hr_corrupt l_elm_cnt : '||to_char(l_elm_cnt));

5322: fetch csr_elm_cnt into l_elm_cnt;
5323: close csr_elm_cnt;
5324: --
5325: if (g_dbg) then
5326: hr_utility.trace('fix_hr_corrupt l_elm_cnt : '||to_char(l_elm_cnt));
5327: end if;
5328: --
5329: if l_elm_cnt > 0 then
5330: --

Line 5524: -- hr_utility.trace('fix_hr_corrupt, update elm : '||l_dummy);

5520: -- from pay_element_types_f pet2
5521: -- where pet2.element_type_id = pet.element_type_id);
5522: -- --
5523: -- if (g_dbg) then
5524: -- hr_utility.trace('fix_hr_corrupt, update elm : '||l_dummy);
5525: -- end if;
5526: -- --
5527: -- if l_dummy is null then
5528: -- --

Line 5530: -- hr_utility.trace('fix_hr_corrupt, no update elm : '||l_elm_tbl(l_elm_ind));

5526: -- --
5527: -- if l_dummy is null then
5528: -- --
5529: -- if (g_dbg) then
5530: -- hr_utility.trace('fix_hr_corrupt, no update elm : '||l_elm_tbl(l_elm_ind));
5531: -- end if;
5532: -- --
5533: -- else
5534: -- --

Line 5543: -- hr_utility.trace('fix_hr_corrupt, no update elm err : '||l_elm_tbl(l_elm_ind));

5539: -- exception
5540: -- when others then
5541: -- --
5542: -- if (g_dbg) then
5543: -- hr_utility.trace('fix_hr_corrupt, no update elm err : '||l_elm_tbl(l_elm_ind));
5544: -- end if;
5545: -- --
5546: -- end;
5547: -- --

Line 5551: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

5547: -- --
5548: -- end loop;
5549: ----
5550: -- if (g_dbg) then
5551: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
5552: -- end if;
5553: --
5554: -- use bulk collect
5555: forall l_elm_ind in 1..l_elm_tbl.count

Line 5565: hr_utility.set_location(l_proc,10);

5561: --
5562: end if;
5563: --
5564: if (g_dbg) then
5565: hr_utility.set_location(l_proc,10);
5566: end if;
5567: --
5568: -- ---------------------------------------------
5569: -- element classification

Line 5577: hr_utility.trace('fix_hr_corrupt l_class_cnt : '||to_char(l_class_cnt));

5573: fetch csr_class_cnt into l_class_cnt;
5574: close csr_class_cnt;
5575: --
5576: if (g_dbg) then
5577: hr_utility.trace('fix_hr_corrupt l_class_cnt : '||to_char(l_class_cnt));
5578: end if;
5579: --
5580: if l_class_cnt > 0 then
5581: --

Line 5694: -- hr_utility.trace('fix_hr_corrupt, update class : '||l_dummy);

5690: -- where pec.classification_name = l_class_tbl(l_class_ind)
5691: -- and pec.legislation_code = 'JP';
5692: -- --
5693: -- if (g_dbg) then
5694: -- hr_utility.trace('fix_hr_corrupt, update class : '||l_dummy);
5695: -- end if;
5696: -- --
5697: -- if l_dummy is null then
5698: -- --

Line 5700: -- hr_utility.trace('fix_hr_corrupt, no update class: '||l_class_tbl(l_class_ind));

5696: -- --
5697: -- if l_dummy is null then
5698: -- --
5699: -- if (g_dbg) then
5700: -- hr_utility.trace('fix_hr_corrupt, no update class: '||l_class_tbl(l_class_ind));
5701: -- end if;
5702: -- --
5703: -- else
5704: -- --

Line 5713: -- hr_utility.trace('fix_hr_corrupt, no update class err : '||l_class_tbl(l_class_ind));

5709: -- exception
5710: -- when others then
5711: -- --
5712: -- if (g_dbg) then
5713: -- hr_utility.trace('fix_hr_corrupt, no update class err : '||l_class_tbl(l_class_ind));
5714: -- end if;
5715: -- --
5716: -- end;
5717: -- --

Line 5721: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

5717: -- --
5718: -- end loop;
5719: ----
5720: -- if (g_dbg) then
5721: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
5722: -- end if;
5723: --
5724: -- use bulk collect
5725: forall l_class_ind in 1..l_class_tbl.count

Line 5735: hr_utility.set_location(l_proc,20);

5731: --
5732: end if;
5733: --
5734: if (g_dbg) then
5735: hr_utility.set_location(l_proc,20);
5736: end if;
5737: --
5738: -- ---------------------------------------------
5739: -- balance

Line 5747: hr_utility.trace('fix_hr_corrupt l_bal_cnt : '||to_char(l_bal_cnt));

5743: fetch csr_bal_cnt into l_bal_cnt;
5744: close csr_bal_cnt;
5745: --
5746: if (g_dbg) then
5747: hr_utility.trace('fix_hr_corrupt l_bal_cnt : '||to_char(l_bal_cnt));
5748: end if;
5749: --
5750: if l_bal_cnt > 0 then
5751: --

Line 5898: -- hr_utility.trace('fix_hr_corrupt, update bal : '||l_dummy);

5894: -- where pbt.balance_name = l_bal_tbl(l_bal_ind)
5895: -- and pbt.legislation_code = 'JP';
5896: -- --
5897: -- if (g_dbg) then
5898: -- hr_utility.trace('fix_hr_corrupt, update bal : '||l_dummy);
5899: -- end if;
5900: -- --
5901: -- if l_dummy is null then
5902: -- --

Line 5904: -- hr_utility.trace('fix_hr_corrupt, no update bal : '||l_bal_tbl(l_bal_ind));

5900: -- --
5901: -- if l_dummy is null then
5902: -- --
5903: -- if (g_dbg) then
5904: -- hr_utility.trace('fix_hr_corrupt, no update bal : '||l_bal_tbl(l_bal_ind));
5905: -- end if;
5906: -- --
5907: -- else
5908: -- --

Line 5917: -- hr_utility.trace('fix_hr_corrupt, no update bal err : '||l_bal_tbl(l_bal_ind));

5913: -- exception
5914: -- when others then
5915: -- --
5916: -- if (g_dbg) then
5917: -- hr_utility.trace('fix_hr_corrupt, no update bal err : '||l_bal_tbl(l_bal_ind));
5918: -- end if;
5919: -- --
5920: -- end;
5921: -- --

Line 5925: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

5921: -- --
5922: -- end loop;
5923: ----
5924: -- if (g_dbg) then
5925: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
5926: -- end if;
5927: --
5928: -- use bulk collect
5929: forall l_bal_ind in 1..l_bal_tbl.count

Line 5939: hr_utility.set_location(l_proc,30);

5935: --
5936: end if;
5937: --
5938: if (g_dbg) then
5939: hr_utility.set_location(l_proc,30);
5940: end if;
5941: --
5942: -- ---------------------------------------------
5943: -- dimension

Line 5951: hr_utility.trace('fix_hr_corrupt l_dim_cnt : '||to_char(l_dim_cnt));

5947: fetch csr_dim_cnt into l_dim_cnt;
5948: close csr_dim_cnt;
5949: --
5950: if (g_dbg) then
5951: hr_utility.trace('fix_hr_corrupt l_dim_cnt : '||to_char(l_dim_cnt));
5952: end if;
5953: --
5954: if l_dim_cnt > 0 then
5955: --

Line 5989: -- hr_utility.trace('fix_hr_corrupt, update dim : '||l_dummy);

5985: -- where pbd.dimension_name = l_dim_tbl(l_dim_ind)
5986: -- and pbd.legislation_code = 'JP';
5987: -- --
5988: -- if (g_dbg) then
5989: -- hr_utility.trace('fix_hr_corrupt, update dim : '||l_dummy);
5990: -- end if;
5991: -- --
5992: -- if l_dummy is null then
5993: -- --

Line 5995: -- hr_utility.trace('fix_hr_corrupt, no update dim : '||l_dim_tbl(l_dim_ind));

5991: -- --
5992: -- if l_dummy is null then
5993: -- --
5994: -- if (g_dbg) then
5995: -- hr_utility.trace('fix_hr_corrupt, no update dim : '||l_dim_tbl(l_dim_ind));
5996: -- end if;
5997: -- --
5998: -- else
5999: -- --

Line 6008: -- hr_utility.trace('fix_hr_corrupt, no update dim err : '||l_dim_tbl(l_dim_ind));

6004: -- exception
6005: -- when others then
6006: -- --
6007: -- if (g_dbg) then
6008: -- hr_utility.trace('fix_hr_corrupt, no update dim err : '||l_dim_tbl(l_dim_ind));
6009: -- end if;
6010: -- --
6011: -- end;
6012: -- --

Line 6016: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

6012: -- --
6013: -- end loop;
6014: ----
6015: -- if (g_dbg) then
6016: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
6017: -- end if;
6018: --
6019: -- use bulk collect
6020: forall l_dim_ind in 1..l_dim_tbl.count

Line 6031: hr_utility.set_location(l_proc,40);

6027: --
6028: end if;
6029: --
6030: if (g_dbg) then
6031: hr_utility.set_location(l_proc,40);
6032: end if;
6033: --
6034: -- ---------------------------------------------
6035: -- element set

Line 6043: hr_utility.trace('fix_hr_corrupt l_eset_cnt : '||to_char(l_eset_cnt));

6039: fetch csr_eset_cnt into l_eset_cnt;
6040: close csr_eset_cnt;
6041: --
6042: if (g_dbg) then
6043: hr_utility.trace('fix_hr_corrupt l_eset_cnt : '||to_char(l_eset_cnt));
6044: end if;
6045: --
6046: if l_eset_cnt > 0 then
6047: --

Line 6077: -- hr_utility.trace('fix_hr_corrupt, update eset : '||l_dummy);

6073: -- where pes.element_set_name = l_eset_tbl(l_eset_ind)
6074: -- and pes.legislation_code = 'JP';
6075: -- --
6076: -- if (g_dbg) then
6077: -- hr_utility.trace('fix_hr_corrupt, update eset : '||l_dummy);
6078: -- end if;
6079: -- --
6080: -- if l_dummy is null then
6081: -- --

Line 6083: -- hr_utility.trace('fix_hr_corrupt, no update eset : '||l_eset_tbl(l_eset_ind));

6079: -- --
6080: -- if l_dummy is null then
6081: -- --
6082: -- if (g_dbg) then
6083: -- hr_utility.trace('fix_hr_corrupt, no update eset : '||l_eset_tbl(l_eset_ind));
6084: -- end if;
6085: -- --
6086: -- else
6087: -- --

Line 6096: -- hr_utility.trace('fix_hr_corrupt, no update eset err : '||l_eset_tbl(l_eset_ind));

6092: -- exception
6093: -- when others then
6094: -- --
6095: -- if (g_dbg) then
6096: -- hr_utility.trace('fix_hr_corrupt, no update eset err : '||l_eset_tbl(l_eset_ind));
6097: -- end if;
6098: -- --
6099: -- end;
6100: -- --

Line 6104: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

6100: -- --
6101: -- end loop;
6102: ----
6103: -- if (g_dbg) then
6104: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
6105: -- end if;
6106: --
6107: -- use bulk collect
6108: forall l_eset_ind in 1..l_eset_tbl.count

Line 6117: hr_utility.set_location(l_proc,50);

6113: --
6114: end if;
6115: --
6116: if (g_dbg) then
6117: hr_utility.set_location(l_proc,50);
6118: end if;
6119: --
6120: -- ---------------------------------------------
6121: -- global value

Line 6129: hr_utility.trace('fix_hr_corrupt l_glb_cnt : '||to_char(l_glb_cnt));

6125: fetch csr_glb_cnt into l_glb_cnt;
6126: close csr_glb_cnt;
6127: --
6128: if (g_dbg) then
6129: hr_utility.trace('fix_hr_corrupt l_glb_cnt : '||to_char(l_glb_cnt));
6130: end if;
6131: --
6132: if l_glb_cnt > 0 then
6133: --

Line 6182: -- hr_utility.trace('fix_hr_corrupt, update glb : '||l_dummy);

6178: -- from ff_globals_f fg2
6179: -- where fg2.global_id = fg.global_id);
6180: -- --
6181: -- if (g_dbg) then
6182: -- hr_utility.trace('fix_hr_corrupt, update glb : '||l_dummy);
6183: -- end if;
6184: -- --
6185: -- if l_dummy is null then
6186: -- --

Line 6188: -- hr_utility.trace('fix_hr_corrupt, no update glb : '||l_glb_tbl(l_glb_ind));

6184: -- --
6185: -- if l_dummy is null then
6186: -- --
6187: -- if (g_dbg) then
6188: -- hr_utility.trace('fix_hr_corrupt, no update glb : '||l_glb_tbl(l_glb_ind));
6189: -- end if;
6190: -- --
6191: -- else
6192: -- --

Line 6201: -- hr_utility.trace('fix_hr_corrupt, no update glb err : '||l_glb_tbl(l_glb_ind));

6197: -- exception
6198: -- when others then
6199: -- --
6200: -- if (g_dbg) then
6201: -- hr_utility.trace('fix_hr_corrupt, no update glb err : '||l_glb_tbl(l_glb_ind));
6202: -- end if;
6203: -- --
6204: -- end;
6205: -- --

Line 6209: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

6205: -- --
6206: -- end loop;
6207: ----
6208: -- if (g_dbg) then
6209: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
6210: -- end if;
6211: --
6212: l_status_mode := hr_general.g_data_migrator_mode;
6213: --

Line 6235: hr_utility.set_location(l_proc,55);

6231: -- unset for subsequent procedure to enable trigger
6232: hr_general.g_data_migrator_mode := l_status_mode;
6233: --
6234: if (g_dbg) then
6235: hr_utility.set_location(l_proc,55);
6236: end if;
6237: --
6238: for l_glb_tl_ind in 1..l_glb_tbl.count loop
6239: --

Line 6263: hr_utility.set_location(l_proc,60);

6259: --
6260: end if;
6261: --
6262: if (g_dbg) then
6263: hr_utility.set_location(l_proc,60);
6264: end if;
6265: --
6266: -- ---------------------------------------------
6267: -- formula

Line 6275: hr_utility.trace('fix_hr_corrupt l_ff_cnt : '||to_char(l_ff_cnt));

6271: fetch csr_ff_cnt into l_ff_cnt;
6272: close csr_ff_cnt;
6273: --
6274: if (g_dbg) then
6275: hr_utility.trace('fix_hr_corrupt l_ff_cnt : '||to_char(l_ff_cnt));
6276: end if;
6277: --
6278: if l_ff_cnt > 0 then
6279: --

Line 6388: -- hr_utility.trace('fix_hr_corrupt, update ff : '||l_dummy);

6384: -- from ff_formulas_f ff2
6385: -- where ff2.formula_id = ff.formula_id);
6386: -- --
6387: -- if (g_dbg) then
6388: -- hr_utility.trace('fix_hr_corrupt, update ff : '||l_dummy);
6389: -- end if;
6390: -- --
6391: -- if l_dummy is null then
6392: -- --

Line 6394: -- hr_utility.trace('fix_hr_corrupt, no update ff : '||l_ff_tbl(l_ff_ind));

6390: -- --
6391: -- if l_dummy is null then
6392: -- --
6393: -- if (g_dbg) then
6394: -- hr_utility.trace('fix_hr_corrupt, no update ff : '||l_ff_tbl(l_ff_ind));
6395: -- end if;
6396: -- --
6397: -- else
6398: -- --

Line 6407: -- hr_utility.trace('fix_hr_corrupt, no update ff err : '||l_ff_tbl(l_ff_ind));

6403: -- exception
6404: -- when others then
6405: -- --
6406: -- if (g_dbg) then
6407: -- hr_utility.trace('fix_hr_corrupt, no update ff err : '||l_ff_tbl(l_ff_ind));
6408: -- end if;
6409: -- --
6410: -- end;
6411: -- --

Line 6415: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

6411: -- --
6412: -- end loop;
6413: ----
6414: -- if (g_dbg) then
6415: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
6416: -- end if;
6417: --
6418: -- use bulk collect
6419: forall l_ff_ind in 1..l_ff_tbl.count

Line 6429: hr_utility.set_location(l_proc,70);

6425: --
6426: end if;
6427: --
6428: if (g_dbg) then
6429: hr_utility.set_location(l_proc,70);
6430: end if;
6431: --
6432: -- ---------------------------------------------
6433: -- monetary unit

Line 6441: hr_utility.trace('fix_hr_corrupt l_mon_cnt : '||to_char(l_mon_cnt));

6437: fetch csr_mon_cnt into l_mon_cnt;
6438: close csr_mon_cnt;
6439: --
6440: if (g_dbg) then
6441: hr_utility.trace('fix_hr_corrupt l_mon_cnt : '||to_char(l_mon_cnt));
6442: end if;
6443: --
6444: if l_mon_cnt > 0 then
6445: --

Line 6476: -- hr_utility.trace('fix_hr_corrupt, update mon : '||l_dummy);

6472: -- where pmu.monetary_unit_name = l_mon_tbl(l_mon_ind)
6473: -- and pmu.legislation_code = 'JP';
6474: -- --
6475: -- if (g_dbg) then
6476: -- hr_utility.trace('fix_hr_corrupt, update mon : '||l_dummy);
6477: -- end if;
6478: -- --
6479: -- if l_dummy is null then
6480: -- --

Line 6482: -- hr_utility.trace('fix_hr_corrupt, no update mon : '||l_mon_tbl(l_mon_ind));

6478: -- --
6479: -- if l_dummy is null then
6480: -- --
6481: -- if (g_dbg) then
6482: -- hr_utility.trace('fix_hr_corrupt, no update mon : '||l_mon_tbl(l_mon_ind));
6483: -- end if;
6484: -- --
6485: -- else
6486: -- --

Line 6495: -- hr_utility.trace('fix_hr_corrupt, no update mon err : '||l_mon_tbl(l_mon_ind));

6491: -- exception
6492: -- when others then
6493: -- --
6494: -- if (g_dbg) then
6495: -- hr_utility.trace('fix_hr_corrupt, no update mon err : '||l_mon_tbl(l_mon_ind));
6496: -- end if;
6497: -- --
6498: -- end;
6499: -- --

Line 6503: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

6499: -- --
6500: -- end loop;
6501: ----
6502: -- if (g_dbg) then
6503: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
6504: -- end if;
6505: --
6506: -- use bulk collect
6507: forall l_mon_ind in 1..l_mon_tbl.count

Line 6516: hr_utility.set_location(l_proc,80);

6512: --
6513: end if;
6514: --
6515: if (g_dbg) then
6516: hr_utility.set_location(l_proc,80);
6517: end if;
6518: --
6519: -- ---------------------------------------------
6520: -- udt

Line 6528: hr_utility.trace('fix_hr_corrupt l_udt_cnt : '||to_char(l_udt_cnt));

6524: fetch csr_udt_cnt into l_udt_cnt;
6525: close csr_udt_cnt;
6526: --
6527: if (g_dbg) then
6528: hr_utility.trace('fix_hr_corrupt l_udt_cnt : '||to_char(l_udt_cnt));
6529: end if;
6530: --
6531: if l_udt_cnt > 0 then
6532: --

Line 6588: -- hr_utility.trace('fix_hr_corrupt, update udt : '||l_dummy);

6584: -- where put.user_table_name = l_udt_tbl(l_udt_ind)
6585: -- and put.legislation_code = 'JP';
6586: -- --
6587: -- if (g_dbg) then
6588: -- hr_utility.trace('fix_hr_corrupt, update udt : '||l_dummy);
6589: -- end if;
6590: -- --
6591: -- if l_dummy is null then
6592: -- --

Line 6594: -- hr_utility.trace('fix_hr_corrupt, no update udt : '||l_udt_tbl(l_udt_ind));

6590: -- --
6591: -- if l_dummy is null then
6592: -- --
6593: -- if (g_dbg) then
6594: -- hr_utility.trace('fix_hr_corrupt, no update udt : '||l_udt_tbl(l_udt_ind));
6595: -- end if;
6596: -- --
6597: -- else
6598: -- --

Line 6607: -- hr_utility.trace('fix_hr_corrupt, no update udt err : '||l_udt_tbl(l_udt_ind));

6603: -- exception
6604: -- when others then
6605: -- --
6606: -- if (g_dbg) then
6607: -- hr_utility.trace('fix_hr_corrupt, no update udt err : '||l_udt_tbl(l_udt_ind));
6608: -- end if;
6609: -- --
6610: -- end;
6611: -- --

Line 6615: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));

6611: -- --
6612: -- end loop;
6613: ----
6614: -- if (g_dbg) then
6615: -- hr_utility.trace('fix_hr_corrupt l_dummy_cnt : '||to_char(l_dummy_cnt));
6616: -- end if;
6617: --
6618: -- use bulk collect
6619: forall l_udt_ind in 1..l_udt_tbl.count

Line 6629: hr_utility.set_location(l_proc,1000);

6625: --
6626: end if;
6627: --
6628: if (g_dbg) then
6629: hr_utility.set_location(l_proc,1000);
6630: end if;
6631: --
6632: end fix_hr_corrupt;
6633: --

Line 6671: hr_utility.set_location(l_proc,0);

6667: --
6668: begin
6669: --
6670: if (g_dbg) then
6671: hr_utility.set_location(l_proc,0);
6672: end if;
6673: --
6674: open csr_pay_install;
6675: fetch csr_pay_install into l_pay_install;

Line 6679: hr_utility.trace('chk_dbi_corrupt l_pay_install : '||l_pay_install);

6675: fetch csr_pay_install into l_pay_install;
6676: close csr_pay_install;
6677: --
6678: if (g_dbg) then
6679: hr_utility.trace('chk_dbi_corrupt l_pay_install : '||l_pay_install);
6680: end if;
6681: --
6682: if l_pay_install is not null
6683: and l_pay_install = 'Y' then

Line 6690: hr_utility.trace('chk_dbi_corrupt l_run_script : '||l_run_script);

6686: fetch csr_run_script into l_run_script, l_process_type;
6687: close csr_run_script;
6688: --
6689: if (g_dbg) then
6690: hr_utility.trace('chk_dbi_corrupt l_run_script : '||l_run_script);
6691: hr_utility.trace('chk_dbi_corrupt l_process_type : '||l_process_type);
6692: end if;
6693: --
6694: if l_run_script is not null

Line 6691: hr_utility.trace('chk_dbi_corrupt l_process_type : '||l_process_type);

6687: close csr_run_script;
6688: --
6689: if (g_dbg) then
6690: hr_utility.trace('chk_dbi_corrupt l_run_script : '||l_run_script);
6691: hr_utility.trace('chk_dbi_corrupt l_process_type : '||l_process_type);
6692: end if;
6693: --
6694: if l_run_script is not null
6695: and l_run_script = 'Y' then

Line 6711: hr_utility.trace('chk_dbi_corrupt o_dbi_corrupt : '||o_dbi_corrupt);

6707: --
6708: end if;
6709: --
6710: if (g_dbg) then
6711: hr_utility.trace('chk_dbi_corrupt o_dbi_corrupt : '||o_dbi_corrupt);
6712: hr_utility.set_location(l_proc,1000);
6713: end if;
6714: --
6715: return o_dbi_corrupt;

Line 6712: hr_utility.set_location(l_proc,1000);

6708: end if;
6709: --
6710: if (g_dbg) then
6711: hr_utility.trace('chk_dbi_corrupt o_dbi_corrupt : '||o_dbi_corrupt);
6712: hr_utility.set_location(l_proc,1000);
6713: end if;
6714: --
6715: return o_dbi_corrupt;
6716: end chk_dbi_corrupt;

Line 6764: hr_utility.set_location(l_proc,0);

6760: --
6761: begin
6762: --
6763: if (g_dbg) then
6764: hr_utility.set_location(l_proc,0);
6765: end if;
6766: --
6767: -- ---------------------------------------------
6768: -- corrupt dbi tl by mismatch ja udt col

Line 6778: hr_utility.trace('fix_dbi_corrupt l_corrupt_dbi_tl_cnt : '||to_char(l_corrupt_dbi_tl_cnt));

6774: fetch csr_corrupt_dbi_tl into l_corrupt_dbi_tl_cnt;
6775: close csr_corrupt_dbi_tl;
6776: --
6777: if (g_dbg) then
6778: hr_utility.trace('fix_dbi_corrupt l_corrupt_dbi_tl_cnt : '||to_char(l_corrupt_dbi_tl_cnt));
6779: end if;
6780: --
6781: if l_corrupt_dbi_tl_cnt > 0 then
6782: --

Line 6833: hr_utility.set_location(l_proc,10);

6829: --
6830: end if;
6831: --
6832: if (g_dbg) then
6833: hr_utility.set_location(l_proc,10);
6834: end if;
6835: --
6836: update pay_patch_status
6837: set process_type = decode(nvl(process_type,'X'),'X',null,process_type||',')||'12566233'

Line 6844: hr_utility.set_location(l_proc,1000);

6840: and phase = 'C'
6841: and legislation_code = 'JP';
6842: --
6843: if (g_dbg) then
6844: hr_utility.set_location(l_proc,1000);
6845: end if;
6846: --
6847: end fix_dbi_corrupt;
6848: --

Line 6861: hr_utility.set_location(l_proc,0);

6857: l_proc VARCHAR2(50) := g_pkg||'.migrate_data';
6858: --
6859: BEGIN
6860: --
6861: hr_utility.set_location(l_proc,0);
6862: --
6863: -- this corrupt data fix routine is required here before rename
6864: --
6865: if chk_hr_corrupt = 'Y' then

Line 6867: hr_utility.trace('chk_hr_corrupt true');

6863: -- this corrupt data fix routine is required here before rename
6864: --
6865: if chk_hr_corrupt = 'Y' then
6866: --
6867: hr_utility.trace('chk_hr_corrupt true');
6868: --
6869: fix_hr_corrupt;
6870: --
6871: hr_utility.set_location(l_proc,5);

Line 6871: hr_utility.set_location(l_proc,5);

6867: hr_utility.trace('chk_hr_corrupt true');
6868: --
6869: fix_hr_corrupt;
6870: --
6871: hr_utility.set_location(l_proc,5);
6872: --
6873: end if;
6874: --
6875: hr_utility.set_location(l_proc,10);

Line 6875: hr_utility.set_location(l_proc,10);

6871: hr_utility.set_location(l_proc,5);
6872: --
6873: end if;
6874: --
6875: hr_utility.set_location(l_proc,10);
6876: --
6877: SELECT COUNT(1)
6878: INTO l_count
6879: FROM pay_input_values_f

Line 6887: hr_utility.set_location(l_proc, 20);

6883: IF (l_count > 0) THEN
6884: migrate_input_values;
6885: END IF;
6886:
6887: hr_utility.set_location(l_proc, 20);
6888:
6889: SELECT COUNT(1)
6890: INTO l_count
6891: FROM pay_element_types_f

Line 6900: hr_utility.set_location(l_proc, 30);

6896: IF (l_count > 0) THEN
6897: migrate_element_types;
6898: END IF;
6899:
6900: hr_utility.set_location(l_proc, 30);
6901:
6902: SELECT COUNT(1)
6903: INTO l_count
6904: FROM pay_element_classifications

Line 6912: hr_utility.set_location(l_proc, 40);

6908: IF (l_count > 0) THEN
6909: migrate_element_class;
6910: END IF;
6911:
6912: hr_utility.set_location(l_proc, 40);
6913:
6914: SELECT COUNT(1)
6915: INTO l_count
6916: FROM pay_balance_types

Line 6925: hr_utility.set_location(l_proc, 50);

6921: IF (l_count > 0) THEN
6922: migrate_balance_types;
6923: END IF;
6924:
6925: hr_utility.set_location(l_proc, 50);
6926:
6927: SELECT COUNT(1)
6928: INTO l_count
6929: FROM pay_balance_dimensions

Line 6937: hr_utility.set_location(l_proc, 60);

6933: IF (l_count > 0) THEN
6934: migrate_bal_dimensions;
6935: END IF;
6936:
6937: hr_utility.set_location(l_proc, 60);
6938:
6939: SELECT COUNT(1)
6940: INTO l_count
6941: FROM pay_element_sets

Line 6949: hr_utility.set_location(l_proc, 70);

6945: IF (l_count > 0) THEN
6946: migrate_element_sets;
6947: END IF;
6948:
6949: hr_utility.set_location(l_proc, 70);
6950:
6951: SELECT COUNT(1)
6952: INTO l_count
6953: FROM ff_globals_f

Line 6962: hr_utility.set_location(l_proc, 80);

6958: IF (l_count > 0) THEN
6959: migrate_globals;
6960: END IF;
6961:
6962: hr_utility.set_location(l_proc, 80);
6963:
6964: SELECT COUNT(1)
6965: INTO l_count
6966: FROM ff_formulas_f

Line 6975: hr_utility.set_location(l_proc, 90);

6971: IF (l_count > 0) THEN
6972: migrate_formulas;
6973: END IF;
6974:
6975: hr_utility.set_location(l_proc, 90);
6976:
6977: SELECT COUNT(1)
6978: INTO l_count
6979: FROM pay_monetary_units

Line 6987: hr_utility.set_location(l_proc, 100);

6983: IF (l_count > 0) THEN
6984: migrate_monetary_units;
6985: END IF;
6986:
6987: hr_utility.set_location(l_proc, 100);
6988:
6989: SELECT COUNT(1)
6990: INTO l_count
6991: FROM pay_user_columns

Line 6999: hr_utility.set_location(l_proc, 110);

6995: IF (l_count > 0) THEN
6996: migrate_user_columns;
6997: END IF;
6998:
6999: hr_utility.set_location(l_proc, 110);
7000:
7001: SELECT COUNT(1)
7002: INTO l_count
7003: FROM pay_user_rows_f

Line 7011: hr_utility.set_location(l_proc, 120);

7007: IF (l_count > 0) THEN
7008: migrate_user_rows;
7009: END IF;
7010:
7011: hr_utility.set_location(l_proc, 120);
7012:
7013: SELECT COUNT(1)
7014: INTO l_count
7015: FROM pay_user_tables

Line 7023: hr_utility.set_location(l_proc, 130);

7019: IF (l_count > 0) THEN
7020: migrate_user_tables;
7021: END IF;
7022:
7023: hr_utility.set_location(l_proc, 130);
7024:
7025: -- To delete JP Char DBI's
7026: delete_dbi;
7027:

Line 7028: hr_utility.set_location(l_proc, 140);

7024:
7025: -- To delete JP Char DBI's
7026: delete_dbi;
7027:
7028: hr_utility.set_location(l_proc, 140);
7029: --
7030: migrate_li_ff;
7031: --
7032: hr_utility.set_location(l_proc, 150);

Line 7032: hr_utility.set_location(l_proc, 150);

7028: hr_utility.set_location(l_proc, 140);
7029: --
7030: migrate_li_ff;
7031: --
7032: hr_utility.set_location(l_proc, 150);
7033: --
7034: -- this corrupt data fix routine is required here after delete_dbi
7035: --
7036: if chk_dbi_corrupt = 'Y' then

Line 7038: hr_utility.trace('chk_dbi_corrupt true');

7034: -- this corrupt data fix routine is required here after delete_dbi
7035: --
7036: if chk_dbi_corrupt = 'Y' then
7037: --
7038: hr_utility.trace('chk_dbi_corrupt true');
7039: --
7040: fix_dbi_corrupt;
7041: --
7042: hr_utility.set_location(l_proc,155);

Line 7042: hr_utility.set_location(l_proc,155);

7038: hr_utility.trace('chk_dbi_corrupt true');
7039: --
7040: fix_dbi_corrupt;
7041: --
7042: hr_utility.set_location(l_proc,155);
7043: --
7044: end if;
7045: --
7046: hr_utility.set_location('Successful completion of ' || l_proc, 160);

Line 7046: hr_utility.set_location('Successful completion of ' || l_proc, 160);

7042: hr_utility.set_location(l_proc,155);
7043: --
7044: end if;
7045: --
7046: hr_utility.set_location('Successful completion of ' || l_proc, 160);
7047: --
7048: EXCEPTION
7049:
7050: WHEN OTHERS THEN

Line 7052: hr_utility.set_location(l_proc, 160);

7048: EXCEPTION
7049:
7050: WHEN OTHERS THEN
7051:
7052: hr_utility.set_location(l_proc, 160);
7053:
7054: raise;
7055:
7056: END migrate_data;