DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SWI dependencies on HR_API_TRANSACTION_STEPS

Line 186: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

182: is
183: l_proc varchar2(72) := g_package || 'create_transaction_step';
184: l_result varchar2(100);
185: l_trns_object_version_number number;
186: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
187: PRAGMA AUTONOMOUS_TRANSACTION;
188: begin
189: --savepoint create_transaction_step;
190: l_transaction_step_id := P_TRANSACTION_STEP_ID;

Line 653: from hr_api_transaction_steps

649: return VARCHAR2 IS
650:
651: cursor csr_hat_steps(p_Api_Name in varchar2) is
652: select *
653: from hr_api_transaction_steps
654: where transaction_id=p_transaction_id
655: and API_NAME = p_Api_Name
656: and OBJECT_TYPE is null;
657: