DBA Data[Home] [Help]

APPS.IGS_PE_UNT_SET_EXCL_PKG dependencies on IGS_GE_DATE

Line 84: (NVL(old_references.puse_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

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,

Line 111: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

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,