APPS.PER_HRTCA_MERGE dependencies on PER_COMPETENCE_ELEMENTS

Line 66: from per_competence_elements

62: l_proc varchar2(80) := g_package||'update_child_tables';
63: --
64: cursor c_competences is
65: select *
66: from per_competence_elements
67: where person_id = p_rec.person_id;
68: --
69: l_competences c_competences%rowtype;
70: --

Line 153: update per_competence_elements

149: --
150: fetch c_competences into l_competences;
151: exit when c_competences%notfound;
152: --
153: update per_competence_elements
154: set party_id = p_rec.party_id
155: where competence_element_id = l_competences.competence_element_id;
156: --
157: /*

Line 1259: update PER_COMPETENCE_ELEMENTS

1255: raise;
1256: end;
1257:
1258: begin
1259: update PER_COMPETENCE_ELEMENTS
1260: set party_id = null
1261: where party_id = p_party_id;
1262: exception
1263: when no_data_found then

Line 1350: from per_competence_elements pce,

1346: l_data_migrator_mode varchar2(30);
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: --

Line 1463: update per_competence_elements

1459: exit;
1460: end if;
1461: --
1462: FORALL i in t_pce_party_id.FIRST..t_pce_party_id.LAST
1463: update per_competence_elements
1464: set party_id = null
1465: where party_id = t_pce_party_id(i);
1466: --
1467: commit;

Line 1708: update PER_COMPETENCE_ELEMENTS

1704: raise;
1705: end;
1706:
1707: begin
1708: update PER_COMPETENCE_ELEMENTS
1709: set party_id = p_party_id
1710: where person_id = p_person_id;
1711: exception
1712: when no_data_found then

Line 6184: update per_competence_elements

6180: --
6181: -- Bulk update competence records
6182: --
6183: forall i in t_elig_person_id.first..t_elig_person_id.last
6184: update per_competence_elements
6185: set party_id = t_party_id(i)
6186: where person_id = t_elig_person_id(i);
6187: --
6188: -- Bulk update events records