APPS.PER_HRTCA_MERGE dependencies on PER_QUALIFICATIONS

Line 100: from per_qualifications

96: l_phones c_phones%rowtype;
97: --
98: cursor c_qualifications is
99: select *
100: from per_qualifications
101: where person_id = p_rec.person_id;
102: --
103: l_qualifications c_qualifications%rowtype;
104: --

Line 112: from per_qualifications qua,

108: where person_id = p_rec.person_id;
109: --
110: cursor c_qualifications_estab is
111: select qua.*
112: from per_qualifications qua,
113: per_establishment_attendances esa
114: where esa.attendance_id = qua.attendance_id
115: and esa.person_id = p_rec.person_id;
116: --

Line 259: update per_qualifications

255: exit when c_qualifications%notfound;
256: --
257: -- No API at the moment so use base table.
258: --
259: update per_qualifications
260: set party_id = p_rec.party_id
261: where qualification_id = l_qualifications.qualification_id;
262: --
263: end loop;

Line 276: update per_qualifications

272: exit when c_qualifications_estab%notfound;
273: --
274: -- No API at the moment so use base table.
275: --
276: update per_qualifications
277: set party_id = p_rec.party_id
278: where qualification_id = l_qualifications.qualification_id;
279: --
280: end loop;

Line 1317: update PER_QUALIFICATIONS

1313: raise;
1314: end;
1315:
1316: begin
1317: update PER_QUALIFICATIONS
1318: set party_id = null
1319: where party_id = p_party_id;
1320: exception
1321: when no_data_found then

Line 1389: from per_qualifications qua,

1385: t_phn_party_id g_party_id_type;
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: --

Line 1572: update per_qualifications

1568: exit;
1569: end if;
1570: --
1571: forall i in t_qua_party_id.first..t_qua_party_id.last
1572: update per_qualifications
1573: set party_id = null
1574: where party_id = t_qua_party_id(i);
1575: --
1576: commit;

Line 1787: update PER_QUALIFICATIONS

1783: raise;
1784: end;
1785:
1786: begin
1787: update PER_QUALIFICATIONS
1788: set party_id = p_party_id
1789: where person_id = p_person_id;
1790: exception
1791: when no_data_found then

Line 6236: update per_qualifications

6232: --
6233: -- Bulk update qualification records
6234: --
6235: forall i in t_elig_person_id.first..t_elig_person_id.last
6236: update per_qualifications
6237: set party_id = t_party_id(i)
6238: where person_id = t_elig_person_id(i);
6239: --
6240: -- Bulk update etablishment attendances records