19: 29-Jan-95 D.Kerr 70.5 Removed WHO-columns for Set8 Changes.
20: 29-Jan-95 D.Kerr 70.6 Added uniqueness checks to prevent
21: duplicate vacancies for a recruitment
22: activity G1351
23: 05-Mar-97 J.Alloun 70.7 Changed all occurances of system.dual
24: to sys.dual for next release requirements.
25: =============================================================================*/
26: -----------------------------------------------------------------------------
27: -- Name --
20: 29-Jan-95 D.Kerr 70.6 Added uniqueness checks to prevent
21: duplicate vacancies for a recruitment
22: activity G1351
23: 05-Mar-97 J.Alloun 70.7 Changed all occurances of system.dual
24: to sys.dual for next release requirements.
25: =============================================================================*/
26: -----------------------------------------------------------------------------
27: -- Name --
28: -- chk_vacancy_unique
118:
119:
120: CURSOR C2 IS
121: SELECT per_recruitment_activity_for_s.nextval
122: FROM sys.dual;
123:
124: BEGIN
125: --
126: -- Check that the vacancy id has not already been used for this