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.

[Home] [Help]

APPS.IGS_FI_VAL_FT dependencies on IGS_FI_UNIT_FEE_TRG

Line 274: p_fee_type IGS_FI_UNIT_FEE_TRG.fee_type%TYPE)

270: RETURN FALSE;
271: END;
272: END finpl_get_course_trig;
273: FUNCTION finpl_get_unit_trig(
274: p_fee_type IGS_FI_UNIT_FEE_TRG.fee_type%TYPE)
275: RETURN BOOLEAN AS
276: ------------------------------------------------------------------
277: --Change History:
278: --Who When What

Line 281: -- so that the records in table IGS_FI_UNIT_FEE_TRG which are logically deleted

277: --Change History:
278: --Who When What
279: --rmaddipa 2-SEP-04 Bug #: 3864296
280: -- Modified the definition of cursor c_unit_fee_trig
281: -- so that the records in table IGS_FI_UNIT_FEE_TRG which are logically deleted
282: -- are not considered.
283: -------------------------------------------------------------------
284: BEGIN
285: DECLARE

Line 290: cp_fee_type IGS_FI_UNIT_FEE_TRG.fee_type%TYPE) IS

286: v_dummy VARCHAR2(1);
287: -- cursor definition modified by rmaddipa ( Bug #: 3864296)
288: -- records that are deleted should'nt be considered
289: CURSOR c_unit_fee_trig (
290: cp_fee_type IGS_FI_UNIT_FEE_TRG.fee_type%TYPE) IS
291: SELECT 'x'
292: FROM IGS_FI_UNIT_FEE_TRG uft
293: WHERE uft.fee_type = cp_fee_type
294: AND logical_delete_dt IS NULL;

Line 292: FROM IGS_FI_UNIT_FEE_TRG uft

288: -- records that are deleted should'nt be considered
289: CURSOR c_unit_fee_trig (
290: cp_fee_type IGS_FI_UNIT_FEE_TRG.fee_type%TYPE) IS
291: SELECT 'x'
292: FROM IGS_FI_UNIT_FEE_TRG uft
293: WHERE uft.fee_type = cp_fee_type
294: AND logical_delete_dt IS NULL;
295: BEGIN
296: -- Check if there are any IGS_PS_UNIT Triggers in the IGS_FI_UNIT_FEE_TRG table.

Line 296: -- Check if there are any IGS_PS_UNIT Triggers in the IGS_FI_UNIT_FEE_TRG table.

292: FROM IGS_FI_UNIT_FEE_TRG uft
293: WHERE uft.fee_type = cp_fee_type
294: AND logical_delete_dt IS NULL;
295: BEGIN
296: -- Check if there are any IGS_PS_UNIT Triggers in the IGS_FI_UNIT_FEE_TRG table.
297: -- If any are found the function should return TRUE otherwise return FALSE.
298: OPEN c_unit_fee_trig(
299: p_fee_type);
300: FETCH c_unit_fee_trig INTO v_dummy;