...
Tables involved as per the requirement given in LocationhandlinginOLE.pdf and JIRA No. OLE-2558 OLE_LOCN_LEVEL_T and OLE_LOCN_T
OLE_LOCN_LEVEL_T:
...
- LEVEL_ID – varchar2(40)(Primary key)
...
- OBJ_ID – varchar2(Not Null)
...
- VER_NBR – Number(8)(Not Null)
...
- LEVEL_CD – varchar2(40)(Unique & Not Null)
...
- LEVEL_NAME – varchar2(100)(Not Null)
...
- PARENT_LEVEL – varchar2(40) (Nullable) - References OLE_LOCN_LEVEL_T.LEVEL_ID. Varchar2(40)
OLE_LOCN_T:
- * *LOCN_ID - varchar2(40)(Primary Key)
- OBJ_ID – varchar2(36)(Not Null)
- VER_NBR – Number(8)(Not Null)
- LOCN_CD – varchar2(40)(Unique & Not Null)
- LOCN_NAME – varchar2(200)(Not Null)
- LEVEL_ID - varchar2(40)(Not Null) - References OLE_LOCN_LEVEL_T.LEVEL_ID.
- PARENT_LOCN_ID – varchar2(40)(Nullable)- References OLE_LOCN_T.LOCN_ID
Tests :
Location_UT.java
- testSave
- testFindMatching
- testDelete
LocationLevel_UT.java
- testSave
- testFindMatching
- testDelete
Issues :
NA
...