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