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 AS
2 /* $Header: EAMPACTS.pls 120.1 2005/06/12 22:06:54 appldev  $ */
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 );
56 
57 TYPE Activity_Association_Tbl_Type IS TABLE OF Activity_Association_Rec_Type
58 	INDEX BY BINARY_INTEGER;
59 
60 
61 
62 -- Start of comments
63 --	API name 	: Create_Activity
64 --	Type		: Public
65 --	Function	:
66 --	Pre-reqs	: None.
67 --	Parameters	:
68 --	IN		:	p_api_version           	IN NUMBER	Required
69 --				p_init_msg_list			IN VARCHAR2 	Optional
70 --					Default = FND_API.G_FALSE
71 --				p_commit	    		IN VARCHAR2	Optional
72 --					Default = FND_API.G_FALSE
73 --				p_validation_level		IN NUMBER	Optional
74 --					Default = FND_API.G_VALID_LEVEL_FULL
75 --	p_asset_activity_name		IN	EAM_Activity_PUB.Item_Rec_Type,
76 --	p_asset_activity_description	IN	VARCHAR2 := NULL,
77 --      p_work_order_rec		IN	EAM_Activity_PUB.Work_Order_Rec_Type,
78 --	p_operation_copy_option		IN	VARCHAR2 := '2', -- 1 (NONE) or 2 (ALL)
79 --	p_material_copy_option		IN	VARCHAR2 := '2', -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
80 --	p_resource_copy_option		IN	VARCHAR2 := '2', -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
81 --	p_association_copy_option	IN	VARCHAR2 := '2', -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
82 
83 --	OUT		:
84 --				x_msg_count			OUT	NUMBER
85 --				x_msg_data			OUT	VARCHAR2(2000)
86 --	x_inventory_item_id		OUT	NUMBER -- the inventory_item_it the system has created
87 
88 --	Version	: Current version	1.0
89 --			  Initial version 	1.0
90 --
91 --	Notes		: EAM Business Object API to create Asset Activity from a Work Order.
92 --			Will assigne Activity to the Work Order's organization, and its master org.
93 --
94 -- End of comments
95 PROCEDURE Create_Activity
96 ( 	p_api_version           	IN	NUMBER				,
97   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
98 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
99 	p_validation_level		IN  	NUMBER	:=
100 						FND_API.G_VALID_LEVEL_FULL	,
101 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
102 	x_msg_count			OUT NOCOPY	NUMBER				,
103 	x_msg_data			OUT NOCOPY	VARCHAR2			,
104 
105 	p_asset_activity		IN	INV_Item_GRP.Item_Rec_Type,
106 	p_template_id			IN	NUMBER 		:= NULL,
107         p_template_name			IN	VARCHAR2 	:= NULL,
108 	p_activity_type_code		IN	VARCHAR2	:= NULL,
109 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
110 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
111 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
112 	p_activity_source_code		IN	VARCHAR2	:= NULL,
113 
114         p_work_order_rec		IN	EAM_Activity_PUB.Work_Order_Rec_Type,
115 	p_operation_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
116 	p_material_copy_option		IN	NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
117 	p_resource_copy_option		IN	NUMBER := 2, -- 1 (NONE), 2 (ISSUED), OR 3 (ALL)
118 	p_association_copy_option	IN	NUMBER := 2, -- 1 (NONE), 2 (CURRENT), OR 3 (ALL)
119 
120 --	x_inventory_item_id		OUT	NUMBER, -- the inventory_item_it the system has created
121 	x_work_order_rec		OUT	NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
122 
123 	x_curr_item_rec			OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
124 	x_curr_item_return_status	OUT	NOCOPY	VARCHAR2,
125 	x_curr_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
126 	x_master_item_rec		OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
127 	x_master_item_return_status	OUT	NOCOPY	VARCHAR2,
128 	x_master_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
129 
130 	x_rtg_header_rec		OUT	NOCOPY	BOM_Rtg_Pub.Rtg_Header_Rec_Type,
131 	x_rtg_revision_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
132 	x_operation_tbl			OUT	NOCOPY	BOM_Rtg_Pub.Operation_Tbl_Type,
133 	x_op_resource_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Op_Resource_Tbl_Type,
134 	x_sub_resource_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
135 	x_op_network_tbl		OUT	NOCOPY	BOM_Rtg_Pub.Op_Network_Tbl_Type,
136 	x_rtg_return_status		OUT	NOCOPY	VARCHAR2,
137 	x_rtg_msg_count			OUT	NOCOPY	NUMBER,
138 	x_rtg_msg_list			OUT	NOCOPY	Error_Handler.Error_Tbl_Type,
139 
140 	x_bom_header_rec		OUT	NOCOPY	BOM_BO_PUB.BOM_Head_Rec_Type,
141 	x_bom_revision_tbl		OUT	NOCOPY	BOM_BO_PUB.BOM_Revision_Tbl_Type,
142 	x_bom_component_tbl		OUT	NOCOPY	BOM_BO_PUB.BOM_Comps_Tbl_Type,
143 	x_bom_ref_designator_tbl	OUT	NOCOPY	BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
144 	x_bom_sub_component_tbl		OUT	NOCOPY	BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
145 	x_bom_return_status		OUT	NOCOPY	VARCHAR2,
146 	x_bom_msg_count			OUT	NOCOPY	NUMBER,
147 	x_bom_msg_list			OUT	NOCOPY	Error_Handler.Error_Tbl_Type,
148 
149 	x_assoc_return_status		OUT	NOCOPY	VARCHAR2,
150 	x_assoc_msg_count		OUT	NOCOPY	NUMBER,
151 	x_assoc_msg_data		OUT	NOCOPY	VARCHAR2,
152 	x_act_num_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type,
153 	x_activity_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type
154 );
155 
156 PROCEDURE Copy_Activity
157 ( 	p_api_version           	IN	NUMBER				,
158   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
159 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
160 	p_validation_level		IN  	NUMBER	:=
161 						FND_API.G_VALID_LEVEL_FULL	,
162 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
163 	x_msg_count			OUT NOCOPY	NUMBER				,
164 	x_msg_data			OUT NOCOPY	VARCHAR2			,
165 
166 	-- target activity, need to set org, item name, description
167 	p_asset_activity		IN	INV_Item_GRP.Item_Rec_Type,
168 
169 
170 	p_template_id			IN	NUMBER 		:= NULL,
171         p_template_name			IN	VARCHAR2 	:= NULL,
172 	p_activity_type_code		IN	VARCHAR2	:= NULL,
173 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
174 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
175 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
176 	p_activity_source_code		IN	VARCHAR2	:= NULL,
177 
178 	-- source Activity
179 	p_source_org_id			IN	NUMBER,
180 	p_source_activity_id		IN	NUMBER, -- inventory_item_id
181 	-- source BOM
182 	p_source_alt_bom_designator	IN	VARCHAR2	:= NULL,
183 	p_source_bom_rev_date		IN 	DATE		:= sysdate,
184 	-- source Routing
185 	p_source_alt_rtg_designator	IN	VARCHAR2	:= NULL,
186 	p_source_rtg_rev_date		IN	DATE		:= sysdate,
187 
188 	p_bom_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
189 	p_routing_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
190 	p_association_copy_option	IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
191 
192 	x_curr_item_rec			OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
193 	x_curr_item_return_status	OUT	NOCOPY	VARCHAR2,
194 	x_curr_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
195 	x_master_item_rec		OUT	NOCOPY	INV_Item_GRP.Item_Rec_Type,
196 	x_master_item_return_status	OUT	NOCOPY	VARCHAR2,
197 	x_master_item_error_tbl		OUT	NOCOPY	INV_Item_GRP.Error_Tbl_Type,
198 
199 	x_assoc_return_status		OUT	NOCOPY	VARCHAR2,
200 	x_assoc_msg_count		OUT	NOCOPY	NUMBER,
201 	x_assoc_msg_data		OUT	NOCOPY	VARCHAR2,
202 	x_act_num_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type,
203 	x_activity_association_tbl	OUT	NOCOPY	EAM_Activity_PUB.Activity_Association_Tbl_Type
204 );
205 
206 
207 PROCEDURE Create_Activity_From_Form (
208 	p_wip_entity_id			IN	NUMBER
209 	, p_asset_activity		IN	VARCHAR2 := NULL
210 	, p_segment1			IN	VARCHAR2 := NULL
211 	, p_segment2			IN	VARCHAR2 := NULL
212 	, p_segment3			IN	VARCHAR2 := NULL
213 	, p_segment4			IN	VARCHAR2 := NULL
214 	, p_segment5			IN	VARCHAR2 := NULL
215 	, p_segment6			IN	VARCHAR2 := NULL
216 	, p_segment7			IN	VARCHAR2 := NULL
217 	, p_segment8			IN	VARCHAR2 := NULL
218 	, p_segment9			IN	VARCHAR2 := NULL
219 	, p_segment10			IN	VARCHAR2 := NULL
220 	, p_segment11			IN	VARCHAR2 := NULL
221 	, p_segment12			IN	VARCHAR2 := NULL
222 	, p_segment13			IN	VARCHAR2 := NULL
223 	, p_segment14			IN	VARCHAR2 := NULL
224 	, p_segment15			IN	VARCHAR2 := NULL
225 	, p_segment16			IN	VARCHAR2 := NULL
226 	, p_segment17			IN	VARCHAR2 := NULL
227 	, p_segment18			IN	VARCHAR2 := NULL
228 	, p_segment19			IN	VARCHAR2 := NULL
229 	, p_segment20			IN	VARCHAR2 := NULL
230 	, p_description			IN	VARCHAR2
231 	, p_template_id			IN	NUMBER
232 	, p_activity_type_code		IN	VARCHAR2
233 	, p_activity_cause_code 	IN	VARCHAR2
234 	, p_shutdown_type_code		IN	VARCHAR2
235 	, p_notification_req_flag	IN	VARCHAR2
236 	, p_activity_source_code	IN	VARCHAR2
237 
238 	, p_operation_copy_option	IN	NUMBER
239 	, p_material_copy_option	IN	NUMBER
240 	, p_resource_copy_option	IN	NUMBER
241 	, p_association_copy_option	IN	NUMBER
242 	, x_successful			OUT NOCOPY	BOOLEAN
243 	);
244 
245 PROCEDURE Create_Activity_With_Template(
246  	p_api_version           	IN	NUMBER				,
247   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
248 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
249 	p_validation_level		IN  	NUMBER	:=
250 						FND_API.G_VALID_LEVEL_FULL	,
251 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
252 	x_msg_count			OUT NOCOPY	NUMBER				,
253 	x_msg_data			OUT NOCOPY	VARCHAR2			,
254 
255 	p_organization_id		IN	NUMBER 		:= NULL,
256 	p_organization_code		IN	NUMBER		:= NULL,
257 	p_asset_activity		IN	VARCHAR2 := NULL,
258 	p_segment1			IN	VARCHAR2 := NULL,
259 	p_segment2			IN	VARCHAR2 := NULL,
260 	p_segment3			IN	VARCHAR2 := NULL,
261 	p_segment4			IN	VARCHAR2 := NULL,
262 	p_segment5			IN	VARCHAR2 := NULL,
263 	p_segment6			IN	VARCHAR2 := NULL,
264 	p_segment7			IN	VARCHAR2 := NULL,
265 	p_segment8			IN	VARCHAR2 := NULL,
266 	p_segment9			IN	VARCHAR2 := NULL,
267 	p_segment10			IN	VARCHAR2 := NULL,
268 	p_segment11			IN	VARCHAR2 := NULL,
269 	p_segment12			IN	VARCHAR2 := NULL,
270 	p_segment13			IN	VARCHAR2 := NULL,
271 	p_segment14			IN	VARCHAR2 := NULL,
272 	p_segment15			IN	VARCHAR2 := NULL,
273 	p_segment16			IN	VARCHAR2 := NULL,
274 	p_segment17			IN	VARCHAR2 := NULL,
275 	p_segment18			IN	VARCHAR2 := NULL,
276 	p_segment19			IN	VARCHAR2 := NULL,
277 	p_segment20			IN	VARCHAR2 := NULL,
278 	p_description			IN	VARCHAR2,
279 	p_template_id			IN	NUMBER 		:= NULL,
280 	p_template_name			IN	VARCHAR2 	:= NULL,
281 	p_activity_type_code		IN	VARCHAR2	:= NULL,
282 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
283 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
284 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
285 	p_activity_source_code		IN	VARCHAR2	:= NULL,
286 
287 	x_curr_item_rec			OUT NOCOPY	INV_Item_GRP.Item_Rec_Type,
288 	x_curr_item_return_status	OUT NOCOPY	VARCHAR2,
289 	x_curr_item_error_tbl		OUT NOCOPY	INV_Item_GRP.Error_Tbl_Type,
290 	x_master_item_rec		OUT NOCOPY	INV_Item_GRP.Item_Rec_Type,
291 	x_master_item_return_status	OUT NOCOPY	VARCHAR2,
292 	x_master_item_error_tbl		OUT NOCOPY	INV_Item_GRP.Error_Tbl_Type
293 );
294 
295 -- From Saurabh
296 procedure create_bom_header(
297 	p_target_item_rec		IN INV_Item_GRP.Item_Rec_Type,
298 	--p_source_org_id			IN	NUMBER,
299 	--p_source_activity_id		IN	NUMBER, -- inventory_item_id
300 
301 	--p_material_copy_option		IN NUMBER,
302 
303 	x_bom_header_rec		OUT NOCOPY	BOM_BO_PUB.BOM_Head_Rec_Type,
304 	x_bom_revision_tbl		OUT NOCOPY	BOM_BO_PUB.BOM_Revision_Tbl_Type,
305 	x_bom_component_tbl		OUT NOCOPY	BOM_BO_PUB.BOM_Comps_Tbl_Type,
306 	x_bom_ref_designator_tbl	OUT NOCOPY	BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
307 	x_bom_sub_component_tbl		OUT NOCOPY	BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
308 	x_bom_return_status		OUT NOCOPY	VARCHAR2,
309 	x_bom_msg_count			OUT NOCOPY	NUMBER,
310 	x_bom_msg_list			OUT NOCOPY	Error_Handler.Error_Tbl_Type
311 );
312 
313 procedure create_bom_header_form(
314     --p_target_item_rec		IN INV_Item_GRP.Item_Rec_Type,
315     p_inventory_item_name varchar2,
316     p_organization_code varchar2,
317     x_return_status     OUT NOCOPY	VARCHAR2
318 );
319 
320 PROCEDURE Create_Activity_With_Template(
321  	--p_api_version           	IN	NUMBER				,
322   	--p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
323 	--p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
324 	--p_validation_level		IN  	NUMBER	:=
325 						--FND_API.G_VALID_LEVEL_FULL	,
326 	x_return_status			OUT NOCOPY	varchar2		  	,
327 	--x_msg_count			OUT	NUMBER				,
328 	--x_msg_data			OUT	VARCHAR2			,
329 
330 	p_organization_id		IN	NUMBER 		:= NULL,
331 	p_organization_code		IN	NUMBER		:= NULL,
332 	p_asset_activity		IN	VARCHAR2 := NULL,
333 	p_segment1			IN	VARCHAR2 := NULL,
334 	p_segment2			IN	VARCHAR2 := NULL,
335 	p_segment3			IN	VARCHAR2 := NULL,
336 	p_segment4			IN	VARCHAR2 := NULL,
337 	p_segment5			IN	VARCHAR2 := NULL,
338 	p_segment6			IN	VARCHAR2 := NULL,
339 	p_segment7			IN	VARCHAR2 := NULL,
340 	p_segment8			IN	VARCHAR2 := NULL,
341 	p_segment9			IN	VARCHAR2 := NULL,
342 	p_segment10			IN	VARCHAR2 := NULL,
343 	p_segment11			IN	VARCHAR2 := NULL,
344 	p_segment12			IN	VARCHAR2 := NULL,
345 	p_segment13			IN	VARCHAR2 := NULL,
346 	p_segment14			IN	VARCHAR2 := NULL,
347 	p_segment15			IN	VARCHAR2 := NULL,
348 	p_segment16			IN	VARCHAR2 := NULL,
349 	p_segment17			IN	VARCHAR2 := NULL,
350 	p_segment18			IN	VARCHAR2 := NULL,
351 	p_segment19			IN	VARCHAR2 := NULL,
352 	p_segment20			IN	VARCHAR2 := NULL,
353 	p_description			IN	VARCHAR2,
354 	p_template_id			IN	NUMBER 		:= NULL,
355 	p_template_name			IN	VARCHAR2 	:= NULL,
356 	p_activity_type_code		IN	VARCHAR2	:= NULL,
357 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
358 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
359 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
360 	p_activity_source_code		IN	VARCHAR2	:= NULL
361 
362 	--x_curr_item_rec			OUT	INV_Item_GRP.Item_Rec_Type,
363 	--x_curr_item_return_status	OUT	VARCHAR2,
364 	--x_curr_item_error_tbl		OUT	INV_Item_GRP.Error_Tbl_Type,
365 	--x_master_item_rec		OUT	INV_Item_GRP.Item_Rec_Type,
366 	--x_master_item_return_status	OUT	VARCHAR2,
367 	--x_master_item_error_tbl		OUT	INV_Item_GRP.Error_Tbl_Type
368 );
369 
370 PROCEDURE Create_Routing_Header(
371 	p_target_item_rec			IN INV_Item_GRP.Item_Rec_Type,
372 
373 	x_rtg_header_rec		OUT NOCOPY	BOM_Rtg_Pub.Rtg_Header_Rec_Type,
374 	x_rtg_revision_tbl		OUT NOCOPY	BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
375 	x_operation_tbl			OUT NOCOPY	BOM_Rtg_Pub.Operation_Tbl_Type,
376 	x_op_resource_tbl		OUT NOCOPY	BOM_Rtg_Pub.Op_Resource_Tbl_Type,
377 	x_sub_resource_tbl		OUT NOCOPY	BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
378 	x_op_network_tbl		OUT NOCOPY	BOM_Rtg_Pub.Op_Network_Tbl_Type,
379 	x_rtg_return_status		OUT NOCOPY	VARCHAR2,
380 	x_rtg_msg_count			OUT NOCOPY	NUMBER,
381 	x_rtg_msg_list			OUT NOCOPY	Error_Handler.Error_Tbl_Type
382 );
383 
384 procedure create_routing_header_form(
385     --p_target_item_rec		IN INV_Item_GRP.Item_Rec_Type,
386     p_inventory_item_name varchar2,
387     p_organization_code varchar2,
388     x_return_status     OUT NOCOPY	VARCHAR2
389 );
390 
391 -- from Saurabh
392 -- package spec.
393 -- wrapper API used to call Copy_Activity procedure from form
394 procedure Copy_Activity(
395     	p_api_version           	IN	NUMBER				,
396   	p_init_msg_list			IN	VARCHAR2 := FND_API.G_FALSE	,
397 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE	,
398 	p_validation_level		IN  	NUMBER	:=
399 						FND_API.G_VALID_LEVEL_FULL	,
400 	x_return_status			OUT NOCOPY	VARCHAR2		  	,
401 	x_msg_count			OUT NOCOPY	NUMBER				,
402 	x_msg_data			OUT NOCOPY	VARCHAR2			,
403 
404     	p_activity_item_name 		IN 	VARCHAR2 := NULL,
405 	p_segment1			IN	VARCHAR2 := NULL,
406 	p_segment2			IN	VARCHAR2 := NULL,
407 	p_segment3			IN	VARCHAR2 := NULL,
408 	p_segment4			IN	VARCHAR2 := NULL,
409 	p_segment5			IN	VARCHAR2 := NULL,
410 	p_segment6			IN	VARCHAR2 := NULL,
411 	p_segment7			IN	VARCHAR2 := NULL,
412 	p_segment8			IN	VARCHAR2 := NULL,
413 	p_segment9			IN	VARCHAR2 := NULL,
414 	p_segment10			IN	VARCHAR2 := NULL,
415 	p_segment11			IN	VARCHAR2 := NULL,
416 	p_segment12			IN	VARCHAR2 := NULL,
417 	p_segment13			IN	VARCHAR2 := NULL,
418 	p_segment14			IN	VARCHAR2 := NULL,
419 	p_segment15			IN	VARCHAR2 := NULL,
420 	p_segment16			IN	VARCHAR2 := NULL,
421 	p_segment17			IN	VARCHAR2 := NULL,
422 	p_segment18			IN	VARCHAR2 := NULL,
423 	p_segment19			IN	VARCHAR2 := NULL,
424 	p_segment20			IN	VARCHAR2 := NULL,
425 	p_activity_org_id 		IN 	NUMBER,
426 	p_activity_description 		IN	VARCHAR2,
427 
428     	p_template_id			IN	NUMBER 		:= NULL,
429         p_template_name			IN	VARCHAR2 	:= NULL,
430         p_activity_type_code		IN	VARCHAR2	:= NULL,
431 	p_activity_cause_code 		IN	VARCHAR2	:= NULL,
432 	p_shutdown_type_code		IN	VARCHAR2	:= NULL,
433 	p_notification_req_flag		IN	VARCHAR2	:= NULL,
434 	p_activity_source_code		IN	VARCHAR2	:= NULL,
435 
436 	-- source Activity
437 	p_source_org_id			IN	NUMBER,
438 	p_source_activity_id		IN	NUMBER, -- inventory_item_id
439     	p_bom_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
440 	p_routing_copy_option		IN	NUMBER := 2, -- 1 (NONE) or 2 (ALL)
441 	p_association_copy_option	IN	NUMBER := 2 -- 1 (NONE) or 2 (ALL)
442 
443 );
444 
445 /* Procedure to assign the activity to the current maintenance organization */
446 
447 PROCEDURE Activity_org_assign
448 ( 	p_api_version           IN   	        NUMBER				,
449 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
450 	x_msg_count		OUT NOCOPY	NUMBER				,
451 	x_msg_data		OUT NOCOPY	VARCHAR2			,
452 	p_org_id	        IN		NUMBER,
453 	p_activity_id	        IN		NUMBER -- inventory_item_id
454 );
455 
456 
457 
458 
459 END EAM_Activity_PUB;
460