APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_FIELD_STUDY

Line 335: v_field_of_study IGS_PS_FIELD_STUDY.field_of_study%TYPE;

331: v_cv_rec IGS_PS_VER%ROWTYPE;
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;

Line 363: FROM IGS_PS_FIELD_STUDY

359: WHERE course_cd = p_course_cd AND
360: version_number = p_version_number;
361: CURSOR c_get_field_of_study IS
362: SELECT field_of_study
363: FROM IGS_PS_FIELD_STUDY
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

Line 460: -- Validate the IGS_PS_FIELD_STUDY record percentage of total 100%. Removed Code

456: v_cv_rec.responsible_ou_start_dt,
457: p_message_name) = FALSE) THEN
458: RETURN FALSE;
459: END IF;
460: -- Validate the IGS_PS_FIELD_STUDY record percentage of total 100%. Removed Code
461:
462: -- Validate the IGS_PS_OWN record percentage total 100%
463: IF (IGS_PS_VAL_COw.crsp_val_cow_perc(
464: p_course_cd,

Line 521: -- validate the IGS_PS_FIELD_STUDY table and that the

517: END LOOP;
518: IF (v_terminate = TRUE) THEN
519: RETURN FALSE;
520: END IF;
521: -- validate the IGS_PS_FIELD_STUDY table and that the
522: -- IGS_PS_FLD_OF_STUDY is not closed
523: FOR fos_rec IN c_get_field_of_study LOOP
524: IF (IGS_PS_VAL_CFOS.crsp_val_cfos_fos(
525: fos_rec.field_of_study,