DBA Data[Home] [Help]

APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on HR_API_TRANSACTIONS

Line 106: l_transaction_id hr_api_transactions.transaction_id%type;

102: -- --------------------------------------------------------------------------
103: -- declare local variables
104: -- --------------------------------------------------------------------------
105: l_proc varchar2(72);
106: l_transaction_id hr_api_transactions.transaction_id%type;
107: -- cursor to select the transaction_id of the step
108: cursor csr_hats is
109: select hats.transaction_id
110: from hr_api_transaction_steps hats

Line 279: UPDATE hr_api_transactions hat

275: itemkey =>itemkey,
276: aname =>'HR_RUNTIME_APPROVAL_REQ_FLAG',
277: avalue =>'YES');
278:
279: UPDATE hr_api_transactions hat
280: set hat.item_key = itemkey
281: WHERE hat.transaction_id=l_transaction_id;
282:
283: UPDATE hr_api_transaction_steps hats