APPS.IGS_OR_VAL_OA dependencies on IGS_GE_DATE

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

209: -- Set the default message number
210: p_message_name := NULL;
211: -- set p_end_dt to a high date if null
212: IF (p_end_dt IS NULL) THEN
213: v_end_dt := IGS_GE_DATE.IGSDATE('9999/01/01');
214: ELSE
215: v_end_dt := p_end_dt;
216: END IF;
217: -- Loop through the selected IGS_OR_ADDR records,

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

226: p_ou_start_dt,
227: p_addr_type) LOOP
228: -- check if p_start_dt between existing date range.
229: IF (p_start_dt >= v_oa_rec.start_dt) AND
230: (p_start_dt <= NVL(v_oa_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: -- check if p_end_date between existing date range.

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

232: RETURN FALSE;
233: END IF;
234: -- check if p_end_date between existing date range.
235: IF (v_end_dt >= v_oa_rec.start_dt) AND
236: (v_end_dt <= NVL(v_oa_rec.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
237: p_message_name := 'IGS_EN_ADDRESS_DATES_OVERLAP';
238: RETURN FALSE;
239: END IF;
240: -- check if input dates overlap entire existing

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

239: END IF;
240: -- check if input dates overlap entire existing
241: -- date range.
242: IF (p_start_dt <= v_oa_rec.start_dt) AND
243: (v_end_dt >= NVL(v_oa_rec.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))) THEN
244: p_message_name := 'IGS_EN_ADDRESS_DATES_OVERLAP';
245: RETURN FALSE;
246: END IF;
247: END LOOP;