DBA Data[Home] [Help]

APPS.HRI_EDW_DIM_EVENTS dependencies on HRI_EDW_EVENT_HRCHYS

Line 212: FROM hri_edw_event_hrchys

208: event_code
209: ,parent_event_id
210: ,reason_type
211: ,user_event_type
212: FROM hri_edw_event_hrchys
213: WHERE hierarchy = p_hierarchy
214: AND level_number = p_level_number
215: AND event_id = p_event_id;
216:

Line 226: INSERT INTO hri_edw_event_hrchys

222: l_reason_type,
223: l_user_event_type;
224: IF (row_exists_cur%NOTFOUND OR row_exists_cur%NOTFOUND IS NULL) THEN
225: CLOSE row_exists_cur;
226: INSERT INTO hri_edw_event_hrchys
227: ( event_id
228: , hierarchy
229: , level_number
230: , event_code

Line 244: UPDATE hri_edw_event_hrchys

240: , p_reason_type
241: , p_user_event_type );
242: ELSE
243: CLOSE row_exists_cur;
244: UPDATE hri_edw_event_hrchys
245: SET event_code = p_event_code
246: , parent_event_id = p_parent_event_id
247: , reason_type = p_reason_type
248: , user_event_type = p_user_event_type