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