APPS.PER_KAD_SHD dependencies on PER_ADDRESSES

Line 38: If (p_constraint_name = 'PER_ADDRESSES_PK') Then

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: -- 70.2 change d start.
37: --
38: If (p_constraint_name = 'PER_ADDRESSES_PK') Then
39: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_ADDR_PRIMARY_FLAG_CHK') Then
42: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');

Line 117: from per_addresses

113: addr_attribute18,
114: addr_attribute19,
115: addr_attribute20,
116: object_version_number
117: from per_addresses
118: where address_id = p_address_id;
119: --
120: l_proc varchar2(72) := g_package||'api_updating';
121: l_fct_ret boolean;

Line 233: from per_addresses

229: addr_attribute18,
230: addr_attribute19,
231: addr_attribute20,
232: object_version_number
233: from per_addresses
234: where address_id = p_address_id
235: for update nowait;
236: --
237: l_proc varchar2(72) := g_package||'lck';

Line 279: hr_utility.set_message_token('TABLE_NAME', 'per_addresses');

275: -- The object is locked therefore we need to supply a meaningful
276: -- error message.
277: --
278: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
279: hr_utility.set_message_token('TABLE_NAME', 'per_addresses');
280: hr_utility.raise_error;
281: End lck;
282: --
283: -- ----------------------------------------------------------------------------