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

Line 45: FUNCTION check_grading_cohort (lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

41: APP_EXCEPTION.RAISE_EXCEPTION;
42:
43: END get_dt_alias_val; -- get_dt_alias_val
44:
45: FUNCTION check_grading_cohort (lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
46: lp_grading_period_cd IN igs_as_grd_schema.grading_schema_cd%TYPE,
47: lp_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
48: lp_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
49: RETURN BOOLEAN IS

Line 146: lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

142:
143:
144: PROCEDURE raise_business_event (
145: lp_internal_name IN VARCHAR2,
146: lp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
147: lp_teach_description IN igs_ca_inst_all.description%TYPE,
148: lp_load_description IN igs_ca_inst_all.description%TYPE,
149: lp_grading_period_start_dt IN DATE,
150: lp_grading_period_end_dt IN DATE,

Line 151: lp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

147: lp_teach_description IN igs_ca_inst_all.description%TYPE,
148: lp_load_description IN igs_ca_inst_all.description%TYPE,
149: lp_grading_period_start_dt IN DATE,
150: lp_grading_period_end_dt IN DATE,
151: lp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
152: lp_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
153: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
154: lp_location_description IN igs_ad_location.description%TYPE,
155: lp_title IN igs_ps_unit_ver_all.title%TYPE,

Line 152: lp_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,

148: lp_load_description IN igs_ca_inst_all.description%TYPE,
149: lp_grading_period_start_dt IN DATE,
150: lp_grading_period_end_dt IN DATE,
151: lp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
152: lp_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
153: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
154: lp_location_description IN igs_ad_location.description%TYPE,
155: lp_title IN igs_ps_unit_ver_all.title%TYPE,
156: lp_short_title IN igs_ps_unit_ver_all.short_title%TYPE,

Line 153: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

149: lp_grading_period_start_dt IN DATE,
150: lp_grading_period_end_dt IN DATE,
151: lp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
152: lp_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
153: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
154: lp_location_description IN igs_ad_location.description%TYPE,
155: lp_title IN igs_ps_unit_ver_all.title%TYPE,
156: lp_short_title IN igs_ps_unit_ver_all.short_title%TYPE,
157: lp_instructor_id IN igs_ps_usec_tch_resp.instructor_id%TYPE )

Line 309: FROM igs_ps_unit_ofr_opt uoo,

305: uoo.attendance_required_ind,
306: uv.title,
307: uv.short_title,
308: utr.instructor_id
309: FROM igs_ps_unit_ofr_opt uoo,
310: igs_ps_unit_ver uv,
311: igs_ps_usec_tch_resp utr,
312: igs_ad_location loc
313: WHERE uoo.cal_type = cp_teach_cal_type

Line 321: CURSOR c_attend_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

317: AND uoo.location_cd = loc.location_cd
318: AND uoo.uoo_id = utr.uoo_id (+)
319: AND utr.lead_instructor_flag (+) = 'Y' ;
320:
321: CURSOR c_attend_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
322: SELECT 'X'
323: FROM igs_as_gaa_sub_hist gash
324: WHERE gash.uoo_id = cp_uoo_id
325: AND gash.submission_type = 'ATTENDANCE'

Line 333: CURSOR c_midterm_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE)IS

329: FROM igs_as_gaa_sub_hist gash2
330: WHERE gash2.uoo_id = cp_uoo_id
331: AND gash2.submission_type = 'ATTENDANCE');
332:
333: CURSOR c_midterm_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE)IS
334: SELECT 'X'
335: FROM igs_as_gaa_sub_hist gash
336: WHERE gash.uoo_id = cp_uoo_id
337: AND gash.submission_type = 'GRADE'

Line 347: CURSOR c_earlyfinal_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

343: WHERE gash2.uoo_id = cp_uoo_id
344: AND gash2.submission_type = 'GRADE'
345: AND gash2.grading_period_cd = 'MIDTERM');
346:
347: CURSOR c_earlyfinal_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
348: SELECT 'X'
349: FROM igs_as_gaa_sub_hist gash
350: WHERE gash.uoo_id = cp_uoo_id
351: AND gash.submission_type = 'GRADE'

Line 361: CURSOR c_final_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

357: WHERE gash2.uoo_id = cp_uoo_id
358: AND gash2.submission_type = 'GRADE'
359: AND gash2.grading_period_cd = 'EARLY_FINAL');
360:
361: CURSOR c_final_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
362: SELECT 'X'
363: FROM igs_as_gaa_sub_hist gash
364: WHERE gash.uoo_id = cp_uoo_id
365: AND gash.submission_type = 'GRADE'