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_POOUS_ALL

Line 40: v_old_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;

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;
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;

Line 44: v_new_prg_fundability_cd igs_he_poous_all.fundability_cd%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;
48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;

Line 153: -- Cursor to retrieve old record values for record 1 from IGS_HE_POOUS_ALL

149: sequence_number = v_u_old_sequence_number;
150: c_old_susa_rec c_old_susa%ROWTYPE ;
151:
152:
153: -- Cursor to retrieve old record values for record 1 from IGS_HE_POOUS_ALL
154: -- that will be validated.
155: -- smaddali selecting fundability_cd ,for bug 2730371
156: -- smaddali added field funding_source as part of hefd208 bug#2717751
157: CURSOR c_old_poous IS

Line 168: FROM igs_he_poous_all

164: fee_band,
165: type_of_year,
166: fundability_cd,
167: funding_source
168: FROM igs_he_poous_all
169: WHERE course_cd = p_old_course_cd AND
170: unit_set_cd = p_old_unit_set_cd AND
171: us_version_number = p_old_us_version_number AND
172: crv_version_number = v_u_old_version_number AND

Line 202: -- Cursor to retrieve values for new record from IGS_HE_POOUS_ALL

198: WHERE course_cd = cp_course_cd AND
199: version_number = cp_version_number AND
200: dflt_ind = 'Y';
201:
202: -- Cursor to retrieve values for new record from IGS_HE_POOUS_ALL
203: -- that will be validated against old values.
204: -- smaddali selecting fundability_cd ,for bug 2730371
205: -- smaddali added field funding_source as part of hefd208 bug#2717751
206: CURSOR c_new_poous IS

Line 216: FROM igs_he_poous_all

212: gs_version_number,
213: fee_band,type_of_year,
214: fundability_cd,
215: funding_source
216: FROM igs_he_poous_all
217: WHERE course_cd = p_new_course_cd AND
218: crv_version_number = v_u_new_version_number AND
219: cal_type = v_u_new_cal_type AND
220: location_cd = v_u_new_location_cd AND

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: