DBA Data[Home] [Help]

APPS.IGS_PE_CRS_GRP_EXCL_PKG dependencies on IGS_GE_DATE

Line 84: (NVL(old_references.pcge_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.pcge_start_dt IS NOT NULL) THEN
83: IF p_inserting OR (p_updating AND
84: (NVL(old_references.pcge_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
85: <> new_references.pcge_start_dt))
86: THEN
87: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
88: new_references.pcge_start_dt,

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

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