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

Line 16: FROM IGS_EN_SU_ATTEMPT_ALL sua

12: l_rowid VARCHAR2(25);
13:
14: CURSOR c_sua (CP_ROW_ID VARCHAR2) IS
15: SELECT sua.*
16: FROM IGS_EN_SU_ATTEMPT_ALL sua
17: WHERE ROWID = CP_ROW_ID;
18:
19:
20: -- For Enhancement Bug 1287292

Line 587: FROM igs_en_su_attempt

583:
584: --Cursor to get the count of audit attempts
585: CURSOR c_audit_attempts_count(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
586: SELECT count(*)
587: FROM igs_en_su_attempt
588: WHERE no_assessment_ind='Y'
589: AND uoo_id = cp_uoo_id
590: AND unit_attempt_status in (cst_enrolled,cst_completed,cst_invalid,cst_unconfirm);
591: l_audit_attempts_count NUMBER;

Line 598: CURSOR cur_get_prog_ver(cp_person_id igs_en_su_attempt.person_id%TYPE,

594: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
595: l_waitlist_ind VARCHAR2(10);
596:
597: -- cursor that gets version number given person_id and course_cd
598: CURSOR cur_get_prog_ver(cp_person_id igs_en_su_attempt.person_id%TYPE,
599: cp_course_cd igs_en_su_attempt.course_cd%TYPE) IS
600: SELECT version_number
601: FROM igs_en_stdnt_ps_att
602: WHERE

Line 599: cp_course_cd igs_en_su_attempt.course_cd%TYPE) IS

595: l_waitlist_ind VARCHAR2(10);
596:
597: -- cursor that gets version number given person_id and course_cd
598: CURSOR cur_get_prog_ver(cp_person_id igs_en_su_attempt.person_id%TYPE,
599: cp_course_cd igs_en_su_attempt.course_cd%TYPE) IS
600: SELECT version_number
601: FROM igs_en_stdnt_ps_att
602: WHERE
603: person_id = cp_person_id AND

Line 621: CURSOR cur_count_wlsts_stud(cp_person_id igs_en_su_attempt.person_id%TYPE,

617: CURSOR cur_max_wlst_stud IS
618: SELECT max_waitlists_student_num
619: FROM IGS_EN_INST_WL_STPS;
620:
621: CURSOR cur_count_wlsts_stud(cp_person_id igs_en_su_attempt.person_id%TYPE,
622: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
623: cp_load_seq_num IGS_CA_INST.sequence_number%TYPE) IS
624: SELECT count(*)
625: FROM igs_en_su_attempt

Line 625: FROM igs_en_su_attempt

621: CURSOR cur_count_wlsts_stud(cp_person_id igs_en_su_attempt.person_id%TYPE,
622: cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
623: cp_load_seq_num IGS_CA_INST.sequence_number%TYPE) IS
624: SELECT count(*)
625: FROM igs_en_su_attempt
626: WHERE person_id = cp_person_id
627: AND unit_attempt_status =cst_waitlisted
628: AND (cal_type, ci_sequence_number) IN
629: (SELECT teach_cal_type, teach_ci_sequence_number

Line 641: CURSOR cur_wlst_same_unit(cp_person_id igs_en_su_attempt.person_id%TYPE,

637: FROM igs_ps_unit_ver
638: WHERE unit_cd = cp_unit_cd
639: AND version_number = cp_version_number;
640:
641: CURSOR cur_wlst_same_unit(cp_person_id igs_en_su_attempt.person_id%TYPE,
642: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
643: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
644: cp_cal_type IGS_CA_INST.cal_type%TYPE,
645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,

Line 642: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

638: WHERE unit_cd = cp_unit_cd
639: AND version_number = cp_version_number;
640:
641: CURSOR cur_wlst_same_unit(cp_person_id igs_en_su_attempt.person_id%TYPE,
642: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
643: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
644: cp_cal_type IGS_CA_INST.cal_type%TYPE,
645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
646: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS

Line 643: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

639: AND version_number = cp_version_number;
640:
641: CURSOR cur_wlst_same_unit(cp_person_id igs_en_su_attempt.person_id%TYPE,
642: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
643: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
644: cp_cal_type IGS_CA_INST.cal_type%TYPE,
645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
646: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
647: SELECT 'X'

Line 646: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS

642: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
643: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
644: cp_cal_type IGS_CA_INST.cal_type%TYPE,
645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
646: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
647: SELECT 'X'
648: FROM igs_en_su_attempt sua
649: WHERE sua.person_id = cp_person_id AND
650: sua.course_cd = cp_course_cd AND

Line 648: FROM igs_en_su_attempt sua

644: cp_cal_type IGS_CA_INST.cal_type%TYPE,
645: cp_sequence_number IGS_CA_INST.sequence_number%TYPE,
646: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE ) IS
647: SELECT 'X'
648: FROM igs_en_su_attempt sua
649: WHERE sua.person_id = cp_person_id AND
650: sua.course_cd = cp_course_cd AND
651: sua.unit_cd = cp_unit_cd AND
652: sua.cal_type = cp_cal_type AND

Line 668: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

664: WHERE cal_type = p_load_cal_type AND
665: smlnes_waitlist_alwd = 'N';
666:
667: CURSOR cur_simul_org_allwd(cp_load_cal_type IGS_CA_INST.cal_type%TYPE,
668: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
669: SELECT smtanus_wlst_unit_enr_alwd
670: FROM igs_En_or_unit_wlst
671: WHERE cal_type = cp_load_cal_type AND
672: closed_flag = 'N' AND

Line 981: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW

977: X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER,
978: X_CORE_INDICATOR_CODE IN VARCHAR2
979: ) AS
980: ------------------------------------------------------------------------------------------------
981: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW
982: -- and IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW added as part of Prevent Dropping Core Units. Enh Bug# 3052432
983: ------------------------------------------------------------------------------------------------
984:
985: new_references EN_SUA_REC_TYPE%TYPE;

Line 982: -- and IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW added as part of Prevent Dropping Core Units. Enh Bug# 3052432

978: X_CORE_INDICATOR_CODE IN VARCHAR2
979: ) AS
980: ------------------------------------------------------------------------------------------------
981: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW
982: -- and IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW added as part of Prevent Dropping Core Units. Enh Bug# 3052432
983: ------------------------------------------------------------------------------------------------
984:
985: new_references EN_SUA_REC_TYPE%TYPE;
986:

Line 990: IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW (

986:
987:
988: BEGIN
989: SAVEPOINT create_unit_attempt;
990: IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW (
991: X_ROWID,
992: X_PERSON_ID,
993: X_COURSE_CD,
994: X_UNIT_CD,

Line 1201: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (

1197: END IF;
1198:
1199: SAVEPOINT update_unit_attempt;
1200:
1201: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
1202: X_ROWID,
1203: X_PERSON_ID,
1204: X_COURSE_CD,
1205: X_UNIT_CD,

Line 1280: NVL(igs_en_su_attempt_pkg.pkg_source_of_drop,'NULL') <>'DROP' THEN

1276: -- this code is being commented here but will be replicated in Drop page
1277: -- StdDropAMImpl.java:dropSubmit
1278: --bdeviset 26-APR-2006 Modified if condition for bug# 5119136
1279: IF X_UNIT_ATTEMPT_STATUS NOT IN ('DROPPED','DISCONTIN' ) OR
1280: NVL(igs_en_su_attempt_pkg.pkg_source_of_drop,'NULL') <>'DROP' THEN
1281: OPEN C_SUA (X_ROWID);
1282: FETCH C_SUA INTO new_references;
1283: CLOSE C_SUA;
1284:

Line 1330: FROM igs_en_su_attempt sua, igs_ps_unit_ofr_opt uoo

1326: l_sub_uoo igs_ps_unit_ofr_opt.uoo_id%TYPE;
1327:
1328: CURSOR cur_sub_uoo IS
1329: SELECT sua.uoo_id sub_uoo_id, sua.unit_attempt_status sub_uoo_status
1330: FROM igs_en_su_attempt sua, igs_ps_unit_ofr_opt uoo
1331: WHERE uoo.sup_uoo_id = p_uoo_id
1332: AND uoo.relation_type = 'SUBORDINATE'
1333: AND sua.uoo_id = uoo.uoo_id
1334: AND sua.person_id = p_person_id

Line 1338: l_sub_uoo_status igs_en_su_attempt.unit_attempt_status%TYPE;

1334: AND sua.person_id = p_person_id
1335: AND sua.course_cd = p_course_cd
1336: AND sua.unit_attempt_status <> 'DUPLICATE';
1337:
1338: l_sub_uoo_status igs_en_su_attempt.unit_attempt_status%TYPE;
1339:
1340: CURSOR cur_sup_uoo IS
1341: SELECT uoo.sup_uoo_id sup_uoo_id, sua.unit_attempt_status sup_uoo_status
1342: FROM igs_en_su_attempt sua, igs_ps_unit_ofr_opt uoo

Line 1342: FROM igs_en_su_attempt sua, igs_ps_unit_ofr_opt uoo

1338: l_sub_uoo_status igs_en_su_attempt.unit_attempt_status%TYPE;
1339:
1340: CURSOR cur_sup_uoo IS
1341: SELECT uoo.sup_uoo_id sup_uoo_id, sua.unit_attempt_status sup_uoo_status
1342: FROM igs_en_su_attempt sua, igs_ps_unit_ofr_opt uoo
1343: WHERE uoo.uoo_id = p_uoo_id
1344: AND uoo.sup_uoo_id = sua.uoo_id
1345: AND sua.person_id = p_person_id
1346: AND sua.course_cd = p_course_cd;

Line 1349: l_sup_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;

1345: AND sua.person_id = p_person_id
1346: AND sua.course_cd = p_course_cd;
1347:
1348: l_sup_uoo_Id igs_ps_unit_ofr_opt.uoo_id%TYPE;
1349: l_sup_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
1350:
1351:
1352: BEGIN
1353: --initialize out parameter

Line 1536: igs_en_su_attempt sua

1532:
1533: CURSOR cur_sub IS
1534: SELECT sua.unit_attempt_status
1535: FROM igs_ps_unit_ofr_opt uoo,
1536: igs_en_su_attempt sua
1537: WHERE uoo.sup_uoo_id = p_uoo_id
1538: AND uoo.relation_type = 'SUPERIOR'
1539: AND sua.uoo_id = uoo.uoo_id
1540: AND sua.person_Id = p_person_id

Line 1544: v_sub_status igs_en_su_attempt.unit_attempt_status%TYPE;

1540: AND sua.person_Id = p_person_id
1541: AND sua.course_cd = p_course_cd
1542: AND sua.unit_attempt_status NOT IN ('DROPPED','DUPLICATE');
1543:
1544: v_sub_status igs_en_su_attempt.unit_attempt_status%TYPE;
1545: v_sup igs_ps_unit_ofr_opt.relation_type%TYPE;
1546:
1547: BEGIN
1548: