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_HE_POOUS_ALL

Line 76: l_oss_mode igs_he_poous_all.mode_of_study%TYPE ;

72: (reverse chronological order - newest change first)
73: ***************************************************************/
74:
75: l_coo_type VARCHAR2(2) ;
76: l_oss_mode igs_he_poous_all.mode_of_study%TYPE ;
77: l_hesa_mode igs_he_code_map_val.map1%TYPE ;
78: l_course_cd igs_ps_ver_all.course_cd%TYPE ;
79: l_version_number igs_ps_ver_all.version_number%TYPE ;
80: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;

Line 88: FROM igs_he_poous_all

84:
85: -- get the mode of study at program offering unit set level
86: CURSOR c_poous IS
87: SELECT mode_of_study
88: FROM igs_he_poous_all
89: WHERE unit_set_cd = p_unit_set_cd AND
90: us_version_number = p_us_version_number AND
91: course_cd = l_course_cd AND
92: crv_version_number = l_version_number AND

Line 118: CURSOR c_hesa_mode(cp_oss_mode_of_study igs_he_poous_all.mode_of_study%TYPE) IS

114: WHERE coo_id = p_coo_id
115: AND delete_flag = 'N');
116:
117: -- get the HESA mode of study associated with OSS mode of study
118: CURSOR c_hesa_mode(cp_oss_mode_of_study igs_he_poous_all.mode_of_study%TYPE) IS
119: SELECT map1
120: FROM IGS_HE_CODE_MAP_VAL
121: WHERE map2 = cp_oss_mode_of_study AND
122: association_code = 'OSS_HESA_MODE_ASSOC' ;

Line 201: p_fte_calc_type OUT NOCOPY igs_he_poous_all.fte_calc_type%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 ,
203: p_selection_dt_from IN VARCHAR2,
204: p_selection_dt_to IN VARCHAR2,
205: p_message OUT NOCOPY VARCHAR2 ) AS

Line 202: p_fte_intensity OUT NOCOPY igs_he_poous_all.fte_intensity%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 ,
203: p_selection_dt_from IN VARCHAR2,
204: p_selection_dt_to IN VARCHAR2,
205: p_message OUT NOCOPY VARCHAR2 ) AS
206:

Line 262: FROM igs_he_poous_all

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
264: us_version_number = cp_us_version_number AND
265: course_cd = l_course_cd AND
266: crv_version_number = l_version_number AND

Line 593: l_fte_calc_type igs_he_poous_all.fte_calc_type%TYPE ;

589: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
590: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
591: i NUMBER := 1;
592:
593: l_fte_calc_type igs_he_poous_all.fte_calc_type%TYPE ;
594: l_fte_intensity igs_he_en_susa.fte_intensity%TYPE ;
595: l_calculated_intensity igs_he_en_susa.fte_intensity%TYPE ;
596: l_total_credit_points NUMBER := NULL ;
597: l_unit_cp NUMBER := NULL ;

Line 599: l_dummy1 igs_he_poous_all.fte_calc_type%TYPE;

595: l_calculated_intensity igs_he_en_susa.fte_intensity%TYPE ;
596: l_total_credit_points NUMBER := NULL ;
597: l_unit_cp NUMBER := NULL ;
598: l_message fnd_new_messages.message_name%TYPE := NULL;
599: l_dummy1 igs_he_poous_all.fte_calc_type%TYPE;
600: l_dummy2 igs_he_poous_all.fte_intensity%TYPE;
601: l_calculated_FTE igs_he_en_susa.calculated_fte%TYPE := NULL;
602: l_trn_from_crs igs_ps_ver.course_cd%TYPE := NULL;
603: l_unit_ver_cp igs_ps_unit_ver.enrolled_credit_points%TYPE := NULL;

Line 600: l_dummy2 igs_he_poous_all.fte_intensity%TYPE;

596: l_total_credit_points NUMBER := NULL ;
597: l_unit_cp NUMBER := NULL ;
598: l_message fnd_new_messages.message_name%TYPE := NULL;
599: l_dummy1 igs_he_poous_all.fte_calc_type%TYPE;
600: l_dummy2 igs_he_poous_all.fte_intensity%TYPE;
601: l_calculated_FTE igs_he_en_susa.calculated_fte%TYPE := NULL;
602: l_trn_from_crs igs_ps_ver.course_cd%TYPE := NULL;
603: l_unit_ver_cp igs_ps_unit_ver.enrolled_credit_points%TYPE := NULL;
604: l_std_annual_load igs_ps_ver.std_annual_load%TYPE := NULL;

Line 918: FROM igs_he_poous_all poous, igs_ps_ofr_opt_all coo

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
921: poous.cal_type = coo.cal_type AND
922: poous.location_cd = coo.location_cd AND