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_GENERIC_UPGRADE_PKG dependencies on HR_JP_DATA_MIGRATION_PKG

Line 2019: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;

2015: l_proc varchar2(80) := c_package||'qualify_hi_smr_data';
2016: --
2017: l_valid_delete varchar2(1) := 'N';
2018: --
2019: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;
2020: --
2021: begin
2022: --
2023: if g_debug then

Line 2028: hr_jp_data_migration_pkg.init_def_hi_smr_data;

2024: hr_utility.set_location(l_proc,0);
2025: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2026: end if;
2027: --
2028: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

Line 2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

2028: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2036: --

Line 2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);

2029: --
2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2036: --
2037: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then

Line 2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));

2030: if g_debug then
2031: hr_utility.set_location(l_proc,10);
2032: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2036: --
2037: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2038: --

Line 2037: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then

2033: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2034: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2035: end if;
2036: --
2037: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2038: --
2039: if g_debug then
2040: hr_utility.set_location(l_proc,20);
2041: end if;

Line 2044: hr_jp_data_migration_pkg.qualify_hi_smr_hd(

2040: hr_utility.set_location(l_proc,20);
2041: end if;
2042: --
2043: -- print header for each threads but it is ok because just log.
2044: hr_jp_data_migration_pkg.qualify_hi_smr_hd(
2045: p_assignment_id => p_assignment_id);
2046: --
2047: if g_debug then
2048: hr_utility.set_location(l_proc,30);

Line 2051: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(

2047: if g_debug then
2048: hr_utility.set_location(l_proc,30);
2049: end if;
2050: --
2051: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2052: p_assignment_id => p_assignment_id,
2053: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2054: --
2055: if g_debug then

Line 2053: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);

2049: end if;
2050: --
2051: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2052: p_assignment_id => p_assignment_id,
2053: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2054: --
2055: if g_debug then
2056: hr_utility.set_location(l_proc,40);
2057: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));

Line 2060: hr_jp_data_migration_pkg.val_mig_smr_assact(

2056: hr_utility.set_location(l_proc,40);
2057: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2058: end if;
2059: --
2060: hr_jp_data_migration_pkg.val_mig_smr_assact(
2061: p_business_group_id => l_ass_info.bg_id,
2062: p_business_group_name => l_ass_info.bg_name,
2063: p_assignment_id => p_assignment_id,
2064: p_assignment_number => l_ass_info.ass_num,

Line 2065: p_session_date => hr_jp_data_migration_pkg.g_mig_date,

2061: p_business_group_id => l_ass_info.bg_id,
2062: p_business_group_name => l_ass_info.bg_name,
2063: p_assignment_id => p_assignment_id,
2064: p_assignment_number => l_ass_info.ass_num,
2065: p_session_date => hr_jp_data_migration_pkg.g_mig_date,
2066: p_valid_delete => l_valid_delete);
2067: --
2068: if g_debug then
2069: hr_utility.set_location(l_proc,50);

Line 2109: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;

2105: is
2106: --
2107: l_proc varchar2(80) := c_package||'migrate_hi_smr_data';
2108: --
2109: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;
2110: --
2111: begin
2112: --
2113: if g_debug then

Line 2119: hr_jp_data_migration_pkg.init_def_hi_smr_data;

2115: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2116: end if;
2117: --
2118: -- need to reset for retry, qualify_obs_data is not called in retry process.
2119: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2120: --
2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

Line 2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

2119: hr_jp_data_migration_pkg.init_def_hi_smr_data;
2120: --
2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2127: --

Line 2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);

2120: --
2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2127: --
2128: -- print header for each threads but it is ok because just log.

Line 2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));

2121: if g_debug then
2122: hr_utility.set_location(l_proc,10);
2123: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2124: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2127: --
2128: -- print header for each threads but it is ok because just log.
2129: hr_jp_data_migration_pkg.migrate_hi_smr_hd(

Line 2129: hr_jp_data_migration_pkg.migrate_hi_smr_hd(

2125: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2126: end if;
2127: --
2128: -- print header for each threads but it is ok because just log.
2129: hr_jp_data_migration_pkg.migrate_hi_smr_hd(
2130: p_assignment_id => p_assignment_id);
2131: --
2132: if g_debug then
2133: hr_utility.set_location(l_proc,20);

Line 2136: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(

2132: if g_debug then
2133: hr_utility.set_location(l_proc,20);
2134: end if;
2135: --
2136: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2137: p_assignment_id => p_assignment_id,
2138: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2139: --
2140: if g_debug then

Line 2138: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);

2134: end if;
2135: --
2136: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2137: p_assignment_id => p_assignment_id,
2138: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2139: --
2140: if g_debug then
2141: hr_utility.set_location(l_proc,30);
2142: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));

Line 2146: hr_jp_data_migration_pkg.insert_session(

2142: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2143: end if;
2144: --
2145: -- for api use
2146: hr_jp_data_migration_pkg.insert_session(
2147: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2148: --
2149: hr_jp_data_migration_pkg.mig_smr_assact(
2150: p_business_group_id => l_ass_info.bg_id,

Line 2147: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);

2143: end if;
2144: --
2145: -- for api use
2146: hr_jp_data_migration_pkg.insert_session(
2147: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2148: --
2149: hr_jp_data_migration_pkg.mig_smr_assact(
2150: p_business_group_id => l_ass_info.bg_id,
2151: p_business_group_name => l_ass_info.bg_name,

Line 2149: hr_jp_data_migration_pkg.mig_smr_assact(

2145: -- for api use
2146: hr_jp_data_migration_pkg.insert_session(
2147: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2148: --
2149: hr_jp_data_migration_pkg.mig_smr_assact(
2150: p_business_group_id => l_ass_info.bg_id,
2151: p_business_group_name => l_ass_info.bg_name,
2152: p_assignment_id => p_assignment_id,
2153: p_assignment_number => l_ass_info.ass_num,

Line 2154: p_session_date => hr_jp_data_migration_pkg.g_mig_date,

2150: p_business_group_id => l_ass_info.bg_id,
2151: p_business_group_name => l_ass_info.bg_name,
2152: p_assignment_id => p_assignment_id,
2153: p_assignment_number => l_ass_info.ass_num,
2154: p_session_date => hr_jp_data_migration_pkg.g_mig_date,
2155: p_hi_mr => null);
2156: --
2157: -- delete session is invalid, cause no data found.
2158: --hr_jp_data_migration_pkg.delete_session;

Line 2158: --hr_jp_data_migration_pkg.delete_session;

2154: p_session_date => hr_jp_data_migration_pkg.g_mig_date,
2155: p_hi_mr => null);
2156: --
2157: -- delete session is invalid, cause no data found.
2158: --hr_jp_data_migration_pkg.delete_session;
2159: --
2160: -- commit is invalid in archive loop for ORA-01002
2161: -- automatically commit will be executed for each assignment in archive process.
2162: -- commit;

Line 2311: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;

2307: l_proc varchar2(80) := c_package||'qualify_dep_data';
2308: --
2309: l_valid_update varchar2(1) := 'N';
2310: --
2311: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;
2312: --
2313: begin
2314: --
2315: if g_debug then

Line 2320: hr_jp_data_migration_pkg.init_def_dep_data;

2316: hr_utility.set_location(l_proc,0);
2317: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2318: end if;
2319: --
2320: hr_jp_data_migration_pkg.init_def_dep_data;
2321: --
2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

Line 2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

2320: hr_jp_data_migration_pkg.init_def_dep_data;
2321: --
2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2328: --

Line 2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);

2321: --
2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2328: --
2329: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then

Line 2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));

2322: if g_debug then
2323: hr_utility.set_location(l_proc,10);
2324: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2328: --
2329: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2330: --

Line 2329: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then

2325: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2326: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2327: end if;
2328: --
2329: if hr_jp_data_migration_pkg.g_skip_qualify = 'N' then
2330: --
2331: if g_debug then
2332: hr_utility.set_location(l_proc,20);
2333: end if;

Line 2336: hr_jp_data_migration_pkg.qualify_dep_hd(

2332: hr_utility.set_location(l_proc,20);
2333: end if;
2334: --
2335: -- print header for each threads but it is ok because just log.
2336: hr_jp_data_migration_pkg.qualify_dep_hd(
2337: p_assignment_id => p_assignment_id);
2338: --
2339: if g_debug then
2340: hr_utility.set_location(l_proc,30);

Line 2343: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(

2339: if g_debug then
2340: hr_utility.set_location(l_proc,30);
2341: end if;
2342: --
2343: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2344: p_assignment_id => p_assignment_id,
2345: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2346: --
2347: if g_debug then

Line 2345: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);

2341: end if;
2342: --
2343: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2344: p_assignment_id => p_assignment_id,
2345: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2346: --
2347: if g_debug then
2348: hr_utility.set_location(l_proc,40);
2349: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));

Line 2352: hr_jp_data_migration_pkg.val_mig_dep_assact(

2348: hr_utility.set_location(l_proc,40);
2349: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2350: end if;
2351: --
2352: hr_jp_data_migration_pkg.val_mig_dep_assact(
2353: p_business_group_id => l_ass_info.bg_id,
2354: p_business_group_name => l_ass_info.bg_name,
2355: p_assignment_id => p_assignment_id,
2356: p_assignment_number => l_ass_info.ass_num,

Line 2357: p_session_date => hr_jp_data_migration_pkg.g_mig_date,

2353: p_business_group_id => l_ass_info.bg_id,
2354: p_business_group_name => l_ass_info.bg_name,
2355: p_assignment_id => p_assignment_id,
2356: p_assignment_number => l_ass_info.ass_num,
2357: p_session_date => hr_jp_data_migration_pkg.g_mig_date,
2358: p_valid_update => l_valid_update);
2359: --
2360: if g_debug then
2361: hr_utility.set_location(l_proc,50);

Line 2400: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;

2396: is
2397: --
2398: l_proc varchar2(80) := c_package||'migrate_dep_data';
2399: --
2400: l_ass_info hr_jp_data_migration_pkg.t_ass_hi_smr_rec;
2401: --
2402: begin
2403: --
2404: if g_debug then

Line 2410: hr_jp_data_migration_pkg.init_def_dep_data;

2406: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2407: end if;
2408: --
2409: -- need to reset for retry, qualify_dep_data is not called in retry process.
2410: hr_jp_data_migration_pkg.init_def_dep_data;
2411: --
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

Line 2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);

2410: hr_jp_data_migration_pkg.init_def_dep_data;
2411: --
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2418: --

Line 2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);

2411: --
2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2418: --
2419: -- print header for each threads but it is ok because just log.

Line 2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));

2412: if g_debug then
2413: hr_utility.set_location(l_proc,10);
2414: hr_utility.trace('hr_jp_data_migration_pkg.g_skip_qualify : '||hr_jp_data_migration_pkg.g_skip_qualify);
2415: hr_utility.trace('hr_jp_data_migration_pkg.g_upd_mode : '||hr_jp_data_migration_pkg.g_upd_mode);
2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2418: --
2419: -- print header for each threads but it is ok because just log.
2420: hr_jp_data_migration_pkg.migrate_dep_hd(

Line 2420: hr_jp_data_migration_pkg.migrate_dep_hd(

2416: hr_utility.trace('hr_jp_data_migration_pkg.g_mig_date : '||to_char(hr_jp_data_migration_pkg.g_mig_date,'YYYY/MM/DD'));
2417: end if;
2418: --
2419: -- print header for each threads but it is ok because just log.
2420: hr_jp_data_migration_pkg.migrate_dep_hd(
2421: p_assignment_id => p_assignment_id);
2422: --
2423: if g_debug then
2424: hr_utility.set_location(l_proc,20);

Line 2427: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(

2423: if g_debug then
2424: hr_utility.set_location(l_proc,20);
2425: end if;
2426: --
2427: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2428: p_assignment_id => p_assignment_id,
2429: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2430: --
2431: if g_debug then

Line 2429: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);

2425: end if;
2426: --
2427: l_ass_info := hr_jp_data_migration_pkg.get_ass_info(
2428: p_assignment_id => p_assignment_id,
2429: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2430: --
2431: if g_debug then
2432: hr_utility.set_location(l_proc,30);
2433: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));

Line 2437: hr_jp_data_migration_pkg.insert_session(

2433: hr_utility.trace('l_ass_info.ass_id : '||to_char(l_ass_info.ass_id));
2434: end if;
2435: --
2436: -- for api use
2437: hr_jp_data_migration_pkg.insert_session(
2438: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2439: --
2440: hr_jp_data_migration_pkg.mig_dep_assact(
2441: p_business_group_id => l_ass_info.bg_id,

Line 2438: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);

2434: end if;
2435: --
2436: -- for api use
2437: hr_jp_data_migration_pkg.insert_session(
2438: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2439: --
2440: hr_jp_data_migration_pkg.mig_dep_assact(
2441: p_business_group_id => l_ass_info.bg_id,
2442: p_business_group_name => l_ass_info.bg_name,

Line 2440: hr_jp_data_migration_pkg.mig_dep_assact(

2436: -- for api use
2437: hr_jp_data_migration_pkg.insert_session(
2438: p_effective_date => hr_jp_data_migration_pkg.g_mig_date);
2439: --
2440: hr_jp_data_migration_pkg.mig_dep_assact(
2441: p_business_group_id => l_ass_info.bg_id,
2442: p_business_group_name => l_ass_info.bg_name,
2443: p_assignment_id => p_assignment_id,
2444: p_assignment_number => l_ass_info.ass_num,

Line 2445: p_session_date => hr_jp_data_migration_pkg.g_mig_date);

2441: p_business_group_id => l_ass_info.bg_id,
2442: p_business_group_name => l_ass_info.bg_name,
2443: p_assignment_id => p_assignment_id,
2444: p_assignment_number => l_ass_info.ass_num,
2445: p_session_date => hr_jp_data_migration_pkg.g_mig_date);
2446: --
2447: -- delete session is invalid, cause no data found.
2448: --hr_jp_data_migration_pkg.delete_session;
2449: --

Line 2448: --hr_jp_data_migration_pkg.delete_session;

2444: p_assignment_number => l_ass_info.ass_num,
2445: p_session_date => hr_jp_data_migration_pkg.g_mig_date);
2446: --
2447: -- delete session is invalid, cause no data found.
2448: --hr_jp_data_migration_pkg.delete_session;
2449: --
2450: -- commit is invalid in archive loop for ORA-01002
2451: -- automatically commit will be executed for each assignment in archive process.
2452: -- commit;