APPS.IGS_PR_GEN_005 dependencies on IGS_PR_OU_TYPE

Line 869: igs_pr_ou_type pot

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
872: AND spo.decision_status IN (cst_approved, cst_pending)
873: AND ci.cal_type = spo.prg_cal_type

Line 1026: pl_progression_outcome_type igs_pr_ou_type.progression_outcome_type%TYPE,

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);
1030: BEGIN -- prgpl_determine_outcome_level

Line 1038: v_s_prg_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;

1034: cst_manual CONSTANT VARCHAR2 (10) := 'MANUAL';
1035: cst_nopenalty CONSTANT VARCHAR2 (10) := 'NOPENALTY';
1036: cst_probation CONSTANT VARCHAR2 (10) := 'PROBATION';
1037: cst_expulsion CONSTANT VARCHAR2 (10) := 'EXPULSION';
1038: v_s_prg_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;
1039: v_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE;
1040: v_dummy VARCHAR2 (1);
1041: CURSOR c_pot IS
1042: SELECT pot.s_progression_outcome_type,

Line 1039: v_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE;

1035: cst_nopenalty CONSTANT VARCHAR2 (10) := 'NOPENALTY';
1036: cst_probation CONSTANT VARCHAR2 (10) := 'PROBATION';
1037: cst_expulsion CONSTANT VARCHAR2 (10) := 'EXPULSION';
1038: v_s_prg_outcome_type igs_pr_ou_type.s_progression_outcome_type%TYPE;
1039: v_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE;
1040: v_dummy VARCHAR2 (1);
1041: CURSOR c_pot IS
1042: SELECT pot.s_progression_outcome_type,
1043: pot.encumbrance_type

Line 1044: FROM igs_pr_ou_type pot

1040: v_dummy VARCHAR2 (1);
1041: CURSOR c_pot IS
1042: SELECT pot.s_progression_outcome_type,
1043: pot.encumbrance_type
1044: FROM igs_pr_ou_type pot
1045: WHERE pot.progression_outcome_type = pl_progression_outcome_type;
1046: CURSOR c_etde (cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS
1047: SELECT 'X'
1048: FROM igs_fi_enc_dflt_eft etde

Line 1046: CURSOR c_etde (cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS

1042: SELECT pot.s_progression_outcome_type,
1043: pot.encumbrance_type
1044: FROM igs_pr_ou_type pot
1045: WHERE pot.progression_outcome_type = pl_progression_outcome_type;
1046: CURSOR c_etde (cp_encumbrance_type igs_pr_ou_type.encumbrance_type%TYPE) IS
1047: SELECT 'X'
1048: FROM igs_fi_enc_dflt_eft etde
1049: WHERE encumbrance_type = cp_encumbrance_type
1050: AND s_encmb_effect_type IN (cst_exc_course, cst_exc_crs_gp);