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