APPS.IGS_AS_VAL_SCAP dependencies on IGS_EN_SU_ATTEMPT

Line 101: v_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

97: RETURN BOOLEAN IS
98: gv_other_detail VARCHAR2(255);
99: BEGIN
100: DECLARE
101: v_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
102: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
103: v_person_id IGS_AS_UAI_SUA_V.person_id%TYPE;
104: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
105: 'UNCONFIRM';

Line 102: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

98: gv_other_detail VARCHAR2(255);
99: BEGIN
100: DECLARE
101: v_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
102: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
103: v_person_id IGS_AS_UAI_SUA_V.person_id%TYPE;
104: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
105: 'UNCONFIRM';
106: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

Line 104: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

100: DECLARE
101: v_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
102: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
103: v_person_id IGS_AS_UAI_SUA_V.person_id%TYPE;
104: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
105: 'UNCONFIRM';
106: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
107: 'ENROLLED';
108: l_dummy VARCHAR2(1);

Line 106: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=

102: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
103: v_person_id IGS_AS_UAI_SUA_V.person_id%TYPE;
104: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
105: 'UNCONFIRM';
106: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
107: 'ENROLLED';
108: l_dummy VARCHAR2(1);
109: CURSOR c_sua IS
110: SELECT sua.unit_attempt_status,

Line 112: FROM IGS_EN_SU_ATTEMPT sua

108: l_dummy VARCHAR2(1);
109: CURSOR c_sua IS
110: SELECT sua.unit_attempt_status,
111: sua.uoo_id
112: FROM IGS_EN_SU_ATTEMPT sua
113: WHERE sua.person_id = p_person_id AND
114: sua.course_cd = p_course_cd AND
115: -- anilk, 22-Apr-2003, Bug# 2829262
116: sua.uoo_id = p_uoo_id;

Line 130: CURSOR c_usv(l_usv_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

126: -- The Following cursor is added by Nishikant -15JAN2002- Enh Bug#2162831
127: -- to check whether the assessment item is available at unitsection level or not
128: -- Changed as required by the JOB.Maintain the student attempt Items and the
129: -- form IGSAS016
130: CURSOR c_usv(l_usv_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
131: SELECT 'X'
132: FROM igs_ps_unitass_item_v usv
133: WHERE usv.ass_id = p_ass_id AND
134: usv.uoo_id = l_usv_uoo_id AND