APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 77: l_hesa_mode igs_he_code_map_val.map1%TYPE ;

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 ;
81: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;

Line 110: FROM IGS_HE_CODE_MAP_VAL

106:
107: -- get the HESA attendance type associated to the program offering option attendance mode
108: CURSOR c_coo IS
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

Line 120: FROM IGS_HE_CODE_MAP_VAL

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' ;
123:
124: -- get the course details for the program offering option passed

Line 225: l_hesa_att_type igs_he_code_map_val.map1%TYPE := NULL;

221: smaddali 05-Jul-2002 modified cursor c_year for bug 2448315
222: (reverse chronological order - newest change first)
223: ***************************************************************/
224:
225: l_hesa_att_type igs_he_code_map_val.map1%TYPE := NULL;
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;

Line 236: l_hesa_mode igs_he_code_map_val.map1%TYPE := NULL;

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
240: -- jtmathew modified this cursor for end_dt selection for HE357 changes

Line 288: FROM IGS_HE_CODE_MAP_VAL

284:
285: -- get the HESA attendance type associated to the program offering option attendance type
286: CURSOR c_coo IS
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

Line 615: l_hesa_mode igs_he_code_map_val.map1%TYPE ;

611: l_actual_start_dt DATE := NULL ;
612: l_actual_end_dt DATE := NULL ;
613: l_selection_dt_to DATE := NULL;
614: l_selection_dt_from DATE := NULL;
615: l_hesa_mode igs_he_code_map_val.map1%TYPE ;
616: l_coo_type VARCHAR2(2) := NULL;
617: l_app_days NUMBER := NULL ;
618: l_actual_days NUMBER := NULL;
619: l_rowid VARCHAR2(40) := NULL;