APPS.PER_PSS_SHD dependencies on PER_SALARY_SURVEYS

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

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_SALARY_SURVEYS_PK') Then
22: hr_utility.set_message(800, 'THE 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_SALARY_SURVEYS_UK1') Then

22: hr_utility.set_message(800, 'THE 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_SALARY_SURVEYS_UK1') Then
27: hr_utility.set_message(800, 'PER_50330_INV_SURVEY_COMB');
28: hr_utility.raise_error;
29: Else
30: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

Line 82: from per_salary_surveys

78: attribute17,
79: attribute18,
80: attribute19,
81: attribute20
82: from per_salary_surveys
83: where salary_survey_id = p_salary_survey_id;
84: --
85: l_proc varchar2(72) := g_package||'api_updating';
86: l_fct_ret boolean;

Line 180: from per_salary_surveys

176: attribute17,
177: attribute18,
178: attribute19,
179: attribute20
180: from per_salary_surveys
181: where salary_survey_id = p_salary_survey_id
182: for update nowait;
183: --
184: l_proc varchar2(72) := g_package||'lck';

Line 223: hr_utility.set_message_token('TABLE_NAME', 'per_salary_surveys');

219: -- The object is locked therefore we need to supply a meaningful
220: -- error message.
221: --
222: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
223: hr_utility.set_message_token('TABLE_NAME', 'per_salary_surveys');
224: hr_utility.raise_error;
225: End lck;
226: --
227: -- ----------------------------------------------------------------------------