APPS.IGS_PS_OFR_PAT_PKG dependencies on IGS_PS_OFR_PAT_NOTE_PKG

Line 566: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(

562:
563: PROCEDURE Check_Child_Existance AS
564: BEGIN
565:
566: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(
567: old_references.cop_id
568: );
569:
570: IGS_PS_OFR_PAT_NOTE_PKG.GET_FK_IGS_PS_OFR_PAT(

Line 570: IGS_PS_OFR_PAT_NOTE_PKG.GET_FK_IGS_PS_OFR_PAT(

566: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(
567: old_references.cop_id
568: );
569:
570: IGS_PS_OFR_PAT_NOTE_PKG.GET_FK_IGS_PS_OFR_PAT(
571: old_references.course_cd,
572: old_references.version_number,
573: old_references.cal_type,
574: old_references.ci_sequence_number,

Line 588: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(old_references.cop_id

584: IF (((old_references.cop_id = new_references.cop_id)) OR
585: ((old_references.cop_id IS NULL)))THEN
586: NULL;
587: ELSE
588: IGS_PS_OFR_PAT_NOTE_PKG.GET_UFK_IGS_PS_OFR_PAT(old_references.cop_id
589: );
590: END IF;
591: END Check_UK_Child_Existance;
592: