DBA Data[Home] [Help]

APPS.IGS_EN_STDNT_PS_INTM_PKG dependencies on IGS_GE_DATE

Line 185: IF p_inserting OR (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

181: BEGIN
182: -- If trigger has not been disabled, perform required processing
183: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_INTM') THEN
184: -- Validate for date overlaps.
185: IF p_inserting OR (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
186: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
187:
188: -- Validate IGS_EN_STDNTPSHECSOP date overlaps.
189: IF IGS_EN_VAL_SCI.enrp_val_sci_ovrlp (

Line 186: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

182: -- If trigger has not been disabled, perform required processing
183: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_EN_STDNT_PS_INTM') THEN
184: -- Validate for date overlaps.
185: IF p_inserting OR (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
186: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
187:
188: -- Validate IGS_EN_STDNTPSHECSOP date overlaps.
189: IF IGS_EN_VAL_SCI.enrp_val_sci_ovrlp (
190: NEW_REFERENCES.person_id,