DBA Data[Home] [Help]

APPS.IGS_RE_VAL_THE dependencies on IGS_GE_DATE

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

219: END IF;
220: -- Check that the embargo expiry date is different to the old embargo date and
221: -- not backdated
222: IF p_legacy <> 'Y' THEN --for legacy this validation is not required
223: IF NVL(p_old_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
224: NVL(p_new_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
225: (p_new_embargo_expiry_dt IS NOT NULL AND
226: p_new_embargo_expiry_dt < TRUNC(SYSDATE)) THEN
227: p_message_name := 'IGS_RE_EMBARGO_DT_CANT_BACKDT';

Line 224: NVL(p_new_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND

220: -- Check that the embargo expiry date is different to the old embargo date and
221: -- not backdated
222: IF p_legacy <> 'Y' THEN --for legacy this validation is not required
223: IF NVL(p_old_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
224: NVL(p_new_embargo_expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) AND
225: (p_new_embargo_expiry_dt IS NOT NULL AND
226: p_new_embargo_expiry_dt < TRUNC(SYSDATE)) THEN
227: p_message_name := 'IGS_RE_EMBARGO_DT_CANT_BACKDT';
228: RETURN FALSE;