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_HE_PROG_TRANSFER_PKG dependencies on IGS_HE_ST_PROG_ALL

Line 181: CURSOR c_prg_awd( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,

177: c_old_poous_rec c_old_poous%ROWTYPE ;
178:
179: -- Cursor to retrieve default program award for the passed program from IGS_PS_AWARD
180: -- that will be validated.
181: CURSOR c_prg_awd( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
182: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
183: SELECT map1
184: FROM igs_ps_award, igs_he_code_map_val
185: WHERE course_cd = cp_course_cd AND

Line 182: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS

178:
179: -- Cursor to retrieve default program award for the passed program from IGS_PS_AWARD
180: -- that will be validated.
181: CURSOR c_prg_awd( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
182: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
183: SELECT map1
184: FROM igs_ps_award, igs_he_code_map_val
185: WHERE course_cd = cp_course_cd AND
186: version_number = cp_version_number AND

Line 194: CURSOR c_fnd_src_rstn( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,

190: ORDER BY default_ind DESC, map1 ASC ;
191:
192: -- Cursor to retrieve funding source restriction values for passed program from IGS_FI_FND_SRC_RSTN
193: -- that will be validated.
194: CURSOR c_fnd_src_rstn( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
195: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
196: SELECT funding_source
197: FROM igs_fi_fnd_src_rstn
198: WHERE course_cd = cp_course_cd AND

Line 195: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS

191:
192: -- Cursor to retrieve funding source restriction values for passed program from IGS_FI_FND_SRC_RSTN
193: -- that will be validated.
194: CURSOR c_fnd_src_rstn( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
195: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
196: SELECT funding_source
197: FROM igs_fi_fnd_src_rstn
198: WHERE course_cd = cp_course_cd AND
199: version_number = cp_version_number AND

Line 244: CURSOR c_prg_fundability(cp_course_cd igs_he_st_prog_all.course_cd%TYPE,

240:
241: -- smaddali added new cursor for bug 2730371
242: -- Cursor to retrieve fundability_cd for passed program record
243: -- that will be validated against old values.
244: CURSOR c_prg_fundability(cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
245: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
246: SELECT fundability
247: FROM IGS_he_st_prog_all
248: WHERE course_cd = cp_course_cd AND

Line 245: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS

241: -- smaddali added new cursor for bug 2730371
242: -- Cursor to retrieve fundability_cd for passed program record
243: -- that will be validated against old values.
244: CURSOR c_prg_fundability(cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
245: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
246: SELECT fundability
247: FROM IGS_he_st_prog_all
248: WHERE course_cd = cp_course_cd AND
249: version_number = cp_version_number ;

Line 247: FROM IGS_he_st_prog_all

243: -- that will be validated against old values.
244: CURSOR c_prg_fundability(cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
245: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
246: SELECT fundability
247: FROM IGS_he_st_prog_all
248: WHERE course_cd = cp_course_cd AND
249: version_number = cp_version_number ;
250:
251: -- smaddali added this cursor for Bug# 2717755