1 PACKAGE AMS_Dm_Binvalues_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdbvs.pls 115.3 2002/12/09 11:03:16 choang noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Dm_Binvalues_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 -- dm_binvalues_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- bin_value_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- source_field_id
33 -- bucket
34 -- bin_value
35 -- start_value
36 -- end_value
37 --
38 -- Required
39 --
40 -- Defaults
41 --
42 -- Note: This is automatic generated record definition, it includes all columns
43 -- defined in the table, developer must manually add or delete some of the attributes.
44 --
45 -- End of Comments
46
47 --===================================================================
48 TYPE dm_binvalues_rec_type IS RECORD
49 (
50 bin_value_id NUMBER := FND_API.G_MISS_NUM,
51 last_update_date DATE := FND_API.G_MISS_DATE,
52 last_updated_by NUMBER := FND_API.G_MISS_NUM,
53 creation_date DATE := FND_API.G_MISS_DATE,
54 created_by NUMBER := FND_API.G_MISS_NUM,
55 last_update_login NUMBER := FND_API.G_MISS_NUM,
56 object_version_number NUMBER := FND_API.G_MISS_NUM,
57 source_field_id NUMBER := FND_API.G_MISS_NUM,
58 bucket NUMBER := FND_API.G_MISS_NUM,
59 bin_value VARCHAR2(120) := FND_API.G_MISS_CHAR,
60 start_value NUMBER := FND_API.G_MISS_NUM,
61 end_value NUMBER := FND_API.G_MISS_NUM
62 );
63
64 g_miss_dm_binvalues_rec dm_binvalues_rec_type;
65 TYPE dm_binvalues_tbl_type IS TABLE OF dm_binvalues_rec_type INDEX BY BINARY_INTEGER;
66 g_miss_dm_binvalues_tbl dm_binvalues_tbl_type;
67
68 -- ==============================================================================
69 -- Start of Comments
70 -- ==============================================================================
71 -- API Name
72 -- Create_Dm_Binvalues
73 -- Type
74 -- Private
75 -- Pre-Req
76 --
77 -- Parameters
78 --
79 -- IN
80 -- p_api_version_number IN NUMBER Required
81 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
82 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
83 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
84 -- p_dm_binvalues_rec IN dm_binvalues_rec_type Required
85 --
86 -- OUT
87 -- x_return_status OUT VARCHAR2
88 -- x_msg_count OUT NUMBER
89 -- x_msg_data OUT VARCHAR2
90 -- Version : Current version 1.0
91 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
92 -- and basic operation, developer must manually add parameters and business logic as necessary.
93 --
94 -- End of Comments
95 -- ==============================================================================
96 --
97
98 PROCEDURE Create_Dm_Binvalues(
99 p_api_version_number IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107
108 p_dm_binvalues_rec IN dm_binvalues_rec_type := g_miss_dm_binvalues_rec,
109 x_bin_value_id OUT NOCOPY NUMBER
110 );
111
112 -- ==============================================================================
113 -- Start of Comments
114 -- ==============================================================================
115 -- API Name
116 -- Update_Dm_Binvalues
117 -- Type
118 -- Private
119 -- Pre-Req
120 --
121 -- Parameters
122 --
123 -- IN
124 -- p_api_version_number IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
126 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
128 -- p_dm_binvalues_rec IN dm_binvalues_rec_type Required
129 --
130 -- OUT
131 -- x_return_status OUT VARCHAR2
132 -- x_msg_count OUT NUMBER
133 -- x_msg_data OUT VARCHAR2
134 -- Version : Current version 1.0
135 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
136 -- and basic operation, developer must manually add parameters and business logic as necessary.
137 --
138 -- End of Comments
139 -- ==============================================================================
140 --
141
142 PROCEDURE Update_Dm_Binvalues(
143 p_api_version_number IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151
152 p_dm_binvalues_rec IN dm_binvalues_rec_type,
153 x_object_version_number OUT NOCOPY NUMBER
154 );
155
156 -- ==============================================================================
157 -- Start of Comments
158 -- ==============================================================================
159 -- API Name
160 -- Delete_Dm_Binvalues
161 -- Type
162 -- Private
163 -- Pre-Req
164 --
165 -- Parameters
166 --
167 -- IN
168 -- p_api_version_number IN NUMBER Required
169 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172 -- p_BIN_VALUE_ID IN NUMBER
173 -- p_object_version_number IN NUMBER Optional Default = NULL
174 --
175 -- OUT
176 -- x_return_status OUT VARCHAR2
177 -- x_msg_count OUT NUMBER
178 -- x_msg_data OUT VARCHAR2
179 -- Version : Current version 1.0
180 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
181 -- and basic operation, developer must manually add parameters and business logic as necessary.
182 --
183 -- End of Comments
184 -- ==============================================================================
185 --
186
187 PROCEDURE Delete_Dm_Binvalues(
188 p_api_version_number IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE,
191 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_bin_value_id IN NUMBER,
196 p_object_version_number IN NUMBER
197 );
198
199 -- ==============================================================================
200 -- Start of Comments
201 -- ==============================================================================
202 -- API Name
203 -- Lock_Dm_Binvalues
204 -- Type
205 -- Private
206 -- Pre-Req
207 --
208 -- Parameters
209 --
210 -- IN
211 -- p_api_version_number IN NUMBER Required
212 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215 -- p_dm_binvalues_rec IN dm_binvalues_rec_type Required
216 --
217 -- OUT
218 -- x_return_status OUT VARCHAR2
219 -- x_msg_count OUT NUMBER
220 -- x_msg_data OUT VARCHAR2
221 -- Version : Current version 1.0
222 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
223 -- and basic operation, developer must manually add parameters and business logic as necessary.
224 --
225 -- End of Comments
226 -- ==============================================================================
227 --
228
229 PROCEDURE Lock_Dm_Binvalues(
230 p_api_version_number IN NUMBER,
231 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236
237 p_bin_value_id IN NUMBER,
238 p_object_version IN NUMBER
239 );
240
241
242 -- Start of Comments
243 --
244 -- validation procedures
245 --
246 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
247 -- For create: G_CREATE, for update: G_UPDATE
248 -- Note: 1. This is automated generated item level validation procedure.
249 -- The actual validation detail is needed to be added.
250 -- 2. We can also validate table instead of record. There will be an option for user to choose.
251 -- End of Comments
252
253 PROCEDURE Validate_dm_binvalues(
254 p_api_version_number IN NUMBER,
255 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
257 p_dm_binvalues_rec IN dm_binvalues_rec_type,
258 p_validation_mode IN VARCHAR2,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2
262 );
263
264 -- Start of Comments
265 --
266 -- validation procedures
267 --
268 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
269 -- For create: G_CREATE, for update: G_UPDATE
270 -- Note: 1. This is automated generated item level validation procedure.
271 -- The actual validation detail is needed to be added.
272 -- 2. Validate the unique keys, lookups here
273 -- End of Comments
274
275 PROCEDURE Check_dm_binvalues_Items (
276 P_dm_binvalues_rec IN dm_binvalues_rec_type,
277 p_validation_mode IN VARCHAR2,
278 x_return_status OUT NOCOPY VARCHAR2
279 );
280
281 -- Start of Comments
282 --
283 -- Record level validation procedures
284 --
285 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
286 -- For create: G_CREATE, for update: G_UPDATE
287 -- Note: 1. This is automated generated item level validation procedure.
288 -- The actual validation detail is needed to be added.
289 -- 2. Developer can manually added inter-field level validation.
290 -- End of Comments
291
292 PROCEDURE Validate_dm_binvalues_rec(
293 p_api_version_number IN NUMBER,
294 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2,
298 p_dm_binvalues_rec IN dm_binvalues_rec_type
299 );
300
301
302 -- ==============================================================================
303 -- Start of Comments
304 -- ==============================================================================
305 -- API Name
306 -- Delete_Dm_Binvalues_For_Field
307 -- Type
308 -- Private
309 -- Pre-Req
310 --
311 -- Parameters
312 --
313 -- IN
314 -- p_DATSOURCE_FIELD_ID IN NUMBER
315 --
316 -- Version : Current version 1.0
317 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
318 -- and basic operation, developer must manually add parameters and business logic as necessary.
319 --
320 -- End of Comments
321 -- ==============================================================================
322 --
323
324 PROCEDURE Delete_Dm_Binvalues_For_Field(
325 p_datasource_field_id IN NUMBER
326 );
327
328 END AMS_Dm_Binvalues_PVT;