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_FTE_CALC_PKG dependencies on IGS_EN_UNIT_SET

Line 56: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE,

52: END research_st ;
53:
54:
55: PROCEDURE coo_type (p_person_id IN igs_pe_person.person_id%TYPE ,
56: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE,
57: p_us_version_number IN igs_en_unit_set.version_number%TYPE,
58: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,
59: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,
60: p_coo_type OUT NOCOPY VARCHAR2 ,

Line 57: p_us_version_number IN igs_en_unit_set.version_number%TYPE,

53:
54:
55: PROCEDURE coo_type (p_person_id IN igs_pe_person.person_id%TYPE ,
56: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE,
57: p_us_version_number IN igs_en_unit_set.version_number%TYPE,
58: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,
59: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,
60: p_coo_type OUT NOCOPY VARCHAR2 ,
61: p_hesa_mode OUT NOCOPY VARCHAR2 ,

Line 197: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE ,

193:
194:
195: PROCEDURE fte_type_intensity ( p_person_id IN igs_pe_person.person_id%TYPE ,
196: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,
197: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE ,
198: p_us_version_number IN igs_en_unit_set.version_number%TYPE ,
199: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,
200: P_att_prc_st_fte IN VARCHAR2,
201: p_fte_calc_type OUT NOCOPY igs_he_poous_all.fte_calc_type%TYPE ,

Line 198: p_us_version_number IN igs_en_unit_set.version_number%TYPE ,

194:
195: PROCEDURE fte_type_intensity ( p_person_id IN igs_pe_person.person_id%TYPE ,
196: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,
197: p_unit_set_cd IN igs_en_unit_set.unit_set_cd%TYPE ,
198: p_us_version_number IN igs_en_unit_set.version_number%TYPE ,
199: p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE ,
200: P_att_prc_st_fte IN VARCHAR2,
201: p_fte_calc_type OUT NOCOPY igs_he_poous_all.fte_calc_type%TYPE ,
202: p_fte_intensity OUT NOCOPY igs_he_poous_all.fte_intensity%TYPE ,

Line 258: CURSOR c_poous (cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,

254: ORDER BY NVL(susa.rqrmnts_complete_dt, susa.end_dt) DESC;
255: c_year_rec c_year%ROWTYPE;
256:
257: --get fte calc type set up at program offering unit set level
258: CURSOR c_poous (cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
259: cp_us_version_number igs_en_unit_set.version_number%TYPE
260: ) IS
261: SELECT fte_calc_type , fte_intensity
262: FROM igs_he_poous_all

Line 259: cp_us_version_number igs_en_unit_set.version_number%TYPE

255: c_year_rec c_year%ROWTYPE;
256:
257: --get fte calc type set up at program offering unit set level
258: CURSOR c_poous (cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
259: cp_us_version_number igs_en_unit_set.version_number%TYPE
260: ) IS
261: SELECT fte_calc_type , fte_intensity
262: FROM igs_he_poous_all
263: WHERE unit_set_cd = cp_unit_set_cd AND

Line 274: CURSOR c_susa (cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,

270: attendance_mode = l_attendance_mode ;
271: c_poous_rec c_poous%ROWTYPE ;
272:
273: -- get fte calculation type set up at student unit set attempt level
274: CURSOR c_susa (cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
275: cp_sequence_number igs_as_su_setatmpt.sequence_number%TYPE
276: )IS
277: SELECT fte_calc_type , fte_intensity
278: FROM igs_he_en_susa

Line 860: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,

856: -- get the HESA unit set attempt corresponding to the current year of program
857: -- in which to save the calculated fte
858: CURSOR c_susa_upd (cp_person_id igs_pe_person.person_id%TYPE ,
859: cp_course_cd igs_ps_ver.course_cd%TYPE ,
860: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
861: cp_sequence_number igs_as_su_setatmpt.sequence_number%TYPE ) IS
862: SELECT rowid , susa.*
863: FROM igs_he_en_susa susa
864: WHERE person_id = cp_person_id AND

Line 915: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,

911: c_prog_app_rec c_prog_app%ROWTYPE ;
912:
913: -- get the apportionment period set up at the POOUS level
914: CURSOR c_poous_app(cp_coo_id igs_ps_ofr_opt_all.coo_id%TYPE ,
915: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
916: cp_us_version_number igs_en_unit_set.version_number%TYPE ) IS
917: SELECT teach_period_start_dt , teach_period_end_dt
918: FROM igs_he_poous_all poous, igs_ps_ofr_opt_all coo
919: WHERE poous.course_cd = coo.course_cd AND

Line 916: cp_us_version_number igs_en_unit_set.version_number%TYPE ) IS

912:
913: -- get the apportionment period set up at the POOUS level
914: CURSOR c_poous_app(cp_coo_id igs_ps_ofr_opt_all.coo_id%TYPE ,
915: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE ,
916: cp_us_version_number igs_en_unit_set.version_number%TYPE ) IS
917: SELECT teach_period_start_dt , teach_period_end_dt
918: FROM igs_he_poous_all poous, igs_ps_ofr_opt_all coo
919: WHERE poous.course_cd = coo.course_cd AND
920: poous.crv_version_number = coo.version_number AND