32: not l_api_updating then
33: --
34: -- raise error as PK not null
35: --
36: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
37: --
38: end if;
39: --
40: -- check if qualification_type_id has been updated
44: and l_api_updating then
45: --
46: -- raise error as update is not allowed
47: --
48: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_PK');
49: --
50: end if;
51: --
52: end if;
67: l_dummy varchar2(1);
68: --
69: cursor c1 is
70: select null
71: from per_qualification_types per
72: where per.name = p_name;
73: --
74: Begin
75: hr_utility.set_location('Entering:'||l_proc, 5);
85: if p_name is null then
86: --
87: -- raise error
88: --
89: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');
90: --
91: end if;
92: --
93: -- check if the qualification name exists in the per_qualification_types
89: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');
90: --
91: end if;
92: --
93: -- check if the qualification name exists in the per_qualification_types
94: -- table.
95: --
96: if p_name <> per_za_eqt_shd.g_old_rec.name then
97: --
105: --
106: -- raise error
107: --
108: close c1;
109: per_za_eqt_shd.constraint_error('PER_QUALIFICATION_TYPES_UK');
110: --
111: end if;
112: --
113: close c1;