1 PACKAGE EAM_WOREP_PUB AS
2 /* $Header: EAMPWORS.pls 120.0 2006/03/29 06:45:40 smrsharm noship $ */
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 );
48
49
50
51 END;
52