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_002 dependencies on IGS_ST_GVTSEMLOAD_OV

Line 189: v_govt_sem IGS_ST_GVTSEMLOAD_OV.govt_semester%TYPE;

185: RETURN NUMBER AS
186: BEGIN
187: DECLARE
188: v_other_detail VARCHAR2(255);
189: v_govt_sem IGS_ST_GVTSEMLOAD_OV.govt_semester%TYPE;
190: CURSOR c_gslov IS
191: SELECT gslov.govt_semester
192: FROM IGS_ST_GVTSEMLOAD_OV gslov
193: WHERE gslov.submission_yr = p_submission_yr AND

Line 192: FROM IGS_ST_GVTSEMLOAD_OV gslov

188: v_other_detail VARCHAR2(255);
189: v_govt_sem IGS_ST_GVTSEMLOAD_OV.govt_semester%TYPE;
190: CURSOR c_gslov IS
191: SELECT gslov.govt_semester
192: FROM IGS_ST_GVTSEMLOAD_OV gslov
193: WHERE gslov.submission_yr = p_submission_yr AND
194: gslov.submission_number = p_submission_number AND
195: gslov.cal_type = p_load_cal_type AND
196: gslov.ci_sequence_number = p_load_ci_sequence_number AND

Line 211: -- get the government value from the IGS_ST_GVTSEMLOAD_OV

207: -- instance or a load calendar structure (ie. load calendar instance
208: -- and teaching calendar) for a specified government submission.
209: -- If the government semester cannot be determined, a null value
210: -- will be returned.
211: -- get the government value from the IGS_ST_GVTSEMLOAD_OV
212: -- table
213: OPEN c_gslov;
214: FETCH c_gslov INTO v_govt_sem;
215: -- check if a record has been found