APPS.PER_ADD_SHD dependencies on PER_ADDRESSES

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

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

Line 130: from per_addresses

126: add_information20,
127: object_version_number,
128: party_id, -- HR/TCA merge
129: geometry
130: from per_addresses
131: where address_id = p_address_id;
132: --
133: l_proc varchar2(72) := g_package||'api_updating';
134: l_fct_ret boolean;

Line 257: from per_addresses

253: add_information20,
254: object_version_number,
255: party_id, -- HR/TCA merge
256: geometry
257: from per_addresses
258: where address_id = p_address_id
259: for update nowait;
260: --
261: l_proc varchar2(72) := g_package||'lck';

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

299: -- The object is locked therefore we need to supply a meaningful
300: -- error message.
301: --
302: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
303: hr_utility.set_message_token('TABLE_NAME', 'per_addresses');
304: hr_utility.raise_error;
305: End lck;
306: --
307: -- ----------------------------------------------------------------------------