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_PR_STDNT_PR_OU

Line 359: FROM IGS_PR_STDNT_PR_OU spo,

355: sca.version_number,
356: sca.commencement_dt,
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 (

Line 518: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

514: FROM IGS_EN_DCNT_REASONCD dr
515: WHERE dr.discontinuation_reason_cd = cp_discontinuation_reason_cd AND
516: dr.s_discontinuation_reason_type = cst_progress;
517: CURSOR c_spo_pot (
518: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
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,

Line 519: cp_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

515: WHERE dr.discontinuation_reason_cd = cp_discontinuation_reason_cd AND
516: dr.s_discontinuation_reason_type = cst_progress;
517: CURSOR c_spo_pot (
518: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
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

Line 520: cp_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,

516: dr.s_discontinuation_reason_type = cst_progress;
517: CURSOR c_spo_pot (
518: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
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)*/

Line 522: IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,

518: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
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

Line 527: FROM IGS_PR_STDNT_PR_OU spo,

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,
528: IGS_PR_OU_TYPE pot
529: WHERE
530: (EXISTS (
531: SELECT 'X'

Line 578: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

574: WHERE sca.person_id = cp_person_id AND
575: sca.course_cd = cp_course_cd
576: FOR UPDATE NOWAIT;
577: CURSOR c_sca2 (
578: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
579: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
580: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
581: cp_spo_encmb_course_group_cd
582: IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE) IS

Line 579: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

575: sca.course_cd = cp_course_cd
576: FOR UPDATE NOWAIT;
577: CURSOR c_sca2 (
578: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
579: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
580: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
581: cp_spo_encmb_course_group_cd
582: IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE) IS
583: SELECT sca.person_id,

Line 580: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,

576: FOR UPDATE NOWAIT;
577: CURSOR c_sca2 (
578: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
579: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
580: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
581: cp_spo_encmb_course_group_cd
582: IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE) IS
583: SELECT sca.person_id,
584: sca.course_cd,

Line 582: IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE) IS

578: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
579: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
580: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
581: cp_spo_encmb_course_group_cd
582: IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE) IS
583: SELECT sca.person_id,
584: sca.course_cd,
585: sca.version_number,
586: sca.course_attempt_status,

Line 611: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

607: cgm.course_cd = sca.course_cd AND
608: cgm.version_number = sca.version_number)
609: ));
610: CURSOR c_susa (
611: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
612: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
613: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
614: SELECT
615: susa.*,

Line 612: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

608: cgm.version_number = sca.version_number)
609: ));
610: CURSOR c_susa (
611: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
612: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
613: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
614: SELECT
615: susa.*,
616: susa.ROWID,

Line 613: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS

609: ));
610: CURSOR c_susa (
611: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
612: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
613: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
614: SELECT
615: susa.*,
616: susa.ROWID,
617: DECODE(acai.acai_ind, 'Y', 'Y', 'N') acai_ind

Line 649: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

645: acai.person_id (+)= susa.person_id AND
646: acai.course_cd (+)= susa.course_cd ;
647: --FOR UPDATE NOWAIT; -- Commente by Prajeesh
648: CURSOR c_pra (
649: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
650: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
651: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
652: SELECT /*+INDEX(pra1 pra_spo_fk_i)*/
653: pra1.progression_rule_cat,

Line 650: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

646: acai.course_cd (+)= susa.course_cd ;
647: --FOR UPDATE NOWAIT; -- Commente by Prajeesh
648: CURSOR c_pra (
649: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
650: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
651: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
652: SELECT /*+INDEX(pra1 pra_spo_fk_i)*/
653: pra1.progression_rule_cat,
654: pra1.sequence_number

Line 651: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS

647: --FOR UPDATE NOWAIT; -- Commente by Prajeesh
648: CURSOR c_pra (
649: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
650: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
651: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
652: SELECT /*+INDEX(pra1 pra_spo_fk_i)*/
653: pra1.progression_rule_cat,
654: pra1.sequence_number
655: FROM IGS_PR_RU_APPL pra1

Line 674: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

670: pra2.logical_delete_dt IS NULL AND
671: NVL(pra2.reference_cd, pra2.progression_rule_cd)
672: = NVL(pra1.reference_cd, pra1.progression_rule_cd));
673: CURSOR c_pra_prct (
674: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
675: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
676: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
677: SELECT /*+INDEX(pra pra_spo_fk_i)*/
678: prct.*,

Line 675: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

671: NVL(pra2.reference_cd, pra2.progression_rule_cd)
672: = NVL(pra1.reference_cd, pra1.progression_rule_cd));
673: CURSOR c_pra_prct (
674: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
675: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
676: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
677: SELECT /*+INDEX(pra pra_spo_fk_i)*/
678: prct.*,
679: prct.ROWID

Line 676: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS

672: = NVL(pra1.reference_cd, pra1.progression_rule_cd));
673: CURSOR c_pra_prct (
674: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
675: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
676: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
677: SELECT /*+INDEX(pra pra_spo_fk_i)*/
678: prct.*,
679: prct.ROWID
680: FROM IGS_PR_RU_APPL pra,

Line 709: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

705: WHERE ci2.cal_type = cp_spo_cal_type AND
706: ci2.sequence_number = cp_spo_sequence_number)
707: ORDER BY ci1.start_dt ASC;
708: CURSOR c_pra_upd1 (
709: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
710: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
711: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
712: SELECT pra.*,
713: pra.ROWID

Line 710: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

706: ci2.sequence_number = cp_spo_sequence_number)
707: ORDER BY ci1.start_dt ASC;
708: CURSOR c_pra_upd1 (
709: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
710: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
711: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
712: SELECT pra.*,
713: pra.ROWID
714: FROM IGS_PR_RU_APPL pra

Line 711: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS

707: ORDER BY ci1.start_dt ASC;
708: CURSOR c_pra_upd1 (
709: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
710: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
711: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
712: SELECT pra.*,
713: pra.ROWID
714: FROM IGS_PR_RU_APPL pra
715: WHERE pra.spo_person_id = cp_spo_person_id AND

Line 724: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

720: pra.logical_delete_dt IS NULL AND
721: pra.s_relation_type = cst_sca ;
722: --FOR UPDATE NOWAIT; -- commented by Prajeesh
723: CURSOR c_pra_upd2 (
724: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
725: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
726: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
727: SELECT pra1.*,
728: pra1.ROWID

Line 725: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

721: pra.s_relation_type = cst_sca ;
722: --FOR UPDATE NOWAIT; -- commented by Prajeesh
723: CURSOR c_pra_upd2 (
724: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
725: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
726: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
727: SELECT pra1.*,
728: pra1.ROWID
729: FROM IGS_PR_RU_APPL pra1

Line 726: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS

722: --FOR UPDATE NOWAIT; -- commented by Prajeesh
723: CURSOR c_pra_upd2 (
724: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
725: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
726: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
727: SELECT pra1.*,
728: pra1.ROWID
729: FROM IGS_PR_RU_APPL pra1
730: WHERE pra1.sca_person_id = cp_spo_person_id AND

Line 760: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

756: AND course_cd = cp_course_cd
757: AND spa.spo_sequence_number = cp_spo_sequence_number;
758:
759: CURSOR c_sua (
760: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
761: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
762: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
763: SELECT
764: sua.*, sua.ROWID

Line 761: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

757: AND spa.spo_sequence_number = cp_spo_sequence_number;
758:
759: CURSOR c_sua (
760: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
761: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
762: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
763: SELECT
764: sua.*, sua.ROWID
765: FROM IGS_EN_SU_ATTEMPT sua

Line 762: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS

758:
759: CURSOR c_sua (
760: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
761: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
762: cp_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
763: SELECT
764: sua.*, sua.ROWID
765: FROM IGS_EN_SU_ATTEMPT sua
766: WHERE sua.person_id = cp_spo_person_id AND

Line 782: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

778: -- kdande; 22-Apr-2003; Bug# 2829262
779: -- Added uoo_id field to the WHERE clause of cursor c_suao
780: --
781: CURSOR c_suao (
782: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
783: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
784: cp_sua_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
785: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
786: cp_sua_ci_seq_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

Line 783: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

779: -- Added uoo_id field to the WHERE clause of cursor c_suao
780: --
781: CURSOR c_suao (
782: cp_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
783: cp_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
784: cp_sua_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
785: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
786: cp_sua_ci_seq_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
787: cp_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

Line 801: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,

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,
803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
804: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,

Line 802: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%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,
803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
804: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
806: p_message_name VARCHAR2,

Line 803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%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,
803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
804: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
806: p_message_name VARCHAR2,
807: p_text IGS_GE_s_log_entry.text%TYPE

Line 804: p_duration IGS_PR_STDNT_PR_OU.duration%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,
803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
804: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
806: p_message_name VARCHAR2,
807: p_text IGS_GE_s_log_entry.text%TYPE
808: ) IS

Line 922: p_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

918: App_Exception.Raise_Exception;
919: END prgpl_ins_log_entry;
920:
921: FUNCTION prgpl_upd_spo (
922: p_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
923: p_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,
926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,

Line 923: p_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

919: END prgpl_ins_log_entry;
920:
921: FUNCTION prgpl_upd_spo (
922: p_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
923: p_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,
926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,
927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,

Line 924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,

920:
921: FUNCTION prgpl_upd_spo (
922: p_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
923: p_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
924: p_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
925: p_show_cause_ind IGS_PR_S_PRG_CONF.show_cause_ind%TYPE,
926: p_apply_before_show_ind IGS_PR_S_PRG_CONF.apply_before_show_ind%TYPE,
927: p_appeal_ind IGS_PR_S_PRG_CONF.appeal_ind%TYPE,
928: p_apply_before_appeal_ind IGS_PR_S_PRG_CONF.apply_before_appeal_ind%TYPE)

Line 940: FROM IGS_PR_STDNT_PR_OU spo,

936: SELECT sca.course_cd sca_course_cd,
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

Line 950: v_orig_appeal_expiry_dt IGS_PR_STDNT_PR_OU.appeal_expiry_dt%TYPE;

946: spo.course_cd = sca.course_cd ;
947: --FOR UPDATE NOWAIT; -- commented by Prajeesh
948: v_spo_rec c_spo%ROWTYPE;
949: v_old_show_cause_expiry_dt DATE;
950: v_orig_appeal_expiry_dt IGS_PR_STDNT_PR_OU.appeal_expiry_dt%TYPE;
951: v_orig_show_cause_expiry_dt IGS_PR_STDNT_PR_OU.show_cause_expiry_dt%TYPE;
952: BEGIN
953: OPEN c_spo;
954: FETCH c_spo INTO v_spo_rec;

Line 951: v_orig_show_cause_expiry_dt IGS_PR_STDNT_PR_OU.show_cause_expiry_dt%TYPE;

947: --FOR UPDATE NOWAIT; -- commented by Prajeesh
948: v_spo_rec c_spo%ROWTYPE;
949: v_old_show_cause_expiry_dt DATE;
950: v_orig_appeal_expiry_dt IGS_PR_STDNT_PR_OU.appeal_expiry_dt%TYPE;
951: v_orig_show_cause_expiry_dt IGS_PR_STDNT_PR_OU.show_cause_expiry_dt%TYPE;
952: BEGIN
953: OPEN c_spo;
954: FETCH c_spo INTO v_spo_rec;
955: IF c_spo%FOUND THEN

Line 1035: UPDATE IGS_PR_STDNT_PR_OU

1031: NULL,
1032: v_expiry_dt
1033: );
1034: /*
1035: UPDATE IGS_PR_STDNT_PR_OU
1036: SET applied_dt = SYSDATE,
1037: expiry_dt = v_expiry_dt,
1038: show_cause_expiry_dt = v_spo_rec.show_cause_expiry_dt,
1039: appeal_expiry_dt = v_spo_rec.appeal_expiry_dt

Line 1042: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

1038: show_cause_expiry_dt = v_spo_rec.show_cause_expiry_dt,
1039: appeal_expiry_dt = v_spo_rec.appeal_expiry_dt
1040: WHERE CURRENT OF c_spo;
1041: */
1042: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
1043: X_ROWID => v_spo_rec.ROWID,
1044: X_PERSON_ID => v_spo_rec.PERSON_ID,
1045: X_COURSE_CD => v_spo_rec.COURSE_CD,
1046: X_SEQUENCE_NUMBER => v_spo_rec.SEQUENCE_NUMBER,

Line 1084: /* UPDATE IGS_PR_STDNT_PR_OU

1080: );
1081:
1082:
1083: ELSE
1084: /* UPDATE IGS_PR_STDNT_PR_OU
1085: SET applied_dt = SYSDATE,
1086: show_cause_expiry_dt = v_spo_rec.show_cause_expiry_dt,
1087: appeal_expiry_dt = v_spo_rec.appeal_expiry_dt
1088: WHERE CURRENT OF c_spo;

Line 1090: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

1086: show_cause_expiry_dt = v_spo_rec.show_cause_expiry_dt,
1087: appeal_expiry_dt = v_spo_rec.appeal_expiry_dt
1088: WHERE CURRENT OF c_spo;
1089: */
1090: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
1091: X_ROWID => v_spo_rec.ROWID,
1092: X_PERSON_ID => v_spo_rec.PERSON_ID,
1093: X_COURSE_CD => v_spo_rec.COURSE_CD,
1094: X_SEQUENCE_NUMBER => v_spo_rec.SEQUENCE_NUMBER,

Line 1132: UPDATE IGS_PR_STDNT_PR_OU

1128: );
1129: END IF;
1130: ELSE
1131: /*
1132: UPDATE IGS_PR_STDNT_PR_OU
1133: SET applied_dt = NULL,
1134: expiry_dt = NULL
1135: WHERE CURRENT OF c_spo;
1136: */

Line 1137: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

1133: SET applied_dt = NULL,
1134: expiry_dt = NULL
1135: WHERE CURRENT OF c_spo;
1136: */
1137: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
1138: X_ROWID => v_spo_rec.ROWID,
1139: X_PERSON_ID => v_spo_rec.PERSON_ID,
1140: X_COURSE_CD => v_spo_rec.COURSE_CD,
1141: X_SEQUENCE_NUMBER => v_spo_rec.SEQUENCE_NUMBER,

Line 3593: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,

3589: PROCEDURE prgpl_ins_log_entry (
3590: p_record_type VARCHAR2,
3591: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
3592: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
3593: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
3594: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
3595: p_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE,
3596: p_progression_outcome_type
3597: IGS_PR_OU_TYPE.progression_outcome_type%TYPE,

Line 3674: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%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,
3677: p_encmb_course_group_cd IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,
3678: p_restricted_enrolment_cp IGS_PR_STDNT_PR_OU.restricted_enrolment_cp%TYPE,

Line 3675: p_duration IGS_PR_STDNT_PR_OU.duration%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,
3677: p_encmb_course_group_cd IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,
3678: p_restricted_enrolment_cp IGS_PR_STDNT_PR_OU.restricted_enrolment_cp%TYPE,
3679: p_restricted_attendance_type IGS_PR_STDNT_PR_OU.restricted_attendance_type%TYPE,

Line 3676: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%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,
3677: p_encmb_course_group_cd IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,
3678: p_restricted_enrolment_cp IGS_PR_STDNT_PR_OU.restricted_enrolment_cp%TYPE,
3679: p_restricted_attendance_type IGS_PR_STDNT_PR_OU.restricted_attendance_type%TYPE,
3680: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,

Line 3677: p_encmb_course_group_cd IGS_PR_STDNT_PR_OU.encmb_course_group_cd%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,
3677: p_encmb_course_group_cd IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,
3678: p_restricted_enrolment_cp IGS_PR_STDNT_PR_OU.restricted_enrolment_cp%TYPE,
3679: p_restricted_attendance_type IGS_PR_STDNT_PR_OU.restricted_attendance_type%TYPE,
3680: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
3681: p_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE)

Line 3678: p_restricted_enrolment_cp IGS_PR_STDNT_PR_OU.restricted_enrolment_cp%TYPE,

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,
3677: p_encmb_course_group_cd IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,
3678: p_restricted_enrolment_cp IGS_PR_STDNT_PR_OU.restricted_enrolment_cp%TYPE,
3679: p_restricted_attendance_type IGS_PR_STDNT_PR_OU.restricted_attendance_type%TYPE,
3680: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
3681: p_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE)
3682: IS

Line 3679: p_restricted_attendance_type IGS_PR_STDNT_PR_OU.restricted_attendance_type%TYPE,

3675: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
3676: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
3677: p_encmb_course_group_cd IGS_PR_STDNT_PR_OU.encmb_course_group_cd%TYPE,
3678: p_restricted_enrolment_cp IGS_PR_STDNT_PR_OU.restricted_enrolment_cp%TYPE,
3679: p_restricted_attendance_type IGS_PR_STDNT_PR_OU.restricted_attendance_type%TYPE,
3680: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
3681: p_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE)
3682: IS
3683: BEGIN -- prgpl_add_stdnt_prg_outcomes

Line 3695: v_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE;

3691: cst_pro CONSTANT VARCHAR2(10) := 'PRO';
3692: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
3693: v_spo_sequence_number INTEGER;
3694: v_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
3695: v_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE;
3696: v_decision_org_unit_cd IGS_OR_unit.org_unit_cd%TYPE;
3697: v_decision_ou_start_dt IGS_OR_unit.start_dt%TYPE;
3698: v_decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE;
3699: v_show_cause_expiry_dt IGS_PR_STDNT_PR_OU_ALL.SHOW_CAUSE_EXPIRY_DT%TYPE;

Line 3698: v_decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE;

3694: v_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
3695: v_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE;
3696: v_decision_org_unit_cd IGS_OR_unit.org_unit_cd%TYPE;
3697: v_decision_ou_start_dt IGS_OR_unit.start_dt%TYPE;
3698: v_decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE;
3699: v_show_cause_expiry_dt IGS_PR_STDNT_PR_OU_ALL.SHOW_CAUSE_EXPIRY_DT%TYPE;
3700: v_appeal_expiry_dt IGS_PR_STDNT_PR_OU_ALL.APPEAL_EXPIRY_DT%TYPE;
3701: v_poc_rec_found BOOLEAN DEFAULT FALSE;
3702: v_message_name VARCHAR2(30);

Line 3699: v_show_cause_expiry_dt IGS_PR_STDNT_PR_OU_ALL.SHOW_CAUSE_EXPIRY_DT%TYPE;

3695: v_decision_status IGS_PR_STDNT_PR_OU_ALL.DECISION_STATUS%TYPE;
3696: v_decision_org_unit_cd IGS_OR_unit.org_unit_cd%TYPE;
3697: v_decision_ou_start_dt IGS_OR_unit.start_dt%TYPE;
3698: v_decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE;
3699: v_show_cause_expiry_dt IGS_PR_STDNT_PR_OU_ALL.SHOW_CAUSE_EXPIRY_DT%TYPE;
3700: v_appeal_expiry_dt IGS_PR_STDNT_PR_OU_ALL.APPEAL_EXPIRY_DT%TYPE;
3701: v_poc_rec_found BOOLEAN DEFAULT FALSE;
3702: v_message_name VARCHAR2(30);
3703: v_dummy VARCHAR2(1);

Line 3700: v_appeal_expiry_dt IGS_PR_STDNT_PR_OU_ALL.APPEAL_EXPIRY_DT%TYPE;

3696: v_decision_org_unit_cd IGS_OR_unit.org_unit_cd%TYPE;
3697: v_decision_ou_start_dt IGS_OR_unit.start_dt%TYPE;
3698: v_decision_dt IGS_PR_STDNT_PR_OU_ALL.DECISION_DT%TYPE;
3699: v_show_cause_expiry_dt IGS_PR_STDNT_PR_OU_ALL.SHOW_CAUSE_EXPIRY_DT%TYPE;
3700: v_appeal_expiry_dt IGS_PR_STDNT_PR_OU_ALL.APPEAL_EXPIRY_DT%TYPE;
3701: v_poc_rec_found BOOLEAN DEFAULT FALSE;
3702: v_message_name VARCHAR2(30);
3703: v_dummy VARCHAR2(1);
3704:

Line 3833: igs_pr_stdnt_pr_ou_pkg.insert_row (

3829: lv_rowid VARCHAR2(25);
3830: lv_org_id NUMBER(15);
3831: BEGIN
3832: lv_org_id := igs_ge_gen_003.get_org_id;
3833: igs_pr_stdnt_pr_ou_pkg.insert_row (
3834: x_rowid => lv_rowid,
3835: x_person_id => p_person_id,
3836: x_course_cd => p_course_cd,
3837: x_sequence_number => v_spo_sequence_number,

Line 4327: FROM IGS_PR_STDNT_PR_OU spo

4323: IGS_PR_OU_TYPE.progression_outcome_type%TYPE;
4324: CURSOR c_spo IS
4325: SELECT spo.*,
4326: spo.ROWID
4327: FROM IGS_PR_STDNT_PR_OU spo
4328: WHERE spo.person_id = p_person_id AND
4329: spo.course_cd = p_course_cd AND
4330: spo.prg_cal_type = p_prg_cal_type AND
4331: spo.prg_ci_sequence_number = p_prg_sequence_number AND

Line 4695: IGS_PR_STDNT_PR_OU_PKG.DELETE_ROW(

4691: EXIT;
4692: WHEN OTHERS THEN
4693: RAISE;
4694: END;
4695: IGS_PR_STDNT_PR_OU_PKG.DELETE_ROW(
4696: v_spo_rec.ROWID
4697: );
4698: ELSE
4699: -- Outcome has not yet been applied, so it can be removed

Line 4700: /* UPDATE IGS_PR_STDNT_PR_OU spo

4696: v_spo_rec.ROWID
4697: );
4698: ELSE
4699: -- Outcome has not yet been applied, so it can be removed
4700: /* UPDATE IGS_PR_STDNT_PR_OU spo
4701: SET spo.decision_status = cst_removed
4702: WHERE CURRENT OF c_spo;
4703: */
4704: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

Line 4704: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(

4700: /* UPDATE IGS_PR_STDNT_PR_OU spo
4701: SET spo.decision_status = cst_removed
4702: WHERE CURRENT OF c_spo;
4703: */
4704: IGS_PR_STDNT_PR_OU_PKG.UPDATE_ROW(
4705: x_rowid => v_spo_rec.ROWID,
4706: x_person_id => v_spo_rec.person_id,
4707: x_course_cd => v_spo_rec.course_cd,
4708: x_sequence_number => v_spo_rec.sequence_number,

Line 6217: v_decision_status IGS_PR_STDNT_PR_OU.decision_status%TYPE;

6213: e_record_locked EXCEPTION;
6214: PRAGMA EXCEPTION_INIT(e_record_locked, -54);
6215: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
6216: cst_applied_dt CONSTANT DATE := igs_ge_date.igsdate('0001/01/01');
6217: v_decision_status IGS_PR_STDNT_PR_OU.decision_status%TYPE;
6218: CURSOR c_spo_upd IS
6219: SELECT spo.*, spo.ROWID
6220: FROM IGS_PR_STDNT_PR_OU spo
6221: WHERE person_id = p_person_id AND

Line 6220: FROM IGS_PR_STDNT_PR_OU spo

6216: cst_applied_dt CONSTANT DATE := igs_ge_date.igsdate('0001/01/01');
6217: v_decision_status IGS_PR_STDNT_PR_OU.decision_status%TYPE;
6218: CURSOR c_spo_upd IS
6219: SELECT spo.*, spo.ROWID
6220: FROM IGS_PR_STDNT_PR_OU spo
6221: WHERE person_id = p_person_id AND
6222: course_cd = p_course_cd AND
6223: sequence_number = p_sequence_number
6224: FOR UPDATE NOWAIT;

Line 6236: UPDATE IGS_PR_STDNT_PR_OU

6232: OPEN c_spo_upd;
6233: FETCH c_spo_upd INTO v_spo_upd_rec;
6234: IF v_spo_upd_rec.decision_status = cst_approved THEN
6235: /*
6236: UPDATE IGS_PR_STDNT_PR_OU
6237: SET applied_dt = cst_applied_dt
6238: WHERE CURRENT OF c_spo_upd;
6239: */
6240: igs_pr_stdnt_pr_ou_pkg.update_row(

Line 6240: igs_pr_stdnt_pr_ou_pkg.update_row(

6236: UPDATE IGS_PR_STDNT_PR_OU
6237: SET applied_dt = cst_applied_dt
6238: WHERE CURRENT OF c_spo_upd;
6239: */
6240: igs_pr_stdnt_pr_ou_pkg.update_row(
6241: x_rowid => v_spo_upd_rec.ROWID,
6242: x_person_id => v_spo_upd_rec.person_id,
6243: x_course_cd => v_spo_upd_rec.course_cd,
6244: x_sequence_number => v_spo_upd_rec.sequence_number,

Line 6339: FROM IGS_PR_STDNT_PR_OU spo,

6335: SELECT spo.person_id,
6336: spo.course_cd,
6337: spo.sequence_number,
6338: spo.expiry_dt
6339: FROM IGS_PR_STDNT_PR_OU spo,
6340: IGS_PR_OU_TYPE pot
6341: WHERE spo.decision_status = cst_approved AND
6342: spo.applied_dt IS NOT NULL AND
6343: spo.expiry_dt IS NULL AND

Line 6349: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

6345: pot.progression_outcome_type = spo.progression_outcome_type AND
6346: pot.s_progression_outcome_type IN
6347: (cst_suspension, cst_probation, cst_manual);
6348: CURSOR c_spo_upd (
6349: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
6350: cp_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
6351: cp_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
6352: SELECT spo.*, spo.ROWID
6353: FROM IGS_PR_STDNT_PR_OU spo

Line 6350: cp_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

6346: pot.s_progression_outcome_type IN
6347: (cst_suspension, cst_probation, cst_manual);
6348: CURSOR c_spo_upd (
6349: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
6350: cp_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
6351: cp_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
6352: SELECT spo.*, spo.ROWID
6353: FROM IGS_PR_STDNT_PR_OU spo
6354: WHERE spo.person_id = cp_person_id AND

Line 6351: cp_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS

6347: (cst_suspension, cst_probation, cst_manual);
6348: CURSOR c_spo_upd (
6349: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
6350: cp_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
6351: cp_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
6352: SELECT spo.*, spo.ROWID
6353: FROM IGS_PR_STDNT_PR_OU spo
6354: WHERE spo.person_id = cp_person_id AND
6355: spo.course_cd = cp_course_cd AND

Line 6353: FROM IGS_PR_STDNT_PR_OU spo

6349: cp_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
6350: cp_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
6351: cp_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE) IS
6352: SELECT spo.*, spo.ROWID
6353: FROM IGS_PR_STDNT_PR_OU spo
6354: WHERE spo.person_id = cp_person_id AND
6355: spo.course_cd = cp_course_cd AND
6356: spo.sequence_number = cp_sequence_number
6357: FOR UPDATE NOWAIT;

Line 6371: FROM IGS_PR_STDNT_PR_OU spo,

6367: WHERE sca.progression_status = cst_goodstand AND
6368: sca.course_attempt_status NOT IN ('UNCONFIRM','DELETED','COMPLETED') AND
6369: EXISTS (
6370: SELECT 'X'
6371: FROM IGS_PR_STDNT_PR_OU spo,
6372: IGS_PR_OU_TYPE pot
6373: WHERE pot.progression_outcome_type = spo.progression_outcome_type AND
6374: spo.person_id = sca.person_id AND
6375: spo.course_cd = sca.course_cd AND

Line 6412: FROM IGS_PR_STDNT_PR_OU spo

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'
6412: FROM IGS_PR_STDNT_PR_OU spo
6413: WHERE sca.person_id = spo.person_id AND
6414: sca.course_cd = spo.course_cd AND
6415: spo.decision_status = cst_pending);
6416: CURSOR c_sca3 IS

Line 6426: FROM IGS_PR_STDNT_PR_OU spo

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'
6426: FROM IGS_PR_STDNT_PR_OU spo
6427: WHERE sca.person_id = spo.person_id AND
6428: sca.course_cd = spo.course_cd AND
6429: spo.decision_status = cst_approved AND
6430: spo.show_cause_expiry_dt IS NOT NULL AND

Line 6448: FROM IGS_PR_STDNT_PR_OU spo,

6444: cst_expulsion) AND
6445: sca.course_attempt_status NOT IN ('UNCONFIRM','DELETED','COMPLETED') AND
6446: NOT EXISTS (
6447: SELECT 'X'
6448: FROM IGS_PR_STDNT_PR_OU spo,
6449: IGS_PR_OU_TYPE pot
6450: WHERE pot.progression_outcome_type = spo.progression_outcome_type AND
6451: spo.person_id = sca.person_id AND
6452: spo.course_cd = sca.course_cd AND

Line 6510: UPDATE IGS_PR_STDNT_PR_OU

6506: v_spo_rec.course_cd,
6507: v_spo_rec.sequence_number);
6508: FETCH c_spo_upd INTO v_spo_upd_rec;
6509: /*
6510: UPDATE IGS_PR_STDNT_PR_OU
6511: SET expiry_dt = v_expiry_dt,
6512: applied_dt = igs_ge_date.igsdate('0001/01/01')
6513: WHERE CURRENT OF c_spo_upd;
6514: */

Line 6515: igs_pr_stdnt_pr_ou_pkg.update_row(

6511: SET expiry_dt = v_expiry_dt,
6512: applied_dt = igs_ge_date.igsdate('0001/01/01')
6513: WHERE CURRENT OF c_spo_upd;
6514: */
6515: igs_pr_stdnt_pr_ou_pkg.update_row(
6516: x_rowid => v_spo_upd_rec.ROWID,
6517: x_person_id => v_spo_upd_rec.person_id,
6518: x_course_cd => v_spo_upd_rec.course_cd,
6519: x_sequence_number => v_spo_upd_rec.sequence_number,

Line 6568: -- Check the decision status for record in IGS_PR_STDNT_PR_OU table and check the corresponding

6564: ' With the Course := '||v_spo_upd_rec.COURSE_CD||' Has no Expiry date');
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