APPS.IGS_OR_VAL_IA dependencies on IGS_GE_DATE

Line 201: v_end_dt := IGS_GE_DATE.IGSDATE('9999/01/01');

197: -- Set the default message number
198: p_message_name := null;
199: -- set p_end_dt to a high date if null
200: IF (p_end_dt IS NULL) THEN
201: v_end_dt := IGS_GE_DATE.IGSDATE('9999/01/01');
202: ELSE
203: v_end_dt := p_end_dt;
204: END IF;
205: -- Loop through the selected institution_addr records,

Line 217: (p_start_dt <= NVL(v_ia_rec.end_dt,IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN

213: p_institution_cd,
214: p_addr_type) LOOP
215: -- check if p_start_dt between existing date range.
216: IF (p_start_dt >= v_ia_rec.start_dt) AND
217: (p_start_dt <= NVL(v_ia_rec.end_dt,IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
218: p_message_name:= 'IGS_EN_ADDRESS_DATES_OVERLAP';
219: RETURN FALSE;
220: END IF;
221: -- check if p_end_date between existing date range.

Line 223: (v_end_dt <= NVL(v_ia_rec.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN

219: RETURN FALSE;
220: END IF;
221: -- check if p_end_date between existing date range.
222: IF (v_end_dt >= v_ia_rec.start_dt) AND
223: (v_end_dt <= NVL(v_ia_rec.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
224: p_message_name:= 'IGS_EN_ADDRESS_DATES_OVERLAP';
225: RETURN FALSE;
226: END IF;
227: -- check if input dates overlap entire existing

Line 230: (v_end_dt >= NVL(v_ia_rec.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN

226: END IF;
227: -- check if input dates overlap entire existing
228: -- date range.
229: IF (p_start_dt <= v_ia_rec.start_dt) AND
230: (v_end_dt >= NVL(v_ia_rec.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
231: p_message_name:= 'IGS_EN_ADDRESS_DATES_OVERLAP';
232: RETURN FALSE;
233: END IF;
234: END LOOP;