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 1351: hr_tca_party_unmerge punm

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

Line 1360: hr_tca_party_unmerge punm

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

Line 1369: hr_tca_party_unmerge punm

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

Line 1378: hr_tca_party_unmerge punm

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

Line 1387: hr_tca_party_unmerge punm

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

Line 1396: hr_tca_party_unmerge punm

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

Line 1405: hr_tca_party_unmerge punm

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

Line 1414: hr_tca_party_unmerge punm

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

Line 1986: from hr_tca_party_unmerge ptyun

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

Line 2099: -- bulk insert into hr_tca_party_unmerge added new

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

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

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

Line 2111: -- bulk insert into hr_tca_party_unmerge

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

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

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

Line 2151: from hr_tca_party_unmerge

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

Line 2217: from hr_tca_party_unmerge

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;
2220:
2221: /*

Line 2238: update hr_tca_party_unmerge

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

Line 2270: from hr_tca_party_unmerge

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

Line 2298: from hr_tca_party_unmerge

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;
2301:
2302: /*

Line 2319: update hr_tca_party_unmerge

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

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

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

Line 2511: INSERT INTO hr_tca_party_unmerge (party_id,status)

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

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

6352:
6353: hr_utility.set_location('purge_person ', 12);
6354: --fix for bug 6620368 starts here.
6355: -- Call to purge_parties is commented to improve performance.
6356: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE
6357: -- so that party id will be purged when the user run the
6358: -- party unmerge program next time.
6359:
6360: INSERT INTO hr_tca_party_unmerge (party_id,status)

Line 6360: INSERT INTO hr_tca_party_unmerge (party_id,status)

6356: -- Party id is inserted into table HR_TCA_PARTY_UNMERGE
6357: -- so that party id will be purged when the user run the
6358: -- party unmerge program next time.
6359:
6360: INSERT INTO hr_tca_party_unmerge (party_id,status)
6361: VALUES (p_party_id,'PURGE');
6362:
6363:
6364: /* hr_utility.set_location('before calling add_party_for_purge ', 12);