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_VAL_SPO dependencies on IGS_PR_OU_TYPE

Line 1188: IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;

1184: cst_intermit CONSTANT VARCHAR2(10) := 'INTERMIT';
1185: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
1186: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1187: v_s_progression_outcome_type
1188: IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;
1189: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1190: v_passed_ind IGS_PR_SDT_PR_RU_CK.passed_ind%TYPE;
1191: v_dummy VARCHAR2(1);
1192: CURSOR c_sca IS

Line 1315: v_s_progression_outcome_type IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;

1311: cst_nopenalty CONSTANT VARCHAR(10) := 'NOPENALTY';
1312: cst_manual CONSTANT VARCHAR(10) := 'MANUAL';
1313: cst_probation CONSTANT VARCHAR(10) := 'PROBATION';
1314: cst_ex_fund CONSTANT VARCHAR2(10):= 'EX_FUND';
1315: v_s_progression_outcome_type IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;
1316: CURSOR c_pot IS
1317: SELECT s_progression_outcome_type
1318: FROM IGS_PR_OU_TYPE pot
1319: WHERE pot.progression_outcome_type = p_progression_outcome_type;

Line 1318: FROM IGS_PR_OU_TYPE pot

1314: cst_ex_fund CONSTANT VARCHAR2(10):= 'EX_FUND';
1315: v_s_progression_outcome_type IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;
1316: CURSOR c_pot IS
1317: SELECT s_progression_outcome_type
1318: FROM IGS_PR_OU_TYPE pot
1319: WHERE pot.progression_outcome_type = p_progression_outcome_type;
1320: BEGIN
1321: -- Set the default message number
1322: p_message_name := null;

Line 1394: FROM IGS_PR_OU_TYPE pot,

1390: cst_rstr_at_ty CONSTANT VARCHAR(10) := 'RSTR_AT_TY';
1391: v_dummy VARCHAR2(1);
1392: CURSOR c_pot_etde IS
1393: SELECT 'X'
1394: FROM IGS_PR_OU_TYPE pot,
1395: IGS_FI_ENC_DFLT_EFT etde
1396: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1397: pot.encumbrance_type = etde.encumbrance_type AND
1398: etde.s_encmb_effect_type = cst_rstr_at_ty;

Line 1454: FROM IGS_PR_OU_TYPE pot,

1450: cst_exc_crs_gp CONSTANT VARCHAR(10) := 'EXC_CRS_GP';
1451: v_dummy VARCHAR2(1);
1452: CURSOR c_pot_etde IS
1453: SELECT 'X'
1454: FROM IGS_PR_OU_TYPE pot,
1455: IGS_FI_ENC_DFLT_EFT etde
1456: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1457: pot.encumbrance_type = etde.encumbrance_type AND
1458: etde.s_encmb_effect_type = cst_exc_crs_gp;

Line 1507: -- set that the IGS_PR_OU_TYPE relates to a s_encmb_effect_type of

1503: RETURN BOOLEAN IS
1504: gv_other_detail VARCHAR2(255);
1505: BEGIN -- prgp_val_spo_cp
1506: -- Validate that if IGS_PR_STDNT_PR_OU.restricted_enrolment_cp is
1507: -- set that the IGS_PR_OU_TYPE relates to a s_encmb_effect_type of
1508: -- RSTR_GE_CP or RSTR_LE_CP.
1509: DECLARE
1510: cst_rstr_ge_cp CONSTANT VARCHAR(10) := 'RSTR_GE_CP';
1511: cst_rstr_le_cp CONSTANT VARCHAR(10) := 'RSTR_LE_CP';

Line 1515: FROM IGS_PR_OU_TYPE pot,

1511: cst_rstr_le_cp CONSTANT VARCHAR(10) := 'RSTR_LE_CP';
1512: v_dummy VARCHAR2(1);
1513: CURSOR c_pot_etde IS
1514: SELECT 'X'
1515: FROM IGS_PR_OU_TYPE pot,
1516: IGS_FI_ENC_DFLT_EFT etde
1517: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1518: pot.encumbrance_type = etde.encumbrance_type AND
1519: etde.s_encmb_effect_type IN (

Line 1719: -- to the IGS_PR_OU_TYPE.encumbrance_type defined for the

1715: BEGIN
1716: -- prgp_val_spo_approve
1717: -- If the IGS_PR_STDNT_PR_OU.decision_status is being set to approved
1718: -- then check the encmb_dflt_effect_type.s_encmb_effect_type records related
1719: -- to the IGS_PR_OU_TYPE.encumbrance_type defined for the
1720: -- student _progression_outcome.IGS_PR_OU_TYPE.
1721: DECLARE
1722: cst_approved CONSTANT VARCHAR(10) := 'APPROVED';
1723: cst_sus_course CONSTANT VARCHAR(10) := 'SUS_COURSE';

Line 1720: -- student _progression_outcome.IGS_PR_OU_TYPE.

1716: -- prgp_val_spo_approve
1717: -- If the IGS_PR_STDNT_PR_OU.decision_status is being set to approved
1718: -- then check the encmb_dflt_effect_type.s_encmb_effect_type records related
1719: -- to the IGS_PR_OU_TYPE.encumbrance_type defined for the
1720: -- student _progression_outcome.IGS_PR_OU_TYPE.
1721: DECLARE
1722: cst_approved CONSTANT VARCHAR(10) := 'APPROVED';
1723: cst_sus_course CONSTANT VARCHAR(10) := 'SUS_COURSE';
1724: cst_exc_course CONSTANT VARCHAR(10) := 'EXC_COURSE';

Line 1750: FROM IGS_PR_OU_TYPE pot,

1746: WHERE person_id = p_person_id AND
1747: course_cd = p_course_cd;
1748: CURSOR c_pot_etde IS
1749: SELECT etde.s_encmb_effect_type
1750: FROM IGS_PR_OU_TYPE pot,
1751: IGS_FI_ENC_DFLT_EFT etde
1752: WHERE pot.progression_outcome_type = p_progression_outcome_type AND
1753: pot. encumbrance_type = etde.encumbrance_type;
1754: CURSOR c_spc IS

Line 2262: -- Prevent changes to IGS_PR_STDNT_PR_OU.IGS_PR_OU_TYPE

2258: p_message_name OUT NOCOPY VARCHAR2 )
2259: RETURN BOOLEAN IS
2260: gv_other_detail VARCHAR2(255);
2261: BEGIN -- prgp_val_spo_pot
2262: -- Prevent changes to IGS_PR_STDNT_PR_OU.IGS_PR_OU_TYPE
2263: p_message_name := null;
2264: IF p_old_progression_outcome_type IS NULL OR
2265: p_new_progression_outcome_type IS NULL THEN
2266: RETURN TRUE;