1 PACKAGE AMS_Dm_Target_Value_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvdtvs.pls 115.6 2002/12/09 11:11:20 choang noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Dm_Target_Value_PVT
7 -- Purpose
8 --
9 -- History
10 -- 08-Oct-2002 nyostos Added value_condition column
11 -- 16-Oct-2002 choang Added target_operator and range_value, replacing value_condition
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 -- dm_target_value_rec_type
25 -- -------------------------------------------------------
26 -- Parameters:
27 -- target_value_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 -- target_id
36 -- target_value
37 -- target_operator
38 -- range_value
39 -- description
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 dm_target_value_rec_type IS RECORD
52 (
53 target_value_id NUMBER := FND_API.G_MISS_NUM,
54 last_update_date DATE := FND_API.G_MISS_DATE,
55 last_updated_by NUMBER := FND_API.G_MISS_NUM,
56 creation_date DATE := FND_API.G_MISS_DATE,
57 created_by NUMBER := FND_API.G_MISS_NUM,
58 last_update_login NUMBER := FND_API.G_MISS_NUM,
59 object_version_number NUMBER := FND_API.G_MISS_NUM,
60 security_group_id NUMBER := FND_API.G_MISS_NUM,
61 target_id NUMBER := FND_API.G_MISS_NUM,
62 target_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 target_operator VARCHAR2(10) := FND_API.G_MISS_CHAR,
64 range_value VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66 );
67
68 g_miss_dm_target_value_rec dm_target_value_rec_type;
69 TYPE dm_target_value_tbl_type IS TABLE OF dm_target_value_rec_type INDEX BY BINARY_INTEGER;
70 g_miss_dm_target_value_tbl dm_target_value_tbl_type;
71
72 -- ==============================================================================
73 -- Start of Comments
74 -- ==============================================================================
75 -- API Name
76 -- Create_Dm_Target_Value
77 -- Type
78 -- Private
79 -- Pre-Req
80 --
81 -- Parameters
82 --
83 -- IN
84 -- p_api_version_number IN NUMBER Required
85 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88 -- p_dm_target_value_rec IN dm_target_value_rec_type Required
89 --
90 -- OUT
91 -- x_return_status OUT VARCHAR2
92 -- x_msg_count OUT NUMBER
93 -- x_msg_data OUT VARCHAR2
94 -- Version : Current version 1.0
95 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
96 -- and basic operation, developer must manually add parameters and business logic as necessary.
97 --
98 -- End of Comments
99 -- ==============================================================================
100 --
101
102 PROCEDURE Create_Dm_Target_Value(
103 p_api_version_number IN NUMBER,
104 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105 p_commit IN VARCHAR2 := FND_API.G_FALSE,
106 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111
112 p_dm_target_value_rec IN dm_target_value_rec_type := g_miss_dm_target_value_rec,
113 x_target_value_id OUT NOCOPY NUMBER
114 );
115
116 -- ==============================================================================
117 -- Start of Comments
118 -- ==============================================================================
119 -- API Name
120 -- Update_Dm_Target_Value
121 -- Type
122 -- Private
123 -- Pre-Req
124 --
125 -- Parameters
126 --
127 -- IN
128 -- p_api_version_number IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132 -- p_dm_target_value_rec IN dm_target_value_rec_type Required
133 --
134 -- OUT
135 -- x_return_status OUT VARCHAR2
136 -- x_msg_count OUT NUMBER
137 -- x_msg_data OUT VARCHAR2
138 -- Version : Current version 1.0
139 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
140 -- and basic operation, developer must manually add parameters and business logic as necessary.
141 --
142 -- End of Comments
143 -- ==============================================================================
144 --
145
146 PROCEDURE Update_Dm_Target_Value(
147 p_api_version_number IN NUMBER,
148 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155
156 p_dm_target_value_rec IN dm_target_value_rec_type,
157 x_object_version_number OUT NOCOPY NUMBER
158 );
159
160 -- ==============================================================================
161 -- Start of Comments
162 -- ==============================================================================
163 -- API Name
164 -- Delete_Dm_Target_Value
165 -- Type
166 -- Private
167 -- Pre-Req
168 --
169 -- Parameters
170 --
171 -- IN
172 -- p_api_version_number IN NUMBER Required
173 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176 -- p_TARGET_VALUE_ID IN NUMBER
177 -- p_object_version_number IN NUMBER Optional Default = NULL
178 --
179 -- OUT
180 -- x_return_status OUT VARCHAR2
181 -- x_msg_count OUT NUMBER
182 -- x_msg_data OUT VARCHAR2
183 -- Version : Current version 1.0
184 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
185 -- and basic operation, developer must manually add parameters and business logic as necessary.
186 --
187 -- End of Comments
188 -- ==============================================================================
189 --
190
191 PROCEDURE Delete_Dm_Target_Value(
192 p_api_version_number IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194 p_commit IN VARCHAR2 := FND_API.G_FALSE,
195 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_target_value_id IN NUMBER,
200 p_object_version_number IN NUMBER
201 );
202
203 -- ==============================================================================
204 -- Start of Comments
205 -- ==============================================================================
206 -- API Name
207 -- Lock_Dm_Target_Value
208 -- Type
209 -- Private
210 -- Pre-Req
211 --
212 -- Parameters
213 --
214 -- IN
215 -- p_api_version_number IN NUMBER Required
216 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
217 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
218 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
219 -- p_dm_target_value_rec IN dm_target_value_rec_type Required
220 --
221 -- OUT
222 -- x_return_status OUT VARCHAR2
223 -- x_msg_count OUT NUMBER
224 -- x_msg_data OUT VARCHAR2
225 -- Version : Current version 1.0
226 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
227 -- and basic operation, developer must manually add parameters and business logic as necessary.
228 --
229 -- End of Comments
230 -- ==============================================================================
231 --
232
233 PROCEDURE Lock_Dm_Target_Value(
234 p_api_version_number IN NUMBER,
235 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240
241 p_target_value_id IN NUMBER,
242 p_object_version IN NUMBER
243 );
244
245
246 -- Start of Comments
247 --
248 -- validation procedures
249 --
250 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
251 -- For create: G_CREATE, for update: G_UPDATE
252 -- Note: 1. This is automated generated item level validation procedure.
253 -- The actual validation detail is needed to be added.
254 -- 2. We can also validate table instead of record. There will be an option for user to choose.
255 -- End of Comments
256
257 PROCEDURE Validate_dm_target_value(
258 p_api_version_number IN NUMBER,
259 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
260 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261 p_dm_target_value_rec IN dm_target_value_rec_type,
262 p_validation_mode IN VARCHAR2,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2
266 );
267
268 -- Start of Comments
269 --
270 -- validation procedures
271 --
272 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
273 -- For create: G_CREATE, for update: G_UPDATE
274 -- Note: 1. This is automated generated item level validation procedure.
275 -- The actual validation detail is needed to be added.
276 -- 2. Validate the unique keys, lookups here
277 -- End of Comments
278
279 PROCEDURE Check_dm_target_value_Items (
280 P_dm_target_value_rec IN dm_target_value_rec_type,
281 p_validation_mode IN VARCHAR2,
282 x_return_status OUT NOCOPY VARCHAR2
283 );
284
285 -- Start of Comments
286 --
287 -- Record level validation procedures
288 --
289 -- p_validation_mode is a constant defined in null_UTILITY_PVT package
290 -- For create: G_CREATE, for update: G_UPDATE
291 -- Note: 1. This is automated generated item level validation procedure.
292 -- The actual validation detail is needed to be added.
293 -- 2. Developer can manually added inter-field level validation.
294 -- End of Comments
295
296 PROCEDURE Validate_dm_target_value_rec(
297 p_api_version_number IN NUMBER,
298 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299 x_return_status OUT NOCOPY VARCHAR2,
300 x_msg_count OUT NOCOPY NUMBER,
301 x_msg_data OUT NOCOPY VARCHAR2,
302 p_dm_target_value_rec IN dm_target_value_rec_type
303 );
304
305
306 PROCEDURE Delete_TgtValues_For_Target (
307 p_target_id IN NUMBER
308 );
309
310 END AMS_Dm_Target_Value_PVT;