APPS.IGS_AS_VAL_SUAAI dependencies on IGS_AS_COURSE_TYPE

Line 32: -- then validate if there exists IGS_AS_COURSE_TYPE records that restrict

28: RETURN BOOLEAN IS
29: gv_other_detail VARCHAR2(255);
30: BEGIN -- assp_val_ai_acot
31: -- Validate that if the assessment item is of an examinable type,
32: -- then validate if there exists IGS_AS_COURSE_TYPE records that restrict
33: -- the assessment item to particular IGS_PS_COURSE types.
34: DECLARE
35: cst_no CONSTANT CHAR := 'N';
36: v_rows_exist BOOLEAN := FALSE;

Line 39: v_course_type IGS_AS_COURSE_TYPE.course_type%TYPE;

35: cst_no CONSTANT CHAR := 'N';
36: v_rows_exist BOOLEAN := FALSE;
37: v_valid_item BOOLEAN := FALSE;
38: v_examinable_ind IGS_AS_ASSESSMNT_TYP.examinable_ind%TYPE;
39: v_course_type IGS_AS_COURSE_TYPE.course_type%TYPE;
40: CURSOR c_atyp(
41: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS
42: SELECT atyp.examinable_ind
43: FROM IGS_AS_ASSESSMNT_TYP atyp,

Line 50: FROM IGS_AS_COURSE_TYPE

46: ai.assessment_type = atyp.assessment_type;
47: CURSOR c_act(
48: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS
49: SELECT course_type
50: FROM IGS_AS_COURSE_TYPE
51: WHERE ass_id = cp_ass_id;
52: BEGIN
53: -- Set the default message number
54: p_message_name := NULL;