APPS.IGS_PE_PERS_ENCUMB_PKG dependencies on IGS_GE_DATE

Line 199: (NVL(old_references.start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

195:
196: -- Validate that start date is not less than the current date.
197: IF (new_references.start_dt IS NOT NULL) AND
198: (p_inserting OR (p_updating AND
199: (NVL(old_references.start_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
200: <> new_references.start_dt)))
201: THEN
202:
203: IF IGS_EN_VAL_PCE.enrp_val_encmb_dt (

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

222: CLOSE cur_hold_ovr;
223: IF new_references.expiry_dt <> l_hold_old_end_date THEN
224: IF (new_references.expiry_dt IS NOT NULL) AND
225: (p_inserting OR (p_updating AND
226: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
227: <> new_references.expiry_dt)))
228: THEN
229: IF IGS_EN_VAL_PCE.enrp_val_strt_exp_dt (
230: new_references.start_dt,

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

305: v_rowid_saved := TRUE;
306: END IF;
307: END IF;
308: IF p_updating AND
309: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
310: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
311: -- Cannot call enrp_set_expiry_dts because trigger will be mutating.
312: -- Save the rowid of the current row.
313: IF v_rowid_saved = FALSE THEN

Line 310: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

306: END IF;
307: END IF;
308: IF p_updating AND
309: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
310: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
311: -- Cannot call enrp_set_expiry_dts because trigger will be mutating.
312: -- Save the rowid of the current row.
313: IF v_rowid_saved = FALSE THEN
314: