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.PER_HRTCA_MERGE dependencies on HR_TCA_PARTY_UNMERGE

Line 1354: hr_tca_party_unmerge punm

1350: --
1351: cursor c_competences is
1352: select pce.party_id
1353: from per_competence_elements pce,
1354: hr_tca_party_unmerge punm
1355: where pce.party_id = punm.party_id
1356: and punm.status = 'PURGE';
1357: --
1358: t_pce_party_id g_party_id_type;

Line 1363: hr_tca_party_unmerge punm

1359: --
1360: cursor c_events is
1361: select eve.party_id
1362: from per_events eve,
1363: hr_tca_party_unmerge punm
1364: where eve.party_id = punm.party_id
1365: and punm.status = 'PURGE';
1366: --
1367: t_eve_party_id g_party_id_type;

Line 1372: hr_tca_party_unmerge punm

1368: --
1369: cursor c_addresses is
1370: select addr.party_id
1371: from per_addresses addr,
1372: hr_tca_party_unmerge punm
1373: where addr.party_id = punm.party_id
1374: and punm.status = 'PURGE';
1375: --
1376: t_add_party_id g_party_id_type;

Line 1381: hr_tca_party_unmerge punm

1377: --
1378: cursor c_phones is
1379: select phn.party_id
1380: from per_phones phn,
1381: hr_tca_party_unmerge punm
1382: where phn.party_id = punm.party_id
1383: and punm.status = 'PURGE';
1384: --
1385: t_phn_party_id g_party_id_type;

Line 1390: hr_tca_party_unmerge punm

1386: --
1387: cursor c_qualifications is
1388: select qua.party_id
1389: from per_qualifications qua,
1390: hr_tca_party_unmerge punm
1391: where qua.party_id = punm.party_id
1392: and punm.status = 'PURGE';
1393: --
1394: t_qua_party_id g_party_id_type;

Line 1399: hr_tca_party_unmerge punm

1395: --
1396: cursor c_establishment_attendances is
1397: select esta.party_id
1398: from per_establishment_attendances esta,
1399: hr_tca_party_unmerge punm
1400: where esta.party_id = punm.party_id
1401: and punm.status = 'PURGE';
1402: --
1403: t_esta_party_id g_party_id_type;

Line 1408: hr_tca_party_unmerge punm

1404: --
1405: cursor c_prev_employers is
1406: select pemp.party_id
1407: from per_previous_employers pemp,
1408: hr_tca_party_unmerge punm
1409: where pemp.party_id = punm.party_id
1410: and punm.status = 'PURGE';
1411: --
1412: t_pemp_party_id g_party_id_type;

Line 1417: hr_tca_party_unmerge punm

1413: --
1414: cursor c_people is
1415: select papf.party_id
1416: from per_all_people_f papf,
1417: hr_tca_party_unmerge punm
1418: where papf.party_id = punm.party_id
1419: and punm.status = 'PURGE';
1420: --
1421: t_papf_party_id g_party_id_type;

Line 1989: from hr_tca_party_unmerge ptyun

1985: where p.rowid
1986: between p_start_rowid and p_end_rowid
1987: and p.party_id is not null
1988: and not exists (select null
1989: from hr_tca_party_unmerge ptyun
1990: where ptyun.party_id = p.party_id);
1991: --
1992: l_effective_date date := hr_api.g_eot;
1993: l_return_value varchar2(30);

Line 2102: -- bulk insert into hr_tca_party_unmerge added new

2098: -- End of code shifted from a procedure
2099: --
2100: end loop;
2101: --
2102: -- bulk insert into hr_tca_party_unmerge added new
2103: --
2104: IF t_party_id_notto_purge.COUNT > 0 THEN
2105: FORALL i IN t_party_id_notto_purge.FIRST..t_party_id_notto_purge.LAST
2106: INSERT INTO hr_tca_party_unmerge (party_id,status) VALUES (t_party_id_notto_purge(i),'NOPURGE');

Line 2106: INSERT INTO hr_tca_party_unmerge (party_id,status) VALUES (t_party_id_notto_purge(i),'NOPURGE');

2102: -- bulk insert into hr_tca_party_unmerge added new
2103: --
2104: IF t_party_id_notto_purge.COUNT > 0 THEN
2105: FORALL i IN t_party_id_notto_purge.FIRST..t_party_id_notto_purge.LAST
2106: INSERT INTO hr_tca_party_unmerge (party_id,status) VALUES (t_party_id_notto_purge(i),'NOPURGE');
2107: --
2108: t_party_id_notto_purge.delete;
2109: --
2110: END IF;

Line 2114: -- bulk insert into hr_tca_party_unmerge

2110: END IF;
2111:
2112: -- do we have any parties to purge?
2113: IF t_party_id_to_purge.COUNT > 0 THEN
2114: -- bulk insert into hr_tca_party_unmerge
2115: FORALL i IN t_party_id_to_purge.FIRST..t_party_id_to_purge.LAST
2116: INSERT INTO hr_tca_party_unmerge (party_id,status) VALUES (t_party_id_to_purge(i),'PURGE');
2117: --
2118: t_party_id_to_purge.delete;

Line 2116: INSERT INTO hr_tca_party_unmerge (party_id,status) VALUES (t_party_id_to_purge(i),'PURGE');

2112: -- do we have any parties to purge?
2113: IF t_party_id_to_purge.COUNT > 0 THEN
2114: -- bulk insert into hr_tca_party_unmerge
2115: FORALL i IN t_party_id_to_purge.FIRST..t_party_id_to_purge.LAST
2116: INSERT INTO hr_tca_party_unmerge (party_id,status) VALUES (t_party_id_to_purge(i),'PURGE');
2117: --
2118: t_party_id_to_purge.delete;
2119: --
2120: /*

Line 2154: from hr_tca_party_unmerge

2150: l_have_rows_topurge number := 0;
2151: --
2152: cursor chk_rows_exist is
2153: select count(party_id)
2154: from hr_tca_party_unmerge
2155: where status = 'PURGE';
2156: --
2157: l_start_rowid rowid;
2158: l_end_rowid rowid;

Line 2220: from hr_tca_party_unmerge

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;
2223:
2224: /*

Line 2241: update hr_tca_party_unmerge

2237: FND_FILE.put_line(fnd_file.log,'End TCA process to identify/purge in HR tables');
2238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'End TCA process to identify/purge in HR tables');
2239: --
2240: begin
2241: update hr_tca_party_unmerge
2242: set status = 'PURGE COMPLETED'
2243: where status = 'PURGE';
2244: end;
2245: --

Line 2273: from hr_tca_party_unmerge

2269: l_have_rows_topurge number :=0;
2270: --
2271: cursor chk_rows_exist is
2272: select count(party_id)
2273: from hr_tca_party_unmerge
2274: where status = 'PURGE';
2275: --
2276: l_data_migrator_mode varchar2(30);
2277: --

Line 2301: from hr_tca_party_unmerge

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;
2304:
2305: /*

Line 2322: update hr_tca_party_unmerge

2318: FND_FILE.put_line(fnd_file.log,'End TCA process to identify/purge in HR tables');
2319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'End TCA process to identify/purge in HR tables');
2320: --
2321: begin
2322: update hr_tca_party_unmerge
2323: set status = 'PURGE COMPLETED'
2324: where status = 'PURGE';
2325: end;
2326: --

Line 2510: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE

2506: --
2507: -- Bug fix 4005740 starts here--
2508:
2509: -- Call to purge_parties is commented to improve performance.
2510: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE
2511: -- so that party id will be purged when the user run the
2512: -- party unmerge program next time.
2513:
2514: INSERT INTO hr_tca_party_unmerge (party_id,status)

Line 2514: INSERT INTO hr_tca_party_unmerge (party_id,status)

2510: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE
2511: -- so that party id will be purged when the user run the
2512: -- party unmerge program next time.
2513:
2514: INSERT INTO hr_tca_party_unmerge (party_id,status)
2515: VALUES (p_rec.party_id,'PURGE');
2516: /*
2517: --
2518: -- If we are at the appropropriate maintenance pack(11.5.6 or later)

Line 6376: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE

6372:
6373: hr_utility.set_location('purge_person ', 12);
6374: --fix for bug 6620368 starts here.
6375: -- Call to purge_parties is commented to improve performance.
6376: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE
6377: -- so that party id will be purged when the user run the
6378: -- party unmerge program next time.
6379:
6380: INSERT INTO hr_tca_party_unmerge (party_id,status)

Line 6380: INSERT INTO hr_tca_party_unmerge (party_id,status)

6376: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE
6377: -- so that party id will be purged when the user run the
6378: -- party unmerge program next time.
6379:
6380: INSERT INTO hr_tca_party_unmerge (party_id,status)
6381: VALUES (p_party_id,'PURGE');
6382:
6383:
6384: /* hr_utility.set_location('before calling add_party_for_purge ', 12);