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_ENROLL_WLST dependencies on IGS_PS_USEC_LIM_WLST

Line 10: p_max_quota IN igs_ps_usec_lim_wlst.enrollment_maximum%TYPE,

6: p_person_id igs_pe_person.person_id%TYPE,
7: p_course_cd igs_en_su_attempt.course_cd%TYPE,
8: p_waitlist_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.waitlist_actual%TYPE,
9: p_enrollment_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.enrollment_actual%TYPE,
10: p_max_quota IN igs_ps_usec_lim_wlst.enrollment_maximum%TYPE,
11: p_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE,
12: p_enrolled_yn OUT NOCOPY VARCHAR2 ,
13: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
14: p_version_number igs_en_su_attempt.version_number%TYPE,

Line 11: p_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE,

7: p_course_cd igs_en_su_attempt.course_cd%TYPE,
8: p_waitlist_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.waitlist_actual%TYPE,
9: p_enrollment_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.enrollment_actual%TYPE,
10: p_max_quota IN igs_ps_usec_lim_wlst.enrollment_maximum%TYPE,
11: p_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE,
12: p_enrolled_yn OUT NOCOPY VARCHAR2 ,
13: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,
14: p_version_number igs_en_su_attempt.version_number%TYPE,
15: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE

Line 1424: lv_max_quota igs_ps_usec_lim_wlst.enrollment_maximum%TYPE; --maximun quota

1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class
1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist
1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment
1423:
1424: lv_max_quota igs_ps_usec_lim_wlst.enrollment_maximum%TYPE; --maximun quota
1425: lv_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE; --maximun students per waitlist
1426: lv_enrolled_yn VARCHAR2(1);
1427: --unit section (unit offering option -uoo_id)
1428: CURSOR igs_ps_unit_ofr_opt_cur

Line 1425: lv_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE; --maximun students per waitlist

1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist
1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment
1423:
1424: lv_max_quota igs_ps_usec_lim_wlst.enrollment_maximum%TYPE; --maximun quota
1425: lv_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE; --maximun students per waitlist
1426: lv_enrolled_yn VARCHAR2(1);
1427: --unit section (unit offering option -uoo_id)
1428: CURSOR igs_ps_unit_ofr_opt_cur
1429: IS

Line 1443: CURSOR igs_ps_usec_lim_wlst_cur IS

1439: WHERE unit_section_status = 'HOLD'
1440: AND uoo_id = p_uoo_id;
1441:
1442: --maximum quota (max_quota) and maximum students per waitlist - Will be setting it to 9999 (unlimited) if null or no row
1443: CURSOR igs_ps_usec_lim_wlst_cur IS
1444: SELECT NVL (usec.enrollment_maximum, NVL(uv.enrollment_maximum,9999) ) enrollment_maximum,
1445: usec.max_students_per_waitlist
1446: FROM igs_ps_usec_lim_wlst usec,
1447: igs_ps_unit_ver uv,

Line 1446: FROM igs_ps_usec_lim_wlst usec,

1442: --maximum quota (max_quota) and maximum students per waitlist - Will be setting it to 9999 (unlimited) if null or no row
1443: CURSOR igs_ps_usec_lim_wlst_cur IS
1444: SELECT NVL (usec.enrollment_maximum, NVL(uv.enrollment_maximum,9999) ) enrollment_maximum,
1445: usec.max_students_per_waitlist
1446: FROM igs_ps_usec_lim_wlst usec,
1447: igs_ps_unit_ver uv,
1448: igs_ps_unit_ofr_opt uoo
1449: WHERE uoo.unit_cd = uv.unit_cd
1450: AND uoo.version_number = uv.version_number

Line 1556: OPEN igs_ps_usec_lim_wlst_cur;

1552: lv_unit_class,
1553: lv_waitlist_actual,
1554: lv_enrollment_actual;
1555:
1556: OPEN igs_ps_usec_lim_wlst_cur;
1557: FETCH igs_ps_usec_lim_wlst_cur INTO lv_max_quota,
1558: lv_max_stdnts_per_wlst;
1559: IF igs_ps_usec_lim_wlst_cur%NOTFOUND THEN
1560: lv_max_quota := 9999;

Line 1557: FETCH igs_ps_usec_lim_wlst_cur INTO lv_max_quota,

1553: lv_waitlist_actual,
1554: lv_enrollment_actual;
1555:
1556: OPEN igs_ps_usec_lim_wlst_cur;
1557: FETCH igs_ps_usec_lim_wlst_cur INTO lv_max_quota,
1558: lv_max_stdnts_per_wlst;
1559: IF igs_ps_usec_lim_wlst_cur%NOTFOUND THEN
1560: lv_max_quota := 9999;
1561: lv_max_stdnts_per_wlst := 9999;

Line 1559: IF igs_ps_usec_lim_wlst_cur%NOTFOUND THEN

1555:
1556: OPEN igs_ps_usec_lim_wlst_cur;
1557: FETCH igs_ps_usec_lim_wlst_cur INTO lv_max_quota,
1558: lv_max_stdnts_per_wlst;
1559: IF igs_ps_usec_lim_wlst_cur%NOTFOUND THEN
1560: lv_max_quota := 9999;
1561: lv_max_stdnts_per_wlst := 9999;
1562: END IF;
1563: CLOSE igs_ps_usec_lim_wlst_cur;

Line 1563: CLOSE igs_ps_usec_lim_wlst_cur;

1559: IF igs_ps_usec_lim_wlst_cur%NOTFOUND THEN
1560: lv_max_quota := 9999;
1561: lv_max_stdnts_per_wlst := 9999;
1562: END IF;
1563: CLOSE igs_ps_usec_lim_wlst_cur;
1564:
1565: IF lv_max_quota IS NULL THEN
1566: lv_max_quota := 9999;
1567: END IF;