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_PS_OFR_OPT_ALL

Line 59: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,

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 ,
62: p_message OUT NOCOPY VARCHAR2 ) AS
63: /*************************************************************

Line 80: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;

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 ;
81: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
82: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
83: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
84:

Line 81: l_location_cd igs_ps_ofr_opt_all.location_cd%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 ;
81: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
82: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
83: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
84:
85: -- get the mode of study at program offering unit set level

Line 82: l_attendance_type igs_ps_ofr_opt_all.attendance_type%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 ;
81: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
82: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
83: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
84:
85: -- get the mode of study at program offering unit set level
86: CURSOR c_poous IS

Line 83: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;

79: l_version_number igs_ps_ver_all.version_number%TYPE ;
80: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
81: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
82: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
83: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
84:
85: -- get the mode of study at program offering unit set level
86: CURSOR c_poous IS
87: SELECT mode_of_study

Line 113: FROM igs_ps_ofr_opt_all

109: SELECT map1
110: FROM IGS_HE_CODE_MAP_VAL
111: WHERE association_code = 'OSS_HESA_ATTEND_MODE_ASSOC' AND
112: map2 = (SELECT attendance_type
113: FROM igs_ps_ofr_opt_all
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

Line 127: FROM igs_ps_ofr_opt_all

123:
124: -- get the course details for the program offering option passed
125: CURSOR c_crs_dets IS
126: SELECT course_cd , version_number, cal_type, location_cd ,attendance_type ,attendance_mode
127: FROM igs_ps_ofr_opt_all
128: WHERE coo_id = p_coo_id
129: AND delete_flag = 'N';
130:
131:

Line 196: p_coo_id IN igs_ps_ofr_opt_all.coo_id%TYPE ,

192: END coo_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,

Line 230: l_course_cd igs_ps_ofr_opt_all.course_cd%TYPE ;

226: l_coo_type VARCHAR2(2) := NULL ;
227: l_pt VARCHAR2(1) := NULL;
228: l_ft VARCHAR2(1) := NULL;
229: l_message fnd_new_messages.message_name%TYPE := NULL;
230: l_course_cd igs_ps_ofr_opt_all.course_cd%TYPE ;
231: l_version_number igs_ps_ofr_opt_all.version_number%TYPE ;
232: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
233: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
234: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;

Line 231: l_version_number igs_ps_ofr_opt_all.version_number%TYPE ;

227: l_pt VARCHAR2(1) := NULL;
228: l_ft VARCHAR2(1) := NULL;
229: l_message fnd_new_messages.message_name%TYPE := NULL;
230: l_course_cd igs_ps_ofr_opt_all.course_cd%TYPE ;
231: l_version_number igs_ps_ofr_opt_all.version_number%TYPE ;
232: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
233: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
234: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
235: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;

Line 232: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;

228: l_ft VARCHAR2(1) := NULL;
229: l_message fnd_new_messages.message_name%TYPE := NULL;
230: l_course_cd igs_ps_ofr_opt_all.course_cd%TYPE ;
231: l_version_number igs_ps_ofr_opt_all.version_number%TYPE ;
232: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
233: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
234: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
235: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
236: l_hesa_mode igs_he_code_map_val.map1%TYPE := NULL;

Line 233: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;

229: l_message fnd_new_messages.message_name%TYPE := NULL;
230: l_course_cd igs_ps_ofr_opt_all.course_cd%TYPE ;
231: l_version_number igs_ps_ofr_opt_all.version_number%TYPE ;
232: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
233: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
234: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
235: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
236: l_hesa_mode igs_he_code_map_val.map1%TYPE := NULL;
237:

Line 234: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;

230: l_course_cd igs_ps_ofr_opt_all.course_cd%TYPE ;
231: l_version_number igs_ps_ofr_opt_all.version_number%TYPE ;
232: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
233: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
234: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
235: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
236: l_hesa_mode igs_he_code_map_val.map1%TYPE := NULL;
237:
238: -- Get the current year of program which either started, completed or ended in the FTE period

Line 235: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;

231: l_version_number igs_ps_ofr_opt_all.version_number%TYPE ;
232: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
233: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
234: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
235: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;
236: l_hesa_mode igs_he_code_map_val.map1%TYPE := NULL;
237:
238: -- Get the current year of program which either started, completed or ended in the FTE period
239: -- jtmathew modified this cursor to use optional cp_selection_dt parameters for HE370 changes

Line 291: FROM igs_ps_ofr_opt_all

287: SELECT map1
288: FROM IGS_HE_CODE_MAP_VAL
289: WHERE association_code = 'OSS_HESA_ATTEND_MODE_ASSOC' AND
290: map2 = (SELECT attendance_type
291: FROM igs_ps_ofr_opt_all
292: WHERE coo_id = p_coo_id
293: AND delete_flag = 'N');
294:
295: -- get the course details for the program offering option passed

Line 298: FROM igs_ps_ofr_opt_all

294:
295: -- get the course details for the program offering option passed
296: CURSOR c_crs_dets IS
297: SELECT course_cd , version_number, cal_type, location_cd ,attendance_type ,attendance_mode
298: FROM igs_ps_ofr_opt_all
299: WHERE coo_id = p_coo_id
300: AND delete_flag = 'N';
301:
302: -- get the attendance percentage for the research student which will be his fte intensity

Line 321: FROM igs_ps_ofr_opt_all

317:
318: -- get all the program offering optiond for the current program
319: CURSOR c_crs_off IS
320: SELECT coo_id
321: FROM igs_ps_ofr_opt_all
322: WHERE course_cd = l_course_cd AND
323: version_number = l_version_number AND
324: delete_flag = 'N';
325:

Line 914: CURSOR c_poous_app(cp_coo_id igs_ps_ofr_opt_all.coo_id%TYPE ,

910: prog.version_number = cp_version_number ;
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

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