DBA Data[Home] [Help]

APPS.IGS_AS_VAL_ESE dependencies on IGS_GE_DATE

Line 250: v_start_time := IGS_GE_DATE.IGSDATE( '1900/01/01 ' || SUBSTR(IGS_GE_DATE.IGSCHARDT(p_start_time),12));

246: --- Set the default message number
247: P_MESSAGE_NAME := NULL;
248: --- Make sure the only comparing the time component and that the dates
249: --- are identical. (01/01/1900 is an arbitrary date)
250: v_start_time := IGS_GE_DATE.IGSDATE( '1900/01/01 ' || SUBSTR(IGS_GE_DATE.IGSCHARDT(p_start_time),12));
251: v_end_time := IGS_GE_DATE.IGSDATE( '1900/01/01 ' || SUBSTR(IGS_GE_DATE.IGSCHARDT(p_end_time),12));
252: IF v_end_time <= v_start_time THEN
253: P_MESSAGE_NAME := 'IGS_GE_ST_TIME_LT_END_TIME';
254: RETURN FALSE;

Line 251: v_end_time := IGS_GE_DATE.IGSDATE( '1900/01/01 ' || SUBSTR(IGS_GE_DATE.IGSCHARDT(p_end_time),12));

247: P_MESSAGE_NAME := NULL;
248: --- Make sure the only comparing the time component and that the dates
249: --- are identical. (01/01/1900 is an arbitrary date)
250: v_start_time := IGS_GE_DATE.IGSDATE( '1900/01/01 ' || SUBSTR(IGS_GE_DATE.IGSCHARDT(p_start_time),12));
251: v_end_time := IGS_GE_DATE.IGSDATE( '1900/01/01 ' || SUBSTR(IGS_GE_DATE.IGSCHARDT(p_end_time),12));
252: IF v_end_time <= v_start_time THEN
253: P_MESSAGE_NAME := 'IGS_GE_ST_TIME_LT_END_TIME';
254: RETURN FALSE;
255: ELSE