1 PACKAGE WMS_Data_Type_Definitions_PUB AS
2 /* $Header: WMSPDTDS.pls 120.3 2005/10/18 07:39:48 methomas noship $ */
3 -- Basic Table Types
4 TYPE NumberTableType IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE Varchar2_3_TableType IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
6 TYPE Varchar2_10_TableType IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
7 TYPE Varchar2_30_TableType IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
8 TYPE Varchar2_150_TableType IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
9
10 TYPE LPNRecordType is RECORD (
11 LPN_ID NUMBER
12 , LICENSE_PLATE_NUMBER VARCHAR2(30)
13 , PARENT_LPN_ID NUMBER
14 , OUTERMOST_LPN_ID NUMBER
15 , LPN_CONTEXT NUMBER
16
17 , ORGANIZATION_ID NUMBER
18 , SUBINVENTORY_CODE VARCHAR2(10)
19 , LOCATOR_ID NUMBER
20
21 , INVENTORY_ITEM_ID NUMBER
22 , REVISION VARCHAR2(3)
23 -- Increased lot size to 80 Char - Mercy Thomas - B4625329
24 , LOT_NUMBER VARCHAR2(80)
25 , SERIAL_NUMBER VARCHAR2(30)
26 , COST_GROUP_ID NUMBER
27
28 , TARE_WEIGHT_UOM_CODE VARCHAR2(3)
29 , TARE_WEIGHT NUMBER
30 , GROSS_WEIGHT_UOM_CODE VARCHAR2(3)
31 , GROSS_WEIGHT NUMBER
32 , CONTAINER_VOLUME_UOM VARCHAR2(3)
33 , CONTAINER_VOLUME NUMBER
34 , CONTENT_VOLUME_UOM_CODE VARCHAR2(3)
35 , CONTENT_VOLUME NUMBER
36
37 , SOURCE_TYPE_ID NUMBER
38 , SOURCE_HEADER_ID NUMBER
39 , SOURCE_LINE_ID NUMBER
40 , SOURCE_LINE_DETAIL_ID NUMBER
41 , SOURCE_NAME VARCHAR2(30)
42 , SOURCE_TRANSACTION_ID NUMBER
43 , REFERENCE_ID NUMBER
44
45 , ATTRIBUTE_CATEGORY VARCHAR2(30)
46 , ATTRIBUTE1 VARCHAR2(150)
47 , ATTRIBUTE2 VARCHAR2(150)
48 , ATTRIBUTE3 VARCHAR2(150)
49 , ATTRIBUTE4 VARCHAR2(150)
50 , ATTRIBUTE5 VARCHAR2(150)
51 , ATTRIBUTE6 VARCHAR2(150)
52 , ATTRIBUTE7 VARCHAR2(150)
53 , ATTRIBUTE8 VARCHAR2(150)
54 , ATTRIBUTE9 VARCHAR2(150)
55 , ATTRIBUTE10 VARCHAR2(150)
56 , ATTRIBUTE11 VARCHAR2(150)
57 , ATTRIBUTE12 VARCHAR2(150)
58 , ATTRIBUTE13 VARCHAR2(150)
59 , ATTRIBUTE14 VARCHAR2(150)
60 , ATTRIBUTE15 VARCHAR2(150)
61 );
62
63 TYPE LPNTableType IS TABLE OF LPNRecordType INDEX BY BINARY_INTEGER;
64
65 TYPE SerialRangeRecordType is RECORD (
66 FM_SERIAL_NUMBER VARCHAR2(30)
67 , TO_SERIAL_NUMBER VARCHAR2(30)
68 , PREFIX VARCHAR2(30)
69 , QUANTITY NUMBER
70 , FM_NUMBER NUMBER
71 , TO_NUMBER NUMBER );
72
73 TYPE SerialRangeTableType IS TABLE OF SerialRangeRecordType INDEX BY BINARY_INTEGER;
74
75 TYPE LPNPurgeRecordType is RECORD (
76 LPN_IDs NumberTableType
77 );
78
79 TYPE AutoCreateLPNRecordType is RECORD (
80 SOURCE_TRANSACTION_ID NUMBER
81 , ORGANIZATION_ID NUMBER
82 , SUBINVENTORY_CODE VARCHAR2(30)
83 , LOCATOR_ID NUMBER
84 , CONTAINER_ITEM_ID NUMBER
85 , LPN_PREFIX VARCHAR2(30)
86 , LPN_SUFFIX VARCHAR2(30)
87 , STARTING_NUM NUMBER
88 , QUANTITY NUMBER
89 , LPN_CONTEXT NUMBER
90 , TOTAL_LPN_LENGTH NUMBER
91 , UCC_128_SUFFIX_FLAG NUMBER );
92
93 END WMS_Data_Type_Definitions_PUB;