1 PACKAGE AMS_Adhoc_Param_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvapvs.pls 120.0 2005/07/01 03:59:34 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Adhoc_Param_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- adhoc_param_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- adhoc_param_id
26 -- adhoc_param_code
27 -- adhoc_param_value
28 -- ctd_id
29 -- object_version_number
30 -- last_update_date
31 -- last_updated_by
32 -- last_update_login
33 -- creation_date
34 -- created_by
35 -- security_group_id
36 --
37 -- Required
38 --
39 -- Defaults
40 --
41 -- Note: This is automatic generated record definition, it includes all columns
42 -- defined in the table, developer must manually add or delete some of the attributes.
43 --
44 -- End of Comments
45
46 --===================================================================
47 TYPE adhoc_param_rec_type IS RECORD
48 (
49 adhoc_param_id NUMBER := FND_API.G_MISS_NUM,
50 adhoc_param_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
51 adhoc_param_value VARCHAR2(255) := FND_API.G_MISS_CHAR,
52 ctd_id NUMBER := FND_API.G_MISS_NUM,
53 object_version_number NUMBER := FND_API.G_MISS_NUM,
54 last_update_date DATE := FND_API.G_MISS_DATE,
55 last_updated_by NUMBER := FND_API.G_MISS_NUM,
56 last_update_login NUMBER := FND_API.G_MISS_NUM,
57 creation_date DATE := FND_API.G_MISS_DATE,
58 created_by NUMBER := FND_API.G_MISS_NUM,
59 security_group_id NUMBER := FND_API.G_MISS_NUM
60 );
61
62 g_miss_adhoc_param_rec adhoc_param_rec_type;
63 TYPE adhoc_param_tbl_type IS TABLE OF adhoc_param_rec_type INDEX BY BINARY_INTEGER;
64 g_miss_adhoc_param_tbl adhoc_param_tbl_type;
65
66 -- ==============================================================================
67 -- Start of Comments
68 -- ==============================================================================
69 -- API Name
70 -- Create_Adhoc_Param
71 -- Type
72 -- Private
73 -- Pre-Req
74 --
75 -- Parameters
76 --
77 -- IN
78 -- p_api_version_number IN NUMBER Required
79 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82 -- p_adhoc_param_rec IN adhoc_param_rec_type Required
83 --
84 -- OUT NOCOPY
85 -- x_return_status OUT NOCOPY VARCHAR2
86 -- x_msg_count OUT NOCOPY NUMBER
87 -- x_msg_data OUT NOCOPY VARCHAR2
88 -- Version : Current version 1.0
89 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
90 -- and basic operation, developer must manually add parameters and business logic as necessary.
91 --
92 -- End of Comments
93 -- ==============================================================================
94 --
95
96 PROCEDURE Create_Adhoc_Param(
97 p_api_version_number IN NUMBER,
98 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99 p_commit IN VARCHAR2 := FND_API.G_FALSE,
100 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105
106 p_adhoc_param_rec IN adhoc_param_rec_type := g_miss_adhoc_param_rec,
107 x_adhoc_param_id OUT NOCOPY NUMBER
108 );
109
110 -- ==============================================================================
111 -- Start of Comments
112 -- ==============================================================================
113 -- API Name
114 -- Update_Adhoc_Param
115 -- Type
116 -- Private
117 -- Pre-Req
118 --
119 -- Parameters
120 --
121 -- IN
122 -- p_api_version_number IN NUMBER Required
123 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126 -- p_adhoc_param_rec IN adhoc_param_rec_type Required
127 --
128 -- OUT NOCOPY
129 -- x_return_status OUT NOCOPY VARCHAR2
130 -- x_msg_count OUT NOCOPY NUMBER
131 -- x_msg_data OUT NOCOPY VARCHAR2
132 -- Version : Current version 1.0
133 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
134 -- and basic operation, developer must manually add parameters and business logic as necessary.
135 --
136 -- End of Comments
137 -- ==============================================================================
138 --
139
140 PROCEDURE Update_Adhoc_Param(
141 p_api_version_number IN NUMBER,
142 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143 p_commit IN VARCHAR2 := FND_API.G_FALSE,
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149
150 p_adhoc_param_rec IN adhoc_param_rec_type,
151 x_object_version_number OUT NOCOPY NUMBER
152 );
153
154 -- ==============================================================================
155 -- Start of Comments
156 -- ==============================================================================
157 -- API Name
158 -- Delete_Adhoc_Param
159 -- Type
160 -- Private
161 -- Pre-Req
162 --
163 -- Parameters
164 --
165 -- IN
166 -- p_api_version_number IN NUMBER Required
167 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170 -- p_ADHOC_PARAM_ID IN NUMBER
171 -- p_object_version_number IN NUMBER Optional Default = NULL
172 --
173 -- OUT NOCOPY
174 -- x_return_status OUT NOCOPY VARCHAR2
175 -- x_msg_count OUT NOCOPY NUMBER
176 -- x_msg_data OUT NOCOPY VARCHAR2
177 -- Version : Current version 1.0
178 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
179 -- and basic operation, developer must manually add parameters and business logic as necessary.
180 --
181 -- End of Comments
182 -- ==============================================================================
183 --
184
185 PROCEDURE Delete_Adhoc_Param(
186 p_api_version_number IN NUMBER,
187 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188 p_commit IN VARCHAR2 := FND_API.G_FALSE,
189 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_adhoc_param_id IN NUMBER,
194 p_object_version_number IN NUMBER
195 );
196
197 -- ==============================================================================
198 -- Start of Comments
199 -- ==============================================================================
200 -- API Name
201 -- Lock_Adhoc_Param
202 -- Type
203 -- Private
204 -- Pre-Req
205 --
206 -- Parameters
207 --
208 -- IN
209 -- p_api_version_number IN NUMBER Required
210 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213 -- p_adhoc_param_rec IN adhoc_param_rec_type Required
214 --
215 -- OUT NOCOPY
216 -- x_return_status OUT NOCOPY VARCHAR2
217 -- x_msg_count OUT NOCOPY NUMBER
218 -- x_msg_data OUT NOCOPY VARCHAR2
219 -- Version : Current version 1.0
220 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
221 -- and basic operation, developer must manually add parameters and business logic as necessary.
222 --
223 -- End of Comments
224 -- ==============================================================================
225 --
226
227 PROCEDURE Lock_Adhoc_Param(
228 p_api_version_number IN NUMBER,
229 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
230
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234
235 p_adhoc_param_id IN NUMBER,
236 p_object_version IN NUMBER
237 );
238
239
240 -- Start of Comments
241 --
242 -- validation procedures
243 --
244 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
245 -- For create: G_CREATE, for update: G_UPDATE
246 -- Note: 1. This is automated generated item level validation procedure.
247 -- The actual validation detail is needed to be added.
248 -- 2. We can also validate table instead of record. There will be an option for user to choose.
249 -- End of Comments
250
251 PROCEDURE Validate_adhoc_param(
252 p_api_version_number IN NUMBER,
253 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255 p_adhoc_param_rec IN adhoc_param_rec_type,
256 x_return_status OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER,
258 x_msg_data OUT NOCOPY VARCHAR2
259 );
260
261 -- Start of Comments
262 --
263 -- validation procedures
264 --
265 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
266 -- For create: G_CREATE, for update: G_UPDATE
267 -- Note: 1. This is automated generated item level validation procedure.
268 -- The actual validation detail is needed to be added.
269 -- 2. Validate the unique keys, lookups here
270 -- End of Comments
271
272 PROCEDURE Check_adhoc_param_Items (
273 P_adhoc_param_rec IN adhoc_param_rec_type,
274 p_validation_mode IN VARCHAR2,
275 x_return_status OUT NOCOPY VARCHAR2
276 );
277
278 -- Start of Comments
279 --
280 -- Record level validation procedures
281 --
282 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
283 -- For create: G_CREATE, for update: G_UPDATE
284 -- Note: 1. This is automated generated item level validation procedure.
285 -- The actual validation detail is needed to be added.
286 -- 2. Developer can manually added inter-field level validation.
287 -- End of Comments
288
289 PROCEDURE Validate_adhoc_param_rec(
290 p_api_version_number IN NUMBER,
291 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_adhoc_param_rec IN adhoc_param_rec_type
296 );
297 END AMS_Adhoc_Param_PVT;
[Home] [Help]