DBA Data[Home] [Help]

APPS.CLN_SHOWSHIP_PKG dependencies on DUAL

Line 248: SELECT CLN_SHOWSHIP_S.nextval into l_showship_seq from dual;

244: cln_debug_pub.Add('Failure point ' || x_progress, 1);
245: end if;
246:
247: -- create unique key
248: SELECT CLN_SHOWSHIP_S.nextval into l_showship_seq from dual;
249: l_event_key := to_char(p_delivery_id) || '.' || to_char(l_showship_seq);
250:
251: SELECT sysdate into l_date from dual;
252: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);

Line 251: SELECT sysdate into l_date from dual;

247: -- create unique key
248: SELECT CLN_SHOWSHIP_S.nextval into l_showship_seq from dual;
249: l_event_key := to_char(p_delivery_id) || '.' || to_char(l_showship_seq);
250:
251: SELECT sysdate into l_date from dual;
252: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
253:
254: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 08';
255: if (l_debug_level <= 1) then