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