APPS.IGS_EN_VAL_SUA dependencies on IGS_AV_VAL_ASU

Line 1004: igs_av_val_asu.granted_adv_standing(p_person_id,p_course_cd,NULL,

1000: WHERE asu.person_id = p_person_id AND
1001: asu.as_course_cd = p_course_cd AND
1002: asu.unit_cd = p_unit_cd AND
1003: ((asu.s_adv_stnd_recognition_type = cst_credit AND
1004: igs_av_val_asu.granted_adv_standing(p_person_id,p_course_cd,NULL,
1005: p_unit_cd,NULL,'BOTH',NULL) ='TRUE')
1006: OR
1007: (asu.s_adv_stnd_granting_status IN (cst_approved,cst_granted) AND
1008: asu.s_adv_stnd_recognition_type = cst_preclusion));

Line 1187: IF NOT igs_av_val_asu.adv_Credit_pts(p_person_id,p_course_cd,v_crs_version_number,

1183: p_unit_cd,
1184: p_un_version_number) LOOP
1185: -- Changed after academic records maitenance dld
1186: IF v_Adv_stnd.s_adv_stnd_recognition_type = cst_credit THEN
1187: IF NOT igs_av_val_asu.adv_Credit_pts(p_person_id,p_course_cd,v_crs_version_number,
1188: v_adv_stnd.unit_cd,v_adv_stnd.version_number,'BOTH',NULL,
1189: l_credits,l_s_adv_atnd_granting_status,p_message_name) THEN
1190:
1191: -- unit will still need to be studied if credit is less than 100

Line 1211: IF (IGS_AV_VAL_ASU.advp_val_as_totals (

1207: ELSIF (l_s_adv_atnd_granting_status <> cst_granted AND p_legacy <> 'Y' ) THEN
1208: -- check that course version advanced
1209: -- standing limits are not exceeded by
1210: -- approved and granted advanced standing
1211: IF (IGS_AV_VAL_ASU.advp_val_as_totals (
1212: p_person_id,
1213: p_course_cd,
1214: v_crs_version_number,
1215: TRUE, -- include approved advanced standing