APPS.IGS_PS_VAL_UV dependencies on IGS_EN_SU_ATTEMPT

Line 866: FROM IGS_EN_SU_ATTEMPT sua

862: v_uas2_discontin BOOLEAN := FALSE;
863: NO_AUSL_RECORD_FOUND EXCEPTION;
864: CURSOR c_sua1 IS
865: SELECT DISTINCT sua.unit_attempt_status
866: FROM IGS_EN_SU_ATTEMPT sua
867: WHERE sua.unit_cd = p_unit_cd AND
868: sua.version_number = p_version_number AND
869: (sua.unit_attempt_status IN (cst_enrolled,cst_completed) OR
870: (sua.unit_attempt_status = cst_discontin AND

Line 886: FROM IGS_EN_SU_ATTEMPT sua

882: (sua.override_enrolled_cp IS NOT NULL OR
883: sua.override_achievable_cp IS NOT NULL);
884: CURSOR c_sua2 IS
885: SELECT sua.unit_attempt_status
886: FROM IGS_EN_SU_ATTEMPT sua
887: WHERE sua.unit_cd = p_unit_cd AND
888: sua.version_number = p_version_number AND
889: (sua.unit_attempt_status IN (cst_enrolled,cst_completed) OR
890: (sua.unit_attempt_status = cst_discontin AND

Line 1044: FROM IGS_EN_SU_ATTEMPT sua,

1040: cst_pass CONSTANT VARCHAR2(4) := 'PASS';
1041: v_x VARCHAR2(1);
1042: CURSOR c_uv_dsc_ovrd IS
1043: SELECT 'x'
1044: FROM IGS_EN_SU_ATTEMPT sua,
1045: IGS_AS_SU_STMPTOUT suao,
1046: IGS_AS_GRD_SCH_GRADE gsg
1047: WHERE sua.unit_cd = p_unit_cd AND
1048: sua.version_number = p_version_number AND

Line 1119: FROM IGS_EN_SU_ATTEMPT sua

1115: v_sua_enrolled BOOLEAN := FALSE;
1116: v_sua_inv_unc BOOLEAN := FALSE;
1117: CURSOR c_sua IS
1118: SELECT DISTINCT sua.unit_attempt_status
1119: FROM IGS_EN_SU_ATTEMPT sua
1120: WHERE sua.unit_cd = p_unit_cd AND
1121: sua.version_number = p_version_number AND
1122: sua.unit_attempt_status in (cst_enrolled, cst_unconfirm, cst_invalid);
1123: BEGIN

Line 1159: -- Validate if students have IGS_EN_SU_ATTEMPT IGS_PE_TITLE override set

1155: IGS_GE_MSG_STACK.ADD;
1156: App_Exception.Raise_Exception;
1157: END crsp_val_uv_end;
1158: --
1159: -- Validate if students have IGS_EN_SU_ATTEMPT IGS_PE_TITLE override set
1160: FUNCTION crsp_val_uv_ttl_ovrd(
1161: p_unit_cd IN VARCHAR2 ,
1162: p_version_number IN NUMBER ,
1163: p_title_override_ind IN VARCHAR2 ,

Line 1173: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := NULL;

1169: cst_enrolled CONSTANT VARCHAR(10) := 'ENROLLED';
1170: cst_completed CONSTANT VARCHAR(10) := 'COMPLETED';
1171: cst_discontin CONSTANT VARCHAR(10) := 'DISCONTIN';
1172: v_unit_attempt_status
1173: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := NULL;
1174: CURSOR c_sua IS
1175: SELECT sua.unit_attempt_status
1176: FROM IGS_EN_SU_ATTEMPT sua
1177: WHERE sua.unit_cd = p_unit_cd AND

Line 1176: FROM IGS_EN_SU_ATTEMPT sua

1172: v_unit_attempt_status
1173: IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := NULL;
1174: CURSOR c_sua IS
1175: SELECT sua.unit_attempt_status
1176: FROM IGS_EN_SU_ATTEMPT sua
1177: WHERE sua.unit_cd = p_unit_cd AND
1178: sua.version_number = p_version_number AND
1179: sua.unit_attempt_status IN (
1180: cst_enrolled,