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_ALL

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