APPS.IGS_PS_OFR_OPT_PKG dependencies on IGS_PS_OFR_OPT_NOTE_PKG

Line 458: IGS_PS_OFR_OPT_NOTE_PKG.GET_FK_IGS_PS_OFR_OPT (

454: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT (
455: old_references.coo_id
456: );
457:
458: IGS_PS_OFR_OPT_NOTE_PKG.GET_FK_IGS_PS_OFR_OPT (
459: old_references.course_cd,
460: old_references.version_number,
461: old_references.cal_type,
462: old_references.location_cd,

Line 467: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT (

463: old_references.attendance_mode,
464: old_references.attendance_type
465: );
466:
467: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT (
468: old_references.coo_id
469: );
470:
471: IGS_PS_OFR_PAT_PKG.GET_FK_IGS_PS_OFR_OPT (

Line 571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);

567: IF (old_references.coo_id = new_references.coo_id) OR (old_references.coo_id IS NULL) THEN
568: NULL;
569: ELSE
570: IGS_PS_ENT_PT_REF_CD_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
571: IGS_PS_OFR_OPT_NOTE_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
572: IGS_PS_OFR_PAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
573: IGS_PS_OF_OPT_UNT_ST_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
574: IGS_EN_STDNT_PS_ATT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);
575: IGS_PS_OF_OPT_AD_CAT_PKG.GET_UFK_IGS_PS_OFR_OPT(old_references.coo_id);