[Home] [Help]
PACKAGE: APPS.EAM_EST_DATASTRUCTURES_PUB
Source
1 PACKAGE EAM_EST_DATASTRUCTURES_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPEDSS.pls 120.0.12010000.3 2009/01/03 00:12:17 devijay noship $ */
3 -- Start of Comments
4 -- Package name : EAM_EST_DATASTRUCTURES_PUB
5 -- Purpose : Package Specification for Construction estimate DS
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 G_PKG_NAME CONSTANT VARCHAR2(30) := 'EAM_EST_DATASTRUCTURES_PUB';
11 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EAMPEDSS.pls';
12
13 TYPE EAM_CE_MESSAGE_REC IS RECORD
14 ( ORGANIZATION_ID NUMBER,
15 ESTIMATE_ID VARCHAR2(3),
16 MESSAGE_TEXT VARCHAR2(2000),
17 ROW_REFERENCE NUMBER,
18 MESSAGE_CODE VARCHAR2(30),
19 MESSAGE_TYPE VARCHAR2(1)
20 );
21
22 TYPE EAM_CE_MESSAGE_TBL IS TABLE OF EAM_CE_MESSAGE_REC
23 INDEX BY BINARY_INTEGER;
24
25 --+=================================================================+
26 --| Record Name : EAM_CE_WO_DEFAULTS_REC |
27 --| Description : Work Order defaults record |
28 --+=================================================================+
29 TYPE EAM_CE_WO_DEFAULTS_REC IS RECORD
30 (
31 ESTIMATE_ID NUMBER,
32 DEFAULT_WORK_ORDER_NUMBER VARCHAR2(30) := NULL,
33 ORGANIZATION_ID NUMBER,
34 ASSET_GROUP_ID NUMBER,
35 ASSET_NUMBER VARCHAR2(30) := NULL,
36 MAINTENANCE_OBJECT_ID NUMBER,
37 MAINTENANCE_OBJECT_TYPE NUMBER,
38 MAINTENANCE_OBJECT_SOURCE NUMBER,
39 WORK_ORDER_DESCRIPTION VARCHAR2(240):= NULL,
40 ACCT_CLASS_CODE VARCHAR2(10) := NULL,
41 PROJECT_ID NUMBER,
42 TASK_ID NUMBER,
43 SCHEDULED_START_DATE DATE,
44 SCHEDULED_COMPLETION_DATE DATE,
45 USER_DEFINED_STATUS_ID NUMBER,
46 GROUPING_OPTION NUMBER
47 );
48
49 TYPE EAM_CE_PARENT_WO_REC IS RECORD
50 (
51 ESTIMATE_ID NUMBER,
52 PARENT_WORK_ORDER_NUMBER VARCHAR2(30) := NULL,
53 ORGANIZATION_ID NUMBER,
54 ASSET_GROUP_ID NUMBER,
55 ASSET_NUMBER VARCHAR2(30) := NULL,
56 MAINTENANCE_OBJECT_ID NUMBER,
57 MAINTENANCE_OBJECT_TYPE NUMBER,
58 MAINTENANCE_OBJECT_SOURCE NUMBER,
59 WORK_ORDER_DESCRIPTION VARCHAR2(240):= NULL,
60 ACCT_CLASS_CODE VARCHAR2(10) := NULL,
61 PROJECT_ID NUMBER,
62 TASK_ID NUMBER,
63 SCHEDULED_START_DATE DATE,
64 SCHEDULED_COMPLETION_DATE DATE,
65 STATUS_TYPE NUMBER,
66 CREATE_PARENT_FLAG VARCHAR2(1) := NULL,
67 OWNING_DEPARTMENT_ID NUMBER
68 );
69
70 TYPE EAM_CONSTRUCTION_ESTIMATE_REC IS RECORD
71 (
72 ESTIMATE_ID NUMBER,
73 ORGANIZATION_ID NUMBER,
74 ESTIMATE_NUMBER VARCHAR2(30),
75 ESTIMATE_DESCRIPTION VARCHAR2(240),
76 GROUPING_OPTION NUMBER,
77 PARENT_WO_ID NUMBER,
78 CREATE_PARENT_WO_FLAG VARCHAR2(1),
79 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
95 );
96
97 TYPE EAM_CONSTRUCTION_ESTIMATE_TBL IS TABLE OF EAM_CONSTRUCTION_ESTIMATE_REC INDEX BY BINARY_INTEGER;
98
99 TYPE EAM_CONSTRUCTION_UNITS_REC IS RECORD
100 (
101 CU_ID NUMBER,
102 CU_NAME VARCHAR2(50),
103 DESCRIPTION VARCHAR2(240),
104 ORGANIZATION_ID NUMBER,
105 CU_EFFECTIVE_FROM DATE,
106 CU_EFFECTIVE_TO DATE
107 );
108
109 TYPE EAM_CONSTRUCTION_UNITS_TBL IS TABLE OF EAM_CONSTRUCTION_UNITS_REC INDEX BY BINARY_INTEGER;
110
111 TYPE EAM_ESTIMATE_ASSOCIATIONS_REC IS RECORD
112 (
113 ESTIMATE_ASSOCIATION_ID NUMBER,
114 ORGANIZATION_ID NUMBER,
115 ESTIMATE_ID NUMBER,
116 CU_ID NUMBER,
117 CU_QTY NUMBER,
118 CU_NAME VARCHAR2(50),
119 CU_DESCRIPTION VARCHAR2(240),
120 ACCT_CLASS_CODE VARCHAR2(10),
121 ACTIVITY_ID NUMBER,
122 ACTIVITY_NAME VARCHAR2(40),
123 ACTIVITY_DESCRIPTION VARCHAR2(240),
124 ACTIVITY_QTY NUMBER,
125 DIFFICULTY_ID NUMBER,
126 RESOURCE_MULTIPLIER NUMBER
127 );
128
129 TYPE EAM_ESTIMATE_ASSOCIATIONS_TBL IS TABLE OF EAM_ESTIMATE_ASSOCIATIONS_REC INDEX BY BINARY_INTEGER;
130
131 TYPE EAM_CE_WORK_ORDER_LINES_REC IS RECORD
132 (
133 ESTIMATE_WORK_ORDER_LINE_ID NUMBER,
134 SRC_CU_ID NUMBER,
135 SRC_ACTIVITY_ID NUMBER,
136 SRC_ACTIVITY_QTY NUMBER,
137 SRC_OP_SEQ_NUM NUMBER,
138 SRC_ACCT_CLASS_CODE VARCHAR2(10) := NULL,
139 ESTIMATE_ID NUMBER,
140 ORGANIZATION_ID NUMBER,
141 WORK_ORDER_SEQ_NUM NUMBER,
142 WORK_ORDER_NUMBER VARCHAR2(30) := NULL,
143 WORK_ORDER_DESCRIPTION VARCHAR2(240):= NULL,
144 REF_WIP_ENTITY_ID NUMBER,
145 PRIMARY_ITEM_ID NUMBER,
146 STATUS_TYPE NUMBER,
150 PROJECT_ID NUMBER,
147 ACCT_CLASS_CODE VARCHAR2(10) := NULL,
148 SCHEDULED_START_DATE DATE,
149 SCHEDULED_COMPLETION_DATE DATE,
151 TASK_ID NUMBER,
152 MAINTENANCE_OBJECT_ID NUMBER,
153 MAINTENANCE_OBJECT_TYPE NUMBER,
154 MAINTENANCE_OBJECT_SOURCE NUMBER,
155 OWNING_DEPARTMENT_ID NUMBER,
156 USER_DEFINED_STATUS_ID NUMBER,
157 OP_SEQ_NUM NUMBER,
158 OP_DESCRIPTION VARCHAR2(240):= NULL,
159 STANDARD_OPERATION_ID NUMBER,
160 OP_DEPARTMENT_ID NUMBER,
161 OP_LONG_DESCRIPTION VARCHAR2(4000):= NULL,
162 RES_SEQ_NUM NUMBER,
163 RES_ID NUMBER,
164 RES_UOM VARCHAR2(3) := NULL,
165 RES_BASIS_TYPE NUMBER,
166 RES_USAGE_RATE_OR_AMOUNT NUMBER,
167 RES_REQUIRED_UNITS NUMBER,
168 RES_ASSIGNED_UNITS NUMBER,
169 ITEM_TYPE NUMBER,
170 REQUIRED_QUANTITY NUMBER,
171 UNIT_PRICE NUMBER,
172 UOM VARCHAR2(3) := NULL,
173 BASIS_TYPE NUMBER,
174 SUGGESTED_VENDOR_NAME VARCHAR2(240):= NULL,
175 SUGGESTED_VENDOR_ID NUMBER,
176 SUGGESTED_VENDOR_SITE VARCHAR2(15):=NULL,
177 SUGGESTED_VENDOR_SITE_ID NUMBER,
178 MAT_INVENTORY_ITEM_ID NUMBER,
179 MAT_COMPONENT_SEQ_NUM NUMBER,
180 MAT_SUPPLY_SUBINVENTORY VARCHAR2(10):=NULL,
181 MAT_SUPPLY_LOCATOR_ID NUMBER,
182 DI_AMOUNT NUMBER,
183 DI_ORDER_TYPE_LOOKUP_CODE VARCHAR2(25):=NULL,
184 DI_DESCRIPTION VARCHAR2(240):=NULL,
185 DI_PURCHASE_CATEGORY_ID NUMBER,
186 DI_AUTO_REQUEST_MATERIAL VARCHAR2(1):=NULL,
187 DI_NEED_BY_DATE DATE,
188 WORK_ORDER_LINE_COST NUMBER,
189 DIFFICULTY_QTY NUMBER,
190 DIFFICULTY_ID NUMBER,
191 CU_QTY NUMBER,
192 ITEM_COMMENTS VARCHAR2(240),
193 WORK_ORDER_TYPE NUMBER,
194 ACTIVITY_TYPE NUMBER,
195 ACTIVITY_CAUSE NUMBER,
196 ACTIVITY_SOURCE NUMBER,
197 AVAILABLE_QUANTITY NUMBER,
198 RES_SCHEDULED_FLAG NUMBER
199 );
200
201 TYPE EAM_CE_WORK_ORDER_LINES_TBL IS TABLE OF EAM_CE_WORK_ORDER_LINES_REC
202 INDEX BY BINARY_INTEGER;
203
204 End EAM_EST_DATASTRUCTURES_PUB;