APPS.IGS_EN_GEN_012 dependencies on IGS_EN_DCNT_REASONCD

Line 848: v_description IGS_EN_DCNT_REASONCD.description%TYPE;

844: RETURN BOOLEAN AS
845: BEGIN
846: DECLARE
847: v_discontinuation_reason_cd IGS_EN_STDNT_PS_ATT.discontinuation_reason_cd%TYPE;
848: v_description IGS_EN_DCNT_REASONCD.description%TYPE;
849: v_administrative_unit_status IGS_EN_SU_ATTEMPT.ADMINISTRATIVE_UNIT_STATUS%TYPE;
850: v_suao_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
851: v_sca_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
852: v_alias_val DATE;

Line 920: FROM IGS_EN_DCNT_REASONCD

916: AND pv1.course_type = pv2.course_type;
917:
918: CURSOR c_unit_dcnt is
919: SELECT DISCONTINUATION_REASON_CD
920: FROM IGS_EN_DCNT_REASONCD
921: WHERE S_DISCONTINUATION_REASON_TYPE = 'UNIT_TRANS'
922: AND DCNT_UNIT_IND = 'Y'
923: AND SYS_DFLT_IND = 'Y'
924: AND CLOSED_IND = 'N';

Line 926: l_unt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;

922: AND DCNT_UNIT_IND = 'Y'
923: AND SYS_DFLT_IND = 'Y'
924: AND CLOSED_IND = 'N';
925:
926: l_unt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
927: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
928:
929: CURSOR c_dcnt_rsn IS
930: SELECT discontinuation_reason_cd

Line 927: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;

923: AND SYS_DFLT_IND = 'Y'
924: AND CLOSED_IND = 'N';
925:
926: l_unt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
927: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
928:
929: CURSOR c_dcnt_rsn IS
930: SELECT discontinuation_reason_cd
931: FROM igs_en_dcnt_reasoncd

Line 931: FROM igs_en_dcnt_reasoncd

927: l_dflt_disc_code IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE := null;
928:
929: CURSOR c_dcnt_rsn IS
930: SELECT discontinuation_reason_cd
931: FROM igs_en_dcnt_reasoncd
932: WHERE NVL(closed_ind,'N') ='N'
933: AND dflt_ind ='Y'
934: AND dcnt_unit_ind ='Y'
935: AND s_discontinuation_reason_type IS NULL;

Line 956: -- IGS_EN_DCNT_REASONCD

952: -- (this is done by table database trigger)
953: -- 2. Validate that the IGS_EN_STDNT_PS_ATT can be
954: -- discontinued
955: -- 3. Discontinue IGS_EN_STDNT_PS_ATT, setting default
956: -- IGS_EN_DCNT_REASONCD
957: -- 4. Set IGS_EN_STDNT_PS_ATT.course_attempt_status (this
958: -- is done by table database trigger).
959: --
960: -- IGS_GE_NOTE : This process will be called to the update student_