79: purpose_usage_id,
80: start_date,
81: end_date,
82: object_version_number
83: from hr_calendar_usages
84: where calendar_usage_id = p_calendar_usage_id;
85: --
86: l_proc varchar2(72) := g_package||'api_updating';
87: l_fct_ret boolean;
155: purpose_usage_id,
156: start_date,
157: end_date,
158: object_version_number
159: from hr_calendar_usages
160: where calendar_usage_id = p_calendar_usage_id
161: for update nowait;
162: --
163: l_proc varchar2(72) := g_package||'lck';
198: -- The object is locked therefore we need to supply a meaningful
199: -- error message.
200: --
201: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
202: hr_utility.set_message_token('TABLE_NAME', 'hr_calendar_usages');
203: hr_utility.raise_error;
204: End lck;
205: --
206: -- ----------------------------------------------------------------------------