oracle.apps.fnd.appltest.diagfwk.engine
Class UTestDiagPLSQLStepTests

java.lang.Object
  oracle.apps.fnd.appllcm.sdk.common.TestBaseLCM
      oracle.apps.fnd.appltest.diagfwk.TestBaseDiagfwk
          oracle.apps.fnd.appltest.diagfwk.engine.UTestDiagPLSQLStepTests

public class UTestDiagPLSQLStepTests
extends TestBaseDiagfwk

Since:

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

Version:

$Header: atgpf/appltest/applications/Diagnostics/Engine/test/oracle/apps/fnd/appltest/diagfwk/engine/UTestDiagPLSQLStepTests.java /main/5 2009/09/22 16:49:48 ilawler Exp $

Author:

ppradhan

Nested Class Summary

static class

UTestDiagPLSQLStepTests.SimpleJavaPiperTest

Field Summary

Fields inherited from class oracle.apps.fnd.appltest.diagfwk.TestBaseDiagfwk

SYSPROP_ORACLE_ADR_BASE, SYSPROP_ORACLE_ADR_HOME, SYSPROP_ORACLE_ADR_INSTANCE_ID, SYSPROP_ORACLE_ADR_PRODUCT_ID, SYSPROP_TEST_DIR

Fields inherited from class oracle.apps.fnd.appllcm.sdk.common.TestBaseLCM

mWorkingDir

Constructor Summary

UTestDiagPLSQLStepTests()

Method Summary

protected static java.lang.String	getPackageOwner(java.sql.Connection conn, java.lang.String packageName)
static void	main(java.lang.String[] args) For testing standalone (outside of the build)
void	setup()
static void	setUpClass()
static junit.framework.Test	suite() For compatibility with old (pre junit 4.0) junit runners
void	tearDown()
static void	tearDownClass()
void	testAnonymousProcSytaxError()
void	testAvailabilityInfo()
void	testCompoundPrereqMultiple()
void	testDebugLines()
void	testDiagnosticAndExecutionStatus()
void	testOptionalOwnerInPrecompiledProcs()
void	testPiping()
void	testPlsqlProcOrchestation()
void	testPLSQLStepWithDBLinks()
void	testRegistrationNegative()
void	testRunByTag()
void	testTheMegaPLSQLTestCase() Tests 1.
void	testUserIdentity()

Methods inherited from class oracle.apps.fnd.appltest.diagfwk.TestBaseDiagfwk

addSummaryMsg, assertCount, assertCountActiveInputParams, assertCountActiveOutputParams, assertCountActivePrereqs, assertCountActiveTagValues, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsBobj, assertEqualsListSize, assertFileContains_s, assertFileContainsUnderWorkDir, assertInputSetExists, assertListContents, assertNestedExecsForRun, assertNotTagValueAssocInTest, assertRunExists, assertRunNotExists, assertRunNotExistsById, assertSingeTestGotCreated, assertTagExists, assertTagIdNotExists, assertTagValueAssocExists, assertTagValueExists, assertTagValueIdNotExists, assertTestDefExists, assertTestDefExists, assertTestDefNotExists, assertTestExecExists, assertTestExecs, assertTestMetadataDoesNotReferenceTagValueId, assertTestParamExists, assertTestParamExists, assertTestsGotCreated, checkTagExists, cleanPSRConnectionPool, clearAdrSystemProperties, createIncident, createIncident, createInputSet, createPSRConnectionPool, delete, deleteDir, deleteFileUnderWorkDir_s, deleteFNDMessage, deleteInputSet, deleteModuleId, deleteModuleIdByModKeys, deleteProfileValue, deleteProfileValueAtSiteLevel, deleteRun, deleteTag, deleteTagValue, deleteTaxModules, deleteTestDef, deleteTestExec, doLoginAsSpecificUser, fetchTestRun, getConnection, getDefaultADRBase, getFileContents, getSysGuid, getTestPassword, getTestPasswordAsArg, getTestUserName, getTestUserNameAsArg, getWorkDir, grantAllTagPrivs, grantAllTagPrivsByName, grantAllTestPrivs, grantAllTestPrivsByName, grantTestUpdateAllowed, insertFNDMessage, insertModuleDelHeirarchy, insertModuleId, insertModuleId, insertModuleId, insertModuleId, insertModuleId, insertModuleId, insertTag, insertTag, insertTagValue, insertTagValue, insertTagValue, insertTagValueHeirarchy, insertTagValuePrereq, insertTagValuePrereq, insertTagValueWithParent, loadTaxModuleHeirarchy, loadTaxModules, loadTests, loadTests, loginAsAdmin, loginAsAdvancedUser, loginAsAnonymous, loginAsDefault, loginAsRegularUser, loginAsViewer, lookupModuleIdForKey, makeDescriptiveHeader, makeErrorInfo, makeFixInfo, makeHeader, makeMessage, makeMessageLinkExternal, makeMessageLinkInternal, makeMsgList, makeNameValue, makeSection, makeStepReportExtn, makeSummaryInfo, makeTable, makeTestReportExtn, removeCycleSrcIdPrereqId, returnConnection, runTest, runTests, runTests, saveProfileValue, saveProfileValueAtSiteLevel, setAdrSystemProperties, setTestPassword, setTestUserName, setUpBaseDiag, setUpBaseDiagClass, tearDownBaseDiag, tearDownBaseDiagClass, toList, verifyExtractedReportsExist, verifyExtractedReportsExist, verifyExtractedReportsExist, verifyExtractedReportsExist, verifyFileExists, verifyTestRun, writeFile, writeFile

Methods inherited from class oracle.apps.fnd.appllcm.sdk.common.TestBaseLCM

assertFileContains, deleteFilesUnderDir, deleteFilesUnderDir, deleteFileUnderDir, deleteFileUnderWorkDir, getWorkingDir, setUpBase, setWorkingDir, tearDownBase, writeFileUnderDir, writeFileUnderWorkDir

Methods inherited from class java.lang.Object

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

Constructor Detail

UTestDiagPLSQLStepTests

public UTestDiagPLSQLStepTests()

Method Detail

setUpClass

public static void setUpClass()
                       throws java.lang.Exception

Throws:

java.lang.Exception

setup

public void setup()

tearDown

public void tearDown()

tearDownClass

public static void tearDownClass()
                          throws java.lang.Exception

Throws:

java.lang.Exception

testTheMegaPLSQLTestCase

public void testTheMegaPLSQLTestCase()
                              throws java.lang.Exception

Tests 1. Exercise PLSQL API 2. Precompiled procs 3. anonymous procs 4. optional init and cleanup procs 5. optional owner attribute for procs 6. supported input / output types

Throws:

java.lang.Exception

testDiagnosticAndExecutionStatus

public void testDiagnosticAndExecutionStatus()
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testPlsqlProcOrchestation

public void testPlsqlProcOrchestation()
                               throws java.lang.Exception

Throws:

java.lang.Exception

testAnonymousProcSytaxError

public void testAnonymousProcSytaxError()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testCompoundPrereqMultiple

public void testCompoundPrereqMultiple()
                                throws java.lang.Exception

Throws:

java.lang.Exception

testPiping

public void testPiping()
                throws java.lang.Exception

Throws:

java.lang.Exception

testDebugLines

public void testDebugLines()
                    throws java.lang.Exception

Throws:

java.lang.Exception

testRegistrationNegative

public void testRegistrationNegative()
                              throws java.lang.Exception

Throws:

java.lang.Exception

testUserIdentity

public void testUserIdentity()
                      throws java.lang.Exception

Throws:

java.lang.Exception

testAvailabilityInfo

public void testAvailabilityInfo()
                          throws java.lang.Exception

Throws:

java.lang.Exception

testOptionalOwnerInPrecompiledProcs

public void testOptionalOwnerInPrecompiledProcs()
                                         throws java.lang.Exception

Throws:

java.lang.Exception

getPackageOwner

protected static java.lang.String getPackageOwner(java.sql.Connection conn,
                                                  java.lang.String packageName)
                                           throws java.sql.SQLException,
                                                  java.lang.Exception

Throws:

java.sql.SQLException

java.lang.Exception

testRunByTag

public void testRunByTag()
                  throws java.lang.Exception

Throws:

java.lang.Exception

testPLSQLStepWithDBLinks

public void testPLSQLStepWithDBLinks()
                              throws java.lang.Exception

Throws:

java.lang.Exception

suite

public static junit.framework.Test suite()

For compatibility with old (pre junit 4.0) junit runners

main

public static void main(java.lang.String[] args)

For testing standalone (outside of the build)