DBA Data[Home] [Help]

APPS.POS_SUPP_PUB_RAISE_EVENT_PKG dependencies on DUAL

Line 383: FROM dual;

379: l_message VARCHAR2(50) := NULL;
380:
381: CURSOR c IS
382: SELECT POS_SUPP_NOTIFY_WORKFLOW_S.nextval
383: FROM dual;
384:
385: BEGIN
386:
387: OPEN c;

Line 493: FROM dual;

489: --checking for no zero value for current supplier publication event id, if not zero, then just return it, else find the next sequence and return
490: -- IF g_curr_supp_publish_event_id = 0 THEN
491: SELECT pos_supp_pub_event_s.nextval
492: INTO g_curr_supp_publish_event_id
493: FROM dual;
494: --END IF;
495:
496: RETURN g_curr_supp_publish_event_id;
497: