APPS.PER_HRTCA_MERGE dependencies on HR_PURGE_PARTIES_GT

Line 1821: delete from hr_purge_parties_gt;

1817: is
1818: l_proc varchar2(100) := g_package||'.clear_purge_parties_temp';
1819: begin
1820: hr_utility.set_location('Entering :'||l_proc,10);
1821: delete from hr_purge_parties_gt;
1822: hr_utility.set_location('Leaving :'||l_proc,20);
1823: end;
1824:
1825: --

Line 1841: insert into hr_purge_parties_gt (party_id) values (p_party_id);

1837: begin
1838: hr_utility.set_location('Entering : '||l_proc,10);
1839:
1840: begin
1841: insert into hr_purge_parties_gt (party_id) values (p_party_id);
1842: exception
1843: when others then
1844: raise;
1845: end;

Line 1873: from hr_purge_parties_gt)';

1869: l_errbuf varchar2(1000);
1870: l_retcode varchar2(250);
1871: l_batchid number;
1872: l_subset_sql varchar2(1000) := 'party_id in (select party_id
1873: from hr_purge_parties_gt)';
1874:
1875: cursor csr_get_purge_parties is
1876: select party_id
1877: from hr_purge_parties_gt;

Line 1877: from hr_purge_parties_gt;

1873: from hr_purge_parties_gt)';
1874:
1875: cursor csr_get_purge_parties is
1876: select party_id
1877: from hr_purge_parties_gt;
1878:
1879: l_return_status varchar2(100);
1880: l_msg_count number;
1881: l_msg_data varchar2(1000);

Line 2215: insert into hr_purge_parties_gt (PARTY_ID)

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
2217: from hr_tca_party_unmerge
2218: where status = 'PURGE';
2219: end;

Line 2296: insert into hr_purge_parties_gt (PARTY_ID)

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
2298: from hr_tca_party_unmerge
2299: where status = 'PURGE';
2300: end;