oracle.apps.fnd.appltest.diagfwk.engine.provider.plsql
Class PLSQLProvider

java.lang.Object
  oracle.apps.fnd.appltest.diagfwk.common.DiagBaseFactory
      oracle.apps.fnd.appltest.diagfwk.engine.provider.plsql.PLSQLProvider

All Implemented Interfaces:

DiagConstants

Direct Known Subclasses:

OraclePLSQLProvider

public abstract class PLSQLProvider
extends DiagBaseFactory

Since:

release specific (what release of product did this appear in)

Version:

$Header: atgpf/appltest/applications/Diagnostics/Engine/src/oracle/apps/fnd/appltest/diagfwk/engine/provider/plsql/PLSQLProvider.java /main/1 2009/04/07 09:52:51 viramac Exp $

Author:

rvij

Nested Class Summary

Nested classes/interfaces inherited from interface oracle.apps.fnd.appltest.diagfwk.common.DiagConstants

DiagConstants.ExecutionMode, DiagConstants.Format, DiagConstants.LinkType, DiagConstants.Status

Field Summary

Fields inherited from interface oracle.apps.fnd.appltest.diagfwk.common.DiagConstants

APPS_MSG_ID_TAG_NAME, CFG_ADR_PROVIDER_CLASS, CFG_CACHE_PROVIDER_CLASS, CFG_CRED_PROVIDER_CLASS, CFG_DAO_FACTORY_CLASS, CFG_DB_CONN_INFO_PROVIDER_CLASS, CFG_DB_CONN_PROVIDER_CLASS, CFG_NLS_PROVIDER_CLASS, CFG_PLSQL_PROVIDER_CLASS, CFG_PROFILE_PROVIDER_CLASS, CFG_SECURITY_PROVIDER_CLASS, CFG_SESSION_INFO_PROVIDER_CLASS, CFG_URL_PROVIDER_FACTORY_CLASS, CFG_WLS_MBEANSRV_CONNINFO_PROVIDER_CLASS, DATA_SECURITY_PERMISSION_ALLOWED, DATA_SECURITY_PERMISSION_NOT_ALLOWED, DELIM_URL, EXEC_MODE_CLI, EXEC_MODE_ESS, EXEC_MODE_INCIDENT, EXEC_MODE_JAVA, EXEC_MODE_UI, EXECUTABLE_TYPE_JAVA, EXECUTABLE_TYPE_PLSQL, EXECUTABLE_TYPE_TESTREF, FORMAT_HTML, FORMAT_XML, GUID_ORACLE_MINUS1, GUID_ORACLE_ZERO, INPUTS_STATUS_ALL_OPT_INPUTS, INPUTS_STATUS_NO_INPUTS, INPUTS_STATUS_REQ_INPUTS_NO_DEFAULTS, INPUTS_STATUS_REQ_INPUTS_W_DEFAULTS, IO_FLAG_I, IO_FLAG_O, JMX_API_BASE_OBJECT_NAME, LINK_EXTERNAL, LINK_INTERNAL, LINK_METALINK, N, NLS_BUNDLE_JAVA_RES, NLS_BUNDLE_MSG_SVC, NLS_BUNDLE_RES_REF, NLS_BUNDLE_XLIFF, NO, NULL, ODF_MBEAN_DOMAIN_NAME, PARAM_MON_INTERVAL, PLSQL_DEBUG_ENABLED_SYSTEM_PROP, PREREQ_TYPE_TAG_VALUE, PREREQ_TYPE_TEST, SECONDS_IN_ONE_DAY, SECONDS_IN_ONE_HOUR, STATUS_CANCELED, STATUS_EXECERROR, STATUS_FAILURE, STATUS_RUNNING, STATUS_SUCCESS, STATUS_WARNING, SYS_PROP_MAX_MONITOR_INTERNVAL, SYS_PROP_MAX_NUM_THREADS, SYSPROP_APPCONNFILE, SYSPROP_DIAG_CONFIG_FILE, TAG_TYPE_DIAG, TAG_TYPE_TAXONOMY, TEST_TYPE_DECL, TEST_TYPE_JAVA, USER_NAME, WEB_APP_NAME_TAG_NAME, Y, YES

Constructor Summary

PLSQLProvider()

Method Summary

static BaseDAO.DBSessionInfo	getDBSessionInfo(java.sql.Connection conn) Client facing API to get the database session information for the given Connection.
abstract java.lang.String	getProcedureLabel(PLSQLProcedureType proc) Method to retrieve the procedure label.
abstract java.lang.String	getProcedureName(PLSQLProcedureType proc) Method to formulate name of a plsql procedure.
static java.lang.String	getProcLabel(PLSQLProcedureType proc) Client facing API to get the procedure label.
static java.lang.String	getProcName(PLSQLProcedureType proc) Client facing API to formulate name of a plsql procedure.
abstract BaseDAO.DBSessionInfo	getSessionInfo(java.sql.Connection conn) Retrieves the database session information for the given Connection.
abstract java.util.Map<java.lang.String,java.lang.Boolean>	validatePLSQLProcedure(java.util.List<java.lang.String> fqProcNameList) Validates a list of fully qualified PL/SQL procedure names by verifying that they exist and are valid.
static java.util.Map<java.lang.String,java.lang.Boolean>	validateProcedure(java.util.List<java.lang.String> fqProcNameList) Client facing API that validates a list of fully qualified PL/SQL procedure names by verifying that they exist and are valid.

Methods inherited from class oracle.apps.fnd.appltest.diagfwk.common.DiagBaseFactory

createClassLoader, loadClassFor

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PLSQLProvider

public PLSQLProvider()

Method Detail

getProcedureLabel

public abstract java.lang.String getProcedureLabel(PLSQLProcedureType proc)

Method to retrieve the procedure label.

Parameters:

proc - a PLSQLProcedureType object

Returns:

the label string

getProcLabel

public static java.lang.String getProcLabel(PLSQLProcedureType proc)

Client facing API to get the procedure label.

Parameters:

proc - a PLSQLProcedureType object

Returns:

the label string

getProcedureName

public abstract java.lang.String getProcedureName(PLSQLProcedureType proc)

Method to formulate name of a plsql procedure.

Parameters:

proc - a PLSQLProcedureType object

Returns:

null if it is an anonymous plsql step, otherwise return a formulated name for the procedure

getProcName

public static java.lang.String getProcName(PLSQLProcedureType proc)

Client facing API to formulate name of a plsql procedure.

Parameters:

proc - a PLSQLProcedureType object

Returns:

null if it is an anonymous plsql step, otherwise return a formulated name for the procedure

getSessionInfo

public abstract BaseDAO.DBSessionInfo getSessionInfo(java.sql.Connection conn)

Retrieves the database session information for the given Connection.

Parameters:

conn - a Connection object

Returns:

a BaseDAO.DBSessionInfo object

getDBSessionInfo

public static BaseDAO.DBSessionInfo getDBSessionInfo(java.sql.Connection conn)

Client facing API to get the database session information for the given Connection.

Parameters:

conn - a Connection object

Returns:

a BaseDAO.DBSessionInfo object

validatePLSQLProcedure

public abstract java.util.Map<java.lang.String,java.lang.Boolean> validatePLSQLProcedure(java.util.List<java.lang.String> fqProcNameList)

Validates a list of fully qualified PL/SQL procedure names by verifying that they exist and are valid. A fully qualified procedure name is formed using the following elements: [schemaName].[packageName].[procedureName]. SchemaName is optional. This method also verifies that that the PL/SQL procedure has no formal parameters.

Parameters:

fqProcNameList - a list of fully qualified procedure names

Returns:

a String/Boolean map corresponding to the list of fully qualified procedure names that indicates whether the procedure exists or not

validateProcedure

public static java.util.Map<java.lang.String,java.lang.Boolean> validateProcedure(java.util.List<java.lang.String> fqProcNameList)

Client facing API that validates a list of fully qualified PL/SQL procedure names by verifying that they exist and are valid.

Parameters:

fqProcNameList - a list of fully qualified procedure names

Returns:

a String/Boolean map corresponding to the list of fully qualified procedure names that indicates whether the procedure exists or not

See Also:

PLSQLProvider#validatePLSQLProcedure(List fqProcNameList)