APPS.IGS_AV_STND_UNIT_PKG dependencies on IGS_GE_DATE

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

153: END IF;
154: -- Validate Advanced Standing Unit Approved Date
155: IF (new_references.approved_dt IS NOT NULL) AND
156: (p_inserting OR
157: (NVL(old_references.approved_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
158: new_references.approved_dt)) THEN
159: IF igs_av_val_asu.advp_val_as_dates (
160: new_references.approved_dt,
161: 'APPROVED',

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

188: END IF;
189: -- Validate Advanced Standing Unit Granted Date
190: IF (new_references.granted_dt IS NOT NULL) AND
191: (p_inserting OR
192: (NVL(old_references.granted_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
193: new_references.granted_dt)) THEN
194: IF igs_av_val_asu.advp_val_as_dates (
195: new_references.granted_dt,
196: 'GRANTED',

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

204: END IF;
205: -- Validate expiry date is greater than current date and approved date.
206: IF (new_references.expiry_dt IS NOT NULL) AND
207: (p_inserting OR
208: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
209: new_references.expiry_dt)) THEN
210: IF igs_av_val_asu.advp_val_expiry_dt (
211: new_references.expiry_dt,
212: v_message_name,

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

219: END IF;
220: -- Validate Advanced Standing Unit Cancelled Date
221: IF (new_references.cancelled_dt IS NOT NULL) AND
222: (p_inserting OR
223: (NVL(old_references.cancelled_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
224: new_references.cancelled_dt)) THEN
225: IF igs_av_val_asu.advp_val_as_dates (
226: new_references.cancelled_dt,
227: 'CANCELLED',

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

243: END IF;
244: -- Validate Advanced Standing Unit Revoked Date
245: IF (new_references.revoked_dt IS NOT NULL) AND
246: (p_inserting OR
247: (NVL(old_references.revoked_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
248: new_references.revoked_dt)) THEN
249: IF igs_av_val_asu.advp_val_as_dates (
250: new_references.revoked_dt,
251: 'REVOKED',