DBA Data[Home] [Help]

APPS.IGS_AS_VAL_AI dependencies on IGS_GE_DATE

Line 117: v_exam_perusal_time := SUBSTR(IGS_GE_DATE.IGSCHARDT(p_exam_perusal_time), 12, 5);

113: CLOSE c_atyp;
114: IF (v_atyp_rec.examinable_ind = cst_yes) THEN
115: IF (p_exam_working_time IS NOT NULL AND
116: p_exam_perusal_time IS NOT NULL) THEN
117: v_exam_perusal_time := SUBSTR(IGS_GE_DATE.IGSCHARDT(p_exam_perusal_time), 12, 5);
118: v_exam_working_time := SUBSTR(IGS_GE_DATE.IGSCHARDT(p_exam_working_time), 12, 5);
119: IF (v_exam_perusal_time >= v_exam_working_time) THEN
120: P_MESSAGE_NAME := 'IGS_AS_PERUSALTIME_LT_WORKTIM';
121: RETURN FALSE;

Line 118: v_exam_working_time := SUBSTR(IGS_GE_DATE.IGSCHARDT(p_exam_working_time), 12, 5);

114: IF (v_atyp_rec.examinable_ind = cst_yes) THEN
115: IF (p_exam_working_time IS NOT NULL AND
116: p_exam_perusal_time IS NOT NULL) THEN
117: v_exam_perusal_time := SUBSTR(IGS_GE_DATE.IGSCHARDT(p_exam_perusal_time), 12, 5);
118: v_exam_working_time := SUBSTR(IGS_GE_DATE.IGSCHARDT(p_exam_working_time), 12, 5);
119: IF (v_exam_perusal_time >= v_exam_working_time) THEN
120: P_MESSAGE_NAME := 'IGS_AS_PERUSALTIME_LT_WORKTIM';
121: RETURN FALSE;
122: END IF;