494: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
495:
496: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
497:
498: -- Cannot call IGS_EN_GEN_011.ENRP_SET_PEN_EXPRY because trigger will be mutating.
499:
500: -- Save the rowid of the current row.
501:
502: IF v_rowid_saved = FALSE THEN
544: -- effect has been updated.
545:
546: IF new_references.expiry_dt IS NOT NULL THEN
547:
548: IGS_EN_GEN_011.ENRP_SET_PEE_EXPRY (new_references.person_id,
549:
550: new_references.encumbrance_type,
551:
552: new_references.pen_start_dt,
577: -- remain.
578:
579: IF new_references.expiry_dt IS NOT NULL AND igs_pe_pers_encumb_pkg.initialised IS NULL THEN
580:
581: IGS_EN_GEN_011.ENRP_SET_PEN_EXPRY (new_references.person_id,
582:
583: new_references.encumbrance_type,
584:
585: new_references.pen_start_dt,