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_VAL_FT dependencies on IGS_PS_TYPE_FEE_TRG

Line 160: p_fee_type IGS_PS_TYPE_FEE_TRG.fee_type%TYPE)

156: RETURN FALSE;
157: END;
158: END finpl_get_fee_ass;
159: FUNCTION finpl_get_course_type_trig(
160: p_fee_type IGS_PS_TYPE_FEE_TRG.fee_type%TYPE)
161: RETURN BOOLEAN AS
162: ------------------------------------------------------------------
163: --Change History:
164: --Who When What

Line 167: -- so that the records in table IGS_PS_TYPE_FEE_TRG which are logically deleted

163: --Change History:
164: --Who When What
165: --rmaddipa 2-SEP-04 Bug #: 3864296
166: -- Modified the definition of cursor c_crs_typ_fee_trig
167: -- so that the records in table IGS_PS_TYPE_FEE_TRG which are logically deleted
168: -- are not considered.
169: -------------------------------------------------------------------
170: BEGIN
171: DECLARE

Line 177: cp_fee_type IGS_PS_TYPE_FEE_TRG.fee_type%TYPE) IS

173:
174: -- cursor definition modified by rmaddipa ( Bug #: 3864296)
175: -- records that are deleted should'nt be considered
176: CURSOR c_crs_typ_fee_trig (
177: cp_fee_type IGS_PS_TYPE_FEE_TRG.fee_type%TYPE) IS
178: SELECT 'x'
179: FROM IGS_PS_TYPE_FEE_TRG ctft
180: WHERE ctft.fee_type = cp_fee_type
181: AND logical_delete_dt IS NULL;

Line 179: FROM IGS_PS_TYPE_FEE_TRG ctft

175: -- records that are deleted should'nt be considered
176: CURSOR c_crs_typ_fee_trig (
177: cp_fee_type IGS_PS_TYPE_FEE_TRG.fee_type%TYPE) IS
178: SELECT 'x'
179: FROM IGS_PS_TYPE_FEE_TRG ctft
180: WHERE ctft.fee_type = cp_fee_type
181: AND logical_delete_dt IS NULL;
182: BEGIN
183: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_TYPE_FEE_TRG table.

Line 183: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_TYPE_FEE_TRG table.

179: FROM IGS_PS_TYPE_FEE_TRG ctft
180: WHERE ctft.fee_type = cp_fee_type
181: AND logical_delete_dt IS NULL;
182: BEGIN
183: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_TYPE_FEE_TRG table.
184: -- If any are found the function should return TRUE otherwise return FALSE.
185: OPEN c_crs_typ_fee_trig(
186: p_fee_type);
187: FETCH c_crs_typ_fee_trig INTO v_dummy;

Line 234: p_fee_type IGS_PS_TYPE_FEE_TRG.fee_type%TYPE)

230: RETURN FALSE;
231: END;
232: END finpl_get_course_group_trig;
233: FUNCTION finpl_get_course_trig(
234: p_fee_type IGS_PS_TYPE_FEE_TRG.fee_type%TYPE)
235: RETURN BOOLEAN AS
236: ------------------------------------------------------------------
237: --Change History:
238: --Who When What

Line 260: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_TYPE_FEE_TRG,

256: WHERE cft.fee_type = cp_fee_type
257: AND logical_delete_dt IS NULL;
258:
259: BEGIN
260: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_TYPE_FEE_TRG,
261: -- IGS_PS_GRP_FEE_TRG OR IGS_PS_FEE_TRG tables. If any are found
262: -- the function should return TRUE otherwise return FALSE.
263: OPEN c_crs_fee_trig (p_fee_type);
264: FETCH c_crs_fee_trig INTO v_dummy;