1 package EAM_WORKORDERS_JSP AUTHID CURRENT_USER AS
2 /* $Header: EAMJOBJS.pls 120.3.12020000.1 2012/06/27 12:16:15 appldev ship $
3 $Author: appldev $ */
4
5 -- Author : YULIN
6 -- Created : 7/24/01 12:48:31 PM
7 -- Purpose : eam work order functionalities
8 -- Standard who
9 g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
10 g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
11 g_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
12 g_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
13 g_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
14 g_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
15
16
17
18 -----------------------------------------------------------------
19 --procedure to validate if a work order can be cancelled or not
20 -----------------------------------------------------------
21 procedure validate_cancel(p_wip_entity_id NUMBER);
22
23
24
25 -------------------------------------------------------------
26 --procedure to add existing work orders
27 ----------------------------------------------------------------
28 procedure add_exist_work_order(
29 p_api_version IN NUMBER := 1.0
30 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
33 ,p_record_version_number IN NUMBER := NULL
34 ,x_return_status OUT NOCOPY VARCHAR2
35 ,x_msg_count OUT NOCOPY NUMBER
36 ,x_msg_data OUT NOCOPY VARCHAR2
37 ,p_organization_id IN NUMBER
38 ,p_wip_entity_id IN NUMBER
39 ,p_firm_flag IN NUMBER
40 ,p_parent_wip_id IN NUMBER
41 , p_relation_type IN NUMBER
42
43
44 );
45
46
47 -------------------------------------------------------------------------
48 -- a wrapper procedure to the eam_completion.complete_work_order,
49 -- also check the return status add message to the message list
50 -- so jsp pages can get them.
51 -------------------------------------------------------------------------
52 procedure Complete_Workorder
53 ( p_api_version IN NUMBER := 1.0
54 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
55 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
57 ,p_record_version_number IN NUMBER := NULL
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_wip_entity_id IN NUMBER
62 ,p_actual_start_date IN DATE
63 ,p_actual_end_date IN DATE
64 ,p_actual_duration IN NUMBER
65 ,p_transaction_date IN DATE
66 ,p_transaction_type IN NUMBER
67 ,p_shutdown_start_date IN DATE
68 ,p_shutdown_end_date IN DATE
69 ,p_reconciliation_code IN VARCHAR2
70 ,p_stored_last_update_date IN DATE
71 ,p_rebuild_jobs IN VARCHAR2 := NULL -- holds 'Y' or 'N'
72 ,p_subinventory IN VARCHAR2 := NULL
73 ,p_subinv_ctrl IN NUMBER := NULL
74 ,p_org_id IN NUMBER := NULL
75 ,p_item_id IN NUMBER := NULL
76 ,p_locator_id IN NUMBER := NULL
77 ,p_locator_ctrl IN NUMBER := NULL
78 ,p_locator IN VARCHAR2 := NULL
79 ,p_lot IN VARCHAR2 := NULL
80 ,p_serial IN VARCHAR2 := NULL
81 ,p_manual_flag IN VARCHAR2 := NULL
82 ,p_serial_status IN VARCHAR2 := NULL
83 ,p_qa_collection_id IN NUMBER DEFAULT NULL
84 ,p_attribute_category IN VARCHAR2 := null
85 ,p_attribute1 IN VARCHAR2 := null
86 ,p_attribute2 IN VARCHAR2 := null
87 ,p_attribute3 IN VARCHAR2 := null
88 ,p_attribute4 IN VARCHAR2 := null
89 ,p_attribute5 IN VARCHAR2 := null
90 ,p_attribute6 IN VARCHAR2 := null
91 ,p_attribute7 IN VARCHAR2 := null
92 ,p_attribute8 IN VARCHAR2 := null
93 ,p_attribute9 IN VARCHAR2 := null
94 ,p_attribute10 IN VARCHAR2 := null
95 ,p_attribute11 IN VARCHAR2 := null
96 ,p_attribute12 IN VARCHAR2 := null
97 ,p_attribute13 IN VARCHAR2 := null
98 ,p_attribute14 IN VARCHAR2 := null
99 ,p_attribute15 IN VARCHAR2 := null
100 );
101
102 -------------------------------------------------------------------------------
103 -- Creating easy work order
104 -- insert row into wip_discrete_jobs, wip_entities
105 -- create a default operation 10 for the new work order
106 -- release the work order and call wip_change_status.release
107 -------------------------------------------------------------------------------
108 procedure create_ez_work_order
109 ( p_api_version IN NUMBER := 1.0
110 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
111 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
112 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
113 ,p_record_version_number IN NUMBER := NULL
114 ,x_return_status OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116 ,x_msg_data OUT NOCOPY VARCHAR2
117 ,p_organization_id IN NUMBER := 929
118 ,p_asset_number IN VARCHAR2 --corresponds to serial number in csi_item_instances
119 ,p_asset_group IN VARCHAR2
120 ,p_work_order_type IN NUMBER -- data
121 ,p_description IN VARCHAR2
122 ,p_activity_type IN NUMBER
123 ,p_activity_cause IN NUMBER
124 ,p_scheduled_start_date IN DATE
125 ,p_scheduled_completion_date IN DATE
126 ,p_owning_department IN VARCHAR2
127 ,p_priority IN NUMBER
128 ,p_request_type IN NUMBER := 1
129 ,p_work_request_number IN VARCHAR2
130 ,p_work_request_id IN NUMBER
131 ,x_new_work_order_name OUT NOCOPY VARCHAR2
132 ,x_new_work_order_id OUT NOCOPY NUMBER
133 ,p_asset_activity IN VARCHAR2 DEFAULT NULL
134 ,p_project_number IN VARCHAR2 DEFAULT NULL
135 ,p_task_number IN VARCHAR2 DEFAULT NULL
136 ,p_service_request_number IN VARCHAR2 DEFAULT NULL
137 ,p_service_request_id IN NUMBER DEFAULT NULL
138 ,p_material_issue_by_mo IN VARCHAR2 DEFAULT NULL
139 ,p_status_type IN NUMBER
140 ,p_mode IN NUMBER
141 ,p_wip_entity_name IN VARCHAR2
142 ,p_user_id IN NUMBER
143 ,p_responsibility_id IN NUMBER
144 ,p_firm IN VARCHAR2 -- JSP passes it as a string
145 ,p_activity_source IN NUMBER
146 ,p_shutdown_type IN NUMBER
147 ,p_parent_work_order IN VARCHAR2 DEFAULT NULL
148 ,p_sched_parent_wip_entity_id IN VARCHAR2 DEFAULT NULL
149 ,p_relationship_type IN VARCHAR2 DEFAULT NULL
150 , p_attribute_category IN VARCHAR2 DEFAULT NULL
151 , p_attribute1 IN VARCHAR2 DEFAULT NULL
152 , p_attribute2 IN VARCHAR2 DEFAULT NULL
153 , p_attribute3 IN VARCHAR2 DEFAULT NULL
154 , p_attribute4 IN VARCHAR2 DEFAULT NULL
155 , p_attribute5 IN VARCHAR2 DEFAULT NULL
156 , p_attribute6 IN VARCHAR2 DEFAULT NULL
157 , p_attribute7 IN VARCHAR2 DEFAULT NULL
158 , p_attribute8 IN VARCHAR2 DEFAULT NULL
159 , p_attribute9 IN VARCHAR2 DEFAULT NULL
160 , p_attribute10 IN VARCHAR2 DEFAULT NULL
161 , p_attribute11 IN VARCHAR2 DEFAULT NULL
162 , p_attribute12 IN VARCHAR2 DEFAULT NULL
163 , p_attribute13 IN VARCHAR2 DEFAULT NULL
164 , p_attribute14 IN VARCHAR2 DEFAULT NULL
165 , p_attribute15 IN VARCHAR2 DEFAULT NULL
166 , p_failure_id IN NUMBER DEFAULT NULL
167 , p_failure_date IN DATE DEFAULT NULL
168 , p_failure_entry_id IN NUMBER DEFAULT NULL
169 , p_failure_code IN VARCHAR2 DEFAULT NULL
170 , p_cause_code IN VARCHAR2 DEFAULT NULL
171 , p_resolution_code IN VARCHAR2 DEFAULT NULL
172 , p_failure_comments IN VARCHAR2 DEFAULT NULL
173 , p_failure_code_required IN VARCHAR2 DEFAULT NULL
174 , p_instance_number IN VARCHAR2 --corresponds to instance_number in csi_item_instances (for Bug 8667921)
175 );
176
177
178
179
180
181
182 -----------------------------------------------------------------------------------
183 -- update work order, not involved in changes that could invoke transaction
184 -----------------------------------------------------------------------------------
185 procedure update_work_order
186 ( p_api_version IN NUMBER := 1.0
187 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
188 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
189 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
190 ,p_record_version_number IN NUMBER := NULL
191 ,x_return_status OUT NOCOPY VARCHAR2
192 ,x_msg_count OUT NOCOPY NUMBER
193 ,x_msg_data OUT NOCOPY VARCHAR2
194 ,p_wip_entity_id IN NUMBER
195 ,p_description IN VARCHAR2
196 ,p_owning_department IN VARCHAR2
197 ,p_priority IN NUMBER
198 ,p_shutdown_type IN VARCHAR2
199 ,p_activity_type IN VARCHAR2
200 ,p_activity_cause IN VARCHAR2
201 ,p_firm_planned_flag IN NUMBER
202 ,p_notification_required IN VARCHAR2
203 ,p_tagout_required IN VARCHAR2
204 ,p_scheduled_start_date IN DATE
205 ,p_stored_last_update_date IN DATE
206 );
207
208 procedure get_completion_defaults (
209 p_wip_entity_id in number
210 ,p_tx_type in number default 1
211 ,p_sched_start_date in date default null
212 ,p_sched_end_date in date default null
213 ,x_start_date out NOCOPY date
214 ,x_end_date out NOCOPY date
215 ,x_return_status out NOCOPY varchar2
216 ,x_msg_count out NOCOPY number
217 ,x_msg_data out NOCOPY varchar2
218 );
219
220 procedure Add_WorkOrder_Dependency (
221 p_api_version IN NUMBER := 1.0
222 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
223 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
224 ,p_organization_id IN NUMBER
225 ,p_prior_object_id IN NUMBER
226 ,p_prior_object_type_id IN NUMBER
227 ,p_next_object_id IN NUMBER
228 ,p_next_object_type_id IN NUMBER
229 ,x_return_status OUT NOCOPY VARCHAR2
230 ,x_msg_count OUT NOCOPY NUMBER
231 ,x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234 procedure Delete_WorkOrder_Dependency (
235 p_api_version IN NUMBER := 1.0
236 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
237 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
238 ,p_organization_id IN NUMBER
239 ,p_prior_object_id IN NUMBER
240 ,p_prior_object_type_id IN NUMBER
241 ,p_next_object_id IN NUMBER
242 ,p_next_object_type_id IN NUMBER
243 ,p_relationship_type IN NUMBER := 2
244 ,x_return_status OUT NOCOPY VARCHAR2
245 ,x_msg_count OUT NOCOPY NUMBER
246 ,x_msg_data OUT NOCOPY VARCHAR2
247 );
248
249 -- Start of comments
250 -- API name : resize_wo_edit_hierarchy_pvt
251 -- Type : Private.
252 -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.
253 -- Pre-reqs : None.
254 -- Parameters :
255 -- IN p_api_version IN NUMBER
256 -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
257 -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
258 -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
259 -- p_object_id IN NUMBER
260 -- p_object_type_id IN NUMBER
261 -- p_schedule_start_date IN DATE
262 -- p_schedule_end_date IN DATE
263 -- p_requested_start_date IN DATE := NULL
264 -- p_requested_due_date IN DATE := NULL
265 -- p_duration_for_shifting IN NUMBER
266 -- p_firm IN NUMBER
267 -- OUT x_return_status OUT NOCOPY NUMBER
268 -- x_msg_count OUT NOCOPY NUMBER
269 -- x_msg_data OUT NOCOPY VARCHAR2
270 -- Notes : The procedure sees if the dates being passed are >= current date.
271 -- Consider only schedule start and end date if schedule start date,end date and duration
272 -- is entered.If any 2 is given calculate the other and pass the Start Date and End Date
273 -- to the API to resize the workorder.
274 --
275 -- End of comments
276 /*Bug3521886: Pass requested start date and due date*/
277 PROCEDURE resize_wo_hierarchy_pvt(
278 p_api_version IN NUMBER ,
279 p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
280 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
281 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
282 p_object_id IN NUMBER,
283 p_object_type_id IN NUMBER,
284 p_schedule_start_date IN DATE,
285 p_schedule_end_date IN DATE,
286 p_duration_for_shifting IN NUMBER,
287 p_requested_start_date IN DATE := NULL ,
288 p_requested_due_date IN DATE := NULL,
289 p_firm IN NUMBER,
290 p_org_id IN VARCHAR2,
291 x_return_status OUT NOCOPY VARCHAR2 ,
292 x_msg_count OUT NOCOPY NUMBER ,
293 x_msg_data OUT NOCOPY VARCHAR2
294 ) ;
295
296 -- Start of comments
297 -- API name : create_cost_hierarchy_pvt
298 -- Type : Private.
299 -- Function : Creates the costing hierarchy from the scheduling hierarchy.
300 -- Pre-reqs : None.
301 -- Parameters :
302 -- IN p_api_version IN NUMBER
303 -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
304 -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
305 -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
306 -- p_top_level_object_id IN VARCHAR2
307 -- OUT x_return_status OUT NOCOPY NUMBER
308 -- x_msg_count OUT NOCOPY NUMBER
309 -- x_msg_data OUT NOCOPY VARCHAR2
310 -- Notes : The procedure gets the entire work hierarchy for the required top_level_object_id.
311 -- It then passes the child workorder and the parent Work order to the Process_Master_Child_WO
312 -- in the EAM_PROCESS_WO_PUB, to generate the costing relationship between the 2 workorders
313 --
314 -- End of comments
315
316 procedure create_cost_hierarchy_pvt(
317 p_api_version IN NUMBER :=1.0 ,
318 p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
319 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
320 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
321 p_wip_entity_id IN VARCHAR2,
322 p_org_id IN VARCHAR2,
323 x_return_status OUT NOCOPY VARCHAR2 ,
324 x_msg_count OUT NOCOPY NUMBER ,
325 x_msg_data OUT NOCOPY VARCHAR2
326 ) ;
327
328
329 end EAM_WORKORDERS_JSP;
[Home] [Help]