oracle.apps.fnd.applcore.oaext.model
Class OAViewObjectImpl

java.lang.Object
  oracle.jbo.common.NamedObjectImpl
      oracle.jbo.server.NamedObjectImpl
          oracle.jbo.server.ComponentObjectImpl
              oracle.jbo.server.ViewObjectImpl
                  oracle.apps.fnd.applcore.oaext.model.OAViewObjectImpl

All Implemented Interfaces:

java.util.EventListener, oracle.jbo.common.ViewCriteriaClauseBuilder, oracle.jbo.common.ViewCriteriaManagerOwner, oracle.jbo.common.ViewObjectDynAttr, oracle.jbo.common.ws.WSRowSetIteratorMarshaller, oracle.jbo.common.ws.WSRowSetMarshaller, oracle.jbo.ComponentObject, oracle.jbo.ExprWrappable, oracle.jbo.GenericHints, oracle.jbo.NavigatableRowIterator, oracle.jbo.OperationContainer, oracle.jbo.Properties, oracle.jbo.RowIterator, oracle.jbo.RowMatchBindValueSupplier, oracle.jbo.RowNavigationListener, oracle.jbo.RowSet, oracle.jbo.RowSetIterator, oracle.jbo.RowSetListener, oracle.jbo.server.AttributeDependencyManager, oracle.jbo.server.EntityListener, oracle.jbo.server.TransactionListener, oracle.jbo.server.TransactionPostListener, oracle.jbo.StructureDef, oracle.jbo.VariableManagerOwner, oracle.jbo.VariableManagerOwnerBase, oracle.jbo.ViewCriteriaManager, oracle.jbo.ViewObject, oracle.jbo.XMLInterface

Direct Known Subclasses:

ApplicationPVOImpl, ApplicationVOImpl, ApplTaxonomyApplicationsVOImpl, ApplTaxonomyComponentsVOImpl, ApplTaxonomyDeliveryRootNodeVOImpl, ApplTaxonomyEntAppMapVOImpl, ApplTaxonomyFullDeliveryPVOImpl, ApplTaxonomyFullDeliveryVOImpl, ApplTaxonomyFullNameVOImpl, ApplTaxonomyHierarchyFullVOImpl, ApplTaxonomyHierarchyVOImpl, ApplTaxonomyLanguageVOImpl, ApplTaxonomyNodeComponentsVOImpl, ApplTaxonomyReleaseVOImpl, ApplTaxonomyRfPVOImpl, ApplTaxonomySeedDataVOImpl, ApplTaxonomySeedExtractVOImpl, ApplTaxonomyTranslationVOImpl, ApplTaxonomyVOImpl, ApplTaxReleaseHierarchyVOImpl, AttachmentsVOImpl, AttributesVOImpl, AuthorizationDocumentCategoriesImpl, ChildTableVOImpl, CreateConditionVOImpl, CurrencyPVOImpl, CurrencyVOImpl, CustomVO, DescriptiveFlexfieldRegistrationUIVOImpl, DescriptiveFlexfieldSecondaryColumnUsageRegUIVOImpl, DescriptiveFlexfieldSecondaryTableUsageRegUIVOImpl, DescriptiveFlexfieldSecondaryUsageRegUIVOImpl, DescriptiveFlexfieldTableUsageRegUIVOImpl, DescriptiveFlexfieldUsageRegUIVOImpl, DeterminantValuesLOVVOImpl, EFFCategoryTreeBranchVOImpl, EFFDeploymentCategoriesVOImpl, EFFDeploymentCategoryContextsVOImpl, EFFDeploymentContextUsagesImpl, EFFDeploymentDescriptiveFlexfieldVOImpl, EFFDeploymentEntityUsagesVOImpl, EFFDeploymentFlexFieldUsagesVOImpl, EFFDeploymentFlexfieldVOImpl, EFFDeploymentPagesVOImpl, EFFDeploymentPageTaskFlowsImpl, EFFDeploymentTableUsagesVOImpl, EFFPartialDeploymentCategoriesVOImpl, EFFPartialDeploymentCategoryContextsVOImpl, EntAppLibUsageMapVOImpl, ExtensibleFlexfieldUiPageVOImpl, FavoriteFoldersVOImpl, FavoriteItemsVOImpl, FlexfieldValueViewObjectImpl, FlexfieldViewObjectImpl, FndApplTaxEntAppMapVOImpl, FndApplTaxonomyRfVOImpl, FndAuditAttributesVOImpl, FndAuditReportVOImpl, FndAuditShadowTableVOImpl, FndAuditWebappAMVOImpl, FndAuditWebAppObjectsVOImpl, FndCalDayPVOImpl, FndCalMonthVOImpl, FndCalQuarterVOImpl, FndCalWeekVOImpl, FndCalYearVOImpl, FndDataSecurityDiagnosticsDataVOImpl, FndDataSecurityGrantsDataVOImpl, FndDataSecurityPrivilegesDataVOImpl, FndDemoCityVOImpl, FndDemoContinentVOImpl, FndDemoCountryVOImpl, FndDemoDeptEmpVOImpl, FndDemoDeptVOImpl, FndDemoEmpVOImpl, FndDemoLabelVOImpl, FndDemoStateVOImpl, FndDeploymentsVOImpl, FndDocumentCategoriesVOImpl, FndDocumentEntitiesVOImpl, FndFKValuesTransVOImpl, FndFormFunctionsVOImpl, FndGrantsSBChangesVOImpl, FndGrantsUnSecuredVOImpl, FndGrantsVOImpl, FndKfEssFiltersPVOImpl, FndLabelUIVOImpl, FndLabelVOImpl, FndMapAttachDocsVOImpl, FndMapAttachEntityVOImpl, FndMapCurrenciesVOImpl, FndMapFlexDffColumnsVOImpl, FndMapFlexDffVOImpl, FndMapFlexKffColumnsVOImpl, FndMapFlexKffVOImpl, FndMapIndustriesVOImpl, FndMapIsoLanguagesVOImpl, FndMapLanguagesVOImpl, FndMapLookupsVOImpl, FndMapNaturalLanguagesVOImpl, FndMapSetidRefGroupsVOImpl, FndMapTerritoriesVOImpl, FndMapTimezonesVOImpl, FndMapTreeNodeVOImpl, FndMenuEntriesVOImpl, FndMenusVOImpl, FndNodeVOImpl, FndObjectInstanceSetsVOImpl, FndObjectISSBChangesVOImpl, FndObjectsSBChangesVOImpl, FndObjectsUnSecuredVOImpl, FndObjectsVOImpl, FndRawGeneratorVOImpl, FndSessionAttributesDataVOImpl, FndSessionRolesDataVOImpl, FndSessionUsersVOImpl, FndSessionVOImpl, FndTreeAuditJobVOImpl, FndTreeDataSourceParamsVOImpl, FndTreeFlatteningHistoryVOImpl, FndTreeLabelVOImpl, FndTreeLogParamVOImpl, FndTreeLogVOImpl, FndTreeNodeCfVOImpl, FndTreeNodeRfVOImpl, FndTreeNodeVOImpl, FndTreeStructureSummaryVOImpl, FndTreeStructureVOImpl, FndTreeVersionAuditResultVOImpl, FndTreeVersionVOImpl, FndTreeVersionVOImpl, FndTreeVOImpl, FndTreeVOImpl, FndTsDataSourceParamsVOImpl, FndTsDataSourceRelVOImpl, FndTsDataSourceVOImpl, GroupSpaceDetailVOImpl, GroupSpaceMemberVOImpl, GroupSpaceTemplateVOImpl, GroupSpaceUserRoleVOImpl, IndustryInTerritoryPVOImpl, IndustryPVOImpl, IndustryVOImpl, IsoLanguagePVOImpl, IsoLanguageVOImpl, KFFHierFilterVOImpl, LanguagePVOImpl, LanguageVOImpl, LanguageVOImpl, LibraryVOImpl, MessageRuntimeTestVOImpl, MessageTokenVOImpl, MessageVOImpl, NaturalLanguagePVOImpl, NaturalLanguageVOImpl, OAStaticListViewObjectImpl, ObjectColumnsVOImpl, OperatorsVOImpl, ParentTableVOImpl, PillarMappingVOImpl, PillarTopologyOptionsVOImpl, ProductFamilyDomainVOImpl, ProfileCategoryOptionVOImpl, ProfileCategoryVOImpl, ProfileHierarchyLevelVOImpl, ProfileOptionExptVOImpl, ProfileOptionValuesExptVOImpl, ProfileOptionValuesForProductsVOImpl, ProfileOptionValuesForUsersVOImpl, ProfileOptionValuesLOVVOImpl, ProfileOptionValueVOImpl, ProfileOptionVOImpl, ProfileVOImpl, ProfileVOImpl, RdsPillarDataUsageVOImpl, RdsPillarTplgyMapVOImpl, RdsVOImpl, RoleHierarchyVOImpl, SavedSearchFormatVOImpl, SearchAttachmentsVOImpl, SearchCriteriaVOImpl, SearchCurrenciesTVOImpl, SearchDffVOImpl, SearchIndustriesVOImpl, SearchIsoLanguagesVOImpl, SearchKffVOImpl, SearchLanguagesVOImpl, SearchNaturalLanguagesVOImpl, SearchSetidRefGroupsVOImpl, SearchTerritoriesVOImpl, SearchTimezonesVOImpl, SearchTreeNodeVOImpl, SessionAttributeVOImpl, SessionNamespaceVOImpl, SessionRoleSetsVOImpl, SessionRolesVOImpl, SessionVOImpl, SqlValidationVOImpl, TerritoryPVOImpl, TerritoryVOImpl, TimezonePVOImpl, TimezoneVOImpl, TokenValueVOImpl, TransFilterVOImpl, TreeIconLovImpl, TreeNodeTableLovImpl, UserGroupSpaceVOImpl

public class OAViewObjectImpl
extends oracle.jbo.server.ViewObjectImpl

Accesses the result set of a SQL statement. A view object is a business component that encapsulates SQL code and metadata that maps columns in the select statement to the attributes of one or more entity objects. A view object use SQL to join, filter or sort business data or to shape it for presentation. View objects provide row sets that can be viewed or used to update the underlying entity objects.

Introduction

You can define multiple view objects per entity object or a view object can select data from multiple entity objects. Data is cached in an entity object. All view object references made within the same transaction share the same cache i.e. changes made through one view object are immediately available to other view objects within the same transaction.

View objects can be used to:

• Provide additional security by restricting access to a predetermined set of rows and columns. For example, you could create a view in which columns containing sensitive data in the underlying entity object (such as salaries) are not included.
• Hide data complexity. For example, a view object can hide the fact that data is coming from multiple entities.
• Customize presentation. For example, using a view, you can rename columns without affecting the entities on which the view is based.
• Store complex queries. By saving complex queries in a view, calculations can be performed when the view's query is executed.
• Improve the efficiency of the application by using well optimized SQL, selecting only the data required.

Create and Search view object

OAViewObject can be created either from a view object's definition or based on a SQL statement. Which ever way you create it, you need an application module to contain it.

For Example

In this example we create a view object based on its definition, stored in the file abc.xy.ViewDef.

    // name given to the view instance
    String viewUsageName = "SampleName";

    // create view object based on definition
    OAViewObject sampleViewObject = (OAViewObject) am.createViewObject
                                     (viewUsageName, "abc.xy.ViewDef");
 

The distinction between view usage and view definition is:

• View definition refers to the metadata which describes the structure of view object.
• View usage refers to the instance in memory based on this definition.

In other words, you can have multiple view instances all based on same definition. Each instance will have a different name, which is given to a particular instance when adding it to an application module. This name is referred to as the view usage name.

View objects can be searched in application module, based on the view usage name.

For Example

In this example we search for an existing view object. The view object could be present in the root application module or in any of nested application modules.

    // Name can not have spaces.
    // Letters, digits, connecting punctuation such as '_' are however valid.
    String viewUsageName = "SampleName";

    // search for view object in application module
    OAViewObject viewInstance = (OAViewObject)
    am.findViewObject(viewUsageName);
 

Update or remove the view object

A view object is made of multiple RowSets. RowSet is like a result set which holds the result of a query. Each RowSet is made of RowSetIterators which help to scroll through a set of rows.

A view object holds the query clause which shapes the data. A view object creates a default RowSet to hold the query result. You can create multiple secondary RowSets which can hold results based on a condition or bind parameter.

For Example

In this example we create a secondary RowSet and populate it:

    // Say the SQL of VO is "SELECT EMPNO, ENAME, JOB FROM EMP
    // WHERE DEPTNO = :1"
    String viewUsageName = "EmpVO";

    OAViewObject sampleViewInstance =
                              (OAViewObject)am.findViewObject(viewUsageName);

    // bind the where clause with department number = 10
    sampleViewInstance.setWhereClauseParam(0, "10");

    // This will populate the default RowSet
    sampleViewInstance.executeQuery();

    // count the number of employees in this department
    int rowCount = sampleViewInstance.getRowCount();

    // create secondary RowSet
    String rowSetName = "SampleRowSet";

    // Always find RowSet before creating a new one.
    RowSet secondaryRowSet = sampleViewInstance.findRowSet(rowSetName);
    if (secondaryRowSet == null)
    {
      secondaryRowSet = sampleViewInstance.createRowSet(rowSetName);
    }

    // bind the where clause with department number = 20
    secondaryRowSet.setWhereClauseParam(0, "20");

    // This will populate secondary RowSet
    secondaryRowSet.executeQuery();

    // count the number of employees in department number = 20
    int rowCountAgain = secondaryRowSet.getRowCount();
 

If you no longer need a view object you can remove it from the application module. This will close all the RowSets in the view object.

For Example

In this example we remove an existing view object:

    // name given to the view instance
    String viewUsageName = "SampleName";

    // Search for an existing view object
    OAViewObject sampleViewInstance =
    (OAViewObject)am.findViewObject(viewUsageName);

    if (sampleViewInstance == null)
    {
       System.out.println("Sample view object not found");
    }
    else
    {
       // remove the view object
       sampleViewInstance.remove();
    }
 

Field Summary

static java.lang.String	MOAC_PRIV_PROPERTY_NAME
static java.lang.String	MOAC_PROPERTY_NAME
static java.lang.String	RCS_ID Oracle Applications internal source control identifier.
static java.lang.String	VAR_APPLCORE_SETID Constant for SETID.

Fields inherited from class oracle.jbo.server.ViewObjectImpl

DATA_ROWKEYTAG, DISC_TAG, DYN_ATTRS, DYN_ATTRS_ENTRY, DYN_ATTRS_EXPR, DYN_ATTRS_NAME, DYN_ATTRS_TYPE, EFFDT_MODE, ENT_HDL_TRACKER, ENT_REF_INDEX, FETCH_ALL, FETCH_AS_NEEDED, FETCH_DEFAULT, FULLSQL_MODE_AUGMENTATION, FULLSQL_MODE_NO_AUGMENTATION, INTERNAL_EXPR_VALUE_OVERRIDES, mAssocClause, mAssocFromClause, mAssocRefs, mAttrDefs, mAttrDefsTab, mAutoPostChanges, mChangedAttrIndices, mChgAttrIndUseCount, mDefaultMaxActiveNodes, mDefaultMaxRowsPerNode, mDefaultRowSetMap, mDynAttrOffset, MIN_ACTIVE_NODES, MIN_ROWS_PER_NODE, mKeyAttrRefs, mOptimizerHint, mOrderBy, mUsePersColl, mUserDefinedQuery, mViewDef, mViewRowSet, mWhere, NEW_ROW_HANDLE, NEW_ROW_INDEX, NEW_ROW_TRACKER, PROPERTY_DEFERRED_ESTIMATED_ROWCOUNT, QC_TAG, TRANSIENT_DATA_ROWTAG

Fields inherited from class oracle.jbo.common.NamedObjectImpl

mFullName, mObjName, mParent, mProperties, RES_ID_SUFFIX

Fields inherited from interface oracle.jbo.ViewObject

IMAGE_LOC, PROP_ALWAYS_USE_SORT, QUERY_MODE_SCAN_DATABASE_TABLES, QUERY_MODE_SCAN_ENTITY_ROWS, QUERY_MODE_SCAN_UNPOSTED_ENTITY_ROWS, QUERY_MODE_SCAN_VIEW_ROWS, QUERY_MODE_SKIP_WHERE, QUERY_TIMEOUT_WAIT_FOREVER, XML_ELEM_PASSIVATE_TRANSIENT

Fields inherited from interface oracle.jbo.RowSet

COPY_OPT_ALL_ROWS, COPY_OPT_LIMIT_RANGE, FORWARD_ONLY, RANGE_PAGING, RANGE_PAGING_AUTO_POST, RANGE_PAGING_INCR, SCROLLABLE

Fields inherited from interface oracle.jbo.RowIterator

ITER_MODE_LAST_PAGE_FULL, ITER_MODE_LAST_PAGE_PARTIAL, SLOT_BEFORE_FIRST, SLOT_BEYOND_LAST, SLOT_DELETED, SLOT_VALID

Fields inherited from interface oracle.jbo.XMLInterface

XML_IGNORE_DEPTH_COUNT, XML_OPT_ALL_ROWS, XML_OPT_ASSOC_CONSISTENT, XML_OPT_CHANGES_ONLY, XML_OPT_LIMIT_RANGE, XML_PASSIVATION_USE

Fields inherited from interface oracle.jbo.GenericHints

PROPERTY_LABEL, PROPERTY_LABEL_PLURAL, PROPERTY_TOOLTIP

Fields inherited from interface oracle.jbo.ViewCriteriaManager

DFLT_VIEW_CRITERIA_NAME, IMPLICIT_VIEW_CRITERIA_NAME, QUICKSEARCH_VIEW_CRITERIA_NAME

Constructor Summary

OAViewObjectImpl()

Method Summary

protected boolean	buildWhereClause(java.lang.StringBuffer sqlBuffer, int noUserParams)
protected void	create() Applications: Do not override this method.
protected oracle.jbo.server.ViewObjectImpl	createFinderVO(java.lang.String suffix)
protected oracle.jbo.server.ViewRowImpl	createRowFromResultSet(java.lang.Object qc, java.sql.ResultSet resultSet)
protected oracle.jbo.server.ViewRowSetImpl	createViewAccessorRS(oracle.jbo.server.ViewAccessorDef accessorDef, oracle.jbo.Row masterRow, java.lang.Object[] valuse, boolean addRSToMasterRow)
void	doInitMOAC(Privilege priv) MOAC Initialization
protected void	executeQueryForCollection(java.lang.Object qc, java.lang.Object[] params, int noUserParams)
oracle.jbo.ViewCriteria[]	getApplyAllViewCriterias(int criteriaMode, boolean getAllReqdVC)
oracle.jbo.AttributeDef[]	getAttributeDefsForRowDuplication() Gets the list of attributes for view row duplication.
java.lang.String	getCriteriaItemClause(oracle.jbo.ViewCriteriaItem vci)
java.lang.String	getCriteriaItemClauseWhenKffExposedinQueryPanel(oracle.jbo.ViewCriteriaItem vci, java.lang.String criteriaName, java.lang.String kffAccessorName) Deprecated.
java.sql.Date	getCurrentDatabaseDate() Gets the current dtabase date as a java.sql.Date instance.
protected int	getEntityDefCount()
oracle.jbo.server.ViewDefImpl	getFlexfieldViewDef(java.lang.String accessorName, java.lang.Object discrValue) Gets the flexfield view definition for a discriminator value.
int	getMaxFetchSize()
protected long	getRowLimit()
oracle.jbo.server.ViewDefImpl	getViewDef() Returns ViewDef for the ViewObject.
void	initMOAC() This method gets invoked if a View Object is MOAC enabled.
protected boolean	isFilterVO()
protected boolean	isFlexfieldMaster() Returns true if this view object is a master view object of flexfield detail view objects.
protected void	notifyRowInserted(oracle.jbo.server.ViewRowSetImpl vrs, oracle.jbo.Row viewRow, int rowIndex) Applications: When overriding this method, call super.notifyRowInserted first before your implementation.
void	prepareVOForQuery()
static void	processDSVCERHintForBI(java.lang.String fullViewDefName, java.lang.String vcName)
void	setMaxFetchSize(int i)
void	sourceChanged(oracle.jbo.server.EntityEvent event) Applications: When overriding this method, call super.sourceChanged first before your implementation.

Methods inherited from class oracle.jbo.server.ViewObjectImpl

_internal_dbg_debug_data, activateCurrentRow, activateDynamicAttributeDefs, activateIteratorState, activateNewRowTracker, activateNewRowTracker, activateState, activateState, activateState, activateTransientAttribute, activateTransients, activateTransients, addDynamicAttribute, addDynamicAttributeWithType, addForwardDependency, addListener, addManagementListener, addOrderByClause, addQueryMode, addRowSet, addViewCriteriaToWhereClause, addViewLink, addWhereClause, adjustERCWithChangedRows, afterCommit, afterEntityRemove, afterRemove, afterRollback, appendViewCriteria, appendXMLElementNodes, appendXMLElementNodes, applyBindVariableForCriteria, applyPersonalization, applyViewCriteria, applyViewCriteria, beforeCommit, beforeEntityRemove, beforeRollback, bindFinderRS, bindParametersForCollection, bindRangePagingParams, buildEffectiveDateFromClauseFragment, buildEffectiveDateWhereClauseFragment, buildFromClause, buildKey, buildNewCollection, buildOrderByClause, buildQualifyingRowFilters, buildQuery, buildQuery, buildRangePagingQuery, buildRowFilter, buildSelectClause, buildSubquery, buildViewCriteriaClauses, cancelQuery, checkPassivateViewAttributes, clearCache, clearViewCriterias, closeFreedStatements, closeRowSet, closeRowSetIterator, createAndInitRow, createAndInitRowForCollection, createDetailRowSet, createInstance, createInstanceFromResultSet, createInstanceWithEntities, createKey, createNewRowForCollection, createRow, createRowSet, createRowSetIterator, createVariableValueManager, createVariableValueManagerForRS, createViewCriteria, createViewCriteriaManagerImpl, createViewLinkAccessor, createViewLinkAccessorRS, createViewLinkAccessorVO, createViewLinkScanBaseRS, createViewRowSet, createXMLDefinition, criteriaChanged, criteriaSelReqBindVarsChanged, deepCopy, defineNamedWhereClauseParam, disconnectCollection, doesRowFilterMatch, dumpQCs, enumerateRowsInRange, executeDetailQuery, executeEmptyRowSet, executeQuery, executeQueryForActivation, findAltKeyDef, findAndSetCurrentRowByKey, findAssociatedEntity, findAttributeDef, findByAltKey, findByAltKey, findByEntity, findByKey, findByKey, findByViewCriteria, findByViewCriteriaForViewRowSet, findByViewCriteriaWithBindVars, findByViewCriteriaWithBindVars, findInCacheByAltKey, findInCacheByKey, findListBindingDef, findOrCreateLocalViewObject, findOrCreateLocalViewObject, findPrimaryKeyColumns, findRowInQCs, findRowSet, findRowSetIterator, findRowsMatchingCriteria, findViewAccessorDef, findViewDefFromDiscrVals, findViewDefFromDiscrVals, findViewLinkAccessor, findViewLinkAccessorVO, first, forceExecuteQueryOfSharedVO, getAccessMode, getAllCachedQueryCollections, getAllRowsInRange, getAllViewCriteriaNames, getAllViewCriterias, getAltKeyAttrDefs, getApplicationModule, getApplicationModuleForLocalViewObject, getApplyJoinedViewCriteriaNames, getApplyViewCriteriaNames, getApplyViewCriterias, getAssociationClause, getAttrDefsForEntityAttr, getAttributeCount, getAttributeDef, getAttributeDefs, getAttributeIndexOf, getAttrIndicesForEntityAttr, getAvailableViewCriteriaNames, getBackwardDependencies, getBackwardDependencyAttributes, getBindingStyle, getBindValsForSqlGen, getByKeyFinderRS, getCachedQueryCollection, getCalculatedAttributeCount, getCallableStatement, getCappedQueryHitCount, getCappedRowCount, getCliIteratorState, getColumnNameForQuery, getCriteriaAdapter, getCriteriaItemAttributeHints, getCurrentRow, getCurrentRowIndex, getCurrentRowSlot, getDBSortCriteria, getDBTransaction, getDef, getDefaultAccessMode, getDefaultRangePagingCacheFactor, getDefaultRangeSize, getDefaultRowSet, getDefaultRowSetInternal, getDeferEstimatedRowCountProperty, getDeferredEstimatedRowCount, getDefFullName, getDefName, getDeleteParticipants, getDetailEstimatedRowCount, getDetailRowSets, getDiscrColLoadIndices, getDynamicAttributeCount, getDynamicAttributeOffset, getEntityDef, getEntityDefs, getEstimatedRangePageCount, getEstimatedRowCount, getFetchedRowCount, getFetchMode, getFetchSize, getFilteredRows, getFilteredRows, getFilteredRowsInRange, getFilteredRowsInRange, getForeignKeyValues, getForwardDependencies, getForwardDependencyAttributes, getFromClause, getFromClauseFlags, getFullLoggingName, getFullSqlMode, getImageLoc, getImplObject, getInsertParticipants, getIterMode, getKeyAttributeDefs, getListBindingDefsInternal, getLockParticipants, getMasterKeyValues, getMasterRowSetIterators, getNamedWhereClauseParam, getNamedWhereClauseParams, getNextRangeSet, getOperationDefinitions, getOrderByClause, getParametersAsStorageTypes, getPreparedStatement, getPreviousRangeSet, getPrimaryKeys, getProxyClassName, getProxyInterfaceName, getQualifyingRowFilters, getQuery, getQueryCollection, getQueryHint, getQueryHitCount, getQueryHitCount, getQueryMode, getQueryOptimizerHint, getQueryTimeOut, getRangeIndexOf, getRangePageStartForCollection, getRangePagingCacheFactor, getRangeSize, getRangeStart, getReqdVC, getRequiredViewCriteria, getRow, getRowAtRangeIndex, getRowClass, getRowComparator, getRowCount, getRowCountInRange, getRowFilters, getRowFilterValues, getRowFromHandle, getRowMatch, getRowMatchBindValue, getRowMatchFromViewCriteria, getRowOperationDefinitions, getRowProxyClassName, getRowQualifier, getRowSet, getRowSetForSqlGen, getRowSetImpl, getRowSetIterator, getRowSetIterators, getRowSets, getRowSetsInternal, getScanRowFilterAttributeDefs, getSelectClause, getSelectClauseFlags, getSignature, getSortBy, getSortCriteria, getSubclassDef, getSubclassDefFromStructureDef, getSubstitutedDefNames, getSyncLock, getTransPostHandle, getUserDataForCollection, getUserDefinedQuery, getViewAccessorDefsInternal, getViewAttributeDefImpls, getViewCriteria, getViewCriteria, getViewCriteriaClause, getViewCriteriaClause, getViewCriteriaManager, getViewCriteriaManagerInternal, getViewLinkAccessorInfo, getViewLinkDestinationAttributes, getViewLinkNames, getViewLinks, getViewObject, getWhereClause, getWhereClauseFlags, getWhereClauseParams, getXMLElementTag, getXMLRowElementTag, handleActivatedRowNotFound, hasDefaultRowSet, hasNext, hasNextForCollection, hasPrevious, hideAttributeDef, initFromDef, insertRow, insertRowAtRangeIndex, isAssociationConsistent, isAttributeKey, isAutoPostChanges, isAutoRefreshEnabled, isCollectionPresent, isDefaultAssocConsistent, isDefaultRowSet, isDynamicAttribute, isDynamicAttribute, isEffectiveDated, isEntityReferenceSelected, isExecuted, isFetchComplete, isForeignKey, isForScan, isForwardOnly, isInternal, isManageRowsByKey, isMasterKeyValues, isMaxFetchSizeExceeded, isNameGenerated, isPassivatableTransientAttribute, isPassivationEnabled, isPostedToDB, isQueryChanged, isRangeAtBottom, isRangeAtTop, isReadOnly, isRowValidation, isRuntimeSQLGeneration, isSelectAllAttributes, isTransientTransactionListener, isTransientTransactionPostListener, isViewLinkAccessorRetained, last, lookupAltKeyDef, lookupAttributeDef, lookupListBindingDef, lookupViewAccessorDef, markQueryCollectionDirty, marshalListBindingDefs, navigated, needsRefresh, next, notifyRowDeleted, notifyRowUpdated, notifyRowUpdated, notifyRowUpdated, notifyRowUpdated, onDatabaseChangeNotification, passivateDynamicAttributeDef, passivateDynamicAttributes, passivateNewRowTracker, passivateState, passivateState, passivateState, passivateTransients, passivateTransients, populateAttributeForRow, postChanges, preFetchRowsByKeys, preFetchRowsByKeys, prepareForActivation, prepareForBatchMode, prepareForPassivation, prepareRowSetForQuery, prepareRowSetForQuery, previous, printXMLDefinition, processDatabaseChangeNotification, processNewSelectSet, processSortCriteria, putViewCriteria, qualifiesRowFilter, rangeRefreshed, rangeScrolled, readFromXml, readRowXML, readRowXML, readXML, readXML, reconnectCollection, refreshCollection, refreshWhereClauseParams, registerDatabaseChangeListener, releaseUserDataForCollection, remove, removeApplyViewCriteriaName, removeCurrentRow, removeCurrentRowAndRetain, removeCurrentRowFromCollection, removeListener, removeManagementListener, removeMasterRowSetIterator, removeNamedWhereClauseParam, removeRowHandle, removeRowSet, removeViewCriteria, reset, resetCriteria, resetExecuted, resetSelectedAttributeDefs, resetSelectedAttributeDefs, resetSession, retrieveByKey, retrieveByKey, retrieveByKey, rowDeleted, rowInserted, rowQualifies, rowUpdated, scrollRange, scrollRangeTo, scrollToRangePage, selectAttributeDefs, setAccessMode, setApplyJoinedViewCriteriaNames, setApplyViewCriteriaName, setApplyViewCriteriaName, setApplyViewCriteriaNames, setAssociationConsistent, setAutoPostChanges, setBindingStyle, setCurrentRow, setCurrentRowAtRangeIndex, setCurrentUnionViewCriteriaName, setDBSortCriteria, setDefaultAccessMode, setDefaultAssocConsistent, setDefaultRangePagingCacheFactor, setDefaultRangeSize, setFetchCompleteForCollection, setFetchMode, setFetchSize, setForwardOnly, setFromClause, setFromClauseFlags, setFullSqlMode, setIterMode, setKeyAttributeDefs, setListenToEntityEvents, setManageRowsByKey, setMasterRowSetIterator, setNamedWhereClauseParam, setNamedWhereClauseParams, setNestedSelectForFullSql, setOrderByClause, setOrderByOrSortBy, setPassivatableTransientAttribute, setPassivationEnabled, setPostedToDB, setProxyClassName, setQuery, setQueryAsChanged, setQueryChanged, setQueryHint, setQueryMode, setQueryOptimizerHint, setQueryTimeOut, setRangePagingCacheFactor, setRangeSize, setRangeStart, setReqdVC, setRequiredViewCriteria, setResultSetForCollection, setRowFilterValues, setRowMatch, setRowMatchFromViewCriteria, setRowQualifier, setRowValidation, setSelectClause, setSelectClauseFlags, setSortBy, setSortCriteria, setThrowOnListBindingMismatch, setTransPostHandle, setUserDataForCollection, setViewCriteriaAdapter, setViewLinkAccessorRetained, setWhereClause, setWhereClauseFlags, setWhereClauseParam, setWhereClauseParams, shouldPutJoinConstraintInWhereClause, showCursorUsage, skipNamedWhereClauseParam, sortRows, substituteAttribute, throwOnListBindingMismatch, unpinDetailQC, unselectAttributeDefs, updateRowSetFromXML, validate, validateRangeSizeForRangePaging, writeXML, writeXML, writeXML, writeXML

Methods inherited from class oracle.jbo.server.ComponentObjectImpl

addListener, createRef, ensureVariableManager, findOperationDefinitions, findPersDefObject, getAllProperties, getCompListeners, getCompListenersList, getDefinitionManager, getFullNameForPersDef, getHintValue, getLabel, getLabelPlural, getMessageBundleClass, getProxyClassName, getResourceBundleDef, getRootApplicationModule, getStringFromMessageBundle, getTooltip, getVariableManager, hasVariables, isDead, isPersonalized, isRegWithPiggyMan, resolvePropertyRaw, setName, setParent

Methods inherited from class oracle.jbo.server.NamedObjectImpl

setParent, setPropertiesMap

Methods inherited from class oracle.jbo.common.NamedObjectImpl

allocatePropertyMap, getFullName, getName, getParent, getProperties, getPropertiesAsStrings, getPropertiesMap, getProperty, getProperty, getPropertyExpressionsMap, getPropertyMap, getResourcesFromBundle, isPropertyExpression, mergePropertyMap, refreshProperty, removeProperty, removeProperty, requiresNamePrefixedResId, resolveObjectProperty, setFullName, setPropertiesMap2, setProperty, setProperty, setPropertyExpression, setPropertyMap

Methods inherited from class java.lang.Object

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

Methods inherited from interface oracle.jbo.StructureDef

getFullName, getName

Methods inherited from interface oracle.jbo.RowSet

getName

Methods inherited from interface oracle.jbo.VariableManagerOwnerBase

ensureVariableManager, getMessageBundleClass, getResourceBundleDef, getVariableManager, hasVariables

Methods inherited from interface oracle.jbo.ComponentObject

getFullName, getName

Methods inherited from interface oracle.jbo.GenericHints

getHintValue, getLabel, getLabelPlural, getTooltip

Methods inherited from interface oracle.jbo.Properties

getProperties, getProperty, getProperty, refreshProperty

Field Detail

RCS_ID

public static final java.lang.String RCS_ID

Oracle Applications internal source control identifier.

See Also:

Constant Field Values

VAR_APPLCORE_SETID

public static final java.lang.String VAR_APPLCORE_SETID

Constant for SETID.

See Also:

Constant Field Values

MOAC_PRIV_PROPERTY_NAME

public static final java.lang.String MOAC_PRIV_PROPERTY_NAME

See Also:

Constant Field Values

MOAC_PROPERTY_NAME

public static final java.lang.String MOAC_PROPERTY_NAME

See Also:

Constant Field Values

Constructor Detail

OAViewObjectImpl

public OAViewObjectImpl()

Method Detail

createRowFromResultSet

protected oracle.jbo.server.ViewRowImpl createRowFromResultSet(java.lang.Object qc,
                                                               java.sql.ResultSet resultSet)

Overrides:

createRowFromResultSet in class oracle.jbo.server.ViewObjectImpl

setMaxFetchSize

public void setMaxFetchSize(int i)

Specified by:

setMaxFetchSize in interface oracle.jbo.ViewObject

Overrides:

setMaxFetchSize in class oracle.jbo.server.ViewObjectImpl

getEntityDefCount

protected int getEntityDefCount()

Overrides:

getEntityDefCount in class oracle.jbo.server.ViewObjectImpl

getCurrentDatabaseDate

public java.sql.Date getCurrentDatabaseDate()

Gets the current dtabase date as a java.sql.Date instance.

Returns:

java.sql.Date instance of database date.

sourceChanged

public void sourceChanged(oracle.jbo.server.EntityEvent event)

Applications: When overriding this method, call super.sourceChanged first before your implementation.

Specified by:

sourceChanged in interface oracle.jbo.server.EntityListener

Overrides:

sourceChanged in class oracle.jbo.server.ViewObjectImpl

notifyRowInserted

protected void notifyRowInserted(oracle.jbo.server.ViewRowSetImpl vrs,
                                 oracle.jbo.Row viewRow,
                                 int rowIndex)

Applications: When overriding this method, call super.notifyRowInserted first before your implementation.

Overrides:

notifyRowInserted in class oracle.jbo.server.ViewObjectImpl

getAttributeDefsForRowDuplication

public final oracle.jbo.AttributeDef[] getAttributeDefsForRowDuplication()

Gets the list of attributes for view row duplication. The attribute values must be duplicated in the order of the return array.

Returns:

the list of attributes for view row duplication

getFlexfieldViewDef

public oracle.jbo.server.ViewDefImpl getFlexfieldViewDef(java.lang.String accessorName,
                                                         java.lang.Object discrValue)

Gets the flexfield view definition for a discriminator value.

Parameters:

accessorName - the flexfield view link accessor name

discrValue - the discriminator value

Returns:

the view definition; null if no matching view definition is found

Throws:

java.lang.IllegalArgumentException - if the view link accessor is not a flexfield view link accessor

FlexfieldJboException - if the application module hierarchy does not contain a flexfield application module associated with the view link accessor

isFlexfieldMaster

protected boolean isFlexfieldMaster()

Returns true if this view object is a master view object of flexfield detail view objects. Whether a view object is a flexfield master object is determined by a custom property FND_ACFF_Master in the view object. If the property value is true, the view object is a flexfield master view object.

Returns:

true if this view object is a flexfield master view object

getViewDef

public oracle.jbo.server.ViewDefImpl getViewDef()

Returns ViewDef for the ViewObject. Calls super method.

Overrides:

getViewDef in class oracle.jbo.server.ViewObjectImpl

Returns:

ViewDef for the ViewObject.

create

protected void create()

Applications: Do not override this method.

Overrides:

create in class oracle.jbo.server.ComponentObjectImpl

isFilterVO

protected boolean isFilterVO()

createViewAccessorRS

protected oracle.jbo.server.ViewRowSetImpl createViewAccessorRS(oracle.jbo.server.ViewAccessorDef accessorDef,
                                                                oracle.jbo.Row masterRow,
                                                                java.lang.Object[] valuse,
                                                                boolean addRSToMasterRow)

Overrides:

createViewAccessorRS in class oracle.jbo.server.ViewObjectImpl

buildWhereClause

protected boolean buildWhereClause(java.lang.StringBuffer sqlBuffer,
                                   int noUserParams)

Overrides:

buildWhereClause in class oracle.jbo.server.ViewObjectImpl

executeQueryForCollection

protected void executeQueryForCollection(java.lang.Object qc,
                                         java.lang.Object[] params,
                                         int noUserParams)

Overrides:

executeQueryForCollection in class oracle.jbo.server.ViewObjectImpl

getMaxFetchSize

public int getMaxFetchSize()

Specified by:

getMaxFetchSize in interface oracle.jbo.ViewObject

Overrides:

getMaxFetchSize in class oracle.jbo.server.ViewObjectImpl

getRowLimit

protected long getRowLimit()

Overrides:

getRowLimit in class oracle.jbo.server.ViewObjectImpl

getApplyAllViewCriterias

public oracle.jbo.ViewCriteria[] getApplyAllViewCriterias(int criteriaMode,
                                                          boolean getAllReqdVC)

Overrides:

getApplyAllViewCriterias in class oracle.jbo.server.ViewObjectImpl

prepareVOForQuery

public void prepareVOForQuery()

Overrides:

prepareVOForQuery in class oracle.jbo.server.ViewObjectImpl

processDSVCERHintForBI

public static void processDSVCERHintForBI(java.lang.String fullViewDefName,
                                          java.lang.String vcName)

initMOAC

public void initMOAC()

This method gets invoked if a View Object is MOAC enabled. The default implementation will look up the Groovy expression stored in the schema based property fnd:MOAC_PRIV_NAME and evaluate it to determine the privilege name that should be used to do MOAC initialization by calling doMOACInit(priv) method. You may override this method to do custom MOAC initialization. A simple implementation of this method can identify the privilege name they want to use to filter Business Unit and invoke doMOACInit(priv) method. If MOAC has been initialized by calling MOACUtil.doMOACInit() by any other means (like in the AM), then this could be empty. Also, if fnd:MOAC_PRIV_NAME is not specified then then this does nothing. When MOAC initialization is done, the privilege name is set on the session attribute and the list of BUs available to the user is computed.

doInitMOAC

public void doInitMOAC(Privilege priv)

MOAC Initialization

Parameters:

priv - Privilege of user/role

createFinderVO

protected oracle.jbo.server.ViewObjectImpl createFinderVO(java.lang.String suffix)

Overrides:

createFinderVO in class oracle.jbo.server.ViewObjectImpl

getCriteriaItemClause

public java.lang.String getCriteriaItemClause(oracle.jbo.ViewCriteriaItem vci)

Overrides:

getCriteriaItemClause in class oracle.jbo.server.ViewObjectImpl

getCriteriaItemClauseWhenKffExposedinQueryPanel

public java.lang.String getCriteriaItemClauseWhenKffExposedinQueryPanel(oracle.jbo.ViewCriteriaItem vci,
                                                                        java.lang.String criteriaName,
                                                                        java.lang.String kffAccessorName)

Deprecated.

This is a utility method that is to be used when a MasterVO containing KFF has a ViewCriteria on it that includes the KFF exposed on ADF Query Panel This method is to be called within the overriden getCriteriaItemClause() of the product team ViewObject.

Parameters:

vci - - ViewCriteriaItem

criteriaName - - ViewCriterianame

kffAccessorName - - KffAccessor Name

Returns: