PACKAGE BODY: APPS.FEM_INTG_VIEW_PKG

Source

1 PACKAGE BODY FEM_INTG_VIEW_PKG AS
2 /* $Header: fem_intg_view.plb 120.0 2005/06/06 21:48:50 appldev noship $ */
3 
4 
5 --
6 -- PUBLIC PROCEDURES
7 --
8 
9   PROCEDURE Recreate_View(
10 	p_view_name	VARCHAR2,
11 	p_sql		VARCHAR2) IS
12   BEGIN
13     EXECUTE IMMEDIATE 'CREATE OR REPLACE VIEW ' || p_view_name || ' AS ' || p_sql;
14     commit;
15   END Recreate_View;
16 
17 END FEM_INTG_VIEW_PKG;