1 PACKAGE AMS_PRETTY_URL_PVT AS
2 /* $Header: amsvpurs.pls 120.1 2006/09/06 17:28:43 dbiswas noship $ */
3
4
5 -- ===============================================================
6 -- Start of Comments
7 -- Package name
8 -- AMS_PRETTY_URL_PVT
9 -- Purpose
10 --
11 -- This package contains all the program units for Pretty Urls
12 --
13 -- History
14 --
15 -- NOTE
16 --
17 -- End of Comments
18 -- ===============================================================
19 G_PACKAGE_NAME CONSTANT VARCHAR2(30) := 'AMS_PRETTY_URL_PVT';
20
21 -- Start of Comments
22 -- Name
23 -- IS_SYSTEM_URL_UNIQ
24 --
25 -- Purpose
26 -- This procedure checks to see if the pretty_url/additional_url_params is unique
27 --
28
29 Procedure IS_SYSTEM_URL_UNIQ(
30 p_sys_url IN VARCHAR2,
31 p_current_used_by_id IN NUMBER,
32 p_current_used_by_type IN VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2
34 );
35
36 -- ===============================================================
37 -- Start of Comments
38 -- Package name
39 -- AMS_Pretty_Url_PVT
40 -- Purpose
41 --
42 -- History
43 --
44 -- NOTE
45 --
46 -- End of Comments
47 -- ===============================================================
48
49 -- Default number of records fetch per call
50 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
51 --===================================================================
52 -- Start of Comments
53 -- -------------------------------------------------------
54 -- Record name
55 -- pretty_url_rec_type
56 -- -------------------------------------------------------
57 -- Parameters:
58 -- pretty_url_id
59 -- creation_date
60 -- created_by
61 -- last_update_date
62 -- last_updated_by
63 -- last_update_login
64 -- object_version_number
65 -- landing_page_url
66 --
67 -- Required
68 --
69 -- Defaults
70 --
71 -- Note: This is automatic generated record definition, it includes all columns
72 -- defined in the table, developer must manually add or delete some of the attributes.
73 --
74 -- End of Comments
75
76 --===================================================================
77 TYPE pretty_url_rec_type IS RECORD
78 (
79 pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80 creation_date DATE := FND_API.G_MISS_DATE,
81 created_by NUMBER := FND_API.G_MISS_NUM,
82 last_update_date DATE := FND_API.G_MISS_DATE,
83 last_updated_by NUMBER := FND_API.G_MISS_NUM,
84 last_update_login NUMBER := FND_API.G_MISS_NUM,
85 object_version_number NUMBER := FND_API.G_MISS_NUM,
86 landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87 );
88
89 g_miss_pretty_url_rec pretty_url_rec_type;
90 TYPE pretty_url_tbl_type IS TABLE OF pretty_url_rec_type INDEX BY BINARY_INTEGER;
91 g_miss_pretty_url_tbl pretty_url_tbl_type;
92
93 -- ==============================================================================
94 -- Start of Comments
95 -- ==============================================================================
96 -- API Name
97 -- Create_Pretty_Url
98 -- Type
99 -- Private
100 -- Pre-Req
101 --
102 -- Parameters
103 --
104 -- IN
105 -- p_api_version_number IN NUMBER Required
106 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109 -- p_pretty_url_rec IN pretty_url_rec_type Required
110 --
111 -- OUT NOCOPY
112 -- x_return_status OUT NOCOPY VARCHAR2
113 -- x_msg_count OUT NOCOPY NUMBER
114 -- x_msg_data OUT NOCOPY VARCHAR2
115 -- Version : Current version 1.0
116 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
117 -- and basic operation, developer must manually add parameters and business logic as necessary.
118 --
119 -- End of Comments
120 -- ==============================================================================
121 --
122
123 PROCEDURE Create_Pretty_Url(
124 p_api_version_number IN NUMBER,
125 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126 p_commit IN VARCHAR2 := FND_API.G_FALSE,
127 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132
133 p_pretty_url_rec IN pretty_url_rec_type := g_miss_pretty_url_rec,
134 x_pretty_url_id OUT NOCOPY NUMBER
135 );
136
137 -- ==============================================================================
138 -- Start of Comments
139 -- ==============================================================================
140 -- API Name
141 -- Update_Pretty_Url
142 -- Type
143 -- Private
144 -- Pre-Req
145 --
146 -- Parameters
147 --
148 -- IN
149 -- p_api_version_number IN NUMBER Required
150 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153 -- p_pretty_url_rec IN pretty_url_rec_type Required
154 --
155 -- OUT NOCOPY
156 -- x_return_status OUT NOCOPY VARCHAR2
157 -- x_msg_count OUT NOCOPY NUMBER
158 -- x_msg_data OUT NOCOPY VARCHAR2
159 -- Version : Current version 1.0
160 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
161 -- and basic operation, developer must manually add parameters and business logic as necessary.
162 --
163 -- End of Comments
164 -- ==============================================================================
165 --
166
167 PROCEDURE Update_Pretty_Url(
168 p_api_version_number IN NUMBER,
172
169 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170 p_commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176
177 p_pretty_url_rec IN pretty_url_rec_type,
178 x_object_version_number OUT NOCOPY NUMBER
179 );
180
181 -- ==============================================================================
182 -- Start of Comments
183 -- ==============================================================================
184 -- API Name
185 -- Delete_Pretty_Url
186 -- Type
187 -- Private
188 -- Pre-Req
189 --
190 -- Parameters
191 --
192 -- IN
193 -- p_api_version_number IN NUMBER Required
194 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197 -- p_PRETTY_URL_ID IN NUMBER
198 -- p_object_version_number IN NUMBER Optional Default = NULL
199 --
200 -- OUT NOCOPY
201 -- x_return_status OUT NOCOPY VARCHAR2
202 -- x_msg_count OUT NOCOPY NUMBER
203 -- x_msg_data OUT NOCOPY VARCHAR2
204 -- Version : Current version 1.0
205 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
206 -- and basic operation, developer must manually add parameters and business logic as necessary.
207 --
208 -- End of Comments
209 -- ==============================================================================
210 --
211
212 PROCEDURE Delete_Pretty_Url(
213 p_api_version_number IN NUMBER,
214 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215 p_commit IN VARCHAR2 := FND_API.G_FALSE,
216 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_pretty_url_id IN NUMBER,
221 p_object_version_number IN NUMBER
222 );
223
224 -- ==============================================================================
225 -- Start of Comments
226 -- ==============================================================================
227 -- API Name
228 -- Lock_Pretty_Url
229 -- Type
230 -- Private
231 -- Pre-Req
232 --
233 -- Parameters
234 --
235 -- IN
236 -- p_api_version_number IN NUMBER Required
237 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
240 -- p_pretty_url_rec IN pretty_url_rec_type Required
241 --
242 -- OUT NOCOPY
243 -- x_return_status OUT NOCOPY VARCHAR2
244 -- x_msg_count OUT NOCOPY NUMBER
245 -- x_msg_data OUT NOCOPY VARCHAR2
246 -- Version : Current version 1.0
247 -- Note: This automatic generated procedure definition, it includes standard IN/OUT NOCOPY parameters
248 -- and basic operation, developer must manually add parameters and business logic as necessary.
249 --
250 -- End of Comments
251 -- ==============================================================================
252 --
253
254 PROCEDURE Lock_Pretty_Url(
255 p_api_version_number IN NUMBER,
259 x_msg_count OUT NOCOPY NUMBER,
256 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257
258 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_data OUT NOCOPY VARCHAR2,
261
262 p_pretty_url_id IN NUMBER,
263 p_object_version IN NUMBER
264 );
265
266
267 -- Start of Comments
268 --
269 -- validation procedures
270 --
271 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
272 -- For create: G_CREATE, for update: G_UPDATE
273 -- Note: 1. This is automated generated item level validation procedure.
274 -- The actual validation detail is needed to be added.
275 -- 2. We can also validate table instead of record. There will be an option for user to choose.
276 -- End of Comments
277
278 PROCEDURE Validate_pretty_url(
279 p_api_version_number IN NUMBER,
280 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282 p_pretty_url_rec IN pretty_url_rec_type,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 -- Start of Comments
289 --
290 -- validation procedures
291 --
292 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
293 -- For create: G_CREATE, for update: G_UPDATE
294 -- Note: 1. This is automated generated item level validation procedure.
295 -- The actual validation detail is needed to be added.
296 -- 2. Validate the unique keys, lookups here
297 -- End of Comments
298
299 PROCEDURE Check_pretty_url_Items (
300 P_pretty_url_rec IN pretty_url_rec_type,
301 p_validation_mode IN VARCHAR2,
302 x_return_status OUT NOCOPY VARCHAR2
303 );
304
305 -- Start of Comments
306 --
307 -- Record level validation procedures
308 --
309 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
310 -- For create: G_CREATE, for update: G_UPDATE
311 -- Note: 1. This is automated generated item level validation procedure.
312 -- The actual validation detail is needed to be added.
313 -- 2. Developer can manually added inter-field level validation.
314 -- End of Comments
315
316 PROCEDURE Validate_pretty_url_rec(
317 p_api_version_number IN NUMBER,
318 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319 x_return_status OUT NOCOPY VARCHAR2,
320 x_msg_count OUT NOCOPY NUMBER,
321 x_msg_data OUT NOCOPY VARCHAR2,
322 p_pretty_url_rec IN pretty_url_rec_type
323 );
324
325 --========================================================================
326 -- PROCEDURE
327 -- CHECK_PU_MANDATORY_FIELDS
328 --
329 -- PURPOSE
330 -- This api is created to be used for schedule status changes.
331 --
332 -- HISTORY
333 -- 28-Mar-2001 ptendulk Created.
334 --========================================================================
335
336 PROCEDURE CHECK_PU_MANDATORY_FIELDS(
337 p_pretty_url_rec IN pretty_url_rec_type,
338 x_return_status OUT NOCOPY VARCHAR2
339 );
340
341 END AMS_Pretty_Url_PVT;
342