1 PACKAGE AMS_Metric_Template_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvmths.pls 115.4 2003/10/12 10:42:57 sunkumar ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Metric_Template_PVT
7 -- Purpose
8 --
9 -- History
10 -- 03/05/2002 dmvincen Created.
11 -- 08-Sep-2003 Sunkumar Bug#3130095 Metric Template UI Enh. 11510
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18 -- Default number of records fetch per call
19 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
20 --===================================================================
21 -- Start of Comments
22 -- -------------------------------------------------------
23 -- Record name
24 -- metric_tpl_header_rec_type
25 -- -------------------------------------------------------
26 -- Parameters:
27 -- metric_tpl_header_id
28 -- last_update_date
29 -- last_updated_by
30 -- creation_date
31 -- created_by
32 -- last_update_login
33 -- object_version_number
34 -- security_group_id
35 -- enabled_flag
36 -- application_id
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 metric_tpl_header_rec_type IS RECORD
49 (
50 metric_tpl_header_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 application_id NUMBER := FND_API.G_MISS_NUM,
58 enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
59 METRIC_TPL_HEADER_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
60 DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
61 object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62 association_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 used_by_id NUMBER := FND_API.G_MISS_NUM,
64 used_by_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65 );
66
67 g_miss_metric_tpl_header_rec metric_tpl_header_rec_type;
68 TYPE metric_tpl_header_tbl_type IS TABLE OF metric_tpl_header_rec_type INDEX BY BINARY_INTEGER;
69 g_miss_metric_tpl_header_tbl metric_tpl_header_tbl_type;
70
71 -- ==============================================================================
72 -- Start of Comments
73 -- ==============================================================================
74 -- API Name
75 -- Create_Metric_Template
76 -- Type
77 -- Private
78 -- Pre-Req
79 --
80 -- Parameters
81 --
82 -- IN
83 -- p_api_version_number IN NUMBER Required
84 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87 -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
88 --
89 -- OUT
90 -- x_return_status OUT VARCHAR2
91 -- x_msg_count OUT NUMBER
92 -- x_msg_data OUT VARCHAR2
93 -- Version : Current version 1.0
94 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
95 -- and basic operation, developer must manually add parameters and business logic as necessary.
96 --
97 -- End of Comments
98 -- ==============================================================================
99 --
100
101 PROCEDURE Create_Metric_Template(
102 p_api_version_number IN NUMBER,
103 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE,
105 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110
111 p_metric_tpl_header_rec IN metric_tpl_header_rec_type := g_miss_metric_tpl_header_rec,
112 x_metric_tpl_header_id OUT NOCOPY NUMBER
113 );
114
115 -- ==============================================================================
116 -- Start of Comments
117 -- ==============================================================================
118 -- API Name
119 -- Update_Metric_Template
120 -- Type
121 -- Private
122 -- Pre-Req
123 --
124 -- Parameters
125 --
126 -- IN
127 -- p_api_version_number IN NUMBER Required
128 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131 -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
132 --
133 -- OUT
134 -- x_return_status OUT VARCHAR2
135 -- x_msg_count OUT NUMBER
136 -- x_msg_data OUT VARCHAR2
137 -- Version : Current version 1.0
138 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
139 -- and basic operation, developer must manually add parameters and business logic as necessary.
140 --
141 -- End of Comments
142 -- ==============================================================================
143 --
144
145 PROCEDURE Update_Metric_Template(
146 p_api_version_number IN NUMBER,
147 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148 p_commit IN VARCHAR2 := FND_API.G_FALSE,
149 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154
155 p_metric_tpl_header_rec IN metric_tpl_header_rec_type,
156 x_object_version_number OUT NOCOPY NUMBER
157 );
158
159 -- ==============================================================================
160 -- Start of Comments
161 -- ==============================================================================
162 -- API Name
163 -- Delete_Metric_Template
164 -- Type
165 -- Private
166 -- Pre-Req
167 --
168 -- Parameters
169 --
170 -- IN
171 -- p_api_version_number IN NUMBER Required
172 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175 -- p_METRIC_TPL_HEADER_ID IN NUMBER
176 -- p_object_version_number IN NUMBER Optional Default = NULL
177 --
178 -- OUT
179 -- x_return_status OUT VARCHAR2
180 -- x_msg_count OUT NUMBER
181 -- x_msg_data OUT VARCHAR2
182 -- Version : Current version 1.0
183 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
184 -- and basic operation, developer must manually add parameters and business logic as necessary.
185 --
186 -- End of Comments
187 -- ==============================================================================
188 --
189
190 PROCEDURE Delete_Metric_Template(
191 p_api_version_number IN NUMBER,
192 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193 p_commit IN VARCHAR2 := FND_API.G_FALSE,
194 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_metric_tpl_header_id IN NUMBER,
199 p_object_version_number IN NUMBER
200 );
201
202 -- ==============================================================================
203 -- Start of Comments
204 -- ==============================================================================
205 -- API Name
206 -- Lock_Metric_Template
207 -- Type
208 -- Private
209 -- Pre-Req
210 --
211 -- Parameters
212 --
213 -- IN
214 -- p_api_version_number IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218 -- p_metric_tpl_header_rec IN metric_tpl_header_rec_type Required
219 --
220 -- OUT
221 -- x_return_status OUT VARCHAR2
222 -- x_msg_count OUT NUMBER
223 -- x_msg_data OUT VARCHAR2
224 -- Version : Current version 1.0
225 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
226 -- and basic operation, developer must manually add parameters and business logic as necessary.
227 --
228 -- End of Comments
229 -- ==============================================================================
230 --
231
232 PROCEDURE Lock_Metric_Template(
233 p_api_version_number IN NUMBER,
234 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239
240 p_metric_tpl_header_id IN NUMBER,
241 p_object_version IN NUMBER
242 );
243
244
245 -- Start of Comments
246 --
247 -- validation procedures
248 --
249 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
250 -- For create: G_CREATE, for update: G_UPDATE
251 -- Note: 1. This is automated generated item level validation procedure.
252 -- The actual validation detail is needed to be added.
253 -- 2. We can also validate table instead of record. There will be an option for user to choose.
254 -- End of Comments
255
256 PROCEDURE Validate_metric_template(
257 p_api_version_number IN NUMBER,
258 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
260 p_metric_tpl_header_rec IN metric_tpl_header_rec_type,
261 p_validation_mode IN VARCHAR2,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2
265 );
266
267 -- Start of Comments
268 --
269 -- validation procedures
270 --
271 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
272 -- For create: G_CREATE, for update: G_UPDATE
273 -- Note: 1. This is automated generated item level validation procedure.
274 -- The actual validation detail is needed to be added.
275 -- 2. Validate the unique keys, lookups here
276 -- End of Comments
277
278 PROCEDURE Check_met_tpl_hdr_Items (
279 P_metric_tpl_header_rec IN metric_tpl_header_rec_type,
280 p_validation_mode IN VARCHAR2,
281 x_return_status OUT NOCOPY VARCHAR2
282 );
283
284 -- Start of Comments
285 --
286 -- Record level validation procedures
287 --
288 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
289 -- For create: G_CREATE, for update: G_UPDATE
290 -- Note: 1. This is automated generated item level validation procedure.
291 -- The actual validation detail is needed to be added.
292 -- 2. Developer can manually added inter-field level validation.
293 -- End of Comments
294
295 PROCEDURE Validate_met_tpl_hdr_rec(
296 p_api_version_number IN NUMBER,
297 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
298 x_return_status OUT NOCOPY VARCHAR2,
299 x_msg_count OUT NOCOPY NUMBER,
300 x_msg_data OUT NOCOPY VARCHAR2,
301 p_metric_tpl_header_rec IN metric_tpl_header_rec_type
302 );
303 END AMS_Metric_Template_PVT;