DBA Data[Home] [Help]

APPS.HR_HRHD_EVENT_DATA_HANDLER dependencies on HR_HRHD_RIR_EVENT_DATA

Line 31: Insert into HR_HRHD_RIR_EVENT_DATA (Transaction_Id,Event_Data,Status) Values (l_transaction_id,p_in_event_data,'Y');

27: End;
28:
29: If l_transaction_id <> 0 and p_in_event_data is not null
30: Then
31: Insert into HR_HRHD_RIR_EVENT_DATA (Transaction_Id,Event_Data,Status) Values (l_transaction_id,p_in_event_data,'Y');
32: End If;
33: Else
34: Raise Null_Event_Data;
35: End If;

Line 61: Select EVENT_DATA into l_event_data from HR_HRHD_RIR_EVENT_DATA where TRANSACTION_ID = p_transaction_id;

57: Begin
58: If p_transaction_id is not null
59: Then
60: Begin
61: Select EVENT_DATA into l_event_data from HR_HRHD_RIR_EVENT_DATA where TRANSACTION_ID = p_transaction_id;
62: Exception
63: When Others then
64: l_event_data := null;
65: Raise Null_Event_Data;