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