1 PACKAGE EAM_SAFETY_ASSET_NUMBER_PUB AUTHID CURRENT_USER as
2 /* $Header: EAMPSAFS.pls 120.0 2011/02/23 16:36:47 srkotika noship $ */
3
4 TYPE eam_asset_safety_info_rec_type IS RECORD
5 ( INSTANCE_ID NUMBER
6 ,SAFETY_TYPE NUMBER
7 ,OPERATING_POSITION NUMBER
8 ,OPERATING_TAG NUMBER
9 ,SHUTDOWN_POSITION NUMBER
10 ,SHUTDOWN_TAG NUMBER
11 ,POS_LOCKOUT_DEVICE NUMBER
12 ,LOCKOUT_DEVICE NUMBER
13 );
14
15 TYPE eam_asset_safety_info_tbl_type IS TABLE OF eam_asset_safety_info_rec_type
16 INDEX BY BINARY_INTEGER;
17
18
19
20
21 PROCEDURE CREATEUPDATE_ASSET_SAFETY_INFO
22 (
23 p_api_version IN NUMBER
24 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
25 ,p_eAM_asset_safety_tbl IN EAM_SAFETY_ASSET_NUMBER_PUB.eam_asset_safety_info_tbl_type
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31
32
33 END EAM_SAFETY_ASSET_NUMBER_PUB;