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_EN_SU_ATTEMPT

Line 370: FROM igs_ca_inst_rel cir, igs_en_su_attempt_all sua

366:
367:
368: CURSOR c_acad IS
369: SELECT DISTINCT cir.sup_cal_type acad_cal_type, cir.sup_ci_sequence_number acad_ci_sequence_number
370: FROM igs_ca_inst_rel cir, igs_en_su_attempt_all sua
371: WHERE sua.cal_type = cir.sub_cal_type
372: AND sua.ci_sequence_number = cir.sub_ci_sequence_number
373: AND sua.person_id = p_person_id
374: AND sua.course_cd = p_course_cd

Line 390: IGS_EN_SU_ATTEMPT_all sua1,

386: sua2.no_assessment_ind,
387: loadcal.cal_type ci_cal_type,
388: loadcal.sequence_number ci_sequence_number
389: FROM
390: IGS_EN_SU_ATTEMPT_all sua1,
391: IGS_EN_SU_ATTEMPT_all sua2 ,
392: IGS_PS_UNIT_VER_ALL uv1,
393: IGS_PS_UNIT_VER_ALL uv2,
394: IGS_CA_INST_ALL loadcal,

Line 391: IGS_EN_SU_ATTEMPT_all sua2 ,

387: loadcal.cal_type ci_cal_type,
388: loadcal.sequence_number ci_sequence_number
389: FROM
390: IGS_EN_SU_ATTEMPT_all sua1,
391: IGS_EN_SU_ATTEMPT_all sua2 ,
392: IGS_PS_UNIT_VER_ALL uv1,
393: IGS_PS_UNIT_VER_ALL uv2,
394: IGS_CA_INST_ALL loadcal,
395: IGS_CA_INST_REL acadterm,

Line 629: -- This modules validates the update of IGS_EN_SU_ATTEMPT in relation to

625: -- ckasu 21-Dec-2004 modified procedure inorder to as a part of bug# 4080883
626: -- ctyagi 29-Sept-2005 modified cursor c_sut for bug# 4524765
627: -------------------------------------------------------------------------------------------
628: BEGIN -- enrp_val_sua_update
629: -- This modules validates the update of IGS_EN_SU_ATTEMPT in relation to
630: -- unit_attempt_status.
631: DECLARE
632: CURSOR c_sut IS
633: SELECT 'X'

Line 656: FROM igs_en_su_attempt sua

652: WHERE sca.person_id = p_person_id AND
653: sca.course_cd = p_course_cd;
654: CURSOR c_old_sua_attr IS
655: SELECT sua.unit_attempt_status
656: FROM igs_en_su_attempt sua
657: WHERE sua.person_id = p_person_id AND
658: sua.course_cd = p_course_cd AND
659: sua.uoo_id = p_uoo_id;
660: l_old_unit_status igs_en_su_attempt.unit_attempt_status%TYPE;

Line 660: l_old_unit_status igs_en_su_attempt.unit_attempt_status%TYPE;

656: FROM igs_en_su_attempt sua
657: WHERE sua.person_id = p_person_id AND
658: sua.course_cd = p_course_cd AND
659: sua.uoo_id = p_uoo_id;
660: l_old_unit_status igs_en_su_attempt.unit_attempt_status%TYPE;
661:
662: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
663: v_sut_found VARCHAR2(1) := NULL;
664: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';

Line 797: -- This module validates that IGS_EN_SU_ATTEMPT.override_credit_reason

793: p_message_name OUT NOCOPY varchar2 )
794: RETURN BOOLEAN AS
795:
796: BEGIN -- enrp_val_sua_cp_rsn
797: -- This module validates that IGS_EN_SU_ATTEMPT.override_credit_reason
798: -- only exists if one of IGS_EN_STDNT_PS_ATT.override_enrolled_cp or
799: -- IGS_EN_STDNT_PS_ATT.override_achievalble_cp exists.
800: BEGIN
801: p_message_name := null;

Line 842: -- IGS_EN_SU_ATTEMPT.

838: RETURN BOOLEAN AS
839:
840: BEGIN -- enrp_val_sua_ci
841: -- This module validates that the teaching period is valid for the
842: -- IGS_EN_SU_ATTEMPT.
843: -- * Teaching period must start after the commencement date of the
844: -- IGS_EN_STDNT_PS_ATT.
845: DECLARE
846: CURSOR c_ci IS

Line 1144: -- This function validates a IGS_EN_SU_ATTEMPT in

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;
1147: -- validate the input parameters
1148: IF (p_person_id IS NULL OR

Line 1277: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1273: SELECT sgcc.census_dt_alias
1274: FROM IGS_GE_S_GEN_CAL_CON sgcc
1275: WHERE sgcc.s_control_num = 1;
1276: CURSOR c_sci_details
1277: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1278: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1279: SELECT sci.start_dt,
1280: sci.end_dt,
1281: sci.cond_return_flag , sci.logical_delete_date

Line 1278: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

1274: FROM IGS_GE_S_GEN_CAL_CON sgcc
1275: WHERE sgcc.s_control_num = 1;
1276: CURSOR c_sci_details
1277: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1278: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1279: SELECT sci.start_dt,
1280: sci.end_dt,
1281: sci.cond_return_flag , sci.logical_delete_date
1282: FROM IGS_EN_STDNT_PS_INTM sci,

Line 1291: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1287: eit.intermission_type = sci.intermission_type AND
1288: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY');
1289:
1290: CURSOR c_daiv_details
1291: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1292: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1293: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,

Line 1292: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

1288: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY');
1289:
1290: CURSOR c_daiv_details
1291: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1292: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1293: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,
1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE,

Line 1293: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

1289:
1290: CURSOR c_daiv_details
1291: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1292: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1293: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,
1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE,
1297: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE,

Line 1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

1290: CURSOR c_daiv_details
1291: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1292: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1293: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,
1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE,
1297: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE,
1298: cp_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,

Line 1423: -- IGS_EN_SU_ATTEMPT.administrative_unit_status

1419: FROM IGS_AD_ADM_UNIT_STAT
1420: WHERE administrative_unit_status = p_administrative_unit_status;
1421: BEGIN
1422: -- This module validates the
1423: -- IGS_EN_SU_ATTEMPT.administrative_unit_status
1424: p_message_name := null;
1425: -- Validate no administrative unit status
1426: OPEN c_aus;
1427: FETCH c_aus INTO v_closed_ind, v_unit_attempt_status;

Line 1676: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;

1672: DECLARE
1673:
1674: v_ausg_count NUMBER;
1675: v_dummy VARCHAR2 (1);
1676: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;
1677:
1678: CURSOR c_no_ass_ind IS
1679: SELECT no_assessment_ind
1680: FROM igs_en_su_attempt

Line 1680: FROM igs_en_su_attempt

1676: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;
1677:
1678: CURSOR c_no_ass_ind IS
1679: SELECT no_assessment_ind
1680: FROM igs_en_su_attempt
1681: WHERE person_id = p_person_id
1682: AND course_cd = p_course_cd
1683: AND uoo_id = p_uoo_id;
1684:

Line 1687: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS

1683: AND uoo_id = p_uoo_id;
1684:
1685: CURSOR c_ausg_exists
1686: (cp_admin_unit_status
1687: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE) IS
1688: SELECT 'X'
1689: FROM IGS_AD_ADM_UT_STA_GD ausg
1690: WHERE ausg.administrative_unit_status = cp_admin_unit_status;
1691:

Line 1693: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,

1689: FROM IGS_AD_ADM_UT_STA_GD ausg
1690: WHERE ausg.administrative_unit_status = cp_admin_unit_status;
1691:
1692: CURSOR c_ausg_count
1693: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1694: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
1695: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1696: SELECT COUNT(*)
1697: FROM igs_ad_adm_ut_sta_gd ausg,

Line 1695: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS

1691:
1692: CURSOR c_ausg_count
1693: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1694: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
1695: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1696: SELECT COUNT(*)
1697: FROM igs_ad_adm_ut_sta_gd ausg,
1698: igs_as_grd_schema gs,
1699: igs_as_grd_sch_grade gsg

Line 1715: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,

1711: ( gsg.s_result_type <> 'AUDIT' AND cp_no_assessment_ind <> 'Y')
1712: );
1713:
1714: CURSOR c_ausg
1715: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1716: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
1717: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1718: SELECT ausg.grading_schema_cd,
1719: ausg.version_number,

Line 1717: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS

1713:
1714: CURSOR c_ausg
1715: (cp_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1716: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE,
1717: cp_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE) IS
1718: SELECT ausg.grading_schema_cd,
1719: ausg.version_number,
1720: ausg.grade
1721: FROM igs_ad_adm_ut_sta_gd ausg,

Line 1740: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,

1736: );
1737:
1738: CURSOR c_sua_ausg
1739: (cp_admin_unit_status
1740: IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE,
1741: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE) IS
1742: SELECT ausg.grading_schema_cd,
1743: ausg.version_number,
1744: ausg.grade

Line 1745: FROM IGS_EN_SU_ATTEMPT sua,

1741: cp_effective_dt IGS_AS_GRD_SCHEMA.start_dt%TYPE) IS
1742: SELECT ausg.grading_schema_cd,
1743: ausg.version_number,
1744: ausg.grade
1745: FROM IGS_EN_SU_ATTEMPT sua,
1746: IGS_PS_UNIT_OFR_OPT uoo,
1747: IGS_AD_ADM_UT_STA_GD ausg,
1748: IGS_AS_GRD_SCHEMA gs,
1749: igs_as_grd_sch_grade gsg

Line 1904: -- the IGS_EN_SU_ATTEMPT

1900: WHERE person_id = p_person_id AND
1901: course_cd = p_course_cd;
1902: BEGIN
1903: -- This module validates the discontinued_dt from
1904: -- the IGS_EN_SU_ATTEMPT
1905: p_message_name := null;
1906:
1907: -- This validation should not be done for dropped unit attempts
1908: -- which are being enrolled again. The administrative status

Line 2024: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

2020: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
2021: v_sca_details IGS_EN_STDNT_PS_ATT%ROWTYPE;
2022:
2023: CURSOR c_sca_details (
2024: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2025: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
2026: SELECT *
2027: FROM IGS_EN_STDNT_PS_ATT
2028: WHERE person_id = cp_person_id AND

Line 2025: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

2021: v_sca_details IGS_EN_STDNT_PS_ATT%ROWTYPE;
2022:
2023: CURSOR c_sca_details (
2024: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2025: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
2026: SELECT *
2027: FROM IGS_EN_STDNT_PS_ATT
2028: WHERE person_id = cp_person_id AND
2029: course_cd = cp_course_cd;

Line 2031: -- Validate that the IGS_EN_SU_ATTEMPT.enrolled_dt must be set

2027: FROM IGS_EN_STDNT_PS_ATT
2028: WHERE person_id = cp_person_id AND
2029: course_cd = cp_course_cd;
2030: BEGIN
2031: -- Validate that the IGS_EN_SU_ATTEMPT.enrolled_dt must be set
2032: -- for all unit attempt statuses with the exception of UNCONFIRM
2033: -- Validate that IGS_EN_SU_ATTEMPT.enrolled_dt >=
2034: -- IGS_EN_STDNT_PS_ATT.commencement_dt.
2035: -- Validate that the student unit attempt enrolled date must

Line 2033: -- Validate that IGS_EN_SU_ATTEMPT.enrolled_dt >=

2029: course_cd = cp_course_cd;
2030: BEGIN
2031: -- Validate that the IGS_EN_SU_ATTEMPT.enrolled_dt must be set
2032: -- for all unit attempt statuses with the exception of UNCONFIRM
2033: -- Validate that IGS_EN_SU_ATTEMPT.enrolled_dt >=
2034: -- IGS_EN_STDNT_PS_ATT.commencement_dt.
2035: -- Validate that the student unit attempt enrolled date must
2036: -- be set for all unit attempt statuses, with the exception
2037: -- of UNCONFIRM.

Line 2126: --kkillams 28-04-2003 Removed the cur_uoo_IGS_EN_SU_ATTEMPT cursor and it's references

2122: p_uoo_id IN NUMBER)
2123: -------------------------------------------------------------------------------------------
2124: --Change History:
2125: --Who When What
2126: --kkillams 28-04-2003 Removed the cur_uoo_IGS_EN_SU_ATTEMPT cursor and it's references
2127: -- and modified the c_sut cursor where clause w.r.t. bug number 2829262
2128: -------------------------------------------------------------------------------------------
2129: RETURN BOOLEAN AS
2130: gv_other_details VARCHAR2(255);

Line 2132: -- Validate the deletion of a IGS_EN_SU_ATTEMPT

2128: -------------------------------------------------------------------------------------------
2129: RETURN BOOLEAN AS
2130: gv_other_details VARCHAR2(255);
2131: BEGIN -- enrp_val_sua_delete
2132: -- Validate the deletion of a IGS_EN_SU_ATTEMPT
2133: DECLARE
2134: cst_duplicate IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';

Line 2134: cst_duplicate IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';

2130: gv_other_details VARCHAR2(255);
2131: BEGIN -- enrp_val_sua_delete
2132: -- Validate the deletion of a IGS_EN_SU_ATTEMPT
2133: DECLARE
2134: cst_duplicate IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
2137: cst_unconfirmed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
2138: cst_enrolled IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

Line 2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';

2131: BEGIN -- enrp_val_sua_delete
2132: -- Validate the deletion of a IGS_EN_SU_ATTEMPT
2133: DECLARE
2134: cst_duplicate IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
2137: cst_unconfirmed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
2138: cst_enrolled IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
2139: cst_invalid IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';

Line 2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';

2132: -- Validate the deletion of a IGS_EN_SU_ATTEMPT
2133: DECLARE
2134: cst_duplicate IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
2137: cst_unconfirmed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
2138: cst_enrolled IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
2139: cst_invalid IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
2140: v_del_alwd_dt DATE := NULL;

Line 2137: cst_unconfirmed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';

2133: DECLARE
2134: cst_duplicate IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
2137: cst_unconfirmed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
2138: cst_enrolled IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
2139: cst_invalid IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
2140: v_del_alwd_dt DATE := NULL;
2141: CURSOR c_sca IS

Line 2138: cst_enrolled IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

2134: cst_duplicate IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
2137: cst_unconfirmed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
2138: cst_enrolled IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
2139: cst_invalid IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
2140: v_del_alwd_dt DATE := NULL;
2141: CURSOR c_sca IS
2142: SELECT course_rqrmnt_complete_ind

Line 2139: cst_invalid IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';

2135: cst_discontinued IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
2136: cst_completed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
2137: cst_unconfirmed IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
2138: cst_enrolled IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
2139: cst_invalid IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
2140: v_del_alwd_dt DATE := NULL;
2141: CURSOR c_sca IS
2142: SELECT course_rqrmnt_complete_ind
2143: FROM IGS_EN_STDNT_PS_ATT

Line 2210: -- to the pk of igs_en_su_attempt and passed to IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD

2206: v_del_alwd_dt := p_effective_dt;
2207: END IF;
2208: --Modified as a part of Enrollment Process build bug no:1832130
2209: -- Sarakshi , 27-07-2001,one cursor is opened to fetch the uoo_id corresponding
2210: -- to the pk of igs_en_su_attempt and passed to IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD
2211: IF IGS_EN_GEN_008.ENRP_GET_UA_DEL_ALWD(
2212: p_cal_type,
2213: p_ci_sequence_number,
2214: v_del_alwd_dt,

Line 2226: -- to the pk of igs_en_su_attempt and passed to igs_en_gen_008.enrp_get_var_window

2222: --- record can only be deleted in the record enrolments time frame.
2223: IF p_unit_attempt_status = cst_enrolled THEN
2224: --Modified as a part of Enrollment Process build bug no:1832130
2225: -- Sarakshi , 27-07-2001,one cursor is opened to fetch the uoo_id corresponding
2226: -- to the pk of igs_en_su_attempt and passed to igs_en_gen_008.enrp_get_var_window
2227:
2228: -- Modified the Next IF logic as per the Bug# 2356997. Made the
2229: -- call to the igs_en_gen_008.enrp_get_var_window instead of IGS_EN_GEN_004.ENRP_GET_REC_WINDOW
2230: IF igs_en_gen_008.enrp_get_var_window(

Line 2419: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

2415: AND ci_sequence_number = p_ci_sequence_number
2416: AND location_cd = p_location_cd
2417: AND unit_class = p_unit_class;
2418:
2419: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
2420: v_sca_rec c_sca%ROWTYPE;
2421: v_return_val BOOLEAN := FALSE;
2422: v_message_name varchar2(30);
2423: v_duplicate_course_cd VARCHAR2(6);

Line 2663: CURSOR c_get_teach_cal_dtls(cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

2659: cst_cross CONSTANT VARCHAR2(10) := 'CROSS';
2660: cst_superior CONSTANT VARCHAR2(10) := 'SUPERIOR';
2661: v_message_name varchar2(30);
2662:
2663: CURSOR c_get_teach_cal_dtls(cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2664: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2665: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
2666: SELECT cal_type,ci_sequence_number
2667: FROM IGS_EN_SU_ATTEMPT

Line 2664: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

2660: cst_superior CONSTANT VARCHAR2(10) := 'SUPERIOR';
2661: v_message_name varchar2(30);
2662:
2663: CURSOR c_get_teach_cal_dtls(cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2664: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2665: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
2666: SELECT cal_type,ci_sequence_number
2667: FROM IGS_EN_SU_ATTEMPT
2668: WHERE person_id = cp_person_id AND

Line 2665: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

2661: v_message_name varchar2(30);
2662:
2663: CURSOR c_get_teach_cal_dtls(cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2664: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2665: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
2666: SELECT cal_type,ci_sequence_number
2667: FROM IGS_EN_SU_ATTEMPT
2668: WHERE person_id = cp_person_id AND
2669: course_cd = cp_course_cd AND

Line 2667: FROM IGS_EN_SU_ATTEMPT

2663: CURSOR c_get_teach_cal_dtls(cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2664: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2665: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
2666: SELECT cal_type,ci_sequence_number
2667: FROM IGS_EN_SU_ATTEMPT
2668: WHERE person_id = cp_person_id AND
2669: course_cd = cp_course_cd AND
2670: uoo_id = cp_uoo_id;
2671:

Line 3121: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS

3117: FROM IGS_PS_OFR_OPT
3118: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3119: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3120: CURSOR c_unit_class(
3121: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
3122: SELECT unit_mode
3123: FROM IGS_AS_UNIT_CLASS
3124: WHERE IGS_AS_UNIT_CLASS.unit_class = cp_unit_class AND IGS_AS_UNIT_CLASS.closed_ind = 'N';
3125: CURSOR c_unit_mode(

Line 3230: CURSOR c_sua(cp_location_cd IGS_EN_SU_ATTEMPT.LOCATION_CD%TYPE,

3226: WHERE daiv.cal_type = cp_cal_type AND
3227: daiv.ci_sequence_number = cp_ci_sequence_number AND
3228: daiv.dt_alias = sgcc.census_dt_alias AND
3229: sgcc.s_control_num = 1;
3230: CURSOR c_sua(cp_location_cd IGS_EN_SU_ATTEMPT.LOCATION_CD%TYPE,
3231: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE)IS
3232: SELECT sua.course_cd,
3233: sua.cal_type,
3234: sua.ci_sequence_number,

Line 3231: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE)IS

3227: daiv.ci_sequence_number = cp_ci_sequence_number AND
3228: daiv.dt_alias = sgcc.census_dt_alias AND
3229: sgcc.s_control_num = 1;
3230: CURSOR c_sua(cp_location_cd IGS_EN_SU_ATTEMPT.LOCATION_CD%TYPE,
3231: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE)IS
3232: SELECT sua.course_cd,
3233: sua.cal_type,
3234: sua.ci_sequence_number,
3235: sua.unit_attempt_status,

Line 3237: FROM IGS_EN_SU_ATTEMPT sua

3233: sua.cal_type,
3234: sua.ci_sequence_number,
3235: sua.unit_attempt_status,
3236: sua.uoo_id
3237: FROM IGS_EN_SU_ATTEMPT sua
3238: WHERE sua.person_id = p_person_id AND
3239: sua.unit_cd = p_unit_cd AND
3240: sua.version_number = p_uv_version_number AND
3241: sua.location_cd = cp_location_cd AND

Line 3252: FROM IGS_EN_SU_ATTEMPT sua

3248: cst_discontin);
3249: CURSOR c_sua_d IS
3250: SELECT sua.location_cd,
3251: sua.unit_class
3252: FROM IGS_EN_SU_ATTEMPT sua
3253: WHERE sua.person_id = p_person_id AND
3254: sua.course_cd = p_course_cd AND
3255: sua.uoo_id = p_uoo_id;
3256: CURSOR c_sct (

Line 3288: v_duplicate_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;

3284: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
3285: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
3286: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
3287: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
3288: v_duplicate_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
3289: BEGIN
3290: -- Set the default message number and duplicate course code
3291: p_message_name := null;
3292: p_duplicate_course_cd := NULL;

Line 3718: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo

3714: l_check_sup NUMBER(1);
3715:
3716: CURSOR cur_sub_sua IS
3717: SELECT sua.uoo_id sub_uoo_id
3718: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo
3719: WHERE sua.person_id = p_person_id AND
3720: sua.course_cd = p_course_cd AND
3721: sua.uoo_id = uoo.uoo_id AND
3722: uoo.sup_uoo_id = p_uoo_id AND

Line 3894: FROM igs_en_su_attempt

3890:
3891: CURSOR c_mus_allowed (cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_unit_cd VARCHAR2,
3892: cp_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_uoo_id NUMBER) IS
3893: SELECT 'x'
3894: FROM igs_en_su_attempt
3895: WHERE person_id=cp_person_id AND
3896: course_cd=cp_course_cd AND
3897: unit_cd=cp_unit_cd AND
3898: cal_type=cp_cal_type AND

Line 3912: FROM igs_en_su_attempt sua,

3908: CURSOR c_mus_participate (cp_not_multiple_section_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE,
3909: cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_unit_cd VARCHAR2,
3910: cp_cal_type VARCHAR2, cp_ci_sequence_number NUMBER, cp_uoo_id NUMBER) IS
3911: SELECT 'x'
3912: FROM igs_en_su_attempt sua,
3913: igs_ps_unit_ofr_opt opt
3914: WHERE sua.person_id=cp_person_id AND
3915: sua.course_cd=cp_course_cd AND
3916: sua.unit_cd=cp_unit_cd AND

Line 3924: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;

3920: sua.uoo_id<> cp_uoo_id AND
3921: sua.uoo_id=opt.uoo_id AND
3922: opt.not_multiple_section_flag=cp_not_multiple_section_flag;
3923:
3924: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
3925: l_unit_ver igs_en_su_attempt.version_number%TYPE;
3926: l_cal_type igs_en_su_attempt.cal_type%TYPE;
3927: l_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
3928: l_same_teaching_period igs_ps_unit_ver.same_teaching_period%TYPE;

Line 3925: l_unit_ver igs_en_su_attempt.version_number%TYPE;

3921: sua.uoo_id=opt.uoo_id AND
3922: opt.not_multiple_section_flag=cp_not_multiple_section_flag;
3923:
3924: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
3925: l_unit_ver igs_en_su_attempt.version_number%TYPE;
3926: l_cal_type igs_en_su_attempt.cal_type%TYPE;
3927: l_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
3928: l_same_teaching_period igs_ps_unit_ver.same_teaching_period%TYPE;
3929: l_usec_exclude_mus_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;

Line 3926: l_cal_type igs_en_su_attempt.cal_type%TYPE;

3922: opt.not_multiple_section_flag=cp_not_multiple_section_flag;
3923:
3924: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
3925: l_unit_ver igs_en_su_attempt.version_number%TYPE;
3926: l_cal_type igs_en_su_attempt.cal_type%TYPE;
3927: l_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
3928: l_same_teaching_period igs_ps_unit_ver.same_teaching_period%TYPE;
3929: l_usec_exclude_mus_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;
3930: l_notused VARCHAR2(1);

Line 3927: l_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;

3923:
3924: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
3925: l_unit_ver igs_en_su_attempt.version_number%TYPE;
3926: l_cal_type igs_en_su_attempt.cal_type%TYPE;
3927: l_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
3928: l_same_teaching_period igs_ps_unit_ver.same_teaching_period%TYPE;
3929: l_usec_exclude_mus_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;
3930: l_notused VARCHAR2(1);
3931: