eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TYPE: SYSTEM.WIP_LOT_SERIAL_OBJ_T

Object Details

Object Name:	WIP_LOT_SERIAL_OBJ_T
Object Type:	TYPE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
LOT_ITERATOR_PVT	INTEGER
ITEM_ITERATOR_PVT	INTEGER
SERIAL_ITERATOR_PVT	INTEGER
ITEMS	WIP_COMPONENT_TBL_T
LOTS	WIP_TXN_LOT_TBL_T
SERIALS	WIP_TXN_SERIAL_TBL_T

Methods

Name	Parameters	Result
INITIALIZE	SELF(WIP_LOT_SERIAL_OBJ_T)
RESET	SELF(WIP_LOT_SERIAL_OBJ_T)
SETNEXTITEM	SELF(WIP_LOT_SERIAL_OBJ_T)	PL/SQL BOOLEAN
SETCURRENTITEM	SELF(WIP_LOT_SERIAL_OBJ_T) P_INDEX(NUMBER)	PL/SQL BOOLEAN
GETCURRENTITEM	SELF(WIP_LOT_SERIAL_OBJ_T) X_ITEM(WIP_COMPONENT_OBJ_T)	PL/SQL BOOLEAN
SETNEXTLOT	SELF(WIP_LOT_SERIAL_OBJ_T)	PL/SQL BOOLEAN
SETCURRENTLOT	SELF(WIP_LOT_SERIAL_OBJ_T) P_INDEX(NUMBER)	PL/SQL BOOLEAN
GETNEXTLOT	SELF(WIP_LOT_SERIAL_OBJ_T) X_LOT(WIP_TXN_LOT_OBJ_T)	PL/SQL BOOLEAN
ADDLOT	SELF(WIP_LOT_SERIAL_OBJ_T) P_LOTNUMBER(VARCHAR2) P_PRIQTY(NUMBER) P_ATTRIBUTES(WIP_LOT_ATTRIBUTES_OBJ_T)
GETNEXTSERIAL	SELF(WIP_LOT_SERIAL_OBJ_T) X_SERIAL(WIP_TXN_SERIAL_OBJ_T)	PL/SQL BOOLEAN
GETNEXTLOTSERIAL	SELF(WIP_LOT_SERIAL_OBJ_T) X_SERIAL(WIP_TXN_SERIAL_OBJ_T)	PL/SQL BOOLEAN
ADDSERIAL	SELF(WIP_LOT_SERIAL_OBJ_T) P_FMSERIAL(VARCHAR2) P_TOSERIAL(VARCHAR2) P_PARENTSERIAL(VARCHAR2) P_PRIQTY(NUMBER) P_ATTRIBUTES(WIP_SERIAL_ATTRIBUTES_OBJ_T)
ADDLOTSERIAL	SELF(WIP_LOT_SERIAL_OBJ_T) P_FMSERIAL(VARCHAR2) P_TOSERIAL(VARCHAR2) P_PARENTSERIAL(VARCHAR2) P_PRIQTY(NUMBER) P_ATTRIBUTES(WIP_SERIAL_ATTRIBUTES_OBJ_T)
ADDITEM	SELF(WIP_LOT_SERIAL_OBJ_T) P_OPSEQNUM(NUMBER) P_ITEMID(NUMBER) P_ITEMNAME(VARCHAR2) P_PRIQTY(NUMBER) P_PRIUOMCODE(VARCHAR2) P_SUPPLYSUBINV(VARCHAR2) P_SUPPLYLOCID(NUMBER) P_WIPSUPPLYTYPE(NUMBER) P_TXNACTIONID(NUMBER) P_MTLTXNSENABLEDFLAG(VARCHAR2) P_REVISION(VARCHAR2) P_LOTCONTROLCODE(NUMBER) P_SERIALCONTROLCODE(NUMBER) P_GENERICID(NUMBER) P_DEPARTMENTID(NUMBER) P_RESTRICTSUBSCODE(NUMBER) P_RESTRICTLOCSCODE(NUMBER) P_PROJECTID(NUMBER) P_TASKID(NUMBER) P_COMPONENTSEQID(NUMBER) P_CMPTXNID(NUMBER) P_ITEMDESCRIPTION(VARCHAR2) P_LOCATORNAME(VARCHAR2) P_REVISIONCONTOLCODE(NUMBER) P_LOCATIONCONTROLCODE(NUMBER) P_LOCATORPROJECTID(NUMBER) P_LOCATORTASKID(NUMBER)
SETREVISION	SELF(WIP_LOT_SERIAL_OBJ_T) P_REVISION(VARCHAR2)

Dependencies

[top of page]

SYSTEM.WIP_LOT_SERIAL_OBJ_T references the following:

SYS: STANDARD - show dependent code
SYSTEM: WIP_COMPONENT_OBJ_T; WIP_COMPONENT_TBL_T; WIP_LOT_ATTRIBUTES_OBJ_T; WIP_SERIAL_ATTRIBUTES_OBJ_T; WIP_TXN_LOT_OBJ_T; WIP_TXN_LOT_TBL_T; WIP_TXN_SERIAL_OBJ_T; WIP_TXN_SERIAL_TBL_T

SYSTEM.WIP_LOT_SERIAL_OBJ_T is referenced by following:

APPS: FLM_EXECUTION_UTIL - show dependent code; FLM_EXECUTION_UTIL - show dependent code; WIP_AUTOLOTPROC_PRIV - show dependent code; WIP_AUTOLOTPROC_PRIV - show dependent code; WIP_AUTOSERIALPROC_PRIV - show dependent code; WIP_AUTOSERIALPROC_PRIV - show dependent code; WIP_BFLPROC_PRIV - show dependent code; WIP_BFLPROC_PRIV - show dependent code; WIP_DISCRETE_WS_MOVE - show dependent code; WIP_DISCRETE_WS_MOVE - show dependent code; WIP_FLOW_UTILITIES - show dependent code; WIP_MOVPROC_GRP - show dependent code; WIP_MOVPROC_GRP - show dependent code; WMA_COMPLETION - show dependent code; WMA_COMPLETION - show dependent code; WMA_FLOW - show dependent code; WMA_FLOW - show dependent code; WMA_MOVE - show dependent code; WMA_MOVE - show dependent code
SYSTEM: WIP_LOT_SERIAL_OBJ_T