1 PACKAGE EAM_WOREP_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPWORS.pls 120.2 2011/04/09 22:40:22 somitra ship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMPWORS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_WOREP_PUB
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 20-MARCH-2006 Smriti Sharma Initial Creation
21 ***************************************************************************/
22
23
24 PROCEDURE Work_Order_CP
25 (errbuf OUT NOCOPY VARCHAR2
26 , retcode OUT NOCOPY VARCHAR2
27 , p_work_order_from IN VARCHAR2
28 , p_work_order_to IN VARCHAR2
29 , p_scheduled_start_date_from IN VARCHAR2
30 , p_scheduled_start_date_to IN VARCHAR2
31 , p_asset_area_from IN VARCHAR2
32 , p_asset_area_to IN VARCHAR2
33 , p_asset_number IN VARCHAR2
34 , p_status_type IN NUMBER
35 , p_assigned_department IN NUMBER
36 , p_organization_id IN NUMBER
37 , p_operation IN NUMBER
38 , p_resource IN NUMBER
39 , p_material IN NUMBER
40 , p_direct_item IN NUMBER
41 , p_work_request IN NUMBER
42 , p_meter IN NUMBER
43 , p_quality_plan IN NUMBER
44 , p_mandatory IN NUMBER
45 , p_attachment IN NUMBER
46 , p_asset_bom IN NUMBER
47 , p_permit IN NUMBER --added bug 9812863
48 , p_clearance IN NUMBER
49 );
50
51
52
53 END;
54