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