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_SS_ENR_DETAILS dependencies on IGS_PS_UNIT

Line 372: CURSOR c_usec_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

368: ) RETURN VARCHAR2 IS
369:
370: lv_ref_cd VARCHAR2(32000) ;
371:
372: CURSOR c_usec_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
373: SELECT a.reference_code||' - '||a.reference_code_desc ref_cd
374: FROM igs_ps_us_req_ref_cd a, igs_ps_usec_ref b
375: WHERE b.uoo_id = cp_uoo_id
376: AND a.unit_section_reference_id = b.unit_section_reference_id

Line 379: CURSOR c_unit_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

375: WHERE b.uoo_id = cp_uoo_id
376: AND a.unit_section_reference_id = b.unit_section_reference_id
377: ORDER BY 1 ;
378:
379: CURSOR c_unit_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
380: SELECT unitref.REFERENCE_CODE || ' - ' || unitref.REFERENCE_CODE_DESC ref_cd
381: FROM igs_ps_unitreqref_cd unitref,
382: igs_ps_unit_ofr_opt uoo
383: WHERE uoo.uoo_id = cp_uoo_id

Line 381: FROM igs_ps_unitreqref_cd unitref,

377: ORDER BY 1 ;
378:
379: CURSOR c_unit_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
380: SELECT unitref.REFERENCE_CODE || ' - ' || unitref.REFERENCE_CODE_DESC ref_cd
381: FROM igs_ps_unitreqref_cd unitref,
382: igs_ps_unit_ofr_opt uoo
383: WHERE uoo.uoo_id = cp_uoo_id
384: AND uoo.unit_cd = unitref.unit_cd
385: AND uoo.version_number = unitref.version_number

Line 382: igs_ps_unit_ofr_opt uoo

378:
379: CURSOR c_unit_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
380: SELECT unitref.REFERENCE_CODE || ' - ' || unitref.REFERENCE_CODE_DESC ref_cd
381: FROM igs_ps_unitreqref_cd unitref,
382: igs_ps_unit_ofr_opt uoo
383: WHERE uoo.uoo_id = cp_uoo_id
384: AND uoo.unit_cd = unitref.unit_cd
385: AND uoo.version_number = unitref.version_number
386: ORDER BY 1;

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 563: igs_ps_unit_subtitle usub

559: uref.title,
560: usub.subtitle
561: FROM
562: igs_ps_usec_ref uref,
563: igs_ps_unit_subtitle usub
564: WHERE
565: uref.uoo_id = p_uoo_id AND
566: uref.subtitle_id = usub.subtitle_id(+);
567:

Line 569: CURSOR uv_title_dtls (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

565: uref.uoo_id = p_uoo_id AND
566: uref.subtitle_id = usub.subtitle_id(+);
567:
568: -- To fetch the deatils from unit level level
569: CURSOR uv_title_dtls (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
570: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE)
571: IS
572: SELECT
573: uv.title,

Line 570: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE)

566: uref.subtitle_id = usub.subtitle_id(+);
567:
568: -- To fetch the deatils from unit level level
569: CURSOR uv_title_dtls (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
570: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE)
571: IS
572: SELECT
573: uv.title,
574: usub.subtitle

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 577: igs_ps_unit_subtitle usub

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
581: uv.subtitle_id = usub.subtitle_id(+);

Line 585: from igs_ps_unit_ofr_opt

581: uv.subtitle_id = usub.subtitle_id(+);
582:
583: CURSOR cur_fetch_unit_dtls(cp_uoo_id NUMBER) IS
584: select unit_cd , version_number
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;

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 590: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

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;
594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%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 592: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

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;
596: l_unit_ver igs_ps_unit_ver.version_number%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 594: l_uv_subtitle igs_ps_unit_subtitle.subtitle%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
598: IF p_unit_cd IS NULL THEN

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 676: igs_ps_unit_subtitle usub

672: uref.title,
673: usub.subtitle
674: FROM
675: igs_ps_usec_ref uref,
676: igs_ps_unit_subtitle usub
677: WHERE
678: uref.uoo_id = p_uoo_id AND
679: uref.subtitle_id = usub.subtitle_id(+);
680:

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 688: igs_ps_unit_subtitle usub

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
692: uv.subtitle_id = usub.subtitle_id(+);

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 695: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

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;
699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%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 697: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

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
701: -- first check if title and subtitle exists at student level

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 699: l_uv_subtitle igs_ps_unit_subtitle.subtitle%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;
703: FETCH stdnt_subtitle_dtls INTO title_subtitle_dtls_rec;

Line 761: igs_ps_unit_subtitle usub

757: uref.title,
758: usub.subtitle
759: FROM
760: igs_ps_usec_ref uref,
761: igs_ps_unit_subtitle usub
762: WHERE
763: uref.uoo_id = p_uoo_id AND
764: uref.subtitle_id = usub.subtitle_id(+);
765:

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 773: igs_ps_unit_subtitle usub

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
777: uv.subtitle_id = usub.subtitle_id(+);

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 780: l_stdnt_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

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;
784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%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 782: l_usec_subtitle igs_ps_unit_subtitle.subtitle%TYPE DEFAULT NULL;

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
786: -- first check if title and subtitle exists at student level

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 784: l_uv_subtitle igs_ps_unit_subtitle.subtitle%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;
788: FETCH stdnt_subtitle_dtls INTO title_subtitle_dtls_rec;

Line 868: igs_ps_unit_grd_schm uvgr

864: CURSOR unit_grd_sch IS
865: SELECT
866: grading_schema_code
867: FROM
868: igs_ps_unit_grd_schm uvgr
869: WHERE
870: uvgr.unit_code = p_unit_cd AND
871: uvgr.unit_version_number = p_version_number AND
872: uvgr.default_flag = 'Y';

Line 949: igs_ps_unit_grd_schm uvgr

945: CURSOR unit_grd_sch IS
946: SELECT
947: grd_schm_version_number
948: FROM
949: igs_ps_unit_grd_schm uvgr
950: WHERE
951: uvgr.unit_code = p_unit_cd AND
952: uvgr.unit_version_number = p_version_number AND
953: uvgr.default_flag = 'Y';

Line 1023: igs_ps_unit_grd_schm uvgr

1019: SELECT
1020: uvgr.grading_schema_code,
1021: uvgr.grd_schm_version_number
1022: FROM
1023: igs_ps_unit_grd_schm uvgr
1024: WHERE
1025: uvgr.unit_code = cp_c_unit_cd AND
1026: uvgr.unit_version_number = cp_n_ver_num AND
1027: uvgr.default_flag = 'Y';

Line 1115: igs_ps_unit_grd_schm uvgr

1111: SELECT
1112: uvgr.grading_schema_code,
1113: uvgr.grd_schm_version_number
1114: FROM
1115: igs_ps_unit_grd_schm uvgr
1116: WHERE
1117: uvgr.unit_code = cp_c_unit_cd AND
1118: uvgr.unit_version_number = cp_n_ver_num AND
1119: uvgr.default_flag = 'Y';

Line 1187: igs_ps_unit_ofr_opt uoo,

1183: CURSOR unit_credit_pts IS
1184: SELECT
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

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 1347: CURSOR c_get_unit_cd_ver (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1343: (
1344: p_uoo_id IN NUMBER
1345: ) RETURN VARCHAR2 IS
1346:
1347: CURSOR c_get_unit_cd_ver (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1348: SELECT unit_cd,version_number
1349: FROM igs_ps_unit_ofr_opt
1350: WHERE uoo_id = p_uoo_id;
1351:

Line 1349: FROM igs_ps_unit_ofr_opt

1345: ) RETURN VARCHAR2 IS
1346:
1347: CURSOR c_get_unit_cd_ver (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1348: SELECT unit_cd,version_number
1349: FROM igs_ps_unit_ofr_opt
1350: WHERE uoo_id = p_uoo_id;
1351:
1352: CURSOR c_usec_cp IS
1353: SELECT

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 1372: igs_ps_unit_ofr_opt uoo,

1368:
1369: CURSOR c_enr_cp IS
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

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 1557: FROM igs_ps_unit_ofr_opt

1553:
1554: CURSOR c_usec_dates IS
1555: SELECT TO_CHAR(UNIT_SECTION_START_DATE) ||' - '||
1556: TO_CHAR(UNIT_SECTION_END_DATE )
1557: FROM igs_ps_unit_ofr_opt
1558: WHERE unit_cd = x_unit_cd
1559: AND version_number = x_version
1560: AND cal_type = x_cal_type
1561: AND ci_sequence_number = x_ci_seq_number

Line 1597: FROM igs_ps_unit_ofr_opt

1593: AS
1594: --Cursor to fetch the actual enrolled from Unit Offering Option
1595: CURSOR cur_get_actual IS
1596: SELECT enrollment_actual
1597: FROM igs_ps_unit_ofr_opt
1598: WHERE uoo_id=p_uooid;
1599: --Cursor to fetch the limits from Unit Section
1600: CURSOR cur_get_usec_maxmin_limits IS
1601: SELECT enrollment_minimum,enrollment_maximum

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 1801: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

1797:
1798: END get_usec_instructor_names ;
1799:
1800: PROCEDURE Enrp_Get_Usec_Group (
1801: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
1802: p_return_status OUT NOCOPY VARCHAR2,
1803: p_group_type OUT NOCOPY igs_lookups_view.meaning%TYPE,
1804: p_group_name OUT NOCOPY igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE
1805: ) AS

Line 1825: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1821: -------------------------------------------------------------------------------------
1822:
1823:
1824: -- Cursor to get the enrollment maximum in cross listed group
1825: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1826: SELECT grp.usec_x_listed_group_name
1827: FROM igs_ps_usec_x_grpmem grpmem,
1828: igs_ps_usec_x_grp grp
1829: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id

Line 1834: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1830: AND grpmem.uoo_id = l_uoo_id;
1831:
1832:
1833: -- Cursor to get the enrollment maximum in Meet with class group
1834: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1835: SELECT grp.class_meet_group_name
1836: FROM igs_ps_uso_clas_meet ucm,
1837: igs_ps_uso_cm_grp grp
1838: WHERE grp.class_meet_group_id = ucm.class_meet_group_id

Line 1900: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE

1896: END Enrp_Get_Usec_Group;
1897:
1898:
1899: FUNCTION Enrp_Get_Enr_Max_Act (
1900: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE
1901: ) RETURN VARCHAR2 IS
1902:
1903: ------------------------------------------------------------------------------------
1904: --Created by : pradhakr

Line 1922: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1918: -- igs_ps_usec_lim_wlst.enrollment_maximum.
1919: -------------------------------------------------------------------------------------
1920:
1921: -- Cursor to get the enrollment maximum in cross listed group
1922: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1923: SELECT grp.max_enr_group, grpmem.usec_x_listed_group_id
1924: FROM igs_ps_usec_x_grpmem grpmem,
1925: igs_ps_usec_x_grp grp
1926: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id

Line 1931: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1927: AND grpmem.uoo_id = l_uoo_id;
1928:
1929:
1930: -- Cursor to get the enrollment maximum in Meet with class group
1931: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1932: SELECT grp.max_enr_group, ucm.class_meet_group_id
1933: FROM igs_ps_uso_clas_meet ucm,
1934: igs_ps_uso_cm_grp grp
1935: WHERE grp.class_meet_group_id = ucm.class_meet_group_id

Line 1942: FROM igs_ps_unit_ofr_opt uoo,

1938: -- Cursor to get the actual enrollment of all the unit sections that belong
1939: -- to this class listed group.
1940: CURSOR c_actual_enr_crs_lst(l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1941: SELECT SUM(enrollment_actual)
1942: FROM igs_ps_unit_ofr_opt uoo,
1943: igs_ps_usec_x_grpmem ugrp
1944: WHERE uoo.uoo_id = ugrp.uoo_id
1945: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;
1946:

Line 1952: FROM igs_ps_unit_ofr_opt uoo,

1948: -- Cursor to get the actual enrollment of all the unit sections that belong
1949: -- to this meet with class group.
1950: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
1951: SELECT SUM(enrollment_actual)
1952: FROM igs_ps_unit_ofr_opt uoo,
1953: igs_ps_uso_clas_meet ucls
1954: WHERE uoo.uoo_id = ucls.uoo_id
1955: AND ucls.class_meet_group_id = l_class_meet_group_id;
1956:

Line 1966: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1962: WHERE lookup_type = 'IGS_PS_USEC_GROUPS'
1963: AND lookup_code = l_lookup_code;
1964:
1965: -- Cursor to fetch the enrollment Maximum value defined at Unit Section level
1966: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1967: SELECT enrollment_maximum
1968: FROM igs_ps_usec_lim_wlst
1969: WHERE uoo_id = p_uoo_id;
1970:

Line 1972: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1968: FROM igs_ps_usec_lim_wlst
1969: WHERE uoo_id = p_uoo_id;
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

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 1976: FROM igs_ps_unit_ofr_opt

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:
1979: --
1980: -- Cursor to find the Actual Enrollment of the Unit section

Line 1982: CURSOR c_enroll_actual (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1978:
1979: --
1980: -- Cursor to find the Actual Enrollment of the Unit section
1981: --
1982: CURSOR c_enroll_actual (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1983: SELECT enrollment_actual
1984: FROM igs_ps_unit_ofr_opt
1985: WHERE uoo_id = cp_uoo_id;
1986:

Line 1984: FROM igs_ps_unit_ofr_opt

1980: -- Cursor to find the Actual Enrollment of the Unit section
1981: --
1982: CURSOR c_enroll_actual (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1983: SELECT enrollment_actual
1984: FROM igs_ps_unit_ofr_opt
1985: WHERE uoo_id = cp_uoo_id;
1986:
1987:
1988: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE;

Line 1990: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;

1986:
1987:
1988: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE;
1989: l_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
1990: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
1991: l_total_enrollment NUMBER;
1992: l_actual_enr igs_ps_unit_ofr_opt_all.enrollment_actual%TYPE;
1993: l_meet_meaning igs_lookups_view.meaning%TYPE;
1994: l_cross_meaning igs_lookups_view.meaning%TYPE;

Line 1992: l_actual_enr igs_ps_unit_ofr_opt_all.enrollment_actual%TYPE;

1988: l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE;
1989: l_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
1990: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
1991: l_total_enrollment NUMBER;
1992: l_actual_enr igs_ps_unit_ofr_opt_all.enrollment_actual%TYPE;
1993: l_meet_meaning igs_lookups_view.meaning%TYPE;
1994: l_cross_meaning igs_lookups_view.meaning%TYPE;
1995: l_usec_partof_group BOOLEAN;
1996: l_cat_enr_act varchar2(100);

Line 2126: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE

2122: END Enrp_Get_Enr_Max_Act;
2123:
2124:
2125: FUNCTION Enrp_Chk_Usec_Group (
2126: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE
2127: ) RETURN VARCHAR2 IS
2128:
2129: ------------------------------------------------------------------------------------
2130: --Created by : pradhakr

Line 2151: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2147: p_group_type igs_lookups_view.meaning%TYPE;
2148: p_group_name igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE;
2149:
2150: -- Cursor to get the enrollment maximum in cross listed group
2151: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2152: SELECT grp.max_enr_group, grpmem.usec_x_listed_group_id
2153: FROM igs_ps_usec_x_grpmem grpmem,
2154: igs_ps_usec_x_grp grp
2155: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id

Line 2160: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2156: AND grpmem.uoo_id = l_uoo_id;
2157:
2158:
2159: -- Cursor to get the enrollment maximum in Meet with class group
2160: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2161: SELECT grp.max_enr_group, ucm.class_meet_group_id
2162: FROM igs_ps_uso_clas_meet ucm,
2163: igs_ps_uso_cm_grp grp
2164: WHERE grp.class_meet_group_id = ucm.class_meet_group_id

Line 2249: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2245:
2246: --
2247: -- Cursor to find the Unit Code
2248: --
2249: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2250: SELECT unit_cd, unit_class
2251: FROM igs_ps_unit_ofr_opt
2252: WHERE uoo_id = p_uoo_id;
2253:

Line 2251: FROM igs_ps_unit_ofr_opt

2247: -- Cursor to find the Unit Code
2248: --
2249: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2250: SELECT unit_cd, unit_class
2251: FROM igs_ps_unit_ofr_opt
2252: WHERE uoo_id = p_uoo_id;
2253:
2254: --
2255: -- Cursor to find the meaning of lookup code CORE

Line 2264: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

2260: WHERE lkup.lookup_type = 'IGS_EN_CORE_IND'
2261: AND lkup.lookup_code = en.core_req_ind;
2262:
2263:
2264: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2265: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
2266: l_core_meaning igs_lookup_values.meaning%TYPE;
2267:
2268: BEGIN

Line 2265: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

2261: AND lkup.lookup_code = en.core_req_ind;
2262:
2263:
2264: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2265: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
2266: l_core_meaning igs_lookup_values.meaning%TYPE;
2267:
2268: BEGIN
2269: -- Get the Unit Code

Line 2578: FROM igs_ps_unit_ofr_opt

2574: RETURN VARCHAR2 IS
2575:
2576: CURSOR chk_rel IS
2577: SELECT relation_type ,sup_uoo_Id
2578: FROM igs_ps_unit_ofr_opt
2579: WHERE uoo_id = p_uoo_id;
2580:
2581: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;
2582: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;

Line 2581: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;

2577: SELECT relation_type ,sup_uoo_Id
2578: FROM igs_ps_unit_ofr_opt
2579: WHERE uoo_id = p_uoo_id;
2580:
2581: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;
2582: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
2583:
2584: BEGIN
2585: OPEN chk_rel;

Line 2582: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;

2578: FROM igs_ps_unit_ofr_opt
2579: WHERE uoo_id = p_uoo_id;
2580:
2581: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;
2582: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
2583:
2584: BEGIN
2585: OPEN chk_rel;
2586: FETCH chk_rel INTO l_rel_type, l_sup_uoo_id;

Line 2624: FROM igs_ps_unit_ofr_opt

2620: ret_value VARCHAR2 (2000);
2621:
2622: CURSOR c_sub_uoo_ids IS
2623: SELECT uoo_id
2624: FROM igs_ps_unit_ofr_opt
2625: WHERE sup_uoo_id = p_uoo_id;
2626:
2627: BEGIN
2628:

Line 2668: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

2664: FROM igs_lookup_values
2665: WHERE lookup_code = cp_lookup_code
2666: AND lookup_type = 'UOO_RELATION_TYPE';
2667:
2668: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
2669: SELECT unit_cd
2670: FROM igs_ps_unit_ofr_opt
2671: WHERE uoo_id = cp_sup_uoo_id;
2672:

Line 2670: FROM igs_ps_unit_ofr_opt

2666: AND lookup_type = 'UOO_RELATION_TYPE';
2667:
2668: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
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;

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 2726: IGS_PS_UNIT_OFR_OPT_ALL UOO

2722:
2723: CURSOR c_uop (cp_n_uoo_id IN NUMBER) IS
2724: SELECT 1
2725: FROM IGS_PS_UNT_OFR_PAT_N UOP,
2726: IGS_PS_UNIT_OFR_OPT_ALL UOO
2727: WHERE UOO.UNIT_CD = UOP.UNIT_CD
2728: AND UOO.VERSION_NUMBER = UOP.VERSION_NUMBER
2729: AND UOO.CAL_TYPE = UOP.CAL_TYPE
2730: AND UOO.CI_SEQUENCE_NUMBER = UOP.CI_SEQUENCE_NUMBER

Line 2736: FROM IGS_PS_UNIT_OFR_NOTE UO,

2732: AND ROWNUM < 2;
2733:
2734: CURSOR c_uo (cp_n_uoo_id IN NUMBER) IS
2735: SELECT 1
2736: FROM IGS_PS_UNIT_OFR_NOTE UO,
2737: IGS_PS_UNIT_OFR_OPT_ALL UOO
2738: WHERE UOO.UNIT_CD = UO.UNIT_CD
2739: AND UOO.VERSION_NUMBER = UO.VERSION_NUMBER
2740: AND UOO.CAL_TYPE = UO.CAL_TYPE

Line 2737: IGS_PS_UNIT_OFR_OPT_ALL UOO

2733:
2734: CURSOR c_uo (cp_n_uoo_id IN NUMBER) IS
2735: SELECT 1
2736: FROM IGS_PS_UNIT_OFR_NOTE UO,
2737: IGS_PS_UNIT_OFR_OPT_ALL UOO
2738: WHERE UOO.UNIT_CD = UO.UNIT_CD
2739: AND UOO.VERSION_NUMBER = UO.VERSION_NUMBER
2740: AND UOO.CAL_TYPE = UO.CAL_TYPE
2741: AND UOO.UOO_ID = cp_n_uoo_id

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 2747: IGS_PS_UNIT_OFR_OPT_ALL UOO

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
2751: AND ROWNUM < 2;

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 2895: from igs_ps_unit_ofr_pat

2891:
2892: Cursor c_check2(cp_unit_cd VARCHAR2, cp_version NUMBER,
2893: cp_cal_type VARCHAR2, cp_sequence_number NUMBER) IS
2894: select max_students_per_waitlist
2895: from igs_ps_unit_ofr_pat
2896: where unit_cd=cp_unit_cd
2897: and version_number=cp_version
2898: and cal_type=cp_cal_type
2899: and ci_sequence_number=cp_sequence_number

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 3260: igs_ps_unit_ofr_opt_all US,

3256: DECODE(uso.sunday, 'Y', 'Su', NULL),'TBA') meetings,
3257: TO_CHAR(uso.start_time,'hh:miam') start_time,
3258: TO_CHAR(uso.end_time, 'hh:miam') end_time
3259: FROM igs_ps_usec_occurs_all USO,
3260: igs_ps_unit_ofr_opt_all US,
3261: igs_ca_inst_all CA
3262: WHERE uso.uoo_id = cp_n_uoo_id AND
3263: uso.uoo_id = us.uoo_id AND
3264: us.cal_type = ca.cal_type AND

Line 3305: FROM igs_ps_unit_ofr_opt_all us,

3301: FUNCTION get_dummy_data(p_n_uoo_id IN NUMBER) RETURN VARCHAR2 IS
3302: CURSOR c_uoo(cp_n_uoo_id IN NUMBER) IS
3303: SELECT NVL(us.unit_section_start_date,ca.start_dt) start_date,
3304: NVL(us.unit_section_end_date, ca.end_dt) end_date
3305: FROM igs_ps_unit_ofr_opt_all us,
3306: igs_ca_inst_all ca
3307: WHERE us.uoo_id = cp_n_uoo_id AND
3308: us.cal_type = ca.cal_type AND
3309: us.ci_sequence_number = ca.sequence_number;

Line 3397: FROM igs_ps_unit_ofr_opt_all us,

3393: WHERE t.uoo_id = cp_n_uoo_id;
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;

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 3445: igs_ps_unit_ofr_opt_all uoo

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
3449: AND ru.s_rule_call_cd = cp_c_rul_call_cd;

Line 3504: FROM igs_ps_unit_ofr_opt uoo

3500: -- get unit section details
3501: CURSOR c_unit_dtls(cp_uoo_id NUMBER)
3502: IS
3503: SELECT unit_cd,version_number,cal_type,ci_sequence_number
3504: FROM igs_ps_unit_ofr_opt uoo
3505: WHERE uoo_id = cp_uoo_id;
3506:
3507: l_unit_dtls c_unit_dtls%ROWTYPE;
3508: l_dummy1 NUMBER;

Line 3542: FUNCTION get_billable_credit_points(p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE)

3538: return l_result;
3539:
3540: END get_apor_credits;
3541:
3542: FUNCTION get_billable_credit_points(p_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.uoo_id%TYPE)
3543: RETURN NUMBER
3544: ------------------------------------------------------------------
3545: --Created by : rvangala
3546: --Date created: 24-May-2005

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 3599: igs_ps_unit_ofr_opt uoo

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
3603: AND uvr.s_rule_call_cd = p_rule_type;

Line 3670: FROM igs_ps_unit_ofr_opt_all usec

3666: AS
3667: --cursor to check if special permission is setup at unit section level or at unit level
3668: CURSOR cur_usec_details ( cp_uoo_id NUMBER) IS
3669: SELECT NVL(usec.special_permission_ind,'N') special_permission_ind
3670: FROM igs_ps_unit_ofr_opt_all usec
3671: WHERE usec.uoo_id = cp_uoo_id;
3672:
3673:
3674: cur_usec_details_rec cur_usec_details %ROWTYPE;

Line 3713: FROM igs_ps_unit_ofr_opt_all usec

3709: --cursor to check if audit permission is setup at unit section level or at unit level
3710: CURSOR cur_usec_details ( cp_uoo_id NUMBER) IS
3711: SELECT NVL(usec.auditable_ind,'N') auditable_ind,
3712: NVL(usec.audit_permission_ind,'N') audit_permission_ind
3713: FROM igs_ps_unit_ofr_opt_all usec
3714: WHERE usec.uoo_id = cp_uoo_id;
3715:
3716: cur_usec_details_rec cur_usec_details %ROWTYPE;
3717:

Line 3756: FROM igs_ps_unit_ofr_opt

3752: AS
3753:
3754: CURSOR c_get_spl_audit_perm(cp_uoo_id NUMBER) IS
3755: SELECT NVL(special_permission_ind,'N'),NVL(audit_permission_ind,'N')
3756: FROM igs_ps_unit_ofr_opt
3757: WHERE uoo_id=cp_uoo_id;
3758:
3759: l_spl_perm VARCHAR2(1);
3760: l_aud_perm VARCHAR2(1);

Line 3806: FROM igs_ps_unit_ofr_opt_all usec

3802: -- level, if not found checks at unit level
3803:
3804: CURSOR cur_uv_audit_ind (cp_uoo_id NUMBER) IS
3805: Select NVL(usec.auditable_ind,'N') auditable_ind, cal_type,ci_sequence_number
3806: FROM igs_ps_unit_ofr_opt_all usec
3807: WHERE usec.uoo_id = cp_uoo_id;
3808:
3809: CURSOR c_usr_conf (cp_person_type VARCHAR2) IS
3810: SELECT UPD_AUDIT_DT_ALIAS

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 3917: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

3913: -------------------------------------------------------------------
3914: IS
3915:
3916: -- Cursor to get the enrollment maximum in cross listed group
3917: CURSOR c_cross_listed (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3918: SELECT grp.max_enr_group, grpmem.usec_x_listed_group_id
3919: FROM igs_ps_usec_x_grpmem grpmem,
3920: igs_ps_usec_x_grp grp
3921: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id

Line 3926: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

3922: AND grpmem.uoo_id = l_uoo_id;
3923:
3924:
3925: -- Cursor to get the enrollment maximum in Meet with class group
3926: CURSOR c_meet_with_cls (l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3927: SELECT grp.max_enr_group, ucm.class_meet_group_id
3928: FROM igs_ps_uso_clas_meet ucm,
3929: igs_ps_uso_cm_grp grp
3930: WHERE grp.class_meet_group_id = ucm.class_meet_group_id

Line 3937: FROM igs_ps_unit_ofr_opt uoo,

3933: -- Cursor to get the actual enrollment of all the unit sections that belong
3934: -- to this class listed group.
3935: CURSOR c_actual_enr_crs_lst(l_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
3936: SELECT SUM(enrollment_actual)
3937: FROM igs_ps_unit_ofr_opt uoo,
3938: igs_ps_usec_x_grpmem ugrp
3939: WHERE uoo.uoo_id = ugrp.uoo_id
3940: AND ugrp.usec_x_listed_group_id = l_usec_x_listed_group_id;
3941:

Line 3947: FROM igs_ps_unit_ofr_opt uoo,

3943: -- Cursor to get the actual enrollment of all the unit sections that belong
3944: -- to this meet with class group.
3945: CURSOR c_actual_enr_meet_cls(l_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
3946: SELECT SUM(enrollment_actual)
3947: FROM igs_ps_unit_ofr_opt uoo,
3948: igs_ps_uso_clas_meet ucls
3949: WHERE uoo.uoo_id = ucls.uoo_id
3950: AND ucls.class_meet_group_id = l_class_meet_group_id;
3951:

Line 3954: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

3950: AND ucls.class_meet_group_id = l_class_meet_group_id;
3951:
3952:
3953: -- Cursor to fetch the enrollment Maximum value defined at Unit Section level
3954: CURSOR cur_usec_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3955: SELECT enrollment_maximum
3956: FROM igs_ps_usec_lim_wlst
3957: WHERE uoo_id = p_uoo_id;
3958:

Line 3960: CURSOR cur_unit_enr_max( p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

3956: FROM igs_ps_usec_lim_wlst
3957: WHERE uoo_id = p_uoo_id;
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

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 3964: FROM igs_ps_unit_ofr_opt

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:
3967: --
3968: -- Cursor to find the Actual Enrollment of the Unit section

Line 3970: CURSOR c_enroll_actual (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

3966:
3967: --
3968: -- Cursor to find the Actual Enrollment of the Unit section
3969: --
3970: CURSOR c_enroll_actual (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3971: SELECT enrollment_actual
3972: FROM igs_ps_unit_ofr_opt
3973: WHERE uoo_id = cp_uoo_id;
3974:

Line 3972: FROM igs_ps_unit_ofr_opt

3968: -- Cursor to find the Actual Enrollment of the Unit section
3969: --
3970: CURSOR c_enroll_actual (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3971: SELECT enrollment_actual
3972: FROM igs_ps_unit_ofr_opt
3973: WHERE uoo_id = cp_uoo_id;
3974:
3975: l_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
3976: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;

Line 3976: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;

3972: FROM igs_ps_unit_ofr_opt
3973: WHERE uoo_id = cp_uoo_id;
3974:
3975: l_max igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;
3976: l_act igs_ps_unit_ofr_opt.enrollment_actual%TYPE;
3977: l_setup_found NUMBER;
3978: l_cross_listed_row c_cross_listed%ROWTYPE;
3979: l_meet_with_cls_row c_meet_with_cls%ROWTYPE;
3980: l_usec_partof_group BOOLEAN;

Line 4107: CURSOR c_uoo_teach_cal (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

4103: --ckasu 05-JUL-2005 modified as a part of EN317 BUILD
4104: -------------------------------------------------------------------
4105: AS
4106:
4107: CURSOR c_uoo_teach_cal (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
4108: SELECT cal_type, ci_sequence_number
4109: FROM IGS_PS_UNIT_OFR_OPT
4110: WHERE uoo_id = cp_uoo_id;
4111:

Line 4109: FROM IGS_PS_UNIT_OFR_OPT

4105: AS
4106:
4107: CURSOR c_uoo_teach_cal (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
4108: SELECT cal_type, ci_sequence_number
4109: FROM IGS_PS_UNIT_OFR_OPT
4110: WHERE uoo_id = cp_uoo_id;
4111:
4112: -- cursor to check whether unit section is superior unit section.
4113: CURSOR c_sup(cp_n_uoo_id IN NUMBER) IS

Line 4115: FROM igs_ps_unit_ofr_opt_all

4111:
4112: -- cursor to check whether unit section is superior unit section.
4113: CURSOR c_sup(cp_n_uoo_id IN NUMBER) IS
4114: SELECT 1
4115: FROM igs_ps_unit_ofr_opt_all
4116: WHERE sup_uoo_id = cp_n_uoo_id
4117: AND rownum <2;
4118:
4119: -- cursor to checks whether subordinate unit section exists in unit attempt status

Line 4126: IGS_PS_UNIT_OFR_OPT_ALL uoo

4122: cp_n_person_id IN NUMBER,
4123: cp_n_uoo_id IN NUMBER) IS
4124: SELECT 1
4125: FROM IGS_EN_SU_ATTEMPT_ALL sua,
4126: IGS_PS_UNIT_OFR_OPT_ALL uoo
4127: WHERE sua.uoo_id = uoo.uoo_id
4128: AND uoo.sup_uoo_id = cp_n_uoo_id
4129: AND sua.course_cd = cp_c_course_cd
4130: AND sua.person_id = cp_n_person_id

Line 4141: IGS_PS_UNIT_OFR_OPT_ALL uoo

4137: cp_n_uoo_id IN NUMBER) IS
4138: SELECT sua.uoo_id,
4139: sua.core_indicator_code
4140: FROM IGS_EN_SU_ATTEMPT_ALL sua,
4141: IGS_PS_UNIT_OFR_OPT_ALL uoo
4142: WHERE sua.uoo_id = uoo.uoo_id
4143: AND uoo.sup_uoo_id = cp_n_uoo_id
4144: AND sua.course_cd = cp_c_course_cd
4145: AND sua.person_id = cp_n_person_id

Line 4151: l_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;

4147:
4148: temp Number; -- temporary variable.
4149: l_c_deny_warn VARCHAR2(10); -- deny warn flag.
4150:
4151: l_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;
4152: l_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;
4153:
4154: BEGIN
4155:

Line 4152: l_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;

4148: temp Number; -- temporary variable.
4149: l_c_deny_warn VARCHAR2(10); -- deny warn flag.
4150:
4151: l_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE;
4152: l_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.CI_SEQUENCE_NUMBER%TYPE;
4153:
4154: BEGIN
4155:
4156: OPEN c_uoo_teach_cal(p_uoo_id);

Line 4459: FROM igs_ps_unit_subtitle t,

4455: -------------------------------------------------------------------
4456: IS
4457: CURSOR c_us_title(cp_n_uoo_id IN NUMBER) IS
4458: SELECT t.subtitle
4459: FROM igs_ps_unit_subtitle t,
4460: igs_ps_usec_ref us
4461: WHERE us.uoo_id = cp_n_uoo_id
4462: AND us.subtitle_id = t.subtitle_id;
4463:

Line 4466: FROM igs_ps_unit_subtitle t,

4462: AND us.subtitle_id = t.subtitle_id;
4463:
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

Line 4467: igs_ps_unit_ofr_opt_all us,

4463:
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

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 4473: l_c_subtitle igs_ps_unit_subtitle.subtitle%TYPE;

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;
4473: l_c_subtitle igs_ps_unit_subtitle.subtitle%TYPE;
4474: BEGIN
4475: OPEN c_us_title(p_n_uoo_id);
4476: FETCH c_us_title INTO l_c_subtitle;
4477: CLOSE c_us_title;

Line 4506: from igs_ps_unit_ofr_opt

4502: -------------------------------------------------------------------
4503: IS
4504: Cursor cur_wait_actual(cp_uoo_id NUMBER) IS
4505: Select NVL(waitlist_actual,0)
4506: from igs_ps_unit_ofr_opt
4507: where uoo_id=cp_uoo_id;
4508:
4509: l_result VARCHAR2(100);
4510:

Line 4627: igs_ps_unit_ofr_opt_all US,

4623: CA.START_DT), 'DD MON YYYY') || ' - ' ||
4624: TO_CHAR( NVL( NVL( USO.END_DATE, US.UNIT_SECTION_END_DATE),
4625: CA.END_DT), 'DD MON YYYY') effective_date
4626: FROM igs_ps_usec_occurs_all USO,
4627: igs_ps_unit_ofr_opt_all US,
4628: igs_ca_inst_all CA
4629: WHERE uso.unit_section_occurrence_id = cp_n_uso_id
4630: AND uso.uoo_id = us.uoo_id
4631: AND us.cal_type = ca.cal_type

Line 4887: FROM igs_ps_unit

4883: l_unit_cd VARCHAR2(2000);
4884:
4885: CURSOR c_unit_cd(cp_unit_cd VARCHAR2) IS
4886: SELECT DISTINCT unit_cd
4887: FROM igs_ps_unit
4888: WHERE unit_cd like cp_unit_cd;
4889:
4890: BEGIN
4891: l_coreq_string := p_coreq_string;

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 5071: FROM igs_ps_unit_ofr_opt_all

5067:
5068: CURSOR c_uv(cp_n_uoo_id IN NUMBER) IS
5069: SELECT unit_cd,
5070: version_number
5071: FROM igs_ps_unit_ofr_opt_all
5072: WHERE uoo_id = cp_n_uoo_id;
5073:
5074:
5075: CURSOR c_uv_gen_ref(cp_c_unit_cd IN VARCHAR2, cp_n_version IN NUMBER) IS

Line 5077: FROM igs_ps_unit_ref_cd

5073:
5074:
5075: CURSOR c_uv_gen_ref(cp_c_unit_cd IN VARCHAR2, cp_n_version IN NUMBER) IS
5076: SELECT 1
5077: FROM igs_ps_unit_ref_cd
5078: WHERE unit_cd = cp_c_unit_cd
5079: AND version_number = cp_n_version
5080: AND ROWNUM < 2;
5081:

Line 5084: FROM igs_ps_unitreqref_cd

5080: AND ROWNUM < 2;
5081:
5082: CURSOR c_uv_req_ref(cp_c_unit_cd IN VARCHAR2, cp_n_version IN NUMBER) IS
5083: SELECT 1
5084: FROM igs_ps_unitreqref_cd
5085: WHERE unit_cd = cp_c_unit_cd
5086: AND version_number = cp_n_version
5087: AND ROWNUM <2 ;
5088:

Line 5219: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

5215:
5216: --
5217: -- Cursor to find the Unit Code
5218: --
5219: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
5220: SELECT unit_cd, unit_class, CORE_INDICATOR_CODE
5221: FROM igs_en_su_attempt
5222: WHERE person_id = p_person_id
5223: AND course_cd = p_program_cd

Line 5236: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

5232: WHERE lkup.lookup_type = 'IGS_EN_CORE_IND'
5233: AND lkup.lookup_code = en.core_req_ind;
5234:
5235:
5236: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
5237: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
5238: l_core_meaning igs_lookup_values.meaning%TYPE;
5239: l_core_ind_cd igs_en_su_attempt_all.CORE_INDICATOR_CODE%TYPE;
5240: BEGIN

Line 5237: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

5233: AND lkup.lookup_code = en.core_req_ind;
5234:
5235:
5236: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
5237: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
5238: l_core_meaning igs_lookup_values.meaning%TYPE;
5239: l_core_ind_cd igs_en_su_attempt_all.CORE_INDICATOR_CODE%TYPE;
5240: BEGIN
5241: -- Get the Unit Code

Line 5446: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

5442: FROM igs_lookup_values
5443: WHERE lookup_code = cp_lookup_code
5444: AND lookup_type = 'UOO_RELATION_TYPE';
5445:
5446: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
5447: SELECT unit_cd
5448: FROM igs_ps_unit_ofr_opt
5449: WHERE uoo_id = cp_sup_uoo_id;
5450:

Line 5448: FROM igs_ps_unit_ofr_opt

5444: AND lookup_type = 'UOO_RELATION_TYPE';
5445:
5446: CURSOR c_sup_unit_cd (CP_SUP_UOO_ID IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
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;

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: