APPS.PER_ZA_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: ElsIf (p_constraint_name = 'PER_QUALIFICATION_TYPES_UK') Then
40: hr_utility.set_message(801, 'HR_51536_EQT_NAME_UK');

Line 39: ElsIf (p_constraint_name = 'PER_QUALIFICATION_TYPES_UK') Then

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: ElsIf (p_constraint_name = 'PER_QUALIFICATION_TYPES_UK') Then
40: hr_utility.set_message(801, 'HR_51536_EQT_NAME_UK');
41: hr_utility.raise_error;
42: Else
43: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 93: from per_qualification_types a,

89: a.attribute18,
90: a.attribute19,
91: a.attribute20,
92: a.object_version_number
93: from per_qualification_types a,
94: per_za_qualification_types b
95: where a.qualification_type_id = p_qualification_type_id and
96: a.qualification_type_id = b.qualification_type_id(+);
97: --

Line 192: from per_qualification_types a,

188: a.attribute18,
189: a.attribute19,
190: a.attribute20,
191: a.object_version_number
192: from per_qualification_types a,
193: per_za_qualification_types b
194: where a.qualification_type_id = p_qualification_type_id and
195: a.qualification_type_id = b.qualification_type_id(+)
196: for update nowait;

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

233: -- The object is locked therefore we need to supply a meaningful
234: -- error message.
235: --
236: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
237: hr_utility.set_message_token('TABLE_NAME', 'per_qualification_types');
238: hr_utility.raise_error;
239: End lck;
240: --
241: -- ----------------------------------------------------------------------------