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_GENERIC_PUB dependencies on IGS_PS_USEC_CPS

Line 342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,

338: auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
339: audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
340: waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
341: max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
344: variable_increment igs_ps_usec_cps.variable_increment%type,
345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,

Line 343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,

339: audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
340: waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
341: max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
344: variable_increment igs_ps_usec_cps.variable_increment%type,
345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,

Line 344: variable_increment igs_ps_usec_cps.variable_increment%type,

340: waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
341: max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
344: variable_increment igs_ps_usec_cps.variable_increment%type,
345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,

Line 345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,

341: max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
344: variable_increment igs_ps_usec_cps.variable_increment%type,
345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,

Line 346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,

342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
344: variable_increment igs_ps_usec_cps.variable_increment%type,
345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,

Line 347: other_credit_points igs_ps_usec_cps.other_credit_points%type,

343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
344: variable_increment igs_ps_usec_cps.variable_increment%type,
345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,

Line 348: clock_hours igs_ps_usec_cps.clock_hours%type,

344: variable_increment igs_ps_usec_cps.variable_increment%type,
345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,

Line 349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,

345: lecture_credit_points igs_ps_usec_cps.lecture_credit_points%type,
346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,

Line 350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,

346: lab_credit_points igs_ps_usec_cps.lab_credit_points%type,
347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,

Line 351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,

347: other_credit_points igs_ps_usec_cps.other_credit_points%type,
348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,

Line 352: work_load_other igs_ps_usec_cps.work_load_other%type,

348: clock_hours igs_ps_usec_cps.clock_hours%type,
349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,

Line 353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,

349: work_load_cp_lecture igs_ps_usec_cps.work_load_cp_lecture%type,
350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,

Line 354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,

350: work_load_cp_lab igs_ps_usec_cps.work_load_cp_lab%type,
351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,

Line 355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,

351: continuing_education_units igs_ps_usec_cps.continuing_education_units%type,
352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,
359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,

Line 356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,

352: work_load_other igs_ps_usec_cps.work_load_other%type,
353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,
359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,
360: enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,

Line 357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,

353: contact_hrs_lecture igs_ps_usec_cps.contact_hrs_lecture%type,
354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,
359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,
360: enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,
361: billing_credit_points igs_ps_usec_cps.billing_credit_points%TYPE,

Line 358: claimable_hours igs_ps_usec_cps.claimable_hours%type,

354: contact_hrs_lab igs_ps_usec_cps.contact_hrs_lab%type,
355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,
359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,
360: enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,
361: billing_credit_points igs_ps_usec_cps.billing_credit_points%TYPE,
362: reference_subtitle igs_ps_unit_subtitle.subtitle%type,

Line 359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,

355: contact_hrs_other igs_ps_usec_cps.contact_hrs_other%type,
356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,
359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,
360: enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,
361: billing_credit_points igs_ps_usec_cps.billing_credit_points%TYPE,
362: reference_subtitle igs_ps_unit_subtitle.subtitle%type,
363: reference_short_title igs_ps_usec_ref.short_title%type,

Line 360: enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,

356: non_schd_required_hrs igs_ps_usec_cps.non_schd_required_hrs%type,
357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,
359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,
360: enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,
361: billing_credit_points igs_ps_usec_cps.billing_credit_points%TYPE,
362: reference_subtitle igs_ps_unit_subtitle.subtitle%type,
363: reference_short_title igs_ps_usec_ref.short_title%type,
364: reference_subtitle_mod_flag igs_ps_usec_ref.subtitle_modifiable_flag%type,

Line 361: billing_credit_points igs_ps_usec_cps.billing_credit_points%TYPE,

357: exclude_from_max_cp_limit igs_ps_usec_cps.exclude_from_max_cp_limit%type,
358: claimable_hours igs_ps_usec_cps.claimable_hours%type,
359: achievable_credit_points igs_ps_usec_cps.achievable_credit_points%TYPE,
360: enrolled_credit_points igs_ps_usec_cps.enrolled_credit_points%TYPE,
361: billing_credit_points igs_ps_usec_cps.billing_credit_points%TYPE,
362: reference_subtitle igs_ps_unit_subtitle.subtitle%type,
363: reference_short_title igs_ps_usec_ref.short_title%type,
364: reference_subtitle_mod_flag igs_ps_usec_ref.subtitle_modifiable_flag%type,
365: reference_class_sch_excl_flag igs_ps_usec_ref.class_schedule_exclusion_flag%type,

Line 408: billing_hrs igs_ps_usec_cps.billing_hrs%type

404: sup_teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
405: sup_location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
406: sup_unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
407: default_enroll_flag igs_ps_unit_ofr_opt_all.default_enroll_flag%type,
408: billing_hrs igs_ps_usec_cps.billing_hrs%type
409: );
410:
411: TYPE usec_tbl_type IS TABLE OF usec_rec_type INDEX BY BINARY_INTEGER;
412: