eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 263: ,p_instance_rec IN csi_datastructures_pub.instance_rec

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

Line 265: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 266: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

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

Line 292: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,

288: /*---------------------------------------------------*/
289:
290: PROCEDURE Initialize_inst_rec
291: (
292: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,
293: p_instance_hist_id IN NUMBER ,
294: x_nearest_full_dump IN OUT NOCOPY DATE ) ;
295:
296: /*---------------------------------------------------*/

Line 304: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,

300: /*---------------------------------------------------*/
301:
302: PROCEDURE Construct_inst_from_hist
303: (
304: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec,
305: p_time_stamp IN DATE ) ;
306:
307: /*---------------------------------------------------*/
308: /* Procedure name: Construct_inst_header_rec */

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

312:
313: PROCEDURE Construct_inst_header_rec
314: (
315: p_inst_id IN NUMBER,
316: x_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl );
317:
318: /*----------------------------------------------------------*/
319: /* Procedure name: Resolve_Id_Columns */
320: /* Description : This procedure gets the column values */

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

321: /* for the Dynamic SQL */
322: /*----------------------------------------------------------*/
323:
324: PROCEDURE Resolve_id_columns
325: (p_instance_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_header_tbl);
326:
327: /*---------------------------------------------------*/
328: /* Procedure name: Define_Inst_Columns */
329: /* Description : This procedure defines the */

Line 336: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec );

332:
333: PROCEDURE Define_Inst_Columns
334: (
335: p_get_inst_cursor_id IN NUMBER,
336: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec );
337:
338: /*---------------------------------------------------*/
339: /* Procedure name: Bind_Inst_variable */
340: /* Description : Procedure used to generate the */

Line 346: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,

342: /*---------------------------------------------------*/
343:
344: PROCEDURE Bind_Inst_variable
345: (
346: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
347: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
348: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
349: p_transaction_id IN NUMBER,
350: p_cur_get_inst_rel IN NUMBER

Line 347: p_party_query_rec IN csi_datastructures_pub.party_query_rec,

343:
344: PROCEDURE Bind_Inst_variable
345: (
346: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
347: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
348: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
349: p_transaction_id IN NUMBER,
350: p_cur_get_inst_rel IN NUMBER
351: );

Line 348: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,

344: PROCEDURE Bind_Inst_variable
345: (
346: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
347: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
348: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
349: p_transaction_id IN NUMBER,
350: p_cur_get_inst_rel IN NUMBER
351: );
352:

Line 361: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,

357: /*---------------------------------------------------*/
358:
359: PROCEDURE Gen_Inst_Where_Clause
360: (
361: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
362: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
363: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
364: p_transaction_id IN NUMBER,
365: x_select_stmt OUT NOCOPY VARCHAR2,

Line 362: p_party_query_rec IN csi_datastructures_pub.party_query_rec,

358:
359: PROCEDURE Gen_Inst_Where_Clause
360: (
361: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
362: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
363: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
364: p_transaction_id IN NUMBER,
365: x_select_stmt OUT NOCOPY VARCHAR2,
366: p_active_instance_only IN VARCHAR2

Line 363: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,

359: PROCEDURE Gen_Inst_Where_Clause
360: (
361: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
362: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
363: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
364: p_transaction_id IN NUMBER,
365: x_select_stmt OUT NOCOPY VARCHAR2,
366: p_active_instance_only IN VARCHAR2
367: );

Line 378: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec

374:
375: PROCEDURE Get_Instance_Col_Values
376: (
377: p_get_instance_cur_id IN NUMBER,
378: x_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
379: );
380:
381: /*---------------------------------------------------*/
382: /* Procedure name: Define_Instance_Columns */

Line 401: p_instance_rec csi_datastructures_pub.instance_rec

397: /*---------------------------------------------------*/
398:
399: FUNCTION Anything_To_Update
400: (
401: p_instance_rec csi_datastructures_pub.instance_rec
402: )
403: RETURN BOOLEAN;
404:
405: /*----------------------------------------------------*/

Line 417: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

413: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
414: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
415: ,p_instance_id IN NUMBER
416: ,p_instance_expiry_flag IN VARCHAR2 := fnd_api.g_true
417: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
418: ,x_acct_class_code OUT NOCOPY VARCHAR2
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER
421: ,x_msg_data OUT NOCOPY VARCHAR2

Line 432: p_instance_rec IN csi_datastructures_pub.instance_header_rec,

428: /*---------------------------------------------------*/
429:
430: PROCEDURE Bind_Instance_variable
431: (
432: p_instance_rec IN csi_datastructures_pub.instance_header_rec,
433: p_cur_get_instance_rel IN NUMBER
434: );
435:
436: /*---------------------------------------------------*/

Line 448: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

444: p_api_version IN NUMBER
445: ,p_commit IN VARCHAR2 := fnd_api.g_false
446: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
447: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
448: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
449: ,p_quantity1 IN NUMBER
450: ,p_quantity2 IN NUMBER
451: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
452: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true

Line 458: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

454: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
458: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
459: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
460: ,x_return_status OUT NOCOPY VARCHAR2
461: ,x_msg_count OUT NOCOPY NUMBER
462: ,x_msg_data OUT NOCOPY VARCHAR2

Line 459: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec

455: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
456: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
457: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
458: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
459: ,x_new_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec
460: ,x_return_status OUT NOCOPY VARCHAR2
461: ,x_msg_count OUT NOCOPY NUMBER
462: ,x_msg_data OUT NOCOPY VARCHAR2
463: );

Line 476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

472: p_api_version IN NUMBER
473: ,p_commit IN VARCHAR2 := fnd_api.g_false
474: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
475: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
476: ,p_source_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
477: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_true
478: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_true
479: ,p_copy_parties IN VARCHAR2 := fnd_api.g_true
480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true

Line 484: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

480: -- ,p_copy_contacts IN VARCHAR2 := fnd_api.g_true
481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
484: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
485: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
486: ,x_return_status OUT NOCOPY VARCHAR2
487: ,x_msg_count OUT NOCOPY NUMBER
488: ,x_msg_data OUT NOCOPY VARCHAR2

Line 485: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

481: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_true
482: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_true
483: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_true
484: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
485: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
486: ,x_return_status OUT NOCOPY VARCHAR2
487: ,x_msg_count OUT NOCOPY NUMBER
488: ,x_msg_data OUT NOCOPY VARCHAR2
489: );

Line 499: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,

495: /*----------------------------------------------------------*/
496:
497: PROCEDURE Initialize_ver_rec_no_dump
498: (
499: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
500: p_version_label_id IN NUMBER ,
501: x_no_dump IN OUT NOCOPY DATE
502: );
503:

Line 512: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,

508: /*---------------------------------------------------*/
509:
510: PROCEDURE Initialize_ver_rec
511: (
512: x_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec,
513: p_version_label_hist_id IN NUMBER ,
514: x_nearest_full_dump IN OUT NOCOPY DATE ) ;
515:
516: /*---------------------------------------------------*/

Line 524: x_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl,

520: /*---------------------------------------------------*/
521:
522: PROCEDURE Construct_ver_from_hist
523: (
524: x_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl,
525: p_time_stamp IN DATE ) ;
526:
527: /*---------------------------------------------------*/
528: /* Procedure name: Get_Ver_Column_Values */

Line 536: x_ver_label_query_rec OUT NOCOPY csi_datastructures_pub.version_label_rec );

532:
533: PROCEDURE Get_Ver_Column_Values
534: (
535: p_get_ver_cursor_id IN NUMBER ,
536: x_ver_label_query_rec OUT NOCOPY csi_datastructures_pub.version_label_rec );
537:
538: /*---------------------------------------------------*/
539: /* Procedure name: Define_Ver_Columns */
540: /* Description : This procudure defines the */

Line 556: p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec,

552: /*---------------------------------------------------*/
553:
554: PROCEDURE Bind_Ver_variable
555: (
556: p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec,
557: p_get_ver_cursor_id IN NUMBER );
558:
559: /*---------------------------------------------------*/
560: /* Procedure name:Gen_Ver_Where_Clause */

Line 566: ( p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec

562: /* where cluase for Party relationship */
563: /*---------------------------------------------------*/
564:
565: PROCEDURE Gen_Ver_Where_Clause
566: ( p_ver_label_query_rec IN csi_datastructures_pub.version_label_query_rec
567: ,x_where_clause OUT NOCOPY VARCHAR2 );
568:
569: /*---------------------------------------------------*/
570: /* Pocedure name: Create_version_label */

Line 581: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec

577: ( p_api_version IN NUMBER
578: ,p_commit IN VARCHAR2 := fnd_api.g_false
579: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
580: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
581: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
582: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
583: ,x_return_status OUT NOCOPY VARCHAR2
584: ,x_msg_count OUT NOCOPY NUMBER
585: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 582: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

578: ,p_commit IN VARCHAR2 := fnd_api.g_false
579: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
580: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
581: ,p_version_label_rec IN OUT NOCOPY csi_datastructures_pub.version_label_rec
582: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
583: ,x_return_status OUT NOCOPY VARCHAR2
584: ,x_msg_count OUT NOCOPY NUMBER
585: ,x_msg_data OUT NOCOPY VARCHAR2 );
586:

Line 599: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec

595: ( p_api_version IN NUMBER
596: ,p_commit IN VARCHAR2 := fnd_api.g_false
597: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
598: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
600: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
601: ,p_call_transaction IN VARCHAR2 := fnd_api.g_true
602: ,x_return_status OUT NOCOPY VARCHAR2
603: ,x_msg_count OUT NOCOPY NUMBER

Line 600: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 618: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec

614: ( p_api_version IN NUMBER
615: ,p_commit IN VARCHAR2 := fnd_api.g_false
616: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
617: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
618: ,p_version_label_rec IN csi_datastructures_pub.version_label_rec
619: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ,x_msg_count OUT NOCOPY NUMBER
622: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 619: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 671: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,

667: /*----------------------------------------------------------*/
668:
669: PROCEDURE Initialize_ext_rec_no_dump
670: (
671: x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
672: p_ext_id IN NUMBER,
673: x_no_dump IN OUT NOCOPY DATE
674: );
675:

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

679: /* record from the history */
680: /*---------------------------------------------------*/
681:
682: PROCEDURE Initialize_ext_rec
683: (x_ext_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec,
684: p_ext_h_id IN NUMBER,
685: x_nearest_full_dump IN OUT NOCOPY DATE
686: );
687:

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

691: /* record from the history */
692: /*---------------------------------------------------*/
693:
694: PROCEDURE Construct_ext_from_hist
695: ( x_ext_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
696: p_time_stamp IN DATE
697: );
698:
699: /*---------------------------------------------------*/

Line 716: x_ext_rec OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec

712: /*---------------------------------------------------*/
713:
714: PROCEDURE Get_ext_Column_Values
715: ( p_get_ext_cursor_id IN NUMBER,
716: x_ext_rec OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
717: );
718:
719: /*---------------------------------------------------*/
720: /* Procedure name: Bind_ext_variable */

Line 726: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec,

722: /* values for the Dynamic SQL */
723: /*---------------------------------------------------*/
724:
725: PROCEDURE Bind_ext_variable
726: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec,
727: p_cur_get_ext IN NUMBER
728: );
729:
730: /*---------------------------------------------------*/

Line 738: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec

734: /* Attribute units */
735: /*---------------------------------------------------*/
736:
737: PROCEDURE Gen_ext_Where_Clause
738: ( p_ext_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
739: ,x_where_clause OUT NOCOPY VARCHAR2
740: );
741:
742: /*---------------------------------------------------*/

Line 754: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec

750: ( p_api_version IN NUMBER
751: ,p_commit IN VARCHAR2 := fnd_api.g_false
752: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
753: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
754: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
755: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
756: ,x_return_status OUT NOCOPY VARCHAR2
757: ,x_msg_count OUT NOCOPY NUMBER
758: ,x_msg_data OUT NOCOPY VARCHAR2

Line 755: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

751: ,p_commit IN VARCHAR2 := fnd_api.g_false
752: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
753: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
754: ,p_ext_attrib_rec IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_rec
755: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
756: ,x_return_status OUT NOCOPY VARCHAR2
757: ,x_msg_count OUT NOCOPY NUMBER
758: ,x_msg_data OUT NOCOPY VARCHAR2
759: ,p_ext_id_tbl IN OUT NOCOPY csi_item_instance_pvt.ext_id_tbl

Line 778: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec

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

Line 779: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

775: ,p_commit IN VARCHAR2 := fnd_api.g_false
776: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
777: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
778: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec
779: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
780: ,x_return_status OUT NOCOPY VARCHAR2
781: ,x_msg_count OUT NOCOPY NUMBER
782: ,x_msg_data OUT NOCOPY VARCHAR2
783: );

Line 797: ,p_ext_attrib_rec IN csi_datastructures_pub.extend_attrib_values_rec

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

Line 798: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

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

Line 816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

812: p_api_version IN NUMBER
813: ,p_commit IN VARCHAR2 := fnd_api.g_false
814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
815: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
816: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
817: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
818: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
819: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
820: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false

Line 826: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

822: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
826: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
827: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
828: ,x_return_status OUT NOCOPY VARCHAR2
829: ,x_msg_count OUT NOCOPY NUMBER
830: ,x_msg_data OUT NOCOPY VARCHAR2

Line 827: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

823: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
824: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
825: ,p_call_from_bom_expl IN VARCHAR2 DEFAULT fnd_api.g_false -- should be passed only from Explode BOM
826: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
827: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
828: ,x_return_status OUT NOCOPY VARCHAR2
829: ,x_msg_count OUT NOCOPY NUMBER
830: ,x_msg_data OUT NOCOPY VARCHAR2
831: );

Line 848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

844: p_api_version IN NUMBER
845: ,p_commit IN VARCHAR2 := fnd_api.g_false
846: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
847: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
849: ,p_explosion_level IN NUMBER
850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
851: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
852: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

846: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
847: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
849: ,p_explosion_level IN NUMBER
850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
851: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
852: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
853: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
854: ,x_return_status OUT NOCOPY VARCHAR2

Line 851: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

847: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
848: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
849: ,p_explosion_level IN NUMBER
850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
851: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
852: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
853: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
854: ,x_return_status OUT NOCOPY VARCHAR2
855: ,x_msg_count OUT NOCOPY NUMBER

Line 853: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

849: ,p_explosion_level IN NUMBER
850: ,p_item_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
851: ,p_item_relation_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
852: ,p_create_instance IN VARCHAR2 DEFAULT FND_API.G_FALSE
853: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
854: ,x_return_status OUT NOCOPY VARCHAR2
855: ,x_msg_count OUT NOCOPY NUMBER
856: ,x_msg_data OUT NOCOPY VARCHAR2
857: );

Line 871: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl

867: ,p_commit IN VARCHAR2 := fnd_api.g_false
868: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
869: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
870: ,p_transaction_id IN NUMBER
871: ,x_instance_history_tbl OUT NOCOPY csi_datastructures_pub.instance_history_tbl
872: ,x_return_status OUT NOCOPY VARCHAR2
873: ,x_msg_count OUT NOCOPY NUMBER
874: ,x_msg_data OUT NOCOPY VARCHAR2
875: );

Line 918: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl

914: ,p_commit IN VARCHAR2 := fnd_api.g_false
915: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
916: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
917: ,p_transaction_id IN NUMBER
918: ,x_ext_attrib_val_hist_tbl OUT NOCOPY csi_datastructures_pub.ext_attrib_val_history_tbl
919: ,x_return_status OUT NOCOPY VARCHAR2
920: ,x_msg_count OUT NOCOPY NUMBER
921: ,x_msg_data OUT NOCOPY VARCHAR2
922: );

Line 936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

932: ( p_api_version IN NUMBER
933: ,p_commit IN VARCHAR2 := fnd_api.g_false
934: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
935: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
936: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
937: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
938: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
939: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
940: ,p_copy_contacts IN VARCHAR2 := fnd_api.g_false

Line 946: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

942: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
946: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
947: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
948: ,x_return_status OUT NOCOPY VARCHAR2
949: ,x_msg_count OUT NOCOPY NUMBER
950: ,x_msg_data OUT NOCOPY VARCHAR2

Line 947: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

943: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
944: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
945: ,p_call_from_split IN VARCHAR2 := fnd_api.g_false
946: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
947: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
948: ,x_return_status OUT NOCOPY VARCHAR2
949: ,x_msg_count OUT NOCOPY NUMBER
950: ,x_msg_data OUT NOCOPY VARCHAR2
951: );

Line 967: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl

963: ,p_commit IN VARCHAR2 := fnd_api.g_false
964: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
965: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
966: ,p_transaction_id IN NUMBER
967: ,x_version_label_hist_tbl OUT NOCOPY csi_datastructures_pub.version_label_history_tbl
968: ,x_return_status OUT NOCOPY VARCHAR2
969: ,x_msg_count OUT NOCOPY NUMBER
970: ,x_msg_data OUT NOCOPY VARCHAR2
971: );

Line 986: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec

982: ,p_commit IN VARCHAR2 := fnd_api.g_false
983: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
984: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
985: ,p_instance_id IN NUMBER
986: ,x_instance_link_rec OUT NOCOPY csi_datastructures_pub.instance_link_rec
987: ,x_return_status OUT NOCOPY VARCHAR2
988: ,x_msg_count OUT NOCOPY NUMBER
989: ,x_msg_data OUT NOCOPY VARCHAR2
990: );

Line 998: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

994: p_api_version IN NUMBER
995: ,p_commit IN VARCHAR2 := fnd_api.g_false
996: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
997: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
998: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
999: ,x_return_status OUT NOCOPY VARCHAR2
1000: ,x_msg_count OUT NOCOPY NUMBER
1001: ,x_msg_data OUT NOCOPY VARCHAR2);
1002: