77: archive_item_id,
78: sequence_no,
79: context,
80: context_id
81: from ff_archive_item_contexts
82: where archive_item_id = p_archive_item_id
83: and context_id = p_context_id;
84: --
85: l_proc varchar2(72) := g_package||'api_updating';
148: select archive_item_id,
149: sequence_no,
150: context,
151: context_id
152: from ff_archive_item_contexts
153: where archive_item_id = p_archive_item_id
154: and context_id = p_context_id
155: for update nowait;
156: --
189: -- The object is locked therefore we need to supply a meaningful
190: -- error message.
191: --
192: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
193: hr_utility.set_message_token('TABLE_NAME', 'ff_archive_item_contexts');
194: hr_utility.raise_error;
195: End lck;
196: --
197: -- ----------------------------------------------------------------------------