APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_AS_SU_ATMPT_ITM

Line 1700: CURSOR CUR_IGS_AS_SU_ATMPT_ITM IS

1696: END Check_Parent_Existance;
1697:
1698:
1699: PROCEDURE Check_Child_Existance AS
1700: CURSOR CUR_IGS_AS_SU_ATMPT_ITM IS
1701: SELECT ROWID
1702: FROM IGS_AS_SU_ATMPT_ITM
1703: WHERE person_id = old_references.person_id
1704: AND course_cd = old_references.course_cd

Line 1702: FROM IGS_AS_SU_ATMPT_ITM

1698:
1699: PROCEDURE Check_Child_Existance AS
1700: CURSOR CUR_IGS_AS_SU_ATMPT_ITM IS
1701: SELECT ROWID
1702: FROM IGS_AS_SU_ATMPT_ITM
1703: WHERE person_id = old_references.person_id
1704: AND course_cd = old_references.course_cd
1705: AND uoo_id = old_references.uoo_id;
1706:

Line 1723: FOR IGS_AS_SU_ATMPT_ITM_REC IN CUR_IGS_AS_SU_ATMPT_ITM LOOP

1719: /*deleting the history record*/
1720: FOR IGS_EN_SU_ATTEMPT_H_REC IN CUR_IGS_EN_SU_ATTEMPT_H LOOP
1721: IGS_EN_SU_ATTEMPT_H_PKG.DELETE_ROW(X_ROWID => IGS_EN_SU_ATTEMPT_H_REC.ROWID);
1722: END LOOP;
1723: FOR IGS_AS_SU_ATMPT_ITM_REC IN CUR_IGS_AS_SU_ATMPT_ITM LOOP
1724: IGS_AS_SU_ATMPT_ITM_PKG.DELETE_ROW(X_ROWID => IGS_AS_SU_ATMPT_ITM_REC.ROWID);
1725: END LOOP;
1726: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_EN_SU_ATTEMPT (
1727: old_references.person_id,

Line 1724: IGS_AS_SU_ATMPT_ITM_PKG.DELETE_ROW(X_ROWID => IGS_AS_SU_ATMPT_ITM_REC.ROWID);

1720: FOR IGS_EN_SU_ATTEMPT_H_REC IN CUR_IGS_EN_SU_ATTEMPT_H LOOP
1721: IGS_EN_SU_ATTEMPT_H_PKG.DELETE_ROW(X_ROWID => IGS_EN_SU_ATTEMPT_H_REC.ROWID);
1722: END LOOP;
1723: FOR IGS_AS_SU_ATMPT_ITM_REC IN CUR_IGS_AS_SU_ATMPT_ITM LOOP
1724: IGS_AS_SU_ATMPT_ITM_PKG.DELETE_ROW(X_ROWID => IGS_AS_SU_ATMPT_ITM_REC.ROWID);
1725: END LOOP;
1726: IGS_AS_SU_STMPTOUT_PKG.GET_FK_IGS_EN_SU_ATTEMPT (
1727: old_references.person_id,
1728: old_references.course_cd,