[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select HRHD_RIR_EVENT_DATA_SEQ.nextval into l_transaction_id from dual;
Insert into HR_HRHD_RIR_EVENT_DATA (Transaction_Id,Event_Data,Status) Values (l_transaction_id,p_in_event_data,'Y');
Select EVENT_DATA into l_event_data from HR_HRHD_RIR_EVENT_DATA where TRANSACTION_ID = p_transaction_id;