1473:
1474: BEGIN
1475: SELECT abc_class_id
1476: INTO l_abc_class_id
1477: FROM mtl_cycle_count_items
1478: WHERE cycle_count_header_id = l_cycle_count_header_id
1479: AND inventory_item_id = l_inventory_item_id;
1480: EXCEPTION
1481: WHEN NO_DATA_FOUND THEN
1487: SELECT approval_tolerance_positive,
1488: approval_tolerance_negative
1489: INTO l_item_app_tol_pos,
1490: l_item_app_tol_neg
1491: FROM mtl_cycle_count_items
1492: WHERE cycle_count_header_id = l_cycle_count_header_id
1493: AND inventory_item_id = l_inventory_item_id;
1494: ELSE
1495: l_item_app_tol_pos := NULL;
7317: -- Make sure that this inventory item is defined in the
7318: -- cycle count header item scope
7319: SELECT COUNT ( * )
7320: INTO l_temp_count
7321: FROM mtl_cycle_count_items
7322: WHERE inventory_item_id = v_lpn_id.inventory_item_id
7323: AND cycle_count_header_id = p_cycle_count_header_id;
7324:
7325: IF ( l_temp_count <> 0 ) THEN
7359: -- Make sure that this inventory item is defined in the
7360: -- cycle count header item scope
7361: SELECT COUNT ( * )
7362: INTO l_temp_count
7363: FROM mtl_cycle_count_items
7364: WHERE inventory_item_id = v_lpn_content.inventory_item_id
7365: AND cycle_count_header_id = p_cycle_count_header_id;
7366:
7367: IF ( l_temp_count <> 0 ) THEN
7411: -- Make sure that this inventory item is defined in the
7412: -- cycle count header item scope
7413: SELECT COUNT ( * )
7414: INTO l_temp_count
7415: FROM mtl_cycle_count_items
7416: WHERE inventory_item_id =
7417: v_lpn_serial_content.inventory_item_id
7418: AND cycle_count_header_id = p_cycle_count_header_id;
7419:
7484: -- Make sure that this inventory item is defined in the
7485: -- cycle count header item scope
7486: SELECT COUNT ( * )
7487: INTO l_temp_count
7488: FROM mtl_cycle_count_items
7489: WHERE inventory_item_id =
7490: v_lpn_multiple_serial.inventory_item_id
7491: AND cycle_count_header_id = p_cycle_count_header_id;
7492: