531: --
532: -- Stage 1 - Select person latest records and create TCA
533: -- person records.
534: --
535: l_data_migrator_mode := hr_general.g_data_migrator_mode;
536: hr_general.g_data_migrator_mode := 'Y';
537: --
538: g_count := 100;
539: --
532: -- Stage 1 - Select person latest records and create TCA
533: -- person records.
534: --
535: l_data_migrator_mode := hr_general.g_data_migrator_mode;
536: hr_general.g_data_migrator_mode := 'Y';
537: --
538: g_count := 100;
539: --
540: open c_person;
602: commit;
603: --
604: g_count := 0;
605: --
606: hr_general.g_data_migrator_mode := l_data_migrator_mode;
607: --
608: hr_utility.set_location('Entering '||l_proc,10);
609: --
610: end;
1418: t_papf_party_id g_party_id_type;
1419: --
1420: begin
1421: --
1422: l_data_migrator_mode := hr_general.g_data_migrator_mode;
1423: hr_general.g_data_migrator_mode := 'Y';
1424: --
1425: --
1426: /*
1419: --
1420: begin
1421: --
1422: l_data_migrator_mode := hr_general.g_data_migrator_mode;
1423: hr_general.g_data_migrator_mode := 'Y';
1424: --
1425: --
1426: /*
1427: hr_utility.set_location('Entering : '||l_proc,10);
1658: --
1659: hr_utility.set_location('Leaving '||l_proc,10);
1660: --
1661: --
1662: hr_general.g_data_migrator_mode := l_data_migrator_mode;
1663: --
1664: --
1665: end clear_parties_from_hrms;
1666: --
2203: --
2204: if l_have_rows_topurge > 0 then
2205: --
2206: --
2207: l_data_migrator_mode := hr_general.g_data_migrator_mode;
2208: hr_general.g_data_migrator_mode := 'Y';
2209: --
2210: clear_parties_from_hrms();
2211: --
2204: if l_have_rows_topurge > 0 then
2205: --
2206: --
2207: l_data_migrator_mode := hr_general.g_data_migrator_mode;
2208: hr_general.g_data_migrator_mode := 'Y';
2209: --
2210: clear_parties_from_hrms();
2211: --
2212: hr_general.g_data_migrator_mode := l_data_migrator_mode;
2208: hr_general.g_data_migrator_mode := 'Y';
2209: --
2210: clear_parties_from_hrms();
2211: --
2212: hr_general.g_data_migrator_mode := l_data_migrator_mode;
2213: --
2214: begin
2215: insert into hr_purge_parties_gt (PARTY_ID)
2216: select distinct party_id
2283: --
2284: if l_have_rows_topurge > 0 then
2285: --
2286: --
2287: l_data_migrator_mode := hr_general.g_data_migrator_mode;
2288: hr_general.g_data_migrator_mode := 'Y';
2289: --
2290: clear_parties_from_hrms();
2291: --
2284: if l_have_rows_topurge > 0 then
2285: --
2286: --
2287: l_data_migrator_mode := hr_general.g_data_migrator_mode;
2288: hr_general.g_data_migrator_mode := 'Y';
2289: --
2290: clear_parties_from_hrms();
2291: --
2292: --
2289: --
2290: clear_parties_from_hrms();
2291: --
2292: --
2293: hr_general.g_data_migrator_mode := l_data_migrator_mode;
2294: --
2295: begin
2296: insert into hr_purge_parties_gt (PARTY_ID)
2297: select distinct party_id
6289: begin
6290:
6291: hr_utility.set_location('Entering '||l_proc,10);
6292:
6293: l_data_migrator_mode := hr_general.g_data_migrator_mode;
6294: hr_general.g_data_migrator_mode := 'Y';
6295:
6296: -- intialize the rows processed count
6297: p_rows_processed := 0;
6290:
6291: hr_utility.set_location('Entering '||l_proc,10);
6292:
6293: l_data_migrator_mode := hr_general.g_data_migrator_mode;
6294: hr_general.g_data_migrator_mode := 'Y';
6295:
6296: -- intialize the rows processed count
6297: p_rows_processed := 0;
6298:
6335: --
6336: commit;
6337:
6338: --
6339: hr_general.g_data_migrator_mode := l_data_migrator_mode;
6340: --
6341: hr_utility.set_location('Leaving '||l_proc,20);
6342: --
6343: end migrate_all_hr_email;