[Home] [Help]
780: FROM IGS_LOOKUPS_VIEW
781: WHERE lookup_type = 'CRS_ATTEMPT_STATUS'
782: AND lookup_CODE = 'DISCONTIN';
783:
784: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
785: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
786: l_return_status VARCHAR2(10);
787: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
788:
781: WHERE lookup_type = 'CRS_ATTEMPT_STATUS'
782: AND lookup_CODE = 'DISCONTIN';
783:
784: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
785: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
786: l_return_status VARCHAR2(10);
787: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
788:
789: BEGIN
1617: v_next_lapse_dt_found BOOLEAN := FALSE;
1618: v_enr_form_due_dt DATE ;
1619: v_lapsed BOOLEAN := FALSE;
1620: v_dummy VARCHAR2(1);
1621: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
1622: v_last_teaching VARCHAR2(30);
1623: CURSOR c_secc IS
1624: SELECT secc.lapse_dt_alias
1625: FROM IGS_EN_CAL_CONF secc
1626: WHERE secc.s_control_num = 1;
1627: CURSOR c_ci IS
1628: SELECT ci.start_dt,
1629: ci.end_dt
1630: FROM IGS_CA_INST ci
1631: WHERE ci.cal_type = p_acad_cal_type AND
1632: ci.sequence_number = p_acad_sequence_number;
1633: v_ci_rec c_ci%ROWTYPE;
1634: CURSOR c_daiv (p_cal_type VARCHAR2, p_seq_num NUMBER)IS
1683: scae.cal_type,
1684: scae.ci_sequence_number,
1685: scae.enr_form_due_dt
1686: FROM IGS_AS_SC_ATMPT_ENR scae,
1687: IGS_CA_INST ci
1688: WHERE scae.person_id = cp_person_id AND
1689: scae.course_cd = cp_course_cd AND
1690: ci.cal_type = scae.cal_type AND
1691: ci.sequence_number = scae.ci_sequence_number AND
1697: SELECT ci.alternate_code,
1698: sua.cal_type,
1699: sua.ci_sequence_number
1700: FROM IGS_EN_SU_ATTEMPT sua,
1701: IGS_CA_INST ci
1702: WHERE sua.person_id = cp_person_id AND
1703: sua.course_cd = cp_course_cd AND
1704: sua.unit_attempt_status IN (cst_enrolled,cst_discontin,cst_completed) AND
1705: sua.ci_start_dt <= TRUNC(SYSDATE) AND
1718: FOR UPDATE NOWAIT;
1719: v_sca_exists c_sca%ROWTYPE;
1720:
1721: CURSOR c_teachLoad(cp_cal_type VARCHAR2, cp_ci_sequence_number NUMBER) IS
1722: SELECT start_dt, end_dt FROM IGS_CA_INST_ALL
1723: WHERE cal_type = cp_cal_type AND
1724: sequence_number = cp_ci_sequence_number;
1725: v_teachload_rec c_teachload%ROWTYPE;
1726: v_trm_or_tch_start_date DATE;
3145: v_message_name VARCHAR2(30);
3146: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
3147: v_change_made BOOLEAN;
3148: PROCEDURE enrpl_upd_invalid_ua(
3149: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3150: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3151: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3152: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3153: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3146: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
3147: v_change_made BOOLEAN;
3148: PROCEDURE enrpl_upd_invalid_ua(
3149: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3150: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3151: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3152: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3153: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3154: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS
3422: App_Exception.Raise_Exception;*/
3423: END enrpl_upd_invalid_ua;
3424:
3425: PROCEDURE enrpl_upd_enrolled_ua(
3426: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3427: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3428: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3429: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3430: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3423: END enrpl_upd_invalid_ua;
3424:
3425: PROCEDURE enrpl_upd_enrolled_ua(
3426: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3427: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
3428: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3429: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
3430: p_s_log_type IGS_GE_S_LOG.s_log_type%TYPE,
3431: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE) AS