DBA Data[Home] [Help]

APPS.IGS_PE_UNT_REQUIRMNT_PKG dependencies on IGS_GE_DATE

Line 82: (NVL(old_references.pur_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

78: BEGIN
79: -- Validate that start date is not less than the current date.
80: IF (new_references.pur_start_dt IS NOT NULL) THEN
81: IF p_inserting OR (p_updating AND
82: (NVL(old_references.pur_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
83: <> new_references.pur_start_dt))
84: THEN
85: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (
86: new_references.pur_start_dt,

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

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