APPS.IGS_PR_GEN_005 dependencies on IGS_PR_STDNT_PR_OU

Line 867: FROM igs_pr_stdnt_pr_ou spo,

863: v_latest_sequence_number igs_ca_inst.sequence_number%TYPE;
864: CURSOR c_spo_ci IS
865: SELECT spo.prg_cal_type,
866: spo.prg_ci_sequence_number
867: FROM igs_pr_stdnt_pr_ou spo,
868: igs_ca_inst ci,
869: igs_pr_ou_type pot
870: WHERE spo.person_id = p_person_id
871: AND spo.course_cd = p_course_cd

Line 899: FROM igs_pr_stdnt_pr_ou spo

895: spo.show_cause_expiry_dt,
896: spo.show_cause_dt,
897: spo.show_cause_outcome_dt,
898: spo.encmb_course_group_cd
899: FROM igs_pr_stdnt_pr_ou spo
900: WHERE spo.person_id = p_person_id
901: AND spo.course_cd = p_course_cd
902: AND spo.decision_status IN (cst_approved, cst_pending)
903: AND spo.prg_cal_type = cp_latest_cal_type

Line 911: pl_spo_course_cd igs_pr_stdnt_pr_ou.course_cd%TYPE,

907: spo.course_cd,
908: spo.sequence_number,
909: spo.expiry_dt) <> 'EXPIRED';
910: FUNCTION prgpl_course_match (
911: pl_spo_course_cd igs_pr_stdnt_pr_ou.course_cd%TYPE,
912: pl_spo_sequence_number igs_pr_stdnt_pr_ou.sequence_number%TYPE
913: ) RETURN BOOLEAN IS
914: gvl_other_detail VARCHAR2 (255);
915: BEGIN -- prgpl_course_match

Line 912: pl_spo_sequence_number igs_pr_stdnt_pr_ou.sequence_number%TYPE

908: spo.sequence_number,
909: spo.expiry_dt) <> 'EXPIRED';
910: FUNCTION prgpl_course_match (
911: pl_spo_course_cd igs_pr_stdnt_pr_ou.course_cd%TYPE,
912: pl_spo_sequence_number igs_pr_stdnt_pr_ou.sequence_number%TYPE
913: ) RETURN BOOLEAN IS
914: gvl_other_detail VARCHAR2 (255);
915: BEGIN -- prgpl_course_match
916: DECLARE

Line 967: pl_encmb_course_group_cd igs_pr_stdnt_pr_ou.encmb_course_group_cd%TYPE

963: app_exception.raise_exception;
964: END prgpl_course_match;
965:
966: FUNCTION prgpl_course_group_match (
967: pl_encmb_course_group_cd igs_pr_stdnt_pr_ou.encmb_course_group_cd%TYPE
968: ) RETURN BOOLEAN IS
969: gvl_other_detail VARCHAR2 (255);
970: BEGIN -- prgpl_course_group_match
971: DECLARE

Line 1024: pl_spo_course_cd igs_pr_stdnt_pr_ou.course_cd%TYPE,

1020: app_exception.raise_exception;
1021: END prgpl_course_group_match;
1022:
1023: PROCEDURE prgpl_determine_outcome_level (
1024: pl_spo_course_cd igs_pr_stdnt_pr_ou.course_cd%TYPE,
1025: pl_spo_sequence_number igs_pr_stdnt_pr_ou.sequence_number%TYPE,
1026: pl_progression_outcome_type igs_pr_ou_type.progression_outcome_type%TYPE,
1027: pl_encmb_course_group_cd igs_pr_stdnt_pr_ou.encmb_course_group_cd%TYPE
1028: ) IS

Line 1025: pl_spo_sequence_number igs_pr_stdnt_pr_ou.sequence_number%TYPE,

1021: END prgpl_course_group_match;
1022:
1023: PROCEDURE prgpl_determine_outcome_level (
1024: pl_spo_course_cd igs_pr_stdnt_pr_ou.course_cd%TYPE,
1025: pl_spo_sequence_number igs_pr_stdnt_pr_ou.sequence_number%TYPE,
1026: pl_progression_outcome_type igs_pr_ou_type.progression_outcome_type%TYPE,
1027: pl_encmb_course_group_cd igs_pr_stdnt_pr_ou.encmb_course_group_cd%TYPE
1028: ) IS
1029: gvl_other_detail VARCHAR2 (255);

Line 1027: pl_encmb_course_group_cd igs_pr_stdnt_pr_ou.encmb_course_group_cd%TYPE

1023: PROCEDURE prgpl_determine_outcome_level (
1024: pl_spo_course_cd igs_pr_stdnt_pr_ou.course_cd%TYPE,
1025: pl_spo_sequence_number igs_pr_stdnt_pr_ou.sequence_number%TYPE,
1026: pl_progression_outcome_type igs_pr_ou_type.progression_outcome_type%TYPE,
1027: pl_encmb_course_group_cd igs_pr_stdnt_pr_ou.encmb_course_group_cd%TYPE
1028: ) IS
1029: gvl_other_detail VARCHAR2 (255);
1030: BEGIN -- prgpl_determine_outcome_level
1031: DECLARE

Line 1178: FROM igs_pr_stdnt_pr_ou spo

1174: cst_approved CONSTANT VARCHAR2 (10) := 'APPROVED';
1175: v_dummy VARCHAR2 (1);
1176: CURSOR c_spo IS
1177: SELECT 'X'
1178: FROM igs_pr_stdnt_pr_ou spo
1179: WHERE spo.person_id = p_person_id
1180: AND spo.course_cd = p_course_cd
1181: AND spo.decision_status = cst_approved
1182: AND spo.appeal_dt IS NOT NULL