DBA Data[Home] [Help]

APPS.IGS_RE_VAL_TPM dependencies on IGS_GE_DATE

Line 537: NVL(p_old_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

533: IF NVL(p_old_thesis_result_cd, 'NULL') <>
534: NVL(p_new_thesis_result_cd, 'NULL') OR
535: NVL(p_old_panel_member_type, 'NULL') <>
536: NVL(p_new_panel_member_type, 'NULL') OR
537: NVL(p_old_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
538: NVL(p_new_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
539: p_message_name := 'IGS_RE_CANT_UPD_PAN_MEM_TYPE';
540: RETURN FALSE;
541: END IF;

Line 538: NVL(p_new_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN

534: NVL(p_new_thesis_result_cd, 'NULL') OR
535: NVL(p_old_panel_member_type, 'NULL') <>
536: NVL(p_new_panel_member_type, 'NULL') OR
537: NVL(p_old_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
538: NVL(p_new_confirmed_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) THEN
539: p_message_name := 'IGS_RE_CANT_UPD_PAN_MEM_TYPE';
540: RETURN FALSE;
541: END IF;
542: END IF;