303: -- --------------------------------------------------------------------------
304: -- declare local variables
305: -- --------------------------------------------------------------------------
306: l_proc constant varchar2(100) := g_package || ' get_transaction_id';
307: l_transaction_id hr_api_transactions.transaction_id%type;
308: -- cursor to select the transaction_id of the step
309: cursor csr_hats is
310: select hats.transaction_id
311: from hr_api_transaction_steps hats
345: -- --------------------------------------------------------------------------
346: -- declare local variables
347: -- --------------------------------------------------------------------------
348: l_proc constant varchar2(100) := g_package || 'check_transaction_privilege';
349: l_creator_person_id hr_api_transactions.creator_person_id%type;
350: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
351: -- cursor to select the privilege
352: cursor csr_hat is
353: select hat.creator_person_id
346: -- declare local variables
347: -- --------------------------------------------------------------------------
348: l_proc constant varchar2(100) := g_package || 'check_transaction_privilege';
349: l_creator_person_id hr_api_transactions.creator_person_id%type;
350: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
351: -- cursor to select the privilege
352: cursor csr_hat is
353: select hat.creator_person_id
354: ,hat.transaction_privilege
351: -- cursor to select the privilege
352: cursor csr_hat is
353: select hat.creator_person_id
354: ,hat.transaction_privilege
355: from hr_api_transactions hat
356: where hat.transaction_id = p_transaction_id;
357:
358: begin
359: