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

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

All Implemented Interfaces:

DiagConstants

public class OraclePLSQLProvider
extends PLSQLProvider

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/OraclePLSQLProvider.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

OraclePLSQLProvider()

Method Summary

java.lang.String	getProcedureLabel(PLSQLProcedureType proc) Method to retrieve the procedure label.
java.lang.String	getProcedureName(PLSQLProcedureType proc) Util method to formulate name of a plsql procedure.
BaseDAO.DBSessionInfo	getSessionInfo(java.sql.Connection conn) Retrieves the database session information for the given Connection.
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.

Methods inherited from class oracle.apps.fnd.appltest.diagfwk.engine.provider.plsql.PLSQLProvider

getDBSessionInfo, getProcLabel, getProcName, validateProcedure

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

OraclePLSQLProvider

public OraclePLSQLProvider()

Method Detail

getSessionInfo

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

Retrieves the database session information for the given Connection.

Specified by:

getSessionInfo in class PLSQLProvider

Parameters:

conn - a Connection object

Returns:

a BaseDAO.DBSessionInfo object

getProcedureLabel

public java.lang.String getProcedureLabel(PLSQLProcedureType proc)

Method to retrieve the procedure label.

Specified by:

getProcedureLabel in class PLSQLProvider

Parameters:

proc - a PLSQLProcedureType object

Returns:

the label string

getProcedureName

public java.lang.String getProcedureName(PLSQLProcedureType proc)

Util method to formulate name of a plsql procedure.

Specified by:

getProcedureName in class PLSQLProvider

Parameters:

proc - JAXB object for plsql step

Returns:

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

validatePLSQLProcedure

public 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.

Specified by:

validatePLSQLProcedure in class PLSQLProvider

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