[Home] [Help]
33: /* Cursor definition to check whether item is a valid and it's lot, child lot controlled */
34: CURSOR c_chk_msi_attr IS
35: SELECT lot_control_code,
36: child_lot_flag
37: FROM mtl_system_items
38: WHERE inventory_item_id = p_inventory_item_id
39: AND organization_id = p_organization_id;
40:
41: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;
45: x_return_status := fnd_api.g_ret_sts_success;
46:
47: /******************* START Item validation ********************/
48:
49: /* Check item attributes in Mtl_system_items Table */
50: OPEN c_chk_msi_attr ;
51: FETCH c_chk_msi_attr INTO l_chk_msi_attr_rec;
52:
53: IF c_chk_msi_attr%NOTFOUND THEN
295: /* Verify p_copy_lot_attribute_flag and populate l_copy_lot_attribute_flag */
296:
297: IF p_copy_lot_attribute_flag IS NULL THEN
298: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either
299: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.
300:
301: /* Check needed for Lot UOM conversion */
302: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;
303: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
311: IF l_lot_uom_conv.lot_number_generation = 1 THEN
312: l_copy_lot_attribute_flag := NVL(l_lot_uom_conv.copy_lot_attribute_flag,'N') ;
313: ELSIF l_lot_uom_conv.lot_number_generation IN (2,3) THEN
314: SELECT copy_lot_attribute_flag INTO l_copy_lot_attribute_flag
315: FROM mtl_system_items
316: WHERE inventory_item_id = p_lot_rec.inventory_item_id
317: AND organization_id = p_lot_rec.organization_id;
318: END IF;
319:
606: , retest_interval
607: , maturity_days
608: , hold_days
609: , default_lot_status_id --bug10257769
610: FROM mtl_system_items_b
611: WHERE organization_id = cp_organization_id
612: AND inventory_item_id = cp_inventory_item_id;
613:
614: -- nsinghi bug#5209065 rework START. If existing lot,
967: user_defined_exp_date CONSTANT NUMBER := 4;
968: l_mtl_gen_obj_no NUMBER ;
969:
970: /*Program variables declaration */
971: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
972: l_chk_lot_uniqueness BOOLEAN;
973: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
974: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
975: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
969:
970: /*Program variables declaration */
971: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
972: l_chk_lot_uniqueness BOOLEAN;
973: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
974: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
975: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
976: l_wms_installed VARCHAR2(5);
977: l_lot_number_uniqueness NUMBER;
970: /*Program variables declaration */
971: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
972: l_chk_lot_uniqueness BOOLEAN;
973: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
974: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
975: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
976: l_wms_installed VARCHAR2(5);
977: l_lot_number_uniqueness NUMBER;
978: l_return_status VARCHAR2(1);
1247: SELECT shelf_life_days
1248: , shelf_life_code
1249: INTO l_shelf_life_days
1250: , l_shelf_life_code
1251: FROM mtl_system_items
1252: WHERE inventory_item_id = p_inventory_item_id
1253: AND organization_id = p_organization_id;
1254: EXCEPTION
1255: WHEN NO_DATA_FOUND THEN
1349:
1350: BEGIN
1351: SELECT lot_status_enabled , default_lot_status_id
1352: INTO l_lot_status_flag , l_def_lot_status
1353: FROM mtl_system_items
1354: WHERE organization_id = p_organization_id
1355: AND inventory_item_id = p_inventory_item_id ;
1356:
1357: IF p_status_id IS NOT NULL THEN
1693: l_lot_record c_get_lot_record%ROWTYPE;
1694:
1695: CURSOR c_get_item_info IS
1696: SELECT *
1697: FROM mtl_system_items
1698: WHERE organization_id = p_organization_id
1699: AND inventory_item_id = p_inventory_item_id ;
1700:
1701: l_item_info c_get_item_info%ROWTYPE;