APPS.PER_EQT_SHD dependencies on PER_QUALIFICATION_TYPES

Line 36: If (p_constraint_name = 'PER_QUALIFICATION_TYPES_PK') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_QUALIFICATION_TYPES_PK') Then
37: hr_utility.set_message(801, 'HR_51535_EQT_QUAL_TYPE_PK');
38: hr_utility.raise_error;
39: --
40: -- pmfletch. Now coded check in TL row handler

Line 42: -- ElsIf (p_constraint_name = 'PER_QUALIFICATION_TYPES_UK') Then

38: hr_utility.raise_error;
39: --
40: -- pmfletch. Now coded check in TL row handler
41: --
42: -- ElsIf (p_constraint_name = 'PER_QUALIFICATION_TYPES_UK') Then
43: -- hr_utility.set_message(801, 'HR_51536_EQT_NAME_UK');
44: -- hr_utility.raise_error;
45: Else
46: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 139: from per_qualification_types

135: ,field
136: ,sub_field
137: ,provider
138: ,qa_organization
139: from per_qualification_types
140: where qualification_type_id = p_qualification_type_id;
141: --
142: l_proc varchar2(72) := g_package||'api_updating';
143: l_fct_ret boolean;

Line 278: from per_qualification_types

274: ,field
275: ,sub_field
276: ,provider
277: ,qa_organization
278: from per_qualification_types
279: where qualification_type_id = p_qualification_type_id
280: for update nowait;
281: --
282: l_proc varchar2(72) := g_package||'lck';

Line 321: hr_utility.set_message_token('TABLE_NAME', 'per_qualification_types');

317: -- The object is locked therefore we need to supply a meaningful
318: -- error message.
319: --
320: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
321: hr_utility.set_message_token('TABLE_NAME', 'per_qualification_types');
322: hr_utility.raise_error;
323: End lck;
324: --
325: -- ----------------------------------------------------------------------------