[Home] [Help]
PACKAGE: APPS.AMS_CNT_POINT_PVT
Source
1 PACKAGE AMS_Cnt_Point_PVT AS
2 /* $Header: amsvcons.pls 120.0 2005/05/31 16:09:48 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Cnt_Point_PVT
7 -- Purpose
8 --
9 -- History
10 -- 20-may-2005 musman Added contact_point_value_id column for webadi collaboration script usage
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 -- cnt_point_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- contact_point_id
26 -- last_update_date
27 -- last_updated_by
28 -- creation_date
29 -- created_by
30 -- last_update_login
31 -- object_version_number
32 -- arc_contact_used_by
33 -- act_contact_used_by_id
34 -- contact_point_type
35 -- contact_point_value
36 -- city
37 -- country
38 -- zipcode
39 -- attribute_category
40 -- attribute1
41 -- attribute2
42 -- attribute3
43 -- attribute4
44 -- attribute5
45 -- attribute6
46 -- attribute7
47 -- attribute8
48 -- attribute9
49 -- attribute10
50 -- attribute11
51 -- attribute12
52 -- attribute13
53 -- attribute14
54 -- attribute15
55 -- content_point_value_id
56 -- Required
57 --
58 -- Defaults
59 --
60 -- Note: This is automatic generated record definition, it includes all columns
61 -- defined in the table, developer must manually add or delete some of the attributes.
62 --
63 -- End of Comments
64
65 --===================================================================
66 TYPE cnt_point_rec_type IS RECORD
67 (
68 contact_point_id NUMBER := FND_API.G_MISS_NUM,
69 last_update_date DATE := FND_API.G_MISS_DATE,
70 last_updated_by NUMBER := FND_API.G_MISS_NUM,
71 creation_date DATE := FND_API.G_MISS_DATE,
72 created_by NUMBER := FND_API.G_MISS_NUM,
73 last_update_login NUMBER := FND_API.G_MISS_NUM,
74 object_version_number NUMBER := FND_API.G_MISS_NUM,
75 arc_contact_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
76 act_contact_used_by_id NUMBER := FND_API.G_MISS_NUM,
77 contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 contact_point_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
79 city VARCHAR2(120) := FND_API.G_MISS_CHAR,
80 country NUMBER := FND_API.G_MISS_NUM,
81 zipcode VARCHAR2(120) := FND_API.G_MISS_CHAR,
82 attribute_category VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98 contact_point_value_id NUMBER := FND_API.G_MISS_NUM
99 );
100
101 g_miss_cnt_point_rec cnt_point_rec_type;
102 TYPE cnt_point_tbl_type IS TABLE OF cnt_point_rec_type INDEX BY BINARY_INTEGER;
103 g_miss_cnt_point_tbl cnt_point_tbl_type;
104
105 -- ==============================================================================
106 -- Start of Comments
107 -- ==============================================================================
108 -- API Name
109 -- Create_Cnt_Point
110 -- Type
111 -- Private
112 -- Pre-Req
113 --
114 -- Parameters
115 --
116 -- IN
117 -- p_api_version_number IN NUMBER Required
118 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
119 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
120 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
121 -- p_cnt_point_rec IN cnt_point_rec_type Required
122 --
123 -- OUT
124 -- x_return_status OUT VARCHAR2
125 -- x_msg_count OUT NUMBER
126 -- x_msg_data OUT VARCHAR2
127 -- Version : Current version 1.0
128 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
129 -- and basic operation, developer must manually add parameters and business logic as necessary.
130 --
131 -- End of Comments
132 -- ==============================================================================
133 --
134
135 PROCEDURE Create_Cnt_Point(
136 p_api_version_number IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144
145 p_cnt_point_rec IN cnt_point_rec_type := g_miss_cnt_point_rec,
146 x_contact_point_id OUT NOCOPY NUMBER
147 );
148
149 -- ==============================================================================
150 -- Start of Comments
151 -- ==============================================================================
152 -- API Name
153 -- Update_Cnt_Point
154 -- Type
155 -- Private
156 -- Pre-Req
157 --
158 -- Parameters
159 --
160 -- IN
161 -- p_api_version_number IN NUMBER Required
162 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
165 -- p_cnt_point_rec IN cnt_point_rec_type Required
166 --
167 -- OUT
168 -- x_return_status OUT VARCHAR2
169 -- x_msg_count OUT NUMBER
170 -- x_msg_data OUT VARCHAR2
171 -- Version : Current version 1.0
172 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
173 -- and basic operation, developer must manually add parameters and business logic as necessary.
174 --
175 -- End of Comments
176 -- ==============================================================================
177 --
178
179 PROCEDURE Update_Cnt_Point(
180 p_api_version_number IN NUMBER,
181 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182 p_commit IN VARCHAR2 := FND_API.G_FALSE,
183 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188
189 p_cnt_point_rec IN cnt_point_rec_type,
190 x_object_version_number OUT NOCOPY NUMBER
191 );
192
193 -- ==============================================================================
194 -- Start of Comments
195 -- ==============================================================================
196 -- API Name
197 -- Delete_Cnt_Point
198 -- Type
199 -- Private
200 -- Pre-Req
201 --
202 -- Parameters
203 --
204 -- IN
205 -- p_api_version_number IN NUMBER Required
206 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
207 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
208 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
209 -- p_CONTACT_POINT_ID IN NUMBER
210 -- p_object_version_number IN NUMBER Optional Default = NULL
211 --
212 -- OUT
213 -- x_return_status OUT VARCHAR2
214 -- x_msg_count OUT NUMBER
215 -- x_msg_data OUT VARCHAR2
216 -- Version : Current version 1.0
217 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
218 -- and basic operation, developer must manually add parameters and business logic as necessary.
219 --
220 -- End of Comments
221 -- ==============================================================================
222 --
223
224 PROCEDURE Delete_Cnt_Point(
225 p_api_version_number IN NUMBER,
226 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227 p_commit IN VARCHAR2 := FND_API.G_FALSE,
228 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_contact_point_id IN NUMBER,
233 p_object_version_number IN NUMBER
234 );
235
236 -- ==============================================================================
237 -- Start of Comments
238 -- ==============================================================================
239 -- API Name
240 -- Lock_Cnt_Point
241 -- Type
242 -- Private
243 -- Pre-Req
244 --
245 -- Parameters
246 --
247 -- IN
248 -- p_api_version_number IN NUMBER Required
249 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
250 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
251 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252 -- p_cnt_point_rec IN cnt_point_rec_type Required
253 --
254 -- OUT
255 -- x_return_status OUT VARCHAR2
256 -- x_msg_count OUT NUMBER
257 -- x_msg_data OUT VARCHAR2
258 -- Version : Current version 1.0
259 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
260 -- and basic operation, developer must manually add parameters and business logic as necessary.
261 --
262 -- End of Comments
263 -- ==============================================================================
264 --
265
266 PROCEDURE Lock_Cnt_Point(
267 p_api_version_number IN NUMBER,
268 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273
274 p_contact_point_id IN NUMBER,
275 p_object_version IN NUMBER
276 );
277
278
279 -- Start of Comments
280 --
281 -- validation procedures
282 --
283 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
284 -- For create: G_CREATE, for update: G_UPDATE
285 -- Note: 1. This is automated generated item level validation procedure.
286 -- The actual validation detail is needed to be added.
287 -- 2. We can also validate table instead of record. There will be an option for user to choose.
288 -- End of Comments
289
290 PROCEDURE Validate_cnt_point(
291 p_api_version_number IN NUMBER,
292 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294 p_validation_mode IN VARCHAR2,
295 p_cnt_point_rec IN cnt_point_rec_type,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2
299 );
300
301 -- Start of Comments
302 --
303 -- validation procedures
304 --
305 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
306 -- For create: G_CREATE, for update: G_UPDATE
307 -- Note: 1. This is automated generated item level validation procedure.
308 -- The actual validation detail is needed to be added.
309 -- 2. Validate the unique keys, lookups here
310 -- End of Comments
311
312 PROCEDURE Check_cnt_point_Items (
313 P_cnt_point_rec IN cnt_point_rec_type,
314 p_validation_mode IN VARCHAR2,
315 x_return_status OUT NOCOPY VARCHAR2
316 );
317
318 -- Start of Comments
319 --
320 -- Record level validation procedures
321 --
322 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
323 -- For create: G_CREATE, for update: G_UPDATE
324 -- Note: 1. This is automated generated item level validation procedure.
325 -- The actual validation detail is needed to be added.
326 -- 2. Developer can manually added inter-field level validation.
327 -- End of Comments
328
329 PROCEDURE Validate_cnt_point_rec(
330 p_api_version_number IN NUMBER,
331 p_validation_mode IN VARCHAR2,
332 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336 p_cnt_point_rec IN cnt_point_rec_type
337 );
338 END AMS_Cnt_Point_PVT;