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_EN_VAL_SUSA dependencies on IGS_EN_STDNT_PS_ATT

Line 242: v_ver_no IGS_EN_STDNT_PS_ATT.version_number%TYPE;

238: -- * If the unit set is being specified as a child of another
239: -- IGS_AS_SU_SETATMPT, then then parent unit set version must be
240: -- permitted within the course_off_unit_set_relationship entries
241: DECLARE
242: v_ver_no IGS_EN_STDNT_PS_ATT.version_number%TYPE;
243: v_susa_us_version_no IGS_AS_SU_SETATMPT.us_version_number%TYPE;
244: v_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE;
245: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;
246: v_check VARCHAR2(1) := NULL;

Line 244: v_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE;

240: -- permitted within the course_off_unit_set_relationship entries
241: DECLARE
242: v_ver_no IGS_EN_STDNT_PS_ATT.version_number%TYPE;
243: v_susa_us_version_no IGS_AS_SU_SETATMPT.us_version_number%TYPE;
244: v_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE;
245: v_only_as_sub_ind IGS_PS_OFR_UNIT_SET.only_as_sub_ind%TYPE;
246: v_check VARCHAR2(1) := NULL;
247: -- Determine if the student's course offering and the course version
248: CURSOR c_sca IS

Line 251: FROM IGS_EN_STDNT_PS_ATT sca

247: -- Determine if the student's course offering and the course version
248: CURSOR c_sca IS
249: SELECT sca.version_number,
250: sca.cal_type
251: FROM IGS_EN_STDNT_PS_ATT sca
252: WHERE sca.person_id = p_person_id AND
253: sca.course_cd = p_course_cd;
254: CURSOR c_susa IS
255: SELECT susa.us_version_number

Line 263: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

259: susa.course_cd = p_course_cd AND
260: susa.unit_set_cd = p_parent_unit_set_cd AND
261: susa.sequence_number = p_parent_sequence_number;
262: CURSOR c_cousr(
263: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
264: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
265: cp_susa_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
266: SELECT 'x'
267: FROM IGS_PS_OF_UNT_SET_RL cousr

Line 264: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,

260: susa.unit_set_cd = p_parent_unit_set_cd AND
261: susa.sequence_number = p_parent_sequence_number;
262: CURSOR c_cousr(
263: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
264: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
265: cp_susa_us_version_number IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
266: SELECT 'x'
267: FROM IGS_PS_OF_UNT_SET_RL cousr
268: WHERE cousr.course_cd = p_course_cd AND

Line 276: cp_us_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

272: cousr.sub_us_version_number =p_us_version_number AND
273: cousr.sup_unit_set_cd = p_parent_unit_set_cd AND
274: cousr.sup_us_version_number = cp_susa_us_version_number;
275: CURSOR c_cousr2(
276: cp_us_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
277: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE) IS
278: SELECT 'x'
279: FROM IGS_PS_OF_UNT_SET_RL cousr
280: WHERE cousr.course_cd = p_course_cd AND

Line 277: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE) IS

273: cousr.sup_unit_set_cd = p_parent_unit_set_cd AND
274: cousr.sup_us_version_number = cp_susa_us_version_number;
275: CURSOR c_cousr2(
276: cp_us_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
277: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE) IS
278: SELECT 'x'
279: FROM IGS_PS_OF_UNT_SET_RL cousr
280: WHERE cousr.course_cd = p_course_cd AND
281: cousr.crv_version_number = cp_us_version_number AND

Line 444: IGS_EN_STDNT_PS_ATT sca

440: CURSOR c_acai_sca IS
441: SELECT acai.unit_set_cd,
442: acai.us_version_number
443: FROM IGS_AD_PS_APPL_INST acai,
444: IGS_EN_STDNT_PS_ATT sca
445: WHERE sca.person_id = p_person_id AND
446: sca.course_cd = p_course_cd AND
447: acai.person_id = sca.person_id AND
448: acai.admission_appl_number = sca.adm_admission_appl_number AND

Line 636: IGS_EN_STDNT_PS_ATT sca

632: CURSOR c_chk_us IS
633: SELECT acai.unit_set_cd,
634: acai.us_version_number
635: FROM IGS_AD_PS_APPL_INST acai,
636: IGS_EN_STDNT_PS_ATT sca
637: WHERE sca.person_id = p_person_id AND
638: sca.course_cd = p_course_cd AND
639: sca.person_id = acai.person_id AND
640: sca.adm_admission_appl_number = acai.admission_appl_number AND

Line 819: IGS_EN_STDNT_PS_ATT spa

815: SELECT 'X'
816: FROM IGS_PS_OFR_UNIT_SET cous,
817: igs_en_unit_set_stat uss1,
818: IGS_EN_UNIT_SET_ALL US,
819: IGS_EN_STDNT_PS_ATT spa
820: WHERE spa.person_id = p_person_id
821: AND spa.course_cd = p_course_cd
822: AND us.version_number = p_us_version_number
823: AND us.unit_set_cd = p_unit_set_cd

Line 842: IGS_EN_STDNT_PS_ATT spa

838: SELECT 'X'
839: FROM IGS_PS_OF_OPT_UNT_ST coous,
840: IGS_EN_UNIT_SET_ALL US,
841: igs_en_unit_set_stat uss1,
842: IGS_EN_STDNT_PS_ATT spa
843: WHERE spa.person_id = p_person_id
844: AND spa.course_cd = p_course_cd
845: AND coous.coo_id = spa.coo_id
846: AND us.version_number = p_us_version_number

Line 1252: -- a valid IGS_EN_STDNT_PS_ATT status.

1248: RETURN BOOLEAN AS
1249:
1250: BEGIN -- enrp_val_susa_sca
1251: -- This module validates the IGS_AS_SU_SETATMPT is created against
1252: -- a valid IGS_EN_STDNT_PS_ATT status.
1253: DECLARE
1254: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1255: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
1256: cst_deleted CONSTANT VARCHAR2(10) := 'DELETED';

Line 1260: FROM IGS_EN_STDNT_PS_ATT sca

1256: cst_deleted CONSTANT VARCHAR2(10) := 'DELETED';
1257: v_dummy VARCHAR2(1);
1258: CURSOR c_sca IS
1259: SELECT 'x'
1260: FROM IGS_EN_STDNT_PS_ATT sca
1261: WHERE sca.person_id = p_person_id AND
1262: sca.course_cd = p_course_cd AND
1263: sca.course_attempt_status IN ( cst_discontin,
1264: cst_lapsed,

Line 1330: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';

1326: -- - The student confirmed indicator cannot be set if the student
1327: -- is excluded from the unit set via encumbrances.
1328: DECLARE
1329: cst_enrolled CONSTANT
1330: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1331: cst_inactive CONSTANT
1332: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1333: v_dummy VARCHAR2(1);
1334: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 1332: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';

1328: DECLARE
1329: cst_enrolled CONSTANT
1330: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1331: cst_inactive CONSTANT
1332: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1333: v_dummy VARCHAR2(1);
1334: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1335: v_message_name VARCHAR2(30);
1336: CURSOR c_sca IS

Line 1334: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

1330: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1331: cst_inactive CONSTANT
1332: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1333: v_dummy VARCHAR2(1);
1334: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1335: v_message_name VARCHAR2(30);
1336: CURSOR c_sca IS
1337: SELECT sca.version_number
1338: FROM IGS_EN_STDNT_PS_ATT sca

Line 1338: FROM IGS_EN_STDNT_PS_ATT sca

1334: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1335: v_message_name VARCHAR2(30);
1336: CURSOR c_sca IS
1337: SELECT sca.version_number
1338: FROM IGS_EN_STDNT_PS_ATT sca
1339: WHERE sca.person_id = p_person_id AND
1340: sca.course_cd = p_course_cd AND
1341: sca.course_attempt_status IN (
1342:

Line 1357: FROM IGS_EN_STDNT_PS_ATT sca

1353:
1354:
1355: CURSOR c_sca_legacy IS
1356: SELECT sca.version_number
1357: FROM IGS_EN_STDNT_PS_ATT sca
1358: WHERE sca.person_id = p_person_id AND
1359: sca.course_cd = p_course_cd AND
1360: sca.course_attempt_status = 'UNCONFIRM';
1361:

Line 1528: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';

1524: -- - The student confirmed indicator cannot be set if
1525: -- rules exist preventing this.
1526: DECLARE
1527: cst_enrolled CONSTANT
1528: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1529: cst_inactive CONSTANT
1530: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1531: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1532: v_message_name VARCHAR2(30);

Line 1530: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';

1526: DECLARE
1527: cst_enrolled CONSTANT
1528: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1529: cst_inactive CONSTANT
1530: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1531: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1532: v_message_name VARCHAR2(30);
1533: CURSOR c_sca IS
1534: SELECT sca.version_number

Line 1531: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

1527: cst_enrolled CONSTANT
1528: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'ENROLLED';
1529: cst_inactive CONSTANT
1530: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'INACTIVE';
1531: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1532: v_message_name VARCHAR2(30);
1533: CURSOR c_sca IS
1534: SELECT sca.version_number
1535: FROM IGS_EN_STDNT_PS_ATT sca

Line 1535: FROM IGS_EN_STDNT_PS_ATT sca

1531: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1532: v_message_name VARCHAR2(30);
1533: CURSOR c_sca IS
1534: SELECT sca.version_number
1535: FROM IGS_EN_STDNT_PS_ATT sca
1536: WHERE sca.person_id = p_person_id AND
1537: sca.course_cd = p_course_cd AND
1538: sca.course_attempt_status IN (
1539: cst_enrolled,