APPS.IGS_PS_GEN_002 dependencies on IGS_PS_UNIT_LVL

Line 225: v_unit_level igs_ps_unit_lvl.unit_level%TYPE;

221: p_course_version_number IN NUMBER )
222: RETURN VARCHAR2 AS
223: BEGIN
224: DECLARE
225: v_unit_level igs_ps_unit_lvl.unit_level%TYPE;
226: CURSOR c_cul_crv IS
227: SELECT cul.unit_level
228: FROM igs_ps_unit_lvl cul
229: WHERE cul.course_cd = p_course_cd AND

Line 228: FROM igs_ps_unit_lvl cul

224: DECLARE
225: v_unit_level igs_ps_unit_lvl.unit_level%TYPE;
226: CURSOR c_cul_crv IS
227: SELECT cul.unit_level
228: FROM igs_ps_unit_lvl cul
229: WHERE cul.course_cd = p_course_cd AND
230: cul.version_number = p_course_version_number AND
231: cul.unit_cd = p_unit_cd AND
232: cul.version_number = p_unit_version_number;

Line 240: -- Searches for the existence of a IGS_PS_UNIT_LVL record using the

236: WHERE uv.unit_cd = p_unit_cd AND
237: uv.version_number = p_unit_version_number;
238: BEGIN
239: -- Get the IGS_PS_UNIT level of a IGS_PS_UNIT attempt within a nominated IGS_PS_COURSE.
240: -- Searches for the existence of a IGS_PS_UNIT_LVL record using the
241: -- IGS_PS_UNIT.level
242: -- 1. Search for a IGS_PS_UNIT_LVL record matching the IGS_PS_UNIT version and the
243: -- IGS_PS_COURSE type of the nominated IGS_PS_COURSE.
244: OPEN c_cul_crv;

Line 242: -- 1. Search for a IGS_PS_UNIT_LVL record matching the IGS_PS_UNIT version and the

238: BEGIN
239: -- Get the IGS_PS_UNIT level of a IGS_PS_UNIT attempt within a nominated IGS_PS_COURSE.
240: -- Searches for the existence of a IGS_PS_UNIT_LVL record using the
241: -- IGS_PS_UNIT.level
242: -- 1. Search for a IGS_PS_UNIT_LVL record matching the IGS_PS_UNIT version and the
243: -- IGS_PS_COURSE type of the nominated IGS_PS_COURSE.
244: OPEN c_cul_crv;
245: FETCH c_cul_crv INTO v_unit_level;
246: IF (c_cul_crv%FOUND) THEN