1 PACKAGE PV_Ge_Hist_Log_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvghls.pls 115.5 2003/08/08 23:53:09 ktsao ship $ */
3
4 -- ===============================================================
5 -- Start of Comments
6 -- Package name
7 -- PV_Ge_Hist_Log_PVT
8 -- Purpose
9 --
10 -- History
11 --
12 -- NOTE
13 --
14 -- This Api is generated with Latest version of
15 -- Rosetta, where g_miss indicates NULL and
16 -- NULL indicates missing value. Rosetta Version 1.55
17 -- End of Comments
18 -- ===============================================================
19
20 -- Default number of records fetch per call
21 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
22 --===================================================================
23 -- Start of Comments
24 -- -------------------------------------------------------
25 -- Record name
26 -- ge_hist_log_rec_type
27 -- -------------------------------------------------------
28 -- Parameters:
29 -- entity_history_log_id
30 -- object_version_number
31 -- arc_history_for_entity_code
32 -- history_for_entity_id
33 -- message_code
34 -- history_category_code
35 -- created_by
36 -- creation_date
37 -- last_updated_by
38 -- last_update_date
39 -- last_update_login
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE ge_hist_log_rec_type IS RECORD
52 (
53 entity_history_log_id NUMBER,
54 object_version_number NUMBER,
55 arc_history_for_entity_code VARCHAR2(30),
56 history_for_entity_id NUMBER,
57 message_code VARCHAR2(30),
58 history_category_code VARCHAR2(30),
59 created_by NUMBER,
60 creation_date DATE,
61 last_updated_by NUMBER,
62 last_update_date DATE,
63 last_update_login NUMBER,
64 partner_id NUMBER,
65 access_level_flag VARCHAR2(1),
66 interaction_level NUMBER,
67 comments VARCHAR2(4000):= FND_API.G_MISS_CHAR
68 -- comments VARCHAR2(4000)
69 );
70
71 g_miss_ge_hist_log_rec ge_hist_log_rec_type := NULL;
72 TYPE ge_hist_log_tbl_type IS TABLE OF ge_hist_log_rec_type INDEX BY BINARY_INTEGER;
73 g_miss_ge_hist_log_tbl ge_hist_log_tbl_type;
74
75 -- ==============================================================================
76 -- Start of Comments
77 -- ==============================================================================
78 -- API Name
79 -- Create_Ge_Hist_Log
80 -- Type
81 -- Private
82 -- Pre-Req
83 --
84 -- Parameters
85 --
86 -- IN
87 -- p_api_version_number IN NUMBER Required
88 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
89 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
90 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
91 -- p_ge_hist_log_rec IN ge_hist_log_rec_type Required
92 --
93 -- OUT
94 -- x_return_status OUT VARCHAR2
95 -- x_msg_count OUT NUMBER
96 -- x_msg_data OUT VARCHAR2
97 -- Version : Current version 1.0
98 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
99 -- and basic operation, developer must manually add parameters and business logic as necessary.
100 --
101 -- History
102 --
103 -- NOTE
104 --
105 -- End of Comments
106 -- ==============================================================================
107
108 PROCEDURE Create_Ge_Hist_Log(
109 p_api_version_number IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117
118 p_ge_hist_log_rec IN ge_hist_log_rec_type := g_miss_ge_hist_log_rec,
119 x_entity_history_log_id OUT NOCOPY NUMBER
120 );
121
122 -- ==============================================================================
123 -- Start of Comments
124 -- ==============================================================================
125 -- API Name
126 -- Update_Ge_Hist_Log
127 -- Type
128 -- Private
129 -- Pre-Req
130 --
131 -- Parameters
132 --
133 -- IN
134 -- p_api_version_number IN NUMBER Required
135 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
138 -- p_ge_hist_log_rec IN ge_hist_log_rec_type Required
139 --
140 -- OUT
141 -- x_return_status OUT VARCHAR2
142 -- x_msg_count OUT NUMBER
143 -- x_msg_data OUT VARCHAR2
144 -- Version : Current version 1.0
145 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
146 -- and basic operation, developer must manually add parameters and business logic as necessary.
147 --
148 -- History
149 --
150 -- NOTE
151 --
152 -- End of Comments
153 -- ==============================================================================
154
155 PROCEDURE Update_Ge_Hist_Log(
156 p_api_version_number IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158 p_commit IN VARCHAR2 := FND_API.G_FALSE,
159 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164
165 p_ge_hist_log_rec IN ge_hist_log_rec_type
166 );
167
168 -- ==============================================================================
169 -- Start of Comments
170 -- ==============================================================================
171 -- API Name
172 -- Delete_Ge_Hist_Log
173 -- Type
174 -- Private
175 -- Pre-Req
176 --
177 -- Parameters
178 --
179 -- IN
180 -- p_api_version_number IN NUMBER Required
181 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
182 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
183 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
184 -- p_entity_history_log_id IN NUMBER
185 -- p_object_version_number IN NUMBER Optional Default = NULL
186 --
187 -- OUT
188 -- x_return_status OUT VARCHAR2
189 -- x_msg_count OUT NUMBER
190 -- x_msg_data OUT VARCHAR2
191 -- Version : Current version 1.0
192 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
193 -- and basic operation, developer must manually add parameters and business logic as necessary.
194 --
195 -- History
196 --
197 -- NOTE
198 --
199 -- End of Comments
200 -- ==============================================================================
201
202 PROCEDURE Delete_Ge_Hist_Log(
203 p_api_version_number IN NUMBER,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_entity_history_log_id IN NUMBER,
211 p_object_version_number IN NUMBER
212 );
213
214 -- ==============================================================================
215 -- Start of Comments
216 -- ==============================================================================
217 -- API Name
218 -- Lock_Ge_Hist_Log
219 -- Type
220 -- Private
221 -- Pre-Req
222 --
223 -- Parameters
224 --
225 -- IN
226 -- p_api_version_number IN NUMBER Required
227 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
228 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
229 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
230 -- p_ge_hist_log_rec IN ge_hist_log_rec_type Required
231 --
232 -- OUT
233 -- x_return_status OUT VARCHAR2
234 -- x_msg_count OUT NUMBER
235 -- x_msg_data OUT VARCHAR2
236 -- Version : Current version 1.0
237 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
238 -- and basic operation, developer must manually add parameters and business logic as necessary.
239 --
240 -- History
241 --
242 -- NOTE
243 --
244 -- End of Comments
245 -- ==============================================================================
246
247 PROCEDURE Lock_Ge_Hist_Log(
248 p_api_version_number IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254
255 p_entity_history_log_id IN NUMBER,
256 p_object_version IN NUMBER
257 );
258
259
260 -- ==============================================================================
261 -- Start of Comments
262 -- ==============================================================================
263 -- API Name
264 -- Validate_Ge_Hist_Log
265 --
266 -- Version : Current version 1.0
267 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
268 -- For create: G_CREATE, for update: G_UPDATE
269 -- Note: 1. This is automated generated item level validation procedure.
270 -- The actual validation detail is needed to be added.
271 -- 2. We can also validate table instead of record. There will be an option for user to choose.
272 --
273 -- History
274 --
275 -- NOTE
276 --
277 -- End of Comments
278 -- ==============================================================================
279
280
281 PROCEDURE Validate_Ge_Hist_Log(
282 p_api_version_number IN NUMBER,
283 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285 p_ge_hist_log_rec IN ge_hist_log_rec_type,
286 p_validation_mode IN VARCHAR2,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2
290 );
291
292 -- ==============================================================================
293 -- Start of Comments
294 -- ==============================================================================
295 -- API Name
296 -- Ge_Hist_Log_Items
297 --
298 -- Version : Current version 1.0
299 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
300 -- For create: G_CREATE, for update: G_UPDATE
301 -- Note: 1. This is automated generated item level validation procedure.
302 -- The actual validation detail is needed to be added.
303 -- 2. Validate the unique keys, lookups here
304 --
305 -- History
306 --
307 -- NOTE
308 --
309 -- End of Comments
310 -- ==============================================================================
311
312
313 PROCEDURE Check_Ge_Hist_Log_Items (
314 P_ge_hist_log_rec IN ge_hist_log_rec_type,
315 p_validation_mode IN VARCHAR2,
316 x_return_status OUT NOCOPY VARCHAR2
317 );
318
319 -- ==============================================================================
320 -- Start of Comments
321 -- ==============================================================================
322 -- API Name
323 -- Validate_Ge_Hist_Log_Rec
324 --
325 -- Version : Current version 1.0
326 -- p_validation_mode is a constant defined in PV_UTILITY_PVT package
327 -- For create: G_CREATE, for update: G_UPDATE
328 -- Note: 1. This is automated generated item level validation procedure.
329 -- The actual validation detail is needed to be added.
330 -- 2. Developer can manually added inter-field level validation.
331 --
332 -- History
333 --
334 -- NOTE
335 --
336 -- End of Comments
337 -- ==============================================================================
338
339
340 PROCEDURE Validate_Ge_Hist_Log_Rec (
341 p_api_version_number IN NUMBER,
342 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
343 x_return_status OUT NOCOPY VARCHAR2,
344 x_msg_count OUT NOCOPY NUMBER,
345 x_msg_data OUT NOCOPY VARCHAR2,
346 p_ge_hist_log_rec IN ge_hist_log_rec_type
347 );
348
349 ---------------------------------------------------------------------
350 -- FUNCTION
351 -- get_message_from_param
352 --
353 -- PURPOSE
354 -- This function returns the message
355
356 ---------------------------------------------------------------------
357 FUNCTION get_message_from_param(
358 p_entity_history_log_id IN NUMBER,
359 p_message_code IN VARCHAR2
360 )
361 RETURN VARCHAR2;
362
363 END PV_Ge_Hist_Log_PVT;