[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
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;
4314: l_quantity_reserved NUMBER;
4315: l_reservation_id NUMBER;
4316: l_error_code VARCHAR2(2000);
4317:
4317:
4318: --Define cursors
4319: --Cursor to get the serial numbers for the given reservation
4320: CURSOR Cur_Srl_Nums(p_inv_item_id NUMBER, p_Inv_Org_id NUMBER, p_reservation_Id number) is
4321: SELECT Serial_Number from MTL_SERIAL_NUMBERS
4322: WHERE INVENTORY_ITEM_ID = p_inv_item_id AND
4323: CURRENT_ORGANIZATION_ID = p_inv_org_id AND
4324: RESERVATION_ID = p_reservation_Id;
4325:
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
4564: CURSOR Cur_Srl_Nums(p_inv_item_id NUMBER, p_Inv_Org_id NUMBER, p_reservation_Id number) is
4565: SELECT Serial_Number from MTL_SERIAL_NUMBERS
4561: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%type;
4562: --Define cursors
4563: --Cursor to get the serial numbers for the given reservation
4564: CURSOR Cur_Srl_Nums(p_inv_item_id NUMBER, p_Inv_Org_id NUMBER, p_reservation_Id number) is
4565: SELECT Serial_Number from MTL_SERIAL_NUMBERS
4566: WHERE INVENTORY_ITEM_ID = p_inv_item_id AND
4567: CURRENT_ORGANIZATION_ID = p_inv_org_id AND
4568: RESERVATION_ID = p_reservation_Id;
4569: