DBA Data[Home] [Help]

APPS.IGS_GE_GEN_003 dependencies on IGS_GE_DATE

Line 303: RETURN IGS_GE_DATE.IGSDATE(NULL);

299: -- is the only component that is being analysed and the date is superfluous.
300: DECLARE
301: BEGIN
302: IF(p_time IS NULL) THEN
303: RETURN IGS_GE_DATE.IGSDATE(NULL);
304: ELSE
305:
306:
307: RETURN (IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(IGS_GE_DATE.IGSDATE('1900/01/01')) ||

Line 307: RETURN (IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(IGS_GE_DATE.IGSDATE('1900/01/01')) ||

303: RETURN IGS_GE_DATE.IGSDATE(NULL);
304: ELSE
305:
306:
307: RETURN (IGS_GE_DATE.IGSDATE(IGS_GE_DATE.IGSCHAR(IGS_GE_DATE.IGSDATE('1900/01/01')) ||
308: ' ' || TO_CHAR(p_time, 'HH24:MI:SS')));
309: END IF;
310: END;
311: EXCEPTION