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_ST_GEN_003 dependencies on IGS_PS_TYPE

Line 245: v_govt_crs_type IGS_PS_TYPE.govt_course_type%TYPE;

241: v_unit_cat IGS_PS_UNIT_CATEGORY.unit_cat%TYPE;
242: v_crs_cat IGS_PS_CATEGORISE.course_cat%TYPE;
243: v_resp_ou_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
244: v_resp_ou_start_dt IGS_PS_VER.responsible_ou_start_dt%TYPE;
245: v_govt_crs_type IGS_PS_TYPE.govt_course_type%TYPE;
246: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
247: v_enr_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
248: v_message_name_temp VARCHAR2(30) DEFAULT NULL;
249: v_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE DEFAULT NULL;

Line 246: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;

242: v_crs_cat IGS_PS_CATEGORISE.course_cat%TYPE;
243: v_resp_ou_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
244: v_resp_ou_start_dt IGS_PS_VER.responsible_ou_start_dt%TYPE;
245: v_govt_crs_type IGS_PS_TYPE.govt_course_type%TYPE;
246: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;
247: v_enr_cp IGS_PS_UNIT_VER.enrolled_credit_points%TYPE;
248: v_message_name_temp VARCHAR2(30) DEFAULT NULL;
249: v_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE DEFAULT NULL;
250: v_crs_req_cmplt_ind IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;

Line 277: IGS_PS_TYPE cty

273: crv.responsible_ou_start_dt,
274: cty.govt_course_type,
275: cty.award_course_ind
276: FROM IGS_PS_VER crv,
277: IGS_PS_TYPE cty
278: WHERE crv.course_cd = p_course_cd AND
279: crv.version_number = p_crv_version_number AND
280: cty.course_type = crv.course_type;
281: CURSOR c_uv IS