DBA Data[Home] [Help]

APPS.IGS_PE_COURSE_EXCL_PKG dependencies on IGS_GE_DATE

Line 86: (NVL(old_references.pce_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

82:
83: -- Validate that start date is not less than the current date.
84: IF (new_references.pce_start_dt IS NOT NULL) AND
85: (p_inserting OR (p_updating AND
86: (NVL(old_references.pce_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
87: <> new_references.pce_start_dt)))
88: THEN
89: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
90: new_references.pce_start_dt,

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

109: -- Validate that if expiry date is specified, then expiry date is not
110: -- less than the start date.
111: IF (new_references.expiry_dt IS NOT NULL) AND
112: (p_inserting OR (p_updating AND
113: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
114: <> new_references.expiry_dt)))
115: THEN
116: IF IGS_EN_VAL_PCE.enrp_val_strt_exp_dt (
117: new_references.pce_start_dt,