[Home] [Help]
350: ,sep_event_id
351: ,reason_type
352: ,facts
353: ,description
354: FROM hri_edw_event_hrchy_cmbns
355: WHERE combination_id = p_combination_id;
356:
357: BEGIN
358:
366: l_facts,
367: l_description;
368: IF (row_exists_cur%NOTFOUND OR row_exists_cur%NOTFOUND IS NULL) THEN
369: CLOSE row_exists_cur;
370: INSERT INTO hri_edw_event_hrchy_cmbns
371: ( combination_id
372: , gain_event_id
373: , loss_event_id
374: , rec_event_id
386: , p_facts
387: , p_description );
388: ELSE
389: CLOSE row_exists_cur;
390: UPDATE hri_edw_event_hrchy_cmbns
391: SET gain_event_id = p_gain_event_id
392: , loss_event_id = p_loss_event_id
393: , rec_event_id = p_rec_event_id
394: , sep_event_id = p_sep_event_id