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_USEC_X_GRP

Line 1804: p_group_name OUT NOCOPY igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE

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
1806:
1807: ------------------------------------------------------------------------------------
1808: --Created by : pradhakr

Line 1827: FROM igs_ps_usec_x_grpmem grpmem,

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
1830: AND grpmem.uoo_id = l_uoo_id;
1831:

Line 1828: igs_ps_usec_x_grp grp

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
1830: AND grpmem.uoo_id = l_uoo_id;
1831:
1832:

Line 1917: -- igs_ps_usec_x_grp.max_enr_group to

1913: --
1914: --Change History:
1915: --Who When What
1916: -- pradhakr 30-Dec-02 Changed the data type of the variable l_max from
1917: -- igs_ps_usec_x_grp.max_enr_group to
1918: -- igs_ps_usec_lim_wlst.enrollment_maximum.
1919: -------------------------------------------------------------------------------------
1920:
1921: -- Cursor to get the enrollment maximum in cross listed group

Line 1924: FROM igs_ps_usec_x_grpmem grpmem,

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
1927: AND grpmem.uoo_id = l_uoo_id;
1928:

Line 1925: igs_ps_usec_x_grp grp

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
1927: AND grpmem.uoo_id = l_uoo_id;
1928:
1929:

Line 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

1936: AND ucm.uoo_id = l_uoo_id;
1937:
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

Line 1943: igs_ps_usec_x_grpmem ugrp

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

Line 2148: p_group_name igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE;

2144: --
2145: -------------------------------------------------------------------------------------
2146: p_return_status VARCHAR2(1);
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

Line 2153: FROM igs_ps_usec_x_grpmem grpmem,

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
2156: AND grpmem.uoo_id = l_uoo_id;
2157:

Line 2154: igs_ps_usec_x_grp grp

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
2156: AND grpmem.uoo_id = l_uoo_id;
2157:
2158:

Line 3919: FROM igs_ps_usec_x_grpmem grpmem,

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
3922: AND grpmem.uoo_id = l_uoo_id;
3923:

Line 3920: igs_ps_usec_x_grp grp

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
3922: AND grpmem.uoo_id = l_uoo_id;
3923:
3924:

Line 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

3931: AND ucm.uoo_id = l_uoo_id;
3932:
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

Line 3938: igs_ps_usec_x_grpmem ugrp

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