APPS.PER_HRTCA_MERGE dependencies on PER_PHONES

Line 92: from per_phones

88: l_addresses c_addresses%rowtype;
89: --
90: cursor c_phones is
91: select *
92: from per_phones
93: where parent_id = p_rec.person_id
94: and parent_table = 'PER_ALL_PEOPLE_F';
95: --
96: l_phones c_phones%rowtype;

Line 239: update per_phones

235: p_object_version_number => l_phones.object_version_number,
236: p_party_id => p_rec.party_id,
237: p_effective_date => p_rec.effective_start_date);
238: */
239: update per_phones
240: set party_id = p_rec.party_id
241: where phone_id = l_phones.phone_id;
242: --
243: end loop;

Line 1292: update PER_PHONES

1288: raise;
1289: end;
1290:
1291: begin
1292: update PER_PHONES
1293: set party_id = null
1294: where party_id = p_party_id;
1295: exception
1296: when no_data_found then

Line 1377: from per_phones phn,

1373: t_add_party_id g_party_id_type;
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: --

Line 1543: update per_phones

1539: exit;
1540: end if;
1541: --
1542: FORALL i in t_phn_party_id.FIRST..t_phn_party_id.LAST
1543: update per_phones
1544: set party_id = null
1545: where party_id = t_phn_party_id(i);
1546: --
1547: commit;

Line 1759: update PER_PHONES

1755: raise;
1756: end;
1757:
1758: begin
1759: update PER_PHONES
1760: set party_id = p_party_id
1761: -- There is no person_id column in per_phones table
1762: -- where person_id = p_person_id;
1763: where parent_id = p_person_id

Line 1761: -- There is no person_id column in per_phones table

1757:
1758: begin
1759: update PER_PHONES
1760: set party_id = p_party_id
1761: -- There is no person_id column in per_phones table
1762: -- where person_id = p_person_id;
1763: where parent_id = p_person_id
1764: and parent_table = 'PER_ALL_PEOPLE_F';
1765: exception

Line 6208: update per_phones

6204: --
6205: -- Bulk update phone records
6206: --
6207: forall i in t_elig_person_id.first..t_elig_person_id.last
6208: update per_phones
6209: set party_id = t_party_id(i)
6210: where parent_id = t_elig_person_id(i)
6211: and parent_table = 'PER_ALL_PEOPLE_F';
6212: --