psdi.app.mr

Class MRSet

java.lang.Object

psdi.mbo.MboSet

psdi.app.mr.MRSet

All Implemented Interfaces:

java.rmi.Remote, MRSetRemote, MboAccessInterface, MboConstants, MboSetRemote, MaxRemoteProxy, Transactable, FixedLoggerNames, FixedLoggers

public class MRSet
extends MboSet
implements MRSetRemote

Represents the set of MRs.

Relationships to other MboSets:

Relationship Name	MboSet	Relationship
ASSET	ASSET	assetnum = mr.assetnum
INVRESERVE	INVRESERVE	mrnum = mr.mrnum
COMPANIES	ADDRESS	addresscode = mr.shipto
LOCATIONS	LOCATIONS	location = mr.location
MATRECTRANS	MATRECTRANS	mrnum = mr.mrnum
MATUSETRANS	MATUSETRANS	mrnum = mr.mrnum
MRLINE	MRLINE	mrnum = mr.mrnum
MRSTATUS	MRSTATUS	mrnum = mr.mrnum
PO	PO	ponum in (select ponum from poline where mrnum = mr.mrnum)
POLINE	POLINE	receiptscomplete = :NO
POSTATUS	POSTATUS	ponum in (select ponum from poline where mrnum = mr.mrnum)
PRSTATUS	PRSTATUS	prnum in (select prnum from prline where mrnum = mr.mrnum)
WFASSIGNMENT	WFASSIGNMENT	recordkey = mr.mrnum
WFMRTRANSACTION	WFTRANSACTION	RECORDKEY = :MRNUM and MAINTBNAME = 'MR'
WORKORDER	WORKORDER	wonum = mr.wonum

Field Summary

Fields inherited from class psdi.mbo.MboSet

fetchStopLimitEnabled, LOOKUPMAXROW, maxSorterSize, mboCountCleanuplist, perfStats, strNoBaseLangValueEntered

Fields inherited from interface psdi.app.mr.MRSetRemote

ADDRESS, ASSET, COMPLETEWF, INVRESERVE, LOCATIONS, MATRECTRANS, MATUSETRANS, MRCOST, MRLINE, MRSTATUS, PO, POLINE, PR, REASSIGNWF, RFQ, SITE, STARTWF, STOPWF, WFACTION, WFASSIGNMENT, WFMRTRANSACTION, WORKORDER

Fields inherited from interface psdi.mbo.MboSetRemote

INSERTONLY, INSERTORUPDATE, UPDATEONLY

Fields inherited from interface psdi.mbo.MboConstants

ALLROWS, CHANGEDBY_USER, COUNT_ADDITIONS, COUNT_AFTERSAVE, COUNT_DATABASE, COUNT_DELETED, COUNT_EXISTING, DBCONFIG, DELAYVALIDATION, DELAYVALIDATIONONLY, DISCARDABLE, GOTCOMPLETEWHERE, HIDDEN, NO_RELATEDMBOS_OF_OWNERSCHILDREN_FETCH, NOACCESSCHECK, NOACTION, NOADD, NOCOMMIT, NODELETE, NONE, NOOVERWRITE, NOSAVE, NOSETVALUE, NOUPDATE, NOVALIDATION, NOVALIDATION_AND_NOACTION, NOVALIDATION_AND_NOACTION_ALLOWCROSSOVER, READONLY, REBUILD, REQUIRED, SAMEVALUEVALIDATION, SETBYPARENT, USER

Fields inherited from interface psdi.util.logging.FixedLoggers

APPLOGGER, CRONTASKLOGGER, CRONTASKMGRLOGGER, CRONTASKMGRSQLLOGGER, DBCONNECTIONLOGGER, DDLOGGER, DMLOGGER, EVENTLOGGER, EXCEPTIONLOGGER, MAILLOGGER, MAXIMOLOGGER, MTLOGGER, NULLMBOPOINTER, SECURITY, SENDFAILEDLOGGER, SERVICELOGGER, SQLLOGGER

Fields inherited from interface psdi.util.logging.FixedLoggerNames

appenderPrefix, LOGGERNAME_APP, LOGGERNAME_CRONTASK, LOGGERNAME_CRONTASKMGR, LOGGERNAME_DBCONNECTION, LOGGERNAME_DD, LOGGERNAME_DM, LOGGERNAME_DMPREVIEW, LOGGERNAME_EVENT, LOGGERNAME_EXCEPTION, LOGGERNAME_MAIL, LOGGERNAME_MAXIMO, LOGGERNAME_MT, LOGGERNAME_NULLMBOPOINTER, LOGGERNAME_SECURITY, LOGGERNAME_SENDFAILED, LOGGERNAME_SERVICE, LOGGERNAME_SQL, LOGGERNAME_SQL_CRONTASKMGR, LOGGERNAME_TXN, loggerPrefix

Constructor Summary

Constructors

Constructor and Description
MRSet(MboServerInterface ms) Construct the set

Method Summary

Modifier and Type	Method and Description
boolean	checkWFEnabled() This method checks whether to start the workflow process.
void	deleteInvReserves() When a work order is cancelled, unapproved, or completed/closed, all of the InvReserve Mbos are deleted.
void	findAllDraftMRsForCurrentUser() Finds all draft mr's for the current user.
void	findAllDraftMRsForPersonCode(java.lang.String personCode) Finds all draft mr's for the specified user.
void	findAllMRsForCurrentUser() Finds all mrs for the current user.
void	findAllMRsForPersonCode(java.lang.String personCode) Finds all mrs for the specified user.
void	findAllOpenMRs() This method retrives all the open MRs in the database irrespective of the user who created it.It also includes the \ condition that the MRs are not waiting for approval do not have their history flags set(to "YES").
void	findAllOpenMRsForCurrentUser() Finds all open mr's for the current user.
void	findAllOpenMRsForPersonCode(java.lang.String personCode) Finds all open mr's for the specified user.
void	findAllReceivingMRs() This method retrieves all MRs irrespective of the user who created it but the MR must satisfy the following condition They must have a corresponding POLINE with the receiptscomplete flag on this POLINE set to false.
void	findAllReceivingMRsForCurrentUser() This method retrieves all MRs created by the current user if those MRs satisfy the following condition They must have a corresponding POLINE with the receiptscomplete flag on this POLINE set to false.
void	findAllRecurringMRs() Find all Recurring MR's.
void	findAllRecurringMRsForCurrentUser() Finds all recurring mr's for the current user.
void	findAllRecurringMRsForPersonCode(java.lang.String personId) Finds all recurring mr's for the specified user.
void	findMR(java.lang.String mrnum) Find an mr based on mrnum.
void	reset() reset method is overriden to set back the flags related to WorkFlow to the default values.

Methods inherited from class psdi.mbo.MboSet

abortSql, add, add, addAtEnd, addAtEnd, addAtIndex, addAtIndex, addFakeAtEnd, addFederatedMboToSorter, addSubQbe, addSubQbe, addSubQbe, addSubQbe, addToEndOfSelectStatement, addWarning, addWarnings, appendToWhere, applyRowSecurity, avg, canAdd, cancelAndClose, checkMethodAccess, checkMethodAccess, cleanup, clear, clearBatchedPreparedStmt, clearBatchedPreparedStmts, clearESigTransactionIdThread, clearESigTransIDForAdmin, clearIgnoredAutokeyAttrs, clearLongOpPipe, clearToBeSaved, clearTransactionReference, clearWarnings, close, commit, commitTransaction, copy, copy, copy, copyForDM, count, count, deleteAll, deleteAll, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemoveAll, deleteAndRemoveAll, determineRequiredFieldsFromERM, dump, earliestDate, enableMethod, executeBatch, fetchNext, findAllNullRequiredFields, findByIntegrationKey, findKey, fireEventsAfterDB, fireEventsAfterDBCommit, fireEventsBeforeDB, forceDBSort, getAllowQualifiedRestriction, getAlwaysFlags, getAlwaysFlags, getApp, getAppAlwaysFieldFlags, getAppWhere, getAttrRestrictions, getBoolean, getByte, getBytes, getClientLocale, getClientTimeZone, getCompleteWhere, getCurrentPosition, getDate, getDBFetchMaxRows, getDefaultValue, getDefaultValueHash, getDouble, getERMEntity, getESigTransactionId, getExcludeMeFromPropagation, getFlags, getFloat, getIgnoredAutokeyAttrs, getInsertCompanySet, getInsertItemSet, getInsertOrg, getInsertSite, getInt, getJspDefaultValueHash, getKeyAttributes, getList, getList, getLong, getMaxAppsWhere, getMaxMessage, getMbo, getMbo, getMboForUniqueId, getMboLogger, getMboServer, getMboSetData, getMboSetData, getMboSetInfo, getMboSetRetainMboPositionData, getMboSetRetainMboPositionInfo, getMboSetValueData, getMboSetValueData, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMLFromClause, getMultiSiteWhere, getMXTransaction, getName, getOrderBy, getOwner, getParentApp, getPreparedStmt, getProfile, getProxy, getQbe, getQbe, getQbe, getQbeSiteAuthorization, getQbeWhere, getQualifiedWhere, getQueryTimeout, getRelationName, getRelationship, getRowRestrictions, getSecurityLogger, getSelection, getSelectionWhere, getSetOrderByForUI, getSharedMboSet, getSize, getSkipFirstNRows, getSqlLogger, getSQLOptions, getString, getTxnPropertyMap, getUserAndQbeWhere, getUserInfo, getUserName, getUserPrefWhere, getUserWhere, getUserWhere, getWarnings, getWhere, getZombie, handleMLMbo, handleMLMbo, hasMLQbe, hasQbe, hasWarnings, ignoreAutokeyAttr, ignoreAutokeyAttr, ignoreQbeExactMatchSet, incrementDeletedCount, init, init, initDataDictionary, isBasedOn, isClosed, isDeltaStorage, isDMDeploySet, isDMSkipFieldValidation, isEAuditFieldModified, isEmpty, isESigFieldModified, isESigNeeded, isFlagSet, isIgnoreQbeExactMatchSet, isLookup, isNull, isQbeCaseSensitive, isQbeExactMatch, isRetainMboPosition, isTableDomainLookup, latestDate, locateMbo, logESigVerification, logRowUpdatedException, max, min, moveFirst, moveLast, moveNext, movePrev, moveTo, moveToKey, newMboIndex, notExist, positionState, processML, remove, remove, remove, resetForRefreshOnSave, resetQbe, resetWithSelection, rollback, rollbackToCheckpoint, rollbackToCheckpoint, rollbackTransaction, save, save, save, save, saveMbos, saveTransaction, select, select, select, selectAll, setAllowQualifiedRestriction, setApp, setAppAlwaysFieldFlag, setAppWhere, setAutoKeyFlag, setDBFetchMaxRows, setDefaultOrderBy, setDefaultValue, setDefaultValue, setDefaultValues, setDefaultValues, setDMDeploySet, setDMSkipFieldValidation, setEAuditFieldModified, setERMEntity, setESigFieldModified, setExcludeMeFromPropagation, setFederatedResources, setFlag, setFlag, setFlags, setInsertCompanySet, setInsertItemSet, setInsertOrg, setInsertSite, setLastESigTransId, setLogLargFetchResultDisabled, setMboSetInfo, setMXTransaction, setNoNeedtoFetchFromDB, setOrderBy, setOrderByNVL, setOwner, setPreserveOrderByCase, setProxy, setQbe, setQbe, setQbe, setQbe, setQbe, setQbeCaseSensitive, setQbeCaseSensitive, setQbeExactMatch, setQbeExactMatch, setQbeOperatorOr, setQueryBySiteQbe, setQueryTimeout, setRelationName, setRelationship, setRequiedFlagsFromERM, setRetainMboPosition, setSetOrderByForUI, setSkipFirstNRows, setSQLOptions, setTableDomainLookup, setTxnPropertyMap, setupLongOpPipe, setUserWhere, setUserWhereAfterParse, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull, setWhere, setWhereQbe, smartFill, smartFill, smartFind, smartFind, smartFind, smartFind, sort, splitOrderBy, startCheckpoint, startCheckpoint, sum, toBeSaved, undeleteAll, undoTransaction, unselect, unselect, unselect, unselectAll, useStoredQuery, validate, validateTransaction, verifyESig

Methods inherited from class java.lang.Object

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

Methods inherited from interface psdi.mbo.MboSetRemote

abortSql, add, add, addAtEnd, addAtEnd, addAtIndex, addAtIndex, addFakeAtEnd, addSubQbe, addSubQbe, addSubQbe, addSubQbe, addWarning, addWarnings, checkMethodAccess, cleanup, clear, clearLongOpPipe, close, commit, copy, copy, copyForDM, count, count, deleteAll, deleteAll, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemoveAll, deleteAndRemoveAll, determineRequiredFieldsFromERM, earliestDate, fetchNext, findAllNullRequiredFields, findByIntegrationKey, findKey, getApp, getAppAlwaysFieldFlags, getAppWhere, getCompleteWhere, getCurrentPosition, getDBFetchMaxRows, getDefaultValue, getERMEntity, getESigTransactionId, getExcludeMeFromPropagation, getFlags, getKeyAttributes, getList, getList, getMaxMessage, getMbo, getMbo, getMboForUniqueId, getMboSetData, getMboSetData, getMboSetInfo, getMboSetRetainMboPositionData, getMboSetRetainMboPositionInfo, getMboSetValueData, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMLFromClause, getMXTransaction, getName, getOrderBy, getOwner, getParentApp, getProfile, getQbe, getQbe, getQbe, getQbeWhere, getQueryTimeout, getRelationName, getRelationship, getSelection, getSelectionWhere, getSetOrderByForUI, getSize, getSQLOptions, getTxnPropertyMap, getUserAndQbeWhere, getUserInfo, getUserName, getUserWhere, getWarnings, getWhere, getZombie, hasMLQbe, hasQbe, hasWarnings, ignoreQbeExactMatchSet, incrementDeletedCount, init, isBasedOn, isDMDeploySet, isDMSkipFieldValidation, isEmpty, isESigNeeded, isFlagSet, isQbeCaseSensitive, isQbeExactMatch, isRetainMboPosition, latestDate, locateMbo, logESigVerification, max, min, moveFirst, moveLast, moveNext, movePrev, moveTo, newMboIndex, notExist, positionState, processML, remove, remove, remove, resetQbe, resetWithSelection, rollback, rollbackToCheckpoint, rollbackToCheckpoint, save, save, select, select, select, selectAll, setAllowQualifiedRestriction, setApp, setAppAlwaysFieldFlag, setAppWhere, setAutoKeyFlag, setDBFetchMaxRows, setDefaultOrderBy, setDefaultValue, setDefaultValue, setDefaultValues, setDMDeploySet, setDMSkipFieldValidation, setERMEntity, setESigFieldModified, setExcludeMeFromPropagation, setFlag, setFlag, setFlags, setInsertCompanySet, setInsertItemSet, setInsertOrg, setInsertSite, setLastESigTransId, setLogLargFetchResultDisabled, setMboSetInfo, setMXTransaction, setNoNeedtoFetchFromDB, setOrderBy, setOwner, setQbe, setQbe, setQbe, setQbe, setQbe, setQbeCaseSensitive, setQbeCaseSensitive, setQbeExactMatch, setQbeExactMatch, setQbeOperatorOr, setQueryBySiteQbe, setQueryTimeout, setRelationName, setRelationship, setRequiedFlagsFromERM, setRetainMboPosition, setSetOrderByForUI, setSQLOptions, setTableDomainLookup, setTxnPropertyMap, setupLongOpPipe, setUserWhere, setUserWhereAfterParse, setWhere, setWhereQbe, smartFill, smartFill, smartFind, smartFind, startCheckpoint, startCheckpoint, sum, toBeSaved, undeleteAll, unselect, unselect, unselect, unselectAll, useStoredQuery, validate, verifyESig

Methods inherited from interface psdi.mbo.MboAccessInterface

getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getString, isNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull

Methods inherited from interface psdi.txn.Transactable

commitTransaction, fireEventsAfterDB, fireEventsAfterDBCommit, fireEventsBeforeDB, rollbackTransaction, saveTransaction, undoTransaction, validateTransaction

Constructor Detail

MRSet

public MRSet(MboServerInterface ms)
      throws MXException,
             java.rmi.RemoteException

Construct the set

Throws:

MXException

java.rmi.RemoteException

Method Detail

checkWFEnabled

public boolean checkWFEnabled()
                       throws java.rmi.RemoteException,
                              MXException

This method checks whether to start the workflow process. This method returns true, if workflow process needs to be started. Otherwise returns false.

Specified by:

checkWFEnabled in interface MRSetRemote

Returns:

isEnabled

Throws:

MXException

java.rmi.RemoteException

See Also:

checkWFEnabled()

reset

public void reset()
           throws MXException,
                  java.rmi.RemoteException

reset method is overriden to set back the flags related to WorkFlow to the default values.

Specified by:

reset in interface MboSetRemote

Overrides:

reset in class MboSet

Throws:

MXException

java.rmi.RemoteException

See Also:

MboSet.save()

findMR

public void findMR(java.lang.String mrnum)
            throws MXException,
                   java.rmi.RemoteException

Find an mr based on mrnum. This will reset this collection to contain the mr for the mrnum. If an mr was not found, this collection will be empty

Specified by:

findMR in interface MRSetRemote

Parameters:

mrnum - The Mrnum of the record to be found

Throws:

MXException

java.rmi.RemoteException

See Also:

findMR(java.lang.String)

findAllRecurringMRs

public void findAllRecurringMRs()
                         throws MXException,
                                java.rmi.RemoteException

Find all Recurring MR's. This will reset this collection to contain all mr's that are flagged as recurring

Specified by:

findAllRecurringMRs in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllRecurringMRs()

findAllOpenMRsForCurrentUser

public void findAllOpenMRsForCurrentUser()
                                  throws MXException,
                                         java.rmi.RemoteException

Finds all open mr's for the current user. This will reset this collection to contain open mr's created by the current user.

Specified by:

findAllOpenMRsForCurrentUser in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllOpenMRsForCurrentUser()

findAllMRsForCurrentUser

public void findAllMRsForCurrentUser()
                              throws MXException,
                                     java.rmi.RemoteException

Finds all mrs for the current user.

Specified by:

findAllMRsForCurrentUser in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllMRsForCurrentUser()

findAllOpenMRs

public void findAllOpenMRs()
                    throws MXException,
                           java.rmi.RemoteException

This method retrives all the open MRs in the database irrespective of the user who created it.It also includes the \ condition that the MRs are not waiting for approval do not have their history flags set(to "YES"). This method does not take into account the reccuring MRs. This Mbo set is reset to contain the new records.

Specified by:

findAllOpenMRs in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllOpenMRs()

findAllReceivingMRsForCurrentUser

public void findAllReceivingMRsForCurrentUser()
                                       throws MXException,
                                              java.rmi.RemoteException

This method retrieves all MRs created by the current user if those MRs satisfy the following condition

• They must have a corresponding POLINE with the receiptscomplete flag on this POLINE set to false. In other words the corresponding POLINE must have receipts pending against this MR

This MboSet is reset to contain the new records.

Specified by:

findAllReceivingMRsForCurrentUser in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllReceivingMRsForCurrentUser()

findAllReceivingMRs

public void findAllReceivingMRs()
                         throws MXException,
                                java.rmi.RemoteException

This method retrieves all MRs irrespective of the user who created it but the MR must satisfy the following condition

• They must have a corresponding POLINE with the receiptscomplete flag on this POLINE set to false. In other words the corresponding POLINE must have receipts pending against this MR

This Mbo set is reset to contain the new records.

Specified by:

findAllReceivingMRs in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllReceivingMRs()

findAllOpenMRsForPersonCode

public void findAllOpenMRsForPersonCode(java.lang.String personCode)
                                 throws MXException,
                                        java.rmi.RemoteException

Finds all open mr's for the specified user. This will reset this collection to contain open mr's created by the specified user.

Specified by:

findAllOpenMRsForPersonCode in interface MRSetRemote

Parameters:

PersonCode - The person id to be used

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllOpenMRsForPersonCode(java.lang.String)

findAllMRsForPersonCode

public void findAllMRsForPersonCode(java.lang.String personCode)
                             throws MXException,
                                    java.rmi.RemoteException

Finds all mrs for the specified user.

Specified by:

findAllMRsForPersonCode in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllOpenMRsForPersonCode(java.lang.String)

findAllDraftMRsForCurrentUser

public void findAllDraftMRsForCurrentUser()
                                   throws MXException,
                                          java.rmi.RemoteException

Finds all draft mr's for the current user. This will reset this collection to contain draft mr's created by the current user.

Specified by:

findAllDraftMRsForCurrentUser in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllDraftMRsForCurrentUser()

findAllDraftMRsForPersonCode

public void findAllDraftMRsForPersonCode(java.lang.String personCode)
                                  throws MXException,
                                         java.rmi.RemoteException

Finds all draft mr's for the specified user. This will reset this collection to contain draft mr's created by the specified user.

Specified by:

findAllDraftMRsForPersonCode in interface MRSetRemote

Parameters:

personCode - The person id to be used

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllDraftMRsForPersonCode(java.lang.String)

findAllRecurringMRsForCurrentUser

public void findAllRecurringMRsForCurrentUser()
                                       throws MXException,
                                              java.rmi.RemoteException

Finds all recurring mr's for the current user. This will reset this collection to contain recurring mr's created by the current user.

Specified by:

findAllRecurringMRsForCurrentUser in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllRecurringMRsForCurrentUser()

findAllRecurringMRsForPersonCode

public void findAllRecurringMRsForPersonCode(java.lang.String personId)
                                      throws MXException,
                                             java.rmi.RemoteException

Finds all recurring mr's for the specified user. This will reset this collection to contain recurring mr's created by the specified user.

Specified by:

findAllRecurringMRsForPersonCode in interface MRSetRemote

Parameters:

personId -

Throws:

MXException

java.rmi.RemoteException

See Also:

findAllRecurringMRsForPersonCode(java.lang.String)

deleteInvReserves

public void deleteInvReserves()
                       throws MXException,
                              java.rmi.RemoteException

When a work order is cancelled, unapproved, or completed/closed, all of the InvReserve Mbos are deleted. This method accomplishes this.

Specified by:

deleteInvReserves in interface MRSetRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

This method is called to delete the correct reserves.