APPS.PER_CTR_SHD dependencies on PER_CONTACT_RELATIONSHIPS

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

35: --
36: If (p_constraint_name = 'P.ER_CONTACT_RELATIONSHIPS_FK1') Then
37: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
38: hr_utility.raise_error;
39: ElsIf (p_constraint_name = 'PER_CONTACT_RELATIONSHIPS_PK') Then
40: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_CONT_BONDHOLDER_FLAG_CHK') Then
43: hr_utility.set_message(801, 'HR_51386_CTR_INV_BONDHLD_FLAG');

Line 150: from per_contact_relationships

146: dependent_flag,
147: beneficiary_flag,
148: object_version_number
149: --
150: from per_contact_relationships
151: where contact_relationship_id = p_contact_relationship_id;
152: --
153: l_proc varchar2(72) := g_package||'api_updating';
154: l_fct_ret boolean;

Line 285: from per_contact_relationships

281: dependent_flag,
282: beneficiary_flag,
283: object_version_number
284:
285: from per_contact_relationships
286: where contact_relationship_id = p_contact_relationship_id
287: for update nowait;
288: --
289: l_proc varchar2(72) := g_package||'lck';

Line 328: hr_utility.set_message_token('TABLE_NAME', 'per_contact_relationships');

324: -- The object is locked therefore we need to supply a meaningful
325: -- error message.
326: --
327: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
328: hr_utility.set_message_token('TABLE_NAME', 'per_contact_relationships');
329: hr_utility.raise_error;
330: End lck;
331: --
332: -- ----------------------------------------------------------------------------