PACKAGE BODY: APPS.IGI_IAC_BALANCE_REPORT_PKG

Source

1 PACKAGE BODY igi_iac_balance_report_pkg AS
2 -- $Header: igiiabrb.pls 120.6 2007/08/01 10:46:17 npandya ship $
3 --
4 --===========================FND_LOG.START=====================================
5 
6 g_state_level NUMBER	     :=	FND_LOG.LEVEL_STATEMENT;
7 g_proc_level  NUMBER	     :=	FND_LOG.LEVEL_PROCEDURE;
8 g_event_level NUMBER	     :=	FND_LOG.LEVEL_EVENT;
9 g_excep_level NUMBER	     :=	FND_LOG.LEVEL_EXCEPTION;
10 g_error_level NUMBER	     :=	FND_LOG.LEVEL_ERROR;
11 g_unexp_level NUMBER	     :=	FND_LOG.LEVEL_UNEXPECTED;
12 g_path        VARCHAR2(100)  := 'IGI.PLSQL.igiiabrb.igi_iac_balance_report_pkg.';
13 
14 --===========================FND_LOG.END=======================================
15 
16 Function IGI_IAC_CHECK_ACCOUNTS ( p_sql VARCHAR2 , p_accval OUT NOCOPY VARCHAR2 )
17 
18 RETURN BOOLEAN AS
19     l_path 			 VARCHAR2(150) := g_path||'IGI_IAC_CHECK_ACCOUNTS';
20 BEGIN
21   EXECUTE IMMEDIATE  p_sql INTO p_accval ;
22   RETURN TRUE ;
23 EXCEPTION
24   WHEN OTHERS THEN
25      igi_iac_debug_pkg.debug_unexpected_msg(l_path);
26      RETURN FALSE ;
27 END IGI_IAC_CHECK_ACCOUNTS;
28 END;