[Home] [Help]
306: RETURN FALSE;
307: END;
308: END finpl_get_unit_trig;
309: FUNCTION finpl_get_unit_set_trig(
310: p_fee_type IGS_EN_UNITSETFEETRG.fee_type%TYPE)
311: RETURN BOOLEAN AS
312: ------------------------------------------------------------------
313: --Change History:
314: --Who When What
313: --Change History:
314: --Who When What
315: --rmaddipa 2-SEP-04 Bug #: 3864296
316: -- Modified the definition of cursor c_unit_set_fee_trig
317: -- so that the records in table IGS_EN_UNITSETFEETRG which are logically deleted
318: -- are not considered.
319: -------------------------------------------------------------------
320: BEGIN
321: DECLARE
322: v_dummy VARCHAR2(1);
323: -- cursor definition modified by rmaddipa ( Bug #: 3864296)
324: -- records that are deleted should'nt be considered
325: CURSOR c_unit_set_fee_trig(
326: cp_fee_type IGS_EN_UNITSETFEETRG.fee_type%TYPE) IS
327: SELECT 'x'
328: FROM IGS_EN_UNITSETFEETRG usft
329: WHERE usft.fee_type = cp_fee_type
330: AND logical_delete_dt IS NULL;
324: -- records that are deleted should'nt be considered
325: CURSOR c_unit_set_fee_trig(
326: cp_fee_type IGS_EN_UNITSETFEETRG.fee_type%TYPE) IS
327: SELECT 'x'
328: FROM IGS_EN_UNITSETFEETRG usft
329: WHERE usft.fee_type = cp_fee_type
330: AND logical_delete_dt IS NULL;
331: BEGIN
332: -- Check if there are any IGS_PS_UNIT Set Triggers in the IGS_EN_UNITSETFEETRG table.
328: FROM IGS_EN_UNITSETFEETRG usft
329: WHERE usft.fee_type = cp_fee_type
330: AND logical_delete_dt IS NULL;
331: BEGIN
332: -- Check if there are any IGS_PS_UNIT Set Triggers in the IGS_EN_UNITSETFEETRG table.
333: -- If any are found the function should return TRUE otherwise return FALSE.
334: OPEN c_unit_set_fee_trig(
335: p_fee_type);
336: FETCH c_unit_set_fee_trig INTO v_dummy;