APPS.PER_HRTCA_MERGE dependencies on HR_PURGE_PARTIES_GT

Line 1824: delete from hr_purge_parties_gt;

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

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

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

Line 1876: from hr_purge_parties_gt)';

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

Line 1880: from hr_purge_parties_gt;

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

Line 2218: insert into hr_purge_parties_gt (PARTY_ID)

2214: --
2215: hr_general.g_data_migrator_mode := l_data_migrator_mode;
2216: --
2217: begin
2218: insert into hr_purge_parties_gt (PARTY_ID)
2219: select distinct party_id
2220: from hr_tca_party_unmerge
2221: where status = 'PURGE';
2222: end;

Line 2299: insert into hr_purge_parties_gt (PARTY_ID)

2295: --
2296: hr_general.g_data_migrator_mode := l_data_migrator_mode;
2297: --
2298: begin
2299: insert into hr_purge_parties_gt (PARTY_ID)
2300: select distinct party_id
2301: from hr_tca_party_unmerge
2302: where status = 'PURGE';
2303: end;