APPS.PER_SHA_SHD dependencies on PER_STD_HOLIDAY_ABSENCES

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

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_STD_HOLIDAY_ABSENCES_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 79: from per_std_holiday_absences

75: attribute18,
76: attribute19,
77: attribute20,
78: object_version_number
79: from per_std_holiday_absences
80: where std_holiday_absences_id = p_std_holiday_absences_id;
81: --
82: l_proc varchar2(72) := g_package||'api_updating';
83: l_fct_ret boolean;

Line 177: from per_std_holiday_absences

173: attribute18,
174: attribute19,
175: attribute20,
176: object_version_number
177: from per_std_holiday_absences
178: where std_holiday_absences_id = p_std_holiday_absences_id
179: for update nowait;
180: --
181: l_proc varchar2(72) := g_package||'lck';

Line 220: hr_utility.set_message_token('TABLE_NAME', 'per_std_holiday_absences');

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