[Home] [Help]
PACKAGE: APPS.IBC_ASSOCIATIONS_GRP
Source
1 PACKAGE Ibc_Associations_Grp AUTHID CURRENT_USER AS
2 /* $Header: ibcgasss.pls 115.6 2003/09/19 21:55:37 enunez ship $ */
3
4
5 -- shared default value
6 G_OBJ_VERSION_DEFAULT CONSTANT NUMBER := 1;
7
8
9
10 --------------------------------------------------------------------------------
11 -- Start of comments
12 -- API name : Create_Association
13 -- Type : Group
14 -- Pre-reqs : None
15 -- Function : Create an association mapping between an External object
16 -- and a content item (optionally, a particular version).
17 --------------------------------------------------------------------------------
18 PROCEDURE Create_Association (
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
21 p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
22 p_assoc_type_code IN VARCHAR2,
23 p_assoc_object1 IN VARCHAR2,
24 p_assoc_object2 IN VARCHAR2 DEFAULT NULL,
25 p_assoc_object3 IN VARCHAR2 DEFAULT NULL,
26 p_assoc_object4 IN VARCHAR2 DEFAULT NULL,
27 p_assoc_object5 IN VARCHAR2 DEFAULT NULL,
28 p_content_item_id IN NUMBER,
29 p_citem_version_id IN NUMBER DEFAULT NULL,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2
33 );
34
35 --------------------------------------------------------------------------------
36 -- Start of comments
37 -- API name : Delete_Association
38 -- Type : Group
39 -- Pre-reqs : None
40 -- Function : Delete an association mapping between an External object
41 -- and a content item.
42 --------------------------------------------------------------------------------
43 PROCEDURE Delete_Association (
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
46 p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
47 p_assoc_type_code IN VARCHAR2,
48 p_assoc_object1 IN VARCHAR2,
49 p_assoc_object2 IN VARCHAR2 DEFAULT NULL,
50 p_assoc_object3 IN VARCHAR2 DEFAULT NULL,
51 p_assoc_object4 IN VARCHAR2 DEFAULT NULL,
52 p_assoc_object5 IN VARCHAR2 DEFAULT NULL,
53 p_content_item_id IN NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 --------------------------------------------------------------------------------
60 -- Start of comments
61 -- API name : Update_Association
62 -- Type : Group
63 -- Pre-reqs : None
64 -- Function : Update an External object's association mapping with
65 -- a content item (optionally, a particular version).
66 --------------------------------------------------------------------------------
67 PROCEDURE Update_Association (
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
70 p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
71 p_assoc_type_code IN VARCHAR2,
72 p_assoc_object1 IN VARCHAR2,
73 p_assoc_object2 IN VARCHAR2 DEFAULT NULL,
74 p_assoc_object3 IN VARCHAR2 DEFAULT NULL,
75 p_assoc_object4 IN VARCHAR2 DEFAULT NULL,
76 p_assoc_object5 IN VARCHAR2 DEFAULT NULL,
77 p_old_citem_id IN NUMBER,
78 p_new_citem_id IN NUMBER,
79 p_new_citem_ver_id IN NUMBER DEFAULT NULL,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85
86
87
88
89
90
91
92
93
94
95 PROCEDURE Move_Associations (
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2,
98 p_commit IN VARCHAR2,
99 p_old_content_item_ids IN JTF_NUMBER_TABLE,
100 p_new_content_item_ids IN JTF_NUMBER_TABLE,
101 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
102 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
103 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
104 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
105 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,
106 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 PROCEDURE Move_Associations (
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2,
115 p_commit IN VARCHAR2,
116 p_old_content_item_ids IN JTF_NUMBER_TABLE,
117 p_new_content_item_ids IN JTF_NUMBER_TABLE,
118 p_old_citem_version_ids IN JTF_NUMBER_TABLE,
119 p_new_citem_version_ids IN JTF_NUMBER_TABLE,
120 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
121 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
122 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
123 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
124 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,
125 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131 --------------------------------------------------------------------------------
132 -- Start of comments
133 -- API name : Create_Associations
134 -- Type : Group
135 -- Pre-reqs : None
136 -- Function : Create association mappings between content items and
137 -- other CRM objects.
138 -- Parameters :
139 -- IN : p_api_version IN NUMBER Required
140 -- p_init_msg_list IN VARCHAR2 Optional
141 -- Default = FND_API.G_FALSE
142 -- p_commit IN VARCHAR2 Optional
143 -- Default = FND_API.G_FALSE
144 -- p_content_item_ids IN JTF_NUMBER_TABLE Required
145 -- p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100 Required
146 -- p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300 Required
147 -- p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 Optional
148 -- Default = NULL
149 -- p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 Optional
150 -- Default = NULL
151 -- p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 Optional
152 -- Default = NULL
153 -- p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 Optional
154 -- Default = NULL
155 -- OUT : x_return_status OUT VARCHAR2
156 -- x_msg_count OUT NUMBER
157 -- x_msg_data OUT VARCHAR2
158 --------------------------------------------------------------------------------
159 PROCEDURE Create_Associations (
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
162 p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
163 p_content_item_ids IN JTF_NUMBER_TABLE,
164 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
165 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
166 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
167 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
168 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
169 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 PROCEDURE Create_Associations (
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
178 p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
179 p_content_item_ids IN JTF_NUMBER_TABLE,
180 p_citem_version_ids IN JTF_NUMBER_TABLE,
181 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
182 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
183 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
184 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
185 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
186 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2
190 );
191
192
193 --------------------------------------------------------------------------------
194 -- Start of comments
195 -- API name : Delete_Associations
196 -- Type : Group
197 -- Pre-reqs : None
198 -- Function : Delete association mappings between content items and
199 -- other CRM objects.
200 -- Parameters :
201 -- IN : p_api_version IN NUMBER Required
202 -- p_init_msg_list IN VARCHAR2 Optional
203 -- Default = FND_API.G_FALSE
204 -- p_commit IN VARCHAR2 Optional
205 -- Default = FND_API.G_FALSE
206 -- p_content_item_ids IN JTF_NUMBER_TABLE Required
207 -- p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100 Required
208 -- p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300 Required
209 -- p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 Optional
210 -- Default = NULL
211 -- p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 Optional
212 -- Default = NULL
213 -- p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 Optional
214 -- Default = NULL
215 -- p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 Optional
219 -- x_msg_data OUT VARCHAR2
216 -- Default = NULL
217 -- OUT : x_return_status OUT VARCHAR2
218 -- x_msg_count OUT NUMBER
220 --------------------------------------------------------------------------------
221 PROCEDURE Delete_Associations (
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
224 p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
225 p_content_item_ids IN JTF_NUMBER_TABLE,
226 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
227 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
228 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
229 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
230 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
231 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2
235 );
236
237 PROCEDURE Delete_Associations (
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
240 p_commit IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
241 p_content_item_ids IN JTF_NUMBER_TABLE,
242 p_citem_version_ids IN JTF_NUMBER_TABLE,
243 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
244 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
245 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
246 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
247 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
248 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2
252 );
253
254
255 PROCEDURE Get_Associations (
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
258 p_content_item_id IN NUMBER,
259 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
260 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
261 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
262 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
263 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
264 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
265 x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
266 x_assoc_objects1 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
267 x_assoc_objects2 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
268 x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
269 x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
270 x_assoc_objects5 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
271 x_assoc_names OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
272 x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2
276 );
277
278 PROCEDURE Get_Associations (
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE,
281 p_content_item_id IN NUMBER,
282 p_citem_version_id IN NUMBER,
283 p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
284 p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
285 p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
286 p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
287 p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
288 p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
289 x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
290 x_assoc_objects1 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
291 x_assoc_objects2 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
292 x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
293 x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
294 x_assoc_objects5 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
295 x_assoc_names OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
296 x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2
300 );
301
302 FUNCTION Get_Association_NameAndCode(p_content_item_id IN NUMBER,
303 p_citem_version_id IN NUMBER DEFAULT NULL,
304 p_assoc_type_code IN VARCHAR2,
305 p_assoc_object1 IN VARCHAR2,
306 p_assoc_object2 IN VARCHAR2 DEFAULT NULL,
307 p_assoc_object3 IN VARCHAR2 DEFAULT NULL,
308 p_assoc_object4 IN VARCHAR2 DEFAULT NULL,
309 p_assoc_object5 IN VARCHAR2 DEFAULT NULL
310 )
311 RETURN VARCHAR2;
312
313 PRAGMA RESTRICT_REFERENCES(Get_Association_NameAndCode, WNDS, WNPS, TRUST);
314
315 END Ibc_Associations_Grp;