APPS.FLM_EKB_BUSINESS_EVENT_PKG dependencies on DUAL

Line 53: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;

49: elsif p_txn_type = TXN_TYPE_UPDATE then
50: l_event_name := 'oracle.apps.flm.ekanban.pullSeqUpdate';
51: end if;
52:
53: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;
54: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
55:
56: OPEN c_pullSequence;
57: FETCH c_pullSequence INTO l_pull_sequence;

Line 182: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;

178: end if;
179: CLOSE c_kanbanCard;
180:
181:
182: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;
183: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
184:
185: wf_event.AddParameterToList(p_name=>'kanban_card_id',
186: p_value=>p_kanban_card_id,

Line 270: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;

266: BEGIN
267: l_send_date := sysdate;
268: l_event_name := 'oracle.apps.flm.ekanban.cardStatusChange';
269:
270: SELECT MTL_BUSINESS_EVENTS_S.NEXTVAL into l_event_num FROM dual;
271: l_event_key := SUBSTRB(l_event_name, 1, 255) || '-' || l_event_num;
272:
273: OPEN c_kanbanCard;
274: FETCH c_kanbanCard INTO l_kanban_card;

Line 422: into l_seq from sys.dual;

418: we.component_item_id = msi.inventory_item_id (+) and
419: we.exception_id = p_exception_id;
420:
421: select to_char(WIP_EXP_NOTIF_WF_ITEMKEY_S.NEXTVAL)
422: into l_seq from sys.dual;
423:
424: l_itemkey := to_char (p_exception_id)|| '-' || l_seq;
425:
426: