APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_EN_SU_ATTEMPT_H

Line 1707: CURSOR CUR_IGS_EN_SU_ATTEMPT_H IS

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:
1707: CURSOR CUR_IGS_EN_SU_ATTEMPT_H IS
1708: SELECT ROWID
1709: FROM IGS_EN_SU_ATTEMPT_H_ALL
1710: WHERE person_id = old_references.person_id
1711: AND course_cd = old_references.course_cd

Line 1709: FROM IGS_EN_SU_ATTEMPT_H_ALL

1705: AND uoo_id = old_references.uoo_id;
1706:
1707: CURSOR CUR_IGS_EN_SU_ATTEMPT_H IS
1708: SELECT ROWID
1709: FROM IGS_EN_SU_ATTEMPT_H_ALL
1710: WHERE person_id = old_references.person_id
1711: AND course_cd = old_references.course_cd
1712: AND uoo_id = old_references.uoo_id;
1713: BEGIN

Line 1720: FOR IGS_EN_SU_ATTEMPT_H_REC IN CUR_IGS_EN_SU_ATTEMPT_H LOOP

1716: old_references.course_cd,
1717: old_references.uoo_id
1718: );
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);

Line 1721: IGS_EN_SU_ATTEMPT_H_PKG.DELETE_ROW(X_ROWID => IGS_EN_SU_ATTEMPT_H_REC.ROWID);

1717: old_references.uoo_id
1718: );
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;

Line 4426: FROM igs_en_su_attempt_h

4422:
4423: /* Cursor to check whether the unit attempt status before adding to cart is DROPPED, bug 3000742*/
4424: CURSOR cur_sua_hist (cp_person_id NUMBER,cp_course_cd VARCHAR2, cp_uoo_id NUMBER) IS
4425: SELECT unit_attempt_status
4426: FROM igs_en_su_attempt_h
4427: WHERE person_id = cp_person_id
4428: AND course_cd = cp_course_cd
4429: AND uoo_id = cp_uoo_id
4430: ORDER BY hist_end_dt DESC;