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