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 1314: update PER_QUALIFICATIONS

1310: raise;
1311: end;
1312:
1313: begin
1314: update PER_QUALIFICATIONS
1315: set party_id = null
1316: where party_id = p_party_id;
1317: exception
1318: when no_data_found then

Line 1386: from per_qualifications qua,

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

Line 1569: update per_qualifications

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

Line 1784: update PER_QUALIFICATIONS

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

Line 6216: update per_qualifications

6212: --
6213: -- Bulk update qualification records
6214: --
6215: forall i in t_elig_person_id.first..t_elig_person_id.last
6216: update per_qualifications
6217: set party_id = t_party_id(i)
6218: where person_id = t_elig_person_id(i);
6219: --
6220: -- Bulk update etablishment attendances records