APPS.GMA_PURGE_VALIDATE dependencies on USER_TABLESPACES

Line 104: p_tablespace_name IN user_tablespaces.tablespace_name%TYPE)

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.
108: -- Return TRUE if the tablespace exists, FALSE otherwise.

Line 106: -- This function takes a name and checks the user_tablespaces

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.
108: -- Return TRUE if the tablespace exists, FALSE otherwise.
109:
110: CURSOR l_validate_tablespace_cur

Line 111: (c_tablespace_name IN user_tablespaces.tablespace_name%TYPE) IS

107: -- view to make sure the parameter is a valid tablespace name.
108: -- Return TRUE if the tablespace exists, FALSE otherwise.
109:
110: CURSOR l_validate_tablespace_cur
111: (c_tablespace_name IN user_tablespaces.tablespace_name%TYPE) IS
112: select 'X'
113: from user_tablespaces
114: where tablespace_name = upper(c_tablespace_name);
115:

Line 113: from user_tablespaces

109:
110: CURSOR l_validate_tablespace_cur
111: (c_tablespace_name IN user_tablespaces.tablespace_name%TYPE) IS
112: select 'X'
113: from user_tablespaces
114: where tablespace_name = upper(c_tablespace_name);
115:
116: l_tablespace_exists CHAR(1);
117: