1: package body CEP_STANDARD AS
2: /* $Header: ceseutlb.pls 120.29 2011/07/19 09:29:15 bkkashya ship $ */
3: /*-------------------------------------------------------------------------+
4: | |
5: | PRIVATE VARIABLES |
474: DBMS_SQL.Parse(l_cursor_id,
475: l_final_query,
476: DBMS_SQL.v7);
477:
478: cep_standard.debug('Parsed sucessfully');
479:
480: l_exec_id := DBMS_SQL.execute(l_cursor_id);
481: l_row := DBMS_SQL.FETCH_ROWS(l_cursor_id);
482: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
484: RETURN l_row;
485:
486: EXCEPTION
487: WHEN OTHERS THEN
488: cep_standard.debug('EXCEPTION - OTHERS: check_bat_security');
489: IF DBMS_SQL.IS_OPEN(l_cursor_id) THEN
490: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
491: cep_standard.debug('Cursor Closed');
492: END IF;
487: WHEN OTHERS THEN
488: cep_standard.debug('EXCEPTION - OTHERS: check_bat_security');
489: IF DBMS_SQL.IS_OPEN(l_cursor_id) THEN
490: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
491: cep_standard.debug('Cursor Closed');
492: END IF;
493: RAISE;
494: END check_ba_security;
495:
615: /* begin code added for the bug 7125240 */
616: Begin
617: g_debug := FND_PROFILE.value('CE_DEBUG') ;
618:
619: end CEP_STANDARD;