1 package EAM_WORKORDERS_JSP AS
2 /* $Header: EAMJOBJS.pls 120.2 2006/03/21 04:12:37 pkathoti noship $
3 $Author: samjain $ */
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
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 );
175
176
177
178
179
180
181 -----------------------------------------------------------------------------------
182 -- update work order, not involved in changes that could invoke transaction
183 -----------------------------------------------------------------------------------
184 procedure update_work_order
185 ( p_api_version IN NUMBER := 1.0
186 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
187 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
188 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
189 ,p_record_version_number IN NUMBER := NULL
190 ,x_return_status OUT NOCOPY VARCHAR2
191 ,x_msg_count OUT NOCOPY NUMBER
192 ,x_msg_data OUT NOCOPY VARCHAR2
193 ,p_wip_entity_id IN NUMBER
194 ,p_description IN VARCHAR2
195 ,p_owning_department IN VARCHAR2
196 ,p_priority IN NUMBER
197 ,p_shutdown_type IN VARCHAR2
198 ,p_activity_type IN VARCHAR2
199 ,p_activity_cause IN VARCHAR2
200 ,p_firm_planned_flag IN NUMBER
201 ,p_notification_required IN VARCHAR2
202 ,p_tagout_required IN VARCHAR2
203 ,p_scheduled_start_date IN DATE
204 ,p_stored_last_update_date IN DATE
205 );
206
207 procedure get_completion_defaults (
208 p_wip_entity_id in number
209 ,p_tx_type in number default 1
210 ,p_sched_start_date in date default null
211 ,p_sched_end_date in date default null
212 ,x_start_date out NOCOPY date
213 ,x_end_date out NOCOPY date
214 ,x_return_status out NOCOPY varchar2
215 ,x_msg_count out NOCOPY number
216 ,x_msg_data out NOCOPY varchar2
217 );
218
219 procedure Add_WorkOrder_Dependency (
220 p_api_version IN NUMBER := 1.0
221 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
222 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
223 ,p_organization_id IN NUMBER
224 ,p_prior_object_id IN NUMBER
225 ,p_prior_object_type_id IN NUMBER
226 ,p_next_object_id IN NUMBER
227 ,p_next_object_type_id IN NUMBER
228 ,x_return_status OUT NOCOPY VARCHAR2
229 ,x_msg_count OUT NOCOPY NUMBER
230 ,x_msg_data OUT NOCOPY VARCHAR2
231 );
232
233 procedure Delete_WorkOrder_Dependency (
234 p_api_version IN NUMBER := 1.0
235 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
236 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
237 ,p_organization_id IN NUMBER
238 ,p_prior_object_id IN NUMBER
239 ,p_prior_object_type_id IN NUMBER
240 ,p_next_object_id IN NUMBER
241 ,p_next_object_type_id IN NUMBER
242 ,p_relationship_type IN NUMBER := 2
243 ,x_return_status OUT NOCOPY VARCHAR2
244 ,x_msg_count OUT NOCOPY NUMBER
245 ,x_msg_data OUT NOCOPY VARCHAR2
246 );
247
248 -- Start of comments
249 -- API name : resize_wo_edit_hierarchy_pvt
250 -- Type : Private.
251 -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.
252 -- Pre-reqs : None.
253 -- Parameters :
254 -- IN p_api_version IN NUMBER
255 -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
256 -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
257 -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
258 -- p_object_id IN NUMBER
259 -- p_object_type_id IN NUMBER
260 -- p_schedule_start_date IN DATE
261 -- p_schedule_end_date IN DATE
262 -- p_requested_start_date IN DATE := NULL
263 -- p_requested_due_date IN DATE := NULL
264 -- p_duration_for_shifting IN NUMBER
265 -- p_firm IN NUMBER
266 -- OUT x_return_status OUT NOCOPY NUMBER
267 -- x_msg_count OUT NOCOPY NUMBER
268 -- x_msg_data OUT NOCOPY VARCHAR2
269 -- Notes : The procedure sees if the dates being passed are >= current date.
270 -- Consider only schedule start and end date if schedule start date,end date and duration
271 -- is entered.If any 2 is given calculate the other and pass the Start Date and End Date
272 -- to the API to resize the workorder.
273 --
274 -- End of comments
275 /*Bug3521886: Pass requested start date and due date*/
276 PROCEDURE resize_wo_hierarchy_pvt(
277 p_api_version IN NUMBER ,
278 p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
279 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
280 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
281 p_object_id IN NUMBER,
282 p_object_type_id IN NUMBER,
283 p_schedule_start_date IN DATE,
284 p_schedule_end_date IN DATE,
285 p_duration_for_shifting IN NUMBER,
286 p_requested_start_date IN DATE := NULL ,
287 p_requested_due_date IN DATE := NULL,
288 p_firm IN NUMBER,
289 p_org_id IN VARCHAR2,
290 x_return_status OUT NOCOPY VARCHAR2 ,
291 x_msg_count OUT NOCOPY NUMBER ,
292 x_msg_data OUT NOCOPY VARCHAR2
293 ) ;
294
295 -- Start of comments
296 -- API name : create_cost_hierarchy_pvt
297 -- Type : Private.
298 -- Function : Creates the costing hierarchy from the scheduling hierarchy.
299 -- Pre-reqs : None.
300 -- Parameters :
301 -- IN p_api_version IN NUMBER
302 -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
303 -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
304 -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
305 -- p_top_level_object_id IN VARCHAR2
306 -- OUT x_return_status OUT NOCOPY NUMBER
307 -- x_msg_count OUT NOCOPY NUMBER
308 -- x_msg_data OUT NOCOPY VARCHAR2
309 -- Notes : The procedure gets the entire work hierarchy for the required top_level_object_id.
310 -- It then passes the child workorder and the parent Work order to the Process_Master_Child_WO
311 -- in the EAM_PROCESS_WO_PUB, to generate the costing relationship between the 2 workorders
312 --
313 -- End of comments
314
315 procedure create_cost_hierarchy_pvt(
316 p_api_version IN NUMBER :=1.0 ,
317 p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
318 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
319 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
320 p_wip_entity_id IN VARCHAR2,
321 p_org_id IN VARCHAR2,
322 x_return_status OUT NOCOPY VARCHAR2 ,
323 x_msg_count OUT NOCOPY NUMBER ,
324 x_msg_data OUT NOCOPY VARCHAR2
325 ) ;
326
327
328 end EAM_WORKORDERS_JSP;