APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 831: CURSOR c_spa (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS

827: WHERE p.party_number = p_person_number;
828: --
829: -- Get Student Program Attempt details
830: --
831: CURSOR c_spa (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
832: SELECT spa.course_attempt_status,
833: spa.version_number
834: FROM igs_en_stdnt_ps_att_all spa
835: WHERE spa.person_id = cp_person_id

Line 834: FROM igs_en_stdnt_ps_att_all spa

830: --
831: CURSOR c_spa (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
832: SELECT spa.course_attempt_status,
833: spa.version_number
834: FROM igs_en_stdnt_ps_att_all spa
835: WHERE spa.person_id = cp_person_id
836: AND spa.course_cd = p_course_cd;
837: --
838: -- Get the System Progession Outcome Type

Line 848: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

844: --
845: -- Check Student Progression Outcome doesn't already exist
846: --
847: CURSOR c_spo (
848: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
849: cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
850: cp_prg_ci_sequence_number igs_ca_inst.sequence_number%TYPE
851: ) IS
852: SELECT 'X'

Line 870: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

866: WHERE scpc.course_cd = p_course_cd
867: AND scpc.version_number = cp_version_number;
868:
869: CURSOR c_scpc_ci (
870: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
871: cp_version_number igs_ps_ver.version_number%TYPE
872: ) IS
873: SELECT ci.cal_type,
874: ci.sequence_number

Line 907: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

903: --
904: --
905: --
906: CURSOR c_sopc_ci (
907: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
908: cp_version_number igs_ps_ver.version_number%TYPE
909: ) IS
910: SELECT ci.cal_type,
911: ci.sequence_number

Line 935: CURSOR c_spc_ci (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS

931: ORDER BY ci.end_dt DESC;
932: --
933: --
934: --
935: CURSOR c_spc_ci (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
936: SELECT ci.cal_type,
937: ci.sequence_number
938: FROM igs_pr_s_prg_cal spc,
939: igs_ca_inst ci,

Line 962: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

958: --
959: --
960: --
961: CURSOR c_grd_sch (
962: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
963: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE
964: ) IS
965: SELECT hpoous.grading_schema_cd,
966: hpoous.gs_version_number,

Line 963: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE

959: --
960: --
961: CURSOR c_grd_sch (
962: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
963: cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE
964: ) IS
965: SELECT hpoous.grading_schema_cd,
966: hpoous.gs_version_number,
967: yop.unit_set_cd,

Line 971: igs_en_stdnt_ps_att_all spa,

967: yop.unit_set_cd,
968: yop.us_version_number,
969: yop.sequence_number
970: FROM igs_en_susa_year_v yop,
971: igs_en_stdnt_ps_att_all spa,
972: igs_ps_ofr_opt_all coo,
973: igs_he_poous_all hpoous
974: WHERE yop.person_id = cp_person_id
975: AND yop.course_cd = cp_course_cd