DBA Data[Home] [Help]

PACKAGE: APPS.EAM_UTILITY_GRP

Source


1 PACKAGE EAM_UTILITY_GRP AUTHID CURRENT_USER AS
2 /* $Header: EAMGUTLS.pls 120.0 2005/06/22 14:09:42 amondal noship $ */
3 /***************************************************************************
4 --
5 --  Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --
8 --  FILENAME
9 --
10 --      EAMGUTLS.pls
11 --
12 --  DESCRIPTION
13 --
14 --      Spec of package EAM_UTILITY_GRP
15 --
16 --  NOTES
17 --
18 --  HISTORY
19 --
20 --  16-MAY-2005   Anju Gupta      Initial Creation
21 ***************************************************************************/
22 
23 TYPE REPLACE_REBUILD_REC_type IS RECORD
24 
25 (
26   instance_id   NUMBER := NULL
27 );
28 
29 
30 
31 TYPE REPLACE_REBUILD_tbl_type IS TABLE OF REPLACE_REBUILD_REC_type INDEX BY BINARY_INTEGER;
32 
33 
34 PROCEDURE Get_ReplacedRebuilds (
35                   p_api_version      IN  NUMBER,
36                   p_commit           IN  VARCHAR2 := FND_API.G_FALSE,
37                   p_validation_level IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
38                   p_init_msg_list    IN  VARCHAR2 := FND_API.G_FALSE,
39 	          p_wip_entity_id   	    IN         number,
40                   p_organization_id         IN         number,
41 
42                   x_replaced_rebuild_tbl    OUT nocopy EAM_UTILITY_GRP.REPLACE_REBUILD_tbl_type,
43                   x_return_status           OUT nocopy varchar2,
44                   x_msg_count               OUT NOCOPY  NUMBER,
45                   x_msg_data                OUT NOCOPY  VARCHAR2
46 	);
47 
48 /* Function to get next maintenance date for an equipment for OSFM*/
49 
50 FUNCTION get_next_maintenance_date( p_organization_id NUMBER,
51 				    p_resource_id NUMBER,
52 				    p_gen_object_id NUMBER)
53                               	 return DATE;
54 
55 END  EAM_UTILITY_GRP;