772:
773: IF(l_raise_event) THEN
774: -- get event_id and set global variable to event_id for
775: -- BOT populate function
776: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
777: INTO l_event_id
778: FROM DUAL;
779: END IF;
780: ELSE
1765: );
1766:
1767: IF(l_per_raise_event) THEN
1768: -- Get event_id for person
1769: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1770: INTO l_per_event_id
1771: FROM DUAL;
1772: END IF;
1773:
1772: END IF;
1773:
1774: IF(l_pc_raise_event) THEN
1775: -- Get event_id for person customer
1776: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
1777: INTO l_pc_event_id
1778: FROM DUAL;
1779: END IF;
1780: END IF;