APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_CATEGORISE

Line 336: v_course_cat IGS_PS_CATEGORISE.course_cat%TYPE;

332: v_award_cd IGS_PS_AWARD.award_cd%TYPE;
333: v_funding_source IGS_FI_FND_SRC_RSTN.funding_source%TYPE;
334: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
335: v_field_of_study IGS_PS_FIELD_STUDY.field_of_study%TYPE;
336: v_course_cat IGS_PS_CATEGORISE.course_cat%TYPE;
337: v_s_course_status IGS_PS_STAT.s_course_status%TYPE;
338: v_terminate BOOLEAN := FALSE;
339: v_coo_exist BOOLEAN := FALSE;
340: CURSOR c_course_version IS

Line 368: FROM IGS_PS_CATEGORISE

364: WHERE course_cd = p_course_cd AND
365: version_number = p_version_number;
366: CURSOR c_get_course_cat IS
367: SELECT course_cat
368: FROM IGS_PS_CATEGORISE
369: WHERE course_cd = p_course_cd AND
370: version_number = p_version_number;
371: CURSOR c_get_reference_cd_type IS
372: SELECT reference_cd_type

Line 534: -- Validate the IGS_PS_CATEGORISE table and

530: END LOOP;
531: IF (v_terminate = TRUE) THEN
532: RETURN FALSE;
533: END IF;
534: -- Validate the IGS_PS_CATEGORISE table and
535: -- that IGS_PS_CAT is not closed
536: FOR cc_rec IN c_get_course_cat LOOP
537: IF (IGS_PS_VAL_CRC.crsp_val_crc_crs_cat(
538: cc_rec.course_cat,