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_PR_GEN_004 dependencies on IGS_EN_STDNT_PS_ATT

Line 6: --sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

2: /* $Header: IGSPR25B.pls 120.5 2006/02/08 02:52:18 sepalani ship $ */
3: --------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
7: --
8: --nalkumar 19-NOV-2002 Bug NO: 2658550
9: -- Modified this object as per the FA110 PR Enh.
10: --svenkata 20-NOV-2002 Modified the call to the function igs_en_val_sua.enrp_val_sua_discont to add value 'N' for the parameter

Line 63: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

59: cst_progress CONSTANT VARCHAR2(10) := 'PROGRESS';
60: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
61: cst_todo CONSTANT VARCHAR2(10) := 'TODO';
62: cst_prg_check CONSTANT VARCHAR2(10) := 'PRG_CHECK';
63: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
64: v_sequence_number NUMBER;
65: v_insert_todo BOOLEAN DEFAULT FALSE;
66: v_start_dt DATE;
67: v_cutoff_dt DATE;

Line 70: FROM IGS_EN_STDNT_PS_ATT sca

66: v_start_dt DATE;
67: v_cutoff_dt DATE;
68: CURSOR c_sca IS
69: SELECT sca.version_number
70: FROM IGS_EN_STDNT_PS_ATT sca
71: WHERE sca.person_id = p_person_id AND
72: sca.course_cd = p_course_cd;
73: CURSOR c_cir IS
74: SELECT cir.sup_cal_type,

Line 106: -- If version number not passed then load it from IGS_EN_STDNT_PS_ATT

102: NVL(p_new_finalised_outcome_ind, ' ') THEN
103: -- No changes made ; no update required
104: RETURN;
105: END IF;
106: -- If version number not passed then load it from IGS_EN_STDNT_PS_ATT
107: -- record
108: IF p_version_number IS NULL THEN
109: OPEN c_sca;
110: FETCH c_sca INTO v_version_number;

Line 361: IGS_EN_STDNT_PS_ATT sca,

357: sca.course_attempt_status,
358: sca.discontinuation_reason_cd
359: FROM IGS_PR_STDNT_PR_OU spo,
360: IGS_PR_OU_TYPE pot,
361: IGS_EN_STDNT_PS_ATT sca,
362: IGS_PS_VER crv
363: WHERE (
364: p_spo_person_id IS NULL
365: AND

Line 407: -- such that the person has a valid student program attempt record as given in table igs_en_stdnt_ps_att

403: AND
404: crv.version_number = sca.version_number
405: AND
406: -- group_id has not been specified or if specified then take out NOCOPY person_id's for that group_id
407: -- such that the person has a valid student program attempt record as given in table igs_en_stdnt_ps_att
408: (
409: p_group_id IS NULL
410: OR
411: sca.person_id IN (

Line 523: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

519: cp_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
520: cp_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
521: cp_spo_encmb_course_group_cd
522: IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,
523: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
524: SELECT /*+INDEX(spo spo_pk)*/
525: spo.sequence_number,
526: spo.expiry_dt
527: FROM IGS_PR_STDNT_PR_OU spo,

Line 569: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

565: WHERE cgm.course_group_cd = spo.encmb_course_group_cd AND
566: cgm.course_cd = cp_course_cd AND
567: cgm.version_number = cp_sca_version_number)));
568: CURSOR c_sca1 (
569: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
570: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
571: SELECT sca.*,
572: sca.ROWID
573: FROM IGS_EN_STDNT_PS_ATT sca

Line 570: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

566: cgm.course_cd = cp_course_cd AND
567: cgm.version_number = cp_sca_version_number)));
568: CURSOR c_sca1 (
569: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
570: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
571: SELECT sca.*,
572: sca.ROWID
573: FROM IGS_EN_STDNT_PS_ATT sca
574: WHERE sca.person_id = cp_person_id AND

Line 573: FROM IGS_EN_STDNT_PS_ATT sca

569: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
570: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
571: SELECT sca.*,
572: sca.ROWID
573: FROM IGS_EN_STDNT_PS_ATT sca
574: WHERE sca.person_id = cp_person_id AND
575: sca.course_cd = cp_course_cd
576: FOR UPDATE NOWAIT;
577: CURSOR c_sca2 (

Line 588: FROM IGS_EN_STDNT_PS_ATT sca

584: sca.course_cd,
585: sca.version_number,
586: sca.course_attempt_status,
587: sca.commencement_dt
588: FROM IGS_EN_STDNT_PS_ATT sca
589: WHERE sca.person_id = cp_spo_person_id AND
590: sca.course_attempt_status IN (
591: cst_enrolled,
592: cst_inactive,

Line 619: IGS_EN_STDNT_PS_ATT sca,

615: susa.*,
616: susa.ROWID,
617: DECODE(acai.acai_ind, 'Y', 'Y', 'N') acai_ind
618: FROM
619: IGS_EN_STDNT_PS_ATT sca,
620: IGS_AS_SU_SETATMPT susa,
621: ( SELECT /*+INDEX(sca sca_pk)*/
622: sca.person_id,
623: sca.course_cd,

Line 625: FROM IGS_EN_STDNT_PS_ATT sca,

621: ( SELECT /*+INDEX(sca sca_pk)*/
622: sca.person_id,
623: sca.course_cd,
624: 'Y' acai_ind
625: FROM IGS_EN_STDNT_PS_ATT sca,
626: IGS_AD_PS_APPL_INST acai
627: WHERE sca.person_id = acai.person_id AND
628: sca.adm_admission_appl_number = acai.admission_appl_number AND
629: sca.adm_nominated_course_cd = acai.nominated_course_cd AND

Line 797: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

793:
794: PROCEDURE prgpl_ins_log_entry (
795: p_log_creation_dt IGS_GE_s_log.creation_dt%TYPE,
796: p_record_type VARCHAR2,
797: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
798: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
799: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
800: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
801: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,

Line 798: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

794: PROCEDURE prgpl_ins_log_entry (
795: p_log_creation_dt IGS_GE_s_log.creation_dt%TYPE,
796: p_record_type VARCHAR2,
797: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
798: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
799: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
800: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
801: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
802: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE,

Line 941: IGS_EN_STDNT_PS_ATT sca

937: sca.version_number,
938: spo.*,
939: spo.ROWID
940: FROM IGS_PR_STDNT_PR_OU spo,
941: IGS_EN_STDNT_PS_ATT sca
942: WHERE spo.person_id = p_person_id AND
943: spo.course_cd = p_course_cd AND
944: spo.sequence_number = p_sequence_number AND
945: spo.person_id = sca.person_id AND

Line 2419: UPDATE IGS_EN_STDNT_PS_ATT

2415: FOR v_sca_rec IN c_sca1 (
2416: v_spo_rec.person_id,
2417: v_spo_rec.course_cd) LOOP
2418: /*
2419: UPDATE IGS_EN_STDNT_PS_ATT
2420: SET discontinued_dt = NULL,
2421: discontinuation_reason_cd = NULL
2422: WHERE CURRENT OF c_sca1;
2423: */

Line 2424: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

2420: SET discontinued_dt = NULL,
2421: discontinuation_reason_cd = NULL
2422: WHERE CURRENT OF c_sca1;
2423: */
2424: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
2425: X_ROWID => v_sca_rec.ROWID,
2426: X_PERSON_ID => v_sca_rec.PERSON_ID,
2427: X_COURSE_CD => v_sca_rec.COURSE_CD,
2428: X_ADVANCED_STANDING_IND => v_sca_rec.ADVANCED_STANDING_IND,

Line 2709: v_last_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE := NULL;

2705: cst_progress CONSTANT VARCHAR2(10) := 'PROGRESS';
2706: v_recommended_outcomes INTEGER DEFAULT 0;
2707: v_approved_outcomes INTEGER DEFAULT 0;
2708: v_removed_outcomes INTEGER DEFAULT 0;
2709: v_last_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE := NULL;
2710: v_last_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE := NULL;
2711: v_log_creation_dt IGS_GE_s_log.creation_dt%TYPE;
2712: v_key IGS_GE_s_log.KEY%TYPE;
2713: v_message_name VARCHAR2(30);

Line 2710: v_last_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE := NULL;

2706: v_recommended_outcomes INTEGER DEFAULT 0;
2707: v_approved_outcomes INTEGER DEFAULT 0;
2708: v_removed_outcomes INTEGER DEFAULT 0;
2709: v_last_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE := NULL;
2710: v_last_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE := NULL;
2711: v_log_creation_dt IGS_GE_s_log.creation_dt%TYPE;
2712: v_key IGS_GE_s_log.KEY%TYPE;
2713: v_message_name VARCHAR2(30);
2714: CURSOR c_ci IS

Line 2777: p_sca_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

2773: --
2774: --
2775: --
2776: FUNCTION prgpl_upd_check_readiness (
2777: p_sca_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2778: p_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2779: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2780: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
2781: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

Line 2778: p_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

2774: --
2775: --
2776: FUNCTION prgpl_upd_check_readiness (
2777: p_sca_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2778: p_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2779: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2780: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
2781: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2782: p_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE)

Line 2779: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

2775: --
2776: FUNCTION prgpl_upd_check_readiness (
2777: p_sca_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2778: p_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2779: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2780: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
2781: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2782: p_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE)
2783: RETURN VARCHAR2

Line 2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;

2880: AND scae.ci_sequence_number = ci.sequence_number
2881: ORDER BY ci.end_dt DESC;
2882: --
2883: rec_enr_cat cur_enr_cat%ROWTYPE;
2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;
2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
2887: process_record BOOLEAN := TRUE;
2888: --

Line 2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

2881: ORDER BY ci.end_dt DESC;
2882: --
2883: rec_enr_cat cur_enr_cat%ROWTYPE;
2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;
2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN

Line 2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;

2882: --
2883: rec_enr_cat cur_enr_cat%ROWTYPE;
2884: n_person_id igs_en_stdnt_ps_att_all.person_id%TYPE;
2885: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
2886: n_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN
2890: --

Line 2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';

2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN
2890: --
2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';
2892: --
2893: -- Append Person ID Group filter to the Where clause only when it is passed
2894: --
2895: IF (p_group_id IS NOT NULL) THEN

Line 3100: IGS_EN_STDNT_PS_ATT sca

3096: str.course_cd,
3097: sca.version_number
3098: FROM IGS_PE_STD_TODO st,
3099: IGS_PE_STD_TODO_REF str,
3100: IGS_EN_STDNT_PS_ATT sca
3101: WHERE st.s_student_todo_type = cst_prg_check AND
3102: st.logical_delete_dt IS NULL AND
3103: st.person_id = str.person_id AND
3104: st.s_student_todo_type = str.s_student_todo_type AND

Line 3191: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

3187: str.s_student_todo_type = cp_s_student_todo_type AND
3188: str.sequence_number = cp_sequence_number AND
3189: str.logical_delete_dt IS NULL;
3190: CURSOR c_spc1 (
3191: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3192: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3193: SELECT spc.prg_cal_type,
3194: spc.prg_ci_sequence_number
3195: FROM IGS_PR_STDNT_PR_CK spc

Line 3192: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

3188: str.sequence_number = cp_sequence_number AND
3189: str.logical_delete_dt IS NULL;
3190: CURSOR c_spc1 (
3191: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3192: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3193: SELECT spc.prg_cal_type,
3194: spc.prg_ci_sequence_number
3195: FROM IGS_PR_STDNT_PR_CK spc
3196: WHERE spc.person_id = cp_person_id AND

Line 3201: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

3197: spc.course_cd = cp_course_cd;
3198: CURSOR c_spc2 (
3199: cp_cal_type IGS_CA_INST.cal_type%TYPE,
3200: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
3201: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3202: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3203: SELECT spc.prg_cal_type,
3204: spc.prg_ci_sequence_number
3205: FROM IGS_PR_STDNT_PR_CK spc,

Line 3202: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

3198: CURSOR c_spc2 (
3199: cp_cal_type IGS_CA_INST.cal_type%TYPE,
3200: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
3201: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3202: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3203: SELECT spc.prg_cal_type,
3204: spc.prg_ci_sequence_number
3205: FROM IGS_PR_STDNT_PR_CK spc,
3206: IGS_CA_INST ci1

Line 3546: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

3542: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
3543: v_rule_check_dt DATE DEFAULT SYSDATE;
3544: v_rolled_back BOOLEAN DEFAULT FALSE;
3545: v_sprc_insert_count INTEGER DEFAULT 0;
3546: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
3547: v_course_type IGS_PS_VER.course_type%TYPE;
3548: v_message_text IGS_RU_ITEM.value%TYPE;
3549: v_start_dt DATE;
3550: v_result_status VARCHAR2(10);

Line 3551: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

3547: v_course_type IGS_PS_VER.course_type%TYPE;
3548: v_message_text IGS_RU_ITEM.value%TYPE;
3549: v_start_dt DATE;
3550: v_result_status VARCHAR2(10);
3551: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
3552: v_dummy VARCHAR2(1);
3553: v_rules_applicable BOOLEAN DEFAULT FALSE;
3554: v_all_rules_passed BOOLEAN DEFAULT TRUE;
3555: v_rec_outcomes_applied BOOLEAN DEFAULT FALSE;

Line 3582: FROM IGS_EN_STDNT_PS_ATT sca,

3578: CURSOR c_sca_crv IS
3579: SELECT sca.course_attempt_status,
3580: sca.version_number,
3581: crv.course_type
3582: FROM IGS_EN_STDNT_PS_ATT sca,
3583: IGS_PS_VER crv
3584: WHERE sca.person_id = p_person_id AND
3585: sca.course_cd = p_course_cd AND
3586: crv.course_cd = sca.course_cd AND

Line 3672: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

3668: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
3669: p_original_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
3670: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
3671: p_apply_automatically_ind IGS_PR_RU_OU.apply_automatically_ind%TYPE,
3672: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
3673: p_rule_check_dt DATE,
3674: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE,
3675: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
3676: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,

Line 4094: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

4090: END prgpl_add_stdnt_prg_outcomes;
4091:
4092:
4093: PROCEDURE prgpl_create_outcomes (
4094: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
4095: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4096: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4097: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
4098: p_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE,

Line 4818: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

4814: END prgpl_rmv_stdnt_prg_outcomes;
4815:
4816:
4817: FUNCTION prgpl_match_att_type (
4818: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4819: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4820: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4821: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4822: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE)

Line 4819: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

4815:
4816:
4817: FUNCTION prgpl_match_att_type (
4818: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4819: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4820: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4821: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4822: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE)
4823: RETURN VARCHAR2

Line 4822: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE)

4818: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4819: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4820: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4821: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4822: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE)
4823: RETURN VARCHAR2
4824: IS
4825: BEGIN -- prgpl_match_att_type
4826: -- If the sprav.attendance_type is set, then the student must be enrolled

Line 4835: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

4831: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
4832: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
4833: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
4834: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
4835: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
4836: CURSOR c_cir IS
4837: SELECT cir.sub_cal_type,
4838: cir.sub_ci_sequence_number
4839: FROM IGS_CA_INST ci,

Line 4901: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

4897: END prgpl_match_att_type;
4898:
4899: --------------------------------------------------------------------------------
4900: FUNCTION prgpl_match_class_standing (
4901: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4902: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4903: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4904: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4905: p_igs_pr_class_std_id IGS_PR_CLASS_STD.igs_pr_class_std_id%TYPE)

Line 4902: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

4898:
4899: --------------------------------------------------------------------------------
4900: FUNCTION prgpl_match_class_standing (
4901: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4902: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4903: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4904: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4905: p_igs_pr_class_std_id IGS_PR_CLASS_STD.igs_pr_class_std_id%TYPE)
4906: RETURN VARCHAR2 AS

Line 4918: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

4914: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
4915: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
4916:
4917: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
4918: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
4919: v_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;
4920: v_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;
4921: CURSOR c_cir IS
4922: SELECT cir.sub_cal_type,

Line 5006: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

5002: END prgpl_match_class_standing;
5003:
5004:
5005: FUNCTION prgpl_match_cp_range (
5006: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5007: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5008: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
5009: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5010: p_min_cp IGS_PR_RU_APPL.min_cp%TYPE,

Line 5007: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

5003:
5004:
5005: FUNCTION prgpl_match_cp_range (
5006: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5007: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5008: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
5009: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5010: p_min_cp IGS_PR_RU_APPL.min_cp%TYPE,
5011: p_max_cp IGS_PR_RU_APPL.max_cp%TYPE)

Line 5024: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

5020: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
5021: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
5022: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
5023: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
5024: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
5025: v_earned_cp NUMBER;
5026: v_attempted_cp NUMBER;
5027: v_return_status VARCHAR2(1);
5028: v_msg_count NUMBER(2);

Line 5112: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

5108: END prgpl_match_cp_range;
5109: ---------------------------------------------------------------------------------
5110:
5111: FUNCTION prgpl_sca_apply_rules (
5112: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
5113: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5114: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
5115: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
5116: p_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE,

Line 5423: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

5419: END prgpl_sca_apply_rules;
5420:
5421:
5422: PROCEDURE prgpl_sca_process_rules (
5423: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
5424: p_course_type IGS_PS_VER.course_type%TYPE)
5425: IS
5426: BEGIN -- prgpl_sca_process_rules
5427: DECLARE

Line 5473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

5469:
5470:
5471:
5472: CURSOR c_pra_cst_sca (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5475: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5476: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5477: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,

Line 5474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

5470:
5471:
5472: CURSOR c_pra_cst_sca (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5475: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5476: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5477: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,
5478: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,

Line 5495: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

5491: AND pra.sequence_number = prctv.pra_sequence_number
5492: AND prctv.prg_cal_type = cp_cal_type;
5493:
5494: CURSOR c_pra_cst_crv (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5495: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5496: cp_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
5497: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5498: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5499: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,

Line 5517: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

5513: AND pra.sequence_number = prctv.pra_sequence_number
5514: AND prctv.prg_cal_type = cp_cal_type;
5515:
5516: CURSOR c_pra_cst_ou (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5517: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5518: cp_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
5519: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5520: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5521: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,

Line 5585: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

5581: ))
5582: );
5583:
5584: CURSOR c_pra_cst_cty (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5585: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5586: cp_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
5587: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5588: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5589: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,

Line 6311: -- Update the progression status of a IGS_EN_STDNT_PS_ATT when elements of

6307: )
6308: IS
6309: gv_other_detail VARCHAR2(255);
6310: BEGIN -- IGS_PR_upd_spo_maint
6311: -- Update the progression status of a IGS_EN_STDNT_PS_ATT when elements of
6312: -- progression no longer reflect the status. eg. A penalty has expired, a
6313: -- show cause period has expired.
6314: DECLARE
6315: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';

Line 6366: FROM IGS_EN_STDNT_PS_ATT sca

6362: SELECT sca.person_id,
6363: sca.course_cd,
6364: sca.version_number,
6365: sca.progression_status
6366: FROM IGS_EN_STDNT_PS_ATT sca
6367: WHERE sca.progression_status = cst_goodstand AND
6368: sca.course_attempt_status NOT IN ('UNCONFIRM','DELETED','COMPLETED') AND
6369: EXISTS (
6370: SELECT 'X'

Line 6407: FROM IGS_EN_STDNT_PS_ATT sca

6403: SELECT sca.person_id,
6404: sca.course_cd,
6405: sca.version_number,
6406: sca.progression_status
6407: FROM IGS_EN_STDNT_PS_ATT sca
6408: WHERE sca.progression_status = cst_undconsid AND
6409: sca.course_attempt_status NOT IN ('UNCONFIRM','DELETED','COMPLETED') AND
6410: NOT EXISTS (
6411: SELECT 'X'

Line 6421: FROM IGS_EN_STDNT_PS_ATT sca

6417: SELECT sca.person_id,
6418: sca.course_cd,
6419: sca.version_number,
6420: sca.progression_status
6421: FROM IGS_EN_STDNT_PS_ATT sca
6422: WHERE sca.progression_status = cst_showcause AND
6423: sca.course_attempt_status NOT IN ('UNCONFIRM','DELETED','COMPLETED') AND
6424: NOT EXISTS (
6425: SELECT 'X'

Line 6439: FROM IGS_EN_STDNT_PS_ATT sca

6435: SELECT sca.person_id,
6436: sca.course_cd,
6437: sca.version_number,
6438: sca.progression_status
6439: FROM IGS_EN_STDNT_PS_ATT sca
6440: WHERE sca.progression_status IN (
6441: cst_probation,
6442: cst_suspension,
6443: cst_exclusion,

Line 6569: -- progresssion statuses in the table IGS_EN_STDNT_PS_ATT and update these progression statuses suitably

6565: END IF;
6566: END LOOP; -- c_spo
6567: --Functionality for the part of the code that follows:-
6568: -- Check the decision status for record in IGS_PR_STDNT_PR_OU table and check the corresponding
6569: -- progresssion statuses in the table IGS_EN_STDNT_PS_ATT and update these progression statuses suitably
6570:
6571: -- Good Standing : Select records marked as good standing where either Pending
6572: -- record relates directly to the course attempt, or an approved record
6573: -- affects the course (either directly or via course of course group effects).

Line 6595: -- set the progression status in the table 'IGS_EN_STDNT_PS_ATT' to 'UNCONSID'.

6591: end if;
6592: END LOOP; -- c_sca1
6593:
6594: -- Corresponding to all records where decision status is still 'PENDING'
6595: -- set the progression status in the table 'IGS_EN_STDNT_PS_ATT' to 'UNCONSID'.
6596: -- Under Consideration : Selects records with status of under consideration
6597: -- where there are no longer any directly related progression outcomes being
6598: -- considered.
6599: FOR v_sca_rec IN c_sca2 LOOP