APPS.PER_QUA_SHD dependencies on PER_QUALIFICATIONS

Line 35: If (p_constraint_name = 'PER_QUALIFICATIONS_FK1') Then

31: --
32: Begin
33: hr_utility.set_location('Entering:'||l_proc, 5);
34: --
35: If (p_constraint_name = 'PER_QUALIFICATIONS_FK1') Then
36: hr_utility.set_message(801, 'HR_51850_QUA_ATT_ID_FK');
37: hr_utility.raise_error;
38: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_FK2') Then
39: hr_utility.set_message(801, 'HR_51851_QUA_QUAL_TYPE_ID_FK');

Line 38: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_FK2') Then

34: --
35: If (p_constraint_name = 'PER_QUALIFICATIONS_FK1') Then
36: hr_utility.set_message(801, 'HR_51850_QUA_ATT_ID_FK');
37: hr_utility.raise_error;
38: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_FK2') Then
39: hr_utility.set_message(801, 'HR_51851_QUA_QUAL_TYPE_ID_FK');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_FK3') Then
42: hr_utility.set_message(801, 'HR_51852_QUA_BUS_GRP_ID_FK');

Line 41: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_FK3') Then

37: hr_utility.raise_error;
38: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_FK2') Then
39: hr_utility.set_message(801, 'HR_51851_QUA_QUAL_TYPE_ID_FK');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_FK3') Then
42: hr_utility.set_message(801, 'HR_51852_QUA_BUS_GRP_ID_FK');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_QUA_CHK_DATES') Then
45: hr_utility.set_message(801, 'HR_51853_QUA_DATE_INV');

Line 47: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_PK') Then

43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_QUA_CHK_DATES') Then
45: hr_utility.set_message(801, 'HR_51853_QUA_DATE_INV');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_QUALIFICATIONS_PK') Then
48: hr_utility.set_message(801, 'HR_51854_QUA_QUAL_ID_PK');
49: hr_utility.raise_error;
50: Else
51: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 147: from per_qualifications

143: membership_number,
144: membership_category,
145: subscription_payment_method,
146: party_id
147: from per_qualifications
148: where qualification_id = p_qualification_id;
149: --
150: l_proc varchar2(72) := g_package||'api_updating';
151: l_fct_ret boolean;

Line 289: from per_qualifications

285: membership_number,
286: membership_category,
287: subscription_payment_method,
288: party_id
289: from per_qualifications
290: where qualification_id = p_qualification_id
291: for update nowait;
292: --
293: l_proc varchar2(72) := g_package||'lck';

Line 332: hr_utility.set_message_token('TABLE_NAME', 'per_qualifications');

328: -- The object is locked therefore we need to supply a meaningful
329: -- error message.
330: --
331: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
332: hr_utility.set_message_token('TABLE_NAME', 'per_qualifications');
333: hr_utility.raise_error;
334: End lck;
335: --
336: -- ----------------------------------------------------------------------------