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