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_STDNT_PR_OU

Line 197: FROM IGS_PR_STDNT_PR_OU spo

193: cst_removed CONSTANT VARCHAR(10) := 'REMOVED';
194: v_dummy VARCHAR2(1);
195: CURSOR c_spo IS
196: SELECT 'X'
197: FROM IGS_PR_STDNT_PR_OU spo
198: WHERE spo.person_id = p_person_id AND
199: spo.course_cd = p_course_cd AND
200: spo.prg_cal_type = p_prg_cal_type AND
201: spo.prg_ci_sequence_number = p_prg_ci_sequence_number AND

Line 314: -- Validate that the IGS_PR_STDNT_PR_OU decision_dt

310: p_message_name OUT NOCOPY VARCHAR2 )
311: RETURN BOOLEAN IS
312: gv_other_detail VARCHAR2(255);
313: BEGIN -- prgp_val_spo_dcsn_dt
314: -- Validate that the IGS_PR_STDNT_PR_OU decision_dt
315: -- is not future dated.
316: BEGIN
317: -- Set the default message number
318: p_message_name := null;

Line 353: -- Validate the IGS_PR_STDNT_PR_OU show_cause_dt:

349: p_message_name OUT NOCOPY VARCHAR2 )
350: RETURN BOOLEAN IS
351: gv_other_detail VARCHAR2(255);
352: BEGIN -- prgp_val_spo_sc_dt
353: -- Validate the IGS_PR_STDNT_PR_OU show_cause_dt:
354: -- The show_cause_dt cannot be set unless decision_dt has been set
355: -- The show_cause_dt cannot be set if decision_status is WAIVED
356: -- Cannot set show_cause_dt if the appeal_dt is already set
357: -- Cannot alter show_cause_dt once show_cause_outcome_dt has been set

Line 481: -- Validate the IGS_PR_STDNT_PR_OU show_cause_expiry_dt:

477: p_message_name OUT NOCOPY VARCHAR2 )
478: RETURN BOOLEAN IS
479: gv_other_detail VARCHAR2(255);
480: BEGIN -- prgp_val_spo_sc_exp
481: -- Validate the IGS_PR_STDNT_PR_OU show_cause_expiry_dt:
482: -- The show_cause_expiry_dt cannot be set to a past date
483: -- The show_cause_expiry_dt cannot be set to if decision_status is WAIVED
484: -- The show_cause_expiry_dt cannot be after the appeal_expiry_dt (if set)
485: -- Cannot alter show_cause_expiry_dt once show_cause_outcome_dt has been set

Line 619: -- Validate the IGS_PR_STDNT_PR_OU show_cause_outcome_dt and

615: p_message_name OUT NOCOPY VARCHAR2 )
616: RETURN BOOLEAN IS
617: gv_other_detail VARCHAR2(255);
618: BEGIN -- prgp_val_spo_sc_out
619: -- Validate the IGS_PR_STDNT_PR_OU show_cause_outcome_dt and
620: -- show_cause_outcome_type:
621: -- * The show_cause_outcome_dt, show_cause_outcome_type cannot be set
622: -- where show_cause_dt is not set
623: -- * Both show_cause_outcome_dt, show_cause_outcome_type must be set

Line 681: -- Validate the IGS_PR_STDNT_PR_OU appeal_dt:

677: p_message_name OUT NOCOPY VARCHAR2 )
678: RETURN BOOLEAN IS
679: gv_other_detail VARCHAR2(255);
680: BEGIN -- prgp_val_spo_apl_dt
681: -- Validate the IGS_PR_STDNT_PR_OU appeal_dt:
682: -- The appeal_dt cannot be set unless decision_dt is set
683: -- The appeal_dt cannot be before the show_cause_dt (if set)
684: -- Cannot alter appeal_dt once appeal_outcome_dt has been set
685: -- If 'applicable' apply_before_appeal_ind is N then cannot

Line 803: -- Validate the IGS_PR_STDNT_PR_OU appeal_expiry_dt:

799: p_message_name OUT NOCOPY VARCHAR2 )
800: RETURN BOOLEAN IS
801: gv_other_detail VARCHAR2(255);
802: BEGIN -- prgp_val_spo_apl_exp
803: -- Validate the IGS_PR_STDNT_PR_OU appeal_expiry_dt:
804: -- The appeal_expiry_dt cannot be set to a past date
805: -- The appeal_expiry_dt cannot be before the show_cause_expiry_dt (if set)
806: -- Cannot alter appeal_expiry_dt once appeal_outcome_dt has been set
807: -- Warn if the appeal_expiry_dt is after the applicable appeal cut-off date

Line 932: -- Validate the IGS_PR_STDNT_PR_OU appeal_outcome_dt and

928: p_message_name OUT NOCOPY VARCHAR2 )
929: RETURN BOOLEAN IS
930: gv_other_detail VARCHAR2(255);
931: BEGIN -- prgp_val_spo_apl_out
932: -- Validate the IGS_PR_STDNT_PR_OU appeal_outcome_dt and
933: -- appeal_outcome_type:
934: -- * The appeal_outcome_dt, appeal_outcome_type cannot be set where appeal_dt
935: -- is not set
936: -- * Both appeal_outcome_dt, appeal_outcome_type must be set and unset together

Line 1175: -- Validate insert of IGS_PR_STDNT_PR_OU record, validating for

1171: p_message_name OUT NOCOPY VARCHAR2 )
1172: RETURN BOOLEAN IS
1173: gv_other_detail VARCHAR2(255);
1174: BEGIN -- prgp_val_spo_ins
1175: -- Validate insert of IGS_PR_STDNT_PR_OU record, validating for
1176: -- related course attempt must have status of ENROLLED/INACTIVE/INTERMIT/
1177: -- LAPSED / DISCONTIN
1178: -- If related to IGS_PR_SDT_PR_RU_CK cannot be record against passed rule.
1179: -- If related to student rule check, must be recorded against the latest

Line 1386: -- Validate that if IGS_PR_STDNT_PR_OU.restricted_attendance_type

1382: p_message_name OUT NOCOPY VARCHAR2)
1383: RETURN BOOLEAN IS
1384: gv_other_detail VARCHAR2(255);
1385: BEGIN -- prgp_val_spo_att
1386: -- Validate that if IGS_PR_STDNT_PR_OU.restricted_attendance_type
1387: -- is set that the progression_outcome_type relates to a
1388: -- s_encmb_effect_type of RSTR_AT_TY.
1389: DECLARE
1390: cst_rstr_at_ty CONSTANT VARCHAR(10) := 'RSTR_AT_TY';

Line 1446: -- Validate that if IGS_PR_STDNT_PR_OU.encmb_course_group_cd

1442: p_message_name OUT NOCOPY VARCHAR2 )
1443: RETURN BOOLEAN IS
1444: gv_other_detail VARCHAR2(255);
1445: BEGIN -- prgp_val_spo_cgr
1446: -- Validate that if IGS_PR_STDNT_PR_OU.encmb_course_group_cd
1447: -- is set that the progression_outcome_type relates to a
1448: -- s_encmb_effect_type of EXC_CRS_GP.
1449: DECLARE
1450: cst_exc_crs_gp CONSTANT VARCHAR(10) := 'EXC_CRS_GP';

Line 1506: -- Validate that if IGS_PR_STDNT_PR_OU.restricted_enrolment_cp is

1502: p_message_name OUT NOCOPY VARCHAR2 )
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';

Line 1576: -- If the IGS_PR_STDNT_PR_OU.duration or duration_type is being

1572: p_message_name OUT NOCOPY VARCHAR2 )
1573: RETURN BOOLEAN IS
1574: gv_other_detail VARCHAR2(255);
1575: BEGIN -- prgp_val_spo_drtn
1576: -- If the IGS_PR_STDNT_PR_OU.duration or duration_type is being
1577: -- changed and the decision_status has been set to approved then check that:
1578: -- the expiry_dt has not already passed
1579: -- the new expiry date would not have already passed
1580: DECLARE

Line 1583: v_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE;

1579: -- the new expiry date would not have already passed
1580: DECLARE
1581: cst_approved CONSTANT VARCHAR(10) := 'APPROVED';
1582: cst_expired CONSTANT VARCHAR(10) := 'EXPIRED';
1583: v_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE;
1584: v_apply_automatically_ind
1585: IGS_PR_RU_OU.apply_automatically_ind%TYPE;
1586: CURSOR c_spo_pro IS
1587: SELECT pro.apply_automatically_ind

Line 1588: FROM IGS_PR_STDNT_PR_OU spo,

1584: v_apply_automatically_ind
1585: IGS_PR_RU_OU.apply_automatically_ind%TYPE;
1586: CURSOR c_spo_pro IS
1587: SELECT pro.apply_automatically_ind
1588: FROM IGS_PR_STDNT_PR_OU spo,
1589: IGS_PR_RU_OU pro
1590: WHERE spo.person_id = p_person_id AND
1591: spo.course_cd = p_course_cd AND
1592: spo.sequence_number = p_sequence_number AND

Line 1717: -- If the IGS_PR_STDNT_PR_OU.decision_status is being set to approved

1713: ||================================================================================||
1714: */
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

Line 1739: v_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE;

1735: cst_ex_sp_disb CONSTANT VARCHAR(15) := 'EX_SP_DISB';
1736: cst_expired CONSTANT VARCHAR(10) := 'EXPIRED';
1737: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
1738: v_dummy VARCHAR2(1);
1739: v_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE;
1740: v_exit BOOLEAN DEFAULT FALSE;
1741: v_apply_automatically_ind VARCHAR2(1);
1742: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1743: CURSOR c_sca IS

Line 1788: FROM IGS_PR_STDNT_PR_OU spo,

1784: spo_sequence_number = p_sequence_number AND
1785: s_unit_type = cst_required;
1786: CURSOR c_spo_pro IS
1787: SELECT pro.apply_automatically_ind
1788: FROM IGS_PR_STDNT_PR_OU spo,
1789: IGS_PR_RU_OU pro
1790: WHERE spo.person_id = p_person_id AND
1791: spo.course_cd = p_course_cd AND
1792: spo.sequence_number = p_sequence_number AND

Line 1995: BEGIN -- Validate that if IGS_PR_STDNT_PR_OU.applied_dt.

1991: p_appeal_outcome_dt IN DATE ,
1992: p_message_name OUT NOCOPY VARCHAR2 )
1993: RETURN BOOLEAN IS
1994: gv_other_detail VARCHAR2(255);
1995: BEGIN -- Validate that if IGS_PR_STDNT_PR_OU.applied_dt.
1996: -- Cannot set applied_dt unless decision_status is APPROVED
1997: -- Cannot unset applied_dt unless decision_status is CANCELLED or REMOVED
1998: -- The applied_dt cannot be a future date
1999: -- The applied_dt must be on or after the decision_dt

Line 2140: -- Validate the IGS_PR_STDNT_PR_OU show cause details.

2136: p_message_name OUT NOCOPY VARCHAR2 )
2137: RETURN BOOLEAN IS
2138: gv_other_detail VARCHAR2(255);
2139: BEGIN -- prgp_val_spo_cause
2140: -- Validate the IGS_PR_STDNT_PR_OU show cause details.
2141: -- If show cause not allowed then show_cause_expiry_dt, show_cause_dt,
2142: -- show_cause_outcome_dt and show_cause_outcome_type cannot be set.
2143: DECLARE
2144: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 2205: -- Validate the IGS_PR_STDNT_PR_OU appeal details.

2201: p_message_name OUT NOCOPY VARCHAR2 )
2202: RETURN BOOLEAN IS
2203: gv_other_detail VARCHAR2(255);
2204: BEGIN -- prgp_val_spo_appeal
2205: -- Validate the IGS_PR_STDNT_PR_OU appeal details.
2206: -- If appeal not allowed then appeal_expiry_dt, appeal_dt,
2207: -- appeal_outcome_dt and appeal_outcome_type cannot be set.
2208: DECLARE
2209: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

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;

Line 2288: -- Validate that the IGS_PR_STDNT_PR_OU expiry_dt

2284: p_message_name OUT NOCOPY VARCHAR2 )
2285: RETURN BOOLEAN IS
2286: gv_other_detail VARCHAR2(255);
2287: BEGIN -- prgp_val_spo_exp_dt
2288: -- Validate that the IGS_PR_STDNT_PR_OU expiry_dt
2289: -- is not future dated. FORM ONLY!!!
2290: BEGIN
2291: -- Set the default message number
2292: p_message_name := null;