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.

[Home] [Help]

APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_PS_UNIT_VER

Line 155: lp_title IN igs_ps_unit_ver_all.title%TYPE,

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 )
158: IS
159:

Line 156: lp_short_title IN igs_ps_unit_ver_all.short_title%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 )
158: IS
159:
160: /*

Line 310: igs_ps_unit_ver uv,

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
314: AND uoo.ci_sequence_number = cp_teach_ci_sequence_number