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_FUTURE_DT_TRANS dependencies on IGS_EN_SU_ATTEMPT

Line 1260: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1256:
1257: -- procedure to delete all the unit attempt reference codes
1258: PROCEDURE del_suar(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1259: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1260: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1261: IS
1262:
1263: CURSOR cur_sua_ref_cds(cp_person_id NUMBER,
1264: cp_course_cd VARCHAR2,

Line 1292: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1288:
1289:
1290: PROCEDURE del_as_anon_id_us(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1291: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1292: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1293: IS
1294:
1295: CURSOR c_del_as_anon_id_us IS
1296: SELECT rowid

Line 1331: -- (1) Delete IGS_EN_SU_ATTEMPT records

1327: )
1328: RETURN BOOLEAN
1329: IS
1330: BEGIN -- del_sua
1331: -- (1) Delete IGS_EN_SU_ATTEMPT records
1332: DECLARE
1333: CURSOR c_sua IS
1334: SELECT uoo_id
1335: FROM IGS_EN_SU_ATTEMPT sua

Line 1335: FROM IGS_EN_SU_ATTEMPT sua

1331: -- (1) Delete IGS_EN_SU_ATTEMPT records
1332: DECLARE
1333: CURSOR c_sua IS
1334: SELECT uoo_id
1335: FROM IGS_EN_SU_ATTEMPT sua
1336: WHERE sua.person_id = p_person_id
1337: AND sua.course_cd = p_dest_course_cd;
1338:
1339: CURSOR c_sua_del (

Line 1340: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

1336: WHERE sua.person_id = p_person_id
1337: AND sua.course_cd = p_dest_course_cd;
1338:
1339: CURSOR c_sua_del (
1340: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
1341: SELECT rowid
1342: FROM IGS_EN_SU_ATTEMPT sua
1343: WHERE sua.person_id = p_person_id
1344: AND sua.course_cd = p_dest_course_cd

Line 1342: FROM IGS_EN_SU_ATTEMPT sua

1338:
1339: CURSOR c_sua_del (
1340: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
1341: SELECT rowid
1342: FROM IGS_EN_SU_ATTEMPT sua
1343: WHERE sua.person_id = p_person_id
1344: AND sua.course_cd = p_dest_course_cd
1345: AND sua.uoo_id = cp_uoo_id
1346: FOR UPDATE OF sua.LAST_UPDATE_DATE NOWAIT;

Line 1368: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW( X_ROWID => v_sua_del_exists.rowid );

1364: del_suar(p_person_id, p_dest_course_Cd, v_sua_rec.uoo_id);
1365:
1366: del_as_anon_id_us( p_person_id,p_dest_course_cd,v_sua_rec.uoo_id);
1367:
1368: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW( X_ROWID => v_sua_del_exists.rowid );
1369:
1370: END IF;
1371:
1372: END LOOP;

Line 1407: -- (1) Update IGS_EN_SU_ATTEMPT records

1403: p_term_cal_type IGS_CA_INST.cal_type%TYPE,
1404: p_term_sequence_number IGS_CA_INST.sequence_number%TYPE)
1405: IS
1406: BEGIN -- upd_sua
1407: -- (1) Update IGS_EN_SU_ATTEMPT records
1408: DECLARE
1409:
1410: cst_dropped CONSTANT VARCHAR2(10) := 'DROPPED';
1411:

Line 1414: FROM IGS_EN_SU_ATTEMPT sua

1410: cst_dropped CONSTANT VARCHAR2(10) := 'DROPPED';
1411:
1412: CURSOR c_sua IS
1413: SELECT uoo_id
1414: FROM IGS_EN_SU_ATTEMPT sua
1415: WHERE sua.person_id = p_person_id
1416: AND sua.course_cd = p_dest_course_cd;
1417:
1418: CURSOR c_sua_upd (

Line 1419: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

1415: WHERE sua.person_id = p_person_id
1416: AND sua.course_cd = p_dest_course_cd;
1417:
1418: CURSOR c_sua_upd (
1419: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
1420: SELECT rowid,sua.*
1421: FROM IGS_EN_SU_ATTEMPT sua
1422: WHERE sua.person_id = p_person_id
1423: AND sua.course_cd = p_dest_course_cd

Line 1421: FROM IGS_EN_SU_ATTEMPT sua

1417:
1418: CURSOR c_sua_upd (
1419: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
1420: SELECT rowid,sua.*
1421: FROM IGS_EN_SU_ATTEMPT sua
1422: WHERE sua.person_id = p_person_id
1423: AND sua.course_cd = p_dest_course_cd
1424: AND sua.uoo_id = cp_uoo_id
1425: AND sua.unit_attempt_status <> cst_dropped

Line 1458: X_UNIT_ATTEMPT_STATUS => cst_dropped, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,

1454: X_CI_START_DT => v_sua_upd_exists.CI_START_DT,
1455: X_CI_END_DT => v_sua_upd_exists.CI_END_DT,
1456: X_UOO_ID => v_sua_upd_exists.UOO_ID ,
1457: X_ENROLLED_DT => v_sua_upd_exists.ENROLLED_DT,
1458: X_UNIT_ATTEMPT_STATUS => cst_dropped, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1459: X_ADMINISTRATIVE_UNIT_STATUS => v_sua_upd_exists.administrative_unit_status,
1460: X_ADMINISTRATIVE_PRIORITY => v_sua_upd_exists.administrative_PRIORITY,
1461: X_DISCONTINUED_DT => nvl(v_sua_upd_exists.discontinued_dt,trunc(SYSDATE)),
1462: X_DCNT_REASON_CD => v_sua_upd_exists.DCNT_REASON_CD,

Line 1543: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1539: END upd_sua;
1540:
1541: PROCEDURE del_as_stmptout(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1542: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1543: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1544: IS
1545:
1546: CURSOR c_del_as_stmptout(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1547: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 1548: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1544: IS
1545:
1546: CURSOR c_del_as_stmptout(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1547: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1548: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1549: IS
1550: SELECT rowid
1551: FROM igs_as_su_stmptout_all stmptout
1552: WHERE stmptout.person_id = cp_person_id

Line 1577: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1573: END del_as_stmptout;
1574:
1575: PROCEDURE del_ps_stdnt_unt_trn(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1576: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1577: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1578: IS
1579:
1580: CURSOR c_del_ps_stdnt_unt_trn(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1581: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 1582: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1578: IS
1579:
1580: CURSOR c_del_ps_stdnt_unt_trn(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1581: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1582: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1583: IS
1584: SELECT rowid
1585: FROM IGS_PS_STDNT_UNT_TRN unttrn
1586: WHERE unttrn.person_id = cp_person_id

Line 1611: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1607: END del_ps_stdnt_unt_trn;
1608:
1609: PROCEDURE del_as_sua_ses_atts(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1610: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1611: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1612: IS
1613:
1614: CURSOR c_del_as_sua_ses_atts(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1615: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 1616: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1612: IS
1613:
1614: CURSOR c_del_as_sua_ses_atts(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1615: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1616: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1617: IS
1618: SELECT rowid
1619: FROM igs_as_sua_ses_atts sua_ses_atts
1620: WHERE sua_ses_atts.person_id = cp_person_id

Line 1655: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1651: END del_as_sua_ses_atts;
1652:
1653: PROCEDURE del_as_msht_su_atmpt(p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1654: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1655: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1656: IS
1657:
1658: CURSOR c_del_as_msht_su_atmpt(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1659: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

Line 1660: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)

1656: IS
1657:
1658: CURSOR c_del_as_msht_su_atmpt(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1659: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
1660: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
1661: IS
1662: SELECT rowid
1663: FROM IGS_AS_MSHT_SU_ATMPT as_msht_su_atmpt
1664: WHERE as_msht_su_atmpt.person_id = cp_person_id

Line 1749: FROM IGS_EN_SU_ATTEMPT sua

1745: -- cursor for fetching the student unit attempt details having status other than dropped or uncofirmed
1746: CURSOR c_sua (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1747: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1748: SELECT 'X'
1749: FROM IGS_EN_SU_ATTEMPT sua
1750: WHERE sua.person_id = cp_person_id
1751: AND sua.course_cd = cp_course_cd
1752: AND sua.unit_attempt_status NOT IN ('DROPPED','UNCONFIRM');
1753:

Line 1758: FROM IGS_EN_SU_ATTEMPT sua

1754: -- cursor for fetching the student unit attempt details having status as dropped
1755: CURSOR c_sua_drop (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1756: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1757: SELECT 'X'
1758: FROM IGS_EN_SU_ATTEMPT sua
1759: WHERE sua.person_id = cp_person_id
1760: AND sua.course_cd = cp_course_cd
1761: AND sua.unit_attempt_status = 'DROPPED';
1762:

Line 2366: FROM IGS_EN_SU_ATTEMPT sua

2362: CURSOR c_uoo (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2363: cp_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2364: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
2365: SELECT uoo_id,core_indicator_code,unit_attempt_status
2366: FROM IGS_EN_SU_ATTEMPT sua
2367: WHERE person_id = cp_person_id
2368: AND course_cd = cp_src_course_cd
2369: AND not exists (SELECT 'x'
2370: FROM igs_en_su_attempt sua2

Line 2370: FROM igs_en_su_attempt sua2

2366: FROM IGS_EN_SU_ATTEMPT sua
2367: WHERE person_id = cp_person_id
2368: AND course_cd = cp_src_course_cd
2369: AND not exists (SELECT 'x'
2370: FROM igs_en_su_attempt sua2
2371: WHERE person_id = cp_person_id
2372: AND course_cd= cp_dest_course_cd
2373: AND unit_attempt_status <> 'DROPPED'
2374: AND sua.uoo_id = sua2.uoo_id)

Line 2846: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE

2842:
2843: FUNCTION del_sua_for_reopen(
2844: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2845: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2846: p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
2847: )
2848: RETURN BOOLEAN
2849: AS
2850: CURSOR c_sua_del (

Line 2853: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE

2849: AS
2850: CURSOR c_sua_del (
2851: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2852: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2853: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
2854: ) IS
2855: SELECT rowid
2856: FROM IGS_EN_SU_ATTEMPT sua
2857: WHERE sua.person_id = cp_person_id

Line 2856: FROM IGS_EN_SU_ATTEMPT sua

2852: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2853: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
2854: ) IS
2855: SELECT rowid
2856: FROM IGS_EN_SU_ATTEMPT sua
2857: WHERE sua.person_id = cp_person_id
2858: AND sua.course_cd = cp_course_cd
2859: AND sua.uoo_id = cp_uoo_id
2860: FOR UPDATE OF sua.LAST_UPDATE_DATE NOWAIT;

Line 2885: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW( X_ROWID => v_sua_del_exists.rowid );

2881:
2882: del_as_sua_ses_atts( p_person_id,p_course_cd,p_uoo_id);
2883:
2884:
2885: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW( X_ROWID => v_sua_del_exists.rowid );
2886:
2887:
2888:
2889: END LOOP;