DBA Data[Home] [Help]

APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_AS_SUA_SES_ATTS

Line 1619: FROM igs_as_sua_ses_atts sua_ses_atts

1615: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1616: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1617: IS
1618: SELECT rowid
1619: FROM igs_as_sua_ses_atts sua_ses_atts
1620: WHERE sua_ses_atts.person_id = cp_person_id
1621: AND sua_ses_atts.course_cd = cp_course_cd
1622: AND sua_ses_atts.uoo_id = cp_uoo_id;
1623: v_del_as_sua_ses_atts c_del_as_sua_ses_atts%ROWTYPE;

Line 1630: IGS_AS_SUA_SES_ATTS_pkg.DELETE_ROW(v_del_as_sua_ses_atts.rowid,

1626: v_MSG_COUNT NUMBER ;
1627: BEGIN
1628:
1629: FOR v_del_as_sua_ses_atts IN c_del_as_sua_ses_atts(p_person_id,p_course_cd,p_uoo_id) LOOP
1630: IGS_AS_SUA_SES_ATTS_pkg.DELETE_ROW(v_del_as_sua_ses_atts.rowid,
1631: 'R' ,
1632: v_RETURN_STATUS,
1633: v_MSG_DATA,
1634: v_MSG_COUNT