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_EN_GEN_011 dependencies on IGS_PS_UNIT_OFR_OPT

Line 129: p_ci_seq_num IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE

125: suar_table suar_table_type;
126:
127: FUNCTION enrl_sort_usecs ( p_suat IN OUT NOCOPY t_sua_typ,
128: p_cal_type IN igs_ca_inst.cal_type%TYPE,
129: p_ci_seq_num IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE
130: ) RETURN VARCHAR2 AS
131: ------------------------------------------------------------------
132: --Created by : rvivekan, Oracle IDC
133: --Date created:

Line 145: CURSOR c_rel_type (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

141: --Known limitations/enhancements and/or remarks:
142: --
143: --Change History:
144: ---------------------------------------------------------------------
145: CURSOR c_rel_type (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
146: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
147: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 146: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,

142: --
143: --Change History:
144: ---------------------------------------------------------------------
145: CURSOR c_rel_type (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
146: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
147: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
150: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS

Line 147: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,

143: --Change History:
144: ---------------------------------------------------------------------
145: CURSOR c_rel_type (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
146: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
147: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
150: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
151: SELECT uoo_id, relation_type

Line 148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,

144: ---------------------------------------------------------------------
145: CURSOR c_rel_type (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
146: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
147: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
150: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
151: SELECT uoo_id, relation_type
152: FROM igs_ps_unit_ofr_opt

Line 149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

145: CURSOR c_rel_type (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
146: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
147: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
150: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
151: SELECT uoo_id, relation_type
152: FROM igs_ps_unit_ofr_opt
153: WHERE unit_cd = cp_unit_cd

Line 150: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS

146: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
147: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
150: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
151: SELECT uoo_id, relation_type
152: FROM igs_ps_unit_ofr_opt
153: WHERE unit_cd = cp_unit_cd
154: AND version_number = cp_ver_num

Line 152: FROM igs_ps_unit_ofr_opt

148: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
149: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
150: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
151: SELECT uoo_id, relation_type
152: FROM igs_ps_unit_ofr_opt
153: WHERE unit_cd = cp_unit_cd
154: AND version_number = cp_ver_num
155: AND cal_type = cp_cal_type
156: AND ci_sequence_number = cp_ci_seq_num

Line 1297: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

1293: l_attendance_type_reach BOOLEAN := TRUE;
1294: l_att_type VARCHAR2(40);
1295: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1296: l_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1297: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1298: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;

Line 1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;

1298: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;
1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;

Line 1396: CURSOR cur_get_uoo(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

1392: SELECT meaning
1393: FROM igs_lookup_values v1
1394: WHERE v1.lookup_Type = 'VS_EN_ACT_UNIT' AND
1395: v1.lookup_code=cp_code;
1396: CURSOR cur_get_uoo(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1398: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,

1393: FROM igs_lookup_values v1
1394: WHERE v1.lookup_Type = 'VS_EN_ACT_UNIT' AND
1395: v1.lookup_code=cp_code;
1396: CURSOR cur_get_uoo(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1398: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1401: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS

Line 1398: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,

1394: WHERE v1.lookup_Type = 'VS_EN_ACT_UNIT' AND
1395: v1.lookup_code=cp_code;
1396: CURSOR cur_get_uoo(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1398: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1401: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1402: SELECT uoo_id,relation_type

Line 1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,

1395: v1.lookup_code=cp_code;
1396: CURSOR cur_get_uoo(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1398: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1401: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1402: SELECT uoo_id,relation_type
1403: FROM igs_ps_unit_ofr_opt

Line 1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

1396: CURSOR cur_get_uoo(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1398: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1401: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1402: SELECT uoo_id,relation_type
1403: FROM igs_ps_unit_ofr_opt
1404: WHERE unit_cd = cp_unit_cd

Line 1401: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS

1397: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1398: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1401: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1402: SELECT uoo_id,relation_type
1403: FROM igs_ps_unit_ofr_opt
1404: WHERE unit_cd = cp_unit_cd
1405: AND version_number = cp_ver_num

Line 1403: FROM igs_ps_unit_ofr_opt

1399: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1400: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1401: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1402: SELECT uoo_id,relation_type
1403: FROM igs_ps_unit_ofr_opt
1404: WHERE unit_cd = cp_unit_cd
1405: AND version_number = cp_ver_num
1406: AND cal_type = cp_cal_type
1407: AND ci_sequence_number = cp_ci_seq_num

Line 1412: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS

1408: AND unit_class = cp_unit_class
1409: AND location_cd = cp_location_cd;
1410: CURSOR cur_sua_stat (cp_person_id igs_en_su_attempt.person_id%TYPE,
1411: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1412: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS
1413: SELECT unit_attempt_status
1414: FROM igs_en_su_attempt
1415: WHERE person_id = cp_person_id
1416: AND course_cd = cp_course_cd

Line 1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

1429:
1430:
1431: CURSOR cur_get_sua_d (cp_person_id igs_en_su_attempt.person_id%TYPE,
1432: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,

1430:
1431: CURSOR cur_get_sua_d (cp_person_id igs_en_su_attempt.person_id%TYPE,
1432: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS

Line 1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,

1431: CURSOR cur_get_sua_d (cp_person_id igs_en_su_attempt.person_id%TYPE,
1432: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1439: SELECT sua.uoo_id,sua.unit_attempt_status,uoo.relation_type

Line 1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,

1432: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1439: SELECT sua.uoo_id,sua.unit_attempt_status,uoo.relation_type
1440: FROM igs_en_su_attempt sua,

Line 1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1439: SELECT sua.uoo_id,sua.unit_attempt_status,uoo.relation_type
1440: FROM igs_en_su_attempt sua,
1441: igs_ps_unit_ofr_opt uoo

Line 1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS

1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1439: SELECT sua.uoo_id,sua.unit_attempt_status,uoo.relation_type
1440: FROM igs_en_su_attempt sua,
1441: igs_ps_unit_ofr_opt uoo
1442: WHERE sua.person_id = cp_person_id

Line 1441: igs_ps_unit_ofr_opt uoo

1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1439: SELECT sua.uoo_id,sua.unit_attempt_status,uoo.relation_type
1440: FROM igs_en_su_attempt sua,
1441: igs_ps_unit_ofr_opt uoo
1442: WHERE sua.person_id = cp_person_id
1443: AND sua.course_cd = cp_course_cd
1444: AND sua.unit_cd = cp_unit_cd
1445: AND sua.version_number = NVL(cp_ver_num,sua.version_number)

Line 2971: FROM IGS_PS_UNIT_OFR_OPT uoo

2967: cst_transferred CONSTANT VARCHAR2(12) := 'TRANSFERRED';
2968: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
2969: CURSOR c_uoo IS
2970: SELECT uoo.uoo_id, uoo.reserved_seating_allowed
2971: FROM IGS_PS_UNIT_OFR_OPT uoo
2972: WHERE uoo.unit_cd = p_from_unit_cd AND
2973: uoo.version_number = p_to_uv_version_number AND
2974: uoo.cal_type = p_teach_cal_type AND
2975: uoo.ci_sequence_number = p_teach_ci_sequence_number AND

Line 3007: FROM IGS_PS_UNIT_OFR_OPT uoo,

3003: --Cursor to get the unit's enrolled_credit_points
3004: CURSOR c_unit_enroll_cp(cp_uoo_id IN NUMBER) IS
3005: SELECT
3006: NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
3007: FROM IGS_PS_UNIT_OFR_OPT uoo,
3008: IGS_PS_UNIT_VER uv,
3009: IGS_PS_USEC_CPS cps
3010: WHERE uoo.uoo_id = cps.uoo_id(+) AND
3011: uoo.unit_cd = uv.unit_cd AND

Line 3080: FROM igs_ps_unit_ofr_opt

3076:
3077: -- Cursor to get the unit code and version number for the passed uoo_id
3078: CURSOR c_unit_cd (l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3079: SELECT unit_cd, version_number
3080: FROM igs_ps_unit_ofr_opt
3081: WHERE uoo_id = l_uoo_id ;
3082:
3083: -- Cursor to get the Relation_type for the passed uoo_id
3084: CURSOR c_uoo_rel_type (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

Line 3086: FROM igs_ps_unit_ofr_opt

3082:
3083: -- Cursor to get the Relation_type for the passed uoo_id
3084: CURSOR c_uoo_rel_type (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3085: SELECT NVL(relation_type,'NONE'),sup_uoo_id
3086: FROM igs_ps_unit_ofr_opt
3087: WHERE uoo_id = cp_uoo_id ;
3088:
3089:
3090: -- Cursor to get the coo_id of the student from spat if exists else get

Line 3127: FROM igs_ps_unit_ofr_opt

3123: AND unit_attempt_status='WAITLISTED';
3124:
3125: CURSOR c_lock_dest_usec(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3126: SELECT uoo_id
3127: FROM igs_ps_unit_ofr_opt
3128: WHERE uoo_id=cp_uoo_id FOR UPDATE;
3129:
3130:
3131: p_deny_warn_att VARCHAR2(20) := NULL ;

Line 3150: l_reserved_seating_allowed igs_ps_unit_ofr_opt.reserved_seating_allowed%TYPE;

3146: v_key VARCHAR2(255);
3147: v_update_uoo BOOLEAN ;
3148: v_fail_type VARCHAR2(10);
3149: v_message_name VARCHAR2(30) ;
3150: l_reserved_seating_allowed igs_ps_unit_ofr_opt.reserved_seating_allowed%TYPE;
3151: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE DEFAULT NULL;
3152: l_waitlist_ind VARCHAR2(3) DEFAULT NULL;
3153: l_dummy VARCHAR2(50) DEFAULT NULL;
3154: l_dummy_bolean BOOLEAN DEFAULT TRUE;

Line 3151: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE DEFAULT NULL;

3147: v_update_uoo BOOLEAN ;
3148: v_fail_type VARCHAR2(10);
3149: v_message_name VARCHAR2(30) ;
3150: l_reserved_seating_allowed igs_ps_unit_ofr_opt.reserved_seating_allowed%TYPE;
3151: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE DEFAULT NULL;
3152: l_waitlist_ind VARCHAR2(3) DEFAULT NULL;
3153: l_dummy VARCHAR2(50) DEFAULT NULL;
3154: l_dummy_bolean BOOLEAN DEFAULT TRUE;
3155: l_message VARCHAR2(100) DEFAULT NULL;