67: template_id,
68: transaction_id,
69: transaction_category_id,
70: object_version_number
71: from pqh_transaction_templates
72: where transaction_template_id = p_transaction_template_id;
73: --
74: l_proc varchar2(72) := g_package||'api_updating';
75: l_fct_ret boolean;
142: template_id,
143: transaction_id,
144: transaction_category_id,
145: object_version_number
146: from pqh_transaction_templates
147: where transaction_template_id = p_transaction_template_id
148: for update nowait;
149: --
150: l_proc varchar2(72) := g_package||'lck';
185: -- The object is locked therefore we need to supply a meaningful
186: -- error message.
187: --
188: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
189: hr_utility.set_message_token('TABLE_NAME', 'pqh_transaction_templates');
190: hr_utility.raise_error;
191: End lck;
192: --
193: -- ----------------------------------------------------------------------------