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