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_PR_PROUT_LGCY_PUB dependencies on IGS_PR_SPO_SEQ_NUM_S

Line 172: -- from igs_pr_spo_seq_num_s sequence.

168: -- Check for the existance of Student Progression Outcome in OSS which
169: -- matches with the record in interface table. If the record exists then
170: -- assign p_outcome_sequence_number with
171: -- igs_pr_stdnt_pr_ou_all.sequence_number else assign the new sequence value
172: -- from igs_pr_spo_seq_num_s sequence.
173: --
174: OPEN cur_sequence_number;
175: FETCH cur_sequence_number INTO p_outcome_sequence_number;
176: IF (cur_sequence_number%NOTFOUND) THEN

Line 178: SELECT igs_pr_spo_seq_num_s.NEXTVAL

174: OPEN cur_sequence_number;
175: FETCH cur_sequence_number INTO p_outcome_sequence_number;
176: IF (cur_sequence_number%NOTFOUND) THEN
177: CLOSE cur_sequence_number;
178: SELECT igs_pr_spo_seq_num_s.NEXTVAL
179: INTO p_outcome_sequence_number
180: FROM dual
181: WHERE ROWNUM = 1;
182: ELSE