DBA Data[Home] [Help]

PACKAGE: APPS.GMA_PURGE_VALIDATE

Source


1 PACKAGE GMA_PURGE_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: GMAPRGVS.pls 115.3 2002/05/15 17:05:54 pkm ship     $ */
3 
4   PROCEDURE checksql(p_purge_id   sy_purg_mst.purge_id%TYPE,
5                      p_purge_type sy_purg_def.purge_type%TYPE);
6                 -- make sure sql stored in sy_purg_def is valid
7 
8   FUNCTION is_table(p_purge_id  sy_purg_mst.purge_id%TYPE,
9                     p_tablename user_tables.table_name%TYPE) RETURN BOOLEAN;
10                 -- check for existence of named table
11 
12   FUNCTION is_tablespace
13                    (p_purge_id        sy_purg_mst.purge_id%TYPE,
14                     p_tablespace_name user_tablespaces.tablespace_name%TYPE)
15          RETURN BOOLEAN;
16                 -- validate tablespace name
17 
18 END GMA_PURGE_VALIDATE;