1 PACKAGE EAM_ASSET_LOG_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVALGS.pls 120.7 2005/10/05 03:04:22 jamulu noship $ */
3 -- Start of comments
4 -- API name : EAM_ASSET_LOG_PVT.INSERT_ROW
5 -- Type : Private
6 -- Function :
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN P_api_version Required Version Of The Api
10 -- P_init_msg_list Optional Flag To Indicate Initialization Of Message List
11 -- Default = Fnd_api.g_false
12 -- P_commit Optional Flag To Indicate Whether Api Should Commit Changes
13 -- Default = Fnd_api.g_false
14 -- P_validation_level Optional Flag To Indicate Validation Level
15 -- Default = Fnd_api.g_valid_level_full
16 -- P_event_date Optional Indicates Event Date Of The Asset Log
17 -- Default = Sysdate
18 -- P_event_type Optional Name Of Event Type Of The Asset Log Event
19 -- P_event_id Optional Event Id Which Gets Logged.
20 -- P_organization_id Optional Organization Id Which Maintains The Asset
21 -- P_instance_id Required Asset Id Identifier Of The Asset Or Rebuildable.
22 -- P_comments Optional To Log Additional Information / Remarks About The Event On Which Log
23 -- Is Generated.
24 -- P_reference Optional Reference Number Of The Event Eg: Wo Number, Wr Number, Jo Number, Etc.
25 -- P_ref_id Optional Primary Key Identification Of The Reference.
26 -- P_operable_flag Optional Status Of The Asset Or Rebuildable At The Time Of Event Log.
27 -- P_reason_code Optional Reason Code For Generation Of Event Log.
28 -- P_resource_id Optional Prime Identification Of The Resource Instance Attached To The Asset.
29 -- P_equipment_gen_object_id Optional Identification Of The Osfm Resource Attached To The Asset.
30 -- P_source_log_id Optional Identification Of The Transaction Where Logging Is Based On Resource Which
31 -- Got Multiple Assets Attached To It.
32 -- P_instance_number Optional Asset Number / Asset Instance Number Identification
33 -- P_downcode Optional Resource Down Code Of Osfm Resource Attached To The Asset Which Generated The Asset Log
34 -- P_expected_up_date Optional Expected Up Date Of An Osfm Resource At The Time Of Event Log.
35 -- P_employee_id Optional Identification Of The Employee In Osfm Who Creates The Event Log.
36 -- P_department_id Optional Identification Of The Department Which Identifies This Asset As Resource.
37 -- P_attribute_category Optional Dff Information
38 -- P_attribute1 Optional Dff Information
39 -- P_attribute2 Optional Dff Information
40 -- P_attribute3 Optional Dff Information
41 -- P_attribute4 Optional Dff Information
42 -- P_attribute5 Optional Dff Information
43 -- P_attribute6 Optional Dff Information
44 -- P_attribute7 Optional Dff Information
45 -- P_attribute8 Optional Dff Information
46 -- P_attribute9 Optional Dff Information
47 -- P_attribute10 Optional Dff Information
48 -- P_attribute11 Optional Dff Information
49 -- P_attribute12 Optional Dff Information
50 -- P_attribute13 Optional Dff Information
51 -- P_attribute14 Optional Dff Information
52 -- P_attribute15 Optional Dff Information
53 -- P_last_update_date Required Stadard Who Column Values
54 -- P_last_updated_by Required Stadard Who Column Values
55 -- P_creation_date Required Stadard Who Column Values
56 -- P_created_by Required Stadard Who Column Values
57 -- P_last_update_login Required Stadard Who Column Values
58 -- OUT X_return_status Required Return Status Of The Procedure Call
59 -- X_msg_count Required Count Of The Return Messages That Api Returns
60 -- X_msg_data Required The Collection Of The Messages
61 --
62 -- End of comments
63
64 PROCEDURE insert_row(
65 p_log_id IN number := NULL,
66 p_api_version IN number := 1.0,
67 p_init_msg_list IN varchar2 := fnd_api.g_false,
68 p_commit IN varchar2 := fnd_api.g_false,
69 p_validation_level IN number := fnd_api.g_valid_level_full,
70 p_event_date IN date := sysdate,
71 p_event_type IN varchar2 := NULL,
72 p_event_id IN number := NULL,
73 p_organization_id IN number := NULL,
74 p_instance_id IN number,
75 p_comments IN varchar2 := NULL,
76 p_reference IN varchar2 := NULL,
77 p_ref_id IN number := NULL,
78 p_operable_flag IN number := NULL,
79 p_reason_code IN number := NULL,
80 p_resource_id IN number := NULL,
81 p_equipment_gen_object_id IN number := NULL,
82 p_source_log_id IN number := NULL,
83 p_instance_number IN varchar2 := NULL,
84 p_downcode IN number := NULL,
85 p_expected_up_date IN date := NULL,
86 p_employee_id IN number := NULL,
87 p_department_id IN number := NULL,
88 p_attribute_category IN varchar2 := NULL,
89 p_attribute1 IN varchar2 := NULL,
90 p_attribute2 IN varchar2 := NULL,
91 p_attribute3 IN varchar2 := NULL,
92 p_attribute4 IN varchar2 := NULL,
93 p_attribute5 IN varchar2 := NULL,
94 p_attribute6 IN varchar2 := NULL,
95 p_attribute7 IN varchar2 := NULL,
96 p_attribute8 IN varchar2 := NULL,
97 p_attribute9 IN varchar2 := NULL,
98 p_attribute10 IN varchar2 := NULL,
99 p_attribute11 IN varchar2 := NULL,
100 p_attribute12 IN varchar2 := NULL,
101 p_attribute13 IN varchar2 := NULL,
102 p_attribute14 IN varchar2 := NULL,
103 p_attribute15 IN varchar2 := NULL,
104 x_return_status OUT NOCOPY varchar2,
105 x_msg_count OUT NOCOPY number,
106 x_msg_data OUT NOCOPY varchar2);
107
108 -- Start of comments
109 -- API name : EAM_ASSET_LOG_PVT.VALIDATE_EVENT
110 -- Type : Private
111 -- Function :
112 -- Pre-reqs : None.
113 -- Parameters :
114 -- IN P_api_version Required Version Of The Api
115 -- P_init_msg_list Optional Flag To Indicate Initialization Of Message List
116 -- Default = Fnd_api.g_false
117 -- P_commit Optional Flag To Indicate Whether Api Should Commit Changes
118 -- Default = Fnd_api.g_false
119 -- P_validation_level Optional Flag To Indicate Validation Level
120 -- Default = Fnd_api.g_valid_level_full
121 -- P_event_date Optional Indicates Event Date Of The Asset Log
122 -- Default = Sysdate
123 -- P_event_type Optional Name Of Event Type Of The Asset Log Event
124 -- P_event_id Optional Event Id Which Gets Logged.
125 -- P_instance_id Required Asset Id Identifier Of The Asset Or Rebuildable.
126 -- P_instance_number Optional Asset Number / Asset Instance Number Identification
127 -- P_operable_flag Optional Status Of The Asset Or Rebuildable At The Time Of Event Log.
128 -- P_reason_code Optional Reason Code For Generation Of Event Log.
129 -- P_resource_id Optional Prime Identification Of The Resource Instance Attached To The Asset.
130 -- P_downcode Optional Resource Down Code Of Osfm Resource Attached To The Asset Which Generated The Asset Log
131 -- P_expected_up_date Optional Expected Up Date Of An Osfm Resource At The Time Of Event Log.
132 -- OUT X_return_status Required Return Status Of The Procedure Call
133 -- X_msg_count Required Count Of The Return Messages That Api Returns
134 -- X_msg_data Required The Collection Of The Messages
135 --
136 -- End of comments
137
138 PROCEDURE validate_event(
139 p_api_version IN number := 1.0,
140 p_init_msg_list IN varchar2 := fnd_api.g_false,
141 p_commit IN varchar2 := fnd_api.g_false,
142 p_validation_level IN number := fnd_api.g_valid_level_full,
143 p_event_date IN date := sysdate,
144 p_event_type IN varchar2 := NULL,
145 p_event_id IN number := NULL,
146 p_instance_id IN number := NULL,
147 p_instance_number IN varchar2 := NULL,
148 p_operable_flag IN number := NULL,
149 p_reason_code IN number := NULL,
150 p_resource_id IN number := NULL,
151 p_equipment_gen_object_id IN number := NULL,
152 p_downcode IN number := NULL,
153 p_expected_up_date IN date := NULL,
154 x_return_status OUT NOCOPY varchar2,
155 x_msg_count OUT NOCOPY number,
156 x_msg_data OUT NOCOPY varchar2);
157
158 -- Start of comments
159 -- API name : EAM_ASSET_LOG_PVT.DELETE_ROW
160 -- Type : Private
161 -- Function :
162 -- Pre-reqs : None.
163 -- Parameters :
164 -- IN P_start_date Required Indicates Event Start Date Of The Asset Log To Purge
165 -- P_end_date Required Indicates Event End Date Of The Asset Log To Purge
166 -- P_event_type Optional Name Of Event Type Of The Asset Log Event
167 -- P_instance_id Optional Asset Instance Identification
168 -- P_asset_group Optional Asset Group Identification
169 -- P_equipment_gen_object_id Optional Identification Of The Osfm Resource Attached To The Asset.
170 -- P_resource_id Optional Prime Identification Of The Resource Instance Attached To The Asset.
171 -- P_organization_id Optional Organization Id Which Maintains The Asset
172 -- OUT Errbuf Required Contains Error Message
173 -- Retcode Required Return Code To Identify The Event Status
174 --
175 -- End of comments
176
177 PROCEDURE delete_row(
178 errbuf OUT NOCOPY varchar2,
179 retcode OUT NOCOPY number,
180 p_start_date IN varchar2,
181 p_end_date IN varchar2,
182 p_asset_group IN number,
183 p_instance_id IN number,
184 p_event_type IN varchar2,
185 p_event_id IN number,
186 p_resource_id IN number,
187 p_organization_id IN number,
188 p_equipment_gen_object_id IN number);
189
190 -- Start of comments
191 -- API name : EAM_ASSET_LOG_PVT.INSTANCE_UPDATE_EVENT
192 -- Type : Private
193 -- Function :
194 -- Pre-reqs : None.
195 -- Parameters :
196 -- IN P_api_version Required Version Of The Api
197 -- P_init_msg_list Optional Flag To Indicate Initialization Of Message List
198 -- Default = Fnd_api.g_false
199 -- P_commit Optional Flag To Indicate Whether Api Should Commit Changes
200 -- Default = Fnd_api.g_false
201 -- P_validation_level Optional Flag To Indicate Validation Level
202 -- Default = Fnd_api.g_valid_level_full
203 -- P_event_date Optional Indicates Event Date Of The Asset Log
204 -- Default = Sysdate
205 -- P_event_type Optional Name Of Event Type Of The Asset Log Event
206 -- P_event_id Optional Event Id Which Gets Logged.
207 -- P_instance_id Required Asset Id Identifier Of The Asset Or Rebuildable.
208 -- P_ref_id Optional Primary Key Identification Of The Reference.
209 -- P_organization_id Optional Organization Id Which Maintains The Asset
210 -- OUT X_return_status Required Return Status Of The Procedure Call
211 -- X_msg_count Required Count Of The Return Messages That Api Returns
212 -- X_msg_data Required The Collection Of The Messages
213 --
214 -- End of comments
215
216 PROCEDURE instance_update_event(
217 p_api_version IN number := 1.0,
218 p_init_msg_list IN varchar2 := fnd_api.g_false,
219 p_commit IN varchar2 := fnd_api.g_false,
220 p_validation_level IN number := fnd_api.g_valid_level_full,
221 p_event_date IN date,
222 p_event_type IN varchar2 := 'EAM_SYSTEM_EVENTS',
223 p_event_id IN number := NULL,
224 p_instance_id IN number,
225 p_ref_id IN number,
226 p_organization_id IN number := NULL,
227 x_return_status OUT NOCOPY varchar2,
228 x_msg_count OUT NOCOPY number,
229 x_msg_data OUT NOCOPY varchar2);
230
231 -- API name : EAM_ASSET_LOG_PVT.INSERT_METER_LOG
232 -- Type : Private
233 -- Function :
234 -- Pre-reqs : None.
235 -- Parameters :
236 -- IN P_api_version Required Version Of The Api
237 -- P_init_msg_list Optional Flag To Indicate Initialization Of Message List
238 -- Default = Fnd_api.g_false
239 -- P_commit Optional Flag To Indicate Whether Api Should Commit Changes
240 -- Default = Fnd_api.g_false
241 -- P_validation_level Optional Flag To Indicate Validation Level
242 -- Default = Fnd_api.g_valid_level_full
243 -- P_event_date Optional Indicates Event Date Of The Asset Log
244 -- Default = Sysdate
245 -- P_instance_id Required Asset Id Identifier Of The Asset Or Rebuildable.
246 -- P_ref_id Optional Primary Key Identification Of The Reference.
247 -- P_attribute_category Optional Dff Information
248 -- P_attribute1 Optional Dff Information
249 -- P_attribute2 Optional Dff Information
250 -- P_attribute3 Optional Dff Information
251 -- P_attribute4 Optional Dff Information
252 -- P_attribute5 Optional Dff Information
253 -- P_attribute6 Optional Dff Information
254 -- P_attribute7 Optional Dff Information
255 -- P_attribute8 Optional Dff Information
256 -- P_attribute9 Optional Dff Information
257 -- P_attribute10 Optional Dff Information
258 -- P_attribute11 Optional Dff Information
259 -- P_attribute12 Optional Dff Information
260 -- P_attribute13 Optional Dff Information
261 -- P_attribute14 Optional Dff Information
262 -- P_attribute15 Optional Dff Information
263 -- OUT X_return_status Required Return Status Of The Procedure Call
264 -- X_msg_count Required Count Of The Return Messages That Api Returns
265 -- X_msg_data Required The Collection Of The Messages
266 --
267 -- End of comments
268
269 PROCEDURE insert_meter_log(
270 p_api_version IN number := 1.0,
271 p_init_msg_list IN varchar2 := fnd_api.g_false,
272 p_commit IN varchar2 := fnd_api.g_false,
273 p_validation_level IN number := fnd_api.g_valid_level_full,
274 p_event_date IN date := sysdate,
275 p_instance_id IN number := NULL,
276 p_ref_id IN number,
277 p_attribute_category IN varchar2 := NULL,
278 p_attribute1 IN varchar2 := NULL,
279 p_attribute2 IN varchar2 := NULL,
280 p_attribute3 IN varchar2 := NULL,
281 p_attribute4 IN varchar2 := NULL,
282 p_attribute5 IN varchar2 := NULL,
283 p_attribute6 IN varchar2 := NULL,
284 p_attribute7 IN varchar2 := NULL,
285 p_attribute8 IN varchar2 := NULL,
286 p_attribute9 IN varchar2 := NULL,
287 p_attribute10 IN varchar2 := NULL,
288 p_attribute11 IN varchar2 := NULL,
289 p_attribute12 IN varchar2 := NULL,
290 p_attribute13 IN varchar2 := NULL,
291 p_attribute14 IN varchar2 := NULL,
292 p_attribute15 IN varchar2 := NULL,
293 x_return_status OUT NOCOPY varchar2,
294 x_msg_count OUT NOCOPY number,
295 x_msg_data OUT NOCOPY varchar2);
296
297 END EAM_ASSET_LOG_PVT;