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_FI_GEN_003 dependencies on IGS_FI_FEE_AS_RT

Line 181: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,

177: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
178: END finp_del_minor_debt;
179: --
180: FUNCTION finp_ins_cfar(
181: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
182: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,

Line 182: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,

178: END finp_del_minor_debt;
179: --
180: FUNCTION finp_ins_cfar(
181: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
182: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,

Line 183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,

179: --
180: FUNCTION finp_ins_cfar(
181: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
182: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,

Line 184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,

180: FUNCTION finp_ins_cfar(
181: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
182: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,

Line 185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,

181: p_person_id IGS_FI_FEE_AS_RT.person_id%TYPE ,
182: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
189: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,

Line 186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,

182: p_course_cd IGS_FI_FEE_AS_RT.course_cd%TYPE ,
183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
189: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
190: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,

Line 187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,

183: p_fee_type IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
189: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
190: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
191: p_message_name OUT NOCOPY VARCHAR2 )

Line 188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,

184: p_start_dt IGS_FI_FEE_AS_RT.start_dt%TYPE ,
185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
189: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
190: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
191: p_message_name OUT NOCOPY VARCHAR2 )
192: RETURN BOOLEAN AS

Line 189: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,

185: p_end_dt IGS_FI_FEE_AS_RT.end_dt%TYPE ,
186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
189: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
190: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
191: p_message_name OUT NOCOPY VARCHAR2 )
192: RETURN BOOLEAN AS
193: gv_other_detail VARCHAR2(255);

Line 190: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,

186: p_location_cd IGS_FI_FEE_AS_RT.location_cd%TYPE ,
187: p_attendance_type IGS_FI_FEE_AS_RT.ATTENDANCE_TYPE%TYPE ,
188: p_attendance_mode IGS_FI_FEE_AS_RT.ATTENDANCE_MODE%TYPE ,
189: p_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
190: p_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
191: p_message_name OUT NOCOPY VARCHAR2 )
192: RETURN BOOLEAN AS
193: gv_other_detail VARCHAR2(255);
194: BEGIN -- finp_ins_cfar

Line 228: --Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that for

224: p_location_cd,
225: p_message_name) THEN
226: RETURN FALSE;
227: END IF;
228: --Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that for
229: --records with the same person_id, course_cd and IGS_FI_FEE_TYPE, that only
230: --one record has a open end_dt.
231: IF p_end_dt IS NULL THEN
232: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_open (

Line 241: --Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that for

237: p_message_name) THEN
238: RETURN FALSE;
239: END IF;
240: END IF;
241: --Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that for
242: --records with the same person_id, course_cd and IGS_FI_FEE_TYPE, that the
243: --date ranges don't overlap.
244: IF NOT IGS_FI_VAL_CFAR.finp_val_cfar_ovrlp (
245: p_person_id,

Line 254: IGS_FI_FEE_AS_RT_PKG.INSERT_ROW(

250: p_message_name) THEN
251: RETURN FALSE;
252: END IF;
253: --Insert the contract fee assessment rate
254: IGS_FI_FEE_AS_RT_PKG.INSERT_ROW(
255: X_ROWID => X_ROWID,
256: X_person_id => p_person_id,
257: X_course_cd => p_course_cd,
258: X_FEE_TYPE => p_fee_type,