80: BEGIN
81: -- Validate that start date is not less than the current date.
82: IF (new_references.puse_start_dt IS NOT NULL) AND
83: (p_inserting OR (p_updating AND
84: (NVL(old_references.puse_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
85: <> new_references.puse_start_dt)))
86: THEN
87: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
88: new_references.puse_start_dt,
107: -- Validate that if expiry date is specified, then expiry date is not
108: -- less than the start date.
109: IF (new_references.expiry_dt IS NOT NULL) AND
110: (p_inserting OR (p_updating AND
111: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
112: <> new_references.expiry_dt)))
113: THEN
114: IF IGS_EN_VAL_PCE.enrp_val_strt_exp_dt (
115: new_references.puse_start_dt,