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_FI_FND_SRC_RSTN

Line 38: v_old_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;

34: p_message_name OUT NOCOPY VARCHAR2 ) IS
35:
36:
37: -- Variables to hold old and new values from other tables for record.
38: v_old_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;
39: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
40: v_old_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
41:
42: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;

Line 43: v_new_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;

39: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
40: v_old_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
41:
42: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
43: v_new_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;
44: v_new_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
45:
46: -- Variables to hold final values for first record
47: v_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;

Line 192: -- Cursor to retrieve funding source restriction values for passed program from IGS_FI_FND_SRC_RSTN

188: map2 = award_cd AND
189: association_code = 'OSS_HESA_AWD_ASSOC'
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

Line 197: 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
200: dflt_ind = 'Y';
201:

Line 427: --FETCH Values for old records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN

423: ELSE
424:
425: close c_old_susa;
426:
427: --FETCH Values for old records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN
428: OPEN c_old_poous;
429: FETCH c_old_poous INTO c_old_poous_rec;
430: CLOSE c_old_poous;
431:

Line 444: --FETCH Values for new records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN

440: OPEN c_fnd_src_rstn(p_old_course_cd,v_u_old_version_number);
441: FETCH c_fnd_src_rstn INTO v_old_prg_funding_source;
442: CLOSE c_fnd_src_rstn;
443:
444: --FETCH Values for new records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN
445: OPEN c_new_poous;
446: FETCH c_new_poous INTO c_new_poous_rec;
447: CLOSE c_new_poous;
448: