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_OFR_OPT

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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;