DBA Data[Home] [Help]

APPS.IGS_PE_PERSENC_EFFCT_PKG dependencies on IGS_EN_GEN_011

Line 498: -- Cannot call IGS_EN_GEN_011.ENRP_SET_PEN_EXPRY because trigger will be mutating.

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

Line 548: IGS_EN_GEN_011.ENRP_SET_PEE_EXPRY (new_references.person_id,

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,

Line 581: IGS_EN_GEN_011.ENRP_SET_PEN_EXPRY (new_references.person_id,

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,