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