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.INV_RESERVATIONS_INTERFACE dependencies on MTL_RESERVATIONS_INTERFACE

Line 24: ** information into MTL_RESERVATIONS_INTERFACE table.

20: ** Applications in need of reservations processing such as
21: ** Create Reservations, Update Reservations, Delete Reservations and
22: ** Transfer Reservations can write their specific requests with details such
23: ** as item, organization, demand, supply, inventory controls and quantity
24: ** information into MTL_RESERVATIONS_INTERFACE table.
25: ** rsv interface manager thru another program, rsv
26: ** batch processor, processes records from MTL_RESERVATIONS_INTERFACE table
27: ** into MTL_RESERVATIONS table, one or more reservation batch id(s) at a time.
28: ** A reservation batch id consists of one or more reservations processing

Line 26: ** batch processor, processes records from MTL_RESERVATIONS_INTERFACE table

22: ** Transfer Reservations can write their specific requests with details such
23: ** as item, organization, demand, supply, inventory controls and quantity
24: ** information into MTL_RESERVATIONS_INTERFACE table.
25: ** rsv interface manager thru another program, rsv
26: ** batch processor, processes records from MTL_RESERVATIONS_INTERFACE table
27: ** into MTL_RESERVATIONS table, one or more reservation batch id(s) at a time.
28: ** A reservation batch id consists of one or more reservations processing
29: ** requests in MTL_RESERVATIONS_INTERFACE table. Processing includes data
30: ** validation, executions of appropriate reservation APIs, thereby writing

Line 29: ** requests in MTL_RESERVATIONS_INTERFACE table. Processing includes data

25: ** rsv interface manager thru another program, rsv
26: ** batch processor, processes records from MTL_RESERVATIONS_INTERFACE table
27: ** into MTL_RESERVATIONS table, one or more reservation batch id(s) at a time.
28: ** A reservation batch id consists of one or more reservations processing
29: ** requests in MTL_RESERVATIONS_INTERFACE table. Processing includes data
30: ** validation, executions of appropriate reservation APIs, thereby writing
31: ** into MTL_RESERVATIONS table and finally deleting successfuly processed
32: ** records from MTL_RESERVATIONS_INTERFACE table.
33: **

Line 32: ** records from MTL_RESERVATIONS_INTERFACE table.

28: ** A reservation batch id consists of one or more reservations processing
29: ** requests in MTL_RESERVATIONS_INTERFACE table. Processing includes data
30: ** validation, executions of appropriate reservation APIs, thereby writing
31: ** into MTL_RESERVATIONS table and finally deleting successfuly processed
32: ** records from MTL_RESERVATIONS_INTERFACE table.
33: **
34: ** Input Parameters:
35: ** p_api_version_number
36: ** parameter to compare API version

Line 50: ** MTL_RESERVATIONS_INTERFACE for Read and Update.

46: ** x_retcode
47: ** mandatory concurrent program parameter
48: **
49: ** Tables Used:
50: ** MTL_RESERVATIONS_INTERFACE for Read and Update.
51: **
52: ** Current Version 1.0
53: ** Initial Version 1.0
54: ** ===========================================================================

Line 88: from mtl_reservations_interface mri1

84: cursor mric is
85: select
86: reservation_batch_id
87: , count(*) total_num
88: from mtl_reservations_interface mri1
89: where mri1.transaction_mode = 3 /* Background */
90: and mri1.row_status_code = 1 /* Active */
91: and mri1.error_code is null /* No errors */
92: and mri1.error_explanation is null /* No errors */

Line 95: select 1 from mtl_reservations_interface mri2

91: and mri1.error_code is null /* No errors */
92: and mri1.error_explanation is null /* No errors */
93: and mri1.lock_flag = 2 /* No */
94: and not exists(
95: select 1 from mtl_reservations_interface mri2
96: where mri1.reservation_batch_id = mri2.reservation_batch_id
97: and mri2.transaction_mode = 3
98: and (mri2.row_status_code <> 1 or
99: mri2.error_code is not null or

Line 374: ** information into MTL_RESERVATIONS_INTERFACE table.

370: ** Applications in need of reservations processing such as
371: ** Create Reservations, Update Reservations, Delete Reservations and
372: ** Transfer Reservations can write their specific requests with details such
373: ** as item, organization, demand, supply, inventory controls and quantity
374: ** information into MTL_RESERVATIONS_INTERFACE table.
375: ** rsv interface batch processor, processes records from
376: ** MTL_RESERVATIONS_INTERFACE table into MTL_RESERVATIONS table, one or more
377: ** reservation batch id(s) at a time. A reservation batch id consists of one
378: ** or more reservations processing requests in MTL_RESERVATIONS_INTERFACE table.

Line 376: ** MTL_RESERVATIONS_INTERFACE table into MTL_RESERVATIONS table, one or more

372: ** Transfer Reservations can write their specific requests with details such
373: ** as item, organization, demand, supply, inventory controls and quantity
374: ** information into MTL_RESERVATIONS_INTERFACE table.
375: ** rsv interface batch processor, processes records from
376: ** MTL_RESERVATIONS_INTERFACE table into MTL_RESERVATIONS table, one or more
377: ** reservation batch id(s) at a time. A reservation batch id consists of one
378: ** or more reservations processing requests in MTL_RESERVATIONS_INTERFACE table.
379: ** A reservations request in MTL_RESERVATIONS_INTERFACE table is uniquely
380: ** determined by a reservations interface id.

Line 378: ** or more reservations processing requests in MTL_RESERVATIONS_INTERFACE table.

374: ** information into MTL_RESERVATIONS_INTERFACE table.
375: ** rsv interface batch processor, processes records from
376: ** MTL_RESERVATIONS_INTERFACE table into MTL_RESERVATIONS table, one or more
377: ** reservation batch id(s) at a time. A reservation batch id consists of one
378: ** or more reservations processing requests in MTL_RESERVATIONS_INTERFACE table.
379: ** A reservations request in MTL_RESERVATIONS_INTERFACE table is uniquely
380: ** determined by a reservations interface id.
381: ** rsv interface batch processor in turn calls another program,
382: ** rsv interface line processor repetitively, passing each time a

Line 379: ** A reservations request in MTL_RESERVATIONS_INTERFACE table is uniquely

375: ** rsv interface batch processor, processes records from
376: ** MTL_RESERVATIONS_INTERFACE table into MTL_RESERVATIONS table, one or more
377: ** reservation batch id(s) at a time. A reservation batch id consists of one
378: ** or more reservations processing requests in MTL_RESERVATIONS_INTERFACE table.
379: ** A reservations request in MTL_RESERVATIONS_INTERFACE table is uniquely
380: ** determined by a reservations interface id.
381: ** rsv interface batch processor in turn calls another program,
382: ** rsv interface line processor repetitively, passing each time a
383: ** reservations interafce id under the current reservations batch id.

Line 387: ** rows from MTL_RESERVATIONS_INTERFACE table.

383: ** reservations interafce id under the current reservations batch id.
384: ** reservations interface line processor performs the actual reservations
385: ** processing.
386: ** rsv interface batch processor deletes successfully processed
387: ** rows from MTL_RESERVATIONS_INTERFACE table.
388: **
389: ** Input Parameters:
390: ** p_api_version_number
391: ** parameter to compare API version

Line 419: ** MTL_RESERVATIONS_INTERFACE for Read, Update and Delete.

415: ** if the number of messages in message list is 1, contains
416: ** message text
417: **
418: ** Tables Used:
419: ** MTL_RESERVATIONS_INTERFACE for Read, Update and Delete.
420: **
421: ** Current Version 1.0
422: ** Initial Version 1.0
423: ** ===========================================================================

Line 458: from mtl_reservations_interface mri

454: -- Cursor
455: cursor mric(batch_id number,
456: process_mode number) is
457: select reservation_interface_id
458: from mtl_reservations_interface mri
459: where mri.reservation_batch_id = batch_id
460: and mri.row_status_code = 1 /* Active */
461: and mri.transaction_mode = process_mode
462: and mri.error_code is null

Line 518: update mtl_reservations_interface

514: -- Record this point
515: savepoint alpha;
516:
517: -- Lock requests for reservation batch id
518: update mtl_reservations_interface
519: set lock_flag = 1 /* Yes */
520: where reservation_batch_id = l_batch_id
521: and row_status_code = 1 /* Active */
522: and lock_flag = 2 /* No */

Line 585: update mtl_reservations_interface

581: -- Rollback
582: rollback to savepoint alpha;
583:
584: -- Stamp error. rollback should have unlocked rows.
585: update mtl_reservations_interface
586: set
587: row_status_code = 3 /* Error */
588: , error_code = l_error_code
589: , error_explanation = substrb(l_error_text,1,240) -- Bug 5529609

Line 603: update mtl_reservations_interface

599: l_error_code is not null) and
600: (p_partial_batch_process_flag = 1))then
601:
602: -- Stamp error. Unlock rows.
603: update mtl_reservations_interface
604: set
605: row_status_code = 3 /* Error */
606: , lock_flag = 2 /* No */
607: , error_code = l_error_code

Line 616: delete mtl_reservations_interface

612: end loop;
613:
614: -- Delete processed rows
615: if (l_delete_rows = true) then
616: delete mtl_reservations_interface
617: where reservation_batch_id = l_batch_id
618: and transaction_mode = p_process_mode
619: and row_status_code = 2 /* Completed */
620: and error_code is null

Line 693: ** information into MTL_RESERVATIONS_INTERFACE table.

689: ** Applications in need of reservations processing such as
690: ** Create Reservations, Update Reservations, Delete Reservations and
691: ** Transfer Reservations can write their specific requests with details such
692: ** as item, organization, demand, supply, inventory controls and quantity
693: ** information into MTL_RESERVATIONS_INTERFACE table.
694: ** rsv interface line processor processes the reservations
695: ** request line in MTL_RESERVATIONS_INTERFACE, pointed by a given
696: ** reservations interface id. Processing includes data validation and
697: ** performing the requested reservation function by executing the appropriate

Line 695: ** request line in MTL_RESERVATIONS_INTERFACE, pointed by a given

691: ** Transfer Reservations can write their specific requests with details such
692: ** as item, organization, demand, supply, inventory controls and quantity
693: ** information into MTL_RESERVATIONS_INTERFACE table.
694: ** rsv interface line processor processes the reservations
695: ** request line in MTL_RESERVATIONS_INTERFACE, pointed by a given
696: ** reservations interface id. Processing includes data validation and
697: ** performing the requested reservation function by executing the appropriate
698: ** reservations API.
699: **

Line 707: ** MTL_RESERVATIONS_INTERFACE table.

703: ** p_init_msg_lst
704: ** flag indicating if message list should be initialized
705: ** p_reservation interface id
706: ** identifies reservations request line in
707: ** MTL_RESERVATIONS_INTERFACE table.
708: ** p_form_mode
709: ** 'Y','y' - called from form
710: ** 'N','n' - not called from form
711: **

Line 726: ** MTL_RESERVATIONS_INTERFACE for Read and Update.

722: ** if the number of messages in message list is 1, contains
723: ** message text
724: **
725: ** Tables Used:
726: ** MTL_RESERVATIONS_INTERFACE for Read and Update.
727: **
728: ** Current Version 1.0
729: ** Initial Version 1.0
730: ** ===========================================================================

Line 757: ** Variables to hold fetched data from mtl_reservations_interface

753: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
754: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
755:
756: /*
757: ** Variables to hold fetched data from mtl_reservations_interface
758: */
759: l_requirement_date date;
760: l_organization_id number;
761: l_inventory_item_id number;

Line 876: ** Fetch record from mtl_reservations_interface for the given reservation

872: x_error_code := NULL;
873: x_error_text := NULL;
874:
875: /*
876: ** Fetch record from mtl_reservations_interface for the given reservation
877: ** interface id.
878: */
879: -- INVCONV - Incorporate secondary columns into select
880: select

Line 1012: from mtl_reservations_interface

1008: , l_attribute12
1009: , l_attribute13
1010: , l_attribute14
1011: , l_attribute15
1012: from mtl_reservations_interface
1013: where reservation_interface_id = p_reservation_interface_id
1014: and row_status_code = 1 /* Active */
1015: and error_code is null
1016: and error_explanation is null;

Line 1141: -- Bug:3384601 - Uom Conversions are not happening when RESERVATION_UOM_CODE is populated in MTL_RESERVATIONS_INTERFACE

1137: End if;
1138: End if;
1139: End if;
1140:
1141: -- Bug:3384601 - Uom Conversions are not happening when RESERVATION_UOM_CODE is populated in MTL_RESERVATIONS_INTERFACE
1142: -- and processed by the Reservation Interface Manager. It was creating reservations always in primary_uom of the item.
1143:
1144: -- Bug 3475862 added below code for update reservation too, also, calling inv_cache to get the primary_uom_code for
1145: -- better performance.

Line 1424: update mtl_reservations_interface

1420:
1421: end if;
1422:
1423: if (l_return_status = fnd_api.g_ret_sts_success) then
1424: update mtl_reservations_interface
1425: set row_status_code = 2 /* Completed */
1426: where reservation_interface_id = p_reservation_interface_id;
1427: end if;
1428: