APPS.IGS_AV_STND_UNIT_LVL_PKG dependencies on IGS_GE_DATE

Line 147: (NVL(old_references.approved_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

143: END IF;
144: -- Validate Advanced Standing Unit Level Approved Date
145: IF (new_references.approved_dt IS NOT NULL) AND
146: (p_inserting OR
147: (NVL(old_references.approved_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
148: new_references.approved_dt)) THEN
149: IF igs_av_val_asu.advp_val_as_dates (
150: new_references.approved_dt,
151: 'APPROVED',

Line 181: (NVL(old_references.granted_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

177: END IF;
178: -- Validate Advanced Standing Unit Level Granted Date
179: IF (new_references.granted_dt IS NOT NULL) AND
180: (p_inserting OR
181: (NVL(old_references.granted_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
182: new_references.granted_dt)) THEN
183: IF igs_av_val_asu.advp_val_as_dates (
184: new_references.granted_dt,
185: 'GRANTED',

Line 196: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

192: END IF;
193: -- Validate expiry date is greater than current date.
194: IF (new_references.expiry_dt IS NOT NULL) AND
195: (p_inserting OR
196: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
197: new_references.expiry_dt)) THEN
198: IF igs_av_val_asu.advp_val_expiry_dt (
199: new_references.expiry_dt,
200: v_message_name,

Line 210: (NVL(old_references.cancelled_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

206: END IF;
207: -- Validate Advanced Standing Unit Level Cancelled Date
208: IF (new_references.cancelled_dt IS NOT NULL) AND
209: (p_inserting OR
210: (NVL(old_references.cancelled_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
211: new_references.cancelled_dt)) THEN
212: IF igs_av_val_asu.advp_val_as_dates (
213: new_references.cancelled_dt,
214: 'CANCELLED',

Line 232: (NVL(old_references.revoked_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

228: END IF;
229: -- Validate Advanced Standing Unit Level Revoked Date
230: IF (new_references.revoked_dt IS NOT NULL) AND
231: (p_inserting OR
232: (NVL(old_references.revoked_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
233: new_references.revoked_dt)) THEN
234: IF igs_av_val_asu.advp_val_as_dates (
235: new_references.revoked_dt,
236: 'REVOKED',