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_USO_CLAS_MEET

Line 864: FROM igs_ps_uso_clas_meet

860: Who When What
861: ********************************************************************************************** */
862: CURSOR c_host(cp_class_meet_group_id NUMBER) IS
863: SELECT count (ROWID) cnt
864: FROM igs_ps_uso_clas_meet
865: WHERE host = 'Y'
866: AND class_meet_group_id =cp_class_meet_group_id;
867:
868: c_host_rec c_host%ROWTYPE;

Line 870: CURSOR c_cm_grp(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS

866: AND class_meet_group_id =cp_class_meet_group_id;
867:
868: c_host_rec c_host%ROWTYPE;
869:
870: CURSOR c_cm_grp(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
871: SELECT *
872: FROM igs_ps_uso_cm_grp
873: WHERE class_meet_group_id = cp_class_meet_group_id;
874:

Line 878: CURSOR c_sum_enract(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS

874:
875: c_cm_grp_rec c_cm_grp%ROWTYPE;
876:
877:
878: CURSOR c_sum_enract(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
879: SELECT SUM(enrollment_actual) sum_enrollment_actual
880: FROM igs_ps_uso_clas_meet_v
881: WHERE class_meet_group_id = cp_class_meet_group_id ;
882:

Line 880: FROM igs_ps_uso_clas_meet_v

876:
877:
878: CURSOR c_sum_enract(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
879: SELECT SUM(enrollment_actual) sum_enrollment_actual
880: FROM igs_ps_uso_clas_meet_v
881: WHERE class_meet_group_id = cp_class_meet_group_id ;
882:
883: c_sum_enract_rec c_sum_enract%ROWTYPE;
884:

Line 885: CURSOR c_usec_enr(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS

881: WHERE class_meet_group_id = cp_class_meet_group_id ;
882:
883: c_sum_enract_rec c_sum_enract%ROWTYPE;
884:
885: CURSOR c_usec_enr(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
886: SELECT *
887: FROM igs_ps_uso_clas_meet_v
888: WHERE class_meet_group_id = cp_class_meet_group_id ;
889:

Line 887: FROM igs_ps_uso_clas_meet_v

883: c_sum_enract_rec c_sum_enract%ROWTYPE;
884:
885: CURSOR c_usec_enr(cp_class_meet_group_id igs_ps_uso_clas_meet_v.class_meet_group_id%TYPE) IS
886: SELECT *
887: FROM igs_ps_uso_clas_meet_v
888: WHERE class_meet_group_id = cp_class_meet_group_id ;
889:
890: c_usec_enr_rec c_usec_enr%ROWTYPE;
891:

Line 892: CURSOR cur_usec (cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,

888: WHERE class_meet_group_id = cp_class_meet_group_id ;
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

Line 895: FROM igs_ps_uso_clas_meet usm,

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
898: AND usm.uoo_id=uoo.uoo_id
899: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');

Line 1131: CURSOR cur_usec (cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE,

1127: AND ci_sequence_number=cp_seq_no;
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

Line 1134: FROM igs_ps_uso_clas_meet usm,

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
1137: AND usm.uoo_id=uoo.uoo_id
1138: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');

Line 1140: CURSOR cur_usecs_in_group(cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS

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:
1140: CURSOR cur_usecs_in_group(cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
1141: SELECT uoo_id
1142: FROM igs_ps_uso_clas_meet
1143: WHERE class_meet_group_id = cp_class_meet_group_id;
1144:

Line 1142: FROM igs_ps_uso_clas_meet

1138: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
1139:
1140: CURSOR cur_usecs_in_group(cp_class_meet_group_id igs_ps_uso_clas_meet.class_meet_group_id%TYPE) IS
1141: SELECT uoo_id
1142: FROM igs_ps_uso_clas_meet
1143: WHERE class_meet_group_id = cp_class_meet_group_id;
1144:
1145: l_message_name fnd_new_messages.message_name%TYPE;
1146: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;

Line 1254: FROM igs_ps_uso_clas_meet

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:
1257: c_uso_cm_rec c_uso_cm%ROWTYPE;
1258: