1 PACKAGE EAM_FailureSets_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPFSPS.pls 120.0 2006/03/08 07:20:14 sshahid noship $ */
3 TYPE eam_failureset_rec_type IS RECORD
4 (set_name VARCHAR2(80) ,
5 description VARCHAR2(240) ,
6 effective_end_date DATE ,
7 set_id NUMBER ,
8 stored_last_upd_date DATE);
9
10 TYPE eam_set_association_rec_type IS RECORD
11 (set_id NUMBER ,
12 set_name VARCHAR2(80) ,
13 inventory_item_id NUMBER ,
14 failure_code_required VARCHAR2(1) ,
15 effective_end_date DATE ,
16 stored_last_upd_date DATE ,
17 created_by NUMBER ,
18 creation_date DATE ,
19 last_update_date DATE ,
20 last_updated_by NUMBER ,
21 last_update_login NUMBER);
22
23 /**************************************************************************
24 -- Start of comments
25 -- API name : Create_FailureSet
26 -- Type : Public.
27 -- Function : Create Failure Set with failure set
28 -- information passed to this API.
29 -- Pre-reqs : None.
30 -- Parameters :
31 -- IN : p_api_version IN NUMBER Required
32 -- p_init_msg_list IN VARCHAR2 Optional
33 -- Default = FND_API.G_FALSE
34 -- p_commit IN VARCHAR2 Optional
35 -- Default = FND_API.G_FALSE
36 -- p_failureset_rec IN
37 -- EAM_FailureSets_PUB.eam_failureset_rec_type
38 -- Within p_failure_set_rec, set_name column
39 -- is 'Required'
40 -- OUT : x_return_status OUT VARCHAR2(1)
41 -- x_msg_count OUT NUMBER
42 -- x_msg_data OUT VARCHAR2(2000)
43 -- x_failureset_id OUT NUMBER
44 -- Version : Current version 1.0.
45 -- Initial version 1.0
46 -- End of comments
47 ***************************************************************************/
48 PROCEDURE Create_FailureSet
49 (p_api_version IN NUMBER ,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52 p_failureset_rec IN EAM_FailureSets_PUB.eam_failureset_rec_type,
53 x_return_status OUT NOCOPY VARCHAR2 ,
54 x_msg_count OUT NOCOPY NUMBER ,
55 x_msg_data OUT NOCOPY VARCHAR2 ,
56 x_failureset_id OUT NOCOPY NUMBER
57 );
58
59 /**************************************************************************
60 -- Start of comments
61 -- API name : Update_FailureSet
62 -- Type : Public.
63 -- Function : Update Failure Set with failure set
64 -- information passed to this API.
65 -- Pre-reqs : None.
66 -- Parameters :
67 -- IN : p_api_version IN NUMBER Required
68 -- p_init_msg_list IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_commit IN VARCHAR2 Optional
71 -- Default = FND_API.G_FALSE
72 -- p_failureset_rec IN
73 -- EAM_FailureSets_PUB.eam_failureset_rec_type
74 -- Within p_failure_set_rec, either set_name or
75 -- set_id should have a value in update mode.
76 -- OUT : x_return_status OUT VARCHAR2(1)
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2(2000)
79 -- x_failureset_id OUT NUMBER
80 -- Version : Current version 1.0.
81 -- Initial version 1.0
82 -- End of comments
83 ***************************************************************************/
84 PROCEDURE Update_FailureSet
85 (p_api_version IN NUMBER ,
86 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
87 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
88 p_failureset_rec IN EAM_FailureSets_PUB.eam_failureset_rec_type,
89 x_return_status OUT NOCOPY VARCHAR2 ,
90 x_msg_count OUT NOCOPY NUMBER ,
91 x_msg_data OUT NOCOPY VARCHAR2 ,
92 x_failureset_id OUT NOCOPY NUMBER
93 );
94 /**************************************************************************
95 -- Start of comments
96 -- API name : Create_Association
97 -- Type : Public.
98 -- Function : Create Failure Set association with asset group/
99 rebuildable
100 -- Pre-reqs : None.
101 -- Parameters :
102 -- IN : p_api_version IN NUMBER Required
103 -- p_init_msg_list IN VARCHAR2 Optional
104 -- Default = FND_API.G_FALSE
105 -- p_commit IN VARCHAR2 Optional
106 -- Default = FND_API.G_FALSE
107 -- p_association_rec IN
108 -- EAM_FailureSets_PUB.eam_set_association_rec_type
109 -- Within p_association_rec, set_id or set_name column
110 -- is 'Required' and inventory_item_id (of the asset group
111 -- or rebuildable item) is 'Required'
112 -- OUT : x_return_status OUT VARCHAR2(1)
113 -- x_msg_count OUT NUMBER
114 -- x_msg_data OUT VARCHAR2(2000)
115 -- x_failureset_id OUT NUMBER
116 -- Version : Current version 1.0.
117 -- Initial version 1.0
118 -- End of comments
119 ***************************************************************************/
120 PROCEDURE Create_Association
121 (p_api_version IN NUMBER ,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
124 p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
125 x_return_status OUT NOCOPY VARCHAR2 ,
126 x_msg_count OUT NOCOPY NUMBER ,
127 x_msg_data OUT NOCOPY VARCHAR2
128 );
129 /**************************************************************************
130 -- Start of comments
131 -- API name : Update_Association
132 -- Type : Public.
133 -- Function : Update Failure Set association with asset group/
134 rebuildable - failure required flag
135 -- Pre-reqs : None.
136 -- Parameters :
137 -- IN : p_api_version IN NUMBER Required
138 -- p_init_msg_list IN VARCHAR2 Optional
139 -- Default = FND_API.G_FALSE
140 -- p_commit IN VARCHAR2 Optional
141 -- Default = FND_API.G_FALSE
142 -- p_association_rec IN
143 -- EAM_FailureSets_PUB.eam_set_association_rec_type
144 -- Within p_association_rec, set_id or set_name column
145 -- is 'Required' and inventory_item_id (of the asset group
146 -- or rebuildable item) is 'Required'
147 -- OUT : x_return_status OUT VARCHAR2(1)
148 -- x_msg_count OUT NUMBER
149 -- x_msg_data OUT VARCHAR2(2000)
150 -- x_failureset_id OUT NUMBER
151 -- Version : Current version 1.0.
152 -- Initial version 1.0
153 -- End of comments
154 ***************************************************************************/
155 PROCEDURE Update_Association
156 (p_api_version IN NUMBER ,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
158 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159 p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
160 x_return_status OUT NOCOPY VARCHAR2 ,
161 x_msg_count OUT NOCOPY NUMBER ,
162 x_msg_data OUT NOCOPY VARCHAR2
163 );
164 /**************************************************************************
165 -- Start of comments
166 -- API name : Delete_Association
167 -- Type : Public.
168 -- Function : Delete Failure Set association with asset group/
169 rebuildable
170 -- Pre-reqs : None.
171 -- Parameters :
172 -- IN : p_api_version IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional
174 -- Default = FND_API.G_FALSE
175 -- p_commit IN VARCHAR2 Optional
176 -- Default = FND_API.G_FALSE
177 -- p_association_rec IN
178 -- EAM_FailureSets_PUB.eam_set_association_rec_type
179 -- Within p_association_rec, set_id or set_name column
180 -- is 'Required' and inventory_item_id (of the asset group
181 -- or rebuildable item) is 'Required'
182 -- OUT : x_return_status OUT VARCHAR2(1)
183 -- x_msg_count OUT NUMBER
184 -- x_msg_data OUT VARCHAR2(2000)
185 -- x_failureset_id OUT NUMBER
186 -- Version : Current version 1.0.
187 -- Initial version 1.0
188 -- End of comments
189 ***************************************************************************/
190 PROCEDURE Delete_Association
191 (p_api_version IN NUMBER ,
192 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
193 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
194 p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
195 x_return_status OUT NOCOPY VARCHAR2 ,
196 x_msg_count OUT NOCOPY NUMBER ,
197 x_msg_data OUT NOCOPY VARCHAR2
198 );
199 END EAM_FailureSets_PUB;