eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.EAM_ACTIVITY_PUB

Source


1 PACKAGE EAM_Activity_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPACTS.pls 120.1.12020000.2 2013/03/29 02:21:13 shengywa ship $ */
3 
4 -- To uniquely identify a Work Order.
5 -- If the Wip_Entity_Id is given, that would be enough.
6 -- Or user can specify the Wip_Entity_Name along with the Organization.
7 -- Will assigne Activity to the Work Order's organization, and its master org.
8 TYPE Work_Order_Rec_Type IS RECORD
9 (
10 Organization_Id		NUMBER       	:=  NULL, -- Org Id overrides Org Code if both present
11 Organization_Code	VARCHAR2(3)  	:=  NULL,
12 Wip_Entity_Id		NUMBER       	:=  NULL, -- Wip Entity Id overrides Name if both present
13 Wip_Entity_Name		VARCHAR2(240) 	:=  NULL
14 );
15 
16 TYPE Activity_Association_Rec_Type IS RECORD
17 (
18 Organization_Id		NUMBER, -- organization responsible for Asset's maintenance
19 Asset_Activity_Id	NUMBER,
20 Start_Date_Active	DATE,
21 End_Date_Active		DATE,
22 Priority_Code		VARCHAR(30),
23 Attribute_Category	VARCHAR2(30),
24 Attribute1		VARCHAR2(150),
25 Attribute2		VARCHAR2(150),
26 Attribute3		VARCHAR2(150),
27 Attribute4		VARCHAR2(150),
28 Attribute5		VARCHAR2(150),
29 Attribute6		VARCHAR2(150),
30 Attribute7		VARCHAR2(150),
31 Attribute8		VARCHAR2(150),
32 Attribute9		VARCHAR2(150),
33 Attribute10		VARCHAR2(150),
34 Attribute11		VARCHAR2(150),
35 Attribute12		VARCHAR2(150),
36 Attribute13		VARCHAR2(150),
37 Attribute14		VARCHAR2(150),
38 Attribute15		VARCHAR2(150),
39 Owning_Department_Id	NUMBER,
40 Activity_Cause_Code	VARCHAR2(30),
41 Activity_Type_Code	VARCHAR2(30),
42 Activity_Source_Code	VARCHAR2(30),
43 Class_Code		VARCHAR2(10),
44 Maintenance_Object_Id	NUMBER, -- Maintenance Object Id should override asset number and serial number
45 Maintenance_Object_Type	NUMBER,
46 Instance_number 	VARCHAR2(30), -- Asset Number
47 Inventory_Item_Id	NUMBER, -- Asset Group
48 Serial_Number		VARCHAR2(30), -- Asset Serial Number
49 Activity_Association_Id	NUMBER, -- Derived
50 Tagging_Required_Flag	VARCHAR2(1),
51 Shutdown_Type_Code	VARCHAR2(30),
52 Tmpl_Flag		VARCHAR2(1),
53 Return_Status		VARCHAR2(1),
54 Error_Mesg		VARCHAR2(240),
55 -- For bug 16525236
56 Work_Order_Type		NUMBER,
57 Planner           	NUMBER,
58 Firm              	NUMBER,
59 Planned           	VARCHAR2(1),
60 Notification_Required 	VARCHAR2(1)
61 -- Ended for 16525236
62 );
63 
64 TYPE Activity_Association_Tbl_Type IS TABLE OF Activity_Association_Rec_Type
65 	INDEX BY BINARY_INTEGER;
66 
67 
68 
69 -- Start of comments
70 --	API name 	: Create_Activity
71 --	Type		: Public
72 --	Function	:
73 --	Pre-reqs	: None.
74 --	Parameters	:
75 --	IN		:	p_api_version           	IN NUMBER	Required
76 --				p_init_msg_list			IN VARCHAR2 	Optional
77 --					Default = FND_API.G_FALSE
78 --				p_commit	    		IN VARCHAR2	Optional
79 --					Default = FND_API.G_FALSE
80 --				p_validation_level		IN NUMBER	Optional
81 --					Default = FND_API.G_VALID_LEVEL_FULL
82 --	p_asset_activity_name		IN	EAM_Activity_PUB.Item_Rec_Type,
83 --	p_asset_activity_description	IN	VARCHAR2 := NULL,
84 --      p_work_order_rec		IN	EAM_Activity_PUB.Work_Order_Rec_Type,
85 --	p_operation_copy_option		IN	VARCHAR2 := '2', -- 1 (NONE) or 2 (ALL)
86 --	p_material_copy_option		IN	VARCHAR2 := '2', -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
87 --	p_resource_copy_option		IN	VARCHAR2 := '2', -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
88 --	p_association_copy_option	IN	VARCHAR2 := '2', -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
89 
90 --	OUT		:
91 --				x_msg_count			OUT	NUMBER
92 --				x_msg_data			OUT	VARCHAR2(2000)
93 --	x_inventory_item_id		OUT	NUMBER -- the inventory_item_it the system has created
94 
95 --	Version	: Current version	1.0
96 --			  Initial version 	1.0
97 --
98 --	Notes		: EAM Business Object API to create Asset Activity from a Work Order.
99 --			Will assigne Activity to the Work Order's organization, and its master org.
100 --
101 -- End of comments
102 PROCEDURE Create_Activity
103 ( 	p_api_version           	IN	NUMBER				,
104   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
105 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
106 	p_validation_level		IN  	NUMBER	:=
107 						FND_API.G_VALID_LEVEL_FULL	,
108 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
109 	x_msg_count			OUT NOCOPY	NUMBER				,
110 	x_msg_data			OUT NOCOPY	VARCHAR2			,
111 
112 	p_asset_activity		IN	INV_Item_GRP.Item_Rec_Type,
113 	p_template_id			IN	NUMBER 		:= NULL,
114         p_template_name			IN	VARCHAR2 	:= NULL,
115 	p_activity_type_code		IN	VARCHAR2	:= NULL,
116 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
117 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
118 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
119 	p_activity_source_code		IN	VARCHAR2	:= NULL,
120 
121         p_work_order_rec		IN	EAM_Activity_PUB.Work_Order_Rec_Type,
122 	p_operation_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
123 	p_material_copy_option		IN	NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
124 	p_resource_copy_option		IN	NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
125 	p_association_copy_option	IN	NUMBER := 2, -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
126 
127 --	x_inventory_item_id		OUT	NUMBER, -- the inventory_item_it the system has created
128 	x_work_order_rec		OUT	NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
129 
130 	x_curr_item_rec			OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
131 	x_curr_item_return_status	OUT	NOCOPY	VARCHAR2,
132 	x_curr_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
133 	x_master_item_rec		OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
134 	x_master_item_return_status	OUT	NOCOPY	VARCHAR2,
135 	x_master_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
136 
137 	x_rtg_header_rec		OUT	NOCOPY	BOM_Rtg_Pub.Rtg_Header_Rec_Type,
138 	x_rtg_revision_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
139 	x_operation_tbl			OUT	NOCOPY	BOM_Rtg_Pub.Operation_Tbl_Type,
140 	x_op_resource_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Op_Resource_Tbl_Type,
141 	x_sub_resource_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
142 	x_op_network_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Op_Network_Tbl_Type,
143 	x_rtg_return_status		OUT	NOCOPY	VARCHAR2,
144 	x_rtg_msg_count			OUT	NOCOPY	NUMBER,
145 	x_rtg_msg_list			OUT	NOCOPY	Error_Handler.Error_Tbl_Type,
146 
147 	x_bom_header_rec		OUT	NOCOPY	BOM_BO_PUB.BOM_Head_Rec_Type,
148 	x_bom_revision_tbl		OUT	NOCOPY	BOM_BO_PUB.BOM_Revision_Tbl_Type,
149 	x_bom_component_tbl		OUT	NOCOPY	BOM_BO_PUB.BOM_Comps_Tbl_Type,
150 	x_bom_ref_designator_tbl	OUT	NOCOPY	BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
151 	x_bom_sub_component_tbl		OUT	NOCOPY	BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
152 	x_bom_return_status		OUT	NOCOPY	VARCHAR2,
153 	x_bom_msg_count			OUT	NOCOPY	NUMBER,
154 	x_bom_msg_list			OUT	NOCOPY	Error_Handler.Error_Tbl_Type,
155 
156 	x_assoc_return_status		OUT	NOCOPY	VARCHAR2,
157 	x_assoc_msg_count		OUT	NOCOPY	NUMBER,
158 	x_assoc_msg_data		OUT	NOCOPY	VARCHAR2,
159 	x_act_num_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type,
160 	x_activity_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type
161 );
162 
163 PROCEDURE Copy_Activity
164 ( 	p_api_version           	IN	NUMBER				,
165   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
166 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
167 	p_validation_level		IN  	NUMBER	:=
168 						FND_API.G_VALID_LEVEL_FULL	,
169 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
170 	x_msg_count			OUT NOCOPY	NUMBER				,
171 	x_msg_data			OUT NOCOPY	VARCHAR2			,
172 
173 	-- target activity, need to set org, item name, description
174 	p_asset_activity		IN	INV_Item_GRP.Item_Rec_Type,
175 
176 
177 	p_template_id			IN	NUMBER 		:= NULL,
178         p_template_name			IN	VARCHAR2 	:= NULL,
179 	p_activity_type_code		IN	VARCHAR2	:= NULL,
180 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
181 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
182 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
183 	p_activity_source_code		IN	VARCHAR2	:= NULL,
184 
185 	-- source Activity
186 	p_source_org_id			IN	NUMBER,
187 	p_source_activity_id		IN	NUMBER, -- inventory_item_id
188 	-- source BOM
189 	p_source_alt_bom_designator	IN	VARCHAR2	:= NULL,
190 	p_source_bom_rev_date		IN 	DATE		:= sysdate,
191 	-- source Routing
192 	p_source_alt_rtg_designator	IN	VARCHAR2	:= NULL,
193 	p_source_rtg_rev_date		IN	DATE		:= sysdate,
194 
195 	p_bom_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
196 	p_routing_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
197 	p_association_copy_option	IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
198 
199 	x_curr_item_rec			OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
200 	x_curr_item_return_status	OUT	NOCOPY	VARCHAR2,
201 	x_curr_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
202 	x_master_item_rec		OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
203 	x_master_item_return_status	OUT	NOCOPY	VARCHAR2,
204 	x_master_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
205 
206 	x_assoc_return_status		OUT	NOCOPY	VARCHAR2,
207 	x_assoc_msg_count		OUT	NOCOPY	NUMBER,
208 	x_assoc_msg_data		OUT	NOCOPY	VARCHAR2,
209 	x_act_num_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type,
210 	x_activity_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type
211 );
212 
213 
214 PROCEDURE Create_Activity_From_Form (
215 	p_wip_entity_id			IN	NUMBER
216 	, p_asset_activity		IN	VARCHAR2 := NULL
217 	, p_segment1			IN	VARCHAR2 := NULL
218 	, p_segment2			IN	VARCHAR2 := NULL
219 	, p_segment3			IN	VARCHAR2 := NULL
220 	, p_segment4			IN	VARCHAR2 := NULL
221 	, p_segment5			IN	VARCHAR2 := NULL
222 	, p_segment6			IN	VARCHAR2 := NULL
223 	, p_segment7			IN	VARCHAR2 := NULL
224 	, p_segment8			IN	VARCHAR2 := NULL
225 	, p_segment9			IN	VARCHAR2 := NULL
226 	, p_segment10			IN	VARCHAR2 := NULL
227 	, p_segment11			IN	VARCHAR2 := NULL
228 	, p_segment12			IN	VARCHAR2 := NULL
229 	, p_segment13			IN	VARCHAR2 := NULL
230 	, p_segment14			IN	VARCHAR2 := NULL
231 	, p_segment15			IN	VARCHAR2 := NULL
232 	, p_segment16			IN	VARCHAR2 := NULL
233 	, p_segment17			IN	VARCHAR2 := NULL
234 	, p_segment18			IN	VARCHAR2 := NULL
235 	, p_segment19			IN	VARCHAR2 := NULL
236 	, p_segment20			IN	VARCHAR2 := NULL
237 	, p_description			IN	VARCHAR2
238 	, p_template_id			IN	NUMBER
239 	, p_activity_type_code		IN	VARCHAR2
240 	, p_activity_cause_code 	IN	VARCHAR2
241 	, p_shutdown_type_code		IN	VARCHAR2
242 	, p_notification_req_flag	IN	VARCHAR2
243 	, p_activity_source_code	IN	VARCHAR2
244 
245 	, p_operation_copy_option	IN	NUMBER
246 	, p_material_copy_option	IN	NUMBER
247 	, p_resource_copy_option	IN	NUMBER
248 	, p_association_copy_option	IN	NUMBER
249 	, x_successful			OUT NOCOPY	BOOLEAN
250 	);
251 
252 PROCEDURE Create_Activity_With_Template(
253  	p_api_version           	IN	NUMBER				,
254   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
255 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
256 	p_validation_level		IN  	NUMBER	:=
257 						FND_API.G_VALID_LEVEL_FULL	,
258 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
259 	x_msg_count			OUT NOCOPY	NUMBER				,
260 	x_msg_data			OUT NOCOPY	VARCHAR2			,
261 
262 	p_organization_id		IN	NUMBER 		:= NULL,
263 	p_organization_code		IN	NUMBER		:= NULL,
264 	p_asset_activity		IN	VARCHAR2 := NULL,
265 	p_segment1			IN	VARCHAR2 := NULL,
266 	p_segment2			IN	VARCHAR2 := NULL,
267 	p_segment3			IN	VARCHAR2 := NULL,
268 	p_segment4			IN	VARCHAR2 := NULL,
269 	p_segment5			IN	VARCHAR2 := NULL,
270 	p_segment6			IN	VARCHAR2 := NULL,
271 	p_segment7			IN	VARCHAR2 := NULL,
272 	p_segment8			IN	VARCHAR2 := NULL,
273 	p_segment9			IN	VARCHAR2 := NULL,
274 	p_segment10			IN	VARCHAR2 := NULL,
275 	p_segment11			IN	VARCHAR2 := NULL,
276 	p_segment12			IN	VARCHAR2 := NULL,
277 	p_segment13			IN	VARCHAR2 := NULL,
278 	p_segment14			IN	VARCHAR2 := NULL,
279 	p_segment15			IN	VARCHAR2 := NULL,
280 	p_segment16			IN	VARCHAR2 := NULL,
281 	p_segment17			IN	VARCHAR2 := NULL,
282 	p_segment18			IN	VARCHAR2 := NULL,
283 	p_segment19			IN	VARCHAR2 := NULL,
284 	p_segment20			IN	VARCHAR2 := NULL,
285 	p_description			IN	VARCHAR2,
286 	p_template_id			IN	NUMBER 		:= NULL,
287 	p_template_name			IN	VARCHAR2 	:= NULL,
288 	p_activity_type_code		IN	VARCHAR2	:= NULL,
289 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
290 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
291 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
292 	p_activity_source_code		IN	VARCHAR2	:= NULL,
293 
294 	x_curr_item_rec			OUT NOCOPY	INV_Item_GRP.Item_Rec_Type,
295 	x_curr_item_return_status	OUT NOCOPY	VARCHAR2,
296 	x_curr_item_error_tbl		OUT NOCOPY	INV_Item_GRP.Error_Tbl_Type,
297 	x_master_item_rec		OUT NOCOPY	INV_Item_GRP.Item_Rec_Type,
298 	x_master_item_return_status	OUT NOCOPY	VARCHAR2,
299 	x_master_item_error_tbl		OUT NOCOPY	INV_Item_GRP.Error_Tbl_Type
300 );
301 
302 -- From Saurabh
303 procedure create_bom_header(
304 	p_target_item_rec		IN INV_Item_GRP.Item_Rec_Type,
305 	--p_source_org_id			IN	NUMBER,
306 	--p_source_activity_id		IN	NUMBER, -- inventory_item_id
307 
308 	--p_material_copy_option		IN NUMBER,
309 
310 	x_bom_header_rec		OUT NOCOPY	BOM_BO_PUB.BOM_Head_Rec_Type,
311 	x_bom_revision_tbl		OUT NOCOPY	BOM_BO_PUB.BOM_Revision_Tbl_Type,
312 	x_bom_component_tbl		OUT NOCOPY	BOM_BO_PUB.BOM_Comps_Tbl_Type,
313 	x_bom_ref_designator_tbl	OUT NOCOPY	BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
314 	x_bom_sub_component_tbl		OUT NOCOPY	BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
315 	x_bom_return_status		OUT NOCOPY	VARCHAR2,
316 	x_bom_msg_count			OUT NOCOPY	NUMBER,
317 	x_bom_msg_list			OUT NOCOPY	Error_Handler.Error_Tbl_Type
318 );
319 
320 procedure create_bom_header_form(
321     --p_target_item_rec		IN INV_Item_GRP.Item_Rec_Type,
322     p_inventory_item_name varchar2,
323     p_organization_code varchar2,
324     x_return_status     OUT NOCOPY	VARCHAR2
325 );
326 
327 PROCEDURE Create_Activity_With_Template(
328  	--p_api_version           	IN	NUMBER				,
329   	--p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
330 	--p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
331 	--p_validation_level		IN  	NUMBER	:=
332 						--FND_API.G_VALID_LEVEL_FULL	,
333 	x_return_status			OUT NOCOPY	varchar2		  	,
334 	--x_msg_count			OUT	NUMBER				,
335 	--x_msg_data			OUT	VARCHAR2			,
336 
337 	p_organization_id		IN	NUMBER 		:= NULL,
338 	p_organization_code		IN	NUMBER		:= NULL,
339 	p_asset_activity		IN	VARCHAR2 := NULL,
340 	p_segment1			IN	VARCHAR2 := NULL,
341 	p_segment2			IN	VARCHAR2 := NULL,
342 	p_segment3			IN	VARCHAR2 := NULL,
343 	p_segment4			IN	VARCHAR2 := NULL,
344 	p_segment5			IN	VARCHAR2 := NULL,
345 	p_segment6			IN	VARCHAR2 := NULL,
346 	p_segment7			IN	VARCHAR2 := NULL,
347 	p_segment8			IN	VARCHAR2 := NULL,
348 	p_segment9			IN	VARCHAR2 := NULL,
349 	p_segment10			IN	VARCHAR2 := NULL,
350 	p_segment11			IN	VARCHAR2 := NULL,
351 	p_segment12			IN	VARCHAR2 := NULL,
352 	p_segment13			IN	VARCHAR2 := NULL,
353 	p_segment14			IN	VARCHAR2 := NULL,
354 	p_segment15			IN	VARCHAR2 := NULL,
355 	p_segment16			IN	VARCHAR2 := NULL,
356 	p_segment17			IN	VARCHAR2 := NULL,
357 	p_segment18			IN	VARCHAR2 := NULL,
358 	p_segment19			IN	VARCHAR2 := NULL,
359 	p_segment20			IN	VARCHAR2 := NULL,
360 	p_description			IN	VARCHAR2,
361 	p_template_id			IN	NUMBER 		:= NULL,
362 	p_template_name			IN	VARCHAR2 	:= NULL,
363 	p_activity_type_code		IN	VARCHAR2	:= NULL,
364 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
365 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
366 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
367 	p_activity_source_code		IN	VARCHAR2	:= NULL
368 
369 	--x_curr_item_rec			OUT	INV_Item_GRP.Item_Rec_Type,
370 	--x_curr_item_return_status	OUT	VARCHAR2,
371 	--x_curr_item_error_tbl		OUT	INV_Item_GRP.Error_Tbl_Type,
372 	--x_master_item_rec		OUT	INV_Item_GRP.Item_Rec_Type,
373 	--x_master_item_return_status	OUT	VARCHAR2,
374 	--x_master_item_error_tbl		OUT	INV_Item_GRP.Error_Tbl_Type
375 );
376 
377 PROCEDURE Create_Routing_Header(
378 	p_target_item_rec			IN INV_Item_GRP.Item_Rec_Type,
379 
380 	x_rtg_header_rec		OUT NOCOPY	BOM_Rtg_Pub.Rtg_Header_Rec_Type,
381 	x_rtg_revision_tbl		OUT NOCOPY	BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
382 	x_operation_tbl			OUT NOCOPY	BOM_Rtg_Pub.Operation_Tbl_Type,
383 	x_op_resource_tbl		OUT NOCOPY	BOM_Rtg_Pub.Op_Resource_Tbl_Type,
384 	x_sub_resource_tbl		OUT NOCOPY	BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
385 	x_op_network_tbl		OUT NOCOPY	BOM_Rtg_Pub.Op_Network_Tbl_Type,
386 	x_rtg_return_status		OUT NOCOPY	VARCHAR2,
387 	x_rtg_msg_count			OUT NOCOPY	NUMBER,
388 	x_rtg_msg_list			OUT NOCOPY	Error_Handler.Error_Tbl_Type
389 );
390 
391 procedure create_routing_header_form(
392     --p_target_item_rec		IN INV_Item_GRP.Item_Rec_Type,
393     p_inventory_item_name varchar2,
394     p_organization_code varchar2,
395     x_return_status     OUT NOCOPY	VARCHAR2
396 );
397 
398 -- from Saurabh
399 -- package spec.
400 -- wrapper API used to call Copy_Activity procedure from form
401 procedure Copy_Activity(
402     	p_api_version           	IN	NUMBER				,
403   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
404 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
405 	p_validation_level		IN  	NUMBER	:=
406 						FND_API.G_VALID_LEVEL_FULL	,
407 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
408 	x_msg_count			OUT NOCOPY	NUMBER				,
409 	x_msg_data			OUT NOCOPY	VARCHAR2			,
410 
411     	p_activity_item_name 		IN 	VARCHAR2 := NULL,
412 	p_segment1			IN	VARCHAR2 := NULL,
413 	p_segment2			IN	VARCHAR2 := NULL,
414 	p_segment3			IN	VARCHAR2 := NULL,
415 	p_segment4			IN	VARCHAR2 := NULL,
416 	p_segment5			IN	VARCHAR2 := NULL,
417 	p_segment6			IN	VARCHAR2 := NULL,
418 	p_segment7			IN	VARCHAR2 := NULL,
419 	p_segment8			IN	VARCHAR2 := NULL,
420 	p_segment9			IN	VARCHAR2 := NULL,
421 	p_segment10			IN	VARCHAR2 := NULL,
422 	p_segment11			IN	VARCHAR2 := NULL,
423 	p_segment12			IN	VARCHAR2 := NULL,
424 	p_segment13			IN	VARCHAR2 := NULL,
425 	p_segment14			IN	VARCHAR2 := NULL,
426 	p_segment15			IN	VARCHAR2 := NULL,
427 	p_segment16			IN	VARCHAR2 := NULL,
428 	p_segment17			IN	VARCHAR2 := NULL,
429 	p_segment18			IN	VARCHAR2 := NULL,
430 	p_segment19			IN	VARCHAR2 := NULL,
431 	p_segment20			IN	VARCHAR2 := NULL,
432 	p_activity_org_id 		IN 	NUMBER,
433 	p_activity_description 		IN	VARCHAR2,
434 
435     	p_template_id			IN	NUMBER 		:= NULL,
436         p_template_name			IN	VARCHAR2 	:= NULL,
437         p_activity_type_code		IN	VARCHAR2	:= NULL,
438 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
439 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
440 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
441 	p_activity_source_code		IN	VARCHAR2	:= NULL,
442 
443 	-- source Activity
444 	p_source_org_id			IN	NUMBER,
445 	p_source_activity_id		IN	NUMBER, -- inventory_item_id
446     	p_bom_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
447 	p_routing_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
448 	p_association_copy_option	IN	NUMBER := 2 -- 1 (NONE) or 2 (ALL)
449 
450 );
451 
452 /* Procedure to assign the activity to the current maintenance organization */
453 
454 PROCEDURE Activity_org_assign
455 ( 	p_api_version           IN   	        NUMBER				,
456 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
457 	x_msg_count		OUT NOCOPY	NUMBER				,
458 	x_msg_data		OUT NOCOPY	VARCHAR2			,
459 	p_org_id	        IN		NUMBER,
460 	p_activity_id	        IN		NUMBER -- inventory_item_id
461 );
462 
463 
464 
465 
466 END EAM_Activity_PUB;
467