1: PACKAGE BODY FA_IMPAIRMENT_DELETE_PVT AS
2: /* $Header: FAVIMPDB.pls 120.11 2011/06/29 12:12:52 gigupta noship $ */
3:
4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
5: g_release number := fa_cache_pkg.fazarel_release;
6:
7: --
8: -- Datatypes for pl/sql tables below
1: PACKAGE BODY FA_IMPAIRMENT_DELETE_PVT AS
2: /* $Header: FAVIMPDB.pls 120.11 2011/06/29 12:12:52 gigupta noship $ */
3:
4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
5: g_release number := fa_cache_pkg.fazarel_release;
6:
7: --
8: -- Datatypes for pl/sql tables below
9: --
365: fa_debug_pkg.add(l_calling_fn, 'p_thid count ', p_thid.count ,p_log_level_rec => p_log_level_rec);
366: end if;
367:
368: l_event_date :=
369: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
370: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
371: sysdate),
372: sysdate));
373:
366: end if;
367:
368: l_event_date :=
369: greatest(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
370: least(nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date,
371: sysdate),
372: sysdate));
373:
374: if (p_log_level_rec.statement_level) then