eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_VAL_SUA dependencies on IGS_AV_STND_UNIT

Line 999: FROM IGS_AV_STND_UNIT asu

995: cst_credit CONSTANT VARCHAR2(10) := 'CREDIT';
996: cst_preclusion CONSTANT VARCHAR2(10) := 'PRECLUSION';
997: CURSOR c_adv IS
998: SELECT 'x'
999: FROM IGS_AV_STND_UNIT asu
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

Line 1118: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,

1114: FROM IGS_EN_STDNT_PS_ATT sca
1115: WHERE sca.person_id = cp_person_id AND
1116: sca.course_cd = cp_course_cd;
1117: CURSOR c_adv_stnd_unit_details (
1118: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1119: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1120: cp_crs_vers_num IGS_AV_STND_UNIT.as_version_number%TYPE,
1121: cp_unit_cd IGS_AV_STND_UNIT.unit_cd%TYPE,
1122: cp_un_vers_num IGS_AV_STND_UNIT.version_number%TYPE) IS

Line 1119: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,

1115: WHERE sca.person_id = cp_person_id AND
1116: sca.course_cd = cp_course_cd;
1117: CURSOR c_adv_stnd_unit_details (
1118: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1119: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1120: cp_crs_vers_num IGS_AV_STND_UNIT.as_version_number%TYPE,
1121: cp_unit_cd IGS_AV_STND_UNIT.unit_cd%TYPE,
1122: cp_un_vers_num IGS_AV_STND_UNIT.version_number%TYPE) IS
1123: SELECT unit_cd,version_number,s_adv_stnd_recognition_type

Line 1120: cp_crs_vers_num IGS_AV_STND_UNIT.as_version_number%TYPE,

1116: sca.course_cd = cp_course_cd;
1117: CURSOR c_adv_stnd_unit_details (
1118: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1119: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1120: cp_crs_vers_num IGS_AV_STND_UNIT.as_version_number%TYPE,
1121: cp_unit_cd IGS_AV_STND_UNIT.unit_cd%TYPE,
1122: cp_un_vers_num IGS_AV_STND_UNIT.version_number%TYPE) IS
1123: SELECT unit_cd,version_number,s_adv_stnd_recognition_type
1124: FROM IGS_AV_STND_UNIT asu

Line 1121: cp_unit_cd IGS_AV_STND_UNIT.unit_cd%TYPE,

1117: CURSOR c_adv_stnd_unit_details (
1118: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1119: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1120: cp_crs_vers_num IGS_AV_STND_UNIT.as_version_number%TYPE,
1121: cp_unit_cd IGS_AV_STND_UNIT.unit_cd%TYPE,
1122: cp_un_vers_num IGS_AV_STND_UNIT.version_number%TYPE) IS
1123: SELECT unit_cd,version_number,s_adv_stnd_recognition_type
1124: FROM IGS_AV_STND_UNIT asu
1125: WHERE asu.person_id = cp_person_id AND

Line 1122: cp_un_vers_num IGS_AV_STND_UNIT.version_number%TYPE) IS

1118: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,
1119: cp_course_cd IGS_AV_STND_UNIT.as_course_cd%TYPE,
1120: cp_crs_vers_num IGS_AV_STND_UNIT.as_version_number%TYPE,
1121: cp_unit_cd IGS_AV_STND_UNIT.unit_cd%TYPE,
1122: cp_un_vers_num IGS_AV_STND_UNIT.version_number%TYPE) IS
1123: SELECT unit_cd,version_number,s_adv_stnd_recognition_type
1124: FROM IGS_AV_STND_UNIT asu
1125: WHERE asu.person_id = cp_person_id AND
1126: asu.as_course_cd = cp_course_cd AND

Line 1124: FROM IGS_AV_STND_UNIT asu

1120: cp_crs_vers_num IGS_AV_STND_UNIT.as_version_number%TYPE,
1121: cp_unit_cd IGS_AV_STND_UNIT.unit_cd%TYPE,
1122: cp_un_vers_num IGS_AV_STND_UNIT.version_number%TYPE) IS
1123: SELECT unit_cd,version_number,s_adv_stnd_recognition_type
1124: FROM IGS_AV_STND_UNIT asu
1125: WHERE asu.person_id = cp_person_id AND
1126: asu.as_course_cd = cp_course_cd AND
1127: asu.as_version_number = cp_crs_vers_num AND
1128: asu.unit_cd = cp_unit_cd AND

Line 1142: l_s_adv_atnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;

1138: FROM IGS_PS_UNIT_VER uv
1139: WHERE uv.unit_cd = cp_unit_cd AND
1140: uv.version_number = cp_version_number;
1141: l_credits NUMBER;
1142: l_s_adv_atnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;
1143: BEGIN
1144: -- This function validates a IGS_EN_SU_ATTEMPT in
1145: -- relation to advanced standing units.
1146: p_message_name := null;

Line 1178: -- check for the existace of IGS_AV_STND_UNIT

1174: p_unit_cd,
1175: p_un_version_number);
1176: FETCH c_unit_version INTO v_repeatable_ind;
1177: CLOSE c_unit_version;
1178: -- check for the existace of IGS_AV_STND_UNIT
1179: FOR v_adv_stnd IN c_adv_stnd_unit_details(
1180: p_person_id,
1181: p_course_cd,
1182: v_crs_version_number,

Line 1216: '', -- IGS_AV_STND_UNIT.unit_cd

1212: p_person_id,
1213: p_course_cd,
1214: v_crs_version_number,
1215: TRUE, -- include approved advanced standing
1216: '', -- IGS_AV_STND_UNIT.unit_cd
1217: '', -- IGS_AV_STND_UNIT.version_number
1218: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1219: '', -- IGS_AV_STND_UNIT_LVL.unit_LEVEL
1220: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd

Line 1217: '', -- IGS_AV_STND_UNIT.version_number

1213: p_course_cd,
1214: v_crs_version_number,
1215: TRUE, -- include approved advanced standing
1216: '', -- IGS_AV_STND_UNIT.unit_cd
1217: '', -- IGS_AV_STND_UNIT.version_number
1218: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1219: '', -- IGS_AV_STND_UNIT_LVL.unit_LEVEL
1220: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1221: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status

Line 1218: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status

1214: v_crs_version_number,
1215: TRUE, -- include approved advanced standing
1216: '', -- IGS_AV_STND_UNIT.unit_cd
1217: '', -- IGS_AV_STND_UNIT.version_number
1218: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1219: '', -- IGS_AV_STND_UNIT_LVL.unit_LEVEL
1220: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1221: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1222: v_total_exmptn_approved,

Line 1219: '', -- IGS_AV_STND_UNIT_LVL.unit_LEVEL

1215: TRUE, -- include approved advanced standing
1216: '', -- IGS_AV_STND_UNIT.unit_cd
1217: '', -- IGS_AV_STND_UNIT.version_number
1218: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1219: '', -- IGS_AV_STND_UNIT_LVL.unit_LEVEL
1220: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1221: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1222: v_total_exmptn_approved,
1223: v_total_exmptn_granted,

Line 1220: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd

1216: '', -- IGS_AV_STND_UNIT.unit_cd
1217: '', -- IGS_AV_STND_UNIT.version_number
1218: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1219: '', -- IGS_AV_STND_UNIT_LVL.unit_LEVEL
1220: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1221: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1222: v_total_exmptn_approved,
1223: v_total_exmptn_granted,
1224: v_total_exmptn_perc_grntd,

Line 1221: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status

1217: '', -- IGS_AV_STND_UNIT.version_number
1218: '', -- IGS_AV_STND_UNIT.s_adv_stnd_granting_status
1219: '', -- IGS_AV_STND_UNIT_LVL.unit_LEVEL
1220: '', -- IGS_AV_STND_UNIT_LVL.exemption_institution_cd
1221: '', -- IGS_AV_STND_UNIT_LVL.s_adv_stnd_granting_status
1222: v_total_exmptn_approved,
1223: v_total_exmptn_granted,
1224: v_total_exmptn_perc_grntd,
1225: v_message_name) = FALSE) THEN