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.CSD_LOGISTICS_UTIL dependencies on INV_RESERVATION_GLOBAL

Line 4189: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,

4185: -- End of Comments.
4186: ---------------------------------------------------------------------------------------------------------------------
4187: PROCEDURE SET_RSV_REC (
4188: p_rsv_serial_rec IN CSD_SERIAL_RESERVE_REC_TYPE,
4189: x_rsv_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type,
4190: x_return_status OUT NOCOPY VARCHAR2
4191: )
4192: IS
4193:

Line 4225: x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

4221: x_rsv_rec.primary_reservation_quantity := NULL;
4222: x_rsv_rec.autodetail_group_id := NULL;
4223: x_rsv_rec.external_source_code := 'CSD';
4224: x_rsv_rec.external_source_line_id := NULL;
4225: x_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
4226: x_rsv_rec.supply_source_header_id := NULL;
4227: x_rsv_rec.supply_source_line_id := NULL;
4228: x_rsv_rec.supply_source_name := NULL;
4229: x_rsv_rec.supply_source_line_detail := NULL;

Line 4241: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_oe;

4237: x_rsv_rec.revision := p_rsv_serial_Rec.revision;
4238: x_rsv_rec.lot_number := p_rsv_serial_Rec.lot_number;
4239: x_rsv_rec.demand_source_header_id := INV_salesorder.GET_SALESORDER_FOR_OEHEADER(p_rsv_serial_rec.order_header_id);
4240: x_rsv_rec.demand_source_line_id := p_rsv_serial_rec.order_line_id;
4241: x_rsv_rec.demand_source_type_id := inv_reservation_global.g_source_type_oe;
4242: x_rsv_rec.inventory_item_id := p_rsv_serial_rec.inventory_item_id;
4243: x_rsv_rec.organization_id := p_rsv_serial_rec.inv_organization_id;
4244: x_rsv_rec.reservation_uom_code := p_rsv_serial_rec.reservation_uom_code;
4245:

Line 4300: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;

4296: l_api_name CONSTANT VARCHAR2(30) := 'reserve_serial_number';
4297: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4298: -- Variables to check the log level according to the coding standards
4299: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4300: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4301: l_msg_Count NUMBER;
4302: l_msg_data VARCHAR2(4000);
4303: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4304: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 4303: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

4299: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4300: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4301: l_msg_Count NUMBER;
4302: l_msg_data VARCHAR2(4000);
4303: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4304: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4305: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4306: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4307: l_mtl_reservation_tbl_count NUMBER;

Line 4304: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

4300: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4301: l_msg_Count NUMBER;
4302: l_msg_data VARCHAR2(4000);
4303: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4304: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4305: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4306: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4307: l_mtl_reservation_tbl_count NUMBER;
4308: lx_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;

Line 4305: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;

4301: l_msg_Count NUMBER;
4302: l_msg_data VARCHAR2(4000);
4303: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4304: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4305: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4306: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4307: l_mtl_reservation_tbl_count NUMBER;
4308: lx_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4309: l_from_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;

Line 4306: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

4302: l_msg_data VARCHAR2(4000);
4303: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4304: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4305: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4306: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4307: l_mtl_reservation_tbl_count NUMBER;
4308: lx_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4309: l_from_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4310: l_srl_rsv_match BOOLEAN;

Line 4308: lx_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;

4304: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4305: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4306: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4307: l_mtl_reservation_tbl_count NUMBER;
4308: lx_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4309: l_from_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4310: l_srl_rsv_match BOOLEAN;
4311: l_create_reservation BOOLEAN;
4312: l_highlevel_rsv BOOLEAN;

Line 4309: l_from_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;

4305: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4306: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4307: l_mtl_reservation_tbl_count NUMBER;
4308: lx_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4309: l_from_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4310: l_srl_rsv_match BOOLEAN;
4311: l_create_reservation BOOLEAN;
4312: l_highlevel_rsv BOOLEAN;
4313: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%type;

Line 4552: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;

4548: l_api_name CONSTANT VARCHAR2(30) := 'unreserve_serial_number';
4549: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4550: -- Variables to check the log level according to the coding standards
4551: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4552: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4553: l_msg_Count NUMBER;
4554: l_msg_data VARCHAR2(4000);
4555: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4556: l_error_code varchar2(2000);

Line 4555: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

4551: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4552: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4553: l_msg_Count NUMBER;
4554: l_msg_data VARCHAR2(4000);
4555: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4556: l_error_code varchar2(2000);
4557: l_mtl_reservation_tbl_count NUMBER;
4558: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4559: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;

Line 4558: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

4554: l_msg_data VARCHAR2(4000);
4555: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4556: l_error_code varchar2(2000);
4557: l_mtl_reservation_tbl_count NUMBER;
4558: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4559: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4560:
4561: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%type;
4562: --Define cursors

Line 4559: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;

4555: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4556: l_error_code varchar2(2000);
4557: l_mtl_reservation_tbl_count NUMBER;
4558: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4559: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4560:
4561: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%type;
4562: --Define cursors
4563: --Cursor to get the serial numbers for the given reservation