1 PACKAGE AMS_Ps_Strats_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvstrs.pls 120.0 2005/06/01 00:24:07 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ps_Strats_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 -- ps_strats_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- created_by
26 -- creation_date
27 -- last_updated_by
28 -- last_update_date
29 -- last_update_login
30 -- object_version_number
31 -- strategy_id
32 -- max_returned
33 -- strategy_type
34 -- content_type
35 -- strategy_ref_code
36 -- selector_class
37 -- strategy_name
38 -- strategy_description
39 --
40 -- Required
41 --
42 -- Defaults
43 --
44 -- Note: This is automatic generated record definition, it includes all columns
45 -- defined in the table, developer must manually add or delete some of the attributes.
46 --
47 -- End of Comments
48
49 --===================================================================
50 TYPE ps_strats_rec_type IS RECORD
51 (
52 created_by NUMBER := FND_API.G_MISS_NUM,
53 creation_date DATE := FND_API.G_MISS_DATE,
54 last_updated_by NUMBER := FND_API.G_MISS_NUM,
55 last_update_date DATE := FND_API.G_MISS_DATE,
56 last_update_login NUMBER := FND_API.G_MISS_NUM,
57 object_version_number NUMBER := FND_API.G_MISS_NUM,
58 strategy_id NUMBER := FND_API.G_MISS_NUM,
59 max_returned NUMBER := FND_API.G_MISS_NUM,
60 strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61 content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62 strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
64 strategy_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 strategy_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66 );
67
68 g_miss_ps_strats_rec ps_strats_rec_type;
69 TYPE ps_strats_tbl_type IS TABLE OF ps_strats_rec_type INDEX BY BINARY_INTEGER;
70 g_miss_ps_strats_tbl ps_strats_tbl_type;
71
72 -- ==========================================================
73 -- Start of Comments
74 -- ==========================================================
75 -- API Name
76 -- Create_Ps_Strats
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_ps_strats_rec IN ps_strats_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_Ps_Strats(
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_ps_strats_rec IN ps_strats_rec_type := g_miss_ps_strats_rec,
113 x_strategy_id OUT NOCOPY NUMBER
114 );
115
116 -- ==========================================================
117 -- Start of Comments
118 -- ==========================================================
119 -- API Name
120 -- Update_Ps_Strats
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_ps_strats_rec IN ps_strats_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_Ps_Strats(
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_ps_strats_rec IN ps_strats_rec_type,
157 x_object_version_number OUT NOCOPY NUMBER
158 );
159
160 -- ==========================================================
161 -- Start of Comments
162 -- ==========================================================
163 -- API Name
164 -- Update_Ps_Strats_Seg
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_ps_strats_rec IN ps_strats_rec_type Required
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 Procedure updates 'max_returned' column for 'INFERRED' and
184 -- 'PREDEFINED' strategies.
185 --
186 -- End of Comments
187 -- ==========================================================
188 --
189
190 PROCEDURE Update_Ps_Strats_Seg(
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
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199
200 p_ps_strats_rec IN ps_strats_rec_type,
201 x_object_version_number OUT NOCOPY NUMBER,
202 p_strat_type IN VARCHAR2
203 );
204
205 -- ==========================================================
206 -- Start of Comments
207 -- ==========================================================
208 -- API Name
209 -- Delete_Ps_Strats
210 -- Type
211 -- Private
212 -- Pre-Req
213 --
214 -- Parameters
215 --
216 -- IN
217 -- p_api_version_number IN NUMBER Required
218 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221 -- p_STRATEGY_ID IN NUMBER
222 -- p_object_version_number IN NUMBER Optional Default = NULL
223 --
224 -- OUT
225 -- x_return_status OUT VARCHAR2
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2
228 -- Version : Current version 1.0
229 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
230 -- and basic operation, developer must manually add parameters and business logic as necessary.
231 --
232 -- End of Comments
233 -- ==========================================================
234 --
235
236 PROCEDURE Delete_Ps_Strats(
237 p_api_version_number IN NUMBER,
238 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239 p_commit IN VARCHAR2 := FND_API.G_FALSE,
240 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_strategy_id IN NUMBER,
245 p_object_version_number IN NUMBER
246 );
247
248 -- ==========================================================
249 -- Start of Comments
250 -- ==========================================================
251 -- API Name
252 -- Lock_Ps_Strats
253 -- Type
254 -- Private
255 -- Pre-Req
256 --
257 -- Parameters
258 --
259 -- IN
260 -- p_api_version_number IN NUMBER Required
261 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264 -- p_ps_strats_rec IN ps_strats_rec_type Required
265 --
266 -- OUT
267 -- x_return_status OUT VARCHAR2
268 -- x_msg_count OUT NUMBER
269 -- x_msg_data OUT VARCHAR2
270 -- Version : Current version 1.0
271 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
272 -- and basic operation, developer must manually add parameters and business logic as necessary.
273 --
274 -- End of Comments
275 -- ==========================================================
276 --
277
278 PROCEDURE Lock_Ps_Strats(
279 p_api_version_number IN NUMBER,
280 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281
282 x_return_status OUT NOCOPY VARCHAR2,
283 x_msg_count OUT NOCOPY NUMBER,
284 x_msg_data OUT NOCOPY VARCHAR2,
285
286 p_strategy_id IN NUMBER,
287 p_object_version IN NUMBER
288 );
289
290
291 -- Start of Comments
292 --
293 -- validation procedures
294 --
295 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
296 -- For create: G_CREATE, for update: G_UPDATE
297 -- Note: 1. This is automated generated item level validation procedure.
298 -- The actual validation detail is needed to be added.
299 -- 2. We can also validate table instead of record. There will be an option for user to choose.
300 -- End of Comments
301
302 PROCEDURE Validate_ps_strats(
303 p_api_version_number IN NUMBER,
304 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306 p_ps_strats_rec IN ps_strats_rec_type,
307 x_return_status OUT NOCOPY VARCHAR2,
308 x_msg_count OUT NOCOPY NUMBER,
309 x_msg_data OUT NOCOPY VARCHAR2
310 );
311
312 -- Start of Comments
313 --
314 -- validation procedures
315 --
316 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
317 -- For create: G_CREATE, for update: G_UPDATE
318 -- Note: 1. This is automated generated item level validation procedure.
319 -- The actual validation detail is needed to be added.
320 -- 2. Validate the unique keys, lookups here
321 -- End of Comments
322
323 PROCEDURE Check_ps_strats_Items (
324 P_ps_strats_rec IN ps_strats_rec_type,
325 p_validation_mode IN VARCHAR2,
326 x_return_status OUT NOCOPY VARCHAR2
327 );
328
329 -- Start of Comments
330 --
331 -- Record level validation procedures
332 --
333 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
334 -- For create: G_CREATE, for update: G_UPDATE
335 -- Note: 1. This is automated generated item level validation procedure.
336 -- The actual validation detail is needed to be added.
337 -- 2. Developer can manually added inter-field level validation.
338 -- End of Comments
339
340 PROCEDURE Validate_ps_strats_rec(
341 p_api_version_number IN NUMBER,
342 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
343 x_return_status OUT NOCOPY VARCHAR2,
344 x_msg_count OUT NOCOPY NUMBER,
345 x_msg_data OUT NOCOPY VARCHAR2,
346 p_ps_strats_rec IN ps_strats_rec_type
347 );
348 END AMS_Ps_Strats_PVT;