APPS.PER_ASR_SHD dependencies on PER_ASSESSMENT_GROUPS

Line 21: If (p_constraint_name = 'PER_ASSESSMENT_GROUPS_PK') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_ASSESSMENT_GROUPS_PK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;

Line 26: ElsIf (p_constraint_name = 'PER_ASSESSMENT_GROUPS_NAME_UK1') Then

22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PER_ASSESSMENT_GROUPS_NAME_UK1') Then
27: hr_utility.set_message(801, 'HR_51594_ASR_NAME_NOT_UNIQ');
28: hr_utility.raise_error;
29: Else
30: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 80: from per_assessment_groups

76: attribute18,
77: attribute19,
78: attribute20,
79: object_version_number
80: from per_assessment_groups
81: where assessment_group_id = p_assessment_group_id;
82: --
83: l_proc varchar2(72) := g_package||'api_updating';
84: l_fct_ret boolean;

Line 176: from per_assessment_groups

172: attribute18,
173: attribute19,
174: attribute20,
175: object_version_number
176: from per_assessment_groups
177: where assessment_group_id = p_assessment_group_id
178: for update nowait;
179: --
180: l_proc varchar2(72) := g_package||'lck';

Line 219: hr_utility.set_message_token('TABLE_NAME', 'per_assessment_groups');

215: -- The object is locked therefore we need to supply a meaningful
216: -- error message.
217: --
218: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
219: hr_utility.set_message_token('TABLE_NAME', 'per_assessment_groups');
220: hr_utility.raise_error;
221: End lck;
222: --
223: -- ----------------------------------------------------------------------------