40: 2. Added check to per_assignments
41: to check_references and call
42: this procedure from delete_row.
43:
44: 05-MAR-97 J.Alloun 70.10 Changed all occurances of system.dual
45: to sys.dual for next release requirements.
46:
47: 26-JAN-98 I.Harding 110.2 Added vacancy_category parameter to
48: insert, update and lock procs.
41: to check_references and call
42: this procedure from delete_row.
43:
44: 05-MAR-97 J.Alloun 70.10 Changed all occurances of system.dual
45: to sys.dual for next release requirements.
46:
47: 26-JAN-98 I.Harding 110.2 Added vacancy_category parameter to
48: insert, update and lock procs.
49:
856: WHERE vacancy_id = X_Vacancy_Id;
857:
858:
859: CURSOR C2 IS SELECT per_vacancies_s.nextval
860: FROM sys.dual;
861: BEGIN
862:
863: if (X_Vacancy_Id is NULL) then
864: OPEN C2;