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 375: ** information into MTL_RESERVATIONS_INTERFACE table.

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

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

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

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

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

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

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

Line 388: ** rows from MTL_RESERVATIONS_INTERFACE table.

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

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

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

Line 459: from mtl_reservations_interface mri

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

Line 519: update mtl_reservations_interface

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

Line 586: update mtl_reservations_interface

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

Line 604: update mtl_reservations_interface

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

Line 617: delete mtl_reservations_interface

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

Line 694: ** information into MTL_RESERVATIONS_INTERFACE table.

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

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

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

Line 708: ** MTL_RESERVATIONS_INTERFACE table.

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

Line 727: ** MTL_RESERVATIONS_INTERFACE for Read and Update.

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

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

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

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

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

Line 1015: from mtl_reservations_interface

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

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

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

Line 1466: update mtl_reservations_interface

1462:
1463: end if;
1464:
1465: if (l_return_status = fnd_api.g_ret_sts_success) then
1466: update mtl_reservations_interface
1467: set row_status_code = 2 /* Completed */
1468: where reservation_interface_id = p_reservation_interface_id;
1469: end if;
1470: