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

Line 51: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

47: END validate_usec_notes;
48:
49:
50: PROCEDURE validate_usec_assmnt ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,
51: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
52: p_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE,
53: p_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE,
54: p_n_building_id NUMBER,
55: p_n_room_id NUMBER,

Line 206: FROM igs_ps_unit_ofr_opt_all

202: Who When What
203: ********************************************************************************************** */
204: CURSOR cur_usec (cp_uoo_id NUMBER) IS
205: SELECT 'X'
206: FROM igs_ps_unit_ofr_opt_all
207: WHERE uoo_id = cp_uoo_id
208: AND NVL(enrollment_actual,0) > 0;
209: l_c_var VARCHAR2(1);
210: l_c_message VARCHAR2(30);

Line 346: FROM igs_ps_unit_ofr_opt_all

342: c_reference_rec c_reference%ROWTYPE;
343:
344: CURSOR c_usec(cp_n_uoo_id NUMBER) IS
345: SELECT *
346: FROM igs_ps_unit_ofr_opt_all
347: WHERE uoo_id = cp_n_uoo_id;
348:
349: c_usec_rec c_usec%ROWTYPE;
350:

Line 628: FROM igs_ps_unit_ofr_opt_all uoo

624: ********************************************************************************************** */
625:
626: CURSOR cur_usec IS
627: SELECT 'X'
628: FROM igs_ps_unit_ofr_opt_all uoo
629: WHERE uoo.unit_section_status IN ('OPEN','PLANNED','FULLWAITOK','CLOSED')
630: AND uoo.relation_type='NONE'
631: AND uoo.cal_type=p_c_cal_type
632: AND uoo.ci_sequence_number =p_n_seq_num

Line 643: CURSOR c_x_grpmem(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

639: FROM igs_en_su_attempt
640: WHERE uoo_id=cp_uoo_id
641: AND unit_attempt_status='WAITLISTED';
642:
643: CURSOR c_x_grpmem(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
644: SELECT 'X'
645: FROM igs_ps_usec_x_grpmem
646: WHERE uoo_id=cp_uoo_id;
647:

Line 650: CURSOR cur_waitlist(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

646: WHERE uoo_id=cp_uoo_id;
647:
648: c_x_grpmem_rec c_x_grpmem%ROWTYPE;
649:
650: CURSOR cur_waitlist(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
651: SELECT waitlist_actual
652: FROM igs_ps_unit_ofr_opt
653: WHERE uoo_id=cp_uoo_id;
654: l_cur_waitlist cur_waitlist%ROWTYPE;

Line 652: FROM igs_ps_unit_ofr_opt

648: c_x_grpmem_rec c_x_grpmem%ROWTYPE;
649:
650: CURSOR cur_waitlist(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
651: SELECT waitlist_actual
652: FROM igs_ps_unit_ofr_opt
653: WHERE uoo_id=cp_uoo_id;
654: l_cur_waitlist cur_waitlist%ROWTYPE;
655:
656: l_sysdate DATE := trunc(SYSDATE);

Line 791: PROCEDURE update_usec_status(p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

787: CLOSE cur_waitlist;
788:
789: END validate_uso_clas_meet;
790:
791: PROCEDURE update_usec_status(p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
792: p_unit_section_status IN igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
793: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
794: SELECT *
795: FROM igs_ps_unit_ofr_opt

Line 792: p_unit_section_status IN igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS

788:
789: END validate_uso_clas_meet;
790:
791: PROCEDURE update_usec_status(p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
792: p_unit_section_status IN igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
793: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
794: SELECT *
795: FROM igs_ps_unit_ofr_opt
796: WHERE uoo_id=cp_uoo_id;

Line 793: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

789: END validate_uso_clas_meet;
790:
791: PROCEDURE update_usec_status(p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
792: p_unit_section_status IN igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
793: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
794: SELECT *
795: FROM igs_ps_unit_ofr_opt
796: WHERE uoo_id=cp_uoo_id;
797: l_cur_usec cur_usec%ROWTYPE;

Line 795: FROM igs_ps_unit_ofr_opt

791: PROCEDURE update_usec_status(p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
792: p_unit_section_status IN igs_ps_unit_ofr_opt.unit_section_status%TYPE) IS
793: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
794: SELECT *
795: FROM igs_ps_unit_ofr_opt
796: WHERE uoo_id=cp_uoo_id;
797: l_cur_usec cur_usec%ROWTYPE;
798:
799: BEGIN

Line 805: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_cur_usec.row_id,

801: FETCH cur_usec INTO l_cur_usec;
802: CLOSE cur_usec;
803:
804:
805: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_cur_usec.row_id,
806: x_unit_cd =>l_cur_usec.unit_cd,
807: x_version_number =>l_cur_usec.version_number,
808: x_cal_type =>l_cur_usec.cal_type,
809: x_ci_sequence_number =>l_cur_usec.ci_sequence_number,

Line 893: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ) IS

889:
890: c_usec_enr_rec c_usec_enr%ROWTYPE;
891:
892: CURSOR cur_usec (cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,
893: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ) IS
894: SELECT uoo.uoo_id
895: FROM igs_ps_uso_clas_meet usm,
896: igs_ps_unit_ofr_opt uoo
897: WHERE usm.class_meet_group_id = cp_class_meet_group_id

Line 896: igs_ps_unit_ofr_opt uoo

892: CURSOR cur_usec (cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,
893: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ) IS
894: SELECT uoo.uoo_id
895: FROM igs_ps_uso_clas_meet usm,
896: igs_ps_unit_ofr_opt uoo
897: WHERE usm.class_meet_group_id = cp_class_meet_group_id
898: AND usm.uoo_id=uoo.uoo_id
899: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
900:

Line 1132: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ) IS

1128:
1129: c_old_cmgrp_rec c_old_cmgrp%ROWTYPE;
1130:
1131: CURSOR cur_usec (cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,
1132: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ) IS
1133: SELECT uoo.uoo_id
1134: FROM igs_ps_uso_clas_meet usm,
1135: igs_ps_unit_ofr_opt uoo
1136: WHERE usm.class_meet_group_id = cp_class_meet_group_id

Line 1135: igs_ps_unit_ofr_opt uoo

1131: CURSOR cur_usec (cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,
1132: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE ) IS
1133: SELECT uoo.uoo_id
1134: FROM igs_ps_uso_clas_meet usm,
1135: igs_ps_unit_ofr_opt uoo
1136: WHERE usm.class_meet_group_id = cp_class_meet_group_id
1137: AND usm.uoo_id=uoo.uoo_id
1138: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
1139:

Line 1243: FROM igs_ps_unit_ofr_opt_all uoo

1239: ********************************************************************************************** */
1240:
1241: CURSOR cur_usec IS
1242: SELECT 'X'
1243: FROM igs_ps_unit_ofr_opt_all uoo
1244: WHERE uoo.unit_section_status IN ('OPEN','PLANNED','FULLWAITOK','CLOSED')
1245: AND uoo.relation_type='NONE'
1246: AND uoo.cal_type=p_c_cal_type
1247: AND uoo.ci_sequence_number =p_n_seq_num

Line 1252: CURSOR c_uso_cm(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

1248: AND uoo.uoo_id=p_n_uoo_id;
1249:
1250: cur_usec_rec cur_usec%ROWTYPE;
1251:
1252: CURSOR c_uso_cm(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
1253: SELECT 'X'
1254: FROM igs_ps_uso_clas_meet
1255: WHERE uoo_id=cp_uoo_id;
1256:

Line 1265: CURSOR cur_waitlist(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1261: FROM igs_en_su_attempt
1262: WHERE uoo_id=cp_uoo_id
1263: AND unit_attempt_status='WAITLISTED';
1264:
1265: CURSOR cur_waitlist(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1266: SELECT waitlist_actual
1267: FROM igs_ps_unit_ofr_opt
1268: WHERE uoo_id=cp_uoo_id;
1269: l_cur_waitlist cur_waitlist%ROWTYPE;

Line 1267: FROM igs_ps_unit_ofr_opt

1263: AND unit_attempt_status='WAITLISTED';
1264:
1265: CURSOR cur_waitlist(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1266: SELECT waitlist_actual
1267: FROM igs_ps_unit_ofr_opt
1268: WHERE uoo_id=cp_uoo_id;
1269: l_cur_waitlist cur_waitlist%ROWTYPE;
1270:
1271: l_sysdate DATE := trunc(SYSDATE);

Line 1449: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE

1445:
1446: c_usec_enr_rec c_usec_enr%ROWTYPE;
1447:
1448: CURSOR cur_usec (cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,
1449: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE
1450: ) IS
1451: SELECT uoo.uoo_id
1452: FROM igs_ps_usec_x_grpmem usm,
1453: igs_ps_unit_ofr_opt uoo

Line 1453: igs_ps_unit_ofr_opt uoo

1449: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE
1450: ) IS
1451: SELECT uoo.uoo_id
1452: FROM igs_ps_usec_x_grpmem usm,
1453: igs_ps_unit_ofr_opt uoo
1454: WHERE usm.usec_x_listed_group_id = cp_usec_x_listed_group_id
1455: AND usm.uoo_id=uoo.uoo_id
1456: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
1457:

Line 1825: FROM igs_as_us_ai_group a, igs_ps_unit_ofr_opt_all b, igs_ca_inst_all c

1821: AND logical_delete_dt IS NULL;
1822:
1823: CURSOR cur_group (cp_rec_as_us_ai igs_ps_generic_pub.usec_ass_item_grp_rec_type) IS
1824: SELECT a.us_ass_item_group_id
1825: FROM igs_as_us_ai_group a, igs_ps_unit_ofr_opt_all b, igs_ca_inst_all c
1826: WHERE a.group_name = cp_rec_as_us_ai.group_name
1827: AND a.uoo_id =b.uoo_id
1828: AND b.unit_cd=cp_rec_as_us_ai.unit_cd
1829: AND b.version_number=cp_rec_as_us_ai.version_number

Line 1948: CURSOR c_tro_perc_sum( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

1944: Known limitations,enhancements,remarks:
1945: Change History (in reverse chronological order)
1946: Who When What
1947: ********************************************************************************************** */
1948: CURSOR c_tro_perc_sum( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
1949: SELECT SUM(percentage) percentage
1950: FROM igs_ps_tch_resp_ovrd_all
1951: WHERE uoo_id=cp_uoo_id;
1952: c_tro_perc_sum_rec c_tro_perc_sum%ROWTYPE;

Line 1956: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

1952: c_tro_perc_sum_rec c_tro_perc_sum%ROWTYPE;
1953:
1954: CURSOR c_uoo_id (cp_usec_tch_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type) IS
1955: SELECT uoo_id
1956: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
1957: WHERE a.unit_cd = cp_usec_tch_resp_rec.unit_cd
1958: AND a.version_number = cp_usec_tch_resp_rec.version_number
1959: AND a.cal_type = b.cal_type
1960: AND a.ci_sequence_number = b.sequence_number

Line 2017: CURSOR c_rsv_perc_sum( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

2013: Who When What
2014: ********************************************************************************************** */
2015: l_n_count_msg NUMBER(6);
2016:
2017: CURSOR c_rsv_perc_sum( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2018: SELECT nvl(SUM(percentage_reserved),0) percentage_reserved
2019: FROM igs_ps_rsv_usec_pri usprv,igs_ps_rsv_usec_prf uspfv
2020: WHERE usprv.rsv_usec_pri_id = uspfv.rsv_usec_pri_id
2021: AND usprv.uoo_id =cp_uoo_id;

Line 2045: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

2041: l_c_usec_rsvprfc_ser c_usec_rsvprfc_ser%ROWTYPE;
2042:
2043: CURSOR c_uoo_id (cp_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type) IS
2044: SELECT uoo_id
2045: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
2046: WHERE a.unit_cd = cp_usec_rsv_rec.unit_cd
2047: AND a.version_number = cp_usec_rsv_rec.version_number
2048: AND a.cal_type = b.cal_type
2049: AND a.ci_sequence_number = b.sequence_number

Line 2219: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

2215: l_c_usec_wlstprfc_ser c_usec_wlstprfc_ser%ROWTYPE;
2216:
2217: CURSOR c_uoo_id (cp_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type) IS
2218: SELECT uoo_id
2219: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
2220: WHERE a.unit_cd = cp_usec_wlst_rec.unit_cd
2221: AND a.version_number = cp_usec_wlst_rec.version_number
2222: AND a.cal_type = b.cal_type
2223: AND a.ci_sequence_number = b.sequence_number

Line 2450: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

2446:
2447: END validate_category;
2448:
2449: PROCEDURE validate_usec_rsvpri(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,
2450: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
2451: p_insert_update IN VARCHAR2)
2452: AS
2453: /***********************************************************************************************
2454: Created By : Sommukhe

Line 2462: CURSOR c_rsv_allow (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

2458: Known limitations,enhancements,remarks:
2459: Change History (in reverse chronological order)
2460: Who When What
2461: ********************************************************************************************** */
2462: CURSOR c_rsv_allow (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2463: SELECT reserved_seating_allowed
2464: FROM igs_ps_unit_ofr_opt_all
2465: WHERE uoo_id =cp_n_uoo_id;
2466: c_rsvpri_rec c_rsv_allow%ROWTYPE;

Line 2464: FROM igs_ps_unit_ofr_opt_all

2460: Who When What
2461: ********************************************************************************************** */
2462: CURSOR c_rsv_allow (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2463: SELECT reserved_seating_allowed
2464: FROM igs_ps_unit_ofr_opt_all
2465: WHERE uoo_id =cp_n_uoo_id;
2466: c_rsvpri_rec c_rsv_allow%ROWTYPE;
2467:
2468: l_c_message VARCHAR2(30);

Line 2781: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

2777:
2778:
2779: --Validations for Unit section waitlist
2780: PROCEDURE validate_usec_wlstpri(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,
2781: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
2782: p_insert_update VARCHAR2)
2783: AS
2784: /***********************************************************************************************
2785: Created By : Sommukhe

Line 2793: CURSOR c_wlst_allow (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

2789: Known limitations,enhancements,remarks:
2790: Change History (in reverse chronological order)
2791: Who When What
2792: ********************************************************************************************** */
2793: CURSOR c_wlst_allow (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2794: SELECT waitlist_allowed
2795: FROM igs_ps_usec_lim_wlst
2796: WHERE uoo_id = cp_n_uoo_id;
2797:

Line 2800: CURSOR c_wlst_allow_pat (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

2796: WHERE uoo_id = cp_n_uoo_id;
2797:
2798: c_wlst_allow_rec c_wlst_allow%ROWTYPE;
2799:
2800: CURSOR c_wlst_allow_pat (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2801: SELECT 'X'
2802: FROM igs_ps_unit_ofr_pat_all a, igs_ps_unit_ofr_opt_all b
2803: WHERE b.uoo_id = cp_n_uoo_id
2804: AND a.unit_cd=b.unit_cd

Line 2802: FROM igs_ps_unit_ofr_pat_all a, igs_ps_unit_ofr_opt_all b

2798: c_wlst_allow_rec c_wlst_allow%ROWTYPE;
2799:
2800: CURSOR c_wlst_allow_pat (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2801: SELECT 'X'
2802: FROM igs_ps_unit_ofr_pat_all a, igs_ps_unit_ofr_opt_all b
2803: WHERE b.uoo_id = cp_n_uoo_id
2804: AND a.unit_cd=b.unit_cd
2805: AND a.version_number=b.version_number
2806: AND a.cal_type=b.cal_type