[Home] [Help]
259: /* description : Define helper routine that validates Revision for a given */
260: /* Inventory Item Id */
261: /* Parameters Required: */
262: /* p_Inventory_Item_Id IN Item identifier */
263: /* p_Revision IN Revision from mtl serial numbers */
264: /*---------------------------------------------------------------------------*/
265: PROCEDURE Validate_Revision(p_Inventory_Item_Id IN NUMBER,
266: p_Revision IN VARCHAR2) IS
267:
429: /* procedure name: Validate_SerialNumber */
430: /* description : Validate Serial Number for a given Inv Item Id */
431: /* Parameters Required: */
432: /* p_Inventory_Item_Id IN Item identifier */
433: /* p_Serial_Number IN Serial_Number from mtl serial numbers */
434: /*---------------------------------------------------------------------------*/
435: PROCEDURE Validate_SerialNumber(p_Inventory_Item_Id IN NUMBER,
436: p_Serial_Number IN VARCHAR2) IS
437:
442: BEGIN
443:
444: SELECT Current_Status
445: INTO l_Current_Status
446: FROM mtl_serial_numbers
447: WHERE inventory_item_id = p_inventory_item_id
448: -- SU Should not check for current organization
449: -- AND current_organization_id = cs_std.get_item_valdn_orgzn_id
450: AND serial_number = p_Serial_Number;
1040: BEGIN
1041:
1042: SELECT Current_Status
1043: INTO l_Current_Status
1044: FROM mtl_serial_numbers
1045: WHERE inventory_item_id = p_inventory_item_id
1046: -- SU:02/24: While doing Serial Number validation current organization should not be
1047: -- hard coded to item validation organization. So please comment following statement
1048: --AND current_organization_id = cs_std.get_item_valdn_orgzn_id
4295: l_from_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4296: l_srl_rsv_match BOOLEAN;
4297: l_create_reservation BOOLEAN;
4298: l_highlevel_rsv BOOLEAN;
4299: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%type;
4300: l_quantity_reserved NUMBER;
4301: l_reservation_id NUMBER;
4302: l_error_code VARCHAR2(2000);
4303:
4303:
4304: --Define cursors
4305: --Cursor to get the serial numbers for the given reservation
4306: CURSOR Cur_Srl_Nums(p_inv_item_id NUMBER, p_Inv_Org_id NUMBER, p_reservation_Id number) is
4307: SELECT Serial_Number from MTL_SERIAL_NUMBERS
4308: WHERE INVENTORY_ITEM_ID = p_inv_item_id AND
4309: CURRENT_ORGANIZATION_ID = p_inv_org_id AND
4310: RESERVATION_ID = p_reservation_Id;
4311:
4543: l_mtl_reservation_tbl_count NUMBER;
4544: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4545: l_serial_rsv_tbl inv_reservation_global.serial_number_tbl_type;
4546:
4547: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%type;
4548: --Define cursors
4549: --Cursor to get the serial numbers for the given reservation
4550: CURSOR Cur_Srl_Nums(p_inv_item_id NUMBER, p_Inv_Org_id NUMBER, p_reservation_Id number) is
4551: SELECT Serial_Number from MTL_SERIAL_NUMBERS
4547: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%type;
4548: --Define cursors
4549: --Cursor to get the serial numbers for the given reservation
4550: CURSOR Cur_Srl_Nums(p_inv_item_id NUMBER, p_Inv_Org_id NUMBER, p_reservation_Id number) is
4551: SELECT Serial_Number from MTL_SERIAL_NUMBERS
4552: WHERE INVENTORY_ITEM_ID = p_inv_item_id AND
4553: CURRENT_ORGANIZATION_ID = p_inv_org_id AND
4554: RESERVATION_ID = p_reservation_Id;
4555: