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 657: from hr_api_transaction_steps

653: return VARCHAR2 IS
654:
655: cursor csr_hat_steps(p_Api_Name in varchar2) is
656: select *
657: from hr_api_transaction_steps
658: where transaction_id=p_transaction_id
659: and API_NAME = p_Api_Name
660: and OBJECT_TYPE is null;
661: