DBA Data[Home] [Help]

APPS.IGS_RE_VAL_MIL dependencies on IGS_GE_DATE

Line 325: IF NVL(p_old_due_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

321: NVL(mil.preced_sequence_number,0) = p_sequence_number;
322: BEGIN
323: -- Set the default message number
324: p_message_name := null;
325: IF NVL(p_old_due_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
326: p_new_due_dt THEN
327: FOR v_mil_rec IN c_mil
328: LOOP
329: IF p_new_due_dt > v_mil_rec.due_dt THEN

Line 413: NVL(p_old_due_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) = p_new_due_dt THEN

409: IF p_validation_level in ('RECORD','TRIGGER') THEN
410: -- 3. Check whether being re-planned and date has changed.
411: If v_new_mst_rec.s_milestone_status = cst_replanned AND
412: v_old_mst_rec.s_milestone_status <> cst_replanned AND
413: NVL(p_old_due_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) = p_new_due_dt THEN
414: p_message_name := 'IGS_RE_DUE_DT_MUST_BE_CHANGED';
415: RETURN FALSE;
416: END IF;
417: END IF;