DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 178: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

174: ,p_commit IN VARCHAR2 := fnd_api.g_false
175: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
176: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
177: ,px_config_tbl IN OUT NOCOPY csi_cz_int.config_tbl
178: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_count OUT NOCOPY NUMBER
181: ,x_msg_data OUT NOCOPY VARCHAR2
182: );

Line 192: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

188: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
189: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
190: ,p_config_tbl IN csi_cz_int.config_tbl
191: ,p_unlock_all IN VARCHAR2 :=fnd_api.g_false
192: -- ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
193: ,x_return_status OUT NOCOPY VARCHAR2
194: ,x_msg_count OUT NOCOPY NUMBER
195: ,x_msg_data OUT NOCOPY VARCHAR2
196: );

Line 204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

200: p_api_version IN NUMBER
201: ,p_commit IN VARCHAR2 := fnd_api.g_false
202: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
206: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
207: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
208: ,x_return_status OUT NOCOPY VARCHAR2

Line 205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

201: ,p_commit IN VARCHAR2 := fnd_api.g_false
202: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
206: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
207: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER

Line 206: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

202: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
206: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
207: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER
210: ,x_msg_data OUT NOCOPY VARCHAR2

Line 207: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

203: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
204: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
205: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
206: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
207: ,p_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER
210: ,x_msg_data OUT NOCOPY VARCHAR2
211: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl

Line 232: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

228: p_api_version IN NUMBER
229: ,p_commit IN VARCHAR2 := fnd_api.g_false
230: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
231: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
232: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
233: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
234:
235: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
236: ,x_return_status OUT NOCOPY VARCHAR2

Line 233: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

229: ,p_commit IN VARCHAR2 := fnd_api.g_false
230: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
231: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
232: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
233: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
234:
235: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
236: ,x_return_status OUT NOCOPY VARCHAR2
237: ,x_msg_count OUT NOCOPY NUMBER

Line 235: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

231: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
232: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
233: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
234:
235: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
236: ,x_return_status OUT NOCOPY VARCHAR2
237: ,x_msg_count OUT NOCOPY NUMBER
238: ,x_msg_data OUT NOCOPY VARCHAR2
239: ,p_item_attribute_tbl IN OUT NOCOPY csi_item_instance_pvt.item_attribute_tbl

Line 262: p_instance_rec IN csi_datastructures_pub.instance_rec,

258: ( p_api_version IN NUMBER,
259: p_commit IN VARCHAR2,
260: p_init_msg_list IN VARCHAR2,
261: p_validation_level IN NUMBER,
262: p_instance_rec IN csi_datastructures_pub.instance_rec,
263: p_expire_children IN VARCHAR2,
264: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
265: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
266: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,

Line 264: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

260: p_init_msg_list IN VARCHAR2,
261: p_validation_level IN NUMBER,
262: p_instance_rec IN csi_datastructures_pub.instance_rec,
263: p_expire_children IN VARCHAR2,
264: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
265: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
266: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,

Line 265: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,

261: p_validation_level IN NUMBER,
262: p_instance_rec IN csi_datastructures_pub.instance_rec,
263: p_expire_children IN VARCHAR2,
264: p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
265: x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl,
266: p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2

Line 284: ,p_instance_rec IN csi_datastructures_pub.instance_rec

280: p_api_version IN NUMBER
281: ,p_commit IN VARCHAR2 := fnd_api.g_false
282: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
283: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
284: ,p_instance_rec IN csi_datastructures_pub.instance_rec
285: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
286: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
287: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
288: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl

Line 286: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

282: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
283: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
284: ,p_instance_rec IN csi_datastructures_pub.instance_rec
285: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
286: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
287: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
288: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
289: ,x_return_status OUT NOCOPY VARCHAR2
290: ,x_msg_count OUT NOCOPY NUMBER

Line 287: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

283: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
284: ,p_instance_rec IN csi_datastructures_pub.instance_rec
285: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
286: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
287: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
288: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
289: ,x_return_status OUT NOCOPY VARCHAR2
290: ,x_msg_count OUT NOCOPY NUMBER
291: ,x_msg_data OUT NOCOPY VARCHAR2

Line 313: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,

309: /*---------------------------------------------------*/
310:
311: PROCEDURE Initialize_inst_rec
312: (
313: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,
314: p_instance_hist_id IN NUMBER ,
315: x_nearest_full_dump IN OUT NOCOPY DATE ) ;
316:
317: /*---------------------------------------------------*/

Line 325: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,

321: /*---------------------------------------------------*/
322:
323: PROCEDURE Construct_inst_from_hist
324: (
325: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,
326: p_time_stamp IN DATE ) ;
327:
328: /*---------------------------------------------------*/
329: /* Procedure name: Construct_inst_header_rec */

Line 337: x_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl );

333:
334: PROCEDURE Construct_inst_header_rec
335: (
336: p_inst_id IN NUMBER,
337: x_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl );
338:
339: /*----------------------------------------------------------*/
340: /* Procedure name: Resolve_Id_Columns */
341: /* Description : This procedure gets the column values */

Line 346: (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl);

342: /* for the Dynamic SQL */
343: /*----------------------------------------------------------*/
344:
345: PROCEDURE Resolve_id_columns
346: (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl);
347:
348: /*---------------------------------------------------*/
349: /* Procedure name: Define_Inst_Columns */
350: /* Description : This procedure defines the */

Line 357: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec );

353:
354: PROCEDURE Define_Inst_Columns
355: (
356: p_get_inst_cursor_id IN NUMBER,
357: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec );
358:
359: /*---------------------------------------------------*/
360: /* Procedure name: Bind_Inst_variable */
361: /* Description : Procedure used to generate the */

Line 367: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,

363: /*---------------------------------------------------*/
364:
365: PROCEDURE Bind_Inst_variable
366: (
367: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
368: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
369: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
370: p_transaction_id IN NUMBER,
371: p_cur_get_inst_rel IN NUMBER

Line 368: p_party_query_rec IN csi_datastructures_pub.party_query_rec,

364:
365: PROCEDURE Bind_Inst_variable
366: (
367: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
368: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
369: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
370: p_transaction_id IN NUMBER,
371: p_cur_get_inst_rel IN NUMBER
372: );

Line 369: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,

365: PROCEDURE Bind_Inst_variable
366: (
367: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
368: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
369: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
370: p_transaction_id IN NUMBER,
371: p_cur_get_inst_rel IN NUMBER
372: );
373:

Line 382: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,

378: /*---------------------------------------------------*/
379:
380: PROCEDURE Gen_Inst_Where_Clause
381: (
382: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
383: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
384: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
385: p_transaction_id IN NUMBER,
386: x_select_stmt OUT NOCOPY VARCHAR2,

Line 383: p_party_query_rec IN csi_datastructures_pub.party_query_rec,

379:
380: PROCEDURE Gen_Inst_Where_Clause
381: (
382: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
383: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
384: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
385: p_transaction_id IN NUMBER,
386: x_select_stmt OUT NOCOPY VARCHAR2,
387: p_active_instance_only IN VARCHAR2

Line 384: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,

380: PROCEDURE Gen_Inst_Where_Clause
381: (
382: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
383: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
384: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
385: p_transaction_id IN NUMBER,
386: x_select_stmt OUT NOCOPY VARCHAR2,
387: p_active_instance_only IN VARCHAR2
388: );

Line 399: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec

395:
396: PROCEDURE Get_Instance_Col_Values
397: (
398: p_get_instance_cur_id IN NUMBER,
399: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
400: );
401:
402: /*---------------------------------------------------*/
403: /* Procedure name: Define_Instance_Columns */

Line 422: p_instance_rec csi_datastructures_pub.instance_rec

418: /*---------------------------------------------------*/
419:
420: FUNCTION Anything_To_Update
421: (
422: p_instance_rec csi_datastructures_pub.instance_rec
423: )
424: RETURN BOOLEAN;
425:
426: /*----------------------------------------------------*/

Line 438: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

434: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
435: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
436: ,p_instance_id IN NUMBER
437: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
438: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
439: ,x_acct_class_code OUT NOCOPY VARCHAR2
440: ,x_return_status OUT NOCOPY VARCHAR2
441: ,x_msg_count OUT NOCOPY NUMBER
442: ,x_msg_data OUT NOCOPY VARCHAR2

Line 453: p_instance_rec IN csi_datastructures_pub.instance_header_rec,

449: /*---------------------------------------------------*/
450:
451: PROCEDURE Bind_Instance_variable
452: (
453: p_instance_rec IN csi_datastructures_pub.instance_header_rec,
454: p_cur_get_instance_rel IN NUMBER
455: );
456:
457: /*---------------------------------------------------*/

Line 469: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

465: p_api_version IN NUMBER
466: ,p_commit IN VARCHAR2 := fnd_api.g_false
467: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
468: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
469: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
470: ,p_quantity1 IN NUMBER
471: ,p_quantity2 IN NUMBER
472: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
473: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true

Line 479: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

475: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
479: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
480: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
481: ,x_return_status OUT NOCOPY VARCHAR2
482: ,x_msg_count OUT NOCOPY NUMBER
483: ,x_msg_data OUT NOCOPY VARCHAR2

Line 480: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

476: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
477: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
479: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
480: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
481: ,x_return_status OUT NOCOPY VARCHAR2
482: ,x_msg_count OUT NOCOPY NUMBER
483: ,x_msg_data OUT NOCOPY VARCHAR2
484: );

Line 497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

493: p_api_version IN NUMBER
494: ,p_commit IN VARCHAR2 := fnd_api.g_false
495: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
496: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
497: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
498: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
499: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
500: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true

Line 505: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

501: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
504: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
505: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
506: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
507: ,x_return_status OUT NOCOPY VARCHAR2
508: ,x_msg_count OUT NOCOPY NUMBER
509: ,x_msg_data OUT NOCOPY VARCHAR2

Line 506: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

502: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
503: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
504: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
505: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
506: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
507: ,x_return_status OUT NOCOPY VARCHAR2
508: ,x_msg_count OUT NOCOPY NUMBER
509: ,x_msg_data OUT NOCOPY VARCHAR2
510: );

Line 520: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,

516: /*----------------------------------------------------------*/
517:
518: PROCEDURE Initialize_ver_rec_no_dump
519: (
520: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
521: p_version_label_id IN NUMBER ,
522: x_no_dump IN OUT NOCOPY DATE
523: );
524:

Line 533: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,

529: /*---------------------------------------------------*/
530:
531: PROCEDURE Initialize_ver_rec
532: (
533: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
534: p_version_label_hist_id IN NUMBER ,
535: x_nearest_full_dump IN OUT NOCOPY DATE ) ;
536:
537: /*---------------------------------------------------*/

Line 545: x_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl,

541: /*---------------------------------------------------*/
542:
543: PROCEDURE Construct_ver_from_hist
544: (
545: x_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl,
546: p_time_stamp IN DATE ) ;
547:
548: /*---------------------------------------------------*/
549: /* Procedure name: Get_Ver_Column_Values */

Line 557: x_ver_label_query_rec OUT NOCOPY csi_datastructures_pub.version_label_rec );

553:
554: PROCEDURE Get_Ver_Column_Values
555: (
556: p_get_ver_cursor_id IN NUMBER ,
557: x_ver_label_query_rec OUT NOCOPY csi_datastructures_pub.version_label_rec );
558:
559: /*---------------------------------------------------*/
560: /* Procedure name: Define_Ver_Columns */
561: /* Description : This procudure defines the */

Line 577: p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec,

573: /*---------------------------------------------------*/
574:
575: PROCEDURE Bind_Ver_variable
576: (
577: p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec,
578: p_get_ver_cursor_id IN NUMBER );
579:
580: /*---------------------------------------------------*/
581: /* Procedure name:Gen_Ver_Where_Clause */

Line 587: ( p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec

583: /* where cluase for Party relationship */
584: /*---------------------------------------------------*/
585:
586: PROCEDURE Gen_Ver_Where_Clause
587: ( p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec
588: ,x_where_clause OUT NOCOPY VARCHAR2 );
589:
590: /*---------------------------------------------------*/
591: /* Pocedure name: Create_version_label */

Line 602: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec

598: ( p_api_version IN NUMBER
599: ,p_commit IN VARCHAR2 := fnd_api.g_false
600: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
601: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
602: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
606: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

599: ,p_commit IN VARCHAR2 := fnd_api.g_false
600: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
601: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
602: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
603: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
604: ,x_return_status OUT NOCOPY VARCHAR2
605: ,x_msg_count OUT NOCOPY NUMBER
606: ,x_msg_data OUT NOCOPY VARCHAR2 );
607:

Line 620: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec

616: ( p_api_version IN NUMBER
617: ,p_commit IN VARCHAR2 := fnd_api.g_false
618: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
619: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
620: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
621: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
622: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true
623: ,x_return_status OUT NOCOPY VARCHAR2
624: ,x_msg_count OUT NOCOPY NUMBER

Line 621: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

617: ,p_commit IN VARCHAR2 := fnd_api.g_false
618: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
619: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
620: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
621: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
622: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true
623: ,x_return_status OUT NOCOPY VARCHAR2
624: ,x_msg_count OUT NOCOPY NUMBER
625: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 639: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec

635: ( p_api_version IN NUMBER
636: ,p_commit IN VARCHAR2 := fnd_api.g_false
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
639: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
640: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
641: ,x_return_status OUT NOCOPY VARCHAR2
642: ,x_msg_count OUT NOCOPY NUMBER
643: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 640: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

636: ,p_commit IN VARCHAR2 := fnd_api.g_false
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
639: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
640: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
641: ,x_return_status OUT NOCOPY VARCHAR2
642: ,x_msg_count OUT NOCOPY NUMBER
643: ,x_msg_data OUT NOCOPY VARCHAR2 );
644:

Line 692: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,

688: /*----------------------------------------------------------*/
689:
690: PROCEDURE Initialize_ext_rec_no_dump
691: (
692: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
693: p_ext_id IN NUMBER,
694: x_no_dump IN OUT NOCOPY DATE
695: );
696:

Line 704: (x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,

700: /* record from the history */
701: /*---------------------------------------------------*/
702:
703: PROCEDURE Initialize_ext_rec
704: (x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
705: p_ext_h_id IN NUMBER,
706: x_nearest_full_dump IN OUT NOCOPY DATE
707: );
708:

Line 716: ( x_ext_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

712: /* record from the history */
713: /*---------------------------------------------------*/
714:
715: PROCEDURE Construct_ext_from_hist
716: ( x_ext_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
717: p_time_stamp IN DATE
718: );
719:
720: /*---------------------------------------------------*/

Line 737: x_ext_rec OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec

733: /*---------------------------------------------------*/
734:
735: PROCEDURE Get_ext_Column_Values
736: ( p_get_ext_cursor_id IN NUMBER,
737: x_ext_rec OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
738: );
739:
740: /*---------------------------------------------------*/
741: /* Procedure name: Bind_ext_variable */

Line 747: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec,

743: /* values for the Dynamic SQL */
744: /*---------------------------------------------------*/
745:
746: PROCEDURE Bind_ext_variable
747: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec,
748: p_cur_get_ext IN NUMBER
749: );
750:
751: /*---------------------------------------------------*/

Line 759: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec

755: /* Attribute units */
756: /*---------------------------------------------------*/
757:
758: PROCEDURE Gen_ext_Where_Clause
759: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
760: ,x_where_clause OUT NOCOPY VARCHAR2
761: );
762:
763: /*---------------------------------------------------*/

Line 775: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec

771: ( p_api_version IN NUMBER
772: ,p_commit IN VARCHAR2 := fnd_api.g_false
773: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
774: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
775: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
776: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
777: ,x_return_status OUT NOCOPY VARCHAR2
778: ,x_msg_count OUT NOCOPY NUMBER
779: ,x_msg_data OUT NOCOPY VARCHAR2

Line 776: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

772: ,p_commit IN VARCHAR2 := fnd_api.g_false
773: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
774: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
775: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
776: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
777: ,x_return_status OUT NOCOPY VARCHAR2
778: ,x_msg_count OUT NOCOPY NUMBER
779: ,x_msg_data OUT NOCOPY VARCHAR2
780: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl

Line 799: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec

795: ( p_api_version IN NUMBER
796: ,p_commit IN VARCHAR2 := fnd_api.g_false
797: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
798: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
799: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
800: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
801: ,x_return_status OUT NOCOPY VARCHAR2
802: ,x_msg_count OUT NOCOPY NUMBER
803: ,x_msg_data OUT NOCOPY VARCHAR2

Line 800: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

796: ,p_commit IN VARCHAR2 := fnd_api.g_false
797: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
798: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
799: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
800: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
801: ,x_return_status OUT NOCOPY VARCHAR2
802: ,x_msg_count OUT NOCOPY NUMBER
803: ,x_msg_data OUT NOCOPY VARCHAR2
804: );

Line 818: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec

814: ( p_api_version IN NUMBER
815: ,p_commit IN VARCHAR2 := fnd_api.g_false
816: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
817: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
818: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
820: ,x_return_status OUT NOCOPY VARCHAR2
821: ,x_msg_count OUT NOCOPY NUMBER
822: ,x_msg_data OUT NOCOPY VARCHAR2

Line 819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

815: ,p_commit IN VARCHAR2 := fnd_api.g_false
816: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
817: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
818: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
819: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
820: ,x_return_status OUT NOCOPY VARCHAR2
821: ,x_msg_count OUT NOCOPY NUMBER
822: ,x_msg_data OUT NOCOPY VARCHAR2
823: );

Line 837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

833: p_api_version IN NUMBER
834: ,p_commit IN VARCHAR2 := fnd_api.g_false
835: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
836: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
837: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
838: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
839: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
840: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
841: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false

Line 847: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

843: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
846: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
847: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
848: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
849: ,x_return_status OUT NOCOPY VARCHAR2
850: ,x_msg_count OUT NOCOPY NUMBER
851: ,x_msg_data OUT NOCOPY VARCHAR2

Line 848: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

844: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
845: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
846: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
847: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
848: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
849: ,x_return_status OUT NOCOPY VARCHAR2
850: ,x_msg_count OUT NOCOPY NUMBER
851: ,x_msg_data OUT NOCOPY VARCHAR2
852: );

Line 869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

865: p_api_version IN NUMBER
866: ,p_commit IN VARCHAR2 := fnd_api.g_false
867: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
868: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
870: ,p_explosion_level IN NUMBER
871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
872: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
873: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

867: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
868: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
870: ,p_explosion_level IN NUMBER
871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
872: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
873: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
875: ,x_return_status OUT NOCOPY VARCHAR2

Line 872: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

868: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
869: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
870: ,p_explosion_level IN NUMBER
871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
872: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
873: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
875: ,x_return_status OUT NOCOPY VARCHAR2
876: ,x_msg_count OUT NOCOPY NUMBER

Line 874: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

870: ,p_explosion_level IN NUMBER
871: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
872: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
873: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
874: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
875: ,x_return_status OUT NOCOPY VARCHAR2
876: ,x_msg_count OUT NOCOPY NUMBER
877: ,x_msg_data OUT NOCOPY VARCHAR2
878: );

Line 892: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl

888: ,p_commit IN VARCHAR2 := fnd_api.g_false
889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
890: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
891: ,p_transaction_id IN NUMBER
892: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
893: ,x_return_status OUT NOCOPY VARCHAR2
894: ,x_msg_count OUT NOCOPY NUMBER
895: ,x_msg_data OUT NOCOPY VARCHAR2
896: );

Line 939: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl

935: ,p_commit IN VARCHAR2 := fnd_api.g_false
936: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
937: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
938: ,p_transaction_id IN NUMBER
939: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
940: ,x_return_status OUT NOCOPY VARCHAR2
941: ,x_msg_count OUT NOCOPY NUMBER
942: ,x_msg_data OUT NOCOPY VARCHAR2
943: );

Line 957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

953: ( p_api_version IN NUMBER
954: ,p_commit IN VARCHAR2 := fnd_api.g_false
955: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
956: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
957: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
958: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
959: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
960: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
961: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false

Line 967: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

963: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
966: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
967: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
968: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
969: ,x_return_status OUT NOCOPY VARCHAR2
970: ,x_msg_count OUT NOCOPY NUMBER
971: ,x_msg_data OUT NOCOPY VARCHAR2

Line 968: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

964: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
965: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
966: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
967: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
968: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
969: ,x_return_status OUT NOCOPY VARCHAR2
970: ,x_msg_count OUT NOCOPY NUMBER
971: ,x_msg_data OUT NOCOPY VARCHAR2
972: );

Line 988: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl

984: ,p_commit IN VARCHAR2 := fnd_api.g_false
985: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
986: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
987: ,p_transaction_id IN NUMBER
988: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
989: ,x_return_status OUT NOCOPY VARCHAR2
990: ,x_msg_count OUT NOCOPY NUMBER
991: ,x_msg_data OUT NOCOPY VARCHAR2
992: );

Line 1007: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec

1003: ,p_commit IN VARCHAR2 := fnd_api.g_false
1004: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1005: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1006: ,p_instance_id IN NUMBER
1007: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
1008: ,x_return_status OUT NOCOPY VARCHAR2
1009: ,x_msg_count OUT NOCOPY NUMBER
1010: ,x_msg_data OUT NOCOPY VARCHAR2
1011: );

Line 1019: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1015: p_api_version IN NUMBER
1016: ,p_commit IN VARCHAR2 := fnd_api.g_false
1017: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1018: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1019: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1020: ,x_return_status OUT NOCOPY VARCHAR2
1021: ,x_msg_count OUT NOCOPY NUMBER
1022: ,x_msg_data OUT NOCOPY VARCHAR2);
1023: