APPS.GHR_PDI_SHD dependencies on GHR_POSITION_DESCRIPTIONS

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

36: --
37: Begin
38: hr_utility.set_location('Entering:'||l_proc, 5);
39: --
40: If (p_constraint_name = 'GHR_POSITION_DESCRIPTIONS_PK') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','5');
44: hr_utility.raise_error;

Line 45: ElsIf (p_constraint_name = 'GHR_POSITION_DESCRIPTIONS_FK1') Then

41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','5');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'GHR_POSITION_DESCRIPTIONS_FK1') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','5');
49: hr_utility.raise_error;

Line 122: from ghr_position_descriptions

118: attribute19,
119: attribute20,
120: business_group_id,
121: object_version_number
122: from ghr_position_descriptions
123: where position_description_id = p_position_description_id;
124: --
125: l_proc varchar2(72) := g_package||'api_updating';
126: l_fct_ret boolean;

Line 239: from ghr_position_descriptions

235: attribute19,
236: attribute20,
237: business_group_id,
238: object_version_number
239: from ghr_position_descriptions
240: where position_description_id = p_position_description_id
241: for update nowait;
242: --
243: l_proc varchar2(72) := g_package||'lck';

Line 282: hr_utility.set_message_token('TABLE_NAME', 'ghr_position_descriptions');

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