APPS.IGS_SS_ENR_DETAILS dependencies on IGS_LOOKUPS_VIEW

Line 1503: igs_lookups_view lkup

1499:
1500: IF l_system_person_type = 'STUDENT' THEN
1501: OPEN cur_program_steps FOR SELECT DECODE (l_pig_deny_warn, NULL, eru.notification_flag, l_pig_deny_warn) notification_flag
1502: FROM igs_en_cpd_ext eru,
1503: igs_lookups_view lkup
1504: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
1505: eru.enrolment_cat = p_enrollment_category AND
1506: (eru.s_student_comm_type = p_comm_type OR
1507: eru.s_student_comm_type = 'ALL' ) AND

Line 1523: igs_lookups_view lkup

1519: NULL, DECODE (l_pig_deny_warn, NULL, eru.notification_flag, l_pig_deny_warn)
1520: ) notification_flag
1521: FROM igs_en_cpd_ext_all eru,
1522: igs_pe_usr_aval_all uact,
1523: igs_lookups_view lkup
1524: WHERE eru.s_enrolment_step_type = lkup.lookup_code
1525: AND eru.enrolment_cat = p_enrollment_category
1526: AND eru.enr_method_type = p_enr_method_type
1527: AND (eru.s_student_comm_type = p_comm_type

Line 1803: p_group_type OUT NOCOPY igs_lookups_view.meaning%TYPE,

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
1806:
1807: ------------------------------------------------------------------------------------

Line 1842: CURSOR c_group_type(l_lookup_code igs_lookups_view.lookup_code%type) IS

1838: WHERE grp.class_meet_group_id = ucm.class_meet_group_id
1839: AND ucm.uoo_id = l_uoo_id;
1840:
1841: -- Cursor to get the meaning for the lookup_code 'CROSS_LIST' / 'MEET_WITH'
1842: CURSOR c_group_type(l_lookup_code igs_lookups_view.lookup_code%type) IS
1843: SELECT meaning
1844: FROM igs_lookups_view
1845: WHERE lookup_type = 'IGS_PS_USEC_GROUPS'
1846: AND lookup_code = l_lookup_code;

Line 1844: FROM igs_lookups_view

1840:
1841: -- Cursor to get the meaning for the lookup_code 'CROSS_LIST' / 'MEET_WITH'
1842: CURSOR c_group_type(l_lookup_code igs_lookups_view.lookup_code%type) IS
1843: SELECT meaning
1844: FROM igs_lookups_view
1845: WHERE lookup_type = 'IGS_PS_USEC_GROUPS'
1846: AND lookup_code = l_lookup_code;
1847:
1848: l_cross_listed_row c_cross_listed%ROWTYPE;

Line 1959: CURSOR c_group_type(l_lookup_code igs_lookups_view.lookup_code%type) IS

1955: AND ucls.class_meet_group_id = l_class_meet_group_id;
1956:
1957:
1958: -- Cursor to get the meaning for the lookup_code 'CROSS_LIST' / 'MEET_WITH'
1959: CURSOR c_group_type(l_lookup_code igs_lookups_view.lookup_code%type) IS
1960: SELECT meaning
1961: FROM igs_lookups_view
1962: WHERE lookup_type = 'IGS_PS_USEC_GROUPS'
1963: AND lookup_code = l_lookup_code;

Line 1961: FROM igs_lookups_view

1957:
1958: -- Cursor to get the meaning for the lookup_code 'CROSS_LIST' / 'MEET_WITH'
1959: CURSOR c_group_type(l_lookup_code igs_lookups_view.lookup_code%type) IS
1960: SELECT meaning
1961: FROM igs_lookups_view
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

Line 1993: l_meet_meaning igs_lookups_view.meaning%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);
1997: l_setup_found NUMBER;

Line 1994: l_cross_meaning igs_lookups_view.meaning%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);
1997: l_setup_found NUMBER;
1998: l_temp VARCHAR2(10);

Line 2147: p_group_type igs_lookups_view.meaning%TYPE;

2143: --Who When What
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

Line 2662: CURSOR c_lkups (CP_LOOKUP_CODE IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS

2658: --
2659: --Change History:
2660: --Who When What
2661: -------------------------------------------------------------------
2662: CURSOR c_lkups (CP_LOOKUP_CODE IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
2663: SELECT meaning
2664: FROM igs_lookup_values
2665: WHERE lookup_code = cp_lookup_code
2666: AND lookup_type = 'UOO_RELATION_TYPE';

Line 2674: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;

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:
2678: IF NVL(p_relation_type,'NONE') = 'NONE' THEN

Line 5440: CURSOR c_lkups (CP_LOOKUP_CODE IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS

5436: --
5437: --Change History:
5438: --Who When What
5439: -------------------------------------------------------------------
5440: CURSOR c_lkups (CP_LOOKUP_CODE IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE) IS
5441: SELECT meaning
5442: FROM igs_lookup_values
5443: WHERE lookup_code = cp_lookup_code
5444: AND lookup_type = 'UOO_RELATION_TYPE';

Line 5452: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;

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:
5456: IF NVL(p_relation_type,'NONE') = 'NONE' THEN