DBA Data[Home] [Help]

APPS.GMA_PURGE_VALIDATE dependencies on SY_PURG_MST

Line 4: FUNCTION is_table(p_purge_id sy_purg_mst.purge_id%TYPE,

1: PACKAGE BODY GMA_PURGE_VALIDATE AS
2: /* $Header: GMAPRGVB.pls 115.8 2004/02/12 21:30:52 kmoizudd ship $ */
3:
4: FUNCTION is_table(p_purge_id sy_purg_mst.purge_id%TYPE,
5: p_tablename user_tables.table_name%TYPE)
6: RETURN BOOLEAN IS
7: -- check to make sure given name IS a real table
8: -- Added one more cursor parameter owner for UDTF standards by KH 3431801

Line 103: (p_purge_id sy_purg_mst.purge_id%TYPE,

99:
100: /***********************************************************/
101:
102: FUNCTION is_tablespace
103: (p_purge_id sy_purg_mst.purge_id%TYPE,
104: p_tablespace_name IN user_tablespaces.tablespace_name%TYPE)
105: RETURN BOOLEAN IS
106: -- This function takes a name and checks the user_tablespaces
107: -- view to make sure the parameter is a valid tablespace name.

Line 147: PROCEDURE checksql(p_purge_id sy_purg_mst.purge_id%TYPE,

143: END is_tablespace;
144:
145: /***********************************************************/
146:
147: PROCEDURE checksql(p_purge_id sy_purg_mst.purge_id%TYPE,
148: p_purge_type sy_purg_def.purge_type%TYPE) IS
149: -- used for debugging... checks sql syntax
150:
151: CURSOR l_sql_cur(c_purge_type sy_purg_def.purge_type%TYPE) IS