[Home] [Help]
PACKAGE: APPS.EAM_LINEAR_LOCATIONS_PUB
Source
1 PACKAGE eam_linear_locations_pub AS
2 /* $Header: EAMPELLS.pls 120.0 2005/05/25 16:01:37 appldev noship $*/
3 -- Start of comments
4 -- API name : eam_linear_locations_pub
5 -- Type : Public.
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN p_api_version IN NUMBER Required
10 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13 -- parameter1
14 -- parameter2
15 -- .
16 -- .
17 -- OUT x_return_status OUT VARCHAR2(1)
18 -- x_msg_count OUT NUMBER
19 -- x_msg_data OUT VARCHAR2(2000)
20 -- parameter1
21 -- parameter2
22 -- .
23 -- .
24 -- Version Current version x.x
25 -- Changed....
26 -- previous version y.y
27 -- Changed....
28 -- .
29 -- .
30 -- previous version 2.0
31 -- Changed....
32 -- Initial version 1.0
33 --
34 -- Notes : Note text
35 --
36 -- End of comments
37
38 TYPE bom_departments_record is RECORD
39 (
40 Department_Id bom_departments.department_id%type,
41 Department_Code bom_departments.department_code%type,
42 Description bom_departments.description%type,
43 Organization_Id bom_departments.organization_id%type
44
45 );
46
47 Type Bom_Departments_Table is TABLE of bom_departments_record index by binary_integer;
48
49 TYPE Org_Access_Record is record
50 (
51 Organization_Id Number,
52 Organization_Code Varchar2(3),
53 Organization_Name Varchar2(240)
54
55 );
56
57 TYPE Org_Access_Table is TABLE of Org_Access_Record index by binary_integer;
58
59 TYPE Work_Request_Record is record
60 (
61 Work_Request_Number Number,
62 Asset_Number Varchar2(80),
63 ORGANIZATION_CODE varchar2(3),
64 Organization_Name varchar2(240),
65 work_request_status varchar2(80),
66 work_request_priority varchar2(80),
67 owning_dept_code varchar2(80),
68 owning_dept_description varchar2(80),
69 EXPECTED_RESOLUTION_DATE DATE,
70 work_order varchar2(80),
71 DESCRIPTION VARCHAR2(240),
72 WORK_REQUEST_TYPE VARCHAR2(80),
73 PHONE_NUMBER VARCHAR2(4000),
74 E_MAIL VARCHAR2(240),
75 CONTACT_PREFERENCE NUMBER(30,0)
76 );
77
78 TYPE Work_Request_Table is TABLE of Work_Request_Record index by binary_integer;
79
80
81 Type Work_Order_Record is record
82 ( HEADER_ID NUMBER :=null,
83 BATCH_ID NUMBER :=null,
84 ROW_ID NUMBER :=null,
85 WIP_ENTITY_NAME VARCHAR2(240) :=null,
86 WIP_ENTITY_ID NUMBER :=null,
87 ORGANIZATION_ID NUMBER :=null,
88 DESCRIPTION VARCHAR2(240) :=null,
89 ASSET_NUMBER VARCHAR2(30) :=null,
90 ASSET_GROUP_ID NUMBER :=null,
91 REBUILD_ITEM_ID NUMBER :=null,
92 REBUILD_SERIAL_NUMBER VARCHAR2(30) :=null,
93 MAINTENANCE_OBJECT_ID NUMBER :=null,
94 MAINTENANCE_OBJECT_TYPE NUMBER :=null,
95 MAINTENANCE_OBJECT_SOURCE NUMBER :=null,
96 EAM_LINEAR_LOCATION_ID NUMBER :=null,
97 CLASS_CODE VARCHAR2(10) :=null,
98 ASSET_ACTIVITY_ID NUMBER :=null,
99 ACTIVITY_TYPE VARCHAR2(30) :=null,
100 ACTIVITY_CAUSE VARCHAR2(30) :=null,
101 ACTIVITY_SOURCE VARCHAR2(30) :=null,
102 WORK_ORDER_TYPE VARCHAR2(30) :=null,
103 STATUS_TYPE NUMBER :=null,
104 WO_STATUS VARCHAR2(80) :=null,
105 JOB_QUANTITY NUMBER :=null,
106 DATE_RELEASED DATE :=null,
107 OWNING_DEPARTMENT NUMBER :=null,
108 PRIORITY NUMBER :=null,
109 REQUESTED_START_DATE DATE :=null,
110 DUE_DATE DATE :=null,
111 SHUTDOWN_TYPE VARCHAR2(30) :=null,
112 FIRM_PLANNED_FLAG NUMBER :=null,
113 NOTIFICATION_REQUIRED VARCHAR2(1) :=null,
114 TAGOUT_REQUIRED VARCHAR2(1) :=null,
115 PLAN_MAINTENANCE VARCHAR2(1) :=null,
116 PROJECT_ID NUMBER :=null,
117 TASK_ID NUMBER :=null,
118 END_ITEM_UNIT_NUMBER VARCHAR2(30) :=null,
119 SCHEDULE_GROUP_ID NUMBER :=null,
120 BOM_REVISION_DATE DATE :=null,
121 ROUTING_REVISION_DATE DATE :=null,
122 ALTERNATE_ROUTING_DESIGNATOR VARCHAR2(10) :=null,
123 ALTERNATE_BOM_DESIGNATOR VARCHAR2(10) :=null,
124 ROUTING_REVISION VARCHAR2(3) :=null,
125 BOM_REVISION VARCHAR2(3) :=null,
126 PARENT_WIP_ENTITY_ID NUMBER :=null,
127 MANUAL_REBUILD_FLAG VARCHAR2(1) :=null,
128 PM_SCHEDULE_ID NUMBER :=null,
129 WIP_SUPPLY_TYPE NUMBER :=null,
130 MATERIAL_ACCOUNT NUMBER :=null,
131 MATERIAL_OVERHEAD_ACCOUNT NUMBER :=null,
132 RESOURCE_ACCOUNT NUMBER :=null,
133 OUTSIDE_PROCESSING_ACCOUNT NUMBER :=null,
134 MATERIAL_VARIANCE_ACCOUNT NUMBER :=null,
135 RESOURCE_VARIANCE_ACCOUNT NUMBER :=null,
136 OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER :=null,
137 STD_COST_ADJUSTMENT_ACCOUNT NUMBER :=null,
138 OVERHEAD_ACCOUNT NUMBER :=null,
139 OVERHEAD_VARIANCE_ACCOUNT NUMBER :=null,
140 SCHEDULED_START_DATE DATE :=null,
141 SCHEDULED_COMPLETION_DATE DATE :=null,
142 COMMON_BOM_SEQUENCE_ID NUMBER :=null,
143 COMMON_ROUTING_SEQUENCE_ID NUMBER :=null,
144 PO_CREATION_TIME NUMBER :=null,
145 GEN_OBJECT_ID NUMBER :=null,
146 RUN_SCHEDULER VARCHAR2(1) :=null,
147 ATTRIBUTE_CATEGORY VARCHAR2(30) :=null,
148 ATTRIBUTE1 VARCHAR2(150) :=null,
149 ATTRIBUTE2 VARCHAR2(150) :=null,
150 ATTRIBUTE3 VARCHAR2(150) :=null,
151 ATTRIBUTE4 VARCHAR2(150) :=null,
152 ATTRIBUTE5 VARCHAR2(150) :=null,
153 ATTRIBUTE6 VARCHAR2(150) :=null,
154 ATTRIBUTE7 VARCHAR2(150) :=null,
155 ATTRIBUTE8 VARCHAR2(150) :=null,
156 ATTRIBUTE9 VARCHAR2(150) :=null,
157 ATTRIBUTE10 VARCHAR2(150) :=null,
158 ATTRIBUTE11 VARCHAR2(150) :=null,
159 ATTRIBUTE12 VARCHAR2(150) :=null,
160 ATTRIBUTE13 VARCHAR2(150) :=null,
161 ATTRIBUTE14 VARCHAR2(150) :=null,
162 ATTRIBUTE15 VARCHAR2(150) :=null,
163 MATERIAL_ISSUE_BY_MO VARCHAR2(1) :=null,
164 ISSUE_ZERO_COST_FLAG VARCHAR2(1) :=null,
165 USER_ID NUMBER :=null,
166 RESPONSIBILITY_ID NUMBER :=null,
167 REQUEST_ID NUMBER :=null,
168 PROGRAM_ID NUMBER :=null,
169 PROGRAM_APPLICATION_ID NUMBER :=null,
170 SOURCE_LINE_ID NUMBER :=null,
171 SOURCE_CODE VARCHAR2(30) :=null,
172 VALIDATE_STRUCTURE VARCHAR2(1) :='N',
173 RETURN_STATUS VARCHAR2(1) :=null,
174 TRANSACTION_TYPE NUMBER :=null
175 );
176
177 TYPE Work_Order_Table is TABLE of Work_Order_Record index by binary_integer;
178
179
180 PROCEDURE insert_row
181 (
182 p_api_version IN NUMBER
183 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
184 ,p_commit IN VARCHAR2 := fnd_api.g_false
185 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
186 ,p_external_linear_id IN NUMBER
187 ,p_external_linear_name IN VARCHAR2
188 ,p_external_source_name IN VARCHAR2
189 ,p_external_linear_type IN VARCHAR2
190 ,x_eam_linear_id OUT NOCOPY NUMBER
191 ,x_return_status OUT NOCOPY VARCHAR2
192 ,x_msg_count OUT NOCOPY NUMBER
193 ,x_msg_data OUT NOCOPY VARCHAR2
194 );
195
196
197 PROCEDURE update_row
198 (
199 p_api_version IN NUMBER
200 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
201 ,p_commit IN VARCHAR2 := fnd_api.g_false
202 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
203 ,p_external_linear_id IN NUMBER
204 ,p_external_linear_name IN VARCHAR2
205 ,p_external_source_name IN VARCHAR2
206 ,p_external_linear_type IN VARCHAR2
207 ,p_eam_linear_id IN NUMBER
208 ,x_return_status OUT NOCOPY VARCHAR2
209 ,x_msg_count OUT NOCOPY NUMBER
210 ,x_msg_data OUT NOCOPY VARCHAR2
211 );
212
213
214 PROCEDURE get_eam_linear_id
215 (
216 p_api_version IN NUMBER
217 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
218 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
219 ,p_external_linear_id IN NUMBER
220 ,p_external_source_name IN VARCHAR2
221 ,p_external_linear_type IN VARCHAR2
222 ,x_eam_linear_id OUT NOCOPY NUMBER
223 ,x_return_status OUT NOCOPY VARCHAR2
224 ,x_msg_count OUT NOCOPY NUMBER
225 ,x_msg_data OUT NOCOPY VARCHAR2
226 );
227
228 procedure create_asset(
229 p_api_version IN NUMBER
230 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
231 ,p_commit IN VARCHAR2 := fnd_api.g_false
232 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
233 ,p_external_linear_id IN NUMBER
234 ,p_external_linear_name IN VARCHAR2
235 ,p_external_source_name IN VARCHAR2
236 ,p_external_linear_type IN VARCHAR2
237 ,p_serial_number IN VARCHAR2
238 ,p_user_name IN VARCHAR2
239 ,p_inventory_item_id IN NUMBER
240 ,p_current_organization_id IN NUMBER
241 ,p_owning_department_id IN NUMBER
242 ,p_descriptive_text IN VARCHAR2
243 ,x_object_id OUT NOCOPY VARCHAR2
244 ,x_return_status OUT NOCOPY VARCHAR2
245 ,x_msg_count OUT NOCOPY NUMBER
246 ,x_msg_data OUT NOCOPY VARCHAR2
247 );
248
249 procedure create_work_request(
250 p_api_version IN NUMBER
251 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
252 ,p_commit IN VARCHAR2 := fnd_api.g_false
253 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
254 ,p_external_linear_id IN NUMBER
255 ,p_external_linear_name IN VARCHAR2
256 ,p_external_source_name IN VARCHAR2
257 ,p_external_linear_type IN VARCHAR2
258 ,p_work_request_rec IN WIP_EAM_WORK_REQUESTS%ROWTYPE
259 ,p_user_name IN VARCHAR2
260 ,p_mode IN VARCHAR2
261 ,p_request_log IN VARCHAR2
262 ,x_work_request_id OUT NOCOPY VARCHAR2
263 ,x_return_status OUT NOCOPY VARCHAR2
264 ,x_msg_count OUT NOCOPY NUMBER
265 ,x_msg_data OUT NOCOPY VARCHAR2
266 );
267
268
269
270
271 PROCEDURE CREATE_EAM_WO
272 ( p_bo_identifier IN VARCHAR2 := 'EAM'
273 , p_api_version IN NUMBER := 1.0
274 , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
275 , p_commit IN VARCHAR2 := fnd_api.g_false
276 , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
277 , p_external_source_name IN VARCHAR2
278 , p_external_linear_type IN VARCHAR2 := 'ASSET'
279 , p_external_linear_name IN VARCHAR2
280 , p_external_linear_id IN NUMBER
281 , p_user_name IN VARCHAR2
282 , x_wip_entity_id OUT NOCOPY NUMBER
283 , x_msg_data OUT NOCOPY VARCHAR2
284 , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
285 , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type
286 , p_eam_op_network_tbl IN EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
287 , p_eam_res_tbl IN EAM_PROCESS_WO_PUB.eam_res_tbl_type
288 , p_eam_res_inst_tbl IN EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
289 , p_eam_sub_res_tbl IN EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
290 , p_eam_res_usage_tbl IN EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
291 , p_eam_mat_req_tbl IN EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
292 , p_eam_direct_items_tbl IN EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
293 , p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
294 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
295 , p_eam_meter_reading_tbl IN EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
296 , p_eam_wo_comp_rebuild_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
297 , p_eam_wo_comp_mr_read_tbl IN EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
298 , p_eam_op_comp_tbl IN EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
299 , p_eam_request_tbl IN EAM_PROCESS_WO_PUB.eam_request_tbl_type
300 , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
301 , x_eam_op_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_tbl_type
302 , x_eam_op_network_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_tbl_type
303 , x_eam_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_tbl_type
304 , x_eam_res_inst_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_inst_tbl_type
305 , x_eam_sub_res_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_sub_res_tbl_type
306 , x_eam_res_usage_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type
307 , x_eam_mat_req_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_tbl_type
308 , x_eam_direct_items_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type
309 , x_eam_wo_comp_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
310 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
311 , x_eam_meter_reading_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_meter_reading_tbl_type
312 , x_eam_wo_comp_rebuild_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_rebuild_tbl_type
313 , x_eam_wo_comp_mr_read_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_comp_mr_read_tbl_type
314 , x_eam_op_comp_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_comp_tbl_type
315 , x_eam_request_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_request_tbl_type
316 , x_return_status OUT NOCOPY VARCHAR2
317 , x_msg_count OUT NOCOPY NUMBER
318 , p_debug IN VARCHAR2 := fnd_api.g_false
319 , p_output_dir IN VARCHAR2 := NULL
320 , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
321 , p_debug_file_mode IN VARCHAR2 := 'w'
322 );
323
324 PROCEDURE return_bom_departments
325 (
326 p_organization_id NUMBER
327 ,p_user_name VARCHAR2
328 ,x_bom_departments_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.bom_departments_table
329 );
330
331 Procedure return_organizations
332 (
333 p_user_name VARCHAR2
334 ,x_organizations_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Org_Access_Table
335 );
336
337 Procedure return_work_request_details
338 (
339 p_user_name VARCHAR2
340 , p_work_request_id number
341 , x_work_request_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Work_Request_Table
342 );
343
344 Procedure return_work_order_details
345 (
346 p_user_name VARCHAR2
347 , p_wip_entity_id number
348 , x_work_order_rec OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Work_Order_Record
349 );
350
351
352 END eam_linear_locations_pub;