1 PACKAGE CSI_ITEM_INSTANCE_PUB AUTHID CURRENT_USER as
2 /* $Header: csipiis.pls 120.5.12010000.1 2008/07/25 08:11:14 appldev ship $ */
3 /*#
4 * This is a public API for Item Instances Management.
5 * It contains routines to Create, Update, Copy and Get Item Instances.
6 * @rep:scope public
7 * @rep:product CSI
8 * @rep:displayname Manage Item Instances
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY CSI_ITEM_INSTANCE
12 */
13
14 /*----------------------------------------------------*/
15 /* procedure name: create_item_instance */
16 /* description : procedure used to */
17 /* create item instances */
18 /*----------------------------------------------------*/
19
20 /*#
21 * This procedure creates an Item Instance in Install Base along with its child entities.
22 * The child entities include associated parties, accounts, organization units,
23 * extended attributes, pricing attributes and asset assignments.
24 * The child entities are optional except for the owner party and owner account if the
25 * instance is owned by an external party.
26 * @param p_api_version Current API version
27 * @param p_commit API commits if set to fnd_api.g_true
28 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
29 * @param p_validation_level API validation level
30 * @param p_instance_rec Instance Record containing the attributes of the instance to be created
31 * @param p_ext_attrib_values_tbl Extended Attributes to be associated with the item instance
32 * @param p_party_tbl Parties to be associated with the item instance
33 * @param p_account_tbl Party Accounts to be associated with the Parties
34 * @param p_pricing_attrib_tbl Pricing Attributes to be associated with the item instance
35 * @param p_org_assignments_tbl Organization Assignments to be associated with the item instance
36 * @param p_asset_assignment_tbl Asset Attributes to be associated with the item instance
37 * @param p_txn_rec Transaction Record structure
38 * @param x_return_status API Return Status
39 * @param x_msg_count Message count
40 * @param x_msg_data Message Data
41 * @rep:scope public
42 * @rep:lifecycle active
43 * @rep:displayname Create Item Instance
44 */
45 PROCEDURE create_item_instance
46 (
47 p_api_version IN NUMBER
48 ,p_commit IN VARCHAR2 := fnd_api.g_false
49 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51 ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52 ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53 ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54 ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55 ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56 ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57 ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 /*----------------------------------------------------*/
65 /* Procedure name: update_item_instance */
66 /* Description : procedure used to update an Item */
67 /* Instance */
68 /*----------------------------------------------------*/
69
70 /*#
71 * This procedure updates an existing item instance and its child entities in Install Base.
72 * @param p_api_version API version
73 * @param p_commit API commits if set to fnd_api.g_true
74 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
75 * @param p_validation_level API validation level
76 * @param p_instance_rec Instance Record structure containing the instance that needs to be updated
77 * @param p_ext_attrib_values_tbl Extended Attributes to be updated
78 * @param p_party_tbl Parties to be updated
79 * @param p_account_tbl Party Accounts to be updated
80 * @param p_pricing_attrib_tbl Pricing Attributes to be updated
81 * @param p_org_assignments_tbl Organization Assignments to be updated
82 * @param p_asset_assignment_tbl Asset Attributes to be updated
83 * @param p_txn_rec Transaction Record structure
84 * @param x_instance_id_lst List of instances
85 * @param x_return_status API Return Status
86 * @param x_msg_count Message count
87 * @param x_msg_data Message Data
88 * @rep:scope public
89 * @rep:lifecycle active
90 * @rep:displayname Update Item Instance
91 */
92 PROCEDURE update_item_instance
93 (
94 p_api_version IN NUMBER
95 ,p_commit IN VARCHAR2 := fnd_api.g_false
96 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
97 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98 ,p_instance_rec IN csi_datastructures_pub.instance_rec
99 ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100 ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101 ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102 ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103 ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104 ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 /*----------------------------------------------------*/
113 /* Procedure name: expire_item_instance */
114 /* Description : procedure for */
115 /* Expiring an Item Instance */
116 /*----------------------------------------------------*/
117
118 PROCEDURE expire_item_instance
119 (
120 p_api_version IN NUMBER
121 ,p_commit IN VARCHAR2 := fnd_api.g_false
122 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
124 ,p_instance_rec IN csi_datastructures_pub.instance_rec
125 ,p_expire_children IN VARCHAR2 := fnd_api.g_false
126 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
127 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
128 ,x_return_status OUT NOCOPY VARCHAR2
129 ,x_msg_count OUT NOCOPY NUMBER
130 ,x_msg_data OUT NOCOPY VARCHAR2
131 );
132
133 /*----------------------------------------------------*/
134 /* Procedure name: get_item_instances */
135 /* Description : procedure to */
136 /* get an Item Instance */
137 /*----------------------------------------------------*/
138
139 /*#
140 * This procedure gets a list of item instances in Oracle Install Base satisfying the
141 * query criteria provided by the calling application.
142 * @param p_api_version API version
143 * @param p_commit API commits if set to fnd_api.g_true
144 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
145 * @param p_validation_level API validation level
146 * @param p_instance_query_rec Instance query criteria record structure
147 * @param p_party_query_rec Party query criteria record structure
148 * @param p_account_query_rec Party Account query criteria record structure
149 * @param p_transaction_id Transaction ID based query
150 * @param p_resolve_id_columns Resolve ID Columns to get corresponding description
151 * @param p_active_instance_only Get only active instances
152 * @param x_instance_header_tbl Output table structure containing the instance information
153 * @param x_return_status API Return Status
154 * @param x_msg_count Message count
155 * @param x_msg_data Message Data
156 * @rep:scope public
157 * @rep:lifecycle active
158 * @rep:displayname Get Item Instances
159 */
160 PROCEDURE get_item_instances
161 (
162 p_api_version IN NUMBER
163 ,p_commit IN VARCHAR2 := fnd_api.g_false
164 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
166 ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
167 ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
168 ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169 ,p_transaction_id IN NUMBER
170 ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
171 ,p_active_instance_only IN VARCHAR2 := fnd_api.g_true
172 ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
173 ,x_return_status OUT NOCOPY VARCHAR2
174 ,x_msg_count OUT NOCOPY NUMBER
175 ,x_msg_data OUT NOCOPY VARCHAR2
176 );
177
178 /*#
179 * This procedure gets the details of an Item Instance at a given point of time along with other
180 * entities if needed. It uses only the instance query criteria to get the instances and the
181 * information is constructed from history if a time stamp is passed. If the time stamp is not
182 * passed then the current information would be retreived. The other entities are retreived if the
183 * corresponding p_get's are set to fnd_api.g_true.
184 * @param p_api_version API version
185 * @param p_commit API commits if set to fnd_api.g_true
186 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
187 * @param p_validation_level API validation level
188 * @param p_instance_rec Instance record structure containing the instance_id to be queried and the output
189 * @param p_get_parties Decides whether to get Party information
190 * @param p_party_header_tbl Contains the output of Party for the instance
191 * @param p_get_accounts Decides whether to get Party Account information
192 * @param p_account_header_tbl Contains the output of Party Account for the instance
193 * @param p_get_org_assignments Decides whether to get Org Assignments information
194 * @param p_org_header_tbl Contains the output of Org Assignments for the instance
195 * @param p_get_pricing_attribs Decides whether to get Pricing Attributes information
196 * @param p_pricing_attrib_tbl Contains the output of pricing attributes for the instance
197 * @param p_get_ext_attribs Decides whether to get Extended Attributes information
198 * @param p_ext_attrib_tbl Contains the output of extended attributes values for the instance
199 * @param p_ext_attrib_def_tbl Contains the output of extended attributes definition
200 * @param p_get_asset_assignments Decides whether to get Assets
201 * @param p_asset_header_tbl Contains the output Assets for the instance
202 * @param p_resolve_id_columns Resolve ID Columns to get corresponding description
203 * @param p_time_stamp Instance information as of given time
204 * @param x_return_status API Return Status
205 * @param x_msg_count Message count
206 * @param x_msg_data Message Data
207 * @rep:scope public
208 * @rep:lifecycle active
209 * @rep:displayname Get Item Instance Details
210 */
211 /*----------------------------------------------------*/
212 /* Procedure name: get_item_instance_details */
213 /* Description : procedure to */
214 /* get an Item Instance details */
215 /*----------------------------------------------------*/
216
217 PROCEDURE get_item_instance_details
218 (
219 p_api_version IN NUMBER
220 ,p_commit IN VARCHAR2 := fnd_api.g_false
221 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
222 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
223 ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
224 ,p_get_parties IN VARCHAR2 := fnd_api.g_false
225 ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226 ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227 ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228 ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229 ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230 ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231 ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232 ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233 ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234 ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235 ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
236 ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
237 ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
238 ,p_time_stamp IN DATE
239 ,x_return_status OUT NOCOPY VARCHAR2
240 ,x_msg_count OUT NOCOPY NUMBER
241 ,x_msg_data OUT NOCOPY VARCHAR2
242 );
243
244 /*----------------------------------------------------*/
245 /* Pocedure name: get_version_label */
246 /* Description : procedure for creating */
247 /* version label for */
248 /* an Item Instance */
249 /*----------------------------------------------------*/
250
251 PROCEDURE get_version_labels
252 ( p_api_version IN NUMBER
253 ,p_commit IN VARCHAR2 := fnd_api.g_false
254 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
255 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
256 ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
257 ,p_time_stamp IN DATE
258 ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
259 ,x_return_status OUT NOCOPY VARCHAR2
260 ,x_msg_count OUT NOCOPY NUMBER
261 ,x_msg_data OUT NOCOPY VARCHAR2 );
262
263 /*----------------------------------------------------*/
264 /* Pocedure name: Create_version_label */
265 /* Description : procedure for creating */
266 /* version label for */
267 /* an Item Instance */
268 /*----------------------------------------------------*/
269
270 PROCEDURE create_version_label
271 ( p_api_version IN NUMBER
272 ,p_commit IN VARCHAR2 := fnd_api.g_false
273 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
274 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
275 ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
276 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
277 ,x_return_status OUT NOCOPY VARCHAR2
278 ,x_msg_count OUT NOCOPY NUMBER
279 ,x_msg_data OUT NOCOPY VARCHAR2 );
280
281 /*----------------------------------------------------*/
282 /* Procedure name: Update_version_label */
283 /* Description : procedure for Update */
284 /* version label for */
285 /* an Item Instance */
286 /*----------------------------------------------------*/
287
288 PROCEDURE update_version_label
289 ( p_api_version IN NUMBER
290 ,p_commit IN VARCHAR2 := fnd_api.g_false
291 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
292 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
293 ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
294 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
295 ,x_return_status OUT NOCOPY VARCHAR2
296 ,x_msg_count OUT NOCOPY NUMBER
297 ,x_msg_data OUT NOCOPY VARCHAR2 );
298
299 /*----------------------------------------------------*/
300 /* Procedure name: expire_version_label */
301 /* Description : procedure for expire */
302 /* version label for */
303 /* an Item Instance */
304 /*----------------------------------------------------*/
305
306 PROCEDURE expire_version_label
307 ( p_api_version IN NUMBER
308 ,p_commit IN VARCHAR2 := fnd_api.g_false
309 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
311 ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
312 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
313 ,x_return_status OUT NOCOPY VARCHAR2
314 ,x_msg_count OUT NOCOPY NUMBER
315 ,x_msg_data OUT NOCOPY VARCHAR2 );
316
317 /*----------------------------------------------------*/
318 /* procedure name: get_extended_attrib_values */
319 /* description : Gets the extended attribute */
320 /* values of an item instance */
321 /*----------------------------------------------------*/
322
323 PROCEDURE get_extended_attrib_values
324 ( p_api_version IN NUMBER
325 ,p_commit IN VARCHAR2 := fnd_api.g_false
326 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
327 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
328 ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
329 ,p_time_stamp IN DATE
330 ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
331 ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
332 ,x_return_status OUT NOCOPY VARCHAR2
333 ,x_msg_count OUT NOCOPY NUMBER
334 ,x_msg_data OUT NOCOPY VARCHAR2
335 );
336
337 /*----------------------------------------------------*/
338 /* procedure name: create_extended_attrib_values */
339 /* description : Associates extended attribute */
340 /* values to an item instance */
341 /*----------------------------------------------------*/
342
343 PROCEDURE create_extended_attrib_values
344 ( p_api_version IN NUMBER
345 ,p_commit IN VARCHAR2 := fnd_api.g_false
346 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
347 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
348 ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
349 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
350 ,x_return_status OUT NOCOPY VARCHAR2
351 ,x_msg_count OUT NOCOPY NUMBER
352 ,x_msg_data OUT NOCOPY VARCHAR2
353 );
354
355 /*----------------------------------------------------*/
356 /* procedure name: update_extended_attrib_values */
357 /* description : Updates extended attrib values for */
358 /* for an item instance */
359 /*----------------------------------------------------*/
360
361 PROCEDURE update_extended_attrib_values
362 ( p_api_version IN NUMBER
363 ,p_commit IN VARCHAR2 := fnd_api.g_false
364 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
365 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
366 ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
367 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
368 ,x_return_status OUT NOCOPY VARCHAR2
369 ,x_msg_count OUT NOCOPY NUMBER
370 ,x_msg_data OUT NOCOPY VARCHAR2
371 );
372
373 /*----------------------------------------------------*/
374 /* procedure name: Expire_extended_attrib_values */
375 /* description : Expires extended attribute values */
376 /* for an item instance */
377 /*----------------------------------------------------*/
378
379 PROCEDURE expire_extended_attrib_values
380 ( p_api_version IN NUMBER
381 ,p_commit IN VARCHAR2 := fnd_api.g_false
382 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
383 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
384 ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
385 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
386 ,x_return_status OUT NOCOPY VARCHAR2
387 ,x_msg_count OUT NOCOPY NUMBER
388 ,x_msg_data OUT NOCOPY VARCHAR2
389 );
390
391 /*---------------------------------------------------*/
392 /* procedure name: copy_item_instance */
393 /* description : Copies an instace from an instance */
394 /* */
395 /* */
396 /*---------------------------------------------------*/
397
398 /*#
399 * This procedure creates a new item instance and its child entities by copying an existing
400 * item instance in Oracle Install Base.
401 * The child instances underneath the source instance would be copied if the parameter p_copy_inst_children
402 * is set to fnd_api.g_true.
403 * @param p_api_version API version
404 * @param p_commit API commits if set to fnd_api.g_true
405 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
406 * @param p_validation_level API validation level
407 * @param p_source_instance_rec Contains the source instance record that needs to be copied
408 * @param p_copy_ext_attribs Determines whether to copy Extended Attributes for the instance
409 * @param p_copy_org_assignments Determines whether to copy Org Assignments for the instance
410 * @param p_copy_parties Determines whether to copy Parties for the instance
411 * @param p_copy_party_contacts Determines whether to copy Contact Parties for the instance
412 * @param p_copy_accounts Determines whether to copy Party Accounts for the instance
413 * @param p_copy_asset_assignments Determines whether to copy Assets for the instance
414 * @param p_copy_pricing_attribs Determines whether to copy Pricing Attributes for the instance
415 * @param p_copy_inst_children Determines whether to copy child instances underneath this instance
416 * @param p_txn_rec Transaction Record structure
417 * @param x_new_instance_tbl Contains the new instance information
418 * @param x_return_status API Return Status
419 * @param x_msg_count Message count
420 * @param x_msg_data Message Data
421 * @rep:scope public
422 * @rep:lifecycle active
423 * @rep:displayname Copy Item Instance
424 */
425 PROCEDURE copy_item_instance
426 (
427 p_api_version IN NUMBER
428 ,p_commit IN VARCHAR2 := fnd_api.g_false
429 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
430 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
431 ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
432 ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
433 ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
434 ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
435 ,p_copy_party_contacts IN VARCHAR2 := fnd_api.g_false
436 ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
437 ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
438 ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
439 ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
440 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
441 ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
442 ,x_return_status OUT NOCOPY VARCHAR2
443 ,x_msg_count OUT NOCOPY NUMBER
444 ,x_msg_data OUT NOCOPY VARCHAR2
445 );
446
447 TYPE txn_oks_type_tbl is TABLE of VARCHAR2(3) INDEX BY BINARY_INTEGER;
448
449 PROCEDURE get_oks_txn_types (
450 p_api_version IN NUMBER
451 ,p_commit IN VARCHAR2
452 ,p_init_msg_list IN VARCHAR2
453 ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC
454 ,p_check_contracts_yn IN VARCHAR2
455 ,p_txn_type IN VARCHAR2
456 ,x_txn_type_tbl OUT NOCOPY CSI_ITEM_INSTANCE_PUB.TXN_OKS_TYPE_TBL
457 ,x_configflag OUT NOCOPY VARCHAR2
458 ,px_txn_date IN OUT NOCOPY DATE
459 ,x_imp_contracts_flag OUT NOCOPY VARCHAR2
460 ,x_return_status OUT NOCOPY VARCHAR2
461 ,x_msg_count OUT NOCOPY NUMBER
462 ,x_msg_data OUT NOCOPY VARCHAR2
463 );
464
465
466 END CSI_ITEM_INSTANCE_PUB;