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.

[Home] [Help]

APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_VER

Line 468: from igs_ge_note a, igs_ps_unit_ver_note b

464: cursor c_unit_note is
465: select
466: a.note_text,
467: b.crs_note_type
468: from igs_ge_note a, igs_ps_unit_ver_note b
469: where a.reference_number = b.reference_number
470: and b.unit_cd = p_unit_cd
471: and b.version_number = p_version_number
472: order by crs_note_type ;

Line 576: igs_ps_unit_ver uv ,

572: SELECT
573: uv.title,
574: usub.subtitle
575: FROM
576: igs_ps_unit_ver uv ,
577: igs_ps_unit_subtitle usub
578: WHERE
579: uv.unit_cd = cp_unit_cd AND
580: uv.version_number = cp_version_number AND

Line 589: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

585: from igs_ps_unit_ofr_opt
586: where uoo_id = cp_uoo_id;
587:
588: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
589: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

Line 591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

587:
588: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
589: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;

Line 593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

589: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
597: BEGIN

Line 595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;

591: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
597: BEGIN
598: IF p_unit_cd IS NULL THEN
599: OPEN cur_fetch_unit_dtls(p_uoo_id);

Line 596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;

592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
593: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
595: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
596: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
597: BEGIN
598: IF p_unit_cd IS NULL THEN
599: OPEN cur_fetch_unit_dtls(p_uoo_id);
600: FETCH cur_fetch_unit_dtls into l_unit_cd, l_unit_ver;

Line 687: igs_ps_unit_ver uv ,

683: SELECT
684: uv.title,
685: usub.subtitle
686: FROM
687: igs_ps_unit_ver uv ,
688: igs_ps_unit_subtitle usub
689: WHERE
690: uv.unit_cd = p_unit_cd AND
691: uv.version_number = p_version_number AND

Line 694: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

690: uv.unit_cd = p_unit_cd AND
691: uv.version_number = p_version_number AND
692: uv.subtitle_id = usub.subtitle_id(+);
693: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
694: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
696: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
698: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

Line 696: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

692: uv.subtitle_id = usub.subtitle_id(+);
693: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
694: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
696: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
698: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
700: BEGIN

Line 698: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

694: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
696: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
698: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
700: BEGIN
701: -- first check if title and subtitle exists at student level
702: OPEN stdnt_subtitle_dtls;

Line 772: igs_ps_unit_ver uv ,

768: SELECT
769: uv.title,
770: usub.subtitle
771: FROM
772: igs_ps_unit_ver uv ,
773: igs_ps_unit_subtitle usub
774: WHERE
775: uv.unit_cd = p_unit_cd AND
776: uv.version_number = p_version_number AND

Line 779: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

775: uv.unit_cd = p_unit_cd AND
776: uv.version_number = p_version_number AND
777: uv.subtitle_id = usub.subtitle_id(+);
778: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
779: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
781: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
783: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

Line 781: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

777: uv.subtitle_id = usub.subtitle_id(+);
778: title_subtitle_dtls_rec usec_subtitle_dtls%ROWTYPE;
779: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
781: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
783: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
785: BEGIN

Line 783: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;

779: l_stdnt_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
781: l_usec_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
783: l_uv_title igs_ps_unit_ver.title%TYPE DEFAULT NULL;
784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;
785: BEGIN
786: -- first check if title and subtitle exists at student level
787: OPEN stdnt_subtitle_dtls;

Line 1189: igs_ps_unit_ver uv

1185: NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) credit_points
1186: FROM
1187: igs_ps_unit_ofr_opt uoo,
1188: igs_ps_usec_cps cps,
1189: igs_ps_unit_ver uv
1190: WHERE
1191: uoo.uoo_id=cps.uoo_id(+) AND
1192: uoo.uoo_id=p_uoo_id AND
1193: uoo.unit_cd=uv.unit_cd AND

Line 1208: l_unit_credit_pts igs_ps_unit_ver.enrolled_credit_points%TYPE DEFAULT NULL;

1204: sua.person_id = p_person_id AND
1205: sua.uoo_id = p_uoo_id AND
1206: sua.course_cd= p_course_cd;
1207:
1208: l_unit_credit_pts igs_ps_unit_ver.enrolled_credit_points%TYPE DEFAULT NULL;
1209: l_stdnt_credit_pts igs_ps_unit_ver.enrolled_credit_points%TYPE DEFAULT NULL;
1210:
1211: BEGIN
1212: -- verify at student level and return if value found

Line 1209: l_stdnt_credit_pts igs_ps_unit_ver.enrolled_credit_points%TYPE DEFAULT NULL;

1205: sua.uoo_id = p_uoo_id AND
1206: sua.course_cd= p_course_cd;
1207:
1208: l_unit_credit_pts igs_ps_unit_ver.enrolled_credit_points%TYPE DEFAULT NULL;
1209: l_stdnt_credit_pts igs_ps_unit_ver.enrolled_credit_points%TYPE DEFAULT NULL;
1210:
1211: BEGIN
1212: -- verify at student level and return if value found
1213: IF p_person_id IS NOT NULL THEN

Line 1360: CURSOR c_unit_cp(p_unit_cd igs_ps_unit_ver.unit_cd%TYPE,p_unit_ver igs_ps_unit_ver.version_number%TYPE) IS

1356: variable_increment
1357: FROM igs_ps_usec_cps
1358: WHERE uoo_id = p_uoo_id;
1359:
1360: CURSOR c_unit_cp(p_unit_cd igs_ps_unit_ver.unit_cd%TYPE,p_unit_ver igs_ps_unit_ver.version_number%TYPE) IS
1361: SELECT
1362: POINTS_MIN ,
1363: POINTS_MAX ,
1364: points_increment

Line 1365: FROM igs_ps_unit_ver

1361: SELECT
1362: POINTS_MIN ,
1363: POINTS_MAX ,
1364: points_increment
1365: FROM igs_ps_unit_ver
1366: WHERE unit_cd = p_unit_cd
1367: AND version_number = p_unit_ver;
1368:
1369: CURSOR c_enr_cp IS

Line 1374: igs_ps_unit_ver uv

1370: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
1371: FROM
1372: igs_ps_unit_ofr_opt uoo,
1373: igs_ps_usec_cps cps,
1374: igs_ps_unit_ver uv
1375: WHERE
1376: uoo.uoo_id = cps.uoo_id(+) AND
1377: uoo.uoo_id=p_uoo_id AND
1378: uoo.unit_cd=uv.unit_cd AND

Line 1387: l_unit_min_cp igs_ps_unit_ver.points_min%TYPE;

1383: l_usec_min_cp igs_ps_usec_cps.minimum_credit_points%TYPE;
1384: l_usec_max_cp igs_ps_usec_cps.maximum_credit_points%TYPE;
1385: l_usec_var igs_ps_usec_cps.variable_increment%TYPE;
1386:
1387: l_unit_min_cp igs_ps_unit_ver.points_min%TYPE;
1388: l_unit_max_cp igs_ps_unit_ver.points_max%TYPE;
1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;
1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
1391:

Line 1388: l_unit_max_cp igs_ps_unit_ver.points_max%TYPE;

1384: l_usec_max_cp igs_ps_usec_cps.maximum_credit_points%TYPE;
1385: l_usec_var igs_ps_usec_cps.variable_increment%TYPE;
1386:
1387: l_unit_min_cp igs_ps_unit_ver.points_min%TYPE;
1388: l_unit_max_cp igs_ps_unit_ver.points_max%TYPE;
1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;
1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
1391:
1392: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;

Line 1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;

1385: l_usec_var igs_ps_usec_cps.variable_increment%TYPE;
1386:
1387: l_unit_min_cp igs_ps_unit_ver.points_min%TYPE;
1388: l_unit_max_cp igs_ps_unit_ver.points_max%TYPE;
1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;
1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
1391:
1392: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
1393: l_unit_ver igs_ps_unit_ver.version_number%TYPE;

Line 1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;

1386:
1387: l_unit_min_cp igs_ps_unit_ver.points_min%TYPE;
1388: l_unit_max_cp igs_ps_unit_ver.points_max%TYPE;
1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;
1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
1391:
1392: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
1393: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
1394:

Line 1392: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;

1388: l_unit_max_cp igs_ps_unit_ver.points_max%TYPE;
1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;
1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
1391:
1392: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
1393: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
1394:
1395: l_count NUMBER(6,3) DEFAULT 0;
1396: l_return_val VARCHAR2(10000);

Line 1393: l_unit_ver igs_ps_unit_ver.version_number%TYPE;

1389: l_unit_var igs_ps_unit_ver.points_increment%TYPE;
1390: l_enr_cr_points igs_ps_unit_ver.enrolled_credit_points%TYPE;
1391:
1392: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
1393: l_unit_ver igs_ps_unit_ver.version_number%TYPE;
1394:
1395: l_count NUMBER(6,3) DEFAULT 0;
1396: l_return_val VARCHAR2(10000);
1397:

Line 1607: FROM igs_ps_unit_ver_v

1603: WHERE uoo_id =p_uooid;
1604: --Cursor to fetch the limits for Unit Code
1605: CURSOR cur_get_unit_maxmin_limits IS
1606: SELECT enrollment_minimum,enrollment_maximum
1607: FROM igs_ps_unit_ver_v
1608: WHERE unit_cd=p_unitcode
1609: AND version_number=p_version;
1610:
1611: BEGIN

Line 1974: FROM igs_ps_unit_ver

1970:
1971: -- cursor to fetch the enrollment maximum value defined at unit level
1972: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1973: SELECT enrollment_maximum
1974: FROM igs_ps_unit_ver
1975: WHERE (unit_cd , version_number ) IN (SELECT unit_cd , version_number
1976: FROM igs_ps_unit_ofr_opt
1977: WHERE uoo_id = p_uoo_id);
1978:

Line 2673: v_sup_unit_cd IGS_PS_UNIT_VER.UNIT_CD%TYPE;

2669: SELECT unit_cd
2670: FROM igs_ps_unit_ofr_opt
2671: WHERE uoo_id = cp_sup_uoo_id;
2672:
2673: v_sup_unit_cd IGS_PS_UNIT_VER.UNIT_CD%TYPE;
2674: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
2675:
2676: BEGIN
2677:

Line 2746: FROM IGS_PS_UNIT_VER_NOTE UV,

2742: AND ROWNUM < 2;
2743:
2744: CURSOR c_uv (cp_n_uoo_id IN NUMBER) IS
2745: SELECT 1
2746: FROM IGS_PS_UNIT_VER_NOTE UV,
2747: IGS_PS_UNIT_OFR_OPT_ALL UOO
2748: WHERE UOO.UNIT_CD = UV.UNIT_CD
2749: AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
2750: AND UOO.UOO_ID = cp_n_uoo_id

Line 2867: Select title from igs_ps_unit_ver

2863:
2864: FUNCTION get_title_for_unit(p_unit_cd IN VARCHAR2, p_version IN NUMBER) RETURN VARCHAR2
2865: IS
2866: Cursor cur_title(cp_unit_cd VARCHAR2, cp_version NUMBER) IS
2867: Select title from igs_ps_unit_ver
2868: where unit_cd=cp_unit_cd
2869: and version_number=cp_version;
2870:
2871: l_title igs_ps_unit_ver.title%TYPE;

Line 2871: l_title igs_ps_unit_ver.title%TYPE;

2867: Select title from igs_ps_unit_ver
2868: where unit_cd=cp_unit_cd
2869: and version_number=cp_version;
2870:
2871: l_title igs_ps_unit_ver.title%TYPE;
2872: BEGIN
2873: OPEN cur_title(p_unit_cd,p_version);
2874: FETCH cur_title INTO l_title;
2875: CLOSE cur_title;

Line 2939: from igs_ps_unit_ver

2935:
2936: Cursor c_check2(cp_unit_cd VARCHAR2,
2937: cp_version NUMBER) IS
2938: select enrollment_maximum
2939: from igs_ps_unit_ver
2940: where unit_cd=cp_unit_cd
2941: and version_number=cp_version;
2942:
2943: l_result igs_ps_usec_lim_wlst.enrollment_maximum%TYPE DEFAULT NULL;

Line 2973: from igs_ps_unit_ver

2969:
2970: Cursor c_check2(cp_unit_cd VARCHAR2,
2971: cp_version NUMBER) IS
2972: select enrollment_minimum
2973: from igs_ps_unit_ver
2974: where unit_cd=cp_unit_cd
2975: and version_number=cp_version;
2976:
2977: l_result igs_ps_usec_lim_wlst.enrollment_minimum%TYPE DEFAULT NULL;

Line 3398: igs_ps_unit_ver_all uv

3394:
3395: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
3396: SELECT uv.title
3397: FROM igs_ps_unit_ofr_opt_all us,
3398: igs_ps_unit_ver_all uv
3399: WHERE us.uoo_id = cp_n_uoo_id
3400: AND us.unit_cd = uv.unit_cd
3401: AND us.version_number = uv.version_number;
3402:

Line 3403: l_c_title igs_ps_unit_ver_all.title%TYPE;

3399: WHERE us.uoo_id = cp_n_uoo_id
3400: AND us.unit_cd = uv.unit_cd
3401: AND us.version_number = uv.version_number;
3402:
3403: l_c_title igs_ps_unit_ver_all.title%TYPE;
3404: BEGIN
3405: OPEN c_us_title (p_n_uoo_id);
3406: FETCH c_us_title INTO l_c_title;
3407: CLOSE c_us_title;

Line 3444: FROM igs_ps_unit_ver_ru ru,

3440:
3441: --cursor to look up the rule code in unit version rules
3442: CURSOR c_unit_ru(cp_n_uoo_id IN NUMBER, cp_c_rul_call_cd IN VARCHAR2) IS
3443: SELECT ru.rul_sequence_number
3444: FROM igs_ps_unit_ver_ru ru,
3445: igs_ps_unit_ofr_opt_all uoo
3446: WHERE uoo.uoo_id = p_n_uoo_id
3447: AND uoo.unit_cd = ru.unit_cd
3448: AND uoo.version_number = ru.version_number

Line 3558: l_uv_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;

3554: --Who When What
3555: -------------------------------------------------------------------
3556: IS
3557:
3558: l_uv_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
3559: l_uv_billing_cp IGS_PS_UNIT_VER.billing_hrs%TYPE;
3560: l_uv_audit_cp IGS_PS_UNIT_VER.billing_credit_points%TYPE;
3561:
3562: BEGIN

Line 3559: l_uv_billing_cp IGS_PS_UNIT_VER.billing_hrs%TYPE;

3555: -------------------------------------------------------------------
3556: IS
3557:
3558: l_uv_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
3559: l_uv_billing_cp IGS_PS_UNIT_VER.billing_hrs%TYPE;
3560: l_uv_audit_cp IGS_PS_UNIT_VER.billing_credit_points%TYPE;
3561:
3562: BEGIN
3563: IGS_PS_VAL_UV.get_cp_values(p_uoo_id, l_uv_enrolled_cp, l_uv_billing_cp,

Line 3560: l_uv_audit_cp IGS_PS_UNIT_VER.billing_credit_points%TYPE;

3556: IS
3557:
3558: l_uv_enrolled_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
3559: l_uv_billing_cp IGS_PS_UNIT_VER.billing_hrs%TYPE;
3560: l_uv_audit_cp IGS_PS_UNIT_VER.billing_credit_points%TYPE;
3561:
3562: BEGIN
3563: IGS_PS_VAL_UV.get_cp_values(p_uoo_id, l_uv_enrolled_cp, l_uv_billing_cp,
3564: l_uv_audit_cp);

Line 3598: FROM igs_ps_unit_ver_ru uvr,

3594:
3595: --Check if the prereq/coreq rule is setup at the unit version level.
3596: CURSOR c_get_unit_rul_seq_no IS
3597: SELECT rul_sequence_number
3598: FROM igs_ps_unit_ver_ru uvr,
3599: igs_ps_unit_ofr_opt uoo
3600: WHERE uvr.unit_cd = uoo.unit_cd
3601: AND uvr.version_number = uoo.version_number
3602: AND uoo_id = p_uoo_id

Line 3883: From igs_ps_unit_ver

3879: AS
3880: -- if the unit version has been marked as a practical unit then placement details will be available else no
3881: Cursor cur_practical_ind(cp_unit_cd VARCHAR2, cp_version_number NUMBER) IS
3882: Select practical_ind
3883: From igs_ps_unit_ver
3884: where unit_cd=cp_unit_cd
3885: and version_number= cp_version_number;
3886:
3887: l_result igs_ps_unit_ver.practical_ind%TYPE;

Line 3887: l_result igs_ps_unit_ver.practical_ind%TYPE;

3883: From igs_ps_unit_ver
3884: where unit_cd=cp_unit_cd
3885: and version_number= cp_version_number;
3886:
3887: l_result igs_ps_unit_ver.practical_ind%TYPE;
3888:
3889: BEGIN
3890:
3891: OPEN cur_practical_ind(p_unit_cd,p_version_number);

Line 3962: FROM igs_ps_unit_ver

3958:
3959: -- cursor to fetch the enrollment maximum value defined at unit level
3960: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3961: SELECT enrollment_maximum
3962: FROM igs_ps_unit_ver
3963: WHERE (unit_cd , version_number ) IN (SELECT unit_cd , version_number
3964: FROM igs_ps_unit_ofr_opt
3965: WHERE uoo_id = p_uoo_id);
3966:

Line 4468: igs_ps_unit_ver_all uv

4464: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
4465: SELECT t.subtitle
4466: FROM igs_ps_unit_subtitle t,
4467: igs_ps_unit_ofr_opt_all us,
4468: igs_ps_unit_ver_all uv
4469: WHERE us.uoo_id = cp_n_uoo_id
4470: AND us.unit_cd = uv.unit_cd
4471: AND us.version_number = uv.version_number
4472: AND uv.subtitle_id = t.subtitle_id;

Line 4950: FROM igs_ps_unit_ver_ru uvr, igs_ps_unit_ofr_opt uoo

4946:
4947: /*** get the coreq rule defined at the unit version rules ***/
4948: Cursor c_coreq_unit(cp_uoo_id NUMBER) IS
4949: SELECT rul_sequence_number
4950: FROM igs_ps_unit_ver_ru uvr, igs_ps_unit_ofr_opt uoo
4951: WHERE uvr.unit_cd = uoo.unit_cd
4952: AND uvr.version_number = uoo.version_number
4953: AND uoo_id = cp_uoo_id
4954: AND uvr.s_rule_call_cd = 'COREQ';

Line 5451: v_sup_unit_cd IGS_PS_UNIT_VER.UNIT_CD%TYPE;

5447: SELECT unit_cd
5448: FROM igs_ps_unit_ofr_opt
5449: WHERE uoo_id = cp_sup_uoo_id;
5450:
5451: v_sup_unit_cd IGS_PS_UNIT_VER.UNIT_CD%TYPE;
5452: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
5453:
5454: BEGIN
5455: